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_SUAEH_DTL dependencies on IGS_EN_SU_ATTEMPT

Line 15: p_uoo_id IN IGS_EN_SU_ATTEMPT.UOO_ID%TYPE)

11: p_cal_type IN IGS_CA_TYPE.cal_type%TYPE ,
12: p_ci_seq_num IN IGS_CA_INST_ALL.sequence_number%TYPE ,
13: p_hist_start_dt IN DATE ,
14: p_unit_attempt_status IN VARCHAR2,
15: p_uoo_id IN IGS_EN_SU_ATTEMPT.UOO_ID%TYPE)
16: -------------------------------------------------------------------------------------------
17: --Change History:
18: --Who When What
19: --kkillams 28-04-2003 New parameter p_uoo_id is added to this function and

Line 29: cp_person_id igs_en_su_attempt.person_id%TYPE,

25: BEGIN
26: DECLARE
27: -- cursor to get the current student unit attempt status
28: CURSOR c_sua ( cp_column_name user_tab_columns.column_name%TYPE,
29: cp_person_id igs_en_su_attempt.person_id%TYPE,
30: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
31: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS
32: SELECT /*+ ROWID(IGS_EN_SU_ATTEMPT) */
33: unit_attempt_status,

Line 30: cp_course_cd igs_en_su_attempt.course_cd%TYPE,

26: DECLARE
27: -- cursor to get the current student unit attempt status
28: CURSOR c_sua ( cp_column_name user_tab_columns.column_name%TYPE,
29: cp_person_id igs_en_su_attempt.person_id%TYPE,
30: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
31: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS
32: SELECT /*+ ROWID(IGS_EN_SU_ATTEMPT) */
33: unit_attempt_status,
34: enrolled_dt,

Line 31: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS

27: -- cursor to get the current student unit attempt status
28: CURSOR c_sua ( cp_column_name user_tab_columns.column_name%TYPE,
29: cp_person_id igs_en_su_attempt.person_id%TYPE,
30: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
31: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS
32: SELECT /*+ ROWID(IGS_EN_SU_ATTEMPT) */
33: unit_attempt_status,
34: enrolled_dt,
35: DECODE (cp_column_name,

Line 32: SELECT /+ ROWID(IGS_EN_SU_ATTEMPT) /

28: CURSOR c_sua ( cp_column_name user_tab_columns.column_name%TYPE,
29: cp_person_id igs_en_su_attempt.person_id%TYPE,
30: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
31: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS
32: SELECT /*+ ROWID(IGS_EN_SU_ATTEMPT) */
33: unit_attempt_status,
34: enrolled_dt,
35: DECODE (cp_column_name,
36: 'VERSION_NUMBER', TO_CHAR(version_number),

Line 54: FROM IGS_EN_SU_ATTEMPT

50: 'OVERRIDE_EFTSU', TO_CHAR(override_eftsu),
51: 'OVERRIDE_ACHIEVABLE_CP', TO_CHAR(override_achievable_cp),
52: 'OVERRIDE_OUTCOME_DUE_DT', IGS_GE_DATE.IGSCHARDT(override_outcome_due_dt),
53: 'OVERRIDE_CREDIT_REASON', override_credit_reason)
54: FROM IGS_EN_SU_ATTEMPT
55: WHERE person_id = cp_person_id AND
56: course_cd = cp_course_cd AND
57: uoo_id = cp_uoo_id;
58: -- cursor to get the last enrolled history

Line 61: cp_person_id igs_en_su_attempt_h.person_id%TYPE,

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

Line 62: cp_course_cd igs_en_su_attempt_h.course_cd%TYPE,

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

Line 63: cp_uoo_id igs_en_su_attempt_h.uoo_id%TYPE) IS

59: CURSOR c_last_e_suah (
60: cp_column_name user_tab_columns.column_name%TYPE,
61: cp_person_id igs_en_su_attempt_h.person_id%TYPE,
62: cp_course_cd igs_en_su_attempt_h.course_cd%TYPE,
63: cp_uoo_id igs_en_su_attempt_h.uoo_id%TYPE) IS
64: SELECT /*+ FIRST_ROWS */
65: hist_start_dt,
66: hist_end_dt,
67: DECODE (cp_column_name,

Line 86: FROM IGS_EN_SU_ATTEMPT_H

82: 'OVERRIDE_EFTSU', TO_CHAR(override_eftsu),
83: 'OVERRIDE_ACHIEVABLE_CP', TO_CHAR(override_achievable_cp),
84: 'OVERRIDE_OUTCOME_DUE_DT', IGS_GE_DATE.IGSCHARDT(override_outcome_due_dt),
85: 'OVERRIDE_CREDIT_REASON', override_credit_reason)
86: FROM IGS_EN_SU_ATTEMPT_H
87: WHERE person_id = cp_person_id AND
88: course_cd = cp_course_cd AND
89: uoo_id = cp_uoo_id AND
90: unit_attempt_status = 'ENROLLED'

Line 92: v_last_hist_start_dt IGS_EN_SU_ATTEMPT_H.hist_start_dt%TYPE;

88: course_cd = cp_course_cd AND
89: uoo_id = cp_uoo_id AND
90: unit_attempt_status = 'ENROLLED'
91: ORDER BY hist_start_dt DESC;
92: v_last_hist_start_dt IGS_EN_SU_ATTEMPT_H.hist_start_dt%TYPE;
93: v_last_hist_end_dt IGS_EN_SU_ATTEMPT_H.hist_end_dt%TYPE;
94: v_current_cas IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
95: v_current_e_dt IGS_EN_SU_ATTEMPT.enrolled_dt%TYPE;
96: v_current_col_value VARCHAR2(2000);

Line 93: v_last_hist_end_dt IGS_EN_SU_ATTEMPT_H.hist_end_dt%TYPE;

89: uoo_id = cp_uoo_id AND
90: unit_attempt_status = 'ENROLLED'
91: ORDER BY hist_start_dt DESC;
92: v_last_hist_start_dt IGS_EN_SU_ATTEMPT_H.hist_start_dt%TYPE;
93: v_last_hist_end_dt IGS_EN_SU_ATTEMPT_H.hist_end_dt%TYPE;
94: v_current_cas IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
95: v_current_e_dt IGS_EN_SU_ATTEMPT.enrolled_dt%TYPE;
96: v_current_col_value VARCHAR2(2000);
97: v_hist_col_value VARCHAR2(2000);

Line 94: v_current_cas IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;

90: unit_attempt_status = 'ENROLLED'
91: ORDER BY hist_start_dt DESC;
92: v_last_hist_start_dt IGS_EN_SU_ATTEMPT_H.hist_start_dt%TYPE;
93: v_last_hist_end_dt IGS_EN_SU_ATTEMPT_H.hist_end_dt%TYPE;
94: v_current_cas IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
95: v_current_e_dt IGS_EN_SU_ATTEMPT.enrolled_dt%TYPE;
96: v_current_col_value VARCHAR2(2000);
97: v_hist_col_value VARCHAR2(2000);
98: BEGIN

Line 95: v_current_e_dt IGS_EN_SU_ATTEMPT.enrolled_dt%TYPE;

91: ORDER BY hist_start_dt DESC;
92: v_last_hist_start_dt IGS_EN_SU_ATTEMPT_H.hist_start_dt%TYPE;
93: v_last_hist_end_dt IGS_EN_SU_ATTEMPT_H.hist_end_dt%TYPE;
94: v_current_cas IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
95: v_current_e_dt IGS_EN_SU_ATTEMPT.enrolled_dt%TYPE;
96: v_current_col_value VARCHAR2(2000);
97: v_hist_col_value VARCHAR2(2000);
98: BEGIN
99: -- get the current unit attempt status

Line 230: p_person_id IN IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,

226: END enrp_get_suaeh_col;
227: --
228: -- Routine to get the effective end date for a SUA history
229: FUNCTION enrp_get_suaeh_eff_end(
230: p_person_id IN IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,
231: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
232: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
233: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
234: p_ci_sequence_num IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,

Line 231: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,

227: --
228: -- Routine to get the effective end date for a SUA history
229: FUNCTION enrp_get_suaeh_eff_end(
230: p_person_id IN IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,
231: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
232: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
233: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
234: p_ci_sequence_num IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
235: p_hist_end_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_end_dt%TYPE ,

Line 232: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,

228: -- Routine to get the effective end date for a SUA history
229: FUNCTION enrp_get_suaeh_eff_end(
230: p_person_id IN IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,
231: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
232: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
233: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
234: p_ci_sequence_num IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
235: p_hist_end_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_end_dt%TYPE ,
236: p_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE,

Line 233: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,

229: FUNCTION enrp_get_suaeh_eff_end(
230: p_person_id IN IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,
231: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
232: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
233: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
234: p_ci_sequence_num IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
235: p_hist_end_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_end_dt%TYPE ,
236: p_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE,
237: p_uoo_id IN IGS_EN_SU_ATTEMPT.UOO_ID%TYPE)

Line 234: p_ci_sequence_num IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,

230: p_person_id IN IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,
231: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
232: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
233: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
234: p_ci_sequence_num IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
235: p_hist_end_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_end_dt%TYPE ,
236: p_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE,
237: p_uoo_id IN IGS_EN_SU_ATTEMPT.UOO_ID%TYPE)
238: -------------------------------------------------------------------------------------------

Line 235: p_hist_end_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_end_dt%TYPE ,

231: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
232: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
233: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
234: p_ci_sequence_num IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
235: p_hist_end_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_end_dt%TYPE ,
236: p_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE,
237: p_uoo_id IN IGS_EN_SU_ATTEMPT.UOO_ID%TYPE)
238: -------------------------------------------------------------------------------------------
239: --Change History:

Line 236: p_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE,

232: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
233: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
234: p_ci_sequence_num IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
235: p_hist_end_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_end_dt%TYPE ,
236: p_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE,
237: p_uoo_id IN IGS_EN_SU_ATTEMPT.UOO_ID%TYPE)
238: -------------------------------------------------------------------------------------------
239: --Change History:
240: --Who When What

Line 237: p_uoo_id IN IGS_EN_SU_ATTEMPT.UOO_ID%TYPE)

233: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
234: p_ci_sequence_num IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
235: p_hist_end_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_end_dt%TYPE ,
236: p_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE,
237: p_uoo_id IN IGS_EN_SU_ATTEMPT.UOO_ID%TYPE)
238: -------------------------------------------------------------------------------------------
239: --Change History:
240: --Who When What
241: --rvivekan 23-Jun-2003 modified cursor c_last_e_suah as it was giving rise to

Line 253: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,

249: BEGIN
250: DECLARE
251: -- cursor to get the current student unit attempt status
252: CURSOR c_sua (
253: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
254: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
255: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE) IS
256: SELECT /*+ ROWID(IGS_EN_SU_ATTEMPT) */
257: unit_attempt_status,

Line 254: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,

250: DECLARE
251: -- cursor to get the current student unit attempt status
252: CURSOR c_sua (
253: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
254: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
255: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE) IS
256: SELECT /*+ ROWID(IGS_EN_SU_ATTEMPT) */
257: unit_attempt_status,
258: enrolled_dt,

Line 255: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE) IS

251: -- cursor to get the current student unit attempt status
252: CURSOR c_sua (
253: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
254: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
255: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE) IS
256: SELECT /*+ ROWID(IGS_EN_SU_ATTEMPT) */
257: unit_attempt_status,
258: enrolled_dt,
259: discontinued_dt

Line 256: SELECT /+ ROWID(IGS_EN_SU_ATTEMPT) /

252: CURSOR c_sua (
253: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
254: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
255: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE) IS
256: SELECT /*+ ROWID(IGS_EN_SU_ATTEMPT) */
257: unit_attempt_status,
258: enrolled_dt,
259: discontinued_dt
260: FROM IGS_EN_SU_ATTEMPT

Line 260: FROM IGS_EN_SU_ATTEMPT

256: SELECT /*+ ROWID(IGS_EN_SU_ATTEMPT) */
257: unit_attempt_status,
258: enrolled_dt,
259: discontinued_dt
260: FROM IGS_EN_SU_ATTEMPT
261: WHERE person_id = cp_person_id AND
262: course_cd = cp_course_cd AND
263: uoo_id = cp_uoo_id;
264: -- cursor to get the last enrolled history..modified cursor due perfomance issues

Line 266: cp_person_id IGS_EN_SU_ATTEMPT_H.person_id%TYPE,

262: course_cd = cp_course_cd AND
263: uoo_id = cp_uoo_id;
264: -- cursor to get the last enrolled history..modified cursor due perfomance issues
265: CURSOR c_last_e_suah (
266: cp_person_id IGS_EN_SU_ATTEMPT_H.person_id%TYPE,
267: cp_course_cd IGS_EN_SU_ATTEMPT_H.course_cd%TYPE,
268: cp_uoo_id IGS_EN_SU_ATTEMPT_H.uoo_id%TYPE) IS
269: SELECT MAX(SUAH1.hist_end_dt)
270: FROM IGS_EN_SU_ATTEMPT_H suah1, IGS_EN_SU_ATTEMPT sua1

Line 267: cp_course_cd IGS_EN_SU_ATTEMPT_H.course_cd%TYPE,

263: uoo_id = cp_uoo_id;
264: -- cursor to get the last enrolled history..modified cursor due perfomance issues
265: CURSOR c_last_e_suah (
266: cp_person_id IGS_EN_SU_ATTEMPT_H.person_id%TYPE,
267: cp_course_cd IGS_EN_SU_ATTEMPT_H.course_cd%TYPE,
268: cp_uoo_id IGS_EN_SU_ATTEMPT_H.uoo_id%TYPE) IS
269: SELECT MAX(SUAH1.hist_end_dt)
270: FROM IGS_EN_SU_ATTEMPT_H suah1, IGS_EN_SU_ATTEMPT sua1
271: WHERE SUA1.person_id = SUAH1.person_id AND SUA1.course_cd = SUAH1.course_cd AND SUA1.uoo_id = SUAH1.uoo_id

Line 268: cp_uoo_id IGS_EN_SU_ATTEMPT_H.uoo_id%TYPE) IS

