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_ALL

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