APPS.IGS_UC_EXP_APPLICANT_DTLS dependencies on IGS_AD_INTERFACE_BATCH_ID_S

Line 613: -- Fetch the Batch ID from the Sequence, IGS_AD_INTERFACE_BATCH_ID_S and

609: -- If the Batch ID is already generated use the same,
610: -- otherwise create the new Batch ID ( i.e. for First Time)
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,

Line 628: IGS_AD_INTERFACE_BATCH_ID_S.NEXTVAL,

624: program_application_id,
625: program_update_date,
626: program_id )
627: VALUES (
628: IGS_AD_INTERFACE_BATCH_ID_S.NEXTVAL,
629: fnd_message.get_string('IGS','IGS_UC_IMP_FROM_UCAS_BATCH_ID'),
630: g_created_by,
631: SYSDATE,
632: g_last_updated_by,

Line 1057: -- Fetch the Batch ID from the Sequence, IGS_AD_INTERFACE_BATCH_ID_S and

1053: -- If the Batch ID is already generated use the same,
1054: -- otherwise create the new Batch ID ( i.e. for First Time)
1055: IF l_ad_batch_id IS NULL THEN
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,

Line 1073: IGS_AD_INTERFACE_BATCH_ID_S.NEXTVAL,

1069: program_application_id,
1070: program_update_date,
1071: program_id)
1072: VALUES (
1073: IGS_AD_INTERFACE_BATCH_ID_S.NEXTVAL,
1074: fnd_message.get_string('IGS','IGS_UC_IMP_FROM_UCAS_BATCH_ID'),
1075: fnd_global.user_id,
1076: SYSDATE,
1077: fnd_global.user_id,