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_OFR_RESP_STAT

Line 1099: v_s_adm_offer_resp_status igs_ad_ofr_resp_stat.s_adm_offer_resp_status%TYPE;

1095: cst_trg_as CONSTANT VARCHAR2(7) := 'TRG_AS';
1096: cst_notcoming CONSTANT VARCHAR2(10) := 'NOT-COMING';
1097: cst_rejected CONSTANT VARCHAR2(10) := 'REJECTED';
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;

Line 1100: v_old_s_adm_offer_resp_status igs_ad_ofr_resp_stat.s_adm_offer_resp_status%TYPE;

1096: cst_notcoming CONSTANT VARCHAR2(10) := 'NOT-COMING';
1097: cst_rejected CONSTANT VARCHAR2(10) := 'REJECTED';
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);

Line 1277: v_s_adm_offer_resp_status igs_ad_ofr_resp_stat.s_adm_offer_resp_status%TYPE;

1273: sca.adm_sequence_number = p_acai_sequence_number AND
1274: sca.student_confirmed_ind = 'Y';
1275: v_sca_conf_rec c_sca_conf%ROWTYPE;
1276: v_message_name VARCHAR2(30);
1277: v_s_adm_offer_resp_status igs_ad_ofr_resp_stat.s_adm_offer_resp_status%TYPE;
1278: cst_pending CONSTANT VARCHAR2(10) := 'PENDING';
1279: cst_readmit CONSTANT VARCHAR2(10) := 'RE-ADMIT';
1280: cst_rejected CONSTANT VARCHAR2(10) := 'REJECTED';
1281: cst_discontin CONSTANT VARCHAR2(10) := 'DISCONTIN';

Line 1416: -- Validate if IGS_AD_OFR_RESP_STAT.adm_offer_resp_status is closed.

1412: IGS_GE_MSG_STACK.ADD;
1413: App_Exception.Raise_Exception;
1414: END admp_val_aors_item;
1415: --
1416: -- Validate if IGS_AD_OFR_RESP_STAT.adm_offer_resp_status is closed.
1417: FUNCTION admp_val_aors_closed(
1418: p_adm_offer_resp_status IN VARCHAR2 ,
1419: p_message_name OUT NOCOPY VARCHAR2 )
1420: RETURN BOOLEAN AS

Line 1423: v_closed_ind IGS_AD_OFR_RESP_STAT.closed_ind%TYPE;

1419: p_message_name OUT NOCOPY VARCHAR2 )
1420: RETURN BOOLEAN AS
1421: BEGIN
1422: DECLARE
1423: v_closed_ind IGS_AD_OFR_RESP_STAT.closed_ind%TYPE;
1424: CURSOR c_aors IS
1425: SELECT aors.closed_ind
1426: FROM IGS_AD_OFR_RESP_STAT aors
1427: WHERE aors.adm_offer_resp_status = p_adm_offer_resp_status;

Line 1426: FROM IGS_AD_OFR_RESP_STAT aors

1422: DECLARE
1423: v_closed_ind IGS_AD_OFR_RESP_STAT.closed_ind%TYPE;
1424: CURSOR c_aors IS
1425: SELECT aors.closed_ind
1426: FROM IGS_AD_OFR_RESP_STAT aors
1427: WHERE aors.adm_offer_resp_status = p_adm_offer_resp_status;
1428: BEGIN
1429: -- Validate if IGS_AD_OFR_RESP_STAT.adm_offer_resp_status is closed.
1430: OPEN c_aors;

Line 1429: -- Validate if IGS_AD_OFR_RESP_STAT.adm_offer_resp_status is closed.

1425: SELECT aors.closed_ind
1426: FROM IGS_AD_OFR_RESP_STAT aors
1427: WHERE aors.adm_offer_resp_status = p_adm_offer_resp_status;
1428: BEGIN
1429: -- Validate if IGS_AD_OFR_RESP_STAT.adm_offer_resp_status is closed.
1430: OPEN c_aors;
1431: FETCH c_aors INTO v_closed_ind;
1432: IF (c_aors%FOUND) THEN
1433: IF (v_closed_ind = 'Y') THEN

