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_H

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 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 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 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 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 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