[Home] [Help]
PACKAGE: APPS.AMS_IS_LINE_PVT
Source
1 PACKAGE AMS_Is_Line_PVT AUTHID CURRENT_USER AS
2 /* $Header: amsvisls.pls 115.9 2004/01/27 20:48:12 sranka ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- AMS_Is_Line_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 -- is_line_rec_type
23 -- -------------------------------------------------------
24 -- Parameters:
25 -- import_source_line_id
26 -- object_version_number
27 -- last_update_date
28 -- last_updated_by
29 -- creation_date
30 -- created_by
31 -- last_update_login
32 -- import_list_header_id
33 -- import_successful_flag
34 -- enabled_flag
35 -- import_failure_reason
36 -- re_import_last_done_date
37 -- party_id
38 -- dedupe_key
39 -- col1
40 -- col2
41 -- col3
42 -- col4
43 -- col5
44 -- col6
45 -- col7
46 -- col8
47 -- col9
48 -- col10
49 -- col11
50 -- col12
51 -- col13
52 -- col14
53 -- col15
54 -- col16
55 -- col17
56 -- col18
57 -- col19
58 -- col20
59 -- col21
60 -- col22
61 -- col23
62 -- col24
63 -- col25
64 -- col26
65 -- col27
66 -- col28
67 -- col29
68 -- col30
69 -- col31
70 -- col32
71 -- col33
72 -- col34
73 -- col35
74 -- col36
75 -- col37
76 -- col38
77 -- col39
78 -- col40
79 -- col41
80 -- col42
81 -- col43
82 -- col44
83 -- col45
84 -- col46
85 -- col47
86 -- col48
87 -- col49
88 -- col50
89 -- col51
90 -- col52
91 -- col53
92 -- col54
93 -- col55
94 -- col56
95 -- col57
96 -- col58
97 -- col59
98 -- col60
99 -- col61
100 -- col62
101 -- col63
102 -- col64
103 -- col65
104 -- col66
105 -- col67
106 -- col68
107 -- col69
108 -- col70
109 -- col71
110 -- col72
111 -- col73
112 -- col74
113 -- col75
114 -- col76
115 -- col77
116 -- col78
117 -- col79
118 -- col80
119 -- col81
120 -- col82
121 -- col83
122 -- col84
123 -- col85
124 -- col86
125 -- col87
126 -- col88
127 -- col89
128 -- col90
129 -- col91
130 -- col92
131 -- col93
132 -- col94
133 -- col95
134 -- col96
135 -- col97
136 -- col98
137 -- col99
138 -- col100
139 -- col101
140 -- col102
141 -- col103
142 -- col104
143 -- col105
144 -- col106
145 -- col107
146 -- col108
147 -- col109
148 -- col110
149 -- col111
150 -- col112
151 -- col113
152 -- col114
153 -- col115
154 -- col116
155 -- col117
156 -- col118
157 -- col119
158 -- col120
159 -- col121
160 -- col122
161 -- col123
162 -- col124
163 -- col125
164 -- col126
165 -- col127
166 -- col128
167 -- col129
168 -- col130
169 -- col131
170 -- col132
171 -- col133
172 -- col134
173 -- col135
174 -- col136
175 -- col137
176 -- col138
177 -- col139
178 -- col140
179 -- col141
180 -- col142
181 -- col143
182 -- col144
183 -- col145
184 -- col146
185 -- col147
186 -- col148
187 -- col149
188 -- col150
189 -- col151
190 -- col152
191 -- col153
192 -- col154
193 -- col155
194 -- col156
195 -- col157
196 -- col158
197 -- col159
198 -- col160
199 -- col161
200 -- col162
201 -- col163
202 -- col164
203 -- col165
204 -- col166
205 -- col167
206 -- col168
207 -- col169
208 -- col170
209 -- col171
210 -- col172
211 -- col173
212 -- col174
213 -- col175
214 -- col176
215 -- col177
216 -- col178
217 -- col179
218 -- col180
219 -- col181
220 -- col182
221 -- col183
222 -- col184
223 -- col185
224 -- col186
225 -- col187
226 -- col188
227 -- col189
228 -- col190
229 -- col191
230 -- col192
231 -- col193
232 -- col194
233 -- col195
234 -- col196
235 -- col197
236 -- col198
237 -- col199
238 -- col200
239 -- col201
240 -- col202
241 -- col203
242 -- col204
243 -- col205
244 -- col206
245 -- col207
246 -- col208
247 -- col209
248 -- col210
249 -- col211
250 -- col212
251 -- col213
252 -- col214
253 -- col215
254 -- col216
255 -- col217
256 -- col218
257 -- col219
258 -- col220
259 -- col221
260 -- col222
261 -- col223
262 -- col224
263 -- col225
264 -- col226
265 -- col227
266 -- col228
267 -- col229
268 -- col230
269 -- col231
270 -- col232
271 -- col233
272 -- col234
273 -- col235
274 -- col236
275 -- col237
276 -- col238
277 -- col239
278 -- col240
279 -- col241
280 -- col242
281 -- col243
282 -- col244
283 -- col245
284 -- col246
285 -- col247
286 -- col248
287 -- col249
288 -- col250
289 -- duplicate_flag
290 -- current_usage
291 --
292 -- Required
293 --
294 -- Defaults
295 --
296 -- Note: This is automatic generated record definition, it includes all columns
297 -- defined in the table, developer must manually add or delete some of the attributes.
298 --
299 -- End of Comments
300
301 --===================================================================
302 TYPE is_line_rec_type IS RECORD
303 (
304 import_source_line_id NUMBER := FND_API.G_MISS_NUM,
305 object_version_number NUMBER := FND_API.G_MISS_NUM,
306 last_update_date DATE := FND_API.G_MISS_DATE,
307 last_updated_by NUMBER := FND_API.G_MISS_NUM,
308 creation_date DATE := FND_API.G_MISS_DATE,
309 created_by NUMBER := FND_API.G_MISS_NUM,
310 last_update_login NUMBER := FND_API.G_MISS_NUM,
311 import_list_header_id NUMBER := FND_API.G_MISS_NUM,
312 import_successful_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
313 enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
314 import_failure_reason VARCHAR2(4000) := FND_API.G_MISS_CHAR,
315 re_import_last_done_date DATE := FND_API.G_MISS_DATE,
316 party_id NUMBER := FND_API.G_MISS_NUM,
317 dedupe_key VARCHAR2(500) := FND_API.G_MISS_CHAR,
318 col1 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
319 col2 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
320 col3 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
321 col4 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
322 col5 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
323 col6 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
324 col7 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
325 col8 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
326 col9 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
327 col10 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
328 col11 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
329 col12 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
330 col13 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
331 col14 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
332 col15 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
333 col16 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
334 col17 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
335 col18 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
336 col19 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
337 col20 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
338 col21 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
339 col22 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
340 col23 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
341 col24 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
342 col25 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
343 col26 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
344 col27 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
345 col28 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
346 col29 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
347 col30 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
348 col31 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
349 col32 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
350 col33 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
351 col34 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
352 col35 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
353 col36 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
354 col37 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
355 col38 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
356 col39 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
357 col40 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
358 col41 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
359 col42 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
360 col43 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
361 col44 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
362 col45 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
363 col46 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
364 col47 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
365 col48 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
366 col49 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
367 col50 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
368 col51 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
369 col52 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
370 col53 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
371 col54 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
372 col55 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
373 col56 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
374 col57 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
375 col58 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
376 col59 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
377 col60 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
378 col61 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
379 col62 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
380 col63 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
381 col64 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
382 col65 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
383 col66 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
384 col67 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
385 col68 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
386 col69 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
387 col70 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
388 col71 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
389 col72 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
390 col73 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
391 col74 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
392 col75 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
393 col76 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
394 col77 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
395 col78 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
396 col79 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
397 col80 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
398 col81 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
399 col82 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
400 col83 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
401 col84 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
402 col85 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
403 col86 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
404 col87 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
405 col88 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
406 col89 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
407 col90 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
408 col91 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
409 col92 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
410 col93 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
414 col97 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
411 col94 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
412 col95 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
413 col96 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
415 col98 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
416 col99 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
417 col100 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
418 col101 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
419 col102 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
420 col103 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
421 col104 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
422 col105 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
423 col106 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
424 col107 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
425 col108 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
426 col109 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
427 col110 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
428 col111 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
429 col112 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
430 col113 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
431 col114 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
432 col115 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
433 col116 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
434 col117 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
435 col118 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
436 col119 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
437 col120 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
438 col121 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
439 col122 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
440 col123 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
441 col124 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
442 col125 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
443 col126 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
444 col127 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
445 col128 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
446 col129 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
447 col130 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
448 col131 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
449 col132 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
450 col133 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
451 col134 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
452 col135 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
453 col136 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
454 col137 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
455 col138 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
456 col139 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
457 col140 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
458 col141 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
459 col142 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
460 col143 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
461 col144 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
462 col145 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
463 col146 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
464 col147 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
465 col148 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
466 col149 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
467 col150 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
468 col151 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
469 col152 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
470 col153 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
471 col154 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
472 col155 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
473 col156 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
474 col157 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
475 col158 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
476 col159 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
477 col160 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
478 col161 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
479 col162 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
480 col163 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
481 col164 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
482 col165 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
483 col166 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
484 col167 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
488 col171 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
485 col168 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
486 col169 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
487 col170 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
489 col172 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
490 col173 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
491 col174 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
492 col175 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
493 col176 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
494 col177 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
495 col178 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
496 col179 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
497 col180 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
498 col181 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
499 col182 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
500 col183 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
501 col184 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
502 col185 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
503 col186 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
504 col187 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
505 col188 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
506 col189 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
507 col190 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
508 col191 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
509 col192 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
510 col193 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
511 col194 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
512 col195 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
513 col196 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
514 col197 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
515 col198 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
516 col199 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
517 col200 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
518 col201 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
519 col202 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
520 col203 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
521 col204 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
522 col205 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
523 col206 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
524 col207 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
525 col208 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
526 col209 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
527 col210 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
528 col211 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
529 col212 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
530 col213 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
531 col214 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
532 col215 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
533 col216 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
534 col217 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
535 col218 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
536 col219 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
537 col220 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
538 col221 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
539 col222 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
540 col223 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
541 col224 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
542 col225 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
543 col226 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
544 col227 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
545 col228 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
546 col229 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
547 col230 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
548 col231 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
549 col232 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
550 col233 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
551 col234 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
552 col235 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
553 col236 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
554 col237 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
555 col238 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
556 col239 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
557 col240 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
558 col241 VARCHAR2(4000) := FND_API.G_MISS_CHAR,
562 col245 VARCHAR2(4000) := FND_API.G_MISS_CHAR,
559 col242 VARCHAR2(4000) := FND_API.G_MISS_CHAR,
560 col243 VARCHAR2(4000) := FND_API.G_MISS_CHAR,
561 col244 VARCHAR2(4000) := FND_API.G_MISS_CHAR,
563 col246 VARCHAR2(4000) := FND_API.G_MISS_CHAR,
564 col247 VARCHAR2(4000) := FND_API.G_MISS_CHAR,
565 col248 VARCHAR2(4000) := FND_API.G_MISS_CHAR,
566 col249 VARCHAR2(4000) := FND_API.G_MISS_CHAR,
567 col250 VARCHAR2(4000) := FND_API.G_MISS_CHAR,
568 duplicate_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
569 current_usage NUMBER := FND_API.G_MISS_NUM,
570 load_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
571 notes VARCHAR2(4000) := FND_API.G_MISS_CHAR,
572 sales_agent_email_address VARCHAR2(2000) := FND_API.G_MISS_CHAR,
573 vehicle_response_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
574
575 custom_column1 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
576 custom_column2 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
577 custom_column3 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
578 custom_column4 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
579 custom_column5 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
580 custom_column6 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
581 custom_column7 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
582 custom_column8 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
583 custom_column9 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
584 custom_column10 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
585 custom_column11 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
586 custom_column12 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
587 custom_column13 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
588 custom_column14 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
589 custom_column15 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
590 custom_column16 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
591 custom_column17 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
592 custom_column18 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
593 custom_column19 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
594 custom_column20 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
595 custom_column21 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
596 custom_column22 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
597 custom_column23 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
598 custom_column24 VARCHAR2(2000) := FND_API.G_MISS_CHAR,
599 custom_column25 VARCHAR2(2000) := FND_API.G_MISS_CHAR
600
601
602
603 );
604
605 g_miss_is_line_rec is_line_rec_type;
606 TYPE is_line_tbl_type IS TABLE OF is_line_rec_type INDEX BY BINARY_INTEGER;
607 g_miss_is_line_tbl is_line_tbl_type;
608
609 -- ==============================================================================
610 -- Start of Comments
611 -- ==============================================================================
612 -- API Name
613 -- Create_Is_Line
614 -- Type
615 -- Private
616 -- Pre-Req
617 --
618 -- Parameters
619 --
620 -- IN
621 -- p_api_version_number IN NUMBER Required
622 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
623 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
624 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
625 -- p_is_line_rec IN is_line_rec_type Required
626 --
627 -- OUT
628 -- x_return_status OUT VARCHAR2
629 -- x_msg_count OUT NUMBER
630 -- x_msg_data OUT VARCHAR2
631 -- Version : Current version 1.0
632 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
633 -- and basic operation, developer must manually add parameters and business logic as necessary.
634 --
635 -- End of Comments
636 -- ==============================================================================
637 --
638
639 PROCEDURE Create_Is_Line(
640 p_api_version_number IN NUMBER,
641 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
642 p_commit IN VARCHAR2 := FND_API.G_FALSE,
643 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
644
645 x_return_status OUT NOCOPY VARCHAR2,
646 x_msg_count OUT NOCOPY NUMBER,
647 x_msg_data OUT NOCOPY VARCHAR2,
648
649 p_is_line_rec IN is_line_rec_type := g_miss_is_line_rec,
653 -- ==============================================================================
650 x_import_source_line_id OUT NOCOPY NUMBER
651 );
652
654 -- Start of Comments
655 -- ==============================================================================
656 -- API Name
657 -- Update_Is_Line
658 -- Type
659 -- Private
660 -- Pre-Req
661 --
662 -- Parameters
663 --
664 -- IN
665 -- p_api_version_number IN NUMBER Required
666 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
667 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
668 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
669 -- p_is_line_rec IN is_line_rec_type Required
670 --
671 -- OUT
672 -- x_return_status OUT VARCHAR2
673 -- x_msg_count OUT NUMBER
674 -- x_msg_data OUT VARCHAR2
675 -- Version : Current version 1.0
676 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
677 -- and basic operation, developer must manually add parameters and business logic as necessary.
678 --
679 -- End of Comments
680 -- ==============================================================================
681 --
682
683 PROCEDURE Update_Is_Line(
684 p_api_version_number IN NUMBER,
685 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
686 p_commit IN VARCHAR2 := FND_API.G_FALSE,
687 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
688
689 x_return_status OUT NOCOPY VARCHAR2,
690 x_msg_count OUT NOCOPY NUMBER,
691 x_msg_data OUT NOCOPY VARCHAR2,
692
693 p_is_line_rec IN is_line_rec_type,
694 x_object_version_number OUT NOCOPY NUMBER
695 );
696
697 -- ==============================================================================
698 -- Start of Comments
699 -- ==============================================================================
700 -- API Name
701 -- Delete_Is_Line
702 -- Type
703 -- Private
704 -- Pre-Req
705 --
706 -- Parameters
707 --
708 -- IN
709 -- p_api_version_number IN NUMBER Required
710 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
711 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
712 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
713 -- p_IMPORT_SOURCE_LINE_ID IN NUMBER
714 -- p_object_version_number IN NUMBER Optional Default = NULL
715 --
716 -- OUT
717 -- x_return_status OUT VARCHAR2
718 -- x_msg_count OUT NUMBER
719 -- x_msg_data OUT VARCHAR2
720 -- Version : Current version 1.0
721 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
722 -- and basic operation, developer must manually add parameters and business logic as necessary.
723 --
724 -- End of Comments
725 -- ==============================================================================
726 --
727
728 PROCEDURE Delete_Is_Line(
729 p_api_version_number IN NUMBER,
730 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
731 p_commit IN VARCHAR2 := FND_API.G_FALSE,
732 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
733 x_return_status OUT NOCOPY VARCHAR2,
734 x_msg_count OUT NOCOPY NUMBER,
735 x_msg_data OUT NOCOPY VARCHAR2,
736 p_import_source_line_id IN NUMBER,
737 p_object_version_number IN NUMBER
738 );
739
740 -- ==============================================================================
741 -- Start of Comments
742 -- ==============================================================================
743 -- API Name
744 -- Lock_Is_Line
745 -- Type
746 -- Private
747 -- Pre-Req
748 --
749 -- Parameters
750 --
751 -- IN
752 -- p_api_version_number IN NUMBER Required
753 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
754 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
755 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
756 -- p_is_line_rec IN is_line_rec_type Required
757 --
758 -- OUT
759 -- x_return_status OUT VARCHAR2
760 -- x_msg_count OUT NUMBER
761 -- x_msg_data OUT VARCHAR2
762 -- Version : Current version 1.0
763 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
767 -- ==============================================================================
764 -- and basic operation, developer must manually add parameters and business logic as necessary.
765 --
766 -- End of Comments
768 --
769
770 PROCEDURE Lock_Is_Line(
771 p_api_version_number IN NUMBER,
772 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
773
774 x_return_status OUT NOCOPY VARCHAR2,
775 x_msg_count OUT NOCOPY NUMBER,
776 x_msg_data OUT NOCOPY VARCHAR2,
777
778 p_import_source_line_id IN NUMBER,
779 p_object_version IN NUMBER
780 );
781
782
783 -- Start of Comments
784 --
785 -- validation procedures
786 --
787 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
788 -- For create: G_CREATE, for update: G_UPDATE
789 -- Note: 1. This is automated generated item level validation procedure.
790 -- The actual validation detail is needed to be added.
791 -- 2. We can also validate table instead of record. There will be an option for user to choose.
792 -- End of Comments
793
794 PROCEDURE Validate_is_line(
795 p_api_version_number IN NUMBER,
796 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
797 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
798 p_is_line_rec IN is_line_rec_type,
799 x_return_status OUT NOCOPY VARCHAR2,
800 x_msg_count OUT NOCOPY NUMBER,
801 x_msg_data OUT NOCOPY VARCHAR2
802 );
803
804 -- Start of Comments
805 --
806 -- validation procedures
807 --
808 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
809 -- For create: G_CREATE, for update: G_UPDATE
810 -- Note: 1. This is automated generated item level validation procedure.
811 -- The actual validation detail is needed to be added.
812 -- 2. Validate the unique keys, lookups here
813 -- End of Comments
814
815 PROCEDURE Check_is_line_Items (
816 P_is_line_rec IN is_line_rec_type,
817 p_validation_mode IN VARCHAR2,
818 x_return_status OUT NOCOPY VARCHAR2
819 );
820
821 -- Start of Comments
822 --
823 -- Record level validation procedures
824 --
825 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
826 -- For create: G_CREATE, for update: G_UPDATE
827 -- Note: 1. This is automated generated item level validation procedure.
828 -- The actual validation detail is needed to be added.
829 -- 2. Developer can manually added inter-field level validation.
830 -- End of Comments
831
832 PROCEDURE Validate_is_line_rec(
833 p_api_version_number IN NUMBER,
834 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
835 x_return_status OUT NOCOPY VARCHAR2,
836 x_msg_count OUT NOCOPY NUMBER,
837 x_msg_data OUT NOCOPY VARCHAR2,
838 p_is_line_rec IN is_line_rec_type
839 );
840 END AMS_Is_Line_PVT;