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.

[Home] [Help]

APPS.IGS_AD_VAL_ACAI_STATUS dependencies on IGS_AD_OU_STAT

Line 19: v_s_adm_outcome_status igs_ad_ou_stat.s_adm_outcome_status%TYPE;

15: -- Validate the IGS_AD_PS_APPL_INST.adm_entry_qual_status.
16: DECLARE
17: v_message_name VARCHAR2(30);
18: v_s_adm_entry_qual_status igs_ad_ent_qf_stat.s_adm_entry_qual_status%TYPE;
19: v_s_adm_outcome_status igs_ad_ou_stat.s_adm_outcome_status%TYPE;
20: BEGIN
21: -- Set the default message number
22: p_message_name := NULL;
23: -- Perform item level validations.

Line 159: cst_offer CONSTANT IGS_AD_OU_STAT.s_adm_outcome_status%TYPE := 'OFFER';

155: cst_pending CONSTANT
156: IGS_AD_ENT_QF_STAT.s_adm_entry_qual_status%TYPE := 'PENDING';
157: cst_not_qual CONSTANT
158: IGS_AD_ENT_QF_STAT.s_adm_entry_qual_status%TYPE := 'NOT-QUAL';
159: cst_offer CONSTANT IGS_AD_OU_STAT.s_adm_outcome_status%TYPE := 'OFFER';
160: cst_cond_offer CONSTANT
161: IGS_AD_OU_STAT.s_adm_outcome_status%TYPE := 'COND-OFFER';
162: cst_withdrawn CONSTANT
163: IGS_AD_OU_STAT.s_adm_outcome_status%TYPE := 'WITHDRAWN';

Line 161: IGS_AD_OU_STAT.s_adm_outcome_status%TYPE := 'COND-OFFER';

157: cst_not_qual CONSTANT
158: IGS_AD_ENT_QF_STAT.s_adm_entry_qual_status%TYPE := 'NOT-QUAL';
159: cst_offer CONSTANT IGS_AD_OU_STAT.s_adm_outcome_status%TYPE := 'OFFER';
160: cst_cond_offer CONSTANT
161: IGS_AD_OU_STAT.s_adm_outcome_status%TYPE := 'COND-OFFER';
162: cst_withdrawn CONSTANT
163: IGS_AD_OU_STAT.s_adm_outcome_status%TYPE := 'WITHDRAWN';
164: cst_voided CONSTANT IGS_AD_OU_STAT.s_adm_outcome_status%TYPE := 'VOIDED';
165: BEGIN

Line 163: IGS_AD_OU_STAT.s_adm_outcome_status%TYPE := 'WITHDRAWN';

159: cst_offer CONSTANT IGS_AD_OU_STAT.s_adm_outcome_status%TYPE := 'OFFER';
160: cst_cond_offer CONSTANT
161: IGS_AD_OU_STAT.s_adm_outcome_status%TYPE := 'COND-OFFER';
162: cst_withdrawn CONSTANT
163: IGS_AD_OU_STAT.s_adm_outcome_status%TYPE := 'WITHDRAWN';
164: cst_voided CONSTANT IGS_AD_OU_STAT.s_adm_outcome_status%TYPE := 'VOIDED';
165: BEGIN
166: p_message_name := NULL;
167: -- Only validate the admission entry qualification status if

Line 164: cst_voided CONSTANT IGS_AD_OU_STAT.s_adm_outcome_status%TYPE := 'VOIDED';

160: cst_cond_offer CONSTANT
161: IGS_AD_OU_STAT.s_adm_outcome_status%TYPE := 'COND-OFFER';
162: cst_withdrawn CONSTANT
163: IGS_AD_OU_STAT.s_adm_outcome_status%TYPE := 'WITHDRAWN';
164: cst_voided CONSTANT IGS_AD_OU_STAT.s_adm_outcome_status%TYPE := 'VOIDED';
165: BEGIN
166: p_message_name := NULL;
167: -- Only validate the admission entry qualification status if
168: -- it has a system value other then not-applicable

Line 217: v_s_adm_outcome_status igs_ad_ou_stat.s_adm_outcome_status%TYPE;

213: -- Validate the IGS_AD_PS_APPL_INST.adm_doc_status.
214: DECLARE
215: v_message_name VARCHAR2(30);
216: v_s_adm_doc_status igs_ad_doc_stat.s_adm_doc_status%TYPE;
217: v_s_adm_outcome_status igs_ad_ou_stat.s_adm_outcome_status%TYPE;
218: v_s_adm_cndtnl_offer_status igs_ad_cndnl_ofrstat.s_adm_cndtnl_offer_status%TYPE;
219: BEGIN
220: -- Set the default message number
221: p_message_name := NULL;

