APPS.IGS_UC_EXPORT_TO_OSS dependencies on IGS_AD_GEN_008

Line 929: igs_ad_gen_008.Admp_Get_Saos(e.adm_outcome_status) IN ('PENDING','SUSPEND');

925: e.us_version_number = cp_us_version_number AND
926: b.app_no = cp_app_no AND
927: b.choice_no = cp_choice_no AND
928: igs_ad_gen_007.Admp_Get_Saas(c.adm_appl_status) = 'RECEIVED' AND
929: igs_ad_gen_008.Admp_Get_Saos(e.adm_outcome_status) IN ('PENDING','SUSPEND');
930: c_cancel_appl_rec c_cancel_appl%ROWTYPE;
931:
932:
933: -- Get the interface ctl ID

Line 1120: AND igs_ad_gen_008.Admp_Get_Saos(aplinst.adm_outcome_status) <> 'CANCELLED';

1116: AND aplps.person_id = aplinst.person_id
1117: AND aplps.admission_appl_number = aplinst.admission_appl_number
1118: AND aplps.nominated_course_cd = aplinst.nominated_course_cd
1119: AND igs_ad_gen_007.admp_get_saas(apl.adm_appl_status) = 'COMPLETED'
1120: AND igs_ad_gen_008.Admp_Get_Saos(aplinst.adm_outcome_status) <> 'CANCELLED';
1121: cur_comp_app_choice_rec cur_comp_app_choice%ROWTYPE;
1122:
1123: -- Cursor to find any change in the UCAS Application Choice with the OSS Admission
1124: -- Application Instance