[Home] [Help]
PACKAGE: APPS.AMS_PARTYIMPORT_PVT
Source
1 PACKAGE AMS_PartyImport_PVT AUTHID CURRENT_USER AS
2 /* $Header: amsvptys.pls 115.14 2002/11/22 08:56:10 jieli ship $ */
3
4 -----------------------------------------------------------
5 -- PACKAGE
6 -- AMS_PartyImport_PVT
7 --
8 -- PURPOSE
9 -- Private API for Oracle Marketing Party Sources.
10 --
11 -- PROCEDURES
12 -- Create_Party
13 -- Delete_Party
14 -- Lock_Party
15 -- Update_Party
16 -- Validate_Party
17 --
18 -- Check_Party_Items
19 -- Check_Party_Record
20 --
21 -- Init_Party_Rec
22 -- Complete_Party_Rec
23 --
24 -- Refresh_Key
25 -- Process_Party
26 --
27 ------------------------------------------------------------
28
29 --
30 -- Record of table AMS_PARTY_SOURCES
31 TYPE Party_Rec_Type IS RECORD (
32 party_sources_id NUMBER,
33 party_id NUMBER,
34 import_source_line_id NUMBER,
35 object_version_number NUMBER,
36 last_update_date DATE,
37 last_updated_by NUMBER,
38 creation_date DATE,
39 created_by NUMBER,
40 last_update_login NUMBER,
41 import_list_header_id NUMBER,
42 list_source_type_id NUMBER,
43 used_flag VARCHAR2(1),
44 overlay_flag VARCHAR2(1),
45 overlay_date DATE,
46 col1 VARCHAR2(150),
47 col2 VARCHAR2(150),
48 col3 VARCHAR2(150),
49 col4 VARCHAR2(150),
50 col5 VARCHAR2(150),
51 col6 VARCHAR2(150),
52 col7 VARCHAR2(150),
53 col8 VARCHAR2(150),
54 col9 VARCHAR2(150),
55 col10 VARCHAR2(150),
56 col11 VARCHAR2(150),
57 col12 VARCHAR2(150),
58 col13 VARCHAR2(150),
59 col14 VARCHAR2(150),
60 col15 VARCHAR2(150),
61 col16 VARCHAR2(150),
62 col17 VARCHAR2(150),
63 col18 VARCHAR2(150),
64 col19 VARCHAR2(150),
65 col20 VARCHAR2(150),
66 col21 VARCHAR2(150),
67 col22 VARCHAR2(150),
68 col23 VARCHAR2(150),
69 col24 VARCHAR2(150),
70 col25 VARCHAR2(150),
71 col26 VARCHAR2(150),
72 col27 VARCHAR2(150),
73 col28 VARCHAR2(150),
74 col29 VARCHAR2(150),
75 col30 VARCHAR2(150),
76 col31 VARCHAR2(150),
77 col32 VARCHAR2(150),
78 col33 VARCHAR2(150),
79 col34 VARCHAR2(150),
80 col35 VARCHAR2(150),
81 col36 VARCHAR2(150),
82 col37 VARCHAR2(150),
83 col38 VARCHAR2(150),
84 col39 VARCHAR2(150),
85 col40 VARCHAR2(150),
86 col41 VARCHAR2(150),
87 col42 VARCHAR2(150),
88 col43 VARCHAR2(150),
89 col44 VARCHAR2(150),
90 col45 VARCHAR2(150),
91 col46 VARCHAR2(150),
92 col47 VARCHAR2(150),
93 col48 VARCHAR2(150),
94 col49 VARCHAR2(150),
95 col50 VARCHAR2(150),
96 col51 VARCHAR2(150),
97 col52 VARCHAR2(150),
98 col53 VARCHAR2(150),
99 col54 VARCHAR2(150),
100 col55 VARCHAR2(150),
101 col56 VARCHAR2(150),
102 col57 VARCHAR2(150),
103 col58 VARCHAR2(150),
104 col59 VARCHAR2(150),
105 col60 VARCHAR2(150),
106 col61 VARCHAR2(150),
107 col62 VARCHAR2(150),
108 col63 VARCHAR2(150),
109 col64 VARCHAR2(150),
110 col65 VARCHAR2(150),
111 col66 VARCHAR2(150),
112 col67 VARCHAR2(150),
113 col68 VARCHAR2(150),
114 col69 VARCHAR2(150),
115 col70 VARCHAR2(150),
116 col71 VARCHAR2(150),
117 col72 VARCHAR2(150),
118 col73 VARCHAR2(150),
119 col74 VARCHAR2(150),
120 col75 VARCHAR2(150),
121 col76 VARCHAR2(150),
122 col77 VARCHAR2(150),
123 col78 VARCHAR2(150),
124 col79 VARCHAR2(150),
125 col80 VARCHAR2(150),
126 col81 VARCHAR2(150),
127 col82 VARCHAR2(150),
128 col83 VARCHAR2(150),
129 col84 VARCHAR2(150),
130 col85 VARCHAR2(150),
131 col86 VARCHAR2(150),
132 col87 VARCHAR2(150),
133 col88 VARCHAR2(150),
134 col89 VARCHAR2(150),
135 col90 VARCHAR2(150),
136 col91 VARCHAR2(150),
137 col92 VARCHAR2(150),
138 col93 VARCHAR2(150),
139 col94 VARCHAR2(150),
140 col95 VARCHAR2(150),
141 col96 VARCHAR2(150),
142 col97 VARCHAR2(150),
143 col98 VARCHAR2(150),
144 col99 VARCHAR2(150),
145 col100 VARCHAR2(150),
146 col101 VARCHAR2(150),
147 col102 VARCHAR2(150),
148 col103 VARCHAR2(150),
149 col104 VARCHAR2(150),
150 col105 VARCHAR2(150),
151 col106 VARCHAR2(150),
152 col107 VARCHAR2(150),
153 col108 VARCHAR2(150),
154 col109 VARCHAR2(150),
155 col110 VARCHAR2(150),
156 col111 VARCHAR2(150),
157 col112 VARCHAR2(150),
158 col113 VARCHAR2(150),
159 col114 VARCHAR2(150),
160 col115 VARCHAR2(150),
161 col116 VARCHAR2(150),
162 col117 VARCHAR2(150),
163 col118 VARCHAR2(150),
164 col119 VARCHAR2(150),
165 col120 VARCHAR2(150),
166 col121 VARCHAR2(150),
167 col122 VARCHAR2(150),
168 col123 VARCHAR2(150),
169 col124 VARCHAR2(150),
170 col125 VARCHAR2(150),
171 col126 VARCHAR2(150),
172 col127 VARCHAR2(150),
173 col128 VARCHAR2(150),
174 col129 VARCHAR2(150),
175 col130 VARCHAR2(150),
176 col131 VARCHAR2(150),
177 col132 VARCHAR2(150),
178 col133 VARCHAR2(150),
179 col134 VARCHAR2(150),
180 col135 VARCHAR2(150),
181 col136 VARCHAR2(150),
182 col137 VARCHAR2(150),
183 col138 VARCHAR2(150),
184 col139 VARCHAR2(150),
185 col140 VARCHAR2(150),
186 col141 VARCHAR2(150),
187 col142 VARCHAR2(150),
188 col143 VARCHAR2(150),
189 col144 VARCHAR2(150),
190 col145 VARCHAR2(150),
191 col146 VARCHAR2(150),
192 col147 VARCHAR2(150),
193 col148 VARCHAR2(150),
194 col149 VARCHAR2(150),
195 col150 VARCHAR2(150),
196 col151 VARCHAR2(150),
197 col152 VARCHAR2(150),
198 col153 VARCHAR2(150),
199 col154 VARCHAR2(150),
200 col155 VARCHAR2(150),
201 col156 VARCHAR2(150),
202 col157 VARCHAR2(150),
203 col158 VARCHAR2(150),
204 col159 VARCHAR2(150),
205 col160 VARCHAR2(150),
206 col161 VARCHAR2(150),
207 col162 VARCHAR2(150),
208 col163 VARCHAR2(150),
209 col164 VARCHAR2(150),
210 col165 VARCHAR2(150),
211 col166 VARCHAR2(150),
212 col167 VARCHAR2(150),
213 col168 VARCHAR2(150),
214 col169 VARCHAR2(150),
215 col170 VARCHAR2(150),
216 col171 VARCHAR2(150),
217 col172 VARCHAR2(150),
218 col173 VARCHAR2(150),
219 col174 VARCHAR2(150),
220 col175 VARCHAR2(150),
221 col176 VARCHAR2(150),
222 col177 VARCHAR2(150),
223 col178 VARCHAR2(150),
224 col179 VARCHAR2(150),
225 col180 VARCHAR2(150),
226 col181 VARCHAR2(150),
227 col182 VARCHAR2(150),
228 col183 VARCHAR2(150),
229 col184 VARCHAR2(150),
230 col185 VARCHAR2(150),
231 col186 VARCHAR2(150),
232 col187 VARCHAR2(150),
233 col188 VARCHAR2(150),
234 col189 VARCHAR2(150),
235 col190 VARCHAR2(150),
236 col191 VARCHAR2(150),
237 col192 VARCHAR2(150),
238 col193 VARCHAR2(150),
239 col194 VARCHAR2(150),
240 col195 VARCHAR2(150),
241 col196 VARCHAR2(150),
242 col197 VARCHAR2(150),
243 col198 VARCHAR2(150),
244 col199 VARCHAR2(150),
245 col200 VARCHAR2(150),
246 col201 VARCHAR2(150),
247 col202 VARCHAR2(150),
248 col203 VARCHAR2(150),
249 col204 VARCHAR2(150),
250 col205 VARCHAR2(150),
251 col206 VARCHAR2(150),
252 col207 VARCHAR2(150),
253 col208 VARCHAR2(150),
254 col209 VARCHAR2(150),
255 col210 VARCHAR2(150),
256 col211 VARCHAR2(150),
257 col212 VARCHAR2(150),
258 col213 VARCHAR2(150),
259 col214 VARCHAR2(150),
260 col215 VARCHAR2(150),
261 col216 VARCHAR2(150),
262 col217 VARCHAR2(150),
263 col218 VARCHAR2(150),
264 col219 VARCHAR2(150),
265 col220 VARCHAR2(150),
266 col221 VARCHAR2(150),
267 col222 VARCHAR2(150),
268 col223 VARCHAR2(150),
269 col224 VARCHAR2(150),
270 col225 VARCHAR2(150),
271 col226 VARCHAR2(150),
272 col227 VARCHAR2(150),
273 col228 VARCHAR2(150),
274 col229 VARCHAR2(150),
275 col230 VARCHAR2(150),
276 col231 VARCHAR2(150),
277 col232 VARCHAR2(150),
278 col233 VARCHAR2(150),
279 col234 VARCHAR2(150),
280 col235 VARCHAR2(150),
281 col236 VARCHAR2(150),
282 col237 VARCHAR2(150),
283 col238 VARCHAR2(150),
284 col239 VARCHAR2(150),
285 col240 VARCHAR2(150),
286 col241 VARCHAR2(4000),
287 col242 VARCHAR2(4000),
288 col243 VARCHAR2(4000),
289 col244 VARCHAR2(4000),
290 col245 VARCHAR2(4000),
291 col246 VARCHAR2(4000),
292 col247 VARCHAR2(4000),
293 col248 VARCHAR2(4000),
294 col249 VARCHAR2(4000),
295 col250 VARCHAR2(4000)
296 );
297
298
299 --------------------------------------------------------------------
300 -- PROCEDURE
301 -- Create_Party
302 --
303 -- PURPOSE
304 -- Create a party source entry.
305 --
306 -- PARAMETERS
307 -- p_party_rec: the record representing AMS_PARTY_SOURCES.
308 -- x_party_sources_id: the party_sources_id.
309 --
310 -- NOTES
311 -- 1. object_version_number will be set to 1.
312 -- 2. If party_sources_id is passed in, the uniqueness will be checked.
313 -- Raise exception in case of duplicates.
314 -- 3. If party_sources_id is not passed in, generate a unique one from
315 -- the sequence.
316 -- 4. If a flag column is passed in, check if it is 'Y' or 'N'.
317 -- Raise exception for invalid flag.
318 -- 5. If a flag column is not passed in, default it to 'Y' or 'N'.
319 -- 6. Please don't pass in any FND_API.g_mess_char/num/date.
320 --------------------------------------------------------------------
321 PROCEDURE Create_Party (
322 p_api_version IN NUMBER,
326
323 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
324 p_commit IN VARCHAR2 := FND_API.g_false,
325 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
327 x_return_status OUT NOCOPY VARCHAR2,
328 x_msg_count OUT NOCOPY NUMBER,
329 x_msg_data OUT NOCOPY VARCHAR2,
330
331 p_party_rec IN Party_Rec_Type,
332 x_party_sources_id OUT NOCOPY NUMBER
333 );
334
335
336 --------------------------------------------------------------------
337 -- PROCEDURE
338 -- Delete_Party
339 --
340 -- PURPOSE
341 -- Delete a party source entry.
342 --
343 -- PARAMETERS
344 -- p_party_sources_id: the party_sources_id
345 -- p_object_version: the object_version_number
346 --
347 -- ISSUES
348 -- Currently, we are not allowing people to delete list header
349 -- entries. We may add some business rules for deletion though.
350 --
351 -- NOTES
352 -- 1. Raise exception if the object_version_number doesn't match.
353 --------------------------------------------------------------------
354 PROCEDURE Delete_Party (
355 p_api_version IN NUMBER,
356 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
357 p_commit IN VARCHAR2 := FND_API.g_false,
358 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
359
360 x_return_status OUT NOCOPY VARCHAR2,
361 x_msg_count OUT NOCOPY NUMBER,
362 x_msg_data OUT NOCOPY VARCHAR2,
363
364 p_party_sources_id IN NUMBER,
365 p_object_version IN NUMBER
366 );
367
368
369 --------------------------------------------------------------------
370 -- PROCEDURE
371 -- Lock_Party
372 --
373 -- PURPOSE
374 -- Lock a party source entry.
375 --
376 -- PARAMETERS
377 -- p_party_sources_id: the party_sources_id
378 -- p_object_version: the object_version_number
379 --
380 -- ISSUES
381 --
382 -- NOTES
383 -- 1. Raise exception if the object_version_number doesn't match.
384 --------------------------------------------------------------------
385 PROCEDURE Lock_Party (
386 p_api_version IN NUMBER,
387 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
388 p_commit IN VARCHAR2 := FND_API.g_false,
389 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
390
391 x_return_status OUT NOCOPY VARCHAR2,
392 x_msg_count OUT NOCOPY NUMBER,
393 x_msg_data OUT NOCOPY VARCHAR2,
394
395 p_party_sources_id IN NUMBER,
396 p_object_version IN NUMBER
397 );
398
399
400 --------------------------------------------------------------------
401 -- PROCEDURE
402 -- Update_Party
403 --
404 -- PURPOSE
405 -- Update a party source entry.
406 --
407 -- PARAMETERS
408 -- p_party_rec: the record representing AMS_PARTY_SOURCES.
409 --
410 -- NOTES
411 -- 1. Raise exception if the object_version_number doesn't match.
412 -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,
413 -- that column won't be updated.
414 --------------------------------------------------------------------
415 PROCEDURE Update_Party (
416 p_api_version IN NUMBER,
417 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
418 p_commit IN VARCHAR2 := FND_API.g_false,
419 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
420
421 x_return_status OUT NOCOPY VARCHAR2,
422 x_msg_count OUT NOCOPY NUMBER,
423 x_msg_data OUT NOCOPY VARCHAR2,
424
425 p_party_rec IN Party_Rec_Type
426 );
427
428
429 --------------------------------------------------------------------
430 -- PROCEDURE
431 -- Validate_Party
432 --
433 -- PURPOSE
434 -- Validate a party source entry.
435 --
436 -- PARAMETERS
437 -- p_party_rec: the record representing AMS_PARTY_SOURCES.
438 --
439 -- NOTES
440 -- 1. p_party_rec should be the complete list header record. There
441 -- should not be any FND_API.g_miss_char/num/date in it.
442 -- 2. If FND_API.g_miss_char/num/date is in the record, then raise
443 -- an exception, as those values are not handled.
444 --------------------------------------------------------------------
445 PROCEDURE Validate_Party (
446 p_api_version IN NUMBER,
447 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
448 p_commit IN VARCHAR2 := FND_API.g_false,
449 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
450
451 x_return_status OUT NOCOPY VARCHAR2,
452 x_msg_count OUT NOCOPY NUMBER,
453 x_msg_data OUT NOCOPY VARCHAR2,
454
455 p_party_rec IN Party_Rec_Type
456 );
457
458
459 ---------------------------------------------------------------------
460 -- PROCEDURE
461 -- Check_Party_Items
462 --
463 -- PURPOSE
464 -- Perform the item level checking including unique keys,
465 -- required columns, foreign keys, domain constraints.
466 --
467 -- PARAMETERS
468 -- p_party_rec: the record to be validated
469 -- p_validation_mode: JTF_PLSQL_API.g_create/g_update
473 p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
470 ---------------------------------------------------------------------
471 PROCEDURE Check_Party_Items (
472 p_party_rec IN Party_Rec_Type,
474 x_return_status OUT NOCOPY VARCHAR2
475 );
476
477
478 ---------------------------------------------------------------------
479 -- PROCEDURE
480 -- Check_Party_Record
481 --
482 -- PURPOSE
483 -- Check the record level business rules.
484 --
485 -- PARAMETERS
486 -- p_party_rec: the record to be validated; may contain attributes
487 -- as FND_API.g_miss_char/num/date
488 -- p_complete_rec: the complete record after all "g_miss" items
489 -- have been replaced by current database values
490 ---------------------------------------------------------------------
491 PROCEDURE Check_Party_Record (
492 p_party_rec IN Party_Rec_Type,
493 p_complete_rec IN Party_Rec_Type := NULL,
494 x_return_status OUT NOCOPY VARCHAR2
495 );
496
497
498 ---------------------------------------------------------------------
499 -- PROCEDURE
500 -- Init_Party_Rec
501 --
502 -- PURPOSE
503 -- Initialize all attributes to be FND_API.g_miss_char/num/date.
504 ---------------------------------------------------------------------
505 PROCEDURE Init_Party_Rec (
506 x_party_rec OUT NOCOPY Party_Rec_Type
507 );
508
509
510 ---------------------------------------------------------------------
511 -- PROCEDURE
512 -- Complete_Party_Rec
513 --
514 -- PURPOSE
515 -- For Update_Party, some attributes may be passed in as
516 -- FND_API.g_miss_char/num/date if the user doesn't want to
517 -- update those attributes. This procedure will replace the
518 -- "g_miss" attributes with current database values.
519 --
520 -- PARAMETERS
521 -- p_listdr_rec: the record which may contain attributes as
522 -- FND_API.g_miss_char/num/date
523 -- x_complete_rec: the complete record after all "g_miss" items
524 -- have been replaced by current database values
525 ---------------------------------------------------------------------
526 PROCEDURE Complete_Party_Rec (
527 p_party_rec IN Party_Rec_Type,
528 x_complete_rec OUT NOCOPY Party_Rec_Type
529 );
530
531
532 --------------------------------------------------------------------
533 -- PROCEDURE
534 -- Refresh_Key
535 -- PURPOSE
536 -- Concurrent program which updates AMS_PARTY_DEDUPE with the
537 -- DEDUPE_KEY, derived from HZ_PARTIES.
538 --------------------------------------------------------------------
539 PROCEDURE Refresh_Key (
540 errbuf OUT NOCOPY VARCHAR2,
541 retcode OUT NOCOPY NUMBER,
542 p_word_replacement_flag IN VARCHAR2,
543 p_commit_flag IN VARCHAR2
544 );
545
546
547 --------------------------------------------------------------------
548 -- PROCEDURE
549 -- Process_Party
550 -- PURPOSE
551 -- Process an imported record using business rules
552 -- which validate against HZ_PARTIES. Those records
553 -- are then created in AMS_PARTY_SOURCES.
554 --------------------------------------------------------------------
555 PROCEDURE Process_Party (
556 p_api_version IN NUMBER,
557 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
558 p_commit IN VARCHAR2 := FND_API.g_false,
559 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
560
561 x_return_status OUT NOCOPY VARCHAR2,
562 x_msg_count OUT NOCOPY NUMBER,
563 x_msg_data OUT NOCOPY VARCHAR2,
564
565 p_import_source_line_id IN NUMBER,
566 p_word_replacement_flag IN VARCHAR2
567 );
568
569
570 --------------------------------------------------------------------
571 -- PROCEDURE
572 -- Schedule_PartyProcess
573 -- PURPOSE
574 -- Used as a concurrent program to process all imported
575 -- records for a given import header.
576 --------------------------------------------------------------------
577 PROCEDURE Schedule_Party_Process (
578 errbuf OUT NOCOPY VARCHAR2,
579 retcode OUT NOCOPY NUMBER,
580 p_import_list_header_id IN NUMBER,
581 p_word_replacement_flag IN VARCHAR2
582 );
583
584
585 END AMS_PartyImport_PVT;