Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\patches\3.2.1\patch

Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\patches\3.2.1\patch_8551429.sql

set define '^'

Rem
Rem    MODIFIED   (MM/DD/YYYY)
Rem    jkallman    05/28/2009 - Created for bug 8551429

declare
  s varchar2(4000) := null;
begin
    wwv_flow_security.g_security_group_id := 10;

s:=s||'with messages as ('||chr(10)||
'select wwv_flow_lang.system_message(''AUTH.LOGIN_PAGE'') login_page,'||chr(10)||
'wwv_flow_lang.system_message(''UNAUTHENTICATED_USER'') unauth_user,'||chr(10)||
'(select count(*) tv'||chr(10)||
'from wwv_flow_activity_log l'||chr(10)||
'where l.time_stamp>=(select sysdate - to_number('||chr(10)||
':F4050_P36_DAYS) x from dual )  ) tv'||chr(10)||
'from dual)'||chr(10)||
'select '||chr(10)||
'decode(upper(l.userid),null,'||chr(10)||
'  messages.login_page,''NOBODY'','||chr(10)||
'  messages.unauth_user,upper(l.us';

s:=s||'erid))'||chr(10)||
'   user_name,'||chr(10)||
'lower(c.short_name) workspace,'||chr(10)||
' count(*) page_views, 100*count(*)/tv pct, sum(num_rows) report_rows, count(distinct(ip_address)) ip_addresses, sum(elap) total_elapsed, avg(elap) average_elapsed, count(distinct to_char(time_stamp,''YYYYMMDDHH24'')) distinct_hours, count(distinct to_char(time_stamp,''YYYYMMDD'')) distinct_days'||chr(10)||
'from wwv_flow_activity_log l, wwv_flow_companies c, mess';

s:=s||'ages'||chr(10)||
'where l.security_group_id = c.provisioning_company_id (+)'||chr(10)||
'and page_mode != ''A'''||chr(10)||
'and l.time_stamp>=(select sysdate - to_number('||chr(10)||
':F4050_P36_DAYS) x from dual )  '||chr(10)||
'and (c.PROVISIONING_COMPANY_ID = :F4050_P36_COMPANY or :F4050_P36_COMPANY = 0)'||chr(10)||
'group by decode(upper(l.userid),null,'||chr(10)||
'  login_page,''NOBODY'','||chr(10)||
'  unauth_user,upper(l.userid)),'||chr(10)||
'  lower(c.short_name),'||chr(10)||
'  tv';

update wwv_flow_page_plugs
 set plug_source = s
 where flow_id between 4050 and 4059
 and page_id >= 36
 and page_id < 36+1
 and id >= 7636510665243086
 and id < 7636510665243086+1;
 
 
s:='select '||chr(10)||
' trunc(audit_date) audit_date,'||chr(10)||
' to_char(count(distinct flow_user),''999,999,999,999,999,990'') developers,'||chr(10)||
' to_char(count(*),''999,999,999,999,990'') developer_changes,'||chr(10)||
' txt_developers,'||chr(10)||
' txt_changes'||chr(10)||
'from wwv_flow_builder_audit_trail,'||chr(10)||
' (select wwv_flow_lang.system_message(''CHANGES'') txt_changes'||chr(10)||
' from dual) t1,'||chr(10)||
' (select wwv_flow_lang.system_message(''DEVELOPERS'') txt_developers'||chr(10)||
' ';

s:=s||' from dual) t2'||chr(10)||
'where security_group_id = :flow_security_group_id '||chr(10)||
'group by trunc(audit_date), txt_developers, txt_changes'||chr(10)||
'order by trunc(audit_date)';
 
 
 update wwv_flow_page_plugs
 set plug_source = s
 where flow_id between 4350 and 4359
 and page_id >= 20
 and page_id < 20+1
 and id >= 22824023806841842
 and id < 22824023806841842+1;

s:='select trunc(TIME_STAMP) ts, '||chr(10)||
' ''''||'||chr(10)||
' t.v||'':''||'||chr(10)||
' to_char(count(*),''999,999,999,990'') ||'' ''||'||chr(10)||
' t.u||'':''||'||chr(10)||
' to_char(count(distinct upper(USERID)),''999,999,999,990'')||'' ''||'||chr(10)||
' t.a||'':''||'||chr(10)||
' to_char(count(distinct flow_id),''999,999,999,990'')||'' ''||'||chr(10)||
' t.p||'':''||'||chr(10)||
' to_char(count(distinct step_id),';

s:=s||'''999,999,999,990'')||'''' display'||chr(10)||
' from WWV_FLOW_ACTIVITY_LOG,'||chr(10)||
'(select wwv_flow_lang.system_message(''views'') v,'||chr(10)||
' wwv_flow_lang.system_message(''users'') u,'||chr(10)||
' wwv_flow_lang.system_message(''applications'') a,'||chr(10)||
' wwv_flow_lang.system_message(''pages'') p'||chr(10)||
' from dual) t'||chr(10)||
' where security_group_id = :flow_security_group_id and page_mode != ''A'''||chr(10)||
'group by trunc(time_stamp), t.v, t.u';

s:=s||', t.a, t.p';
 
 
 update wwv_flow_page_plugs
 set plug_source = s
 where flow_id between 4350 and 4359
 and page_id >= 27
 and page_id < 27+1
 and id >= 233523126780054135
 and id < 233523126780054135+1;

commit;

end;
/

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de