APPS.CSP_ITEM_SUB_INVENTORIES_PKG dependencies on FND_API

Line 100: decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID),

96: PROCESSING_LEAD_TIME,
97: POSTPROCESSING_LEAD_TIME
98: ) VALUES (
99: px_INVENTORY_ITEM_ID,
100: decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID),
101: decode( p_SECONDARY_INVENTORY, FND_API.G_MISS_CHAR, NULL, p_SECONDARY_INVENTORY),
102: decode( p_LAST_UPDATE_DATE, fnd_api.g_miss_date, to_date(null), p_last_update_date),
103: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
104: decode(p_CREATION_DATE, fnd_api.g_miss_date,to_date(null),p_creation_date),

Line 101: decode( p_SECONDARY_INVENTORY, FND_API.G_MISS_CHAR, NULL, p_SECONDARY_INVENTORY),

97: POSTPROCESSING_LEAD_TIME
98: ) VALUES (
99: px_INVENTORY_ITEM_ID,
100: decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID),
101: decode( p_SECONDARY_INVENTORY, FND_API.G_MISS_CHAR, NULL, p_SECONDARY_INVENTORY),
102: decode( p_LAST_UPDATE_DATE, fnd_api.g_miss_date, to_date(null), p_last_update_date),
103: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
104: decode(p_CREATION_DATE, fnd_api.g_miss_date,to_date(null),p_creation_date),
105: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),

Line 102: decode( p_LAST_UPDATE_DATE, fnd_api.g_miss_date, to_date(null), p_last_update_date),

98: ) VALUES (
99: px_INVENTORY_ITEM_ID,
100: decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID),
101: decode( p_SECONDARY_INVENTORY, FND_API.G_MISS_CHAR, NULL, p_SECONDARY_INVENTORY),
102: decode( p_LAST_UPDATE_DATE, fnd_api.g_miss_date, to_date(null), p_last_update_date),
103: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
104: decode(p_CREATION_DATE, fnd_api.g_miss_date,to_date(null),p_creation_date),
105: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
106: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),

Line 103: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),

99: px_INVENTORY_ITEM_ID,
100: decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID),
101: decode( p_SECONDARY_INVENTORY, FND_API.G_MISS_CHAR, NULL, p_SECONDARY_INVENTORY),
102: decode( p_LAST_UPDATE_DATE, fnd_api.g_miss_date, to_date(null), p_last_update_date),
103: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
104: decode(p_CREATION_DATE, fnd_api.g_miss_date,to_date(null),p_creation_date),
105: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
106: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
107: decode( p_PRIMARY_SUBINVENTORY_FLAG, FND_API.G_MISS_NUM, NULL, p_PRIMARY_SUBINVENTORY_FLAG),

Line 104: decode(p_CREATION_DATE, fnd_api.g_miss_date,to_date(null),p_creation_date),

100: decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID),
101: decode( p_SECONDARY_INVENTORY, FND_API.G_MISS_CHAR, NULL, p_SECONDARY_INVENTORY),
102: decode( p_LAST_UPDATE_DATE, fnd_api.g_miss_date, to_date(null), p_last_update_date),
103: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
104: decode(p_CREATION_DATE, fnd_api.g_miss_date,to_date(null),p_creation_date),
105: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
106: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
107: decode( p_PRIMARY_SUBINVENTORY_FLAG, FND_API.G_MISS_NUM, NULL, p_PRIMARY_SUBINVENTORY_FLAG),
108: decode( p_PICKING_ORDER, FND_API.G_MISS_NUM, NULL, p_PICKING_ORDER),

Line 105: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),

101: decode( p_SECONDARY_INVENTORY, FND_API.G_MISS_CHAR, NULL, p_SECONDARY_INVENTORY),
102: decode( p_LAST_UPDATE_DATE, fnd_api.g_miss_date, to_date(null), p_last_update_date),
103: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
104: decode(p_CREATION_DATE, fnd_api.g_miss_date,to_date(null),p_creation_date),
105: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
106: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
107: decode( p_PRIMARY_SUBINVENTORY_FLAG, FND_API.G_MISS_NUM, NULL, p_PRIMARY_SUBINVENTORY_FLAG),
108: decode( p_PICKING_ORDER, FND_API.G_MISS_NUM, NULL, p_PICKING_ORDER),
109: decode( p_MIN_MINMAX_QUANTITY, FND_API.G_MISS_NUM, NULL, p_MIN_MINMAX_QUANTITY),

Line 106: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),

102: decode( p_LAST_UPDATE_DATE, fnd_api.g_miss_date, to_date(null), p_last_update_date),
103: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
104: decode(p_CREATION_DATE, fnd_api.g_miss_date,to_date(null),p_creation_date),
105: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
106: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
107: decode( p_PRIMARY_SUBINVENTORY_FLAG, FND_API.G_MISS_NUM, NULL, p_PRIMARY_SUBINVENTORY_FLAG),
108: decode( p_PICKING_ORDER, FND_API.G_MISS_NUM, NULL, p_PICKING_ORDER),
109: decode( p_MIN_MINMAX_QUANTITY, FND_API.G_MISS_NUM, NULL, p_MIN_MINMAX_QUANTITY),
110: decode( p_MAX_MINMAX_QUANTITY, FND_API.G_MISS_NUM, NULL, p_MAX_MINMAX_QUANTITY),

Line 107: decode( p_PRIMARY_SUBINVENTORY_FLAG, FND_API.G_MISS_NUM, NULL, p_PRIMARY_SUBINVENTORY_FLAG),

103: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
104: decode(p_CREATION_DATE, fnd_api.g_miss_date,to_date(null),p_creation_date),
105: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
106: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
107: decode( p_PRIMARY_SUBINVENTORY_FLAG, FND_API.G_MISS_NUM, NULL, p_PRIMARY_SUBINVENTORY_FLAG),
108: decode( p_PICKING_ORDER, FND_API.G_MISS_NUM, NULL, p_PICKING_ORDER),
109: decode( p_MIN_MINMAX_QUANTITY, FND_API.G_MISS_NUM, NULL, p_MIN_MINMAX_QUANTITY),
110: decode( p_MAX_MINMAX_QUANTITY, FND_API.G_MISS_NUM, NULL, p_MAX_MINMAX_QUANTITY),
111: decode( p_INVENTORY_PLANNING_CODE, FND_API.G_MISS_NUM, NULL, p_INVENTORY_PLANNING_CODE),

Line 108: decode( p_PICKING_ORDER, FND_API.G_MISS_NUM, NULL, p_PICKING_ORDER),

104: decode(p_CREATION_DATE, fnd_api.g_miss_date,to_date(null),p_creation_date),
105: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
106: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
107: decode( p_PRIMARY_SUBINVENTORY_FLAG, FND_API.G_MISS_NUM, NULL, p_PRIMARY_SUBINVENTORY_FLAG),
108: decode( p_PICKING_ORDER, FND_API.G_MISS_NUM, NULL, p_PICKING_ORDER),
109: decode( p_MIN_MINMAX_QUANTITY, FND_API.G_MISS_NUM, NULL, p_MIN_MINMAX_QUANTITY),
110: decode( p_MAX_MINMAX_QUANTITY, FND_API.G_MISS_NUM, NULL, p_MAX_MINMAX_QUANTITY),
111: decode( p_INVENTORY_PLANNING_CODE, FND_API.G_MISS_NUM, NULL, p_INVENTORY_PLANNING_CODE),
112: decode( p_FIXED_LOT_MULTIPLE, FND_API.G_MISS_NUM, NULL, p_FIXED_LOT_MULTIPLE),

Line 109: decode( p_MIN_MINMAX_QUANTITY, FND_API.G_MISS_NUM, NULL, p_MIN_MINMAX_QUANTITY),

105: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
106: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
107: decode( p_PRIMARY_SUBINVENTORY_FLAG, FND_API.G_MISS_NUM, NULL, p_PRIMARY_SUBINVENTORY_FLAG),
108: decode( p_PICKING_ORDER, FND_API.G_MISS_NUM, NULL, p_PICKING_ORDER),
109: decode( p_MIN_MINMAX_QUANTITY, FND_API.G_MISS_NUM, NULL, p_MIN_MINMAX_QUANTITY),
110: decode( p_MAX_MINMAX_QUANTITY, FND_API.G_MISS_NUM, NULL, p_MAX_MINMAX_QUANTITY),
111: decode( p_INVENTORY_PLANNING_CODE, FND_API.G_MISS_NUM, NULL, p_INVENTORY_PLANNING_CODE),
112: decode( p_FIXED_LOT_MULTIPLE, FND_API.G_MISS_NUM, NULL, p_FIXED_LOT_MULTIPLE),
113: decode( p_MINIMUM_ORDER_QUANTITY, FND_API.G_MISS_NUM, NULL, p_MINIMUM_ORDER_QUANTITY),

Line 110: decode( p_MAX_MINMAX_QUANTITY, FND_API.G_MISS_NUM, NULL, p_MAX_MINMAX_QUANTITY),

106: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
107: decode( p_PRIMARY_SUBINVENTORY_FLAG, FND_API.G_MISS_NUM, NULL, p_PRIMARY_SUBINVENTORY_FLAG),
108: decode( p_PICKING_ORDER, FND_API.G_MISS_NUM, NULL, p_PICKING_ORDER),
109: decode( p_MIN_MINMAX_QUANTITY, FND_API.G_MISS_NUM, NULL, p_MIN_MINMAX_QUANTITY),
110: decode( p_MAX_MINMAX_QUANTITY, FND_API.G_MISS_NUM, NULL, p_MAX_MINMAX_QUANTITY),
111: decode( p_INVENTORY_PLANNING_CODE, FND_API.G_MISS_NUM, NULL, p_INVENTORY_PLANNING_CODE),
112: decode( p_FIXED_LOT_MULTIPLE, FND_API.G_MISS_NUM, NULL, p_FIXED_LOT_MULTIPLE),
113: decode( p_MINIMUM_ORDER_QUANTITY, FND_API.G_MISS_NUM, NULL, p_MINIMUM_ORDER_QUANTITY),
114: decode( p_MAXIMUM_ORDER_QUANTITY, FND_API.G_MISS_NUM, NULL, p_MAXIMUM_ORDER_QUANTITY),

Line 111: decode( p_INVENTORY_PLANNING_CODE, FND_API.G_MISS_NUM, NULL, p_INVENTORY_PLANNING_CODE),

107: decode( p_PRIMARY_SUBINVENTORY_FLAG, FND_API.G_MISS_NUM, NULL, p_PRIMARY_SUBINVENTORY_FLAG),
108: decode( p_PICKING_ORDER, FND_API.G_MISS_NUM, NULL, p_PICKING_ORDER),
109: decode( p_MIN_MINMAX_QUANTITY, FND_API.G_MISS_NUM, NULL, p_MIN_MINMAX_QUANTITY),
110: decode( p_MAX_MINMAX_QUANTITY, FND_API.G_MISS_NUM, NULL, p_MAX_MINMAX_QUANTITY),
111: decode( p_INVENTORY_PLANNING_CODE, FND_API.G_MISS_NUM, NULL, p_INVENTORY_PLANNING_CODE),
112: decode( p_FIXED_LOT_MULTIPLE, FND_API.G_MISS_NUM, NULL, p_FIXED_LOT_MULTIPLE),
113: decode( p_MINIMUM_ORDER_QUANTITY, FND_API.G_MISS_NUM, NULL, p_MINIMUM_ORDER_QUANTITY),
114: decode( p_MAXIMUM_ORDER_QUANTITY, FND_API.G_MISS_NUM, NULL, p_MAXIMUM_ORDER_QUANTITY),
115: decode( p_SOURCE_TYPE, FND_API.G_MISS_NUM, NULL, p_SOURCE_TYPE),

Line 112: decode( p_FIXED_LOT_MULTIPLE, FND_API.G_MISS_NUM, NULL, p_FIXED_LOT_MULTIPLE),

108: decode( p_PICKING_ORDER, FND_API.G_MISS_NUM, NULL, p_PICKING_ORDER),
109: decode( p_MIN_MINMAX_QUANTITY, FND_API.G_MISS_NUM, NULL, p_MIN_MINMAX_QUANTITY),
110: decode( p_MAX_MINMAX_QUANTITY, FND_API.G_MISS_NUM, NULL, p_MAX_MINMAX_QUANTITY),
111: decode( p_INVENTORY_PLANNING_CODE, FND_API.G_MISS_NUM, NULL, p_INVENTORY_PLANNING_CODE),
112: decode( p_FIXED_LOT_MULTIPLE, FND_API.G_MISS_NUM, NULL, p_FIXED_LOT_MULTIPLE),
113: decode( p_MINIMUM_ORDER_QUANTITY, FND_API.G_MISS_NUM, NULL, p_MINIMUM_ORDER_QUANTITY),
114: decode( p_MAXIMUM_ORDER_QUANTITY, FND_API.G_MISS_NUM, NULL, p_MAXIMUM_ORDER_QUANTITY),
115: decode( p_SOURCE_TYPE, FND_API.G_MISS_NUM, NULL, p_SOURCE_TYPE),
116: decode( p_SOURCE_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_ORGANIZATION_ID),

Line 113: decode( p_MINIMUM_ORDER_QUANTITY, FND_API.G_MISS_NUM, NULL, p_MINIMUM_ORDER_QUANTITY),

109: decode( p_MIN_MINMAX_QUANTITY, FND_API.G_MISS_NUM, NULL, p_MIN_MINMAX_QUANTITY),
110: decode( p_MAX_MINMAX_QUANTITY, FND_API.G_MISS_NUM, NULL, p_MAX_MINMAX_QUANTITY),
111: decode( p_INVENTORY_PLANNING_CODE, FND_API.G_MISS_NUM, NULL, p_INVENTORY_PLANNING_CODE),
112: decode( p_FIXED_LOT_MULTIPLE, FND_API.G_MISS_NUM, NULL, p_FIXED_LOT_MULTIPLE),
113: decode( p_MINIMUM_ORDER_QUANTITY, FND_API.G_MISS_NUM, NULL, p_MINIMUM_ORDER_QUANTITY),
114: decode( p_MAXIMUM_ORDER_QUANTITY, FND_API.G_MISS_NUM, NULL, p_MAXIMUM_ORDER_QUANTITY),
115: decode( p_SOURCE_TYPE, FND_API.G_MISS_NUM, NULL, p_SOURCE_TYPE),
116: decode( p_SOURCE_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_ORGANIZATION_ID),
117: decode( p_SOURCE_SUBINVENTORY, FND_API.G_MISS_CHAR, NULL, p_SOURCE_SUBINVENTORY),

Line 114: decode( p_MAXIMUM_ORDER_QUANTITY, FND_API.G_MISS_NUM, NULL, p_MAXIMUM_ORDER_QUANTITY),

110: decode( p_MAX_MINMAX_QUANTITY, FND_API.G_MISS_NUM, NULL, p_MAX_MINMAX_QUANTITY),
111: decode( p_INVENTORY_PLANNING_CODE, FND_API.G_MISS_NUM, NULL, p_INVENTORY_PLANNING_CODE),
112: decode( p_FIXED_LOT_MULTIPLE, FND_API.G_MISS_NUM, NULL, p_FIXED_LOT_MULTIPLE),
113: decode( p_MINIMUM_ORDER_QUANTITY, FND_API.G_MISS_NUM, NULL, p_MINIMUM_ORDER_QUANTITY),
114: decode( p_MAXIMUM_ORDER_QUANTITY, FND_API.G_MISS_NUM, NULL, p_MAXIMUM_ORDER_QUANTITY),
115: decode( p_SOURCE_TYPE, FND_API.G_MISS_NUM, NULL, p_SOURCE_TYPE),
116: decode( p_SOURCE_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_ORGANIZATION_ID),
117: decode( p_SOURCE_SUBINVENTORY, FND_API.G_MISS_CHAR, NULL, p_SOURCE_SUBINVENTORY),
118: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),

Line 115: decode( p_SOURCE_TYPE, FND_API.G_MISS_NUM, NULL, p_SOURCE_TYPE),

111: decode( p_INVENTORY_PLANNING_CODE, FND_API.G_MISS_NUM, NULL, p_INVENTORY_PLANNING_CODE),
112: decode( p_FIXED_LOT_MULTIPLE, FND_API.G_MISS_NUM, NULL, p_FIXED_LOT_MULTIPLE),
113: decode( p_MINIMUM_ORDER_QUANTITY, FND_API.G_MISS_NUM, NULL, p_MINIMUM_ORDER_QUANTITY),
114: decode( p_MAXIMUM_ORDER_QUANTITY, FND_API.G_MISS_NUM, NULL, p_MAXIMUM_ORDER_QUANTITY),
115: decode( p_SOURCE_TYPE, FND_API.G_MISS_NUM, NULL, p_SOURCE_TYPE),
116: decode( p_SOURCE_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_ORGANIZATION_ID),
117: decode( p_SOURCE_SUBINVENTORY, FND_API.G_MISS_CHAR, NULL, p_SOURCE_SUBINVENTORY),
118: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
119: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),

Line 116: decode( p_SOURCE_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_ORGANIZATION_ID),

112: decode( p_FIXED_LOT_MULTIPLE, FND_API.G_MISS_NUM, NULL, p_FIXED_LOT_MULTIPLE),
113: decode( p_MINIMUM_ORDER_QUANTITY, FND_API.G_MISS_NUM, NULL, p_MINIMUM_ORDER_QUANTITY),
114: decode( p_MAXIMUM_ORDER_QUANTITY, FND_API.G_MISS_NUM, NULL, p_MAXIMUM_ORDER_QUANTITY),
115: decode( p_SOURCE_TYPE, FND_API.G_MISS_NUM, NULL, p_SOURCE_TYPE),
116: decode( p_SOURCE_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_ORGANIZATION_ID),
117: decode( p_SOURCE_SUBINVENTORY, FND_API.G_MISS_CHAR, NULL, p_SOURCE_SUBINVENTORY),
118: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
119: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
120: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),

Line 117: decode( p_SOURCE_SUBINVENTORY, FND_API.G_MISS_CHAR, NULL, p_SOURCE_SUBINVENTORY),

113: decode( p_MINIMUM_ORDER_QUANTITY, FND_API.G_MISS_NUM, NULL, p_MINIMUM_ORDER_QUANTITY),
114: decode( p_MAXIMUM_ORDER_QUANTITY, FND_API.G_MISS_NUM, NULL, p_MAXIMUM_ORDER_QUANTITY),
115: decode( p_SOURCE_TYPE, FND_API.G_MISS_NUM, NULL, p_SOURCE_TYPE),
116: decode( p_SOURCE_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_ORGANIZATION_ID),
117: decode( p_SOURCE_SUBINVENTORY, FND_API.G_MISS_CHAR, NULL, p_SOURCE_SUBINVENTORY),
118: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
119: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
120: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
121: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),

Line 118: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),

114: decode( p_MAXIMUM_ORDER_QUANTITY, FND_API.G_MISS_NUM, NULL, p_MAXIMUM_ORDER_QUANTITY),
115: decode( p_SOURCE_TYPE, FND_API.G_MISS_NUM, NULL, p_SOURCE_TYPE),
116: decode( p_SOURCE_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_ORGANIZATION_ID),
117: decode( p_SOURCE_SUBINVENTORY, FND_API.G_MISS_CHAR, NULL, p_SOURCE_SUBINVENTORY),
118: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
119: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
120: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
121: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
122: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),

Line 119: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),

115: decode( p_SOURCE_TYPE, FND_API.G_MISS_NUM, NULL, p_SOURCE_TYPE),
116: decode( p_SOURCE_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_ORGANIZATION_ID),
117: decode( p_SOURCE_SUBINVENTORY, FND_API.G_MISS_CHAR, NULL, p_SOURCE_SUBINVENTORY),
118: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
119: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
120: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
121: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
122: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
123: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),

Line 120: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),

116: decode( p_SOURCE_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_ORGANIZATION_ID),
117: decode( p_SOURCE_SUBINVENTORY, FND_API.G_MISS_CHAR, NULL, p_SOURCE_SUBINVENTORY),
118: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
119: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
120: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
121: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
122: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
123: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
124: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),

Line 121: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),

117: decode( p_SOURCE_SUBINVENTORY, FND_API.G_MISS_CHAR, NULL, p_SOURCE_SUBINVENTORY),
118: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
119: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
120: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
121: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
122: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
123: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
124: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
125: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),

Line 122: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),

118: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
119: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
120: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
121: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
122: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
123: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
124: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
125: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
126: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),

Line 123: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),

119: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
120: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
121: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
122: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
123: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
124: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
125: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
126: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
127: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),

Line 124: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),

120: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
121: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
122: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
123: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
124: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
125: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
126: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
127: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
128: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),

Line 125: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),

121: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
122: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
123: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
124: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
125: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
126: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
127: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
128: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
129: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),

Line 126: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),

122: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
123: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
124: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
125: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
126: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
127: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
128: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
129: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
130: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),

Line 127: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),

123: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
124: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
125: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
126: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
127: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
128: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
129: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
130: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
131: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),

Line 128: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),

124: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
125: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
126: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
127: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
128: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
129: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
130: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
131: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
132: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),

Line 129: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),

125: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
126: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
127: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
128: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
129: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
130: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
131: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
132: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
133: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),

Line 130: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),

126: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
127: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
128: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
129: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
130: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
131: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
132: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
133: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
134: decode( p_ENCUMBRANCE_ACCOUNT, FND_API.G_MISS_NUM, NULL, p_ENCUMBRANCE_ACCOUNT),

Line 131: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),

127: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
128: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
129: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
130: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
131: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
132: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
133: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
134: decode( p_ENCUMBRANCE_ACCOUNT, FND_API.G_MISS_NUM, NULL, p_ENCUMBRANCE_ACCOUNT),
135: decode( p_PREPROCESSING_LEAD_TIME, FND_API.G_MISS_NUM, NULL, p_PREPROCESSING_LEAD_TIME),

Line 132: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),

128: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
129: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
130: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
131: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
132: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
133: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
134: decode( p_ENCUMBRANCE_ACCOUNT, FND_API.G_MISS_NUM, NULL, p_ENCUMBRANCE_ACCOUNT),
135: decode( p_PREPROCESSING_LEAD_TIME, FND_API.G_MISS_NUM, NULL, p_PREPROCESSING_LEAD_TIME),
136: decode( p_PROCESSING_LEAD_TIME, FND_API.G_MISS_NUM, NULL, p_PROCESSING_LEAD_TIME),

Line 133: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),

129: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
130: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
131: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
132: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
133: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
134: decode( p_ENCUMBRANCE_ACCOUNT, FND_API.G_MISS_NUM, NULL, p_ENCUMBRANCE_ACCOUNT),
135: decode( p_PREPROCESSING_LEAD_TIME, FND_API.G_MISS_NUM, NULL, p_PREPROCESSING_LEAD_TIME),
136: decode( p_PROCESSING_LEAD_TIME, FND_API.G_MISS_NUM, NULL, p_PROCESSING_LEAD_TIME),
137: decode( p_POSTPROCESSING_LEAD_TIME, FND_API.G_MISS_NUM, NULL, p_POSTPROCESSING_LEAD_TIME));

Line 134: decode( p_ENCUMBRANCE_ACCOUNT, FND_API.G_MISS_NUM, NULL, p_ENCUMBRANCE_ACCOUNT),

130: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
131: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
132: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
133: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
134: decode( p_ENCUMBRANCE_ACCOUNT, FND_API.G_MISS_NUM, NULL, p_ENCUMBRANCE_ACCOUNT),
135: decode( p_PREPROCESSING_LEAD_TIME, FND_API.G_MISS_NUM, NULL, p_PREPROCESSING_LEAD_TIME),
136: decode( p_PROCESSING_LEAD_TIME, FND_API.G_MISS_NUM, NULL, p_PROCESSING_LEAD_TIME),
137: decode( p_POSTPROCESSING_LEAD_TIME, FND_API.G_MISS_NUM, NULL, p_POSTPROCESSING_LEAD_TIME));
138: End Insert_Row;

Line 135: decode( p_PREPROCESSING_LEAD_TIME, FND_API.G_MISS_NUM, NULL, p_PREPROCESSING_LEAD_TIME),