264: -- cursor to get the last enrolled history..modified cursor due perfomance issues
265: CURSOR c_last_e_suah (
266: cp_person_id IGS_EN_SU_ATTEMPT_H.person_id%TYPE,
267: cp_course_cd IGS_EN_SU_ATTEMPT_H.course_cd%TYPE,
268: cp_uoo_id IGS_EN_SU_ATTEMPT_H.uoo_id%TYPE) IS
269: SELECT MAX(SUAH1.hist_end_dt)
270: FROM IGS_EN_SU_ATTEMPT_H suah1, IGS_EN_SU_ATTEMPT sua1
271: WHERE SUA1.person_id = SUAH1.person_id AND SUA1.course_cd = SUAH1.course_cd AND SUA1.uoo_id = SUAH1.uoo_id
272: AND SUAH1.person_id = cp_person_id AND SUAH1.course_cd = cp_course_cd AND SUAH1.uoo_id = cp_uoo_id

Line 270: FROM IGS_EN_SU_ATTEMPT_H suah1, IGS_EN_SU_ATTEMPT sua1

266: cp_person_id IGS_EN_SU_ATTEMPT_H.person_id%TYPE,
267: cp_course_cd IGS_EN_SU_ATTEMPT_H.course_cd%TYPE,
268: cp_uoo_id IGS_EN_SU_ATTEMPT_H.uoo_id%TYPE) IS
269: SELECT MAX(SUAH1.hist_end_dt)
270: FROM IGS_EN_SU_ATTEMPT_H suah1, IGS_EN_SU_ATTEMPT sua1
271: WHERE SUA1.person_id = SUAH1.person_id AND SUA1.course_cd = SUAH1.course_cd AND SUA1.uoo_id = SUAH1.uoo_id
272: AND SUAH1.person_id = cp_person_id AND SUAH1.course_cd = cp_course_cd AND SUAH1.uoo_id = cp_uoo_id
273: AND SUBSTR(NVL(SUAH1.unit_attempt_status, NVL(Igs_Au_Gen_003.audp_get_suah_col('UNIT_ATTEMPT_STATUS', SUAH1.person_id, SUAH1.course_cd, SUAH1.hist_end_dt, SUAH1.uoo_id ), SUA1.unit_attempt_status)),1,10)='ENROLLED' ;
274:

