APPS.HZ_IMP_LOAD_STAGE3 dependencies on HZ_IMP_LOAD_WRAPPER

Line 33: l_dml_record HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE;

29: P_MAINTAIN_LOC_HIST IN VARCHAR2,
30: P_ALLOW_ADDR_CORR IN VARCHAR2
31: ) IS
32:
33: l_dml_record HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE;
34: l_rerun_flag VARCHAR2(1) := 'N';
35: l_orig_error_count NUMBER;
36: l_start_error_id NUMBER;
37: l_current_error_id NUMBER;

Line 120: HZ_IMP_LOAD_WRAPPER.RETRIEVE_WORK_UNIT(P_BATCH_ID, '3' , l_dml_record.OS, l_dml_record.FROM_OSR, l_dml_record.TO_OSR,

116:
117: -- get the next available worker
118: l_dml_record.OS := NUll;
119: -- Bug 4594407
120: HZ_IMP_LOAD_WRAPPER.RETRIEVE_WORK_UNIT(P_BATCH_ID, '3' , l_dml_record.OS, l_dml_record.FROM_OSR, l_dml_record.TO_OSR,
121: l_hwm_stage, l_pp_status);
122:
123: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Retrieved Work unit');
124: FND_FILE.PUT_LINE(FND_FILE.LOG, 'wu_os:' || l_dml_record.OS);

Line 395: HZ_IMP_LOAD_WRAPPER.cleanup_staging(l_dml_record.BATCH_ID, l_dml_record.BATCH_MODE_FLAG);

391:
392: /* comment out as this will be done in main wrapper
393:
394: -- Clean up Staging table
395: HZ_IMP_LOAD_WRAPPER.cleanup_staging(l_dml_record.BATCH_ID, l_dml_record.BATCH_MODE_FLAG);
396: FND_FILE.PUT_LINE(FND_FILE.LOG, 'debug: Staging table cleaned up ');
397:
398: -- Delete Work Unit
399: delete hz_imp_work_units where batch_id = P_BATCH_ID;