DBA Data[Home] [Help]

APPS.IGS_AD_CANCEL_RECONSIDER dependencies on IGS_AD_GEN_008

Line 881: IF NVL(igs_ad_gen_008.admp_get_saors(l_get_pending_hist_rec.ADM_OFFER_RESP_STATUS),'NULL') = 'ACCEPTED' THEN

877: OPEN c_apcs(l_adm_cat.admission_cat, l_adm_cat.s_admission_process_type);
878: FETCH c_apcs INTO l_apcs;
879: CLOSE c_apcs;
880:
881: IF NVL(igs_ad_gen_008.admp_get_saors(l_get_pending_hist_rec.ADM_OFFER_RESP_STATUS),'NULL') = 'ACCEPTED' THEN
882: IF igs_ad_upd_initialise.perform_pre_enrol(l_get_inst_dtls_rec.Person_Id,
883: l_get_inst_dtls_rec.Admission_Appl_Number,
884: l_get_inst_dtls_rec.Nominated_Course_cd,
885: l_get_inst_dtls_rec.Sequence_Number,

Line 893: ELSIF (igs_ad_gen_008.admp_get_saos(l_get_pending_hist_rec.ADM_OUTCOME_STATUS)) IN ('COND-OFFER', 'OFFER') AND l_apcs = 'Y' THEN

889: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cancel Reconsideration Failed: ' || v_message_name);
890: l_record_failed := 'Y';
891: ROLLBACK TO c_create_prog;
892: END IF;
893: ELSIF (igs_ad_gen_008.admp_get_saos(l_get_pending_hist_rec.ADM_OUTCOME_STATUS)) IN ('COND-OFFER', 'OFFER') AND l_apcs = 'Y' THEN
894: IF igs_ad_upd_initialise.perform_pre_enrol(l_get_inst_dtls_rec.Person_Id,
895: l_get_inst_dtls_rec.Admission_Appl_Number,
896: l_get_inst_dtls_rec.Nominated_Course_cd,
897: l_get_inst_dtls_rec.Sequence_Number,

Line 1402: IF NVL(igs_ad_gen_008.admp_get_saors(l_get_pending_hist_rec.ADM_OFFER_RESP_STATUS),'NULL') = 'ACCEPTED' THEN

1398: OPEN c_apcs(l_adm_cat.admission_cat, l_adm_cat.s_admission_process_type);
1399: FETCH c_apcs INTO l_apcs;
1400: CLOSE c_apcs;
1401:
1402: IF NVL(igs_ad_gen_008.admp_get_saors(l_get_pending_hist_rec.ADM_OFFER_RESP_STATUS),'NULL') = 'ACCEPTED' THEN
1403: IF igs_ad_upd_initialise.perform_pre_enrol(l_get_inst_dtls_rec.Person_Id,
1404: l_get_inst_dtls_rec.Admission_Appl_Number,
1405: l_get_inst_dtls_rec.Nominated_Course_cd,
1406: l_get_inst_dtls_rec.Sequence_Number,

Line 1417: IF (igs_ad_gen_008.admp_get_saos(l_get_pending_hist_rec.ADM_OUTCOME_STATUS)) IN ('COND-OFFER', 'OFFER') AND l_apcs = 'Y' THEN

1413: END IF;
1414: END IF;
1415:
1416:
1417: IF (igs_ad_gen_008.admp_get_saos(l_get_pending_hist_rec.ADM_OUTCOME_STATUS)) IN ('COND-OFFER', 'OFFER') AND l_apcs = 'Y' THEN
1418: IF igs_ad_upd_initialise.perform_pre_enrol(l_get_inst_dtls_rec.Person_Id,
1419: l_get_inst_dtls_rec.Admission_Appl_Number,
1420: l_get_inst_dtls_rec.Nominated_Course_cd,
1421: l_get_inst_dtls_rec.Sequence_Number,