APPS.HZ_IMP_LOAD_STAGE2 dependencies on HZ_IMP_LOAD_WRAPPER

Line 30: HZ_IMP_LOAD_WRAPPER.cleanup_staging(P_BATCH_ID, P_BATCH_MODE_FLAG);

26: WHERE batch_id = P_BATCH_ID);
27:
28: /* comment out as this will be done in main wrapper
29:
30: HZ_IMP_LOAD_WRAPPER.cleanup_staging(P_BATCH_ID, P_BATCH_MODE_FLAG);
31: */
32:
33: commit;
34:

Line 140: l_dml_record HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE;

136: P_REGISTRY_DEDUP IN VARCHAR2,
137: P_REGISTRY_DEDUP_MATCH_RULE_ID IN VARCHAR2
138: ) IS
139:
140: l_dml_record HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE;
141: l_hwm_stage NUMBER;
142: -- l_rerun_flag VARCHAR2(1) := 'N';
143: l_start_error_id NUMBER;
144: l_current_error_id NUMBER;

Line 185: l_what_if_sg_data_exists := HZ_IMP_LOAD_WRAPPER.STAGING_DATA_EXISTS(P_BATCH_ID, P_BATCH_MODE_FLAG, 2);

181: -- get the start error_id sequence number
182: SELECT hz_imp_errors_s.NEXTVAL INTO l_start_error_id FROM dual;
183:
184: -- check if staging table has data
185: l_what_if_sg_data_exists := HZ_IMP_LOAD_WRAPPER.STAGING_DATA_EXISTS(P_BATCH_ID, P_BATCH_MODE_FLAG, 2);
186:
187: LOOP
188:
189: -- get the start error_id sequence number

Line 227: HZ_IMP_LOAD_WRAPPER.RETRIEVE_WORK_UNIT(P_BATCH_ID, '2' , l_dml_record.OS, l_dml_record.FROM_OSR, l_dml_record.TO_OSR,

223:
224: -- get the next available worker
225: l_dml_record.OS := NUll;
226: -- Bug 4594407
227: HZ_IMP_LOAD_WRAPPER.RETRIEVE_WORK_UNIT(P_BATCH_ID, '2' , l_dml_record.OS, l_dml_record.FROM_OSR, l_dml_record.TO_OSR,
228: l_hwm_stage, l_pp_status);
229:
230: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Retrieved Work unit');
231: FND_FILE.PUT_LINE(FND_FILE.LOG, 'wu_os:' || l_dml_record.OS);