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);
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:
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:
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:
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 ;
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 ;
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;
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;