Line 1604: v_s_adm_offer_resp_status igs_ad_ofr_resp_stat.s_adm_offer_resp_status%TYPE;

1600: v_s_adm_fee_status igs_ad_fee_stat.s_adm_fee_status%TYPE;
1601: v_late_s_adm_fee_status igs_ad_fee_stat.s_adm_fee_status%TYPE;
1602: v_s_adm_entry_qual_status igs_ad_ent_qf_stat.s_adm_entry_qual_status%TYPE;
1603: v_s_adm_cndtnl_offer_status igs_ad_cndnl_ofrstat.s_adm_cndtnl_offer_status%TYPE;
1604: v_s_adm_offer_resp_status igs_ad_ofr_resp_stat.s_adm_offer_resp_status%TYPE;
1605: v_old_s_adm_offer_resp_status igs_ad_ofr_resp_stat.s_adm_offer_resp_status%TYPE;
1606: BEGIN
1607: -- Perform the following validations when the module has been called
1608: -- from the form or from the before row database trigger

Line 1605: v_old_s_adm_offer_resp_status igs_ad_ofr_resp_stat.s_adm_offer_resp_status%TYPE;

1601: v_late_s_adm_fee_status igs_ad_fee_stat.s_adm_fee_status%TYPE;
1602: v_s_adm_entry_qual_status igs_ad_ent_qf_stat.s_adm_entry_qual_status%TYPE;
1603: v_s_adm_cndtnl_offer_status igs_ad_cndnl_ofrstat.s_adm_cndtnl_offer_status%TYPE;
1604: v_s_adm_offer_resp_status igs_ad_ofr_resp_stat.s_adm_offer_resp_status%TYPE;
1605: v_old_s_adm_offer_resp_status igs_ad_ofr_resp_stat.s_adm_offer_resp_status%TYPE;
1606: BEGIN
1607: -- Perform the following validations when the module has been called
1608: -- from the form or from the before row database trigger
1609: IF (p_called_from IN (

Line 2215: v_s_adm_offer_resp_status IGS_AD_OFR_RESP_STAT.s_adm_offer_resp_status%TYPE;

2211: cst_approved CONSTANT VARCHAR2(10) := 'APPROVED';
2212: cst_no_quota CONSTANT VARCHAR2(10) := 'NO-QUOTA';
2213: cst_rejected CONSTANT VARCHAR2(10) := 'REJECTED';
2214: v_s_adm_outcome_status IGS_AD_OU_STAT.s_adm_outcome_status%TYPE;
2215: v_s_adm_offer_resp_status IGS_AD_OFR_RESP_STAT.s_adm_offer_resp_status%TYPE;
2216: v_s_adm_offer_dfrmnt_status IGS_LOOKUPS_VIEW.lookup_code%TYPE;
2217: v_ret_val BOOLEAN;
2218: v_check CHAR := NULL;
2219: v_counter NUMBER := 0;

Line 2226: IGS_AD_OFR_RESP_STAT aors,

2222: aors.s_adm_offer_resp_status,
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

Line 2700: IGS_AD_OFR_RESP_STAT aors

2696: CURSOR c_acaiv_aos IS
2697: SELECT 'x'
2698: FROM IGS_AD_PS_APPL_INST acaiv, /* References to IGS_AD_PS_APPL_INST_APLINST_V replaced with IGS_AD_PS_APPL_INST Bug 3150054 */
2699: IGS_AD_OU_STAT aos,
2700: IGS_AD_OFR_RESP_STAT aors
2701: WHERE acaiv.person_id = p_person_id AND
2702: (acaiv.admission_appl_number <> p_admission_appl_number OR
2703: acaiv.nominated_course_cd <> p_nominated_course_cd OR
2704: acaiv.sequence_number <> p_acai_sequence_number) AND

Line 2717: IGS_AD_OFR_RESP_STAT aors

2713: SELECT count(*)
2714: FROM IGS_AD_PS_APPL_INST acaiv, /* References to IGS_AD_PS_APPL_INST_APLINST_V replaced with IGS_AD_PS_APPL_INST Bug 3150054 */
2715: IGS_AD_APPL aa,
2716: IGS_AD_OU_STAT aos,
2717: IGS_AD_OFR_RESP_STAT aors
2718: WHERE acaiv.person_id = p_person_id AND
2719: (acaiv.admission_appl_number <> p_admission_appl_number OR
2720: acaiv.nominated_course_cd <> p_nominated_course_cd OR
2721: acaiv.sequence_number <> p_acai_sequence_number) AND

Line 2817: IGS_AD_OFR_RESP_STAT.s_adm_offer_resp_status%TYPE :='REJECTED';

2813: cst_offer CONSTANT IGS_AD_OU_STAT.s_adm_outcome_status%TYPE :='OFFER';
2814: cst_cond_offer CONSTANT
2815: IGS_AD_OU_STAT.s_adm_outcome_status%TYPE :='COND-OFFER';
2816: cst_rejected CONSTANT
2817: IGS_AD_OFR_RESP_STAT.s_adm_offer_resp_status%TYPE :='REJECTED';
2818: cst_not_applic CONSTANT
2819: IGS_AD_OFR_RESP_STAT.s_adm_offer_resp_status%TYPE :='NOT-APPLIC';
2820: cst_warn CONSTANT VARCHAR2(1) := 'W';
2821: cst_error CONSTANT VARCHAR2(1) := 'E';

Line 2819: IGS_AD_OFR_RESP_STAT.s_adm_offer_resp_status%TYPE :='NOT-APPLIC';

2815: IGS_AD_OU_STAT.s_adm_outcome_status%TYPE :='COND-OFFER';
2816: cst_rejected CONSTANT
2817: IGS_AD_OFR_RESP_STAT.s_adm_offer_resp_status%TYPE :='REJECTED';
2818: cst_not_applic CONSTANT
2819: IGS_AD_OFR_RESP_STAT.s_adm_offer_resp_status%TYPE :='NOT-APPLIC';
2820: cst_warn CONSTANT VARCHAR2(1) := 'W';
2821: cst_error CONSTANT VARCHAR2(1) := 'E';
2822: v_aaaa_exists VARCHAR2(1);
2823: v_s_adm_outcome_status igs_ad_ou_stat.s_adm_outcome_status%TYPE;

Line 2824: v_s_adm_offer_resp_status igs_ad_ofr_resp_stat.s_adm_offer_resp_status%TYPE;

2820: cst_warn CONSTANT VARCHAR2(1) := 'W';
2821: cst_error CONSTANT VARCHAR2(1) := 'E';
2822: v_aaaa_exists VARCHAR2(1);
2823: v_s_adm_outcome_status igs_ad_ou_stat.s_adm_outcome_status%TYPE;
2824: v_s_adm_offer_resp_status igs_ad_ofr_resp_stat.s_adm_offer_resp_status%TYPE;
2825: CURSOR c_aaaa IS
2826: SELECT 'x'
2827: FROM IGS_AD_PS_APPL_INST acaiv, /* References to IGS_AD_PS_APPL_INST_APLINST_V replaced with IGS_AD_PS_APPL_INST Bug 3150054 */
2828: IGS_AD_APPL aa,

Line 2830: IGS_AD_OFR_RESP_STAT aors

2826: SELECT 'x'
2827: FROM IGS_AD_PS_APPL_INST acaiv, /* References to IGS_AD_PS_APPL_INST_APLINST_V replaced with IGS_AD_PS_APPL_INST Bug 3150054 */
2828: IGS_AD_APPL aa,
2829: IGS_AD_OU_STAT aos,
2830: IGS_AD_OFR_RESP_STAT aors
2831: WHERE acaiv.person_id = p_person_id AND
2832: (acaiv.admission_appl_number <> p_admission_appl_number OR
2833: acaiv.nominated_course_cd <> p_nominated_course_cd OR
2834: acaiv.sequence_number <> p_acai_sequence_number) AND