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.IGR_VAL_EAP dependencies on IGR_I_APPL

Line 17: -- Validate IGR_I_APPL.enquiry_status:

13: p_enquiry_status IN VARCHAR2 ,
14: p_message_name OUT NOCOPY VARCHAR2)
15: RETURN BOOLEAN IS
16: BEGIN -- admp_val_eap_es_comp
17: -- Validate IGR_I_APPL.enquiry_status:
18: -- * Must be set to system status of 'COMPLETE' if no child
19: -- IGR_I_A_PKGITM_V records exist with mailed_dt set to NULL.
20: DECLARE
21: cst_complete CONSTANT VARCHAR2(20) := 'OSS_COMPLETE';

Line 107: -- (IGR_I_APPL.acad_cal_type, IGR_I_APPL.acad_ci_sequence_number).

103: p_message_name OUT NOCOPY VARCHAR2)
104: RETURN BOOLEAN IS
105: BEGIN -- admp_val_aa_acad_cal
106: -- Validate the admission enquiry application commencement period
107: -- (IGR_I_APPL.acad_cal_type, IGR_I_APPL.acad_ci_sequence_number).
108: -- Validations are -
109: -- ? IGR_I_APPL.acad_cal_type must be an Academic calendar.
110: -- ? IGR_I_APPL.acad_cal_type and IGR_I_APPL.acad_ci_sequence_number
111: -- must be an Active calendar instance.

Line 109: -- ? IGR_I_APPL.acad_cal_type must be an Academic calendar.

105: BEGIN -- admp_val_aa_acad_cal
106: -- Validate the admission enquiry application commencement period
107: -- (IGR_I_APPL.acad_cal_type, IGR_I_APPL.acad_ci_sequence_number).
108: -- Validations are -
109: -- ? IGR_I_APPL.acad_cal_type must be an Academic calendar.
110: -- ? IGR_I_APPL.acad_cal_type and IGR_I_APPL.acad_ci_sequence_number
111: -- must be an Active calendar instance.
112: DECLARE
113: CURSOR c_ct (

Line 110: -- ? IGR_I_APPL.acad_cal_type and IGR_I_APPL.acad_ci_sequence_number

106: -- Validate the admission enquiry application commencement period
107: -- (IGR_I_APPL.acad_cal_type, IGR_I_APPL.acad_ci_sequence_number).
108: -- Validations are -
109: -- ? IGR_I_APPL.acad_cal_type must be an Academic calendar.
110: -- ? IGR_I_APPL.acad_cal_type and IGR_I_APPL.acad_ci_sequence_number
111: -- must be an Active calendar instance.
112: DECLARE
113: CURSOR c_ct (
114: cp_acad_cal_type IGR_I_APPL.acad_cal_type%TYPE) IS

Line 114: cp_acad_cal_type IGR_I_APPL.acad_cal_type%TYPE) IS

110: -- ? IGR_I_APPL.acad_cal_type and IGR_I_APPL.acad_ci_sequence_number
111: -- must be an Active calendar instance.
112: DECLARE
113: CURSOR c_ct (
114: cp_acad_cal_type IGR_I_APPL.acad_cal_type%TYPE) IS
115: SELECT s_cal_cat
116: FROM IGS_CA_TYPE
117: WHERE cal_type = cp_acad_cal_type;
118: CURSOR c_ci_cs (

Line 119: cp_acad_cal_type IGR_I_APPL.acad_cal_type%TYPE,

115: SELECT s_cal_cat
116: FROM IGS_CA_TYPE
117: WHERE cal_type = cp_acad_cal_type;
118: CURSOR c_ci_cs (
119: cp_acad_cal_type IGR_I_APPL.acad_cal_type%TYPE,
120: cp_acad_ci_sequence_number IGR_I_APPL.acad_ci_sequence_number%TYPE) IS
121: SELECT cs.s_cal_status
122: FROM IGS_CA_STAT cs,
123: IGS_CA_INST ci

Line 120: cp_acad_ci_sequence_number IGR_I_APPL.acad_ci_sequence_number%TYPE) IS

116: FROM IGS_CA_TYPE
117: WHERE cal_type = cp_acad_cal_type;
118: CURSOR c_ci_cs (
119: cp_acad_cal_type IGR_I_APPL.acad_cal_type%TYPE,
120: cp_acad_ci_sequence_number IGR_I_APPL.acad_ci_sequence_number%TYPE) IS
121: SELECT cs.s_cal_status
122: FROM IGS_CA_STAT cs,
123: IGS_CA_INST ci
124: WHERE ci.cal_type = cp_acad_cal_type AND

Line 213: -- (IGR_I_APPL.adm_cal_type,

209: cir.sub_cal_type = cp_adm_cal_type AND
210: cir.sub_ci_sequence_number = cp_adm_ci_sequence_number;
211: BEGIN
212: -- Validate the admission enquiry admission calendar
213: -- (IGR_I_APPL.adm_cal_type,
214: -- IGR_I_APPL.adm_ci_sequence_number).
215: -- Validations are -
216: -- IGR_I_APPL.acad_cal_type must be an Admission calendar.
217: -- IGR_I_APPL.adm_cal_type and IGR_I_APPL.adm_ci_sequence_number

Line 214: -- IGR_I_APPL.adm_ci_sequence_number).

