[Home] [Help]
PACKAGE BODY: APPS.ARP_CPC_PKG
Source
1 PACKAGE BODY ARP_CPC_PKG as
2 /* $Header: AROCPCB.pls 120.1 2005/08/11 00:50:14 hyu noship $ */
3
4 --
5 PROCEDURE sel_class (x_customer_profile_class_id IN NUMBER,
6 x_collector_id IN OUT NOCOPY NUMBER,
7 x_collector_name IN OUT NOCOPY VARCHAR2,
8 x_credit_checking IN OUT NOCOPY VARCHAR2,
9 x_tolerance IN OUT NOCOPY VARCHAR2,
10 x_interest_charges IN OUT NOCOPY VARCHAR2,
11 x_charge_on_fin_charge_flag IN OUT NOCOPY VARCHAR2,
12 x_interest_period_days IN OUT NOCOPY NUMBER,
13 x_discount_terms IN OUT NOCOPY VARCHAR2,
14 x_discount_grace_days IN OUT NOCOPY NUMBER,
15 x_statements IN OUT NOCOPY VARCHAR2,
16 x_statement_cycle_id IN OUT NOCOPY NUMBER,
17 x_statement_cycle_name IN OUT NOCOPY VARCHAR2,
18 x_credit_balance_statements IN OUT NOCOPY VARCHAR2,
19 x_standard_terms IN OUT NOCOPY NUMBER,
20 x_standard_terms_name IN OUT NOCOPY VARCHAR2,
21 x_override_terms IN OUT NOCOPY VARCHAR2,
22 x_payment_grace_days IN OUT NOCOPY NUMBER,
23 x_dunning_letters IN OUT NOCOPY VARCHAR2,
24 x_dunning_letter_set_id IN OUT NOCOPY NUMBER,
25 x_dunning_letter_set_name IN OUT NOCOPY VARCHAR2,
26 x_autocash_hierarchy_id IN OUT NOCOPY NUMBER,
27 x_autocash_hierarchy_name IN OUT NOCOPY VARCHAR2,
28 x_auto_rec_incl_disputed_flag IN OUT NOCOPY VARCHAR2,
29 x_tax_printing_option IN OUT NOCOPY VARCHAR2,
30 x_grouping_rule_id IN OUT NOCOPY VARCHAR2,
31 x_grouping_rule_name IN OUT NOCOPY VARCHAR2,
32 x_attribute_category IN OUT NOCOPY VARCHAR2,
33 x_attribute1 IN OUT NOCOPY VARCHAR2,
34 x_attribute2 IN OUT NOCOPY VARCHAR2,
35 x_attribute3 IN OUT NOCOPY VARCHAR2,
36 x_attribute4 IN OUT NOCOPY VARCHAR2,
37 x_attribute5 IN OUT NOCOPY VARCHAR2,
38 x_attribute6 IN OUT NOCOPY VARCHAR2,
39 x_attribute7 IN OUT NOCOPY VARCHAR2,
40 x_attribute8 IN OUT NOCOPY VARCHAR2,
41 x_attribute9 IN OUT NOCOPY VARCHAR2,
42 x_attribute10 IN OUT NOCOPY VARCHAR2,
43 x_attribute11 IN OUT NOCOPY VARCHAR2,
44 x_attribute12 IN OUT NOCOPY VARCHAR2,
45 x_attribute13 IN OUT NOCOPY VARCHAR2,
46 x_attribute14 IN OUT NOCOPY VARCHAR2,
47 x_attribute15 IN OUT NOCOPY VARCHAR2
48 )
49 IS
50 BEGIN
51 NULL;
52 END sel_class;
53 --
54 --
55 PROCEDURE check_unique (c_profile_class_name in varchar2, c_rowid in varchar2) is
56 BEGIN
57 NULL;
58 END check_unique;
59 --
60 --
61
62 PROCEDURE Insert_Row (X_Row_Id IN OUT NOCOPY VARCHAR2,
63 X_Customer_Profile_Class_Id IN OUT NOCOPY NUMBER,
64 X_Last_Updated_By NUMBER,
65 X_Last_Update_Date DATE,
66 X_Last_Update_Login NUMBER,
67 X_Created_By NUMBER,
68 X_Creation_Date DATE,
69 X_Profile_Class_Name VARCHAR2,
70 X_Profile_Class_Description VARCHAR2,
71 X_Status VARCHAR2,
72 X_Collector_Id NUMBER,
73 X_Credit_Checking VARCHAR2,
74 X_Tolerance NUMBER,
75 X_Interest_Charges VARCHAR2,
76 X_Charge_On_Finance_Charge_Flg VARCHAR2,
77 X_Interest_Period_Days NUMBER,
78 X_Discount_Terms VARCHAR2,
79 X_Discount_Grace_Days NUMBER,
80 X_Statements VARCHAR2,
81 X_Statement_Cycle_Id NUMBER,
82 X_Credit_Balance_Statements VARCHAR2,
83 X_Standard_Terms NUMBER,
84 X_Override_Terms VARCHAR2,
85 X_Payment_Grace_Days NUMBER,
86 X_Dunning_Letters VARCHAR2,
87 X_Dunning_Letter_Set_Id NUMBER,
88 X_Autocash_Hierarchy_Id NUMBER,
89 X_Copy_Method VARCHAR2,
90 X_Auto_Rec_Incl_Disputed_Flag VARCHAR2,
91 X_Tax_Printing_Option VARCHAR2,
92 X_Tax_Printing_Option_Meaning VARCHAR2,
93 X_Grouping_Rule_Id NUMBER,
94 X_Cons_Inv_Flag VARCHAR2,
95 X_Cons_Inv_Type VARCHAR2,
96 X_Request_Id NUMBER,
97 X_Attribute_Category VARCHAR2,
98 X_Attribute1 VARCHAR2,
99 X_Attribute2 VARCHAR2,
100 X_Attribute3 VARCHAR2,
101 X_Attribute4 VARCHAR2,
102 X_Attribute5 VARCHAR2,
103 X_Attribute6 VARCHAR2,
104 X_Attribute7 VARCHAR2,
105 X_Attribute8 VARCHAR2,
106 X_Attribute9 VARCHAR2,
107 X_Attribute10 VARCHAR2,
108 X_Attribute11 VARCHAR2,
109 X_Attribute12 VARCHAR2,
110 X_Attribute13 VARCHAR2,
111 X_Attribute14 VARCHAR2,
112 X_Attribute15 VARCHAR2,
113 X_Jgzz_attribute_Category VARCHAR2,
114 X_Jgzz_attribute1 VARCHAR2,
115 X_Jgzz_attribute2 VARCHAR2,
116 X_Jgzz_attribute3 VARCHAR2,
117 X_Jgzz_attribute4 VARCHAR2,
118 X_Jgzz_attribute5 VARCHAR2,
119 X_Jgzz_attribute6 VARCHAR2,
120 X_Jgzz_attribute7 VARCHAR2,
121 X_Jgzz_attribute8 VARCHAR2,
122 X_Jgzz_attribute9 VARCHAR2,
123 X_Jgzz_attribute10 VARCHAR2,
124 X_Jgzz_attribute11 VARCHAR2,
125 X_Jgzz_attribute12 VARCHAR2,
126 X_Jgzz_attribute13 VARCHAR2,
127 X_Jgzz_attribute14 VARCHAR2,
128 X_Jgzz_attribute15 VARCHAR2,
129 X_global_attribute_category VARCHAR2,
130 X_global_attribute1 VARCHAR2,
131 X_global_attribute2 VARCHAR2,
132 X_global_attribute3 VARCHAR2,
133 X_global_attribute4 VARCHAR2,
134 X_global_attribute5 VARCHAR2,
135 X_global_attribute6 VARCHAR2,
136 X_global_attribute7 VARCHAR2,
137 X_global_attribute8 VARCHAR2,
138 X_global_attribute9 VARCHAR2,
139 X_global_attribute10 VARCHAR2,
140 X_global_attribute11 VARCHAR2,
141 X_global_attribute12 VARCHAR2,
142 X_global_attribute13 VARCHAR2,
143 X_global_attribute14 VARCHAR2,
144 X_global_attribute15 VARCHAR2,
145 X_global_attribute16 VARCHAR2,
146 X_global_attribute17 VARCHAR2,
147 X_global_attribute18 VARCHAR2,
148 X_global_attribute19 VARCHAR2,
149 X_global_attribute20 VARCHAR2,
150 X_lockbox_matching_option VARCHAR2,
151 X_autocash_hierarchy_id_adr NUMBER
152
153 )
154 IS
155 BEGIN
156 NULL;
157 END Insert_Row;
158
159
160 PROCEDURE Lock_Row (X_Row_Id VARCHAR2,
161 X_Customer_Profile_Class_Id NUMBER,
165 X_Collector_Id NUMBER,
162 X_Profile_Class_Name VARCHAR2,
163 X_Profile_Class_Description VARCHAR2,
164 X_Status VARCHAR2,
166 X_Credit_Checking VARCHAR2,
167 X_Tolerance NUMBER,
168 X_Interest_Charges VARCHAR2,
169 X_Charge_On_Finance_Charge_Flg VARCHAR2,
170 X_Interest_Period_Days NUMBER,
171 X_Discount_Terms VARCHAR2,
172 X_Discount_Grace_Days NUMBER,
173 X_Statements VARCHAR2,
174 X_Statement_Cycle_Id NUMBER,
175 X_Credit_Balance_Statements VARCHAR2,
176 X_Standard_Terms NUMBER,
177 X_Override_Terms VARCHAR2,
178 X_Payment_Grace_Days NUMBER,
179 X_Dunning_Letters VARCHAR2,
180 X_Dunning_Letter_Set_Id NUMBER,
181 X_Autocash_Hierarchy_Id NUMBER,
182 X_Copy_Method VARCHAR2,
183 X_Auto_Rec_Incl_Disputed_Flag VARCHAR2,
184 X_Tax_Printing_Option VARCHAR2,
185 X_Tax_Printing_Option_Meaning VARCHAR2,
186 X_Grouping_Rule_Id NUMBER,
187 X_Cons_Inv_Flag VARCHAR2,
188 X_Cons_Inv_Type VARCHAR2,
189 X_Request_Id NUMBER,
190 X_Attribute_Category VARCHAR2,
191 X_Attribute1 VARCHAR2,
192 X_Attribute2 VARCHAR2,
193 X_Attribute3 VARCHAR2,
194 X_Attribute4 VARCHAR2,
195 X_Attribute5 VARCHAR2,
196 X_Attribute6 VARCHAR2,
197 X_Attribute7 VARCHAR2,
198 X_Attribute8 VARCHAR2,
199 X_Attribute9 VARCHAR2,
200 X_Attribute10 VARCHAR2,
201 X_Attribute11 VARCHAR2,
202 X_Attribute12 VARCHAR2,
203 X_Attribute13 VARCHAR2,
204 X_Attribute14 VARCHAR2,
205 X_Attribute15 VARCHAR2,
206 X_Jgzz_attribute_Category VARCHAR2,
207 X_Jgzz_attribute1 VARCHAR2,
208 X_Jgzz_attribute2 VARCHAR2,
209 X_Jgzz_attribute3 VARCHAR2,
210 X_Jgzz_attribute4 VARCHAR2,
211 X_Jgzz_attribute5 VARCHAR2,
212 X_Jgzz_attribute6 VARCHAR2,
213 X_Jgzz_attribute7 VARCHAR2,
214 X_Jgzz_attribute8 VARCHAR2,
215 X_Jgzz_attribute9 VARCHAR2,
216 X_Jgzz_attribute10 VARCHAR2,
217 X_Jgzz_attribute11 VARCHAR2,
218 X_Jgzz_attribute12 VARCHAR2,
219 X_Jgzz_attribute13 VARCHAR2,
220 X_Jgzz_attribute14 VARCHAR2,
221 X_Jgzz_attribute15 VARCHAR2,
222 X_global_attribute_category VARCHAR2,
223 X_global_attribute1 VARCHAR2,
227 X_global_attribute5 VARCHAR2,
224 X_global_attribute2 VARCHAR2,
225 X_global_attribute3 VARCHAR2,
226 X_global_attribute4 VARCHAR2,
228 X_global_attribute6 VARCHAR2,
229 X_global_attribute7 VARCHAR2,
230 X_global_attribute8 VARCHAR2,
231 X_global_attribute9 VARCHAR2,
232 X_global_attribute10 VARCHAR2,
233 X_global_attribute11 VARCHAR2,
234 X_global_attribute12 VARCHAR2,
235 X_global_attribute13 VARCHAR2,
236 X_global_attribute14 VARCHAR2,
237 X_global_attribute15 VARCHAR2,
238 X_global_attribute16 VARCHAR2,
239 X_global_attribute17 VARCHAR2,
240 X_global_attribute18 VARCHAR2,
241 X_global_attribute19 VARCHAR2,
242 X_global_attribute20 VARCHAR2,
243 X_lockbox_matching_option VARCHAR2,
244 X_autocash_hierarchy_id_adr NUMBER
245 )
246 IS
247 BEGIN
248 NULL;
249 END Lock_Row;
250
251
252
253 PROCEDURE Update_Row (X_Row_Id IN OUT NOCOPY VARCHAR2,
254 X_Customer_Profile_Class_Id IN OUT NOCOPY NUMBER,
255 X_Last_Updated_By NUMBER,
256 X_Last_Update_Date DATE,
257 X_Last_Update_Login NUMBER,
258 X_Profile_Class_Name VARCHAR2,
259 X_Profile_Class_Description VARCHAR2,
260 X_Status VARCHAR2,
261 X_Collector_Id NUMBER,
262 X_Credit_Checking VARCHAR2,
263 X_Tolerance NUMBER,
264 X_Interest_Charges VARCHAR2,
265 X_Charge_On_Finance_Charge_Flg VARCHAR2,
266 X_Interest_Period_Days NUMBER,
267 X_Discount_Terms VARCHAR2,
268 X_Discount_Grace_Days NUMBER,
269 X_Statements VARCHAR2,
270 X_Statement_Cycle_Id NUMBER,
271 X_Credit_Balance_Statements VARCHAR2,
272 X_Standard_Terms NUMBER,
273 X_Override_Terms VARCHAR2,
277 X_Autocash_Hierarchy_Id NUMBER,
274 X_Payment_Grace_Days NUMBER,
275 X_Dunning_Letters VARCHAR2,
276 X_Dunning_Letter_Set_Id NUMBER,
278 X_Copy_Method VARCHAR2,
279 X_Auto_Rec_Incl_Disputed_Flag VARCHAR2,
280 X_Tax_Printing_Option VARCHAR2,
281 X_Tax_Printing_Option_Meaning VARCHAR2,
282 X_Grouping_Rule_Id NUMBER,
283 X_Cons_Inv_Flag VARCHAR2,
284 X_Cons_Inv_Type VARCHAR2,
285 X_Request_Id NUMBER,
286 X_Attribute_Category VARCHAR2,
287 X_Attribute1 VARCHAR2,
288 X_Attribute2 VARCHAR2,
289 X_Attribute3 VARCHAR2,
290 X_Attribute4 VARCHAR2,
291 X_Attribute5 VARCHAR2,
292 X_Attribute6 VARCHAR2,
293 X_Attribute7 VARCHAR2,
294 X_Attribute8 VARCHAR2,
295 X_Attribute9 VARCHAR2,
296 X_Attribute10 VARCHAR2,
297 X_Attribute11 VARCHAR2,
298 X_Attribute12 VARCHAR2,
299 X_Attribute13 VARCHAR2,
300 X_Attribute14 VARCHAR2,
301 X_Attribute15 VARCHAR2,
302 X_Jgzz_attribute_Category VARCHAR2,
303 X_Jgzz_attribute1 VARCHAR2,
304 X_Jgzz_attribute2 VARCHAR2,
305 X_Jgzz_attribute3 VARCHAR2,
306 X_Jgzz_attribute4 VARCHAR2,
307 X_Jgzz_attribute5 VARCHAR2,
308 X_Jgzz_attribute6 VARCHAR2,
309 X_Jgzz_attribute7 VARCHAR2,
310 X_Jgzz_attribute8 VARCHAR2,
311 X_Jgzz_attribute9 VARCHAR2,
312 X_Jgzz_attribute10 VARCHAR2,
313 X_Jgzz_attribute11 VARCHAR2,
314 X_Jgzz_attribute12 VARCHAR2,
315 X_Jgzz_attribute13 VARCHAR2,
316 X_Jgzz_attribute14 VARCHAR2,
317 X_Jgzz_attribute15 VARCHAR2,
318 X_global_attribute_category VARCHAR2,
319 X_global_attribute1 VARCHAR2,
320 X_global_attribute2 VARCHAR2,
321 X_global_attribute3 VARCHAR2,
322 X_global_attribute4 VARCHAR2,
323 X_global_attribute5 VARCHAR2,
324 X_global_attribute6 VARCHAR2,
325 X_global_attribute7 VARCHAR2,
326 X_global_attribute8 VARCHAR2,
327 X_global_attribute9 VARCHAR2,
328 X_global_attribute10 VARCHAR2,
329 X_global_attribute11 VARCHAR2,
330 X_global_attribute12 VARCHAR2,
331 X_global_attribute13 VARCHAR2,
332 X_global_attribute14 VARCHAR2,
336 X_global_attribute18 VARCHAR2,
333 X_global_attribute15 VARCHAR2,
334 X_global_attribute16 VARCHAR2,
335 X_global_attribute17 VARCHAR2,
337 X_global_attribute19 VARCHAR2,
338 X_global_attribute20 VARCHAR2,
339 X_lockbox_matching_option VARCHAR2,
340 X_autocash_hierarchy_id_adr NUMBER
341
342 ) IS
343 BEGIN
344 NULL;
345 END Update_Row;
346
347 PROCEDURE Delete_Row(X_Row_Id VARCHAR2) IS
348 BEGIN
349 NULL;
350 END Delete_Row;
351
352
353 PROCEDURE compute_negative_id (X_Customer_Profile_Class_Id Number,
354 X_Negative_Id IN OUT NOCOPY Number,
355 Notify_Flag IN OUT NOCOPY varchar2)
356 IS
357 BEGIN
358 NULL;
359 END compute_negative_id;
360 --
361 --
362 PROCEDURE insert_negative_row (X_Customer_Profile_Class_Id Number,
363 X_Negative_Id Number,
364 X_Update_Options Varchar2)
365 IS
366 BEGIN
367 NULL;
368 END insert_negative_row;
369 --
370
371 END ARP_CPC_PKG;