PACKAGE: APPS.IGS_EN_GET_SCAEH_DTL

Source

1 PACKAGE IGS_EN_GET_SCAEH_DTL AUTHID CURRENT_USER AS
2 /* $Header: IGSEN15S.pls 115.3 2002/02/12 16:49:25 pkm ship    $ */
3 
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;
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;
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;
31 PRAGMA RESTRICT_REFERENCES (ENRP_GET_SCAEH_EFF_ST,WNDS);
32 
33 
34 END IGS_EN_GET_SCAEH_DTL;