Line 275: v_current_uas IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;

271: WHERE SUA1.person_id = SUAH1.person_id AND SUA1.course_cd = SUAH1.course_cd AND SUA1.uoo_id = SUAH1.uoo_id
272: AND SUAH1.person_id = cp_person_id AND SUAH1.course_cd = cp_course_cd AND SUAH1.uoo_id = cp_uoo_id
273: AND SUBSTR(NVL(SUAH1.unit_attempt_status, NVL(Igs_Au_Gen_003.audp_get_suah_col('UNIT_ATTEMPT_STATUS', SUAH1.person_id, SUAH1.course_cd, SUAH1.hist_end_dt, SUAH1.uoo_id ), SUA1.unit_attempt_status)),1,10)='ENROLLED' ;
274:
275: v_current_uas IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
276: v_current_e_dt IGS_EN_SU_ATTEMPT.enrolled_dt%TYPE;
277: v_current_d_dt IGS_EN_SU_ATTEMPT.discontinued_dt%TYPE;
278: v_last_hist_end_dt IGS_EN_SU_ATTEMPT_H.hist_end_dt%TYPE;
279: BEGIN -- enrp_get_scahl_eff_end

Line 276: v_current_e_dt IGS_EN_SU_ATTEMPT.enrolled_dt%TYPE;

