105:
106: IS
107: CURSOR C2 IS SELECT CSI_T_TXN_LINE_DETAILS_S.nextval FROM sys.dual;
108: BEGIN
109: If (px_TXN_LINE_DETAIL_ID IS NULL) OR (px_TXN_LINE_DETAIL_ID = FND_API.G_MISS_NUM) then
110: OPEN C2;
111: FETCH C2 INTO px_TXN_LINE_DETAIL_ID;
112: CLOSE C2;
113: End If;
188: ASSC_TXN_LINE_DETAIL_ID,
189: OVERRIDING_CSI_TXN_ID
190: ) VALUES (
191: px_TXN_LINE_DETAIL_ID,
192: decode( p_TRANSACTION_LINE_ID, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_LINE_ID),
193: decode( p_SUB_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_SUB_TYPE_ID),
194: decode( p_INSTANCE_EXISTS_FLAG, FND_API.G_MISS_CHAR, NULL, p_INSTANCE_EXISTS_FLAG),
195: decode( p_SOURCE_TRANSACTION_FLAG, FND_API.G_MISS_CHAR, NULL, p_SOURCE_TRANSACTION_FLAG),
196: decode( p_INSTANCE_ID, FND_API.G_MISS_NUM, NULL, p_INSTANCE_ID),
189: OVERRIDING_CSI_TXN_ID
190: ) VALUES (
191: px_TXN_LINE_DETAIL_ID,
192: decode( p_TRANSACTION_LINE_ID, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_LINE_ID),
193: decode( p_SUB_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_SUB_TYPE_ID),
194: decode( p_INSTANCE_EXISTS_FLAG, FND_API.G_MISS_CHAR, NULL, p_INSTANCE_EXISTS_FLAG),
195: decode( p_SOURCE_TRANSACTION_FLAG, FND_API.G_MISS_CHAR, NULL, p_SOURCE_TRANSACTION_FLAG),
196: decode( p_INSTANCE_ID, FND_API.G_MISS_NUM, NULL, p_INSTANCE_ID),
197: decode( p_CSI_SYSTEM_ID, FND_API.G_MISS_NUM, NULL, p_CSI_SYSTEM_ID),
190: ) VALUES (
191: px_TXN_LINE_DETAIL_ID,
192: decode( p_TRANSACTION_LINE_ID, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_LINE_ID),
193: decode( p_SUB_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_SUB_TYPE_ID),
194: decode( p_INSTANCE_EXISTS_FLAG, FND_API.G_MISS_CHAR, NULL, p_INSTANCE_EXISTS_FLAG),
195: decode( p_SOURCE_TRANSACTION_FLAG, FND_API.G_MISS_CHAR, NULL, p_SOURCE_TRANSACTION_FLAG),
196: decode( p_INSTANCE_ID, FND_API.G_MISS_NUM, NULL, p_INSTANCE_ID),
197: decode( p_CSI_SYSTEM_ID, FND_API.G_MISS_NUM, NULL, p_CSI_SYSTEM_ID),
198: decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID),
191: px_TXN_LINE_DETAIL_ID,
192: decode( p_TRANSACTION_LINE_ID, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_LINE_ID),
193: decode( p_SUB_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_SUB_TYPE_ID),
194: decode( p_INSTANCE_EXISTS_FLAG, FND_API.G_MISS_CHAR, NULL, p_INSTANCE_EXISTS_FLAG),
195: decode( p_SOURCE_TRANSACTION_FLAG, FND_API.G_MISS_CHAR, NULL, p_SOURCE_TRANSACTION_FLAG),
196: decode( p_INSTANCE_ID, FND_API.G_MISS_NUM, NULL, p_INSTANCE_ID),
197: decode( p_CSI_SYSTEM_ID, FND_API.G_MISS_NUM, NULL, p_CSI_SYSTEM_ID),
198: decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID),
199: decode( p_INV_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_INV_ORGANIZATION_ID),
192: decode( p_TRANSACTION_LINE_ID, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_LINE_ID),
193: decode( p_SUB_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_SUB_TYPE_ID),
194: decode( p_INSTANCE_EXISTS_FLAG, FND_API.G_MISS_CHAR, NULL, p_INSTANCE_EXISTS_FLAG),
195: decode( p_SOURCE_TRANSACTION_FLAG, FND_API.G_MISS_CHAR, NULL, p_SOURCE_TRANSACTION_FLAG),
196: decode( p_INSTANCE_ID, FND_API.G_MISS_NUM, NULL, p_INSTANCE_ID),
197: decode( p_CSI_SYSTEM_ID, FND_API.G_MISS_NUM, NULL, p_CSI_SYSTEM_ID),
198: decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID),
199: decode( p_INV_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_INV_ORGANIZATION_ID),
200: decode( p_INVENTORY_REVISION, FND_API.G_MISS_CHAR, NULL, p_INVENTORY_REVISION),
193: decode( p_SUB_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_SUB_TYPE_ID),
194: decode( p_INSTANCE_EXISTS_FLAG, FND_API.G_MISS_CHAR, NULL, p_INSTANCE_EXISTS_FLAG),
195: decode( p_SOURCE_TRANSACTION_FLAG, FND_API.G_MISS_CHAR, NULL, p_SOURCE_TRANSACTION_FLAG),
196: decode( p_INSTANCE_ID, FND_API.G_MISS_NUM, NULL, p_INSTANCE_ID),
197: decode( p_CSI_SYSTEM_ID, FND_API.G_MISS_NUM, NULL, p_CSI_SYSTEM_ID),
198: decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID),
199: decode( p_INV_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_INV_ORGANIZATION_ID),
200: decode( p_INVENTORY_REVISION, FND_API.G_MISS_CHAR, NULL, p_INVENTORY_REVISION),
201: decode( p_INSTANCE_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_INSTANCE_TYPE_CODE),
194: decode( p_INSTANCE_EXISTS_FLAG, FND_API.G_MISS_CHAR, NULL, p_INSTANCE_EXISTS_FLAG),
195: decode( p_SOURCE_TRANSACTION_FLAG, FND_API.G_MISS_CHAR, NULL, p_SOURCE_TRANSACTION_FLAG),
196: decode( p_INSTANCE_ID, FND_API.G_MISS_NUM, NULL, p_INSTANCE_ID),
197: decode( p_CSI_SYSTEM_ID, FND_API.G_MISS_NUM, NULL, p_CSI_SYSTEM_ID),
198: decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID),
199: decode( p_INV_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_INV_ORGANIZATION_ID),
200: decode( p_INVENTORY_REVISION, FND_API.G_MISS_CHAR, NULL, p_INVENTORY_REVISION),
201: decode( p_INSTANCE_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_INSTANCE_TYPE_CODE),
202: decode( p_ITEM_CONDITION_ID, FND_API.G_MISS_NUM, NULL, p_ITEM_CONDITION_ID),
195: decode( p_SOURCE_TRANSACTION_FLAG, FND_API.G_MISS_CHAR, NULL, p_SOURCE_TRANSACTION_FLAG),
196: decode( p_INSTANCE_ID, FND_API.G_MISS_NUM, NULL, p_INSTANCE_ID),
197: decode( p_CSI_SYSTEM_ID, FND_API.G_MISS_NUM, NULL, p_CSI_SYSTEM_ID),
198: decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID),
199: decode( p_INV_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_INV_ORGANIZATION_ID),
200: decode( p_INVENTORY_REVISION, FND_API.G_MISS_CHAR, NULL, p_INVENTORY_REVISION),
201: decode( p_INSTANCE_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_INSTANCE_TYPE_CODE),
202: decode( p_ITEM_CONDITION_ID, FND_API.G_MISS_NUM, NULL, p_ITEM_CONDITION_ID),
203: decode( p_QUANTITY, FND_API.G_MISS_NUM, NULL, p_QUANTITY),
196: decode( p_INSTANCE_ID, FND_API.G_MISS_NUM, NULL, p_INSTANCE_ID),
197: decode( p_CSI_SYSTEM_ID, FND_API.G_MISS_NUM, NULL, p_CSI_SYSTEM_ID),
198: decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID),
199: decode( p_INV_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_INV_ORGANIZATION_ID),
200: decode( p_INVENTORY_REVISION, FND_API.G_MISS_CHAR, NULL, p_INVENTORY_REVISION),
201: decode( p_INSTANCE_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_INSTANCE_TYPE_CODE),
202: decode( p_ITEM_CONDITION_ID, FND_API.G_MISS_NUM, NULL, p_ITEM_CONDITION_ID),
203: decode( p_QUANTITY, FND_API.G_MISS_NUM, NULL, p_QUANTITY),
204: decode( p_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, NULL, p_UNIT_OF_MEASURE),
197: decode( p_CSI_SYSTEM_ID, FND_API.G_MISS_NUM, NULL, p_CSI_SYSTEM_ID),
198: decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID),
199: decode( p_INV_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_INV_ORGANIZATION_ID),
200: decode( p_INVENTORY_REVISION, FND_API.G_MISS_CHAR, NULL, p_INVENTORY_REVISION),
201: decode( p_INSTANCE_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_INSTANCE_TYPE_CODE),
202: decode( p_ITEM_CONDITION_ID, FND_API.G_MISS_NUM, NULL, p_ITEM_CONDITION_ID),
203: decode( p_QUANTITY, FND_API.G_MISS_NUM, NULL, p_QUANTITY),
204: decode( p_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, NULL, p_UNIT_OF_MEASURE),
205: decode( p_QTY_REMAINING, FND_API.G_MISS_NUM, NULL, p_QTY_REMAINING),
198: decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID),
199: decode( p_INV_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_INV_ORGANIZATION_ID),
200: decode( p_INVENTORY_REVISION, FND_API.G_MISS_CHAR, NULL, p_INVENTORY_REVISION),
201: decode( p_INSTANCE_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_INSTANCE_TYPE_CODE),
202: decode( p_ITEM_CONDITION_ID, FND_API.G_MISS_NUM, NULL, p_ITEM_CONDITION_ID),
203: decode( p_QUANTITY, FND_API.G_MISS_NUM, NULL, p_QUANTITY),
204: decode( p_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, NULL, p_UNIT_OF_MEASURE),
205: decode( p_QTY_REMAINING, FND_API.G_MISS_NUM, NULL, p_QTY_REMAINING),
206: decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NULL, p_SERIAL_NUMBER),
199: decode( p_INV_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_INV_ORGANIZATION_ID),
200: decode( p_INVENTORY_REVISION, FND_API.G_MISS_CHAR, NULL, p_INVENTORY_REVISION),
201: decode( p_INSTANCE_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_INSTANCE_TYPE_CODE),
202: decode( p_ITEM_CONDITION_ID, FND_API.G_MISS_NUM, NULL, p_ITEM_CONDITION_ID),
203: decode( p_QUANTITY, FND_API.G_MISS_NUM, NULL, p_QUANTITY),
204: decode( p_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, NULL, p_UNIT_OF_MEASURE),
205: decode( p_QTY_REMAINING, FND_API.G_MISS_NUM, NULL, p_QTY_REMAINING),
206: decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NULL, p_SERIAL_NUMBER),
207: decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, NULL, p_LOT_NUMBER),
200: decode( p_INVENTORY_REVISION, FND_API.G_MISS_CHAR, NULL, p_INVENTORY_REVISION),
201: decode( p_INSTANCE_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_INSTANCE_TYPE_CODE),
202: decode( p_ITEM_CONDITION_ID, FND_API.G_MISS_NUM, NULL, p_ITEM_CONDITION_ID),
203: decode( p_QUANTITY, FND_API.G_MISS_NUM, NULL, p_QUANTITY),
204: decode( p_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, NULL, p_UNIT_OF_MEASURE),
205: decode( p_QTY_REMAINING, FND_API.G_MISS_NUM, NULL, p_QTY_REMAINING),
206: decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NULL, p_SERIAL_NUMBER),
207: decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, NULL, p_LOT_NUMBER),
208: decode( p_MFG_SERIAL_NUMBER_FLAG, FND_API.G_MISS_CHAR, NULL, p_MFG_SERIAL_NUMBER_FLAG),
201: decode( p_INSTANCE_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_INSTANCE_TYPE_CODE),
202: decode( p_ITEM_CONDITION_ID, FND_API.G_MISS_NUM, NULL, p_ITEM_CONDITION_ID),
203: decode( p_QUANTITY, FND_API.G_MISS_NUM, NULL, p_QUANTITY),
204: decode( p_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, NULL, p_UNIT_OF_MEASURE),
205: decode( p_QTY_REMAINING, FND_API.G_MISS_NUM, NULL, p_QTY_REMAINING),
206: decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NULL, p_SERIAL_NUMBER),
207: decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, NULL, p_LOT_NUMBER),
208: decode( p_MFG_SERIAL_NUMBER_FLAG, FND_API.G_MISS_CHAR, NULL, p_MFG_SERIAL_NUMBER_FLAG),
209: decode( p_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_LOCATION_TYPE_CODE),
202: decode( p_ITEM_CONDITION_ID, FND_API.G_MISS_NUM, NULL, p_ITEM_CONDITION_ID),
203: decode( p_QUANTITY, FND_API.G_MISS_NUM, NULL, p_QUANTITY),
204: decode( p_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, NULL, p_UNIT_OF_MEASURE),
205: decode( p_QTY_REMAINING, FND_API.G_MISS_NUM, NULL, p_QTY_REMAINING),
206: decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NULL, p_SERIAL_NUMBER),
207: decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, NULL, p_LOT_NUMBER),
208: decode( p_MFG_SERIAL_NUMBER_FLAG, FND_API.G_MISS_CHAR, NULL, p_MFG_SERIAL_NUMBER_FLAG),
209: decode( p_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_LOCATION_TYPE_CODE),
210: decode( p_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_LOCATION_ID),
203: decode( p_QUANTITY, FND_API.G_MISS_NUM, NULL, p_QUANTITY),
204: decode( p_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, NULL, p_UNIT_OF_MEASURE),
205: decode( p_QTY_REMAINING, FND_API.G_MISS_NUM, NULL, p_QTY_REMAINING),
206: decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NULL, p_SERIAL_NUMBER),
207: decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, NULL, p_LOT_NUMBER),
208: decode( p_MFG_SERIAL_NUMBER_FLAG, FND_API.G_MISS_CHAR, NULL, p_MFG_SERIAL_NUMBER_FLAG),
209: decode( p_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_LOCATION_TYPE_CODE),
210: decode( p_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_LOCATION_ID),
211: decode( p_INSTALLATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_INSTALLATION_DATE),
204: decode( p_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, NULL, p_UNIT_OF_MEASURE),
205: decode( p_QTY_REMAINING, FND_API.G_MISS_NUM, NULL, p_QTY_REMAINING),
206: decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NULL, p_SERIAL_NUMBER),
207: decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, NULL, p_LOT_NUMBER),
208: decode( p_MFG_SERIAL_NUMBER_FLAG, FND_API.G_MISS_CHAR, NULL, p_MFG_SERIAL_NUMBER_FLAG),
209: decode( p_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_LOCATION_TYPE_CODE),
210: decode( p_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_LOCATION_ID),
211: decode( p_INSTALLATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_INSTALLATION_DATE),
212: decode( p_IN_SERVICE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_IN_SERVICE_DATE),
205: decode( p_QTY_REMAINING, FND_API.G_MISS_NUM, NULL, p_QTY_REMAINING),
206: decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NULL, p_SERIAL_NUMBER),
207: decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, NULL, p_LOT_NUMBER),
208: decode( p_MFG_SERIAL_NUMBER_FLAG, FND_API.G_MISS_CHAR, NULL, p_MFG_SERIAL_NUMBER_FLAG),
209: decode( p_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_LOCATION_TYPE_CODE),
210: decode( p_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_LOCATION_ID),
211: decode( p_INSTALLATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_INSTALLATION_DATE),
212: decode( p_IN_SERVICE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_IN_SERVICE_DATE),
213: decode( p_EXTERNAL_REFERENCE, FND_API.G_MISS_CHAR, NULL, p_EXTERNAL_REFERENCE),
206: decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NULL, p_SERIAL_NUMBER),
207: decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, NULL, p_LOT_NUMBER),
208: decode( p_MFG_SERIAL_NUMBER_FLAG, FND_API.G_MISS_CHAR, NULL, p_MFG_SERIAL_NUMBER_FLAG),
209: decode( p_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_LOCATION_TYPE_CODE),
210: decode( p_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_LOCATION_ID),
211: decode( p_INSTALLATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_INSTALLATION_DATE),
212: decode( p_IN_SERVICE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_IN_SERVICE_DATE),
213: decode( p_EXTERNAL_REFERENCE, FND_API.G_MISS_CHAR, NULL, p_EXTERNAL_REFERENCE),
214: decode( p_VERSION_LABEL, FND_API.G_MISS_CHAR, NULL, p_VERSION_LABEL),
207: decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, NULL, p_LOT_NUMBER),
208: decode( p_MFG_SERIAL_NUMBER_FLAG, FND_API.G_MISS_CHAR, NULL, p_MFG_SERIAL_NUMBER_FLAG),
209: decode( p_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_LOCATION_TYPE_CODE),
210: decode( p_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_LOCATION_ID),
211: decode( p_INSTALLATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_INSTALLATION_DATE),
212: decode( p_IN_SERVICE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_IN_SERVICE_DATE),
213: decode( p_EXTERNAL_REFERENCE, FND_API.G_MISS_CHAR, NULL, p_EXTERNAL_REFERENCE),
214: decode( p_VERSION_LABEL, FND_API.G_MISS_CHAR, NULL, p_VERSION_LABEL),
215: decode( p_TRANSACTION_SYSTEM_ID, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_SYSTEM_ID),
208: decode( p_MFG_SERIAL_NUMBER_FLAG, FND_API.G_MISS_CHAR, NULL, p_MFG_SERIAL_NUMBER_FLAG),
209: decode( p_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_LOCATION_TYPE_CODE),
210: decode( p_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_LOCATION_ID),
211: decode( p_INSTALLATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_INSTALLATION_DATE),
212: decode( p_IN_SERVICE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_IN_SERVICE_DATE),
213: decode( p_EXTERNAL_REFERENCE, FND_API.G_MISS_CHAR, NULL, p_EXTERNAL_REFERENCE),
214: decode( p_VERSION_LABEL, FND_API.G_MISS_CHAR, NULL, p_VERSION_LABEL),
215: decode( p_TRANSACTION_SYSTEM_ID, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_SYSTEM_ID),
216: decode( p_SELLABLE_FLAG, FND_API.G_MISS_CHAR, NULL, p_SELLABLE_FLAG),
209: decode( p_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_LOCATION_TYPE_CODE),
210: decode( p_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_LOCATION_ID),
211: decode( p_INSTALLATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_INSTALLATION_DATE),
212: decode( p_IN_SERVICE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_IN_SERVICE_DATE),
213: decode( p_EXTERNAL_REFERENCE, FND_API.G_MISS_CHAR, NULL, p_EXTERNAL_REFERENCE),
214: decode( p_VERSION_LABEL, FND_API.G_MISS_CHAR, NULL, p_VERSION_LABEL),
215: decode( p_TRANSACTION_SYSTEM_ID, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_SYSTEM_ID),
216: decode( p_SELLABLE_FLAG, FND_API.G_MISS_CHAR, NULL, p_SELLABLE_FLAG),
217: decode( p_RETURN_BY_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_RETURN_BY_DATE),
210: decode( p_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_LOCATION_ID),
211: decode( p_INSTALLATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_INSTALLATION_DATE),
212: decode( p_IN_SERVICE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_IN_SERVICE_DATE),
213: decode( p_EXTERNAL_REFERENCE, FND_API.G_MISS_CHAR, NULL, p_EXTERNAL_REFERENCE),
214: decode( p_VERSION_LABEL, FND_API.G_MISS_CHAR, NULL, p_VERSION_LABEL),
215: decode( p_TRANSACTION_SYSTEM_ID, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_SYSTEM_ID),
216: decode( p_SELLABLE_FLAG, FND_API.G_MISS_CHAR, NULL, p_SELLABLE_FLAG),
217: decode( p_RETURN_BY_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_RETURN_BY_DATE),
218: decode( p_ACTIVE_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTIVE_START_DATE),
211: decode( p_INSTALLATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_INSTALLATION_DATE),
212: decode( p_IN_SERVICE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_IN_SERVICE_DATE),
213: decode( p_EXTERNAL_REFERENCE, FND_API.G_MISS_CHAR, NULL, p_EXTERNAL_REFERENCE),
214: decode( p_VERSION_LABEL, FND_API.G_MISS_CHAR, NULL, p_VERSION_LABEL),
215: decode( p_TRANSACTION_SYSTEM_ID, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_SYSTEM_ID),
216: decode( p_SELLABLE_FLAG, FND_API.G_MISS_CHAR, NULL, p_SELLABLE_FLAG),
217: decode( p_RETURN_BY_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_RETURN_BY_DATE),
218: decode( p_ACTIVE_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTIVE_START_DATE),
219: decode( p_ACTIVE_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTIVE_END_DATE),
212: decode( p_IN_SERVICE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_IN_SERVICE_DATE),
213: decode( p_EXTERNAL_REFERENCE, FND_API.G_MISS_CHAR, NULL, p_EXTERNAL_REFERENCE),
214: decode( p_VERSION_LABEL, FND_API.G_MISS_CHAR, NULL, p_VERSION_LABEL),
215: decode( p_TRANSACTION_SYSTEM_ID, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_SYSTEM_ID),
216: decode( p_SELLABLE_FLAG, FND_API.G_MISS_CHAR, NULL, p_SELLABLE_FLAG),
217: decode( p_RETURN_BY_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_RETURN_BY_DATE),
218: decode( p_ACTIVE_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTIVE_START_DATE),
219: decode( p_ACTIVE_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTIVE_END_DATE),
220: decode( p_PRESERVE_DETAIL_FLAG, FND_API.G_MISS_CHAR, NULL, p_PRESERVE_DETAIL_FLAG),
213: decode( p_EXTERNAL_REFERENCE, FND_API.G_MISS_CHAR, NULL, p_EXTERNAL_REFERENCE),
214: decode( p_VERSION_LABEL, FND_API.G_MISS_CHAR, NULL, p_VERSION_LABEL),
215: decode( p_TRANSACTION_SYSTEM_ID, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_SYSTEM_ID),
216: decode( p_SELLABLE_FLAG, FND_API.G_MISS_CHAR, NULL, p_SELLABLE_FLAG),
217: decode( p_RETURN_BY_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_RETURN_BY_DATE),
218: decode( p_ACTIVE_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTIVE_START_DATE),
219: decode( p_ACTIVE_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTIVE_END_DATE),
220: decode( p_PRESERVE_DETAIL_FLAG, FND_API.G_MISS_CHAR, NULL, p_PRESERVE_DETAIL_FLAG),
221: decode( p_CHANGED_INSTANCE_ID, FND_API.G_MISS_NUM, NULL, p_CHANGED_INSTANCE_ID),
214: decode( p_VERSION_LABEL, FND_API.G_MISS_CHAR, NULL, p_VERSION_LABEL),
215: decode( p_TRANSACTION_SYSTEM_ID, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_SYSTEM_ID),
216: decode( p_SELLABLE_FLAG, FND_API.G_MISS_CHAR, NULL, p_SELLABLE_FLAG),
217: decode( p_RETURN_BY_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_RETURN_BY_DATE),
218: decode( p_ACTIVE_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTIVE_START_DATE),
219: decode( p_ACTIVE_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTIVE_END_DATE),
220: decode( p_PRESERVE_DETAIL_FLAG, FND_API.G_MISS_CHAR, NULL, p_PRESERVE_DETAIL_FLAG),
221: decode( p_CHANGED_INSTANCE_ID, FND_API.G_MISS_NUM, NULL, p_CHANGED_INSTANCE_ID),
222: decode( p_REFERENCE_SOURCE_ID, FND_API.G_MISS_NUM, NULL, p_REFERENCE_SOURCE_ID),
215: decode( p_TRANSACTION_SYSTEM_ID, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_SYSTEM_ID),
216: decode( p_SELLABLE_FLAG, FND_API.G_MISS_CHAR, NULL, p_SELLABLE_FLAG),
217: decode( p_RETURN_BY_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_RETURN_BY_DATE),
218: decode( p_ACTIVE_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTIVE_START_DATE),
219: decode( p_ACTIVE_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTIVE_END_DATE),
220: decode( p_PRESERVE_DETAIL_FLAG, FND_API.G_MISS_CHAR, NULL, p_PRESERVE_DETAIL_FLAG),
221: decode( p_CHANGED_INSTANCE_ID, FND_API.G_MISS_NUM, NULL, p_CHANGED_INSTANCE_ID),
222: decode( p_REFERENCE_SOURCE_ID, FND_API.G_MISS_NUM, NULL, p_REFERENCE_SOURCE_ID),
223: decode( p_REFERENCE_SOURCE_LINE_ID, FND_API.G_MISS_NUM, NULL, p_REFERENCE_SOURCE_LINE_ID),
216: decode( p_SELLABLE_FLAG, FND_API.G_MISS_CHAR, NULL, p_SELLABLE_FLAG),
217: decode( p_RETURN_BY_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_RETURN_BY_DATE),
218: decode( p_ACTIVE_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTIVE_START_DATE),
219: decode( p_ACTIVE_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTIVE_END_DATE),
220: decode( p_PRESERVE_DETAIL_FLAG, FND_API.G_MISS_CHAR, NULL, p_PRESERVE_DETAIL_FLAG),
221: decode( p_CHANGED_INSTANCE_ID, FND_API.G_MISS_NUM, NULL, p_CHANGED_INSTANCE_ID),
222: decode( p_REFERENCE_SOURCE_ID, FND_API.G_MISS_NUM, NULL, p_REFERENCE_SOURCE_ID),
223: decode( p_REFERENCE_SOURCE_LINE_ID, FND_API.G_MISS_NUM, NULL, p_REFERENCE_SOURCE_LINE_ID),
224: decode( p_REFERENCE_SOURCE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_REFERENCE_SOURCE_DATE),
217: decode( p_RETURN_BY_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_RETURN_BY_DATE),
218: decode( p_ACTIVE_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTIVE_START_DATE),
219: decode( p_ACTIVE_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTIVE_END_DATE),
220: decode( p_PRESERVE_DETAIL_FLAG, FND_API.G_MISS_CHAR, NULL, p_PRESERVE_DETAIL_FLAG),
221: decode( p_CHANGED_INSTANCE_ID, FND_API.G_MISS_NUM, NULL, p_CHANGED_INSTANCE_ID),
222: decode( p_REFERENCE_SOURCE_ID, FND_API.G_MISS_NUM, NULL, p_REFERENCE_SOURCE_ID),
223: decode( p_REFERENCE_SOURCE_LINE_ID, FND_API.G_MISS_NUM, NULL, p_REFERENCE_SOURCE_LINE_ID),
224: decode( p_REFERENCE_SOURCE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_REFERENCE_SOURCE_DATE),
225: decode( p_CSI_TRANSACTION_ID, FND_API.G_MISS_NUM, NULL, p_CSI_TRANSACTION_ID),
218: decode( p_ACTIVE_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTIVE_START_DATE),
219: decode( p_ACTIVE_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTIVE_END_DATE),
220: decode( p_PRESERVE_DETAIL_FLAG, FND_API.G_MISS_CHAR, NULL, p_PRESERVE_DETAIL_FLAG),
221: decode( p_CHANGED_INSTANCE_ID, FND_API.G_MISS_NUM, NULL, p_CHANGED_INSTANCE_ID),
222: decode( p_REFERENCE_SOURCE_ID, FND_API.G_MISS_NUM, NULL, p_REFERENCE_SOURCE_ID),
223: decode( p_REFERENCE_SOURCE_LINE_ID, FND_API.G_MISS_NUM, NULL, p_REFERENCE_SOURCE_LINE_ID),
224: decode( p_REFERENCE_SOURCE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_REFERENCE_SOURCE_DATE),
225: decode( p_CSI_TRANSACTION_ID, FND_API.G_MISS_NUM, NULL, p_CSI_TRANSACTION_ID),
226: decode( p_SOURCE_TXN_LINE_DETAIL_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_TXN_LINE_DETAIL_ID),
219: decode( p_ACTIVE_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTIVE_END_DATE),
220: decode( p_PRESERVE_DETAIL_FLAG, FND_API.G_MISS_CHAR, NULL, p_PRESERVE_DETAIL_FLAG),
221: decode( p_CHANGED_INSTANCE_ID, FND_API.G_MISS_NUM, NULL, p_CHANGED_INSTANCE_ID),
222: decode( p_REFERENCE_SOURCE_ID, FND_API.G_MISS_NUM, NULL, p_REFERENCE_SOURCE_ID),
223: decode( p_REFERENCE_SOURCE_LINE_ID, FND_API.G_MISS_NUM, NULL, p_REFERENCE_SOURCE_LINE_ID),
224: decode( p_REFERENCE_SOURCE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_REFERENCE_SOURCE_DATE),
225: decode( p_CSI_TRANSACTION_ID, FND_API.G_MISS_NUM, NULL, p_CSI_TRANSACTION_ID),
226: decode( p_SOURCE_TXN_LINE_DETAIL_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_TXN_LINE_DETAIL_ID),
227: decode( p_INV_MTL_TRANSACTION_ID, FND_API.G_MISS_NUM, NULL, p_INV_MTL_TRANSACTION_ID),
220: decode( p_PRESERVE_DETAIL_FLAG, FND_API.G_MISS_CHAR, NULL, p_PRESERVE_DETAIL_FLAG),
221: decode( p_CHANGED_INSTANCE_ID, FND_API.G_MISS_NUM, NULL, p_CHANGED_INSTANCE_ID),
222: decode( p_REFERENCE_SOURCE_ID, FND_API.G_MISS_NUM, NULL, p_REFERENCE_SOURCE_ID),
223: decode( p_REFERENCE_SOURCE_LINE_ID, FND_API.G_MISS_NUM, NULL, p_REFERENCE_SOURCE_LINE_ID),
224: decode( p_REFERENCE_SOURCE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_REFERENCE_SOURCE_DATE),
225: decode( p_CSI_TRANSACTION_ID, FND_API.G_MISS_NUM, NULL, p_CSI_TRANSACTION_ID),
226: decode( p_SOURCE_TXN_LINE_DETAIL_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_TXN_LINE_DETAIL_ID),
227: decode( p_INV_MTL_TRANSACTION_ID, FND_API.G_MISS_NUM, NULL, p_INV_MTL_TRANSACTION_ID),
228: decode( p_PROCESSING_STATUS, FND_API.G_MISS_CHAR, NULL, p_PROCESSING_STATUS),
221: decode( p_CHANGED_INSTANCE_ID, FND_API.G_MISS_NUM, NULL, p_CHANGED_INSTANCE_ID),
222: decode( p_REFERENCE_SOURCE_ID, FND_API.G_MISS_NUM, NULL, p_REFERENCE_SOURCE_ID),
223: decode( p_REFERENCE_SOURCE_LINE_ID, FND_API.G_MISS_NUM, NULL, p_REFERENCE_SOURCE_LINE_ID),
224: decode( p_REFERENCE_SOURCE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_REFERENCE_SOURCE_DATE),
225: decode( p_CSI_TRANSACTION_ID, FND_API.G_MISS_NUM, NULL, p_CSI_TRANSACTION_ID),
226: decode( p_SOURCE_TXN_LINE_DETAIL_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_TXN_LINE_DETAIL_ID),
227: decode( p_INV_MTL_TRANSACTION_ID, FND_API.G_MISS_NUM, NULL, p_INV_MTL_TRANSACTION_ID),
228: decode( p_PROCESSING_STATUS, FND_API.G_MISS_CHAR, NULL, p_PROCESSING_STATUS),
229: decode( p_ERROR_CODE, FND_API.G_MISS_CHAR, NULL, p_ERROR_CODE),
222: decode( p_REFERENCE_SOURCE_ID, FND_API.G_MISS_NUM, NULL, p_REFERENCE_SOURCE_ID),
223: decode( p_REFERENCE_SOURCE_LINE_ID, FND_API.G_MISS_NUM, NULL, p_REFERENCE_SOURCE_LINE_ID),
224: decode( p_REFERENCE_SOURCE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_REFERENCE_SOURCE_DATE),
225: decode( p_CSI_TRANSACTION_ID, FND_API.G_MISS_NUM, NULL, p_CSI_TRANSACTION_ID),
226: decode( p_SOURCE_TXN_LINE_DETAIL_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_TXN_LINE_DETAIL_ID),
227: decode( p_INV_MTL_TRANSACTION_ID, FND_API.G_MISS_NUM, NULL, p_INV_MTL_TRANSACTION_ID),
228: decode( p_PROCESSING_STATUS, FND_API.G_MISS_CHAR, NULL, p_PROCESSING_STATUS),
229: decode( p_ERROR_CODE, FND_API.G_MISS_CHAR, NULL, p_ERROR_CODE),
230: decode( p_ERROR_EXPLANATION, FND_API.G_MISS_CHAR, NULL, p_ERROR_EXPLANATION),
223: decode( p_REFERENCE_SOURCE_LINE_ID, FND_API.G_MISS_NUM, NULL, p_REFERENCE_SOURCE_LINE_ID),
224: decode( p_REFERENCE_SOURCE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_REFERENCE_SOURCE_DATE),
225: decode( p_CSI_TRANSACTION_ID, FND_API.G_MISS_NUM, NULL, p_CSI_TRANSACTION_ID),
226: decode( p_SOURCE_TXN_LINE_DETAIL_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_TXN_LINE_DETAIL_ID),
227: decode( p_INV_MTL_TRANSACTION_ID, FND_API.G_MISS_NUM, NULL, p_INV_MTL_TRANSACTION_ID),
228: decode( p_PROCESSING_STATUS, FND_API.G_MISS_CHAR, NULL, p_PROCESSING_STATUS),
229: decode( p_ERROR_CODE, FND_API.G_MISS_CHAR, NULL, p_ERROR_CODE),
230: decode( p_ERROR_EXPLANATION, FND_API.G_MISS_CHAR, NULL, p_ERROR_EXPLANATION),
231: decode( p_CONFIG_INST_HDR_ID , FND_API.G_MISS_NUM, NULL, p_CONFIG_INST_HDR_ID),
224: decode( p_REFERENCE_SOURCE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_REFERENCE_SOURCE_DATE),
225: decode( p_CSI_TRANSACTION_ID, FND_API.G_MISS_NUM, NULL, p_CSI_TRANSACTION_ID),
226: decode( p_SOURCE_TXN_LINE_DETAIL_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_TXN_LINE_DETAIL_ID),
227: decode( p_INV_MTL_TRANSACTION_ID, FND_API.G_MISS_NUM, NULL, p_INV_MTL_TRANSACTION_ID),
228: decode( p_PROCESSING_STATUS, FND_API.G_MISS_CHAR, NULL, p_PROCESSING_STATUS),
229: decode( p_ERROR_CODE, FND_API.G_MISS_CHAR, NULL, p_ERROR_CODE),
230: decode( p_ERROR_EXPLANATION, FND_API.G_MISS_CHAR, NULL, p_ERROR_EXPLANATION),
231: decode( p_CONFIG_INST_HDR_ID , FND_API.G_MISS_NUM, NULL, p_CONFIG_INST_HDR_ID),
232: decode( p_CONFIG_INST_REV_NUM , FND_API.G_MISS_NUM, NULL, p_CONFIG_INST_REV_NUM),
225: decode( p_CSI_TRANSACTION_ID, FND_API.G_MISS_NUM, NULL, p_CSI_TRANSACTION_ID),
226: decode( p_SOURCE_TXN_LINE_DETAIL_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_TXN_LINE_DETAIL_ID),
227: decode( p_INV_MTL_TRANSACTION_ID, FND_API.G_MISS_NUM, NULL, p_INV_MTL_TRANSACTION_ID),
228: decode( p_PROCESSING_STATUS, FND_API.G_MISS_CHAR, NULL, p_PROCESSING_STATUS),
229: decode( p_ERROR_CODE, FND_API.G_MISS_CHAR, NULL, p_ERROR_CODE),
230: decode( p_ERROR_EXPLANATION, FND_API.G_MISS_CHAR, NULL, p_ERROR_EXPLANATION),
231: decode( p_CONFIG_INST_HDR_ID , FND_API.G_MISS_NUM, NULL, p_CONFIG_INST_HDR_ID),
232: decode( p_CONFIG_INST_REV_NUM , FND_API.G_MISS_NUM, NULL, p_CONFIG_INST_REV_NUM),
233: decode( p_CONFIG_INST_ITEM_ID , FND_API.G_MISS_NUM, NULL, p_CONFIG_INST_ITEM_ID),
226: decode( p_SOURCE_TXN_LINE_DETAIL_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_TXN_LINE_DETAIL_ID),
227: decode( p_INV_MTL_TRANSACTION_ID, FND_API.G_MISS_NUM, NULL, p_INV_MTL_TRANSACTION_ID),
228: decode( p_PROCESSING_STATUS, FND_API.G_MISS_CHAR, NULL, p_PROCESSING_STATUS),
229: decode( p_ERROR_CODE, FND_API.G_MISS_CHAR, NULL, p_ERROR_CODE),
230: decode( p_ERROR_EXPLANATION, FND_API.G_MISS_CHAR, NULL, p_ERROR_EXPLANATION),
231: decode( p_CONFIG_INST_HDR_ID , FND_API.G_MISS_NUM, NULL, p_CONFIG_INST_HDR_ID),
232: decode( p_CONFIG_INST_REV_NUM , FND_API.G_MISS_NUM, NULL, p_CONFIG_INST_REV_NUM),
233: decode( p_CONFIG_INST_ITEM_ID , FND_API.G_MISS_NUM, NULL, p_CONFIG_INST_ITEM_ID),
234: decode( p_CONFIG_INST_BASELINE_REV_NUM , FND_API.G_MISS_NUM, NULL, p_CONFIG_INST_BASELINE_REV_NUM),
227: decode( p_INV_MTL_TRANSACTION_ID, FND_API.G_MISS_NUM, NULL, p_INV_MTL_TRANSACTION_ID),
228: decode( p_PROCESSING_STATUS, FND_API.G_MISS_CHAR, NULL, p_PROCESSING_STATUS),
229: decode( p_ERROR_CODE, FND_API.G_MISS_CHAR, NULL, p_ERROR_CODE),
230: decode( p_ERROR_EXPLANATION, FND_API.G_MISS_CHAR, NULL, p_ERROR_EXPLANATION),
231: decode( p_CONFIG_INST_HDR_ID , FND_API.G_MISS_NUM, NULL, p_CONFIG_INST_HDR_ID),
232: decode( p_CONFIG_INST_REV_NUM , FND_API.G_MISS_NUM, NULL, p_CONFIG_INST_REV_NUM),
233: decode( p_CONFIG_INST_ITEM_ID , FND_API.G_MISS_NUM, NULL, p_CONFIG_INST_ITEM_ID),
234: decode( p_CONFIG_INST_BASELINE_REV_NUM , FND_API.G_MISS_NUM, NULL, p_CONFIG_INST_BASELINE_REV_NUM),
235: decode( p_TARGET_COMMITMENT_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_TARGET_COMMITMENT_DATE),
228: decode( p_PROCESSING_STATUS, FND_API.G_MISS_CHAR, NULL, p_PROCESSING_STATUS),
229: decode( p_ERROR_CODE, FND_API.G_MISS_CHAR, NULL, p_ERROR_CODE),
230: decode( p_ERROR_EXPLANATION, FND_API.G_MISS_CHAR, NULL, p_ERROR_EXPLANATION),
231: decode( p_CONFIG_INST_HDR_ID , FND_API.G_MISS_NUM, NULL, p_CONFIG_INST_HDR_ID),
232: decode( p_CONFIG_INST_REV_NUM , FND_API.G_MISS_NUM, NULL, p_CONFIG_INST_REV_NUM),
233: decode( p_CONFIG_INST_ITEM_ID , FND_API.G_MISS_NUM, NULL, p_CONFIG_INST_ITEM_ID),
234: decode( p_CONFIG_INST_BASELINE_REV_NUM , FND_API.G_MISS_NUM, NULL, p_CONFIG_INST_BASELINE_REV_NUM),
235: decode( p_TARGET_COMMITMENT_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_TARGET_COMMITMENT_DATE),
236: decode( p_INSTANCE_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_INSTANCE_DESCRIPTION),
229: decode( p_ERROR_CODE, FND_API.G_MISS_CHAR, NULL, p_ERROR_CODE),
230: decode( p_ERROR_EXPLANATION, FND_API.G_MISS_CHAR, NULL, p_ERROR_EXPLANATION),
231: decode( p_CONFIG_INST_HDR_ID , FND_API.G_MISS_NUM, NULL, p_CONFIG_INST_HDR_ID),
232: decode( p_CONFIG_INST_REV_NUM , FND_API.G_MISS_NUM, NULL, p_CONFIG_INST_REV_NUM),
233: decode( p_CONFIG_INST_ITEM_ID , FND_API.G_MISS_NUM, NULL, p_CONFIG_INST_ITEM_ID),
234: decode( p_CONFIG_INST_BASELINE_REV_NUM , FND_API.G_MISS_NUM, NULL, p_CONFIG_INST_BASELINE_REV_NUM),
235: decode( p_TARGET_COMMITMENT_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_TARGET_COMMITMENT_DATE),
236: decode( p_INSTANCE_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_INSTANCE_DESCRIPTION),
237: decode( p_INSTALL_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_INSTALL_LOCATION_TYPE_CODE),
230: decode( p_ERROR_EXPLANATION, FND_API.G_MISS_CHAR, NULL, p_ERROR_EXPLANATION),
231: decode( p_CONFIG_INST_HDR_ID , FND_API.G_MISS_NUM, NULL, p_CONFIG_INST_HDR_ID),
232: decode( p_CONFIG_INST_REV_NUM , FND_API.G_MISS_NUM, NULL, p_CONFIG_INST_REV_NUM),
233: decode( p_CONFIG_INST_ITEM_ID , FND_API.G_MISS_NUM, NULL, p_CONFIG_INST_ITEM_ID),
234: decode( p_CONFIG_INST_BASELINE_REV_NUM , FND_API.G_MISS_NUM, NULL, p_CONFIG_INST_BASELINE_REV_NUM),
235: decode( p_TARGET_COMMITMENT_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_TARGET_COMMITMENT_DATE),
236: decode( p_INSTANCE_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_INSTANCE_DESCRIPTION),
237: decode( p_INSTALL_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_INSTALL_LOCATION_TYPE_CODE),
238: decode( p_INSTALL_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_INSTALL_LOCATION_ID),
231: decode( p_CONFIG_INST_HDR_ID , FND_API.G_MISS_NUM, NULL, p_CONFIG_INST_HDR_ID),
232: decode( p_CONFIG_INST_REV_NUM , FND_API.G_MISS_NUM, NULL, p_CONFIG_INST_REV_NUM),
233: decode( p_CONFIG_INST_ITEM_ID , FND_API.G_MISS_NUM, NULL, p_CONFIG_INST_ITEM_ID),
234: decode( p_CONFIG_INST_BASELINE_REV_NUM , FND_API.G_MISS_NUM, NULL, p_CONFIG_INST_BASELINE_REV_NUM),
235: decode( p_TARGET_COMMITMENT_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_TARGET_COMMITMENT_DATE),
236: decode( p_INSTANCE_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_INSTANCE_DESCRIPTION),
237: decode( p_INSTALL_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_INSTALL_LOCATION_TYPE_CODE),
238: decode( p_INSTALL_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_INSTALL_LOCATION_ID),
239: decode( p_CASCADE_OWNER_FLAG, FND_API.G_MISS_CHAR, NULL, p_CASCADE_OWNER_FLAG),-- bug 2972082
232: decode( p_CONFIG_INST_REV_NUM , FND_API.G_MISS_NUM, NULL, p_CONFIG_INST_REV_NUM),
233: decode( p_CONFIG_INST_ITEM_ID , FND_API.G_MISS_NUM, NULL, p_CONFIG_INST_ITEM_ID),
234: decode( p_CONFIG_INST_BASELINE_REV_NUM , FND_API.G_MISS_NUM, NULL, p_CONFIG_INST_BASELINE_REV_NUM),
235: decode( p_TARGET_COMMITMENT_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_TARGET_COMMITMENT_DATE),
236: decode( p_INSTANCE_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_INSTANCE_DESCRIPTION),
237: decode( p_INSTALL_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_INSTALL_LOCATION_TYPE_CODE),
238: decode( p_INSTALL_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_INSTALL_LOCATION_ID),
239: decode( p_CASCADE_OWNER_FLAG, FND_API.G_MISS_CHAR, NULL, p_CASCADE_OWNER_FLAG),-- bug 2972082
240: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
233: decode( p_CONFIG_INST_ITEM_ID , FND_API.G_MISS_NUM, NULL, p_CONFIG_INST_ITEM_ID),
234: decode( p_CONFIG_INST_BASELINE_REV_NUM , FND_API.G_MISS_NUM, NULL, p_CONFIG_INST_BASELINE_REV_NUM),
235: decode( p_TARGET_COMMITMENT_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_TARGET_COMMITMENT_DATE),
236: decode( p_INSTANCE_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_INSTANCE_DESCRIPTION),
237: decode( p_INSTALL_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_INSTALL_LOCATION_TYPE_CODE),
238: decode( p_INSTALL_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_INSTALL_LOCATION_ID),
239: decode( p_CASCADE_OWNER_FLAG, FND_API.G_MISS_CHAR, NULL, p_CASCADE_OWNER_FLAG),-- bug 2972082
240: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
241: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
234: decode( p_CONFIG_INST_BASELINE_REV_NUM , FND_API.G_MISS_NUM, NULL, p_CONFIG_INST_BASELINE_REV_NUM),
235: decode( p_TARGET_COMMITMENT_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_TARGET_COMMITMENT_DATE),
236: decode( p_INSTANCE_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_INSTANCE_DESCRIPTION),
237: decode( p_INSTALL_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_INSTALL_LOCATION_TYPE_CODE),
238: decode( p_INSTALL_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_INSTALL_LOCATION_ID),
239: decode( p_CASCADE_OWNER_FLAG, FND_API.G_MISS_CHAR, NULL, p_CASCADE_OWNER_FLAG),-- bug 2972082
240: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
241: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
242: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
235: decode( p_TARGET_COMMITMENT_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_TARGET_COMMITMENT_DATE),
236: decode( p_INSTANCE_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_INSTANCE_DESCRIPTION),
237: decode( p_INSTALL_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_INSTALL_LOCATION_TYPE_CODE),
238: decode( p_INSTALL_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_INSTALL_LOCATION_ID),
239: decode( p_CASCADE_OWNER_FLAG, FND_API.G_MISS_CHAR, NULL, p_CASCADE_OWNER_FLAG),-- bug 2972082
240: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
241: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
242: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
243: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
236: decode( p_INSTANCE_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_INSTANCE_DESCRIPTION),
237: decode( p_INSTALL_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_INSTALL_LOCATION_TYPE_CODE),
238: decode( p_INSTALL_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_INSTALL_LOCATION_ID),
239: decode( p_CASCADE_OWNER_FLAG, FND_API.G_MISS_CHAR, NULL, p_CASCADE_OWNER_FLAG),-- bug 2972082
240: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
241: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
242: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
243: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
244: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
237: decode( p_INSTALL_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_INSTALL_LOCATION_TYPE_CODE),
238: decode( p_INSTALL_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_INSTALL_LOCATION_ID),
239: decode( p_CASCADE_OWNER_FLAG, FND_API.G_MISS_CHAR, NULL, p_CASCADE_OWNER_FLAG),-- bug 2972082
240: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
241: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
242: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
243: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
244: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
245: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
238: decode( p_INSTALL_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_INSTALL_LOCATION_ID),
239: decode( p_CASCADE_OWNER_FLAG, FND_API.G_MISS_CHAR, NULL, p_CASCADE_OWNER_FLAG),-- bug 2972082
240: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
241: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
242: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
243: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
244: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
245: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
246: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
239: decode( p_CASCADE_OWNER_FLAG, FND_API.G_MISS_CHAR, NULL, p_CASCADE_OWNER_FLAG),-- bug 2972082
240: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
241: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
242: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
243: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
244: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
245: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
246: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
247: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
240: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
241: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
242: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
243: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
244: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
245: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
246: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
247: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
248: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
241: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
242: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
243: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
244: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
245: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
246: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
247: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
248: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
249: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
242: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
243: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
244: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
245: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
246: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
247: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
248: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
249: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
250: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
243: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
244: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
245: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
246: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
247: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
248: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
249: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
250: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
251: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
244: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
245: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
246: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
247: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
248: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
249: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
250: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
251: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
252: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
245: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
246: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
247: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
248: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
249: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
250: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
251: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
252: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
253: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
246: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
247: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
248: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
249: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
250: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
251: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
252: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
253: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
254: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
247: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
248: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
249: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
250: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
251: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
252: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
253: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
254: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
255: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
248: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
249: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
250: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
251: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
252: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
253: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
254: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
255: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
256: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
249: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
250: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
251: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
252: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
253: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
254: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
255: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
256: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
257: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
250: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
251: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
252: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
253: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
254: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
255: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
256: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
257: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
258: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
251: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
252: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
253: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
254: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
255: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
256: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
257: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
258: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
259: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
252: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
253: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
254: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
255: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
256: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
257: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
258: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
259: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
260: decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER),
253: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
254: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
255: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
256: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
257: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
258: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
259: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
260: decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER),
261: decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_CONTEXT),
254: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
255: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
256: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
257: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
258: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
259: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
260: decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER),
261: decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_CONTEXT),
262: decode( p_INSTANCE_STATUS_ID, FND_API.G_MISS_NUM, NULL, p_INSTANCE_STATUS_ID),
255: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
256: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
257: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
258: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
259: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
260: decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER),
261: decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_CONTEXT),
262: decode( p_INSTANCE_STATUS_ID, FND_API.G_MISS_NUM, NULL, p_INSTANCE_STATUS_ID),
263: decode( p_PARENT_INSTANCE_ID, FND_API.G_MISS_NUM, NULL, p_PARENT_INSTANCE_ID),
256: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
257: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
258: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
259: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
260: decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER),
261: decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_CONTEXT),
262: decode( p_INSTANCE_STATUS_ID, FND_API.G_MISS_NUM, NULL, p_INSTANCE_STATUS_ID),
263: decode( p_PARENT_INSTANCE_ID, FND_API.G_MISS_NUM, NULL, p_PARENT_INSTANCE_ID),
264: decode( p_ASSC_TXN_LINE_DETAIL_ID, FND_API.G_MISS_NUM, NULL, p_ASSC_TXN_LINE_DETAIL_ID),
257: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
258: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
259: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
260: decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER),
261: decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_CONTEXT),
262: decode( p_INSTANCE_STATUS_ID, FND_API.G_MISS_NUM, NULL, p_INSTANCE_STATUS_ID),
263: decode( p_PARENT_INSTANCE_ID, FND_API.G_MISS_NUM, NULL, p_PARENT_INSTANCE_ID),
264: decode( p_ASSC_TXN_LINE_DETAIL_ID, FND_API.G_MISS_NUM, NULL, p_ASSC_TXN_LINE_DETAIL_ID),
265: decode( p_OVERRIDING_CSI_TXN_ID, FND_API.G_MISS_NUM, NULL, p_OVERRIDING_CSI_TXN_ID));
258: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
259: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
260: decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER),
261: decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_CONTEXT),
262: decode( p_INSTANCE_STATUS_ID, FND_API.G_MISS_NUM, NULL, p_INSTANCE_STATUS_ID),
263: decode( p_PARENT_INSTANCE_ID, FND_API.G_MISS_NUM, NULL, p_PARENT_INSTANCE_ID),
264: decode( p_ASSC_TXN_LINE_DETAIL_ID, FND_API.G_MISS_NUM, NULL, p_ASSC_TXN_LINE_DETAIL_ID),
265: decode( p_OVERRIDING_CSI_TXN_ID, FND_API.G_MISS_NUM, NULL, p_OVERRIDING_CSI_TXN_ID));
266: End Insert_Row;
259: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
260: decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER),
261: decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_CONTEXT),
262: decode( p_INSTANCE_STATUS_ID, FND_API.G_MISS_NUM, NULL, p_INSTANCE_STATUS_ID),
263: decode( p_PARENT_INSTANCE_ID, FND_API.G_MISS_NUM, NULL, p_PARENT_INSTANCE_ID),
264: decode( p_ASSC_TXN_LINE_DETAIL_ID, FND_API.G_MISS_NUM, NULL, p_ASSC_TXN_LINE_DETAIL_ID),
265: decode( p_OVERRIDING_CSI_TXN_ID, FND_API.G_MISS_NUM, NULL, p_OVERRIDING_CSI_TXN_ID));
266: End Insert_Row;
267:
260: decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER),
261: decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_CONTEXT),
262: decode( p_INSTANCE_STATUS_ID, FND_API.G_MISS_NUM, NULL, p_INSTANCE_STATUS_ID),
263: decode( p_PARENT_INSTANCE_ID, FND_API.G_MISS_NUM, NULL, p_PARENT_INSTANCE_ID),
264: decode( p_ASSC_TXN_LINE_DETAIL_ID, FND_API.G_MISS_NUM, NULL, p_ASSC_TXN_LINE_DETAIL_ID),
265: decode( p_OVERRIDING_CSI_TXN_ID, FND_API.G_MISS_NUM, NULL, p_OVERRIDING_CSI_TXN_ID));
266: End Insert_Row;
267:
268: PROCEDURE Update_Row(
261: decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_CONTEXT),
262: decode( p_INSTANCE_STATUS_ID, FND_API.G_MISS_NUM, NULL, p_INSTANCE_STATUS_ID),
263: decode( p_PARENT_INSTANCE_ID, FND_API.G_MISS_NUM, NULL, p_PARENT_INSTANCE_ID),
264: decode( p_ASSC_TXN_LINE_DETAIL_ID, FND_API.G_MISS_NUM, NULL, p_ASSC_TXN_LINE_DETAIL_ID),
265: decode( p_OVERRIDING_CSI_TXN_ID, FND_API.G_MISS_NUM, NULL, p_OVERRIDING_CSI_TXN_ID));
266: End Insert_Row;
267:
268: PROCEDURE Update_Row(
269: p_TXN_LINE_DETAIL_ID NUMBER,
345: IS
346: BEGIN
347: Update CSI_T_TXN_LINE_DETAILS
348: SET
349: TRANSACTION_LINE_ID = decode( p_TRANSACTION_LINE_ID, FND_API.G_MISS_NUM, TRANSACTION_LINE_ID, p_TRANSACTION_LINE_ID),
350: SUB_TYPE_ID = decode( p_SUB_TYPE_ID, FND_API.G_MISS_NUM, SUB_TYPE_ID, p_SUB_TYPE_ID),
351: INSTANCE_EXISTS_FLAG = decode( p_INSTANCE_EXISTS_FLAG, FND_API.G_MISS_CHAR, INSTANCE_EXISTS_FLAG, p_INSTANCE_EXISTS_FLAG),
352: SOURCE_TRANSACTION_FLAG = decode( p_SOURCE_TRANSACTION_FLAG, FND_API.G_MISS_CHAR, SOURCE_TRANSACTION_FLAG, p_SOURCE_TRANSACTION_FLAG),
353: INSTANCE_ID = decode( p_INSTANCE_ID, FND_API.G_MISS_NUM, INSTANCE_ID, p_INSTANCE_ID),
346: BEGIN
347: Update CSI_T_TXN_LINE_DETAILS
348: SET
349: TRANSACTION_LINE_ID = decode( p_TRANSACTION_LINE_ID, FND_API.G_MISS_NUM, TRANSACTION_LINE_ID, p_TRANSACTION_LINE_ID),
350: SUB_TYPE_ID = decode( p_SUB_TYPE_ID, FND_API.G_MISS_NUM, SUB_TYPE_ID, p_SUB_TYPE_ID),
351: INSTANCE_EXISTS_FLAG = decode( p_INSTANCE_EXISTS_FLAG, FND_API.G_MISS_CHAR, INSTANCE_EXISTS_FLAG, p_INSTANCE_EXISTS_FLAG),
352: SOURCE_TRANSACTION_FLAG = decode( p_SOURCE_TRANSACTION_FLAG, FND_API.G_MISS_CHAR, SOURCE_TRANSACTION_FLAG, p_SOURCE_TRANSACTION_FLAG),
353: INSTANCE_ID = decode( p_INSTANCE_ID, FND_API.G_MISS_NUM, INSTANCE_ID, p_INSTANCE_ID),
354: CSI_SYSTEM_ID = decode( p_CSI_SYSTEM_ID, FND_API.G_MISS_NUM, CSI_SYSTEM_ID, p_CSI_SYSTEM_ID),
347: Update CSI_T_TXN_LINE_DETAILS
348: SET
349: TRANSACTION_LINE_ID = decode( p_TRANSACTION_LINE_ID, FND_API.G_MISS_NUM, TRANSACTION_LINE_ID, p_TRANSACTION_LINE_ID),
350: SUB_TYPE_ID = decode( p_SUB_TYPE_ID, FND_API.G_MISS_NUM, SUB_TYPE_ID, p_SUB_TYPE_ID),
351: INSTANCE_EXISTS_FLAG = decode( p_INSTANCE_EXISTS_FLAG, FND_API.G_MISS_CHAR, INSTANCE_EXISTS_FLAG, p_INSTANCE_EXISTS_FLAG),
352: SOURCE_TRANSACTION_FLAG = decode( p_SOURCE_TRANSACTION_FLAG, FND_API.G_MISS_CHAR, SOURCE_TRANSACTION_FLAG, p_SOURCE_TRANSACTION_FLAG),
353: INSTANCE_ID = decode( p_INSTANCE_ID, FND_API.G_MISS_NUM, INSTANCE_ID, p_INSTANCE_ID),
354: CSI_SYSTEM_ID = decode( p_CSI_SYSTEM_ID, FND_API.G_MISS_NUM, CSI_SYSTEM_ID, p_CSI_SYSTEM_ID),
355: INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID),
348: SET
349: TRANSACTION_LINE_ID = decode( p_TRANSACTION_LINE_ID, FND_API.G_MISS_NUM, TRANSACTION_LINE_ID, p_TRANSACTION_LINE_ID),
350: SUB_TYPE_ID = decode( p_SUB_TYPE_ID, FND_API.G_MISS_NUM, SUB_TYPE_ID, p_SUB_TYPE_ID),
351: INSTANCE_EXISTS_FLAG = decode( p_INSTANCE_EXISTS_FLAG, FND_API.G_MISS_CHAR, INSTANCE_EXISTS_FLAG, p_INSTANCE_EXISTS_FLAG),
352: SOURCE_TRANSACTION_FLAG = decode( p_SOURCE_TRANSACTION_FLAG, FND_API.G_MISS_CHAR, SOURCE_TRANSACTION_FLAG, p_SOURCE_TRANSACTION_FLAG),
353: INSTANCE_ID = decode( p_INSTANCE_ID, FND_API.G_MISS_NUM, INSTANCE_ID, p_INSTANCE_ID),
354: CSI_SYSTEM_ID = decode( p_CSI_SYSTEM_ID, FND_API.G_MISS_NUM, CSI_SYSTEM_ID, p_CSI_SYSTEM_ID),
355: INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID),
356: INV_ORGANIZATION_ID = decode( p_INV_ORGANIZATION_ID, FND_API.G_MISS_NUM, INV_ORGANIZATION_ID, p_INV_ORGANIZATION_ID),
349: TRANSACTION_LINE_ID = decode( p_TRANSACTION_LINE_ID, FND_API.G_MISS_NUM, TRANSACTION_LINE_ID, p_TRANSACTION_LINE_ID),
350: SUB_TYPE_ID = decode( p_SUB_TYPE_ID, FND_API.G_MISS_NUM, SUB_TYPE_ID, p_SUB_TYPE_ID),
351: INSTANCE_EXISTS_FLAG = decode( p_INSTANCE_EXISTS_FLAG, FND_API.G_MISS_CHAR, INSTANCE_EXISTS_FLAG, p_INSTANCE_EXISTS_FLAG),
352: SOURCE_TRANSACTION_FLAG = decode( p_SOURCE_TRANSACTION_FLAG, FND_API.G_MISS_CHAR, SOURCE_TRANSACTION_FLAG, p_SOURCE_TRANSACTION_FLAG),
353: INSTANCE_ID = decode( p_INSTANCE_ID, FND_API.G_MISS_NUM, INSTANCE_ID, p_INSTANCE_ID),
354: CSI_SYSTEM_ID = decode( p_CSI_SYSTEM_ID, FND_API.G_MISS_NUM, CSI_SYSTEM_ID, p_CSI_SYSTEM_ID),
355: INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID),
356: INV_ORGANIZATION_ID = decode( p_INV_ORGANIZATION_ID, FND_API.G_MISS_NUM, INV_ORGANIZATION_ID, p_INV_ORGANIZATION_ID),
357: INVENTORY_REVISION = decode( p_INVENTORY_REVISION, FND_API.G_MISS_CHAR, INVENTORY_REVISION, p_INVENTORY_REVISION),
350: SUB_TYPE_ID = decode( p_SUB_TYPE_ID, FND_API.G_MISS_NUM, SUB_TYPE_ID, p_SUB_TYPE_ID),
351: INSTANCE_EXISTS_FLAG = decode( p_INSTANCE_EXISTS_FLAG, FND_API.G_MISS_CHAR, INSTANCE_EXISTS_FLAG, p_INSTANCE_EXISTS_FLAG),
352: SOURCE_TRANSACTION_FLAG = decode( p_SOURCE_TRANSACTION_FLAG, FND_API.G_MISS_CHAR, SOURCE_TRANSACTION_FLAG, p_SOURCE_TRANSACTION_FLAG),
353: INSTANCE_ID = decode( p_INSTANCE_ID, FND_API.G_MISS_NUM, INSTANCE_ID, p_INSTANCE_ID),
354: CSI_SYSTEM_ID = decode( p_CSI_SYSTEM_ID, FND_API.G_MISS_NUM, CSI_SYSTEM_ID, p_CSI_SYSTEM_ID),
355: INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID),
356: INV_ORGANIZATION_ID = decode( p_INV_ORGANIZATION_ID, FND_API.G_MISS_NUM, INV_ORGANIZATION_ID, p_INV_ORGANIZATION_ID),
357: INVENTORY_REVISION = decode( p_INVENTORY_REVISION, FND_API.G_MISS_CHAR, INVENTORY_REVISION, p_INVENTORY_REVISION),
358: INSTANCE_TYPE_CODE = decode( p_INSTANCE_TYPE_CODE, FND_API.G_MISS_CHAR, INSTANCE_TYPE_CODE, p_INSTANCE_TYPE_CODE),
351: INSTANCE_EXISTS_FLAG = decode( p_INSTANCE_EXISTS_FLAG, FND_API.G_MISS_CHAR, INSTANCE_EXISTS_FLAG, p_INSTANCE_EXISTS_FLAG),
352: SOURCE_TRANSACTION_FLAG = decode( p_SOURCE_TRANSACTION_FLAG, FND_API.G_MISS_CHAR, SOURCE_TRANSACTION_FLAG, p_SOURCE_TRANSACTION_FLAG),
353: INSTANCE_ID = decode( p_INSTANCE_ID, FND_API.G_MISS_NUM, INSTANCE_ID, p_INSTANCE_ID),
354: CSI_SYSTEM_ID = decode( p_CSI_SYSTEM_ID, FND_API.G_MISS_NUM, CSI_SYSTEM_ID, p_CSI_SYSTEM_ID),
355: INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID),
356: INV_ORGANIZATION_ID = decode( p_INV_ORGANIZATION_ID, FND_API.G_MISS_NUM, INV_ORGANIZATION_ID, p_INV_ORGANIZATION_ID),
357: INVENTORY_REVISION = decode( p_INVENTORY_REVISION, FND_API.G_MISS_CHAR, INVENTORY_REVISION, p_INVENTORY_REVISION),
358: INSTANCE_TYPE_CODE = decode( p_INSTANCE_TYPE_CODE, FND_API.G_MISS_CHAR, INSTANCE_TYPE_CODE, p_INSTANCE_TYPE_CODE),
359: ITEM_CONDITION_ID = decode( p_ITEM_CONDITION_ID, FND_API.G_MISS_NUM, ITEM_CONDITION_ID, p_ITEM_CONDITION_ID),
352: SOURCE_TRANSACTION_FLAG = decode( p_SOURCE_TRANSACTION_FLAG, FND_API.G_MISS_CHAR, SOURCE_TRANSACTION_FLAG, p_SOURCE_TRANSACTION_FLAG),
353: INSTANCE_ID = decode( p_INSTANCE_ID, FND_API.G_MISS_NUM, INSTANCE_ID, p_INSTANCE_ID),
354: CSI_SYSTEM_ID = decode( p_CSI_SYSTEM_ID, FND_API.G_MISS_NUM, CSI_SYSTEM_ID, p_CSI_SYSTEM_ID),
355: INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID),
356: INV_ORGANIZATION_ID = decode( p_INV_ORGANIZATION_ID, FND_API.G_MISS_NUM, INV_ORGANIZATION_ID, p_INV_ORGANIZATION_ID),
357: INVENTORY_REVISION = decode( p_INVENTORY_REVISION, FND_API.G_MISS_CHAR, INVENTORY_REVISION, p_INVENTORY_REVISION),
358: INSTANCE_TYPE_CODE = decode( p_INSTANCE_TYPE_CODE, FND_API.G_MISS_CHAR, INSTANCE_TYPE_CODE, p_INSTANCE_TYPE_CODE),
359: ITEM_CONDITION_ID = decode( p_ITEM_CONDITION_ID, FND_API.G_MISS_NUM, ITEM_CONDITION_ID, p_ITEM_CONDITION_ID),
360: QUANTITY = decode( p_QUANTITY, FND_API.G_MISS_NUM, QUANTITY, p_QUANTITY),
353: INSTANCE_ID = decode( p_INSTANCE_ID, FND_API.G_MISS_NUM, INSTANCE_ID, p_INSTANCE_ID),
354: CSI_SYSTEM_ID = decode( p_CSI_SYSTEM_ID, FND_API.G_MISS_NUM, CSI_SYSTEM_ID, p_CSI_SYSTEM_ID),
355: INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID),
356: INV_ORGANIZATION_ID = decode( p_INV_ORGANIZATION_ID, FND_API.G_MISS_NUM, INV_ORGANIZATION_ID, p_INV_ORGANIZATION_ID),
357: INVENTORY_REVISION = decode( p_INVENTORY_REVISION, FND_API.G_MISS_CHAR, INVENTORY_REVISION, p_INVENTORY_REVISION),
358: INSTANCE_TYPE_CODE = decode( p_INSTANCE_TYPE_CODE, FND_API.G_MISS_CHAR, INSTANCE_TYPE_CODE, p_INSTANCE_TYPE_CODE),
359: ITEM_CONDITION_ID = decode( p_ITEM_CONDITION_ID, FND_API.G_MISS_NUM, ITEM_CONDITION_ID, p_ITEM_CONDITION_ID),
360: QUANTITY = decode( p_QUANTITY, FND_API.G_MISS_NUM, QUANTITY, p_QUANTITY),
361: UNIT_OF_MEASURE = decode( p_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, UNIT_OF_MEASURE, p_UNIT_OF_MEASURE),
354: CSI_SYSTEM_ID = decode( p_CSI_SYSTEM_ID, FND_API.G_MISS_NUM, CSI_SYSTEM_ID, p_CSI_SYSTEM_ID),
355: INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID),
356: INV_ORGANIZATION_ID = decode( p_INV_ORGANIZATION_ID, FND_API.G_MISS_NUM, INV_ORGANIZATION_ID, p_INV_ORGANIZATION_ID),
357: INVENTORY_REVISION = decode( p_INVENTORY_REVISION, FND_API.G_MISS_CHAR, INVENTORY_REVISION, p_INVENTORY_REVISION),
358: INSTANCE_TYPE_CODE = decode( p_INSTANCE_TYPE_CODE, FND_API.G_MISS_CHAR, INSTANCE_TYPE_CODE, p_INSTANCE_TYPE_CODE),
359: ITEM_CONDITION_ID = decode( p_ITEM_CONDITION_ID, FND_API.G_MISS_NUM, ITEM_CONDITION_ID, p_ITEM_CONDITION_ID),
360: QUANTITY = decode( p_QUANTITY, FND_API.G_MISS_NUM, QUANTITY, p_QUANTITY),
361: UNIT_OF_MEASURE = decode( p_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, UNIT_OF_MEASURE, p_UNIT_OF_MEASURE),
362: QTY_REMAINING = decode( p_QTY_REMAINING, FND_API.G_MISS_NUM, QTY_REMAINING, p_QTY_REMAINING),
355: INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID),
356: INV_ORGANIZATION_ID = decode( p_INV_ORGANIZATION_ID, FND_API.G_MISS_NUM, INV_ORGANIZATION_ID, p_INV_ORGANIZATION_ID),
357: INVENTORY_REVISION = decode( p_INVENTORY_REVISION, FND_API.G_MISS_CHAR, INVENTORY_REVISION, p_INVENTORY_REVISION),
358: INSTANCE_TYPE_CODE = decode( p_INSTANCE_TYPE_CODE, FND_API.G_MISS_CHAR, INSTANCE_TYPE_CODE, p_INSTANCE_TYPE_CODE),
359: ITEM_CONDITION_ID = decode( p_ITEM_CONDITION_ID, FND_API.G_MISS_NUM, ITEM_CONDITION_ID, p_ITEM_CONDITION_ID),
360: QUANTITY = decode( p_QUANTITY, FND_API.G_MISS_NUM, QUANTITY, p_QUANTITY),
361: UNIT_OF_MEASURE = decode( p_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, UNIT_OF_MEASURE, p_UNIT_OF_MEASURE),
362: QTY_REMAINING = decode( p_QTY_REMAINING, FND_API.G_MISS_NUM, QTY_REMAINING, p_QTY_REMAINING),
363: SERIAL_NUMBER = decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, SERIAL_NUMBER, p_SERIAL_NUMBER),
356: INV_ORGANIZATION_ID = decode( p_INV_ORGANIZATION_ID, FND_API.G_MISS_NUM, INV_ORGANIZATION_ID, p_INV_ORGANIZATION_ID),
357: INVENTORY_REVISION = decode( p_INVENTORY_REVISION, FND_API.G_MISS_CHAR, INVENTORY_REVISION, p_INVENTORY_REVISION),
358: INSTANCE_TYPE_CODE = decode( p_INSTANCE_TYPE_CODE, FND_API.G_MISS_CHAR, INSTANCE_TYPE_CODE, p_INSTANCE_TYPE_CODE),
359: ITEM_CONDITION_ID = decode( p_ITEM_CONDITION_ID, FND_API.G_MISS_NUM, ITEM_CONDITION_ID, p_ITEM_CONDITION_ID),
360: QUANTITY = decode( p_QUANTITY, FND_API.G_MISS_NUM, QUANTITY, p_QUANTITY),
361: UNIT_OF_MEASURE = decode( p_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, UNIT_OF_MEASURE, p_UNIT_OF_MEASURE),
362: QTY_REMAINING = decode( p_QTY_REMAINING, FND_API.G_MISS_NUM, QTY_REMAINING, p_QTY_REMAINING),
363: SERIAL_NUMBER = decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, SERIAL_NUMBER, p_SERIAL_NUMBER),
364: LOT_NUMBER = decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, LOT_NUMBER, p_LOT_NUMBER),
357: INVENTORY_REVISION = decode( p_INVENTORY_REVISION, FND_API.G_MISS_CHAR, INVENTORY_REVISION, p_INVENTORY_REVISION),
358: INSTANCE_TYPE_CODE = decode( p_INSTANCE_TYPE_CODE, FND_API.G_MISS_CHAR, INSTANCE_TYPE_CODE, p_INSTANCE_TYPE_CODE),
359: ITEM_CONDITION_ID = decode( p_ITEM_CONDITION_ID, FND_API.G_MISS_NUM, ITEM_CONDITION_ID, p_ITEM_CONDITION_ID),
360: QUANTITY = decode( p_QUANTITY, FND_API.G_MISS_NUM, QUANTITY, p_QUANTITY),
361: UNIT_OF_MEASURE = decode( p_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, UNIT_OF_MEASURE, p_UNIT_OF_MEASURE),
362: QTY_REMAINING = decode( p_QTY_REMAINING, FND_API.G_MISS_NUM, QTY_REMAINING, p_QTY_REMAINING),
363: SERIAL_NUMBER = decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, SERIAL_NUMBER, p_SERIAL_NUMBER),
364: LOT_NUMBER = decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, LOT_NUMBER, p_LOT_NUMBER),
365: MFG_SERIAL_NUMBER_FLAG = decode( p_MFG_SERIAL_NUMBER_FLAG, FND_API.G_MISS_CHAR, MFG_SERIAL_NUMBER_FLAG, p_MFG_SERIAL_NUMBER_FLAG),
358: INSTANCE_TYPE_CODE = decode( p_INSTANCE_TYPE_CODE, FND_API.G_MISS_CHAR, INSTANCE_TYPE_CODE, p_INSTANCE_TYPE_CODE),
359: ITEM_CONDITION_ID = decode( p_ITEM_CONDITION_ID, FND_API.G_MISS_NUM, ITEM_CONDITION_ID, p_ITEM_CONDITION_ID),
360: QUANTITY = decode( p_QUANTITY, FND_API.G_MISS_NUM, QUANTITY, p_QUANTITY),
361: UNIT_OF_MEASURE = decode( p_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, UNIT_OF_MEASURE, p_UNIT_OF_MEASURE),
362: QTY_REMAINING = decode( p_QTY_REMAINING, FND_API.G_MISS_NUM, QTY_REMAINING, p_QTY_REMAINING),
363: SERIAL_NUMBER = decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, SERIAL_NUMBER, p_SERIAL_NUMBER),
364: LOT_NUMBER = decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, LOT_NUMBER, p_LOT_NUMBER),
365: MFG_SERIAL_NUMBER_FLAG = decode( p_MFG_SERIAL_NUMBER_FLAG, FND_API.G_MISS_CHAR, MFG_SERIAL_NUMBER_FLAG, p_MFG_SERIAL_NUMBER_FLAG),
366: LOCATION_TYPE_CODE = decode( p_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, LOCATION_TYPE_CODE, p_LOCATION_TYPE_CODE),
359: ITEM_CONDITION_ID = decode( p_ITEM_CONDITION_ID, FND_API.G_MISS_NUM, ITEM_CONDITION_ID, p_ITEM_CONDITION_ID),
360: QUANTITY = decode( p_QUANTITY, FND_API.G_MISS_NUM, QUANTITY, p_QUANTITY),
361: UNIT_OF_MEASURE = decode( p_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, UNIT_OF_MEASURE, p_UNIT_OF_MEASURE),
362: QTY_REMAINING = decode( p_QTY_REMAINING, FND_API.G_MISS_NUM, QTY_REMAINING, p_QTY_REMAINING),
363: SERIAL_NUMBER = decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, SERIAL_NUMBER, p_SERIAL_NUMBER),
364: LOT_NUMBER = decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, LOT_NUMBER, p_LOT_NUMBER),
365: MFG_SERIAL_NUMBER_FLAG = decode( p_MFG_SERIAL_NUMBER_FLAG, FND_API.G_MISS_CHAR, MFG_SERIAL_NUMBER_FLAG, p_MFG_SERIAL_NUMBER_FLAG),
366: LOCATION_TYPE_CODE = decode( p_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, LOCATION_TYPE_CODE, p_LOCATION_TYPE_CODE),
367: LOCATION_ID = decode( p_LOCATION_ID, FND_API.G_MISS_NUM, LOCATION_ID, p_LOCATION_ID),
360: QUANTITY = decode( p_QUANTITY, FND_API.G_MISS_NUM, QUANTITY, p_QUANTITY),
361: UNIT_OF_MEASURE = decode( p_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, UNIT_OF_MEASURE, p_UNIT_OF_MEASURE),
362: QTY_REMAINING = decode( p_QTY_REMAINING, FND_API.G_MISS_NUM, QTY_REMAINING, p_QTY_REMAINING),
363: SERIAL_NUMBER = decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, SERIAL_NUMBER, p_SERIAL_NUMBER),
364: LOT_NUMBER = decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, LOT_NUMBER, p_LOT_NUMBER),
365: MFG_SERIAL_NUMBER_FLAG = decode( p_MFG_SERIAL_NUMBER_FLAG, FND_API.G_MISS_CHAR, MFG_SERIAL_NUMBER_FLAG, p_MFG_SERIAL_NUMBER_FLAG),
366: LOCATION_TYPE_CODE = decode( p_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, LOCATION_TYPE_CODE, p_LOCATION_TYPE_CODE),
367: LOCATION_ID = decode( p_LOCATION_ID, FND_API.G_MISS_NUM, LOCATION_ID, p_LOCATION_ID),
368: INSTALLATION_DATE = decode( p_INSTALLATION_DATE, FND_API.G_MISS_DATE, INSTALLATION_DATE, p_INSTALLATION_DATE),
361: UNIT_OF_MEASURE = decode( p_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, UNIT_OF_MEASURE, p_UNIT_OF_MEASURE),
362: QTY_REMAINING = decode( p_QTY_REMAINING, FND_API.G_MISS_NUM, QTY_REMAINING, p_QTY_REMAINING),
363: SERIAL_NUMBER = decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, SERIAL_NUMBER, p_SERIAL_NUMBER),
364: LOT_NUMBER = decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, LOT_NUMBER, p_LOT_NUMBER),
365: MFG_SERIAL_NUMBER_FLAG = decode( p_MFG_SERIAL_NUMBER_FLAG, FND_API.G_MISS_CHAR, MFG_SERIAL_NUMBER_FLAG, p_MFG_SERIAL_NUMBER_FLAG),
366: LOCATION_TYPE_CODE = decode( p_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, LOCATION_TYPE_CODE, p_LOCATION_TYPE_CODE),
367: LOCATION_ID = decode( p_LOCATION_ID, FND_API.G_MISS_NUM, LOCATION_ID, p_LOCATION_ID),
368: INSTALLATION_DATE = decode( p_INSTALLATION_DATE, FND_API.G_MISS_DATE, INSTALLATION_DATE, p_INSTALLATION_DATE),
369: IN_SERVICE_DATE = decode( p_IN_SERVICE_DATE, FND_API.G_MISS_DATE, IN_SERVICE_DATE, p_IN_SERVICE_DATE),
362: QTY_REMAINING = decode( p_QTY_REMAINING, FND_API.G_MISS_NUM, QTY_REMAINING, p_QTY_REMAINING),
363: SERIAL_NUMBER = decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, SERIAL_NUMBER, p_SERIAL_NUMBER),
364: LOT_NUMBER = decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, LOT_NUMBER, p_LOT_NUMBER),
365: MFG_SERIAL_NUMBER_FLAG = decode( p_MFG_SERIAL_NUMBER_FLAG, FND_API.G_MISS_CHAR, MFG_SERIAL_NUMBER_FLAG, p_MFG_SERIAL_NUMBER_FLAG),
366: LOCATION_TYPE_CODE = decode( p_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, LOCATION_TYPE_CODE, p_LOCATION_TYPE_CODE),
367: LOCATION_ID = decode( p_LOCATION_ID, FND_API.G_MISS_NUM, LOCATION_ID, p_LOCATION_ID),
368: INSTALLATION_DATE = decode( p_INSTALLATION_DATE, FND_API.G_MISS_DATE, INSTALLATION_DATE, p_INSTALLATION_DATE),
369: IN_SERVICE_DATE = decode( p_IN_SERVICE_DATE, FND_API.G_MISS_DATE, IN_SERVICE_DATE, p_IN_SERVICE_DATE),
370: EXTERNAL_REFERENCE = decode( p_EXTERNAL_REFERENCE, FND_API.G_MISS_CHAR, EXTERNAL_REFERENCE, p_EXTERNAL_REFERENCE),
363: SERIAL_NUMBER = decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, SERIAL_NUMBER, p_SERIAL_NUMBER),
364: LOT_NUMBER = decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, LOT_NUMBER, p_LOT_NUMBER),
365: MFG_SERIAL_NUMBER_FLAG = decode( p_MFG_SERIAL_NUMBER_FLAG, FND_API.G_MISS_CHAR, MFG_SERIAL_NUMBER_FLAG, p_MFG_SERIAL_NUMBER_FLAG),
366: LOCATION_TYPE_CODE = decode( p_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, LOCATION_TYPE_CODE, p_LOCATION_TYPE_CODE),
367: LOCATION_ID = decode( p_LOCATION_ID, FND_API.G_MISS_NUM, LOCATION_ID, p_LOCATION_ID),
368: INSTALLATION_DATE = decode( p_INSTALLATION_DATE, FND_API.G_MISS_DATE, INSTALLATION_DATE, p_INSTALLATION_DATE),
369: IN_SERVICE_DATE = decode( p_IN_SERVICE_DATE, FND_API.G_MISS_DATE, IN_SERVICE_DATE, p_IN_SERVICE_DATE),
370: EXTERNAL_REFERENCE = decode( p_EXTERNAL_REFERENCE, FND_API.G_MISS_CHAR, EXTERNAL_REFERENCE, p_EXTERNAL_REFERENCE),
371: VERSION_LABEL = decode( p_VERSION_LABEL, FND_API.G_MISS_CHAR, VERSION_LABEL, p_VERSION_LABEL),
364: LOT_NUMBER = decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, LOT_NUMBER, p_LOT_NUMBER),
365: MFG_SERIAL_NUMBER_FLAG = decode( p_MFG_SERIAL_NUMBER_FLAG, FND_API.G_MISS_CHAR, MFG_SERIAL_NUMBER_FLAG, p_MFG_SERIAL_NUMBER_FLAG),
366: LOCATION_TYPE_CODE = decode( p_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, LOCATION_TYPE_CODE, p_LOCATION_TYPE_CODE),
367: LOCATION_ID = decode( p_LOCATION_ID, FND_API.G_MISS_NUM, LOCATION_ID, p_LOCATION_ID),
368: INSTALLATION_DATE = decode( p_INSTALLATION_DATE, FND_API.G_MISS_DATE, INSTALLATION_DATE, p_INSTALLATION_DATE),
369: IN_SERVICE_DATE = decode( p_IN_SERVICE_DATE, FND_API.G_MISS_DATE, IN_SERVICE_DATE, p_IN_SERVICE_DATE),
370: EXTERNAL_REFERENCE = decode( p_EXTERNAL_REFERENCE, FND_API.G_MISS_CHAR, EXTERNAL_REFERENCE, p_EXTERNAL_REFERENCE),
371: VERSION_LABEL = decode( p_VERSION_LABEL, FND_API.G_MISS_CHAR, VERSION_LABEL, p_VERSION_LABEL),
372: TRANSACTION_SYSTEM_ID = decode( p_TRANSACTION_SYSTEM_ID, FND_API.G_MISS_NUM, TRANSACTION_SYSTEM_ID, p_TRANSACTION_SYSTEM_ID),
365: MFG_SERIAL_NUMBER_FLAG = decode( p_MFG_SERIAL_NUMBER_FLAG, FND_API.G_MISS_CHAR, MFG_SERIAL_NUMBER_FLAG, p_MFG_SERIAL_NUMBER_FLAG),
366: LOCATION_TYPE_CODE = decode( p_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, LOCATION_TYPE_CODE, p_LOCATION_TYPE_CODE),
367: LOCATION_ID = decode( p_LOCATION_ID, FND_API.G_MISS_NUM, LOCATION_ID, p_LOCATION_ID),
368: INSTALLATION_DATE = decode( p_INSTALLATION_DATE, FND_API.G_MISS_DATE, INSTALLATION_DATE, p_INSTALLATION_DATE),
369: IN_SERVICE_DATE = decode( p_IN_SERVICE_DATE, FND_API.G_MISS_DATE, IN_SERVICE_DATE, p_IN_SERVICE_DATE),
370: EXTERNAL_REFERENCE = decode( p_EXTERNAL_REFERENCE, FND_API.G_MISS_CHAR, EXTERNAL_REFERENCE, p_EXTERNAL_REFERENCE),
371: VERSION_LABEL = decode( p_VERSION_LABEL, FND_API.G_MISS_CHAR, VERSION_LABEL, p_VERSION_LABEL),
372: TRANSACTION_SYSTEM_ID = decode( p_TRANSACTION_SYSTEM_ID, FND_API.G_MISS_NUM, TRANSACTION_SYSTEM_ID, p_TRANSACTION_SYSTEM_ID),
373: SELLABLE_FLAG = decode( p_SELLABLE_FLAG, FND_API.G_MISS_CHAR, SELLABLE_FLAG, p_SELLABLE_FLAG),
366: LOCATION_TYPE_CODE = decode( p_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, LOCATION_TYPE_CODE, p_LOCATION_TYPE_CODE),
367: LOCATION_ID = decode( p_LOCATION_ID, FND_API.G_MISS_NUM, LOCATION_ID, p_LOCATION_ID),
368: INSTALLATION_DATE = decode( p_INSTALLATION_DATE, FND_API.G_MISS_DATE, INSTALLATION_DATE, p_INSTALLATION_DATE),
369: IN_SERVICE_DATE = decode( p_IN_SERVICE_DATE, FND_API.G_MISS_DATE, IN_SERVICE_DATE, p_IN_SERVICE_DATE),
370: EXTERNAL_REFERENCE = decode( p_EXTERNAL_REFERENCE, FND_API.G_MISS_CHAR, EXTERNAL_REFERENCE, p_EXTERNAL_REFERENCE),
371: VERSION_LABEL = decode( p_VERSION_LABEL, FND_API.G_MISS_CHAR, VERSION_LABEL, p_VERSION_LABEL),
372: TRANSACTION_SYSTEM_ID = decode( p_TRANSACTION_SYSTEM_ID, FND_API.G_MISS_NUM, TRANSACTION_SYSTEM_ID, p_TRANSACTION_SYSTEM_ID),
373: SELLABLE_FLAG = decode( p_SELLABLE_FLAG, FND_API.G_MISS_CHAR, SELLABLE_FLAG, p_SELLABLE_FLAG),
374: RETURN_BY_DATE = decode( p_RETURN_BY_DATE, FND_API.G_MISS_DATE, RETURN_BY_DATE, p_RETURN_BY_DATE),
367: LOCATION_ID = decode( p_LOCATION_ID, FND_API.G_MISS_NUM, LOCATION_ID, p_LOCATION_ID),
368: INSTALLATION_DATE = decode( p_INSTALLATION_DATE, FND_API.G_MISS_DATE, INSTALLATION_DATE, p_INSTALLATION_DATE),
369: IN_SERVICE_DATE = decode( p_IN_SERVICE_DATE, FND_API.G_MISS_DATE, IN_SERVICE_DATE, p_IN_SERVICE_DATE),
370: EXTERNAL_REFERENCE = decode( p_EXTERNAL_REFERENCE, FND_API.G_MISS_CHAR, EXTERNAL_REFERENCE, p_EXTERNAL_REFERENCE),
371: VERSION_LABEL = decode( p_VERSION_LABEL, FND_API.G_MISS_CHAR, VERSION_LABEL, p_VERSION_LABEL),
372: TRANSACTION_SYSTEM_ID = decode( p_TRANSACTION_SYSTEM_ID, FND_API.G_MISS_NUM, TRANSACTION_SYSTEM_ID, p_TRANSACTION_SYSTEM_ID),
373: SELLABLE_FLAG = decode( p_SELLABLE_FLAG, FND_API.G_MISS_CHAR, SELLABLE_FLAG, p_SELLABLE_FLAG),
374: RETURN_BY_DATE = decode( p_RETURN_BY_DATE, FND_API.G_MISS_DATE, RETURN_BY_DATE, p_RETURN_BY_DATE),
375: ACTIVE_START_DATE = decode( p_ACTIVE_START_DATE, FND_API.G_MISS_DATE, ACTIVE_START_DATE, p_ACTIVE_START_DATE),
368: INSTALLATION_DATE = decode( p_INSTALLATION_DATE, FND_API.G_MISS_DATE, INSTALLATION_DATE, p_INSTALLATION_DATE),
369: IN_SERVICE_DATE = decode( p_IN_SERVICE_DATE, FND_API.G_MISS_DATE, IN_SERVICE_DATE, p_IN_SERVICE_DATE),
370: EXTERNAL_REFERENCE = decode( p_EXTERNAL_REFERENCE, FND_API.G_MISS_CHAR, EXTERNAL_REFERENCE, p_EXTERNAL_REFERENCE),
371: VERSION_LABEL = decode( p_VERSION_LABEL, FND_API.G_MISS_CHAR, VERSION_LABEL, p_VERSION_LABEL),
372: TRANSACTION_SYSTEM_ID = decode( p_TRANSACTION_SYSTEM_ID, FND_API.G_MISS_NUM, TRANSACTION_SYSTEM_ID, p_TRANSACTION_SYSTEM_ID),
373: SELLABLE_FLAG = decode( p_SELLABLE_FLAG, FND_API.G_MISS_CHAR, SELLABLE_FLAG, p_SELLABLE_FLAG),
374: RETURN_BY_DATE = decode( p_RETURN_BY_DATE, FND_API.G_MISS_DATE, RETURN_BY_DATE, p_RETURN_BY_DATE),
375: ACTIVE_START_DATE = decode( p_ACTIVE_START_DATE, FND_API.G_MISS_DATE, ACTIVE_START_DATE, p_ACTIVE_START_DATE),
376: ACTIVE_END_DATE = decode( p_ACTIVE_END_DATE, FND_API.G_MISS_DATE, ACTIVE_END_DATE, p_ACTIVE_END_DATE),
369: IN_SERVICE_DATE = decode( p_IN_SERVICE_DATE, FND_API.G_MISS_DATE, IN_SERVICE_DATE, p_IN_SERVICE_DATE),
370: EXTERNAL_REFERENCE = decode( p_EXTERNAL_REFERENCE, FND_API.G_MISS_CHAR, EXTERNAL_REFERENCE, p_EXTERNAL_REFERENCE),
371: VERSION_LABEL = decode( p_VERSION_LABEL, FND_API.G_MISS_CHAR, VERSION_LABEL, p_VERSION_LABEL),
372: TRANSACTION_SYSTEM_ID = decode( p_TRANSACTION_SYSTEM_ID, FND_API.G_MISS_NUM, TRANSACTION_SYSTEM_ID, p_TRANSACTION_SYSTEM_ID),
373: SELLABLE_FLAG = decode( p_SELLABLE_FLAG, FND_API.G_MISS_CHAR, SELLABLE_FLAG, p_SELLABLE_FLAG),
374: RETURN_BY_DATE = decode( p_RETURN_BY_DATE, FND_API.G_MISS_DATE, RETURN_BY_DATE, p_RETURN_BY_DATE),
375: ACTIVE_START_DATE = decode( p_ACTIVE_START_DATE, FND_API.G_MISS_DATE, ACTIVE_START_DATE, p_ACTIVE_START_DATE),
376: ACTIVE_END_DATE = decode( p_ACTIVE_END_DATE, FND_API.G_MISS_DATE, ACTIVE_END_DATE, p_ACTIVE_END_DATE),
377: PRESERVE_DETAIL_FLAG = decode( p_PRESERVE_DETAIL_FLAG, FND_API.G_MISS_CHAR, PRESERVE_DETAIL_FLAG, p_PRESERVE_DETAIL_FLAG),
370: EXTERNAL_REFERENCE = decode( p_EXTERNAL_REFERENCE, FND_API.G_MISS_CHAR, EXTERNAL_REFERENCE, p_EXTERNAL_REFERENCE),
371: VERSION_LABEL = decode( p_VERSION_LABEL, FND_API.G_MISS_CHAR, VERSION_LABEL, p_VERSION_LABEL),
372: TRANSACTION_SYSTEM_ID = decode( p_TRANSACTION_SYSTEM_ID, FND_API.G_MISS_NUM, TRANSACTION_SYSTEM_ID, p_TRANSACTION_SYSTEM_ID),
373: SELLABLE_FLAG = decode( p_SELLABLE_FLAG, FND_API.G_MISS_CHAR, SELLABLE_FLAG, p_SELLABLE_FLAG),
374: RETURN_BY_DATE = decode( p_RETURN_BY_DATE, FND_API.G_MISS_DATE, RETURN_BY_DATE, p_RETURN_BY_DATE),
375: ACTIVE_START_DATE = decode( p_ACTIVE_START_DATE, FND_API.G_MISS_DATE, ACTIVE_START_DATE, p_ACTIVE_START_DATE),
376: ACTIVE_END_DATE = decode( p_ACTIVE_END_DATE, FND_API.G_MISS_DATE, ACTIVE_END_DATE, p_ACTIVE_END_DATE),
377: PRESERVE_DETAIL_FLAG = decode( p_PRESERVE_DETAIL_FLAG, FND_API.G_MISS_CHAR, PRESERVE_DETAIL_FLAG, p_PRESERVE_DETAIL_FLAG),
378: CHANGED_INSTANCE_ID = decode( p_CHANGED_INSTANCE_ID, FND_API.G_MISS_NUM, CHANGED_INSTANCE_ID, p_CHANGED_INSTANCE_ID),
371: VERSION_LABEL = decode( p_VERSION_LABEL, FND_API.G_MISS_CHAR, VERSION_LABEL, p_VERSION_LABEL),
372: TRANSACTION_SYSTEM_ID = decode( p_TRANSACTION_SYSTEM_ID, FND_API.G_MISS_NUM, TRANSACTION_SYSTEM_ID, p_TRANSACTION_SYSTEM_ID),
373: SELLABLE_FLAG = decode( p_SELLABLE_FLAG, FND_API.G_MISS_CHAR, SELLABLE_FLAG, p_SELLABLE_FLAG),
374: RETURN_BY_DATE = decode( p_RETURN_BY_DATE, FND_API.G_MISS_DATE, RETURN_BY_DATE, p_RETURN_BY_DATE),
375: ACTIVE_START_DATE = decode( p_ACTIVE_START_DATE, FND_API.G_MISS_DATE, ACTIVE_START_DATE, p_ACTIVE_START_DATE),
376: ACTIVE_END_DATE = decode( p_ACTIVE_END_DATE, FND_API.G_MISS_DATE, ACTIVE_END_DATE, p_ACTIVE_END_DATE),
377: PRESERVE_DETAIL_FLAG = decode( p_PRESERVE_DETAIL_FLAG, FND_API.G_MISS_CHAR, PRESERVE_DETAIL_FLAG, p_PRESERVE_DETAIL_FLAG),
378: CHANGED_INSTANCE_ID = decode( p_CHANGED_INSTANCE_ID, FND_API.G_MISS_NUM, CHANGED_INSTANCE_ID, p_CHANGED_INSTANCE_ID),
379: REFERENCE_SOURCE_ID = decode( p_REFERENCE_SOURCE_ID, FND_API.G_MISS_NUM, REFERENCE_SOURCE_ID, p_REFERENCE_SOURCE_ID),
372: TRANSACTION_SYSTEM_ID = decode( p_TRANSACTION_SYSTEM_ID, FND_API.G_MISS_NUM, TRANSACTION_SYSTEM_ID, p_TRANSACTION_SYSTEM_ID),
373: SELLABLE_FLAG = decode( p_SELLABLE_FLAG, FND_API.G_MISS_CHAR, SELLABLE_FLAG, p_SELLABLE_FLAG),
374: RETURN_BY_DATE = decode( p_RETURN_BY_DATE, FND_API.G_MISS_DATE, RETURN_BY_DATE, p_RETURN_BY_DATE),
375: ACTIVE_START_DATE = decode( p_ACTIVE_START_DATE, FND_API.G_MISS_DATE, ACTIVE_START_DATE, p_ACTIVE_START_DATE),
376: ACTIVE_END_DATE = decode( p_ACTIVE_END_DATE, FND_API.G_MISS_DATE, ACTIVE_END_DATE, p_ACTIVE_END_DATE),
377: PRESERVE_DETAIL_FLAG = decode( p_PRESERVE_DETAIL_FLAG, FND_API.G_MISS_CHAR, PRESERVE_DETAIL_FLAG, p_PRESERVE_DETAIL_FLAG),
378: CHANGED_INSTANCE_ID = decode( p_CHANGED_INSTANCE_ID, FND_API.G_MISS_NUM, CHANGED_INSTANCE_ID, p_CHANGED_INSTANCE_ID),
379: REFERENCE_SOURCE_ID = decode( p_REFERENCE_SOURCE_ID, FND_API.G_MISS_NUM, REFERENCE_SOURCE_ID, p_REFERENCE_SOURCE_ID),
380: REFERENCE_SOURCE_LINE_ID = decode( p_REFERENCE_SOURCE_LINE_ID, FND_API.G_MISS_NUM, REFERENCE_SOURCE_LINE_ID, p_REFERENCE_SOURCE_LINE_ID),
373: SELLABLE_FLAG = decode( p_SELLABLE_FLAG, FND_API.G_MISS_CHAR, SELLABLE_FLAG, p_SELLABLE_FLAG),
374: RETURN_BY_DATE = decode( p_RETURN_BY_DATE, FND_API.G_MISS_DATE, RETURN_BY_DATE, p_RETURN_BY_DATE),
375: ACTIVE_START_DATE = decode( p_ACTIVE_START_DATE, FND_API.G_MISS_DATE, ACTIVE_START_DATE, p_ACTIVE_START_DATE),
376: ACTIVE_END_DATE = decode( p_ACTIVE_END_DATE, FND_API.G_MISS_DATE, ACTIVE_END_DATE, p_ACTIVE_END_DATE),
377: PRESERVE_DETAIL_FLAG = decode( p_PRESERVE_DETAIL_FLAG, FND_API.G_MISS_CHAR, PRESERVE_DETAIL_FLAG, p_PRESERVE_DETAIL_FLAG),
378: CHANGED_INSTANCE_ID = decode( p_CHANGED_INSTANCE_ID, FND_API.G_MISS_NUM, CHANGED_INSTANCE_ID, p_CHANGED_INSTANCE_ID),
379: REFERENCE_SOURCE_ID = decode( p_REFERENCE_SOURCE_ID, FND_API.G_MISS_NUM, REFERENCE_SOURCE_ID, p_REFERENCE_SOURCE_ID),
380: REFERENCE_SOURCE_LINE_ID = decode( p_REFERENCE_SOURCE_LINE_ID, FND_API.G_MISS_NUM, REFERENCE_SOURCE_LINE_ID, p_REFERENCE_SOURCE_LINE_ID),
381: REFERENCE_SOURCE_DATE = decode( p_REFERENCE_SOURCE_DATE, FND_API.G_MISS_DATE, REFERENCE_SOURCE_DATE, p_REFERENCE_SOURCE_DATE),
374: RETURN_BY_DATE = decode( p_RETURN_BY_DATE, FND_API.G_MISS_DATE, RETURN_BY_DATE, p_RETURN_BY_DATE),
375: ACTIVE_START_DATE = decode( p_ACTIVE_START_DATE, FND_API.G_MISS_DATE, ACTIVE_START_DATE, p_ACTIVE_START_DATE),
376: ACTIVE_END_DATE = decode( p_ACTIVE_END_DATE, FND_API.G_MISS_DATE, ACTIVE_END_DATE, p_ACTIVE_END_DATE),
377: PRESERVE_DETAIL_FLAG = decode( p_PRESERVE_DETAIL_FLAG, FND_API.G_MISS_CHAR, PRESERVE_DETAIL_FLAG, p_PRESERVE_DETAIL_FLAG),
378: CHANGED_INSTANCE_ID = decode( p_CHANGED_INSTANCE_ID, FND_API.G_MISS_NUM, CHANGED_INSTANCE_ID, p_CHANGED_INSTANCE_ID),
379: REFERENCE_SOURCE_ID = decode( p_REFERENCE_SOURCE_ID, FND_API.G_MISS_NUM, REFERENCE_SOURCE_ID, p_REFERENCE_SOURCE_ID),
380: REFERENCE_SOURCE_LINE_ID = decode( p_REFERENCE_SOURCE_LINE_ID, FND_API.G_MISS_NUM, REFERENCE_SOURCE_LINE_ID, p_REFERENCE_SOURCE_LINE_ID),
381: REFERENCE_SOURCE_DATE = decode( p_REFERENCE_SOURCE_DATE, FND_API.G_MISS_DATE, REFERENCE_SOURCE_DATE, p_REFERENCE_SOURCE_DATE),
382: CSI_TRANSACTION_ID = decode( p_CSI_TRANSACTION_ID, FND_API.G_MISS_NUM, CSI_TRANSACTION_ID, p_CSI_TRANSACTION_ID),
375: ACTIVE_START_DATE = decode( p_ACTIVE_START_DATE, FND_API.G_MISS_DATE, ACTIVE_START_DATE, p_ACTIVE_START_DATE),
376: ACTIVE_END_DATE = decode( p_ACTIVE_END_DATE, FND_API.G_MISS_DATE, ACTIVE_END_DATE, p_ACTIVE_END_DATE),
377: PRESERVE_DETAIL_FLAG = decode( p_PRESERVE_DETAIL_FLAG, FND_API.G_MISS_CHAR, PRESERVE_DETAIL_FLAG, p_PRESERVE_DETAIL_FLAG),
378: CHANGED_INSTANCE_ID = decode( p_CHANGED_INSTANCE_ID, FND_API.G_MISS_NUM, CHANGED_INSTANCE_ID, p_CHANGED_INSTANCE_ID),
379: REFERENCE_SOURCE_ID = decode( p_REFERENCE_SOURCE_ID, FND_API.G_MISS_NUM, REFERENCE_SOURCE_ID, p_REFERENCE_SOURCE_ID),
380: REFERENCE_SOURCE_LINE_ID = decode( p_REFERENCE_SOURCE_LINE_ID, FND_API.G_MISS_NUM, REFERENCE_SOURCE_LINE_ID, p_REFERENCE_SOURCE_LINE_ID),
381: REFERENCE_SOURCE_DATE = decode( p_REFERENCE_SOURCE_DATE, FND_API.G_MISS_DATE, REFERENCE_SOURCE_DATE, p_REFERENCE_SOURCE_DATE),
382: CSI_TRANSACTION_ID = decode( p_CSI_TRANSACTION_ID, FND_API.G_MISS_NUM, CSI_TRANSACTION_ID, p_CSI_TRANSACTION_ID),
383: SOURCE_TXN_LINE_DETAIL_ID = decode( p_SOURCE_TXN_LINE_DETAIL_ID, FND_API.G_MISS_NUM, SOURCE_TXN_LINE_DETAIL_ID, p_SOURCE_TXN_LINE_DETAIL_ID),
376: ACTIVE_END_DATE = decode( p_ACTIVE_END_DATE, FND_API.G_MISS_DATE, ACTIVE_END_DATE, p_ACTIVE_END_DATE),
377: PRESERVE_DETAIL_FLAG = decode( p_PRESERVE_DETAIL_FLAG, FND_API.G_MISS_CHAR, PRESERVE_DETAIL_FLAG, p_PRESERVE_DETAIL_FLAG),
378: CHANGED_INSTANCE_ID = decode( p_CHANGED_INSTANCE_ID, FND_API.G_MISS_NUM, CHANGED_INSTANCE_ID, p_CHANGED_INSTANCE_ID),
379: REFERENCE_SOURCE_ID = decode( p_REFERENCE_SOURCE_ID, FND_API.G_MISS_NUM, REFERENCE_SOURCE_ID, p_REFERENCE_SOURCE_ID),
380: REFERENCE_SOURCE_LINE_ID = decode( p_REFERENCE_SOURCE_LINE_ID, FND_API.G_MISS_NUM, REFERENCE_SOURCE_LINE_ID, p_REFERENCE_SOURCE_LINE_ID),
381: REFERENCE_SOURCE_DATE = decode( p_REFERENCE_SOURCE_DATE, FND_API.G_MISS_DATE, REFERENCE_SOURCE_DATE, p_REFERENCE_SOURCE_DATE),
382: CSI_TRANSACTION_ID = decode( p_CSI_TRANSACTION_ID, FND_API.G_MISS_NUM, CSI_TRANSACTION_ID, p_CSI_TRANSACTION_ID),
383: SOURCE_TXN_LINE_DETAIL_ID = decode( p_SOURCE_TXN_LINE_DETAIL_ID, FND_API.G_MISS_NUM, SOURCE_TXN_LINE_DETAIL_ID, p_SOURCE_TXN_LINE_DETAIL_ID),
384: INV_MTL_TRANSACTION_ID = decode( p_INV_MTL_TRANSACTION_ID, FND_API.G_MISS_NUM, INV_MTL_TRANSACTION_ID, p_INV_MTL_TRANSACTION_ID),
377: PRESERVE_DETAIL_FLAG = decode( p_PRESERVE_DETAIL_FLAG, FND_API.G_MISS_CHAR, PRESERVE_DETAIL_FLAG, p_PRESERVE_DETAIL_FLAG),
378: CHANGED_INSTANCE_ID = decode( p_CHANGED_INSTANCE_ID, FND_API.G_MISS_NUM, CHANGED_INSTANCE_ID, p_CHANGED_INSTANCE_ID),
379: REFERENCE_SOURCE_ID = decode( p_REFERENCE_SOURCE_ID, FND_API.G_MISS_NUM, REFERENCE_SOURCE_ID, p_REFERENCE_SOURCE_ID),
380: REFERENCE_SOURCE_LINE_ID = decode( p_REFERENCE_SOURCE_LINE_ID, FND_API.G_MISS_NUM, REFERENCE_SOURCE_LINE_ID, p_REFERENCE_SOURCE_LINE_ID),
381: REFERENCE_SOURCE_DATE = decode( p_REFERENCE_SOURCE_DATE, FND_API.G_MISS_DATE, REFERENCE_SOURCE_DATE, p_REFERENCE_SOURCE_DATE),
382: CSI_TRANSACTION_ID = decode( p_CSI_TRANSACTION_ID, FND_API.G_MISS_NUM, CSI_TRANSACTION_ID, p_CSI_TRANSACTION_ID),
383: SOURCE_TXN_LINE_DETAIL_ID = decode( p_SOURCE_TXN_LINE_DETAIL_ID, FND_API.G_MISS_NUM, SOURCE_TXN_LINE_DETAIL_ID, p_SOURCE_TXN_LINE_DETAIL_ID),
384: INV_MTL_TRANSACTION_ID = decode( p_INV_MTL_TRANSACTION_ID, FND_API.G_MISS_NUM, INV_MTL_TRANSACTION_ID, p_INV_MTL_TRANSACTION_ID),
385: PROCESSING_STATUS = decode( p_PROCESSING_STATUS, FND_API.G_MISS_CHAR, PROCESSING_STATUS, p_PROCESSING_STATUS),
378: CHANGED_INSTANCE_ID = decode( p_CHANGED_INSTANCE_ID, FND_API.G_MISS_NUM, CHANGED_INSTANCE_ID, p_CHANGED_INSTANCE_ID),
379: REFERENCE_SOURCE_ID = decode( p_REFERENCE_SOURCE_ID, FND_API.G_MISS_NUM, REFERENCE_SOURCE_ID, p_REFERENCE_SOURCE_ID),
380: REFERENCE_SOURCE_LINE_ID = decode( p_REFERENCE_SOURCE_LINE_ID, FND_API.G_MISS_NUM, REFERENCE_SOURCE_LINE_ID, p_REFERENCE_SOURCE_LINE_ID),
381: REFERENCE_SOURCE_DATE = decode( p_REFERENCE_SOURCE_DATE, FND_API.G_MISS_DATE, REFERENCE_SOURCE_DATE, p_REFERENCE_SOURCE_DATE),
382: CSI_TRANSACTION_ID = decode( p_CSI_TRANSACTION_ID, FND_API.G_MISS_NUM, CSI_TRANSACTION_ID, p_CSI_TRANSACTION_ID),
383: SOURCE_TXN_LINE_DETAIL_ID = decode( p_SOURCE_TXN_LINE_DETAIL_ID, FND_API.G_MISS_NUM, SOURCE_TXN_LINE_DETAIL_ID, p_SOURCE_TXN_LINE_DETAIL_ID),
384: INV_MTL_TRANSACTION_ID = decode( p_INV_MTL_TRANSACTION_ID, FND_API.G_MISS_NUM, INV_MTL_TRANSACTION_ID, p_INV_MTL_TRANSACTION_ID),
385: PROCESSING_STATUS = decode( p_PROCESSING_STATUS, FND_API.G_MISS_CHAR, PROCESSING_STATUS, p_PROCESSING_STATUS),
386: ERROR_CODE = decode( p_ERROR_CODE, FND_API.G_MISS_CHAR, ERROR_CODE, p_ERROR_CODE),
379: REFERENCE_SOURCE_ID = decode( p_REFERENCE_SOURCE_ID, FND_API.G_MISS_NUM, REFERENCE_SOURCE_ID, p_REFERENCE_SOURCE_ID),
380: REFERENCE_SOURCE_LINE_ID = decode( p_REFERENCE_SOURCE_LINE_ID, FND_API.G_MISS_NUM, REFERENCE_SOURCE_LINE_ID, p_REFERENCE_SOURCE_LINE_ID),
381: REFERENCE_SOURCE_DATE = decode( p_REFERENCE_SOURCE_DATE, FND_API.G_MISS_DATE, REFERENCE_SOURCE_DATE, p_REFERENCE_SOURCE_DATE),
382: CSI_TRANSACTION_ID = decode( p_CSI_TRANSACTION_ID, FND_API.G_MISS_NUM, CSI_TRANSACTION_ID, p_CSI_TRANSACTION_ID),
383: SOURCE_TXN_LINE_DETAIL_ID = decode( p_SOURCE_TXN_LINE_DETAIL_ID, FND_API.G_MISS_NUM, SOURCE_TXN_LINE_DETAIL_ID, p_SOURCE_TXN_LINE_DETAIL_ID),
384: INV_MTL_TRANSACTION_ID = decode( p_INV_MTL_TRANSACTION_ID, FND_API.G_MISS_NUM, INV_MTL_TRANSACTION_ID, p_INV_MTL_TRANSACTION_ID),
385: PROCESSING_STATUS = decode( p_PROCESSING_STATUS, FND_API.G_MISS_CHAR, PROCESSING_STATUS, p_PROCESSING_STATUS),
386: ERROR_CODE = decode( p_ERROR_CODE, FND_API.G_MISS_CHAR, ERROR_CODE, p_ERROR_CODE),
387: ERROR_EXPLANATION = decode( p_ERROR_EXPLANATION, FND_API.G_MISS_CHAR, ERROR_EXPLANATION, p_ERROR_EXPLANATION),
380: REFERENCE_SOURCE_LINE_ID = decode( p_REFERENCE_SOURCE_LINE_ID, FND_API.G_MISS_NUM, REFERENCE_SOURCE_LINE_ID, p_REFERENCE_SOURCE_LINE_ID),
381: REFERENCE_SOURCE_DATE = decode( p_REFERENCE_SOURCE_DATE, FND_API.G_MISS_DATE, REFERENCE_SOURCE_DATE, p_REFERENCE_SOURCE_DATE),
382: CSI_TRANSACTION_ID = decode( p_CSI_TRANSACTION_ID, FND_API.G_MISS_NUM, CSI_TRANSACTION_ID, p_CSI_TRANSACTION_ID),
383: SOURCE_TXN_LINE_DETAIL_ID = decode( p_SOURCE_TXN_LINE_DETAIL_ID, FND_API.G_MISS_NUM, SOURCE_TXN_LINE_DETAIL_ID, p_SOURCE_TXN_LINE_DETAIL_ID),
384: INV_MTL_TRANSACTION_ID = decode( p_INV_MTL_TRANSACTION_ID, FND_API.G_MISS_NUM, INV_MTL_TRANSACTION_ID, p_INV_MTL_TRANSACTION_ID),
385: PROCESSING_STATUS = decode( p_PROCESSING_STATUS, FND_API.G_MISS_CHAR, PROCESSING_STATUS, p_PROCESSING_STATUS),
386: ERROR_CODE = decode( p_ERROR_CODE, FND_API.G_MISS_CHAR, ERROR_CODE, p_ERROR_CODE),
387: ERROR_EXPLANATION = decode( p_ERROR_EXPLANATION, FND_API.G_MISS_CHAR, ERROR_EXPLANATION, p_ERROR_EXPLANATION),
388: CONFIG_INST_HDR_ID = decode( p_CONFIG_INST_HDR_ID , FND_API.G_MISS_NUM, CONFIG_INST_HDR_ID , p_CONFIG_INST_HDR_ID),
381: REFERENCE_SOURCE_DATE = decode( p_REFERENCE_SOURCE_DATE, FND_API.G_MISS_DATE, REFERENCE_SOURCE_DATE, p_REFERENCE_SOURCE_DATE),
382: CSI_TRANSACTION_ID = decode( p_CSI_TRANSACTION_ID, FND_API.G_MISS_NUM, CSI_TRANSACTION_ID, p_CSI_TRANSACTION_ID),
383: SOURCE_TXN_LINE_DETAIL_ID = decode( p_SOURCE_TXN_LINE_DETAIL_ID, FND_API.G_MISS_NUM, SOURCE_TXN_LINE_DETAIL_ID, p_SOURCE_TXN_LINE_DETAIL_ID),
384: INV_MTL_TRANSACTION_ID = decode( p_INV_MTL_TRANSACTION_ID, FND_API.G_MISS_NUM, INV_MTL_TRANSACTION_ID, p_INV_MTL_TRANSACTION_ID),
385: PROCESSING_STATUS = decode( p_PROCESSING_STATUS, FND_API.G_MISS_CHAR, PROCESSING_STATUS, p_PROCESSING_STATUS),
386: ERROR_CODE = decode( p_ERROR_CODE, FND_API.G_MISS_CHAR, ERROR_CODE, p_ERROR_CODE),
387: ERROR_EXPLANATION = decode( p_ERROR_EXPLANATION, FND_API.G_MISS_CHAR, ERROR_EXPLANATION, p_ERROR_EXPLANATION),
388: CONFIG_INST_HDR_ID = decode( p_CONFIG_INST_HDR_ID , FND_API.G_MISS_NUM, CONFIG_INST_HDR_ID , p_CONFIG_INST_HDR_ID),
389: CONFIG_INST_REV_NUM = decode( p_CONFIG_INST_REV_NUM , FND_API.G_MISS_NUM, CONFIG_INST_REV_NUM , p_CONFIG_INST_REV_NUM),
382: CSI_TRANSACTION_ID = decode( p_CSI_TRANSACTION_ID, FND_API.G_MISS_NUM, CSI_TRANSACTION_ID, p_CSI_TRANSACTION_ID),
383: SOURCE_TXN_LINE_DETAIL_ID = decode( p_SOURCE_TXN_LINE_DETAIL_ID, FND_API.G_MISS_NUM, SOURCE_TXN_LINE_DETAIL_ID, p_SOURCE_TXN_LINE_DETAIL_ID),
384: INV_MTL_TRANSACTION_ID = decode( p_INV_MTL_TRANSACTION_ID, FND_API.G_MISS_NUM, INV_MTL_TRANSACTION_ID, p_INV_MTL_TRANSACTION_ID),
385: PROCESSING_STATUS = decode( p_PROCESSING_STATUS, FND_API.G_MISS_CHAR, PROCESSING_STATUS, p_PROCESSING_STATUS),
386: ERROR_CODE = decode( p_ERROR_CODE, FND_API.G_MISS_CHAR, ERROR_CODE, p_ERROR_CODE),
387: ERROR_EXPLANATION = decode( p_ERROR_EXPLANATION, FND_API.G_MISS_CHAR, ERROR_EXPLANATION, p_ERROR_EXPLANATION),
388: CONFIG_INST_HDR_ID = decode( p_CONFIG_INST_HDR_ID , FND_API.G_MISS_NUM, CONFIG_INST_HDR_ID , p_CONFIG_INST_HDR_ID),
389: CONFIG_INST_REV_NUM = decode( p_CONFIG_INST_REV_NUM , FND_API.G_MISS_NUM, CONFIG_INST_REV_NUM , p_CONFIG_INST_REV_NUM),
390: CONFIG_INST_ITEM_ID = decode( p_CONFIG_INST_ITEM_ID , FND_API.G_MISS_NUM, CONFIG_INST_ITEM_ID , p_CONFIG_INST_ITEM_ID),
383: SOURCE_TXN_LINE_DETAIL_ID = decode( p_SOURCE_TXN_LINE_DETAIL_ID, FND_API.G_MISS_NUM, SOURCE_TXN_LINE_DETAIL_ID, p_SOURCE_TXN_LINE_DETAIL_ID),
384: INV_MTL_TRANSACTION_ID = decode( p_INV_MTL_TRANSACTION_ID, FND_API.G_MISS_NUM, INV_MTL_TRANSACTION_ID, p_INV_MTL_TRANSACTION_ID),
385: PROCESSING_STATUS = decode( p_PROCESSING_STATUS, FND_API.G_MISS_CHAR, PROCESSING_STATUS, p_PROCESSING_STATUS),
386: ERROR_CODE = decode( p_ERROR_CODE, FND_API.G_MISS_CHAR, ERROR_CODE, p_ERROR_CODE),
387: ERROR_EXPLANATION = decode( p_ERROR_EXPLANATION, FND_API.G_MISS_CHAR, ERROR_EXPLANATION, p_ERROR_EXPLANATION),
388: CONFIG_INST_HDR_ID = decode( p_CONFIG_INST_HDR_ID , FND_API.G_MISS_NUM, CONFIG_INST_HDR_ID , p_CONFIG_INST_HDR_ID),
389: CONFIG_INST_REV_NUM = decode( p_CONFIG_INST_REV_NUM , FND_API.G_MISS_NUM, CONFIG_INST_REV_NUM , p_CONFIG_INST_REV_NUM),
390: CONFIG_INST_ITEM_ID = decode( p_CONFIG_INST_ITEM_ID , FND_API.G_MISS_NUM, CONFIG_INST_ITEM_ID , p_CONFIG_INST_ITEM_ID),
391: CONFIG_INST_BASELINE_REV_NUM = decode( p_CONFIG_INST_BASELINE_REV_NUM , FND_API.G_MISS_NUM,CONFIG_INST_BASELINE_REV_NUM, p_CONFIG_INST_BASELINE_REV_NUM),
384: INV_MTL_TRANSACTION_ID = decode( p_INV_MTL_TRANSACTION_ID, FND_API.G_MISS_NUM, INV_MTL_TRANSACTION_ID, p_INV_MTL_TRANSACTION_ID),
385: PROCESSING_STATUS = decode( p_PROCESSING_STATUS, FND_API.G_MISS_CHAR, PROCESSING_STATUS, p_PROCESSING_STATUS),
386: ERROR_CODE = decode( p_ERROR_CODE, FND_API.G_MISS_CHAR, ERROR_CODE, p_ERROR_CODE),
387: ERROR_EXPLANATION = decode( p_ERROR_EXPLANATION, FND_API.G_MISS_CHAR, ERROR_EXPLANATION, p_ERROR_EXPLANATION),
388: CONFIG_INST_HDR_ID = decode( p_CONFIG_INST_HDR_ID , FND_API.G_MISS_NUM, CONFIG_INST_HDR_ID , p_CONFIG_INST_HDR_ID),
389: CONFIG_INST_REV_NUM = decode( p_CONFIG_INST_REV_NUM , FND_API.G_MISS_NUM, CONFIG_INST_REV_NUM , p_CONFIG_INST_REV_NUM),
390: CONFIG_INST_ITEM_ID = decode( p_CONFIG_INST_ITEM_ID , FND_API.G_MISS_NUM, CONFIG_INST_ITEM_ID , p_CONFIG_INST_ITEM_ID),
391: CONFIG_INST_BASELINE_REV_NUM = decode( p_CONFIG_INST_BASELINE_REV_NUM , FND_API.G_MISS_NUM,CONFIG_INST_BASELINE_REV_NUM, p_CONFIG_INST_BASELINE_REV_NUM),
392: TARGET_COMMITMENT_DATE = decode( p_TARGET_COMMITMENT_DATE, FND_API.G_MISS_DATE, TARGET_COMMITMENT_DATE , p_TARGET_COMMITMENT_DATE),
385: PROCESSING_STATUS = decode( p_PROCESSING_STATUS, FND_API.G_MISS_CHAR, PROCESSING_STATUS, p_PROCESSING_STATUS),
386: ERROR_CODE = decode( p_ERROR_CODE, FND_API.G_MISS_CHAR, ERROR_CODE, p_ERROR_CODE),
387: ERROR_EXPLANATION = decode( p_ERROR_EXPLANATION, FND_API.G_MISS_CHAR, ERROR_EXPLANATION, p_ERROR_EXPLANATION),
388: CONFIG_INST_HDR_ID = decode( p_CONFIG_INST_HDR_ID , FND_API.G_MISS_NUM, CONFIG_INST_HDR_ID , p_CONFIG_INST_HDR_ID),
389: CONFIG_INST_REV_NUM = decode( p_CONFIG_INST_REV_NUM , FND_API.G_MISS_NUM, CONFIG_INST_REV_NUM , p_CONFIG_INST_REV_NUM),
390: CONFIG_INST_ITEM_ID = decode( p_CONFIG_INST_ITEM_ID , FND_API.G_MISS_NUM, CONFIG_INST_ITEM_ID , p_CONFIG_INST_ITEM_ID),
391: CONFIG_INST_BASELINE_REV_NUM = decode( p_CONFIG_INST_BASELINE_REV_NUM , FND_API.G_MISS_NUM,CONFIG_INST_BASELINE_REV_NUM, p_CONFIG_INST_BASELINE_REV_NUM),
392: TARGET_COMMITMENT_DATE = decode( p_TARGET_COMMITMENT_DATE, FND_API.G_MISS_DATE, TARGET_COMMITMENT_DATE , p_TARGET_COMMITMENT_DATE),
393: INSTANCE_DESCRIPTION = decode( p_INSTANCE_DESCRIPTION, FND_API.G_MISS_CHAR, INSTANCE_DESCRIPTION , p_INSTANCE_DESCRIPTION),
386: ERROR_CODE = decode( p_ERROR_CODE, FND_API.G_MISS_CHAR, ERROR_CODE, p_ERROR_CODE),
387: ERROR_EXPLANATION = decode( p_ERROR_EXPLANATION, FND_API.G_MISS_CHAR, ERROR_EXPLANATION, p_ERROR_EXPLANATION),
388: CONFIG_INST_HDR_ID = decode( p_CONFIG_INST_HDR_ID , FND_API.G_MISS_NUM, CONFIG_INST_HDR_ID , p_CONFIG_INST_HDR_ID),
389: CONFIG_INST_REV_NUM = decode( p_CONFIG_INST_REV_NUM , FND_API.G_MISS_NUM, CONFIG_INST_REV_NUM , p_CONFIG_INST_REV_NUM),
390: CONFIG_INST_ITEM_ID = decode( p_CONFIG_INST_ITEM_ID , FND_API.G_MISS_NUM, CONFIG_INST_ITEM_ID , p_CONFIG_INST_ITEM_ID),
391: CONFIG_INST_BASELINE_REV_NUM = decode( p_CONFIG_INST_BASELINE_REV_NUM , FND_API.G_MISS_NUM,CONFIG_INST_BASELINE_REV_NUM, p_CONFIG_INST_BASELINE_REV_NUM),
392: TARGET_COMMITMENT_DATE = decode( p_TARGET_COMMITMENT_DATE, FND_API.G_MISS_DATE, TARGET_COMMITMENT_DATE , p_TARGET_COMMITMENT_DATE),
393: INSTANCE_DESCRIPTION = decode( p_INSTANCE_DESCRIPTION, FND_API.G_MISS_CHAR, INSTANCE_DESCRIPTION , p_INSTANCE_DESCRIPTION),
394: INSTALL_LOCATION_TYPE_CODE = decode( p_INSTALL_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, INSTALL_LOCATION_TYPE_CODE, p_INSTALL_LOCATION_TYPE_CODE),
387: ERROR_EXPLANATION = decode( p_ERROR_EXPLANATION, FND_API.G_MISS_CHAR, ERROR_EXPLANATION, p_ERROR_EXPLANATION),
388: CONFIG_INST_HDR_ID = decode( p_CONFIG_INST_HDR_ID , FND_API.G_MISS_NUM, CONFIG_INST_HDR_ID , p_CONFIG_INST_HDR_ID),
389: CONFIG_INST_REV_NUM = decode( p_CONFIG_INST_REV_NUM , FND_API.G_MISS_NUM, CONFIG_INST_REV_NUM , p_CONFIG_INST_REV_NUM),
390: CONFIG_INST_ITEM_ID = decode( p_CONFIG_INST_ITEM_ID , FND_API.G_MISS_NUM, CONFIG_INST_ITEM_ID , p_CONFIG_INST_ITEM_ID),
391: CONFIG_INST_BASELINE_REV_NUM = decode( p_CONFIG_INST_BASELINE_REV_NUM , FND_API.G_MISS_NUM,CONFIG_INST_BASELINE_REV_NUM, p_CONFIG_INST_BASELINE_REV_NUM),
392: TARGET_COMMITMENT_DATE = decode( p_TARGET_COMMITMENT_DATE, FND_API.G_MISS_DATE, TARGET_COMMITMENT_DATE , p_TARGET_COMMITMENT_DATE),
393: INSTANCE_DESCRIPTION = decode( p_INSTANCE_DESCRIPTION, FND_API.G_MISS_CHAR, INSTANCE_DESCRIPTION , p_INSTANCE_DESCRIPTION),
394: INSTALL_LOCATION_TYPE_CODE = decode( p_INSTALL_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, INSTALL_LOCATION_TYPE_CODE, p_INSTALL_LOCATION_TYPE_CODE),
395: INSTALL_LOCATION_ID = decode( p_INSTALL_LOCATION_ID, FND_API.G_MISS_NUM, INSTALL_LOCATION_ID, p_INSTALL_LOCATION_ID),
388: CONFIG_INST_HDR_ID = decode( p_CONFIG_INST_HDR_ID , FND_API.G_MISS_NUM, CONFIG_INST_HDR_ID , p_CONFIG_INST_HDR_ID),
389: CONFIG_INST_REV_NUM = decode( p_CONFIG_INST_REV_NUM , FND_API.G_MISS_NUM, CONFIG_INST_REV_NUM , p_CONFIG_INST_REV_NUM),
390: CONFIG_INST_ITEM_ID = decode( p_CONFIG_INST_ITEM_ID , FND_API.G_MISS_NUM, CONFIG_INST_ITEM_ID , p_CONFIG_INST_ITEM_ID),
391: CONFIG_INST_BASELINE_REV_NUM = decode( p_CONFIG_INST_BASELINE_REV_NUM , FND_API.G_MISS_NUM,CONFIG_INST_BASELINE_REV_NUM, p_CONFIG_INST_BASELINE_REV_NUM),
392: TARGET_COMMITMENT_DATE = decode( p_TARGET_COMMITMENT_DATE, FND_API.G_MISS_DATE, TARGET_COMMITMENT_DATE , p_TARGET_COMMITMENT_DATE),
393: INSTANCE_DESCRIPTION = decode( p_INSTANCE_DESCRIPTION, FND_API.G_MISS_CHAR, INSTANCE_DESCRIPTION , p_INSTANCE_DESCRIPTION),
394: INSTALL_LOCATION_TYPE_CODE = decode( p_INSTALL_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, INSTALL_LOCATION_TYPE_CODE, p_INSTALL_LOCATION_TYPE_CODE),
395: INSTALL_LOCATION_ID = decode( p_INSTALL_LOCATION_ID, FND_API.G_MISS_NUM, INSTALL_LOCATION_ID, p_INSTALL_LOCATION_ID),
396: CASCADE_OWNER_FLAG = decode( p_CASCADE_OWNER_FLAG, FND_API.G_MISS_CHAR, CASCADE_OWNER_FLAG, p_CASCADE_OWNER_FLAG),
389: CONFIG_INST_REV_NUM = decode( p_CONFIG_INST_REV_NUM , FND_API.G_MISS_NUM, CONFIG_INST_REV_NUM , p_CONFIG_INST_REV_NUM),
390: CONFIG_INST_ITEM_ID = decode( p_CONFIG_INST_ITEM_ID , FND_API.G_MISS_NUM, CONFIG_INST_ITEM_ID , p_CONFIG_INST_ITEM_ID),
391: CONFIG_INST_BASELINE_REV_NUM = decode( p_CONFIG_INST_BASELINE_REV_NUM , FND_API.G_MISS_NUM,CONFIG_INST_BASELINE_REV_NUM, p_CONFIG_INST_BASELINE_REV_NUM),
392: TARGET_COMMITMENT_DATE = decode( p_TARGET_COMMITMENT_DATE, FND_API.G_MISS_DATE, TARGET_COMMITMENT_DATE , p_TARGET_COMMITMENT_DATE),
393: INSTANCE_DESCRIPTION = decode( p_INSTANCE_DESCRIPTION, FND_API.G_MISS_CHAR, INSTANCE_DESCRIPTION , p_INSTANCE_DESCRIPTION),
394: INSTALL_LOCATION_TYPE_CODE = decode( p_INSTALL_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, INSTALL_LOCATION_TYPE_CODE, p_INSTALL_LOCATION_TYPE_CODE),
395: INSTALL_LOCATION_ID = decode( p_INSTALL_LOCATION_ID, FND_API.G_MISS_NUM, INSTALL_LOCATION_ID, p_INSTALL_LOCATION_ID),
396: CASCADE_OWNER_FLAG = decode( p_CASCADE_OWNER_FLAG, FND_API.G_MISS_CHAR, CASCADE_OWNER_FLAG, p_CASCADE_OWNER_FLAG),
397: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
390: CONFIG_INST_ITEM_ID = decode( p_CONFIG_INST_ITEM_ID , FND_API.G_MISS_NUM, CONFIG_INST_ITEM_ID , p_CONFIG_INST_ITEM_ID),
391: CONFIG_INST_BASELINE_REV_NUM = decode( p_CONFIG_INST_BASELINE_REV_NUM , FND_API.G_MISS_NUM,CONFIG_INST_BASELINE_REV_NUM, p_CONFIG_INST_BASELINE_REV_NUM),
392: TARGET_COMMITMENT_DATE = decode( p_TARGET_COMMITMENT_DATE, FND_API.G_MISS_DATE, TARGET_COMMITMENT_DATE , p_TARGET_COMMITMENT_DATE),
393: INSTANCE_DESCRIPTION = decode( p_INSTANCE_DESCRIPTION, FND_API.G_MISS_CHAR, INSTANCE_DESCRIPTION , p_INSTANCE_DESCRIPTION),
394: INSTALL_LOCATION_TYPE_CODE = decode( p_INSTALL_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, INSTALL_LOCATION_TYPE_CODE, p_INSTALL_LOCATION_TYPE_CODE),
395: INSTALL_LOCATION_ID = decode( p_INSTALL_LOCATION_ID, FND_API.G_MISS_NUM, INSTALL_LOCATION_ID, p_INSTALL_LOCATION_ID),
396: CASCADE_OWNER_FLAG = decode( p_CASCADE_OWNER_FLAG, FND_API.G_MISS_CHAR, CASCADE_OWNER_FLAG, p_CASCADE_OWNER_FLAG),
397: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
398: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
391: CONFIG_INST_BASELINE_REV_NUM = decode( p_CONFIG_INST_BASELINE_REV_NUM , FND_API.G_MISS_NUM,CONFIG_INST_BASELINE_REV_NUM, p_CONFIG_INST_BASELINE_REV_NUM),
392: TARGET_COMMITMENT_DATE = decode( p_TARGET_COMMITMENT_DATE, FND_API.G_MISS_DATE, TARGET_COMMITMENT_DATE , p_TARGET_COMMITMENT_DATE),
393: INSTANCE_DESCRIPTION = decode( p_INSTANCE_DESCRIPTION, FND_API.G_MISS_CHAR, INSTANCE_DESCRIPTION , p_INSTANCE_DESCRIPTION),
394: INSTALL_LOCATION_TYPE_CODE = decode( p_INSTALL_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, INSTALL_LOCATION_TYPE_CODE, p_INSTALL_LOCATION_TYPE_CODE),
395: INSTALL_LOCATION_ID = decode( p_INSTALL_LOCATION_ID, FND_API.G_MISS_NUM, INSTALL_LOCATION_ID, p_INSTALL_LOCATION_ID),
396: CASCADE_OWNER_FLAG = decode( p_CASCADE_OWNER_FLAG, FND_API.G_MISS_CHAR, CASCADE_OWNER_FLAG, p_CASCADE_OWNER_FLAG),
397: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
398: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
399: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
392: TARGET_COMMITMENT_DATE = decode( p_TARGET_COMMITMENT_DATE, FND_API.G_MISS_DATE, TARGET_COMMITMENT_DATE , p_TARGET_COMMITMENT_DATE),
393: INSTANCE_DESCRIPTION = decode( p_INSTANCE_DESCRIPTION, FND_API.G_MISS_CHAR, INSTANCE_DESCRIPTION , p_INSTANCE_DESCRIPTION),
394: INSTALL_LOCATION_TYPE_CODE = decode( p_INSTALL_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, INSTALL_LOCATION_TYPE_CODE, p_INSTALL_LOCATION_TYPE_CODE),
395: INSTALL_LOCATION_ID = decode( p_INSTALL_LOCATION_ID, FND_API.G_MISS_NUM, INSTALL_LOCATION_ID, p_INSTALL_LOCATION_ID),
396: CASCADE_OWNER_FLAG = decode( p_CASCADE_OWNER_FLAG, FND_API.G_MISS_CHAR, CASCADE_OWNER_FLAG, p_CASCADE_OWNER_FLAG),
397: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
398: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
399: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
400: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
393: INSTANCE_DESCRIPTION = decode( p_INSTANCE_DESCRIPTION, FND_API.G_MISS_CHAR, INSTANCE_DESCRIPTION , p_INSTANCE_DESCRIPTION),
394: INSTALL_LOCATION_TYPE_CODE = decode( p_INSTALL_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, INSTALL_LOCATION_TYPE_CODE, p_INSTALL_LOCATION_TYPE_CODE),
395: INSTALL_LOCATION_ID = decode( p_INSTALL_LOCATION_ID, FND_API.G_MISS_NUM, INSTALL_LOCATION_ID, p_INSTALL_LOCATION_ID),
396: CASCADE_OWNER_FLAG = decode( p_CASCADE_OWNER_FLAG, FND_API.G_MISS_CHAR, CASCADE_OWNER_FLAG, p_CASCADE_OWNER_FLAG),
397: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
398: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
399: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
400: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
401: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
394: INSTALL_LOCATION_TYPE_CODE = decode( p_INSTALL_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, INSTALL_LOCATION_TYPE_CODE, p_INSTALL_LOCATION_TYPE_CODE),
395: INSTALL_LOCATION_ID = decode( p_INSTALL_LOCATION_ID, FND_API.G_MISS_NUM, INSTALL_LOCATION_ID, p_INSTALL_LOCATION_ID),
396: CASCADE_OWNER_FLAG = decode( p_CASCADE_OWNER_FLAG, FND_API.G_MISS_CHAR, CASCADE_OWNER_FLAG, p_CASCADE_OWNER_FLAG),
397: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
398: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
399: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
400: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
401: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
402: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
395: INSTALL_LOCATION_ID = decode( p_INSTALL_LOCATION_ID, FND_API.G_MISS_NUM, INSTALL_LOCATION_ID, p_INSTALL_LOCATION_ID),
396: CASCADE_OWNER_FLAG = decode( p_CASCADE_OWNER_FLAG, FND_API.G_MISS_CHAR, CASCADE_OWNER_FLAG, p_CASCADE_OWNER_FLAG),
397: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
398: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
399: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
400: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
401: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
402: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
403: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
396: CASCADE_OWNER_FLAG = decode( p_CASCADE_OWNER_FLAG, FND_API.G_MISS_CHAR, CASCADE_OWNER_FLAG, p_CASCADE_OWNER_FLAG),
397: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
398: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
399: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
400: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
401: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
402: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
403: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
404: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
397: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
398: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
399: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
400: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
401: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
402: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
403: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
404: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
405: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
398: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
399: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
400: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
401: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
402: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
403: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
404: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
405: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
406: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
399: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
400: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
401: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
402: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
403: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
404: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
405: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
406: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
407: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
400: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
401: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
402: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
403: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
404: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
405: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
406: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
407: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
408: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
401: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
402: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
403: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
404: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
405: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
406: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
407: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
408: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
409: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
402: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
403: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
404: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
405: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
406: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
407: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
408: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
409: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
410: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
403: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
404: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
405: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
406: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
407: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
408: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
409: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
410: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
411: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
404: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
405: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
406: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
407: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
408: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
409: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
410: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
411: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
412: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
405: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
406: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
407: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
408: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
409: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
410: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
411: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
412: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
413: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
406: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
407: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
408: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
409: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
410: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
411: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
412: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
413: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
414: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
407: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
408: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
409: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
410: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
411: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
412: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
413: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
414: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
415: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
408: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
409: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
410: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
411: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
412: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
413: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
414: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
415: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
416: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
409: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
410: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
411: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
412: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
413: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
414: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
415: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
416: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
417: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),
410: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
411: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
412: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
413: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
414: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
415: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
416: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
417: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),
418: CONTEXT = decode( p_CONTEXT, FND_API.G_MISS_CHAR, CONTEXT, p_CONTEXT),
411: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
412: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
413: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
414: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
415: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
416: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
417: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),
418: CONTEXT = decode( p_CONTEXT, FND_API.G_MISS_CHAR, CONTEXT, p_CONTEXT),
419: INSTANCE_STATUS_ID = decode( p_INSTANCE_STATUS_ID, FND_API.G_MISS_NUM, INSTANCE_STATUS_ID, p_INSTANCE_STATUS_ID),
412: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
413: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
414: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
415: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
416: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
417: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),
418: CONTEXT = decode( p_CONTEXT, FND_API.G_MISS_CHAR, CONTEXT, p_CONTEXT),
419: INSTANCE_STATUS_ID = decode( p_INSTANCE_STATUS_ID, FND_API.G_MISS_NUM, INSTANCE_STATUS_ID, p_INSTANCE_STATUS_ID),
420: PARENT_INSTANCE_ID = decode( p_PARENT_INSTANCE_ID, FND_API.G_MISS_NUM, PARENT_INSTANCE_ID, p_PARENT_INSTANCE_ID),
413: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
414: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
415: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
416: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
417: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),
418: CONTEXT = decode( p_CONTEXT, FND_API.G_MISS_CHAR, CONTEXT, p_CONTEXT),
419: INSTANCE_STATUS_ID = decode( p_INSTANCE_STATUS_ID, FND_API.G_MISS_NUM, INSTANCE_STATUS_ID, p_INSTANCE_STATUS_ID),
420: PARENT_INSTANCE_ID = decode( p_PARENT_INSTANCE_ID, FND_API.G_MISS_NUM, PARENT_INSTANCE_ID, p_PARENT_INSTANCE_ID),
421: ASSC_TXN_LINE_DETAIL_ID = decode( p_ASSC_TXN_LINE_DETAIL_ID, FND_API.G_MISS_NUM, ASSC_TXN_LINE_DETAIL_ID, p_ASSC_TXN_LINE_DETAIL_ID),
414: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
415: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
416: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
417: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),
418: CONTEXT = decode( p_CONTEXT, FND_API.G_MISS_CHAR, CONTEXT, p_CONTEXT),
419: INSTANCE_STATUS_ID = decode( p_INSTANCE_STATUS_ID, FND_API.G_MISS_NUM, INSTANCE_STATUS_ID, p_INSTANCE_STATUS_ID),
420: PARENT_INSTANCE_ID = decode( p_PARENT_INSTANCE_ID, FND_API.G_MISS_NUM, PARENT_INSTANCE_ID, p_PARENT_INSTANCE_ID),
421: ASSC_TXN_LINE_DETAIL_ID = decode( p_ASSC_TXN_LINE_DETAIL_ID, FND_API.G_MISS_NUM, ASSC_TXN_LINE_DETAIL_ID, p_ASSC_TXN_LINE_DETAIL_ID),
422: OVERRIDING_CSI_TXN_ID = decode( p_OVERRIDING_CSI_TXN_ID, FND_API.G_MISS_NUM, OVERRIDING_CSI_TXN_ID, p_OVERRIDING_CSI_TXN_ID)
415: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
416: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
417: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),
418: CONTEXT = decode( p_CONTEXT, FND_API.G_MISS_CHAR, CONTEXT, p_CONTEXT),
419: INSTANCE_STATUS_ID = decode( p_INSTANCE_STATUS_ID, FND_API.G_MISS_NUM, INSTANCE_STATUS_ID, p_INSTANCE_STATUS_ID),
420: PARENT_INSTANCE_ID = decode( p_PARENT_INSTANCE_ID, FND_API.G_MISS_NUM, PARENT_INSTANCE_ID, p_PARENT_INSTANCE_ID),
421: ASSC_TXN_LINE_DETAIL_ID = decode( p_ASSC_TXN_LINE_DETAIL_ID, FND_API.G_MISS_NUM, ASSC_TXN_LINE_DETAIL_ID, p_ASSC_TXN_LINE_DETAIL_ID),
422: OVERRIDING_CSI_TXN_ID = decode( p_OVERRIDING_CSI_TXN_ID, FND_API.G_MISS_NUM, OVERRIDING_CSI_TXN_ID, p_OVERRIDING_CSI_TXN_ID)
423: where TXN_LINE_DETAIL_ID = p_TXN_LINE_DETAIL_ID;
416: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
417: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),
418: CONTEXT = decode( p_CONTEXT, FND_API.G_MISS_CHAR, CONTEXT, p_CONTEXT),
419: INSTANCE_STATUS_ID = decode( p_INSTANCE_STATUS_ID, FND_API.G_MISS_NUM, INSTANCE_STATUS_ID, p_INSTANCE_STATUS_ID),
420: PARENT_INSTANCE_ID = decode( p_PARENT_INSTANCE_ID, FND_API.G_MISS_NUM, PARENT_INSTANCE_ID, p_PARENT_INSTANCE_ID),
421: ASSC_TXN_LINE_DETAIL_ID = decode( p_ASSC_TXN_LINE_DETAIL_ID, FND_API.G_MISS_NUM, ASSC_TXN_LINE_DETAIL_ID, p_ASSC_TXN_LINE_DETAIL_ID),
422: OVERRIDING_CSI_TXN_ID = decode( p_OVERRIDING_CSI_TXN_ID, FND_API.G_MISS_NUM, OVERRIDING_CSI_TXN_ID, p_OVERRIDING_CSI_TXN_ID)
423: where TXN_LINE_DETAIL_ID = p_TXN_LINE_DETAIL_ID;
424:
417: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),
418: CONTEXT = decode( p_CONTEXT, FND_API.G_MISS_CHAR, CONTEXT, p_CONTEXT),
419: INSTANCE_STATUS_ID = decode( p_INSTANCE_STATUS_ID, FND_API.G_MISS_NUM, INSTANCE_STATUS_ID, p_INSTANCE_STATUS_ID),
420: PARENT_INSTANCE_ID = decode( p_PARENT_INSTANCE_ID, FND_API.G_MISS_NUM, PARENT_INSTANCE_ID, p_PARENT_INSTANCE_ID),
421: ASSC_TXN_LINE_DETAIL_ID = decode( p_ASSC_TXN_LINE_DETAIL_ID, FND_API.G_MISS_NUM, ASSC_TXN_LINE_DETAIL_ID, p_ASSC_TXN_LINE_DETAIL_ID),
422: OVERRIDING_CSI_TXN_ID = decode( p_OVERRIDING_CSI_TXN_ID, FND_API.G_MISS_NUM, OVERRIDING_CSI_TXN_ID, p_OVERRIDING_CSI_TXN_ID)
423: where TXN_LINE_DETAIL_ID = p_TXN_LINE_DETAIL_ID;
424:
425: If (SQL%NOTFOUND) then
418: CONTEXT = decode( p_CONTEXT, FND_API.G_MISS_CHAR, CONTEXT, p_CONTEXT),
419: INSTANCE_STATUS_ID = decode( p_INSTANCE_STATUS_ID, FND_API.G_MISS_NUM, INSTANCE_STATUS_ID, p_INSTANCE_STATUS_ID),
420: PARENT_INSTANCE_ID = decode( p_PARENT_INSTANCE_ID, FND_API.G_MISS_NUM, PARENT_INSTANCE_ID, p_PARENT_INSTANCE_ID),
421: ASSC_TXN_LINE_DETAIL_ID = decode( p_ASSC_TXN_LINE_DETAIL_ID, FND_API.G_MISS_NUM, ASSC_TXN_LINE_DETAIL_ID, p_ASSC_TXN_LINE_DETAIL_ID),
422: OVERRIDING_CSI_TXN_ID = decode( p_OVERRIDING_CSI_TXN_ID, FND_API.G_MISS_NUM, OVERRIDING_CSI_TXN_ID, p_OVERRIDING_CSI_TXN_ID)
423: where TXN_LINE_DETAIL_ID = p_TXN_LINE_DETAIL_ID;
424:
425: If (SQL%NOTFOUND) then
426: RAISE NO_DATA_FOUND;