[Home] [Help]
PACKAGE BODY: APPS.ARP_CSU_PKG
Source
1 PACKAGE BODY arp_csu_pkg as
2 /* $Header: AROCSUB.pls 120.1 2005/08/11 01:04:17 hyu noship $ */
3 --
4 --
5 --
6 -- PROCEDURE
7 -- maintain_denormalized_data
8 --
9 -- DESCRIPTION
10 -- This procedure coordinates the calling of routines to maintains
11 -- denormailized site_use data.
12 --
13 -- SCOPE - PUBLIC
14 --
15 -- EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
16 --
17 -- ARGUMENTS : IN: p_customer_id
18 -- p_address_id
19 -- p_site_use_id
20 -- p_site_use_code
21 -- p_primary_flag
22 -- OUT:
23 --
24 -- NOTES
25 --
26 --
27 --
28 --
29 procedure maintain_denormalized_data ( p_customer_id in number,
30 p_address_id in number,
31 p_site_use_id in number,
32 p_site_use_code in varchar2,
33 p_status in varchar2,
34 p_primary_flag in varchar2 ) is
35 BEGIN
36 NULL;
37 end maintain_denormalized_data;
38 --
39 --
40 --
41 PROCEDURE delete_customer_alt_names(p_rowid in varchar2,
42 p_status in varchar2,
43 p_customer_id in number,
44 p_site_use_id in number
45 ) is
46 begin
47 NULL;
48 end delete_customer_alt_names;
49 --
50 --
51 --
52 -- PROCEDURE
53 -- site_use_exists
54 --
55 -- DESCRIPTION
56 -- This procedure determins if an address has a site use of a particular
57 -- Type.
58 --
59 -- SCOPE - PUBLIC
60 --
61 -- EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
62 --
63 -- ARGUMENTS : IN:
64 -- p_address_id -
65 -- p_site_use_code - type of site use to create
66 -- OUT:
67 -- p_site_use_id - id of site use type
68 -- p_site_use_status - status of site use type
69 --
70 -- RETURNS null
71 --
72 -- NOTES
73 --
74 PROCEDURE site_use_exists( p_address_id in number,
75 p_site_use_code in varchar2,
76 p_site_use_id out NOCOPY number,
77 p_site_use_status out NOCOPY varchar2 ) is
78 begin
79 NULL;
80 end site_use_exists;
81 --
82 --
83 --
84 -- PROCEDURE
85 -- update_su_status
86 --
87 -- DESCRIPTION
88 -- This procedure updates the staus of a row in ra_site_uses
89 --
90 -- SCOPE - PUBLIC
91 --
92 -- EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
93 --
94 -- ARGUMENTS : IN:
95 -- p_customer_id
96 -- p_address_id
97 -- p_site_use_code
98 -- p_site_use_id - id of row to be updated
99 -- p_status - status to update row to(A,I)
100 -- OUT:
101 --
102 -- NOTES
103 --
104 --
105 --
106 --
107 PROCEDURE update_su_status ( p_customer_id in number,
108 p_address_id in number,
109 p_site_use_id in number,
110 p_site_use_code in varchar2,
111 p_status in varchar2 ) is
112 begin
113 NULL;
114 end update_su_status;
115 --
116 --
117 --
118 --
119 --
120 -- PROCEDURE
121 -- check_unique_site_use_code
122 --
123 -- DESCRIPTION
124 -- This procedure ensures validates to ensure
125 -- 1). An addres has only active site use per type.
126 -- 2). A Customer only has one primary active site use of each type
127 -- DUN
128 -- STMTS
129 -- LEGAL
130 --
131 -- SCOPE - PUBLIC
132 --
133 -- EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
134 --
135 -- ARGUMENTS : IN:
136 -- - p_site_use_id
137 -- - p_customer_id
138 -- - p_address_id,
139 -- - p_site_use_code
140 --
141 -- OUT:
142 --
143 -- NOTES
144 --
145 --
146 --
147 procedure check_unique_site_use_code( p_site_use_id in number,
148 p_customer_id in number,
149 p_address_id in number,
150 p_site_use_code in varchar2 ) is
151 begin
152 NULL;
153 end check_unique_site_use_code;
154 --
155 --
156 --
157 --
158 --
159 -- PROCEDURE
160 -- check_unique_location
161 --
162 -- DESCRIPTION
163 -- This procedure ensures validates to ensure rows
164 -- in ra_site_uses have unique locations within customer/site_use_code
165 --
166 -- SCOPE - PUBLIC
167 --
168 -- EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
169 --
170 -- ARGUMENTS : IN:
171 -- - p_site_use_id
172 -- - p_customer_id
173 -- - p_site_use_code
174 -- - p_location
175 --
176 -- OUT:
177 --
178 -- NOTES
179 --
180 --
181 --
182 procedure check_unique_location( p_site_use_id in number,
183 p_customer_id in number,
184 p_site_use_code in varchar2,
185 p_location in varchar2
186 ) is
187 begin
188 NULL;
189 end check_unique_location;
190 --
191 --
192 --
193 -- PROCEDURE
194 -- check_primary
195 --
196 -- DESCRIPTION
197 -- This procedure ensures that an address only has one active
198 -- site use per type.
199 --
200 -- SCOPE - PUBLIC
201 --
202 -- EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
203 --
204 -- ARGUMENTS : IN:
205 -- - p_site_use_id
206 -- - p_customer_id,
207 -- - p_site_use_code
208 --
209 -- OUT:
210 --
211 -- NOTES
212 --
213 --
214 --
215 PROCEDURE check_primary ( p_site_use_id in number, p_customer_id in number, p_site_use_code in varchar2) is
216 begin
217 NULL;
218 end check_primary;
219 --
220 --
221 --
222 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
223 X_Site_Use_Id IN OUT NOCOPY NUMBER,
224 X_Last_Update_Date DATE,
225 X_Last_Updated_By NUMBER,
226 X_Creation_Date DATE,
227 X_Created_By NUMBER,
228 X_Site_Use_Code VARCHAR2,
229 X_customer_id NUMBER,
230 X_Address_Id NUMBER,
231 X_Primary_Flag VARCHAR2,
232 X_Status VARCHAR2,
233 X_Location IN OUT NOCOPY VARCHAR2,
234 X_Last_Update_Login NUMBER,
235 X_Contact_Id NUMBER,
236 X_Bill_To_Site_Use_Id NUMBER,
237 X_Sic_Code VARCHAR2,
238 X_Payment_Term_Id NUMBER,
239 X_Gsa_Indicator VARCHAR2,
240 X_Ship_Partial VARCHAR2,
241 X_Ship_Via VARCHAR2,
242 X_Fob_Point VARCHAR2,
243 X_Order_Type_Id NUMBER,
244 X_Price_List_Id NUMBER,
245 X_Freight_Term VARCHAR2,
246 X_Warehouse_Id NUMBER,
247 X_Territory_Id NUMBER,
248 X_Tax_Code VARCHAR2,
249 X_Tax_Reference VARCHAR2,
250 X_Demand_Class_Code VARCHAR2,
251 x_inventory_location_id NUMBER,
252 x_inventory_organization_id NUMBER,
253 X_Attribute_Category VARCHAR2,
254 X_Attribute1 VARCHAR2,
255 X_Attribute2 VARCHAR2,
256 X_Attribute3 VARCHAR2,
257 X_Attribute4 VARCHAR2,
258 X_Attribute5 VARCHAR2,
259 X_Attribute6 VARCHAR2,
260 X_Attribute7 VARCHAR2,
261 X_Attribute8 VARCHAR2,
262 X_Attribute9 VARCHAR2,
263 X_Attribute10 VARCHAR2,
264 X_Attribute11 VARCHAR2,
265 X_Attribute12 VARCHAR2,
266 X_Attribute13 VARCHAR2,
267 X_Attribute14 VARCHAR2,
268 X_Attribute15 VARCHAR2,
269 X_Attribute16 VARCHAR2,
270 X_Attribute17 VARCHAR2,
271 X_Attribute18 VARCHAR2,
272 X_Attribute19 VARCHAR2,
273 X_Attribute20 VARCHAR2,
274 X_Attribute21 VARCHAR2,
275 X_Attribute22 VARCHAR2,
276 X_Attribute23 VARCHAR2,
277 X_Attribute24 VARCHAR2,
278 X_Attribute25 VARCHAR2,
279 X_Tax_Classification VARCHAR2,
280 X_Tax_Header_Level_Flag VARCHAR2,
281 X_Tax_Rounding_Rule VARCHAR2,
282 X_Global_Attribute_Category VARCHAR2,
283 X_Global_Attribute1 VARCHAR2,
284 X_Global_Attribute2 VARCHAR2,
285 X_Global_Attribute3 VARCHAR2,
286 X_Global_Attribute4 VARCHAR2,
287 X_Global_Attribute5 VARCHAR2,
288 X_Global_Attribute6 VARCHAR2,
289 X_Global_Attribute7 VARCHAR2,
290 X_Global_Attribute8 VARCHAR2,
291 X_Global_Attribute9 VARCHAR2,
292 X_Global_Attribute10 VARCHAR2,
293 X_Global_Attribute11 VARCHAR2,
294 X_Global_Attribute12 VARCHAR2,
295 X_Global_Attribute13 VARCHAR2,
296 X_Global_Attribute14 VARCHAR2,
297 X_Global_Attribute15 VARCHAR2,
298 X_Global_Attribute16 VARCHAR2,
299 X_Global_Attribute17 VARCHAR2,
300 X_Global_Attribute18 VARCHAR2,
301 X_Global_Attribute19 VARCHAR2,
302 X_Global_Attribute20 VARCHAR2,
303 X_Primary_Salesrep_Id NUMBER DEFAULT NULL,
304 X_Finchrg_Receivables_Trx_Id NUMBER DEFAULT NULL,
305 X_GL_ID_Rec NUMBER,
306 X_GL_ID_Rev NUMBER,
307 X_GL_ID_Tax NUMBER,
308 X_GL_ID_Freight NUMBER,
309 X_GL_ID_Clearing NUMBER,
310 X_GL_ID_Unbilled NUMBER,
311 X_GL_ID_Unearned NUMBER
312 ) IS
313 BEGIN
314 NULL;
315 END Insert_Row;
316 --
317 --
318
319 PROCEDURE Update_Row(X_Rowid IN OUT NOCOPY VARCHAR2 ,
320 X_Site_Use_Id IN OUT NOCOPY NUMBER,
321 X_Last_Update_Date DATE,
322 X_Last_Updated_By NUMBER,
323 X_Site_Use_Code VARCHAR2,
324 X_customer_id NUMBER,
325 X_Address_Id NUMBER,
326 X_Primary_Flag VARCHAR2,
327 X_Status VARCHAR2,
328 X_Location VARCHAR2,
329 X_Last_Update_Login NUMBER,
330 X_Contact_Id NUMBER,
331 X_Bill_To_Site_Use_Id NUMBER,
332 X_Sic_Code VARCHAR2,
333 X_Payment_Term_Id NUMBER,
334 X_Gsa_Indicator VARCHAR2,
335 X_Ship_Partial VARCHAR2,
336 X_Ship_Via VARCHAR2,
337 X_Fob_Point VARCHAR2,
338 X_Order_Type_Id NUMBER,
339 X_Price_List_Id NUMBER,
340 X_Freight_Term VARCHAR2,
341 X_Warehouse_Id NUMBER,
342 X_Territory_Id NUMBER,
343 X_Tax_Code VARCHAR2,
344 X_Tax_Reference VARCHAR2,
345 X_Demand_Class_Code VARCHAR2,
346 x_inventory_location_id NUMBER,
347 x_inventory_organization_id NUMBER,
348 X_Attribute_Category VARCHAR2,
349 X_Attribute1 VARCHAR2,
350 X_Attribute2 VARCHAR2,
351 X_Attribute3 VARCHAR2,
352 X_Attribute4 VARCHAR2,
353 X_Attribute5 VARCHAR2,
354 X_Attribute6 VARCHAR2,
355 X_Attribute7 VARCHAR2,
356 X_Attribute8 VARCHAR2,
357 X_Attribute9 VARCHAR2,
358 X_Attribute10 VARCHAR2,
359 X_Attribute11 VARCHAR2,
360 X_Attribute12 VARCHAR2,
361 X_Attribute13 VARCHAR2,
362 X_Attribute14 VARCHAR2,
363 X_Attribute15 VARCHAR2,
364 X_Attribute16 VARCHAR2,
365 X_Attribute17 VARCHAR2,
366 X_Attribute18 VARCHAR2,
367 X_Attribute19 VARCHAR2,
368 X_Attribute20 VARCHAR2,
369 X_Attribute21 VARCHAR2,
370 X_Attribute22 VARCHAR2,
371 X_Attribute23 VARCHAR2,
372 X_Attribute24 VARCHAR2,
373 X_Attribute25 VARCHAR2,
374 X_Tax_Classification VARCHAR2,
375 X_Tax_Header_Level_Flag VARCHAR2,
376 X_Tax_Rounding_Rule VARCHAR2,
377 X_Global_Attribute_Category VARCHAR2,
378 X_Global_Attribute1 VARCHAR2,
379 X_Global_Attribute2 VARCHAR2,
380 X_Global_Attribute3 VARCHAR2,
381 X_Global_Attribute4 VARCHAR2,
382 X_Global_Attribute5 VARCHAR2,
383 X_Global_Attribute6 VARCHAR2,
384 X_Global_Attribute7 VARCHAR2,
385 X_Global_Attribute8 VARCHAR2,
386 X_Global_Attribute9 VARCHAR2,
387 X_Global_Attribute10 VARCHAR2,
388 X_Global_Attribute11 VARCHAR2,
389 X_Global_Attribute12 VARCHAR2,
390 X_Global_Attribute13 VARCHAR2,
391 X_Global_Attribute14 VARCHAR2,
392 X_Global_Attribute15 VARCHAR2,
393 X_Global_Attribute16 VARCHAR2,
394 X_Global_Attribute17 VARCHAR2,
398 X_Primary_Salesrep_Id NUMBER DEFAULT NULL,
395 X_Global_Attribute18 VARCHAR2,
396 X_Global_Attribute19 VARCHAR2,
397 X_Global_Attribute20 VARCHAR2,
399 X_Finchrg_Receivables_Trx_Id NUMBER DEFAULT NULL,
400 X_GL_ID_Rec NUMBER,
401 X_GL_ID_Rev NUMBER,
402 X_GL_ID_Tax NUMBER,
403 X_GL_ID_Freight NUMBER,
404 X_GL_ID_Clearing NUMBER,
405 X_GL_ID_Unbilled NUMBER,
406 X_GL_ID_Unearned NUMBER
407
408 ) IS
409 BEGIN
410 NULL;
411 END Update_Row;
412 --
413 --
414
415 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
416 X_Site_Use_Id NUMBER,
417 X_Site_Use_Code VARCHAR2,
418 X_Address_Id NUMBER,
419 X_Primary_Flag VARCHAR2,
420 X_Status VARCHAR2,
421 X_Location VARCHAR2,
422 X_Contact_Id NUMBER,
423 X_Bill_To_Site_Use_Id NUMBER,
424 X_Sic_Code VARCHAR2,
425 X_Payment_Term_Id NUMBER,
426 X_Gsa_Indicator VARCHAR2,
427 X_Ship_Partial VARCHAR2,
428 X_Ship_Via VARCHAR2,
429 X_Fob_Point VARCHAR2,
430 X_Order_Type_Id NUMBER,
431 X_Price_List_Id NUMBER,
432 X_Freight_Term VARCHAR2,
433 X_Warehouse_Id NUMBER,
434 X_Territory_Id NUMBER,
435 X_Tax_Code VARCHAR2,
436 X_Tax_Reference VARCHAR2,
437 X_Demand_Class_Code VARCHAR2,
438 X_Attribute_Category VARCHAR2,
439 X_Attribute1 VARCHAR2,
440 X_Attribute2 VARCHAR2,
441 X_Attribute3 VARCHAR2,
442 X_Attribute4 VARCHAR2,
443 X_Attribute5 VARCHAR2,
444 X_Attribute6 VARCHAR2,
445 X_Attribute7 VARCHAR2,
446 X_Attribute8 VARCHAR2,
447 X_Attribute9 VARCHAR2,
448 X_Attribute10 VARCHAR2,
449 X_Attribute11 VARCHAR2,
450 X_Attribute12 VARCHAR2,
451 X_Attribute13 VARCHAR2,
452 X_Attribute14 VARCHAR2,
453 X_Attribute15 VARCHAR2,
454 X_Attribute16 VARCHAR2,
455 X_Attribute17 VARCHAR2,
456 X_Attribute18 VARCHAR2,
457 X_Attribute19 VARCHAR2,
458 X_Attribute20 VARCHAR2,
459 X_Attribute21 VARCHAR2,
460 X_Attribute22 VARCHAR2,
461 X_Attribute23 VARCHAR2,
462 X_Attribute24 VARCHAR2,
463 X_Attribute25 VARCHAR2,
464 X_Tax_Classification VARCHAR2,
465 X_Tax_Header_Level_Flag VARCHAR2,
466 X_Tax_Rounding_Rule VARCHAR2,
467 X_Global_Attribute_Category VARCHAR2,
468 X_Global_Attribute1 VARCHAR2,
469 X_Global_Attribute2 VARCHAR2,
470 X_Global_Attribute3 VARCHAR2,
471 X_Global_Attribute4 VARCHAR2,
472 X_Global_Attribute5 VARCHAR2,
473 X_Global_Attribute6 VARCHAR2,
474 X_Global_Attribute7 VARCHAR2,
475 X_Global_Attribute8 VARCHAR2,
476 X_Global_Attribute9 VARCHAR2,
477 X_Global_Attribute10 VARCHAR2,
478 X_Global_Attribute11 VARCHAR2,
479 X_Global_Attribute12 VARCHAR2,
480 X_Global_Attribute13 VARCHAR2,
481 X_Global_Attribute14 VARCHAR2,
482 X_Global_Attribute15 VARCHAR2,
483 X_Global_Attribute16 VARCHAR2,
484 X_Global_Attribute17 VARCHAR2,
485 X_Global_Attribute18 VARCHAR2,
486 X_Global_Attribute19 VARCHAR2,
487 X_Global_Attribute20 VARCHAR2,
491 X_GL_ID_Rev NUMBER,
488 X_Primary_Salesrep_Id NUMBER DEFAULT NULL,
489 X_Finchrg_Receivables_Trx_Id NUMBER DEFAULT NULL,
490 X_GL_ID_Rec NUMBER,
492 X_GL_ID_Tax NUMBER,
493 X_GL_ID_Freight NUMBER,
494 X_GL_ID_Clearing NUMBER,
495 X_GL_ID_Unbilled NUMBER,
496 X_GL_ID_Unearned NUMBER
497
498
499 ) IS
500 BEGIN
501 NULL;
502 END Lock_Row;
503 --
504 --
505
506 END arp_csu_pkg;