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_ALL

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