[Home] [Help]
PACKAGE: APPS.IGS_EN_GEN_014
Source
1 PACKAGE IGS_EN_GEN_014 AS
2 /* $Header: IGSEN14S.pls 120.0 2005/06/01 18:58:19 appldev noship $ */
3
4
5 -------------------------------------------------------------------------------------------
6 --Change History:
7 --Who When What
8 --ckasu 22-JUL-2004 added new Functions and Procedures Specs inorder to incorporate the
9 -- logic for getting current,future load calendars information.
10 -- as a part of Bug# 3784635
11 -------------------------------------------------------------------------------------------
12
13 Function Enrs_Clc_Sua_Cp(
14 p_person_id IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
15 p_course_cd IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
16 p_crv_version_number IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
17 p_unit_cd IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
18 p_unit_version_number IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
19 p_teach_cal_type IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
20 p_teach_sequence_number IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
21 p_uoo_id IN NUMBER ,
22 p_load_cal_type IGS_CA_INST_ALL.cal_type%TYPE ,
23 p_load_sequence_number IGS_CA_INST_ALL.sequence_number%TYPE ,
24 p_override_enrolled_cp IN NUMBER ,
25 p_override_eftsu IN NUMBER ,
26 p_truncate_ind IN VARCHAR2 ,
27 p_sca_cp_total IN NUMBER ,
28 -- anilk, Audit special fee build
29 p_include_audit IN VARCHAR2 DEFAULT 'N')
30 RETURN NUMBER;
31 PRAGMA RESTRICT_REFERENCES(Enrs_Clc_Sua_Cp, WNDS, WNPS);
32
33 Function Enrs_Clc_Sua_Eftsu(
34 p_person_id IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
35 p_course_cd IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
36 p_crv_version_number IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
37 p_unit_cd IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
38 p_unit_version_number IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
39 p_teach_cal_type IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
40 p_teach_sequence_number IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
41 p_uoo_id IN NUMBER ,
42 p_load_cal_type IGS_CA_INST_ALL.cal_type%TYPE ,
43 p_load_sequence_number IGS_CA_INST_ALL.sequence_number%TYPE ,
44 p_override_enrolled_cp IN NUMBER ,
45 p_override_eftsu IN NUMBER ,
46 p_truncate_ind IN VARCHAR2 ,
47 p_sca_cp_total IN NUMBER ,
48 -- anilk, Audit special fee build
49 p_include_audit IN VARCHAR2 DEFAULT 'N')
50 RETURN NUMBER;
51 PRAGMA RESTRICT_REFERENCES(Enrs_Clc_Sua_Eftsu, WNDS, WNPS);
52
53 Function Enrs_Clc_Sua_Eftsut(
54 P_PERSON_ID IN NUMBER ,
55 P_COURSE_CD IN VARCHAR2 ,
56 P_CRV_VERSION_NUMBER IN NUMBER ,
57 P_UNIT_CD IN VARCHAR2 ,
58 P_UNIT_VERSION_NUMBER IN NUMBER ,
59 P_TEACH_CAL_TYPE IN VARCHAR2 ,
60 P_TEACH_SEQUENCE_NUMBER IN NUMBER ,
61 p_uoo_id IN NUMBER ,
62 p_override_enrolled_cp IN NUMBER ,
63 p_override_eftsu IN NUMBER ,
64 p_sca_cp_total IN NUMBER )
65 RETURN NUMBER;
66 PRAGMA RESTRICT_REFERENCES(Enrs_Clc_Sua_Eftsut, WNDS, WNPS);
67
68 Function Enrs_Get_Acad_Alt_Cd(
69 p_cal_type IN VARCHAR2 ,
70 p_ci_sequence_number IN NUMBER )
71 RETURN VARCHAR2;
72 PRAGMA RESTRICT_REFERENCES(Enrs_Get_Acad_Alt_Cd, WNDS,WNPS);
73
74 Function Enrs_Get_Acai_Cndtnl(
75 p_adm_cndtnl_offer_status IN VARCHAR2 ,
76 p_cndtnl_off_must_be_stsfd_ind IN VARCHAR2 DEFAULT 'N')
77 RETURN VARCHAR2;
78 PRAGMA RESTRICT_REFERENCES(Enrs_Get_Acai_Cndtnl, WNDS,WNPS);
79
80 Function Enrs_Get_Sca_Comm(
81 p_person_id IN NUMBER ,
82 p_course_cd IN VARCHAR2 ,
83 p_student_confirmed_ind IN VARCHAR2 DEFAULT 'N',
84 p_effective_date IN DATE )
85 RETURN VARCHAR2;
86 PRAGMA RESTRICT_REFERENCES(Enrs_Get_Sca_Comm, WNDS, WNPS);
87
88 Function Enrs_Get_Sca_Elgbl(
89 p_person_id IN NUMBER ,
90 p_course_cd IN VARCHAR2 ,
91 p_student_comm_type IN VARCHAR2 ,
92 p_acad_cal_type IN VARCHAR2 ,
93 p_acad_ci_sequence_number IN NUMBER )
94 RETURN VARCHAR2;
95 --PRAGMA RESTRICT_REFERENCES(Enrs_Get_Sca_Elgbl, WNDS, WNPS);
96
97 Function Enrs_Get_Sca_Trnsfr(
98 p_person_id IN NUMBER ,
99 p_course_cd IN VARCHAR2 )
100 RETURN VARCHAR2;
101 PRAGMA RESTRICT_REFERENCES(Enrs_Get_Sca_Trnsfr, WNDS, WNPS);
102
103 Function Enrs_Get_Within_Ci(
104 p_sup_cal_type IN VARCHAR2 ,
105 p_sup_sequence_number IN NUMBER ,
106 p_sub_cal_type IN VARCHAR2 ,
107 p_sub_sequence_number IN NUMBER ,
108 p_direct_match_ind IN VARCHAR2 )
109 RETURN VARCHAR2;
110 PRAGMA RESTRICT_REFERENCES(Enrs_Get_Within_Ci, WNDS, WNPS);
111
112 TYPE load_cal_rec_type IS RECORD (
113 p_load_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
114 p_load_ci_seq_num IGS_CA_INST.SEQUENCE_NUMBER%TYPE,
115 p_load_ci_alt_code IGS_CA_INST.ALTERNATE_CODE%TYPE,
116 p_load_ci_start_dt IGS_CA_INST.START_DT%TYPE,
117 p_load_ci_end_dt IGS_CA_INST.END_DT%TYPE,
118 p_load_cal_desc IGS_CA_INST.DESCRIPTION%TYPE
119 );
120
121 TYPE load_cal_table_type IS TABLE OF load_cal_rec_type
122 INDEX BY BINARY_INTEGER;
123
124 PROCEDURE get_all_cur_load_cal (
125 p_acad_cal_type IN VARCHAR2,
126 p_effective_dt IN DATE,
127 p_load_cal_table_info_str OUT NOCOPY VARCHAR2
128 );
129
130 PROCEDURE get_all_future_load_cal (
131 p_acad_cal_type IN VARCHAR2,
132 p_future_ld_cal_table_info_str OUT NOCOPY VARCHAR2
133 );
134
135 FUNCTION get_cal_tbl_frm_caltyp_seq_lst (
136 p_seqno_caltype_info IN VARCHAR2
137 ) RETURN load_cal_table_type;
138
139
140 FUNCTION get_cur_ld_cal_with_erly_st_dt (
141 p_load_cal_table_info_str IN VARCHAR2
142 ) RETURN VARCHAR2;
143
144
145 FUNCTION get_load_eff_dt_alias
146 RETURN VARCHAR2;
147
148 FUNCTION get_seqno_caltyp_from_caltable (
149 p_cal_table_info IN load_cal_table_type
150 ) RETURN VARCHAR2;
151
152 FUNCTION is_cur_ld_cal_has_eff_dt_alias (
153 p_acad_cal_type IN VARCHAR2,
154 p_effective_dt IN DATE,
155 p_all_cur_load_cal_info_str OUT NOCOPY VARCHAR2
156 ) RETURN BOOLEAN;
157
158 FUNCTION is_fut_cal_exists_as_cur_cal (
159 p_all_cur_load_cal_info IN load_cal_table_type,
160 p_fut_load_cal_rec IN load_cal_rec_type
161 ) RETURN BOOLEAN;
162
163 END IGS_EN_GEN_014;