[Home] [Help]
PACKAGE: APPS.AMS_LIST_ENTRIES_PVT
Source
1 PACKAGE AMS_List_Entries_PVT AUTHID CURRENT_USER AS
2 /* $Header: amsvlies.pls 115.17 2003/08/19 18:33:34 vbhandar ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- AMS_List_Entries_PVT
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- End of Comments
14 -- ===============================================================
15
16 -- Default number of records fetch per call
17 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
18 --===================================================================
19 -- Start of Comments
20 -- -------------------------------------------------------
21 -- Record name
22 -- list_entries_rec_type
23 -- -------------------------------------------------------
24 -- Parameters:
25 -- list_entry_id
26 -- list_header_id
27 -- last_update_date
28 -- last_updated_by
29 -- creation_date
30 -- created_by
31 -- last_update_login
32 -- object_version_number
33 -- list_select_action_id
34 -- arc_list_select_action_from
35 -- list_select_action_from_name
36 -- source_code
37 -- arc_list_used_by_source
38 -- source_code_for_id
39 -- pin_code
40 -- list_entry_source_system_id
41 -- list_entry_source_system_type
42 -- view_application_id
43 -- manually_entered_flag
44 -- marked_as_duplicate_flag
45 -- marked_as_random_flag
46 -- part_of_control_group_flag
47 -- exclude_in_triggered_list_flag
48 -- enabled_flag
49 -- cell_code
50 -- dedupe_key
51 -- randomly_generated_number
52 -- campaign_id
53 -- media_id
54 -- channel_id
55 -- channel_schedule_id
56 -- event_offer_id
57 -- customer_id
58 -- market_segment_id
59 -- vendor_id
60 -- transfer_flag
61 -- transfer_status
62 -- list_source
63 -- duplicate_master_entry_id
64 -- marked_flag
65 -- lead_id
66 -- letter_id
67 -- picking_header_id
68 -- batch_id
69 -- suffix
70 -- first_name
71 -- last_name
72 -- customer_name
73 -- title
74 -- address_line1
75 -- address_line2
76 -- city
77 -- state
78 -- zipcode
79 -- country
80 -- fax
81 -- phone
82 -- email_address
83 -- col1
84 -- col2
85 -- col3
86 -- col4
87 -- col5
88 -- col6
89 -- col7
90 -- col8
91 -- col9
92 -- col10
93 -- col11
94 -- col12
95 -- col13
96 -- col14
97 -- col15
98 -- col16
99 -- col17
100 -- col18
101 -- col19
102 -- col20
103 -- col21
104 -- col22
105 -- col23
106 -- col24
107 -- col25
108 -- col26
109 -- col27
110 -- col28
111 -- col29
112 -- col30
113 -- col31
114 -- col32
115 -- col33
116 -- col34
117 -- col35
118 -- col36
119 -- col37
120 -- col38
121 -- col39
122 -- col40
123 -- col41
124 -- col42
125 -- col43
126 -- col44
127 -- col45
128 -- col46
129 -- col47
130 -- col48
131 -- col49
132 -- col50
133 -- col51
134 -- col52
135 -- col53
136 -- col54
137 -- col55
138 -- col56
139 -- col57
140 -- col58
141 -- col59
142 -- col60
143 -- col61
144 -- col62
145 -- col63
146 -- col64
147 -- col65
148 -- col66
149 -- col67
150 -- col68
151 -- col69
152 -- col70
153 -- col71
154 -- col72
155 -- col73
156 -- col74
157 -- col75
158 -- col76
159 -- col77
160 -- col78
161 -- col79
162 -- col80
163 -- col81
164 -- col82
165 -- col83
166 -- col84
167 -- col85
168 -- col86
169 -- col87
170 -- col88
171 -- col89
172 -- col90
173 -- col91
174 -- col92
175 -- col93
176 -- col94
177 -- col95
178 -- col96
179 -- col97
180 -- col98
181 -- col99
182 -- col100
183 -- col101
184 -- col102
185 -- col103
186 -- col104
187 -- col105
188 -- col106
189 -- col107
190 -- col108
191 -- col109
192 -- col110
193 -- col111
194 -- col112
195 -- col113
196 -- col114
197 -- col115
198 -- col116
199 -- col117
200 -- col118
201 -- col119
202 -- col120
203 -- col121
204 -- col122
205 -- col123
206 -- col124
207 -- col125
208 -- col126
209 -- col127
210 -- col128
211 -- col129
212 -- col130
213 -- col131
214 -- col132
215 -- col133
216 -- col134
217 -- col135
218 -- col136
219 -- col137
220 -- col138
221 -- col139
222 -- col140
223 -- col141
224 -- col142
225 -- col143
226 -- col144
227 -- col145
228 -- col146
229 -- col147
230 -- col148
231 -- col149
232 -- col150
233 -- col151
234 -- col152
235 -- col153
236 -- col154
237 -- col155
238 -- col156
239 -- col157
240 -- col158
241 -- col159
242 -- col160
243 -- col161
244 -- col162
245 -- col163
246 -- col164
247 -- col165
248 -- col166
249 -- col167
250 -- col168
251 -- col169
252 -- col170
253 -- col171
254 -- col172
255 -- col173
256 -- col174
257 -- col175
258 -- col176
259 -- col177
260 -- col178
261 -- col179
262 -- col180
263 -- col181
264 -- col182
265 -- col183
266 -- col184
267 -- col185
268 -- col186
269 -- col187
270 -- col188
271 -- col189
272 -- col190
273 -- col191
274 -- col192
275 -- col193
276 -- col194
277 -- col195
278 -- col196
279 -- col197
280 -- col198
281 -- col199
282 -- col200
283 -- party_id
284 -- parent_party_id
285 -- geometry
286 -- imp_source_line_id
287 -- usage_restriction
288 -- next_call_time
289 -- callback_flag
290 -- do_not_use_flag
291 -- do_not_use_reason
292 -- record_out_flag
293 -- record_release_time
294 -- last_contacted_date
295 --
296 -- Required
297 --
298 -- Defaults
299 --
300 -- Note: This is automatic generated record definition, it includes all columns
301 -- defined in the table, developer must manually add or delete some of the attributes.
302 --
303 -- End of Comments
304
305 --===================================================================
306 TYPE list_entries_rec_type IS RECORD
307 (
308 list_entry_id NUMBER := FND_API.G_MISS_NUM,
309 list_header_id NUMBER := FND_API.G_MISS_NUM,
310 last_update_date DATE := FND_API.G_MISS_DATE,
311 last_updated_by NUMBER := FND_API.G_MISS_NUM,
312 creation_date DATE := FND_API.G_MISS_DATE,
313 created_by NUMBER := FND_API.G_MISS_NUM,
314 last_update_login NUMBER := FND_API.G_MISS_NUM,
315 object_version_number NUMBER := FND_API.G_MISS_NUM,
316 list_select_action_id NUMBER := FND_API.G_MISS_NUM,
317 arc_list_select_action_from VARCHAR2(30) := FND_API.G_MISS_CHAR,
318 list_select_action_from_name VARCHAR2(254) := FND_API.G_MISS_CHAR,
319 source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
320 arc_list_used_by_source VARCHAR2(30) := FND_API.G_MISS_CHAR,
321 source_code_for_id NUMBER := FND_API.G_MISS_NUM,
322 pin_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
323 list_entry_source_system_id NUMBER := FND_API.G_MISS_NUM,
324 list_entry_source_system_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
325 view_application_id NUMBER := FND_API.G_MISS_NUM,
326 manually_entered_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
327 marked_as_duplicate_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
328 marked_as_random_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
329 part_of_control_group_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
330 exclude_in_triggered_list_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
331 enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
332 cell_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
333 dedupe_key VARCHAR2(500) := FND_API.G_MISS_CHAR,
334 randomly_generated_number NUMBER := FND_API.G_MISS_NUM,
335 campaign_id NUMBER := FND_API.G_MISS_NUM,
336 media_id NUMBER := FND_API.G_MISS_NUM,
337 channel_id NUMBER := FND_API.G_MISS_NUM,
338 channel_schedule_id NUMBER := FND_API.G_MISS_NUM,
339 event_offer_id NUMBER := FND_API.G_MISS_NUM,
340 customer_id NUMBER := FND_API.G_MISS_NUM,
341 market_segment_id NUMBER := FND_API.G_MISS_NUM,
342 vendor_id NUMBER := FND_API.G_MISS_NUM,
343 transfer_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
344 transfer_status VARCHAR2(1) := FND_API.G_MISS_CHAR,
345 list_source VARCHAR2(240) := FND_API.G_MISS_CHAR,
346 duplicate_master_entry_id NUMBER := FND_API.G_MISS_NUM,
347 marked_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
348 lead_id NUMBER := FND_API.G_MISS_NUM,
349 letter_id NUMBER := FND_API.G_MISS_NUM,
350 picking_header_id NUMBER := FND_API.G_MISS_NUM,
351 batch_id NUMBER := FND_API.G_MISS_NUM,
352 suffix VARCHAR2(30) := FND_API.G_MISS_CHAR,
353 first_name VARCHAR2(150) := FND_API.G_MISS_CHAR,
354 last_name VARCHAR2(150) := FND_API.G_MISS_CHAR,
355 customer_name VARCHAR2(500) := FND_API.G_MISS_CHAR,
356 title VARCHAR2(150) := FND_API.G_MISS_CHAR,
357 address_line1 VARCHAR2(500) := FND_API.G_MISS_CHAR,
358 address_line2 VARCHAR2(500) := FND_API.G_MISS_CHAR,
359 city VARCHAR2(100) := FND_API.G_MISS_CHAR,
360 state VARCHAR2(100) := FND_API.G_MISS_CHAR,
361 zipcode VARCHAR2(100) := FND_API.G_MISS_CHAR,
362 country VARCHAR2(100) := FND_API.G_MISS_CHAR,
363 fax VARCHAR2(150) := FND_API.G_MISS_CHAR,
364 phone VARCHAR2(150) := FND_API.G_MISS_CHAR,
365 email_address VARCHAR2(500) := FND_API.G_MISS_CHAR,
366 col1 VARCHAR2(500) := FND_API.G_MISS_CHAR,
367 col2 VARCHAR2(500) := FND_API.G_MISS_CHAR,
368 col3 VARCHAR2(500) := FND_API.G_MISS_CHAR,
369 col4 VARCHAR2(500) := FND_API.G_MISS_CHAR,
370 col5 VARCHAR2(500) := FND_API.G_MISS_CHAR,
371 col6 VARCHAR2(500) := FND_API.G_MISS_CHAR,
372 col7 VARCHAR2(500) := FND_API.G_MISS_CHAR,
373 col8 VARCHAR2(500) := FND_API.G_MISS_CHAR,
374 col9 VARCHAR2(500) := FND_API.G_MISS_CHAR,
375 col10 VARCHAR2(500) := FND_API.G_MISS_CHAR,
376 col11 VARCHAR2(500) := FND_API.G_MISS_CHAR,
377 col12 VARCHAR2(500) := FND_API.G_MISS_CHAR,
378 col13 VARCHAR2(500) := FND_API.G_MISS_CHAR,
379 col14 VARCHAR2(500) := FND_API.G_MISS_CHAR,
380 col15 VARCHAR2(500) := FND_API.G_MISS_CHAR,
381 col16 VARCHAR2(500) := FND_API.G_MISS_CHAR,
382 col17 VARCHAR2(500) := FND_API.G_MISS_CHAR,
383 col18 VARCHAR2(500) := FND_API.G_MISS_CHAR,
384 col19 VARCHAR2(500) := FND_API.G_MISS_CHAR,
385 col20 VARCHAR2(500) := FND_API.G_MISS_CHAR,
386 col21 VARCHAR2(500) := FND_API.G_MISS_CHAR,
387 col22 VARCHAR2(500) := FND_API.G_MISS_CHAR,
388 col23 VARCHAR2(500) := FND_API.G_MISS_CHAR,
389 col24 VARCHAR2(500) := FND_API.G_MISS_CHAR,
390 col25 VARCHAR2(500) := FND_API.G_MISS_CHAR,
391 col26 VARCHAR2(500) := FND_API.G_MISS_CHAR,
392 col27 VARCHAR2(500) := FND_API.G_MISS_CHAR,
393 col28 VARCHAR2(500) := FND_API.G_MISS_CHAR,
394 col29 VARCHAR2(500) := FND_API.G_MISS_CHAR,
395 col30 VARCHAR2(500) := FND_API.G_MISS_CHAR,
396 col31 VARCHAR2(500) := FND_API.G_MISS_CHAR,
400 col35 VARCHAR2(500) := FND_API.G_MISS_CHAR,
397 col32 VARCHAR2(500) := FND_API.G_MISS_CHAR,
398 col33 VARCHAR2(500) := FND_API.G_MISS_CHAR,
399 col34 VARCHAR2(500) := FND_API.G_MISS_CHAR,
401 col36 VARCHAR2(500) := FND_API.G_MISS_CHAR,
402 col37 VARCHAR2(500) := FND_API.G_MISS_CHAR,
403 col38 VARCHAR2(500) := FND_API.G_MISS_CHAR,
404 col39 VARCHAR2(500) := FND_API.G_MISS_CHAR,
405 col40 VARCHAR2(500) := FND_API.G_MISS_CHAR,
406 col41 VARCHAR2(500) := FND_API.G_MISS_CHAR,
407 col42 VARCHAR2(500) := FND_API.G_MISS_CHAR,
408 col43 VARCHAR2(500) := FND_API.G_MISS_CHAR,
409 col44 VARCHAR2(500) := FND_API.G_MISS_CHAR,
410 col45 VARCHAR2(500) := FND_API.G_MISS_CHAR,
411 col46 VARCHAR2(500) := FND_API.G_MISS_CHAR,
412 col47 VARCHAR2(500) := FND_API.G_MISS_CHAR,
413 col48 VARCHAR2(500) := FND_API.G_MISS_CHAR,
414 col49 VARCHAR2(500) := FND_API.G_MISS_CHAR,
415 col50 VARCHAR2(500) := FND_API.G_MISS_CHAR,
416 col51 VARCHAR2(500) := FND_API.G_MISS_CHAR,
417 col52 VARCHAR2(500) := FND_API.G_MISS_CHAR,
418 col53 VARCHAR2(500) := FND_API.G_MISS_CHAR,
419 col54 VARCHAR2(500) := FND_API.G_MISS_CHAR,
420 col55 VARCHAR2(500) := FND_API.G_MISS_CHAR,
421 col56 VARCHAR2(500) := FND_API.G_MISS_CHAR,
422 col57 VARCHAR2(500) := FND_API.G_MISS_CHAR,
423 col58 VARCHAR2(500) := FND_API.G_MISS_CHAR,
424 col59 VARCHAR2(500) := FND_API.G_MISS_CHAR,
425 col60 VARCHAR2(500) := FND_API.G_MISS_CHAR,
426 col61 VARCHAR2(500) := FND_API.G_MISS_CHAR,
427 col62 VARCHAR2(500) := FND_API.G_MISS_CHAR,
428 col63 VARCHAR2(500) := FND_API.G_MISS_CHAR,
429 col64 VARCHAR2(500) := FND_API.G_MISS_CHAR,
430 col65 VARCHAR2(500) := FND_API.G_MISS_CHAR,
431 col66 VARCHAR2(500) := FND_API.G_MISS_CHAR,
432 col67 VARCHAR2(500) := FND_API.G_MISS_CHAR,
433 col68 VARCHAR2(500) := FND_API.G_MISS_CHAR,
434 col69 VARCHAR2(500) := FND_API.G_MISS_CHAR,
435 col70 VARCHAR2(500) := FND_API.G_MISS_CHAR,
436 col71 VARCHAR2(500) := FND_API.G_MISS_CHAR,
437 col72 VARCHAR2(500) := FND_API.G_MISS_CHAR,
438 col73 VARCHAR2(500) := FND_API.G_MISS_CHAR,
439 col74 VARCHAR2(500) := FND_API.G_MISS_CHAR,
440 col75 VARCHAR2(500) := FND_API.G_MISS_CHAR,
441 col76 VARCHAR2(500) := FND_API.G_MISS_CHAR,
442 col77 VARCHAR2(500) := FND_API.G_MISS_CHAR,
443 col78 VARCHAR2(500) := FND_API.G_MISS_CHAR,
444 col79 VARCHAR2(500) := FND_API.G_MISS_CHAR,
445 col80 VARCHAR2(500) := FND_API.G_MISS_CHAR,
446 col81 VARCHAR2(500) := FND_API.G_MISS_CHAR,
447 col82 VARCHAR2(500) := FND_API.G_MISS_CHAR,
448 col83 VARCHAR2(500) := FND_API.G_MISS_CHAR,
449 col84 VARCHAR2(500) := FND_API.G_MISS_CHAR,
450 col85 VARCHAR2(500) := FND_API.G_MISS_CHAR,
451 col86 VARCHAR2(500) := FND_API.G_MISS_CHAR,
452 col87 VARCHAR2(500) := FND_API.G_MISS_CHAR,
453 col88 VARCHAR2(500) := FND_API.G_MISS_CHAR,
454 col89 VARCHAR2(500) := FND_API.G_MISS_CHAR,
455 col90 VARCHAR2(500) := FND_API.G_MISS_CHAR,
456 col91 VARCHAR2(500) := FND_API.G_MISS_CHAR,
457 col92 VARCHAR2(500) := FND_API.G_MISS_CHAR,
458 col93 VARCHAR2(500) := FND_API.G_MISS_CHAR,
459 col94 VARCHAR2(500) := FND_API.G_MISS_CHAR,
460 col95 VARCHAR2(500) := FND_API.G_MISS_CHAR,
461 col96 VARCHAR2(500) := FND_API.G_MISS_CHAR,
462 col97 VARCHAR2(500) := FND_API.G_MISS_CHAR,
463 col98 VARCHAR2(500) := FND_API.G_MISS_CHAR,
464 col99 VARCHAR2(500) := FND_API.G_MISS_CHAR,
465 col100 VARCHAR2(500) := FND_API.G_MISS_CHAR,
466 col101 VARCHAR2(500) := FND_API.G_MISS_CHAR,
467 col102 VARCHAR2(500) := FND_API.G_MISS_CHAR,
468 col103 VARCHAR2(500) := FND_API.G_MISS_CHAR,
469 col104 VARCHAR2(500) := FND_API.G_MISS_CHAR,
470 col105 VARCHAR2(500) := FND_API.G_MISS_CHAR,
471 col106 VARCHAR2(500) := FND_API.G_MISS_CHAR,
472 col107 VARCHAR2(500) := FND_API.G_MISS_CHAR,
476 col111 VARCHAR2(500) := FND_API.G_MISS_CHAR,
473 col108 VARCHAR2(500) := FND_API.G_MISS_CHAR,
474 col109 VARCHAR2(500) := FND_API.G_MISS_CHAR,
475 col110 VARCHAR2(500) := FND_API.G_MISS_CHAR,
477 col112 VARCHAR2(500) := FND_API.G_MISS_CHAR,
478 col113 VARCHAR2(500) := FND_API.G_MISS_CHAR,
479 col114 VARCHAR2(500) := FND_API.G_MISS_CHAR,
480 col115 VARCHAR2(500) := FND_API.G_MISS_CHAR,
481 col116 VARCHAR2(500) := FND_API.G_MISS_CHAR,
482 col117 VARCHAR2(500) := FND_API.G_MISS_CHAR,
483 col118 VARCHAR2(500) := FND_API.G_MISS_CHAR,
484 col119 VARCHAR2(500) := FND_API.G_MISS_CHAR,
485 col120 VARCHAR2(500) := FND_API.G_MISS_CHAR,
486 col121 VARCHAR2(500) := FND_API.G_MISS_CHAR,
487 col122 VARCHAR2(500) := FND_API.G_MISS_CHAR,
488 col123 VARCHAR2(500) := FND_API.G_MISS_CHAR,
489 col124 VARCHAR2(500) := FND_API.G_MISS_CHAR,
490 col125 VARCHAR2(500) := FND_API.G_MISS_CHAR,
491 col126 VARCHAR2(500) := FND_API.G_MISS_CHAR,
492 col127 VARCHAR2(500) := FND_API.G_MISS_CHAR,
493 col128 VARCHAR2(500) := FND_API.G_MISS_CHAR,
494 col129 VARCHAR2(500) := FND_API.G_MISS_CHAR,
495 col130 VARCHAR2(500) := FND_API.G_MISS_CHAR,
496 col131 VARCHAR2(500) := FND_API.G_MISS_CHAR,
497 col132 VARCHAR2(500) := FND_API.G_MISS_CHAR,
498 col133 VARCHAR2(500) := FND_API.G_MISS_CHAR,
499 col134 VARCHAR2(500) := FND_API.G_MISS_CHAR,
500 col135 VARCHAR2(500) := FND_API.G_MISS_CHAR,
501 col136 VARCHAR2(500) := FND_API.G_MISS_CHAR,
502 col137 VARCHAR2(500) := FND_API.G_MISS_CHAR,
503 col138 VARCHAR2(500) := FND_API.G_MISS_CHAR,
504 col139 VARCHAR2(500) := FND_API.G_MISS_CHAR,
505 col140 VARCHAR2(500) := FND_API.G_MISS_CHAR,
506 col141 VARCHAR2(500) := FND_API.G_MISS_CHAR,
507 col142 VARCHAR2(500) := FND_API.G_MISS_CHAR,
508 col143 VARCHAR2(500) := FND_API.G_MISS_CHAR,
509 col144 VARCHAR2(500) := FND_API.G_MISS_CHAR,
510 col145 VARCHAR2(500) := FND_API.G_MISS_CHAR,
511 col146 VARCHAR2(500) := FND_API.G_MISS_CHAR,
512 col147 VARCHAR2(500) := FND_API.G_MISS_CHAR,
513 col148 VARCHAR2(500) := FND_API.G_MISS_CHAR,
514 col149 VARCHAR2(500) := FND_API.G_MISS_CHAR,
515 col150 VARCHAR2(500) := FND_API.G_MISS_CHAR,
516 col151 VARCHAR2(500) := FND_API.G_MISS_CHAR,
517 col152 VARCHAR2(500) := FND_API.G_MISS_CHAR,
518 col153 VARCHAR2(500) := FND_API.G_MISS_CHAR,
519 col154 VARCHAR2(500) := FND_API.G_MISS_CHAR,
520 col155 VARCHAR2(500) := FND_API.G_MISS_CHAR,
521 col156 VARCHAR2(500) := FND_API.G_MISS_CHAR,
522 col157 VARCHAR2(500) := FND_API.G_MISS_CHAR,
523 col158 VARCHAR2(500) := FND_API.G_MISS_CHAR,
524 col159 VARCHAR2(500) := FND_API.G_MISS_CHAR,
525 col160 VARCHAR2(500) := FND_API.G_MISS_CHAR,
526 col161 VARCHAR2(500) := FND_API.G_MISS_CHAR,
527 col162 VARCHAR2(500) := FND_API.G_MISS_CHAR,
528 col163 VARCHAR2(500) := FND_API.G_MISS_CHAR,
529 col164 VARCHAR2(500) := FND_API.G_MISS_CHAR,
530 col165 VARCHAR2(500) := FND_API.G_MISS_CHAR,
531 col166 VARCHAR2(500) := FND_API.G_MISS_CHAR,
532 col167 VARCHAR2(500) := FND_API.G_MISS_CHAR,
533 col168 VARCHAR2(500) := FND_API.G_MISS_CHAR,
534 col169 VARCHAR2(500) := FND_API.G_MISS_CHAR,
535 col170 VARCHAR2(500) := FND_API.G_MISS_CHAR,
536 col171 VARCHAR2(500) := FND_API.G_MISS_CHAR,
537 col172 VARCHAR2(500) := FND_API.G_MISS_CHAR,
538 col173 VARCHAR2(500) := FND_API.G_MISS_CHAR,
539 col174 VARCHAR2(500) := FND_API.G_MISS_CHAR,
540 col175 VARCHAR2(500) := FND_API.G_MISS_CHAR,
541 col176 VARCHAR2(500) := FND_API.G_MISS_CHAR,
542 col177 VARCHAR2(500) := FND_API.G_MISS_CHAR,
543 col178 VARCHAR2(500) := FND_API.G_MISS_CHAR,
544 col179 VARCHAR2(500) := FND_API.G_MISS_CHAR,
545 col180 VARCHAR2(500) := FND_API.G_MISS_CHAR,
546 col181 VARCHAR2(500) := FND_API.G_MISS_CHAR,
547 col182 VARCHAR2(500) := FND_API.G_MISS_CHAR,
548 col183 VARCHAR2(500) := FND_API.G_MISS_CHAR,
552 col187 VARCHAR2(500) := FND_API.G_MISS_CHAR,
549 col184 VARCHAR2(500) := FND_API.G_MISS_CHAR,
550 col185 VARCHAR2(500) := FND_API.G_MISS_CHAR,
551 col186 VARCHAR2(500) := FND_API.G_MISS_CHAR,
553 col188 VARCHAR2(500) := FND_API.G_MISS_CHAR,
554 col189 VARCHAR2(500) := FND_API.G_MISS_CHAR,
555 col190 VARCHAR2(500) := FND_API.G_MISS_CHAR,
556 col191 VARCHAR2(500) := FND_API.G_MISS_CHAR,
557 col192 VARCHAR2(500) := FND_API.G_MISS_CHAR,
558 col193 VARCHAR2(500) := FND_API.G_MISS_CHAR,
559 col194 VARCHAR2(500) := FND_API.G_MISS_CHAR,
560 col195 VARCHAR2(500) := FND_API.G_MISS_CHAR,
561 col196 VARCHAR2(500) := FND_API.G_MISS_CHAR,
562 col197 VARCHAR2(500) := FND_API.G_MISS_CHAR,
563 col198 VARCHAR2(500) := FND_API.G_MISS_CHAR,
564 col199 VARCHAR2(500) := FND_API.G_MISS_CHAR,
565 col200 VARCHAR2(500) := FND_API.G_MISS_CHAR,
566 COL201 VARCHAR2(500) := FND_API.G_MISS_CHAR,
567 COL202 VARCHAR2(500) := FND_API.G_MISS_CHAR,
568 COL203 VARCHAR2(500) := FND_API.G_MISS_CHAR,
569 COL204 VARCHAR2(500) := FND_API.G_MISS_CHAR,
570 COL205 VARCHAR2(500) := FND_API.G_MISS_CHAR,
571 COL206 VARCHAR2(500) := FND_API.G_MISS_CHAR,
572 COL207 VARCHAR2(500) := FND_API.G_MISS_CHAR,
573 COL208 VARCHAR2(500) := FND_API.G_MISS_CHAR,
574 COL209 VARCHAR2(500) := FND_API.G_MISS_CHAR,
575 COL210 VARCHAR2(500) := FND_API.G_MISS_CHAR,
576 COL211 VARCHAR2(500) := FND_API.G_MISS_CHAR,
577 COL212 VARCHAR2(500) := FND_API.G_MISS_CHAR,
578 COL213 VARCHAR2(500) := FND_API.G_MISS_CHAR,
579 COL214 VARCHAR2(500) := FND_API.G_MISS_CHAR,
580 COL215 VARCHAR2(500) := FND_API.G_MISS_CHAR,
581 COL216 VARCHAR2(500) := FND_API.G_MISS_CHAR,
582 COL217 VARCHAR2(500) := FND_API.G_MISS_CHAR,
583 COL218 VARCHAR2(500) := FND_API.G_MISS_CHAR,
584 COL219 VARCHAR2(500) := FND_API.G_MISS_CHAR,
585 COL220 VARCHAR2(500) := FND_API.G_MISS_CHAR,
586 COL221 VARCHAR2(500) := FND_API.G_MISS_CHAR,
587 COL222 VARCHAR2(500) := FND_API.G_MISS_CHAR,
588 COL223 VARCHAR2(500) := FND_API.G_MISS_CHAR,
589 COL224 VARCHAR2(500) := FND_API.G_MISS_CHAR,
590 COL225 VARCHAR2(500) := FND_API.G_MISS_CHAR,
591 COL226 VARCHAR2(500) := FND_API.G_MISS_CHAR,
592 COL227 VARCHAR2(500) := FND_API.G_MISS_CHAR,
593 COL228 VARCHAR2(500) := FND_API.G_MISS_CHAR,
594 COL229 VARCHAR2(500) := FND_API.G_MISS_CHAR,
595 COL230 VARCHAR2(500) := FND_API.G_MISS_CHAR,
596 COL231 VARCHAR2(500) := FND_API.G_MISS_CHAR,
597 COL232 VARCHAR2(500) := FND_API.G_MISS_CHAR,
598 COL233 VARCHAR2(500) := FND_API.G_MISS_CHAR,
599 COL234 VARCHAR2(500) := FND_API.G_MISS_CHAR,
600 COL235 VARCHAR2(500) := FND_API.G_MISS_CHAR,
601 COL236 VARCHAR2(500) := FND_API.G_MISS_CHAR,
602 COL237 VARCHAR2(500) := FND_API.G_MISS_CHAR,
603 COL238 VARCHAR2(500) := FND_API.G_MISS_CHAR,
604 COL239 VARCHAR2(500) := FND_API.G_MISS_CHAR,
605 COL240 VARCHAR2(500) := FND_API.G_MISS_CHAR,
606 COL241 VARCHAR2(4000) := FND_API.G_MISS_CHAR,
607 COL242 VARCHAR2(4000) := FND_API.G_MISS_CHAR,
608 COL243 VARCHAR2(4000) := FND_API.G_MISS_CHAR,
609 COL244 VARCHAR2(4000) := FND_API.G_MISS_CHAR,
610 COL245 VARCHAR2(4000) := FND_API.G_MISS_CHAR,
611 COL246 VARCHAR2(4000) := FND_API.G_MISS_CHAR,
612 COL247 VARCHAR2(4000) := FND_API.G_MISS_CHAR,
613 COL248 VARCHAR2(4000) := FND_API.G_MISS_CHAR,
614 COL249 VARCHAR2(4000) := FND_API.G_MISS_CHAR,
615 COL250 VARCHAR2(4000) := FND_API.G_MISS_CHAR,
616 COL251 VARCHAR2(500) := FND_API.G_MISS_CHAR,
617 COL252 VARCHAR2(500) := FND_API.G_MISS_CHAR,
618 COL253 VARCHAR2(500) := FND_API.G_MISS_CHAR,
619 COL254 VARCHAR2(500) := FND_API.G_MISS_CHAR,
620 COL255 VARCHAR2(500) := FND_API.G_MISS_CHAR,
621 COL256 VARCHAR2(500) := FND_API.G_MISS_CHAR,
622 COL257 VARCHAR2(500) := FND_API.G_MISS_CHAR,
623 COL258 VARCHAR2(500) := FND_API.G_MISS_CHAR,
627 COL262 VARCHAR2(500) := FND_API.G_MISS_CHAR,
624 COL259 VARCHAR2(500) := FND_API.G_MISS_CHAR,
625 COL260 VARCHAR2(500) := FND_API.G_MISS_CHAR,
626 COL261 VARCHAR2(500) := FND_API.G_MISS_CHAR,
628 COL263 VARCHAR2(500) := FND_API.G_MISS_CHAR,
629 COL264 VARCHAR2(500) := FND_API.G_MISS_CHAR,
630 COL265 VARCHAR2(500) := FND_API.G_MISS_CHAR,
631 COL266 VARCHAR2(500) := FND_API.G_MISS_CHAR,
632 COL267 VARCHAR2(500) := FND_API.G_MISS_CHAR,
633 COL268 VARCHAR2(500) := FND_API.G_MISS_CHAR,
634 COL269 VARCHAR2(500) := FND_API.G_MISS_CHAR,
635 COL270 VARCHAR2(500) := FND_API.G_MISS_CHAR,
636 COL271 VARCHAR2(500) := FND_API.G_MISS_CHAR,
637 COL272 VARCHAR2(500) := FND_API.G_MISS_CHAR,
638 COL273 VARCHAR2(500) := FND_API.G_MISS_CHAR,
639 COL274 VARCHAR2(500) := FND_API.G_MISS_CHAR,
640 COL275 VARCHAR2(500) := FND_API.G_MISS_CHAR,
641 COL276 VARCHAR2(500) := FND_API.G_MISS_CHAR,
642 COL277 VARCHAR2(500) := FND_API.G_MISS_CHAR,
643 COL278 VARCHAR2(500) := FND_API.G_MISS_CHAR,
644 COL279 VARCHAR2(500) := FND_API.G_MISS_CHAR,
645 COL280 VARCHAR2(500) := FND_API.G_MISS_CHAR,
646 COL281 VARCHAR2(500) := FND_API.G_MISS_CHAR,
647 COL282 VARCHAR2(500) := FND_API.G_MISS_CHAR,
648 COL283 VARCHAR2(500) := FND_API.G_MISS_CHAR,
649 COL284 VARCHAR2(500) := FND_API.G_MISS_CHAR,
650 COL285 VARCHAR2(500) := FND_API.G_MISS_CHAR,
651 COL286 VARCHAR2(500) := FND_API.G_MISS_CHAR,
652 COL287 VARCHAR2(500) := FND_API.G_MISS_CHAR,
653 COL288 VARCHAR2(500) := FND_API.G_MISS_CHAR,
654 COL289 VARCHAR2(500) := FND_API.G_MISS_CHAR,
655 COL290 VARCHAR2(500) := FND_API.G_MISS_CHAR,
656 COL291 VARCHAR2(500) := FND_API.G_MISS_CHAR,
657 COL292 VARCHAR2(500) := FND_API.G_MISS_CHAR,
658 COL293 VARCHAR2(500) := FND_API.G_MISS_CHAR,
659 COL294 VARCHAR2(500) := FND_API.G_MISS_CHAR,
660 COL295 VARCHAR2(500) := FND_API.G_MISS_CHAR,
661 COL296 VARCHAR2(500) := FND_API.G_MISS_CHAR,
662 COL297 VARCHAR2(500) := FND_API.G_MISS_CHAR,
663 COL298 VARCHAR2(500) := FND_API.G_MISS_CHAR,
664 COL299 VARCHAR2(500) := FND_API.G_MISS_CHAR,
665 COL300 VARCHAR2(500) := FND_API.G_MISS_CHAR,
666 CURR_CP_COUNTRY_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
667 CURR_CP_PHONE_NUMBER VARCHAR2(10) := FND_API.G_MISS_CHAR,
668 CURR_CP_RAW_PHONE_NUMBER VARCHAR2(60) := FND_API.G_MISS_CHAR,
669 CURR_CP_AREA_CODE NUMBER := FND_API.G_MISS_NUM,
670 CURR_CP_ID NUMBER := FND_API.G_MISS_NUM,
671 CURR_CP_INDEX NUMBER := FND_API.G_MISS_NUM,
672 CURR_CP_TIME_ZONE NUMBER := FND_API.G_MISS_NUM,
673 CURR_CP_TIME_ZONE_AUX NUMBER := FND_API.G_MISS_NUM,
674 party_id NUMBER := FND_API.G_MISS_NUM,
675 parent_party_id NUMBER := FND_API.G_MISS_NUM,
676 imp_source_line_id NUMBER := FND_API.G_MISS_NUM,
677 usage_restriction VARCHAR2(1) := FND_API.G_MISS_CHAR,
678 next_call_time DATE := FND_API.G_MISS_DATE,
679 callback_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
680 do_not_use_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
681 do_not_use_reason VARCHAR2(30) := FND_API.G_MISS_CHAR,
682 record_out_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
683 record_release_time DATE := FND_API.G_MISS_DATE,
684 group_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
685 newly_updated_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
686 outcome_id NUMBER := FND_API.G_MISS_NUM,
687 result_id NUMBER := FND_API.G_MISS_NUM,
688 reason_id NUMBER := FND_API.G_MISS_NUM,
689 notes varchar2(4000) := FND_API.G_MISS_CHAR,
690 VEHICLE_RESPONSE_CODE varchar2(30) := FND_API.G_MISS_CHAR,
691 SALES_AGENT_EMAIL_ADDRESS varchar2(2000) := FND_API.G_MISS_CHAR,
692 RESOURCE_ID number := FND_API.G_MISS_NUM,
693 LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
694 CONTACT_POINT_ID NUMBER := FND_API.G_MISS_NUM,
695 last_contacted_date DATE := FND_API.G_MISS_DATE
696 );
697
698 g_miss_list_entries_rec list_entries_rec_type;
699 TYPE list_entries_tbl_type IS TABLE OF list_entries_rec_type INDEX BY BINARY_INTEGER;
700 g_miss_list_entries_tbl list_entries_tbl_type;
701
702 -- ==============================================================================
703 -- Start of Comments
707 -- Type
704 -- ==============================================================================
705 -- API Name
706 -- Create_List_Entries
708 -- Private
709 -- Pre-Req
710 --
711 -- Parameters
712 --
713 -- IN
714 -- p_api_version_number IN NUMBER Required
715 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
716 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
717 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
718 -- p_list_entries_rec IN list_entries_rec_type Required
719 --
720 -- OUT
721 -- x_return_status OUT VARCHAR2
722 -- x_msg_count OUT NUMBER
723 -- x_msg_data OUT VARCHAR2
724 -- Version : Current version 1.0
725 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
726 -- and basic operation, developer must manually add parameters and business logic as necessary.
727 --
728 -- End of Comments
729 -- ==============================================================================
730 --
731
732 PROCEDURE Create_List_Entries(
733 p_api_version_number IN NUMBER,
734 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
735 p_commit IN VARCHAR2 := FND_API.G_FALSE,
736 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
737
738 x_return_status OUT NOCOPY VARCHAR2,
739 x_msg_count OUT NOCOPY NUMBER,
740 x_msg_data OUT NOCOPY VARCHAR2,
741
742 p_list_entries_rec IN list_entries_rec_type := g_miss_list_entries_rec,
743 x_list_entry_id OUT NOCOPY NUMBER
744 );
745
746 -- ==============================================================================
747 -- Start of Comments
748 -- ==============================================================================
749 -- API Name
750 -- Update_List_Entries
751 -- Type
752 -- Private
753 -- Pre-Req
754 --
755 -- Parameters
756 --
757 -- IN
758 -- p_api_version_number IN NUMBER Required
759 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
760 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
761 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
762 -- p_list_entries_rec IN list_entries_rec_type Required
763 --
764 -- OUT
765 -- x_return_status OUT VARCHAR2
766 -- x_msg_count OUT NUMBER
767 -- x_msg_data OUT VARCHAR2
768 -- Version : Current version 1.0
769 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
770 -- and basic operation, developer must manually add parameters and business logic as necessary.
771 --
772 -- End of Comments
773 -- ==============================================================================
774 --
775
776 PROCEDURE Update_List_Entries(
777 p_api_version_number IN NUMBER,
778 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
779 p_commit IN VARCHAR2 := FND_API.G_FALSE,
780 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
781 x_return_status OUT NOCOPY VARCHAR2,
782 x_msg_count OUT NOCOPY NUMBER,
783 x_msg_data OUT NOCOPY VARCHAR2,
784 p_list_entries_rec IN list_entries_rec_type,
785 x_object_version_number OUT NOCOPY NUMBER
786 );
787
788 -- ==============================================================================
789 -- Start of Comments
790 -- ==============================================================================
791 -- API Name
792 -- Delete_List_Entries
793 -- Type
794 -- Private
795 -- Pre-Req
796 --
797 -- Parameters
798 --
799 -- IN
800 -- p_api_version_number IN NUMBER Required
801 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
802 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
803 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
804 -- p_LIST_ENTRY_ID IN NUMBER
805 -- p_object_version_number IN NUMBER Optional Default = NULL
806 --
807 -- OUT
808 -- x_return_status OUT VARCHAR2
809 -- x_msg_count OUT NUMBER
810 -- x_msg_data OUT VARCHAR2
811 -- Version : Current version 1.0
812 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
813 -- and basic operation, developer must manually add parameters and business logic as necessary.
814 --
815 -- End of Comments
816 -- ==============================================================================
817 --
818
819 PROCEDURE Delete_List_Entries(
820 p_api_version_number IN NUMBER,
824 x_return_status OUT NOCOPY VARCHAR2,
821 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
822 p_commit IN VARCHAR2 := FND_API.G_FALSE,
823 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
825 x_msg_count OUT NOCOPY NUMBER,
826 x_msg_data OUT NOCOPY VARCHAR2,
827 p_list_entry_id IN NUMBER,
828 p_object_version_number IN NUMBER
829 );
830
831 -- ==============================================================================
832 -- Start of Comments
833 -- ==============================================================================
834 -- API Name
835 -- Lock_List_Entries
836 -- Type
837 -- Private
838 -- Pre-Req
839 --
840 -- Parameters
841 --
842 -- IN
843 -- p_api_version_number IN NUMBER Required
844 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
845 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
846 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
847 -- p_list_entries_rec IN list_entries_rec_type Required
848 --
849 -- OUT
850 -- x_return_status OUT VARCHAR2
851 -- x_msg_count OUT NUMBER
852 -- x_msg_data OUT VARCHAR2
853 -- Version : Current version 1.0
854 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
855 -- and basic operation, developer must manually add parameters and business logic as necessary.
856 --
857 -- End of Comments
858 -- ==============================================================================
859 --
860
861 PROCEDURE Lock_List_Entries(
862 p_api_version_number IN NUMBER,
863 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
864
865 x_return_status OUT NOCOPY VARCHAR2,
866 x_msg_count OUT NOCOPY NUMBER,
867 x_msg_data OUT NOCOPY VARCHAR2,
868
869 p_list_entry_id IN NUMBER,
870 p_object_version IN NUMBER
871 );
872
873
874 -- Start of Comments
875 --
876 -- validation procedures
877 --
878 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
879 -- For create: G_CREATE, for update: G_UPDATE
880 -- Note: 1. This is automated generated item level validation procedure.
881 -- The actual validation detail is needed to be added.
882 -- 2. We can also validate table instead of record. There will be an option for user to choose.
883 -- End of Comments
884
885 PROCEDURE Validate_list_entries(
886 p_api_version_number IN NUMBER,
887 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
888 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
889 p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_update,
890 p_list_entries_rec IN list_entries_rec_type,
891 x_return_status OUT NOCOPY VARCHAR2,
892 x_msg_count OUT NOCOPY NUMBER,
893 x_msg_data OUT NOCOPY VARCHAR2
894 );
895
896 -- Start of Comments
897 --
898 -- validation procedures
899 --
900 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
901 -- For create: G_CREATE, for update: G_UPDATE
902 -- Note: 1. This is automated generated item level validation procedure.
903 -- The actual validation detail is needed to be added.
904 -- 2. Validate the unique keys, lookups here
905 -- End of Comments
906
907 PROCEDURE Check_list_entries_Items (
908 P_list_entries_rec IN list_entries_rec_type,
909 p_validation_mode IN VARCHAR2,
910 x_return_status OUT NOCOPY VARCHAR2
911 );
912
913 -- Start of Comments
914 --
915 -- Record level validation procedures
916 --
917 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
918 -- For create: G_CREATE, for update: G_UPDATE
919 -- Note: 1. This is automated generated item level validation procedure.
920 -- The actual validation detail is needed to be added.
921 -- 2. Developer can manually added inter-field level validation.
922 -- End of Comments
923
924 PROCEDURE Validate_list_entries_rec(
925 p_api_version_number IN NUMBER,
926 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
927 x_return_status OUT NOCOPY VARCHAR2,
928 x_msg_count OUT NOCOPY NUMBER,
929 x_msg_data OUT NOCOPY VARCHAR2,
930 p_list_entries_rec IN list_entries_rec_type
931 );
932 PROCEDURE init_entry_rec(
933 x_entry_rec OUT NOCOPY list_entries_rec_type
934 ) ;
935
936
937 PROCEDURE Copy_List_Entries
938 (
939 p_api_version_number IN NUMBER,
940 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
941 p_commit IN VARCHAR2 := FND_API.G_FALSE,
942 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
943 x_return_status OUT NOCOPY VARCHAR2,
944 x_msg_count OUT NOCOPY NUMBER,
945 x_msg_data OUT NOCOPY VARCHAR2,
946 p_list_header_id IN NUMBER,
947 p_new_list_header_id IN NUMBER
948
949 );
950
951
952
953 END AMS_List_Entries_PVT;