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_AS_SC_ATTEMPT_H

Line 9: p_person_id IN IGS_AS_SC_ATTEMPT_H_ALL.person_id%TYPE ,

5: -- Get student course attempt effective history column value
6: FUNCTION enrp_get_scaeh_col(
7: p_column_name IN VARCHAR2 ,
8: p_column_value IN VARCHAR2 ,
9: p_person_id IN IGS_AS_SC_ATTEMPT_H_ALL.person_id%TYPE ,
10: p_course_cd IGS_PS_COURSE.course_cd%TYPE ,
11: p_hist_start_dt IN DATE ,
12: p_course_attempt_status VARCHAR2 )
13: RETURN VARCHAR2 AS

Line 62: cp_person_id IGS_AS_SC_ATTEMPT_H.person_id%TYPE,

58: course_cd = cp_course_cd;
59: -- cursor to get the last enrolled history
60: CURSOR c_last_e_scah (
61: cp_column_name user_tab_columns.column_name%TYPE,
62: cp_person_id IGS_AS_SC_ATTEMPT_H.person_id%TYPE,
63: cp_course_cd IGS_AS_SC_ATTEMPT_H.course_cd%TYPE) IS
64: SELECT /*+ FIRST_ROWS */
65: hist_start_dt,
66: hist_end_dt,

Line 63: cp_course_cd IGS_AS_SC_ATTEMPT_H.course_cd%TYPE) IS

59: -- cursor to get the last enrolled history
60: CURSOR c_last_e_scah (
61: cp_column_name user_tab_columns.column_name%TYPE,
62: cp_person_id IGS_AS_SC_ATTEMPT_H.person_id%TYPE,
63: cp_course_cd IGS_AS_SC_ATTEMPT_H.course_cd%TYPE) IS
64: SELECT /*+ FIRST_ROWS */
65: hist_start_dt,
66: hist_end_dt,
67: DECODE(cp_column_name, 'VERSION_NUMBER', TO_CHAR(version_number),

Line 98: FROM IGS_AS_SC_ATTEMPT_H

94: 'CORRESPONDENCE_CAT', correspondence_cat,
95: 'SELF_HELP_GROUP_IND', self_help_group_ind,
96: 'PRIMARY_PROGRAM_TYPE', primary_program_type,
97: 'KEY_PROGRAM', key_program)
98: FROM IGS_AS_SC_ATTEMPT_H
99: WHERE person_id = cp_person_id AND
100: course_cd = cp_course_cd AND
101: course_attempt_status = 'ENROLLED'
102: ORDER BY hist_start_dt DESC;

Line 103: v_last_hist_start_dt IGS_AS_SC_ATTEMPT_H.hist_start_dt%TYPE;

99: WHERE person_id = cp_person_id AND
100: course_cd = cp_course_cd AND
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);

Line 104: v_last_hist_end_dt IGS_AS_SC_ATTEMPT_H.hist_end_dt%TYPE;

100: course_cd = cp_course_cd AND
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);

Line 227: p_person_id IN IGS_AS_SC_ATTEMPT_H_ALL.person_id%TYPE ,

223: END enrp_get_scaeh_col;
224: --
225: -- Routine to get the effective end date for a SCA history
226: FUNCTION enrp_get_scaeh_eff_end(
227: p_person_id IN IGS_AS_SC_ATTEMPT_H_ALL.person_id%TYPE ,
228: p_course_cd IN IGS_AS_SC_ATTEMPT_H_ALL.course_cd%TYPE ,
229: p_hist_end_dt IN DATE ,
230: p_course_attempt_status IN VARCHAR2 )
231: RETURN DATE AS

Line 228: p_course_cd IN IGS_AS_SC_ATTEMPT_H_ALL.course_cd%TYPE ,

224: --
225: -- Routine to get the effective end date for a SCA history
226: FUNCTION enrp_get_scaeh_eff_end(
227: p_person_id IN IGS_AS_SC_ATTEMPT_H_ALL.person_id%TYPE ,
228: p_course_cd IN IGS_AS_SC_ATTEMPT_H_ALL.course_cd%TYPE ,
229: p_hist_end_dt IN DATE ,
230: p_course_attempt_status IN VARCHAR2 )
231: RETURN DATE AS
232: gv_other_detail VARCHAR2(255);

Line 237: cp_person_id IGS_AS_SC_ATTEMPT_H.person_id%TYPE,

233: BEGIN
234: DECLARE
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,

Line 238: cp_course_cd IGS_AS_SC_ATTEMPT_H.course_cd%TYPE) IS

234: DECLARE
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

