eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ITA_RECORD_CURR_STATUS_PKG dependencies on ITA_SETUP_GROUPS_B

Line 14: WHERE table_id IN (SELECT table_id FROM ita_setup_groups_b WHERE audit_end_date IS NULL);

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:
18: BEGIN

Line 193: l_setup_gp_code ITA_SETUP_GROUPS_B.setup_group_code%TYPE;

189: (p_application_id IN NUMBER,
190: p_table_name IN VARCHAR2)
191: RETURN NUMBER
192: IS
193: l_setup_gp_code ITA_SETUP_GROUPS_B.setup_group_code%TYPE;
194: l_ret_val BOOLEAN;
195: BEGIN
196:
197: select setup_gp.SETUP_GROUP_CODE

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 203: UPDATE ita_setup_groups_b SET audit_start_date = sysdate

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
204: WHERE setup_group_code = l_setup_gp_code;
205: RETURN 1;
206: EXCEPTION
207: WHEN OTHERS

Line 257: from ITA_SETUP_GROUPS_B

253: from FND_COLUMNS fc
254: where
255: (APPLICATION_ID, TABLE_ID) = (
256: select TABLE_APP_ID, TABLE_ID
257: from ITA_SETUP_GROUPS_B
258: where SETUP_GROUP_CODE = ispv.SETUP_GROUP_CODE) and
259: COLUMN_ID = ispv.COLUMN_ID
260: ) COLUMN_NAME,
261: AUDIT_ENABLED_FLAG

Line 285: from ITA_SETUP_GROUPS_B

281: from FND_AUDIT_COLUMNS
282: where
283: (TABLE_APP_ID, TABLE_ID) = (
284: select TABLE_APP_ID, TABLE_ID
285: from ITA_SETUP_GROUPS_B
286: where SETUP_GROUP_CODE = ispv.SETUP_GROUP_CODE)
287: and ispv.Column_id = column_id
288: )
289: ;

Line 363: l_setup_gp_code ITA_SETUP_GROUPS_B.SETUP_GROUP_CODE%TYPE;

359: IS
360:
361: l_ret_val BOOLEAN;
362: l_table_id NUMBER;
363: l_setup_gp_code ITA_SETUP_GROUPS_B.SETUP_GROUP_CODE%TYPE;
364: l_audit_start_date DATE;
365: l_context_param_code ITA_SETUP_GROUPS_B.CONTEXT_PARAMETER_CODE%TYPE;
366: l_hier_level_code VARCHAR2(30);
367: l_context_param_code2 ITA_SETUP_GROUPS_B.CONTEXT_PARAMETER_CODE2%TYPE;

Line 365: l_context_param_code ITA_SETUP_GROUPS_B.CONTEXT_PARAMETER_CODE%TYPE;

361: l_ret_val BOOLEAN;
362: l_table_id NUMBER;
363: l_setup_gp_code ITA_SETUP_GROUPS_B.SETUP_GROUP_CODE%TYPE;
364: l_audit_start_date DATE;
365: l_context_param_code ITA_SETUP_GROUPS_B.CONTEXT_PARAMETER_CODE%TYPE;
366: l_hier_level_code VARCHAR2(30);
367: l_context_param_code2 ITA_SETUP_GROUPS_B.CONTEXT_PARAMETER_CODE2%TYPE;
368: l_column_id NUMBER;
369: l_column_id1 NUMBER;

Line 367: l_context_param_code2 ITA_SETUP_GROUPS_B.CONTEXT_PARAMETER_CODE2%TYPE;

363: l_setup_gp_code ITA_SETUP_GROUPS_B.SETUP_GROUP_CODE%TYPE;
364: l_audit_start_date DATE;
365: l_context_param_code ITA_SETUP_GROUPS_B.CONTEXT_PARAMETER_CODE%TYPE;
366: l_hier_level_code VARCHAR2(30);
367: l_context_param_code2 ITA_SETUP_GROUPS_B.CONTEXT_PARAMETER_CODE2%TYPE;
368: l_column_id NUMBER;
369: l_column_id1 NUMBER;
370: --l_shadow_table_name VARCHAR2(40);
371: l_del_sql VARCHAR2(32767);

Line 414: FROM ITA_SETUP_GROUPS_B setup_gp

410: (SELECT column_id FROM ita_setup_parameters_b WHERE parameter_code = setup_gp.CONTEXT_PARAMETER_CODE) column_id,
411: (SELECT column_id FROM ita_setup_parameters_b WHERE parameter_code = setup_gp.CONTEXT_PARAMETER_CODE2) column_id1
412: INTO l_setup_gp_code, l_audit_start_date, l_context_param_code, l_hier_level_code, l_context_param_code2,
413: l_column_id, l_column_id1
414: FROM ITA_SETUP_GROUPS_B setup_gp
415: WHERE setup_gp.TABLE_APP_ID = p_application_id and
416: setup_gp.TABLE_ID = l_table_id;
417:
418: select COLUMN_NAME

