[Home] [Help]
699:
700: -- Derive the Reconsideration Flag value based on the Admission outcome status to be changed. This Reconsideration
701: -- Flag value will be stored in igs_ad_admde_int_all table and used for exporting UCAS decisions to OSS.
702: l_reconsideration_flag := NULL;
703: IF igs_ad_gen_008.admp_get_saos(cur_ou_mapping_rec.adm_outcome_status) IN ('REJECTED','NO-QUOTA') THEN
704: -- Set the Reconsideration Flat to 'Y' for allowing institutions to process UCAS applications seemlessly.
705: l_reconsideration_flag := 'Y';
706: ELSE
707: -- When Application Decision to be changed is not REJECTED or NO-QUOTA then there is no need to set the flag.
814:
815: -- Derive the Reconsideration Flag value based on the Admission outcome status to be changed. This Reconsideration
816: -- Flag value will be stored in igs_ad_admde_int_all table and used for exporting UCAS decisions to OSS.
817: l_reconsideration_flag := NULL;
818: IF igs_ad_gen_008.admp_get_saos(cur_ucas_setup_rec.rejected_outcome_status) IN ('REJECTED','NO-QUOTA') THEN
819: -- Set the Reconsideration Flat to 'Y' for allowing institutions to process UCAS applications seemlessly.
820: l_reconsideration_flag := 'Y';
821: ELSE
822: -- When Application Decision to be changed is not REJECTED or NO-QUOTA then there is no need to set the flag.
895:
896: -- Derive the Reconsideration Flag value based on the Admission outcome status to be changed. This Reconsideration
897: -- Flag value will be stored in igs_ad_admde_int_all table and used for exporting UCAS decisions to OSS.
898: l_reconsideration_flag := NULL;
899: IF igs_ad_gen_008.admp_get_saos(cur_ucas_setup_rec.pending_outcome_status) IN ('REJECTED','NO-QUOTA') THEN
900: -- Set the Reconsideration Flat to 'Y' for allowing institutions to process UCAS applications seemlessly.
901: l_reconsideration_flag := 'Y';
902: ELSE
903: -- When Application Decision to be changed is not REJECTED or NO-QUOTA then there is no need to set the flag.
985:
986: -- Derive the Reconsideration Flag value based on the Admission outcome status to be changed. This Reconsideration
987: -- Flag value will be stored in igs_ad_admde_int_all table and used for exporting UCAS decisions to OSS.
988: l_reconsideration_flag := NULL;
989: IF igs_ad_gen_008.admp_get_saos(l_oss_ou_status_of_app_choice) IN ('REJECTED','NO-QUOTA') THEN
990: -- Set the Reconsideration Flat to 'Y' for allowing institutions to process UCAS applications seemlessly.
991: l_reconsideration_flag := 'Y';
992: ELSE
993: -- When Application Decision to be changed is not REJECTED or NO-QUOTA then there is no need to set the flag.
1052:
1053: -- Derive the Reconsideration Flag value based on the Admission outcome status to be changed. This Reconsideration
1054: -- Flag value will be stored in igs_ad_admde_int_all table and used for exporting UCAS decisions to OSS.
1055: l_reconsideration_flag := NULL;
1056: IF igs_ad_gen_008.admp_get_saos(cur_ou_mapping_rec.adm_outcome_status) IN ('REJECTED','NO-QUOTA') THEN
1057: -- Set the Reconsideration Flat to 'Y' for allowing institutions to process UCAS applications seemlessly.
1058: l_reconsideration_flag := 'Y';
1059: ELSE
1060: -- When Application Decision to be changed is not REJECTED or NO-QUOTA then there is no need to set the flag.
1842: -- If the OSS User Admission Offer Response Status mapped to the
1843: -- Application Choice Reply is not equal to OSS Application Instance Offer Response Status
1844: IF cur_map_offr_resp_rec.adm_offer_resp_status <> cur_oss_appl_inst_rec.adm_offer_resp_status THEN
1845:
1846: IF igs_ad_gen_008.admp_get_saors(cur_map_offr_resp_rec.adm_offer_resp_status) = 'REJECTED' THEN
1847: l_decline_ofr_reason := 'NO-REAS-REQ';
1848: ELSE
1849: l_decline_ofr_reason := NULL;
1850: END IF;