[Home] [Help]
PACKAGE: APPS.AMS_IS_LINE_PUB
Source
1 PACKAGE AMS_Is_Line_PUB AUTHID CURRENT_USER AS
2 /* $Header: amspisls.pls 115.7 2002/11/22 08:53:54 jieli ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- AMS_Is_Line_PUB
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,
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,
414 col97 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,
424 col107 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,
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,
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,
488 col171 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,
499 col182 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,
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 );
572
573 g_miss_is_line_rec is_line_rec_type;
574 TYPE is_line_tbl_type IS TABLE OF is_line_rec_type INDEX BY BINARY_INTEGER;
575 g_miss_is_line_tbl is_line_tbl_type;
576
577 TYPE is_line_sort_rec_type IS RECORD
578 (
579 -- Please define your own sort by record here.
580 object_version_number NUMBER := NULL
581 );
582
583 -- ==============================================================================
584 -- Start of Comments
585 -- ==============================================================================
586 -- API Name
587 -- Create_Is_Line
588 -- Type
589 -- Public
590 -- Pre-Req
591 --
592 -- Parameters
593 --
594 -- IN
595 -- p_api_version_number IN NUMBER Required
596 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
597 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
598 -- p_is_line_rec IN is_line_rec_type Required
599 --
600 -- OUT
601 -- x_return_status OUT VARCHAR2
602 -- x_msg_count OUT NUMBER
603 -- x_msg_data OUT VARCHAR2
604 -- Version : Current version 1.0
605 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
606 -- and basic operation, developer must manually add parameters and business logic as necessary.
607 --
608 -- End of Comments
609 -- ==============================================================================
610 --
611
612 PROCEDURE Create_Is_Line(
613 p_api_version_number IN NUMBER,
614 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
615 p_commit IN VARCHAR2 := FND_API.G_FALSE,
616
617 x_return_status OUT NOCOPY VARCHAR2,
618 x_msg_count OUT NOCOPY NUMBER,
619 x_msg_data OUT NOCOPY VARCHAR2,
620
621 p_is_line_rec IN is_line_rec_type := g_miss_is_line_rec,
622 x_import_source_line_id OUT NOCOPY NUMBER
623 );
624
625 -- ==============================================================================
626 -- Start of Comments
627 -- ==============================================================================
628 -- API Name
629 -- Update_Is_Line
630 -- Type
631 -- Public
632 -- Pre-Req
633 --
634 -- Parameters
635 --
636 -- IN
637 -- p_api_version_number IN NUMBER Required
638 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
639 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
640 -- p_is_line_rec IN is_line_rec_type Required
641 --
642 -- OUT
643 -- x_return_status OUT VARCHAR2
644 -- x_msg_count OUT NUMBER
645 -- x_msg_data OUT VARCHAR2
646 -- Version : Current version 1.0
647 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
648 -- and basic operation, developer must manually add parameters and business logic as necessary.
649 --
650 -- End of Comments
651 -- ==============================================================================
652 --
653
654 PROCEDURE Update_Is_Line(
655 p_api_version_number IN NUMBER,
656 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
657 p_commit IN VARCHAR2 := FND_API.G_FALSE,
658
659 x_return_status OUT NOCOPY VARCHAR2,
660 x_msg_count OUT NOCOPY NUMBER,
661 x_msg_data OUT NOCOPY VARCHAR2,
662
663 p_is_line_rec IN is_line_rec_type,
664 x_object_version_number OUT NOCOPY NUMBER
665 );
666
667 -- ==============================================================================
668 -- Start of Comments
669 -- ==============================================================================
670 -- API Name
671 -- Delete_Is_Line
672 -- Type
673 -- Public
674 -- Pre-Req
675 --
676 -- Parameters
677 --
678 -- IN
679 -- p_api_version_number IN NUMBER Required
680 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
684 --
681 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
682 -- p_IMPORT_SOURCE_LINE_ID IN NUMBER
683 -- p_object_version_number IN NUMBER Optional Default = NULL
685 -- OUT
686 -- x_return_status OUT VARCHAR2
687 -- x_msg_count OUT NUMBER
688 -- x_msg_data OUT VARCHAR2
689 -- Version : Current version 1.0
690 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
691 -- and basic operation, developer must manually add parameters and business logic as necessary.
692 --
693 -- End of Comments
694 -- ==============================================================================
695 --
696
697 PROCEDURE Delete_Is_Line(
698 p_api_version_number IN NUMBER,
699 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
700 p_commit IN VARCHAR2 := FND_API.G_FALSE,
701 x_return_status OUT NOCOPY VARCHAR2,
702 x_msg_count OUT NOCOPY NUMBER,
703 x_msg_data OUT NOCOPY VARCHAR2,
704 p_import_source_line_id IN NUMBER,
705 p_object_version_number IN NUMBER
706 );
707
708 -- ==============================================================================
709 -- Start of Comments
710 -- ==============================================================================
711 -- API Name
712 -- Lock_Is_Line
713 -- Type
714 -- Public
715 -- Pre-Req
716 --
717 -- Parameters
718 --
719 -- IN
720 -- p_api_version_number IN NUMBER Required
721 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
722 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
723 -- p_is_line_rec IN is_line_rec_type Required
724 --
725 -- OUT
726 -- x_return_status OUT VARCHAR2
727 -- x_msg_count OUT NUMBER
728 -- x_msg_data OUT VARCHAR2
729 -- Version : Current version 1.0
730 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
731 -- and basic operation, developer must manually add parameters and business logic as necessary.
732 --
733 -- End of Comments
734 -- ==============================================================================
735 --
736
737 PROCEDURE Lock_Is_Line(
738 p_api_version_number IN NUMBER,
739 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
740 x_return_status OUT NOCOPY VARCHAR2,
741 x_msg_count OUT NOCOPY NUMBER,
742 x_msg_data OUT NOCOPY VARCHAR2,
743
744 p_import_source_line_id IN NUMBER,
745 p_object_version IN NUMBER
746 );
747
748 END AMS_Is_Line_PUB;