131: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
132: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
133: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
134: decode( p_ENCUMBRANCE_ACCOUNT, FND_API.G_MISS_NUM, NULL, p_ENCUMBRANCE_ACCOUNT),
135: decode( p_PREPROCESSING_LEAD_TIME, FND_API.G_MISS_NUM, NULL, p_PREPROCESSING_LEAD_TIME),
136: decode( p_PROCESSING_LEAD_TIME, FND_API.G_MISS_NUM, NULL, p_PROCESSING_LEAD_TIME),
137: decode( p_POSTPROCESSING_LEAD_TIME, FND_API.G_MISS_NUM, NULL, p_POSTPROCESSING_LEAD_TIME));
138: End Insert_Row;
139:

Line 136: decode( p_PROCESSING_LEAD_TIME, FND_API.G_MISS_NUM, NULL, p_PROCESSING_LEAD_TIME),

132: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
133: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
134: decode( p_ENCUMBRANCE_ACCOUNT, FND_API.G_MISS_NUM, NULL, p_ENCUMBRANCE_ACCOUNT),
135: decode( p_PREPROCESSING_LEAD_TIME, FND_API.G_MISS_NUM, NULL, p_PREPROCESSING_LEAD_TIME),
136: decode( p_PROCESSING_LEAD_TIME, FND_API.G_MISS_NUM, NULL, p_PROCESSING_LEAD_TIME),
137: decode( p_POSTPROCESSING_LEAD_TIME, FND_API.G_MISS_NUM, NULL, p_POSTPROCESSING_LEAD_TIME));
138: End Insert_Row;
139:
140: PROCEDURE Update_Row(

Line 137: decode( p_POSTPROCESSING_LEAD_TIME, FND_API.G_MISS_NUM, NULL, p_POSTPROCESSING_LEAD_TIME));

133: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
134: decode( p_ENCUMBRANCE_ACCOUNT, FND_API.G_MISS_NUM, NULL, p_ENCUMBRANCE_ACCOUNT),
135: decode( p_PREPROCESSING_LEAD_TIME, FND_API.G_MISS_NUM, NULL, p_PREPROCESSING_LEAD_TIME),
136: decode( p_PROCESSING_LEAD_TIME, FND_API.G_MISS_NUM, NULL, p_PROCESSING_LEAD_TIME),
137: decode( p_POSTPROCESSING_LEAD_TIME, FND_API.G_MISS_NUM, NULL, p_POSTPROCESSING_LEAD_TIME));
138: End Insert_Row;
139:
140: PROCEDURE Update_Row(
141: p_ROW_ID VARCHAR2,

Line 186: ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, p_ORGANIZATION_ID),

182: IS
183: BEGIN
184: Update MTL_ITEM_SUB_INVENTORIES
185: SET
186: ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, p_ORGANIZATION_ID),
187: SECONDARY_INVENTORY = decode( p_SECONDARY_INVENTORY, FND_API.G_MISS_CHAR, SECONDARY_INVENTORY, p_SECONDARY_INVENTORY),
188: LAST_UPDATE_DATE = decode(p_last_update_date,fnd_api.g_miss_date,last_update_date,p_last_update_date),
189: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
190: CREATION_DATE = decode(p_creation_date,fnd_api.g_miss_date,creation_date,p_creation_date),

Line 187: SECONDARY_INVENTORY = decode( p_SECONDARY_INVENTORY, FND_API.G_MISS_CHAR, SECONDARY_INVENTORY, p_SECONDARY_INVENTORY),

183: BEGIN
184: Update MTL_ITEM_SUB_INVENTORIES
185: SET
186: ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, p_ORGANIZATION_ID),
187: SECONDARY_INVENTORY = decode( p_SECONDARY_INVENTORY, FND_API.G_MISS_CHAR, SECONDARY_INVENTORY, p_SECONDARY_INVENTORY),
188: LAST_UPDATE_DATE = decode(p_last_update_date,fnd_api.g_miss_date,last_update_date,p_last_update_date),
189: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
190: CREATION_DATE = decode(p_creation_date,fnd_api.g_miss_date,creation_date,p_creation_date),
191: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),

Line 188: LAST_UPDATE_DATE = decode(p_last_update_date,fnd_api.g_miss_date,last_update_date,p_last_update_date),

184: Update MTL_ITEM_SUB_INVENTORIES
185: SET
186: ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, p_ORGANIZATION_ID),
187: SECONDARY_INVENTORY = decode( p_SECONDARY_INVENTORY, FND_API.G_MISS_CHAR, SECONDARY_INVENTORY, p_SECONDARY_INVENTORY),
188: LAST_UPDATE_DATE = decode(p_last_update_date,fnd_api.g_miss_date,last_update_date,p_last_update_date),
189: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
190: CREATION_DATE = decode(p_creation_date,fnd_api.g_miss_date,creation_date,p_creation_date),
191: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
192: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),

Line 189: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),

185: SET
186: ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, p_ORGANIZATION_ID),
187: SECONDARY_INVENTORY = decode( p_SECONDARY_INVENTORY, FND_API.G_MISS_CHAR, SECONDARY_INVENTORY, p_SECONDARY_INVENTORY),
188: LAST_UPDATE_DATE = decode(p_last_update_date,fnd_api.g_miss_date,last_update_date,p_last_update_date),
189: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
190: CREATION_DATE = decode(p_creation_date,fnd_api.g_miss_date,creation_date,p_creation_date),
191: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
192: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
193: PRIMARY_SUBINVENTORY_FLAG = decode( p_PRIMARY_SUBINVENTORY_FLAG, FND_API.G_MISS_NUM, PRIMARY_SUBINVENTORY_FLAG, p_PRIMARY_SUBINVENTORY_FLAG),

Line 190: CREATION_DATE = decode(p_creation_date,fnd_api.g_miss_date,creation_date,p_creation_date),

186: ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, p_ORGANIZATION_ID),
187: SECONDARY_INVENTORY = decode( p_SECONDARY_INVENTORY, FND_API.G_MISS_CHAR, SECONDARY_INVENTORY, p_SECONDARY_INVENTORY),
188: LAST_UPDATE_DATE = decode(p_last_update_date,fnd_api.g_miss_date,last_update_date,p_last_update_date),
189: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
190: CREATION_DATE = decode(p_creation_date,fnd_api.g_miss_date,creation_date,p_creation_date),
191: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
192: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
193: PRIMARY_SUBINVENTORY_FLAG = decode( p_PRIMARY_SUBINVENTORY_FLAG, FND_API.G_MISS_NUM, PRIMARY_SUBINVENTORY_FLAG, p_PRIMARY_SUBINVENTORY_FLAG),
194: PICKING_ORDER = decode( p_PICKING_ORDER, FND_API.G_MISS_NUM, PICKING_ORDER, p_PICKING_ORDER),

Line 191: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),

187: SECONDARY_INVENTORY = decode( p_SECONDARY_INVENTORY, FND_API.G_MISS_CHAR, SECONDARY_INVENTORY, p_SECONDARY_INVENTORY),
188: LAST_UPDATE_DATE = decode(p_last_update_date,fnd_api.g_miss_date,last_update_date,p_last_update_date),
189: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
190: CREATION_DATE = decode(p_creation_date,fnd_api.g_miss_date,creation_date,p_creation_date),
191: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
192: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
193: PRIMARY_SUBINVENTORY_FLAG = decode( p_PRIMARY_SUBINVENTORY_FLAG, FND_API.G_MISS_NUM, PRIMARY_SUBINVENTORY_FLAG, p_PRIMARY_SUBINVENTORY_FLAG),
194: PICKING_ORDER = decode( p_PICKING_ORDER, FND_API.G_MISS_NUM, PICKING_ORDER, p_PICKING_ORDER),
195: MIN_MINMAX_QUANTITY = decode( p_MIN_MINMAX_QUANTITY, FND_API.G_MISS_NUM, MIN_MINMAX_QUANTITY, p_MIN_MINMAX_QUANTITY),

Line 192: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),

188: LAST_UPDATE_DATE = decode(p_last_update_date,fnd_api.g_miss_date,last_update_date,p_last_update_date),
189: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
190: CREATION_DATE = decode(p_creation_date,fnd_api.g_miss_date,creation_date,p_creation_date),
191: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
192: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
193: PRIMARY_SUBINVENTORY_FLAG = decode( p_PRIMARY_SUBINVENTORY_FLAG, FND_API.G_MISS_NUM, PRIMARY_SUBINVENTORY_FLAG, p_PRIMARY_SUBINVENTORY_FLAG),
194: PICKING_ORDER = decode( p_PICKING_ORDER, FND_API.G_MISS_NUM, PICKING_ORDER, p_PICKING_ORDER),
195: MIN_MINMAX_QUANTITY = decode( p_MIN_MINMAX_QUANTITY, FND_API.G_MISS_NUM, MIN_MINMAX_QUANTITY, p_MIN_MINMAX_QUANTITY),
196: MAX_MINMAX_QUANTITY = decode( p_MAX_MINMAX_QUANTITY, FND_API.G_MISS_NUM, MAX_MINMAX_QUANTITY, p_MAX_MINMAX_QUANTITY),

Line 193: PRIMARY_SUBINVENTORY_FLAG = decode( p_PRIMARY_SUBINVENTORY_FLAG, FND_API.G_MISS_NUM, PRIMARY_SUBINVENTORY_FLAG, p_PRIMARY_SUBINVENTORY_FLAG),

189: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
190: CREATION_DATE = decode(p_creation_date,fnd_api.g_miss_date,creation_date,p_creation_date),
191: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
192: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
193: PRIMARY_SUBINVENTORY_FLAG = decode( p_PRIMARY_SUBINVENTORY_FLAG, FND_API.G_MISS_NUM, PRIMARY_SUBINVENTORY_FLAG, p_PRIMARY_SUBINVENTORY_FLAG),
194: PICKING_ORDER = decode( p_PICKING_ORDER, FND_API.G_MISS_NUM, PICKING_ORDER, p_PICKING_ORDER),
195: MIN_MINMAX_QUANTITY = decode( p_MIN_MINMAX_QUANTITY, FND_API.G_MISS_NUM, MIN_MINMAX_QUANTITY, p_MIN_MINMAX_QUANTITY),
196: MAX_MINMAX_QUANTITY = decode( p_MAX_MINMAX_QUANTITY, FND_API.G_MISS_NUM, MAX_MINMAX_QUANTITY, p_MAX_MINMAX_QUANTITY),
197: INVENTORY_PLANNING_CODE = decode( p_INVENTORY_PLANNING_CODE, FND_API.G_MISS_NUM, INVENTORY_PLANNING_CODE, p_INVENTORY_PLANNING_CODE),

Line 194: PICKING_ORDER = decode( p_PICKING_ORDER, FND_API.G_MISS_NUM, PICKING_ORDER, p_PICKING_ORDER),

190: CREATION_DATE = decode(p_creation_date,fnd_api.g_miss_date,creation_date,p_creation_date),
191: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
192: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
193: PRIMARY_SUBINVENTORY_FLAG = decode( p_PRIMARY_SUBINVENTORY_FLAG, FND_API.G_MISS_NUM, PRIMARY_SUBINVENTORY_FLAG, p_PRIMARY_SUBINVENTORY_FLAG),
194: PICKING_ORDER = decode( p_PICKING_ORDER, FND_API.G_MISS_NUM, PICKING_ORDER, p_PICKING_ORDER),
195: MIN_MINMAX_QUANTITY = decode( p_MIN_MINMAX_QUANTITY, FND_API.G_MISS_NUM, MIN_MINMAX_QUANTITY, p_MIN_MINMAX_QUANTITY),
196: MAX_MINMAX_QUANTITY = decode( p_MAX_MINMAX_QUANTITY, FND_API.G_MISS_NUM, MAX_MINMAX_QUANTITY, p_MAX_MINMAX_QUANTITY),
197: INVENTORY_PLANNING_CODE = decode( p_INVENTORY_PLANNING_CODE, FND_API.G_MISS_NUM, INVENTORY_PLANNING_CODE, p_INVENTORY_PLANNING_CODE),
198: FIXED_LOT_MULTIPLE = decode( p_FIXED_LOT_MULTIPLE, FND_API.G_MISS_NUM, FIXED_LOT_MULTIPLE, p_FIXED_LOT_MULTIPLE),

Line 195: MIN_MINMAX_QUANTITY = decode( p_MIN_MINMAX_QUANTITY, FND_API.G_MISS_NUM, MIN_MINMAX_QUANTITY, p_MIN_MINMAX_QUANTITY),

191: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
192: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
193: PRIMARY_SUBINVENTORY_FLAG = decode( p_PRIMARY_SUBINVENTORY_FLAG, FND_API.G_MISS_NUM, PRIMARY_SUBINVENTORY_FLAG, p_PRIMARY_SUBINVENTORY_FLAG),
194: PICKING_ORDER = decode( p_PICKING_ORDER, FND_API.G_MISS_NUM, PICKING_ORDER, p_PICKING_ORDER),
195: MIN_MINMAX_QUANTITY = decode( p_MIN_MINMAX_QUANTITY, FND_API.G_MISS_NUM, MIN_MINMAX_QUANTITY, p_MIN_MINMAX_QUANTITY),
196: MAX_MINMAX_QUANTITY = decode( p_MAX_MINMAX_QUANTITY, FND_API.G_MISS_NUM, MAX_MINMAX_QUANTITY, p_MAX_MINMAX_QUANTITY),
197: INVENTORY_PLANNING_CODE = decode( p_INVENTORY_PLANNING_CODE, FND_API.G_MISS_NUM, INVENTORY_PLANNING_CODE, p_INVENTORY_PLANNING_CODE),
198: FIXED_LOT_MULTIPLE = decode( p_FIXED_LOT_MULTIPLE, FND_API.G_MISS_NUM, FIXED_LOT_MULTIPLE, p_FIXED_LOT_MULTIPLE),
199: MINIMUM_ORDER_QUANTITY = decode( p_MINIMUM_ORDER_QUANTITY, FND_API.G_MISS_NUM, MINIMUM_ORDER_QUANTITY, p_MINIMUM_ORDER_QUANTITY),

Line 196: MAX_MINMAX_QUANTITY = decode( p_MAX_MINMAX_QUANTITY, FND_API.G_MISS_NUM, MAX_MINMAX_QUANTITY, p_MAX_MINMAX_QUANTITY),

192: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
193: PRIMARY_SUBINVENTORY_FLAG = decode( p_PRIMARY_SUBINVENTORY_FLAG, FND_API.G_MISS_NUM, PRIMARY_SUBINVENTORY_FLAG, p_PRIMARY_SUBINVENTORY_FLAG),
194: PICKING_ORDER = decode( p_PICKING_ORDER, FND_API.G_MISS_NUM, PICKING_ORDER, p_PICKING_ORDER),
195: MIN_MINMAX_QUANTITY = decode( p_MIN_MINMAX_QUANTITY, FND_API.G_MISS_NUM, MIN_MINMAX_QUANTITY, p_MIN_MINMAX_QUANTITY),
196: MAX_MINMAX_QUANTITY = decode( p_MAX_MINMAX_QUANTITY, FND_API.G_MISS_NUM, MAX_MINMAX_QUANTITY, p_MAX_MINMAX_QUANTITY),
197: INVENTORY_PLANNING_CODE = decode( p_INVENTORY_PLANNING_CODE, FND_API.G_MISS_NUM, INVENTORY_PLANNING_CODE, p_INVENTORY_PLANNING_CODE),
198: FIXED_LOT_MULTIPLE = decode( p_FIXED_LOT_MULTIPLE, FND_API.G_MISS_NUM, FIXED_LOT_MULTIPLE, p_FIXED_LOT_MULTIPLE),
199: MINIMUM_ORDER_QUANTITY = decode( p_MINIMUM_ORDER_QUANTITY, FND_API.G_MISS_NUM, MINIMUM_ORDER_QUANTITY, p_MINIMUM_ORDER_QUANTITY),
200: MAXIMUM_ORDER_QUANTITY = decode( p_MAXIMUM_ORDER_QUANTITY, FND_API.G_MISS_NUM, MAXIMUM_ORDER_QUANTITY, p_MAXIMUM_ORDER_QUANTITY),

Line 197: INVENTORY_PLANNING_CODE = decode( p_INVENTORY_PLANNING_CODE, FND_API.G_MISS_NUM, INVENTORY_PLANNING_CODE, p_INVENTORY_PLANNING_CODE),

193: PRIMARY_SUBINVENTORY_FLAG = decode( p_PRIMARY_SUBINVENTORY_FLAG, FND_API.G_MISS_NUM, PRIMARY_SUBINVENTORY_FLAG, p_PRIMARY_SUBINVENTORY_FLAG),
194: PICKING_ORDER = decode( p_PICKING_ORDER, FND_API.G_MISS_NUM, PICKING_ORDER, p_PICKING_ORDER),
195: MIN_MINMAX_QUANTITY = decode( p_MIN_MINMAX_QUANTITY, FND_API.G_MISS_NUM, MIN_MINMAX_QUANTITY, p_MIN_MINMAX_QUANTITY),
196: MAX_MINMAX_QUANTITY = decode( p_MAX_MINMAX_QUANTITY, FND_API.G_MISS_NUM, MAX_MINMAX_QUANTITY, p_MAX_MINMAX_QUANTITY),
197: INVENTORY_PLANNING_CODE = decode( p_INVENTORY_PLANNING_CODE, FND_API.G_MISS_NUM, INVENTORY_PLANNING_CODE, p_INVENTORY_PLANNING_CODE),
198: FIXED_LOT_MULTIPLE = decode( p_FIXED_LOT_MULTIPLE, FND_API.G_MISS_NUM, FIXED_LOT_MULTIPLE, p_FIXED_LOT_MULTIPLE),
199: MINIMUM_ORDER_QUANTITY = decode( p_MINIMUM_ORDER_QUANTITY, FND_API.G_MISS_NUM, MINIMUM_ORDER_QUANTITY, p_MINIMUM_ORDER_QUANTITY),
200: MAXIMUM_ORDER_QUANTITY = decode( p_MAXIMUM_ORDER_QUANTITY, FND_API.G_MISS_NUM, MAXIMUM_ORDER_QUANTITY, p_MAXIMUM_ORDER_QUANTITY),
201: SOURCE_TYPE = decode( p_SOURCE_TYPE, FND_API.G_MISS_NUM, SOURCE_TYPE, p_SOURCE_TYPE),

Line 198: FIXED_LOT_MULTIPLE = decode( p_FIXED_LOT_MULTIPLE, FND_API.G_MISS_NUM, FIXED_LOT_MULTIPLE, p_FIXED_LOT_MULTIPLE),

194: PICKING_ORDER = decode( p_PICKING_ORDER, FND_API.G_MISS_NUM, PICKING_ORDER, p_PICKING_ORDER),
195: MIN_MINMAX_QUANTITY = decode( p_MIN_MINMAX_QUANTITY, FND_API.G_MISS_NUM, MIN_MINMAX_QUANTITY, p_MIN_MINMAX_QUANTITY),
196: MAX_MINMAX_QUANTITY = decode( p_MAX_MINMAX_QUANTITY, FND_API.G_MISS_NUM, MAX_MINMAX_QUANTITY, p_MAX_MINMAX_QUANTITY),
197: INVENTORY_PLANNING_CODE = decode( p_INVENTORY_PLANNING_CODE, FND_API.G_MISS_NUM, INVENTORY_PLANNING_CODE, p_INVENTORY_PLANNING_CODE),
198: FIXED_LOT_MULTIPLE = decode( p_FIXED_LOT_MULTIPLE, FND_API.G_MISS_NUM, FIXED_LOT_MULTIPLE, p_FIXED_LOT_MULTIPLE),
199: MINIMUM_ORDER_QUANTITY = decode( p_MINIMUM_ORDER_QUANTITY, FND_API.G_MISS_NUM, MINIMUM_ORDER_QUANTITY, p_MINIMUM_ORDER_QUANTITY),
200: MAXIMUM_ORDER_QUANTITY = decode( p_MAXIMUM_ORDER_QUANTITY, FND_API.G_MISS_NUM, MAXIMUM_ORDER_QUANTITY, p_MAXIMUM_ORDER_QUANTITY),
201: SOURCE_TYPE = decode( p_SOURCE_TYPE, FND_API.G_MISS_NUM, SOURCE_TYPE, p_SOURCE_TYPE),
202: SOURCE_ORGANIZATION_ID = decode( p_SOURCE_ORGANIZATION_ID, FND_API.G_MISS_NUM, SOURCE_ORGANIZATION_ID, p_SOURCE_ORGANIZATION_ID),

Line 199: MINIMUM_ORDER_QUANTITY = decode( p_MINIMUM_ORDER_QUANTITY, FND_API.G_MISS_NUM, MINIMUM_ORDER_QUANTITY, p_MINIMUM_ORDER_QUANTITY),

195: MIN_MINMAX_QUANTITY = decode( p_MIN_MINMAX_QUANTITY, FND_API.G_MISS_NUM, MIN_MINMAX_QUANTITY, p_MIN_MINMAX_QUANTITY),
196: MAX_MINMAX_QUANTITY = decode( p_MAX_MINMAX_QUANTITY, FND_API.G_MISS_NUM, MAX_MINMAX_QUANTITY, p_MAX_MINMAX_QUANTITY),
197: INVENTORY_PLANNING_CODE = decode( p_INVENTORY_PLANNING_CODE, FND_API.G_MISS_NUM, INVENTORY_PLANNING_CODE, p_INVENTORY_PLANNING_CODE),
198: FIXED_LOT_MULTIPLE = decode( p_FIXED_LOT_MULTIPLE, FND_API.G_MISS_NUM, FIXED_LOT_MULTIPLE, p_FIXED_LOT_MULTIPLE),
199: MINIMUM_ORDER_QUANTITY = decode( p_MINIMUM_ORDER_QUANTITY, FND_API.G_MISS_NUM, MINIMUM_ORDER_QUANTITY, p_MINIMUM_ORDER_QUANTITY),
200: MAXIMUM_ORDER_QUANTITY = decode( p_MAXIMUM_ORDER_QUANTITY, FND_API.G_MISS_NUM, MAXIMUM_ORDER_QUANTITY, p_MAXIMUM_ORDER_QUANTITY),
201: SOURCE_TYPE = decode( p_SOURCE_TYPE, FND_API.G_MISS_NUM, SOURCE_TYPE, p_SOURCE_TYPE),
202: SOURCE_ORGANIZATION_ID = decode( p_SOURCE_ORGANIZATION_ID, FND_API.G_MISS_NUM, SOURCE_ORGANIZATION_ID, p_SOURCE_ORGANIZATION_ID),
203: SOURCE_SUBINVENTORY = decode( p_SOURCE_SUBINVENTORY, FND_API.G_MISS_CHAR, SOURCE_SUBINVENTORY, p_SOURCE_SUBINVENTORY),

Line 200: MAXIMUM_ORDER_QUANTITY = decode( p_MAXIMUM_ORDER_QUANTITY, FND_API.G_MISS_NUM, MAXIMUM_ORDER_QUANTITY, p_MAXIMUM_ORDER_QUANTITY),

196: MAX_MINMAX_QUANTITY = decode( p_MAX_MINMAX_QUANTITY, FND_API.G_MISS_NUM, MAX_MINMAX_QUANTITY, p_MAX_MINMAX_QUANTITY),
197: INVENTORY_PLANNING_CODE = decode( p_INVENTORY_PLANNING_CODE, FND_API.G_MISS_NUM, INVENTORY_PLANNING_CODE, p_INVENTORY_PLANNING_CODE),
198: FIXED_LOT_MULTIPLE = decode( p_FIXED_LOT_MULTIPLE, FND_API.G_MISS_NUM, FIXED_LOT_MULTIPLE, p_FIXED_LOT_MULTIPLE),
199: MINIMUM_ORDER_QUANTITY = decode( p_MINIMUM_ORDER_QUANTITY, FND_API.G_MISS_NUM, MINIMUM_ORDER_QUANTITY, p_MINIMUM_ORDER_QUANTITY),
200: MAXIMUM_ORDER_QUANTITY = decode( p_MAXIMUM_ORDER_QUANTITY, FND_API.G_MISS_NUM, MAXIMUM_ORDER_QUANTITY, p_MAXIMUM_ORDER_QUANTITY),
201: SOURCE_TYPE = decode( p_SOURCE_TYPE, FND_API.G_MISS_NUM, SOURCE_TYPE, p_SOURCE_TYPE),
202: SOURCE_ORGANIZATION_ID = decode( p_SOURCE_ORGANIZATION_ID, FND_API.G_MISS_NUM, SOURCE_ORGANIZATION_ID, p_SOURCE_ORGANIZATION_ID),
203: SOURCE_SUBINVENTORY = decode( p_SOURCE_SUBINVENTORY, FND_API.G_MISS_CHAR, SOURCE_SUBINVENTORY, p_SOURCE_SUBINVENTORY),
204: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),

Line 201: SOURCE_TYPE = decode( p_SOURCE_TYPE, FND_API.G_MISS_NUM, SOURCE_TYPE, p_SOURCE_TYPE),

197: INVENTORY_PLANNING_CODE = decode( p_INVENTORY_PLANNING_CODE, FND_API.G_MISS_NUM, INVENTORY_PLANNING_CODE, p_INVENTORY_PLANNING_CODE),
198: FIXED_LOT_MULTIPLE = decode( p_FIXED_LOT_MULTIPLE, FND_API.G_MISS_NUM, FIXED_LOT_MULTIPLE, p_FIXED_LOT_MULTIPLE),
199: MINIMUM_ORDER_QUANTITY = decode( p_MINIMUM_ORDER_QUANTITY, FND_API.G_MISS_NUM, MINIMUM_ORDER_QUANTITY, p_MINIMUM_ORDER_QUANTITY),
200: MAXIMUM_ORDER_QUANTITY = decode( p_MAXIMUM_ORDER_QUANTITY, FND_API.G_MISS_NUM, MAXIMUM_ORDER_QUANTITY, p_MAXIMUM_ORDER_QUANTITY),
201: SOURCE_TYPE = decode( p_SOURCE_TYPE, FND_API.G_MISS_NUM, SOURCE_TYPE, p_SOURCE_TYPE),
202: SOURCE_ORGANIZATION_ID = decode( p_SOURCE_ORGANIZATION_ID, FND_API.G_MISS_NUM, SOURCE_ORGANIZATION_ID, p_SOURCE_ORGANIZATION_ID),
203: SOURCE_SUBINVENTORY = decode( p_SOURCE_SUBINVENTORY, FND_API.G_MISS_CHAR, SOURCE_SUBINVENTORY, p_SOURCE_SUBINVENTORY),
204: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
205: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),

Line 202: SOURCE_ORGANIZATION_ID = decode( p_SOURCE_ORGANIZATION_ID, FND_API.G_MISS_NUM, SOURCE_ORGANIZATION_ID, p_SOURCE_ORGANIZATION_ID),

198: FIXED_LOT_MULTIPLE = decode( p_FIXED_LOT_MULTIPLE, FND_API.G_MISS_NUM, FIXED_LOT_MULTIPLE, p_FIXED_LOT_MULTIPLE),
199: MINIMUM_ORDER_QUANTITY = decode( p_MINIMUM_ORDER_QUANTITY, FND_API.G_MISS_NUM, MINIMUM_ORDER_QUANTITY, p_MINIMUM_ORDER_QUANTITY),
200: MAXIMUM_ORDER_QUANTITY = decode( p_MAXIMUM_ORDER_QUANTITY, FND_API.G_MISS_NUM, MAXIMUM_ORDER_QUANTITY, p_MAXIMUM_ORDER_QUANTITY),
201: SOURCE_TYPE = decode( p_SOURCE_TYPE, FND_API.G_MISS_NUM, SOURCE_TYPE, p_SOURCE_TYPE),
202: SOURCE_ORGANIZATION_ID = decode( p_SOURCE_ORGANIZATION_ID, FND_API.G_MISS_NUM, SOURCE_ORGANIZATION_ID, p_SOURCE_ORGANIZATION_ID),
203: SOURCE_SUBINVENTORY = decode( p_SOURCE_SUBINVENTORY, FND_API.G_MISS_CHAR, SOURCE_SUBINVENTORY, p_SOURCE_SUBINVENTORY),
204: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
205: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
206: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),

Line 203: SOURCE_SUBINVENTORY = decode( p_SOURCE_SUBINVENTORY, FND_API.G_MISS_CHAR, SOURCE_SUBINVENTORY, p_SOURCE_SUBINVENTORY),

199: MINIMUM_ORDER_QUANTITY = decode( p_MINIMUM_ORDER_QUANTITY, FND_API.G_MISS_NUM, MINIMUM_ORDER_QUANTITY, p_MINIMUM_ORDER_QUANTITY),
200: MAXIMUM_ORDER_QUANTITY = decode( p_MAXIMUM_ORDER_QUANTITY, FND_API.G_MISS_NUM, MAXIMUM_ORDER_QUANTITY, p_MAXIMUM_ORDER_QUANTITY),
201: SOURCE_TYPE = decode( p_SOURCE_TYPE, FND_API.G_MISS_NUM, SOURCE_TYPE, p_SOURCE_TYPE),
202: SOURCE_ORGANIZATION_ID = decode( p_SOURCE_ORGANIZATION_ID, FND_API.G_MISS_NUM, SOURCE_ORGANIZATION_ID, p_SOURCE_ORGANIZATION_ID),
203: SOURCE_SUBINVENTORY = decode( p_SOURCE_SUBINVENTORY, FND_API.G_MISS_CHAR, SOURCE_SUBINVENTORY, p_SOURCE_SUBINVENTORY),
204: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
205: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
206: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
207: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),

Line 204: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),

200: MAXIMUM_ORDER_QUANTITY = decode( p_MAXIMUM_ORDER_QUANTITY, FND_API.G_MISS_NUM, MAXIMUM_ORDER_QUANTITY, p_MAXIMUM_ORDER_QUANTITY),
201: SOURCE_TYPE = decode( p_SOURCE_TYPE, FND_API.G_MISS_NUM, SOURCE_TYPE, p_SOURCE_TYPE),
202: SOURCE_ORGANIZATION_ID = decode( p_SOURCE_ORGANIZATION_ID, FND_API.G_MISS_NUM, SOURCE_ORGANIZATION_ID, p_SOURCE_ORGANIZATION_ID),
203: SOURCE_SUBINVENTORY = decode( p_SOURCE_SUBINVENTORY, FND_API.G_MISS_CHAR, SOURCE_SUBINVENTORY, p_SOURCE_SUBINVENTORY),
204: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
205: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
206: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
207: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
208: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),

Line 205: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),

201: SOURCE_TYPE = decode( p_SOURCE_TYPE, FND_API.G_MISS_NUM, SOURCE_TYPE, p_SOURCE_TYPE),
202: SOURCE_ORGANIZATION_ID = decode( p_SOURCE_ORGANIZATION_ID, FND_API.G_MISS_NUM, SOURCE_ORGANIZATION_ID, p_SOURCE_ORGANIZATION_ID),
203: SOURCE_SUBINVENTORY = decode( p_SOURCE_SUBINVENTORY, FND_API.G_MISS_CHAR, SOURCE_SUBINVENTORY, p_SOURCE_SUBINVENTORY),
204: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
205: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
206: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
207: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
208: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
209: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),

Line 206: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),

202: SOURCE_ORGANIZATION_ID = decode( p_SOURCE_ORGANIZATION_ID, FND_API.G_MISS_NUM, SOURCE_ORGANIZATION_ID, p_SOURCE_ORGANIZATION_ID),
203: SOURCE_SUBINVENTORY = decode( p_SOURCE_SUBINVENTORY, FND_API.G_MISS_CHAR, SOURCE_SUBINVENTORY, p_SOURCE_SUBINVENTORY),
204: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
205: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
206: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
207: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
208: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
209: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
210: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),

Line 207: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),

203: SOURCE_SUBINVENTORY = decode( p_SOURCE_SUBINVENTORY, FND_API.G_MISS_CHAR, SOURCE_SUBINVENTORY, p_SOURCE_SUBINVENTORY),
204: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
205: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
206: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
207: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
208: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
209: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
210: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
211: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),

Line 208: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),

204: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
205: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
206: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
207: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
208: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
209: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
210: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
211: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
212: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),

Line 209: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),

205: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
206: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
207: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
208: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
209: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
210: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
211: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
212: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
213: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),

Line 210: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),

206: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
207: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
208: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
209: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
210: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
211: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
212: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
213: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
214: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),

Line 211: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),

207: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
208: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
209: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
210: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
211: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
212: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
213: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
214: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
215: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),

Line 212: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),

208: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
209: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
210: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
211: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
212: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
213: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
214: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
215: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
216: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),

Line 213: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),

209: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
210: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
211: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
212: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
213: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
214: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
215: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
216: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
217: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),

Line 214: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),

210: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
211: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
212: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
213: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
214: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
215: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
216: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
217: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
218: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),

Line 215: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),

211: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
212: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
213: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
214: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
215: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
216: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
217: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
218: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
219: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),

Line 216: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),

212: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
213: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
214: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
215: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
216: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
217: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
218: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
219: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
220: ENCUMBRANCE_ACCOUNT = decode( p_ENCUMBRANCE_ACCOUNT, FND_API.G_MISS_NUM, ENCUMBRANCE_ACCOUNT, p_ENCUMBRANCE_ACCOUNT),

Line 217: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),

213: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
214: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
215: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
216: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
217: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
218: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
219: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
220: ENCUMBRANCE_ACCOUNT = decode( p_ENCUMBRANCE_ACCOUNT, FND_API.G_MISS_NUM, ENCUMBRANCE_ACCOUNT, p_ENCUMBRANCE_ACCOUNT),
221: PREPROCESSING_LEAD_TIME = decode( p_PREPROCESSING_LEAD_TIME, FND_API.G_MISS_NUM, PREPROCESSING_LEAD_TIME, p_PREPROCESSING_LEAD_TIME),

Line 218: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),

214: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
215: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
216: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
217: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
218: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
219: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
220: ENCUMBRANCE_ACCOUNT = decode( p_ENCUMBRANCE_ACCOUNT, FND_API.G_MISS_NUM, ENCUMBRANCE_ACCOUNT, p_ENCUMBRANCE_ACCOUNT),
221: PREPROCESSING_LEAD_TIME = decode( p_PREPROCESSING_LEAD_TIME, FND_API.G_MISS_NUM, PREPROCESSING_LEAD_TIME, p_PREPROCESSING_LEAD_TIME),
222: PROCESSING_LEAD_TIME = decode( p_PROCESSING_LEAD_TIME, FND_API.G_MISS_NUM, PROCESSING_LEAD_TIME, p_PROCESSING_LEAD_TIME),

Line 219: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),

215: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
216: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
217: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
218: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
219: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
220: ENCUMBRANCE_ACCOUNT = decode( p_ENCUMBRANCE_ACCOUNT, FND_API.G_MISS_NUM, ENCUMBRANCE_ACCOUNT, p_ENCUMBRANCE_ACCOUNT),
221: PREPROCESSING_LEAD_TIME = decode( p_PREPROCESSING_LEAD_TIME, FND_API.G_MISS_NUM, PREPROCESSING_LEAD_TIME, p_PREPROCESSING_LEAD_TIME),
222: PROCESSING_LEAD_TIME = decode( p_PROCESSING_LEAD_TIME, FND_API.G_MISS_NUM, PROCESSING_LEAD_TIME, p_PROCESSING_LEAD_TIME),
223: POSTPROCESSING_LEAD_TIME = decode( p_POSTPROCESSING_LEAD_TIME, FND_API.G_MISS_NUM, POSTPROCESSING_LEAD_TIME, p_POSTPROCESSING_LEAD_TIME)

Line 220: ENCUMBRANCE_ACCOUNT = decode( p_ENCUMBRANCE_ACCOUNT, FND_API.G_MISS_NUM, ENCUMBRANCE_ACCOUNT, p_ENCUMBRANCE_ACCOUNT),

216: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
217: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
218: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
219: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
220: ENCUMBRANCE_ACCOUNT = decode( p_ENCUMBRANCE_ACCOUNT, FND_API.G_MISS_NUM, ENCUMBRANCE_ACCOUNT, p_ENCUMBRANCE_ACCOUNT),
221: PREPROCESSING_LEAD_TIME = decode( p_PREPROCESSING_LEAD_TIME, FND_API.G_MISS_NUM, PREPROCESSING_LEAD_TIME, p_PREPROCESSING_LEAD_TIME),
222: PROCESSING_LEAD_TIME = decode( p_PROCESSING_LEAD_TIME, FND_API.G_MISS_NUM, PROCESSING_LEAD_TIME, p_PROCESSING_LEAD_TIME),
223: POSTPROCESSING_LEAD_TIME = decode( p_POSTPROCESSING_LEAD_TIME, FND_API.G_MISS_NUM, POSTPROCESSING_LEAD_TIME, p_POSTPROCESSING_LEAD_TIME)
224: where inventory_item_id = p_INVENTORY_ITEM_ID

Line 221: PREPROCESSING_LEAD_TIME = decode( p_PREPROCESSING_LEAD_TIME, FND_API.G_MISS_NUM, PREPROCESSING_LEAD_TIME, p_PREPROCESSING_LEAD_TIME),

217: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
218: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
219: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
220: ENCUMBRANCE_ACCOUNT = decode( p_ENCUMBRANCE_ACCOUNT, FND_API.G_MISS_NUM, ENCUMBRANCE_ACCOUNT, p_ENCUMBRANCE_ACCOUNT),
221: PREPROCESSING_LEAD_TIME = decode( p_PREPROCESSING_LEAD_TIME, FND_API.G_MISS_NUM, PREPROCESSING_LEAD_TIME, p_PREPROCESSING_LEAD_TIME),
222: PROCESSING_LEAD_TIME = decode( p_PROCESSING_LEAD_TIME, FND_API.G_MISS_NUM, PROCESSING_LEAD_TIME, p_PROCESSING_LEAD_TIME),
223: POSTPROCESSING_LEAD_TIME = decode( p_POSTPROCESSING_LEAD_TIME, FND_API.G_MISS_NUM, POSTPROCESSING_LEAD_TIME, p_POSTPROCESSING_LEAD_TIME)
224: where inventory_item_id = p_INVENTORY_ITEM_ID
225: and secondary_inventory = p_SECONDARY_INVENTORY

Line 222: PROCESSING_LEAD_TIME = decode( p_PROCESSING_LEAD_TIME, FND_API.G_MISS_NUM, PROCESSING_LEAD_TIME, p_PROCESSING_LEAD_TIME),

218: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
219: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
220: ENCUMBRANCE_ACCOUNT = decode( p_ENCUMBRANCE_ACCOUNT, FND_API.G_MISS_NUM, ENCUMBRANCE_ACCOUNT, p_ENCUMBRANCE_ACCOUNT),
221: PREPROCESSING_LEAD_TIME = decode( p_PREPROCESSING_LEAD_TIME, FND_API.G_MISS_NUM, PREPROCESSING_LEAD_TIME, p_PREPROCESSING_LEAD_TIME),
222: PROCESSING_LEAD_TIME = decode( p_PROCESSING_LEAD_TIME, FND_API.G_MISS_NUM, PROCESSING_LEAD_TIME, p_PROCESSING_LEAD_TIME),
223: POSTPROCESSING_LEAD_TIME = decode( p_POSTPROCESSING_LEAD_TIME, FND_API.G_MISS_NUM, POSTPROCESSING_LEAD_TIME, p_POSTPROCESSING_LEAD_TIME)
224: where inventory_item_id = p_INVENTORY_ITEM_ID
225: and secondary_inventory = p_SECONDARY_INVENTORY
226: and organization_id = p_ORGANIZATION_ID;

Line 223: POSTPROCESSING_LEAD_TIME = decode( p_POSTPROCESSING_LEAD_TIME, FND_API.G_MISS_NUM, POSTPROCESSING_LEAD_TIME, p_POSTPROCESSING_LEAD_TIME)

219: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
220: ENCUMBRANCE_ACCOUNT = decode( p_ENCUMBRANCE_ACCOUNT, FND_API.G_MISS_NUM, ENCUMBRANCE_ACCOUNT, p_ENCUMBRANCE_ACCOUNT),
221: PREPROCESSING_LEAD_TIME = decode( p_PREPROCESSING_LEAD_TIME, FND_API.G_MISS_NUM, PREPROCESSING_LEAD_TIME, p_PREPROCESSING_LEAD_TIME),
222: PROCESSING_LEAD_TIME = decode( p_PROCESSING_LEAD_TIME, FND_API.G_MISS_NUM, PROCESSING_LEAD_TIME, p_PROCESSING_LEAD_TIME),
223: POSTPROCESSING_LEAD_TIME = decode( p_POSTPROCESSING_LEAD_TIME, FND_API.G_MISS_NUM, POSTPROCESSING_LEAD_TIME, p_POSTPROCESSING_LEAD_TIME)
224: where inventory_item_id = p_INVENTORY_ITEM_ID
225: and secondary_inventory = p_SECONDARY_INVENTORY
226: and organization_id = p_ORGANIZATION_ID;
227: