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_GET_SCAEH_DTL dependencies on IGS_EN_STDNT_PS_ATT

Line 20: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

16: DECLARE
17: -- cursor to get the current student course attempt status
18: CURSOR c_sca (
19: cp_column_name user_tab_columns.column_name%TYPE,
20: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
21: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
22: SELECT /*+ ROWID(IGS_EN_STDNT_PS_ATT) */
23: course_attempt_status,
24: commencement_dt,

Line 21: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS

17: -- cursor to get the current student course attempt status
18: CURSOR c_sca (
19: cp_column_name user_tab_columns.column_name%TYPE,
20: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
21: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
22: SELECT /*+ ROWID(IGS_EN_STDNT_PS_ATT) */
23: course_attempt_status,
24: commencement_dt,
25: DECODE(cp_column_name, 'VERSION_NUMBER', TO_CHAR(version_number),

Line 22: SELECT /+ ROWID(IGS_EN_STDNT_PS_ATT) /

18: CURSOR c_sca (
19: cp_column_name user_tab_columns.column_name%TYPE,
20: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
21: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
22: SELECT /*+ ROWID(IGS_EN_STDNT_PS_ATT) */
23: course_attempt_status,
24: commencement_dt,
25: DECODE(cp_column_name, 'VERSION_NUMBER', TO_CHAR(version_number),
26: 'CAL_TYPE', cal_type,

Line 56: FROM IGS_EN_STDNT_PS_ATT

52: 'CORRESPONDENCE_CAT', correspondence_cat,
53: 'SELF_HELP_GROUP_IND', self_help_group_ind,
54: 'PRIMARY_PROGRAM_TYPE', primary_program_type, --Bug 2162747 by vvutukur
55: 'KEY_PROGRAM', key_program) --Bug 2162747 by vvutukur
56: FROM IGS_EN_STDNT_PS_ATT
57: WHERE person_id = cp_person_id AND
58: course_cd = cp_course_cd;
59: -- cursor to get the last enrolled history
60: CURSOR c_last_e_scah (

Line 105: v_current_cas IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;

101: course_attempt_status = 'ENROLLED'
102: ORDER BY hist_start_dt DESC;
103: v_last_hist_start_dt IGS_AS_SC_ATTEMPT_H.hist_start_dt%TYPE;
104: v_last_hist_end_dt IGS_AS_SC_ATTEMPT_H.hist_end_dt%TYPE;
105: v_current_cas IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
106: v_current_c_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
107: v_current_col_value VARCHAR2(2000);
108: v_hist_col_value VARCHAR2(2000);
109: BEGIN

Line 106: v_current_c_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;

102: ORDER BY hist_start_dt DESC;
103: v_last_hist_start_dt IGS_AS_SC_ATTEMPT_H.hist_start_dt%TYPE;
104: v_last_hist_end_dt IGS_AS_SC_ATTEMPT_H.hist_end_dt%TYPE;
105: v_current_cas IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
106: v_current_c_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
107: v_current_col_value VARCHAR2(2000);
108: v_hist_col_value VARCHAR2(2000);
109: BEGIN
110: -- get the current course attempt status

Line 239: SELECT /+ ROWID(IGS_EN_STDNT_PS_ATT) /

235: -- cursor to get the current student course attempt status
236: CURSOR c_sca (
237: cp_person_id IGS_AS_SC_ATTEMPT_H.person_id%TYPE,
238: cp_course_cd IGS_AS_SC_ATTEMPT_H.course_cd%TYPE) IS
239: SELECT /*+ ROWID(IGS_EN_STDNT_PS_ATT) */
240: course_attempt_status,
241: commencement_dt,
242: discontinued_dt
243: FROM IGS_EN_STDNT_PS_ATT

Line 243: FROM IGS_EN_STDNT_PS_ATT

239: SELECT /*+ ROWID(IGS_EN_STDNT_PS_ATT) */
240: course_attempt_status,
241: commencement_dt,
242: discontinued_dt
243: FROM IGS_EN_STDNT_PS_ATT
244: WHERE person_id = cp_person_id AND
245: course_cd = cp_course_cd;
246: -- cursor to get the last enrolled history
247: CURSOR c_last_e_scah (

Line 255: v_current_cas IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;

251: FROM IGS_AS_SC_ATTEMPT_H
252: WHERE person_id = cp_person_id AND
253: course_cd = cp_course_cd AND
254: course_attempt_status = 'ENROLLED';
255: v_current_cas IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
256: v_current_c_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
257: v_current_d_dt IGS_EN_STDNT_PS_ATT.discontinued_dt%TYPE;
258: v_last_hist_end_dt IGS_AS_SC_ATTEMPT_H.hist_end_dt%TYPE;
259: BEGIN -- enrp_get_scaeh_eff_end

Line 256: v_current_c_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;

252: WHERE person_id = cp_person_id AND
253: course_cd = cp_course_cd AND
254: course_attempt_status = 'ENROLLED';
255: v_current_cas IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
256: v_current_c_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
257: v_current_d_dt IGS_EN_STDNT_PS_ATT.discontinued_dt%TYPE;
258: v_last_hist_end_dt IGS_AS_SC_ATTEMPT_H.hist_end_dt%TYPE;
259: BEGIN -- enrp_get_scaeh_eff_end
260: -- get the current course attempt status

Line 257: v_current_d_dt IGS_EN_STDNT_PS_ATT.discontinued_dt%TYPE;

253: course_cd = cp_course_cd AND
254: course_attempt_status = 'ENROLLED';
255: v_current_cas IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
256: v_current_c_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
257: v_current_d_dt IGS_EN_STDNT_PS_ATT.discontinued_dt%TYPE;
258: v_last_hist_end_dt IGS_AS_SC_ATTEMPT_H.hist_end_dt%TYPE;
259: BEGIN -- enrp_get_scaeh_eff_end
260: -- get the current course attempt status
261: OPEN c_sca( p_person_id,

Line 352: SELECT /+ ROWID(IGS_EN_STDNT_PS_ATT) /

348: -- cursor to get the current student course attempt status
349: CURSOR c_sca (
350: cp_person_id IGS_AS_SC_ATTEMPT_H.person_id%TYPE,
351: cp_course_cd IGS_AS_SC_ATTEMPT_H.course_cd%TYPE) IS
352: SELECT /*+ ROWID(IGS_EN_STDNT_PS_ATT) */
353: course_attempt_status,
354: commencement_dt,
355: discontinued_dt
356: FROM IGS_EN_STDNT_PS_ATT

Line 356: FROM IGS_EN_STDNT_PS_ATT

352: SELECT /*+ ROWID(IGS_EN_STDNT_PS_ATT) */
353: course_attempt_status,
354: commencement_dt,
355: discontinued_dt
356: FROM IGS_EN_STDNT_PS_ATT
357: WHERE person_id = cp_person_id AND
358: course_cd = cp_course_cd;
359: CURSOR c_last_e_scah (
360: cp_person_id IGS_AS_SC_ATTEMPT_H.person_id%TYPE,

Line 368: v_current_cas IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;

364: WHERE person_id = cp_person_id AND
365: course_cd = cp_course_cd AND
366: course_attempt_status = 'ENROLLED';
367: v_last_hist_start_dt IGS_AS_SC_ATTEMPT_H.hist_start_dt%TYPE;
368: v_current_cas IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
369: v_current_c_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
370: v_current_d_dt IGS_EN_STDNT_PS_ATT.discontinued_dt%TYPE;
371: BEGIN -- enrp_get_scaeh_eff_st
372: -- get the current course attempt status

Line 369: v_current_c_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;

365: course_cd = cp_course_cd AND
366: course_attempt_status = 'ENROLLED';
367: v_last_hist_start_dt IGS_AS_SC_ATTEMPT_H.hist_start_dt%TYPE;
368: v_current_cas IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
369: v_current_c_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
370: v_current_d_dt IGS_EN_STDNT_PS_ATT.discontinued_dt%TYPE;
371: BEGIN -- enrp_get_scaeh_eff_st
372: -- get the current course attempt status
373: OPEN c_sca( p_person_id,

Line 370: v_current_d_dt IGS_EN_STDNT_PS_ATT.discontinued_dt%TYPE;

366: course_attempt_status = 'ENROLLED';
367: v_last_hist_start_dt IGS_AS_SC_ATTEMPT_H.hist_start_dt%TYPE;
368: v_current_cas IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
369: v_current_c_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
370: v_current_d_dt IGS_EN_STDNT_PS_ATT.discontinued_dt%TYPE;
371: BEGIN -- enrp_get_scaeh_eff_st
372: -- get the current course attempt status
373: OPEN c_sca( p_person_id,
374: p_course_cd);