1 PACKAGE IGS_FI_GEN_001 AS
2 /* $Header: IGSFI01S.pls 120.0 2005/06/01 20:29:16 appldev noship $ */
3
4 /******************************************************************
5 Change History
6 Who When What
7 uudayapr 06-Jan-2004 Enh#3167098 Added the Added the function CHECK_STDNT_PRG_ATT_LIABLE .
8 vvutukur 1-Dec-2002 Enh#2584986.Removed references to igs_fi_fee_pay_schd, which is an obsoleted object.
9 sarakshi 23-sep-2002 Enh#2564643,removed parameter p_subaccount_id from finp_get_total_planned_credits
10 SMVK 13-Sep-2002 Bug#2531390. Restored the functions finp_get_fps_end_dt,FINP_GET_FDF_END_DT,
11 FINP_GET_FDF_ST_DT,finp_get_fps_start_dt, which are obsolete as the part of same bug.
12 vvutukur 02-Sep-2002 Bug#2531390. Removed the function finp_get_fps_end_dt.
13 smvk 28-Aug-2002 Bug#2531390.Removed the functions FINP_GET_FDF_END_DT, FINP_GET_FDF_ST_DT (SFCR005_Cleanup_Build)
14 vvutukur 26-Aug-2002 Bug#2531390.Removed the function finp_get_fps_start_dt.
15 jbegum 26-Aug-2002 As part of Enh Bug#2531390 the procedure finp_get_overdue_dtl was removed.
16 rnirwani 25-Apr-02 Obsoleting the procedure finp_get_dj_totals,
17 since this is not being used.
18 Bug# 2329407
19
20 SYkrishn 02-APR-2002 Bug 2293676 - Added functions finp_get_planned_credits_ind and
21 finp_get_total_planned_credits
22 schodava 18-Jan-2002 Enh # 2187247
23 Added functions finp_get_lfci_reln
24 and finp_chk_lfci_reln
25 ******************************************************************/
26 --
27 FUNCTION check_stdnt_prg_att_liable(
28 p_n_person_id IN PLS_INTEGER,
29 p_v_course_cd IN VARCHAR2,
30 p_n_course_version IN PLS_INTEGER,
31 p_v_fee_cat IN VARCHAR2,
32 p_v_fee_type IN VARCHAR2,
33 p_v_s_fee_trigger_cat IN VARCHAR2,
34 p_v_fee_cal_type IN VARCHAR2,
35 p_n_fee_ci_seq_number IN PLS_INTEGER,
36 p_n_adm_appl_number IN NUMBER,
37 p_v_adm_nom_course_cd IN VARCHAR2,
38 p_n_adm_seq_number IN NUMBER,
39 p_d_commencement_dt IN DATE,
40 p_d_disc_dt IN DATE,
41 p_v_cal_type IN VARCHAR2,
42 p_v_location_cd IN VARCHAR2,
43 p_v_attendance_mode IN VARCHAR2,
44 p_v_attendance_type IN VARCHAR2
45 ) RETURN VARCHAR2;
46 --
47 FUNCTION finp_get_currency(
48 p_fee_cal_type IN IGS_CA_TYPE.CAL_TYPE%TYPE ,
49 p_fee_ci_sequence_num IN igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE ,
50 p_s_relation_type IN VARCHAR2,
51 p_fee_type IN IGS_FI_FEE_TYPE_ALL.FEE_TYPE%TYPE ,
52 p_fee_category IN IGS_FI_FEE_CAT_ALL.FEE_CAT%TYPE )
53 RETURN VARCHAR2;
54 PRAGMA RESTRICT_REFERENCES(finp_get_currency,WNDS);
55 --
56 --
57 FUNCTION FINP_GET_FAS_MAN_IND(
58 p_person_id IN NUMBER ,
59 p_fee_type IN VARCHAR2 ,
60 p_fee_cal_type IN VARCHAR2 ,
61 p_fee_ci_sequence_number IN NUMBER ,
62 p_fee_cat IN VARCHAR2 ,
63 p_course_cd IN IGS_PS_COURSE.course_cd%TYPE ,
64 p_transaction_cat IN VARCHAR2 )
65 RETURN VARCHAR2;
66 PRAGMA RESTRICT_REFERENCES(FINP_GET_FAS_MAN_IND,WNDS);
67 --
68 FUNCTION FINP_GET_FCFL_DAI(
69 p_dt_alias_column_name IN VARCHAR2 ,
70 p_dai_seq_num_column_name IN VARCHAR2 ,
71 p_get_column_name IN VARCHAR2 ,
72 p_fee_cat IN IGS_FI_F_CAT_FEE_LBL_ALL.FEE_CAT%TYPE ,
73 p_fee_cal_type IN IGS_FI_F_CAT_FEE_LBL_ALL.fee_cal_type%TYPE ,
74 p_fee_ci_sequence_number IN IGS_FI_F_CAT_FEE_LBL_ALL.fee_ci_sequence_number%TYPE ,
75 p_fee_type IN IGS_FI_F_CAT_FEE_LBL_ALL.FEE_TYPE%TYPE )
76 RETURN VARCHAR2;
77 PRAGMA RESTRICT_REFERENCES(FINP_GET_FCFL_DAI,WNDS, WNPS);
78 --
79 FUNCTION finp_get_fdf_end_dt(
80 p_fee_type IN VARCHAR2 ,
81 p_fee_cal_type IN VARCHAR2 ,
82 p_fee_ci_sequence_number IN NUMBER ,
83 p_override_formula IN NUMBER ,
84 p_fee_cat IN VARCHAR2 )
85 RETURN DATE;
86 PRAGMA RESTRICT_REFERENCES(finp_get_fdf_end_dt,WNDS,WNPS);
87 --
88 FUNCTION finp_get_fdf_st_dt(
89 p_fee_type IN VARCHAR2 ,
90 p_fee_cal_type IN VARCHAR2 ,
91 p_fee_ci_sequence_number IN NUMBER ,
92 p_override_formula IN NUMBER ,
93 p_fee_cat IN VARCHAR2 )
94 RETURN DATE;
95 PRAGMA RESTRICT_REFERENCES(finp_get_fdf_st_dt,WNDS,WNPS);
96 --
97 FUNCTION FINP_GET_FEE_TRIGGER(
98 p_fee_cat IN IGS_FI_F_CAT_CA_INST.FEE_CAT%TYPE ,
99 p_fee_cal_type IN IGS_FI_F_CAT_CA_INST.fee_cal_type%TYPE ,
100 p_fee_ci_sequence_number IN IGS_FI_F_CAT_CA_INST.fee_ci_sequence_number%TYPE ,
101 p_fee_type IN IGS_FI_F_CAT_FEE_LBL_ALL.FEE_TYPE%TYPE ,
102 p_s_fee_trigger_cat IN IGS_FI_FEE_TYPE_ALL.s_fee_trigger_cat%TYPE ,
103 p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
104 p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
105 p_version_number IN IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE ,
106 p_cal_type IN IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE%TYPE ,
107 p_location_cd IN IGS_EN_STDNT_PS_ATT_ALL.location_cd%TYPE ,
108 p_attendance_mode IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE%TYPE ,
109 p_attendance_type IN IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE%TYPE )
110 RETURN VARCHAR2 ;
111 PRAGMA RESTRICT_REFERENCES(FINP_GET_FEE_TRIGGER,WNDS,WNPS);
112 --
113 FUNCTION finp_get_fps_end_dt(
114 p_fee_cal_type IN IGS_FI_F_TYP_CA_INST_ALL.fee_cal_type%TYPE,
115 p_fee_ci_sequence_num IN IGS_FI_F_TYP_CA_INST_ALL.fee_ci_sequence_number%TYPE,
116 p_s_relation_type IN VARCHAR2 ,
117 p_fee_type IN IGS_FI_F_TYP_CA_INST_ALL.FEE_TYPE%TYPE,
118 p_fee_cat IN IGS_FI_FEE_CAT_ALL.FEE_CAT%TYPE ,
119 p_schedule_number IN NUMBER,
120 p_dt_alias IN IGS_FI_F_TYP_CA_INST_ALL.START_DT_ALIAS%TYPE,
121 p_dai_sequence_num IN NUMBER )
122 RETURN DATE;
123 PRAGMA RESTRICT_REFERENCES(finp_get_fps_end_dt,WNDS);
124 --
125 FUNCTION finp_get_fps_start_dt(
126 p_fee_cal_type IN IGS_FI_F_TYP_CA_INST_ALL.fee_cal_type%TYPE,
127 p_fee_ci_sequence_num IN IGS_FI_F_TYP_CA_INST_ALL.fee_ci_sequence_number%TYPE,
128 p_s_relation_type IN VARCHAR2 ,
129 p_fee_type IN IGS_FI_F_TYP_CA_INST_ALL.FEE_TYPE%TYPE,
130 p_fee_cat IN IGS_FI_FEE_CAT_ALL.FEE_CAT%TYPE,
131 p_schedule_number IN NUMBER,
132 p_dt_alias IN IGS_FI_F_TYP_CA_INST_ALL.START_DT_ALIAS%TYPE,
133 p_dai_sequence_num IN NUMBER )
134 RETURN DATE;
135 PRAGMA RESTRICT_REFERENCES(finp_get_fps_start_dt,WNDS,WNPS);
136
137 --
138 FUNCTION finp_get_frtns_end_dt(
139 p_fee_cal_type IN IGS_FI_FEE_RET_SCHD.fee_cal_type%TYPE ,
140 p_fee_ci_sequence_num IN IGS_FI_FEE_RET_SCHD.fee_ci_sequence_number%TYPE ,
141 p_s_relation_type IN IGS_FI_FEE_RET_SCHD.s_relation_type%TYPE ,
142 p_fee_type IN IGS_FI_FEE_RET_SCHD.FEE_TYPE%TYPE ,
143 p_fee_cat IN IGS_FI_FEE_RET_SCHD.FEE_CAT%TYPE ,
144 p_dt_alias IN IGS_FI_FEE_RET_SCHD.DT_ALIAS%TYPE ,
145 p_dai_sequence_num IN NUMBER )
146 RETURN DATE;
147 PRAGMA RESTRICT_REFERENCES(finp_get_frtns_end_dt,WNDS);
148 --
149 FUNCTION finp_get_hecs_amt_pd(
150 p_load_cal_type IN VARCHAR2 ,
151 p_load_ci_sequence_number IN NUMBER ,
152 p_person_id IN NUMBER ,
153 p_course_cd IN VARCHAR2 )
154 RETURN NUMBER;
155 PRAGMA RESTRICT_REFERENCES(finp_get_hecs_amt_pd,WNDS);
156 --
157 FUNCTION finp_get_hecs_fee(
158 p_load_cal_type IN VARCHAR2 ,
159 p_load_ci_sequence_number IN NUMBER ,
160 p_person_id IN NUMBER ,
161 p_course_cd IN VARCHAR2 )
162 RETURN NUMBER;
163 PRAGMA RESTRICT_REFERENCES(finp_get_hecs_fee,WNDS);
164 --
165 FUNCTION finp_get_hecs_pymnt_optn(
166 p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
167 p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
168 p_effective_dt IN DATE ,
169 p_fee_cal_type IN IGS_CA_INST_ALL.CAL_TYPE%TYPE ,
170 p_fee_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
171 p_start_dt_alias IN IGS_FI_F_TYP_CA_INST_ALL.start_dt_alias%TYPE ,
172 p_start_dai_sequence_number IN IGS_FI_F_TYP_CA_INST_ALL.start_dai_sequence_number%TYPE ,
173 p_end_dt_alias IN IGS_FI_F_TYP_CA_INST_ALL.end_dt_alias%TYPE ,
174 p_end_dai_sequence_number IN IGS_FI_F_TYP_CA_INST_ALL.end_dai_sequence_number%TYPE )
175 RETURN varchar2;
176 PRAGMA RESTRICT_REFERENCES(finp_get_hecs_pymnt_optn,WNDS,WNPS);
177
178 --
179 FUNCTION finp_get_tuition_fee(
180 p_load_cal_type IN VARCHAR2 ,
181 p_load_ci_sequence_number IN NUMBER ,
182 p_person_id IN NUMBER ,
183 p_course_cd IN VARCHAR2 )
184 RETURN NUMBER;
185 PRAGMA RESTRICT_REFERENCES(finp_get_tuition_fee,WNDS);
186 --
187 FUNCTION finp_get_lfci_reln(
188 p_cal_type IN igs_ca_inst.cal_type%TYPE,
189 p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
190 p_cal_category IN igs_ca_type.s_cal_cat%TYPE,
191 p_ret_cal_type OUT NOCOPY igs_ca_inst.cal_type%TYPE,
192 p_ret_ci_sequence_number OUT NOCOPY igs_ca_inst.sequence_number%TYPE,
193 p_message_name OUT NOCOPY FND_NEW_MESSAGES.MESSAGE_NAME%TYPE)
194 RETURN BOOLEAN;
195 PRAGMA RESTRICT_REFERENCES(finp_get_lfci_reln,WNDS);
196 --
197 FUNCTION finp_chk_lfci_reln(
198 p_cal_type IN igs_ca_inst.cal_type%TYPE,
199 p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
200 p_cal_category IN igs_ca_type.s_cal_cat%TYPE)
201 RETURN VARCHAR2;
202 --
203 FUNCTION finp_get_planned_credits_ind(
204 p_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE)
205 RETURN VARCHAR2;
206 --
207 FUNCTION finp_get_total_planned_credits(
208 p_person_id IN igs_fi_parties_v.person_id%TYPE,
209 p_start_date IN DATE,
210 p_end_date IN DATE,
211 p_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE)
212 RETURN NUMBER;
213
214 END IGS_FI_GEN_001 ;