APPS.IGS_UC_EXP_APPLICANT_DTLS dependencies on IGS_AD_IMP_BATCH_DET

Line 278: l_ad_batch_id IGS_AD_IMP_BATCH_DET.batch_id%TYPE;

274:
275: l_rep_request_id NUMBER;
276: l_sent_to_oss_flag IGS_UC_APP_NAMES.sent_to_oss_flag%TYPE;
277: l_dom_text_value IGS_UC_REF_APR.dom_text%TYPE;
278: l_ad_batch_id IGS_AD_IMP_BATCH_DET.batch_id%TYPE;
279: l_ad_interface_id IGS_AD_INTERFACE_ALL.interface_id%TYPE;
280:
281:
282: -- Bug No. 2980137. Variable to obtain the return code.

Line 615: INSERT INTO igs_ad_imp_batch_det (

611: IF l_ad_batch_id IS NULL THEN
612:
613: -- Fetch the Batch ID from the Sequence, IGS_AD_INTERFACE_BATCH_ID_S and
614: -- populate the admission interface batch table
615: INSERT INTO igs_ad_imp_batch_det (
616: batch_id,
617: batch_desc,
618: created_by,
619: creation_date,

Line 1060: INSERT INTO igs_ad_imp_batch_det (

1056:
1057: -- Fetch the Batch ID from the Sequence, IGS_AD_INTERFACE_BATCH_ID_S and
1058: -- populate the admission interface batch table
1059:
1060: INSERT INTO igs_ad_imp_batch_det (
1061: batch_id,
1062: batch_desc,
1063: created_by,
1064: creation_date,