APPS.FND_AUDIT_PKG dependencies on FND_TABLES

Line 10: from fnd_audit_disp_cols, fnd_tables

6:
7: cursor l_check_from_clause(p_table_name varchar2) is
8: /* TSHORT 4890086 - needed for optional query in find */
9: select from_clause, where_clause
10: from fnd_audit_disp_cols, fnd_tables
11: where table_name = p_table_name and
12: fnd_tables.table_id = fnd_audit_disp_cols.table_id;
13:
14: TYPE RETRIEVE_DATA IS REF CURSOR;

Line 12: fnd_tables.table_id = fnd_audit_disp_cols.table_id;

8: /* TSHORT 4890086 - needed for optional query in find */
9: select from_clause, where_clause
10: from fnd_audit_disp_cols, fnd_tables
11: where table_name = p_table_name and
12: fnd_tables.table_id = fnd_audit_disp_cols.table_id;
13:
14: TYPE RETRIEVE_DATA IS REF CURSOR;
15: AUDIT_TABLE RETRIEVE_DATA; -- declare cursor variable
16: TABLE_DATA RETRIEVE_DATA; -- declare cursor variable

Line 27: audit_sql_stmt := ' select distinct FND_TABLES.TABLE_NAME TABLE_NAME ,

23: j INTEGER := 1;
24: DATA_EXISTS_FLAG INTEGER := null;
25: shadow_table_exists number;
26: BEGIN
27: audit_sql_stmt := ' select distinct FND_TABLES.TABLE_NAME TABLE_NAME ,
28: FND_TABLES.USER_TABLE_NAME USER_TABLE_NAME ,
29: FND_TABLES.TABLE_ID TABLE_ID ,
30: FND_TABLES.APPLICATION_ID TABLE_APPLICATION_ID
31: from FND_AUDIT_GROUPS ,

Line 28: FND_TABLES.USER_TABLE_NAME USER_TABLE_NAME ,

24: DATA_EXISTS_FLAG INTEGER := null;
25: shadow_table_exists number;
26: BEGIN
27: audit_sql_stmt := ' select distinct FND_TABLES.TABLE_NAME TABLE_NAME ,
28: FND_TABLES.USER_TABLE_NAME USER_TABLE_NAME ,
29: FND_TABLES.TABLE_ID TABLE_ID ,
30: FND_TABLES.APPLICATION_ID TABLE_APPLICATION_ID
31: from FND_AUDIT_GROUPS ,
32: FND_AUDIT_TMPLT_DTL ,

Line 29: FND_TABLES.TABLE_ID TABLE_ID ,

25: shadow_table_exists number;
26: BEGIN
27: audit_sql_stmt := ' select distinct FND_TABLES.TABLE_NAME TABLE_NAME ,
28: FND_TABLES.USER_TABLE_NAME USER_TABLE_NAME ,
29: FND_TABLES.TABLE_ID TABLE_ID ,
30: FND_TABLES.APPLICATION_ID TABLE_APPLICATION_ID
31: from FND_AUDIT_GROUPS ,
32: FND_AUDIT_TMPLT_DTL ,
33: FND_AUDIT_TABLES ,

Line 30: FND_TABLES.APPLICATION_ID TABLE_APPLICATION_ID

26: BEGIN
27: audit_sql_stmt := ' select distinct FND_TABLES.TABLE_NAME TABLE_NAME ,
28: FND_TABLES.USER_TABLE_NAME USER_TABLE_NAME ,
29: FND_TABLES.TABLE_ID TABLE_ID ,
30: FND_TABLES.APPLICATION_ID TABLE_APPLICATION_ID
31: from FND_AUDIT_GROUPS ,
32: FND_AUDIT_TMPLT_DTL ,
33: FND_AUDIT_TABLES ,
34: FND_TABLES

Line 34: FND_TABLES

30: FND_TABLES.APPLICATION_ID TABLE_APPLICATION_ID
31: from FND_AUDIT_GROUPS ,
32: FND_AUDIT_TMPLT_DTL ,
33: FND_AUDIT_TABLES ,
34: FND_TABLES
35: WHERE FND_AUDIT_TMPLT_DTL.AUDIT_GROUP_ID = FND_AUDIT_GROUPS.AUDIT_GROUP_ID
36: AND FND_AUDIT_TMPLT_DTL.APPLICATION_ID = FND_AUDIT_GROUPS.APPLICATION_ID
37: AND FND_AUDIT_GROUPS.APPLICATION_ID = FND_AUDIT_TABLES.AUDIT_GROUP_APP_ID
38: AND FND_AUDIT_GROUPS.AUDIT_GROUP_ID = FND_AUDIT_TABLES.AUDIT_GROUP_ID

Line 39: AND FND_AUDIT_TABLES.TABLE_ID = FND_TABLES.TABLE_ID

35: WHERE FND_AUDIT_TMPLT_DTL.AUDIT_GROUP_ID = FND_AUDIT_GROUPS.AUDIT_GROUP_ID
36: AND FND_AUDIT_TMPLT_DTL.APPLICATION_ID = FND_AUDIT_GROUPS.APPLICATION_ID
37: AND FND_AUDIT_GROUPS.APPLICATION_ID = FND_AUDIT_TABLES.AUDIT_GROUP_APP_ID
38: AND FND_AUDIT_GROUPS.AUDIT_GROUP_ID = FND_AUDIT_TABLES.AUDIT_GROUP_ID
39: AND FND_AUDIT_TABLES.TABLE_ID = FND_TABLES.TABLE_ID
40: AND FND_AUDIT_TABLES.TABLE_APP_ID = FND_TABLES.APPLICATION_ID
41: AND FND_AUDIT_GROUPS.STATE in (''E'',''G'',''N'')
42: AND FND_AUDIT_TABLES.STATE in (''E'',''G'',''N'')
43: AND '|| AUDIT_WHERE_CLAUSE;

Line 40: AND FND_AUDIT_TABLES.TABLE_APP_ID = FND_TABLES.APPLICATION_ID

36: AND FND_AUDIT_TMPLT_DTL.APPLICATION_ID = FND_AUDIT_GROUPS.APPLICATION_ID
37: AND FND_AUDIT_GROUPS.APPLICATION_ID = FND_AUDIT_TABLES.AUDIT_GROUP_APP_ID
38: AND FND_AUDIT_GROUPS.AUDIT_GROUP_ID = FND_AUDIT_TABLES.AUDIT_GROUP_ID
39: AND FND_AUDIT_TABLES.TABLE_ID = FND_TABLES.TABLE_ID
40: AND FND_AUDIT_TABLES.TABLE_APP_ID = FND_TABLES.APPLICATION_ID
41: AND FND_AUDIT_GROUPS.STATE in (''E'',''G'',''N'')
42: AND FND_AUDIT_TABLES.STATE in (''E'',''G'',''N'')
43: AND '|| AUDIT_WHERE_CLAUSE;
44: OPEN AUDIT_TABLE FOR audit_sql_stmt;