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_EN_GEN_010 dependencies on IGS_AD_PS_APPL_INST

Line 317: ayedubat 25-MAY-2002 Changed the cursors c_acaiv and c_acaiv1 to replace the view,IGS_AD_PS_APPL_INST_APLINST_V

313: knag 29-OCT-2002 Bug 2647482 addded parameters attendance_mode, location_cd for calculation
314: of proposed completion date by procedure igs_ad_gen_004.admp_get_crv_comp_dt
315: ayedubat 4-JUN-2002 Changed the Code of YOP for default Unit Set pre-enrollment before
316: the Units pre-enrollment Code for the bug fix: 2391842
317: ayedubat 25-MAY-2002 Changed the cursors c_acaiv and c_acaiv1 to replace the view,IGS_AD_PS_APPL_INST_APLINST_V
318: with the base table,IGS_AD_PS_APPL_INST as part of the bug fix:2384449
319: ayedubat 21-MAY-2002 Modified the cursor,c_first_us to select always the Unit Set with mapping
320: sequence number of '1' as part of the bug fix:2348709
321: ayedubat 15-MAY-2002 Changed the cursor,c_chk_census_dt to consider only the SUA records with

Line 318: with the base table,IGS_AD_PS_APPL_INST as part of the bug fix:2384449

314: of proposed completion date by procedure igs_ad_gen_004.admp_get_crv_comp_dt
315: ayedubat 4-JUN-2002 Changed the Code of YOP for default Unit Set pre-enrollment before
316: the Units pre-enrollment Code for the bug fix: 2391842
317: ayedubat 25-MAY-2002 Changed the cursors c_acaiv and c_acaiv1 to replace the view,IGS_AD_PS_APPL_INST_APLINST_V
318: with the base table,IGS_AD_PS_APPL_INST as part of the bug fix:2384449
319: ayedubat 21-MAY-2002 Modified the cursor,c_first_us to select always the Unit Set with mapping
320: sequence number of '1' as part of the bug fix:2348709
321: ayedubat 15-MAY-2002 Changed the cursor,c_chk_census_dt to consider only the SUA records with
322: unit attempt status 'ENROLLED','DISCONTIN','DUPLICATE' or 'COMPLETED' and

Line 411: FROM IGS_AD_PS_APPL_INST acaiv,

407: acaiv.actual_response_dt,
408: acaiv.expected_completion_yr,
409: acaiv.expected_completion_perd,
410: acaiv.offer_dt
411: FROM IGS_AD_PS_APPL_INST acaiv,
412: IGS_AD_APPL aa,
413: IGS_AD_OU_STAT aos,
414: IGS_AD_OFR_RESP_STAT aors
415: WHERE

Line 460: FROM IGS_AD_PS_APPL_INST acaiv,

456: acaiv.actual_response_dt,
457: acaiv.expected_completion_yr,
458: acaiv.expected_completion_perd,
459: acaiv.offer_dt
460: FROM IGS_AD_PS_APPL_INST acaiv,
461: IGS_AD_APPL aa,
462: IGS_AD_OU_STAT aos,
463: IGS_AD_OFR_RESP_STAT aors
464: WHERE acaiv.person_id = p_person_id AND

Line 4067: ayedubat 25-MAY-2002 Changed the cursors c_acaiv to replace the view,IGS_AD_PS_APPL_INST_APLINST_V

4063: end dates for any two unit sets by calling check_usa_overlap.If it returns
4064: false log entry is made and the insert or update is not carried out for bug 3149133.
4065: ayedubat 4-JUN-2002 Changed the Code of YOP for Unit Set pre-enrollment before
4066: the Units pre-enrollment Code for the bug fix: 2391842
4067: ayedubat 25-MAY-2002 Changed the cursors c_acaiv to replace the view,IGS_AD_PS_APPL_INST_APLINST_V
4068: with the base table,IGS_AD_PS_APPL_INST as part of the bug fix:2384449
4069: ayedubat 15-MAY-2002 Changed the cursor,c_chk_census_dt to consider only the SUA records with unit attempt status
4070: 'ENROLLED','DISCONTIN','DUPLICATE' or 'COMPLETED' as part of the bug:2372892
4071: Nishikant 07OCT2002 UK Enhancement Build - Enh Bug#2580731 - Added the parameter p_selection_date in this Function

Line 4068: with the base table,IGS_AD_PS_APPL_INST as part of the bug fix:2384449

4064: false log entry is made and the insert or update is not carried out for bug 3149133.
4065: ayedubat 4-JUN-2002 Changed the Code of YOP for Unit Set pre-enrollment before
4066: the Units pre-enrollment Code for the bug fix: 2391842
4067: ayedubat 25-MAY-2002 Changed the cursors c_acaiv to replace the view,IGS_AD_PS_APPL_INST_APLINST_V
4068: with the base table,IGS_AD_PS_APPL_INST as part of the bug fix:2384449
4069: ayedubat 15-MAY-2002 Changed the cursor,c_chk_census_dt to consider only the SUA records with unit attempt status
4070: 'ENROLLED','DISCONTIN','DUPLICATE' or 'COMPLETED' as part of the bug:2372892
4071: Nishikant 07OCT2002 UK Enhancement Build - Enh Bug#2580731 - Added the parameter p_selection_date in this Function
4072: Nishikant 16DEC2002 ENCR030(UK Enh) Build - Enh Bug#2708430 - Added the parameter p_completion_date in this Function

Line 4190: FROM IGS_AD_PS_APPL_INST acaiv,

4186: cp_adm_sequence_number IGS_EN_STDNT_PS_ATT.adm_sequence_number%TYPE ) IS
4187: SELECT acaiv.unit_set_cd,
4188: acaiv.adm_cal_type,
4189: aa.admission_cat
4190: FROM IGS_AD_PS_APPL_INST acaiv,
4191: IGS_AD_APPL aa
4192: WHERE
4193: acaiv.person_id = p_person_id AND
4194: acaiv.admission_appl_number = cp_adm_admission_appl_number AND

Line 4212: v_unit_set_cd IGS_AD_PS_APPL_INST_APLINST_V.unit_set_cd%TYPE;

4208: susa.end_dt IS NULL;
4209: v_susa_rec c_susa%ROWTYPE;
4210: v_enrolment_cat IGS_EN_ENROLMENT_CAT.enrolment_cat%TYPE;
4211: v_enr_cat IGS_EN_ENROLMENT_CAT.enrolment_cat%TYPE;
4212: v_unit_set_cd IGS_AD_PS_APPL_INST_APLINST_V.unit_set_cd%TYPE;
4213: v_adm_cal_type IGS_AD_PS_APPL_INST_APLINST_V.adm_cal_type%TYPE;
4214: v_admission_cat IGS_AD_APPL.admission_cat%TYPE;
4215: v_warn_level VARCHAR2(10) ;
4216: v_log_creation_dt DATE;

Line 4213: v_adm_cal_type IGS_AD_PS_APPL_INST_APLINST_V.adm_cal_type%TYPE;

4209: v_susa_rec c_susa%ROWTYPE;
4210: v_enrolment_cat IGS_EN_ENROLMENT_CAT.enrolment_cat%TYPE;
4211: v_enr_cat IGS_EN_ENROLMENT_CAT.enrolment_cat%TYPE;
4212: v_unit_set_cd IGS_AD_PS_APPL_INST_APLINST_V.unit_set_cd%TYPE;
4213: v_adm_cal_type IGS_AD_PS_APPL_INST_APLINST_V.adm_cal_type%TYPE;
4214: v_admission_cat IGS_AD_APPL.admission_cat%TYPE;
4215: v_warn_level VARCHAR2(10) ;
4216: v_log_creation_dt DATE;
4217: v_message_name VARCHAR2(2000);