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_ENT_QF_STAT

Line 18: v_s_adm_entry_qual_status igs_ad_ent_qf_stat.s_adm_entry_qual_status%TYPE;

14: BEGIN -- admp_val_acai_aeqs
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;

Line 68: v_s_adm_entry_qual_status igs_ad_ent_qf_stat.s_adm_entry_qual_status%TYPE;

64: -- Validate the IGS_AD_PS_APPL_INST.adm_entry_qual_status.
65: -- It must be open and valid.
66: DECLARE
67: v_message_name VARCHAR2(30);
68: v_s_adm_entry_qual_status igs_ad_ent_qf_stat.s_adm_entry_qual_status%TYPE;
69: BEGIN
70: -- Set the default message number
71: p_message_name := NULL;
72: -- Validate the closed indicator

Line 102: -- Validate if IGS_AD_ENT_QF_STAT.adm_entry_qual_status is closed.

98: RETURN TRUE;
99: END;
100: END admp_val_aeqs_item;
101: --
102: -- Validate if IGS_AD_ENT_QF_STAT.adm_entry_qual_status is closed.
103: FUNCTION admp_val_aeqs_closed(
104: p_adm_entry_qual_status IN VARCHAR2 ,
105: p_message_name OUT NOCOPY VARCHAR2 )
106: RETURN BOOLEAN AS

Line 111: cp_adm_entry_qual_status IGS_AD_ENT_QF_STAT.adm_entry_qual_status%TYPE) IS

107: BEGIN -- admp_val_aeqs_closed
108: -- Validate the adm_entry_qual_status closed indicator
109: DECLARE
110: CURSOR c_aeqs(
111: cp_adm_entry_qual_status IGS_AD_ENT_QF_STAT.adm_entry_qual_status%TYPE) IS
112: SELECT closed_ind
113: FROM IGS_AD_ENT_QF_STAT
114: WHERE adm_entry_qual_status = cp_adm_entry_qual_status;
115: v_aeqs_rec c_aeqs%ROWTYPE;

Line 113: FROM IGS_AD_ENT_QF_STAT

109: DECLARE
110: CURSOR c_aeqs(
111: cp_adm_entry_qual_status IGS_AD_ENT_QF_STAT.adm_entry_qual_status%TYPE) IS
112: SELECT closed_ind
113: FROM IGS_AD_ENT_QF_STAT
114: WHERE adm_entry_qual_status = cp_adm_entry_qual_status;
115: v_aeqs_rec c_aeqs%ROWTYPE;
116: cst_yes CONSTANT CHAR := 'Y';
117: BEGIN

Line 154: IGS_AD_ENT_QF_STAT.s_adm_entry_qual_status%TYPE:= 'NOT-APPLIC';

150: -- If the admission entry qualification status is applicable for the admission
151: -- application, then it cannot be not-qualified if an offer is being made.
152: DECLARE
153: cst_not_applic CONSTANT
154: IGS_AD_ENT_QF_STAT.s_adm_entry_qual_status%TYPE:= 'NOT-APPLIC';
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';

Line 156: IGS_AD_ENT_QF_STAT.s_adm_entry_qual_status%TYPE := 'PENDING';

152: DECLARE
153: cst_not_applic CONSTANT
154: IGS_AD_ENT_QF_STAT.s_adm_entry_qual_status%TYPE:= 'NOT-APPLIC';
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

Line 158: IGS_AD_ENT_QF_STAT.s_adm_entry_qual_status%TYPE := 'NOT-QUAL';

154: IGS_AD_ENT_QF_STAT.s_adm_entry_qual_status%TYPE:= 'NOT-APPLIC';
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

Line 361: IGS_AD_ENT_QF_STAT.s_adm_entry_qual_status%TYPE := 'NOT-APPLIC';

357: -- The admission documentation status cannot be incomple, unsatisfactory or
358: -- rejected if a conditional offer has been satisfied.
359: DECLARE
360: cst_not_applic CONSTANT
361: IGS_AD_ENT_QF_STAT.s_adm_entry_qual_status%TYPE := 'NOT-APPLIC';
362: cst_pending CONSTANT
363: IGS_AD_ENT_QF_STAT.s_adm_entry_qual_status%TYPE := 'PENDING';
364: cst_incomplete CONSTANT
365: IGS_AD_ENT_QF_STAT.s_adm_entry_qual_status%TYPE := 'INCOMPLETE';

Line 363: IGS_AD_ENT_QF_STAT.s_adm_entry_qual_status%TYPE := 'PENDING';

359: DECLARE
360: cst_not_applic CONSTANT
361: IGS_AD_ENT_QF_STAT.s_adm_entry_qual_status%TYPE := 'NOT-APPLIC';
362: cst_pending CONSTANT
363: IGS_AD_ENT_QF_STAT.s_adm_entry_qual_status%TYPE := 'PENDING';
364: cst_incomplete CONSTANT
365: IGS_AD_ENT_QF_STAT.s_adm_entry_qual_status%TYPE := 'INCOMPLETE';
366: cst_unsatisfac CONSTANT
367: IGS_AD_ENT_QF_STAT.s_adm_entry_qual_status%TYPE := 'UNSATISFAC';

Line 365: IGS_AD_ENT_QF_STAT.s_adm_entry_qual_status%TYPE := 'INCOMPLETE';

361: IGS_AD_ENT_QF_STAT.s_adm_entry_qual_status%TYPE := 'NOT-APPLIC';
362: cst_pending CONSTANT
363: IGS_AD_ENT_QF_STAT.s_adm_entry_qual_status%TYPE := 'PENDING';
364: cst_incomplete CONSTANT
365: IGS_AD_ENT_QF_STAT.s_adm_entry_qual_status%TYPE := 'INCOMPLETE';
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';

Line 367: IGS_AD_ENT_QF_STAT.s_adm_entry_qual_status%TYPE := 'UNSATISFAC';

363: IGS_AD_ENT_QF_STAT.s_adm_entry_qual_status%TYPE := 'PENDING';
364: cst_incomplete CONSTANT
365: IGS_AD_ENT_QF_STAT.s_adm_entry_qual_status%TYPE := 'INCOMPLETE';
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

Line 369: IGS_AD_ENT_QF_STAT.s_adm_entry_qual_status%TYPE := 'REJECTED-F';

365: IGS_AD_ENT_QF_STAT.s_adm_entry_qual_status%TYPE := 'INCOMPLETE';
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

Line 1602: v_s_adm_entry_qual_status igs_ad_ent_qf_stat.s_adm_entry_qual_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;
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