Line 370: cst_offer CONSTANT IGS_AD_OU_STAT.s_adm_outcome_status%TYPE := 'OFFER';

366: cst_unsatisfac CONSTANT
367: IGS_AD_ENT_QF_STAT.s_adm_entry_qual_status%TYPE := 'UNSATISFAC';
368: cst_rejected_f CONSTANT
369: IGS_AD_ENT_QF_STAT.s_adm_entry_qual_status%TYPE := 'REJECTED-F';
370: cst_offer CONSTANT IGS_AD_OU_STAT.s_adm_outcome_status%TYPE := 'OFFER';
371: cst_cond_offer CONSTANT
372: IGS_AD_OU_STAT.s_adm_outcome_status%TYPE := 'COND-OFFER';
373: cst_withdrawn CONSTANT
374: IGS_AD_OU_STAT.s_adm_outcome_status%TYPE := 'WITHDRAWN';

Line 372: IGS_AD_OU_STAT.s_adm_outcome_status%TYPE := 'COND-OFFER';

368: cst_rejected_f CONSTANT
369: IGS_AD_ENT_QF_STAT.s_adm_entry_qual_status%TYPE := 'REJECTED-F';
370: cst_offer CONSTANT IGS_AD_OU_STAT.s_adm_outcome_status%TYPE := 'OFFER';
371: cst_cond_offer CONSTANT
372: IGS_AD_OU_STAT.s_adm_outcome_status%TYPE := 'COND-OFFER';
373: cst_withdrawn CONSTANT
374: IGS_AD_OU_STAT.s_adm_outcome_status%TYPE := 'WITHDRAWN';
375: cst_voided CONSTANT IGS_AD_OU_STAT.s_adm_outcome_status%TYPE := 'VOIDED';
376: cst_satisfied CONSTANT

Line 374: IGS_AD_OU_STAT.s_adm_outcome_status%TYPE := 'WITHDRAWN';

370: cst_offer CONSTANT IGS_AD_OU_STAT.s_adm_outcome_status%TYPE := 'OFFER';
371: cst_cond_offer CONSTANT
372: IGS_AD_OU_STAT.s_adm_outcome_status%TYPE := 'COND-OFFER';
373: cst_withdrawn CONSTANT
374: IGS_AD_OU_STAT.s_adm_outcome_status%TYPE := 'WITHDRAWN';
375: cst_voided CONSTANT IGS_AD_OU_STAT.s_adm_outcome_status%TYPE := 'VOIDED';
376: cst_satisfied CONSTANT
377: IGS_AD_CNDNL_OFRSTAT.s_adm_cndtnl_offer_status%TYPE := 'SATISFIED';
378: BEGIN

Line 375: cst_voided CONSTANT IGS_AD_OU_STAT.s_adm_outcome_status%TYPE := 'VOIDED';

371: cst_cond_offer CONSTANT
372: IGS_AD_OU_STAT.s_adm_outcome_status%TYPE := 'COND-OFFER';
373: cst_withdrawn CONSTANT
374: IGS_AD_OU_STAT.s_adm_outcome_status%TYPE := 'WITHDRAWN';
375: cst_voided CONSTANT IGS_AD_OU_STAT.s_adm_outcome_status%TYPE := 'VOIDED';
376: cst_satisfied CONSTANT
377: IGS_AD_CNDNL_OFRSTAT.s_adm_cndtnl_offer_status%TYPE := 'SATISFIED';
378: BEGIN
379: p_message_name := NULL;

Line 738: v_s_adm_outcome_status igs_ad_ou_stat.s_adm_outcome_status%TYPE;

734: BEGIN -- admp_val_acai_lafs
735: -- Validate the IGS_AD_PS_APPL_INST.late_adm_fee_status.
736: DECLARE
737: v_s_late_adm_fee_status igs_ad_fee_stat.s_adm_fee_status%TYPE;
738: v_s_adm_outcome_status igs_ad_ou_stat.s_adm_outcome_status%TYPE;
739: v_s_adm_cndtnl_offer_status igs_ad_cndnl_ofrstat.s_adm_cndtnl_offer_status%TYPE ;
740: v_message_name VARCHAR2(30);
741: BEGIN
742: -- Set the default message number

Line 1101: v_s_adm_outcome_status igs_ad_ou_stat.s_adm_outcome_status%TYPE;

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);
1105:

Line 1597: v_s_adm_outcome_status igs_ad_ou_stat.s_adm_outcome_status%TYPE;

