APPS.AMS_ITEM_OWNER_PVT dependencies on FND_API

Line 46: ITEM_OWNER_ID NUMBER := FND_API.G_MISS_NUM,

42: -- End of Comments
43:
44: TYPE ITEM_OWNER_Rec_Type IS RECORD
45: (
46: ITEM_OWNER_ID NUMBER := FND_API.G_MISS_NUM,
47: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
48: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
49: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
50: ITEM_NUMBER VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 47: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,

43:
44: TYPE ITEM_OWNER_Rec_Type IS RECORD
45: (
46: ITEM_OWNER_ID NUMBER := FND_API.G_MISS_NUM,
47: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
48: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
49: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
50: ITEM_NUMBER VARCHAR2(240) := FND_API.G_MISS_CHAR,
51: OWNER_ID NUMBER := FND_API.G_MISS_NUM,

Line 48: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,

44: TYPE ITEM_OWNER_Rec_Type IS RECORD
45: (
46: ITEM_OWNER_ID NUMBER := FND_API.G_MISS_NUM,
47: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
48: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
49: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
50: ITEM_NUMBER VARCHAR2(240) := FND_API.G_MISS_CHAR,
51: OWNER_ID NUMBER := FND_API.G_MISS_NUM,
52: STATUS_CODE VARCHAR2(20) := FND_API.G_MISS_CHAR,

Line 49: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,

45: (
46: ITEM_OWNER_ID NUMBER := FND_API.G_MISS_NUM,
47: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
48: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
49: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
50: ITEM_NUMBER VARCHAR2(240) := FND_API.G_MISS_CHAR,
51: OWNER_ID NUMBER := FND_API.G_MISS_NUM,
52: STATUS_CODE VARCHAR2(20) := FND_API.G_MISS_CHAR,
53: EFFECTIVE_DATE DATE := FND_API.G_MISS_DATE,

Line 50: ITEM_NUMBER VARCHAR2(240) := FND_API.G_MISS_CHAR,

46: ITEM_OWNER_ID NUMBER := FND_API.G_MISS_NUM,
47: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
48: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
49: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
50: ITEM_NUMBER VARCHAR2(240) := FND_API.G_MISS_CHAR,
51: OWNER_ID NUMBER := FND_API.G_MISS_NUM,
52: STATUS_CODE VARCHAR2(20) := FND_API.G_MISS_CHAR,
53: EFFECTIVE_DATE DATE := FND_API.G_MISS_DATE,
54: IS_MASTER_ITEM VARCHAR2(20) := FND_API.G_MISS_CHAR,

Line 51: OWNER_ID NUMBER := FND_API.G_MISS_NUM,

47: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
48: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
49: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
50: ITEM_NUMBER VARCHAR2(240) := FND_API.G_MISS_CHAR,
51: OWNER_ID NUMBER := FND_API.G_MISS_NUM,
52: STATUS_CODE VARCHAR2(20) := FND_API.G_MISS_CHAR,
53: EFFECTIVE_DATE DATE := FND_API.G_MISS_DATE,
54: IS_MASTER_ITEM VARCHAR2(20) := FND_API.G_MISS_CHAR,
55: ITEM_SETUP_TYPE VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 52: STATUS_CODE VARCHAR2(20) := FND_API.G_MISS_CHAR,

48: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
49: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
50: ITEM_NUMBER VARCHAR2(240) := FND_API.G_MISS_CHAR,
51: OWNER_ID NUMBER := FND_API.G_MISS_NUM,
52: STATUS_CODE VARCHAR2(20) := FND_API.G_MISS_CHAR,
53: EFFECTIVE_DATE DATE := FND_API.G_MISS_DATE,
54: IS_MASTER_ITEM VARCHAR2(20) := FND_API.G_MISS_CHAR,
55: ITEM_SETUP_TYPE VARCHAR2(1) := FND_API.G_MISS_CHAR,
56: CUSTOM_SETUP_ID NUMBER := FND_API.G_MISS_NUM

Line 53: EFFECTIVE_DATE DATE := FND_API.G_MISS_DATE,

49: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
50: ITEM_NUMBER VARCHAR2(240) := FND_API.G_MISS_CHAR,
51: OWNER_ID NUMBER := FND_API.G_MISS_NUM,
52: STATUS_CODE VARCHAR2(20) := FND_API.G_MISS_CHAR,
53: EFFECTIVE_DATE DATE := FND_API.G_MISS_DATE,
54: IS_MASTER_ITEM VARCHAR2(20) := FND_API.G_MISS_CHAR,
55: ITEM_SETUP_TYPE VARCHAR2(1) := FND_API.G_MISS_CHAR,
56: CUSTOM_SETUP_ID NUMBER := FND_API.G_MISS_NUM
57: );

Line 54: IS_MASTER_ITEM VARCHAR2(20) := FND_API.G_MISS_CHAR,

50: ITEM_NUMBER VARCHAR2(240) := FND_API.G_MISS_CHAR,
51: OWNER_ID NUMBER := FND_API.G_MISS_NUM,
52: STATUS_CODE VARCHAR2(20) := FND_API.G_MISS_CHAR,
53: EFFECTIVE_DATE DATE := FND_API.G_MISS_DATE,
54: IS_MASTER_ITEM VARCHAR2(20) := FND_API.G_MISS_CHAR,
55: ITEM_SETUP_TYPE VARCHAR2(1) := FND_API.G_MISS_CHAR,
56: CUSTOM_SETUP_ID NUMBER := FND_API.G_MISS_NUM
57: );
58:

Line 55: ITEM_SETUP_TYPE VARCHAR2(1) := FND_API.G_MISS_CHAR,

51: OWNER_ID NUMBER := FND_API.G_MISS_NUM,
52: STATUS_CODE VARCHAR2(20) := FND_API.G_MISS_CHAR,
53: EFFECTIVE_DATE DATE := FND_API.G_MISS_DATE,
54: IS_MASTER_ITEM VARCHAR2(20) := FND_API.G_MISS_CHAR,
55: ITEM_SETUP_TYPE VARCHAR2(1) := FND_API.G_MISS_CHAR,
56: CUSTOM_SETUP_ID NUMBER := FND_API.G_MISS_NUM
57: );
58:
59: G_MISS_ITEM_OWNER_REC ITEM_OWNER_Rec_Type;

Line 56: CUSTOM_SETUP_ID NUMBER := FND_API.G_MISS_NUM

52: STATUS_CODE VARCHAR2(20) := FND_API.G_MISS_CHAR,
53: EFFECTIVE_DATE DATE := FND_API.G_MISS_DATE,
54: IS_MASTER_ITEM VARCHAR2(20) := FND_API.G_MISS_CHAR,
55: ITEM_SETUP_TYPE VARCHAR2(1) := FND_API.G_MISS_CHAR,
56: CUSTOM_SETUP_ID NUMBER := FND_API.G_MISS_NUM
57: );
58:
59: G_MISS_ITEM_OWNER_REC ITEM_OWNER_Rec_Type;
60: TYPE ITEM_OWNER_Tbl_Type IS TABLE OF ITEM_OWNER_Rec_Type

Line 82: inventory_item_id NUMBER := FND_API.G_MISS_NUM,

78:
79:
80: TYPE ITEM_rec_type is RECORD (
81:
82: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
83: organization_id NUMBER := FND_API.G_MISS_NUM,
84: item_number VARCHAR2(2000) := FND_API.g_MISS_CHAR,
85: description VARCHAR2(240):= FND_API.G_MISS_CHAR,
86: long_description VARCHAR2(4000):=FND_API.G_MISS_CHAR,

Line 83: organization_id NUMBER := FND_API.G_MISS_NUM,

79:
80: TYPE ITEM_rec_type is RECORD (
81:
82: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
83: organization_id NUMBER := FND_API.G_MISS_NUM,
84: item_number VARCHAR2(2000) := FND_API.g_MISS_CHAR,
85: description VARCHAR2(240):= FND_API.G_MISS_CHAR,
86: long_description VARCHAR2(4000):=FND_API.G_MISS_CHAR,
87:

Line 84: item_number VARCHAR2(2000) := FND_API.g_MISS_CHAR,

80: TYPE ITEM_rec_type is RECORD (
81:
82: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
83: organization_id NUMBER := FND_API.G_MISS_NUM,
84: item_number VARCHAR2(2000) := FND_API.g_MISS_CHAR,
85: description VARCHAR2(240):= FND_API.G_MISS_CHAR,
86: long_description VARCHAR2(4000):=FND_API.G_MISS_CHAR,
87:
88: item_type VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 85: description VARCHAR2(240):= FND_API.G_MISS_CHAR,

81:
82: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
83: organization_id NUMBER := FND_API.G_MISS_NUM,
84: item_number VARCHAR2(2000) := FND_API.g_MISS_CHAR,
85: description VARCHAR2(240):= FND_API.G_MISS_CHAR,
86: long_description VARCHAR2(4000):=FND_API.G_MISS_CHAR,
87:
88: item_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
89:

Line 86: long_description VARCHAR2(4000):=FND_API.G_MISS_CHAR,

82: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
83: organization_id NUMBER := FND_API.G_MISS_NUM,
84: item_number VARCHAR2(2000) := FND_API.g_MISS_CHAR,
85: description VARCHAR2(240):= FND_API.G_MISS_CHAR,
86: long_description VARCHAR2(4000):=FND_API.G_MISS_CHAR,
87:
88: item_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
89:
90: primary_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR,

Line 88: item_type VARCHAR2(30) := FND_API.G_MISS_CHAR,

84: item_number VARCHAR2(2000) := FND_API.g_MISS_CHAR,
85: description VARCHAR2(240):= FND_API.G_MISS_CHAR,
86: long_description VARCHAR2(4000):=FND_API.G_MISS_CHAR,
87:
88: item_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
89:
90: primary_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR,
91: primary_unit_of_measure VARCHAR2(25) := FND_API.G_MISS_CHAR,
92:

Line 90: primary_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR,

86: long_description VARCHAR2(4000):=FND_API.G_MISS_CHAR,
87:
88: item_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
89:
90: primary_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR,
91: primary_unit_of_measure VARCHAR2(25) := FND_API.G_MISS_CHAR,
92:
93: start_date_active DATE := FND_API.g_MISS_DATE,
94: end_date_active DATE := FND_API.g_MISS_DATE ,

Line 91: primary_unit_of_measure VARCHAR2(25) := FND_API.G_MISS_CHAR,

87:
88: item_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
89:
90: primary_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR,
91: primary_unit_of_measure VARCHAR2(25) := FND_API.G_MISS_CHAR,
92:
93: start_date_active DATE := FND_API.g_MISS_DATE,
94: end_date_active DATE := FND_API.g_MISS_DATE ,
95:

Line 93: start_date_active DATE := FND_API.g_MISS_DATE,

89:
90: primary_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR,
91: primary_unit_of_measure VARCHAR2(25) := FND_API.G_MISS_CHAR,
92:
93: start_date_active DATE := FND_API.g_MISS_DATE,
94: end_date_active DATE := FND_API.g_MISS_DATE ,
95:
96: inventory_item_status_codE VARCHAR2(10) := FND_API.g_MISS_CHAR,
97:

Line 94: end_date_active DATE := FND_API.g_MISS_DATE ,

90: primary_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR,
91: primary_unit_of_measure VARCHAR2(25) := FND_API.G_MISS_CHAR,
92:
93: start_date_active DATE := FND_API.g_MISS_DATE,
94: end_date_active DATE := FND_API.g_MISS_DATE ,
95:
96: inventory_item_status_codE VARCHAR2(10) := FND_API.g_MISS_CHAR,
97:
98: inventory_item_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 96: inventory_item_status_codE VARCHAR2(10) := FND_API.g_MISS_CHAR,

92:
93: start_date_active DATE := FND_API.g_MISS_DATE,
94: end_date_active DATE := FND_API.g_MISS_DATE ,
95:
96: inventory_item_status_codE VARCHAR2(10) := FND_API.g_MISS_CHAR,
97:
98: inventory_item_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
99: stock_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
100: mtl_transactions_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 98: inventory_item_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

94: end_date_active DATE := FND_API.g_MISS_DATE ,
95:
96: inventory_item_status_codE VARCHAR2(10) := FND_API.g_MISS_CHAR,
97:
98: inventory_item_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
99: stock_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
100: mtl_transactions_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
101: revision_qty_control_code NUMBER := FND_API.g_MISS_NUM,
102:

Line 99: stock_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

95:
96: inventory_item_status_codE VARCHAR2(10) := FND_API.g_MISS_CHAR,
97:
98: inventory_item_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
99: stock_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
100: mtl_transactions_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
101: revision_qty_control_code NUMBER := FND_API.g_MISS_NUM,
102:
103: bom_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 100: mtl_transactions_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

96: inventory_item_status_codE VARCHAR2(10) := FND_API.g_MISS_CHAR,
97:
98: inventory_item_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
99: stock_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
100: mtl_transactions_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
101: revision_qty_control_code NUMBER := FND_API.g_MISS_NUM,
102:
103: bom_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
104: bom_item_type NUMBER := FND_API.G_MISS_NUM,

Line 101: revision_qty_control_code NUMBER := FND_API.g_MISS_NUM,

97:
98: inventory_item_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
99: stock_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
100: mtl_transactions_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
101: revision_qty_control_code NUMBER := FND_API.g_MISS_NUM,
102:
103: bom_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
104: bom_item_type NUMBER := FND_API.G_MISS_NUM,
105:

Line 103: bom_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

99: stock_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
100: mtl_transactions_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
101: revision_qty_control_code NUMBER := FND_API.g_MISS_NUM,
102:
103: bom_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
104: bom_item_type NUMBER := FND_API.G_MISS_NUM,
105:
106: costing_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
107:

Line 104: bom_item_type NUMBER := FND_API.G_MISS_NUM,

100: mtl_transactions_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
101: revision_qty_control_code NUMBER := FND_API.g_MISS_NUM,
102:
103: bom_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
104: bom_item_type NUMBER := FND_API.G_MISS_NUM,
105:
106: costing_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
107:
108: electronic_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,

Line 106: costing_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

102:
103: bom_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
104: bom_item_type NUMBER := FND_API.G_MISS_NUM,
105:
106: costing_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
107:
108: electronic_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
109: downloadable_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
110:

Line 108: electronic_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,

104: bom_item_type NUMBER := FND_API.G_MISS_NUM,
105:
106: costing_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
107:
108: electronic_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
109: downloadable_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
110:
111: customer_order_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
112: customer_order_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 109: downloadable_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,

105:
106: costing_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
107:
108: electronic_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
109: downloadable_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
110:
111: customer_order_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
112: customer_order_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
113:

Line 111: customer_order_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

107:
108: electronic_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
109: downloadable_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
110:
111: customer_order_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
112: customer_order_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
113:
114: internal_order_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
115: internal_order_enabled_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,

Line 112: customer_order_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

108: electronic_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
109: downloadable_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
110:
111: customer_order_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
112: customer_order_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
113:
114: internal_order_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
115: internal_order_enabled_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
116:

Line 114: internal_order_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,

110:
111: customer_order_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
112: customer_order_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
113:
114: internal_order_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
115: internal_order_enabled_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
116:
117: shippable_item_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
118: returnable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 115: internal_order_enabled_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,

111: customer_order_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
112: customer_order_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
113:
114: internal_order_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
115: internal_order_enabled_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
116:
117: shippable_item_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
118: returnable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
119: comms_activation_reqd_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,

Line 117: shippable_item_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

113:
114: internal_order_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
115: internal_order_enabled_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
116:
117: shippable_item_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
118: returnable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
119: comms_activation_reqd_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
120: replenish_to_order_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
121: invoiceable_item_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 118: returnable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

114: internal_order_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
115: internal_order_enabled_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
116:
117: shippable_item_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
118: returnable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
119: comms_activation_reqd_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
120: replenish_to_order_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
121: invoiceable_item_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
122: invoice_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 119: comms_activation_reqd_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,

115: internal_order_enabled_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
116:
117: shippable_item_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
118: returnable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
119: comms_activation_reqd_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
120: replenish_to_order_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
121: invoiceable_item_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
122: invoice_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
123:

Line 120: replenish_to_order_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,

116:
117: shippable_item_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
118: returnable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
119: comms_activation_reqd_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
120: replenish_to_order_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
121: invoiceable_item_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
122: invoice_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
123:
124: service_item_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 121: invoiceable_item_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

117: shippable_item_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
118: returnable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
119: comms_activation_reqd_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
120: replenish_to_order_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
121: invoiceable_item_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
122: invoice_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
123:
124: service_item_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
125: serviceable_product_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 122: invoice_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

118: returnable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
119: comms_activation_reqd_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
120: replenish_to_order_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
121: invoiceable_item_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
122: invoice_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
123:
124: service_item_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
125: serviceable_product_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
126: vendor_warranty_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,

Line 124: service_item_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

120: replenish_to_order_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
121: invoiceable_item_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
122: invoice_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
123:
124: service_item_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
125: serviceable_product_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
126: vendor_warranty_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
127: coverage_schedule_id NUMBER := FND_API.g_MISS_NUM,
128: service_duration NUMBER := FND_API.g_MISS_NUM,

Line 125: serviceable_product_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

121: invoiceable_item_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
122: invoice_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
123:
124: service_item_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
125: serviceable_product_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
126: vendor_warranty_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
127: coverage_schedule_id NUMBER := FND_API.g_MISS_NUM,
128: service_duration NUMBER := FND_API.g_MISS_NUM,
129: service_duration_period_code VARCHAR2(10) := FND_API.g_MISS_CHAR,

Line 126: vendor_warranty_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,

122: invoice_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
123:
124: service_item_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
125: serviceable_product_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
126: vendor_warranty_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
127: coverage_schedule_id NUMBER := FND_API.g_MISS_NUM,
128: service_duration NUMBER := FND_API.g_MISS_NUM,
129: service_duration_period_code VARCHAR2(10) := FND_API.g_MISS_CHAR,
130: defect_tracking_on_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 127: coverage_schedule_id NUMBER := FND_API.g_MISS_NUM,

123:
124: service_item_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
125: serviceable_product_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
126: vendor_warranty_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
127: coverage_schedule_id NUMBER := FND_API.g_MISS_NUM,
128: service_duration NUMBER := FND_API.g_MISS_NUM,
129: service_duration_period_code VARCHAR2(10) := FND_API.g_MISS_CHAR,
130: defect_tracking_on_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
131:

Line 128: service_duration NUMBER := FND_API.g_MISS_NUM,

124: service_item_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
125: serviceable_product_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
126: vendor_warranty_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
127: coverage_schedule_id NUMBER := FND_API.g_MISS_NUM,
128: service_duration NUMBER := FND_API.g_MISS_NUM,
129: service_duration_period_code VARCHAR2(10) := FND_API.g_MISS_CHAR,
130: defect_tracking_on_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
131:
132: orderable_on_web_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 129: service_duration_period_code VARCHAR2(10) := FND_API.g_MISS_CHAR,

125: serviceable_product_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
126: vendor_warranty_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
127: coverage_schedule_id NUMBER := FND_API.g_MISS_NUM,
128: service_duration NUMBER := FND_API.g_MISS_NUM,
129: service_duration_period_code VARCHAR2(10) := FND_API.g_MISS_CHAR,
130: defect_tracking_on_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
131:
132: orderable_on_web_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
133: back_orderable_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,

Line 130: defect_tracking_on_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

126: vendor_warranty_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
127: coverage_schedule_id NUMBER := FND_API.g_MISS_NUM,
128: service_duration NUMBER := FND_API.g_MISS_NUM,
129: service_duration_period_code VARCHAR2(10) := FND_API.g_MISS_CHAR,
130: defect_tracking_on_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
131:
132: orderable_on_web_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
133: back_orderable_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
134: collateral_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,

Line 132: orderable_on_web_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

128: service_duration NUMBER := FND_API.g_MISS_NUM,
129: service_duration_period_code VARCHAR2(10) := FND_API.g_MISS_CHAR,
130: defect_tracking_on_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
131:
132: orderable_on_web_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
133: back_orderable_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
134: collateral_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
135: weight_uom_code VARCHAR2(3) := FND_API.g_MISS_CHAR,
136: unit_weight NUMBER := FND_API.g_MISS_NUM,

Line 133: back_orderable_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,

129: service_duration_period_code VARCHAR2(10) := FND_API.g_MISS_CHAR,
130: defect_tracking_on_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
131:
132: orderable_on_web_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
133: back_orderable_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
134: collateral_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
135: weight_uom_code VARCHAR2(3) := FND_API.g_MISS_CHAR,
136: unit_weight NUMBER := FND_API.g_MISS_NUM,
137: event_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,

Line 134: collateral_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,

130: defect_tracking_on_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
131:
132: orderable_on_web_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
133: back_orderable_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
134: collateral_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
135: weight_uom_code VARCHAR2(3) := FND_API.g_MISS_CHAR,
136: unit_weight NUMBER := FND_API.g_MISS_NUM,
137: event_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
138: comms_nl_trackable_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,

Line 135: weight_uom_code VARCHAR2(3) := FND_API.g_MISS_CHAR,

131:
132: orderable_on_web_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
133: back_orderable_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
134: collateral_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
135: weight_uom_code VARCHAR2(3) := FND_API.g_MISS_CHAR,
136: unit_weight NUMBER := FND_API.g_MISS_NUM,
137: event_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
138: comms_nl_trackable_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
139:

Line 136: unit_weight NUMBER := FND_API.g_MISS_NUM,

132: orderable_on_web_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
133: back_orderable_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
134: collateral_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
135: weight_uom_code VARCHAR2(3) := FND_API.g_MISS_CHAR,
136: unit_weight NUMBER := FND_API.g_MISS_NUM,
137: event_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
138: comms_nl_trackable_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
139:
140: subscription_depend_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,

Line 137: event_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,

133: back_orderable_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
134: collateral_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
135: weight_uom_code VARCHAR2(3) := FND_API.g_MISS_CHAR,
136: unit_weight NUMBER := FND_API.g_MISS_NUM,
137: event_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
138: comms_nl_trackable_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
139:
140: subscription_depend_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
141: contract_item_type_code VARCHAR2(30) := FND_API.g_MISS_CHAR,

Line 138: comms_nl_trackable_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,

134: collateral_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
135: weight_uom_code VARCHAR2(3) := FND_API.g_MISS_CHAR,
136: unit_weight NUMBER := FND_API.g_MISS_NUM,
137: event_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
138: comms_nl_trackable_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
139:
140: subscription_depend_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
141: contract_item_type_code VARCHAR2(30) := FND_API.g_MISS_CHAR,
142: web_status VARCHAR2(30) := FND_API.g_MISS_CHAR,

Line 140: subscription_depend_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,

136: unit_weight NUMBER := FND_API.g_MISS_NUM,
137: event_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
138: comms_nl_trackable_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
139:
140: subscription_depend_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
141: contract_item_type_code VARCHAR2(30) := FND_API.g_MISS_CHAR,
142: web_status VARCHAR2(30) := FND_API.g_MISS_CHAR,
143: indivisible_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
144: material_billable_flag VARCHAR2(30) := FND_API.g_MISS_CHAR,

Line 141: contract_item_type_code VARCHAR2(30) := FND_API.g_MISS_CHAR,

137: event_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
138: comms_nl_trackable_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
139:
140: subscription_depend_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
141: contract_item_type_code VARCHAR2(30) := FND_API.g_MISS_CHAR,
142: web_status VARCHAR2(30) := FND_API.g_MISS_CHAR,
143: indivisible_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
144: material_billable_flag VARCHAR2(30) := FND_API.g_MISS_CHAR,
145: pick_components_flag VARCHAR2(1) := FND_API.g_MISS_CHAR

Line 142: web_status VARCHAR2(30) := FND_API.g_MISS_CHAR,

138: comms_nl_trackable_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
139:
140: subscription_depend_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
141: contract_item_type_code VARCHAR2(30) := FND_API.g_MISS_CHAR,
142: web_status VARCHAR2(30) := FND_API.g_MISS_CHAR,
143: indivisible_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
144: material_billable_flag VARCHAR2(30) := FND_API.g_MISS_CHAR,
145: pick_components_flag VARCHAR2(1) := FND_API.g_MISS_CHAR
146: ,so_transactions_flag VARCHAR2(1) := FND_API.g_MISS_CHAR

Line 143: indivisible_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,

139:
140: subscription_depend_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
141: contract_item_type_code VARCHAR2(30) := FND_API.g_MISS_CHAR,
142: web_status VARCHAR2(30) := FND_API.g_MISS_CHAR,
143: indivisible_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
144: material_billable_flag VARCHAR2(30) := FND_API.g_MISS_CHAR,
145: pick_components_flag VARCHAR2(1) := FND_API.g_MISS_CHAR
146: ,so_transactions_flag VARCHAR2(1) := FND_API.g_MISS_CHAR
147:

Line 144: material_billable_flag VARCHAR2(30) := FND_API.g_MISS_CHAR,

140: subscription_depend_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
141: contract_item_type_code VARCHAR2(30) := FND_API.g_MISS_CHAR,
142: web_status VARCHAR2(30) := FND_API.g_MISS_CHAR,
143: indivisible_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
144: material_billable_flag VARCHAR2(30) := FND_API.g_MISS_CHAR,
145: pick_components_flag VARCHAR2(1) := FND_API.g_MISS_CHAR
146: ,so_transactions_flag VARCHAR2(1) := FND_API.g_MISS_CHAR
147:
148: ,attribute_category VARCHAR2(30) := FND_API.g_MISS_CHAR

Line 145: pick_components_flag VARCHAR2(1) := FND_API.g_MISS_CHAR

141: contract_item_type_code VARCHAR2(30) := FND_API.g_MISS_CHAR,
142: web_status VARCHAR2(30) := FND_API.g_MISS_CHAR,
143: indivisible_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
144: material_billable_flag VARCHAR2(30) := FND_API.g_MISS_CHAR,
145: pick_components_flag VARCHAR2(1) := FND_API.g_MISS_CHAR
146: ,so_transactions_flag VARCHAR2(1) := FND_API.g_MISS_CHAR
147:
148: ,attribute_category VARCHAR2(30) := FND_API.g_MISS_CHAR
149: ,attribute1 VARCHAR2(150) := FND_API.g_MISS_CHAR

Line 146: ,so_transactions_flag VARCHAR2(1) := FND_API.g_MISS_CHAR

142: web_status VARCHAR2(30) := FND_API.g_MISS_CHAR,
143: indivisible_flag VARCHAR2(1) := FND_API.g_MISS_CHAR,
144: material_billable_flag VARCHAR2(30) := FND_API.g_MISS_CHAR,
145: pick_components_flag VARCHAR2(1) := FND_API.g_MISS_CHAR
146: ,so_transactions_flag VARCHAR2(1) := FND_API.g_MISS_CHAR
147:
148: ,attribute_category VARCHAR2(30) := FND_API.g_MISS_CHAR
149: ,attribute1 VARCHAR2(150) := FND_API.g_MISS_CHAR
150: ,attribute2 VARCHAR2(150) := FND_API.g_MISS_CHAR

Line 148: ,attribute_category VARCHAR2(30) := FND_API.g_MISS_CHAR

144: material_billable_flag VARCHAR2(30) := FND_API.g_MISS_CHAR,
145: pick_components_flag VARCHAR2(1) := FND_API.g_MISS_CHAR
146: ,so_transactions_flag VARCHAR2(1) := FND_API.g_MISS_CHAR
147:
148: ,attribute_category VARCHAR2(30) := FND_API.g_MISS_CHAR
149: ,attribute1 VARCHAR2(150) := FND_API.g_MISS_CHAR
150: ,attribute2 VARCHAR2(150) := FND_API.g_MISS_CHAR
151: ,attribute3 VARCHAR2(150) := FND_API.g_MISS_CHAR
152: ,attribute4 VARCHAR2(150) := FND_API.g_MISS_CHAR

Line 149: ,attribute1 VARCHAR2(150) := FND_API.g_MISS_CHAR

145: pick_components_flag VARCHAR2(1) := FND_API.g_MISS_CHAR
146: ,so_transactions_flag VARCHAR2(1) := FND_API.g_MISS_CHAR
147:
148: ,attribute_category VARCHAR2(30) := FND_API.g_MISS_CHAR
149: ,attribute1 VARCHAR2(150) := FND_API.g_MISS_CHAR
150: ,attribute2 VARCHAR2(150) := FND_API.g_MISS_CHAR
151: ,attribute3 VARCHAR2(150) := FND_API.g_MISS_CHAR
152: ,attribute4 VARCHAR2(150) := FND_API.g_MISS_CHAR
153: ,attribute5 VARCHAR2(150) := FND_API.g_MISS_CHAR

Line 150: ,attribute2 VARCHAR2(150) := FND_API.g_MISS_CHAR

146: ,so_transactions_flag VARCHAR2(1) := FND_API.g_MISS_CHAR
147:
148: ,attribute_category VARCHAR2(30) := FND_API.g_MISS_CHAR
149: ,attribute1 VARCHAR2(150) := FND_API.g_MISS_CHAR
150: ,attribute2 VARCHAR2(150) := FND_API.g_MISS_CHAR
151: ,attribute3 VARCHAR2(150) := FND_API.g_MISS_CHAR
152: ,attribute4 VARCHAR2(150) := FND_API.g_MISS_CHAR
153: ,attribute5 VARCHAR2(150) := FND_API.g_MISS_CHAR
154: ,attribute6 VARCHAR2(150) := FND_API.g_MISS_CHAR

Line 151: ,attribute3 VARCHAR2(150) := FND_API.g_MISS_CHAR

147:
148: ,attribute_category VARCHAR2(30) := FND_API.g_MISS_CHAR
149: ,attribute1 VARCHAR2(150) := FND_API.g_MISS_CHAR
150: ,attribute2 VARCHAR2(150) := FND_API.g_MISS_CHAR
151: ,attribute3 VARCHAR2(150) := FND_API.g_MISS_CHAR
152: ,attribute4 VARCHAR2(150) := FND_API.g_MISS_CHAR
153: ,attribute5 VARCHAR2(150) := FND_API.g_MISS_CHAR
154: ,attribute6 VARCHAR2(150) := FND_API.g_MISS_CHAR
155: ,attribute7 VARCHAR2(150) := FND_API.g_MISS_CHAR

Line 152: ,attribute4 VARCHAR2(150) := FND_API.g_MISS_CHAR

148: ,attribute_category VARCHAR2(30) := FND_API.g_MISS_CHAR
149: ,attribute1 VARCHAR2(150) := FND_API.g_MISS_CHAR
150: ,attribute2 VARCHAR2(150) := FND_API.g_MISS_CHAR
151: ,attribute3 VARCHAR2(150) := FND_API.g_MISS_CHAR
152: ,attribute4 VARCHAR2(150) := FND_API.g_MISS_CHAR
153: ,attribute5 VARCHAR2(150) := FND_API.g_MISS_CHAR
154: ,attribute6 VARCHAR2(150) := FND_API.g_MISS_CHAR
155: ,attribute7 VARCHAR2(150) := FND_API.g_MISS_CHAR
156: ,attribute8 VARCHAR2(150) := FND_API.g_MISS_CHAR

Line 153: ,attribute5 VARCHAR2(150) := FND_API.g_MISS_CHAR

149: ,attribute1 VARCHAR2(150) := FND_API.g_MISS_CHAR
150: ,attribute2 VARCHAR2(150) := FND_API.g_MISS_CHAR
151: ,attribute3 VARCHAR2(150) := FND_API.g_MISS_CHAR
152: ,attribute4 VARCHAR2(150) := FND_API.g_MISS_CHAR
153: ,attribute5 VARCHAR2(150) := FND_API.g_MISS_CHAR
154: ,attribute6 VARCHAR2(150) := FND_API.g_MISS_CHAR
155: ,attribute7 VARCHAR2(150) := FND_API.g_MISS_CHAR
156: ,attribute8 VARCHAR2(150) := FND_API.g_MISS_CHAR
157: ,attribute9 VARCHAR2(150) := FND_API.g_MISS_CHAR

Line 154: ,attribute6 VARCHAR2(150) := FND_API.g_MISS_CHAR

150: ,attribute2 VARCHAR2(150) := FND_API.g_MISS_CHAR
151: ,attribute3 VARCHAR2(150) := FND_API.g_MISS_CHAR
152: ,attribute4 VARCHAR2(150) := FND_API.g_MISS_CHAR
153: ,attribute5 VARCHAR2(150) := FND_API.g_MISS_CHAR
154: ,attribute6 VARCHAR2(150) := FND_API.g_MISS_CHAR
155: ,attribute7 VARCHAR2(150) := FND_API.g_MISS_CHAR
156: ,attribute8 VARCHAR2(150) := FND_API.g_MISS_CHAR
157: ,attribute9 VARCHAR2(150) := FND_API.g_MISS_CHAR
158: ,attribute10 VARCHAR2(150) := FND_API.g_MISS_CHAR

Line 155: ,attribute7 VARCHAR2(150) := FND_API.g_MISS_CHAR

151: ,attribute3 VARCHAR2(150) := FND_API.g_MISS_CHAR
152: ,attribute4 VARCHAR2(150) := FND_API.g_MISS_CHAR
153: ,attribute5 VARCHAR2(150) := FND_API.g_MISS_CHAR
154: ,attribute6 VARCHAR2(150) := FND_API.g_MISS_CHAR
155: ,attribute7 VARCHAR2(150) := FND_API.g_MISS_CHAR
156: ,attribute8 VARCHAR2(150) := FND_API.g_MISS_CHAR
157: ,attribute9 VARCHAR2(150) := FND_API.g_MISS_CHAR
158: ,attribute10 VARCHAR2(150) := FND_API.g_MISS_CHAR
159: ,attribute11 VARCHAR2(150) := FND_API.g_MISS_CHAR

Line 156: ,attribute8 VARCHAR2(150) := FND_API.g_MISS_CHAR

152: ,attribute4 VARCHAR2(150) := FND_API.g_MISS_CHAR
153: ,attribute5 VARCHAR2(150) := FND_API.g_MISS_CHAR
154: ,attribute6 VARCHAR2(150) := FND_API.g_MISS_CHAR
155: ,attribute7 VARCHAR2(150) := FND_API.g_MISS_CHAR
156: ,attribute8 VARCHAR2(150) := FND_API.g_MISS_CHAR
157: ,attribute9 VARCHAR2(150) := FND_API.g_MISS_CHAR
158: ,attribute10 VARCHAR2(150) := FND_API.g_MISS_CHAR
159: ,attribute11 VARCHAR2(150) := FND_API.g_MISS_CHAR
160: ,attribute12 VARCHAR2(150) := FND_API.g_MISS_CHAR

Line 157: ,attribute9 VARCHAR2(150) := FND_API.g_MISS_CHAR

153: ,attribute5 VARCHAR2(150) := FND_API.g_MISS_CHAR
154: ,attribute6 VARCHAR2(150) := FND_API.g_MISS_CHAR
155: ,attribute7 VARCHAR2(150) := FND_API.g_MISS_CHAR
156: ,attribute8 VARCHAR2(150) := FND_API.g_MISS_CHAR
157: ,attribute9 VARCHAR2(150) := FND_API.g_MISS_CHAR
158: ,attribute10 VARCHAR2(150) := FND_API.g_MISS_CHAR
159: ,attribute11 VARCHAR2(150) := FND_API.g_MISS_CHAR
160: ,attribute12 VARCHAR2(150) := FND_API.g_MISS_CHAR
161: ,attribute13 VARCHAR2(150) := FND_API.g_MISS_CHAR

Line 158: ,attribute10 VARCHAR2(150) := FND_API.g_MISS_CHAR

154: ,attribute6 VARCHAR2(150) := FND_API.g_MISS_CHAR
155: ,attribute7 VARCHAR2(150) := FND_API.g_MISS_CHAR
156: ,attribute8 VARCHAR2(150) := FND_API.g_MISS_CHAR
157: ,attribute9 VARCHAR2(150) := FND_API.g_MISS_CHAR
158: ,attribute10 VARCHAR2(150) := FND_API.g_MISS_CHAR
159: ,attribute11 VARCHAR2(150) := FND_API.g_MISS_CHAR
160: ,attribute12 VARCHAR2(150) := FND_API.g_MISS_CHAR
161: ,attribute13 VARCHAR2(150) := FND_API.g_MISS_CHAR
162: ,attribute14 VARCHAR2(150) := FND_API.g_MISS_CHAR

Line 159: ,attribute11 VARCHAR2(150) := FND_API.g_MISS_CHAR

155: ,attribute7 VARCHAR2(150) := FND_API.g_MISS_CHAR
156: ,attribute8 VARCHAR2(150) := FND_API.g_MISS_CHAR
157: ,attribute9 VARCHAR2(150) := FND_API.g_MISS_CHAR
158: ,attribute10 VARCHAR2(150) := FND_API.g_MISS_CHAR
159: ,attribute11 VARCHAR2(150) := FND_API.g_MISS_CHAR
160: ,attribute12 VARCHAR2(150) := FND_API.g_MISS_CHAR
161: ,attribute13 VARCHAR2(150) := FND_API.g_MISS_CHAR
162: ,attribute14 VARCHAR2(150) := FND_API.g_MISS_CHAR
163: ,attribute15 VARCHAR2(150) := FND_API.g_MISS_CHAR

Line 160: ,attribute12 VARCHAR2(150) := FND_API.g_MISS_CHAR

156: ,attribute8 VARCHAR2(150) := FND_API.g_MISS_CHAR
157: ,attribute9 VARCHAR2(150) := FND_API.g_MISS_CHAR
158: ,attribute10 VARCHAR2(150) := FND_API.g_MISS_CHAR
159: ,attribute11 VARCHAR2(150) := FND_API.g_MISS_CHAR
160: ,attribute12 VARCHAR2(150) := FND_API.g_MISS_CHAR
161: ,attribute13 VARCHAR2(150) := FND_API.g_MISS_CHAR
162: ,attribute14 VARCHAR2(150) := FND_API.g_MISS_CHAR
163: ,attribute15 VARCHAR2(150) := FND_API.g_MISS_CHAR
164:

Line 161: ,attribute13 VARCHAR2(150) := FND_API.g_MISS_CHAR

157: ,attribute9 VARCHAR2(150) := FND_API.g_MISS_CHAR
158: ,attribute10 VARCHAR2(150) := FND_API.g_MISS_CHAR
159: ,attribute11 VARCHAR2(150) := FND_API.g_MISS_CHAR
160: ,attribute12 VARCHAR2(150) := FND_API.g_MISS_CHAR
161: ,attribute13 VARCHAR2(150) := FND_API.g_MISS_CHAR
162: ,attribute14 VARCHAR2(150) := FND_API.g_MISS_CHAR
163: ,attribute15 VARCHAR2(150) := FND_API.g_MISS_CHAR
164:
165:

Line 162: ,attribute14 VARCHAR2(150) := FND_API.g_MISS_CHAR

158: ,attribute10 VARCHAR2(150) := FND_API.g_MISS_CHAR
159: ,attribute11 VARCHAR2(150) := FND_API.g_MISS_CHAR
160: ,attribute12 VARCHAR2(150) := FND_API.g_MISS_CHAR
161: ,attribute13 VARCHAR2(150) := FND_API.g_MISS_CHAR
162: ,attribute14 VARCHAR2(150) := FND_API.g_MISS_CHAR
163: ,attribute15 VARCHAR2(150) := FND_API.g_MISS_CHAR
164:
165:
166: );

Line 163: ,attribute15 VARCHAR2(150) := FND_API.g_MISS_CHAR

159: ,attribute11 VARCHAR2(150) := FND_API.g_MISS_CHAR
160: ,attribute12 VARCHAR2(150) := FND_API.g_MISS_CHAR
161: ,attribute13 VARCHAR2(150) := FND_API.g_MISS_CHAR
162: ,attribute14 VARCHAR2(150) := FND_API.g_MISS_CHAR
163: ,attribute15 VARCHAR2(150) := FND_API.g_MISS_CHAR
164:
165:
166: );
167:

Line 215: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

211: -- Pre-Req :
212: -- Parameters:
213: -- IN
214: -- p_api_version_number IN NUMBER Required
215: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
216: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
217: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
218: -- P_ITEM_OWNER_Rec IN ITEM_OWNER_Rec_Type Required
219: --

Line 216: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

212: -- Parameters:
213: -- IN
214: -- p_api_version_number IN NUMBER Required
215: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
216: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
217: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
218: -- P_ITEM_OWNER_Rec IN ITEM_OWNER_Rec_Type Required
219: --
220: -- OUT:

Line 217: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

213: -- IN
214: -- p_api_version_number IN NUMBER Required
215: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
216: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
217: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
218: -- P_ITEM_OWNER_Rec IN ITEM_OWNER_Rec_Type Required
219: --
220: -- OUT:
221: -- x_return_status OUT VARCHAR2

Line 232: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

228: -- End of Comments
229: --
230: PROCEDURE Create_item_owner(
231: P_Api_Version_Number IN NUMBER,
232: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
233: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
234: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
235:
236: X_Return_Status OUT NOCOPY VARCHAR2,

Line 233: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

229: --
230: PROCEDURE Create_item_owner(
231: P_Api_Version_Number IN NUMBER,
232: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
233: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
234: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
235:
236: X_Return_Status OUT NOCOPY VARCHAR2,
237: X_Msg_Count OUT NOCOPY NUMBER,

Line 234: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

230: PROCEDURE Create_item_owner(
231: P_Api_Version_Number IN NUMBER,
232: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
233: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
234: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
235:
236: X_Return_Status OUT NOCOPY VARCHAR2,
237: X_Msg_Count OUT NOCOPY NUMBER,
238: X_Msg_Data OUT NOCOPY VARCHAR2,

Line 258: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

254: -- Pre-Req :
255: -- Parameters:
256: -- IN
257: -- p_api_version_number IN NUMBER Required
258: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
259: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
260: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
261: -- P_ITEM_OWNER_Rec IN ITEM_OWNER_Rec_Type Required
262: --

Line 259: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

255: -- Parameters:
256: -- IN
257: -- p_api_version_number IN NUMBER Required
258: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
259: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
260: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
261: -- P_ITEM_OWNER_Rec IN ITEM_OWNER_Rec_Type Required
262: --
263: -- OUT:

Line 260: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

256: -- IN
257: -- p_api_version_number IN NUMBER Required
258: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
259: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
260: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
261: -- P_ITEM_OWNER_Rec IN ITEM_OWNER_Rec_Type Required
262: --
263: -- OUT:
264: -- x_return_status OUT VARCHAR2

Line 275: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

271: -- End of Comments
272: --
273: PROCEDURE Update_item_owner(
274: P_Api_Version_Number IN NUMBER,
275: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
276: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
277: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
278:
279: X_Return_Status OUT NOCOPY VARCHAR2,

Line 276: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

272: --
273: PROCEDURE Update_item_owner(
274: P_Api_Version_Number IN NUMBER,
275: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
276: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
277: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
278:
279: X_Return_Status OUT NOCOPY VARCHAR2,
280: X_Msg_Count OUT NOCOPY NUMBER,

Line 277: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

273: PROCEDURE Update_item_owner(
274: P_Api_Version_Number IN NUMBER,
275: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
276: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
277: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
278:
279: X_Return_Status OUT NOCOPY VARCHAR2,
280: X_Msg_Count OUT NOCOPY NUMBER,
281: X_Msg_Data OUT NOCOPY VARCHAR2,

Line 301: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

297: -- Pre-Req :
298: -- Parameters:
299: -- IN
300: -- p_api_version_number IN NUMBER Required
301: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
302: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
303: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
304: -- p_ITEM_OWNER_ID IN NUMBER
305: -- p_object_version_number IN NUMBER Optional Default = NULL

Line 302: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

298: -- Parameters:
299: -- IN
300: -- p_api_version_number IN NUMBER Required
301: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
302: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
303: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
304: -- p_ITEM_OWNER_ID IN NUMBER
305: -- p_object_version_number IN NUMBER Optional Default = NULL
306: --

Line 303: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

299: -- IN
300: -- p_api_version_number IN NUMBER Required
301: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
302: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
303: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
304: -- p_ITEM_OWNER_ID IN NUMBER
305: -- p_object_version_number IN NUMBER Optional Default = NULL
306: --
307: -- OUT:

Line 319: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

315: -- End of Comments
316: --
317: PROCEDURE Delete_item_owner(
318: P_Api_Version_Number IN NUMBER,
319: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
320: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
321: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
322: X_Return_Status OUT NOCOPY VARCHAR2,
323: X_Msg_Count OUT NOCOPY NUMBER,

Line 320: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

316: --
317: PROCEDURE Delete_item_owner(
318: P_Api_Version_Number IN NUMBER,
319: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
320: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
321: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
322: X_Return_Status OUT NOCOPY VARCHAR2,
323: X_Msg_Count OUT NOCOPY NUMBER,
324: X_Msg_Data OUT NOCOPY VARCHAR2,

Line 321: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

317: PROCEDURE Delete_item_owner(
318: P_Api_Version_Number IN NUMBER,
319: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
320: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
321: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
322: X_Return_Status OUT NOCOPY VARCHAR2,
323: X_Msg_Count OUT NOCOPY NUMBER,
324: X_Msg_Data OUT NOCOPY VARCHAR2,
325: P_ITEM_OWNER_ID IN NUMBER,

Line 343: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

339: -- End of Comments
340:
341: /*PROCEDURE Validate_ITEM_OWNER_rec(
342: P_Api_Version_Number IN NUMBER,
343: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
344: X_Return_Status OUT NOCOPY VARCHAR2,
345: X_Msg_Count OUT NOCOPY NUMBER,
346: X_Msg_Data OUT NOCOPY VARCHAR2,
347: P_ITEM_OWNER_Rec IN ITEM_OWNER_Rec_Type

Line 363: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

359: -- End of Comments
360:
361: PROCEDURE Validate_item_owner(
362: P_Api_Version_Number IN NUMBER,
363: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
364: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
365: P_ITEM_OWNER_Rec IN ITEM_OWNER_Rec_Type,
366: P_ITEM_REC_In IN ITEM_rec_type := G_MISS_ITEM_REC,
367: X_Return_Status OUT NOCOPY VARCHAR2,

Line 364: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

360:
361: PROCEDURE Validate_item_owner(
362: P_Api_Version_Number IN NUMBER,
363: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
364: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
365: P_ITEM_OWNER_Rec IN ITEM_OWNER_Rec_Type,
366: P_ITEM_REC_In IN ITEM_rec_type := G_MISS_ITEM_REC,
367: X_Return_Status OUT NOCOPY VARCHAR2,
368: X_Msg_Count OUT NOCOPY NUMBER,