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_AS_SC_ATMPT_ENR

Line 342: -- * Create a IGS_AS_SC_ATMPT_ENR record

338: -- IGS_PS_COURSE. The following steps will be performed :
339: -- * Check the students eligibility to enrol in the specified IGS_PS_COURSE
340: -- in the specified academic calendar.
341: -- * Create a IGS_EN_STDNT_PS_ATT record
342: -- * Create a IGS_AS_SC_ATMPT_ENR record
343: -- * Create any required IGS_AS_SU_SETATMPT details
344: -- * Create default IGS_EN_STDNTPSHECSOP details
345: -- * Pre-enrol IGS_PS_UNIT attempts entered during Admissions, as parameter
346: -- to the process or through the Pattern of Study.

Line 1919: -- Create a IGS_AS_SC_ATMPT_ENR record

1915: RETURN BOOLEAN
1916: AS
1917:
1918: BEGIN -- enrpl_create_scae
1919: -- Create a IGS_AS_SC_ATMPT_ENR record
1920: DECLARE
1921: CURSOR c_scae (
1922: cp_enr_cal_type IGS_AS_SC_ATMPT_ENR.cal_type%TYPE,
1923: cp_enr_sequence_number IGS_AS_SC_ATMPT_ENR.ci_sequence_number%TYPE) IS

Line 1922: cp_enr_cal_type IGS_AS_SC_ATMPT_ENR.cal_type%TYPE,

1918: BEGIN -- enrpl_create_scae
1919: -- Create a IGS_AS_SC_ATMPT_ENR record
1920: DECLARE
1921: CURSOR c_scae (
1922: cp_enr_cal_type IGS_AS_SC_ATMPT_ENR.cal_type%TYPE,
1923: cp_enr_sequence_number IGS_AS_SC_ATMPT_ENR.ci_sequence_number%TYPE) IS
1924: SELECT enrolment_cat
1925: FROM IGS_AS_SC_ATMPT_ENR scae
1926: WHERE person_id = p_person_id AND

Line 1923: cp_enr_sequence_number IGS_AS_SC_ATMPT_ENR.ci_sequence_number%TYPE) IS

1919: -- Create a IGS_AS_SC_ATMPT_ENR record
1920: DECLARE
1921: CURSOR c_scae (
1922: cp_enr_cal_type IGS_AS_SC_ATMPT_ENR.cal_type%TYPE,
1923: cp_enr_sequence_number IGS_AS_SC_ATMPT_ENR.ci_sequence_number%TYPE) IS
1924: SELECT enrolment_cat
1925: FROM IGS_AS_SC_ATMPT_ENR scae
1926: WHERE person_id = p_person_id AND
1927: course_cd = p_course_cd AND

Line 1925: FROM IGS_AS_SC_ATMPT_ENR scae

1921: CURSOR c_scae (
1922: cp_enr_cal_type IGS_AS_SC_ATMPT_ENR.cal_type%TYPE,
1923: cp_enr_sequence_number IGS_AS_SC_ATMPT_ENR.ci_sequence_number%TYPE) IS
1924: SELECT enrolment_cat
1925: FROM IGS_AS_SC_ATMPT_ENR scae
1926: WHERE person_id = p_person_id AND
1927: course_cd = p_course_cd AND
1928: cal_type = cp_enr_cal_type AND
1929: ci_sequence_number = cp_enr_sequence_number;

Line 1933: cp_enr_cal_type IGS_AS_SC_ATMPT_ENR.cal_type%TYPE,

1929: ci_sequence_number = cp_enr_sequence_number;
1930: v_scae_rec c_scae%ROWTYPE;
1931:
1932: CURSOR c_scae_upd (
1933: cp_enr_cal_type IGS_AS_SC_ATMPT_ENR.cal_type%TYPE,
1934: cp_enr_sequence_number IGS_AS_SC_ATMPT_ENR.ci_sequence_number%TYPE) IS
1935: SELECT rowid,
1936: IGS_AS_SC_ATMPT_ENR.*
1937: FROM IGS_AS_SC_ATMPT_ENR

