[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;
180: 'G','Disable - Prepare for Archive',
181: 'D','Disable - Purge Table',
182: 'E','Enabled',
183: g.state) state
184: from fnd_audit_groups g, fnd_audit_tables t , fnd_tables b
185: where t.audit_group_id = g.audit_group_id
186: and t.table_id = b.table_id
187: and t.table_id in (
188: select t2.table_id
185: where t.audit_group_id = g.audit_group_id
186: and t.table_id = b.table_id
187: and t.table_id in (
188: select t2.table_id
189: from fnd_audit_tables t2
190: where t2.table_id = t.table_id
191: and t2.audit_group_id <> t.audit_group_id)
192: and g.group_name <> p_group_name
193: and b.table_name = p_table_name;
218:
219: cursor c16 (p_audit_group_id number, p_table_id number) is
220: select u.oracle_username, decode(d.state,'R','Audit Enabled',
221: 'X','Audit Disabled', d.state) state
222: from fnd_audit_tables t, sys.dba_tables a, fnd_tables b,
223: fnd_audit_schemas d, fnd_oracle_userid u
224: where u.oracle_id = d.oracle_id
225: and a.owner = u.oracle_username
226: and t.table_id = b.table_id