1593: cst_form CONSTANT VARCHAR2(6) := 'FORM';
1594: cst_trg_br CONSTANT VARCHAR2(6) := 'TRG_BR';
1595: cst_trg_as CONSTANT VARCHAR2(6) := 'TRG_AS';
1596: v_message_name VARCHAR2(30);
1597: v_s_adm_outcome_status igs_ad_ou_stat.s_adm_outcome_status%TYPE;
1598: v_old_s_adm_outcome_status igs_ad_ou_stat.s_adm_outcome_status%TYPE;
1599: v_s_adm_doc_status igs_ad_doc_stat.s_adm_doc_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;

Line 1598: v_old_s_adm_outcome_status igs_ad_ou_stat.s_adm_outcome_status%TYPE;

1594: cst_trg_br CONSTANT VARCHAR2(6) := 'TRG_BR';
1595: cst_trg_as CONSTANT VARCHAR2(6) := 'TRG_AS';
1596: v_message_name VARCHAR2(30);
1597: v_s_adm_outcome_status igs_ad_ou_stat.s_adm_outcome_status%TYPE;
1598: v_old_s_adm_outcome_status igs_ad_ou_stat.s_adm_outcome_status%TYPE;
1599: v_s_adm_doc_status igs_ad_doc_stat.s_adm_doc_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;

Line 1818: v_s_adm_outcome_status igs_ad_ou_stat.s_adm_outcome_status%TYPE;

1814: cst_not_applic CONSTANT VARCHAR2(10) := 'NOT-APPLIC';
1815: cst_deleted CONSTANT VARCHAR2(7) := 'DELETED';
1816: cst_unconfirmed CONSTANT VARCHAR2(11) := 'UNCONFIRM';
1817: cst_offer_future_term CONSTANT VARCHAR2(20) := 'OFFER-FUTURE-TERM';
1818: v_s_adm_outcome_status igs_ad_ou_stat.s_adm_outcome_status%TYPE;
1819: v_old_s_adm_outcome_status igs_ad_ou_stat.s_adm_outcome_status%TYPE;
1820: v_s_adm_fee_status igs_ad_fee_stat.s_adm_fee_status%TYPE;
1821: v_message_name VARCHAR2(30);
1822: v_dummy VARCHAR2(1);

Line 1819: v_old_s_adm_outcome_status igs_ad_ou_stat.s_adm_outcome_status%TYPE;

1815: cst_deleted CONSTANT VARCHAR2(7) := 'DELETED';
1816: cst_unconfirmed CONSTANT VARCHAR2(11) := 'UNCONFIRM';
1817: cst_offer_future_term CONSTANT VARCHAR2(20) := 'OFFER-FUTURE-TERM';
1818: v_s_adm_outcome_status igs_ad_ou_stat.s_adm_outcome_status%TYPE;
1819: v_old_s_adm_outcome_status igs_ad_ou_stat.s_adm_outcome_status%TYPE;
1820: v_s_adm_fee_status igs_ad_fee_stat.s_adm_fee_status%TYPE;
1821: v_message_name VARCHAR2(30);
1822: v_dummy VARCHAR2(1);
1823: CURSOR c_sca IS

Line 1937: -- Validate if IGS_AD_OU_STAT.adm_outcome_status is closed.

1933: IGS_GE_MSG_STACK.ADD;
1934: App_Exception.Raise_Exception;
1935: END admp_val_aos_item;
1936: --
1937: -- Validate if IGS_AD_OU_STAT.adm_outcome_status is closed.
1938: FUNCTION admp_val_aos_closed(
1939: p_adm_outcome_status IN VARCHAR2 ,
1940: p_message_name OUT NOCOPY VARCHAR2 )
1941: RETURN BOOLEAN AS

Line 1944: v_closed_ind IGS_AD_OU_STAT.closed_ind%TYPE;

1940: p_message_name OUT NOCOPY VARCHAR2 )
1941: RETURN BOOLEAN AS
1942: BEGIN
1943: DECLARE
1944: v_closed_ind IGS_AD_OU_STAT.closed_ind%TYPE;
1945: CURSOR c_aos IS
1946: SELECT aos.closed_ind
1947: FROM IGS_AD_OU_STAT aos
1948: WHERE aos.adm_outcome_status = p_adm_outcome_status;

Line 1947: FROM IGS_AD_OU_STAT aos

1943: DECLARE
1944: v_closed_ind IGS_AD_OU_STAT.closed_ind%TYPE;
1945: CURSOR c_aos IS
1946: SELECT aos.closed_ind
1947: FROM IGS_AD_OU_STAT aos
1948: WHERE aos.adm_outcome_status = p_adm_outcome_status;
1949: BEGIN
1950: -- Validate if IGS_AD_OU_STAT.adm_outcome_status is closed.
1951: OPEN c_aos;