Line 248: cp_person_id IGS_AS_SC_ATTEMPT_H.person_id%TYPE,

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 (
248: cp_person_id IGS_AS_SC_ATTEMPT_H.person_id%TYPE,
249: cp_course_cd IGS_AS_SC_ATTEMPT_H.course_cd%TYPE) IS
250: SELECT MAX(hist_end_dt)
251: FROM IGS_AS_SC_ATTEMPT_H
252: WHERE person_id = cp_person_id AND

Line 249: cp_course_cd IGS_AS_SC_ATTEMPT_H.course_cd%TYPE) IS

245: course_cd = cp_course_cd;
246: -- cursor to get the last enrolled history
247: CURSOR c_last_e_scah (
248: cp_person_id IGS_AS_SC_ATTEMPT_H.person_id%TYPE,
249: cp_course_cd IGS_AS_SC_ATTEMPT_H.course_cd%TYPE) IS
250: SELECT MAX(hist_end_dt)
251: FROM IGS_AS_SC_ATTEMPT_H
252: WHERE person_id = cp_person_id AND
253: course_cd = cp_course_cd AND

Line 251: FROM IGS_AS_SC_ATTEMPT_H

247: CURSOR c_last_e_scah (
248: cp_person_id IGS_AS_SC_ATTEMPT_H.person_id%TYPE,
249: cp_course_cd IGS_AS_SC_ATTEMPT_H.course_cd%TYPE) IS
250: SELECT MAX(hist_end_dt)
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;

Line 258: v_last_hist_end_dt IGS_AS_SC_ATTEMPT_H.hist_end_dt%TYPE;

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,
262: p_course_cd);

Line 340: p_person_id IN IGS_AS_SC_ATTEMPT_H_ALL.person_id%TYPE ,

336: END enrp_get_scaeh_eff_end;
337: --
338: -- Routine to get the effective start date for a SCA history
339: FUNCTION enrp_get_scaeh_eff_st(
340: p_person_id IN IGS_AS_SC_ATTEMPT_H_ALL.person_id%TYPE ,
341: p_course_cd IN IGS_AS_SC_ATTEMPT_H_ALL.course_cd%TYPE ,
342: p_hist_start_dt IN DATE ,
343: p_course_attempt_status IN VARCHAR2 )
344: RETURN DATE AS

Line 341: p_course_cd IN IGS_AS_SC_ATTEMPT_H_ALL.course_cd%TYPE ,

337: --
338: -- Routine to get the effective start date for a SCA history
339: FUNCTION enrp_get_scaeh_eff_st(
340: p_person_id IN IGS_AS_SC_ATTEMPT_H_ALL.person_id%TYPE ,
341: p_course_cd IN IGS_AS_SC_ATTEMPT_H_ALL.course_cd%TYPE ,
342: p_hist_start_dt IN DATE ,
343: p_course_attempt_status IN VARCHAR2 )
344: RETURN DATE AS
345: gv_other_detail VARCHAR2(255);

Line 350: cp_person_id IGS_AS_SC_ATTEMPT_H.person_id%TYPE,

346: BEGIN
347: DECLARE
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,

Line 351: cp_course_cd IGS_AS_SC_ATTEMPT_H.course_cd%TYPE) IS

347: DECLARE
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

Line 360: cp_person_id IGS_AS_SC_ATTEMPT_H.person_id%TYPE,

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,
361: cp_course_cd IGS_AS_SC_ATTEMPT_H.course_cd%TYPE) IS
362: SELECT MAX(hist_start_dt)
363: FROM IGS_AS_SC_ATTEMPT_H
364: WHERE person_id = cp_person_id AND

Line 361: cp_course_cd IGS_AS_SC_ATTEMPT_H.course_cd%TYPE) IS

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,
361: cp_course_cd IGS_AS_SC_ATTEMPT_H.course_cd%TYPE) IS
362: SELECT MAX(hist_start_dt)
363: FROM IGS_AS_SC_ATTEMPT_H
364: WHERE person_id = cp_person_id AND
365: course_cd = cp_course_cd AND

Line 363: FROM IGS_AS_SC_ATTEMPT_H

359: CURSOR c_last_e_scah (
360: cp_person_id IGS_AS_SC_ATTEMPT_H.person_id%TYPE,
361: cp_course_cd IGS_AS_SC_ATTEMPT_H.course_cd%TYPE) IS
362: SELECT MAX(hist_start_dt)
363: FROM IGS_AS_SC_ATTEMPT_H
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;

Line 367: v_last_hist_start_dt IGS_AS_SC_ATTEMPT_H.hist_start_dt%TYPE;

363: FROM IGS_AS_SC_ATTEMPT_H
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