1 PACKAGE IGS_RE_GEN_001 AS
2 /* $Header: IGSRE01S.pls 120.0 2005/06/02 04:15:47 appldev noship $ */
3
4 -------------------------------------------------------------------------------------------
5 --Change History:
6 --Who When What
7 --Nishikant 11DEC2002 ENCR027 Build (Program Length Integration). The pragma restriction for the functions
8 -- RESP_CLC_MAX_SBMSN and RESP_CLC_MIN_SBMSN removed since its modifying the variables in package.
9 --Nalin Kumar 12-Dec-2002 Once again putting back the pragma restriction in the RESP_CLC_MAX_SBMSN and RESP_CLC_MIN_SBMSN functions.
10 -- ENCR027 Build (Program Length Integration). Bug# 2608227
11 -- knaraset 09-May-03 modified function RESP_CLC_SUA_EFTSU to add parameter uoo_id, as part of MUS build bug 2829262
12
13 -------------------------------------------------------------------------------------------
14
15 FUNCTION RESP_CLC_EFTSU_TRUNC(
16 p_person_id IN NUMBER ,
17 p_ca_sequence_number IN NUMBER ,
18 p_unit_cd IN VARCHAR2 ,
19 p_version_number IN NUMBER ,
20 p_uoo_id IN NUMBER ,
21 p_census_dt IN DATE ,
22 p_eftsu IN NUMBER )
23 RETURN NUMBER;
24 PRAGMA RESTRICT_REFERENCES(RESP_CLC_EFTSU_TRUNC, WNDS,WNPS);
25
26 FUNCTION RESP_CLC_LOAD_EFTSU(
27 p_acad_cal_type IN VARCHAR2 ,
28 p_acad_ci_sequence_number IN NUMBER ,
29 p_load_cal_type IN VARCHAR2 ,
30 p_load_ci_sequence_number IN NUMBER )
31 RETURN NUMBER;
32 PRAGMA RESTRICT_REFERENCES(RESP_CLC_LOAD_EFTSU, WNDS,WNPS);
33
34 FUNCTION RESP_CLC_MAX_SBMSN(
35 p_person_id IN NUMBER ,
36 p_ca_sequence_number IN NUMBER ,
37 p_sca_course_cd IN VARCHAR2 ,
38 p_acai_admission_appl_number IN NUMBER ,
39 p_acai_nominated_course_cd IN VARCHAR2 ,
40 p_acai_sequence_number IN NUMBER ,
41 p_attendance_percentage IN NUMBER ,
42 p_commencement_dt IN DATE )
43 RETURN DATE;
44 PRAGMA RESTRICT_REFERENCES(RESP_CLC_MAX_SBMSN, WNDS,WNPS);
45
46 FUNCTION RESP_CLC_MIN_SBMSN(
47 P_PERSON_ID IN NUMBER ,
48 p_ca_sequence_number IN NUMBER ,
49 p_sca_course_cd IN VARCHAR2 ,
50 p_acai_admission_appl_number IN NUMBER ,
51 p_acai_nominated_course_cd IN VARCHAR2 ,
52 p_acai_sequence_number IN NUMBER ,
53 p_attendance_percentage IN NUMBER ,
54 p_commencement_dt IN DATE )
55 RETURN DATE;
56 PRAGMA RESTRICT_REFERENCES(RESP_CLC_MIN_SBMSN, WNDS,WNPS);
57
58 FUNCTION RESP_CLC_SUA_EFTSU(
59 p_person_id IN NUMBER ,
60 p_course_cd IN VARCHAR2 ,
61 p_unit_cd IN VARCHAR2 ,
62 p_cal_type IN VARCHAR2 ,
63 p_ci_sequence_number IN NUMBER ,
64 p_load_cal_type IN VARCHAR2 ,
65 p_load_ci_sequence_number IN NUMBER ,
66 p_truncate_ind IN VARCHAR2,
67 p_uoo_id igs_en_su_attempt.uoo_id%TYPE)
68 RETURN NUMBER;
69 PRAGMA RESTRICT_REFERENCES(RESP_CLC_SUA_EFTSU, WNDS,WNPS);
70
71 FUNCTION RESP_CLC_USED_EFTD(
72 p_person_id IN NUMBER ,
73 p_course_cd IN VARCHAR2 ,
74 p_candidature_identified_ind IN VARCHAR2 DEFAULT 'N',
75 p_ca_sequence_number IN NUMBER ,
76 p_attendance_percentage IN NUMBER )
77 RETURN NUMBER;
78 PRAGMA RESTRICT_REFERENCES(RESP_CLC_USED_EFTD, WNDS,WNPS);
79
80 FUNCTION RESP_GET_CA_ATT(
81 p_person_id IN NUMBER ,
82 p_course_cd IN VARCHAR2 ,
83 p_effective_dt IN DATE ,
84 p_ca_sequence_number IN NUMBER ,
85 p_attendance_type IN VARCHAR2 ,
86 p_attendance_percentage IN NUMBER )
87 RETURN NUMBER;
88 PRAGMA RESTRICT_REFERENCES(RESP_GET_CA_ATT, WNDS, WNPS);
89
90
91 FUNCTION resp_get_ca_comm(
92 p_person_id IN NUMBER ,
93 p_sca_course_cd IN VARCHAR2 ,
94 p_acai_admission_appl_number IN NUMBER ,
95 p_acai_nominated_course_cd IN VARCHAR2 ,
96 p_acai_sequence_number IN NUMBER )
97 RETURN DATE;
98 PRAGMA RESTRICT_REFERENCES(resp_get_ca_comm, WNDS,WNPS);
99
100 END IGS_RE_GEN_001;