1 PACKAGE IGS_EN_GET_SUAEH_DTL AUTHID CURRENT_USER AS
2 /* $Header: IGSEN16S.pls 115.6 2003/05/13 08:28:42 kkillams ship $ */
3 -------------------------------------------------------------------------------------------
4 --Change History:
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,
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,
20 p_uoo_id IN IGS_EN_SU_ATTEMPT.UOO_ID%TYPE)
21 RETURN VARCHAR2;
22
23 PRAGMA RESTRICT_REFERENCES (ENRP_GET_SUAEH_COL,WNDS);
24 --
25 -- Routine to get the effective end date for a SUA history
26 FUNCTION enrp_get_suaeh_eff_end(
27 p_person_id IN IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,
28 p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
29 p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
30 p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
31 p_ci_sequence_num IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
32 p_hist_end_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_end_dt%TYPE ,
33 p_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE,
34 p_uoo_id IN IGS_EN_SU_ATTEMPT.UOO_ID%TYPE)
35 RETURN DATE;
36 PRAGMA RESTRICT_REFERENCES (ENRP_GET_SUAEH_EFF_END,WNDS);
37
38 -- Routine to get the effective start date for a SUA history
39 FUNCTION enrp_get_suaeh_eff_st(
40 p_person_id IN IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,
41 p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
42 p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
43 p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
44 p_ci_sequence_num IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
45 p_hist_start_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_start_dt%TYPE ,
46 p_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE,
47 p_uoo_id IN IGS_EN_SU_ATTEMPT.UOO_ID%TYPE)
48 RETURN DATE;
49 PRAGMA RESTRICT_REFERENCES (ENRP_GET_SUAEH_EFF_ST,WNDS);
50
51 END IGS_EN_GET_SUAEH_DTL;