210: cir.sub_ci_sequence_number = cp_adm_ci_sequence_number;
211: BEGIN
212: -- Validate the admission enquiry admission calendar
213: -- (IGR_I_APPL.adm_cal_type,
214: -- IGR_I_APPL.adm_ci_sequence_number).
215: -- Validations are -
216: -- IGR_I_APPL.acad_cal_type must be an Admission calendar.
217: -- IGR_I_APPL.adm_cal_type and IGR_I_APPL.adm_ci_sequence_number
218: -- must be

Line 216: -- IGR_I_APPL.acad_cal_type must be an Admission calendar.

212: -- Validate the admission enquiry admission calendar
213: -- (IGR_I_APPL.adm_cal_type,
214: -- IGR_I_APPL.adm_ci_sequence_number).
215: -- Validations are -
216: -- IGR_I_APPL.acad_cal_type must be an Admission calendar.
217: -- IGR_I_APPL.adm_cal_type and IGR_I_APPL.adm_ci_sequence_number
218: -- must be
219: -- an Active calendar instance.
220: -- The Admission Calendar must be a child of the Academic Calendar.

Line 217: -- IGR_I_APPL.adm_cal_type and IGR_I_APPL.adm_ci_sequence_number

213: -- (IGR_I_APPL.adm_cal_type,
214: -- IGR_I_APPL.adm_ci_sequence_number).
215: -- Validations are -
216: -- IGR_I_APPL.acad_cal_type must be an Admission calendar.
217: -- IGR_I_APPL.adm_cal_type and IGR_I_APPL.adm_ci_sequence_number
218: -- must be
219: -- an Active calendar instance.
220: -- The Admission Calendar must be a child of the Academic Calendar.
221: -- This validation is enforced in the database via the foreign key EAP_CIR_FK.

Line 277: -- Description: Validate IGR_I_APPL.person_id has a current

273: p_person_id IN NUMBER ,
274: p_message_name OUT NOCOPY VARCHAR2)
275: RETURN BOOLEAN IS
276: BEGIN -- admp_val_eap_addr
277: -- Description: Validate IGR_I_APPL.person_id has a current
278: -- correspondence address.
279: DECLARE
280: v_ret_val BOOLEAN DEFAULT TRUE;
281: CURSOR c_pa_adt IS

Line 323: -- Description: Validate if IGR_I_APPL.enquiry_status maps to system

319: p_enquiry_status IN VARCHAR2 ,
320: p_message_name OUT NOCOPY VARCHAR2)
321: RETURN BOOLEAN IS
322: BEGIN -- admp_val_eap_reg
323: -- Description: Validate if IGR_I_APPL.enquiry_status maps to system
324: -- status of 'REGISTERED' when inserting a new enquiry.
325: DECLARE
326: v_es_rec VARCHAR2(1);
327: CURSOR c_es IS

Line 370: -- Validate IGR_I_APPL.enquiry_status

366: p_new_enquiry_status IN VARCHAR2 ,
367: p_message_name OUT NOCOPY VARCHAR2)
368: RETURN BOOLEAN IS
369: BEGIN -- admp_val_eap_status
370: -- Validate IGR_I_APPL.enquiry_status
371: -- * Cannot be set to a system status of COMPLETE if child
372: -- IGR_I_A_PKGITM_V exists with mailed_dt set to NULL
373: -- * Cannot be set to a system status of REGISTERED from a
374: -- system status of ACKNOWLEGE or COMPLETE

Line 384: CURSOR c_es (cp_enquiry_status IGR_I_APPL.enquiry_status%TYPE) IS

380: v_eapmpi_found VARCHAR2(1) DEFAULT NULL;
381: cst_complete CONSTANT VARCHAR2(15) := 'OSS_COMPLETE';
382: cst_acknowlege CONSTANT VARCHAR2(15) := 'OSS_ACKNOWLEGE';
383: cst_registered CONSTANT VARCHAR2(15) := 'OSS_REGISTERED';
384: CURSOR c_es (cp_enquiry_status IGR_I_APPL.enquiry_status%TYPE) IS
385: SELECT es.s_enquiry_status
386: FROM IGR_I_STATUS_V es
387: WHERE es.enquiry_status = cp_enquiry_status;
388: CURSOR c_eapmpi IS

Line 465: -- Validate if IGR_I_APPL.enquiiry_status maps to a system status of

461: p_enquiry_appl_number IN NUMBER ,
462: p_message_name OUT NOCOPY VARCHAR2)
463: RETURN BOOLEAN IS
464: BEGIN -- admp_val_eap_comp
465: -- Validate if IGR_I_APPL.enquiiry_status maps to a system status of
466: -- 'COMPLETE'.
467: DECLARE
468: v_eap_complete VARCHAR2(1);
469: CURSOR c_eap IS

Line 471: FROM IGR_I_APPL eap

467: DECLARE
468: v_eap_complete VARCHAR2(1);
469: CURSOR c_eap IS
470: SELECT 'X'
471: FROM IGR_I_APPL eap
472: WHERE eap.person_id = p_person_id AND
473: eap.enquiry_appl_number = p_enquiry_appl_number AND
474: eap.s_enquiry_status NOT IN ('OSS_REGISTERED','OSS_ACKNOWLEGE');
475: BEGIN

Line 521: BEGIN -- Validate that IGR_I_APPL.indicated_mailing_dt

517: p_indicated_mailing_dt IN DATE ,
518: p_message_name OUT NOCOPY VARCHAR2)
519: RETURN BOOLEAN IS
520: gv_other_detail VARCHAR2(255);
521: BEGIN -- Validate that IGR_I_APPL.indicated_mailing_dt
522: -- is greater than the enquiry_dt.
523: DECLARE
524: BEGIN
525: p_message_name := null;