DBA Data[Home] [Help]

APPS.RCI_ORG_CERT_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 230: l_master_org MTL_PARAMETERS.MASTER_ORGANIZATION_ID%TYPE;

226: l_run_date DATE;
227: l_proc_name VARCHAR2(30);
228: l_status VARCHAR2(30) ;
229: l_industry VARCHAR2(30) ;
230: l_master_org MTL_PARAMETERS.MASTER_ORGANIZATION_ID%TYPE;
231:
232: l_user_id NUMBER ;
233: l_login_id NUMBER ;
234: l_program_id NUMBER ;

Line 500: l_master_org MTL_PARAMETERS.MASTER_ORGANIZATION_ID%TYPE;

496: l_run_date DATE;
497: l_proc_name VARCHAR2(30);
498: l_status VARCHAR2(30) ;
499: l_industry VARCHAR2(30) ;
500: l_master_org MTL_PARAMETERS.MASTER_ORGANIZATION_ID%TYPE;
501:
502: l_user_id NUMBER ;
503: l_login_id NUMBER ;
504: l_program_id NUMBER ;

Line 770: l_master_org MTL_PARAMETERS.MASTER_ORGANIZATION_ID%TYPE;

766: l_run_date DATE;
767: l_last_run_date DATE;
768: l_proc_name VARCHAR2(30);
769: l_message VARCHAR2(30);
770: l_master_org MTL_PARAMETERS.MASTER_ORGANIZATION_ID%TYPE;
771: l_count NUMBER;
772:
773: l_user_id NUMBER;
774: l_login_id NUMBER;

Line 1015: l_master_org MTL_PARAMETERS.MASTER_ORGANIZATION_ID%TYPE;

1011: l_run_date DATE;
1012: l_last_run_date DATE;
1013: l_proc_name VARCHAR2(30);
1014: l_message VARCHAR2(30);
1015: l_master_org MTL_PARAMETERS.MASTER_ORGANIZATION_ID%TYPE;
1016: l_count NUMBER;
1017:
1018: l_user_id NUMBER;
1019: l_login_id NUMBER;