272: AND SUAH1.person_id = cp_person_id AND SUAH1.course_cd = cp_course_cd AND SUAH1.uoo_id = cp_uoo_id
273: AND SUBSTR(NVL(SUAH1.unit_attempt_status, NVL(Igs_Au_Gen_003.audp_get_suah_col('UNIT_ATTEMPT_STATUS', SUAH1.person_id, SUAH1.course_cd, SUAH1.hist_end_dt, SUAH1.uoo_id ), SUA1.unit_attempt_status)),1,10)='ENROLLED' ;
274:
275: v_current_uas IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
276: v_current_e_dt IGS_EN_SU_ATTEMPT.enrolled_dt%TYPE;
277: v_current_d_dt IGS_EN_SU_ATTEMPT.discontinued_dt%TYPE;
278: v_last_hist_end_dt IGS_EN_SU_ATTEMPT_H.hist_end_dt%TYPE;
279: BEGIN -- enrp_get_scahl_eff_end
280: -- get the current unit attempt status

Line 277: v_current_d_dt IGS_EN_SU_ATTEMPT.discontinued_dt%TYPE;

273: AND SUBSTR(NVL(SUAH1.unit_attempt_status, NVL(Igs_Au_Gen_003.audp_get_suah_col('UNIT_ATTEMPT_STATUS', SUAH1.person_id, SUAH1.course_cd, SUAH1.hist_end_dt, SUAH1.uoo_id ), SUA1.unit_attempt_status)),1,10)='ENROLLED' ;
274:
275: v_current_uas IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
276: v_current_e_dt IGS_EN_SU_ATTEMPT.enrolled_dt%TYPE;
277: v_current_d_dt IGS_EN_SU_ATTEMPT.discontinued_dt%TYPE;
278: v_last_hist_end_dt IGS_EN_SU_ATTEMPT_H.hist_end_dt%TYPE;
279: BEGIN -- enrp_get_scahl_eff_end
280: -- get the current unit attempt status
281: OPEN c_sua( p_person_id,

Line 278: v_last_hist_end_dt IGS_EN_SU_ATTEMPT_H.hist_end_dt%TYPE;

274:
275: v_current_uas IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
276: v_current_e_dt IGS_EN_SU_ATTEMPT.enrolled_dt%TYPE;
277: v_current_d_dt IGS_EN_SU_ATTEMPT.discontinued_dt%TYPE;
278: v_last_hist_end_dt IGS_EN_SU_ATTEMPT_H.hist_end_dt%TYPE;
279: BEGIN -- enrp_get_scahl_eff_end
280: -- get the current unit attempt status
281: OPEN c_sua( p_person_id,
282: p_course_cd,

Line 361: p_person_id IN IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,

357: END enrp_get_suaeh_eff_end;
358: --
359: -- Routine to get the effective start date for a SUA history
360: FUNCTION enrp_get_suaeh_eff_st(
361: p_person_id IN IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,
362: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
363: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
364: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
365: p_ci_sequence_num IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,

Line 362: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,

358: --
359: -- Routine to get the effective start date for a SUA history
360: FUNCTION enrp_get_suaeh_eff_st(
361: p_person_id IN IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,
362: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
363: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
364: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
365: p_ci_sequence_num IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
366: p_hist_start_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_start_dt%TYPE ,

Line 363: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,

359: -- Routine to get the effective start date for a SUA history
360: FUNCTION enrp_get_suaeh_eff_st(
361: p_person_id IN IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,
362: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
363: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
364: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
365: p_ci_sequence_num IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
366: p_hist_start_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_start_dt%TYPE ,
367: p_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE,

Line 364: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,

360: FUNCTION enrp_get_suaeh_eff_st(
361: p_person_id IN IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,
362: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
363: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
364: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
365: p_ci_sequence_num IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
366: p_hist_start_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_start_dt%TYPE ,
367: p_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE,
368: p_uoo_id IN IGS_EN_SU_ATTEMPT.UOO_ID%TYPE)

Line 365: p_ci_sequence_num IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,

361: p_person_id IN IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,
362: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
363: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
364: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
365: p_ci_sequence_num IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
366: p_hist_start_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_start_dt%TYPE ,
367: p_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE,
368: p_uoo_id IN IGS_EN_SU_ATTEMPT.UOO_ID%TYPE)
369: -------------------------------------------------------------------------------------------

Line 366: p_hist_start_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_start_dt%TYPE ,

362: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
363: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
364: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
365: p_ci_sequence_num IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
366: p_hist_start_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_start_dt%TYPE ,
367: p_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE,
368: p_uoo_id IN IGS_EN_SU_ATTEMPT.UOO_ID%TYPE)
369: -------------------------------------------------------------------------------------------
370: --Change History:

Line 367: p_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE,

363: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
364: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
365: p_ci_sequence_num IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
366: p_hist_start_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_start_dt%TYPE ,
367: p_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE,
368: p_uoo_id IN IGS_EN_SU_ATTEMPT.UOO_ID%TYPE)
369: -------------------------------------------------------------------------------------------
370: --Change History:
371: --Who When What

Line 368: p_uoo_id IN IGS_EN_SU_ATTEMPT.UOO_ID%TYPE)

364: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
365: p_ci_sequence_num IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
366: p_hist_start_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_start_dt%TYPE ,
367: p_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE,
368: p_uoo_id IN IGS_EN_SU_ATTEMPT.UOO_ID%TYPE)
369: -------------------------------------------------------------------------------------------
370: --Change History:
371: --Who When What
372: --kkillams 28-04-2003 New parameter p_uoo_id is added to this function and

