[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Row(
px_INSTANCE_HISTORY_ID IN OUT NOCOPY NUMBER,
p_INSTANCE_ID NUMBER,
p_TRANSACTION_ID NUMBER,
p_OLD_INSTANCE_NUMBER VARCHAR2,
p_NEW_INSTANCE_NUMBER VARCHAR2,
p_OLD_EXTERNAL_REFERENCE VARCHAR2,
p_NEW_EXTERNAL_REFERENCE VARCHAR2,
p_OLD_INVENTORY_ITEM_ID NUMBER,
p_NEW_INVENTORY_ITEM_ID NUMBER,
p_OLD_INVENTORY_REVISION VARCHAR2,
p_NEW_INVENTORY_REVISION VARCHAR2,
p_OLD_INV_MASTER_ORGZN_ID NUMBER,
p_NEW_INV_MASTER_ORGZN_ID NUMBER,
p_OLD_SERIAL_NUMBER VARCHAR2,
p_NEW_SERIAL_NUMBER VARCHAR2 ,
p_OLD_MFG_SERIAL_NUMBER_FLAG VARCHAR2,
p_NEW_MFG_SERIAL_NUMBER_FLAG VARCHAR2,
p_OLD_LOT_NUMBER VARCHAR2,
p_NEW_LOT_NUMBER VARCHAR2,
p_OLD_QUANTITY NUMBER,
p_NEW_QUANTITY NUMBER,
p_OLD_UNIT_OF_MEASURE VARCHAR2,
p_NEW_UNIT_OF_MEASURE VARCHAR2,
p_OLD_ACCOUNTING_CLASS_CODE VARCHAR2,
p_NEW_ACCOUNTING_CLASS_CODE VARCHAR2,
p_OLD_INSTANCE_CONDITION_ID NUMBER,
p_NEW_INSTANCE_CONDITION_ID NUMBER,
p_OLD_INSTANCE_STATUS_ID NUMBER,
p_NEW_INSTANCE_STATUS_ID NUMBER,
p_OLD_CUSTOMER_VIEW_FLAG VARCHAR2,
p_NEW_CUSTOMER_VIEW_FLAG VARCHAR2,
p_OLD_MERCHANT_VIEW_FLAG VARCHAR2,
p_NEW_MERCHANT_VIEW_FLAG VARCHAR2,
p_OLD_SELLABLE_FLAG VARCHAR2,
p_NEW_SELLABLE_FLAG VARCHAR2,
p_OLD_SYSTEM_ID NUMBER,
p_NEW_SYSTEM_ID NUMBER,
p_OLD_INSTANCE_TYPE_CODE VARCHAR2,
p_NEW_INSTANCE_TYPE_CODE VARCHAR2,
p_OLD_ACTIVE_START_DATE DATE,
p_NEW_ACTIVE_START_DATE DATE,
p_OLD_ACTIVE_END_DATE DATE,
p_NEW_ACTIVE_END_DATE DATE,
p_OLD_LOCATION_TYPE_CODE VARCHAR2,
p_NEW_LOCATION_TYPE_CODE VARCHAR2,
p_OLD_LOCATION_ID NUMBER,
p_NEW_LOCATION_ID NUMBER,
p_OLD_INV_ORGANIZATION_ID NUMBER,
p_NEW_INV_ORGANIZATION_ID NUMBER,
p_OLD_INV_SUBINVENTORY_NAME VARCHAR2,
p_NEW_INV_SUBINVENTORY_NAME VARCHAR2,
p_OLD_INV_LOCATOR_ID NUMBER,
p_NEW_INV_LOCATOR_ID NUMBER,
p_OLD_PA_PROJECT_ID NUMBER,
p_NEW_PA_PROJECT_ID NUMBER,
p_OLD_PA_PROJECT_TASK_ID NUMBER,
p_NEW_PA_PROJECT_TASK_ID NUMBER,
p_OLD_IN_TRANSIT_ORDER_LINE_ID NUMBER,
p_NEW_IN_TRANSIT_ORDER_LINE_ID NUMBER,
p_OLD_WIP_JOB_ID NUMBER,
p_NEW_WIP_JOB_ID NUMBER,
p_OLD_PO_ORDER_LINE_ID NUMBER,
p_NEW_PO_ORDER_LINE_ID NUMBER,
p_OLD_COMPLETENESS_FLAG VARCHAR2,
p_NEW_COMPLETENESS_FLAG VARCHAR2,
p_FULL_DUMP_FLAG VARCHAR2,
p_OLD_CONTEXT VARCHAR2,
p_NEW_CONTEXT VARCHAR2,
p_OLD_ATTRIBUTE1 VARCHAR2,
p_NEW_ATTRIBUTE1 VARCHAR2,
p_OLD_ATTRIBUTE2 VARCHAR2,
p_NEW_ATTRIBUTE2 VARCHAR2,
p_OLD_ATTRIBUTE3 VARCHAR2,
p_NEW_ATTRIBUTE3 VARCHAR2,
p_OLD_ATTRIBUTE4 VARCHAR2,
p_NEW_ATTRIBUTE4 VARCHAR2,
p_OLD_ATTRIBUTE5 VARCHAR2,
p_NEW_ATTRIBUTE5 VARCHAR2,
p_OLD_ATTRIBUTE6 VARCHAR2,
p_NEW_ATTRIBUTE6 VARCHAR2,
p_OLD_ATTRIBUTE7 VARCHAR2,
p_NEW_ATTRIBUTE7 VARCHAR2,
p_OLD_ATTRIBUTE8 VARCHAR2,
p_NEW_ATTRIBUTE8 VARCHAR2,
p_OLD_ATTRIBUTE9 VARCHAR2,
p_NEW_ATTRIBUTE9 VARCHAR2,
p_OLD_ATTRIBUTE10 VARCHAR2,
p_NEW_ATTRIBUTE10 VARCHAR2,
p_OLD_ATTRIBUTE11 VARCHAR2,
p_NEW_ATTRIBUTE11 VARCHAR2,
p_OLD_ATTRIBUTE12 VARCHAR2,
p_NEW_ATTRIBUTE12 VARCHAR2,
p_OLD_ATTRIBUTE13 VARCHAR2,
p_NEW_ATTRIBUTE13 VARCHAR2,
p_OLD_ATTRIBUTE14 VARCHAR2,
p_NEW_ATTRIBUTE14 VARCHAR2,
p_OLD_ATTRIBUTE15 VARCHAR2,
p_NEW_ATTRIBUTE15 VARCHAR2,
p_CREATED_BY NUMBER,
p_CREATION_DATE DATE,
p_LAST_UPDATED_BY NUMBER,
p_LAST_UPDATE_DATE DATE,
p_LAST_UPDATE_LOGIN NUMBER,
p_OBJECT_VERSION_NUMBER NUMBER,
p_OLD_INST_LOC_TYPE_CODE VARCHAR2,
p_NEW_INST_LOC_TYPE_CODE VARCHAR2,
p_OLD_INST_LOC_ID NUMBER,
p_NEW_INST_LOC_ID NUMBER,
p_OLD_INST_USAGE_CODE VARCHAR2,
p_NEW_INST_USAGE_CODE VARCHAR2,
p_OLD_last_vld_organization_id NUMBER :=fnd_api.g_miss_num,
p_NEW_last_vld_organization_id NUMBER :=fnd_api.g_miss_num,
p_OLD_CONFIG_INST_REV_NUM NUMBER,
p_NEW_CONFIG_INST_REV_NUM NUMBER,
p_OLD_CONFIG_VALID_STATUS VARCHAR2,
p_NEW_CONFIG_VALID_STATUS VARCHAR2,
p_OLD_INSTANCE_DESCRIPTION VARCHAR2,
p_NEW_INSTANCE_DESCRIPTION VARCHAR2,
p_OLD_INSTALL_DATE DATE,
p_NEW_INSTALL_DATE DATE,
p_OLD_RETURN_BY_DATE DATE,
p_NEW_RETURN_BY_DATE DATE,
p_OLD_ACTUAL_RETURN_DATE DATE,
p_NEW_ACTUAL_RETURN_DATE DATE,
p_OLD_LAST_OE_AGREEMENT_ID NUMBER,
p_NEW_LAST_OE_AGREEMENT_ID NUMBER,
p_OLD_LAST_OE_ORDER_LINE_ID NUMBER ,
p_NEW_LAST_OE_ORDER_LINE_ID NUMBER ,
p_OLD_LAST_OE_RMA_LINE_ID NUMBER ,
p_NEW_LAST_OE_RMA_LINE_ID NUMBER ,
p_OLD_LAST_WIP_JOB_ID NUMBER ,
p_NEW_LAST_WIP_JOB_ID NUMBER ,
p_OLD_LAST_PO_PO_LINE_ID NUMBER ,
p_NEW_LAST_PO_PO_LINE_ID NUMBER ,
p_OLD_LAST_PA_PROJECT_ID NUMBER ,
p_NEW_LAST_PA_PROJECT_ID NUMBER ,
p_OLD_LAST_PA_TASK_ID NUMBER ,
p_NEW_LAST_PA_TASK_ID NUMBER ,
p_OLD_LAST_TXN_LINE_DETAIL_ID NUMBER ,
p_NEW_LAST_TXN_LINE_DETAIL_ID NUMBER ,
p_OLD_LAST_OE_PO_NUMBER VARCHAR2,
p_NEW_LAST_OE_PO_NUMBER VARCHAR2,
--start of eam integration changes--
p_OLD_NETWORK_ASSET_FLAG VARCHAR2,
p_NEW_NETWORK_ASSET_FLAG VARCHAR2,
p_OLD_MAINTAINABLE_FLAG VARCHAR2,
p_NEW_MAINTAINABLE_FLAG VARCHAR2,
p_OLD_PN_LOCATION_ID NUMBER,
p_NEW_PN_LOCATION_ID NUMBER,
p_OLD_ASSET_CRITICALITY_CODE VARCHAR2,
p_NEW_ASSET_CRITICALITY_CODE VARCHAR2,
p_OLD_CATEGORY_ID NUMBER,
p_NEW_CATEGORY_ID NUMBER,
p_OLD_EQUIPMENT_GEN_OBJECT_ID NUMBER,
p_NEW_EQUIPMENT_GEN_OBJECT_ID NUMBER,
p_OLD_INSTANTIATION_FLAG VARCHAR2,
p_NEW_INSTANTIATION_FLAG VARCHAR2,
p_OLD_LINEAR_LOCATION_ID NUMBER,
p_NEW_LINEAR_LOCATION_ID NUMBER,
p_OLD_OPERATIONAL_LOG_FLAG VARCHAR2,
p_NEW_OPERATIONAL_LOG_FLAG VARCHAR2,
p_OLD_CHECKIN_STATUS NUMBER,
p_NEW_CHECKIN_STATUS NUMBER,
p_OLD_SUP_WARRANTY_EXP_DATE DATE,
p_NEW_SUP_WARRANTY_EXP_DATE DATE,
p_OLD_ATTRIBUTE16 VARCHAR2,
p_NEW_ATTRIBUTE16 VARCHAR2,
p_OLD_ATTRIBUTE17 VARCHAR2,
p_NEW_ATTRIBUTE17 VARCHAR2,
p_OLD_ATTRIBUTE18 VARCHAR2,
p_NEW_ATTRIBUTE18 VARCHAR2,
p_OLD_ATTRIBUTE19 VARCHAR2,
p_NEW_ATTRIBUTE19 VARCHAR2,
p_OLD_ATTRIBUTE20 VARCHAR2,
p_NEW_ATTRIBUTE20 VARCHAR2,
p_OLD_ATTRIBUTE21 VARCHAR2,
p_NEW_ATTRIBUTE21 VARCHAR2,
p_OLD_ATTRIBUTE22 VARCHAR2,
p_NEW_ATTRIBUTE22 VARCHAR2,
p_OLD_ATTRIBUTE23 VARCHAR2,
p_NEW_ATTRIBUTE23 VARCHAR2,
p_OLD_ATTRIBUTE24 VARCHAR2,
p_NEW_ATTRIBUTE24 VARCHAR2,
p_OLD_ATTRIBUTE25 VARCHAR2,
p_NEW_ATTRIBUTE25 VARCHAR2,
p_OLD_ATTRIBUTE26 VARCHAR2,
p_NEW_ATTRIBUTE26 VARCHAR2,
p_OLD_ATTRIBUTE27 VARCHAR2,
p_NEW_ATTRIBUTE27 VARCHAR2,
p_OLD_ATTRIBUTE28 VARCHAR2,
p_NEW_ATTRIBUTE28 VARCHAR2,
p_OLD_ATTRIBUTE29 VARCHAR2,
p_NEW_ATTRIBUTE29 VARCHAR2,
p_OLD_ATTRIBUTE30 VARCHAR2,
p_NEW_ATTRIBUTE30 VARCHAR2,
--end of eam integration changes--
-- Addition of columns for FA Integration
p_OLD_PAYABLES_UNIT_PRICE NUMBER,
p_NEW_PAYABLES_UNIT_PRICE NUMBER,
p_OLD_PAYABLES_CURRENCY_CODE VARCHAR2,
p_NEW_PAYABLES_CURRENCY_CODE VARCHAR2,
p_OLD_PURCHASE_UNIT_PRICE NUMBER,
p_NEW_PURCHASE_UNIT_PRICE NUMBER,
p_OLD_PURCHASE_CURRENCY_CODE VARCHAR2,
p_NEW_PURCHASE_CURRENCY_CODE VARCHAR2,
p_OLD_SALES_UNIT_PRICE NUMBER,
p_NEW_SALES_UNIT_PRICE NUMBER,
p_OLD_SALES_CURRENCY_CODE VARCHAR2,
p_NEW_SALES_CURRENCY_CODE VARCHAR2,
p_OLD_OPERATIONAL_STATUS_CODE VARCHAR2,
p_NEW_OPERATIONAL_STATUS_CODE VARCHAR2,
-- End addition of columns for FA Integration
-- Begin Add Code for Siebel Genesis Project
p_OLD_SOURCE_CODE VARCHAR2,
p_NEW_SOURCE_CODE VARCHAR2
-- End Add Code for Siebel Genesis Project
)
IS
CURSOR C2 IS SELECT CSI_ITEM_INSTANCES_H_S.NEXTVAL FROM sys.dual;
INSERT INTO CSI_ITEM_INSTANCES_H(
INSTANCE_HISTORY_ID,
INSTANCE_ID,
TRANSACTION_ID,
OLD_INSTANCE_NUMBER,
NEW_INSTANCE_NUMBER,
OLD_EXTERNAL_REFERENCE,
NEW_EXTERNAL_REFERENCE,
OLD_INVENTORY_ITEM_ID,
NEW_INVENTORY_ITEM_ID,
OLD_INVENTORY_REVISION,
NEW_INVENTORY_REVISION,
OLD_INV_MASTER_ORGANIZATION_ID,
NEW_INV_MASTER_ORGANIZATION_ID,
OLD_SERIAL_NUMBER,
NEW_SERIAL_NUMBER ,
OLD_MFG_SERIAL_NUMBER_FLAG,
NEW_MFG_SERIAL_NUMBER_FLAG,
OLD_LOT_NUMBER,
NEW_LOT_NUMBER,
OLD_QUANTITY,
NEW_QUANTITY,
OLD_UNIT_OF_MEASURE,
NEW_UNIT_OF_MEASURE,
OLD_ACCOUNTING_CLASS_CODE,
NEW_ACCOUNTING_CLASS_CODE,
OLD_INSTANCE_CONDITION_ID,
NEW_INSTANCE_CONDITION_ID,
OLD_INSTANCE_STATUS_ID,
NEW_INSTANCE_STATUS_ID,
OLD_CUSTOMER_VIEW_FLAG,
NEW_CUSTOMER_VIEW_FLAG,
OLD_MERCHANT_VIEW_FLAG,
NEW_MERCHANT_VIEW_FLAG,
OLD_SELLABLE_FLAG,
NEW_SELLABLE_FLAG,
OLD_SYSTEM_ID,
NEW_SYSTEM_ID,
OLD_INSTANCE_TYPE_CODE,
NEW_INSTANCE_TYPE_CODE,
OLD_ACTIVE_START_DATE,
NEW_ACTIVE_START_DATE,
OLD_ACTIVE_END_DATE,
NEW_ACTIVE_END_DATE,
OLD_LOCATION_TYPE_CODE,
NEW_LOCATION_TYPE_CODE,
OLD_LOCATION_ID,
NEW_LOCATION_ID,
OLD_INV_ORGANIZATION_ID,
NEW_INV_ORGANIZATION_ID,
OLD_INV_SUBINVENTORY_NAME,
NEW_INV_SUBINVENTORY_NAME,
OLD_INV_LOCATOR_ID,
NEW_INV_LOCATOR_ID,
OLD_PA_PROJECT_ID,
NEW_PA_PROJECT_ID,
OLD_PA_PROJECT_TASK_ID,
NEW_PA_PROJECT_TASK_ID,
OLD_IN_TRANSIT_ORDER_LINE_ID,
NEW_IN_TRANSIT_ORDER_LINE_ID,
OLD_WIP_JOB_ID,
NEW_WIP_JOB_ID,
OLD_PO_ORDER_LINE_ID,
NEW_PO_ORDER_LINE_ID,
OLD_COMPLETENESS_FLAG,
NEW_COMPLETENESS_FLAG,
FULL_DUMP_FLAG,
OLD_CONTEXT,
NEW_CONTEXT,
OLD_ATTRIBUTE1,
NEW_ATTRIBUTE1,
OLD_ATTRIBUTE2,
NEW_ATTRIBUTE2,
OLD_ATTRIBUTE3,
NEW_ATTRIBUTE3,
OLD_ATTRIBUTE4,
NEW_ATTRIBUTE4,
OLD_ATTRIBUTE5,
NEW_ATTRIBUTE5,
OLD_ATTRIBUTE6,
NEW_ATTRIBUTE6,
OLD_ATTRIBUTE7,
NEW_ATTRIBUTE7,
OLD_ATTRIBUTE8,
NEW_ATTRIBUTE8,
OLD_ATTRIBUTE9,
NEW_ATTRIBUTE9,
OLD_ATTRIBUTE10,
NEW_ATTRIBUTE10,
OLD_ATTRIBUTE11,
NEW_ATTRIBUTE11,
OLD_ATTRIBUTE12,
NEW_ATTRIBUTE12,
OLD_ATTRIBUTE13,
NEW_ATTRIBUTE13,
OLD_ATTRIBUTE14,
NEW_ATTRIBUTE14,
OLD_ATTRIBUTE15,
NEW_ATTRIBUTE15,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
OBJECT_VERSION_NUMBER,
OLD_INST_LOC_TYPE_CODE,
NEW_INST_LOC_TYPE_CODE,
OLD_INST_LOC_ID,
NEW_INST_LOC_ID,
OLD_INST_USAGE_CODE,
NEW_INST_USAGE_CODE,
OLD_last_vld_organization_id,
NEW_last_vld_organization_id,
OLD_CONFIG_INST_REV_NUM ,
NEW_CONFIG_INST_REV_NUM ,
OLD_CONFIG_VALID_STATUS ,
NEW_CONFIG_VALID_STATUS ,
OLD_INSTANCE_DESCRIPTION ,
NEW_INSTANCE_DESCRIPTION ,
OLD_INSTALL_DATE ,
NEW_INSTALL_DATE ,
OLD_RETURN_BY_DATE ,
NEW_RETURN_BY_DATE ,
OLD_ACTUAL_RETURN_DATE ,
NEW_ACTUAL_RETURN_DATE ,
OLD_OE_AGREEMENT_ID ,
NEW_OE_AGREEMENT_ID ,
OLD_LAST_OE_ORDER_LINE_ID,
NEW_LAST_OE_ORDER_LINE_ID,
OLD_LAST_OE_RMA_LINE_ID,
NEW_LAST_OE_RMA_LINE_ID,
OLD_LAST_WIP_JOB_ID,
NEW_LAST_WIP_JOB_ID,
OLD_LAST_PO_PO_LINE_ID,
NEW_LAST_PO_PO_LINE_ID,
OLD_LAST_PA_PROJECT_ID,
NEW_LAST_PA_PROJECT_ID,
OLD_LAST_PA_TASK_ID,
NEW_LAST_PA_TASK_ID,
OLD_LAST_TXN_LINE_DETAIL_ID,
NEW_LAST_TXN_LINE_DETAIL_ID,
OLD_LAST_OE_PO_NUMBER,
NEW_LAST_OE_PO_NUMBER,
--start of eam integration changes--
OLD_NETWORK_ASSET_FLAG,
NEW_NETWORK_ASSET_FLAG,
OLD_MAINTAINABLE_FLAG,
NEW_MAINTAINABLE_FLAG,
OLD_PN_LOCATION_ID,
NEW_PN_LOCATION_ID,
OLD_ASSET_CRITICALITY_CODE,
NEW_ASSET_CRITICALITY_CODE,
OLD_CATEGORY_ID,
NEW_CATEGORY_ID,
OLD_EQUIPMENT_GEN_OBJECT_ID,
NEW_EQUIPMENT_GEN_OBJECT_ID,
OLD_INSTANTIATION_FLAG,
NEW_INSTANTIATION_FLAG,
OLD_LINEAR_LOCATION_ID,
NEW_LINEAR_LOCATION_ID,
OLD_OPERATIONAL_LOG_FLAG,
NEW_OPERATIONAL_LOG_FLAG,
OLD_CHECKIN_STATUS,
NEW_CHECKIN_STATUS,
OLD_SUPPLIER_WARRANTY_EXP_DATE,
NEW_SUPPLIER_WARRANTY_EXP_DATE,
OLD_ATTRIBUTE16,
NEW_ATTRIBUTE16,
OLD_ATTRIBUTE17,
NEW_ATTRIBUTE17,
OLD_ATTRIBUTE18,
NEW_ATTRIBUTE18,
OLD_ATTRIBUTE19,
NEW_ATTRIBUTE19,
OLD_ATTRIBUTE20,
NEW_ATTRIBUTE20,
OLD_ATTRIBUTE21,
NEW_ATTRIBUTE21,
OLD_ATTRIBUTE22,
NEW_ATTRIBUTE22,
OLD_ATTRIBUTE23,
NEW_ATTRIBUTE23,
OLD_ATTRIBUTE24,
NEW_ATTRIBUTE24,
OLD_ATTRIBUTE25,
NEW_ATTRIBUTE25,
OLD_ATTRIBUTE26,
NEW_ATTRIBUTE26,
OLD_ATTRIBUTE27,
NEW_ATTRIBUTE27,
OLD_ATTRIBUTE28,
NEW_ATTRIBUTE28,
OLD_ATTRIBUTE29,
NEW_ATTRIBUTE29,
OLD_ATTRIBUTE30,
NEW_ATTRIBUTE30,
--end of eam integration changes--
-- Addition of columns for FA Integration
OLD_PAYABLES_UNIT_PRICE,
NEW_PAYABLES_UNIT_PRICE,
OLD_PAYABLES_CURRENCY_CODE,
NEW_PAYABLES_CURRENCY_CODE,
OLD_PURCHASE_UNIT_PRICE,
NEW_PURCHASE_UNIT_PRICE,
OLD_PURCHASE_CURRENCY_CODE,
NEW_PURCHASE_CURRENCY_CODE,
OLD_SALES_UNIT_PRICE,
NEW_SALES_UNIT_PRICE,
OLD_SALES_CURRENCY_CODE,
NEW_SALES_CURRENCY_CODE,
OLD_OPERATIONAL_STATUS_CODE,
NEW_OPERATIONAL_STATUS_CODE,
-- End addition of columns for FA Integration
-- Begin Add Code for Siebel Genesis Project
OLD_SOURCE_CODE,
NEW_SOURCE_CODE
-- End Add Code for Siebel Genesis Project
)
VALUES (
px_INSTANCE_HISTORY_ID,
decode( p_INSTANCE_ID, FND_API.G_MISS_NUM, NULL, p_INSTANCE_ID),
decode( p_TRANSACTION_ID, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_ID),
decode( p_OLD_INSTANCE_NUMBER, FND_API.G_MISS_CHAR, NULL, p_OLD_INSTANCE_NUMBER),
decode( p_NEW_INSTANCE_NUMBER, FND_API.G_MISS_CHAR, NULL, p_NEW_INSTANCE_NUMBER),
decode( p_OLD_EXTERNAL_REFERENCE, FND_API.G_MISS_CHAR, NULL, p_OLD_EXTERNAL_REFERENCE),
decode( p_NEW_EXTERNAL_REFERENCE, FND_API.G_MISS_CHAR, NULL, p_NEW_EXTERNAL_REFERENCE),
decode( p_OLD_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_OLD_INVENTORY_ITEM_ID),
decode( p_NEW_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_NEW_INVENTORY_ITEM_ID),
decode( p_OLD_INVENTORY_REVISION, FND_API.G_MISS_CHAR, NULL, p_OLD_INVENTORY_REVISION),
decode( p_NEW_INVENTORY_REVISION, FND_API.G_MISS_CHAR, NULL, p_NEW_INVENTORY_REVISION),
decode( p_OLD_INV_MASTER_ORGZN_ID, FND_API.G_MISS_NUM, NULL, p_OLD_INV_MASTER_ORGZN_ID),
decode( p_NEW_INV_MASTER_ORGZN_ID, FND_API.G_MISS_NUM, NULL, p_NEW_INV_MASTER_ORGZN_ID),
decode( p_OLD_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NULL, p_OLD_SERIAL_NUMBER),
decode( p_NEW_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NULL, p_NEW_SERIAL_NUMBER) ,
decode( p_OLD_MFG_SERIAL_NUMBER_FLAG, FND_API.G_MISS_CHAR, NULL, p_OLD_MFG_SERIAL_NUMBER_FLAG),
decode( p_NEW_MFG_SERIAL_NUMBER_FLAG, FND_API.G_MISS_CHAR, NULL, p_NEW_MFG_SERIAL_NUMBER_FLAG),
decode( p_OLD_LOT_NUMBER, FND_API.G_MISS_CHAR, NULL, p_OLD_LOT_NUMBER),
decode( p_NEW_LOT_NUMBER, FND_API.G_MISS_CHAR, NULL, p_NEW_LOT_NUMBER),
decode( p_OLD_QUANTITY, FND_API.G_MISS_NUM, NULL, p_OLD_QUANTITY),
decode( p_NEW_QUANTITY, FND_API.G_MISS_NUM, NULL, p_NEW_QUANTITY),
decode( p_OLD_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, NULL, p_OLD_UNIT_OF_MEASURE),
decode( p_NEW_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, NULL, p_NEW_UNIT_OF_MEASURE),
decode( p_OLD_ACCOUNTING_CLASS_CODE, FND_API.G_MISS_CHAR, NULL, p_OLD_ACCOUNTING_CLASS_CODE),
decode( p_NEW_ACCOUNTING_CLASS_CODE, FND_API.G_MISS_CHAR, NULL, p_NEW_ACCOUNTING_CLASS_CODE),
decode( p_OLD_INSTANCE_CONDITION_ID, FND_API.G_MISS_NUM, NULL, p_OLD_INSTANCE_CONDITION_ID),
decode( p_NEW_INSTANCE_CONDITION_ID, FND_API.G_MISS_NUM, NULL, p_NEW_INSTANCE_CONDITION_ID),
decode( p_OLD_INSTANCE_STATUS_ID, FND_API.G_MISS_NUM, NULL, p_OLD_INSTANCE_STATUS_ID),
decode( p_NEW_INSTANCE_STATUS_ID, FND_API.G_MISS_NUM, NULL, p_NEW_INSTANCE_STATUS_ID),
decode( p_OLD_CUSTOMER_VIEW_FLAG, FND_API.G_MISS_CHAR, NULL, p_OLD_CUSTOMER_VIEW_FLAG),
decode( p_NEW_CUSTOMER_VIEW_FLAG, FND_API.G_MISS_CHAR, NULL, p_NEW_CUSTOMER_VIEW_FLAG),
decode( p_OLD_MERCHANT_VIEW_FLAG, FND_API.G_MISS_CHAR, NULL, p_OLD_MERCHANT_VIEW_FLAG),
decode( p_NEW_MERCHANT_VIEW_FLAG, FND_API.G_MISS_CHAR, NULL, p_NEW_MERCHANT_VIEW_FLAG),
decode( p_OLD_SELLABLE_FLAG, FND_API.G_MISS_CHAR, NULL, p_OLD_SELLABLE_FLAG),
decode( p_NEW_SELLABLE_FLAG, FND_API.G_MISS_CHAR, NULL, p_NEW_SELLABLE_FLAG),
decode( p_OLD_SYSTEM_ID, FND_API.G_MISS_NUM, NULL, p_OLD_SYSTEM_ID),
decode( p_NEW_SYSTEM_ID, FND_API.G_MISS_NUM, NULL, p_NEW_SYSTEM_ID),
decode( p_OLD_INSTANCE_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_OLD_INSTANCE_TYPE_CODE),
decode( p_NEW_INSTANCE_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_NEW_INSTANCE_TYPE_CODE),
decode( p_OLD_ACTIVE_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_OLD_ACTIVE_START_DATE),
decode( p_NEW_ACTIVE_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_NEW_ACTIVE_START_DATE),
decode( p_OLD_ACTIVE_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_OLD_ACTIVE_END_DATE),
decode( p_NEW_ACTIVE_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_NEW_ACTIVE_END_DATE),
decode( p_OLD_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_OLD_LOCATION_TYPE_CODE),
decode( p_NEW_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_NEW_LOCATION_TYPE_CODE),
decode( p_OLD_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_OLD_LOCATION_ID),
decode( p_NEW_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_NEW_LOCATION_ID),
decode( p_OLD_INV_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_OLD_INV_ORGANIZATION_ID),
decode( p_NEW_INV_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_NEW_INV_ORGANIZATION_ID),
decode( p_OLD_INV_SUBINVENTORY_NAME, FND_API.G_MISS_CHAR, NULL, p_OLD_INV_SUBINVENTORY_NAME),
decode( p_NEW_INV_SUBINVENTORY_NAME, FND_API.G_MISS_CHAR, NULL, p_NEW_INV_SUBINVENTORY_NAME),
decode( p_OLD_INV_LOCATOR_ID, FND_API.G_MISS_NUM, NULL, p_OLD_INV_LOCATOR_ID),
decode( p_NEW_INV_LOCATOR_ID, FND_API.G_MISS_NUM, NULL, p_NEW_INV_LOCATOR_ID),
decode( p_OLD_PA_PROJECT_ID, FND_API.G_MISS_NUM, NULL, p_OLD_PA_PROJECT_ID),
decode( p_NEW_PA_PROJECT_ID, FND_API.G_MISS_NUM, NULL, p_NEW_PA_PROJECT_ID),
decode( p_OLD_PA_PROJECT_TASK_ID, FND_API.G_MISS_NUM, NULL, p_OLD_PA_PROJECT_TASK_ID),
decode( p_NEW_PA_PROJECT_TASK_ID, FND_API.G_MISS_NUM, NULL, p_NEW_PA_PROJECT_TASK_ID),
decode( p_OLD_IN_TRANSIT_ORDER_LINE_ID, FND_API.G_MISS_NUM, NULL, p_OLD_IN_TRANSIT_ORDER_LINE_ID),
decode( p_NEW_IN_TRANSIT_ORDER_LINE_ID, FND_API.G_MISS_NUM, NULL, p_NEW_IN_TRANSIT_ORDER_LINE_ID),
decode( p_OLD_WIP_JOB_ID, FND_API.G_MISS_NUM, NULL, p_OLD_WIP_JOB_ID),
decode( p_NEW_WIP_JOB_ID, FND_API.G_MISS_NUM, NULL, p_NEW_WIP_JOB_ID),
decode( p_OLD_PO_ORDER_LINE_ID, FND_API.G_MISS_NUM, NULL, p_OLD_PO_ORDER_LINE_ID),
decode( p_NEW_PO_ORDER_LINE_ID, FND_API.G_MISS_NUM, NULL, p_NEW_PO_ORDER_LINE_ID),
decode( p_OLD_COMPLETENESS_FLAG, FND_API.G_MISS_CHAR, NULL, p_OLD_COMPLETENESS_FLAG),
decode( p_NEW_COMPLETENESS_FLAG, FND_API.G_MISS_CHAR, NULL, p_NEW_COMPLETENESS_FLAG),
decode( p_FULL_DUMP_FLAG, FND_API.G_MISS_CHAR, NULL, p_FULL_DUMP_FLAG),
decode( p_OLD_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_OLD_CONTEXT),
decode( p_NEW_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_NEW_CONTEXT),
decode( p_OLD_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE1),
decode( p_NEW_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE1),
decode( p_OLD_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE2),
decode( p_NEW_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE2),
decode( p_OLD_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE3),
decode( p_NEW_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE3),
decode( p_OLD_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE4),
decode( p_NEW_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE4),
decode( p_OLD_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE5),
decode( p_NEW_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE5),
decode( p_OLD_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE6),
decode( p_NEW_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE6),
decode( p_OLD_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE7),
decode( p_NEW_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE7),
decode( p_OLD_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE8),
decode( p_NEW_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE8),
decode( p_OLD_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE9),
decode( p_NEW_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE9),
decode( p_OLD_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE10),
decode( p_NEW_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE10),
decode( p_OLD_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE11),
decode( p_NEW_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE11),
decode( p_OLD_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE12),
decode( p_NEW_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE12),
decode( p_OLD_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE13),
decode( p_NEW_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE13),
decode( p_OLD_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE14),
decode( p_NEW_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE14),
decode( p_OLD_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE15),
decode( p_NEW_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE15),
decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER),
decode( p_OLD_INST_LOC_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_OLD_INST_LOC_TYPE_CODE),
decode( p_NEW_INST_LOC_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_NEW_INST_LOC_TYPE_CODE),
decode( p_OLD_INST_LOC_ID, FND_API.G_MISS_NUM, NULL, p_OLD_INST_LOC_ID),
decode( p_NEW_INST_LOC_ID, FND_API.G_MISS_NUM, NULL, p_NEW_INST_LOC_ID),
decode( p_OLD_INST_USAGE_CODE, FND_API.G_MISS_CHAR, NULL, p_OLD_INST_USAGE_CODE),
decode( p_NEW_INST_USAGE_CODE, FND_API.G_MISS_CHAR, NULL, p_NEW_INST_USAGE_CODE),
decode( p_OLD_last_vld_organization_id, FND_API.G_MISS_NUM, NULL, p_OLD_last_vld_organization_id),
decode( p_NEW_last_vld_organization_id, FND_API.G_MISS_NUM, NULL, p_new_last_vld_organization_id),
decode( p_OLD_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, NULL, p_OLD_CONFIG_INST_REV_NUM),
decode( p_NEW_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, NULL, p_NEW_CONFIG_INST_REV_NUM),
decode( p_OLD_CONFIG_VALID_STATUS, FND_API.G_MISS_CHAR, NULL, p_OLD_CONFIG_VALID_STATUS),
decode( p_NEW_CONFIG_VALID_STATUS, FND_API.G_MISS_CHAR, NULL, p_NEW_CONFIG_VALID_STATUS),
decode( p_OLD_INSTANCE_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_OLD_INSTANCE_DESCRIPTION),
decode( p_NEW_INSTANCE_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_NEW_INSTANCE_DESCRIPTION),
decode( p_OLD_INSTALL_DATE,FND_API.G_MISS_DATE, TO_DATE(NULL), p_OLD_INSTALL_DATE),
decode( p_NEW_INSTALL_DATE ,FND_API.G_MISS_DATE, TO_DATE(NULL), p_NEW_INSTALL_DATE),
decode( p_OLD_RETURN_BY_DATE,FND_API.G_MISS_DATE, TO_DATE(NULL), p_OLD_RETURN_BY_DATE),
decode( p_NEW_RETURN_BY_DATE,FND_API.G_MISS_DATE, TO_DATE(NULL), p_NEW_RETURN_BY_DATE),
decode( p_OLD_ACTUAL_RETURN_DATE,FND_API.G_MISS_DATE, TO_DATE(NULL), p_OLD_ACTUAL_RETURN_DATE),
decode( p_NEW_ACTUAL_RETURN_DATE,FND_API.G_MISS_DATE, TO_DATE(NULL), p_NEW_ACTUAL_RETURN_DATE),
decode( p_OLD_LAST_OE_AGREEMENT_ID,FND_API.G_MISS_NUM, NULL,p_OLD_LAST_OE_AGREEMENT_ID),
decode( p_NEW_LAST_OE_AGREEMENT_ID,FND_API.G_MISS_NUM, NULL,p_NEW_LAST_OE_AGREEMENT_ID),
decode(p_OLD_LAST_OE_ORDER_LINE_ID,FND_API.G_MISS_NUM,NULL,p_OLD_LAST_OE_ORDER_LINE_ID),
decode(p_NEW_LAST_OE_ORDER_LINE_ID,FND_API.G_MISS_NUM,NULL,p_NEW_LAST_OE_ORDER_LINE_ID),
decode(p_OLD_LAST_OE_RMA_LINE_ID,FND_API.G_MISS_NUM,NULL,p_OLD_LAST_OE_RMA_LINE_ID),
decode(p_NEW_LAST_OE_RMA_LINE_ID,FND_API.G_MISS_NUM,NULL,p_NEW_LAST_OE_RMA_LINE_ID),
decode(p_OLD_LAST_WIP_JOB_ID,FND_API.G_MISS_NUM,NULL,p_OLD_LAST_WIP_JOB_ID),
decode(p_NEW_LAST_WIP_JOB_ID,FND_API.G_MISS_NUM,NULL,p_NEW_LAST_WIP_JOB_ID),
decode(p_OLD_LAST_PO_PO_LINE_ID,FND_API.G_MISS_NUM,NULL,p_OLD_LAST_PO_PO_LINE_ID),
decode(p_NEW_LAST_PO_PO_LINE_ID,FND_API.G_MISS_NUM,NULL,p_NEW_LAST_PO_PO_LINE_ID),
decode(p_OLD_LAST_PA_PROJECT_ID,FND_API.G_MISS_NUM,NULL,p_OLD_LAST_PA_PROJECT_ID),
decode(p_NEW_LAST_PA_PROJECT_ID,FND_API.G_MISS_NUM,NULL,p_NEW_LAST_PA_PROJECT_ID),
decode(p_OLD_LAST_PA_TASK_ID,FND_API.G_MISS_NUM,NULL,p_OLD_LAST_PA_TASK_ID),
decode(p_NEW_LAST_PA_TASK_ID,FND_API.G_MISS_NUM,NULL,p_NEW_LAST_PA_TASK_ID),
decode(p_OLD_LAST_TXN_LINE_DETAIL_ID,FND_API.G_MISS_NUM,NULL,p_OLD_LAST_TXN_LINE_DETAIL_ID),
decode(p_NEW_LAST_TXN_LINE_DETAIL_ID,FND_API.G_MISS_NUM,NULL,p_NEW_LAST_TXN_LINE_DETAIL_ID),
decode(p_OLD_LAST_OE_PO_NUMBER,FND_API.G_MISS_CHAR, NULL,p_OLD_LAST_OE_PO_NUMBER),
decode(p_NEW_LAST_OE_PO_NUMBER,FND_API.G_MISS_CHAR, NULL,p_NEW_LAST_OE_PO_NUMBER),
--start of eam integration changes--
decode( p_OLD_NETWORK_ASSET_FLAG, FND_API.G_MISS_CHAR, NULL, p_OLD_NETWORK_ASSET_FLAG),
decode( p_NEW_NETWORK_ASSET_FLAG, FND_API.G_MISS_CHAR, NULL, p_NEW_NETWORK_ASSET_FLAG),
decode( p_OLD_MAINTAINABLE_FLAG, FND_API.G_MISS_CHAR, NULL, p_OLD_MAINTAINABLE_FLAG),
decode( p_NEW_MAINTAINABLE_FLAG, FND_API.G_MISS_CHAR, NULL, p_NEW_MAINTAINABLE_FLAG),
decode( p_OLD_PN_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_OLD_PN_LOCATION_ID),
decode( p_NEW_PN_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_NEW_PN_LOCATION_ID),
decode( p_OLD_ASSET_CRITICALITY_CODE, FND_API.G_MISS_CHAR, NULL, p_OLD_ASSET_CRITICALITY_CODE),
decode( p_NEW_ASSET_CRITICALITY_CODE, FND_API.G_MISS_CHAR, NULL, p_NEW_ASSET_CRITICALITY_CODE),
decode( p_OLD_CATEGORY_ID, FND_API.G_MISS_NUM, NULL, p_OLD_CATEGORY_ID),
decode( p_NEW_CATEGORY_ID, FND_API.G_MISS_NUM, NULL, p_NEW_CATEGORY_ID),
decode( p_OLD_EQUIPMENT_GEN_OBJECT_ID, FND_API.G_MISS_NUM, NULL, p_OLD_EQUIPMENT_GEN_OBJECT_ID),
decode( p_NEW_EQUIPMENT_GEN_OBJECT_ID, FND_API.G_MISS_NUM, NULL, p_NEW_EQUIPMENT_GEN_OBJECT_ID),
decode( p_OLD_INSTANTIATION_FLAG, FND_API.G_MISS_CHAR, NULL, p_OLD_INSTANTIATION_FLAG),
decode( p_NEW_INSTANTIATION_FLAG, FND_API.G_MISS_CHAR, NULL, p_NEW_INSTANTIATION_FLAG),
decode( p_OLD_LINEAR_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_OLD_LINEAR_LOCATION_ID),
decode( p_NEW_LINEAR_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_NEW_LINEAR_LOCATION_ID),
decode( p_OLD_OPERATIONAL_LOG_FLAG, FND_API.G_MISS_CHAR, NULL, p_OLD_OPERATIONAL_LOG_FLAG),
decode( p_NEW_OPERATIONAL_LOG_FLAG, FND_API.G_MISS_CHAR, NULL, p_NEW_OPERATIONAL_LOG_FLAG),
decode( p_OLD_CHECKIN_STATUS, FND_API.G_MISS_NUM, NULL, p_OLD_CHECKIN_STATUS),
decode( p_NEW_CHECKIN_STATUS, FND_API.G_MISS_NUM, NULL, p_NEW_CHECKIN_STATUS),
decode( p_OLD_SUP_WARRANTY_EXP_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_OLD_SUP_WARRANTY_EXP_DATE),
decode( p_NEW_SUP_WARRANTY_EXP_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_NEW_SUP_WARRANTY_EXP_DATE),
decode( p_OLD_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE16),
decode( p_NEW_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE16),
decode( p_OLD_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE17),
decode( p_NEW_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE17),
decode( p_OLD_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE18),
decode( p_NEW_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE18),
decode( p_OLD_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE19),
decode( p_NEW_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE19),
decode( p_OLD_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE20),
decode( p_NEW_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE20),
decode( p_OLD_ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE21),
decode( p_NEW_ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE21),
decode( p_OLD_ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE22),
decode( p_NEW_ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE22),
decode( p_OLD_ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE23),
decode( p_NEW_ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE23),
decode( p_OLD_ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE24),
decode( p_NEW_ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE24),
decode( p_OLD_ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE25),
decode( p_NEW_ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE25),
decode( p_OLD_ATTRIBUTE26, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE26),
decode( p_NEW_ATTRIBUTE26, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE26),
decode( p_OLD_ATTRIBUTE27, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE27),
decode( p_NEW_ATTRIBUTE27, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE27),
decode( p_OLD_ATTRIBUTE28, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE28),
decode( p_NEW_ATTRIBUTE28, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE28),
decode( p_OLD_ATTRIBUTE29, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE29),
decode( p_NEW_ATTRIBUTE29, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE29),
decode( p_OLD_ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL, p_OLD_ATTRIBUTE30),
decode( p_NEW_ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL, p_NEW_ATTRIBUTE30),
--end of eam integration changes--
-- Addition of columns for FA Integration
decode( p_OLD_PAYABLES_UNIT_PRICE, FND_API.G_MISS_NUM, NULL, p_OLD_PAYABLES_UNIT_PRICE),
decode( p_NEW_PAYABLES_UNIT_PRICE, FND_API.G_MISS_NUM, NULL, p_NEW_PAYABLES_UNIT_PRICE),
decode( p_OLD_PAYABLES_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_OLD_PAYABLES_CURRENCY_CODE),
decode( p_NEW_PAYABLES_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_NEW_PAYABLES_CURRENCY_CODE),
decode( p_OLD_PURCHASE_UNIT_PRICE, FND_API.G_MISS_NUM, NULL, p_OLD_PURCHASE_UNIT_PRICE),
decode( p_NEW_PURCHASE_UNIT_PRICE, FND_API.G_MISS_NUM, NULL, p_NEW_PURCHASE_UNIT_PRICE),
decode( p_OLD_PURCHASE_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_OLD_PURCHASE_CURRENCY_CODE),
decode( p_NEW_PURCHASE_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_NEW_PURCHASE_CURRENCY_CODE),
decode( p_OLD_SALES_UNIT_PRICE, FND_API.G_MISS_NUM, NULL, p_OLD_SALES_UNIT_PRICE),
decode( p_NEW_SALES_UNIT_PRICE, FND_API.G_MISS_NUM, NULL, p_NEW_SALES_UNIT_PRICE),
decode( p_OLD_SALES_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_OLD_SALES_CURRENCY_CODE),
decode( p_NEW_SALES_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_NEW_SALES_CURRENCY_CODE),
decode( p_OLD_OPERATIONAL_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_OLD_OPERATIONAL_STATUS_CODE),
decode( p_NEW_OPERATIONAL_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_NEW_OPERATIONAL_STATUS_CODE),
-- End addition of columns for FA Integration
-- Begin Add Code for Siebel Genesis Project
decode( p_OLD_SOURCE_CODE,FND_API.G_MISS_CHAR,NULL,p_OLD_SOURCE_CODE),
decode( p_NEW_SOURCE_CODE,FND_API.G_MISS_CHAR,NULL,p_NEW_SOURCE_CODE)
-- End Add Code for Siebel Genesis Project
);
End Insert_Row;
PROCEDURE Update_Row(
p_INSTANCE_HISTORY_ID NUMBER,
p_INSTANCE_ID NUMBER,
p_TRANSACTION_ID NUMBER,
p_OLD_INSTANCE_NUMBER VARCHAR2,
p_NEW_INSTANCE_NUMBER VARCHAR2,
p_OLD_EXTERNAL_REFERENCE VARCHAR2,
p_NEW_EXTERNAL_REFERENCE VARCHAR2,
p_OLD_INVENTORY_ITEM_ID NUMBER,
p_NEW_INVENTORY_ITEM_ID NUMBER,
p_OLD_INVENTORY_REVISION VARCHAR2,
p_NEW_INVENTORY_REVISION VARCHAR2,
p_OLD_INV_MASTER_ORGZN_ID NUMBER,
p_NEW_INV_MASTER_ORGZN_ID NUMBER,
p_OLD_SERIAL_NUMBER VARCHAR2,
p_NEW_SERIAL_NUMBER VARCHAR2,
p_OLD_MFG_SERIAL_NUMBER_FLAG VARCHAR2,
p_NEW_MFG_SERIAL_NUMBER_FLAG VARCHAR2,
p_OLD_LOT_NUMBER VARCHAR2,
p_NEW_LOT_NUMBER VARCHAR2,
p_OLD_QUANTITY NUMBER,
p_NEW_QUANTITY NUMBER,
p_OLD_UNIT_OF_MEASURE VARCHAR2,
p_NEW_UNIT_OF_MEASURE VARCHAR2,
p_OLD_ACCOUNTING_CLASS_CODE VARCHAR2,
p_NEW_ACCOUNTING_CLASS_CODE VARCHAR2,
p_OLD_INSTANCE_CONDITION_ID NUMBER,
p_NEW_INSTANCE_CONDITION_ID NUMBER,
p_OLD_INSTANCE_STATUS_ID NUMBER,
p_NEW_INSTANCE_STATUS_ID NUMBER,
p_OLD_CUSTOMER_VIEW_FLAG VARCHAR2,
p_NEW_CUSTOMER_VIEW_FLAG VARCHAR2,
p_OLD_MERCHANT_VIEW_FLAG VARCHAR2,
p_NEW_MERCHANT_VIEW_FLAG VARCHAR2,
p_OLD_SELLABLE_FLAG VARCHAR2,
p_NEW_SELLABLE_FLAG VARCHAR2,
p_OLD_SYSTEM_ID NUMBER,
p_NEW_SYSTEM_ID NUMBER,
p_OLD_INSTANCE_TYPE_CODE VARCHAR2,
p_NEW_INSTANCE_TYPE_CODE VARCHAR2,
p_OLD_ACTIVE_START_DATE DATE,
p_NEW_ACTIVE_START_DATE DATE,
p_OLD_ACTIVE_END_DATE DATE,
p_NEW_ACTIVE_END_DATE DATE,
p_OLD_LOCATION_TYPE_CODE VARCHAR2,
p_NEW_LOCATION_TYPE_CODE VARCHAR2,
p_OLD_LOCATION_ID NUMBER,
p_NEW_LOCATION_ID NUMBER,
p_OLD_INV_ORGANIZATION_ID NUMBER,
p_NEW_INV_ORGANIZATION_ID NUMBER,
p_OLD_INV_SUBINVENTORY_NAME VARCHAR2,
p_NEW_INV_SUBINVENTORY_NAME VARCHAR2,
p_OLD_INV_LOCATOR_ID NUMBER,
p_NEW_INV_LOCATOR_ID NUMBER,
p_OLD_PA_PROJECT_ID NUMBER,
p_NEW_PA_PROJECT_ID NUMBER,
p_OLD_PA_PROJECT_TASK_ID NUMBER,
p_NEW_PA_PROJECT_TASK_ID NUMBER,
p_OLD_IN_TRANSIT_ORDER_LINE_ID NUMBER,
p_NEW_IN_TRANSIT_ORDER_LINE_ID NUMBER,
p_OLD_WIP_JOB_ID NUMBER,
p_NEW_WIP_JOB_ID NUMBER,
p_OLD_PO_ORDER_LINE_ID NUMBER,
p_NEW_PO_ORDER_LINE_ID NUMBER,
p_OLD_COMPLETENESS_FLAG VARCHAR2,
p_NEW_COMPLETENESS_FLAG VARCHAR2,
p_FULL_DUMP_FLAG VARCHAR2,
p_OLD_CONTEXT VARCHAR2,
p_NEW_CONTEXT VARCHAR2,
p_OLD_ATTRIBUTE1 VARCHAR2,
p_NEW_ATTRIBUTE1 VARCHAR2,
p_OLD_ATTRIBUTE2 VARCHAR2,
p_NEW_ATTRIBUTE2 VARCHAR2,
p_OLD_ATTRIBUTE3 VARCHAR2,
p_NEW_ATTRIBUTE3 VARCHAR2,
p_OLD_ATTRIBUTE4 VARCHAR2,
p_NEW_ATTRIBUTE4 VARCHAR2,
p_OLD_ATTRIBUTE5 VARCHAR2,
p_NEW_ATTRIBUTE5 VARCHAR2,
p_OLD_ATTRIBUTE6 VARCHAR2,
p_NEW_ATTRIBUTE6 VARCHAR2,
p_OLD_ATTRIBUTE7 VARCHAR2,
p_NEW_ATTRIBUTE7 VARCHAR2,
p_OLD_ATTRIBUTE8 VARCHAR2,
p_NEW_ATTRIBUTE8 VARCHAR2,
p_OLD_ATTRIBUTE9 VARCHAR2,
p_NEW_ATTRIBUTE9 VARCHAR2,
p_OLD_ATTRIBUTE10 VARCHAR2,
p_NEW_ATTRIBUTE10 VARCHAR2,
p_OLD_ATTRIBUTE11 VARCHAR2,
p_NEW_ATTRIBUTE11 VARCHAR2,
p_OLD_ATTRIBUTE12 VARCHAR2,
p_NEW_ATTRIBUTE12 VARCHAR2,
p_OLD_ATTRIBUTE13 VARCHAR2,
p_NEW_ATTRIBUTE13 VARCHAR2,
p_OLD_ATTRIBUTE14 VARCHAR2,
p_NEW_ATTRIBUTE14 VARCHAR2,
p_OLD_ATTRIBUTE15 VARCHAR2,
p_NEW_ATTRIBUTE15 VARCHAR2,
p_CREATED_BY NUMBER,
p_CREATION_DATE DATE,
p_LAST_UPDATED_BY NUMBER,
p_LAST_UPDATE_DATE DATE,
p_LAST_UPDATE_LOGIN NUMBER,
p_OBJECT_VERSION_NUMBER NUMBER,
p_OLD_INST_LOC_TYPE_CODE VARCHAR2,
p_NEW_INST_LOC_TYPE_CODE VARCHAR2,
p_OLD_INST_LOC_ID NUMBER,
p_NEW_INST_LOC_ID NUMBER,
p_OLD_INST_USAGE_CODE VARCHAR2,
p_NEW_INST_USAGE_CODE VARCHAR2,
p_OLD_last_vld_organization_id NUMBER :=fnd_api.g_miss_num,
p_NEW_last_vld_organization_id NUMBER :=fnd_api.g_miss_num,
p_OLD_CONFIG_INST_REV_NUM NUMBER,
p_NEW_CONFIG_INST_REV_NUM NUMBER,
p_OLD_CONFIG_VALID_STATUS VARCHAR2,
p_NEW_CONFIG_VALID_STATUS VARCHAR2,
p_OLD_INSTANCE_DESCRIPTION VARCHAR2,
p_NEW_INSTANCE_DESCRIPTION VARCHAR2,
p_OLD_INSTALL_DATE DATE,
p_NEW_INSTALL_DATE DATE,
p_OLD_RETURN_BY_DATE DATE,
p_NEW_RETURN_BY_DATE DATE,
p_OLD_ACTUAL_RETURN_DATE DATE,
p_NEW_ACTUAL_RETURN_DATE DATE,
p_OLD_LAST_OE_AGREEMENT_ID NUMBER,
p_NEW_LAST_OE_AGREEMENT_ID NUMBER,
p_OLD_LAST_OE_ORDER_LINE_ID NUMBER ,
p_NEW_LAST_OE_ORDER_LINE_ID NUMBER ,
p_OLD_LAST_OE_RMA_LINE_ID NUMBER ,
p_NEW_LAST_OE_RMA_LINE_ID NUMBER ,
p_OLD_LAST_WIP_JOB_ID NUMBER ,
p_NEW_LAST_WIP_JOB_ID NUMBER ,
p_OLD_LAST_PO_PO_LINE_ID NUMBER ,
p_NEW_LAST_PO_PO_LINE_ID NUMBER ,
p_OLD_LAST_PA_PROJECT_ID NUMBER ,
p_NEW_LAST_PA_PROJECT_ID NUMBER ,
p_OLD_LAST_PA_TASK_ID NUMBER ,
p_NEW_LAST_PA_TASK_ID NUMBER ,
p_OLD_LAST_TXN_LINE_DETAIL_ID NUMBER ,
p_NEW_LAST_TXN_LINE_DETAIL_ID NUMBER ,
p_OLD_LAST_OE_PO_NUMBER VARCHAR2,
p_NEW_LAST_OE_PO_NUMBER VARCHAR2,
--start of eam integration changes--
p_OLD_NETWORK_ASSET_FLAG VARCHAR2,
p_NEW_NETWORK_ASSET_FLAG VARCHAR2,
p_OLD_MAINTAINABLE_FLAG VARCHAR2,
p_NEW_MAINTAINABLE_FLAG VARCHAR2,
p_OLD_PN_LOCATION_ID NUMBER,
p_NEW_PN_LOCATION_ID NUMBER,
p_OLD_ASSET_CRITICALITY_CODE VARCHAR2,
p_NEW_ASSET_CRITICALITY_CODE VARCHAR2,
p_OLD_CATEGORY_ID NUMBER,
p_NEW_CATEGORY_ID NUMBER,
p_OLD_EQUIPMENT_GEN_OBJECT_ID NUMBER,
p_NEW_EQUIPMENT_GEN_OBJECT_ID NUMBER,
p_OLD_INSTANTIATION_FLAG VARCHAR2,
p_NEW_INSTANTIATION_FLAG VARCHAR2,
p_OLD_LINEAR_LOCATION_ID NUMBER,
p_NEW_LINEAR_LOCATION_ID NUMBER,
p_OLD_OPERATIONAL_LOG_FLAG VARCHAR2,
p_NEW_OPERATIONAL_LOG_FLAG VARCHAR2,
p_OLD_CHECKIN_STATUS NUMBER,
p_NEW_CHECKIN_STATUS NUMBER,
p_OLD_SUP_WARRANTY_EXP_DATE DATE,
p_NEW_SUP_WARRANTY_EXP_DATE DATE,
p_OLD_ATTRIBUTE16 VARCHAR2,
p_NEW_ATTRIBUTE16 VARCHAR2,
p_OLD_ATTRIBUTE17 VARCHAR2,
p_NEW_ATTRIBUTE17 VARCHAR2,
p_OLD_ATTRIBUTE18 VARCHAR2,
p_NEW_ATTRIBUTE18 VARCHAR2,
p_OLD_ATTRIBUTE19 VARCHAR2,
p_NEW_ATTRIBUTE19 VARCHAR2,
p_OLD_ATTRIBUTE20 VARCHAR2,
p_NEW_ATTRIBUTE20 VARCHAR2,
p_OLD_ATTRIBUTE21 VARCHAR2,
p_NEW_ATTRIBUTE21 VARCHAR2,
p_OLD_ATTRIBUTE22 VARCHAR2,
p_NEW_ATTRIBUTE22 VARCHAR2,
p_OLD_ATTRIBUTE23 VARCHAR2,
p_NEW_ATTRIBUTE23 VARCHAR2,
p_OLD_ATTRIBUTE24 VARCHAR2,
p_NEW_ATTRIBUTE24 VARCHAR2,
p_OLD_ATTRIBUTE25 VARCHAR2,
p_NEW_ATTRIBUTE25 VARCHAR2,
p_OLD_ATTRIBUTE26 VARCHAR2,
p_NEW_ATTRIBUTE26 VARCHAR2,
p_OLD_ATTRIBUTE27 VARCHAR2,
p_NEW_ATTRIBUTE27 VARCHAR2,
p_OLD_ATTRIBUTE28 VARCHAR2,
p_NEW_ATTRIBUTE28 VARCHAR2,
p_OLD_ATTRIBUTE29 VARCHAR2,
p_NEW_ATTRIBUTE29 VARCHAR2,
p_OLD_ATTRIBUTE30 VARCHAR2,
p_NEW_ATTRIBUTE30 VARCHAR2,
--end of eam integration changes--
-- Addition of columns for FA Integration
p_OLD_PAYABLES_UNIT_PRICE NUMBER,
p_NEW_PAYABLES_UNIT_PRICE NUMBER,
p_OLD_PAYABLES_CURRENCY_CODE VARCHAR2,
p_NEW_PAYABLES_CURRENCY_CODE VARCHAR2,
p_OLD_PURCHASE_UNIT_PRICE NUMBER,
p_NEW_PURCHASE_UNIT_PRICE NUMBER,
p_OLD_PURCHASE_CURRENCY_CODE VARCHAR2,
p_NEW_PURCHASE_CURRENCY_CODE VARCHAR2,
p_OLD_SALES_UNIT_PRICE NUMBER,
p_NEW_SALES_UNIT_PRICE NUMBER,
p_OLD_SALES_CURRENCY_CODE VARCHAR2,
p_NEW_SALES_CURRENCY_CODE VARCHAR2,
p_OLD_OPERATIONAL_STATUS_CODE VARCHAR2,
p_NEW_OPERATIONAL_STATUS_CODE VARCHAR2,
-- End addition of columns for FA Integration
-- Begin Add Code for Siebel Genesis Project
p_OLD_SOURCE_CODE VARCHAR2,
p_NEW_SOURCE_CODE VARCHAR2
-- End Add Code for Siebel Genesis Project
)
IS
BEGIN
Update CSI_ITEM_INSTANCES_H
SET
INSTANCE_ID = decode( p_INSTANCE_ID, FND_API.G_MISS_NUM, INSTANCE_ID, p_INSTANCE_ID),
TRANSACTION_ID = decode( p_TRANSACTION_ID, FND_API.G_MISS_NUM, TRANSACTION_ID, p_TRANSACTION_ID),
OLD_INSTANCE_NUMBER = decode( p_OLD_INSTANCE_NUMBER, FND_API.G_MISS_CHAR, OLD_INSTANCE_NUMBER, p_OLD_INSTANCE_NUMBER),
NEW_INSTANCE_NUMBER = decode( p_NEW_INSTANCE_NUMBER, FND_API.G_MISS_CHAR, NEW_INSTANCE_NUMBER, p_NEW_INSTANCE_NUMBER),
OLD_EXTERNAL_REFERENCE = decode( p_OLD_EXTERNAL_REFERENCE, FND_API.G_MISS_CHAR, OLD_EXTERNAL_REFERENCE, p_OLD_EXTERNAL_REFERENCE),
NEW_EXTERNAL_REFERENCE = decode( p_NEW_EXTERNAL_REFERENCE, FND_API.G_MISS_CHAR, NEW_EXTERNAL_REFERENCE, p_NEW_EXTERNAL_REFERENCE),
OLD_INVENTORY_ITEM_ID = decode( p_OLD_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, OLD_INVENTORY_ITEM_ID, p_OLD_INVENTORY_ITEM_ID),
NEW_INVENTORY_ITEM_ID = decode( p_NEW_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NEW_INVENTORY_ITEM_ID, p_NEW_INVENTORY_ITEM_ID),
OLD_INVENTORY_REVISION = decode( p_OLD_INVENTORY_REVISION, FND_API.G_MISS_CHAR, OLD_INVENTORY_REVISION, p_OLD_INVENTORY_REVISION),
NEW_INVENTORY_REVISION = decode( p_NEW_INVENTORY_REVISION, FND_API.G_MISS_CHAR, NEW_INVENTORY_REVISION, p_NEW_INVENTORY_REVISION),
OLD_INV_MASTER_ORGANIZATION_ID = decode( p_OLD_INV_MASTER_ORGZN_ID, FND_API.G_MISS_NUM, OLD_INV_MASTER_ORGANIZATION_ID, p_OLD_INV_MASTER_ORGZN_ID),
NEW_INV_MASTER_ORGANIZATION_ID = decode( p_NEW_INV_MASTER_ORGZN_ID, FND_API.G_MISS_NUM, NEW_INV_MASTER_ORGANIZATION_ID, p_NEW_INV_MASTER_ORGZN_ID),
OLD_SERIAL_NUMBER = decode( p_OLD_SERIAL_NUMBER, FND_API.G_MISS_CHAR, OLD_SERIAL_NUMBER, p_OLD_SERIAL_NUMBER),
NEW_SERIAL_NUMBER = decode( p_NEW_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NEW_SERIAL_NUMBER, p_NEW_SERIAL_NUMBER),
OLD_MFG_SERIAL_NUMBER_FLAG = decode( p_OLD_MFG_SERIAL_NUMBER_FLAG, FND_API.G_MISS_CHAR, OLD_MFG_SERIAL_NUMBER_FLAG, p_OLD_MFG_SERIAL_NUMBER_FLAG),
NEW_MFG_SERIAL_NUMBER_FLAG = decode( p_NEW_MFG_SERIAL_NUMBER_FLAG, FND_API.G_MISS_CHAR, NEW_MFG_SERIAL_NUMBER_FLAG, p_NEW_MFG_SERIAL_NUMBER_FLAG),
OLD_LOT_NUMBER = decode( p_OLD_LOT_NUMBER, FND_API.G_MISS_CHAR, OLD_LOT_NUMBER, p_OLD_LOT_NUMBER),
NEW_LOT_NUMBER = decode( p_NEW_LOT_NUMBER, FND_API.G_MISS_CHAR, NEW_LOT_NUMBER, p_NEW_LOT_NUMBER),
OLD_QUANTITY = decode( p_OLD_QUANTITY, FND_API.G_MISS_NUM, OLD_QUANTITY, p_OLD_QUANTITY),
NEW_QUANTITY = decode( p_NEW_QUANTITY, FND_API.G_MISS_NUM, NEW_QUANTITY, p_NEW_QUANTITY),
OLD_UNIT_OF_MEASURE = decode( p_OLD_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, OLD_UNIT_OF_MEASURE, p_OLD_UNIT_OF_MEASURE),
NEW_UNIT_OF_MEASURE = decode( p_NEW_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, NEW_UNIT_OF_MEASURE, p_NEW_UNIT_OF_MEASURE),
OLD_ACCOUNTING_CLASS_CODE = decode( p_OLD_ACCOUNTING_CLASS_CODE, FND_API.G_MISS_CHAR, OLD_ACCOUNTING_CLASS_CODE, p_OLD_ACCOUNTING_CLASS_CODE),
NEW_ACCOUNTING_CLASS_CODE = decode( p_NEW_ACCOUNTING_CLASS_CODE, FND_API.G_MISS_CHAR, NEW_ACCOUNTING_CLASS_CODE, p_NEW_ACCOUNTING_CLASS_CODE),
OLD_INSTANCE_CONDITION_ID = decode( p_OLD_INSTANCE_CONDITION_ID, FND_API.G_MISS_NUM, OLD_INSTANCE_CONDITION_ID, p_OLD_INSTANCE_CONDITION_ID),
NEW_INSTANCE_CONDITION_ID = decode( p_NEW_INSTANCE_CONDITION_ID, FND_API.G_MISS_NUM, NEW_INSTANCE_CONDITION_ID, p_NEW_INSTANCE_CONDITION_ID),
OLD_INSTANCE_STATUS_ID = decode( p_OLD_INSTANCE_STATUS_ID, FND_API.G_MISS_NUM, OLD_INSTANCE_STATUS_ID, p_OLD_INSTANCE_STATUS_ID),
NEW_INSTANCE_STATUS_ID = decode( p_NEW_INSTANCE_STATUS_ID, FND_API.G_MISS_NUM, NEW_INSTANCE_STATUS_ID, p_NEW_INSTANCE_STATUS_ID),
OLD_CUSTOMER_VIEW_FLAG = decode( p_OLD_CUSTOMER_VIEW_FLAG, FND_API.G_MISS_CHAR, OLD_CUSTOMER_VIEW_FLAG, p_OLD_CUSTOMER_VIEW_FLAG),
NEW_CUSTOMER_VIEW_FLAG = decode( p_NEW_CUSTOMER_VIEW_FLAG, FND_API.G_MISS_CHAR, NEW_CUSTOMER_VIEW_FLAG, p_NEW_CUSTOMER_VIEW_FLAG),
OLD_MERCHANT_VIEW_FLAG = decode( p_OLD_MERCHANT_VIEW_FLAG, FND_API.G_MISS_CHAR, OLD_MERCHANT_VIEW_FLAG, p_OLD_MERCHANT_VIEW_FLAG),
NEW_MERCHANT_VIEW_FLAG = decode( p_NEW_MERCHANT_VIEW_FLAG, FND_API.G_MISS_CHAR, NEW_MERCHANT_VIEW_FLAG, p_NEW_MERCHANT_VIEW_FLAG),
OLD_SELLABLE_FLAG = decode( p_OLD_SELLABLE_FLAG, FND_API.G_MISS_CHAR, OLD_SELLABLE_FLAG, p_OLD_SELLABLE_FLAG),
NEW_SELLABLE_FLAG = decode( p_NEW_SELLABLE_FLAG, FND_API.G_MISS_CHAR, NEW_SELLABLE_FLAG, p_NEW_SELLABLE_FLAG),
OLD_SYSTEM_ID = decode( p_OLD_SYSTEM_ID, FND_API.G_MISS_NUM, OLD_SYSTEM_ID, p_OLD_SYSTEM_ID),
NEW_SYSTEM_ID = decode( p_NEW_SYSTEM_ID, FND_API.G_MISS_NUM, NEW_SYSTEM_ID, p_NEW_SYSTEM_ID),
OLD_INSTANCE_TYPE_CODE = decode( p_OLD_INSTANCE_TYPE_CODE, FND_API.G_MISS_CHAR, OLD_INSTANCE_TYPE_CODE, p_OLD_INSTANCE_TYPE_CODE),
NEW_INSTANCE_TYPE_CODE = decode( p_NEW_INSTANCE_TYPE_CODE, FND_API.G_MISS_CHAR, NEW_INSTANCE_TYPE_CODE, p_NEW_INSTANCE_TYPE_CODE),
OLD_ACTIVE_START_DATE = decode( p_OLD_ACTIVE_START_DATE, FND_API.G_MISS_DATE, OLD_ACTIVE_START_DATE, p_OLD_ACTIVE_START_DATE),
NEW_ACTIVE_START_DATE = decode( p_NEW_ACTIVE_START_DATE, FND_API.G_MISS_DATE, NEW_ACTIVE_START_DATE, p_NEW_ACTIVE_START_DATE),
OLD_ACTIVE_END_DATE = decode( p_OLD_ACTIVE_END_DATE, FND_API.G_MISS_DATE, OLD_ACTIVE_END_DATE, p_OLD_ACTIVE_END_DATE),
NEW_ACTIVE_END_DATE = decode( p_NEW_ACTIVE_END_DATE, FND_API.G_MISS_DATE, NEW_ACTIVE_END_DATE, p_NEW_ACTIVE_END_DATE),
OLD_LOCATION_TYPE_CODE = decode( p_OLD_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, OLD_LOCATION_TYPE_CODE, p_OLD_LOCATION_TYPE_CODE),
NEW_LOCATION_TYPE_CODE = decode( p_NEW_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, NEW_LOCATION_TYPE_CODE, p_NEW_LOCATION_TYPE_CODE),
OLD_LOCATION_ID = decode( p_OLD_LOCATION_ID, FND_API.G_MISS_NUM, OLD_LOCATION_ID, p_OLD_LOCATION_ID),
NEW_LOCATION_ID = decode( p_NEW_LOCATION_ID, FND_API.G_MISS_NUM, NEW_LOCATION_ID, p_NEW_LOCATION_ID),
OLD_INV_ORGANIZATION_ID = decode( p_OLD_INV_ORGANIZATION_ID, FND_API.G_MISS_NUM, OLD_INV_ORGANIZATION_ID, p_OLD_INV_ORGANIZATION_ID),
NEW_INV_ORGANIZATION_ID = decode( p_NEW_INV_ORGANIZATION_ID, FND_API.G_MISS_NUM, NEW_INV_ORGANIZATION_ID, p_NEW_INV_ORGANIZATION_ID),
OLD_INV_SUBINVENTORY_NAME = decode( p_OLD_INV_SUBINVENTORY_NAME, FND_API.G_MISS_CHAR, OLD_INV_SUBINVENTORY_NAME, p_OLD_INV_SUBINVENTORY_NAME),
NEW_INV_SUBINVENTORY_NAME = decode( p_NEW_INV_SUBINVENTORY_NAME, FND_API.G_MISS_CHAR, NEW_INV_SUBINVENTORY_NAME, p_NEW_INV_SUBINVENTORY_NAME),
OLD_INV_LOCATOR_ID = decode( p_OLD_INV_LOCATOR_ID, FND_API.G_MISS_NUM, OLD_INV_LOCATOR_ID, p_OLD_INV_LOCATOR_ID),
NEW_INV_LOCATOR_ID = decode( p_NEW_INV_LOCATOR_ID, FND_API.G_MISS_NUM, NEW_INV_LOCATOR_ID, p_NEW_INV_LOCATOR_ID),
OLD_PA_PROJECT_ID = decode( p_OLD_PA_PROJECT_ID, FND_API.G_MISS_NUM, OLD_PA_PROJECT_ID, p_OLD_PA_PROJECT_ID),
NEW_PA_PROJECT_ID = decode( p_NEW_PA_PROJECT_ID, FND_API.G_MISS_NUM, NEW_PA_PROJECT_ID, p_NEW_PA_PROJECT_ID),
OLD_PA_PROJECT_TASK_ID = decode( p_OLD_PA_PROJECT_TASK_ID, FND_API.G_MISS_NUM, OLD_PA_PROJECT_TASK_ID, p_OLD_PA_PROJECT_TASK_ID),
NEW_PA_PROJECT_TASK_ID = decode( p_NEW_PA_PROJECT_TASK_ID, FND_API.G_MISS_NUM, NEW_PA_PROJECT_TASK_ID, p_NEW_PA_PROJECT_TASK_ID),
OLD_IN_TRANSIT_ORDER_LINE_ID = decode( p_OLD_IN_TRANSIT_ORDER_LINE_ID, FND_API.G_MISS_NUM, OLD_IN_TRANSIT_ORDER_LINE_ID, p_OLD_IN_TRANSIT_ORDER_LINE_ID),
NEW_IN_TRANSIT_ORDER_LINE_ID = decode( p_NEW_IN_TRANSIT_ORDER_LINE_ID, FND_API.G_MISS_NUM, NEW_IN_TRANSIT_ORDER_LINE_ID, p_NEW_IN_TRANSIT_ORDER_LINE_ID),
OLD_WIP_JOB_ID = decode( p_OLD_WIP_JOB_ID, FND_API.G_MISS_NUM, OLD_WIP_JOB_ID, p_OLD_WIP_JOB_ID),
NEW_WIP_JOB_ID = decode( p_NEW_WIP_JOB_ID, FND_API.G_MISS_NUM, NEW_WIP_JOB_ID, p_NEW_WIP_JOB_ID),
OLD_PO_ORDER_LINE_ID = decode( p_OLD_PO_ORDER_LINE_ID, FND_API.G_MISS_NUM, OLD_PO_ORDER_LINE_ID, p_OLD_PO_ORDER_LINE_ID),
NEW_PO_ORDER_LINE_ID = decode( p_NEW_PO_ORDER_LINE_ID, FND_API.G_MISS_NUM, NEW_PO_ORDER_LINE_ID, p_NEW_PO_ORDER_LINE_ID),
OLD_COMPLETENESS_FLAG = decode( p_OLD_COMPLETENESS_FLAG, FND_API.G_MISS_CHAR, OLD_COMPLETENESS_FLAG, p_OLD_COMPLETENESS_FLAG),
NEW_COMPLETENESS_FLAG = decode( p_NEW_COMPLETENESS_FLAG, FND_API.G_MISS_CHAR, NEW_COMPLETENESS_FLAG, p_NEW_COMPLETENESS_FLAG),
FULL_DUMP_FLAG = decode(p_FULL_DUMP_FLAG, FND_API.G_MISS_CHAR, FULL_DUMP_FLAG, p_FULL_DUMP_FLAG),
OLD_CONTEXT = decode( p_OLD_CONTEXT, FND_API.G_MISS_CHAR, OLD_CONTEXT, p_OLD_CONTEXT),
NEW_CONTEXT = decode( p_NEW_CONTEXT, FND_API.G_MISS_CHAR, NEW_CONTEXT, p_NEW_CONTEXT),
OLD_ATTRIBUTE1 = decode( p_OLD_ATTRIBUTE1, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE1, p_OLD_ATTRIBUTE1),
NEW_ATTRIBUTE1 = decode( p_NEW_ATTRIBUTE1, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE1, p_NEW_ATTRIBUTE1),
OLD_ATTRIBUTE2 = decode( p_OLD_ATTRIBUTE2, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE2, p_OLD_ATTRIBUTE2),
NEW_ATTRIBUTE2 = decode( p_NEW_ATTRIBUTE2, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE2, p_NEW_ATTRIBUTE2),
OLD_ATTRIBUTE3 = decode( p_OLD_ATTRIBUTE3, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE3, p_OLD_ATTRIBUTE3),
NEW_ATTRIBUTE3 = decode( p_NEW_ATTRIBUTE3, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE3, p_NEW_ATTRIBUTE3),
OLD_ATTRIBUTE4 = decode( p_OLD_ATTRIBUTE4, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE4, p_OLD_ATTRIBUTE4),
NEW_ATTRIBUTE4 = decode( p_NEW_ATTRIBUTE4, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE4, p_NEW_ATTRIBUTE4),
OLD_ATTRIBUTE5 = decode( p_OLD_ATTRIBUTE5, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE5, p_OLD_ATTRIBUTE5),
NEW_ATTRIBUTE5 = decode( p_NEW_ATTRIBUTE5, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE5, p_NEW_ATTRIBUTE5),
OLD_ATTRIBUTE6 = decode( p_OLD_ATTRIBUTE6, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE6, p_OLD_ATTRIBUTE6),
NEW_ATTRIBUTE6 = decode( p_NEW_ATTRIBUTE6, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE6, p_NEW_ATTRIBUTE6),
OLD_ATTRIBUTE7 = decode( p_OLD_ATTRIBUTE7, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE7, p_OLD_ATTRIBUTE7),
NEW_ATTRIBUTE7 = decode( p_NEW_ATTRIBUTE7, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE7, p_NEW_ATTRIBUTE7),
OLD_ATTRIBUTE8 = decode( p_OLD_ATTRIBUTE8, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE8, p_OLD_ATTRIBUTE8),
NEW_ATTRIBUTE8 = decode( p_NEW_ATTRIBUTE8, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE8, p_NEW_ATTRIBUTE8),
OLD_ATTRIBUTE9 = decode( p_OLD_ATTRIBUTE9, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE9, p_OLD_ATTRIBUTE9),
NEW_ATTRIBUTE9 = decode( p_NEW_ATTRIBUTE9, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE9, p_NEW_ATTRIBUTE9),
OLD_ATTRIBUTE10 = decode( p_OLD_ATTRIBUTE10, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE10, p_OLD_ATTRIBUTE10),
NEW_ATTRIBUTE10 = decode( p_NEW_ATTRIBUTE10, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE10, p_NEW_ATTRIBUTE10),
OLD_ATTRIBUTE11 = decode( p_OLD_ATTRIBUTE11, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE11, p_OLD_ATTRIBUTE11),
NEW_ATTRIBUTE11 = decode( p_NEW_ATTRIBUTE11, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE11, p_NEW_ATTRIBUTE11),
OLD_ATTRIBUTE12 = decode( p_OLD_ATTRIBUTE12, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE12, p_OLD_ATTRIBUTE12),
NEW_ATTRIBUTE12 = decode( p_NEW_ATTRIBUTE12, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE12, p_NEW_ATTRIBUTE12),
OLD_ATTRIBUTE13 = decode( p_OLD_ATTRIBUTE13, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE13, p_OLD_ATTRIBUTE13),
NEW_ATTRIBUTE13 = decode( p_NEW_ATTRIBUTE13, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE13, p_NEW_ATTRIBUTE13),
OLD_ATTRIBUTE14 = decode( p_OLD_ATTRIBUTE14, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE14, p_OLD_ATTRIBUTE14),
NEW_ATTRIBUTE14 = decode( p_NEW_ATTRIBUTE14, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE14, p_NEW_ATTRIBUTE14),
OLD_ATTRIBUTE15 = decode( p_OLD_ATTRIBUTE15, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE15, p_OLD_ATTRIBUTE15),
NEW_ATTRIBUTE15 = decode( p_NEW_ATTRIBUTE15, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE15, p_NEW_ATTRIBUTE15),
CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),
OLD_INST_LOC_TYPE_CODE = decode( p_OLD_INST_LOC_TYPE_CODE, FND_API.G_MISS_CHAR, OLD_INST_LOC_TYPE_CODE, p_OLD_INST_LOC_TYPE_CODE),
NEW_INST_LOC_TYPE_CODE = decode( p_NEW_INST_LOC_TYPE_CODE, FND_API.G_MISS_CHAR, NEW_INST_LOC_TYPE_CODE, p_NEW_INST_LOC_TYPE_CODE),
OLD_INST_LOC_ID = decode( p_OLD_INST_LOC_ID, FND_API.G_MISS_NUM, OLD_INST_LOC_ID, p_OLD_INST_LOC_ID),
NEW_INST_LOC_ID = decode( p_NEW_INST_LOC_ID, FND_API.G_MISS_NUM, NEW_INST_LOC_ID, p_NEW_INST_LOC_ID),
OLD_INST_USAGE_CODE = decode( p_OLD_INST_USAGE_CODE, FND_API.G_MISS_CHAR, OLD_INST_USAGE_CODE, p_OLD_INST_USAGE_CODE),
NEW_INST_USAGE_CODE = decode( p_NEW_INST_USAGE_CODE, FND_API.G_MISS_CHAR, NEW_INST_USAGE_CODE, p_NEW_INST_USAGE_CODE),
OLD_last_vld_organization_id = decode( p_OLD_last_vld_organization_id, FND_API.G_MISS_NUM, OLD_last_vld_organization_id, p_OLD_last_vld_organization_id),
NEW_last_vld_organization_id = decode( p_NEW_last_vld_organization_id, FND_API.G_MISS_NUM, NEW_last_vld_organization_id, p_NEW_last_vld_organization_id),
OLD_CONFIG_INST_REV_NUM = decode( p_OLD_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, OLD_CONFIG_INST_REV_NUM, p_OLD_CONFIG_INST_REV_NUM),
NEW_CONFIG_INST_REV_NUM = decode( p_NEW_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, NEW_CONFIG_INST_REV_NUM, p_NEW_CONFIG_INST_REV_NUM),
OLD_CONFIG_VALID_STATUS = decode( p_OLD_CONFIG_VALID_STATUS, FND_API.G_MISS_CHAR, OLD_CONFIG_VALID_STATUS, p_OLD_CONFIG_VALID_STATUS),
NEW_CONFIG_VALID_STATUS = decode( p_NEW_CONFIG_VALID_STATUS, FND_API.G_MISS_CHAR, NEW_CONFIG_VALID_STATUS, p_NEW_CONFIG_VALID_STATUS),
OLD_INSTANCE_DESCRIPTION = decode( p_OLD_INSTANCE_DESCRIPTION, FND_API.G_MISS_CHAR, OLD_INSTANCE_DESCRIPTION, p_OLD_INSTANCE_DESCRIPTION),
NEW_INSTANCE_DESCRIPTION = decode( p_NEW_INSTANCE_DESCRIPTION, FND_API.G_MISS_CHAR, NEW_INSTANCE_DESCRIPTION, p_NEW_INSTANCE_DESCRIPTION),
OLD_INSTALL_DATE = decode( p_OLD_INSTALL_DATE,FND_API.G_MISS_DATE, OLD_INSTALL_DATE, p_OLD_INSTALL_DATE),
NEW_INSTALL_DATE = decode( p_NEW_INSTALL_DATE ,FND_API.G_MISS_DATE, NEW_INSTALL_DATE, p_NEW_INSTALL_DATE),
OLD_RETURN_BY_DATE = decode( p_OLD_RETURN_BY_DATE,FND_API.G_MISS_DATE, OLD_RETURN_BY_DATE, p_OLD_RETURN_BY_DATE),
NEW_RETURN_BY_DATE = decode( p_NEW_RETURN_BY_DATE,FND_API.G_MISS_DATE, NEW_RETURN_BY_DATE, p_NEW_RETURN_BY_DATE),
OLD_ACTUAL_RETURN_DATE = decode( p_OLD_ACTUAL_RETURN_DATE,FND_API.G_MISS_DATE, OLD_ACTUAL_RETURN_DATE, p_OLD_ACTUAL_RETURN_DATE),
NEW_ACTUAL_RETURN_DATE = decode( p_NEW_ACTUAL_RETURN_DATE,FND_API.G_MISS_DATE, NEW_ACTUAL_RETURN_DATE, p_NEW_ACTUAL_RETURN_DATE),
OLD_OE_AGREEMENT_ID = decode(p_OLD_LAST_OE_AGREEMENT_ID, FND_API.G_MISS_NUM,OLD_OE_AGREEMENT_ID,p_OLD_LAST_OE_AGREEMENT_ID),
NEW_OE_AGREEMENT_ID = decode(p_NEW_LAST_OE_AGREEMENT_ID, FND_API.G_MISS_NUM,NEW_OE_AGREEMENT_ID,p_NEW_LAST_OE_AGREEMENT_ID),
OLD_LAST_OE_ORDER_LINE_ID = decode(p_OLD_LAST_OE_ORDER_LINE_ID,FND_API.G_MISS_NUM,OLD_LAST_OE_ORDER_LINE_ID,p_OLD_LAST_OE_ORDER_LINE_ID),
NEW_LAST_OE_ORDER_LINE_ID = decode(p_NEW_LAST_OE_ORDER_LINE_ID,FND_API.G_MISS_NUM,NEW_LAST_OE_ORDER_LINE_ID,p_NEW_LAST_OE_ORDER_LINE_ID),
OLD_LAST_OE_RMA_LINE_ID = decode(p_OLD_LAST_OE_RMA_LINE_ID,FND_API.G_MISS_NUM,OLD_LAST_OE_RMA_LINE_ID,p_OLD_LAST_OE_RMA_LINE_ID),
NEW_LAST_OE_RMA_LINE_ID = decode(p_NEW_LAST_OE_RMA_LINE_ID,FND_API.G_MISS_NUM,NEW_LAST_OE_RMA_LINE_ID,p_NEW_LAST_OE_RMA_LINE_ID),
OLD_LAST_WIP_JOB_ID = decode(p_OLD_LAST_WIP_JOB_ID,FND_API.G_MISS_NUM,OLD_LAST_WIP_JOB_ID,p_OLD_LAST_WIP_JOB_ID),
NEW_LAST_WIP_JOB_ID = decode(p_NEW_LAST_WIP_JOB_ID,FND_API.G_MISS_NUM,NEW_LAST_WIP_JOB_ID,p_NEW_LAST_WIP_JOB_ID),
OLD_LAST_PO_PO_LINE_ID = decode(p_OLD_LAST_PO_PO_LINE_ID,FND_API.G_MISS_NUM,OLD_LAST_PO_PO_LINE_ID,p_OLD_LAST_PO_PO_LINE_ID),
NEW_LAST_PO_PO_LINE_ID = decode(p_NEW_LAST_PO_PO_LINE_ID,FND_API.G_MISS_NUM,NEW_LAST_PO_PO_LINE_ID,p_NEW_LAST_PO_PO_LINE_ID),
OLD_LAST_PA_PROJECT_ID = decode(p_OLD_LAST_PA_PROJECT_ID,FND_API.G_MISS_NUM,OLD_LAST_PA_PROJECT_ID,p_OLD_LAST_PA_PROJECT_ID),
NEW_LAST_PA_PROJECT_ID = decode(p_NEW_LAST_PA_PROJECT_ID,FND_API.G_MISS_NUM,NEW_LAST_PA_PROJECT_ID,p_NEW_LAST_PA_PROJECT_ID),
OLD_LAST_PA_TASK_ID = decode(p_OLD_LAST_PA_TASK_ID,FND_API.G_MISS_NUM,OLD_LAST_PA_TASK_ID,p_OLD_LAST_PA_TASK_ID),
NEW_LAST_PA_TASK_ID = decode(p_NEW_LAST_PA_TASK_ID,FND_API.G_MISS_NUM,NEW_LAST_PA_TASK_ID,p_NEW_LAST_PA_TASK_ID),
OLD_LAST_TXN_LINE_DETAIL_ID = decode(p_OLD_LAST_TXN_LINE_DETAIL_ID,FND_API.G_MISS_NUM,OLD_LAST_TXN_LINE_DETAIL_ID,p_OLD_LAST_TXN_LINE_DETAIL_ID),
NEW_LAST_TXN_LINE_DETAIL_ID = decode(p_NEW_LAST_TXN_LINE_DETAIL_ID,FND_API.G_MISS_NUM,NEW_LAST_TXN_LINE_DETAIL_ID,p_NEW_LAST_TXN_LINE_DETAIL_ID),
OLD_LAST_OE_PO_NUMBER = decode(p_OLD_LAST_OE_PO_NUMBER,FND_API.G_MISS_CHAR,OLD_LAST_OE_PO_NUMBER,p_OLD_LAST_OE_PO_NUMBER),
NEW_LAST_OE_PO_NUMBER = decode(p_NEW_LAST_OE_PO_NUMBER,FND_API.G_MISS_CHAR,NEW_LAST_OE_PO_NUMBER,p_NEW_LAST_OE_PO_NUMBER),
--start of eam integration changes--
OLD_NETWORK_ASSET_FLAG = decode( p_OLD_NETWORK_ASSET_FLAG, FND_API.G_MISS_CHAR, OLD_NETWORK_ASSET_FLAG, p_OLD_NETWORK_ASSET_FLAG),
NEW_NETWORK_ASSET_FLAG = decode( p_NEW_NETWORK_ASSET_FLAG, FND_API.G_MISS_CHAR, NEW_NETWORK_ASSET_FLAG, p_NEW_NETWORK_ASSET_FLAG),
OLD_MAINTAINABLE_FLAG = decode( p_OLD_MAINTAINABLE_FLAG, FND_API.G_MISS_CHAR, OLD_MAINTAINABLE_FLAG, p_OLD_MAINTAINABLE_FLAG),
NEW_MAINTAINABLE_FLAG = decode( p_NEW_MAINTAINABLE_FLAG, FND_API.G_MISS_CHAR, NEW_MAINTAINABLE_FLAG, p_NEW_MAINTAINABLE_FLAG),
OLD_PN_LOCATION_ID = decode( p_OLD_PN_LOCATION_ID, FND_API.G_MISS_NUM, OLD_PN_LOCATION_ID, p_OLD_PN_LOCATION_ID),
NEW_PN_LOCATION_ID = decode( p_NEW_PN_LOCATION_ID, FND_API.G_MISS_NUM, NEW_PN_LOCATION_ID, p_NEW_PN_LOCATION_ID),
OLD_ASSET_CRITICALITY_CODE = decode( p_OLD_ASSET_CRITICALITY_CODE, FND_API.G_MISS_CHAR, OLD_ASSET_CRITICALITY_CODE, p_OLD_ASSET_CRITICALITY_CODE),
NEW_ASSET_CRITICALITY_CODE = decode( p_NEW_ASSET_CRITICALITY_CODE, FND_API.G_MISS_CHAR, NEW_ASSET_CRITICALITY_CODE, p_NEW_ASSET_CRITICALITY_CODE),
OLD_CATEGORY_ID = decode( p_OLD_CATEGORY_ID, FND_API.G_MISS_NUM, OLD_CATEGORY_ID, p_OLD_CATEGORY_ID),
NEW_CATEGORY_ID = decode( p_NEW_CATEGORY_ID, FND_API.G_MISS_NUM, NEW_CATEGORY_ID, p_NEW_CATEGORY_ID),
OLD_EQUIPMENT_GEN_OBJECT_ID = decode( p_OLD_EQUIPMENT_GEN_OBJECT_ID, FND_API.G_MISS_NUM, OLD_EQUIPMENT_GEN_OBJECT_ID, p_OLD_EQUIPMENT_GEN_OBJECT_ID),
NEW_EQUIPMENT_GEN_OBJECT_ID = decode( p_NEW_EQUIPMENT_GEN_OBJECT_ID, FND_API.G_MISS_NUM, NEW_EQUIPMENT_GEN_OBJECT_ID, p_NEW_EQUIPMENT_GEN_OBJECT_ID),
OLD_INSTANTIATION_FLAG = decode( p_OLD_INSTANTIATION_FLAG, FND_API.G_MISS_CHAR, OLD_INSTANTIATION_FLAG, p_OLD_INSTANTIATION_FLAG),
NEW_INSTANTIATION_FLAG = decode( p_NEW_INSTANTIATION_FLAG, FND_API.G_MISS_CHAR, NEW_INSTANTIATION_FLAG, p_NEW_INSTANTIATION_FLAG),
OLD_LINEAR_LOCATION_ID = decode( p_OLD_LINEAR_LOCATION_ID, FND_API.G_MISS_NUM, OLD_LINEAR_LOCATION_ID, p_OLD_LINEAR_LOCATION_ID),
NEW_LINEAR_LOCATION_ID = decode( p_NEW_LINEAR_LOCATION_ID, FND_API.G_MISS_NUM, NEW_LINEAR_LOCATION_ID, p_NEW_LINEAR_LOCATION_ID),
OLD_OPERATIONAL_LOG_FLAG = decode( p_OLD_OPERATIONAL_LOG_FLAG, FND_API.G_MISS_CHAR, OLD_OPERATIONAL_LOG_FLAG, p_OLD_OPERATIONAL_LOG_FLAG),
NEW_OPERATIONAL_LOG_FLAG = decode( p_NEW_OPERATIONAL_LOG_FLAG, FND_API.G_MISS_CHAR, NEW_OPERATIONAL_LOG_FLAG, p_NEW_OPERATIONAL_LOG_FLAG),
OLD_CHECKIN_STATUS = decode( p_OLD_CHECKIN_STATUS, FND_API.G_MISS_NUM, OLD_CHECKIN_STATUS, p_OLD_CHECKIN_STATUS),
NEW_CHECKIN_STATUS = decode( p_NEW_CHECKIN_STATUS, FND_API.G_MISS_NUM, NEW_CHECKIN_STATUS, p_NEW_CHECKIN_STATUS),
OLD_SUPPLIER_WARRANTY_EXP_DATE = decode( p_OLD_SUP_WARRANTY_EXP_DATE, FND_API.G_MISS_DATE, OLD_SUPPLIER_WARRANTY_EXP_DATE, p_OLD_SUP_WARRANTY_EXP_DATE),
NEW_SUPPLIER_WARRANTY_EXP_DATE = decode( p_NEW_SUP_WARRANTY_EXP_DATE, FND_API.G_MISS_DATE, NEW_SUPPLIER_WARRANTY_EXP_DATE, p_NEW_SUP_WARRANTY_EXP_DATE),
OLD_ATTRIBUTE16 = decode( p_OLD_ATTRIBUTE16, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE16, p_OLD_ATTRIBUTE16),
NEW_ATTRIBUTE16 = decode( p_NEW_ATTRIBUTE16, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE16, p_NEW_ATTRIBUTE16),
OLD_ATTRIBUTE17 = decode( p_OLD_ATTRIBUTE17, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE17, p_OLD_ATTRIBUTE17),
NEW_ATTRIBUTE17 = decode( p_NEW_ATTRIBUTE17, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE17, p_NEW_ATTRIBUTE17),
OLD_ATTRIBUTE18 = decode( p_OLD_ATTRIBUTE18, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE18, p_OLD_ATTRIBUTE18),
NEW_ATTRIBUTE18 = decode( p_NEW_ATTRIBUTE18, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE18, p_NEW_ATTRIBUTE18),
OLD_ATTRIBUTE19 = decode( p_OLD_ATTRIBUTE19, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE19, p_OLD_ATTRIBUTE19),
NEW_ATTRIBUTE19 = decode( p_NEW_ATTRIBUTE19, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE19, p_NEW_ATTRIBUTE19),
OLD_ATTRIBUTE20 = decode( p_OLD_ATTRIBUTE20, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE20, p_OLD_ATTRIBUTE20),
NEW_ATTRIBUTE20 = decode( p_NEW_ATTRIBUTE20, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE20, p_NEW_ATTRIBUTE20),
OLD_ATTRIBUTE21 = decode( p_OLD_ATTRIBUTE21, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE21, p_OLD_ATTRIBUTE21),
NEW_ATTRIBUTE21 = decode( p_NEW_ATTRIBUTE21, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE21, p_NEW_ATTRIBUTE21),
OLD_ATTRIBUTE22 = decode( p_OLD_ATTRIBUTE22, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE22, p_OLD_ATTRIBUTE22),
NEW_ATTRIBUTE22 = decode( p_NEW_ATTRIBUTE22, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE22, p_NEW_ATTRIBUTE22),
OLD_ATTRIBUTE23 = decode( p_OLD_ATTRIBUTE23, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE23, p_OLD_ATTRIBUTE23),
NEW_ATTRIBUTE23 = decode( p_NEW_ATTRIBUTE23, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE23, p_NEW_ATTRIBUTE23),
OLD_ATTRIBUTE24 = decode( p_OLD_ATTRIBUTE24, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE24, p_OLD_ATTRIBUTE24),
NEW_ATTRIBUTE24 = decode( p_NEW_ATTRIBUTE24, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE24, p_NEW_ATTRIBUTE24),
OLD_ATTRIBUTE25 = decode( p_OLD_ATTRIBUTE25, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE25, p_OLD_ATTRIBUTE25),
NEW_ATTRIBUTE25 = decode( p_NEW_ATTRIBUTE25, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE25, p_NEW_ATTRIBUTE25),
OLD_ATTRIBUTE26 = decode( p_OLD_ATTRIBUTE26, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE26, p_OLD_ATTRIBUTE26),
NEW_ATTRIBUTE26 = decode( p_NEW_ATTRIBUTE26, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE26, p_NEW_ATTRIBUTE26),
OLD_ATTRIBUTE27 = decode( p_OLD_ATTRIBUTE27, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE27, p_OLD_ATTRIBUTE27),
NEW_ATTRIBUTE27 = decode( p_NEW_ATTRIBUTE27, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE27, p_NEW_ATTRIBUTE27),
OLD_ATTRIBUTE28 = decode( p_OLD_ATTRIBUTE28, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE28, p_OLD_ATTRIBUTE28),
NEW_ATTRIBUTE28 = decode( p_NEW_ATTRIBUTE28, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE28, p_NEW_ATTRIBUTE28),
OLD_ATTRIBUTE29 = decode( p_OLD_ATTRIBUTE29, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE29, p_OLD_ATTRIBUTE29),
NEW_ATTRIBUTE29 = decode( p_NEW_ATTRIBUTE29, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE29, p_NEW_ATTRIBUTE29),
OLD_ATTRIBUTE30 = decode( p_OLD_ATTRIBUTE30, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE30, p_OLD_ATTRIBUTE30),
NEW_ATTRIBUTE30 = decode( p_NEW_ATTRIBUTE30, FND_API.G_MISS_CHAR, NEW_ATTRIBUTE30, p_NEW_ATTRIBUTE30),
--end of eam integration changes--
-- Addition of columns for FA Integration
OLD_PAYABLES_UNIT_PRICE = decode( p_OLD_PAYABLES_UNIT_PRICE, FND_API.G_MISS_NUM, OLD_PAYABLES_UNIT_PRICE, p_OLD_PAYABLES_UNIT_PRICE),
NEW_PAYABLES_UNIT_PRICE = decode( p_NEW_PAYABLES_UNIT_PRICE, FND_API.G_MISS_NUM, NEW_PAYABLES_UNIT_PRICE, p_NEW_PAYABLES_UNIT_PRICE),
OLD_PAYABLES_CURRENCY_CODE = decode( p_OLD_PAYABLES_CURRENCY_CODE, FND_API.G_MISS_CHAR, OLD_PAYABLES_CURRENCY_CODE, p_OLD_PAYABLES_CURRENCY_CODE),
NEW_PAYABLES_CURRENCY_CODE = decode( p_NEW_PAYABLES_CURRENCY_CODE, FND_API.G_MISS_CHAR, NEW_PAYABLES_CURRENCY_CODE, p_NEW_PAYABLES_CURRENCY_CODE),
OLD_PURCHASE_UNIT_PRICE = decode( p_OLD_PURCHASE_UNIT_PRICE, FND_API.G_MISS_NUM, OLD_PURCHASE_UNIT_PRICE, p_OLD_PURCHASE_UNIT_PRICE),
NEW_PURCHASE_UNIT_PRICE = decode( p_NEW_PURCHASE_UNIT_PRICE, FND_API.G_MISS_NUM, NEW_PURCHASE_UNIT_PRICE, p_NEW_PURCHASE_UNIT_PRICE),
OLD_PURCHASE_CURRENCY_CODE = decode( p_OLD_PURCHASE_CURRENCY_CODE, FND_API.G_MISS_CHAR, OLD_PURCHASE_CURRENCY_CODE, p_OLD_PURCHASE_CURRENCY_CODE),
NEW_PURCHASE_CURRENCY_CODE = decode( p_NEW_PURCHASE_CURRENCY_CODE, FND_API.G_MISS_CHAR, NEW_PURCHASE_CURRENCY_CODE, p_NEW_PURCHASE_CURRENCY_CODE),
OLD_SALES_UNIT_PRICE = decode( p_OLD_SALES_UNIT_PRICE, FND_API.G_MISS_NUM, OLD_SALES_UNIT_PRICE, p_OLD_SALES_UNIT_PRICE),
NEW_SALES_UNIT_PRICE = decode( p_NEW_SALES_UNIT_PRICE, FND_API.G_MISS_NUM, NEW_SALES_UNIT_PRICE, p_NEW_SALES_UNIT_PRICE),
OLD_SALES_CURRENCY_CODE = decode( p_OLD_SALES_CURRENCY_CODE, FND_API.G_MISS_CHAR, OLD_SALES_CURRENCY_CODE, p_OLD_SALES_CURRENCY_CODE),
NEW_SALES_CURRENCY_CODE = decode( p_NEW_SALES_CURRENCY_CODE, FND_API.G_MISS_CHAR, NEW_SALES_CURRENCY_CODE, p_NEW_SALES_CURRENCY_CODE),
OLD_OPERATIONAL_STATUS_CODE = decode( p_OLD_OPERATIONAL_STATUS_CODE, FND_API.G_MISS_CHAR, OLD_OPERATIONAL_STATUS_CODE, p_OLD_OPERATIONAL_STATUS_CODE),
NEW_OPERATIONAL_STATUS_CODE = decode( p_NEW_OPERATIONAL_STATUS_CODE, FND_API.G_MISS_CHAR, NEW_OPERATIONAL_STATUS_CODE, p_NEW_OPERATIONAL_STATUS_CODE),
-- End addition of columns for FA Integration
-- Begin Add Code for Siebel Genesis Project
OLD_SOURCE_CODE = decode(p_OLD_SOURCE_CODE,FND_API.G_MISS_CHAR,OLD_SOURCE_CODE,p_OLD_SOURCE_CODE),
NEW_SOURCE_CODE = decode(p_NEW_SOURCE_CODE,FND_API.G_MISS_CHAR,NEW_SOURCE_CODE,p_NEW_SOURCE_CODE)
-- End Add Code for Siebel Genesis Project
WHERE INSTANCE_HISTORY_ID = p_INSTANCE_HISTORY_ID;
END Update_Row;
PROCEDURE Delete_Row(
p_INSTANCE_HISTORY_ID NUMBER)
IS
BEGIN
DELETE FROM CSI_ITEM_INSTANCES_H
WHERE INSTANCE_HISTORY_ID = p_INSTANCE_HISTORY_ID;
END Delete_Row;
p_LAST_UPDATED_BY NUMBER,
p_LAST_UPDATE_DATE DATE,
p_LAST_UPDATE_LOGIN NUMBER,
p_OBJECT_VERSION_NUMBER NUMBER,
p_OLD_INST_LOC_TYPE_CODE VARCHAR2,
p_NEW_INST_LOC_TYPE_CODE VARCHAR2,
p_OLD_INST_LOC_ID NUMBER,
p_NEW_INST_LOC_ID NUMBER,
p_OLD_INST_USAGE_CODE VARCHAR2,
p_NEW_INST_USAGE_CODE VARCHAR2,
p_OLD_CONFIG_INST_REV_NUM NUMBER,
p_NEW_CONFIG_INST_REV_NUM NUMBER,
p_OLD_CONFIG_VALID_STATUS VARCHAR2,
p_NEW_CONFIG_VALID_STATUS VARCHAR2,
p_OLD_INSTANCE_DESCRIPTION VARCHAR2,
p_NEW_INSTANCE_DESCRIPTION VARCHAR2,
p_OLD_LAST_OE_AGREEMENT_ID NUMBER,
p_NEW_LAST_OE_AGREEMENT_ID NUMBER,
p_OLD_LAST_OE_ORDER_LINE_ID NUMBER ,
p_NEW_LAST_OE_ORDER_LINE_ID NUMBER ,
p_OLD_LAST_OE_RMA_LINE_ID NUMBER ,
p_NEW_LAST_OE_RMA_LINE_ID NUMBER ,
p_OLD_LAST_WIP_JOB_ID NUMBER ,
p_NEW_LAST_WIP_JOB_ID NUMBER ,
p_OLD_LAST_PO_PO_LINE_ID NUMBER ,
p_NEW_LAST_PO_PO_LINE_ID NUMBER ,
p_OLD_LAST_PA_PROJECT_ID NUMBER ,
p_NEW_LAST_PA_PROJECT_ID NUMBER ,
p_OLD_LAST_PA_TASK_ID NUMBER ,
p_NEW_LAST_PA_TASK_ID NUMBER ,
p_OLD_LAST_TXN_LINE_DETAIL_ID NUMBER ,
p_NEW_LAST_TXN_LINE_DETAIL_ID NUMBER ,
p_OLD_LAST_OE_PO_NUMBER VARCHAR2,
p_NEW_LAST_OE_PO_NUMBER VARCHAR2,
--start of eam integration changes--
p_OLD_NETWORK_ASSET_FLAG VARCHAR2,
p_NEW_NETWORK_ASSET_FLAG VARCHAR2,
p_OLD_MAINTAINABLE_FLAG VARCHAR2,
p_NEW_MAINTAINABLE_FLAG VARCHAR2,
p_OLD_PN_LOCATION_ID NUMBER,
p_NEW_PN_LOCATION_ID NUMBER,
p_OLD_ASSET_CRITICALITY_CODE VARCHAR2,
p_NEW_ASSET_CRITICALITY_CODE VARCHAR2,
p_OLD_CATEGORY_ID NUMBER,
p_NEW_CATEGORY_ID NUMBER,
p_OLD_EQUIPMENT_GEN_OBJECT_ID NUMBER,
p_NEW_EQUIPMENT_GEN_OBJECT_ID NUMBER,
p_OLD_INSTANTIATION_FLAG VARCHAR2,
p_NEW_INSTANTIATION_FLAG VARCHAR2,
p_OLD_LINEAR_LOCATION_ID NUMBER,
p_NEW_LINEAR_LOCATION_ID NUMBER,
p_OLD_OPERATIONAL_LOG_FLAG VARCHAR2,
p_NEW_OPERATIONAL_LOG_FLAG VARCHAR2,
p_OLD_CHECKIN_STATUS NUMBER,
p_NEW_CHECKIN_STATUS NUMBER,
p_OLD_SUP_WARRANTY_EXP_DATE DATE,
p_NEW_SUP_WARRANTY_EXP_DATE DATE,
p_OLD_ATTRIBUTE16 VARCHAR2,
p_NEW_ATTRIBUTE16 VARCHAR2,
p_OLD_ATTRIBUTE17 VARCHAR2,
p_NEW_ATTRIBUTE17 VARCHAR2,
p_OLD_ATTRIBUTE18 VARCHAR2,
p_NEW_ATTRIBUTE18 VARCHAR2,
p_OLD_ATTRIBUTE19 VARCHAR2,
p_NEW_ATTRIBUTE19 VARCHAR2,
p_OLD_ATTRIBUTE20 VARCHAR2,
p_NEW_ATTRIBUTE20 VARCHAR2,
p_OLD_ATTRIBUTE21 VARCHAR2,
p_NEW_ATTRIBUTE21 VARCHAR2,
p_OLD_ATTRIBUTE22 VARCHAR2,
p_NEW_ATTRIBUTE22 VARCHAR2,
p_OLD_ATTRIBUTE23 VARCHAR2,
p_NEW_ATTRIBUTE23 VARCHAR2,
p_OLD_ATTRIBUTE24 VARCHAR2,
p_NEW_ATTRIBUTE24 VARCHAR2,
p_OLD_ATTRIBUTE25 VARCHAR2,
p_NEW_ATTRIBUTE25 VARCHAR2,
p_OLD_ATTRIBUTE26 VARCHAR2,
p_NEW_ATTRIBUTE26 VARCHAR2,
p_OLD_ATTRIBUTE27 VARCHAR2,
p_NEW_ATTRIBUTE27 VARCHAR2,
p_OLD_ATTRIBUTE28 VARCHAR2,
p_NEW_ATTRIBUTE28 VARCHAR2,
p_OLD_ATTRIBUTE29 VARCHAR2,
p_NEW_ATTRIBUTE29 VARCHAR2,
p_OLD_ATTRIBUTE30 VARCHAR2,
p_NEW_ATTRIBUTE30 VARCHAR2,
--end of eam integration changes--
-- Addition of columns for FA Integration
p_OLD_PAYABLES_UNIT_PRICE NUMBER,
p_NEW_PAYABLES_UNIT_PRICE NUMBER,
p_OLD_PAYABLES_CURRENCY_CODE VARCHAR2,
p_NEW_PAYABLES_CURRENCY_CODE VARCHAR2,
p_OLD_PURCHASE_UNIT_PRICE NUMBER,
p_NEW_PURCHASE_UNIT_PRICE NUMBER,
p_OLD_PURCHASE_CURRENCY_CODE VARCHAR2,
p_NEW_PURCHASE_CURRENCY_CODE VARCHAR2,
p_OLD_SALES_UNIT_PRICE NUMBER,
p_NEW_SALES_UNIT_PRICE NUMBER,
p_OLD_SALES_CURRENCY_CODE VARCHAR2,
p_NEW_SALES_CURRENCY_CODE VARCHAR2,
p_OLD_OPERATIONAL_STATUS_CODE VARCHAR2,
p_NEW_OPERATIONAL_STATUS_CODE VARCHAR2,
-- End addition of columns for FA Integration
-- Begin Add Code for Siebel Genesis Project
p_OLD_SOURCE_CODE VARCHAR2,
p_NEW_SOURCE_CODE VARCHAR2
-- End Add Code for Siebel Genesis Project
)
IS
CURSOR C IS
SELECT *
FROM CSI_ITEM_INSTANCES_H
WHERE INSTANCE_HISTORY_ID = p_INSTANCE_HISTORY_ID
FOR UPDATE of INSTANCE_HISTORY_ID NOWAIT;
FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
AND ( ( Recinfo.LAST_UPDATED_BY = p_LAST_UPDATED_BY)
OR ( ( Recinfo.LAST_UPDATED_BY IS NULL )
AND ( p_LAST_UPDATED_BY IS NULL )))
AND ( ( Recinfo.LAST_UPDATE_DATE = p_LAST_UPDATE_DATE)
OR ( ( Recinfo.LAST_UPDATE_DATE IS NULL )
AND ( p_LAST_UPDATE_DATE IS NULL )))
AND ( ( Recinfo.LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN)
OR ( ( Recinfo.LAST_UPDATE_LOGIN IS NULL )
AND ( p_LAST_UPDATE_LOGIN IS NULL )))
AND ( ( Recinfo.OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER)
OR ( ( Recinfo.OBJECT_VERSION_NUMBER IS NULL )
AND ( p_OBJECT_VERSION_NUMBER IS NULL )))
AND ( ( Recinfo.OLD_INST_LOC_TYPE_CODE = p_OLD_INST_LOC_TYPE_CODE)
OR ( ( Recinfo.OLD_INST_LOC_TYPE_CODE IS NULL )
AND ( p_OLD_INST_LOC_TYPE_CODE IS NULL )))
AND ( ( Recinfo.NEW_INST_LOC_TYPE_CODE = p_NEW_INST_LOC_TYPE_CODE)
OR ( ( Recinfo.NEW_INST_LOC_TYPE_CODE IS NULL )
AND ( p_NEW_INST_LOC_TYPE_CODE IS NULL )))
AND ( ( Recinfo.OLD_INST_LOC_ID = p_OLD_INST_LOC_ID)
OR ( ( Recinfo.OLD_INST_LOC_ID IS NULL )
AND ( p_OLD_INST_LOC_ID IS NULL )))
AND ( ( Recinfo.NEW_INST_LOC_ID = p_NEW_INST_LOC_ID)
OR ( ( Recinfo.NEW_INST_LOC_ID IS NULL )
AND ( p_NEW_INST_LOC_ID IS NULL )))
AND ( ( Recinfo.OLD_INST_USAGE_CODE = p_OLD_INST_USAGE_CODE)
OR ( ( Recinfo.OLD_INST_USAGE_CODE IS NULL )
AND ( p_OLD_INST_USAGE_CODE IS NULL )))
AND ( ( Recinfo.NEW_INST_USAGE_CODE = p_NEW_INST_USAGE_CODE)
OR ( ( Recinfo.NEW_INST_USAGE_CODE IS NULL )
AND ( p_NEW_INST_USAGE_CODE IS NULL )))
AND ( ( Recinfo.OLD_CONFIG_INST_REV_NUM = p_OLD_CONFIG_INST_REV_NUM)
OR ( ( Recinfo.OLD_CONFIG_INST_REV_NUM IS NULL )
AND ( p_OLD_CONFIG_INST_REV_NUM IS NULL )))
AND ( ( Recinfo.NEW_CONFIG_INST_REV_NUM = p_NEW_CONFIG_INST_REV_NUM)
OR ( ( Recinfo.NEW_CONFIG_INST_REV_NUM IS NULL )
AND ( p_NEW_CONFIG_INST_REV_NUM IS NULL )))
AND ( ( Recinfo.OLD_CONFIG_VALID_STATUS = p_OLD_CONFIG_VALID_STATUS)
OR ( ( Recinfo.OLD_CONFIG_VALID_STATUS IS NULL )
AND ( p_OLD_CONFIG_VALID_STATUS IS NULL )))
AND ( ( Recinfo.NEW_CONFIG_VALID_STATUS = p_NEW_CONFIG_VALID_STATUS)
OR ( ( Recinfo.NEW_CONFIG_VALID_STATUS IS NULL )
AND ( p_NEW_CONFIG_VALID_STATUS IS NULL )))
AND ( ( Recinfo.OLD_INSTANCE_DESCRIPTION = p_OLD_INSTANCE_DESCRIPTION)
OR ( ( Recinfo.OLD_INSTANCE_DESCRIPTION IS NULL )
AND ( p_OLD_INSTANCE_DESCRIPTION IS NULL )))
AND ( ( Recinfo.NEW_INSTANCE_DESCRIPTION = p_NEW_INSTANCE_DESCRIPTION)
OR ( ( Recinfo.NEW_INSTANCE_DESCRIPTION IS NULL )
AND ( p_NEW_INSTANCE_DESCRIPTION IS NULL )))
AND ( ( Recinfo.OLD_OE_AGREEMENT_ID = p_OLD_LAST_OE_AGREEMENT_ID)
OR ( ( Recinfo.OLD_OE_AGREEMENT_ID IS NULL )
AND ( p_OLD_LAST_OE_AGREEMENT_ID IS NULL )))
AND ( ( Recinfo.NEW_OE_AGREEMENT_ID = p_NEW_LAST_OE_AGREEMENT_ID)
OR ( ( Recinfo.NEW_OE_AGREEMENT_ID IS NULL )
AND ( p_NEW_LAST_OE_AGREEMENT_ID IS NULL )))
AND ( ( Recinfo.OLD_LAST_OE_ORDER_LINE_ID = p_OLD_LAST_OE_ORDER_LINE_ID)
OR ( ( Recinfo.OLD_LAST_OE_ORDER_LINE_ID IS NULL )
AND ( p_OLD_LAST_OE_ORDER_LINE_ID IS NULL )))
AND ( ( Recinfo.NEW_LAST_OE_ORDER_LINE_ID = p_NEW_LAST_OE_ORDER_LINE_ID)
OR ( ( Recinfo.NEW_LAST_OE_ORDER_LINE_ID IS NULL )
AND ( p_NEW_LAST_OE_ORDER_LINE_ID IS NULL )))
AND ( ( Recinfo.OLD_LAST_OE_RMA_LINE_ID = p_OLD_LAST_OE_RMA_LINE_ID)
OR ( ( Recinfo.OLD_LAST_OE_RMA_LINE_ID IS NULL )
AND ( p_OLD_LAST_OE_RMA_LINE_ID IS NULL )))
AND ( ( Recinfo.NEW_LAST_OE_RMA_LINE_ID = p_NEW_LAST_OE_RMA_LINE_ID)
OR ( ( Recinfo.NEW_LAST_OE_RMA_LINE_ID IS NULL )
AND ( p_NEW_LAST_OE_RMA_LINE_ID IS NULL )))
AND ( ( Recinfo.OLD_LAST_WIP_JOB_ID = p_OLD_LAST_WIP_JOB_ID)
OR ( ( Recinfo.OLD_LAST_WIP_JOB_ID IS NULL )
AND ( p_OLD_LAST_WIP_JOB_ID IS NULL )))
AND ( ( Recinfo.NEW_LAST_WIP_JOB_ID = p_NEW_LAST_WIP_JOB_ID)
OR ( ( Recinfo.NEW_LAST_WIP_JOB_ID IS NULL )
AND ( p_NEW_LAST_WIP_JOB_ID IS NULL )))
AND ( ( Recinfo.OLD_LAST_PO_PO_LINE_ID = p_OLD_LAST_PO_PO_LINE_ID)
OR ( ( Recinfo.OLD_LAST_PO_PO_LINE_ID IS NULL )
AND ( p_OLD_LAST_PO_PO_LINE_ID IS NULL )))
AND ( ( Recinfo.NEW_LAST_PO_PO_LINE_ID = p_NEW_LAST_PO_PO_LINE_ID)
OR ( ( Recinfo.NEW_LAST_PO_PO_LINE_ID IS NULL )
AND ( p_NEW_LAST_PO_PO_LINE_ID IS NULL )))
AND ( ( Recinfo.OLD_LAST_PA_PROJECT_ID = p_OLD_LAST_PA_PROJECT_ID)
OR ( ( Recinfo.OLD_LAST_PA_PROJECT_ID IS NULL )
AND ( p_OLD_LAST_PA_PROJECT_ID IS NULL )))
AND ( ( Recinfo.NEW_LAST_PA_PROJECT_ID = p_NEW_LAST_PA_PROJECT_ID)
OR ( ( Recinfo.NEW_LAST_PA_PROJECT_ID IS NULL )
AND ( p_NEW_LAST_PA_PROJECT_ID IS NULL )))
AND ( ( Recinfo.OLD_LAST_PA_TASK_ID = p_OLD_LAST_PA_TASK_ID)
OR ( ( Recinfo.OLD_LAST_PA_TASK_ID IS NULL )
AND ( p_OLD_LAST_PA_TASK_ID IS NULL )))
AND ( ( Recinfo.NEW_LAST_PA_TASK_ID = p_NEW_LAST_PA_TASK_ID)
OR ( ( Recinfo.NEW_LAST_PA_TASK_ID IS NULL )
AND ( p_NEW_LAST_PA_TASK_ID IS NULL )))
AND ( ( Recinfo.OLD_LAST_TXN_LINE_DETAIL_ID = p_OLD_LAST_TXN_LINE_DETAIL_ID)
OR ( ( Recinfo.OLD_LAST_TXN_LINE_DETAIL_ID IS NULL )
AND ( p_OLD_LAST_TXN_LINE_DETAIL_ID IS NULL )))
AND ( ( Recinfo.NEW_LAST_TXN_LINE_DETAIL_ID = p_NEW_LAST_TXN_LINE_DETAIL_ID)
OR ( ( Recinfo.NEW_LAST_TXN_LINE_DETAIL_ID IS NULL )
AND ( p_NEW_LAST_TXN_LINE_DETAIL_ID IS NULL )))
AND ( ( Recinfo.OLD_LAST_OE_PO_NUMBER = p_OLD_LAST_OE_PO_NUMBER)
OR ( ( Recinfo.OLD_LAST_OE_PO_NUMBER IS NULL )
AND ( p_OLD_LAST_OE_PO_NUMBER IS NULL )))
AND ( ( Recinfo.NEW_LAST_OE_PO_NUMBER = p_NEW_LAST_OE_PO_NUMBER)
OR ( ( Recinfo.NEW_LAST_OE_PO_NUMBER IS NULL )
AND ( p_NEW_LAST_OE_PO_NUMBER IS NULL )))
--start of eam integration changes--
AND ( ( Recinfo.OLD_NETWORK_ASSET_FLAG = p_OLD_NETWORK_ASSET_FLAG)
OR ( ( Recinfo.OLD_NETWORK_ASSET_FLAG IS NULL )
AND ( p_OLD_NETWORK_ASSET_FLAG IS NULL )))
AND ( ( Recinfo.NEW_NETWORK_ASSET_FLAG = p_NEW_NETWORK_ASSET_FLAG)
OR ( ( Recinfo.NEW_NETWORK_ASSET_FLAG IS NULL )
AND ( p_NEW_NETWORK_ASSET_FLAG IS NULL )))
AND ( ( Recinfo.OLD_MAINTAINABLE_FLAG = p_OLD_MAINTAINABLE_FLAG)
OR ( ( Recinfo.OLD_MAINTAINABLE_FLAG IS NULL )
AND ( p_OLD_MAINTAINABLE_FLAG IS NULL )))
AND ( ( Recinfo.NEW_MAINTAINABLE_FLAG = p_NEW_MAINTAINABLE_FLAG)
OR ( ( Recinfo.NEW_MAINTAINABLE_FLAG IS NULL )
AND ( p_NEW_MAINTAINABLE_FLAG IS NULL )))
AND ( ( Recinfo.OLD_PN_LOCATION_ID = p_OLD_PN_LOCATION_ID)
OR ( ( Recinfo.OLD_PN_LOCATION_ID IS NULL )
AND ( p_OLD_PN_LOCATION_ID IS NULL )))
AND ( ( Recinfo.NEW_PN_LOCATION_ID = p_NEW_PN_LOCATION_ID)
OR ( ( Recinfo.NEW_PN_LOCATION_ID IS NULL )
AND ( p_NEW_PN_LOCATION_ID IS NULL )))
AND ( ( Recinfo.OLD_ASSET_CRITICALITY_CODE = p_OLD_ASSET_CRITICALITY_CODE)
OR ( ( Recinfo.OLD_ASSET_CRITICALITY_CODE IS NULL )
AND ( p_OLD_ASSET_CRITICALITY_CODE IS NULL )))
AND ( ( Recinfo.NEW_ASSET_CRITICALITY_CODE = p_NEW_ASSET_CRITICALITY_CODE)
OR ( ( Recinfo.NEW_ASSET_CRITICALITY_CODE IS NULL )
AND ( p_NEW_ASSET_CRITICALITY_CODE IS NULL )))
AND ( ( Recinfo.OLD_CATEGORY_ID = p_OLD_CATEGORY_ID)
OR ( ( Recinfo.OLD_CATEGORY_ID IS NULL )
AND ( p_OLD_CATEGORY_ID IS NULL )))
AND ( ( Recinfo.NEW_CATEGORY_ID = p_NEW_CATEGORY_ID)
OR ( ( Recinfo.NEW_CATEGORY_ID IS NULL )
AND ( p_NEW_CATEGORY_ID IS NULL )))
AND ( ( Recinfo.OLD_EQUIPMENT_GEN_OBJECT_ID = p_OLD_EQUIPMENT_GEN_OBJECT_ID)
OR ( ( Recinfo.OLD_EQUIPMENT_GEN_OBJECT_ID IS NULL )
AND ( p_OLD_EQUIPMENT_GEN_OBJECT_ID IS NULL )))
AND ( ( Recinfo.NEW_EQUIPMENT_GEN_OBJECT_ID = p_NEW_EQUIPMENT_GEN_OBJECT_ID)
OR ( ( Recinfo.NEW_EQUIPMENT_GEN_OBJECT_ID IS NULL )
AND ( p_NEW_EQUIPMENT_GEN_OBJECT_ID IS NULL )))
AND ( ( Recinfo.OLD_INSTANTIATION_FLAG = p_OLD_INSTANTIATION_FLAG)
OR ( ( Recinfo.OLD_INSTANTIATION_FLAG IS NULL )
AND ( p_OLD_INSTANTIATION_FLAG IS NULL )))
AND ( ( Recinfo.NEW_INSTANTIATION_FLAG = p_NEW_INSTANTIATION_FLAG)
OR ( ( Recinfo.NEW_INSTANTIATION_FLAG IS NULL )
AND ( p_NEW_INSTANTIATION_FLAG IS NULL )))
AND ( ( Recinfo.OLD_LINEAR_LOCATION_ID = p_OLD_LINEAR_LOCATION_ID)
OR ( ( Recinfo.OLD_LINEAR_LOCATION_ID IS NULL )
AND ( p_OLD_LINEAR_LOCATION_ID IS NULL )))
AND ( ( Recinfo.NEW_LINEAR_LOCATION_ID = p_NEW_LINEAR_LOCATION_ID)
OR ( ( Recinfo.NEW_LINEAR_LOCATION_ID IS NULL )
AND ( p_NEW_LINEAR_LOCATION_ID IS NULL )))
AND ( ( Recinfo.OLD_OPERATIONAL_LOG_FLAG = p_OLD_OPERATIONAL_LOG_FLAG)
OR ( ( Recinfo.OLD_OPERATIONAL_LOG_FLAG IS NULL )
AND ( p_OLD_OPERATIONAL_LOG_FLAG IS NULL )))
AND ( ( Recinfo.NEW_OPERATIONAL_LOG_FLAG = p_NEW_OPERATIONAL_LOG_FLAG)
OR ( ( Recinfo.NEW_OPERATIONAL_LOG_FLAG IS NULL )
AND ( p_NEW_OPERATIONAL_LOG_FLAG IS NULL )))
AND ( ( Recinfo.OLD_CHECKIN_STATUS = p_OLD_CHECKIN_STATUS)
OR ( ( Recinfo.OLD_CHECKIN_STATUS IS NULL )
AND ( p_OLD_CHECKIN_STATUS IS NULL )))
AND ( ( Recinfo.NEW_CHECKIN_STATUS = p_NEW_CHECKIN_STATUS)
OR ( ( Recinfo.NEW_CHECKIN_STATUS IS NULL )
AND ( p_NEW_CHECKIN_STATUS IS NULL )))
AND ( ( Recinfo.OLD_SUPPLIER_WARRANTY_EXP_DATE = p_OLD_SUP_WARRANTY_EXP_DATE)
OR ( ( Recinfo.OLD_SUPPLIER_WARRANTY_EXP_DATE IS NULL )
AND ( p_OLD_SUP_WARRANTY_EXP_DATE IS NULL )))
AND ( ( Recinfo.NEW_SUPPLIER_WARRANTY_EXP_DATE = p_NEW_SUP_WARRANTY_EXP_DATE)
OR ( ( Recinfo.NEW_SUPPLIER_WARRANTY_EXP_DATE IS NULL )
AND ( p_NEW_SUP_WARRANTY_EXP_DATE IS NULL )))
AND ( ( Recinfo.OLD_ATTRIBUTE16 = p_OLD_ATTRIBUTE16)
OR ( ( Recinfo.OLD_ATTRIBUTE16 IS NULL )
AND ( p_OLD_ATTRIBUTE16 IS NULL )))
AND ( ( Recinfo.NEW_ATTRIBUTE16 = p_NEW_ATTRIBUTE16)
OR ( ( Recinfo.NEW_ATTRIBUTE16 IS NULL )
AND ( p_NEW_ATTRIBUTE16 IS NULL )))
AND ( ( Recinfo.OLD_ATTRIBUTE17 = p_OLD_ATTRIBUTE17)
OR ( ( Recinfo.OLD_ATTRIBUTE17 IS NULL )
AND ( p_OLD_ATTRIBUTE17 IS NULL )))
AND ( ( Recinfo.NEW_ATTRIBUTE17 = p_NEW_ATTRIBUTE17)
OR ( ( Recinfo.NEW_ATTRIBUTE17 IS NULL )
AND ( p_NEW_ATTRIBUTE17 IS NULL )))
AND ( ( Recinfo.OLD_ATTRIBUTE18 = p_OLD_ATTRIBUTE18)
OR ( ( Recinfo.OLD_ATTRIBUTE18 IS NULL )
AND ( p_OLD_ATTRIBUTE18 IS NULL )))
AND ( ( Recinfo.NEW_ATTRIBUTE18 = p_NEW_ATTRIBUTE18)
OR ( ( Recinfo.NEW_ATTRIBUTE18 IS NULL )
AND ( p_NEW_ATTRIBUTE18 IS NULL )))
AND ( ( Recinfo.OLD_ATTRIBUTE19 = p_OLD_ATTRIBUTE19)
OR ( ( Recinfo.OLD_ATTRIBUTE19 IS NULL )
AND ( p_OLD_ATTRIBUTE19 IS NULL )))
AND ( ( Recinfo.NEW_ATTRIBUTE19 = p_NEW_ATTRIBUTE19)
OR ( ( Recinfo.NEW_ATTRIBUTE19 IS NULL )
AND ( p_NEW_ATTRIBUTE19 IS NULL )))
AND ( ( Recinfo.OLD_ATTRIBUTE20 = p_OLD_ATTRIBUTE20)
OR ( ( Recinfo.OLD_ATTRIBUTE20 IS NULL )
AND ( p_OLD_ATTRIBUTE20 IS NULL )))
AND ( ( Recinfo.NEW_ATTRIBUTE20 = p_NEW_ATTRIBUTE20)
OR ( ( Recinfo.NEW_ATTRIBUTE20 IS NULL )
AND ( p_NEW_ATTRIBUTE20 IS NULL )))
AND ( ( Recinfo.OLD_ATTRIBUTE21 = p_OLD_ATTRIBUTE21)
OR ( ( Recinfo.OLD_ATTRIBUTE21 IS NULL )
AND ( p_OLD_ATTRIBUTE21 IS NULL )))
AND ( ( Recinfo.NEW_ATTRIBUTE21 = p_NEW_ATTRIBUTE21)
OR ( ( Recinfo.NEW_ATTRIBUTE21 IS NULL )
AND ( p_NEW_ATTRIBUTE21 IS NULL )))
AND ( ( Recinfo.OLD_ATTRIBUTE22 = p_OLD_ATTRIBUTE22)
OR ( ( Recinfo.OLD_ATTRIBUTE22 IS NULL )
AND ( p_OLD_ATTRIBUTE22 IS NULL )))
AND ( ( Recinfo.NEW_ATTRIBUTE22 = p_NEW_ATTRIBUTE22)
OR ( ( Recinfo.NEW_ATTRIBUTE22 IS NULL )
AND ( p_NEW_ATTRIBUTE22 IS NULL )))
AND ( ( Recinfo.OLD_ATTRIBUTE23 = p_OLD_ATTRIBUTE23)
OR ( ( Recinfo.OLD_ATTRIBUTE23 IS NULL )
AND ( p_OLD_ATTRIBUTE23 IS NULL )))
AND ( ( Recinfo.NEW_ATTRIBUTE23 = p_NEW_ATTRIBUTE23)
OR ( ( Recinfo.NEW_ATTRIBUTE23 IS NULL )
AND ( p_NEW_ATTRIBUTE23 IS NULL )))
AND ( ( Recinfo.OLD_ATTRIBUTE24 = p_OLD_ATTRIBUTE24)
OR ( ( Recinfo.OLD_ATTRIBUTE24 IS NULL )
AND ( p_OLD_ATTRIBUTE24 IS NULL )))
AND ( ( Recinfo.NEW_ATTRIBUTE24 = p_NEW_ATTRIBUTE24)
OR ( ( Recinfo.NEW_ATTRIBUTE24 IS NULL )
AND ( p_NEW_ATTRIBUTE24 IS NULL )))
AND ( ( Recinfo.OLD_ATTRIBUTE25 = p_OLD_ATTRIBUTE25)
OR ( ( Recinfo.OLD_ATTRIBUTE25 IS NULL )
AND ( p_OLD_ATTRIBUTE25 IS NULL )))
AND ( ( Recinfo.NEW_ATTRIBUTE25 = p_NEW_ATTRIBUTE25)
OR ( ( Recinfo.NEW_ATTRIBUTE25 IS NULL )
AND ( p_NEW_ATTRIBUTE25 IS NULL )))
AND ( ( Recinfo.OLD_ATTRIBUTE26 = p_OLD_ATTRIBUTE26)
OR ( ( Recinfo.OLD_ATTRIBUTE26 IS NULL )
AND ( p_OLD_ATTRIBUTE26 IS NULL )))
AND ( ( Recinfo.NEW_ATTRIBUTE26 = p_NEW_ATTRIBUTE26)
OR ( ( Recinfo.NEW_ATTRIBUTE26 IS NULL )
AND ( p_NEW_ATTRIBUTE26 IS NULL )))
AND ( ( Recinfo.OLD_ATTRIBUTE27 = p_OLD_ATTRIBUTE27)
OR ( ( Recinfo.OLD_ATTRIBUTE27 IS NULL )
AND ( p_OLD_ATTRIBUTE27 IS NULL )))
AND ( ( Recinfo.NEW_ATTRIBUTE27 = p_NEW_ATTRIBUTE27)
OR ( ( Recinfo.NEW_ATTRIBUTE27 IS NULL )
AND ( p_NEW_ATTRIBUTE27 IS NULL )))
AND ( ( Recinfo.OLD_ATTRIBUTE28 = p_OLD_ATTRIBUTE28)
OR ( ( Recinfo.OLD_ATTRIBUTE28 IS NULL )
AND ( p_OLD_ATTRIBUTE28 IS NULL )))
AND ( ( Recinfo.NEW_ATTRIBUTE28 = p_NEW_ATTRIBUTE28)
OR ( ( Recinfo.NEW_ATTRIBUTE28 IS NULL )
AND ( p_NEW_ATTRIBUTE28 IS NULL )))
AND ( ( Recinfo.OLD_ATTRIBUTE29 = p_OLD_ATTRIBUTE29)
OR ( ( Recinfo.OLD_ATTRIBUTE29 IS NULL )
AND ( p_OLD_ATTRIBUTE29 IS NULL )))
AND ( ( Recinfo.NEW_ATTRIBUTE29 = p_NEW_ATTRIBUTE29)
OR ( ( Recinfo.NEW_ATTRIBUTE29 IS NULL )
AND ( p_NEW_ATTRIBUTE29 IS NULL )))
AND ( ( Recinfo.OLD_ATTRIBUTE30 = p_OLD_ATTRIBUTE30)
OR ( ( Recinfo.OLD_ATTRIBUTE30 IS NULL )
AND ( p_OLD_ATTRIBUTE30 IS NULL )))
AND ( ( Recinfo.NEW_ATTRIBUTE30 = p_NEW_ATTRIBUTE30)
OR ( ( Recinfo.NEW_ATTRIBUTE30 IS NULL )
AND ( p_NEW_ATTRIBUTE30 IS NULL )))
--end of eam integration changes--
-- Addition of columns for FA Integration
AND ( ( Recinfo.OLD_PAYABLES_UNIT_PRICE = p_OLD_PAYABLES_UNIT_PRICE)
OR ( ( Recinfo.OLD_PAYABLES_UNIT_PRICE IS NULL )
AND ( p_OLD_PAYABLES_UNIT_PRICE IS NULL )))
AND ( ( Recinfo.NEW_PAYABLES_UNIT_PRICE = p_NEW_PAYABLES_UNIT_PRICE)
OR ( ( Recinfo.NEW_PAYABLES_UNIT_PRICE IS NULL )
AND ( p_NEW_PAYABLES_UNIT_PRICE IS NULL )))
AND ( ( Recinfo.OLD_PAYABLES_CURRENCY_CODE = p_OLD_PAYABLES_CURRENCY_CODE)
OR ( ( Recinfo.OLD_PAYABLES_CURRENCY_CODE IS NULL )
AND ( p_OLD_PAYABLES_CURRENCY_CODE IS NULL )))
AND ( ( Recinfo.NEW_PAYABLES_CURRENCY_CODE = p_NEW_PAYABLES_CURRENCY_CODE)
OR ( ( Recinfo.NEW_PAYABLES_CURRENCY_CODE IS NULL )
AND ( p_NEW_PAYABLES_CURRENCY_CODE IS NULL )))
AND ( ( Recinfo.OLD_PURCHASE_UNIT_PRICE = p_OLD_PURCHASE_UNIT_PRICE)
OR ( ( Recinfo.OLD_PURCHASE_UNIT_PRICE IS NULL )
AND ( p_OLD_PURCHASE_UNIT_PRICE IS NULL )))
AND ( ( Recinfo.NEW_PURCHASE_UNIT_PRICE = p_NEW_PURCHASE_UNIT_PRICE)
OR ( ( Recinfo.NEW_PURCHASE_UNIT_PRICE IS NULL )
AND ( p_NEW_PURCHASE_UNIT_PRICE IS NULL )))
AND ( ( Recinfo.OLD_PURCHASE_CURRENCY_CODE = p_OLD_PURCHASE_CURRENCY_CODE)
OR ( ( Recinfo.OLD_PURCHASE_CURRENCY_CODE IS NULL )
AND ( p_OLD_PURCHASE_CURRENCY_CODE IS NULL )))
AND ( ( Recinfo.NEW_PURCHASE_CURRENCY_CODE = p_NEW_PURCHASE_CURRENCY_CODE)
OR ( ( Recinfo.NEW_PURCHASE_CURRENCY_CODE IS NULL )
AND ( p_NEW_PURCHASE_CURRENCY_CODE IS NULL )))
AND ( ( Recinfo.OLD_SALES_UNIT_PRICE = p_OLD_SALES_UNIT_PRICE)
OR ( ( Recinfo.OLD_SALES_UNIT_PRICE IS NULL )
AND ( p_OLD_SALES_UNIT_PRICE IS NULL )))
AND ( ( Recinfo.NEW_SALES_UNIT_PRICE = p_NEW_SALES_UNIT_PRICE)
OR ( ( Recinfo.NEW_SALES_UNIT_PRICE IS NULL )
AND ( p_NEW_SALES_UNIT_PRICE IS NULL )))
AND ( ( Recinfo.OLD_SALES_CURRENCY_CODE = p_OLD_SALES_CURRENCY_CODE)
OR ( ( Recinfo.OLD_SALES_CURRENCY_CODE IS NULL )
AND ( p_OLD_SALES_CURRENCY_CODE IS NULL )))
AND ( ( Recinfo.NEW_SALES_CURRENCY_CODE = p_NEW_SALES_CURRENCY_CODE)
OR ( ( Recinfo.NEW_SALES_CURRENCY_CODE IS NULL )
AND ( p_NEW_SALES_CURRENCY_CODE IS NULL )))
AND ( ( Recinfo.OLD_OPERATIONAL_STATUS_CODE = p_OLD_OPERATIONAL_STATUS_CODE)
OR ( ( Recinfo.OLD_OPERATIONAL_STATUS_CODE IS NULL )
AND ( p_OLD_OPERATIONAL_STATUS_CODE IS NULL )))
AND ( ( Recinfo.NEW_OPERATIONAL_STATUS_CODE = p_NEW_OPERATIONAL_STATUS_CODE)
OR ( ( Recinfo.NEW_OPERATIONAL_STATUS_CODE IS NULL )
AND ( p_NEW_OPERATIONAL_STATUS_CODE IS NULL )))
-- End addition of columns for FA Integration
-- Begin Add Code for Siebel Genesis Project
AND ( ( Recinfo.OLD_SOURCE_CODE = p_OLD_SOURCE_CODE)
OR ( ( Recinfo.OLD_SOURCE_CODE IS NULL )
AND ( p_OLD_SOURCE_CODE IS NULL )))
AND ( ( Recinfo.NEW_SOURCE_CODE = p_NEW_SOURCE_CODE)
OR ( ( Recinfo.NEW_SOURCE_CODE IS NULL )
AND ( p_NEW_SOURCE_CODE IS NULL )))
-- End Add Code for Siebel Genesis Project
) THEN
RETURN;