14: /* of the top model instance */
15: /*----------------------------------------------------------*/
16:
17: TYPE model_inst_rec is RECORD(
18: parent_line_id NUMBER := fnd_api.g_miss_num,
19: instance_id NUMBER := fnd_api.g_miss_num,
20: rem_qty NUMBER := fnd_api.g_miss_num,
21: txn_line_detail_id NUMBER := fnd_api.g_miss_num,
22: process_flag VARCHAR2(1) := fnd_api.g_miss_char);
15: /*----------------------------------------------------------*/
16:
17: TYPE model_inst_rec is RECORD(
18: parent_line_id NUMBER := fnd_api.g_miss_num,
19: instance_id NUMBER := fnd_api.g_miss_num,
20: rem_qty NUMBER := fnd_api.g_miss_num,
21: txn_line_detail_id NUMBER := fnd_api.g_miss_num,
22: process_flag VARCHAR2(1) := fnd_api.g_miss_char);
23:
16:
17: TYPE model_inst_rec is RECORD(
18: parent_line_id NUMBER := fnd_api.g_miss_num,
19: instance_id NUMBER := fnd_api.g_miss_num,
20: rem_qty NUMBER := fnd_api.g_miss_num,
21: txn_line_detail_id NUMBER := fnd_api.g_miss_num,
22: process_flag VARCHAR2(1) := fnd_api.g_miss_char);
23:
24: TYPE model_inst_tbl is TABLE OF model_inst_rec INDEX BY BINARY_INTEGER;
17: TYPE model_inst_rec is RECORD(
18: parent_line_id NUMBER := fnd_api.g_miss_num,
19: instance_id NUMBER := fnd_api.g_miss_num,
20: rem_qty NUMBER := fnd_api.g_miss_num,
21: txn_line_detail_id NUMBER := fnd_api.g_miss_num,
22: process_flag VARCHAR2(1) := fnd_api.g_miss_char);
23:
24: TYPE model_inst_tbl is TABLE OF model_inst_rec INDEX BY BINARY_INTEGER;
25:
18: parent_line_id NUMBER := fnd_api.g_miss_num,
19: instance_id NUMBER := fnd_api.g_miss_num,
20: rem_qty NUMBER := fnd_api.g_miss_num,
21: txn_line_detail_id NUMBER := fnd_api.g_miss_num,
22: process_flag VARCHAR2(1) := fnd_api.g_miss_char);
23:
24: TYPE model_inst_tbl is TABLE OF model_inst_rec INDEX BY BINARY_INTEGER;
25:
26: /*----------------------------------------------------------*/
29: /* of material tansaction */
30: /*----------------------------------------------------------*/
31:
32: TYPE MTL_TXN_REC is RECORD(
33: MTL_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
34: SOURCE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
35: SOURCE_HEADER_REF_ID NUMBER := FND_API.G_MISS_NUM,
36: SOURCE_HEADER_REF VARCHAR2(150) := FND_API.G_MISS_CHAR, -- Changed for bug#15931790
37: SOURCE_LINE_REF_ID NUMBER := FND_API.G_MISS_NUM,
30: /*----------------------------------------------------------*/
31:
32: TYPE MTL_TXN_REC is RECORD(
33: MTL_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
34: SOURCE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
35: SOURCE_HEADER_REF_ID NUMBER := FND_API.G_MISS_NUM,
36: SOURCE_HEADER_REF VARCHAR2(150) := FND_API.G_MISS_CHAR, -- Changed for bug#15931790
37: SOURCE_LINE_REF_ID NUMBER := FND_API.G_MISS_NUM,
38: SOURCE_LINE_REF VARCHAR2(150) := FND_API.G_MISS_CHAR, -- Changed for bug#15931790
31:
32: TYPE MTL_TXN_REC is RECORD(
33: MTL_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
34: SOURCE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
35: SOURCE_HEADER_REF_ID NUMBER := FND_API.G_MISS_NUM,
36: SOURCE_HEADER_REF VARCHAR2(150) := FND_API.G_MISS_CHAR, -- Changed for bug#15931790
37: SOURCE_LINE_REF_ID NUMBER := FND_API.G_MISS_NUM,
38: SOURCE_LINE_REF VARCHAR2(150) := FND_API.G_MISS_CHAR, -- Changed for bug#15931790
39: SOURCE_TRANSACTION_DATE DATE := FND_API.G_MISS_DATE,
32: TYPE MTL_TXN_REC is RECORD(
33: MTL_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
34: SOURCE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
35: SOURCE_HEADER_REF_ID NUMBER := FND_API.G_MISS_NUM,
36: SOURCE_HEADER_REF VARCHAR2(150) := FND_API.G_MISS_CHAR, -- Changed for bug#15931790
37: SOURCE_LINE_REF_ID NUMBER := FND_API.G_MISS_NUM,
38: SOURCE_LINE_REF VARCHAR2(150) := FND_API.G_MISS_CHAR, -- Changed for bug#15931790
39: SOURCE_TRANSACTION_DATE DATE := FND_API.G_MISS_DATE,
40: INV_MATERIAL_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM );
33: MTL_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
34: SOURCE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
35: SOURCE_HEADER_REF_ID NUMBER := FND_API.G_MISS_NUM,
36: SOURCE_HEADER_REF VARCHAR2(150) := FND_API.G_MISS_CHAR, -- Changed for bug#15931790
37: SOURCE_LINE_REF_ID NUMBER := FND_API.G_MISS_NUM,
38: SOURCE_LINE_REF VARCHAR2(150) := FND_API.G_MISS_CHAR, -- Changed for bug#15931790
39: SOURCE_TRANSACTION_DATE DATE := FND_API.G_MISS_DATE,
40: INV_MATERIAL_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM );
41:
34: SOURCE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
35: SOURCE_HEADER_REF_ID NUMBER := FND_API.G_MISS_NUM,
36: SOURCE_HEADER_REF VARCHAR2(150) := FND_API.G_MISS_CHAR, -- Changed for bug#15931790
37: SOURCE_LINE_REF_ID NUMBER := FND_API.G_MISS_NUM,
38: SOURCE_LINE_REF VARCHAR2(150) := FND_API.G_MISS_CHAR, -- Changed for bug#15931790
39: SOURCE_TRANSACTION_DATE DATE := FND_API.G_MISS_DATE,
40: INV_MATERIAL_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM );
41:
42: TYPE item_control_rec IS RECORD (
35: SOURCE_HEADER_REF_ID NUMBER := FND_API.G_MISS_NUM,
36: SOURCE_HEADER_REF VARCHAR2(150) := FND_API.G_MISS_CHAR, -- Changed for bug#15931790
37: SOURCE_LINE_REF_ID NUMBER := FND_API.G_MISS_NUM,
38: SOURCE_LINE_REF VARCHAR2(150) := FND_API.G_MISS_CHAR, -- Changed for bug#15931790
39: SOURCE_TRANSACTION_DATE DATE := FND_API.G_MISS_DATE,
40: INV_MATERIAL_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM );
41:
42: TYPE item_control_rec IS RECORD (
43: inventory_item_id number := fnd_api.g_miss_num,
36: SOURCE_HEADER_REF VARCHAR2(150) := FND_API.G_MISS_CHAR, -- Changed for bug#15931790
37: SOURCE_LINE_REF_ID NUMBER := FND_API.G_MISS_NUM,
38: SOURCE_LINE_REF VARCHAR2(150) := FND_API.G_MISS_CHAR, -- Changed for bug#15931790
39: SOURCE_TRANSACTION_DATE DATE := FND_API.G_MISS_DATE,
40: INV_MATERIAL_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM );
41:
42: TYPE item_control_rec IS RECORD (
43: inventory_item_id number := fnd_api.g_miss_num,
44: organization_id number := fnd_api.g_miss_num,
39: SOURCE_TRANSACTION_DATE DATE := FND_API.G_MISS_DATE,
40: INV_MATERIAL_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM );
41:
42: TYPE item_control_rec IS RECORD (
43: inventory_item_id number := fnd_api.g_miss_num,
44: organization_id number := fnd_api.g_miss_num,
45: ib_trackable_flag varchar2(1) := fnd_api.g_miss_char,
46: serial_control_code number := fnd_api.g_miss_num,
47: lot_control_code number := fnd_api.g_miss_num,
40: INV_MATERIAL_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM );
41:
42: TYPE item_control_rec IS RECORD (
43: inventory_item_id number := fnd_api.g_miss_num,
44: organization_id number := fnd_api.g_miss_num,
45: ib_trackable_flag varchar2(1) := fnd_api.g_miss_char,
46: serial_control_code number := fnd_api.g_miss_num,
47: lot_control_code number := fnd_api.g_miss_num,
48: revision_control_code number := fnd_api.g_miss_num,
41:
42: TYPE item_control_rec IS RECORD (
43: inventory_item_id number := fnd_api.g_miss_num,
44: organization_id number := fnd_api.g_miss_num,
45: ib_trackable_flag varchar2(1) := fnd_api.g_miss_char,
46: serial_control_code number := fnd_api.g_miss_num,
47: lot_control_code number := fnd_api.g_miss_num,
48: revision_control_code number := fnd_api.g_miss_num,
49: locator_control_code number := fnd_api.g_miss_num,
42: TYPE item_control_rec IS RECORD (
43: inventory_item_id number := fnd_api.g_miss_num,
44: organization_id number := fnd_api.g_miss_num,
45: ib_trackable_flag varchar2(1) := fnd_api.g_miss_char,
46: serial_control_code number := fnd_api.g_miss_num,
47: lot_control_code number := fnd_api.g_miss_num,
48: revision_control_code number := fnd_api.g_miss_num,
49: locator_control_code number := fnd_api.g_miss_num,
50: primary_uom_code varchar2(3) := fnd_api.g_miss_char,
43: inventory_item_id number := fnd_api.g_miss_num,
44: organization_id number := fnd_api.g_miss_num,
45: ib_trackable_flag varchar2(1) := fnd_api.g_miss_char,
46: serial_control_code number := fnd_api.g_miss_num,
47: lot_control_code number := fnd_api.g_miss_num,
48: revision_control_code number := fnd_api.g_miss_num,
49: locator_control_code number := fnd_api.g_miss_num,
50: primary_uom_code varchar2(3) := fnd_api.g_miss_char,
51: bom_item_type number := fnd_api.g_miss_num,
44: organization_id number := fnd_api.g_miss_num,
45: ib_trackable_flag varchar2(1) := fnd_api.g_miss_char,
46: serial_control_code number := fnd_api.g_miss_num,
47: lot_control_code number := fnd_api.g_miss_num,
48: revision_control_code number := fnd_api.g_miss_num,
49: locator_control_code number := fnd_api.g_miss_num,
50: primary_uom_code varchar2(3) := fnd_api.g_miss_char,
51: bom_item_type number := fnd_api.g_miss_num,
52: model_item_id number := fnd_api.g_miss_num,
45: ib_trackable_flag varchar2(1) := fnd_api.g_miss_char,
46: serial_control_code number := fnd_api.g_miss_num,
47: lot_control_code number := fnd_api.g_miss_num,
48: revision_control_code number := fnd_api.g_miss_num,
49: locator_control_code number := fnd_api.g_miss_num,
50: primary_uom_code varchar2(3) := fnd_api.g_miss_char,
51: bom_item_type number := fnd_api.g_miss_num,
52: model_item_id number := fnd_api.g_miss_num,
53: pick_components_flag varchar2(1) := fnd_api.g_miss_char,
46: serial_control_code number := fnd_api.g_miss_num,
47: lot_control_code number := fnd_api.g_miss_num,
48: revision_control_code number := fnd_api.g_miss_num,
49: locator_control_code number := fnd_api.g_miss_num,
50: primary_uom_code varchar2(3) := fnd_api.g_miss_char,
51: bom_item_type number := fnd_api.g_miss_num,
52: model_item_id number := fnd_api.g_miss_num,
53: pick_components_flag varchar2(1) := fnd_api.g_miss_char,
54: reservable_type number := fnd_api.g_miss_num,
47: lot_control_code number := fnd_api.g_miss_num,
48: revision_control_code number := fnd_api.g_miss_num,
49: locator_control_code number := fnd_api.g_miss_num,
50: primary_uom_code varchar2(3) := fnd_api.g_miss_char,
51: bom_item_type number := fnd_api.g_miss_num,
52: model_item_id number := fnd_api.g_miss_num,
53: pick_components_flag varchar2(1) := fnd_api.g_miss_char,
54: reservable_type number := fnd_api.g_miss_num,
55: negative_balances_code number := fnd_api.g_miss_num,
48: revision_control_code number := fnd_api.g_miss_num,
49: locator_control_code number := fnd_api.g_miss_num,
50: primary_uom_code varchar2(3) := fnd_api.g_miss_char,
51: bom_item_type number := fnd_api.g_miss_num,
52: model_item_id number := fnd_api.g_miss_num,
53: pick_components_flag varchar2(1) := fnd_api.g_miss_char,
54: reservable_type number := fnd_api.g_miss_num,
55: negative_balances_code number := fnd_api.g_miss_num,
56: shippable_flag varchar2(1) := fnd_api.g_miss_char,
49: locator_control_code number := fnd_api.g_miss_num,
50: primary_uom_code varchar2(3) := fnd_api.g_miss_char,
51: bom_item_type number := fnd_api.g_miss_num,
52: model_item_id number := fnd_api.g_miss_num,
53: pick_components_flag varchar2(1) := fnd_api.g_miss_char,
54: reservable_type number := fnd_api.g_miss_num,
55: negative_balances_code number := fnd_api.g_miss_num,
56: shippable_flag varchar2(1) := fnd_api.g_miss_char,
57: transactable_flag varchar2(1) := fnd_api.g_miss_char);
50: primary_uom_code varchar2(3) := fnd_api.g_miss_char,
51: bom_item_type number := fnd_api.g_miss_num,
52: model_item_id number := fnd_api.g_miss_num,
53: pick_components_flag varchar2(1) := fnd_api.g_miss_char,
54: reservable_type number := fnd_api.g_miss_num,
55: negative_balances_code number := fnd_api.g_miss_num,
56: shippable_flag varchar2(1) := fnd_api.g_miss_char,
57: transactable_flag varchar2(1) := fnd_api.g_miss_char);
58:
51: bom_item_type number := fnd_api.g_miss_num,
52: model_item_id number := fnd_api.g_miss_num,
53: pick_components_flag varchar2(1) := fnd_api.g_miss_char,
54: reservable_type number := fnd_api.g_miss_num,
55: negative_balances_code number := fnd_api.g_miss_num,
56: shippable_flag varchar2(1) := fnd_api.g_miss_char,
57: transactable_flag varchar2(1) := fnd_api.g_miss_char);
58:
59: /*-----------------------------------------------------------*/
52: model_item_id number := fnd_api.g_miss_num,
53: pick_components_flag varchar2(1) := fnd_api.g_miss_char,
54: reservable_type number := fnd_api.g_miss_num,
55: negative_balances_code number := fnd_api.g_miss_num,
56: shippable_flag varchar2(1) := fnd_api.g_miss_char,
57: transactable_flag varchar2(1) := fnd_api.g_miss_char);
58:
59: /*-----------------------------------------------------------*/
60: /* Record name: order_shipment_rec */
53: pick_components_flag varchar2(1) := fnd_api.g_miss_char,
54: reservable_type number := fnd_api.g_miss_num,
55: negative_balances_code number := fnd_api.g_miss_num,
56: shippable_flag varchar2(1) := fnd_api.g_miss_char,
57: transactable_flag varchar2(1) := fnd_api.g_miss_char);
58:
59: /*-----------------------------------------------------------*/
60: /* Record name: order_shipment_rec */
61: /* Description: Record used for keeping the shipment details*/
61: /* Description: Record used for keeping the shipment details*/
62: /*-----------------------------------------------------------*/
63:
64: TYPE order_shipment_rec IS RECORD(
65: line_id NUMBER := FND_API.G_MISS_NUM,
66: header_id NUMBER := FND_API.G_MISS_NUM,
67: txn_line_detail_id NUMBER := FND_API.G_MISS_NUM,
68: orig_inst_id NUMBER := FND_API.G_MISS_NUM,
69: instance_id NUMBER := FND_API.G_MISS_NUM,
62: /*-----------------------------------------------------------*/
63:
64: TYPE order_shipment_rec IS RECORD(
65: line_id NUMBER := FND_API.G_MISS_NUM,
66: header_id NUMBER := FND_API.G_MISS_NUM,
67: txn_line_detail_id NUMBER := FND_API.G_MISS_NUM,
68: orig_inst_id NUMBER := FND_API.G_MISS_NUM,
69: instance_id NUMBER := FND_API.G_MISS_NUM,
70: system_id NUMBER := FND_API.G_MISS_NUM,
63:
64: TYPE order_shipment_rec IS RECORD(
65: line_id NUMBER := FND_API.G_MISS_NUM,
66: header_id NUMBER := FND_API.G_MISS_NUM,
67: txn_line_detail_id NUMBER := FND_API.G_MISS_NUM,
68: orig_inst_id NUMBER := FND_API.G_MISS_NUM,
69: instance_id NUMBER := FND_API.G_MISS_NUM,
70: system_id NUMBER := FND_API.G_MISS_NUM,
71: instance_qty NUMBER := FND_API.G_MISS_NUM,
64: TYPE order_shipment_rec IS RECORD(
65: line_id NUMBER := FND_API.G_MISS_NUM,
66: header_id NUMBER := FND_API.G_MISS_NUM,
67: txn_line_detail_id NUMBER := FND_API.G_MISS_NUM,
68: orig_inst_id NUMBER := FND_API.G_MISS_NUM,
69: instance_id NUMBER := FND_API.G_MISS_NUM,
70: system_id NUMBER := FND_API.G_MISS_NUM,
71: instance_qty NUMBER := FND_API.G_MISS_NUM,
72: party_id NUMBER := FND_API.G_MISS_NUM,
65: line_id NUMBER := FND_API.G_MISS_NUM,
66: header_id NUMBER := FND_API.G_MISS_NUM,
67: txn_line_detail_id NUMBER := FND_API.G_MISS_NUM,
68: orig_inst_id NUMBER := FND_API.G_MISS_NUM,
69: instance_id NUMBER := FND_API.G_MISS_NUM,
70: system_id NUMBER := FND_API.G_MISS_NUM,
71: instance_qty NUMBER := FND_API.G_MISS_NUM,
72: party_id NUMBER := FND_API.G_MISS_NUM,
73: party_source_table VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: header_id NUMBER := FND_API.G_MISS_NUM,
67: txn_line_detail_id NUMBER := FND_API.G_MISS_NUM,
68: orig_inst_id NUMBER := FND_API.G_MISS_NUM,
69: instance_id NUMBER := FND_API.G_MISS_NUM,
70: system_id NUMBER := FND_API.G_MISS_NUM,
71: instance_qty NUMBER := FND_API.G_MISS_NUM,
72: party_id NUMBER := FND_API.G_MISS_NUM,
73: party_source_table VARCHAR2(30) := FND_API.G_MISS_CHAR,
74: party_account_id NUMBER := FND_API.G_MISS_NUM,
67: txn_line_detail_id NUMBER := FND_API.G_MISS_NUM,
68: orig_inst_id NUMBER := FND_API.G_MISS_NUM,
69: instance_id NUMBER := FND_API.G_MISS_NUM,
70: system_id NUMBER := FND_API.G_MISS_NUM,
71: instance_qty NUMBER := FND_API.G_MISS_NUM,
72: party_id NUMBER := FND_API.G_MISS_NUM,
73: party_source_table VARCHAR2(30) := FND_API.G_MISS_CHAR,
74: party_account_id NUMBER := FND_API.G_MISS_NUM,
75: inst_obj_version_number NUMBER := FND_API.G_MISS_NUM,
68: orig_inst_id NUMBER := FND_API.G_MISS_NUM,
69: instance_id NUMBER := FND_API.G_MISS_NUM,
70: system_id NUMBER := FND_API.G_MISS_NUM,
71: instance_qty NUMBER := FND_API.G_MISS_NUM,
72: party_id NUMBER := FND_API.G_MISS_NUM,
73: party_source_table VARCHAR2(30) := FND_API.G_MISS_CHAR,
74: party_account_id NUMBER := FND_API.G_MISS_NUM,
75: inst_obj_version_number NUMBER := FND_API.G_MISS_NUM,
76: txn_dtls_qty NUMBER := FND_API.G_MISS_NUM,
69: instance_id NUMBER := FND_API.G_MISS_NUM,
70: system_id NUMBER := FND_API.G_MISS_NUM,
71: instance_qty NUMBER := FND_API.G_MISS_NUM,
72: party_id NUMBER := FND_API.G_MISS_NUM,
73: party_source_table VARCHAR2(30) := FND_API.G_MISS_CHAR,
74: party_account_id NUMBER := FND_API.G_MISS_NUM,
75: inst_obj_version_number NUMBER := FND_API.G_MISS_NUM,
76: txn_dtls_qty NUMBER := FND_API.G_MISS_NUM,
77: ord_line_shipped_qty NUMBER := FND_API.G_MISS_NUM,
70: system_id NUMBER := FND_API.G_MISS_NUM,
71: instance_qty NUMBER := FND_API.G_MISS_NUM,
72: party_id NUMBER := FND_API.G_MISS_NUM,
73: party_source_table VARCHAR2(30) := FND_API.G_MISS_CHAR,
74: party_account_id NUMBER := FND_API.G_MISS_NUM,
75: inst_obj_version_number NUMBER := FND_API.G_MISS_NUM,
76: txn_dtls_qty NUMBER := FND_API.G_MISS_NUM,
77: ord_line_shipped_qty NUMBER := FND_API.G_MISS_NUM,
78: instance_match VARCHAR2(1) := FND_API.G_MISS_CHAR,
71: instance_qty NUMBER := FND_API.G_MISS_NUM,
72: party_id NUMBER := FND_API.G_MISS_NUM,
73: party_source_table VARCHAR2(30) := FND_API.G_MISS_CHAR,
74: party_account_id NUMBER := FND_API.G_MISS_NUM,
75: inst_obj_version_number NUMBER := FND_API.G_MISS_NUM,
76: txn_dtls_qty NUMBER := FND_API.G_MISS_NUM,
77: ord_line_shipped_qty NUMBER := FND_API.G_MISS_NUM,
78: instance_match VARCHAR2(1) := FND_API.G_MISS_CHAR,
79: quantity_match VARCHAR2(1) := FND_API.G_MISS_CHAR,
72: party_id NUMBER := FND_API.G_MISS_NUM,
73: party_source_table VARCHAR2(30) := FND_API.G_MISS_CHAR,
74: party_account_id NUMBER := FND_API.G_MISS_NUM,
75: inst_obj_version_number NUMBER := FND_API.G_MISS_NUM,
76: txn_dtls_qty NUMBER := FND_API.G_MISS_NUM,
77: ord_line_shipped_qty NUMBER := FND_API.G_MISS_NUM,
78: instance_match VARCHAR2(1) := FND_API.G_MISS_CHAR,
79: quantity_match VARCHAR2(1) := FND_API.G_MISS_CHAR,
80: -- Added this for Bug 3384668
73: party_source_table VARCHAR2(30) := FND_API.G_MISS_CHAR,
74: party_account_id NUMBER := FND_API.G_MISS_NUM,
75: inst_obj_version_number NUMBER := FND_API.G_MISS_NUM,
76: txn_dtls_qty NUMBER := FND_API.G_MISS_NUM,
77: ord_line_shipped_qty NUMBER := FND_API.G_MISS_NUM,
78: instance_match VARCHAR2(1) := FND_API.G_MISS_CHAR,
79: quantity_match VARCHAR2(1) := FND_API.G_MISS_CHAR,
80: -- Added this for Bug 3384668
81: lot_match VARCHAR2(1) := FND_API.G_MISS_CHAR,
74: party_account_id NUMBER := FND_API.G_MISS_NUM,
75: inst_obj_version_number NUMBER := FND_API.G_MISS_NUM,
76: txn_dtls_qty NUMBER := FND_API.G_MISS_NUM,
77: ord_line_shipped_qty NUMBER := FND_API.G_MISS_NUM,
78: instance_match VARCHAR2(1) := FND_API.G_MISS_CHAR,
79: quantity_match VARCHAR2(1) := FND_API.G_MISS_CHAR,
80: -- Added this for Bug 3384668
81: lot_match VARCHAR2(1) := FND_API.G_MISS_CHAR,
82: customer_id NUMBER := FND_API.G_MISS_NUM,
75: inst_obj_version_number NUMBER := FND_API.G_MISS_NUM,
76: txn_dtls_qty NUMBER := FND_API.G_MISS_NUM,
77: ord_line_shipped_qty NUMBER := FND_API.G_MISS_NUM,
78: instance_match VARCHAR2(1) := FND_API.G_MISS_CHAR,
79: quantity_match VARCHAR2(1) := FND_API.G_MISS_CHAR,
80: -- Added this for Bug 3384668
81: lot_match VARCHAR2(1) := FND_API.G_MISS_CHAR,
82: customer_id NUMBER := FND_API.G_MISS_NUM,
83: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
77: ord_line_shipped_qty NUMBER := FND_API.G_MISS_NUM,
78: instance_match VARCHAR2(1) := FND_API.G_MISS_CHAR,
79: quantity_match VARCHAR2(1) := FND_API.G_MISS_CHAR,
80: -- Added this for Bug 3384668
81: lot_match VARCHAR2(1) := FND_API.G_MISS_CHAR,
82: customer_id NUMBER := FND_API.G_MISS_NUM,
83: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
84: organization_id NUMBER := FND_API.G_MISS_NUM,
85: revision VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: instance_match VARCHAR2(1) := FND_API.G_MISS_CHAR,
79: quantity_match VARCHAR2(1) := FND_API.G_MISS_CHAR,
80: -- Added this for Bug 3384668
81: lot_match VARCHAR2(1) := FND_API.G_MISS_CHAR,
82: customer_id NUMBER := FND_API.G_MISS_NUM,
83: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
84: organization_id NUMBER := FND_API.G_MISS_NUM,
85: revision VARCHAR2(30) := FND_API.G_MISS_CHAR,
86: subinventory VARCHAR2(30) := FND_API.G_MISS_CHAR,
79: quantity_match VARCHAR2(1) := FND_API.G_MISS_CHAR,
80: -- Added this for Bug 3384668
81: lot_match VARCHAR2(1) := FND_API.G_MISS_CHAR,
82: customer_id NUMBER := FND_API.G_MISS_NUM,
83: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
84: organization_id NUMBER := FND_API.G_MISS_NUM,
85: revision VARCHAR2(30) := FND_API.G_MISS_CHAR,
86: subinventory VARCHAR2(30) := FND_API.G_MISS_CHAR,
87: locator_id NUMBER := FND_API.G_MISS_NUM,
80: -- Added this for Bug 3384668
81: lot_match VARCHAR2(1) := FND_API.G_MISS_CHAR,
82: customer_id NUMBER := FND_API.G_MISS_NUM,
83: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
84: organization_id NUMBER := FND_API.G_MISS_NUM,
85: revision VARCHAR2(30) := FND_API.G_MISS_CHAR,
86: subinventory VARCHAR2(30) := FND_API.G_MISS_CHAR,
87: locator_id NUMBER := FND_API.G_MISS_NUM,
88: lot_number VARCHAR2(80) := FND_API.G_MISS_CHAR,
81: lot_match VARCHAR2(1) := FND_API.G_MISS_CHAR,
82: customer_id NUMBER := FND_API.G_MISS_NUM,
83: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
84: organization_id NUMBER := FND_API.G_MISS_NUM,
85: revision VARCHAR2(30) := FND_API.G_MISS_CHAR,
86: subinventory VARCHAR2(30) := FND_API.G_MISS_CHAR,
87: locator_id NUMBER := FND_API.G_MISS_NUM,
88: lot_number VARCHAR2(80) := FND_API.G_MISS_CHAR,
89: serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
82: customer_id NUMBER := FND_API.G_MISS_NUM,
83: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
84: organization_id NUMBER := FND_API.G_MISS_NUM,
85: revision VARCHAR2(30) := FND_API.G_MISS_CHAR,
86: subinventory VARCHAR2(30) := FND_API.G_MISS_CHAR,
87: locator_id NUMBER := FND_API.G_MISS_NUM,
88: lot_number VARCHAR2(80) := FND_API.G_MISS_CHAR,
89: serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
90: transaction_uom VARCHAR2(30) := FND_API.G_MISS_CHAR,
83: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
84: organization_id NUMBER := FND_API.G_MISS_NUM,
85: revision VARCHAR2(30) := FND_API.G_MISS_CHAR,
86: subinventory VARCHAR2(30) := FND_API.G_MISS_CHAR,
87: locator_id NUMBER := FND_API.G_MISS_NUM,
88: lot_number VARCHAR2(80) := FND_API.G_MISS_CHAR,
89: serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
90: transaction_uom VARCHAR2(30) := FND_API.G_MISS_CHAR,
91: order_quantity_uom VARCHAR2(30) := FND_API.G_MISS_CHAR,
84: organization_id NUMBER := FND_API.G_MISS_NUM,
85: revision VARCHAR2(30) := FND_API.G_MISS_CHAR,
86: subinventory VARCHAR2(30) := FND_API.G_MISS_CHAR,
87: locator_id NUMBER := FND_API.G_MISS_NUM,
88: lot_number VARCHAR2(80) := FND_API.G_MISS_CHAR,
89: serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
90: transaction_uom VARCHAR2(30) := FND_API.G_MISS_CHAR,
91: order_quantity_uom VARCHAR2(30) := FND_API.G_MISS_CHAR,
92: invoice_to_contact_id NUMBER := FND_API.G_MISS_NUM,
85: revision VARCHAR2(30) := FND_API.G_MISS_CHAR,
86: subinventory VARCHAR2(30) := FND_API.G_MISS_CHAR,
87: locator_id NUMBER := FND_API.G_MISS_NUM,
88: lot_number VARCHAR2(80) := FND_API.G_MISS_CHAR,
89: serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
90: transaction_uom VARCHAR2(30) := FND_API.G_MISS_CHAR,
91: order_quantity_uom VARCHAR2(30) := FND_API.G_MISS_CHAR,
92: invoice_to_contact_id NUMBER := FND_API.G_MISS_NUM,
93: invoice_to_org_id NUMBER := FND_API.G_MISS_NUM,
86: subinventory VARCHAR2(30) := FND_API.G_MISS_CHAR,
87: locator_id NUMBER := FND_API.G_MISS_NUM,
88: lot_number VARCHAR2(80) := FND_API.G_MISS_CHAR,
89: serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
90: transaction_uom VARCHAR2(30) := FND_API.G_MISS_CHAR,
91: order_quantity_uom VARCHAR2(30) := FND_API.G_MISS_CHAR,
92: invoice_to_contact_id NUMBER := FND_API.G_MISS_NUM,
93: invoice_to_org_id NUMBER := FND_API.G_MISS_NUM,
94: line_type_id NUMBER := FND_API.G_MISS_NUM,
87: locator_id NUMBER := FND_API.G_MISS_NUM,
88: lot_number VARCHAR2(80) := FND_API.G_MISS_CHAR,
89: serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
90: transaction_uom VARCHAR2(30) := FND_API.G_MISS_CHAR,
91: order_quantity_uom VARCHAR2(30) := FND_API.G_MISS_CHAR,
92: invoice_to_contact_id NUMBER := FND_API.G_MISS_NUM,
93: invoice_to_org_id NUMBER := FND_API.G_MISS_NUM,
94: line_type_id NUMBER := FND_API.G_MISS_NUM,
95: ordered_quantity NUMBER := FND_API.G_MISS_NUM,
88: lot_number VARCHAR2(80) := FND_API.G_MISS_CHAR,
89: serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
90: transaction_uom VARCHAR2(30) := FND_API.G_MISS_CHAR,
91: order_quantity_uom VARCHAR2(30) := FND_API.G_MISS_CHAR,
92: invoice_to_contact_id NUMBER := FND_API.G_MISS_NUM,
93: invoice_to_org_id NUMBER := FND_API.G_MISS_NUM,
94: line_type_id NUMBER := FND_API.G_MISS_NUM,
95: ordered_quantity NUMBER := FND_API.G_MISS_NUM,
96: ship_to_contact_id NUMBER := FND_API.G_MISS_NUM,
89: serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
90: transaction_uom VARCHAR2(30) := FND_API.G_MISS_CHAR,
91: order_quantity_uom VARCHAR2(30) := FND_API.G_MISS_CHAR,
92: invoice_to_contact_id NUMBER := FND_API.G_MISS_NUM,
93: invoice_to_org_id NUMBER := FND_API.G_MISS_NUM,
94: line_type_id NUMBER := FND_API.G_MISS_NUM,
95: ordered_quantity NUMBER := FND_API.G_MISS_NUM,
96: ship_to_contact_id NUMBER := FND_API.G_MISS_NUM,
97: ship_to_org_id NUMBER := FND_API.G_MISS_NUM,
90: transaction_uom VARCHAR2(30) := FND_API.G_MISS_CHAR,
91: order_quantity_uom VARCHAR2(30) := FND_API.G_MISS_CHAR,
92: invoice_to_contact_id NUMBER := FND_API.G_MISS_NUM,
93: invoice_to_org_id NUMBER := FND_API.G_MISS_NUM,
94: line_type_id NUMBER := FND_API.G_MISS_NUM,
95: ordered_quantity NUMBER := FND_API.G_MISS_NUM,
96: ship_to_contact_id NUMBER := FND_API.G_MISS_NUM,
97: ship_to_org_id NUMBER := FND_API.G_MISS_NUM,
98: ship_from_org_id NUMBER := FND_API.G_MISS_NUM,
91: order_quantity_uom VARCHAR2(30) := FND_API.G_MISS_CHAR,
92: invoice_to_contact_id NUMBER := FND_API.G_MISS_NUM,
93: invoice_to_org_id NUMBER := FND_API.G_MISS_NUM,
94: line_type_id NUMBER := FND_API.G_MISS_NUM,
95: ordered_quantity NUMBER := FND_API.G_MISS_NUM,
96: ship_to_contact_id NUMBER := FND_API.G_MISS_NUM,
97: ship_to_org_id NUMBER := FND_API.G_MISS_NUM,
98: ship_from_org_id NUMBER := FND_API.G_MISS_NUM,
99: sold_to_org_id NUMBER := FND_API.G_MISS_NUM,
92: invoice_to_contact_id NUMBER := FND_API.G_MISS_NUM,
93: invoice_to_org_id NUMBER := FND_API.G_MISS_NUM,
94: line_type_id NUMBER := FND_API.G_MISS_NUM,
95: ordered_quantity NUMBER := FND_API.G_MISS_NUM,
96: ship_to_contact_id NUMBER := FND_API.G_MISS_NUM,
97: ship_to_org_id NUMBER := FND_API.G_MISS_NUM,
98: ship_from_org_id NUMBER := FND_API.G_MISS_NUM,
99: sold_to_org_id NUMBER := FND_API.G_MISS_NUM,
100: sold_from_org_id NUMBER := FND_API.G_MISS_NUM,
93: invoice_to_org_id NUMBER := FND_API.G_MISS_NUM,
94: line_type_id NUMBER := FND_API.G_MISS_NUM,
95: ordered_quantity NUMBER := FND_API.G_MISS_NUM,
96: ship_to_contact_id NUMBER := FND_API.G_MISS_NUM,
97: ship_to_org_id NUMBER := FND_API.G_MISS_NUM,
98: ship_from_org_id NUMBER := FND_API.G_MISS_NUM,
99: sold_to_org_id NUMBER := FND_API.G_MISS_NUM,
100: sold_from_org_id NUMBER := FND_API.G_MISS_NUM,
101: source_line_id NUMBER := FND_API.G_MISS_NUM,
94: line_type_id NUMBER := FND_API.G_MISS_NUM,
95: ordered_quantity NUMBER := FND_API.G_MISS_NUM,
96: ship_to_contact_id NUMBER := FND_API.G_MISS_NUM,
97: ship_to_org_id NUMBER := FND_API.G_MISS_NUM,
98: ship_from_org_id NUMBER := FND_API.G_MISS_NUM,
99: sold_to_org_id NUMBER := FND_API.G_MISS_NUM,
100: sold_from_org_id NUMBER := FND_API.G_MISS_NUM,
101: source_line_id NUMBER := FND_API.G_MISS_NUM,
102: shipped_quantity NUMBER := FND_API.G_MISS_NUM,
95: ordered_quantity NUMBER := FND_API.G_MISS_NUM,
96: ship_to_contact_id NUMBER := FND_API.G_MISS_NUM,
97: ship_to_org_id NUMBER := FND_API.G_MISS_NUM,
98: ship_from_org_id NUMBER := FND_API.G_MISS_NUM,
99: sold_to_org_id NUMBER := FND_API.G_MISS_NUM,
100: sold_from_org_id NUMBER := FND_API.G_MISS_NUM,
101: source_line_id NUMBER := FND_API.G_MISS_NUM,
102: shipped_quantity NUMBER := FND_API.G_MISS_NUM,
103: ship_to_site_use_id NUMBER := FND_API.G_MISS_NUM,
96: ship_to_contact_id NUMBER := FND_API.G_MISS_NUM,
97: ship_to_org_id NUMBER := FND_API.G_MISS_NUM,
98: ship_from_org_id NUMBER := FND_API.G_MISS_NUM,
99: sold_to_org_id NUMBER := FND_API.G_MISS_NUM,
100: sold_from_org_id NUMBER := FND_API.G_MISS_NUM,
101: source_line_id NUMBER := FND_API.G_MISS_NUM,
102: shipped_quantity NUMBER := FND_API.G_MISS_NUM,
103: ship_to_site_use_id NUMBER := FND_API.G_MISS_NUM,
104: transaction_type_id NUMBER := FND_API.G_MISS_NUM,
97: ship_to_org_id NUMBER := FND_API.G_MISS_NUM,
98: ship_from_org_id NUMBER := FND_API.G_MISS_NUM,
99: sold_to_org_id NUMBER := FND_API.G_MISS_NUM,
100: sold_from_org_id NUMBER := FND_API.G_MISS_NUM,
101: source_line_id NUMBER := FND_API.G_MISS_NUM,
102: shipped_quantity NUMBER := FND_API.G_MISS_NUM,
103: ship_to_site_use_id NUMBER := FND_API.G_MISS_NUM,
104: transaction_type_id NUMBER := FND_API.G_MISS_NUM,
105: transaction_date DATE := FND_API.G_MISS_DATE,
98: ship_from_org_id NUMBER := FND_API.G_MISS_NUM,
99: sold_to_org_id NUMBER := FND_API.G_MISS_NUM,
100: sold_from_org_id NUMBER := FND_API.G_MISS_NUM,
101: source_line_id NUMBER := FND_API.G_MISS_NUM,
102: shipped_quantity NUMBER := FND_API.G_MISS_NUM,
103: ship_to_site_use_id NUMBER := FND_API.G_MISS_NUM,
104: transaction_type_id NUMBER := FND_API.G_MISS_NUM,
105: transaction_date DATE := FND_API.G_MISS_DATE,
106: item_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
99: sold_to_org_id NUMBER := FND_API.G_MISS_NUM,
100: sold_from_org_id NUMBER := FND_API.G_MISS_NUM,
101: source_line_id NUMBER := FND_API.G_MISS_NUM,
102: shipped_quantity NUMBER := FND_API.G_MISS_NUM,
103: ship_to_site_use_id NUMBER := FND_API.G_MISS_NUM,
104: transaction_type_id NUMBER := FND_API.G_MISS_NUM,
105: transaction_date DATE := FND_API.G_MISS_DATE,
106: item_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
107: cust_po_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
100: sold_from_org_id NUMBER := FND_API.G_MISS_NUM,
101: source_line_id NUMBER := FND_API.G_MISS_NUM,
102: shipped_quantity NUMBER := FND_API.G_MISS_NUM,
103: ship_to_site_use_id NUMBER := FND_API.G_MISS_NUM,
104: transaction_type_id NUMBER := FND_API.G_MISS_NUM,
105: transaction_date DATE := FND_API.G_MISS_DATE,
106: item_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
107: cust_po_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
108: ato_line_id NUMBER := FND_API.G_MISS_NUM,
101: source_line_id NUMBER := FND_API.G_MISS_NUM,
102: shipped_quantity NUMBER := FND_API.G_MISS_NUM,
103: ship_to_site_use_id NUMBER := FND_API.G_MISS_NUM,
104: transaction_type_id NUMBER := FND_API.G_MISS_NUM,
105: transaction_date DATE := FND_API.G_MISS_DATE,
106: item_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
107: cust_po_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
108: ato_line_id NUMBER := FND_API.G_MISS_NUM,
109: top_model_line_id NUMBER := FND_API.G_MISS_NUM,
102: shipped_quantity NUMBER := FND_API.G_MISS_NUM,
103: ship_to_site_use_id NUMBER := FND_API.G_MISS_NUM,
104: transaction_type_id NUMBER := FND_API.G_MISS_NUM,
105: transaction_date DATE := FND_API.G_MISS_DATE,
106: item_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
107: cust_po_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
108: ato_line_id NUMBER := FND_API.G_MISS_NUM,
109: top_model_line_id NUMBER := FND_API.G_MISS_NUM,
110: link_to_line_id NUMBER := FND_API.G_MISS_NUM,
103: ship_to_site_use_id NUMBER := FND_API.G_MISS_NUM,
104: transaction_type_id NUMBER := FND_API.G_MISS_NUM,
105: transaction_date DATE := FND_API.G_MISS_DATE,
106: item_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
107: cust_po_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
108: ato_line_id NUMBER := FND_API.G_MISS_NUM,
109: top_model_line_id NUMBER := FND_API.G_MISS_NUM,
110: link_to_line_id NUMBER := FND_API.G_MISS_NUM,
111: order_number number := fnd_api.g_miss_num,
104: transaction_type_id NUMBER := FND_API.G_MISS_NUM,
105: transaction_date DATE := FND_API.G_MISS_DATE,
106: item_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
107: cust_po_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
108: ato_line_id NUMBER := FND_API.G_MISS_NUM,
109: top_model_line_id NUMBER := FND_API.G_MISS_NUM,
110: link_to_line_id NUMBER := FND_API.G_MISS_NUM,
111: order_number number := fnd_api.g_miss_num,
112: line_number varchar2(30) := fnd_api.g_miss_char,
105: transaction_date DATE := FND_API.G_MISS_DATE,
106: item_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
107: cust_po_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
108: ato_line_id NUMBER := FND_API.G_MISS_NUM,
109: top_model_line_id NUMBER := FND_API.G_MISS_NUM,
110: link_to_line_id NUMBER := FND_API.G_MISS_NUM,
111: order_number number := fnd_api.g_miss_num,
112: line_number varchar2(30) := fnd_api.g_miss_char,
113: ib_owner varchar2(30) := fnd_api.g_miss_char,
106: item_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
107: cust_po_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
108: ato_line_id NUMBER := FND_API.G_MISS_NUM,
109: top_model_line_id NUMBER := FND_API.G_MISS_NUM,
110: link_to_line_id NUMBER := FND_API.G_MISS_NUM,
111: order_number number := fnd_api.g_miss_num,
112: line_number varchar2(30) := fnd_api.g_miss_char,
113: ib_owner varchar2(30) := fnd_api.g_miss_char,
114: end_customer_id NUMBER := fnd_api.g_miss_num,
107: cust_po_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
108: ato_line_id NUMBER := FND_API.G_MISS_NUM,
109: top_model_line_id NUMBER := FND_API.G_MISS_NUM,
110: link_to_line_id NUMBER := FND_API.G_MISS_NUM,
111: order_number number := fnd_api.g_miss_num,
112: line_number varchar2(30) := fnd_api.g_miss_char,
113: ib_owner varchar2(30) := fnd_api.g_miss_char,
114: end_customer_id NUMBER := fnd_api.g_miss_num,
115: deliver_to_org_id NUMBER := FND_API.G_MISS_NUM,
108: ato_line_id NUMBER := FND_API.G_MISS_NUM,
109: top_model_line_id NUMBER := FND_API.G_MISS_NUM,
110: link_to_line_id NUMBER := FND_API.G_MISS_NUM,
111: order_number number := fnd_api.g_miss_num,
112: line_number varchar2(30) := fnd_api.g_miss_char,
113: ib_owner varchar2(30) := fnd_api.g_miss_char,
114: end_customer_id NUMBER := fnd_api.g_miss_num,
115: deliver_to_org_id NUMBER := FND_API.G_MISS_NUM,
116: ib_install_loc VARCHAR2(60) := fnd_api.g_miss_char,
109: top_model_line_id NUMBER := FND_API.G_MISS_NUM,
110: link_to_line_id NUMBER := FND_API.G_MISS_NUM,
111: order_number number := fnd_api.g_miss_num,
112: line_number varchar2(30) := fnd_api.g_miss_char,
113: ib_owner varchar2(30) := fnd_api.g_miss_char,
114: end_customer_id NUMBER := fnd_api.g_miss_num,
115: deliver_to_org_id NUMBER := FND_API.G_MISS_NUM,
116: ib_install_loc VARCHAR2(60) := fnd_api.g_miss_char,
117: ib_install_loc_id NUMBER := fnd_api.g_miss_num,
110: link_to_line_id NUMBER := FND_API.G_MISS_NUM,
111: order_number number := fnd_api.g_miss_num,
112: line_number varchar2(30) := fnd_api.g_miss_char,
113: ib_owner varchar2(30) := fnd_api.g_miss_char,
114: end_customer_id NUMBER := fnd_api.g_miss_num,
115: deliver_to_org_id NUMBER := FND_API.G_MISS_NUM,
116: ib_install_loc VARCHAR2(60) := fnd_api.g_miss_char,
117: ib_install_loc_id NUMBER := fnd_api.g_miss_num,
118: ib_current_loc VARCHAR2(60) := fnd_api.g_miss_char,
111: order_number number := fnd_api.g_miss_num,
112: line_number varchar2(30) := fnd_api.g_miss_char,
113: ib_owner varchar2(30) := fnd_api.g_miss_char,
114: end_customer_id NUMBER := fnd_api.g_miss_num,
115: deliver_to_org_id NUMBER := FND_API.G_MISS_NUM,
116: ib_install_loc VARCHAR2(60) := fnd_api.g_miss_char,
117: ib_install_loc_id NUMBER := fnd_api.g_miss_num,
118: ib_current_loc VARCHAR2(60) := fnd_api.g_miss_char,
119: ib_current_loc_id NUMBER := fnd_api.g_miss_num,
112: line_number varchar2(30) := fnd_api.g_miss_char,
113: ib_owner varchar2(30) := fnd_api.g_miss_char,
114: end_customer_id NUMBER := fnd_api.g_miss_num,
115: deliver_to_org_id NUMBER := FND_API.G_MISS_NUM,
116: ib_install_loc VARCHAR2(60) := fnd_api.g_miss_char,
117: ib_install_loc_id NUMBER := fnd_api.g_miss_num,
118: ib_current_loc VARCHAR2(60) := fnd_api.g_miss_char,
119: ib_current_loc_id NUMBER := fnd_api.g_miss_num,
120: source_code VARCHAR2(30) := fnd_api.g_miss_char); -- Added for Siebel Genesis Project
113: ib_owner varchar2(30) := fnd_api.g_miss_char,
114: end_customer_id NUMBER := fnd_api.g_miss_num,
115: deliver_to_org_id NUMBER := FND_API.G_MISS_NUM,
116: ib_install_loc VARCHAR2(60) := fnd_api.g_miss_char,
117: ib_install_loc_id NUMBER := fnd_api.g_miss_num,
118: ib_current_loc VARCHAR2(60) := fnd_api.g_miss_char,
119: ib_current_loc_id NUMBER := fnd_api.g_miss_num,
120: source_code VARCHAR2(30) := fnd_api.g_miss_char); -- Added for Siebel Genesis Project
121:
114: end_customer_id NUMBER := fnd_api.g_miss_num,
115: deliver_to_org_id NUMBER := FND_API.G_MISS_NUM,
116: ib_install_loc VARCHAR2(60) := fnd_api.g_miss_char,
117: ib_install_loc_id NUMBER := fnd_api.g_miss_num,
118: ib_current_loc VARCHAR2(60) := fnd_api.g_miss_char,
119: ib_current_loc_id NUMBER := fnd_api.g_miss_num,
120: source_code VARCHAR2(30) := fnd_api.g_miss_char); -- Added for Siebel Genesis Project
121:
122: TYPE order_shipment_tbl IS TABLE OF order_shipment_rec INDEX BY BINARY_INTEGER;
115: deliver_to_org_id NUMBER := FND_API.G_MISS_NUM,
116: ib_install_loc VARCHAR2(60) := fnd_api.g_miss_char,
117: ib_install_loc_id NUMBER := fnd_api.g_miss_num,
118: ib_current_loc VARCHAR2(60) := fnd_api.g_miss_char,
119: ib_current_loc_id NUMBER := fnd_api.g_miss_num,
120: source_code VARCHAR2(30) := fnd_api.g_miss_char); -- Added for Siebel Genesis Project
121:
122: TYPE order_shipment_tbl IS TABLE OF order_shipment_rec INDEX BY BINARY_INTEGER;
123:
116: ib_install_loc VARCHAR2(60) := fnd_api.g_miss_char,
117: ib_install_loc_id NUMBER := fnd_api.g_miss_num,
118: ib_current_loc VARCHAR2(60) := fnd_api.g_miss_char,
119: ib_current_loc_id NUMBER := fnd_api.g_miss_num,
120: source_code VARCHAR2(30) := fnd_api.g_miss_char); -- Added for Siebel Genesis Project
121:
122: TYPE order_shipment_tbl IS TABLE OF order_shipment_rec INDEX BY BINARY_INTEGER;
123:
124: /*----------------------------------------------------------*/
126: /* Description : Record used to keep the order line details */
127: /*----------------------------------------------------------*/
128:
129: TYPE order_line_rec IS RECORD(
130: header_id NUMBER := FND_API.G_MISS_NUM,
131: order_line_id NUMBER := FND_API.G_MISS_NUM,
132: om_vld_org_id NUMBER := fnd_api.g_miss_num,
133: unit_price NUMBER := fnd_api.g_miss_num,
134: currency_code varchar2(15) := fnd_api.g_miss_char,
127: /*----------------------------------------------------------*/
128:
129: TYPE order_line_rec IS RECORD(
130: header_id NUMBER := FND_API.G_MISS_NUM,
131: order_line_id NUMBER := FND_API.G_MISS_NUM,
132: om_vld_org_id NUMBER := fnd_api.g_miss_num,
133: unit_price NUMBER := fnd_api.g_miss_num,
134: currency_code varchar2(15) := fnd_api.g_miss_char,
135: inv_item_id NUMBER := FND_API.G_MISS_NUM,
128:
129: TYPE order_line_rec IS RECORD(
130: header_id NUMBER := FND_API.G_MISS_NUM,
131: order_line_id NUMBER := FND_API.G_MISS_NUM,
132: om_vld_org_id NUMBER := fnd_api.g_miss_num,
133: unit_price NUMBER := fnd_api.g_miss_num,
134: currency_code varchar2(15) := fnd_api.g_miss_char,
135: inv_item_id NUMBER := FND_API.G_MISS_NUM,
136: inv_org_id NUMBER := FND_API.G_MISS_NUM,
129: TYPE order_line_rec IS RECORD(
130: header_id NUMBER := FND_API.G_MISS_NUM,
131: order_line_id NUMBER := FND_API.G_MISS_NUM,
132: om_vld_org_id NUMBER := fnd_api.g_miss_num,
133: unit_price NUMBER := fnd_api.g_miss_num,
134: currency_code varchar2(15) := fnd_api.g_miss_char,
135: inv_item_id NUMBER := FND_API.G_MISS_NUM,
136: inv_org_id NUMBER := FND_API.G_MISS_NUM,
137: ordered_item varchar2(80) := fnd_api.g_miss_char,
130: header_id NUMBER := FND_API.G_MISS_NUM,
131: order_line_id NUMBER := FND_API.G_MISS_NUM,
132: om_vld_org_id NUMBER := fnd_api.g_miss_num,
133: unit_price NUMBER := fnd_api.g_miss_num,
134: currency_code varchar2(15) := fnd_api.g_miss_char,
135: inv_item_id NUMBER := FND_API.G_MISS_NUM,
136: inv_org_id NUMBER := FND_API.G_MISS_NUM,
137: ordered_item varchar2(80) := fnd_api.g_miss_char,
138: ordered_quantity NUMBER := FND_API.G_MISS_NUM,
131: order_line_id NUMBER := FND_API.G_MISS_NUM,
132: om_vld_org_id NUMBER := fnd_api.g_miss_num,
133: unit_price NUMBER := fnd_api.g_miss_num,
134: currency_code varchar2(15) := fnd_api.g_miss_char,
135: inv_item_id NUMBER := FND_API.G_MISS_NUM,
136: inv_org_id NUMBER := FND_API.G_MISS_NUM,
137: ordered_item varchar2(80) := fnd_api.g_miss_char,
138: ordered_quantity NUMBER := FND_API.G_MISS_NUM,
139: shipped_quantity NUMBER := FND_API.G_MISS_NUM,
132: om_vld_org_id NUMBER := fnd_api.g_miss_num,
133: unit_price NUMBER := fnd_api.g_miss_num,
134: currency_code varchar2(15) := fnd_api.g_miss_char,
135: inv_item_id NUMBER := FND_API.G_MISS_NUM,
136: inv_org_id NUMBER := FND_API.G_MISS_NUM,
137: ordered_item varchar2(80) := fnd_api.g_miss_char,
138: ordered_quantity NUMBER := FND_API.G_MISS_NUM,
139: shipped_quantity NUMBER := FND_API.G_MISS_NUM,
140: fulfilled_quantity NUMBER := FND_API.G_MISS_NUM,
133: unit_price NUMBER := fnd_api.g_miss_num,
134: currency_code varchar2(15) := fnd_api.g_miss_char,
135: inv_item_id NUMBER := FND_API.G_MISS_NUM,
136: inv_org_id NUMBER := FND_API.G_MISS_NUM,
137: ordered_item varchar2(80) := fnd_api.g_miss_char,
138: ordered_quantity NUMBER := FND_API.G_MISS_NUM,
139: shipped_quantity NUMBER := FND_API.G_MISS_NUM,
140: fulfilled_quantity NUMBER := FND_API.G_MISS_NUM,
141: trx_sub_type_id NUMBER := FND_API.G_MISS_NUM,
134: currency_code varchar2(15) := fnd_api.g_miss_char,
135: inv_item_id NUMBER := FND_API.G_MISS_NUM,
136: inv_org_id NUMBER := FND_API.G_MISS_NUM,
137: ordered_item varchar2(80) := fnd_api.g_miss_char,
138: ordered_quantity NUMBER := FND_API.G_MISS_NUM,
139: shipped_quantity NUMBER := FND_API.G_MISS_NUM,
140: fulfilled_quantity NUMBER := FND_API.G_MISS_NUM,
141: trx_sub_type_id NUMBER := FND_API.G_MISS_NUM,
142: split_ord_line_id NUMBER := FND_API.G_MISS_NUM,
135: inv_item_id NUMBER := FND_API.G_MISS_NUM,
136: inv_org_id NUMBER := FND_API.G_MISS_NUM,
137: ordered_item varchar2(80) := fnd_api.g_miss_char,
138: ordered_quantity NUMBER := FND_API.G_MISS_NUM,
139: shipped_quantity NUMBER := FND_API.G_MISS_NUM,
140: fulfilled_quantity NUMBER := FND_API.G_MISS_NUM,
141: trx_sub_type_id NUMBER := FND_API.G_MISS_NUM,
142: split_ord_line_id NUMBER := FND_API.G_MISS_NUM,
143: serial_code NUMBER := FND_API.G_MISS_NUM,
136: inv_org_id NUMBER := FND_API.G_MISS_NUM,
137: ordered_item varchar2(80) := fnd_api.g_miss_char,
138: ordered_quantity NUMBER := FND_API.G_MISS_NUM,
139: shipped_quantity NUMBER := FND_API.G_MISS_NUM,
140: fulfilled_quantity NUMBER := FND_API.G_MISS_NUM,
141: trx_sub_type_id NUMBER := FND_API.G_MISS_NUM,
142: split_ord_line_id NUMBER := FND_API.G_MISS_NUM,
143: serial_code NUMBER := FND_API.G_MISS_NUM,
144: internal_party_id NUMBER := FND_API.G_MISS_NUM,
137: ordered_item varchar2(80) := fnd_api.g_miss_char,
138: ordered_quantity NUMBER := FND_API.G_MISS_NUM,
139: shipped_quantity NUMBER := FND_API.G_MISS_NUM,
140: fulfilled_quantity NUMBER := FND_API.G_MISS_NUM,
141: trx_sub_type_id NUMBER := FND_API.G_MISS_NUM,
142: split_ord_line_id NUMBER := FND_API.G_MISS_NUM,
143: serial_code NUMBER := FND_API.G_MISS_NUM,
144: internal_party_id NUMBER := FND_API.G_MISS_NUM,
145: trx_line_id NUMBER := FND_API.G_MISS_NUM,
138: ordered_quantity NUMBER := FND_API.G_MISS_NUM,
139: shipped_quantity NUMBER := FND_API.G_MISS_NUM,
140: fulfilled_quantity NUMBER := FND_API.G_MISS_NUM,
141: trx_sub_type_id NUMBER := FND_API.G_MISS_NUM,
142: split_ord_line_id NUMBER := FND_API.G_MISS_NUM,
143: serial_code NUMBER := FND_API.G_MISS_NUM,
144: internal_party_id NUMBER := FND_API.G_MISS_NUM,
145: trx_line_id NUMBER := FND_API.G_MISS_NUM,
146: ato_line_id NUMBER := FND_API.G_MISS_NUM,
139: shipped_quantity NUMBER := FND_API.G_MISS_NUM,
140: fulfilled_quantity NUMBER := FND_API.G_MISS_NUM,
141: trx_sub_type_id NUMBER := FND_API.G_MISS_NUM,
142: split_ord_line_id NUMBER := FND_API.G_MISS_NUM,
143: serial_code NUMBER := FND_API.G_MISS_NUM,
144: internal_party_id NUMBER := FND_API.G_MISS_NUM,
145: trx_line_id NUMBER := FND_API.G_MISS_NUM,
146: ato_line_id NUMBER := FND_API.G_MISS_NUM,
147: top_model_line_id NUMBER := FND_API.G_MISS_NUM,
140: fulfilled_quantity NUMBER := FND_API.G_MISS_NUM,
141: trx_sub_type_id NUMBER := FND_API.G_MISS_NUM,
142: split_ord_line_id NUMBER := FND_API.G_MISS_NUM,
143: serial_code NUMBER := FND_API.G_MISS_NUM,
144: internal_party_id NUMBER := FND_API.G_MISS_NUM,
145: trx_line_id NUMBER := FND_API.G_MISS_NUM,
146: ato_line_id NUMBER := FND_API.G_MISS_NUM,
147: top_model_line_id NUMBER := FND_API.G_MISS_NUM,
148: link_to_line_id NUMBER := FND_API.G_MISS_NUM,
141: trx_sub_type_id NUMBER := FND_API.G_MISS_NUM,
142: split_ord_line_id NUMBER := FND_API.G_MISS_NUM,
143: serial_code NUMBER := FND_API.G_MISS_NUM,
144: internal_party_id NUMBER := FND_API.G_MISS_NUM,
145: trx_line_id NUMBER := FND_API.G_MISS_NUM,
146: ato_line_id NUMBER := FND_API.G_MISS_NUM,
147: top_model_line_id NUMBER := FND_API.G_MISS_NUM,
148: link_to_line_id NUMBER := FND_API.G_MISS_NUM,
149: party_id NUMBER := FND_API.G_MISS_NUM,
142: split_ord_line_id NUMBER := FND_API.G_MISS_NUM,
143: serial_code NUMBER := FND_API.G_MISS_NUM,
144: internal_party_id NUMBER := FND_API.G_MISS_NUM,
145: trx_line_id NUMBER := FND_API.G_MISS_NUM,
146: ato_line_id NUMBER := FND_API.G_MISS_NUM,
147: top_model_line_id NUMBER := FND_API.G_MISS_NUM,
148: link_to_line_id NUMBER := FND_API.G_MISS_NUM,
149: party_id NUMBER := FND_API.G_MISS_NUM,
150: customer_id NUMBER := FND_API.G_MISS_NUM,
143: serial_code NUMBER := FND_API.G_MISS_NUM,
144: internal_party_id NUMBER := FND_API.G_MISS_NUM,
145: trx_line_id NUMBER := FND_API.G_MISS_NUM,
146: ato_line_id NUMBER := FND_API.G_MISS_NUM,
147: top_model_line_id NUMBER := FND_API.G_MISS_NUM,
148: link_to_line_id NUMBER := FND_API.G_MISS_NUM,
149: party_id NUMBER := FND_API.G_MISS_NUM,
150: customer_id NUMBER := FND_API.G_MISS_NUM,
151: invoice_to_org_id NUMBER := FND_API.G_MISS_NUM,
144: internal_party_id NUMBER := FND_API.G_MISS_NUM,
145: trx_line_id NUMBER := FND_API.G_MISS_NUM,
146: ato_line_id NUMBER := FND_API.G_MISS_NUM,
147: top_model_line_id NUMBER := FND_API.G_MISS_NUM,
148: link_to_line_id NUMBER := FND_API.G_MISS_NUM,
149: party_id NUMBER := FND_API.G_MISS_NUM,
150: customer_id NUMBER := FND_API.G_MISS_NUM,
151: invoice_to_org_id NUMBER := FND_API.G_MISS_NUM,
152: ship_to_org_id NUMBER := FND_API.G_MISS_NUM,
145: trx_line_id NUMBER := FND_API.G_MISS_NUM,
146: ato_line_id NUMBER := FND_API.G_MISS_NUM,
147: top_model_line_id NUMBER := FND_API.G_MISS_NUM,
148: link_to_line_id NUMBER := FND_API.G_MISS_NUM,
149: party_id NUMBER := FND_API.G_MISS_NUM,
150: customer_id NUMBER := FND_API.G_MISS_NUM,
151: invoice_to_org_id NUMBER := FND_API.G_MISS_NUM,
152: ship_to_org_id NUMBER := FND_API.G_MISS_NUM,
153: sold_from_org_id NUMBER := FND_API.G_MISS_NUM,
146: ato_line_id NUMBER := FND_API.G_MISS_NUM,
147: top_model_line_id NUMBER := FND_API.G_MISS_NUM,
148: link_to_line_id NUMBER := FND_API.G_MISS_NUM,
149: party_id NUMBER := FND_API.G_MISS_NUM,
150: customer_id NUMBER := FND_API.G_MISS_NUM,
151: invoice_to_org_id NUMBER := FND_API.G_MISS_NUM,
152: ship_to_org_id NUMBER := FND_API.G_MISS_NUM,
153: sold_from_org_id NUMBER := FND_API.G_MISS_NUM,
154: sold_to_org_id NUMBER := FND_API.G_MISS_NUM,
147: top_model_line_id NUMBER := FND_API.G_MISS_NUM,
148: link_to_line_id NUMBER := FND_API.G_MISS_NUM,
149: party_id NUMBER := FND_API.G_MISS_NUM,
150: customer_id NUMBER := FND_API.G_MISS_NUM,
151: invoice_to_org_id NUMBER := FND_API.G_MISS_NUM,
152: ship_to_org_id NUMBER := FND_API.G_MISS_NUM,
153: sold_from_org_id NUMBER := FND_API.G_MISS_NUM,
154: sold_to_org_id NUMBER := FND_API.G_MISS_NUM,
155: ship_to_party_site_id NUMBER := fnd_api.g_miss_num,
148: link_to_line_id NUMBER := FND_API.G_MISS_NUM,
149: party_id NUMBER := FND_API.G_MISS_NUM,
150: customer_id NUMBER := FND_API.G_MISS_NUM,
151: invoice_to_org_id NUMBER := FND_API.G_MISS_NUM,
152: ship_to_org_id NUMBER := FND_API.G_MISS_NUM,
153: sold_from_org_id NUMBER := FND_API.G_MISS_NUM,
154: sold_to_org_id NUMBER := FND_API.G_MISS_NUM,
155: ship_to_party_site_id NUMBER := fnd_api.g_miss_num,
156: item_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
149: party_id NUMBER := FND_API.G_MISS_NUM,
150: customer_id NUMBER := FND_API.G_MISS_NUM,
151: invoice_to_org_id NUMBER := FND_API.G_MISS_NUM,
152: ship_to_org_id NUMBER := FND_API.G_MISS_NUM,
153: sold_from_org_id NUMBER := FND_API.G_MISS_NUM,
154: sold_to_org_id NUMBER := FND_API.G_MISS_NUM,
155: ship_to_party_site_id NUMBER := fnd_api.g_miss_num,
156: item_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
157: transaction_date DATE := FND_API.G_MISS_DATE,
150: customer_id NUMBER := FND_API.G_MISS_NUM,
151: invoice_to_org_id NUMBER := FND_API.G_MISS_NUM,
152: ship_to_org_id NUMBER := FND_API.G_MISS_NUM,
153: sold_from_org_id NUMBER := FND_API.G_MISS_NUM,
154: sold_to_org_id NUMBER := FND_API.G_MISS_NUM,
155: ship_to_party_site_id NUMBER := fnd_api.g_miss_num,
156: item_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
157: transaction_date DATE := FND_API.G_MISS_DATE,
158: order_quantity_uom VARCHAR2(30) := FND_API.G_MISS_CHAR,
151: invoice_to_org_id NUMBER := FND_API.G_MISS_NUM,
152: ship_to_org_id NUMBER := FND_API.G_MISS_NUM,
153: sold_from_org_id NUMBER := FND_API.G_MISS_NUM,
154: sold_to_org_id NUMBER := FND_API.G_MISS_NUM,
155: ship_to_party_site_id NUMBER := fnd_api.g_miss_num,
156: item_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
157: transaction_date DATE := FND_API.G_MISS_DATE,
158: order_quantity_uom VARCHAR2(30) := FND_API.G_MISS_CHAR,
159: primary_uom VARCHAR2(30) := fnd_api.g_miss_char,
152: ship_to_org_id NUMBER := FND_API.G_MISS_NUM,
153: sold_from_org_id NUMBER := FND_API.G_MISS_NUM,
154: sold_to_org_id NUMBER := FND_API.G_MISS_NUM,
155: ship_to_party_site_id NUMBER := fnd_api.g_miss_num,
156: item_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
157: transaction_date DATE := FND_API.G_MISS_DATE,
158: order_quantity_uom VARCHAR2(30) := FND_API.G_MISS_CHAR,
159: primary_uom VARCHAR2(30) := fnd_api.g_miss_char,
160: inv_mtl_transaction_id NUMBER := FND_API.G_MISS_NUM ,
153: sold_from_org_id NUMBER := FND_API.G_MISS_NUM,
154: sold_to_org_id NUMBER := FND_API.G_MISS_NUM,
155: ship_to_party_site_id NUMBER := fnd_api.g_miss_num,
156: item_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
157: transaction_date DATE := FND_API.G_MISS_DATE,
158: order_quantity_uom VARCHAR2(30) := FND_API.G_MISS_CHAR,
159: primary_uom VARCHAR2(30) := fnd_api.g_miss_char,
160: inv_mtl_transaction_id NUMBER := FND_API.G_MISS_NUM ,
161: ship_to_contact_id NUMBER := FND_API.G_MISS_NUM,
154: sold_to_org_id NUMBER := FND_API.G_MISS_NUM,
155: ship_to_party_site_id NUMBER := fnd_api.g_miss_num,
156: item_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
157: transaction_date DATE := FND_API.G_MISS_DATE,
158: order_quantity_uom VARCHAR2(30) := FND_API.G_MISS_CHAR,
159: primary_uom VARCHAR2(30) := fnd_api.g_miss_char,
160: inv_mtl_transaction_id NUMBER := FND_API.G_MISS_NUM ,
161: ship_to_contact_id NUMBER := FND_API.G_MISS_NUM,
162: invoice_to_contact_id NUMBER := FND_API.G_MISS_NUM,
155: ship_to_party_site_id NUMBER := fnd_api.g_miss_num,
156: item_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
157: transaction_date DATE := FND_API.G_MISS_DATE,
158: order_quantity_uom VARCHAR2(30) := FND_API.G_MISS_CHAR,
159: primary_uom VARCHAR2(30) := fnd_api.g_miss_char,
160: inv_mtl_transaction_id NUMBER := FND_API.G_MISS_NUM ,
161: ship_to_contact_id NUMBER := FND_API.G_MISS_NUM,
162: invoice_to_contact_id NUMBER := FND_API.G_MISS_NUM,
163: agreement_id NUMBER := FND_API.g_MISS_NUM,
156: item_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
157: transaction_date DATE := FND_API.G_MISS_DATE,
158: order_quantity_uom VARCHAR2(30) := FND_API.G_MISS_CHAR,
159: primary_uom VARCHAR2(30) := fnd_api.g_miss_char,
160: inv_mtl_transaction_id NUMBER := FND_API.G_MISS_NUM ,
161: ship_to_contact_id NUMBER := FND_API.G_MISS_NUM,
162: invoice_to_contact_id NUMBER := FND_API.G_MISS_NUM,
163: agreement_id NUMBER := FND_API.g_MISS_NUM,
164: order_number number := fnd_api.g_miss_num,
157: transaction_date DATE := FND_API.G_MISS_DATE,
158: order_quantity_uom VARCHAR2(30) := FND_API.G_MISS_CHAR,
159: primary_uom VARCHAR2(30) := fnd_api.g_miss_char,
160: inv_mtl_transaction_id NUMBER := FND_API.G_MISS_NUM ,
161: ship_to_contact_id NUMBER := FND_API.G_MISS_NUM,
162: invoice_to_contact_id NUMBER := FND_API.G_MISS_NUM,
163: agreement_id NUMBER := FND_API.g_MISS_NUM,
164: order_number number := fnd_api.g_miss_num,
165: line_number varchar2(30):= fnd_api.g_miss_char,
158: order_quantity_uom VARCHAR2(30) := FND_API.G_MISS_CHAR,
159: primary_uom VARCHAR2(30) := fnd_api.g_miss_char,
160: inv_mtl_transaction_id NUMBER := FND_API.G_MISS_NUM ,
161: ship_to_contact_id NUMBER := FND_API.G_MISS_NUM,
162: invoice_to_contact_id NUMBER := FND_API.G_MISS_NUM,
163: agreement_id NUMBER := FND_API.g_MISS_NUM,
164: order_number number := fnd_api.g_miss_num,
165: line_number varchar2(30):= fnd_api.g_miss_char,
166: actual_shipment_date DATE := FND_API.G_MISS_DATE,
159: primary_uom VARCHAR2(30) := fnd_api.g_miss_char,
160: inv_mtl_transaction_id NUMBER := FND_API.G_MISS_NUM ,
161: ship_to_contact_id NUMBER := FND_API.G_MISS_NUM,
162: invoice_to_contact_id NUMBER := FND_API.G_MISS_NUM,
163: agreement_id NUMBER := FND_API.g_MISS_NUM,
164: order_number number := fnd_api.g_miss_num,
165: line_number varchar2(30):= fnd_api.g_miss_char,
166: actual_shipment_date DATE := FND_API.G_MISS_DATE,
167: fulfillment_date DATE := FND_API.G_MISS_DATE,
160: inv_mtl_transaction_id NUMBER := FND_API.G_MISS_NUM ,
161: ship_to_contact_id NUMBER := FND_API.G_MISS_NUM,
162: invoice_to_contact_id NUMBER := FND_API.G_MISS_NUM,
163: agreement_id NUMBER := FND_API.g_MISS_NUM,
164: order_number number := fnd_api.g_miss_num,
165: line_number varchar2(30):= fnd_api.g_miss_char,
166: actual_shipment_date DATE := FND_API.G_MISS_DATE,
167: fulfillment_date DATE := FND_API.G_MISS_DATE,
168: org_id NUMBER := fnd_api.g_miss_num,
161: ship_to_contact_id NUMBER := FND_API.G_MISS_NUM,
162: invoice_to_contact_id NUMBER := FND_API.G_MISS_NUM,
163: agreement_id NUMBER := FND_API.g_MISS_NUM,
164: order_number number := fnd_api.g_miss_num,
165: line_number varchar2(30):= fnd_api.g_miss_char,
166: actual_shipment_date DATE := FND_API.G_MISS_DATE,
167: fulfillment_date DATE := FND_API.G_MISS_DATE,
168: org_id NUMBER := fnd_api.g_miss_num,
169: ib_owner varchar2(60):= fnd_api.g_miss_char,
162: invoice_to_contact_id NUMBER := FND_API.G_MISS_NUM,
163: agreement_id NUMBER := FND_API.g_MISS_NUM,
164: order_number number := fnd_api.g_miss_num,
165: line_number varchar2(30):= fnd_api.g_miss_char,
166: actual_shipment_date DATE := FND_API.G_MISS_DATE,
167: fulfillment_date DATE := FND_API.G_MISS_DATE,
168: org_id NUMBER := fnd_api.g_miss_num,
169: ib_owner varchar2(60):= fnd_api.g_miss_char,
170: end_customer_id NUMBER := fnd_api.g_miss_num,
163: agreement_id NUMBER := FND_API.g_MISS_NUM,
164: order_number number := fnd_api.g_miss_num,
165: line_number varchar2(30):= fnd_api.g_miss_char,
166: actual_shipment_date DATE := FND_API.G_MISS_DATE,
167: fulfillment_date DATE := FND_API.G_MISS_DATE,
168: org_id NUMBER := fnd_api.g_miss_num,
169: ib_owner varchar2(60):= fnd_api.g_miss_char,
170: end_customer_id NUMBER := fnd_api.g_miss_num,
171: deliver_to_org_id NUMBER := FND_API.G_MISS_NUM,
164: order_number number := fnd_api.g_miss_num,
165: line_number varchar2(30):= fnd_api.g_miss_char,
166: actual_shipment_date DATE := FND_API.G_MISS_DATE,
167: fulfillment_date DATE := FND_API.G_MISS_DATE,
168: org_id NUMBER := fnd_api.g_miss_num,
169: ib_owner varchar2(60):= fnd_api.g_miss_char,
170: end_customer_id NUMBER := fnd_api.g_miss_num,
171: deliver_to_org_id NUMBER := FND_API.G_MISS_NUM,
172: ib_install_loc VARCHAR2(60):= fnd_api.g_miss_char,
165: line_number varchar2(30):= fnd_api.g_miss_char,
166: actual_shipment_date DATE := FND_API.G_MISS_DATE,
167: fulfillment_date DATE := FND_API.G_MISS_DATE,
168: org_id NUMBER := fnd_api.g_miss_num,
169: ib_owner varchar2(60):= fnd_api.g_miss_char,
170: end_customer_id NUMBER := fnd_api.g_miss_num,
171: deliver_to_org_id NUMBER := FND_API.G_MISS_NUM,
172: ib_install_loc VARCHAR2(60):= fnd_api.g_miss_char,
173: ib_install_loc_id NUMBER := fnd_api.g_miss_num,
166: actual_shipment_date DATE := FND_API.G_MISS_DATE,
167: fulfillment_date DATE := FND_API.G_MISS_DATE,
168: org_id NUMBER := fnd_api.g_miss_num,
169: ib_owner varchar2(60):= fnd_api.g_miss_char,
170: end_customer_id NUMBER := fnd_api.g_miss_num,
171: deliver_to_org_id NUMBER := FND_API.G_MISS_NUM,
172: ib_install_loc VARCHAR2(60):= fnd_api.g_miss_char,
173: ib_install_loc_id NUMBER := fnd_api.g_miss_num,
174: ib_current_loc VARCHAR2(60):= fnd_api.g_miss_char,
167: fulfillment_date DATE := FND_API.G_MISS_DATE,
168: org_id NUMBER := fnd_api.g_miss_num,
169: ib_owner varchar2(60):= fnd_api.g_miss_char,
170: end_customer_id NUMBER := fnd_api.g_miss_num,
171: deliver_to_org_id NUMBER := FND_API.G_MISS_NUM,
172: ib_install_loc VARCHAR2(60):= fnd_api.g_miss_char,
173: ib_install_loc_id NUMBER := fnd_api.g_miss_num,
174: ib_current_loc VARCHAR2(60):= fnd_api.g_miss_char,
175: ib_current_loc_id NUMBER := fnd_api.g_miss_num,
168: org_id NUMBER := fnd_api.g_miss_num,
169: ib_owner varchar2(60):= fnd_api.g_miss_char,
170: end_customer_id NUMBER := fnd_api.g_miss_num,
171: deliver_to_org_id NUMBER := FND_API.G_MISS_NUM,
172: ib_install_loc VARCHAR2(60):= fnd_api.g_miss_char,
173: ib_install_loc_id NUMBER := fnd_api.g_miss_num,
174: ib_current_loc VARCHAR2(60):= fnd_api.g_miss_char,
175: ib_current_loc_id NUMBER := fnd_api.g_miss_num,
176: bom_item_type number := fnd_api.g_miss_num,
169: ib_owner varchar2(60):= fnd_api.g_miss_char,
170: end_customer_id NUMBER := fnd_api.g_miss_num,
171: deliver_to_org_id NUMBER := FND_API.G_MISS_NUM,
172: ib_install_loc VARCHAR2(60):= fnd_api.g_miss_char,
173: ib_install_loc_id NUMBER := fnd_api.g_miss_num,
174: ib_current_loc VARCHAR2(60):= fnd_api.g_miss_char,
175: ib_current_loc_id NUMBER := fnd_api.g_miss_num,
176: bom_item_type number := fnd_api.g_miss_num,
177: reservable_type number := fnd_api.g_miss_num,
170: end_customer_id NUMBER := fnd_api.g_miss_num,
171: deliver_to_org_id NUMBER := FND_API.G_MISS_NUM,
172: ib_install_loc VARCHAR2(60):= fnd_api.g_miss_char,
173: ib_install_loc_id NUMBER := fnd_api.g_miss_num,
174: ib_current_loc VARCHAR2(60):= fnd_api.g_miss_char,
175: ib_current_loc_id NUMBER := fnd_api.g_miss_num,
176: bom_item_type number := fnd_api.g_miss_num,
177: reservable_type number := fnd_api.g_miss_num,
178: negative_balances_code number := fnd_api.g_miss_num,
171: deliver_to_org_id NUMBER := FND_API.G_MISS_NUM,
172: ib_install_loc VARCHAR2(60):= fnd_api.g_miss_char,
173: ib_install_loc_id NUMBER := fnd_api.g_miss_num,
174: ib_current_loc VARCHAR2(60):= fnd_api.g_miss_char,
175: ib_current_loc_id NUMBER := fnd_api.g_miss_num,
176: bom_item_type number := fnd_api.g_miss_num,
177: reservable_type number := fnd_api.g_miss_num,
178: negative_balances_code number := fnd_api.g_miss_num,
179: mtl_action_id number := fnd_api.g_miss_num,
172: ib_install_loc VARCHAR2(60):= fnd_api.g_miss_char,
173: ib_install_loc_id NUMBER := fnd_api.g_miss_num,
174: ib_current_loc VARCHAR2(60):= fnd_api.g_miss_char,
175: ib_current_loc_id NUMBER := fnd_api.g_miss_num,
176: bom_item_type number := fnd_api.g_miss_num,
177: reservable_type number := fnd_api.g_miss_num,
178: negative_balances_code number := fnd_api.g_miss_num,
179: mtl_action_id number := fnd_api.g_miss_num,
180: mtl_src_type_id number := fnd_api.g_miss_num,
173: ib_install_loc_id NUMBER := fnd_api.g_miss_num,
174: ib_current_loc VARCHAR2(60):= fnd_api.g_miss_char,
175: ib_current_loc_id NUMBER := fnd_api.g_miss_num,
176: bom_item_type number := fnd_api.g_miss_num,
177: reservable_type number := fnd_api.g_miss_num,
178: negative_balances_code number := fnd_api.g_miss_num,
179: mtl_action_id number := fnd_api.g_miss_num,
180: mtl_src_type_id number := fnd_api.g_miss_num,
181: config_header_id number := fnd_api.g_miss_num,
174: ib_current_loc VARCHAR2(60):= fnd_api.g_miss_char,
175: ib_current_loc_id NUMBER := fnd_api.g_miss_num,
176: bom_item_type number := fnd_api.g_miss_num,
177: reservable_type number := fnd_api.g_miss_num,
178: negative_balances_code number := fnd_api.g_miss_num,
179: mtl_action_id number := fnd_api.g_miss_num,
180: mtl_src_type_id number := fnd_api.g_miss_num,
181: config_header_id number := fnd_api.g_miss_num,
182: config_rev_nbr number := fnd_api.g_miss_num,
175: ib_current_loc_id NUMBER := fnd_api.g_miss_num,
176: bom_item_type number := fnd_api.g_miss_num,
177: reservable_type number := fnd_api.g_miss_num,
178: negative_balances_code number := fnd_api.g_miss_num,
179: mtl_action_id number := fnd_api.g_miss_num,
180: mtl_src_type_id number := fnd_api.g_miss_num,
181: config_header_id number := fnd_api.g_miss_num,
182: config_rev_nbr number := fnd_api.g_miss_num,
183: configuration_id number := fnd_api.g_miss_num,
176: bom_item_type number := fnd_api.g_miss_num,
177: reservable_type number := fnd_api.g_miss_num,
178: negative_balances_code number := fnd_api.g_miss_num,
179: mtl_action_id number := fnd_api.g_miss_num,
180: mtl_src_type_id number := fnd_api.g_miss_num,
181: config_header_id number := fnd_api.g_miss_num,
182: config_rev_nbr number := fnd_api.g_miss_num,
183: configuration_id number := fnd_api.g_miss_num,
184: macd_order_line varchar2(1):= fnd_api.g_false,
177: reservable_type number := fnd_api.g_miss_num,
178: negative_balances_code number := fnd_api.g_miss_num,
179: mtl_action_id number := fnd_api.g_miss_num,
180: mtl_src_type_id number := fnd_api.g_miss_num,
181: config_header_id number := fnd_api.g_miss_num,
182: config_rev_nbr number := fnd_api.g_miss_num,
183: configuration_id number := fnd_api.g_miss_num,
184: macd_order_line varchar2(1):= fnd_api.g_false,
185: --4344316
178: negative_balances_code number := fnd_api.g_miss_num,
179: mtl_action_id number := fnd_api.g_miss_num,
180: mtl_src_type_id number := fnd_api.g_miss_num,
181: config_header_id number := fnd_api.g_miss_num,
182: config_rev_nbr number := fnd_api.g_miss_num,
183: configuration_id number := fnd_api.g_miss_num,
184: macd_order_line varchar2(1):= fnd_api.g_false,
185: --4344316
186: model_remnant_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
179: mtl_action_id number := fnd_api.g_miss_num,
180: mtl_src_type_id number := fnd_api.g_miss_num,
181: config_header_id number := fnd_api.g_miss_num,
182: config_rev_nbr number := fnd_api.g_miss_num,
183: configuration_id number := fnd_api.g_miss_num,
184: macd_order_line varchar2(1):= fnd_api.g_false,
185: --4344316
186: model_remnant_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
187: source_code VARCHAR2(30) := FND_API.G_MISS_CHAR -- Added for Siebel Genesis Project
180: mtl_src_type_id number := fnd_api.g_miss_num,
181: config_header_id number := fnd_api.g_miss_num,
182: config_rev_nbr number := fnd_api.g_miss_num,
183: configuration_id number := fnd_api.g_miss_num,
184: macd_order_line varchar2(1):= fnd_api.g_false,
185: --4344316
186: model_remnant_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
187: source_code VARCHAR2(30) := FND_API.G_MISS_CHAR -- Added for Siebel Genesis Project
188: );
182: config_rev_nbr number := fnd_api.g_miss_num,
183: configuration_id number := fnd_api.g_miss_num,
184: macd_order_line varchar2(1):= fnd_api.g_false,
185: --4344316
186: model_remnant_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
187: source_code VARCHAR2(30) := FND_API.G_MISS_CHAR -- Added for Siebel Genesis Project
188: );
189:
190: /*----------------------------------------------------------*/
183: configuration_id number := fnd_api.g_miss_num,
184: macd_order_line varchar2(1):= fnd_api.g_false,
185: --4344316
186: model_remnant_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
187: source_code VARCHAR2(30) := FND_API.G_MISS_CHAR -- Added for Siebel Genesis Project
188: );
189:
190: /*----------------------------------------------------------*/
191: /* Record name: txn_sub_type_rec */
192: /* Description : Record used to keep the sub type definition*/
193: /*----------------------------------------------------------*/
194:
195: TYPE txn_sub_type_rec IS RECORD(
196: src_chg_owner_code VARCHAR2(1) := FND_API.G_MISS_CHAR,
197: nsrc_chg_owner_code VARCHAR2(1) := FND_API.G_MISS_CHAR,
198: src_status_id NUMBER := FND_API.G_MISS_NUM ,
199: nsrc_status_id NUMBER := FND_API.G_MISS_NUM ,
200: src_change_owner VARCHAR2(1) := FND_API.G_MISS_CHAR,
193: /*----------------------------------------------------------*/
194:
195: TYPE txn_sub_type_rec IS RECORD(
196: src_chg_owner_code VARCHAR2(1) := FND_API.G_MISS_CHAR,
197: nsrc_chg_owner_code VARCHAR2(1) := FND_API.G_MISS_CHAR,
198: src_status_id NUMBER := FND_API.G_MISS_NUM ,
199: nsrc_status_id NUMBER := FND_API.G_MISS_NUM ,
200: src_change_owner VARCHAR2(1) := FND_API.G_MISS_CHAR,
201: nsrc_change_owner VARCHAR2(1) := FND_API.G_MISS_CHAR,
194:
195: TYPE txn_sub_type_rec IS RECORD(
196: src_chg_owner_code VARCHAR2(1) := FND_API.G_MISS_CHAR,
197: nsrc_chg_owner_code VARCHAR2(1) := FND_API.G_MISS_CHAR,
198: src_status_id NUMBER := FND_API.G_MISS_NUM ,
199: nsrc_status_id NUMBER := FND_API.G_MISS_NUM ,
200: src_change_owner VARCHAR2(1) := FND_API.G_MISS_CHAR,
201: nsrc_change_owner VARCHAR2(1) := FND_API.G_MISS_CHAR,
202: trx_type_id NUMBER := FND_API.G_MISS_NUM ,
195: TYPE txn_sub_type_rec IS RECORD(
196: src_chg_owner_code VARCHAR2(1) := FND_API.G_MISS_CHAR,
197: nsrc_chg_owner_code VARCHAR2(1) := FND_API.G_MISS_CHAR,
198: src_status_id NUMBER := FND_API.G_MISS_NUM ,
199: nsrc_status_id NUMBER := FND_API.G_MISS_NUM ,
200: src_change_owner VARCHAR2(1) := FND_API.G_MISS_CHAR,
201: nsrc_change_owner VARCHAR2(1) := FND_API.G_MISS_CHAR,
202: trx_type_id NUMBER := FND_API.G_MISS_NUM ,
203: sub_type_id NUMBER := FND_API.G_MISS_NUM ,
196: src_chg_owner_code VARCHAR2(1) := FND_API.G_MISS_CHAR,
197: nsrc_chg_owner_code VARCHAR2(1) := FND_API.G_MISS_CHAR,
198: src_status_id NUMBER := FND_API.G_MISS_NUM ,
199: nsrc_status_id NUMBER := FND_API.G_MISS_NUM ,
200: src_change_owner VARCHAR2(1) := FND_API.G_MISS_CHAR,
201: nsrc_change_owner VARCHAR2(1) := FND_API.G_MISS_CHAR,
202: trx_type_id NUMBER := FND_API.G_MISS_NUM ,
203: sub_type_id NUMBER := FND_API.G_MISS_NUM ,
204: src_reference_reqd VARCHAR2(1) := FND_API.G_MISS_CHAR,
197: nsrc_chg_owner_code VARCHAR2(1) := FND_API.G_MISS_CHAR,
198: src_status_id NUMBER := FND_API.G_MISS_NUM ,
199: nsrc_status_id NUMBER := FND_API.G_MISS_NUM ,
200: src_change_owner VARCHAR2(1) := FND_API.G_MISS_CHAR,
201: nsrc_change_owner VARCHAR2(1) := FND_API.G_MISS_CHAR,
202: trx_type_id NUMBER := FND_API.G_MISS_NUM ,
203: sub_type_id NUMBER := FND_API.G_MISS_NUM ,
204: src_reference_reqd VARCHAR2(1) := FND_API.G_MISS_CHAR,
205: nsrc_reference_reqd VARCHAR2(1) := FND_API.G_MISS_CHAR,
198: src_status_id NUMBER := FND_API.G_MISS_NUM ,
199: nsrc_status_id NUMBER := FND_API.G_MISS_NUM ,
200: src_change_owner VARCHAR2(1) := FND_API.G_MISS_CHAR,
201: nsrc_change_owner VARCHAR2(1) := FND_API.G_MISS_CHAR,
202: trx_type_id NUMBER := FND_API.G_MISS_NUM ,
203: sub_type_id NUMBER := FND_API.G_MISS_NUM ,
204: src_reference_reqd VARCHAR2(1) := FND_API.G_MISS_CHAR,
205: nsrc_reference_reqd VARCHAR2(1) := FND_API.G_MISS_CHAR,
206: src_return_reqd VARCHAR2(1) := FND_API.G_MISS_CHAR,
199: nsrc_status_id NUMBER := FND_API.G_MISS_NUM ,
200: src_change_owner VARCHAR2(1) := FND_API.G_MISS_CHAR,
201: nsrc_change_owner VARCHAR2(1) := FND_API.G_MISS_CHAR,
202: trx_type_id NUMBER := FND_API.G_MISS_NUM ,
203: sub_type_id NUMBER := FND_API.G_MISS_NUM ,
204: src_reference_reqd VARCHAR2(1) := FND_API.G_MISS_CHAR,
205: nsrc_reference_reqd VARCHAR2(1) := FND_API.G_MISS_CHAR,
206: src_return_reqd VARCHAR2(1) := FND_API.G_MISS_CHAR,
207: nsrc_return_reqd VARCHAR2(1) := FND_API.G_MISS_CHAR );
200: src_change_owner VARCHAR2(1) := FND_API.G_MISS_CHAR,
201: nsrc_change_owner VARCHAR2(1) := FND_API.G_MISS_CHAR,
202: trx_type_id NUMBER := FND_API.G_MISS_NUM ,
203: sub_type_id NUMBER := FND_API.G_MISS_NUM ,
204: src_reference_reqd VARCHAR2(1) := FND_API.G_MISS_CHAR,
205: nsrc_reference_reqd VARCHAR2(1) := FND_API.G_MISS_CHAR,
206: src_return_reqd VARCHAR2(1) := FND_API.G_MISS_CHAR,
207: nsrc_return_reqd VARCHAR2(1) := FND_API.G_MISS_CHAR );
208:
201: nsrc_change_owner VARCHAR2(1) := FND_API.G_MISS_CHAR,
202: trx_type_id NUMBER := FND_API.G_MISS_NUM ,
203: sub_type_id NUMBER := FND_API.G_MISS_NUM ,
204: src_reference_reqd VARCHAR2(1) := FND_API.G_MISS_CHAR,
205: nsrc_reference_reqd VARCHAR2(1) := FND_API.G_MISS_CHAR,
206: src_return_reqd VARCHAR2(1) := FND_API.G_MISS_CHAR,
207: nsrc_return_reqd VARCHAR2(1) := FND_API.G_MISS_CHAR );
208:
209: /*----------------------------------------------------------*/
202: trx_type_id NUMBER := FND_API.G_MISS_NUM ,
203: sub_type_id NUMBER := FND_API.G_MISS_NUM ,
204: src_reference_reqd VARCHAR2(1) := FND_API.G_MISS_CHAR,
205: nsrc_reference_reqd VARCHAR2(1) := FND_API.G_MISS_CHAR,
206: src_return_reqd VARCHAR2(1) := FND_API.G_MISS_CHAR,
207: nsrc_return_reqd VARCHAR2(1) := FND_API.G_MISS_CHAR );
208:
209: /*----------------------------------------------------------*/
210: /* Procedure name: Order_shipment */
203: sub_type_id NUMBER := FND_API.G_MISS_NUM ,
204: src_reference_reqd VARCHAR2(1) := FND_API.G_MISS_CHAR,
205: nsrc_reference_reqd VARCHAR2(1) := FND_API.G_MISS_CHAR,
206: src_return_reqd VARCHAR2(1) := FND_API.G_MISS_CHAR,
207: nsrc_return_reqd VARCHAR2(1) := FND_API.G_MISS_CHAR );
208:
209: /*----------------------------------------------------------*/
210: /* Procedure name: Order_shipment */
211: /* Description : Main Procedure that process the order */
270: /* matched txn line details */
271: /*----------------------------------------------------------*/
272: PROCEDURE update_install_base(
273: p_api_version IN NUMBER,
274: p_commit IN VARCHAR2 := fnd_api.g_false,
275: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
276: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
277: p_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
278: p_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
271: /*----------------------------------------------------------*/
272: PROCEDURE update_install_base(
273: p_api_version IN NUMBER,
274: p_commit IN VARCHAR2 := fnd_api.g_false,
275: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
276: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
277: p_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
278: p_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
279: p_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
272: PROCEDURE update_install_base(
273: p_api_version IN NUMBER,
274: p_commit IN VARCHAR2 := fnd_api.g_false,
275: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
276: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
277: p_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
278: p_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
279: p_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
280: p_txn_pty_acct_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,