[Home] [Help]
PACKAGE: APPS.CSI_ITEM_INSTANCE_GRP
Source
1 PACKAGE CSI_ITEM_INSTANCE_GRP AUTHID CURRENT_USER as
2 /* $Header: csigiis.pls 120.8.12010000.1 2008/07/25 08:08:12 appldev ship $ */
3
4
5 TYPE T_DATE is TABLE OF DATE INDEX BY BINARY_INTEGER;
6 TYPE T_NUM is TABLE OF NUMBER INDEX BY BINARY_INTEGER;
7 TYPE T_V1 is TABLE OF VARCHAR(01) INDEX BY BINARY_INTEGER;
8 TYPE T_V3 is TABLE OF VARCHAR(03) INDEX BY BINARY_INTEGER;
9 TYPE T_V10 is TABLE OF VARCHAR(10) INDEX BY BINARY_INTEGER;
10 TYPE T_V15 is TABLE OF VARCHAR(15) INDEX BY BINARY_INTEGER;
11 TYPE T_V20 is TABLE OF VARCHAR(20) INDEX BY BINARY_INTEGER;
12 TYPE T_V25 is TABLE OF VARCHAR(25) INDEX BY BINARY_INTEGER;
13 TYPE T_V30 is TABLE OF VARCHAR(30) INDEX BY BINARY_INTEGER;
14 TYPE T_V35 is TABLE OF VARCHAR(35) INDEX BY BINARY_INTEGER;
15 TYPE T_V40 is TABLE OF VARCHAR(40) INDEX BY BINARY_INTEGER;
16 TYPE T_V50 is TABLE OF VARCHAR(50) INDEX BY BINARY_INTEGER;
17 TYPE T_V60 is TABLE OF VARCHAR(60) INDEX BY BINARY_INTEGER;
18 TYPE T_V80 is TABLE OF VARCHAR(80) INDEX BY BINARY_INTEGER;
19 TYPE T_V85 is TABLE OF VARCHAR(85) INDEX BY BINARY_INTEGER;
20 TYPE T_V150 is TABLE OF VARCHAR(150) INDEX BY BINARY_INTEGER;
21 TYPE T_V240 is TABLE OF VARCHAR(240) INDEX BY BINARY_INTEGER;
22 TYPE T_V360 is TABLE OF VARCHAR(360) INDEX BY BINARY_INTEGER;
23 TYPE T_V1000 is TABLE OF VARCHAR(1000) INDEX BY BINARY_INTEGER;
24 TYPE T_V2000 is TABLE OF VARCHAR(2000) INDEX BY BINARY_INTEGER;
25
26 --
27 TYPE INSTANCE_REC_TAB IS RECORD
28 (
29 INSTANCE_ID T_NUM
30 ,INSTANCE_NUMBER T_V30
31 ,EXTERNAL_REFERENCE T_V30
32 ,INVENTORY_ITEM_ID T_NUM
33 ,VLD_ORGANIZATION_ID T_NUM
34 ,INVENTORY_REVISION T_V3
35 ,INV_MASTER_ORGANIZATION_ID T_NUM
36 ,SERIAL_NUMBER T_V30
37 ,MFG_SERIAL_NUMBER_FLAG T_V1
38 ,LOT_NUMBER T_V80
39 ,QUANTITY T_NUM
40 ,UNIT_OF_MEASURE T_V3
41 ,ACCOUNTING_CLASS_CODE T_V10
42 ,INSTANCE_CONDITION_ID T_NUM
43 ,INSTANCE_STATUS_ID T_NUM
44 ,CUSTOMER_VIEW_FLAG T_V1
45 ,MERCHANT_VIEW_FLAG T_V1
46 ,SELLABLE_FLAG T_V1
47 ,SYSTEM_ID T_NUM
48 ,INSTANCE_TYPE_CODE T_V30
49 ,ACTIVE_START_DATE T_DATE
50 ,ACTIVE_END_DATE T_DATE
51 ,LOCATION_TYPE_CODE T_V30
52 ,LOCATION_ID T_NUM
53 ,INV_ORGANIZATION_ID T_NUM
54 ,INV_SUBINVENTORY_NAME T_V10
55 ,INV_LOCATOR_ID T_NUM
56 ,PA_PROJECT_ID T_NUM
57 ,PA_PROJECT_TASK_ID T_NUM
58 ,IN_TRANSIT_ORDER_LINE_ID T_NUM
59 ,WIP_JOB_ID T_NUM
60 ,PO_ORDER_LINE_ID T_NUM
61 ,LAST_OE_ORDER_LINE_ID T_NUM
62 ,LAST_OE_RMA_LINE_ID T_NUM
63 ,LAST_PO_PO_LINE_ID T_NUM
64 ,LAST_OE_PO_NUMBER T_V50
65 ,LAST_WIP_JOB_ID T_NUM
66 ,LAST_PA_PROJECT_ID T_NUM
67 ,LAST_PA_TASK_ID T_NUM
68 ,LAST_OE_AGREEMENT_ID T_NUM
69 ,INSTALL_DATE T_DATE
70 ,MANUALLY_CREATED_FLAG T_V1
71 ,RETURN_BY_DATE T_DATE
72 ,ACTUAL_RETURN_DATE T_DATE
73 ,CREATION_COMPLETE_FLAG T_V1
74 ,COMPLETENESS_FLAG T_V1
75 ,VERSION_LABEL T_V240
76 ,VERSION_LABEL_DESCRIPTION T_V240
77 ,CONTEXT T_V30
78 ,ATTRIBUTE1 T_V240
79 ,ATTRIBUTE2 T_V240
80 ,ATTRIBUTE3 T_V240
81 ,ATTRIBUTE4 T_V240
82 ,ATTRIBUTE5 T_V240
83 ,ATTRIBUTE6 T_V240
84 ,ATTRIBUTE7 T_V240
85 ,ATTRIBUTE8 T_V240
86 ,ATTRIBUTE9 T_V240
87 ,ATTRIBUTE10 T_V240
88 ,ATTRIBUTE11 T_V240
89 ,ATTRIBUTE12 T_V240
90 ,ATTRIBUTE13 T_V240
91 ,ATTRIBUTE14 T_V240
92 ,ATTRIBUTE15 T_V240
93 ,OBJECT_VERSION_NUMBER T_NUM
94 ,LAST_TXN_LINE_DETAIL_ID T_NUM
95 ,INSTALL_LOCATION_TYPE_CODE T_V30
96 ,INSTALL_LOCATION_ID T_NUM
97 ,INSTANCE_USAGE_CODE T_V30
98 ,CHECK_FOR_INSTANCE_EXPIRY T_V1
99 ,CALL_CONTRACTS T_V1
100 ,GRP_CALL_CONTRACTS T_V1
101 ,CONFIG_INST_HDR_ID T_NUM
102 ,CONFIG_INST_REV_NUM T_NUM
103 ,CONFIG_INST_ITEM_ID T_NUM
104 ,CONFIG_VALID_STATUS T_V30
105 ,INSTANCE_DESCRIPTION T_V240
106 ,NETWORK_ASSET_FLAG T_V1
107 ,MAINTAINABLE_FLAG T_V1
108 ,ASSET_CRITICALITY_CODE T_V30
109 ,CATEGORY_ID T_NUM
110 ,EQUIPMENT_GEN_OBJECT_ID T_NUM
111 ,INSTANTIATION_FLAG T_V1
112 ,OPERATIONAL_LOG_FLAG T_V1
113 ,SUPPLIER_WARRANTY_EXP_DATE T_DATE
114 ,ATTRIBUTE16 T_V240
115 ,ATTRIBUTE17 T_V240
116 ,ATTRIBUTE18 T_V240
117 ,ATTRIBUTE19 T_V240
118 ,ATTRIBUTE20 T_V240
119 ,ATTRIBUTE21 T_V240
120 ,ATTRIBUTE22 T_V240
121 ,ATTRIBUTE23 T_V240
122 ,ATTRIBUTE24 T_V240
123 ,ATTRIBUTE25 T_V240
124 ,ATTRIBUTE26 T_V240
125 ,ATTRIBUTE27 T_V240
126 ,ATTRIBUTE28 T_V240
127 ,ATTRIBUTE29 T_V240
128 ,ATTRIBUTE30 T_V240
129 ,PURCHASE_UNIT_PRICE T_NUM
130 ,PURCHASE_CURRENCY_CODE T_V15
131 ,PAYABLES_UNIT_PRICE T_NUM
132 ,PAYABLES_CURRENCY_CODE T_V15
133 ,SALES_UNIT_PRICE T_NUM
134 ,SALES_CURRENCY_CODE T_V15
135 ,OPERATIONAL_STATUS_CODE T_V30
136 );
137 --
138 TYPE INSTANCE_HISTORY_REC_TAB IS RECORD
139 (
140 instance_id T_NUM
141 ,old_instance_number T_V30
142 ,new_instance_number T_V30
143 ,old_external_reference T_V30
144 ,new_external_reference T_V30
145 ,old_inventory_item_id T_NUM
146 ,new_inventory_item_id T_NUM
147 ,old_inventory_revision T_V3
148 ,new_inventory_revision T_V3
149 ,old_inv_master_org_id T_NUM
150 ,new_inv_master_org_id T_NUM
151 ,old_serial_number T_V30
152 ,new_serial_number T_V30
153 ,old_mfg_serial_number_flag T_V1
154 ,new_mfg_serial_number_flag T_V1
155 ,old_lot_number T_V80
156 ,new_lot_number T_V80
157 ,old_quantity T_NUM
158 ,new_quantity T_NUM
159 ,old_unit_of_measure_name T_V30
160 ,new_unit_of_measure_name T_V30
161 ,old_unit_of_measure T_V3
162 ,new_unit_of_measure T_V3
163 ,old_accounting_class T_V30
164 ,new_accounting_class T_V30
165 ,old_accounting_class_code T_V10
166 ,new_accounting_class_code T_V10
167 ,old_instance_condition T_V80
168 ,new_instance_condition T_V80
169 ,old_instance_condition_id T_NUM
170 ,new_instance_condition_id T_NUM
171 ,old_instance_status T_V50
172 ,new_instance_status T_V50
173 ,old_instance_status_id T_NUM
174 ,new_instance_status_id T_NUM
175 ,old_customer_view_flag T_V1
176 ,new_customer_view_flag T_V1
177 ,old_merchant_view_flag T_V1
178 ,new_merchant_view_flag T_V1
179 ,old_sellable_flag T_V1
180 ,new_sellable_flag T_V1
181 ,old_system_id T_NUM
182 ,new_system_id T_NUM
183 ,old_system_name T_V30
184 ,new_system_name T_V30
185 ,old_instance_type_code T_V30
186 ,new_instance_type_code T_V30
187 ,old_instance_type_name T_V240
188 ,new_instance_type_name T_V240
189 ,old_active_start_date T_DATE
190 ,new_active_start_date T_DATE
191 ,old_active_end_date T_DATE
192 ,new_active_end_date T_DATE
193 ,old_location_type_code T_V30
194 ,new_location_type_code T_V30
195 ,old_location_id T_NUM
196 ,new_location_id T_NUM
197 ,old_inv_organization_id T_NUM
198 ,new_inv_organization_id T_NUM
199 ,old_inv_organization_name T_V60
200 ,new_inv_organization_name T_V60
201 ,old_inv_subinventory_name T_V10
202 ,new_inv_subinventory_name T_V10
203 ,old_inv_locator_id T_NUM
204 ,new_inv_locator_id T_NUM
205 ,old_pa_project_id T_NUM
206 ,new_pa_project_id T_NUM
207 ,old_pa_project_task_id T_NUM
208 ,new_pa_project_task_id T_NUM
209 ,old_pa_project_name T_V30
210 ,new_pa_project_name T_V30
211 ,old_pa_project_number T_V25
212 ,new_pa_project_number T_V25
213 ,old_pa_task_name T_V20
214 ,new_pa_task_name T_V20
215 ,old_pa_task_number T_V25
216 ,new_pa_task_number T_V25
217 ,old_in_transit_order_line_id T_NUM
218 ,new_in_transit_order_line_id T_NUM
219 ,old_in_transit_order_line_num T_NUM
220 ,new_in_transit_order_line_num T_NUM
221 ,old_in_transit_order_number T_NUM
222 ,new_in_transit_order_number T_NUM
223 ,old_wip_job_id T_NUM
224 ,new_wip_job_id T_NUM
225 ,old_wip_entity_name T_V240
226 ,new_wip_entity_name T_V240
227 ,old_po_order_line_id T_NUM
228 ,new_po_order_line_id T_NUM
229 ,old_last_oe_order_line_id T_NUM
230 ,new_last_oe_order_line_id T_NUM
231 ,old_last_oe_rma_line_id T_NUM
232 ,new_last_oe_rma_line_id T_NUM
233 ,old_last_po_po_line_id T_NUM
234 ,new_last_po_po_line_id T_NUM
235 ,old_last_oe_po_number T_V50
236 ,new_last_oe_po_number T_V50
237 ,old_last_wip_job_id T_NUM
238 ,new_last_wip_job_id T_NUM
239 ,old_last_pa_project_id T_NUM
240 ,new_last_pa_project_id T_NUM
241 ,old_last_pa_task_id T_NUM
242 ,new_last_pa_task_id T_NUM
243 ,old_last_oe_agreement_id T_NUM
244 ,new_last_oe_agreement_id T_NUM
245 ,old_install_date T_DATE
246 ,new_install_date T_DATE
247 ,old_manually_created_flag T_V1
248 ,new_manually_created_flag T_V1
249 ,old_return_by_date T_DATE
250 ,new_return_by_date T_DATE
251 ,old_actual_return_date T_DATE
252 ,new_actual_return_date T_DATE
253 ,old_creation_complete_flag T_V1
254 ,new_creation_complete_flag T_V1
255 ,old_completeness_flag T_V1
256 ,new_completeness_flag T_V1
257 ,old_context T_V30
258 ,new_context T_V30
259 ,old_attribute1 T_V240
260 ,new_attribute1 T_V240
261 ,old_attribute2 T_V240
262 ,new_attribute2 T_V240
263 ,old_attribute3 T_V240
264 ,new_attribute3 T_V240
265 ,old_attribute4 T_V240
266 ,new_attribute4 T_V240
267 ,old_attribute5 T_V240
268 ,new_attribute5 T_V240
269 ,old_attribute6 T_V240
270 ,new_attribute6 T_V240
271 ,old_attribute7 T_V240
272 ,new_attribute7 T_V240
273 ,old_attribute8 T_V240
274 ,new_attribute8 T_V240
275 ,old_attribute9 T_V240
276 ,new_attribute9 T_V240
277 ,old_attribute10 T_V240
278 ,new_attribute10 T_V240
279 ,old_attribute11 T_V240
280 ,new_attribute11 T_V240
281 ,old_attribute12 T_V240
282 ,new_attribute12 T_V240
283 ,old_attribute13 T_V240
284 ,new_attribute13 T_V240
285 ,old_attribute14 T_V240
286 ,new_attribute14 T_V240
287 ,old_attribute15 T_V240
288 ,new_attribute15 T_V240
289 ,old_last_txn_line_detail_id T_NUM
290 ,new_last_txn_line_detail_id T_NUM
291 ,old_install_location_type_code T_V30
292 ,new_install_location_type_code T_V30
293 ,old_install_location_id T_NUM
294 ,new_install_location_id T_NUM
295 ,old_instance_usage_code T_V30
296 ,new_instance_usage_code T_V30
297 ,old_current_loc_address1 T_V240
298 ,new_current_loc_address1 T_V240
299 ,old_current_loc_address2 T_V240
300 ,new_current_loc_address2 T_V240
301 ,old_current_loc_address3 T_V240
302 ,new_current_loc_address3 T_V240
303 ,old_current_loc_address4 T_V240
304 ,new_current_loc_address4 T_V240
305 ,old_current_loc_city T_V60
306 ,new_current_loc_city T_V60
307 ,old_current_loc_postal_code T_V60
308 ,new_current_loc_postal_code T_V60
309 ,old_current_loc_country T_V60
310 ,new_current_loc_country T_V60
311 ,old_sales_order_number T_NUM
312 ,new_sales_order_number T_NUM
313 ,old_sales_order_line_number T_NUM
314 ,new_sales_order_line_number T_NUM
315 ,old_sales_order_date T_DATE
316 ,new_sales_order_date T_DATE
317 ,old_purchase_order_number T_V50
318 ,new_purchase_order_number T_V50
319 ,old_instance_usage_name T_V80
320 ,new_instance_usage_name T_V80
321 ,old_current_loc_state T_V60
322 ,new_current_loc_state T_V60
323 ,old_install_loc_address1 T_V240
324 ,new_install_loc_address1 T_V240
325 ,old_install_loc_address2 T_V240
326 ,new_install_loc_address2 T_V240
327 ,old_install_loc_address3 T_V240
328 ,new_install_loc_address3 T_V240
329 ,old_install_loc_address4 T_V240
330 ,new_install_loc_address4 T_V240
331 ,old_install_loc_city T_V60
332 ,new_install_loc_city T_V60
333 ,old_install_loc_state T_V60
334 ,new_install_loc_state T_V60
335 ,old_install_loc_postal_code T_V60
336 ,new_install_loc_postal_code T_V60
337 ,old_install_loc_country T_V60
338 ,new_install_loc_country T_V60
339 ,old_config_inst_rev_num T_NUM
340 ,new_config_inst_rev_num T_NUM
341 ,old_config_valid_status T_V30
342 ,new_config_valid_status T_V30
343 ,old_instance_description T_V240
344 ,new_instance_description T_V240
345 ,instance_history_id T_NUM
346 ,transaction_id T_NUM
347 ,old_last_vld_organization_id T_NUM
348 ,new_last_vld_organization_id T_NUM
349 ,old_network_asset_flag T_V1
350 ,new_network_asset_flag T_V1
351 ,old_maintainable_flag T_V1
352 ,new_maintainable_flag T_V1
353 ,old_pn_location_id T_NUM
354 ,new_pn_location_id T_NUM
355 ,old_asset_criticality_code T_V30
356 ,new_asset_criticality_code T_V30
357 ,old_category_id T_NUM
358 ,new_category_id T_NUM
359 ,old_equipment_gen_object_id T_NUM
360 ,new_equipment_gen_object_id T_NUM
361 ,old_instantiation_flag T_V1
362 ,new_instantiation_flag T_V1
363 ,old_linear_location_id T_NUM
364 ,new_linear_location_id T_NUM
365 ,old_operational_log_flag T_V1
366 ,new_operational_log_flag T_V1
367 ,old_checkin_status T_NUM
368 ,new_checkin_status T_NUM
369 ,old_supplier_warranty_exp_date T_DATE
370 ,new_supplier_warranty_exp_date T_DATE
371 ,old_attribute16 T_V240
372 ,new_attribute16 T_V240
373 ,old_attribute17 T_V240
374 ,new_attribute17 T_V240
375 ,old_attribute18 T_V240
376 ,new_attribute18 T_V240
377 ,old_attribute19 T_V240
378 ,new_attribute19 T_V240
379 ,old_attribute20 T_V240
380 ,new_attribute20 T_V240
381 ,old_attribute21 T_V240
382 ,new_attribute21 T_V240
383 ,old_attribute22 T_V240
384 ,new_attribute22 T_V240
385 ,old_attribute23 T_V240
386 ,new_attribute23 T_V240
387 ,old_attribute24 T_V240
388 ,new_attribute24 T_V240
389 ,old_attribute25 T_V240
390 ,new_attribute25 T_V240
391 ,old_attribute26 T_V240
392 ,new_attribute26 T_V240
393 ,old_attribute27 T_V240
394 ,new_attribute27 T_V240
395 ,old_attribute28 T_V240
396 ,new_attribute28 T_V240
397 ,old_attribute29 T_V240
398 ,new_attribute29 T_V240
399 ,old_attribute30 T_V240
400 ,new_attribute30 T_V240
401 ,old_payables_currency_code T_V15
402 ,new_payables_currency_code T_V15
403 ,old_purchase_unit_price T_NUM
404 ,new_purchase_unit_price T_NUM
405 ,old_purchase_currency_code T_V15
406 ,new_purchase_currency_code T_V15
407 ,old_payables_unit_price T_NUM
408 ,new_payables_unit_price T_NUM
409 ,old_sales_unit_price T_NUM
410 ,new_sales_unit_price T_NUM
411 ,old_sales_currency_code T_V15
412 ,new_sales_currency_code T_V15
413 ,old_operational_status_code T_V30
414 ,new_operational_status_code T_V30
415 ,full_dump_flag T_V30
416 );
417 --
418 TYPE VERSION_LABEL_REC_TAB IS RECORD
419 (
420 version_label_id T_NUM
421 ,instance_id T_NUM
422 ,version_label T_V240
423 ,description T_V240
424 ,date_time_stamp T_DATE
425 ,active_start_date T_DATE
426 ,active_end_date T_DATE
427 ,context T_V30
428 ,attribute1 T_V150
429 ,attribute2 T_V150
430 ,attribute3 T_V150
431 ,attribute4 T_V150
432 ,attribute5 T_V150
433 ,attribute6 T_V150
434 ,attribute7 T_V150
435 ,attribute8 T_V150
436 ,attribute9 T_V150
437 ,attribute10 T_V150
438 ,attribute11 T_V150
439 ,attribute12 T_V150
440 ,attribute13 T_V150
441 ,attribute14 T_V150
442 ,attribute15 T_V150
443 ,object_version_number T_NUM
444 ,parent_tbl_index T_NUM
445 );
446 --
447 TYPE VER_LABEL_HISTORY_REC_TAB IS RECORD
448 (
449 VERSION_LABEL_HISTORY_ID T_NUM
450 ,VERSION_LABEL_ID T_NUM
451 ,TRANSACTION_ID T_NUM
452 ,OLD_VERSION_LABEL T_V30
453 ,NEW_VERSION_LABEL T_V30
454 ,OLD_DESCRIPTION T_V240
455 ,NEW_DESCRIPTION T_V240
456 ,OLD_DATE_TIME_STAMP T_DATE
457 ,NEW_DATE_TIME_STAMP T_DATE
458 ,OLD_ACTIVE_START_DATE T_DATE
459 ,NEW_ACTIVE_START_DATE T_DATE
460 ,OLD_ACTIVE_END_DATE T_DATE
461 ,NEW_ACTIVE_END_DATE T_DATE
462 ,OLD_CONTEXT T_V30
463 ,NEW_CONTEXT T_V30
464 ,OLD_ATTRIBUTE1 T_V150
465 ,NEW_ATTRIBUTE1 T_V150
466 ,OLD_ATTRIBUTE2 T_V150
467 ,NEW_ATTRIBUTE2 T_V150
468 ,OLD_ATTRIBUTE3 T_V150
469 ,NEW_ATTRIBUTE3 T_V150
470 ,OLD_ATTRIBUTE4 T_V150
471 ,NEW_ATTRIBUTE4 T_V150
472 ,OLD_ATTRIBUTE5 T_V150
473 ,NEW_ATTRIBUTE5 T_V150
474 ,OLD_ATTRIBUTE6 T_V150
475 ,NEW_ATTRIBUTE6 T_V150
476 ,OLD_ATTRIBUTE7 T_V150
477 ,NEW_ATTRIBUTE7 T_V150
478 ,OLD_ATTRIBUTE8 T_V150
479 ,NEW_ATTRIBUTE8 T_V150
480 ,OLD_ATTRIBUTE9 T_V150
481 ,NEW_ATTRIBUTE9 T_V150
482 ,OLD_ATTRIBUTE10 T_V150
483 ,NEW_ATTRIBUTE10 T_V150
484 ,OLD_ATTRIBUTE11 T_V150
485 ,NEW_ATTRIBUTE11 T_V150
486 ,OLD_ATTRIBUTE12 T_V150
487 ,NEW_ATTRIBUTE12 T_V150
488 ,OLD_ATTRIBUTE13 T_V150
489 ,NEW_ATTRIBUTE13 T_V150
490 ,OLD_ATTRIBUTE14 T_V150
491 ,NEW_ATTRIBUTE14 T_V150
492 ,OLD_ATTRIBUTE15 T_V150
493 ,NEW_ATTRIBUTE15 T_V150
494 ,FULL_DUMP_FLAG T_V1
495 ,OBJECT_VERSION_NUMBER T_NUM
496 ,INSTANCE_ID T_NUM
497 );
498 --
499 TYPE PARTY_REC_TAB IS RECORD
500 (
501 instance_party_id T_NUM
502 ,instance_id T_NUM
503 ,party_source_table T_V30
504 ,party_id T_NUM
505 ,relationship_type_code T_V30
506 ,contact_flag T_V1
507 ,contact_ip_id T_NUM
508 ,active_start_date T_DATE
509 ,active_end_date T_DATE
510 ,context T_V30
511 ,attribute1 T_V150
512 ,attribute2 T_V150
513 ,attribute3 T_V150
514 ,attribute4 T_V150
515 ,attribute5 T_V150
516 ,attribute6 T_V150
517 ,attribute7 T_V150
518 ,attribute8 T_V150
519 ,attribute9 T_V150
520 ,attribute10 T_V150
521 ,attribute11 T_V150
522 ,attribute12 T_V150
523 ,attribute13 T_V150
524 ,attribute14 T_V150
525 ,attribute15 T_V150
526 ,object_version_number T_NUM
527 ,primary_flag T_V1
528 ,preferred_flag T_V1
529 ,parent_tbl_index T_NUM
530 ,call_contracts T_V1
531 ,contact_parent_tbl_index T_NUM
532 );
533 --
534 TYPE PARTY_HISTORY_REC_TAB IS RECORD
535 (
536 INSTANCE_PARTY_HISTORY_ID T_NUM
537 ,INSTANCE_PARTY_ID T_NUM
538 ,TRANSACTION_ID T_NUM
539 ,OLD_PARTY_SOURCE_TABLE T_V30
540 ,NEW_PARTY_SOURCE_TABLE T_V30
541 ,OLD_PARTY_ID T_NUM
542 ,NEW_PARTY_ID T_NUM
543 ,OLD_RELATIONSHIP_TYPE_CODE T_V30
544 ,NEW_RELATIONSHIP_TYPE_CODE T_V30
545 ,OLD_CONTACT_FLAG T_V1
546 ,NEW_CONTACT_FLAG T_V1
547 ,OLD_CONTACT_IP_ID T_NUM
548 ,NEW_CONTACT_IP_ID T_NUM
549 ,OLD_ACTIVE_START_DATE T_DATE
550 ,NEW_ACTIVE_START_DATE T_DATE
551 ,OLD_ACTIVE_END_DATE T_DATE
552 ,NEW_ACTIVE_END_DATE T_DATE
553 ,OLD_CONTEXT T_V30
554 ,NEW_CONTEXT T_V30
555 ,OLD_ATTRIBUTE1 T_V150
556 ,NEW_ATTRIBUTE1 T_V150
557 ,OLD_ATTRIBUTE2 T_V150
558 ,NEW_ATTRIBUTE2 T_V150
559 ,OLD_ATTRIBUTE3 T_V150
560 ,NEW_ATTRIBUTE3 T_V150
561 ,OLD_ATTRIBUTE4 T_V150
562 ,NEW_ATTRIBUTE4 T_V150
563 ,OLD_ATTRIBUTE5 T_V150
564 ,NEW_ATTRIBUTE5 T_V150
565 ,OLD_ATTRIBUTE6 T_V150
566 ,NEW_ATTRIBUTE6 T_V150
567 ,OLD_ATTRIBUTE7 T_V150
568 ,NEW_ATTRIBUTE7 T_V150
569 ,OLD_ATTRIBUTE8 T_V150
570 ,NEW_ATTRIBUTE8 T_V150
571 ,OLD_ATTRIBUTE9 T_V150
572 ,NEW_ATTRIBUTE9 T_V150
573 ,OLD_ATTRIBUTE10 T_V150
574 ,NEW_ATTRIBUTE10 T_V150
575 ,OLD_ATTRIBUTE11 T_V150
576 ,NEW_ATTRIBUTE11 T_V150
577 ,OLD_ATTRIBUTE12 T_V150
578 ,NEW_ATTRIBUTE12 T_V150
579 ,OLD_ATTRIBUTE13 T_V150
580 ,NEW_ATTRIBUTE13 T_V150
581 ,OLD_ATTRIBUTE14 T_V150
582 ,NEW_ATTRIBUTE14 T_V150
583 ,OLD_ATTRIBUTE15 T_V150
584 ,NEW_ATTRIBUTE15 T_V150
585 ,FULL_DUMP_FLAG T_V1
586 ,OBJECT_VERSION_NUMBER T_NUM
587 ,OLD_PREFERRED_FLAG T_V1
588 ,NEW_PREFERRED_FLAG T_V1
589 ,OLD_PRIMARY_FLAG T_V1
590 ,NEW_PRIMARY_FLAG T_V1
591 ,old_party_number T_V30
592 ,old_party_name T_V360
593 ,old_party_type T_V30
594 ,old_contact_party_number T_V30
595 ,old_contact_party_name T_V360
596 ,old_contact_party_type T_V30
597 ,old_contact_address1 T_V240
598 ,old_contact_address2 T_V240
599 ,old_contact_address3 T_V240
600 ,old_contact_address4 T_V240
601 ,old_contact_city T_V60
602 ,old_contact_state T_V60
603 ,old_contact_postal_code T_V60
604 ,old_contact_country T_V60
605 ,old_contact_work_phone_num T_V85
606 ,old_contact_email_address T_V2000
607 ,new_party_number T_V30
608 ,new_party_name T_V360
609 ,new_party_type T_V30
610 ,new_contact_party_number T_V30
611 ,new_contact_party_name T_V360
612 ,new_contact_party_type T_V30
613 ,new_contact_address1 T_V240
614 ,new_contact_address2 T_V240
615 ,new_contact_address3 T_V240
616 ,new_contact_address4 T_V240
617 ,new_contact_city T_V60
618 ,new_contact_state T_V60
619 ,new_contact_postal_code T_V60
620 ,new_contact_country T_V60
621 ,new_contact_work_phone_num T_V85
622 ,new_contact_email_address T_V2000
623 ,INSTANCE_ID T_NUM
624 );
625 --
626 TYPE ACCOUNT_REC_TAB IS RECORD
627 (
628 ip_account_id T_NUM
629 ,parent_tbl_index T_NUM
630 ,instance_party_id T_NUM
631 ,party_account_id T_NUM
632 ,relationship_type_code T_V30
633 ,bill_to_address T_NUM
634 ,ship_to_address T_NUM
635 ,active_start_date T_DATE
636 ,active_end_date T_DATE
637 ,context T_V30
638 ,attribute1 T_V150
639 ,attribute2 T_V150
640 ,attribute3 T_V150
641 ,attribute4 T_V150
642 ,attribute5 T_V150
643 ,attribute6 T_V150
644 ,attribute7 T_V150
645 ,attribute8 T_V150
646 ,attribute9 T_V150
647 ,attribute10 T_V150
648 ,attribute11 T_V150
649 ,attribute12 T_V150
650 ,attribute13 T_V150
651 ,attribute14 T_V150
652 ,attribute15 T_V150
653 ,object_version_number T_NUM
654 ,call_contracts T_V1
655 ,vld_organization_id T_NUM
656 ,expire_flag T_V1
657 ,grp_call_contracts T_V1
658 );
659 --
660 TYPE ACCOUNT_HISTORY_REC_TAB IS RECORD
661 (
662 IP_ACCOUNT_HISTORY_ID T_NUM
663 ,IP_ACCOUNT_ID T_NUM
664 ,TRANSACTION_ID T_NUM
665 ,OLD_PARTY_ACCOUNT_ID T_NUM
666 ,NEW_PARTY_ACCOUNT_ID T_NUM
667 ,OLD_RELATIONSHIP_TYPE_CODE T_V30
668 ,NEW_RELATIONSHIP_TYPE_CODE T_V30
669 ,OLD_ACTIVE_START_DATE T_DATE
670 ,NEW_ACTIVE_START_DATE T_DATE
671 ,OLD_ACTIVE_END_DATE T_DATE
672 ,NEW_ACTIVE_END_DATE T_DATE
673 ,OLD_CONTEXT T_V30
674 ,NEW_CONTEXT T_V30
675 ,OLD_ATTRIBUTE1 T_V150
676 ,NEW_ATTRIBUTE1 T_V150
677 ,OLD_ATTRIBUTE2 T_V150
678 ,NEW_ATTRIBUTE2 T_V150
679 ,OLD_ATTRIBUTE3 T_V150
680 ,NEW_ATTRIBUTE3 T_V150
681 ,OLD_ATTRIBUTE4 T_V150
682 ,NEW_ATTRIBUTE4 T_V150
683 ,OLD_ATTRIBUTE5 T_V150
684 ,NEW_ATTRIBUTE5 T_V150
685 ,OLD_ATTRIBUTE6 T_V150
686 ,NEW_ATTRIBUTE6 T_V150
687 ,OLD_ATTRIBUTE7 T_V150
688 ,NEW_ATTRIBUTE7 T_V150
689 ,OLD_ATTRIBUTE8 T_V150
690 ,NEW_ATTRIBUTE8 T_V150
691 ,OLD_ATTRIBUTE9 T_V150
692 ,NEW_ATTRIBUTE9 T_V150
693 ,OLD_ATTRIBUTE10 T_V150
694 ,NEW_ATTRIBUTE10 T_V150
695 ,OLD_ATTRIBUTE11 T_V150
696 ,NEW_ATTRIBUTE11 T_V150
697 ,OLD_ATTRIBUTE12 T_V150
698 ,NEW_ATTRIBUTE12 T_V150
699 ,OLD_ATTRIBUTE13 T_V150
700 ,NEW_ATTRIBUTE13 T_V150
701 ,OLD_ATTRIBUTE14 T_V150
702 ,NEW_ATTRIBUTE14 T_V150
703 ,OLD_ATTRIBUTE15 T_V150
704 ,NEW_ATTRIBUTE15 T_V150
705 ,FULL_DUMP_FLAG T_V1
706 ,OBJECT_VERSION_NUMBER T_NUM
707 ,OLD_BILL_TO_ADDRESS T_NUM
708 ,NEW_BILL_TO_ADDRESS T_NUM
709 ,OLD_SHIP_TO_ADDRESS T_NUM
710 ,NEW_SHIP_TO_ADDRESS T_NUM
711 ,old_party_account_number T_V30
712 ,old_party_account_name T_V240
713 ,old_bill_to_location T_V40
714 ,old_ship_to_location T_V40
715 ,new_party_account_number T_V30
716 ,new_party_account_name T_V240
717 ,new_bill_to_location T_V40
718 ,new_ship_to_location T_V40
719 ,INSTANCE_ID T_NUM
720 );
721 --
722 TYPE TRANSACTION_REC_TAB IS RECORD
723 (
724 TRANSACTION_ID T_NUM,
725 TRANSACTION_DATE T_DATE,
726 SOURCE_TRANSACTION_DATE T_DATE,
727 TRANSACTION_TYPE_ID T_NUM,
728 TXN_SUB_TYPE_ID T_NUM,
729 SOURCE_GROUP_REF_ID T_NUM,
730 SOURCE_GROUP_REF T_V50,
731 SOURCE_HEADER_REF_ID T_NUM,
732 SOURCE_HEADER_REF T_V50,
733 SOURCE_LINE_REF_ID T_NUM,
734 SOURCE_LINE_REF T_V50,
735 SOURCE_DIST_REF_ID1 T_NUM,
736 SOURCE_DIST_REF_ID2 T_NUM,
737 INV_MATERIAL_TRANSACTION_ID T_NUM,
738 TRANSACTION_QUANTITY T_NUM,
739 TRANSACTION_UOM_CODE T_V3,
740 TRANSACTED_BY T_NUM,
741 TRANSACTION_STATUS_CODE T_V30,
742 TRANSACTION_ACTION_CODE T_V30,
743 MESSAGE_ID T_NUM,
744 CONTEXT T_V30,
745 ATTRIBUTE1 T_V150,
746 ATTRIBUTE2 T_V150,
747 ATTRIBUTE3 T_V150,
748 ATTRIBUTE4 T_V150,
749 ATTRIBUTE5 T_V150,
750 ATTRIBUTE6 T_V150,
751 ATTRIBUTE7 T_V150,
752 ATTRIBUTE8 T_V150,
753 ATTRIBUTE9 T_V150,
754 ATTRIBUTE10 T_V150,
755 ATTRIBUTE11 T_V150,
756 ATTRIBUTE12 T_V150,
757 ATTRIBUTE13 T_V150,
758 ATTRIBUTE14 T_V150,
759 ATTRIBUTE15 T_V150,
760 OBJECT_VERSION_NUMBER T_NUM,
761 SPLIT_REASON_CODE T_V30,
762 GL_INTERFACE_STATUS_CODE T_NUM
763 );
764 --
765 TYPE org_units_rec_tab IS RECORD
766 (
767 instance_ou_id T_NUM
768 ,instance_id T_NUM
769 ,operating_unit_id T_NUM
770 ,relationship_type_code T_V30
771 ,active_start_date T_DATE
772 ,active_end_date T_DATE
773 ,context T_V30
774 ,attribute1 T_V150
775 ,attribute2 T_V150
776 ,attribute3 T_V150
777 ,attribute4 T_V150
778 ,attribute5 T_V150
779 ,attribute6 T_V150
780 ,attribute7 T_V150
781 ,attribute8 T_V150
782 ,attribute9 T_V150
783 ,attribute10 T_V150
784 ,attribute11 T_V150
785 ,attribute12 T_V150
786 ,attribute13 T_V150
787 ,attribute14 T_V150
788 ,attribute15 T_V150
789 ,object_version_number T_NUM
790 ,parent_tbl_index T_NUM
791 );
792 --
793 TYPE ORG_UNITS_HISTORY_REC_TAB IS RECORD
794 (
795 INSTANCE_OU_HISTORY_ID T_NUM
796 ,INSTANCE_OU_ID T_NUM
797 ,TRANSACTION_ID T_NUM
798 ,OLD_OPERATING_UNIT_ID T_NUM
799 ,NEW_OPERATING_UNIT_ID T_NUM
800 ,OLD_RELATIONSHIP_TYPE_CODE T_V30
801 ,NEW_RELATIONSHIP_TYPE_CODE T_V30
802 ,OLD_ACTIVE_START_DATE T_DATE
803 ,NEW_ACTIVE_START_DATE T_DATE
804 ,OLD_ACTIVE_END_DATE T_DATE
805 ,NEW_ACTIVE_END_DATE T_DATE
806 ,OLD_CONTEXT T_V30
807 ,NEW_CONTEXT T_V30
808 ,OLD_ATTRIBUTE1 T_V150
809 ,NEW_ATTRIBUTE1 T_V150
810 ,OLD_ATTRIBUTE2 T_V150
811 ,NEW_ATTRIBUTE2 T_V150
812 ,OLD_ATTRIBUTE3 T_V150
813 ,NEW_ATTRIBUTE3 T_V150
814 ,OLD_ATTRIBUTE4 T_V150
815 ,NEW_ATTRIBUTE4 T_V150
816 ,OLD_ATTRIBUTE5 T_V150
817 ,NEW_ATTRIBUTE5 T_V150
818 ,OLD_ATTRIBUTE6 T_V150
819 ,NEW_ATTRIBUTE6 T_V150
820 ,OLD_ATTRIBUTE7 T_V150
821 ,NEW_ATTRIBUTE7 T_V150
822 ,OLD_ATTRIBUTE8 T_V150
823 ,NEW_ATTRIBUTE8 T_V150
824 ,OLD_ATTRIBUTE9 T_V150
825 ,NEW_ATTRIBUTE9 T_V150
826 ,OLD_ATTRIBUTE10 T_V150
827 ,NEW_ATTRIBUTE10 T_V150
828 ,OLD_ATTRIBUTE11 T_V150
829 ,NEW_ATTRIBUTE11 T_V150
830 ,OLD_ATTRIBUTE12 T_V150
831 ,NEW_ATTRIBUTE12 T_V150
832 ,OLD_ATTRIBUTE13 T_V150
833 ,NEW_ATTRIBUTE13 T_V150
834 ,OLD_ATTRIBUTE14 T_V150
835 ,NEW_ATTRIBUTE14 T_V150
836 ,OLD_ATTRIBUTE15 T_V150
837 ,NEW_ATTRIBUTE15 T_V150
838 ,FULL_DUMP_FLAG T_V1
839 ,OBJECT_VERSION_NUMBER T_NUM
840 ,NEW_OPERATING_UNIT_NAME T_V60
841 ,OLD_OPERATING_UNIT_NAME T_V60
842 ,INSTANCE_ID T_NUM
843 );
844 --
845 TYPE extend_attrib_values_rec_tab IS RECORD
846 (
847 attribute_value_id T_NUM,
848 instance_id T_NUM,
849 attribute_id T_NUM,
850 attribute_code T_V30,
851 attribute_value T_V240,
852 active_start_date T_DATE,
853 active_end_date T_DATE,
854 context T_V30,
855 attribute1 T_V150,
856 attribute2 T_V150,
857 attribute3 T_V150,
858 attribute4 T_V150,
859 attribute5 T_V150,
860 attribute6 T_V150,
861 attribute7 T_V150,
862 attribute8 T_V150,
863 attribute9 T_V150,
864 attribute10 T_V150,
865 attribute11 T_V150,
866 attribute12 T_V150,
867 attribute13 T_V150,
868 attribute14 T_V150,
869 attribute15 T_V150,
870 object_version_number T_NUM,
871 parent_tbl_index T_NUM
872 );
873 --
874 TYPE ext_attrib_val_hist_rec_tab IS RECORD
875 (
876 attribute_value_history_id T_NUM,
877 attribute_value_id T_NUM,
878 transaction_id T_NUM,
879 old_attribute_value T_V240,
880 new_attribute_value T_V240,
881 old_active_start_date T_DATE,
882 new_active_start_date T_DATE,
883 old_active_end_date T_DATE,
884 new_active_end_date T_DATE,
885 old_context T_V30,
886 new_context T_V30,
887 old_attribute1 T_V150,
888 new_attribute1 T_V150,
889 old_attribute2 T_V150,
890 new_attribute2 T_V150,
891 old_attribute3 T_V150,
892 new_attribute3 T_V150,
893 old_attribute4 T_V150,
894 new_attribute4 T_V150,
895 old_attribute5 T_V150,
896 new_attribute5 T_V150,
897 old_attribute6 T_V150,
898 new_attribute6 T_V150,
899 old_attribute7 T_V150,
900 new_attribute7 T_V150,
901 old_attribute8 T_V150,
902 new_attribute8 T_V150,
903 old_attribute9 T_V150,
904 new_attribute9 T_V150,
905 old_attribute10 T_V150,
906 new_attribute10 T_V150,
907 old_attribute11 T_V150,
908 new_attribute11 T_V150,
909 old_attribute12 T_V150,
910 new_attribute12 T_V150,
911 old_attribute13 T_V150,
912 new_attribute13 T_V150,
913 old_attribute14 T_V150,
914 new_attribute14 T_V150,
915 old_attribute15 T_V150,
916 new_attribute15 T_V150,
917 attribute_code T_V30,
918 instance_id T_NUM
919 );
920 --
921 TYPE instance_asset_rec_tab IS RECORD
922 (
923 instance_asset_id T_NUM,
924 instance_id T_NUM,
925 fa_asset_id T_NUM,
926 fa_book_type_code T_V15,
927 fa_location_id T_NUM,
928 asset_quantity T_NUM,
929 update_status T_V30,
930 active_start_date T_DATE,
931 active_end_date T_DATE,
932 object_version_number T_NUM,
933 check_for_instance_expiry T_V1,
934 parent_tbl_index T_NUM,
935 fa_sync_flag T_V1
936 );
937 --
938 TYPE ins_asset_history_rec_tab IS RECORD
939 (
940 instance_asset_history_id T_NUM,
941 transaction_id T_NUM,
942 instance_asset_id T_NUM,
943 old_instance_id T_NUM,
944 new_instance_id T_NUM,
945 old_fa_asset_id T_NUM,
946 new_fa_asset_id T_NUM,
947 old_fa_book_type_code T_V15,
948 new_fa_book_type_code T_V15,
949 old_fa_location_id T_NUM,
950 new_fa_location_id T_NUM,
951 old_asset_quantity T_NUM,
952 new_asset_quantity T_NUM,
953 old_update_status T_V30,
954 new_update_status T_V30,
955 old_active_start_date T_DATE,
956 new_active_start_date T_DATE,
957 old_active_end_date T_DATE,
958 new_active_end_date T_DATE,
959 old_asset_number T_V15,
960 new_asset_number T_V15,
961 old_serial_number T_V35,
962 new_serial_number T_V35,
963 old_tag_number T_V15,
964 new_tag_number T_V15,
965 old_category T_V60,
966 new_category T_V60,
967 old_fa_location_segment1 T_V30,
968 new_fa_location_segment1 T_V30,
969 old_fa_location_segment2 T_V30,
970 new_fa_location_segment2 T_V30,
971 old_fa_location_segment3 T_V30,
972 new_fa_location_segment3 T_V30,
973 old_fa_location_segment4 T_V30,
974 new_fa_location_segment4 T_V30,
975 old_fa_location_segment5 T_V30,
976 new_fa_location_segment5 T_V30,
977 old_fa_location_segment6 T_V30,
978 new_fa_location_segment6 T_V30,
979 old_fa_location_segment7 T_V30,
980 new_fa_location_segment7 T_V30,
981 old_date_placed_in_service T_DATE,
982 new_date_placed_in_service T_DATE,
983 old_description T_V80,
984 new_description T_V80,
985 old_employee_name T_V240,
986 new_employee_name T_V240,
987 old_expense_account_number T_V25,
988 new_expense_account_number T_V25,
989 instance_id T_NUM,
990 old_fa_sync_flag T_V1,
991 new_fa_sync_flag T_V1
992 );
993 --
994 TYPE PRICING_ATTRIBS_REC_TAB IS RECORD
995 (
996 pricing_attribute_id T_NUM
997 ,instance_id T_NUM
998 ,active_start_date T_DATE
999 ,active_end_date T_DATE
1000 ,pricing_context T_V30
1001 ,pricing_attribute1 T_V150
1002 ,pricing_attribute2 T_V150
1003 ,pricing_attribute3 T_V150
1004 ,pricing_attribute4 T_V150
1005 ,pricing_attribute5 T_V150
1006 ,pricing_attribute6 T_V150
1007 ,pricing_attribute7 T_V150
1008 ,pricing_attribute8 T_V150
1009 ,pricing_attribute9 T_V150
1010 ,pricing_attribute10 T_V150
1011 ,pricing_attribute11 T_V150
1012 ,pricing_attribute12 T_V150
1013 ,pricing_attribute13 T_V150
1014 ,pricing_attribute14 T_V150
1015 ,pricing_attribute15 T_V150
1016 ,pricing_attribute16 T_V150
1017 ,pricing_attribute17 T_V150
1018 ,pricing_attribute18 T_V150
1019 ,pricing_attribute19 T_V150
1020 ,pricing_attribute20 T_V150
1021 ,pricing_attribute21 T_V150
1022 ,pricing_attribute22 T_V150
1023 ,pricing_attribute23 T_V150
1024 ,pricing_attribute24 T_V150
1025 ,pricing_attribute25 T_V150
1026 ,pricing_attribute26 T_V150
1027 ,pricing_attribute27 T_V150
1028 ,pricing_attribute28 T_V150
1029 ,pricing_attribute29 T_V150
1030 ,pricing_attribute30 T_V150
1031 ,pricing_attribute31 T_V150
1032 ,pricing_attribute32 T_V150
1033 ,pricing_attribute33 T_V150
1034 ,pricing_attribute34 T_V150
1035 ,pricing_attribute35 T_V150
1036 ,pricing_attribute36 T_V150
1037 ,pricing_attribute37 T_V150
1038 ,pricing_attribute38 T_V150
1039 ,pricing_attribute39 T_V150
1040 ,pricing_attribute40 T_V150
1041 ,pricing_attribute41 T_V150
1042 ,pricing_attribute42 T_V150
1043 ,pricing_attribute43 T_V150
1044 ,pricing_attribute44 T_V150
1045 ,pricing_attribute45 T_V150
1046 ,pricing_attribute46 T_V150
1047 ,pricing_attribute47 T_V150
1048 ,pricing_attribute48 T_V150
1049 ,pricing_attribute49 T_V150
1050 ,pricing_attribute50 T_V150
1051 ,pricing_attribute51 T_V150
1052 ,pricing_attribute52 T_V150
1053 ,pricing_attribute53 T_V150
1054 ,pricing_attribute54 T_V150
1055 ,pricing_attribute55 T_V150
1056 ,pricing_attribute56 T_V150
1057 ,pricing_attribute57 T_V150
1058 ,pricing_attribute58 T_V150
1059 ,pricing_attribute59 T_V150
1060 ,pricing_attribute60 T_V150
1061 ,pricing_attribute61 T_V150
1062 ,pricing_attribute62 T_V150
1063 ,pricing_attribute63 T_V150
1064 ,pricing_attribute64 T_V150
1065 ,pricing_attribute65 T_V150
1066 ,pricing_attribute66 T_V150
1067 ,pricing_attribute67 T_V150
1068 ,pricing_attribute68 T_V150
1069 ,pricing_attribute69 T_V150
1070 ,pricing_attribute70 T_V150
1071 ,pricing_attribute71 T_V150
1072 ,pricing_attribute72 T_V150
1073 ,pricing_attribute73 T_V150
1074 ,pricing_attribute74 T_V150
1075 ,pricing_attribute75 T_V150
1076 ,pricing_attribute76 T_V150
1077 ,pricing_attribute77 T_V150
1078 ,pricing_attribute78 T_V150
1079 ,pricing_attribute79 T_V150
1080 ,pricing_attribute80 T_V150
1081 ,pricing_attribute81 T_V150
1082 ,pricing_attribute82 T_V150
1083 ,pricing_attribute83 T_V150
1084 ,pricing_attribute84 T_V150
1085 ,pricing_attribute85 T_V150
1086 ,pricing_attribute86 T_V150
1087 ,pricing_attribute87 T_V150
1088 ,pricing_attribute88 T_V150
1089 ,pricing_attribute89 T_V150
1090 ,pricing_attribute90 T_V150
1091 ,pricing_attribute91 T_V150
1092 ,pricing_attribute92 T_V150
1093 ,pricing_attribute93 T_V150
1094 ,pricing_attribute94 T_V150
1095 ,pricing_attribute95 T_V150
1096 ,pricing_attribute96 T_V150
1097 ,pricing_attribute97 T_V150
1098 ,pricing_attribute98 T_V150
1099 ,pricing_attribute99 T_V150
1100 ,pricing_attribute100 T_V150
1101 ,context T_V30
1102 ,attribute1 T_V150
1103 ,attribute2 T_V150
1104 ,attribute3 T_V150
1105 ,attribute4 T_V150
1106 ,attribute5 T_V150
1107 ,attribute6 T_V150
1108 ,attribute7 T_V150
1109 ,attribute8 T_V150
1110 ,attribute9 T_V150
1111 ,attribute10 T_V150
1112 ,attribute11 T_V150
1113 ,attribute12 T_V150
1114 ,attribute13 T_V150
1115 ,attribute14 T_V150
1116 ,attribute15 T_V150
1117 ,object_version_number T_NUM
1118 ,parent_tbl_index T_NUM
1119 );
1120 --
1121 TYPE PRICING_ATTRIBS_HIST_REC_TAB IS RECORD
1122 (
1123 PRICE_ATTRIB_HISTORY_ID T_NUM
1124 ,PRICING_ATTRIBUTE_ID T_NUM
1125 ,TRANSACTION_ID T_NUM
1126 ,OLD_PRICING_CONTEXT T_V30
1127 ,NEW_PRICING_CONTEXT T_V30
1128 ,OLD_PRICING_ATTRIBUTE1 T_V150
1129 ,NEW_PRICING_ATTRIBUTE1 T_V150
1130 ,OLD_PRICING_ATTRIBUTE2 T_V150
1131 ,NEW_PRICING_ATTRIBUTE2 T_V150
1132 ,OLD_PRICING_ATTRIBUTE3 T_V150
1133 ,NEW_PRICING_ATTRIBUTE3 T_V150
1134 ,OLD_PRICING_ATTRIBUTE4 T_V150
1135 ,NEW_PRICING_ATTRIBUTE4 T_V150
1136 ,OLD_PRICING_ATTRIBUTE5 T_V150
1137 ,NEW_PRICING_ATTRIBUTE5 T_V150
1138 ,OLD_PRICING_ATTRIBUTE6 T_V150
1139 ,NEW_PRICING_ATTRIBUTE6 T_V150
1140 ,OLD_PRICING_ATTRIBUTE7 T_V150
1141 ,NEW_PRICING_ATTRIBUTE7 T_V150
1142 ,OLD_PRICING_ATTRIBUTE8 T_V150
1143 ,NEW_PRICING_ATTRIBUTE8 T_V150
1144 ,OLD_PRICING_ATTRIBUTE9 T_V150
1145 ,NEW_PRICING_ATTRIBUTE9 T_V150
1146 ,OLD_PRICING_ATTRIBUTE10 T_V150
1147 ,NEW_PRICING_ATTRIBUTE10 T_V150
1148 ,OLD_PRICING_ATTRIBUTE11 T_V150
1149 ,NEW_PRICING_ATTRIBUTE11 T_V150
1150 ,OLD_PRICING_ATTRIBUTE12 T_V150
1151 ,NEW_PRICING_ATTRIBUTE12 T_V150
1152 ,OLD_PRICING_ATTRIBUTE13 T_V150
1153 ,NEW_PRICING_ATTRIBUTE13 T_V150
1154 ,OLD_PRICING_ATTRIBUTE14 T_V150
1155 ,NEW_PRICING_ATTRIBUTE14 T_V150
1156 ,OLD_PRICING_ATTRIBUTE15 T_V150
1157 ,NEW_PRICING_ATTRIBUTE15 T_V150
1158 ,OLD_PRICING_ATTRIBUTE16 T_V150
1159 ,NEW_PRICING_ATTRIBUTE16 T_V150
1160 ,OLD_PRICING_ATTRIBUTE17 T_V150
1161 ,NEW_PRICING_ATTRIBUTE17 T_V150
1162 ,OLD_PRICING_ATTRIBUTE18 T_V150
1163 ,NEW_PRICING_ATTRIBUTE18 T_V150
1164 ,OLD_PRICING_ATTRIBUTE19 T_V150
1165 ,NEW_PRICING_ATTRIBUTE19 T_V150
1166 ,OLD_PRICING_ATTRIBUTE20 T_V150
1167 ,NEW_PRICING_ATTRIBUTE20 T_V150
1168 ,OLD_PRICING_ATTRIBUTE21 T_V150
1169 ,NEW_PRICING_ATTRIBUTE21 T_V150
1170 ,OLD_PRICING_ATTRIBUTE22 T_V150
1171 ,NEW_PRICING_ATTRIBUTE22 T_V150
1172 ,OLD_PRICING_ATTRIBUTE23 T_V150
1173 ,NEW_PRICING_ATTRIBUTE23 T_V150
1174 ,OLD_PRICING_ATTRIBUTE24 T_V150
1175 ,NEW_PRICING_ATTRIBUTE24 T_V150
1176 ,NEW_PRICING_ATTRIBUTE25 T_V150
1177 ,OLD_PRICING_ATTRIBUTE25 T_V150
1178 ,OLD_PRICING_ATTRIBUTE26 T_V150
1179 ,NEW_PRICING_ATTRIBUTE26 T_V150
1180 ,OLD_PRICING_ATTRIBUTE27 T_V150
1181 ,NEW_PRICING_ATTRIBUTE27 T_V150
1182 ,OLD_PRICING_ATTRIBUTE28 T_V150
1183 ,NEW_PRICING_ATTRIBUTE28 T_V150
1184 ,OLD_PRICING_ATTRIBUTE29 T_V150
1185 ,NEW_PRICING_ATTRIBUTE29 T_V150
1186 ,OLD_PRICING_ATTRIBUTE30 T_V150
1187 ,NEW_PRICING_ATTRIBUTE30 T_V150
1188 ,OLD_PRICING_ATTRIBUTE31 T_V150
1189 ,NEW_PRICING_ATTRIBUTE31 T_V150
1190 ,OLD_PRICING_ATTRIBUTE32 T_V150
1191 ,NEW_PRICING_ATTRIBUTE32 T_V150
1192 ,OLD_PRICING_ATTRIBUTE33 T_V150
1193 ,NEW_PRICING_ATTRIBUTE33 T_V150
1194 ,OLD_PRICING_ATTRIBUTE34 T_V150
1195 ,NEW_PRICING_ATTRIBUTE34 T_V150
1196 ,OLD_PRICING_ATTRIBUTE35 T_V150
1197 ,NEW_PRICING_ATTRIBUTE35 T_V150
1198 ,OLD_PRICING_ATTRIBUTE36 T_V150
1199 ,NEW_PRICING_ATTRIBUTE36 T_V150
1200 ,OLD_PRICING_ATTRIBUTE37 T_V150
1201 ,NEW_PRICING_ATTRIBUTE37 T_V150
1202 ,OLD_PRICING_ATTRIBUTE38 T_V150
1203 ,NEW_PRICING_ATTRIBUTE38 T_V150
1204 ,OLD_PRICING_ATTRIBUTE39 T_V150
1205 ,NEW_PRICING_ATTRIBUTE39 T_V150
1206 ,OLD_PRICING_ATTRIBUTE40 T_V150
1207 ,NEW_PRICING_ATTRIBUTE40 T_V150
1208 ,OLD_PRICING_ATTRIBUTE41 T_V150
1209 ,NEW_PRICING_ATTRIBUTE41 T_V150
1210 ,OLD_PRICING_ATTRIBUTE42 T_V150
1211 ,NEW_PRICING_ATTRIBUTE42 T_V150
1212 ,OLD_PRICING_ATTRIBUTE43 T_V150
1213 ,NEW_PRICING_ATTRIBUTE43 T_V150
1214 ,OLD_PRICING_ATTRIBUTE44 T_V150
1215 ,NEW_PRICING_ATTRIBUTE44 T_V150
1216 ,OLD_PRICING_ATTRIBUTE45 T_V150
1217 ,NEW_PRICING_ATTRIBUTE45 T_V150
1218 ,OLD_PRICING_ATTRIBUTE46 T_V150
1219 ,NEW_PRICING_ATTRIBUTE46 T_V150
1220 ,OLD_PRICING_ATTRIBUTE47 T_V150
1221 ,NEW_PRICING_ATTRIBUTE47 T_V150
1222 ,OLD_PRICING_ATTRIBUTE48 T_V150
1223 ,NEW_PRICING_ATTRIBUTE48 T_V150
1224 ,OLD_PRICING_ATTRIBUTE49 T_V150
1225 ,NEW_PRICING_ATTRIBUTE49 T_V150
1226 ,OLD_PRICING_ATTRIBUTE50 T_V150
1227 ,NEW_PRICING_ATTRIBUTE50 T_V150
1228 ,OLD_PRICING_ATTRIBUTE51 T_V150
1229 ,NEW_PRICING_ATTRIBUTE51 T_V150
1230 ,OLD_PRICING_ATTRIBUTE52 T_V150
1231 ,NEW_PRICING_ATTRIBUTE52 T_V150
1232 ,OLD_PRICING_ATTRIBUTE53 T_V150
1233 ,NEW_PRICING_ATTRIBUTE53 T_V150
1234 ,OLD_PRICING_ATTRIBUTE54 T_V150
1235 ,NEW_PRICING_ATTRIBUTE54 T_V150
1236 ,OLD_PRICING_ATTRIBUTE55 T_V150
1237 ,NEW_PRICING_ATTRIBUTE55 T_V150
1238 ,OLD_PRICING_ATTRIBUTE56 T_V150
1239 ,NEW_PRICING_ATTRIBUTE56 T_V150
1240 ,OLD_PRICING_ATTRIBUTE57 T_V150
1241 ,NEW_PRICING_ATTRIBUTE57 T_V150
1242 ,OLD_PRICING_ATTRIBUTE58 T_V150
1243 ,NEW_PRICING_ATTRIBUTE58 T_V150
1244 ,OLD_PRICING_ATTRIBUTE59 T_V150
1245 ,NEW_PRICING_ATTRIBUTE59 T_V150
1246 ,OLD_PRICING_ATTRIBUTE60 T_V150
1247 ,NEW_PRICING_ATTRIBUTE60 T_V150
1248 ,OLD_PRICING_ATTRIBUTE61 T_V150
1249 ,NEW_PRICING_ATTRIBUTE61 T_V150
1250 ,OLD_PRICING_ATTRIBUTE62 T_V150
1251 ,NEW_PRICING_ATTRIBUTE62 T_V150
1252 ,OLD_PRICING_ATTRIBUTE63 T_V150
1253 ,NEW_PRICING_ATTRIBUTE63 T_V150
1254 ,OLD_PRICING_ATTRIBUTE64 T_V150
1255 ,NEW_PRICING_ATTRIBUTE64 T_V150
1256 ,OLD_PRICING_ATTRIBUTE65 T_V150
1257 ,NEW_PRICING_ATTRIBUTE65 T_V150
1258 ,OLD_PRICING_ATTRIBUTE66 T_V150
1259 ,NEW_PRICING_ATTRIBUTE66 T_V150
1260 ,OLD_PRICING_ATTRIBUTE67 T_V150
1261 ,NEW_PRICING_ATTRIBUTE67 T_V150
1262 ,OLD_PRICING_ATTRIBUTE68 T_V150
1263 ,NEW_PRICING_ATTRIBUTE68 T_V150
1264 ,OLD_PRICING_ATTRIBUTE69 T_V150
1265 ,NEW_PRICING_ATTRIBUTE69 T_V150
1266 ,OLD_PRICING_ATTRIBUTE70 T_V150
1267 ,NEW_PRICING_ATTRIBUTE70 T_V150
1268 ,OLD_PRICING_ATTRIBUTE71 T_V150
1269 ,NEW_PRICING_ATTRIBUTE71 T_V150
1270 ,OLD_PRICING_ATTRIBUTE72 T_V150
1271 ,NEW_PRICING_ATTRIBUTE72 T_V150
1272 ,OLD_PRICING_ATTRIBUTE73 T_V150
1273 ,NEW_PRICING_ATTRIBUTE73 T_V150
1274 ,OLD_PRICING_ATTRIBUTE74 T_V150
1275 ,NEW_PRICING_ATTRIBUTE74 T_V150
1276 ,OLD_PRICING_ATTRIBUTE75 T_V150
1277 ,NEW_PRICING_ATTRIBUTE75 T_V150
1278 ,OLD_PRICING_ATTRIBUTE76 T_V150
1279 ,NEW_PRICING_ATTRIBUTE76 T_V150
1280 ,OLD_PRICING_ATTRIBUTE77 T_V150
1281 ,NEW_PRICING_ATTRIBUTE77 T_V150
1282 ,OLD_PRICING_ATTRIBUTE78 T_V150
1283 ,NEW_PRICING_ATTRIBUTE78 T_V150
1284 ,OLD_PRICING_ATTRIBUTE79 T_V150
1285 ,NEW_PRICING_ATTRIBUTE79 T_V150
1286 ,OLD_PRICING_ATTRIBUTE80 T_V150
1287 ,NEW_PRICING_ATTRIBUTE80 T_V150
1288 ,OLD_PRICING_ATTRIBUTE81 T_V150
1289 ,NEW_PRICING_ATTRIBUTE81 T_V150
1290 ,OLD_PRICING_ATTRIBUTE82 T_V150
1291 ,NEW_PRICING_ATTRIBUTE82 T_V150
1292 ,OLD_PRICING_ATTRIBUTE83 T_V150
1293 ,NEW_PRICING_ATTRIBUTE83 T_V150
1294 ,OLD_PRICING_ATTRIBUTE84 T_V150
1295 ,NEW_PRICING_ATTRIBUTE84 T_V150
1296 ,OLD_PRICING_ATTRIBUTE85 T_V150
1297 ,NEW_PRICING_ATTRIBUTE85 T_V150
1298 ,OLD_PRICING_ATTRIBUTE86 T_V150
1299 ,NEW_PRICING_ATTRIBUTE86 T_V150
1300 ,OLD_PRICING_ATTRIBUTE87 T_V150
1301 ,NEW_PRICING_ATTRIBUTE87 T_V150
1302 ,OLD_PRICING_ATTRIBUTE88 T_V150
1303 ,NEW_PRICING_ATTRIBUTE88 T_V150
1304 ,OLD_PRICING_ATTRIBUTE89 T_V150
1305 ,NEW_PRICING_ATTRIBUTE89 T_V150
1306 ,OLD_PRICING_ATTRIBUTE90 T_V150
1307 ,NEW_PRICING_ATTRIBUTE90 T_V150
1308 ,OLD_PRICING_ATTRIBUTE91 T_V150
1309 ,NEW_PRICING_ATTRIBUTE91 T_V150
1310 ,OLD_PRICING_ATTRIBUTE92 T_V150
1311 ,NEW_PRICING_ATTRIBUTE92 T_V150
1312 ,OLD_PRICING_ATTRIBUTE93 T_V150
1313 ,NEW_PRICING_ATTRIBUTE93 T_V150
1314 ,OLD_PRICING_ATTRIBUTE94 T_V150
1315 ,NEW_PRICING_ATTRIBUTE94 T_V150
1316 ,OLD_PRICING_ATTRIBUTE95 T_V150
1317 ,NEW_PRICING_ATTRIBUTE95 T_V150
1318 ,OLD_PRICING_ATTRIBUTE96 T_V150
1319 ,NEW_PRICING_ATTRIBUTE96 T_V150
1320 ,OLD_PRICING_ATTRIBUTE97 T_V150
1321 ,NEW_PRICING_ATTRIBUTE97 T_V150
1322 ,OLD_PRICING_ATTRIBUTE98 T_V150
1323 ,NEW_PRICING_ATTRIBUTE98 T_V150
1324 ,OLD_PRICING_ATTRIBUTE99 T_V150
1325 ,NEW_PRICING_ATTRIBUTE99 T_V150
1326 ,OLD_PRICING_ATTRIBUTE100 T_V150
1327 ,NEW_PRICING_ATTRIBUTE100 T_V150
1328 ,OLD_ACTIVE_START_DATE T_DATE
1329 ,NEW_ACTIVE_START_DATE T_DATE
1330 ,OLD_ACTIVE_END_DATE T_DATE
1331 ,NEW_ACTIVE_END_DATE T_DATE
1332 ,OLD_CONTEXT T_V30
1333 ,NEW_CONTEXT T_V30
1334 ,OLD_ATTRIBUTE1 T_V150
1335 ,NEW_ATTRIBUTE1 T_V150
1336 ,OLD_ATTRIBUTE2 T_V150
1337 ,NEW_ATTRIBUTE2 T_V150
1338 ,OLD_ATTRIBUTE3 T_V150
1339 ,NEW_ATTRIBUTE3 T_V150
1340 ,OLD_ATTRIBUTE4 T_V150
1341 ,NEW_ATTRIBUTE4 T_V150
1342 ,OLD_ATTRIBUTE5 T_V150
1343 ,NEW_ATTRIBUTE5 T_V150
1344 ,OLD_ATTRIBUTE6 T_V150
1345 ,NEW_ATTRIBUTE6 T_V150
1346 ,OLD_ATTRIBUTE7 T_V150
1347 ,NEW_ATTRIBUTE7 T_V150
1348 ,OLD_ATTRIBUTE8 T_V150
1349 ,NEW_ATTRIBUTE8 T_V150
1350 ,OLD_ATTRIBUTE9 T_V150
1351 ,NEW_ATTRIBUTE9 T_V150
1352 ,OLD_ATTRIBUTE10 T_V150
1353 ,NEW_ATTRIBUTE10 T_V150
1354 ,OLD_ATTRIBUTE11 T_V150
1355 ,NEW_ATTRIBUTE11 T_V150
1356 ,OLD_ATTRIBUTE12 T_V150
1357 ,NEW_ATTRIBUTE12 T_V150
1358 ,OLD_ATTRIBUTE13 T_V150
1359 ,NEW_ATTRIBUTE13 T_V150
1360 ,OLD_ATTRIBUTE14 T_V150
1361 ,NEW_ATTRIBUTE14 T_V150
1362 ,OLD_ATTRIBUTE15 T_V150
1363 ,NEW_ATTRIBUTE15 T_V150
1364 ,FULL_DUMP_FLAG T_V1
1365 );
1366 --
1367
1368 --
1369 TYPE child_inst_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
1370
1371 PROCEDURE lock_item_instances
1372 (
1373 p_api_version IN NUMBER
1374 ,p_commit IN VARCHAR2 := fnd_api.g_false
1375 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1376 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1377 ,px_config_tbl IN OUT NOCOPY csi_cz_int.config_tbl
1378 -- ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
1379 ,x_return_status OUT NOCOPY VARCHAR2
1380 ,x_msg_count OUT NOCOPY NUMBER
1381 ,x_msg_data OUT NOCOPY VARCHAR2
1382 );
1383
1384 PROCEDURE unlock_item_instances
1385 (
1386 p_api_version IN NUMBER
1387 ,p_commit IN VARCHAR2 := fnd_api.g_false
1388 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1389 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1390 ,p_config_tbl IN csi_cz_int.config_tbl
1391 -- ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
1392 ,x_return_status OUT NOCOPY VARCHAR2
1393 ,x_msg_count OUT NOCOPY NUMBER
1394 ,x_msg_data OUT NOCOPY VARCHAR2
1395 );
1396
1397 FUNCTION check_item_instance_lock
1398 ( p_instance_id IN NUMBER :=fnd_api.g_miss_num,
1399 p_config_inst_hdr_id IN NUMBER :=fnd_api.g_miss_num,
1400 p_config_inst_item_id IN NUMBER :=fnd_api.g_miss_num,
1401 p_config_inst_rev_num IN NUMBER :=fnd_api.g_miss_num
1402 ) RETURN BOOLEAN;
1403
1404 --
1405 /*----------------------------------------------------*/
1406 /* procedure name: create_item_instance_grp */
1407 /* description : procedure used to */
1408 /* create item instances */
1409 /*----------------------------------------------------*/
1410
1411 PROCEDURE create_item_instance
1412 (
1413 p_api_version IN NUMBER
1414 ,p_commit IN VARCHAR2 := fnd_api.g_false
1415 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1416 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1417 ,p_instance_tbl IN OUT NOCOPY csi_datastructures_pub.instance_tbl
1418 ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
1419 ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
1420 ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
1421 ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
1422 ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
1423 ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
1424 ,p_txn_tbl IN OUT NOCOPY csi_datastructures_pub.transaction_tbl
1425 ,p_call_from_bom_expl IN VARCHAR2 DEFAULT fnd_api.g_false
1426 ,p_grp_error_tbl OUT NOCOPY csi_datastructures_pub.grp_error_tbl
1427 ,x_return_status OUT NOCOPY VARCHAR2
1428 ,x_msg_count OUT NOCOPY NUMBER
1429 ,x_msg_data OUT NOCOPY VARCHAR2
1430 );
1431
1432 /*----------------------------------------------------*/
1433 /* Procedure name: update_item_instance */
1434 /* Description : procedure used to update an Item */
1435 /* Instance */
1436 /*----------------------------------------------------*/
1437
1438 PROCEDURE update_item_instance
1439 (
1440 p_api_version IN NUMBER
1441 ,p_commit IN VARCHAR2 := fnd_api.g_false
1442 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1443 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1444 ,p_instance_tbl IN OUT NOCOPY csi_datastructures_pub.instance_tbl
1445 ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
1446 ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
1447 ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
1448 ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
1449 ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
1450 ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
1451 ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
1452 ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
1453 ,p_grp_upd_error_tbl OUT NOCOPY csi_datastructures_pub.grp_upd_error_tbl
1454 ,x_return_status OUT NOCOPY VARCHAR2
1455 ,x_msg_count OUT NOCOPY NUMBER
1456 ,x_msg_data OUT NOCOPY VARCHAR2
1457 );
1458
1459 /*----------------------------------------------------*/
1460 /* Procedure name: expire_item_instance */
1461 /* Description : procedure for */
1462 /* Expiring an Item Instance */
1463 /*----------------------------------------------------*/
1464
1465 PROCEDURE expire_item_instance
1466 (
1467 p_api_version IN NUMBER
1468 ,p_commit IN VARCHAR2 := fnd_api.g_false
1469 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1470 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1471 ,p_instance_tbl IN csi_datastructures_pub.instance_tbl
1472 ,p_expire_children IN VARCHAR2 := fnd_api.g_false
1473 ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
1474 ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
1475 ,p_grp_error_tbl OUT NOCOPY csi_datastructures_pub.grp_error_tbl
1476 ,x_return_status OUT NOCOPY VARCHAR2
1477 ,x_msg_count OUT NOCOPY NUMBER
1478 ,x_msg_data OUT NOCOPY VARCHAR2
1479 );
1480 --
1481 PROCEDURE Get_All_Parents
1482 (
1483 p_api_version IN NUMBER,
1484 p_commit IN VARCHAR2,
1485 p_init_msg_list IN VARCHAR2,
1486 p_validation_level IN NUMBER,
1487 p_subject_id IN NUMBER,
1488 x_rel_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
1489 x_return_status OUT NOCOPY VARCHAR2,
1490 x_msg_count OUT NOCOPY NUMBER,
1491 x_msg_data OUT NOCOPY VARCHAR2
1492 );
1493
1494 /*---------------------------------------------------------*/
1495 /* Procedure name: Explode_Bom */
1496 /* Description : This procudure explodes the BOM and */
1497 /* creates instances and relationships */
1498 /* Author : Srinivasan Ramakrishnan */
1499 /*---------------------------------------------------------*/
1500 PROCEDURE Explode_Bom
1501 (
1502 p_api_version IN NUMBER
1503 ,p_commit IN VARCHAR2
1504 ,p_init_msg_list IN VARCHAR2
1505 ,p_validation_level IN NUMBER
1506 ,p_source_instance_tbl IN csi_datastructures_pub.instance_tbl
1507 ,p_explosion_level IN NUMBER
1508 ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
1509 ,x_return_status OUT NOCOPY VARCHAR2
1510 ,x_msg_count OUT NOCOPY NUMBER
1511 ,x_msg_data OUT NOCOPY VARCHAR2
1512 );
1513
1514 END CSI_ITEM_INSTANCE_GRP;