eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AD_GEN_002 dependencies on IGS_AD_GEN_008

Line 2587: IF IGS_AD_GEN_008.ADMP_GET_SAOS(v_acai_rec.adm_outcome_status) IN (cst_offer, cst_cond_offer)

2583: cst_withdrawn,
2584: cst_completed) THEN
2585: -- To decide if the system Applicatiom Status(APS) can be derived to 'WITHDRAWN'
2586: FOR v_acai_rec IN c_aca LOOP
2587: IF IGS_AD_GEN_008.ADMP_GET_SAOS(v_acai_rec.adm_outcome_status) IN (cst_offer, cst_cond_offer)
2588: AND
2589: IGS_AD_GEN_008.ADMP_GET_SAORS(v_acai_rec.adm_offer_resp_status) NOT IN (cst_rejected, cst_lapsed, cst_notapplic) THEN
2590: v_rej_lap := TRUE;
2591: EXIT;

Line 2589: IGS_AD_GEN_008.ADMP_GET_SAORS(v_acai_rec.adm_offer_resp_status) NOT IN (cst_rejected, cst_lapsed, cst_notapplic) THEN

2585: -- To decide if the system Applicatiom Status(APS) can be derived to 'WITHDRAWN'
2586: FOR v_acai_rec IN c_aca LOOP
2587: IF IGS_AD_GEN_008.ADMP_GET_SAOS(v_acai_rec.adm_outcome_status) IN (cst_offer, cst_cond_offer)
2588: AND
2589: IGS_AD_GEN_008.ADMP_GET_SAORS(v_acai_rec.adm_offer_resp_status) NOT IN (cst_rejected, cst_lapsed, cst_notapplic) THEN
2590: v_rej_lap := TRUE;
2591: EXIT;
2592: END IF;
2593: END LOOP;