Line 422: from ITA_SETUP_GROUPS_B

418: select COLUMN_NAME
419: INTO l_column_name
420: from FND_COLUMNS
421: where (APPLICATION_ID, TABLE_ID) = (select TABLE_APP_ID, TABLE_ID
422: from ITA_SETUP_GROUPS_B
423: where SETUP_GROUP_CODE = l_setup_gp_code) and
424: COLUMN_ID = l_column_id;
425:
426: l_user_id := fnd_global.user_id;

Line 616: l_setup_gp_code ITA_SETUP_GROUPS_B.SETUP_GROUP_CODE%TYPE;

612: IS
613:
614: l_ret_val BOOLEAN;
615: l_table_id NUMBER;
616: l_setup_gp_code ITA_SETUP_GROUPS_B.SETUP_GROUP_CODE%TYPE;
617: l_audit_start_date DATE;
618: l_context_param_code ITA_SETUP_GROUPS_B.CONTEXT_PARAMETER_CODE%TYPE;
619: l_hier_level_code VARCHAR2(30);
620: l_context_param_code2 ITA_SETUP_GROUPS_B.CONTEXT_PARAMETER_CODE2%TYPE;

Line 618: l_context_param_code ITA_SETUP_GROUPS_B.CONTEXT_PARAMETER_CODE%TYPE;

614: l_ret_val BOOLEAN;
615: l_table_id NUMBER;
616: l_setup_gp_code ITA_SETUP_GROUPS_B.SETUP_GROUP_CODE%TYPE;
617: l_audit_start_date DATE;
618: l_context_param_code ITA_SETUP_GROUPS_B.CONTEXT_PARAMETER_CODE%TYPE;
619: l_hier_level_code VARCHAR2(30);
620: l_context_param_code2 ITA_SETUP_GROUPS_B.CONTEXT_PARAMETER_CODE2%TYPE;
621: l_column_id NUMBER;
622: l_column_id1 NUMBER;

Line 620: l_context_param_code2 ITA_SETUP_GROUPS_B.CONTEXT_PARAMETER_CODE2%TYPE;

616: l_setup_gp_code ITA_SETUP_GROUPS_B.SETUP_GROUP_CODE%TYPE;
617: l_audit_start_date DATE;
618: l_context_param_code ITA_SETUP_GROUPS_B.CONTEXT_PARAMETER_CODE%TYPE;
619: l_hier_level_code VARCHAR2(30);
620: l_context_param_code2 ITA_SETUP_GROUPS_B.CONTEXT_PARAMETER_CODE2%TYPE;
621: l_column_id NUMBER;
622: l_column_id1 NUMBER;
623: l_del_sql VARCHAR2(32767);
624: l_select_clause ITA_SETUP_PARAMETERS_B.SELECT_CLAUSE%TYPE;

Line 684: FROM ITA_SETUP_GROUPS_B setup_gp

680: (SELECT column_id FROM ita_setup_parameters_b WHERE parameter_code = setup_gp.CONTEXT_PARAMETER_CODE) column_id,
681: (SELECT column_id FROM ita_setup_parameters_b WHERE parameter_code = setup_gp.CONTEXT_PARAMETER_CODE2) column_id1
682: INTO l_setup_gp_code, l_audit_start_date, l_context_param_code, l_hier_level_code, l_context_param_code2,
683: l_column_id, l_column_id1
684: FROM ITA_SETUP_GROUPS_B setup_gp
685: WHERE setup_gp.TABLE_APP_ID = p_application_id and
686: setup_gp.TABLE_ID = l_table_id;
687:
688: select COLUMN_NAME

Line 692: from ITA_SETUP_GROUPS_B

688: select COLUMN_NAME
689: INTO l_column_name
690: from FND_COLUMNS
691: where (APPLICATION_ID, TABLE_ID) = (select TABLE_APP_ID, TABLE_ID
692: from ITA_SETUP_GROUPS_B
693: where SETUP_GROUP_CODE = l_setup_gp_code)
694: and COLUMN_ID = l_column_id;
695:
696: select COLUMN_NAME

Line 700: from ITA_SETUP_GROUPS_B

696: select COLUMN_NAME
697: INTO l_column_name1
698: from FND_COLUMNS
699: where (APPLICATION_ID, TABLE_ID) = (select TABLE_APP_ID, TABLE_ID
700: from ITA_SETUP_GROUPS_B
701: where SETUP_GROUP_CODE = l_setup_gp_code)
702: and COLUMN_ID = l_column_id1;
703:
704: l_user_id := fnd_global.user_id;