Line 1950: -- Validate if IGS_AD_OU_STAT.adm_outcome_status is closed.

1946: SELECT aos.closed_ind
1947: FROM IGS_AD_OU_STAT aos
1948: WHERE aos.adm_outcome_status = p_adm_outcome_status;
1949: BEGIN
1950: -- Validate if IGS_AD_OU_STAT.adm_outcome_status is closed.
1951: OPEN c_aos;
1952: FETCH c_aos INTO v_closed_ind;
1953: IF (c_aos%FOUND) THEN
1954: IF (v_closed_ind = 'Y') THEN

Line 2146: v_adm_outcome_status IGS_AD_OU_STAT.adm_outcome_status%TYPE;

2142: v_message_name VARCHAR2(30);
2143: v_return_type VARCHAR2(1);
2144: v_late_ind VARCHAR2(1);
2145: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
2146: v_adm_outcome_status IGS_AD_OU_STAT.adm_outcome_status%TYPE;
2147: v_effective_dt DATE;
2148: v_prpsd_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
2149: v_ca_sequence_number NUMBER;
2150: CURSOR c_aal IS

Line 2159: IGS_AD_OU_STAT aos

2155: aal.correspondence_type = cst_outcome_lt;
2156: CURSOR c_acai_aos IS
2157: SELECT 'x'
2158: FROM IGS_AD_PS_APPL_INST acai,
2159: IGS_AD_OU_STAT aos
2160: WHERE acai.person_id = p_person_id AND
2161: acai.admission_appl_number = p_admission_appl_number AND
2162: (acai.nominated_course_cd <> p_nominated_course_cd OR
2163: acai.sequence_number <> p_acai_sequence_number) AND

Line 2214: v_s_adm_outcome_status IGS_AD_OU_STAT.s_adm_outcome_status%TYPE;

2210: cst_deferral CONSTANT VARCHAR2(10) := 'DEFERRAL';
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;

Line 2225: IGS_AD_OU_STAT aos,

2221: SELECT aos.s_adm_outcome_status,
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

Line 2699: IGS_AD_OU_STAT aos,

2695: cst_not_applic CONSTANT VARCHAR2(10) := 'NOT-APPLIC';
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

Line 2716: IGS_AD_OU_STAT aos,

2712: CURSOR c_cnt_acaiv_aa_aos IS
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

Line 2813: cst_offer CONSTANT IGS_AD_OU_STAT.s_adm_outcome_status%TYPE :='OFFER';

2809: -- * Warn if the IGS_PE_PERSON is being made an offer and they already have a
2810: -- current offer in another admission process category for
2811: -- this admission period.
2812: DECLARE
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';

Line 2815: IGS_AD_OU_STAT.s_adm_outcome_status%TYPE :='COND-OFFER';

2811: -- this admission period.
2812: DECLARE
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';

Line 2823: v_s_adm_outcome_status igs_ad_ou_stat.s_adm_outcome_status%TYPE;

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;
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 */

Line 2829: IGS_AD_OU_STAT aos,

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,
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

Line 2974: v_s_adm_outcome_status igs_ad_ou_stat.s_adm_outcome_status%TYPE;

2970: DECLARE
2971: v_message_name VARCHAR2(30);
2972: v_s_adm_cndtnl_offer_status igs_ad_cndnl_ofrstat.s_adm_cndtnl_offer_status%TYPE;
2973: v_old_s_adm_cndtnl_offer_stat igs_ad_cndnl_ofrstat.s_adm_cndtnl_offer_status%TYPE;
2974: v_s_adm_outcome_status igs_ad_ou_stat.s_adm_outcome_status%TYPE;
2975: v_s_adm_doc_status igs_ad_doc_stat.s_adm_doc_status%TYPE;
2976: v_late_s_adm_fee_status igs_ad_fee_stat.s_adm_fee_status%TYPE;
2977: BEGIN
2978: --set the default message number

Line 3295: v_s_adm_outcome_status IGS_AD_OU_STAT.s_adm_outcome_status%TYPE;

3291: BEGIN -- admp_val_acai_ais
3292: -- Validate the IGS_AD_PS_APPL_INST.appl_inst_status
3293: DECLARE
3294: v_s_appl_inst_status IGS_AD_PS_APPL_INST.appl_inst_status%TYPE;
3295: v_s_adm_outcome_status IGS_AD_OU_STAT.s_adm_outcome_status%TYPE;
3296: v_message_name VARCHAR2(30);
3297: BEGIN
3298: -- Set the default message number
3299: p_message_name := NULL;