Line 382: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,

378: BEGIN
379: DECLARE
380: -- cursor to get the current student unit attempt status
381: CURSOR c_sua (
382: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
383: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
384: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE) IS
385: SELECT unit_attempt_status,
386: enrolled_dt,

Line 383: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,

379: DECLARE
380: -- cursor to get the current student unit attempt status
381: CURSOR c_sua (
382: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
383: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
384: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE) IS
385: SELECT unit_attempt_status,
386: enrolled_dt,
387: discontinued_dt

Line 384: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE) IS

380: -- cursor to get the current student unit attempt status
381: CURSOR c_sua (
382: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
383: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
384: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE) IS
385: SELECT unit_attempt_status,
386: enrolled_dt,
387: discontinued_dt
388: FROM IGS_EN_SU_ATTEMPT

Line 388: FROM IGS_EN_SU_ATTEMPT

384: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE) IS
385: SELECT unit_attempt_status,
386: enrolled_dt,
387: discontinued_dt
388: FROM IGS_EN_SU_ATTEMPT
389: WHERE person_id = cp_person_id AND
390: course_cd = cp_course_cd AND
391: uoo_id = cp_uoo_id;
392: CURSOR c_last_e_suah (

Line 393: cp_person_id IGS_EN_SU_ATTEMPT_H.person_id%TYPE,

389: WHERE person_id = cp_person_id AND
390: course_cd = cp_course_cd AND
391: uoo_id = cp_uoo_id;
392: CURSOR c_last_e_suah (
393: cp_person_id IGS_EN_SU_ATTEMPT_H.person_id%TYPE,
394: cp_course_cd IGS_EN_SU_ATTEMPT_H.course_cd%TYPE,
395: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE) IS
396: SELECT MAX(hist_start_dt)
397: FROM IGS_EN_SU_ATTEMPT_H

Line 394: cp_course_cd IGS_EN_SU_ATTEMPT_H.course_cd%TYPE,

390: course_cd = cp_course_cd AND
391: uoo_id = cp_uoo_id;
392: CURSOR c_last_e_suah (
393: cp_person_id IGS_EN_SU_ATTEMPT_H.person_id%TYPE,
394: cp_course_cd IGS_EN_SU_ATTEMPT_H.course_cd%TYPE,
395: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE) IS
396: SELECT MAX(hist_start_dt)
397: FROM IGS_EN_SU_ATTEMPT_H
398: WHERE person_id = cp_person_id AND

Line 395: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE) IS