Line 1934: cp_enr_sequence_number IGS_AS_SC_ATMPT_ENR.ci_sequence_number%TYPE) IS

1930: v_scae_rec c_scae%ROWTYPE;
1931:
1932: CURSOR c_scae_upd (
1933: cp_enr_cal_type IGS_AS_SC_ATMPT_ENR.cal_type%TYPE,
1934: cp_enr_sequence_number IGS_AS_SC_ATMPT_ENR.ci_sequence_number%TYPE) IS
1935: SELECT rowid,
1936: IGS_AS_SC_ATMPT_ENR.*
1937: FROM IGS_AS_SC_ATMPT_ENR
1938: WHERE person_id = p_person_id AND

Line 1936: IGS_AS_SC_ATMPT_ENR.*

1932: CURSOR c_scae_upd (
1933: cp_enr_cal_type IGS_AS_SC_ATMPT_ENR.cal_type%TYPE,
1934: cp_enr_sequence_number IGS_AS_SC_ATMPT_ENR.ci_sequence_number%TYPE) IS
1935: SELECT rowid,
1936: IGS_AS_SC_ATMPT_ENR.*
1937: FROM IGS_AS_SC_ATMPT_ENR
1938: WHERE person_id = p_person_id AND
1939: course_cd = p_course_cd AND
1940: cal_type = cp_enr_cal_type AND

Line 1937: FROM IGS_AS_SC_ATMPT_ENR

1933: cp_enr_cal_type IGS_AS_SC_ATMPT_ENR.cal_type%TYPE,
1934: cp_enr_sequence_number IGS_AS_SC_ATMPT_ENR.ci_sequence_number%TYPE) IS
1935: SELECT rowid,
1936: IGS_AS_SC_ATMPT_ENR.*
1937: FROM IGS_AS_SC_ATMPT_ENR
1938: WHERE person_id = p_person_id AND
1939: course_cd = p_course_cd AND
1940: cal_type = cp_enr_cal_type AND
1941: ci_sequence_number = cp_enr_sequence_number

