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.RCI_PROC_DETAIL_ETL_PKG dependencies on MTL_PARAMETERS

Line 138: l_master_org MTL_PARAMETERS.MASTER_ORGANIZATION_ID%TYPE;

134: IS
135: l_func_name VARCHAR2(40);
136: l_profile_name FND_PROFILE_OPTIONS_VL.USER_PROFILE_OPTION_NAME%TYPE;
137: l_stmt_id NUMBER;
138: l_master_org MTL_PARAMETERS.MASTER_ORGANIZATION_ID%TYPE;
139: l_org MTL_PARAMETERS.MASTER_ORGANIZATION_ID%TYPE;
140: MISSING_INV_VALIDATION_ORG EXCEPTION;
141: PRAGMA EXCEPTION_INIT (MISSING_INV_VALIDATION_ORG, -20800);
142: l_err_msg VARCHAR2(2000);

Line 139: l_org MTL_PARAMETERS.MASTER_ORGANIZATION_ID%TYPE;

135: l_func_name VARCHAR2(40);
136: l_profile_name FND_PROFILE_OPTIONS_VL.USER_PROFILE_OPTION_NAME%TYPE;
137: l_stmt_id NUMBER;
138: l_master_org MTL_PARAMETERS.MASTER_ORGANIZATION_ID%TYPE;
139: l_org MTL_PARAMETERS.MASTER_ORGANIZATION_ID%TYPE;
140: MISSING_INV_VALIDATION_ORG EXCEPTION;
141: PRAGMA EXCEPTION_INIT (MISSING_INV_VALIDATION_ORG, -20800);
142: l_err_msg VARCHAR2(2000);
143:

Line 146: from mtl_parameters;

142: l_err_msg VARCHAR2(2000);
143:
144: cursor master_org_cur IS
145: select distinct master_organization_id
146: from mtl_parameters;
147: BEGIN
148: l_func_name := 'get_master_organization_id';
149: l_stmt_id := 0;
150:

Line 181: SELECT master_organization_id INTO l_master_org FROM mtl_parameters WHERE organization_id = l_org;

177: IF (l_org IS NULL) THEN
178: RAISE MISSING_INV_VALIDATION_ORG;
179: END IF;
180:
181: SELECT master_organization_id INTO l_master_org FROM mtl_parameters WHERE organization_id = l_org;
182:
183:
184: END IF;
185:

Line 226: l_master_org MTL_PARAMETERS.MASTER_ORGANIZATION_ID%TYPE;

222: l_run_date DATE;
223: l_proc_name VARCHAR2(30);
224: l_status VARCHAR2(30) ;
225: l_industry VARCHAR2(30) ;
226: l_master_org MTL_PARAMETERS.MASTER_ORGANIZATION_ID%TYPE;
227:
228: l_user_id NUMBER ;
229: l_login_id NUMBER ;
230: l_program_id NUMBER ;

Line 423: l_master_org MTL_PARAMETERS.MASTER_ORGANIZATION_ID%TYPE;

419: l_run_date DATE;
420: l_proc_name VARCHAR2(30);
421: l_status VARCHAR2(30) ;
422: l_industry VARCHAR2(30) ;
423: l_master_org MTL_PARAMETERS.MASTER_ORGANIZATION_ID%TYPE;
424:
425: l_user_id NUMBER ;
426: l_login_id NUMBER ;
427: l_program_id NUMBER ;

Line 629: l_master_org MTL_PARAMETERS.MASTER_ORGANIZATION_ID%TYPE;

625: l_run_date DATE;
626: l_last_run_date DATE;
627: l_proc_name VARCHAR2(30);
628: l_message VARCHAR2(30);
629: l_master_org MTL_PARAMETERS.MASTER_ORGANIZATION_ID%TYPE;
630: l_count NUMBER;
631:
632: l_user_id NUMBER;
633: l_login_id NUMBER;

Line 815: l_master_org MTL_PARAMETERS.MASTER_ORGANIZATION_ID%TYPE;

811: l_run_date DATE;
812: l_last_run_date DATE;
813: l_proc_name VARCHAR2(30);
814: l_message VARCHAR2(30);
815: l_master_org MTL_PARAMETERS.MASTER_ORGANIZATION_ID%TYPE;
816: l_count NUMBER;
817:
818: l_user_id NUMBER;
819: l_login_id NUMBER;