[Home] [Help]
88: where g.group_name = nvl(p_group_name, g.group_name);
89:
90: cursor c1 (p_group_name varchar2) is
91: select g.group_name, b.table_name, g.audit_group_id, t.table_id, a.application_short_name
92: from fnd_audit_groups g, fnd_audit_tables t, fnd_tables b, fnd_application a
93: where g.audit_group_id = t.audit_group_id
94: and t.table_id = b.table_id
95: and g.group_name = p_group_name
96: and t.table_app_id = a.application_id
183: 'G','Disable - Prepare for Archive',
184: 'D','Disable - Purge Table',
185: 'E','Enabled',
186: g.state) state
187: from fnd_audit_groups g, fnd_audit_tables t , fnd_tables b
188: where t.audit_group_id = g.audit_group_id
189: and t.table_id = b.table_id
190: and t.table_id in (
191: select t2.table_id
188: where t.audit_group_id = g.audit_group_id
189: and t.table_id = b.table_id
190: and t.table_id in (
191: select t2.table_id
192: from fnd_audit_tables t2
193: where t2.table_id = t.table_id
194: and t2.audit_group_id <> t.audit_group_id)
195: and g.group_name <> p_group_name
196: and b.table_name = p_table_name;
221:
222: cursor c16 (p_audit_group_id number, p_table_id number) is
223: select u.oracle_username, decode(d.state,'R','Audit Enabled',
224: 'X','Audit Disabled', d.state) state
225: from fnd_audit_tables t, sys.dba_tables a, fnd_tables b,
226: fnd_audit_schemas d, fnd_oracle_userid u
227: where u.oracle_id = d.oracle_id
228: and a.owner = u.oracle_username
229: and t.table_id = b.table_id