Line 2017: IGS_AS_SC_ATMPT_ENR_PKG.INSERT_ROW (

2013:
2014: DECLARE
2015: l_rowid VARCHAR2(25);
2016: BEGIN
2017: IGS_AS_SC_ATMPT_ENR_PKG.INSERT_ROW (
2018: x_rowid => l_rowid,
2019: x_person_id => p_person_id,
2020: x_course_cd => p_course_cd,
2021: x_cal_type => v_enr_cal_type,

Line 2041: IGS_AS_SC_ATMPT_ENR_PKG.UPDATE_ROW(

2037: v_enr_cal_type,
2038: v_enr_sequence_number);
2039: FETCH c_scae_upd INTO v_scae_upd_rec;
2040:
2041: IGS_AS_SC_ATMPT_ENR_PKG.UPDATE_ROW(
2042: X_ROWID => v_scae_upd_rec.rowid,
2043: X_PERSON_ID => v_scae_upd_rec.PERSON_ID,
2044: X_COURSE_CD => v_scae_upd_rec.COURSE_CD,
2045: X_CAL_TYPE => v_scae_upd_rec.CAL_TYPE,

Line 3469: -- create or update IGS_AS_SC_ATMPT_ENR record

3465: p_message_name := v_message_name;
3466: RETURN FALSE;
3467: END IF;
3468:
3469: -- create or update IGS_AS_SC_ATMPT_ENR record
3470: IF NOT enrpl_create_scae(
3471: v_warn_level,
3472: v_message_name) THEN
3473: p_warn_level := v_warn_level;

Line 4086: -- * Create IGS_AS_SC_ATMPT_ENR record.

4082: -- * Check the students eligibility to enrol in the specified IGS_PS_COURSE in the
4083: -- specified academic calendar.
4084: -- * Determine the enrolment category from either a previous pre-enrolment
4085: -- or the default enrolment category passed to the routine.
4086: -- * Create IGS_AS_SC_ATMPT_ENR record.
4087: -- * Pre-enrol the students IGS_EN_SU_ATTEMPT records (next phase)
4088: -- If at any point it becomes impossible to pre-enrol the student, the
4089: -- routine will return FALSE and message number of a message indicating the
4090: -- reason for failure. This can be used by the calling routine (whether batch

Line 4123: FROM IGS_AS_SC_ATMPT_ENR scae,

4119: v_sca_rec c_sca_details%ROWTYPE;
4120:
4121: CURSOR c_prev_enr_cat IS
4122: SELECT scae.enrolment_cat
4123: FROM IGS_AS_SC_ATMPT_ENR scae,
4124: IGS_CA_INST ci
4125: WHERE scae.person_id = p_person_id AND
4126: scae.course_cd = p_course_cd AND
4127: ci.cal_type = scae.cal_type AND

Line 4133: FROM IGS_AS_SC_ATMPT_ENR scae

4129: ORDER BY ci.end_dt DESC;
4130:
4131: CURSOR c_scae_details IS
4132: SELECT enrolment_cat
4133: FROM IGS_AS_SC_ATMPT_ENR scae
4134: WHERE scae.person_id = p_person_id AND
4135: scae.course_cd = p_course_cd AND
4136: scae.cal_type = p_enrol_cal_type AND
4137: scae.ci_sequence_number = p_enrol_sequence_number;

Line 4141: v_scae_details IGS_AS_SC_ATMPT_ENR.enrolment_cat%TYPE;

4137: scae.ci_sequence_number = p_enrol_sequence_number;
4138: --v_scae_details VARCHAR2(1);
4139:
4140:
4141: v_scae_details IGS_AS_SC_ATMPT_ENR.enrolment_cat%TYPE;
4142: CURSOR c_scae_upd IS
4143: SELECT rowid,
4144: IGS_AS_SC_ATMPT_ENR.*
4145: FROM IGS_AS_SC_ATMPT_ENR

Line 4144: IGS_AS_SC_ATMPT_ENR.*

4140:
4141: v_scae_details IGS_AS_SC_ATMPT_ENR.enrolment_cat%TYPE;
4142: CURSOR c_scae_upd IS
4143: SELECT rowid,
4144: IGS_AS_SC_ATMPT_ENR.*
4145: FROM IGS_AS_SC_ATMPT_ENR
4146: WHERE person_id = p_person_id AND
4147: course_cd = p_course_cd AND
4148: cal_type = p_enrol_cal_type AND

Line 4145: FROM IGS_AS_SC_ATMPT_ENR

4141: v_scae_details IGS_AS_SC_ATMPT_ENR.enrolment_cat%TYPE;
4142: CURSOR c_scae_upd IS
4143: SELECT rowid,
4144: IGS_AS_SC_ATMPT_ENR.*
4145: FROM IGS_AS_SC_ATMPT_ENR
4146: WHERE person_id = p_person_id AND
4147: course_cd = p_course_cd AND
4148: cal_type = p_enrol_cal_type AND
4149: ci_sequence_number = p_enrol_sequence_number

Line 4964: IGS_AS_SC_ATMPT_ENR_PKG.UPDATE_ROW(

4960:
4961: OPEN c_scae_upd;
4962: FETCH c_scae_upd INTO v_scae_upd_rec;
4963:
4964: IGS_AS_SC_ATMPT_ENR_PKG.UPDATE_ROW(
4965: X_ROWID => v_scae_upd_rec.rowid,
4966: X_PERSON_ID => v_scae_upd_rec.PERSON_ID,
4967: X_COURSE_CD => v_scae_upd_rec.COURSE_CD,
4968: X_CAL_TYPE => v_scae_upd_rec.CAL_TYPE,

Line 5026: IGS_AS_SC_ATMPT_ENR_PKG.INSERT_ROW (

5022: DECLARE
5023: l_rowid VARCHAR2(25);
5024: BEGIN
5025:
5026: IGS_AS_SC_ATMPT_ENR_PKG.INSERT_ROW (
5027: x_rowid => l_rowid,
5028: x_person_id => p_person_id,
5029: x_course_cd => p_course_cd,
5030: x_cal_type => p_enrol_cal_type,