APPS.IGS_EN_GET_SCAEH_DTL dependencies on IGS_AS_SC_ATTEMPT_H_ALL

Line 8: p_person_id IN IGS_AS_SC_ATTEMPT_H_ALL.person_id%TYPE ,

4: -- Get student course attempt effective history column value
5: FUNCTION enrp_get_scaeh_col(
6: p_column_name IN VARCHAR2 ,
7: p_column_value IN VARCHAR2 ,
8: p_person_id IN IGS_AS_SC_ATTEMPT_H_ALL.person_id%TYPE ,
9: p_course_cd IGS_PS_COURSE.course_cd%TYPE ,
10: p_hist_start_dt IN DATE ,
11: p_course_attempt_status VARCHAR2 )
12: RETURN VARCHAR2;

Line 17: p_person_id IN IGS_AS_SC_ATTEMPT_H_ALL.person_id%TYPE ,

13: PRAGMA RESTRICT_REFERENCES (ENRP_GET_SCAEH_COL,WNDS);
14: --
15: -- Routine to get the effective end date for a SCA history
16: FUNCTION enrp_get_scaeh_eff_end(
17: p_person_id IN IGS_AS_SC_ATTEMPT_H_ALL.person_id%TYPE ,
18: p_course_cd IN IGS_AS_SC_ATTEMPT_H_ALL.course_cd%TYPE ,
19: p_hist_end_dt IN DATE ,
20: p_course_attempt_status IN VARCHAR2 )
21: RETURN DATE;

Line 18: p_course_cd IN IGS_AS_SC_ATTEMPT_H_ALL.course_cd%TYPE ,

14: --
15: -- Routine to get the effective end date for a SCA history
16: FUNCTION enrp_get_scaeh_eff_end(
17: p_person_id IN IGS_AS_SC_ATTEMPT_H_ALL.person_id%TYPE ,
18: p_course_cd IN IGS_AS_SC_ATTEMPT_H_ALL.course_cd%TYPE ,
19: p_hist_end_dt IN DATE ,
20: p_course_attempt_status IN VARCHAR2 )
21: RETURN DATE;
22: PRAGMA RESTRICT_REFERENCES (ENRP_GET_SCAEH_EFF_END,WNDS);

Line 26: p_person_id IN IGS_AS_SC_ATTEMPT_H_ALL.person_id%TYPE ,

22: PRAGMA RESTRICT_REFERENCES (ENRP_GET_SCAEH_EFF_END,WNDS);
23: --
24: -- Routine to get the effective start date for a SCA history
25: FUNCTION enrp_get_scaeh_eff_st(
26: p_person_id IN IGS_AS_SC_ATTEMPT_H_ALL.person_id%TYPE ,
27: p_course_cd IN IGS_AS_SC_ATTEMPT_H_ALL.course_cd%TYPE ,
28: p_hist_start_dt IN DATE ,
29: p_course_attempt_status IN VARCHAR2 )
30: RETURN DATE;

Line 27: p_course_cd IN IGS_AS_SC_ATTEMPT_H_ALL.course_cd%TYPE ,

23: --
24: -- Routine to get the effective start date for a SCA history
25: FUNCTION enrp_get_scaeh_eff_st(
26: p_person_id IN IGS_AS_SC_ATTEMPT_H_ALL.person_id%TYPE ,
27: p_course_cd IN IGS_AS_SC_ATTEMPT_H_ALL.course_cd%TYPE ,
28: p_hist_start_dt IN DATE ,
29: p_course_attempt_status IN VARCHAR2 )
30: RETURN DATE;
31: PRAGMA RESTRICT_REFERENCES (ENRP_GET_SCAEH_EFF_ST,WNDS);