APPS.IGR_IMP_001 dependencies on IGS_AD_IMP_BATCH_DET

Line 12: l_batch_desc igs_ad_imp_batch_det.batch_Desc%TYPE;

8: p_inq_end_date IN VARCHAR2
9: ) AS
10: /* Variable Declaration */
11: l_bool BOOLEAN;
12: l_batch_desc igs_ad_imp_batch_det.batch_Desc%TYPE;
13: l_batch_id NUMBER;
14: l_interface_id NUMBER;
15: l_status NUMBER := 0;
16: l_tokenstr VARCHAR2(500);

Line 470: INSERT INTO IGS_AD_IMP_BATCH_DET

466: fnd_file.put_line(fnd_file.log,'For importing self service inquiry records:');
467: fnd_file.put_line(fnd_file.log,'Batch Id : '||IGS_GE_NUMBER.TO_CANN(l_batch_id));
468: fnd_file.put_line(fnd_file.log,'Batch description : '||l_batch_desc);
469: BEGIN
470: INSERT INTO IGS_AD_IMP_BATCH_DET
471: ( batch_id,
472: batch_Desc,
473: created_by,
474: creation_date,

Line 497: fnd_file.put_line(fnd_file.log,'Insert on IGS_AD_IMP_BATCH_DET failed '||SQLERRM);

493: fnd_global.conc_program_id,
494: sysdate);
495: EXCEPTION WHEN OTHERS THEN
496: l_status:=0;
497: fnd_file.put_line(fnd_file.log,'Insert on IGS_AD_IMP_BATCH_DET failed '||SQLERRM);
498: RAISE;
499: END;
500: END IF; --End of Batch ID null check
501: