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

Line 1087: ayedubat 25-MAY-2002 Changed the cursor,c_acaiv to replace the view,IGS_AD_PS_APPL_INST_APLINST_V

1083: p_load_ci_seq_num IN NUMBER)
1084: AS
1085: /* HISTORY
1086: WHO WHEN WHAT
1087: ayedubat 25-MAY-2002 Changed the cursor,c_acaiv to replace the view,IGS_AD_PS_APPL_INST_APLINST_V
1088: with the base table,IGS_AD_PS_APPL_INST and also replaced the function calls
1089: Igs_En_Gen_002.enrp_get_acai_offer and Igs_En_Gen_014.ENRS_GET_WITHIN_CI as aprt of the bug fix: 2384449
1090: Nishikant 11JUN2002 Bug#2392277. The cursor c_sca modified to add a condition to check whether any of the unit code parameter is provided or not.
1091: If provided then the pre enrollment process will consider all the unit code(s) provided for the persons

Line 1088: with the base table,IGS_AD_PS_APPL_INST and also replaced the function calls

1084: AS
1085: /* HISTORY
1086: WHO WHEN WHAT
1087: ayedubat 25-MAY-2002 Changed the cursor,c_acaiv to replace the view,IGS_AD_PS_APPL_INST_APLINST_V
1088: with the base table,IGS_AD_PS_APPL_INST and also replaced the function calls
1089: Igs_En_Gen_002.enrp_get_acai_offer and Igs_En_Gen_014.ENRS_GET_WITHIN_CI as aprt of the bug fix: 2384449
1090: Nishikant 11JUN2002 Bug#2392277. The cursor c_sca modified to add a condition to check whether any of the unit code parameter is provided or not.
1091: If provided then the pre enrollment process will consider all the unit code(s) provided for the persons
1092: evenif they have already enrolled into any unit in the provided enrollment period.

Line 1111: -- * Loop through IGS_AD_PS_APPL_INST_APLINST_V records matching the academic period

1107: -- ?batch? mode as specified by the parameters passed to it.
1108: -- The routine will process both new and returning students,
1109: -- with the logic being the following:
1110: -- New Students:
1111: -- * Loop through IGS_AD_PS_APPL_INST_APLINST_V records matching the academic period
1112: -- and the specified IGS_PS_COURSE offering option parameters (eg. IGS_PS_COURSE code,
1113: -- IGS_AD_LOCATION, etc).
1114: -- * Call the ENRP_INS_SNEW_PRENRL routine to perform the pre-enrolment on each
1115: -- student.

Line 1292: FROM IGS_AD_PS_APPL_INST acai,

1288: acai.course_cd,
1289: acai.admission_appl_number,
1290: acai.nominated_course_cd,
1291: acai.sequence_number
1292: FROM IGS_AD_PS_APPL_INST acai,
1293: IGS_AD_APPL aa,
1294: IGS_PS_VER crv,
1295: IGS_PS_STAT cs
1296: WHERE

Line 1420: v_person_id IGS_AD_PS_APPL_INST.person_id%TYPE;

1416: AND cal.closed_ind = 'N'
1417: ORDER BY ci.start_dt;
1418:
1419: v_eci_rec c_eci%ROWTYPE;
1420: v_person_id IGS_AD_PS_APPL_INST.person_id%TYPE;
1421: v_course_cd IGS_AD_PS_APPL_INST.course_cd%TYPE;
1422: v_log_creation_dt DATE ;
1423: v_log_error_ind VARCHAR2(1) := 'N';
1424: v_warn_level VARCHAR2(10) := NULL;

Line 1421: v_course_cd IGS_AD_PS_APPL_INST.course_cd%TYPE;

1417: ORDER BY ci.start_dt;
1418:
1419: v_eci_rec c_eci%ROWTYPE;
1420: v_person_id IGS_AD_PS_APPL_INST.person_id%TYPE;
1421: v_course_cd IGS_AD_PS_APPL_INST.course_cd%TYPE;
1422: v_log_creation_dt DATE ;
1423: v_log_error_ind VARCHAR2(1) := 'N';
1424: v_warn_level VARCHAR2(10) := NULL;
1425: v_message_name Varchar2(2000) := NULL;