805: END IF;
806: --------------------------------------------------------------------------
807: -- Set admission COURSE application instance statuses for PENDING outcome
808: --------------------------------------------------------------------------
809: v_adm_doc_status := Igs_Ad_Gen_009.ADMP_GET_SYS_ADS('SATISFIED');
810: v_adm_entry_qual_status := Igs_Ad_Gen_009.ADMP_GET_SYS_AEQS('QUALIFIED');
811: v_adm_pending_outcome_status := Igs_Ad_Gen_009.ADMP_GET_SYS_AOS('PENDING');
812: v_adm_cndtnl_offer_status := Igs_Ad_Gen_009.ADMP_GET_SYS_ACOS('NOT-APPLIC');
813: v_adm_offer_resp_status := Igs_Ad_Gen_009.ADMP_GET_SYS_AORS('NOT-APPLIC');
806: --------------------------------------------------------------------------
807: -- Set admission COURSE application instance statuses for PENDING outcome
808: --------------------------------------------------------------------------
809: v_adm_doc_status := Igs_Ad_Gen_009.ADMP_GET_SYS_ADS('SATISFIED');
810: v_adm_entry_qual_status := Igs_Ad_Gen_009.ADMP_GET_SYS_AEQS('QUALIFIED');
811: v_adm_pending_outcome_status := Igs_Ad_Gen_009.ADMP_GET_SYS_AOS('PENDING');
812: v_adm_cndtnl_offer_status := Igs_Ad_Gen_009.ADMP_GET_SYS_ACOS('NOT-APPLIC');
813: v_adm_offer_resp_status := Igs_Ad_Gen_009.ADMP_GET_SYS_AORS('NOT-APPLIC');
814: v_adm_offer_dfrmnt_status := Igs_Ad_Gen_009.ADMP_GET_SYS_AODS('NOT-APPLIC');
807: -- Set admission COURSE application instance statuses for PENDING outcome
808: --------------------------------------------------------------------------
809: v_adm_doc_status := Igs_Ad_Gen_009.ADMP_GET_SYS_ADS('SATISFIED');
810: v_adm_entry_qual_status := Igs_Ad_Gen_009.ADMP_GET_SYS_AEQS('QUALIFIED');
811: v_adm_pending_outcome_status := Igs_Ad_Gen_009.ADMP_GET_SYS_AOS('PENDING');
812: v_adm_cndtnl_offer_status := Igs_Ad_Gen_009.ADMP_GET_SYS_ACOS('NOT-APPLIC');
813: v_adm_offer_resp_status := Igs_Ad_Gen_009.ADMP_GET_SYS_AORS('NOT-APPLIC');
814: v_adm_offer_dfrmnt_status := Igs_Ad_Gen_009.ADMP_GET_SYS_AODS('NOT-APPLIC');
815: IF v_apcs_late_fee_ind = 'Y' THEN
808: --------------------------------------------------------------------------
809: v_adm_doc_status := Igs_Ad_Gen_009.ADMP_GET_SYS_ADS('SATISFIED');
810: v_adm_entry_qual_status := Igs_Ad_Gen_009.ADMP_GET_SYS_AEQS('QUALIFIED');
811: v_adm_pending_outcome_status := Igs_Ad_Gen_009.ADMP_GET_SYS_AOS('PENDING');
812: v_adm_cndtnl_offer_status := Igs_Ad_Gen_009.ADMP_GET_SYS_ACOS('NOT-APPLIC');
813: v_adm_offer_resp_status := Igs_Ad_Gen_009.ADMP_GET_SYS_AORS('NOT-APPLIC');
814: v_adm_offer_dfrmnt_status := Igs_Ad_Gen_009.ADMP_GET_SYS_AODS('NOT-APPLIC');
815: IF v_apcs_late_fee_ind = 'Y' THEN
816: v_late_adm_fee_status := IGS_AD_GEN_009.ADMP_GET_SYS_AFS('EXEMPT');
809: v_adm_doc_status := Igs_Ad_Gen_009.ADMP_GET_SYS_ADS('SATISFIED');
810: v_adm_entry_qual_status := Igs_Ad_Gen_009.ADMP_GET_SYS_AEQS('QUALIFIED');
811: v_adm_pending_outcome_status := Igs_Ad_Gen_009.ADMP_GET_SYS_AOS('PENDING');
812: v_adm_cndtnl_offer_status := Igs_Ad_Gen_009.ADMP_GET_SYS_ACOS('NOT-APPLIC');
813: v_adm_offer_resp_status := Igs_Ad_Gen_009.ADMP_GET_SYS_AORS('NOT-APPLIC');
814: v_adm_offer_dfrmnt_status := Igs_Ad_Gen_009.ADMP_GET_SYS_AODS('NOT-APPLIC');
815: IF v_apcs_late_fee_ind = 'Y' THEN
816: v_late_adm_fee_status := IGS_AD_GEN_009.ADMP_GET_SYS_AFS('EXEMPT');
817: ELSE
810: v_adm_entry_qual_status := Igs_Ad_Gen_009.ADMP_GET_SYS_AEQS('QUALIFIED');
811: v_adm_pending_outcome_status := Igs_Ad_Gen_009.ADMP_GET_SYS_AOS('PENDING');
812: v_adm_cndtnl_offer_status := Igs_Ad_Gen_009.ADMP_GET_SYS_ACOS('NOT-APPLIC');
813: v_adm_offer_resp_status := Igs_Ad_Gen_009.ADMP_GET_SYS_AORS('NOT-APPLIC');
814: v_adm_offer_dfrmnt_status := Igs_Ad_Gen_009.ADMP_GET_SYS_AODS('NOT-APPLIC');
815: IF v_apcs_late_fee_ind = 'Y' THEN
816: v_late_adm_fee_status := IGS_AD_GEN_009.ADMP_GET_SYS_AFS('EXEMPT');
817: ELSE
818: v_late_adm_fee_status := IGS_AD_GEN_009.ADMP_GET_SYS_AFS('NOT-APPLIC');
812: v_adm_cndtnl_offer_status := Igs_Ad_Gen_009.ADMP_GET_SYS_ACOS('NOT-APPLIC');
813: v_adm_offer_resp_status := Igs_Ad_Gen_009.ADMP_GET_SYS_AORS('NOT-APPLIC');
814: v_adm_offer_dfrmnt_status := Igs_Ad_Gen_009.ADMP_GET_SYS_AODS('NOT-APPLIC');
815: IF v_apcs_late_fee_ind = 'Y' THEN
816: v_late_adm_fee_status := IGS_AD_GEN_009.ADMP_GET_SYS_AFS('EXEMPT');
817: ELSE
818: v_late_adm_fee_status := IGS_AD_GEN_009.ADMP_GET_SYS_AFS('NOT-APPLIC');
819: END IF;
820: --------------------------------
814: v_adm_offer_dfrmnt_status := Igs_Ad_Gen_009.ADMP_GET_SYS_AODS('NOT-APPLIC');
815: IF v_apcs_late_fee_ind = 'Y' THEN
816: v_late_adm_fee_status := IGS_AD_GEN_009.ADMP_GET_SYS_AFS('EXEMPT');
817: ELSE
818: v_late_adm_fee_status := IGS_AD_GEN_009.ADMP_GET_SYS_AFS('NOT-APPLIC');
819: END IF;
820: --------------------------------
821: -- Get the next sequence number
822: --------------------------------
983:
984: ------------------------------------------------------------------------------
985: -- Set admission COURSE application instance statuses for OFFER outcome
986: ------------------------------------------------------------------------------
987: v_offer_adm_outcome_status := Igs_Ad_Gen_009.ADMP_GET_SYS_AOS('OFFER');
988: v_new_adm_offer_resp_status := Igs_Ad_Gen_009.ADMP_GET_SYS_AORS('PENDING');
989: ------------------------------------------------------------------------------
990: -- Validate that admission COURSE application instance is valid for an offer
991: ------------------------------------------------------------------------------
984: ------------------------------------------------------------------------------
985: -- Set admission COURSE application instance statuses for OFFER outcome
986: ------------------------------------------------------------------------------
987: v_offer_adm_outcome_status := Igs_Ad_Gen_009.ADMP_GET_SYS_AOS('OFFER');
988: v_new_adm_offer_resp_status := Igs_Ad_Gen_009.ADMP_GET_SYS_AORS('PENDING');
989: ------------------------------------------------------------------------------
990: -- Validate that admission COURSE application instance is valid for an offer
991: ------------------------------------------------------------------------------
992: IF Igs_Ad_Val_Acai_Status.admp_val_acai_aos(
1702: ----------------------------------
1703: SAVEPOINT sp_save_point1;
1704: v_adm_appl_status := Igs_Ad_Gen_008.ADMP_GET_SYS_AAS(
1705: 'RECEIVED');
1706: v_adm_fee_status := Igs_Ad_Gen_009.ADMP_GET_SYS_AFS(
1707: 'NOT-APPLIC');
1708: IF Igs_Ad_Prc_Tac_Offer.admp_ins_adm_appl(
1709: p_person_id,
1710: p_appl_dt,