[Home] [Help]
PACKAGE BODY: APPS.ARP_CPROF_PKG
Source
1 PACKAGE BODY arp_cprof_pkg as
2 /* $Header: AROCPRFB.pls 120.1 2005/08/11 00:57:09 hyu noship $ */
3 --
4 --
5 PROCEDURE check_unique ( p_customer_id in number,
6 p_site_use_id in number
7 ) is
8 BEGIN
9 NULL;
10 end check_unique;
11 --
12 --
13 PROCEDURE update_customer_alt_names(p_rowid in varchar2,
14 p_standard_terms in number,
15 p_customer_id in number,
16 p_site_use_id in number
17 ) is
18 begin
19 NULL;
20 end update_customer_alt_names;
21 --
22 --
23 --
24 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
25 X_Customer_Profile_Id IN OUT NOCOPY NUMBER,
26 X_Auto_Rec_Incl_Disputed_Flag VARCHAR2,
27 X_Collector_Id NUMBER,
28 X_Created_By NUMBER,
29 X_Creation_Date DATE,
30 X_Credit_Balance_Statements VARCHAR2,
31 X_Credit_Checking VARCHAR2,
32 X_Credit_Hold VARCHAR2,
33 X_Customer_Id NUMBER,
34 X_Discount_Terms VARCHAR2,
35 X_Dunning_Letters VARCHAR2,
36 X_Interest_Charges VARCHAR2,
37 X_Last_Updated_By NUMBER,
38 X_Last_Update_Date DATE,
39 X_Statements VARCHAR2,
40 X_Status VARCHAR2,
41 X_Tolerance NUMBER,
42 X_Tax_Printing_Option VARCHAR2,
43 X_Account_Status VARCHAR2,
44 X_Autocash_Hierarchy_Id NUMBER,
45 X_Credit_Rating VARCHAR2,
46 X_Customer_Profile_Class_Id NUMBER,
47 X_Discount_Grace_Days NUMBER,
48 X_Dunning_Letter_Set_Id NUMBER,
49 X_Interest_Period_Days NUMBER,
50 X_Last_Update_Login NUMBER,
51 X_Override_Terms VARCHAR2,
52 X_Payment_Grace_Days NUMBER,
53 X_Percent_Collectable NUMBER,
54 X_Risk_Code VARCHAR2,
55 X_Site_Use_Id NUMBER,
56 X_Standard_Terms NUMBER,
57 X_Statement_Cycle_Id NUMBER,
58 X_Attribute_Category VARCHAR2,
59 X_Attribute1 VARCHAR2,
60 X_Attribute2 VARCHAR2,
61 X_Attribute3 VARCHAR2,
62 X_Attribute4 VARCHAR2,
63 X_Attribute5 VARCHAR2,
64 X_Attribute6 VARCHAR2,
65 X_Attribute7 VARCHAR2,
66 X_Attribute8 VARCHAR2,
67 X_Attribute9 VARCHAR2,
68 X_Attribute10 VARCHAR2,
69 X_Attribute11 VARCHAR2,
70 X_Attribute12 VARCHAR2,
71 X_Attribute13 VARCHAR2,
72 X_Attribute14 VARCHAR2,
73 X_Attribute15 VARCHAR2,
74 X_Charge_On_Fin_Charge_Flag VARCHAR2,
75 X_Grouping_Rule_Id NUMBER,
76 X_Cons_Inv_Flag VARCHAR2,
77 X_Cons_Inv_Type VARCHAR2,
78 X_Clearing_Days NUMBER,
79 X_Jgzz_attribute_Category VARCHAR2,
80 X_Jgzz_attribute1 VARCHAR2,
81 X_Jgzz_attribute2 VARCHAR2,
82 X_Jgzz_attribute3 VARCHAR2,
83 X_Jgzz_attribute4 VARCHAR2,
84 X_Jgzz_attribute5 VARCHAR2,
85 X_Jgzz_attribute6 VARCHAR2,
86 X_Jgzz_attribute7 VARCHAR2,
87 X_Jgzz_attribute8 VARCHAR2,
88 X_Jgzz_attribute9 VARCHAR2,
89 X_Jgzz_attribute10 VARCHAR2,
90 X_Jgzz_attribute11 VARCHAR2,
91 X_Jgzz_attribute12 VARCHAR2,
92 X_Jgzz_attribute13 VARCHAR2,
93 X_Jgzz_attribute14 VARCHAR2,
94 X_Jgzz_attribute15 VARCHAR2,
95 X_global_attribute_category VARCHAR2,
96 X_global_attribute1 VARCHAR2,
97 X_global_attribute2 VARCHAR2,
98 X_global_attribute3 VARCHAR2,
99 X_global_attribute4 VARCHAR2,
100 X_global_attribute5 VARCHAR2,
101 X_global_attribute6 VARCHAR2,
102 X_global_attribute7 VARCHAR2,
103 X_global_attribute8 VARCHAR2,
104 X_global_attribute9 VARCHAR2,
105 X_global_attribute10 VARCHAR2,
106 X_global_attribute11 VARCHAR2,
107 X_global_attribute12 VARCHAR2,
108 X_global_attribute13 VARCHAR2,
109 X_global_attribute14 VARCHAR2,
110 X_global_attribute15 VARCHAR2,
111 X_global_attribute16 VARCHAR2,
112 X_global_attribute17 VARCHAR2,
113 X_global_attribute18 VARCHAR2,
114 X_global_attribute19 VARCHAR2,
115 X_global_attribute20 VARCHAR2,
116 X_lockbox_matching_option VARCHAR2,
117 X_autocash_hierarchy_id_adr NUMBER
118 ) IS
119 BEGIN
120 NULL;
121 END Insert_Row;
122
123
124 procedure insert_row( x_customer_id number,
125 x_site_use_id number,
126 x_customer_profile_class_id number ) is
127 begin
128 NULL;
129 end insert_row;
130 --
131 --
132 --
133 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
134 X_Customer_Profile_Id NUMBER,
135 X_Auto_Rec_Incl_Disputed_Flag VARCHAR2,
136 X_Collector_Id NUMBER,
137 X_Credit_Balance_Statements VARCHAR2,
138 X_Credit_Checking VARCHAR2,
139 X_Credit_Hold VARCHAR2,
140 X_Customer_Id NUMBER,
141 X_Discount_Terms VARCHAR2,
142 X_Dunning_Letters VARCHAR2,
143 X_Interest_Charges VARCHAR2,
144 X_Statements VARCHAR2,
145 X_Status VARCHAR2,
146 X_Tolerance NUMBER,
147 X_Tax_Printing_Option VARCHAR2,
148 X_Account_Status VARCHAR2,
149 X_Autocash_Hierarchy_Id NUMBER,
150 X_Credit_Rating VARCHAR2,
151 X_Customer_Profile_Class_Id NUMBER,
152 X_Discount_Grace_Days NUMBER,
153 X_Dunning_Letter_Set_Id NUMBER,
154 X_Interest_Period_Days NUMBER,
155 X_Override_Terms VARCHAR2,
156 X_Payment_Grace_Days NUMBER,
157 X_Percent_Collectable NUMBER,
158 X_Risk_Code VARCHAR2,
159 X_Standard_Terms NUMBER,
160 X_Statement_Cycle_Id NUMBER,
161 X_Attribute_Category VARCHAR2,
162 X_Attribute1 VARCHAR2,
163 X_Attribute2 VARCHAR2,
164 X_Attribute3 VARCHAR2,
165 X_Attribute4 VARCHAR2,
166 X_Attribute5 VARCHAR2,
167 X_Attribute6 VARCHAR2,
168 X_Attribute7 VARCHAR2,
169 X_Attribute8 VARCHAR2,
170 X_Attribute9 VARCHAR2,
171 X_Attribute10 VARCHAR2,
172 X_Attribute11 VARCHAR2,
173 X_Attribute12 VARCHAR2,
174 X_Attribute13 VARCHAR2,
175 X_Attribute14 VARCHAR2,
176 X_Attribute15 VARCHAR2,
177 X_Charge_On_Fin_Charge_Flag VARCHAR2,
178 X_Grouping_Rule_Id NUMBER,
179 X_Cons_Inv_Flag VARCHAR2,
180 X_Cons_Inv_Type VARCHAR2,
181 X_Clearing_Days NUMBER,
182 X_Jgzz_attribute_Category VARCHAR2,
183 X_Jgzz_attribute1 VARCHAR2,
184 X_Jgzz_attribute2 VARCHAR2,
185 X_Jgzz_attribute3 VARCHAR2,
186 X_Jgzz_attribute4 VARCHAR2,
187 X_Jgzz_attribute5 VARCHAR2,
188 X_Jgzz_attribute6 VARCHAR2,
189 X_Jgzz_attribute7 VARCHAR2,
190 X_Jgzz_attribute8 VARCHAR2,
191 X_Jgzz_attribute9 VARCHAR2,
192 X_Jgzz_attribute10 VARCHAR2,
193 X_Jgzz_attribute11 VARCHAR2,
194 X_Jgzz_attribute12 VARCHAR2,
195 X_Jgzz_attribute13 VARCHAR2,
196 X_Jgzz_attribute14 VARCHAR2,
197 X_Jgzz_attribute15 VARCHAR2,
198 X_global_attribute_category VARCHAR2,
199 X_global_attribute1 VARCHAR2,
200 X_global_attribute2 VARCHAR2,
201 X_global_attribute3 VARCHAR2,
202 X_global_attribute4 VARCHAR2,
203 X_global_attribute5 VARCHAR2,
204 X_global_attribute6 VARCHAR2,
205 X_global_attribute7 VARCHAR2,
206 X_global_attribute8 VARCHAR2,
207 X_global_attribute9 VARCHAR2,
208 X_global_attribute10 VARCHAR2,
209 X_global_attribute11 VARCHAR2,
210 X_global_attribute12 VARCHAR2,
211 X_global_attribute13 VARCHAR2,
212 X_global_attribute14 VARCHAR2,
213 X_global_attribute15 VARCHAR2,
214 X_global_attribute16 VARCHAR2,
215 X_global_attribute17 VARCHAR2,
216 X_global_attribute18 VARCHAR2,
217 X_global_attribute19 VARCHAR2,
218 X_global_attribute20 VARCHAR2,
219 X_lockbox_matching_option VARCHAR2,
220 X_autocash_hierarchy_id_adr NUMBER
221 )
222 IS
223 BEGIN
224 NULL;
225 END Lock_Row;
226 --
227 --
228 --
229 PROCEDURE Update_Row(X_Rowid VARCHAR2,
230 X_Customer_Profile_Id NUMBER,
231 X_Auto_Rec_Incl_Disputed_Flag VARCHAR2,
232 X_Collector_Id NUMBER,
233 X_Credit_Balance_Statements VARCHAR2,
234 X_Credit_Checking VARCHAR2,
235 X_Credit_Hold VARCHAR2,
236 X_Customer_Id NUMBER,
237 X_Discount_Terms VARCHAR2,
238 X_Dunning_Letters VARCHAR2,
239 X_Interest_Charges VARCHAR2,
240 X_Last_Updated_By NUMBER,
241 X_Last_Update_Date DATE,
242 X_Statements VARCHAR2,
243 X_Status VARCHAR2,
244 X_Tolerance NUMBER,
245 X_Tax_Printing_Option VARCHAR2,
246 X_Account_Status VARCHAR2,
247 X_Autocash_Hierarchy_Id NUMBER,
248 X_Credit_Rating VARCHAR2,
249 X_Customer_Profile_Class_Id NUMBER,
250 X_Discount_Grace_Days NUMBER,
251 X_Dunning_Letter_Set_Id NUMBER,
252 X_Interest_Period_Days NUMBER,
253 X_Last_Update_Login NUMBER,
254 X_Override_Terms VARCHAR2,
255 X_Payment_Grace_Days NUMBER,
256 X_Percent_Collectable NUMBER,
257 X_Risk_Code VARCHAR2,
258 X_Site_Use_Id NUMBER,
259 X_Standard_Terms NUMBER,
260 X_Statement_Cycle_Id NUMBER,
261 X_Attribute_Category VARCHAR2,
262 X_Attribute1 VARCHAR2,
263 X_Attribute2 VARCHAR2,
264 X_Attribute3 VARCHAR2,
265 X_Attribute4 VARCHAR2,
266 X_Attribute5 VARCHAR2,
267 X_Attribute6 VARCHAR2,
268 X_Attribute7 VARCHAR2,
269 X_Attribute8 VARCHAR2,
270 X_Attribute9 VARCHAR2,
271 X_Attribute10 VARCHAR2,
272 X_Attribute11 VARCHAR2,
273 X_Attribute12 VARCHAR2,
277 X_Charge_On_Fin_Charge_Flag VARCHAR2,
274 X_Attribute13 VARCHAR2,
275 X_Attribute14 VARCHAR2,
276 X_Attribute15 VARCHAR2,
278 X_Grouping_Rule_Id NUMBER,
279 X_Cons_Inv_Flag VARCHAR2,
280 X_Cons_Inv_Type VARCHAR2,
281 X_Clearing_Days NUMBER,
282 X_Jgzz_attribute_Category VARCHAR2,
283 X_Jgzz_attribute1 VARCHAR2,
284 X_Jgzz_attribute2 VARCHAR2,
285 X_Jgzz_attribute3 VARCHAR2,
286 X_Jgzz_attribute4 VARCHAR2,
287 X_Jgzz_attribute5 VARCHAR2,
288 X_Jgzz_attribute6 VARCHAR2,
289 X_Jgzz_attribute7 VARCHAR2,
290 X_Jgzz_attribute8 VARCHAR2,
291 X_Jgzz_attribute9 VARCHAR2,
292 X_Jgzz_attribute10 VARCHAR2,
293 X_Jgzz_attribute11 VARCHAR2,
294 X_Jgzz_attribute12 VARCHAR2,
295 X_Jgzz_attribute13 VARCHAR2,
296 X_Jgzz_attribute14 VARCHAR2,
297 X_Jgzz_attribute15 VARCHAR2,
298 X_global_attribute_category VARCHAR2,
299 X_global_attribute1 VARCHAR2,
300 X_global_attribute2 VARCHAR2,
301 X_global_attribute3 VARCHAR2,
302 X_global_attribute4 VARCHAR2,
303 X_global_attribute5 VARCHAR2,
304 X_global_attribute6 VARCHAR2,
305 X_global_attribute7 VARCHAR2,
306 X_global_attribute8 VARCHAR2,
307 X_global_attribute9 VARCHAR2,
308 X_global_attribute10 VARCHAR2,
309 X_global_attribute11 VARCHAR2,
310 X_global_attribute12 VARCHAR2,
311 X_global_attribute13 VARCHAR2,
312 X_global_attribute14 VARCHAR2,
313 X_global_attribute15 VARCHAR2,
314 X_global_attribute16 VARCHAR2,
315 X_global_attribute17 VARCHAR2,
316 X_global_attribute18 VARCHAR2,
317 X_global_attribute19 VARCHAR2,
318 X_global_attribute20 VARCHAR2,
319 X_lockbox_matching_option VARCHAR2,
320 X_autocash_hierarchy_id_adr NUMBER
321 ) IS
322 BEGIN
323 NULL;
324 END Update_Row;
325 --
326 --
327 --
328 --
329 -- PROCEDURE
330 -- create_profile_from_class
331 --
332 -- DESCRIPTION
333 -- This procedure creates a customer profile from the customr_profile_class
334 -- It is designed to be called from the cust_prof|addr_prof blocks of the
335 -- enter customer form.
336 --
337 -- It returns all the profiles attributes to the form ans sliently
338 -- creates the rows in ar_customer_profile_amounts;
339 --
340 -- It is assume that the calling forms has no uncomitted rows for the
341 -- table ar_customer_profile_amounts.
342 --
343 -- SCOPE - PUBLIC
344 --
345 -- EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
346 --
347 -- ARGUMENTS : IN:
348 --
349 -- OUT:
350 -- None
351 --
352 -- RETURNS : NONE
353 --
354 -- NOTES
355 --
356 -- MODIFICATION HISTORY - Created by Kevin Hudson
357 --
358 --
359 PROCEDURE create_profile_from_class(
360 x_customer_profile_class_id in number,
361 x_customer_profile_id in OUT NOCOPY number,
362 x_customer_id in OUT NOCOPY number,
363 x_site_use_id in number,
364 x_collector_id OUT NOCOPY number,
365 x_collector_name OUT NOCOPY varchar2,
366 x_credit_checking OUT NOCOPY varchar2,
367 x_tolerance OUT NOCOPY number,
368 x_interest_charges OUT NOCOPY varchar2,
369 x_charge_on_fin_charge_flag OUT NOCOPY varchar2,
370 x_interest_period_days OUT NOCOPY number,
371 x_discount_terms OUT NOCOPY varchar2,
372 x_discount_grace_days OUT NOCOPY number,
373 x_statements OUT NOCOPY varchar2,
374 x_statement_cycle_id OUT NOCOPY number,
375 x_statement_cycle_name OUT NOCOPY varchar2,
376 x_credit_balance_statements OUT NOCOPY varchar2,
377 x_standard_terms OUT NOCOPY number,
378 x_standard_terms_name OUT NOCOPY varchar2,
379 x_override_terms OUT NOCOPY varchar2,
380 x_payment_grace_days OUT NOCOPY number,
381 x_dunning_letters OUT NOCOPY varchar2,
382 x_dunning_letter_set_id OUT NOCOPY number,
383 x_dunning_letter_set_name OUT NOCOPY varchar2,
384 x_autocash_hierarchy_id OUT NOCOPY number,
385 x_autocash_hierarchy_name OUT NOCOPY varchar2,
389 x_grouping_rule_name OUT NOCOPY varchar2,
386 x_auto_rec_incl_disputed_flag OUT NOCOPY varchar2,
387 x_tax_printing_option OUT NOCOPY varchar2,
388 x_grouping_rule_id OUT NOCOPY number,
390 x_cons_inv_flag OUT NOCOPY varchar2,
391 x_cons_inv_type OUT NOCOPY varchar2,
392 x_attribute_category OUT NOCOPY varchar2,
393 x_attribute1 OUT NOCOPY varchar2,
394 x_attribute2 OUT NOCOPY varchar2,
395 x_attribute3 OUT NOCOPY varchar2,
396 x_attribute4 OUT NOCOPY varchar2,
397 x_attribute5 OUT NOCOPY varchar2,
398 x_attribute6 OUT NOCOPY varchar2,
399 x_attribute7 OUT NOCOPY varchar2,
400 x_attribute8 OUT NOCOPY varchar2,
401 x_attribute9 OUT NOCOPY varchar2,
402 x_attribute10 OUT NOCOPY varchar2,
403 x_attribute11 OUT NOCOPY varchar2,
404 x_attribute12 OUT NOCOPY varchar2,
405 x_attribute13 OUT NOCOPY varchar2,
406 x_attribute14 OUT NOCOPY varchar2,
407 x_attribute15 OUT NOCOPY varchar2,
408 x_jgzz_attribute_category OUT NOCOPY varchar2,
409 x_jgzz_attribute1 OUT NOCOPY varchar2,
410 x_jgzz_attribute2 OUT NOCOPY varchar2,
411 x_jgzz_attribute3 OUT NOCOPY varchar2,
412 x_jgzz_attribute4 OUT NOCOPY varchar2,
413 x_jgzz_attribute5 OUT NOCOPY varchar2,
414 x_jgzz_attribute6 OUT NOCOPY varchar2,
415 x_jgzz_attribute7 OUT NOCOPY varchar2,
416 x_jgzz_attribute8 OUT NOCOPY varchar2,
417 x_jgzz_attribute9 OUT NOCOPY varchar2,
418 x_jgzz_attribute10 OUT NOCOPY varchar2,
419 x_jgzz_attribute11 OUT NOCOPY varchar2,
420 x_jgzz_attribute12 OUT NOCOPY varchar2,
421 x_jgzz_attribute13 OUT NOCOPY varchar2,
422 x_jgzz_attribute14 OUT NOCOPY varchar2,
423 x_jgzz_attribute15 OUT NOCOPY varchar2,
424 x_global_attribute_category OUT NOCOPY varchar2,
425 x_global_attribute1 OUT NOCOPY varchar2,
426 x_global_attribute2 OUT NOCOPY varchar2,
427 x_global_attribute3 OUT NOCOPY varchar2,
428 x_global_attribute4 OUT NOCOPY varchar2,
429 x_global_attribute5 OUT NOCOPY varchar2,
430 x_global_attribute6 OUT NOCOPY varchar2,
431 x_global_attribute7 OUT NOCOPY varchar2,
432 x_global_attribute8 OUT NOCOPY varchar2,
433 x_global_attribute9 OUT NOCOPY varchar2,
434 x_global_attribute10 OUT NOCOPY varchar2,
435 x_global_attribute11 OUT NOCOPY varchar2,
436 x_global_attribute12 OUT NOCOPY varchar2,
437 x_global_attribute13 OUT NOCOPY varchar2,
438 x_global_attribute14 OUT NOCOPY varchar2,
439 x_global_attribute15 OUT NOCOPY varchar2,
440 x_global_attribute16 OUT NOCOPY varchar2,
441 x_global_attribute17 OUT NOCOPY varchar2,
442 x_global_attribute18 OUT NOCOPY varchar2,
443 x_global_attribute19 OUT NOCOPY varchar2,
444 x_global_attribute20 OUT NOCOPY varchar2,
445 x_lockbox_matching_option OUT NOCOPY varchar2,
446 x_lockbox_matching_name OUT NOCOPY varchar2,
447 x_autocash_hierarchy_id_adr OUT NOCOPY number,
448 x_autocash_hierarchy_name_adr OUT NOCOPY varchar2
449 ) is
450 begin
451 NULL;
452 end create_profile_from_class;
453 --
454 --
455 --
456 END arp_cprof_pkg;