391: uoo_id = cp_uoo_id;
392: CURSOR c_last_e_suah (
393: cp_person_id IGS_EN_SU_ATTEMPT_H.person_id%TYPE,
394: cp_course_cd IGS_EN_SU_ATTEMPT_H.course_cd%TYPE,
395: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE) IS
396: SELECT MAX(hist_start_dt)
397: FROM IGS_EN_SU_ATTEMPT_H
398: WHERE person_id = cp_person_id AND
399: course_cd = cp_course_cd AND

Line 397: FROM IGS_EN_SU_ATTEMPT_H

393: cp_person_id IGS_EN_SU_ATTEMPT_H.person_id%TYPE,
394: cp_course_cd IGS_EN_SU_ATTEMPT_H.course_cd%TYPE,
395: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE) IS
396: SELECT MAX(hist_start_dt)
397: FROM IGS_EN_SU_ATTEMPT_H
398: WHERE person_id = cp_person_id AND
399: course_cd = cp_course_cd AND
400: uoo_id = cp_uoo_id AND
401: unit_attempt_status = 'ENROLLED';

Line 402: v_last_hist_start_dt IGS_EN_SU_ATTEMPT_H.hist_start_dt%TYPE;

398: WHERE person_id = cp_person_id AND
399: course_cd = cp_course_cd AND
400: uoo_id = cp_uoo_id AND
401: unit_attempt_status = 'ENROLLED';
402: v_last_hist_start_dt IGS_EN_SU_ATTEMPT_H.hist_start_dt%TYPE;
403: v_current_uas IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
404: v_current_e_dt IGS_EN_SU_ATTEMPT.enrolled_dt%TYPE;
405: v_current_d_dt IGS_EN_SU_ATTEMPT.discontinued_dt%TYPE;
406: BEGIN -- enrp_get_scahl_eff_st

