DBA Data[Home] [Help]

APPS.IGS_EN_GET_SUAEH_DTL dependencies on IGS_PS_UNIT

Line 9: -- Get student IGS_PS_UNIT attempt effective history column value

5: --Who When What
6: --kkillams 28-04-2003 New parameter p_uoo_id is added to the enrp_get_suaeh_col, enrp_get_suaeh_eff_st
7: -- and enrp_get_suaeh_eff_end functions w.r.t. bug number 2829262
8: -------------------------------------------------------------------------------------------
9: -- Get student IGS_PS_UNIT attempt effective history column value
10: FUNCTION enrp_get_suaeh_col(
11: p_column_name IN VARCHAR2 ,
12: p_column_value IN VARCHAR2 ,
13: p_person_id IN HZ_PARTIES.PARTY_ID%TYPE,

Line 15: p_unit_cd IN IGS_PS_UNIT.unit_cd%TYPE ,

11: p_column_name IN VARCHAR2 ,
12: p_column_value IN VARCHAR2 ,
13: p_person_id IN HZ_PARTIES.PARTY_ID%TYPE,
14: p_course_cd IN IGS_PS_COURSE.course_cd%TYPE ,
15: p_unit_cd IN IGS_PS_UNIT.unit_cd%TYPE ,
16: p_cal_type IN IGS_CA_TYPE.cal_type%TYPE ,
17: p_ci_seq_num IN IGS_CA_INST_ALL.sequence_number%TYPE ,
18: p_hist_start_dt IN DATE ,
19: p_unit_attempt_status IN VARCHAR2,