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_SCI dependencies on IGS_EN_STDNT_PS_INTM

Line 25: cp_person_id IGS_EN_STDNT_PS_INTM.person_id%TYPE,

21: SELECT census_dt_alias
22: FROM IGS_GE_S_GEN_CAL_CON
23: WHERE s_control_num = 1;
24: CURSOR c_sua_details(
25: cp_person_id IGS_EN_STDNT_PS_INTM.person_id%TYPE,
26: cp_course_cd IGS_EN_STDNT_PS_INTM.course_cd%TYPE) IS
27: SELECT cal_type,
28: ci_sequence_number
29: FROM IGS_EN_SU_ATTEMPT

Line 26: cp_course_cd IGS_EN_STDNT_PS_INTM.course_cd%TYPE) IS

22: FROM IGS_GE_S_GEN_CAL_CON
23: WHERE s_control_num = 1;
24: CURSOR c_sua_details(
25: cp_person_id IGS_EN_STDNT_PS_INTM.person_id%TYPE,
26: cp_course_cd IGS_EN_STDNT_PS_INTM.course_cd%TYPE) IS
27: SELECT cal_type,
28: ci_sequence_number
29: FROM IGS_EN_SU_ATTEMPT
30: WHERE person_id = cp_person_id AND

Line 316: v_sci_rec IGS_EN_STDNT_PS_INTM%ROWTYPE;

312: p_message_name OUT NOCOPY VARCHAR2)
313: RETURN boolean AS
314: BEGIN
315: DECLARE
316: v_sci_rec IGS_EN_STDNT_PS_INTM%ROWTYPE;
317: -- smaddali added the logical detele date check for EN306 - intermission updates build, bug#3889089 ,
318: -- check for other active records overlapping with the current record.
319: CURSOR c_sci(
320: cp_person_id IGS_EN_STDNT_PS_INTM.person_id%TYPE,

Line 320: cp_person_id IGS_EN_STDNT_PS_INTM.person_id%TYPE,

316: v_sci_rec IGS_EN_STDNT_PS_INTM%ROWTYPE;
317: -- smaddali added the logical detele date check for EN306 - intermission updates build, bug#3889089 ,
318: -- check for other active records overlapping with the current record.
319: CURSOR c_sci(
320: cp_person_id IGS_EN_STDNT_PS_INTM.person_id%TYPE,
321: cp_course_cd IGS_EN_STDNT_PS_INTM.course_cd%TYPE,
322: cp_start_dt IGS_EN_STDNT_PS_INTM.start_dt%TYPE) IS
323: SELECT start_dt,
324: end_dt

Line 321: cp_course_cd IGS_EN_STDNT_PS_INTM.course_cd%TYPE,

317: -- smaddali added the logical detele date check for EN306 - intermission updates build, bug#3889089 ,
318: -- check for other active records overlapping with the current record.
319: CURSOR c_sci(
320: cp_person_id IGS_EN_STDNT_PS_INTM.person_id%TYPE,
321: cp_course_cd IGS_EN_STDNT_PS_INTM.course_cd%TYPE,
322: cp_start_dt IGS_EN_STDNT_PS_INTM.start_dt%TYPE) IS
323: SELECT start_dt,
324: end_dt
325: FROM IGS_EN_STDNT_PS_INTM

Line 322: cp_start_dt IGS_EN_STDNT_PS_INTM.start_dt%TYPE) IS

318: -- check for other active records overlapping with the current record.
319: CURSOR c_sci(
320: cp_person_id IGS_EN_STDNT_PS_INTM.person_id%TYPE,
321: cp_course_cd IGS_EN_STDNT_PS_INTM.course_cd%TYPE,
322: cp_start_dt IGS_EN_STDNT_PS_INTM.start_dt%TYPE) IS
323: SELECT start_dt,
324: end_dt
325: FROM IGS_EN_STDNT_PS_INTM
326: WHERE person_id = cp_person_id AND

Line 325: FROM IGS_EN_STDNT_PS_INTM

321: cp_course_cd IGS_EN_STDNT_PS_INTM.course_cd%TYPE,
322: cp_start_dt IGS_EN_STDNT_PS_INTM.start_dt%TYPE) IS
323: SELECT start_dt,
324: end_dt
325: FROM IGS_EN_STDNT_PS_INTM
326: WHERE person_id = cp_person_id AND
327: course_cd = cp_course_cd AND
328: start_dt <> cp_start_dt AND
329: TRUNC(logical_delete_date) = to_date('31-12-4712','DD-MM-YYYY');