Line 2597: v_s_adm_outcome_status := IGS_AD_GEN_008.ADMP_GET_SAOS(

2593: END LOOP;
2594: -- Retrieve admission course application instance details.
2595: FOR v_aca_rec IN c_aca LOOP
2596: v_acai_records_found := TRUE;
2597: v_s_adm_outcome_status := IGS_AD_GEN_008.ADMP_GET_SAOS(
2598: v_aca_rec.adm_outcome_status);
2599: v_s_adm_offer_resp_status := IGS_AD_GEN_008.ADMP_GET_SAORS(
2600: v_aca_rec.adm_offer_resp_status);
2601: v_s_adm_offer_dfrmnt_status := IGS_AD_GEN_008.ADMP_GET_SAODS(

Line 2599: v_s_adm_offer_resp_status := IGS_AD_GEN_008.ADMP_GET_SAORS(

2595: FOR v_aca_rec IN c_aca LOOP
2596: v_acai_records_found := TRUE;
2597: v_s_adm_outcome_status := IGS_AD_GEN_008.ADMP_GET_SAOS(
2598: v_aca_rec.adm_outcome_status);
2599: v_s_adm_offer_resp_status := IGS_AD_GEN_008.ADMP_GET_SAORS(
2600: v_aca_rec.adm_offer_resp_status);
2601: v_s_adm_offer_dfrmnt_status := IGS_AD_GEN_008.ADMP_GET_SAODS(
2602: v_aca_rec.adm_offer_dfrmnt_status);
2603: v_s_appl_inst_stat := NVL(IGS_AD_GEN_007.ADMP_GET_SAAS(v_aca_rec.appl_inst_status),'-1');

Line 2601: v_s_adm_offer_dfrmnt_status := IGS_AD_GEN_008.ADMP_GET_SAODS(

2597: v_s_adm_outcome_status := IGS_AD_GEN_008.ADMP_GET_SAOS(
2598: v_aca_rec.adm_outcome_status);
2599: v_s_adm_offer_resp_status := IGS_AD_GEN_008.ADMP_GET_SAORS(
2600: v_aca_rec.adm_offer_resp_status);
2601: v_s_adm_offer_dfrmnt_status := IGS_AD_GEN_008.ADMP_GET_SAODS(
2602: v_aca_rec.adm_offer_dfrmnt_status);
2603: v_s_appl_inst_stat := NVL(IGS_AD_GEN_007.ADMP_GET_SAAS(v_aca_rec.appl_inst_status),'-1');
2604: -- Check if the outcome of the admission course
2605: -- application instance is complete or has been resolved.

Line 2651: RETURN IGS_AD_GEN_008.ADMP_GET_SYS_AAS(cst_received);

2647: -- admission application then also return a value of received.
2648: IF v_acai_records_found = TRUE THEN
2649: IF v_received_appl THEN
2650: IF v_s_adm_appl_status <> cst_received THEN
2651: RETURN IGS_AD_GEN_008.ADMP_GET_SYS_AAS(cst_received);
2652: ELSE
2653: RETURN p_adm_appl_status;
2654: END IF;
2655: ELSIF v_withdrawn_appl THEN

Line 2657: RETURN IGS_AD_GEN_008.ADMP_GET_SYS_AAS(cst_withdrawn);

2653: RETURN p_adm_appl_status;
2654: END IF;
2655: ELSIF v_withdrawn_appl THEN
2656: IF v_s_adm_appl_status <> cst_withdrawn THEN
2657: RETURN IGS_AD_GEN_008.ADMP_GET_SYS_AAS(cst_withdrawn);
2658: ELSE
2659: RETURN p_adm_appl_status;
2660: END IF;
2661: ELSIF v_completed_appl THEN

Line 2666: RETURN IGS_AD_GEN_008.ADMP_GET_SYS_AAS(cst_completed);

2662: -- If this point is reached then all admission course application
2663: -- instances must have a resolved outcome or withdrawn and therefore the application
2664: -- is complete.
2665: IF v_s_adm_appl_status <> cst_completed THEN
2666: RETURN IGS_AD_GEN_008.ADMP_GET_SYS_AAS(cst_completed);
2667: ELSE
2668: RETURN p_adm_appl_status;
2669: END IF;
2670: END IF;

Line 3549: IF IGS_AD_GEN_008.ADMP_GET_SAOS(c_aca_rec.outcome_status) IN (cst_offer, cst_cond_offer) THEN

3545: cst_cond_offer CONSTANT VARCHAR2(10) := 'COND-OFFER';
3546: BEGIN
3547: --Loop through the record set; if an instance with outcome 'Offer' or 'Conditional Offer' is found set the flag to TRUE and exit.
3548: FOR c_aca_rec IN c_aca(p_person_id, p_admission_appl_number, p_nominated_course_cd, p_sequence_number) LOOP
3549: IF IGS_AD_GEN_008.ADMP_GET_SAOS(c_aca_rec.outcome_status) IN (cst_offer, cst_cond_offer) THEN
3550: l_instance_found := TRUE;
3551: EXIT;
3552: END IF;
3553: END LOOP;

Line 3602: v_s_adm_outcome_status := Igs_Ad_Gen_008.Admp_Get_Saos(v_aca_rec.adm_outcome_status);

3598: BEGIN
3599: OPEN c_acai;
3600: FETCH c_acai INTO v_aca_rec;
3601: IF (c_acai%FOUND) THEN
3602: v_s_adm_outcome_status := Igs_Ad_Gen_008.Admp_Get_Saos(v_aca_rec.adm_outcome_status);
3603: v_s_adm_offer_resp_status := Igs_Ad_Gen_008.Admp_Get_Saors(v_aca_rec.adm_offer_resp_status);
3604: v_s_adm_offer_dfrmnt_status := Igs_Ad_Gen_008.Admp_Get_Saods(v_aca_rec.adm_offer_dfrmnt_status);
3605: -- Check if the outcome of the admission course
3606: -- application instance is complete or has been resolved.

Line 3603: v_s_adm_offer_resp_status := Igs_Ad_Gen_008.Admp_Get_Saors(v_aca_rec.adm_offer_resp_status);

3599: OPEN c_acai;
3600: FETCH c_acai INTO v_aca_rec;
3601: IF (c_acai%FOUND) THEN
3602: v_s_adm_outcome_status := Igs_Ad_Gen_008.Admp_Get_Saos(v_aca_rec.adm_outcome_status);
3603: v_s_adm_offer_resp_status := Igs_Ad_Gen_008.Admp_Get_Saors(v_aca_rec.adm_offer_resp_status);
3604: v_s_adm_offer_dfrmnt_status := Igs_Ad_Gen_008.Admp_Get_Saods(v_aca_rec.adm_offer_dfrmnt_status);
3605: -- Check if the outcome of the admission course
3606: -- application instance is complete or has been resolved.
3607: IF ( v_s_adm_outcome_status IN (cst_cancelled, cst_voided, cst_withdrawn,cst_no_quota,cst_rejected)

Line 3604: v_s_adm_offer_dfrmnt_status := Igs_Ad_Gen_008.Admp_Get_Saods(v_aca_rec.adm_offer_dfrmnt_status);

3600: FETCH c_acai INTO v_aca_rec;
3601: IF (c_acai%FOUND) THEN
3602: v_s_adm_outcome_status := Igs_Ad_Gen_008.Admp_Get_Saos(v_aca_rec.adm_outcome_status);
3603: v_s_adm_offer_resp_status := Igs_Ad_Gen_008.Admp_Get_Saors(v_aca_rec.adm_offer_resp_status);
3604: v_s_adm_offer_dfrmnt_status := Igs_Ad_Gen_008.Admp_Get_Saods(v_aca_rec.adm_offer_dfrmnt_status);
3605: -- Check if the outcome of the admission course
3606: -- application instance is complete or has been resolved.
3607: IF ( v_s_adm_outcome_status IN (cst_cancelled, cst_voided, cst_withdrawn,cst_no_quota,cst_rejected)
3608: OR

Line 3679: IGS_AD_GEN_008.ADMP_GET_SAOS(acaiv.adm_outcome_status) IN ('OFFER','COND-OFFER')

3675: WHERE acaiv.person_id = p_person_id AND
3676: acaiv.admission_appl_number = p_admission_appl_number AND
3677: acaiv.nominated_course_cd = p_nominated_course_cd AND
3678: acaiv.sequence_number <> p_sequence_number AND
3679: IGS_AD_GEN_008.ADMP_GET_SAOS(acaiv.adm_outcome_status) IN ('OFFER','COND-OFFER')
3680: AND ( IGS_AD_GEN_008.ADMP_GET_SAORS(acaiv.adm_offer_resp_status) IN (cst_accepted,cst_rejected,cst_lapsed)
3681: OR
3682: (IGS_AD_GEN_008.ADMP_GET_SAORS(acaiv.adm_offer_resp_status) IN (cst_deferral)
3683: AND

Line 3680: AND ( IGS_AD_GEN_008.ADMP_GET_SAORS(acaiv.adm_offer_resp_status) IN (cst_accepted,cst_rejected,cst_lapsed)

3676: acaiv.admission_appl_number = p_admission_appl_number AND
3677: acaiv.nominated_course_cd = p_nominated_course_cd AND
3678: acaiv.sequence_number <> p_sequence_number AND
3679: IGS_AD_GEN_008.ADMP_GET_SAOS(acaiv.adm_outcome_status) IN ('OFFER','COND-OFFER')
3680: AND ( IGS_AD_GEN_008.ADMP_GET_SAORS(acaiv.adm_offer_resp_status) IN (cst_accepted,cst_rejected,cst_lapsed)
3681: OR
3682: (IGS_AD_GEN_008.ADMP_GET_SAORS(acaiv.adm_offer_resp_status) IN (cst_deferral)
3683: AND
3684: IGS_AD_GEN_008.ADMP_GET_SAODS(acaiv.adm_offer_dfrmnt_status) IN (cst_confirm)

Line 3682: (IGS_AD_GEN_008.ADMP_GET_SAORS(acaiv.adm_offer_resp_status) IN (cst_deferral)

3678: acaiv.sequence_number <> p_sequence_number AND
3679: IGS_AD_GEN_008.ADMP_GET_SAOS(acaiv.adm_outcome_status) IN ('OFFER','COND-OFFER')
3680: AND ( IGS_AD_GEN_008.ADMP_GET_SAORS(acaiv.adm_offer_resp_status) IN (cst_accepted,cst_rejected,cst_lapsed)
3681: OR
3682: (IGS_AD_GEN_008.ADMP_GET_SAORS(acaiv.adm_offer_resp_status) IN (cst_deferral)
3683: AND
3684: IGS_AD_GEN_008.ADMP_GET_SAODS(acaiv.adm_offer_dfrmnt_status) IN (cst_confirm)
3685: )
3686: )

Line 3684: IGS_AD_GEN_008.ADMP_GET_SAODS(acaiv.adm_offer_dfrmnt_status) IN (cst_confirm)

3680: AND ( IGS_AD_GEN_008.ADMP_GET_SAORS(acaiv.adm_offer_resp_status) IN (cst_accepted,cst_rejected,cst_lapsed)
3681: OR
3682: (IGS_AD_GEN_008.ADMP_GET_SAORS(acaiv.adm_offer_resp_status) IN (cst_deferral)
3683: AND
3684: IGS_AD_GEN_008.ADMP_GET_SAODS(acaiv.adm_offer_dfrmnt_status) IN (cst_confirm)
3685: )
3686: )
3687: AND rownum <= 1 ;
3688: CURSOR c_aa IS

Line 3826: IGS_AD_GEN_008.ADMP_GET_SAOS(acai.ADM_OUTCOME_STATUS) <> 'PENDING'

3822: acai.future_term_adm_appl_number IS NULL AND
3823: acai.future_term_sequence_number IS NULL AND
3824: acai.def_term_adm_appl_num IS NULL AND
3825: acai.def_appl_sequence_num IS NULL AND
3826: IGS_AD_GEN_008.ADMP_GET_SAOS(acai.ADM_OUTCOME_STATUS) <> 'PENDING'
3827: FOR UPDATE NOWAIT;
3828:
3829:
3830: CURSOR cur_ad_ps_appl ( cur_person_id IGS_AD_PS_APPL.person_id%TYPE ,

Line 3885: IF ( NVL(IGS_AD_GEN_008.ADMP_GET_SAORS(c_aca_rec.Adm_Offer_Resp_Status), 'NULL') = 'ACCEPTED' )

3881: P_ADM_OFFER_RESP_STATUS => c_aca_rec.adm_offer_resp_status
3882: );
3883:
3884:
3885: IF ( NVL(IGS_AD_GEN_008.ADMP_GET_SAORS(c_aca_rec.Adm_Offer_Resp_Status), 'NULL') = 'ACCEPTED' )
3886: THEN
3887: -- UNCONFIRM the Student PROGRAM ATTEMPTS. (api would be provided by enrolments team)
3888:
3889: IF NOT IGS_EN_VAL_SCA.handle_rederive_prog_att (p_person_id => c_aca_rec.PERSON_ID ,

Line 4194: IGS_AD_GEN_008.ADMP_GET_SAOS(acai.ADM_OUTCOME_STATUS) = 'PENDING'

4190: acai.future_term_sequence_number IS NULL AND
4191: acai.def_term_adm_appl_num IS NULL AND
4192: acai.def_appl_sequence_num IS NULL AND
4193: NVL(IGS_AD_GEN_007.ADMP_GET_SAAS(acai.APPL_INST_STATUS),'NULL') <> 'WITHDRAWN' AND
4194: IGS_AD_GEN_008.ADMP_GET_SAOS(acai.ADM_OUTCOME_STATUS) = 'PENDING'
4195: FOR UPDATE NOWAIT;
4196:
4197: c_inst_rec c_inst%ROWTYPE;
4198: