DBA Data[Home] [Help]

APPS.CSI_ORDER_SHIP_PUB dependencies on FND_API

Line 18: parent_line_id NUMBER := fnd_api.g_miss_num,

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);

Line 19: instance_id NUMBER := fnd_api.g_miss_num,

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:

Line 20: rem_qty NUMBER := fnd_api.g_miss_num,

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;

Line 21: txn_line_detail_id NUMBER := fnd_api.g_miss_num,

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:

Line 22: process_flag VARCHAR2(1) := fnd_api.g_miss_char);

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: /*----------------------------------------------------------*/

Line 33: MTL_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,

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,

Line 34: SOURCE_LINE_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

Line 35: SOURCE_HEADER_REF_ID NUMBER := FND_API.G_MISS_NUM,

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,

Line 36: SOURCE_HEADER_REF VARCHAR2(150) := FND_API.G_MISS_CHAR, -- Changed for bug#15931790

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 );

Line 37: SOURCE_LINE_REF_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:

Line 38: SOURCE_LINE_REF VARCHAR2(150) := FND_API.G_MISS_CHAR, -- Changed for bug#15931790

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 (

Line 39: SOURCE_TRANSACTION_DATE DATE := FND_API.G_MISS_DATE,

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,

Line 40: INV_MATERIAL_TRANSACTION_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,

Line 43: inventory_item_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,

Line 44: organization_id 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,

Line 45: ib_trackable_flag varchar2(1) := fnd_api.g_miss_char,

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,

Line 46: serial_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,

Line 47: lot_control_code number := fnd_api.g_miss_num,

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,

Line 48: revision_control_code 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,

Line 49: locator_control_code 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,

Line 50: primary_uom_code varchar2(3) := 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,

Line 51: bom_item_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,

Line 52: model_item_id 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,

Line 53: pick_components_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);

Line 54: reservable_type 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);
58:

Line 55: negative_balances_code number := fnd_api.g_miss_num,

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: /*-----------------------------------------------------------*/

Line 56: shippable_flag varchar2(1) := fnd_api.g_miss_char,

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 */

Line 57: transactable_flag varchar2(1) := fnd_api.g_miss_char);

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*/

Line 65: line_id NUMBER := FND_API.G_MISS_NUM,

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,

Line 66: header_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,

Line 67: txn_line_detail_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,

Line 68: orig_inst_id 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,

Line 69: instance_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,

Line 70: system_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,
74: party_account_id NUMBER := FND_API.G_MISS_NUM,

Line 71: instance_qty 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,

Line 72: party_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,
76: txn_dtls_qty NUMBER := FND_API.G_MISS_NUM,

Line 73: party_source_table VARCHAR2(30) := FND_API.G_MISS_CHAR,

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,

Line 74: party_account_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,
78: instance_match VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 75: inst_obj_version_number 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,
79: quantity_match VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 76: txn_dtls_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,
80: -- Added this for Bug 3384668

Line 77: ord_line_shipped_qty 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
81: lot_match VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 78: instance_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,

Line 79: quantity_match VARCHAR2(1) := FND_API.G_MISS_CHAR,

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,

Line 81: lot_match VARCHAR2(1) := FND_API.G_MISS_CHAR,

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,

Line 82: customer_id 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,
86: subinventory VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 83: inventory_item_id NUMBER := FND_API.G_MISS_NUM,

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,

Line 84: organization_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,

Line 85: revision VARCHAR2(30) := 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,

Line 86: subinventory 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,

Line 87: locator_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,
91: order_quantity_uom VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 88: lot_number VARCHAR2(80) := 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,

Line 89: serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR,

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,

Line 90: transaction_uom 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,
94: line_type_id NUMBER := FND_API.G_MISS_NUM,

Line 91: order_quantity_uom 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,
95: ordered_quantity NUMBER := FND_API.G_MISS_NUM,

Line 92: invoice_to_contact_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,
96: ship_to_contact_id NUMBER := FND_API.G_MISS_NUM,

Line 93: invoice_to_org_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,

Line 94: line_type_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,

Line 95: ordered_quantity 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,

Line 96: ship_to_contact_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,

Line 97: ship_to_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,

Line 98: ship_from_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,
102: shipped_quantity NUMBER := FND_API.G_MISS_NUM,

Line 99: sold_to_org_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,
103: ship_to_site_use_id NUMBER := FND_API.G_MISS_NUM,

Line 100: sold_from_org_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,

Line 101: source_line_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,

Line 102: shipped_quantity 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,
106: item_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 103: ship_to_site_use_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,
107: cust_po_number VARCHAR2(50) := FND_API.G_MISS_CHAR,

Line 104: transaction_type_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,
108: ato_line_id NUMBER := FND_API.G_MISS_NUM,

Line 105: transaction_date DATE := FND_API.G_MISS_DATE,

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,

Line 106: item_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,

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,

Line 107: cust_po_number VARCHAR2(50) := FND_API.G_MISS_CHAR,

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,

Line 108: ato_line_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,
112: line_number varchar2(30) := fnd_api.g_miss_char,

Line 109: top_model_line_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,
113: ib_owner varchar2(30) := fnd_api.g_miss_char,

Line 110: link_to_line_id NUMBER := FND_API.G_MISS_NUM,

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,

Line 111: order_number 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,

Line 112: line_number varchar2(30) := 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,
116: ib_install_loc VARCHAR2(60) := fnd_api.g_miss_char,

Line 113: ib_owner varchar2(30) := 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,

Line 114: end_customer_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,

Line 115: deliver_to_org_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,
119: ib_current_loc_id NUMBER := fnd_api.g_miss_num,

Line 116: ib_install_loc VARCHAR2(60) := fnd_api.g_miss_char,

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

Line 117: ib_install_loc_id NUMBER := fnd_api.g_miss_num,

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:

Line 118: ib_current_loc VARCHAR2(60) := 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:
122: TYPE order_shipment_tbl IS TABLE OF order_shipment_rec INDEX BY BINARY_INTEGER;

Line 119: ib_current_loc_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;
123:

Line 120: source_code VARCHAR2(30) := fnd_api.g_miss_char); -- Added for Siebel Genesis Project

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: /*----------------------------------------------------------*/

Line 130: header_id NUMBER := FND_API.G_MISS_NUM,

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,

Line 131: order_line_id NUMBER := FND_API.G_MISS_NUM,

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,

Line 132: om_vld_org_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,

Line 133: unit_price 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,

Line 134: currency_code varchar2(15) := 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,

Line 135: inv_item_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,
139: shipped_quantity NUMBER := FND_API.G_MISS_NUM,

Line 136: inv_org_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,
140: fulfilled_quantity NUMBER := FND_API.G_MISS_NUM,

Line 137: ordered_item varchar2(80) := fnd_api.g_miss_char,

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,

Line 138: ordered_quantity 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,

Line 139: shipped_quantity 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,

Line 140: fulfilled_quantity 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,

Line 141: trx_sub_type_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,

Line 142: split_ord_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,

Line 143: serial_code 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,

Line 144: internal_party_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,

Line 145: trx_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,

Line 146: ato_line_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,

Line 147: top_model_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,
151: invoice_to_org_id NUMBER := FND_API.G_MISS_NUM,

Line 148: link_to_line_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,

Line 149: 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,
153: sold_from_org_id NUMBER := FND_API.G_MISS_NUM,

Line 150: customer_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,

Line 151: invoice_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,

Line 152: ship_to_org_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,

Line 153: sold_from_org_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,
157: transaction_date DATE := FND_API.G_MISS_DATE,

Line 154: sold_to_org_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,
158: order_quantity_uom VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 155: ship_to_party_site_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,
159: primary_uom VARCHAR2(30) := fnd_api.g_miss_char,

Line 156: item_type_code 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 ,

Line 157: transaction_date DATE := FND_API.G_MISS_DATE,

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,

Line 158: order_quantity_uom VARCHAR2(30) := FND_API.G_MISS_CHAR,

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,

Line 159: primary_uom VARCHAR2(30) := fnd_api.g_miss_char,

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,

Line 160: inv_mtl_transaction_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,

Line 161: ship_to_contact_id 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,

Line 162: invoice_to_contact_id NUMBER := FND_API.G_MISS_NUM,

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,

Line 163: agreement_id NUMBER := FND_API.g_MISS_NUM,

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,

Line 164: order_number number := fnd_api.g_miss_num,

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,

Line 165: line_number varchar2(30):= fnd_api.g_miss_char,

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,

Line 166: actual_shipment_date DATE := FND_API.G_MISS_DATE,

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,

Line 167: fulfillment_date DATE := FND_API.G_MISS_DATE,

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,

Line 168: 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,

Line 169: ib_owner 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,

Line 170: end_customer_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,

Line 171: deliver_to_org_id NUMBER := FND_API.G_MISS_NUM,

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,

Line 172: ib_install_loc VARCHAR2(60):= fnd_api.g_miss_char,

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,

Line 173: ib_install_loc_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,
177: reservable_type number := fnd_api.g_miss_num,

Line 174: ib_current_loc 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,
178: negative_balances_code number := fnd_api.g_miss_num,

Line 175: ib_current_loc_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,
179: mtl_action_id number := fnd_api.g_miss_num,

Line 176: bom_item_type 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,

Line 177: reservable_type 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,

Line 178: negative_balances_code 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,

Line 179: mtl_action_id 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,

Line 180: mtl_src_type_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,

Line 181: config_header_id 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,
185: --4344316

Line 182: config_rev_nbr 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
186: model_remnant_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 183: configuration_id 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,
187: source_code VARCHAR2(30) := FND_API.G_MISS_CHAR -- Added for Siebel Genesis Project

Line 184: macd_order_line varchar2(1):= fnd_api.g_false,

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: );

Line 186: model_remnant_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

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: /*----------------------------------------------------------*/

Line 187: source_code VARCHAR2(30) := FND_API.G_MISS_CHAR -- Added for Siebel Genesis Project

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 */

Line 196: src_chg_owner_code VARCHAR2(1) := FND_API.G_MISS_CHAR,

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,

Line 197: nsrc_chg_owner_code 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,

Line 198: src_status_id NUMBER := FND_API.G_MISS_NUM ,

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 ,

Line 199: nsrc_status_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 ,

Line 200: src_change_owner VARCHAR2(1) := FND_API.G_MISS_CHAR,

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,

Line 201: nsrc_change_owner 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,

Line 202: trx_type_id NUMBER := FND_API.G_MISS_NUM ,

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,

Line 203: sub_type_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,
207: nsrc_return_reqd VARCHAR2(1) := FND_API.G_MISS_CHAR );

Line 204: src_reference_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:

Line 205: nsrc_reference_reqd 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:
209: /*----------------------------------------------------------*/

Line 206: src_return_reqd 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: /*----------------------------------------------------------*/
210: /* Procedure name: Order_shipment */

Line 207: nsrc_return_reqd VARCHAR2(1) := FND_API.G_MISS_CHAR );

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 */

Line 274: p_commit IN VARCHAR2 := fnd_api.g_false,

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,

Line 275: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

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,

Line 276: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

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,