Line 403: v_current_uas IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;

399: course_cd = cp_course_cd AND
400: uoo_id = cp_uoo_id AND
401: unit_attempt_status = 'ENROLLED';
402: v_last_hist_start_dt IGS_EN_SU_ATTEMPT_H.hist_start_dt%TYPE;
403: v_current_uas IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
404: v_current_e_dt IGS_EN_SU_ATTEMPT.enrolled_dt%TYPE;
405: v_current_d_dt IGS_EN_SU_ATTEMPT.discontinued_dt%TYPE;
406: BEGIN -- enrp_get_scahl_eff_st
407: -- get the current unit attempt status

Line 404: v_current_e_dt IGS_EN_SU_ATTEMPT.enrolled_dt%TYPE;

400: uoo_id = cp_uoo_id AND
401: unit_attempt_status = 'ENROLLED';
402: v_last_hist_start_dt IGS_EN_SU_ATTEMPT_H.hist_start_dt%TYPE;
403: v_current_uas IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
404: v_current_e_dt IGS_EN_SU_ATTEMPT.enrolled_dt%TYPE;
405: v_current_d_dt IGS_EN_SU_ATTEMPT.discontinued_dt%TYPE;
406: BEGIN -- enrp_get_scahl_eff_st
407: -- get the current unit attempt status
408: OPEN c_sua( p_person_id,

Line 405: v_current_d_dt IGS_EN_SU_ATTEMPT.discontinued_dt%TYPE;

401: unit_attempt_status = 'ENROLLED';
402: v_last_hist_start_dt IGS_EN_SU_ATTEMPT_H.hist_start_dt%TYPE;
403: v_current_uas IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
404: v_current_e_dt IGS_EN_SU_ATTEMPT.enrolled_dt%TYPE;
405: v_current_d_dt IGS_EN_SU_ATTEMPT.discontinued_dt%TYPE;
406: BEGIN -- enrp_get_scahl_eff_st
407: -- get the current unit attempt status
408: OPEN c_sua( p_person_id,
409: p_course_cd,