[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
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
234:
235: cursor c17 (p_table_name varchar2) is
236: select count(*)+1 cnt
237: from fnd_audit_columns c,
238: fnd_tables b
239: where c.state = 'N'
240: and c.table_id = b.table_id
241: and c.schema_id <> -1
242: and b.table_name = p_table_name;