[Home] [Help]
PACKAGE: APPS.AMS_LISTENTRY_PVT
Source
1 PACKAGE AMS_ListEntry_PVT AUTHID CURRENT_USER as
2 /* $Header: amsvlses.pls 115.17 2002/11/22 08:55:54 jieli ship $ */
3 -- Start of Comments
4 --
5 -- PACKAGE
6 -- AMS_ListEntry_PVT
7 --
8 -- PURPOSE
9 -- This package is a Private API for managing List Entry information in
10 -- AMS.
11 --
12 -- Procedures:
13 -- Create_ListEntry
14 -- Update_ListEntry
15 -- Delete_ListEntry
16 -- Lock_ListEntry
17 -- Validate_ListEntry
18 --
19 -- Check_Entry_items
20 -- Check_Entry_record
21 -- Update_Source_Code added 10/27/99
22
23 -- Init_Entry_rec
24 -- Complete_Entry_rec
25 -- Default_ListEntry
26
27 -- Functions
28 -- Get_List_PinCode Calculates a unique pincode for every list entry.
29 --
30
31
32 -- NOTES
33 --
34 --
35 -- HISTORY
36 -- 05/12/1999 tdonohoe created
37 -- 06/06/2000 tdonohoe modified entry_rec_type to include PARTY_ID,PARENT_PARTY_ID,SOURCE_CODE_FOR_ID columns.
38 -- 06/06/2000 tdonohoe added procedure Default_ListEntry.
39 -- End of Comments
40
41 -- global constants
42 TYPE entry_rec_type IS RECORD(
43 LIST_ENTRY_ID NUMBER,
44 LIST_HEADER_ID NUMBER,
45 LAST_UPDATE_DATE DATE,
46 LAST_UPDATED_BY NUMBER,
47 CREATION_DATE DATE,
48 CREATED_BY NUMBER,
49 LAST_UPDATE_LOGIN NUMBER,
50 OBJECT_VERSION_NUMBER NUMBER,
51 LIST_SELECT_ACTION_ID NUMBER,
52 ARC_LIST_SELECT_ACTION_FROM VARCHAR2(30),
53 LIST_SELECT_ACTION_FROM_NAME VARCHAR2(254),
54 SOURCE_CODE VARCHAR2(30),
55 ARC_LIST_USED_BY_SOURCE VARCHAR2(30),
56 SOURCE_CODE_FOR_ID NUMBER,
57 PIN_CODE VARCHAR2(30),
58 LIST_ENTRY_SOURCE_SYSTEM_ID NUMBER,
59 LIST_ENTRY_SOURCE_SYSTEM_TYPE VARCHAR2(30),
60 VIEW_APPLICATION_ID NUMBER,
61 MANUALLY_ENTERED_FLAG VARCHAR2(1),
62 MARKED_AS_DUPLICATE_FLAG VARCHAR2(1),
63 MARKED_AS_RANDOM_FLAG VARCHAR2(1),
64 PART_OF_CONTROL_GROUP_FLAG VARCHAR2(1),
65 EXCLUDE_IN_TRIGGERED_LIST_FLAG VARCHAR2(1),
66 ENABLED_FLAG VARCHAR2(1),
67 CELL_CODE VARCHAR2(30),
68 DEDUPE_KEY VARCHAR2(500),
69 RANDOMLY_GENERATED_NUMBER NUMBER,
70 CAMPAIGN_ID NUMBER,
71 MEDIA_ID NUMBER,
72 CHANNEL_ID NUMBER,
73 CHANNEL_SCHEDULE_ID NUMBER,
74 EVENT_OFFER_ID NUMBER,
75 CUSTOMER_ID NUMBER,
76 MARKET_SEGMENT_ID NUMBER,
77 VENDOR_ID NUMBER,
78 TRANSFER_FLAG VARCHAR2(1),
79 TRANSFER_STATUS VARCHAR2(1),
80 LIST_SOURCE VARCHAR2(240),
81 DUPLICATE_MASTER_ENTRY_ID NUMBER,
82 MARKED_FLAG VARCHAR2(1),
83 LEAD_ID NUMBER,
84 LETTER_ID NUMBER,
85 PICKING_HEADER_ID NUMBER,
86 BATCH_ID NUMBER,
87 FIRST_NAME VARCHAR2(150),
88 LAST_NAME VARCHAR2(150),
89 CUSTOMER_NAME VARCHAR2(500),
90 COL1 VARCHAR2(500),
91 COL2 VARCHAR2(500),
92 COL3 VARCHAR2(500),
93 COL4 VARCHAR2(500),
94 COL5 VARCHAR2(500),
95 COL6 VARCHAR2(500),
96 COL7 VARCHAR2(500),
97 COL8 VARCHAR2(500),
98 COL9 VARCHAR2(500),
99 COL10 VARCHAR2(500),
100 COL11 VARCHAR2(500),
101 COL12 VARCHAR2(500),
102 COL13 VARCHAR2(500),
103 COL14 VARCHAR2(500),
104 COL15 VARCHAR2(500),
105 COL16 VARCHAR2(500),
106 COL17 VARCHAR2(500),
107 COL18 VARCHAR2(500),
108 COL19 VARCHAR2(500),
109 COL20 VARCHAR2(500),
110 COL21 VARCHAR2(500),
111 COL22 VARCHAR2(500),
112 COL23 VARCHAR2(500),
113 COL24 VARCHAR2(500),
114 COL25 VARCHAR2(500),
115 COL26 VARCHAR2(500),
116 COL27 VARCHAR2(500),
117 COL28 VARCHAR2(500),
118 COL29 VARCHAR2(500),
119 COL30 VARCHAR2(500),
120 COL31 VARCHAR2(500),
121 COL32 VARCHAR2(500),
122 COL33 VARCHAR2(500),
123 COL34 VARCHAR2(500),
124 COL35 VARCHAR2(500),
125 COL36 VARCHAR2(500),
126 COL37 VARCHAR2(500),
127 COL38 VARCHAR2(500),
128 COL39 VARCHAR2(500),
129 COL40 VARCHAR2(500),
130 COL41 VARCHAR2(500),
131 COL42 VARCHAR2(500),
132 COL43 VARCHAR2(500),
133 COL44 VARCHAR2(500),
134 COL45 VARCHAR2(500),
135 COL46 VARCHAR2(500),
136 COL47 VARCHAR2(500),
137 COL48 VARCHAR2(500),
138 COL49 VARCHAR2(500),
139 COL50 VARCHAR2(500),
140 COL51 VARCHAR2(500),
141 COL52 VARCHAR2(500),
142 COL53 VARCHAR2(500),
143 COL54 VARCHAR2(500),
144 COL55 VARCHAR2(500),
145 COL56 VARCHAR2(500),
146 COL57 VARCHAR2(500),
147 COL58 VARCHAR2(500),
148 COL59 VARCHAR2(500),
149 COL60 VARCHAR2(500),
150 COL61 VARCHAR2(500),
151 COL62 VARCHAR2(500),
152 COL63 VARCHAR2(500),
153 COL64 VARCHAR2(500),
154 COL65 VARCHAR2(500),
155 COL66 VARCHAR2(500),
156 COL67 VARCHAR2(500),
157 COL68 VARCHAR2(500),
158 COL69 VARCHAR2(500),
159 COL70 VARCHAR2(500),
160 COL71 VARCHAR2(500),
161 COL72 VARCHAR2(500),
162 COL73 VARCHAR2(500),
163 COL74 VARCHAR2(500),
164 COL75 VARCHAR2(500),
165 COL76 VARCHAR2(500),
166 COL77 VARCHAR2(500),
167 COL78 VARCHAR2(500),
168 COL79 VARCHAR2(500),
169 COL80 VARCHAR2(500),
170 COL81 VARCHAR2(500),
171 COL82 VARCHAR2(500),
172 COL83 VARCHAR2(500),
173 COL84 VARCHAR2(500),
174 COL85 VARCHAR2(500),
175 COL86 VARCHAR2(500),
176 COL87 VARCHAR2(500),
177 COL88 VARCHAR2(500),
178 COL89 VARCHAR2(500),
179 COL90 VARCHAR2(500),
180 COL91 VARCHAR2(500),
181 COL92 VARCHAR2(500),
182 COL93 VARCHAR2(500),
183 COL94 VARCHAR2(500),
184 COL95 VARCHAR2(500),
185 COL96 VARCHAR2(500),
186 COL97 VARCHAR2(500),
187 COL98 VARCHAR2(500),
188 COL99 VARCHAR2(500),
189 COL100 VARCHAR2(500),
190 COL101 VARCHAR2(500),
191 COL102 VARCHAR2(500),
192 COL103 VARCHAR2(500),
193 COL104 VARCHAR2(500),
194 COL105 VARCHAR2(500),
195 COL106 VARCHAR2(500),
196 COL107 VARCHAR2(500),
197 COL108 VARCHAR2(500),
198 COL109 VARCHAR2(500),
199 COL110 VARCHAR2(500),
200 COL111 VARCHAR2(500),
201 COL112 VARCHAR2(500),
202 COL113 VARCHAR2(500),
203 COL114 VARCHAR2(500),
204 COL115 VARCHAR2(500),
205 COL116 VARCHAR2(500),
206 COL117 VARCHAR2(500),
207 COL118 VARCHAR2(500),
208 COL119 VARCHAR2(500),
209 COL120 VARCHAR2(500),
210 COL121 VARCHAR2(500),
211 COL122 VARCHAR2(500),
212 COL123 VARCHAR2(500),
213 COL124 VARCHAR2(500),
214 COL125 VARCHAR2(500),
215 COL126 VARCHAR2(500),
216 COL127 VARCHAR2(500),
217 COL128 VARCHAR2(500),
218 COL129 VARCHAR2(500),
219 COL130 VARCHAR2(500),
220 COL131 VARCHAR2(500),
221 COL132 VARCHAR2(500),
222 COL133 VARCHAR2(500),
223 COL134 VARCHAR2(500),
224 COL135 VARCHAR2(500),
225 COL136 VARCHAR2(500),
226 COL137 VARCHAR2(500),
227 COL138 VARCHAR2(500),
228 COL139 VARCHAR2(500),
229 COL140 VARCHAR2(500),
230 COL141 VARCHAR2(500),
231 COL142 VARCHAR2(500),
232 COL143 VARCHAR2(500),
233 COL144 VARCHAR2(500),
234 COL145 VARCHAR2(500),
235 COL146 VARCHAR2(500),
236 COL147 VARCHAR2(500),
237 COL148 VARCHAR2(500),
238 COL149 VARCHAR2(500),
239 COL150 VARCHAR2(500),
240 COL151 VARCHAR2(500),
241 COL152 VARCHAR2(500),
242 COL153 VARCHAR2(500),
243 COL154 VARCHAR2(500),
244 COL155 VARCHAR2(500),
245 COL156 VARCHAR2(500),
246 COL157 VARCHAR2(500),
247 COL158 VARCHAR2(500),
248 COL159 VARCHAR2(500),
249 COL160 VARCHAR2(500),
250 COL161 VARCHAR2(500),
251 COL162 VARCHAR2(500),
252 COL163 VARCHAR2(500),
253 COL164 VARCHAR2(500),
254 COL165 VARCHAR2(500),
255 COL166 VARCHAR2(500),
256 COL167 VARCHAR2(500),
257 COL168 VARCHAR2(500),
258 COL169 VARCHAR2(500),
259 COL170 VARCHAR2(500),
260 COL171 VARCHAR2(500),
261 COL172 VARCHAR2(500),
262 COL173 VARCHAR2(500),
263 COL174 VARCHAR2(500),
264 COL175 VARCHAR2(500),
265 COL176 VARCHAR2(500),
266 COL177 VARCHAR2(500),
267 COL178 VARCHAR2(500),
268 COL179 VARCHAR2(500),
269 COL180 VARCHAR2(500),
270 COL181 VARCHAR2(500),
271 COL182 VARCHAR2(500),
272 COL183 VARCHAR2(500),
273 COL184 VARCHAR2(500),
274 COL185 VARCHAR2(500),
275 COL186 VARCHAR2(500),
276 COL187 VARCHAR2(500),
277 COL188 VARCHAR2(500),
278 COL189 VARCHAR2(500),
279 COL190 VARCHAR2(500),
280 COL191 VARCHAR2(500),
281 COL192 VARCHAR2(500),
282 COL193 VARCHAR2(500),
283 COL194 VARCHAR2(500),
284 COL195 VARCHAR2(500),
288 COL199 VARCHAR2(500),
285 COL196 VARCHAR2(500),
286 COL197 VARCHAR2(500),
287 COL198 VARCHAR2(500),
289 COL200 VARCHAR2(500),
290 COL201 VARCHAR2(500),
291 COL202 VARCHAR2(500),
292 COL203 VARCHAR2(500),
293 COL204 VARCHAR2(500),
294 COL205 VARCHAR2(500),
295 COL206 VARCHAR2(500),
296 COL207 VARCHAR2(500),
297 COL208 VARCHAR2(500),
298 COL209 VARCHAR2(500),
299 COL210 VARCHAR2(500),
300 COL211 VARCHAR2(500),
301 COL212 VARCHAR2(500),
302 COL213 VARCHAR2(500),
303 COL214 VARCHAR2(500),
304 COL215 VARCHAR2(500),
305 COL216 VARCHAR2(500),
306 COL217 VARCHAR2(500),
307 COL218 VARCHAR2(500),
308 COL219 VARCHAR2(500),
309 COL220 VARCHAR2(500),
310 COL221 VARCHAR2(500),
311 COL222 VARCHAR2(500),
312 COL223 VARCHAR2(500),
313 COL224 VARCHAR2(500),
314 COL225 VARCHAR2(500),
315 COL226 VARCHAR2(500),
316 COL227 VARCHAR2(500),
317 COL228 VARCHAR2(500),
318 COL229 VARCHAR2(500),
319 COL230 VARCHAR2(500),
320 COL231 VARCHAR2(500),
321 COL232 VARCHAR2(500),
322 COL233 VARCHAR2(500),
323 COL234 VARCHAR2(500),
324 COL235 VARCHAR2(500),
325 COL236 VARCHAR2(500),
326 COL237 VARCHAR2(500),
327 COL238 VARCHAR2(500),
328 COL239 VARCHAR2(500),
329 COL240 VARCHAR2(500),
330 COL241 VARCHAR2(4000),
331 COL242 VARCHAR2(4000),
332 COL243 VARCHAR2(4000),
333 COL244 VARCHAR2(4000),
334 COL245 VARCHAR2(4000),
335 COL246 VARCHAR2(4000),
336 COL247 VARCHAR2(4000),
337 COL248 VARCHAR2(4000),
338 COL249 VARCHAR2(4000),
339 COL250 VARCHAR2(4000),
340 COL251 VARCHAR2(500),
341 COL252 VARCHAR2(500),
342 COL253 VARCHAR2(500),
343 COL254 VARCHAR2(500),
344 COL255 VARCHAR2(500),
345 COL256 VARCHAR2(500),
346 COL257 VARCHAR2(500),
347 COL258 VARCHAR2(500),
348 COL259 VARCHAR2(500),
349 COL260 VARCHAR2(500),
350 COL261 VARCHAR2(500),
351 COL262 VARCHAR2(500),
352 COL263 VARCHAR2(500),
353 COL264 VARCHAR2(500),
354 COL265 VARCHAR2(500),
355 COL266 VARCHAR2(500),
356 COL267 VARCHAR2(500),
357 COL268 VARCHAR2(500),
358 COL269 VARCHAR2(500),
359 COL270 VARCHAR2(500),
360 COL271 VARCHAR2(500),
361 COL272 VARCHAR2(500),
362 COL273 VARCHAR2(500),
363 COL274 VARCHAR2(500),
364 COL275 VARCHAR2(500),
365 COL276 VARCHAR2(500),
366 COL277 VARCHAR2(500),
367 COL278 VARCHAR2(500),
368 COL279 VARCHAR2(500),
369 COL280 VARCHAR2(500),
370 COL281 VARCHAR2(500),
371 COL282 VARCHAR2(500),
372 COL283 VARCHAR2(500),
373 COL284 VARCHAR2(500),
374 COL285 VARCHAR2(500),
375 COL286 VARCHAR2(500),
376 COL287 VARCHAR2(500),
377 COL288 VARCHAR2(500),
378 COL289 VARCHAR2(500),
379 COL290 VARCHAR2(500),
380 COL291 VARCHAR2(500),
381 COL292 VARCHAR2(500),
385 COL296 VARCHAR2(500),
382 COL293 VARCHAR2(500),
383 COL294 VARCHAR2(500),
384 COL295 VARCHAR2(500),
386 COL297 VARCHAR2(500),
387 COL298 VARCHAR2(500),
388 COL299 VARCHAR2(500),
389 COL300 VARCHAR2(500),
390 ADDRESS_LINE1 VARCHAR2(500),
391 ADDRESS_LINE2 VARCHAR2(500),
392 CALLBACK_FLAG VARCHAR2(1),
393 CITY VARCHAR2(100),
394 COUNTRY VARCHAR2(100),
395 DO_NOT_USE_FLAG VARCHAR2(1),
396 DO_NOT_USE_REASON VARCHAR2(30),
397 EMAIL_ADDRESS VARCHAR2(500),
398 FAX VARCHAR2(150),
399 PHONE VARCHAR2(150),
400 RECORD_OUT_FLAG VARCHAR2(1),
401 STATE VARCHAR2(100),
402 SUFFIX VARCHAR2(30),
403 TITLE VARCHAR2(150),
404 USAGE_RESTRICTION VARCHAR2(1),
405 ZIPCODE VARCHAR2(100),
406 CURR_CP_COUNTRY_CODE VARCHAR2(30),
407 CURR_CP_PHONE_NUMBER VARCHAR2(10),
408 CURR_CP_RAW_PHONE_NUMBER VARCHAR2(60),
409 CURR_CP_AREA_CODE NUMBER,
410 CURR_CP_ID NUMBER,
411 CURR_CP_INDEX NUMBER,
412 CURR_CP_TIME_ZONE NUMBER,
413 CURR_CP_TIME_ZONE_AUX NUMBER,
414 IMP_SOURCE_LINE_ID NUMBER,
415 NEXT_CALL_TIME DATE,
416 RECORD_RELEASE_TIME DATE,
417 PARTY_ID NUMBER,
418 PARENT_PARTY_ID NUMBER);
419
420 ---------------------------------------------------------------------
421 -- PROCEDURE
422 -- update_listentry_source_code
423 --
424 -- PURPOSE
425 -- Updates The Source_Code and Arc_List_Used_By_Source fields on The List Entry table.
426
427 -- A List may be generated without a Source Code Associated , in this case the two columns
428 -- will be defaulted to NONE and 0.
429
430 -- If The List later gets a Source code we must update the two columns to reflect this change
431 -- to allow list tracking from the interactions table.
432
433 -- PARAMETERS
434 -- p_list_id -- the list header id.
435 -- NOTES
436 ---------------------------------------------------------------------
437
438 PROCEDURE update_listentry_source_code(
439 p_api_version IN NUMBER,
440 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
441 p_commit IN VARCHAR2 := FND_API.g_false,
442 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
443 x_return_status OUT NOCOPY VARCHAR2,
444 x_msg_count OUT NOCOPY NUMBER,
445 x_msg_data OUT NOCOPY VARCHAR2,
446 p_list_id IN NUMBER
447 );
448
449 ---------------------------------------------------------------------
450 -- PROCEDURE
451 -- create_listentry
452 --
453 -- PURPOSE
454 -- Create a new list entry.
455 --
456 -- PARAMETERS
457 -- p_entry_rec: the new record to be inserted
458 -- x_entry_id: return the list_entry_id of the new campaign
459 --
460 -- NOTES
461 -- 1. object_version_number will be set to 1.
462 -- 2. If list_entry_id is passed in, the uniqueness will be checked.
463 -- Raise exception in case of duplicates.
464 -- 3. If list_entry_id is not passed in, generate a unique one from
465 -- the sequence.
466 -- 4. If a flag column is passed in, check if it is 'Y' or 'N'.
467 -- Raise exception for invalid flag.
468 -- 5. If a flag column is not passed in, default it to 'Y' or 'N'.
469 -- 6. Please don't pass in any FND_API.g_mess_char/num/date.
470 ---------------------------------------------------------------------
471 PROCEDURE create_listentry(
472 p_api_version IN NUMBER,
473 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
474 p_commit IN VARCHAR2 := FND_API.g_false,
475 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
476 x_return_status OUT NOCOPY VARCHAR2,
477 x_msg_count OUT NOCOPY NUMBER,
478 x_msg_data OUT NOCOPY VARCHAR2,
479 p_entry_rec IN entry_rec_type,
480 x_entry_id OUT NOCOPY NUMBER
481 );
482 ---------------------------------------------------------------------
483 -- PROCEDURE
484 -- update_listentry
485 --
486 -- PURPOSE
487 -- Update a listentry.
488 --
489 -- PARAMETERS
490 -- p_entry_rec: the record with new items
491 --
492 -- NOTES
493 -- 1. Raise exception if the object_version_number doesn't match.
494 -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,
495 -- that column won't be updated.
496 ----------------------------------------------------------------------
497 PROCEDURE update_listentry(
498 p_api_version IN NUMBER,
499 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
500 p_commit IN VARCHAR2 := FND_API.g_false,
501 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
505
502 x_return_status OUT NOCOPY VARCHAR2,
503 x_msg_count OUT NOCOPY NUMBER,
504 x_msg_data OUT NOCOPY VARCHAR2,
506 p_entry_rec IN entry_rec_type
507 );
508
509 --------------------------------------------------------------------
510 -- PROCEDURE
511 -- delete_listentry
512 --
513 -- PURPOSE
514 -- Delete a listentry.
515 --
516 -- PARAMETERS
517 -- p_entry_id: the listentry_id
518 -- p_object_version: the object_version_number
519 --
520 -- NOTES
521 -- 1. Raise exception if the object_version_number doesn't match.
522 --------------------------------------------------------------------
523 PROCEDURE delete_listentry(
524 p_api_version IN NUMBER,
525 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
526 p_commit IN VARCHAR2 := FND_API.g_false,
527 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
528 x_return_status OUT NOCOPY VARCHAR2,
529 x_msg_count OUT NOCOPY NUMBER,
530 x_msg_data OUT NOCOPY VARCHAR2,
531 p_entry_id IN NUMBER,
532 p_object_version_number IN NUMBER
533 );
534
535 -------------------------------------------------------------------
536 -- PROCEDURE
537 -- lock_listentry
538 --
539 -- PURPOSE
540 -- Lock a List Entry.
541 --
542 -- PARAMETERS
543 -- p_entry_id: the list_entry_id
544 -- p_object_version: the object_version_number
545 --
546 -- NOTES
547 -- 1. Raise exception if the object_version_number doesn't match.
548 --------------------------------------------------------------------
549 PROCEDURE lock_listentry(
550 p_api_version IN NUMBER,
551 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
552 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
553 x_return_status OUT NOCOPY VARCHAR2,
554 x_msg_count OUT NOCOPY NUMBER,
555 x_msg_data OUT NOCOPY VARCHAR2,
556 p_entry_id IN NUMBER,
557 p_object_version IN NUMBER
558 );
559
560 ---------------------------------------------------------------------
561 -- PROCEDURE
562 -- validate_listentry
563 --
564 -- PURPOSE
565 -- Validate a listentry record.
566 --
567 -- PARAMETERS
568 -- p_camp_rec: the listentry record to be validated
569 --
570 -- NOTES
571 -- 1. p_entry_rec should be the complete campaign record. There
572 -- should not be any FND_API.g_miss_char/num/date in it.
573 ----------------------------------------------------------------------
574 PROCEDURE validate_listentry(
575 p_api_version IN NUMBER,
576 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
577 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
578 x_return_status OUT NOCOPY VARCHAR2,
579 x_msg_count OUT NOCOPY NUMBER,
580 x_msg_data OUT NOCOPY VARCHAR2,
581 p_entry_rec IN entry_rec_type
582 );
583
584
585 ---------------------------------------------------------------------
586 -- PROCEDURE
587 -- check_entry_items
588 --
589 -- PURPOSE
590 -- Perform the item level checking including unique keys,
591 -- required columns, foreign keys, domain constraints.
592 --
593 -- PARAMETERS
594 -- p_entry_rec: the record to be validated
595 -- p_validation_mode: JTF_PLSQL_API.g_create/g_update
596 ---------------------------------------------------------------------
597 PROCEDURE check_entry_items(
598 p_entry_rec IN entry_rec_type,
599 p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
600 x_return_status OUT NOCOPY VARCHAR2
601 );
602
603
604 ---------------------------------------------------------------------
605 -- PROCEDURE
606 -- check_entry_record
607 --
608 -- PURPOSE
609 -- Check the record level business rules.
610 --
611 -- PARAMETERS
612 -- p_entry_rec: the record to be validated; may contain attributes
613 -- as FND_API.g_miss_char/num/date
614 -- p_complete_rec: the complete record after all "g_miss" items
615 -- have been replaced by current database values
616 ---------------------------------------------------------------------
617 PROCEDURE check_entry_record(
618 p_entry_rec IN entry_rec_type,
619 p_complete_rec IN entry_rec_type := NULL,
620 x_return_status OUT NOCOPY VARCHAR2
621 );
622
623
624 ---------------------------------------------------------------------
625 -- PROCEDURE
626 -- init_entry_rec
627 --
628 -- PURPOSE
629 -- Initialize all attributes to be FND_API.g_miss_char/num/date.
630 ---------------------------------------------------------------------
631 PROCEDURE init_entry_rec(
632 x_entry_rec OUT NOCOPY entry_rec_type
633 );
634
635
636 ---------------------------------------------------------------------
637 -- PROCEDURE
638 -- complete_entry_rec
639 --
640 -- PURPOSE
641 -- For update_listentry, some attributes may be passed in as
642 -- FND_API.g_miss_char/num/date if the user doesn't want to
643 -- update those attributes. This procedure will replace the
644 -- "g_miss" attributes with current database values.
645 --
646 -- PARAMETERS
650 -- have been replaced by current database values
647 -- p_camp_rec: the record which may contain attributes as
648 -- FND_API.g_miss_char/num/date
649 -- x_complete_rec: the complete record after all "g_miss" items
651 ---------------------------------------------------------------------
652 PROCEDURE complete_entry_rec(
653 p_entry_rec IN entry_rec_type,
654 x_complete_rec OUT NOCOPY entry_rec_type
655 );
656
657
658
659 Function Get_ListPinCode(p_list_header_id IN NUMBER,
660 p_list_entry_id IN NUMBER)
661 Return varchar2;
662
663 END AMS_ListEntry_PVT;