APPS.ITA_RECORD_CURR_STATUS_PKG dependencies on FND_TABLES

Line 13: FROM fnd_tables

9: l_app_id NUMBER;
10: l_set_warn BOOLEAN;
11: CURSOR c_all_tables IS
12: SELECT table_name, application_id
13: FROM fnd_tables
14: WHERE table_id IN (SELECT table_id FROM ita_setup_groups_b WHERE audit_end_date IS NULL);
15:
16: l_table c_all_tables%ROWTYPE;
17:

Line 25: FROM fnd_tables

21: THEN
22: l_app_id := -1;
23: SELECT application_id
24: INTO l_app_id
25: FROM fnd_tables
26: WHERE table_name = p_table_name;
27:
28: IF l_app_id = -1
29: THEN

Line 30: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Table ' || p_table_name || ' does not exist in fnd_tables.');

26: WHERE table_name = p_table_name;
27:
28: IF l_app_id = -1
29: THEN
30: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Table ' || p_table_name || ' does not exist in fnd_tables.');
31: l_ret_val := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', 'Current State not fetched.');
32: RETURN;
33: END IF;
34: l_ret_code := enable_tracking_for_table(l_app_id, p_table_name);

Line 199: FROM ITA_SETUP_GROUPS_B setup_gp, FND_TABLES ft

195: BEGIN
196:
197: select setup_gp.SETUP_GROUP_CODE
198: INTO l_setup_gp_code
199: FROM ITA_SETUP_GROUPS_B setup_gp, FND_TABLES ft
200: WHERE setup_gp.TABLE_APP_ID = p_application_id and setup_gp.TABLE_ID = ft.table_id and
201: ft.application_id = setup_gp.table_app_id and ft.table_name = UPPER(p_table_name);
202:
203: UPDATE ita_setup_groups_b SET audit_start_date = sysdate

Line 268: FND_TABLES fnd_table ,

264: (select distinct
265: setup_gp.SETUP_GROUP_CODE
266: from
267: ITA_SETUP_GROUPS_VL setup_gp,
268: FND_TABLES fnd_table ,
269: FND_APPLICATION_VL FND_APP
270: where
271: fnd_table.APPLICATION_ID (+) = setup_gp.TABLE_APP_ID and
272: fnd_table.TABLE_ID (+) = setup_gp.TABLE_ID and

Line 404: FROM FND_TABLES fnd_table

400: END IF;
401:
402: SELECT fnd_table.TABLE_ID
403: INTO l_table_id
404: FROM FND_TABLES fnd_table
405: WHERE fnd_table.APPLICATION_ID = p_application_id AND fnd_table.TABLE_NAME = UPPER(p_table_name);
406:
407: select setup_gp.SETUP_GROUP_CODE, setup_gp.AUDIT_START_DATE,
408: setup_gp.CONTEXT_PARAMETER_CODE, setup_gp.HIERARCHY_LEVEL hierarchy_level_code,

Line 674: FROM FND_TABLES fnd_table

670: END IF;
671:
672: SELECT fnd_table.TABLE_ID
673: INTO l_table_id
674: FROM FND_TABLES fnd_table
675: WHERE fnd_table.APPLICATION_ID = p_application_id AND fnd_table.TABLE_NAME = UPPER(p_table_name);
676:
677: select setup_gp.SETUP_GROUP_CODE, setup_gp.AUDIT_START_DATE,
678: setup_gp.CONTEXT_PARAMETER_CODE, setup_gp.HIERARCHY_LEVEL hierarchy_level_code,