APPS.EGO_IMPORT_BATCH_PURGE_PKG dependencies on EGO_IMPORT_BATCHES_B

Line 489: SELECT BATCH_TYPE INTO l_batch_type FROM EGO_IMPORT_BATCHES_B WHERE BATCH_ID=p_batch_id;

485: stm_num :=1;
486:
487:
488:
489: SELECT BATCH_TYPE INTO l_batch_type FROM EGO_IMPORT_BATCHES_B WHERE BATCH_ID=p_batch_id;
490:
491: fnd_file.put_line(fnd_file.Log,'Purge Program run for Batch ID:'||p_batch_id || '.');
492: fnd_file.put_line(fnd_file.Log,'Batch type is '||l_batch_type||'.');
493: fnd_file.put_line(fnd_file.Log,'Purge Criteria is '|| p_purge_criteria||'.');

Line 1031: SELECT BATCH_TYPE INTO l_batch_type FROM EGO_IMPORT_BATCHES_B WHERE BATCH_ID=p_batch_id;

1027: BEGIN
1028:
1029: stm_num :=1;
1030:
1031: SELECT BATCH_TYPE INTO l_batch_type FROM EGO_IMPORT_BATCHES_B WHERE BATCH_ID=p_batch_id;
1032:
1033: stm_num :=2;
1034:
1035: DELETE FROM MTL_SYSTEM_ITEMS_INTERFACE WHERE set_process_id = p_batch_id AND PROCESS_FLAG IN (3,6,7);