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_VAL_SCT dependencies on IGS_AS_SC_ATMPT_ENR

Line 32: -- current IGS_AS_SC_ATMPT_ENR is also a sub-ordinate of the

28: BEGIN -- enrp_val_scae_acad
29: -- When transferring a IGS_EN_STDNT_PS_ATT and the calendar
30: -- type of the IGS_PS_OFR_OPT varies from that of the
31: -- original course, validate that the enrolment period of the
32: -- current IGS_AS_SC_ATMPT_ENR is also a sub-ordinate of the
33: -- new calendar type.
34: DECLARE
35: v_ci_sequence_number IGS_AS_SC_ATMPT_ENR.ci_sequence_number%TYPE;
36: v_cal_type IGS_AS_SC_ATMPT_ENR.cal_type%TYPE;

Line 35: v_ci_sequence_number IGS_AS_SC_ATMPT_ENR.ci_sequence_number%TYPE;

31: -- original course, validate that the enrolment period of the
32: -- current IGS_AS_SC_ATMPT_ENR is also a sub-ordinate of the
33: -- new calendar type.
34: DECLARE
35: v_ci_sequence_number IGS_AS_SC_ATMPT_ENR.ci_sequence_number%TYPE;
36: v_cal_type IGS_AS_SC_ATMPT_ENR.cal_type%TYPE;
37: v_enrolment_cat IGS_AS_SC_ATMPT_ENR.enrolment_cat%TYPE;
38: v_ret BOOLEAN;
39: CURSOR c_scae_ci IS

Line 36: v_cal_type IGS_AS_SC_ATMPT_ENR.cal_type%TYPE;

32: -- current IGS_AS_SC_ATMPT_ENR is also a sub-ordinate of the
33: -- new calendar type.
34: DECLARE
35: v_ci_sequence_number IGS_AS_SC_ATMPT_ENR.ci_sequence_number%TYPE;
36: v_cal_type IGS_AS_SC_ATMPT_ENR.cal_type%TYPE;
37: v_enrolment_cat IGS_AS_SC_ATMPT_ENR.enrolment_cat%TYPE;
38: v_ret BOOLEAN;
39: CURSOR c_scae_ci IS
40: SELECT scae.cal_type,

Line 37: v_enrolment_cat IGS_AS_SC_ATMPT_ENR.enrolment_cat%TYPE;

33: -- new calendar type.
34: DECLARE
35: v_ci_sequence_number IGS_AS_SC_ATMPT_ENR.ci_sequence_number%TYPE;
36: v_cal_type IGS_AS_SC_ATMPT_ENR.cal_type%TYPE;
37: v_enrolment_cat IGS_AS_SC_ATMPT_ENR.enrolment_cat%TYPE;
38: v_ret BOOLEAN;
39: CURSOR c_scae_ci IS
40: SELECT scae.cal_type,
41: scae.ci_sequence_number,

Line 43: FROM IGS_AS_SC_ATMPT_ENR scae,

39: CURSOR c_scae_ci IS
40: SELECT scae.cal_type,
41: scae.ci_sequence_number,
42: scae.enrolment_cat
43: FROM IGS_AS_SC_ATMPT_ENR scae,
44: IGS_CA_INST ci
45: WHERE scae.person_id = p_person_id AND
46: scae.course_cd = p_course_cd AND
47: scae.cal_type = ci.cal_type AND