1 PACKAGE igs_fi_fee_as_items_pkg AS
2 /* $Header: IGSSI76S.pls 120.5 2005/10/05 16:48:21 appldev ship $ */
3 procedure INSERT_ROW (
4 X_ROWID in out NOCOPY VARCHAR2,
5 x_FEE_ASS_ITEM_ID IN OUT NOCOPY NUMBER,
6 x_TRANSACTION_ID IN NUMBER,
7 x_PERSON_ID IN NUMBER,
8 x_STATUS IN VARCHAR2,
9 x_FEE_TYPE IN VARCHAR2,
10 x_FEE_CAT IN VARCHAR2,
11 x_FEE_CAL_TYPE IN VARCHAR2,
12 x_FEE_CI_SEQUENCE_NUMBER IN NUMBER,
13 x_RUL_SEQUENCE_NUMBER IN NUMBER,
14 x_S_CHG_METHOD_TYPE IN VARCHAR2,
15 x_DESCRIPTION IN VARCHAR2,
16 x_CHG_ELEMENTS IN NUMBER,
17 x_AMOUNT IN NUMBER,
18 x_FEE_EFFECTIVE_DT IN DATE,
19 x_COURSE_CD IN VARCHAR2,
20 x_CRS_VERSION_NUMBER IN NUMBER,
21 x_COURSE_ATTEMPT_STATUS IN VARCHAR2,
22 x_ATTENDANCE_MODE IN VARCHAR2,
23 x_ATTENDANCE_TYPE IN VARCHAR2,
24 x_UNIT_ATTEMPT_STATUS IN VARCHAR2,
25 x_LOCATION_CD IN VARCHAR2,
26 x_EFTSU IN NUMBER,
27 x_CREDIT_POINTS IN NUMBER,
28 x_LOGICAL_DELETE_DATE IN DATE,
29 X_INVOICE_ID IN NUMBER DEFAULT NULL,
30 X_ORG_UNIT_CD IN VARCHAR2 DEFAULT NULL,
31 X_CLASS_STANDING IN VARCHAR2 DEFAULT NULL,
32 X_RESIDENCY_STATUS_CD IN VARCHAR2 DEFAULT NULL,
33 X_MODE in VARCHAR2 default 'R',
34 X_UOO_ID IN NUMBER DEFAULT NULL,
35 X_CHG_RATE IN VARCHAR2 DEFAULT NULL,
36 x_unit_set_cd IN VARCHAR2 DEFAULT NULL,
37 x_us_version_number IN NUMBER DEFAULT NULL,
38 x_unit_type_id IN NUMBER DEFAULT NULL,
39 x_unit_class IN VARCHAR2 DEFAULT NULL,
40 x_unit_mode IN VARCHAR2 DEFAULT NULL,
41 x_unit_level IN VARCHAR2 DEFAULT NULL,
42 x_scope_rul_sequence_num IN NUMBER DEFAULT NULL,
43 x_elm_rng_order_name IN VARCHAR2 DEFAULT NULL,
44 x_max_chg_elements IN NUMBER DEFAULT NULL
45 );
46
47 procedure LOCK_ROW (
48 X_ROWID in VARCHAR2,
49 x_FEE_ASS_ITEM_ID IN NUMBER,
50 x_TRANSACTION_ID IN NUMBER,
51 x_PERSON_ID IN NUMBER,
52 x_STATUS IN VARCHAR2,
53 x_FEE_TYPE IN VARCHAR2,
54 x_FEE_CAT IN VARCHAR2,
55 x_FEE_CAL_TYPE IN VARCHAR2,
56 x_FEE_CI_SEQUENCE_NUMBER IN NUMBER,
57 x_RUL_SEQUENCE_NUMBER IN NUMBER,
58 x_S_CHG_METHOD_TYPE IN VARCHAR2,
59 x_DESCRIPTION IN VARCHAR2,
60 x_CHG_ELEMENTS IN NUMBER,
61 x_AMOUNT IN NUMBER,
62 x_FEE_EFFECTIVE_DT IN DATE,
63 x_COURSE_CD IN VARCHAR2,
64 x_CRS_VERSION_NUMBER IN NUMBER,
65 x_COURSE_ATTEMPT_STATUS IN VARCHAR2,
66 x_ATTENDANCE_MODE IN VARCHAR2,
67 x_ATTENDANCE_TYPE IN VARCHAR2,
68 x_UNIT_ATTEMPT_STATUS IN VARCHAR2,
69 x_LOCATION_CD IN VARCHAR2,
70 x_EFTSU IN NUMBER,
71 x_CREDIT_POINTS IN NUMBER,
72 x_LOGICAL_DELETE_DATE IN DATE,
73 X_INVOICE_ID IN NUMBER DEFAULT NULL,
74 X_ORG_UNIT_CD IN VARCHAR2 DEFAULT NULL,
75 X_CLASS_STANDING IN VARCHAR2 DEFAULT NULL,
76 X_RESIDENCY_STATUS_CD IN VARCHAR2 DEFAULT NULL,
77 X_UOO_ID IN NUMBER DEFAULT NULL,
78 X_CHG_RATE IN VARCHAR2 DEFAULT NULL,
79 x_unit_set_cd IN VARCHAR2 DEFAULT NULL,
80 x_us_version_number IN NUMBER DEFAULT NULL,
81 x_unit_type_id IN NUMBER DEFAULT NULL,
82 x_unit_class IN VARCHAR2 DEFAULT NULL,
83 x_unit_mode IN VARCHAR2 DEFAULT NULL,
84 x_unit_level IN VARCHAR2 DEFAULT NULL,
85 x_scope_rul_sequence_num IN NUMBER DEFAULT NULL,
86 x_elm_rng_order_name IN VARCHAR2 DEFAULT NULL,
87 x_max_chg_elements IN NUMBER DEFAULT NULL
88 );
89
90 procedure UPDATE_ROW (
91 X_ROWID in VARCHAR2,
92 x_FEE_ASS_ITEM_ID IN NUMBER,
93 x_TRANSACTION_ID IN NUMBER,
94 x_PERSON_ID IN NUMBER,
95 x_STATUS IN VARCHAR2,
96 x_FEE_TYPE IN VARCHAR2,
97 x_FEE_CAT IN VARCHAR2,
98 x_FEE_CAL_TYPE IN VARCHAR2,
99 x_FEE_CI_SEQUENCE_NUMBER IN NUMBER,
100 x_RUL_SEQUENCE_NUMBER IN NUMBER,
101 x_S_CHG_METHOD_TYPE IN VARCHAR2,
102 x_DESCRIPTION IN VARCHAR2,
103 x_CHG_ELEMENTS IN NUMBER,
104 x_AMOUNT IN NUMBER,
105 x_FEE_EFFECTIVE_DT IN DATE,
106 x_COURSE_CD IN VARCHAR2,
107 x_CRS_VERSION_NUMBER IN NUMBER,
108 x_COURSE_ATTEMPT_STATUS IN VARCHAR2,
109 x_ATTENDANCE_MODE IN VARCHAR2,
110 x_ATTENDANCE_TYPE IN VARCHAR2,
111 x_UNIT_ATTEMPT_STATUS IN VARCHAR2,
112 x_LOCATION_CD IN VARCHAR2,
113 x_EFTSU IN NUMBER,
114 x_CREDIT_POINTS IN NUMBER,
115 x_LOGICAL_DELETE_DATE IN DATE,
116 X_INVOICE_ID IN NUMBER DEFAULT NULL,
117 X_ORG_UNIT_CD IN VARCHAR2 DEFAULT NULL,
118 X_CLASS_STANDING IN VARCHAR2 DEFAULT NULL,
119 X_RESIDENCY_STATUS_CD IN VARCHAR2 DEFAULT NULL,
120 X_MODE in VARCHAR2 default 'R' ,
121 X_UOO_ID IN NUMBER DEFAULT NULL,
122 X_CHG_RATE IN VARCHAR2 DEFAULT NULL,
123 x_unit_set_cd IN VARCHAR2 DEFAULT NULL,
124 x_us_version_number IN NUMBER DEFAULT NULL,
125 x_unit_type_id IN NUMBER DEFAULT NULL,
126 x_unit_class IN VARCHAR2 DEFAULT NULL,
127 x_unit_mode IN VARCHAR2 DEFAULT NULL,
128 x_unit_level IN VARCHAR2 DEFAULT NULL,
129 x_scope_rul_sequence_num IN NUMBER DEFAULT NULL,
130 x_elm_rng_order_name IN VARCHAR2 DEFAULT NULL,
131 x_max_chg_elements IN NUMBER DEFAULT NULL
132 );
133
134 procedure ADD_ROW (
135 X_ROWID in out NOCOPY VARCHAR2,
136 x_FEE_ASS_ITEM_ID IN OUT NOCOPY NUMBER,
137 x_TRANSACTION_ID IN NUMBER,
138 x_PERSON_ID IN NUMBER,
139 x_STATUS IN VARCHAR2,
140 x_FEE_TYPE IN VARCHAR2,
141 x_FEE_CAT IN VARCHAR2,
142 x_FEE_CAL_TYPE IN VARCHAR2,
143 x_FEE_CI_SEQUENCE_NUMBER IN NUMBER,
144 x_RUL_SEQUENCE_NUMBER IN NUMBER,
145 x_S_CHG_METHOD_TYPE IN VARCHAR2,
146 x_DESCRIPTION IN VARCHAR2,
147 x_CHG_ELEMENTS IN NUMBER,
148 x_AMOUNT IN NUMBER,
149 x_FEE_EFFECTIVE_DT IN DATE,
150 x_COURSE_CD IN VARCHAR2,
151 x_CRS_VERSION_NUMBER IN NUMBER,
152 x_COURSE_ATTEMPT_STATUS IN VARCHAR2,
153 x_ATTENDANCE_MODE IN VARCHAR2,
154 x_ATTENDANCE_TYPE IN VARCHAR2,
155 x_UNIT_ATTEMPT_STATUS IN VARCHAR2,
156 x_LOCATION_CD IN VARCHAR2,
157 x_EFTSU IN NUMBER,
158 x_CREDIT_POINTS IN NUMBER,
159 x_LOGICAL_DELETE_DATE IN DATE,
160 X_INVOICE_ID IN NUMBER DEFAULT NULL,
161 X_ORG_UNIT_CD IN VARCHAR2 DEFAULT NULL,
162 X_CLASS_STANDING IN VARCHAR2 DEFAULT NULL,
163 X_RESIDENCY_STATUS_CD IN VARCHAR2 DEFAULT NULL,
164 X_MODE in VARCHAR2 default 'R' ,
165 X_UOO_ID IN NUMBER DEFAULT NULL,
166 X_CHG_RATE IN VARCHAR2 DEFAULT NULL,
167 x_unit_set_cd IN VARCHAR2 DEFAULT NULL,
168 x_us_version_number IN NUMBER DEFAULT NULL,
169 x_unit_type_id IN NUMBER DEFAULT NULL,
170 x_unit_class IN VARCHAR2 DEFAULT NULL,
171 x_unit_mode IN VARCHAR2 DEFAULT NULL,
172 x_unit_level IN VARCHAR2 DEFAULT NULL,
173 x_scope_rul_sequence_num IN NUMBER DEFAULT NULL,
174 x_elm_rng_order_name IN VARCHAR2 DEFAULT NULL,
175 x_max_chg_elements IN NUMBER DEFAULT NULL
176 ) ;
177
178 procedure DELETE_ROW (
179 X_ROWID in VARCHAR2
180 ) ;
181
182
183 FUNCTION Get_PK_For_Validation (
184 x_fee_ass_item_id IN NUMBER
185 ) RETURN BOOLEAN ;
186
187
188 FUNCTION Get_UK_For_Validation (
189 x_TRANSACTION_ID IN NUMBER,
190 x_person_id IN NUMBER,
191 x_location_cd IN VARCHAR2,
192 x_course_cd IN VARCHAR2,
193 x_crs_version_number IN NUMBER,
194 x_fee_cal_type IN VARCHAR2,
195 x_fee_cat IN VARCHAR2,
196 x_fee_ci_sequence_number IN NUMBER,
197 x_fee_type IN VARCHAR2,
198 X_UOO_ID IN NUMBER DEFAULT NULL,
199 x_org_unit_cd IN VARCHAR2 DEFAULT NULL
200 ) RETURN BOOLEAN;
201
202 PROCEDURE Check_Constraints (
203 Column_Name IN VARCHAR2 DEFAULT NULL,
204 Column_Value IN VARCHAR2 DEFAULT NULL ) ;
205
206
207 PROCEDURE GET_FK_IGS_FI_FEE_AS (
208 x_person_id IN NUMBER,
209 x_transaction_id IN NUMBER
210 );
211
212
213 PROCEDURE Before_DML (
214 p_action IN VARCHAR2,
215 x_rowid IN VARCHAR2 DEFAULT NULL,
216 x_fee_ass_item_id IN NUMBER DEFAULT NULL,
217 x_TRANSACTION_ID IN NUMBER DEFAULT NULL,
218 x_person_id IN NUMBER DEFAULT NULL,
219 x_status IN VARCHAR2 DEFAULT NULL,
220 x_fee_type IN VARCHAR2 DEFAULT NULL,
221 x_fee_cat IN VARCHAR2 DEFAULT NULL,
222 x_fee_cal_type IN VARCHAR2 DEFAULT NULL,
223 x_fee_ci_sequence_number IN NUMBER DEFAULT NULL,
224 x_RUL_SEQUENCE_NUMBER IN NUMBER DEFAULT NULL,
225 x_s_chg_method_type IN VARCHAR2 DEFAULT NULL,
226 x_description IN VARCHAR2 DEFAULT NULL,
227 x_chg_elements IN NUMBER DEFAULT NULL,
228 x_amount IN NUMBER DEFAULT NULL,
229 x_fee_effective_dt IN DATE DEFAULT NULL,
230 x_course_cd IN VARCHAR2 DEFAULT NULL,
231 x_crs_version_number IN NUMBER DEFAULT NULL,
232 x_course_attempt_status IN VARCHAR2 DEFAULT NULL,
233 x_attendance_mode IN VARCHAR2 DEFAULT NULL,
234 x_attendance_type IN VARCHAR2 DEFAULT NULL,
235 x_unit_attempt_status IN VARCHAR2 DEFAULT NULL,
236 x_location_cd IN VARCHAR2 DEFAULT NULL,
237 x_eftsu IN NUMBER DEFAULT NULL,
238 x_credit_points IN NUMBER DEFAULT NULL,
239 x_logical_delete_date IN DATE DEFAULT NULL,
240 X_INVOICE_ID IN NUMBER DEFAULT NULL,
241 X_ORG_UNIT_CD IN VARCHAR2 DEFAULT NULL,
242 X_CLASS_STANDING IN VARCHAR2 DEFAULT NULL,
243 X_RESIDENCY_STATUS_CD IN VARCHAR2 DEFAULT NULL,
244 x_creation_date IN DATE DEFAULT NULL,
245 x_created_by IN NUMBER DEFAULT NULL,
246 x_last_update_date IN DATE DEFAULT NULL,
247 x_last_updated_by IN NUMBER DEFAULT NULL,
248 x_last_update_login IN NUMBER DEFAULT NULL,
249 X_UOO_ID IN NUMBER DEFAULT NULL,
250 X_CHG_RATE IN VARCHAR2 DEFAULT NULL,
251 x_unit_set_cd IN VARCHAR2 DEFAULT NULL,
252 x_us_version_number IN NUMBER DEFAULT NULL,
253 x_unit_type_id IN NUMBER DEFAULT NULL,
254 x_unit_class IN VARCHAR2 DEFAULT NULL,
255 x_unit_mode IN VARCHAR2 DEFAULT NULL,
256 x_unit_level IN VARCHAR2 DEFAULT NULL,
257 x_scope_rul_sequence_num IN NUMBER DEFAULT NULL,
258 x_elm_rng_order_name IN VARCHAR2 DEFAULT NULL,
259 x_max_chg_elements IN NUMBER DEFAULT NULL
260 );
261
262 PROCEDURE get_fk_igs_en_unit_set_all (
263 x_unit_set_cd IN VARCHAR2,
264 x_us_version_number IN NUMBER
265 );
266
267 END igs_fi_fee_as_items_pkg;