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_VAL_ACAI_STATUS dependencies on IGS_AD_OFRDFRMT_STAT

Line 538: IGS_AD_OFRDFRMT_STAT.s_adm_offer_dfrmnt_status%TYPE;

534: NVL(sca.adm_sequence_number, -1) = NVL(p_acai_sequence_number, -1) AND
535: sca.student_confirmed_ind = 'Y';
536: v_sca_exists VARCHAR2(1);
537: v_s_adm_offer_dfrmnt_status
538: IGS_AD_OFRDFRMT_STAT.s_adm_offer_dfrmnt_status%TYPE;
539: v_message_name VARCHAR2(30);
540: BEGIN
541: -- Set the default message number
542: p_message_name := NULL;

Line 606: -- Validate if IGS_AD_OFRDFRMT_STAT.adm_offer_dfrmnt_status is closed.

602: IGS_GE_MSG_STACK.ADD;
603: App_Exception.Raise_Exception;
604: END admp_val_aods_item;
605: --
606: -- Validate if IGS_AD_OFRDFRMT_STAT.adm_offer_dfrmnt_status is closed.
607: FUNCTION admp_val_aods_closed(
608: p_adm_offer_dfrmnt_status IN VARCHAR2 ,
609: p_message_name OUT NOCOPY VARCHAR2 )
610: RETURN BOOLEAN AS

Line 616: IGS_AD_OFRDFRMT_STAT.adm_offer_dfrmnt_status%TYPE) IS

612: -- Validate the adm_offer_dfrmnt_status closed indicator
613: DECLARE
614: CURSOR c_aods(
615: cp_adm_offer_dfrmnt_status
616: IGS_AD_OFRDFRMT_STAT.adm_offer_dfrmnt_status%TYPE) IS
617: SELECT closed_ind
618: FROM IGS_AD_OFRDFRMT_STAT
619: WHERE adm_offer_dfrmnt_status = cp_adm_offer_dfrmnt_status;
620: v_aods_rec c_aods%ROWTYPE;

Line 618: FROM IGS_AD_OFRDFRMT_STAT

614: CURSOR c_aods(
615: cp_adm_offer_dfrmnt_status
616: IGS_AD_OFRDFRMT_STAT.adm_offer_dfrmnt_status%TYPE) IS
617: SELECT closed_ind
618: FROM IGS_AD_OFRDFRMT_STAT
619: WHERE adm_offer_dfrmnt_status = cp_adm_offer_dfrmnt_status;
620: v_aods_rec c_aods%ROWTYPE;
621: cst_yes CONSTANT CHAR := 'Y';
622: BEGIN

Line 1102: v_s_adm_offer_dfrmnt_status igs_ad_ofrdfrmt_stat.s_adm_offer_dfrmnt_status%TYPE;

1098: cst_otherinst CONSTANT VARCHAR2(10) := 'OTHER-INST';
1099: v_s_adm_offer_resp_status igs_ad_ofr_resp_stat.s_adm_offer_resp_status%TYPE;
1100: v_old_s_adm_offer_resp_status igs_ad_ofr_resp_stat.s_adm_offer_resp_status%TYPE;
1101: v_s_adm_outcome_status igs_ad_ou_stat.s_adm_outcome_status%TYPE;
1102: v_s_adm_offer_dfrmnt_status igs_ad_ofrdfrmt_stat.s_adm_offer_dfrmnt_status%TYPE;
1103: v_old_s_adm_dfrmnt_status igs_ad_ofrdfrmt_stat.s_adm_offer_dfrmnt_status%TYPE;
1104: v_message_name VARCHAR2(30);
1105:
1106: BEGIN

Line 1103: v_old_s_adm_dfrmnt_status igs_ad_ofrdfrmt_stat.s_adm_offer_dfrmnt_status%TYPE;

1099: v_s_adm_offer_resp_status igs_ad_ofr_resp_stat.s_adm_offer_resp_status%TYPE;
1100: v_old_s_adm_offer_resp_status igs_ad_ofr_resp_stat.s_adm_offer_resp_status%TYPE;
1101: v_s_adm_outcome_status igs_ad_ou_stat.s_adm_outcome_status%TYPE;
1102: v_s_adm_offer_dfrmnt_status igs_ad_ofrdfrmt_stat.s_adm_offer_dfrmnt_status%TYPE;
1103: v_old_s_adm_dfrmnt_status igs_ad_ofrdfrmt_stat.s_adm_offer_dfrmnt_status%TYPE;
1104: v_message_name VARCHAR2(30);
1105:
1106: BEGIN
1107: -- Set the default message number

Line 2227: IGS_AD_OFRDFRMT_STAT aods

2223: aods.s_adm_offer_dfrmnt_status
2224: FROM IGS_AD_PS_APLINSTHST acaih,
2225: IGS_AD_OU_STAT aos,
2226: IGS_AD_OFR_RESP_STAT aors,
2227: IGS_AD_OFRDFRMT_STAT aods
2228: WHERE acaih.person_id = p_person_id AND
2229: acaih.admission_appl_number = p_admission_appl_number AND
2230: acaih.nominated_course_cd = p_nominated_course_cd AND
2231: acaih.sequence_number = p_acai_sequence_number AND

Line 3252: v_new_ofr_dfrmnt_status igs_ad_ofrdfrmt_stat.s_adm_offer_dfrmnt_status%TYPE;

3248: admission_appl_number = p_admission_appl_number AND
3249: nominated_course_cd = p_nominated_course_cd AND
3250: sequence_number = p_sequence_number ;
3251:
3252: v_new_ofr_dfrmnt_status igs_ad_ofrdfrmt_stat.s_adm_offer_dfrmnt_status%TYPE;
3253: v_ofr_dfrmnt_status igs_ad_ps_appl_inst.adm_offer_dfrmnt_status%TYPE;
3254: v_s_ofr_dfrmnt_status igs_ad_ofrdfrmt_stat.s_adm_offer_dfrmnt_status%TYPE;
3255: BEGIN
3256: v_new_ofr_dfrmnt_status := igs_ad_gen_008.admp_get_saods(p_offer_deferment_status);

Line 3254: v_s_ofr_dfrmnt_status igs_ad_ofrdfrmt_stat.s_adm_offer_dfrmnt_status%TYPE;

3250: sequence_number = p_sequence_number ;
3251:
3252: v_new_ofr_dfrmnt_status igs_ad_ofrdfrmt_stat.s_adm_offer_dfrmnt_status%TYPE;
3253: v_ofr_dfrmnt_status igs_ad_ps_appl_inst.adm_offer_dfrmnt_status%TYPE;
3254: v_s_ofr_dfrmnt_status igs_ad_ofrdfrmt_stat.s_adm_offer_dfrmnt_status%TYPE;
3255: BEGIN
3256: v_new_ofr_dfrmnt_status := igs_ad_gen_008.admp_get_saods(p_offer_deferment_status);
3257: IF v_new_ofr_dfrmnt_status = 'CONFIRM' THEN
3258: OPEN cur_offer_dfrmnt_status (p_person_id,p_admission_appl_number,p_nominated_course_cd,