The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Row(
px_INSTANCE_ID IN OUT NOCOPY NUMBER,
p_INSTANCE_NUMBER VARCHAR2,
p_EXTERNAL_REFERENCE VARCHAR2,
p_INVENTORY_ITEM_ID NUMBER,
p_INVENTORY_REVISION VARCHAR2,
p_INV_MASTER_ORGANIZATION_ID NUMBER,
p_SERIAL_NUMBER VARCHAR2,
p_MFG_SERIAL_NUMBER_FLAG VARCHAR2,
p_LOT_NUMBER VARCHAR2,
p_QUANTITY NUMBER,
p_UNIT_OF_MEASURE VARCHAR2,
p_ACCOUNTING_CLASS_CODE VARCHAR2,
p_INSTANCE_CONDITION_ID NUMBER,
p_INSTANCE_STATUS_ID NUMBER,
p_CUSTOMER_VIEW_FLAG VARCHAR2,
p_MERCHANT_VIEW_FLAG VARCHAR2,
p_SELLABLE_FLAG VARCHAR2,
p_SYSTEM_ID NUMBER,
p_INSTANCE_TYPE_CODE VARCHAR2,
p_ACTIVE_START_DATE DATE,
p_ACTIVE_END_DATE DATE,
p_LOCATION_TYPE_CODE VARCHAR2,
p_LOCATION_ID NUMBER,
p_INV_ORGANIZATION_ID NUMBER,
p_INV_SUBINVENTORY_NAME VARCHAR2,
p_INV_LOCATOR_ID NUMBER,
p_PA_PROJECT_ID NUMBER,
p_PA_PROJECT_TASK_ID NUMBER,
p_IN_TRANSIT_ORDER_LINE_ID NUMBER,
p_WIP_JOB_ID NUMBER,
p_PO_ORDER_LINE_ID NUMBER,
p_LAST_OE_ORDER_LINE_ID NUMBER,
p_LAST_OE_RMA_LINE_ID NUMBER,
p_LAST_PO_PO_LINE_ID NUMBER,
p_LAST_OE_PO_NUMBER VARCHAR2,
p_LAST_WIP_JOB_ID NUMBER,
p_LAST_PA_PROJECT_ID NUMBER,
p_LAST_PA_TASK_ID NUMBER,
p_LAST_OE_AGREEMENT_ID NUMBER,
p_INSTALL_DATE DATE,
p_MANUALLY_CREATED_FLAG VARCHAR2,
p_RETURN_BY_DATE DATE,
p_ACTUAL_RETURN_DATE DATE,
p_CREATION_COMPLETE_FLAG VARCHAR2,
p_COMPLETENESS_FLAG VARCHAR2,
p_CONTEXT VARCHAR2,
p_ATTRIBUTE1 VARCHAR2,
p_ATTRIBUTE2 VARCHAR2,
p_ATTRIBUTE3 VARCHAR2,
p_ATTRIBUTE4 VARCHAR2,
p_ATTRIBUTE5 VARCHAR2,
p_ATTRIBUTE6 VARCHAR2,
p_ATTRIBUTE7 VARCHAR2,
p_ATTRIBUTE8 VARCHAR2,
p_ATTRIBUTE9 VARCHAR2,
p_ATTRIBUTE10 VARCHAR2,
p_ATTRIBUTE11 VARCHAR2,
p_ATTRIBUTE12 VARCHAR2,
p_ATTRIBUTE13 VARCHAR2,
p_ATTRIBUTE14 VARCHAR2,
p_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_LAST_TXN_LINE_DETAIL_ID NUMBER,
p_INSTALL_LOCATION_TYPE_CODE VARCHAR2,
p_INSTALL_LOCATION_ID NUMBER,
P_INSTANCE_USAGE_CODE VARCHAR2,
p_last_vld_organization_id NUMBER :=fnd_api.g_miss_num,
p_CONFIG_INST_HDR_ID NUMBER,
p_CONFIG_INST_REV_NUM NUMBER,
p_CONFIG_INST_ITEM_ID NUMBER,
p_CONFIG_VALID_STATUS VARCHAR2,
p_INSTANCE_DESCRIPTION VARCHAR2,
p_request_id NUMBER,
p_program_application_id NUMBER,
p_program_id NUMBER,
p_program_update_date DATE,
--start of eam integration changes--
p_NETWORK_ASSET_FLAG VARCHAR2,
p_MAINTAINABLE_FLAG VARCHAR2,
p_PN_LOCATION_ID NUMBER,
p_ASSET_CRITICALITY_CODE VARCHAR2,
p_CATEGORY_ID NUMBER,
p_EQUIPMENT_GEN_OBJECT_ID NUMBER,
p_INSTANTIATION_FLAG VARCHAR2,
p_LINEAR_LOCATION_ID NUMBER,
p_OPERATIONAL_LOG_FLAG VARCHAR2,
p_CHECKIN_STATUS NUMBER,
p_SUPPLIER_WARRANTY_EXP_DATE DATE,
p_ATTRIBUTE16 VARCHAR2,
p_ATTRIBUTE17 VARCHAR2,
p_ATTRIBUTE18 VARCHAR2,
p_ATTRIBUTE19 VARCHAR2,
p_ATTRIBUTE20 VARCHAR2,
p_ATTRIBUTE21 VARCHAR2,
p_ATTRIBUTE22 VARCHAR2,
p_ATTRIBUTE23 VARCHAR2,
p_ATTRIBUTE24 VARCHAR2,
p_ATTRIBUTE25 VARCHAR2,
p_ATTRIBUTE26 VARCHAR2,
p_ATTRIBUTE27 VARCHAR2,
p_ATTRIBUTE28 VARCHAR2,
p_ATTRIBUTE29 VARCHAR2,
p_ATTRIBUTE30 VARCHAR2,
--end of eam integration changes--
-- Addition of columns for FA Integration
p_PURCHASE_UNIT_PRICE NUMBER,
p_PURCHASE_CURRENCY_CODE VARCHAR2,
p_PAYABLES_UNIT_PRICE NUMBER,
p_PAYABLES_CURRENCY_CODE VARCHAR2,
p_SALES_UNIT_PRICE NUMBER,
p_SALES_CURRENCY_CODE VARCHAR2,
p_OPERATIONAL_STATUS_CODE VARCHAR2,
-- End addition of columns for FA Integration
p_SOURCE_CODE VARCHAR2 -- Added Code for Siebel Genesis Project
)
IS
CURSOR C2 IS SELECT CSI_ITEM_INSTANCES_S.NEXTVAL FROM sys.dual;
INSERT INTO CSI_ITEM_INSTANCES(
INSTANCE_ID,
INSTANCE_NUMBER,
EXTERNAL_REFERENCE,
INVENTORY_ITEM_ID,
INVENTORY_REVISION,
INV_MASTER_ORGANIZATION_ID,
SERIAL_NUMBER,
MFG_SERIAL_NUMBER_FLAG,
LOT_NUMBER,
QUANTITY,
UNIT_OF_MEASURE,
ACCOUNTING_CLASS_CODE,
INSTANCE_CONDITION_ID,
INSTANCE_STATUS_ID,
CUSTOMER_VIEW_FLAG,
MERCHANT_VIEW_FLAG,
SELLABLE_FLAG,
SYSTEM_ID,
INSTANCE_TYPE_CODE,
ACTIVE_START_DATE,
ACTIVE_END_DATE,
LOCATION_TYPE_CODE,
LOCATION_ID,
INV_ORGANIZATION_ID,
INV_SUBINVENTORY_NAME,
INV_LOCATOR_ID,
PA_PROJECT_ID,
PA_PROJECT_TASK_ID,
IN_TRANSIT_ORDER_LINE_ID,
WIP_JOB_ID,
PO_ORDER_LINE_ID,
LAST_OE_ORDER_LINE_ID,
LAST_OE_RMA_LINE_ID,
LAST_PO_PO_LINE_ID,
LAST_OE_PO_NUMBER,
LAST_WIP_JOB_ID,
LAST_PA_PROJECT_ID,
LAST_PA_TASK_ID,
LAST_OE_AGREEMENT_ID,
INSTALL_DATE,
MANUALLY_CREATED_FLAG,
RETURN_BY_DATE,
ACTUAL_RETURN_DATE,
CREATION_COMPLETE_FLAG,
COMPLETENESS_FLAG,
CONTEXT,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
OBJECT_VERSION_NUMBER,
LAST_TXN_LINE_DETAIL_ID,
INSTALL_LOCATION_TYPE_CODE,
INSTALL_LOCATION_ID,
INSTANCE_USAGE_CODE,
last_vld_organization_id,
CONFIG_INST_HDR_ID ,
CONFIG_INST_REV_NUM,
CONFIG_INST_ITEM_ID,
CONFIG_VALID_STATUS,
INSTANCE_DESCRIPTION,
request_id ,
program_application_id ,
program_id ,
program_update_date,
--start of eam integration changes--
NETWORK_ASSET_FLAG,
MAINTAINABLE_FLAG,
PN_LOCATION_ID,
ASSET_CRITICALITY_CODE,
CATEGORY_ID,
EQUIPMENT_GEN_OBJECT_ID,
INSTANTIATION_FLAG,
LINEAR_LOCATION_ID,
OPERATIONAL_LOG_FLAG,
CHECKIN_STATUS,
SUPPLIER_WARRANTY_EXP_DATE,
ATTRIBUTE16,
ATTRIBUTE17,
ATTRIBUTE18,
ATTRIBUTE19,
ATTRIBUTE20,
ATTRIBUTE21,
ATTRIBUTE22,
ATTRIBUTE23,
ATTRIBUTE24,
ATTRIBUTE25,
ATTRIBUTE26,
ATTRIBUTE27,
ATTRIBUTE28,
ATTRIBUTE29,
ATTRIBUTE30,
--end of eam integration changes--
-- Addition of columns for FA Integration
PURCHASE_UNIT_PRICE,
PURCHASE_CURRENCY_CODE,
PAYABLES_UNIT_PRICE,
PAYABLES_CURRENCY_CODE,
SALES_UNIT_PRICE,
SALES_CURRENCY_CODE,
OPERATIONAL_STATUS_CODE,
-- End addition of columns for FA Integration
SOURCE_CODE -- Added Code for Siebel Genesis Project
)
VALUES (
px_INSTANCE_ID,
decode( p_INSTANCE_NUMBER, FND_API.G_MISS_CHAR, NULL, p_INSTANCE_NUMBER),
decode( p_EXTERNAL_REFERENCE, FND_API.G_MISS_CHAR, NULL, p_EXTERNAL_REFERENCE),
decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID),
decode( p_INVENTORY_REVISION, FND_API.G_MISS_CHAR, NULL, p_INVENTORY_REVISION),
decode( p_INV_MASTER_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_INV_MASTER_ORGANIZATION_ID),
decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NULL, p_SERIAL_NUMBER),
decode( p_MFG_SERIAL_NUMBER_FLAG, FND_API.G_MISS_CHAR, NULL, p_MFG_SERIAL_NUMBER_FLAG),
decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, NULL, p_LOT_NUMBER),
decode( p_QUANTITY, FND_API.G_MISS_NUM, NULL, p_QUANTITY),
decode( p_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, NULL, p_UNIT_OF_MEASURE),
decode( p_ACCOUNTING_CLASS_CODE, FND_API.G_MISS_CHAR, NULL, p_ACCOUNTING_CLASS_CODE),
decode( p_INSTANCE_CONDITION_ID, FND_API.G_MISS_NUM, NULL, p_INSTANCE_CONDITION_ID),
decode( p_INSTANCE_STATUS_ID, FND_API.G_MISS_NUM, NULL, p_INSTANCE_STATUS_ID),
decode( p_CUSTOMER_VIEW_FLAG, FND_API.G_MISS_CHAR, NULL, p_CUSTOMER_VIEW_FLAG),
decode( p_MERCHANT_VIEW_FLAG, FND_API.G_MISS_CHAR, NULL, p_MERCHANT_VIEW_FLAG),
decode( p_SELLABLE_FLAG, FND_API.G_MISS_CHAR, NULL, p_SELLABLE_FLAG),
decode( p_SYSTEM_ID, FND_API.G_MISS_NUM, NULL, p_SYSTEM_ID),
decode( p_INSTANCE_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_INSTANCE_TYPE_CODE),
decode( p_ACTIVE_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTIVE_START_DATE),
decode( p_ACTIVE_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTIVE_END_DATE),
decode( p_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_LOCATION_TYPE_CODE),
decode( p_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_LOCATION_ID),
decode( p_INV_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_INV_ORGANIZATION_ID),
decode( p_INV_SUBINVENTORY_NAME, FND_API.G_MISS_CHAR, NULL, p_INV_SUBINVENTORY_NAME),
decode( p_INV_LOCATOR_ID, FND_API.G_MISS_NUM, NULL, p_INV_LOCATOR_ID),
decode( p_PA_PROJECT_ID, FND_API.G_MISS_NUM, NULL, p_PA_PROJECT_ID),
decode( p_PA_PROJECT_TASK_ID, FND_API.G_MISS_NUM, NULL, p_PA_PROJECT_TASK_ID),
decode( p_IN_TRANSIT_ORDER_LINE_ID, FND_API.G_MISS_NUM, NULL, p_IN_TRANSIT_ORDER_LINE_ID),
decode( p_WIP_JOB_ID, FND_API.G_MISS_NUM, NULL, p_WIP_JOB_ID),
decode( p_PO_ORDER_LINE_ID, FND_API.G_MISS_NUM, NULL, p_PO_ORDER_LINE_ID),
decode( p_LAST_OE_ORDER_LINE_ID, FND_API.G_MISS_NUM, NULL, p_LAST_OE_ORDER_LINE_ID),
decode( p_LAST_OE_RMA_LINE_ID, FND_API.G_MISS_NUM, NULL, p_LAST_OE_RMA_LINE_ID),
decode( p_LAST_PO_PO_LINE_ID, FND_API.G_MISS_NUM, NULL, p_LAST_PO_PO_LINE_ID),
decode( p_LAST_OE_PO_NUMBER, FND_API.G_MISS_CHAR, NULL, p_LAST_OE_PO_NUMBER),
decode( p_LAST_WIP_JOB_ID, FND_API.G_MISS_NUM, NULL, p_LAST_WIP_JOB_ID),
decode( p_LAST_PA_PROJECT_ID, FND_API.G_MISS_NUM, NULL, p_LAST_PA_PROJECT_ID),
decode( p_LAST_PA_TASK_ID, FND_API.G_MISS_NUM, NULL, p_LAST_PA_TASK_ID),
decode( p_LAST_OE_AGREEMENT_ID, FND_API.G_MISS_NUM, NULL, p_LAST_OE_AGREEMENT_ID),
decode( p_INSTALL_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_INSTALL_DATE),
decode( p_MANUALLY_CREATED_FLAG, FND_API.G_MISS_CHAR, NULL, p_MANUALLY_CREATED_FLAG),
decode( p_RETURN_BY_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_RETURN_BY_DATE),
decode( p_ACTUAL_RETURN_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTUAL_RETURN_DATE),
decode( p_CREATION_COMPLETE_FLAG, FND_API.G_MISS_CHAR, NULL, p_CREATION_COMPLETE_FLAG),
decode( p_COMPLETENESS_FLAG, FND_API.G_MISS_CHAR, NULL, p_COMPLETENESS_FLAG),
decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_CONTEXT),
decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_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_LAST_TXN_LINE_DETAIL_ID, FND_API.G_MISS_NUM, NULL, p_LAST_TXN_LINE_DETAIL_ID),
decode( p_INSTALL_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_INSTALL_LOCATION_TYPE_CODE),
decode( p_INSTALL_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_INSTALL_LOCATION_ID),
decode( p_INSTANCE_USAGE_CODE, FND_API.G_MISS_CHAR, NULL, p_INSTANCE_USAGE_CODE),
decode( p_last_vld_organization_id, FND_API.G_MISS_NUM, NULL, p_last_vld_organization_id),
decode( p_CONFIG_INST_HDR_ID , FND_API.G_MISS_NUM, NULL,p_CONFIG_INST_HDR_ID),
decode( p_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, NULL,p_CONFIG_INST_REV_NUM),
decode( p_CONFIG_INST_ITEM_ID, FND_API.G_MISS_NUM, NULL,p_CONFIG_INST_ITEM_ID),
decode( p_CONFIG_VALID_STATUS, FND_API.G_MISS_CHAR, NULL,p_CONFIG_VALID_STATUS),
decode( p_INSTANCE_DESCRIPTION, FND_API.G_MISS_CHAR, NULL,p_INSTANCE_DESCRIPTION),
decode( p_request_id, fnd_api.g_miss_num, NULL, p_request_id),
decode( p_program_application_id, fnd_api.g_miss_num, NULL, p_program_application_id),
decode( p_program_id, fnd_api.g_miss_num, NULL, p_program_id),
decode( p_program_update_date, fnd_api.g_miss_date, to_date(NULL), p_program_update_date),
--start of eam integration changes--
decode( p_NETWORK_ASSET_FLAG, FND_API.G_MISS_CHAR, NULL, p_NETWORK_ASSET_FLAG),
decode( p_MAINTAINABLE_FLAG, FND_API.G_MISS_CHAR, NULL, p_MAINTAINABLE_FLAG),
decode( p_PN_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_PN_LOCATION_ID),
decode( p_ASSET_CRITICALITY_CODE, FND_API.G_MISS_CHAR, NULL, p_ASSET_CRITICALITY_CODE),
decode( p_CATEGORY_ID, FND_API.G_MISS_NUM, NULL, p_CATEGORY_ID),
decode( p_EQUIPMENT_GEN_OBJECT_ID, FND_API.G_MISS_NUM, NULL, p_EQUIPMENT_GEN_OBJECT_ID),
decode( p_INSTANTIATION_FLAG, FND_API.G_MISS_CHAR, NULL, p_INSTANTIATION_FLAG),
decode( p_LINEAR_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_LINEAR_LOCATION_ID),
decode( p_OPERATIONAL_LOG_FLAG, FND_API.G_MISS_CHAR, NULL, p_OPERATIONAL_LOG_FLAG),
decode( p_CHECKIN_STATUS, FND_API.G_MISS_NUM, NULL, p_CHECKIN_STATUS),
decode( p_SUPPLIER_WARRANTY_EXP_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_SUPPLIER_WARRANTY_EXP_DATE),
decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16),
decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17),
decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18),
decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19),
decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20),
decode( p_ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE21),
decode( p_ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE22),
decode( p_ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE23),
decode( p_ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE24),
decode( p_ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE25),
decode( p_ATTRIBUTE26, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE26),
decode( p_ATTRIBUTE27, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE27),
decode( p_ATTRIBUTE28, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE28),
decode( p_ATTRIBUTE29, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE29),
decode( p_ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE30),
--end of eam integration changes--
-- Addition of columns for FA Integration
decode( p_PURCHASE_UNIT_PRICE, FND_API.G_MISS_NUM, NULL, p_PURCHASE_UNIT_PRICE),
decode( p_PURCHASE_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_PURCHASE_CURRENCY_CODE),
decode( p_PAYABLES_UNIT_PRICE, FND_API.G_MISS_NUM, NULL, p_PAYABLES_UNIT_PRICE),
decode( p_PAYABLES_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_PAYABLES_CURRENCY_CODE),
decode( p_SALES_UNIT_PRICE, FND_API.G_MISS_NUM, NULL, p_SALES_UNIT_PRICE),
decode( p_SALES_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_SALES_CURRENCY_CODE),
decode( p_OPERATIONAL_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_OPERATIONAL_STATUS_CODE),
-- End addition of columns for FA Integration
decode( p_SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_CODE) -- Added Code for Siebel Genesis Project
);
END Insert_Row;
PROCEDURE Update_Row(
p_INSTANCE_ID NUMBER,
p_INSTANCE_NUMBER VARCHAR2,
p_EXTERNAL_REFERENCE VARCHAR2,
p_INVENTORY_ITEM_ID NUMBER,
p_INVENTORY_REVISION VARCHAR2,
p_INV_MASTER_ORGANIZATION_ID NUMBER,
p_SERIAL_NUMBER VARCHAR2,
p_MFG_SERIAL_NUMBER_FLAG VARCHAR2,
p_LOT_NUMBER VARCHAR2,
p_QUANTITY NUMBER,
p_UNIT_OF_MEASURE VARCHAR2,
p_ACCOUNTING_CLASS_CODE VARCHAR2,
p_INSTANCE_CONDITION_ID NUMBER,
p_INSTANCE_STATUS_ID NUMBER,
p_CUSTOMER_VIEW_FLAG VARCHAR2,
p_MERCHANT_VIEW_FLAG VARCHAR2,
p_SELLABLE_FLAG VARCHAR2,
p_SYSTEM_ID NUMBER,
p_INSTANCE_TYPE_CODE VARCHAR2,
p_ACTIVE_START_DATE DATE,
p_ACTIVE_END_DATE DATE,
P_LOCATION_TYPE_CODE VARCHAR2,
p_LOCATION_ID NUMBER,
p_INV_ORGANIZATION_ID NUMBER,
p_INV_SUBINVENTORY_NAME VARCHAR2,
p_INV_LOCATOR_ID NUMBER,
p_PA_PROJECT_ID NUMBER,
p_PA_PROJECT_TASK_ID NUMBER,
p_IN_TRANSIT_ORDER_LINE_ID NUMBER,
p_WIP_JOB_ID NUMBER,
p_PO_ORDER_LINE_ID NUMBER,
p_LAST_OE_ORDER_LINE_ID NUMBER,
p_LAST_OE_RMA_LINE_ID NUMBER,
p_LAST_PO_PO_LINE_ID NUMBER,
p_LAST_OE_PO_NUMBER VARCHAR2,
p_LAST_WIP_JOB_ID NUMBER,
p_LAST_PA_PROJECT_ID NUMBER,
p_LAST_PA_TASK_ID NUMBER,
p_LAST_OE_AGREEMENT_ID NUMBER,
p_INSTALL_DATE DATE,
p_MANUALLY_CREATED_FLAG VARCHAR2,
p_RETURN_BY_DATE DATE,
p_ACTUAL_RETURN_DATE DATE,
p_CREATION_COMPLETE_FLAG VARCHAR2,
p_COMPLETENESS_FLAG VARCHAR2,
p_CONTEXT VARCHAR2,
p_ATTRIBUTE1 VARCHAR2,
p_ATTRIBUTE2 VARCHAR2,
p_ATTRIBUTE3 VARCHAR2,
p_ATTRIBUTE4 VARCHAR2,
p_ATTRIBUTE5 VARCHAR2,
p_ATTRIBUTE6 VARCHAR2,
p_ATTRIBUTE7 VARCHAR2,
p_ATTRIBUTE8 VARCHAR2,
p_ATTRIBUTE9 VARCHAR2,
p_ATTRIBUTE10 VARCHAR2,
p_ATTRIBUTE11 VARCHAR2,
p_ATTRIBUTE12 VARCHAR2,
p_ATTRIBUTE13 VARCHAR2,
p_ATTRIBUTE14 VARCHAR2,
p_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_LAST_TXN_LINE_DETAIL_ID NUMBER,
p_INSTALL_LOCATION_TYPE_CODE VARCHAR2,
p_INSTALL_LOCATION_ID NUMBER,
P_INSTANCE_USAGE_CODE VARCHAR2,
P_last_vld_organization_id NUMBER :=fnd_api.g_miss_num,
p_CONFIG_INST_HDR_ID NUMBER ,
p_CONFIG_INST_REV_NUM NUMBER ,
p_CONFIG_INST_ITEM_ID NUMBER ,
p_CONFIG_VALID_STATUS VARCHAR2 ,
p_INSTANCE_DESCRIPTION VARCHAR2 ,
p_request_id NUMBER ,
p_program_application_id NUMBER ,
p_program_id NUMBER ,
p_program_update_date DATE,
--start of eam integration changes--
p_NETWORK_ASSET_FLAG VARCHAR2,
p_MAINTAINABLE_FLAG VARCHAR2,
p_PN_LOCATION_ID NUMBER,
p_ASSET_CRITICALITY_CODE VARCHAR2,
p_CATEGORY_ID NUMBER,
p_EQUIPMENT_GEN_OBJECT_ID NUMBER,
p_INSTANTIATION_FLAG VARCHAR2,
p_LINEAR_LOCATION_ID NUMBER,
p_OPERATIONAL_LOG_FLAG VARCHAR2,
p_CHECKIN_STATUS NUMBER,
p_SUPPLIER_WARRANTY_EXP_DATE DATE,
p_ATTRIBUTE16 VARCHAR2,
p_ATTRIBUTE17 VARCHAR2,
p_ATTRIBUTE18 VARCHAR2,
p_ATTRIBUTE19 VARCHAR2,
p_ATTRIBUTE20 VARCHAR2,
p_ATTRIBUTE21 VARCHAR2,
p_ATTRIBUTE22 VARCHAR2,
p_ATTRIBUTE23 VARCHAR2,
p_ATTRIBUTE24 VARCHAR2,
p_ATTRIBUTE25 VARCHAR2,
p_ATTRIBUTE26 VARCHAR2,
p_ATTRIBUTE27 VARCHAR2,
p_ATTRIBUTE28 VARCHAR2,
p_ATTRIBUTE29 VARCHAR2,
p_ATTRIBUTE30 VARCHAR2,
--end of eam integration changes--
-- Addition of columns for FA Integration
p_PURCHASE_UNIT_PRICE NUMBER,
p_PURCHASE_CURRENCY_CODE VARCHAR2,
p_PAYABLES_UNIT_PRICE NUMBER,
p_PAYABLES_CURRENCY_CODE VARCHAR2,
p_SALES_UNIT_PRICE NUMBER,
p_SALES_CURRENCY_CODE VARCHAR2,
p_OPERATIONAL_STATUS_CODE VARCHAR2,
-- End addition of columns for FA Integration
p_SOURCE_CODE VARCHAR2 -- Added Code for Siebel Genesis Project
)
IS
BEGIN
UPDATE CSI_ITEM_INSTANCES
SET
INSTANCE_NUMBER = decode( p_INSTANCE_NUMBER, FND_API.G_MISS_CHAR, INSTANCE_NUMBER, p_INSTANCE_NUMBER),
EXTERNAL_REFERENCE = decode( p_EXTERNAL_REFERENCE, FND_API.G_MISS_CHAR, EXTERNAL_REFERENCE, p_EXTERNAL_REFERENCE),
INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID),
INVENTORY_REVISION = decode( p_INVENTORY_REVISION, FND_API.G_MISS_CHAR, INVENTORY_REVISION, p_INVENTORY_REVISION),
INV_MASTER_ORGANIZATION_ID = decode( p_INV_MASTER_ORGANIZATION_ID, FND_API.G_MISS_NUM, INV_MASTER_ORGANIZATION_ID, p_INV_MASTER_ORGANIZATION_ID),
SERIAL_NUMBER = decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, SERIAL_NUMBER, p_SERIAL_NUMBER),
MFG_SERIAL_NUMBER_FLAG = decode( p_MFG_SERIAL_NUMBER_FLAG, FND_API.G_MISS_CHAR, MFG_SERIAL_NUMBER_FLAG, p_MFG_SERIAL_NUMBER_FLAG),
LOT_NUMBER = decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, LOT_NUMBER, p_LOT_NUMBER),
QUANTITY = decode( p_QUANTITY, FND_API.G_MISS_NUM, QUANTITY, p_QUANTITY),
UNIT_OF_MEASURE = decode( p_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, UNIT_OF_MEASURE, p_UNIT_OF_MEASURE),
ACCOUNTING_CLASS_CODE = decode( p_ACCOUNTING_CLASS_CODE, FND_API.G_MISS_CHAR, ACCOUNTING_CLASS_CODE, p_ACCOUNTING_CLASS_CODE),
INSTANCE_CONDITION_ID = decode( p_INSTANCE_CONDITION_ID, FND_API.G_MISS_NUM, INSTANCE_CONDITION_ID, p_INSTANCE_CONDITION_ID),
INSTANCE_STATUS_ID = decode( p_INSTANCE_STATUS_ID, FND_API.G_MISS_NUM, INSTANCE_STATUS_ID, p_INSTANCE_STATUS_ID),
CUSTOMER_VIEW_FLAG = decode( p_CUSTOMER_VIEW_FLAG, FND_API.G_MISS_CHAR, CUSTOMER_VIEW_FLAG, p_CUSTOMER_VIEW_FLAG),
MERCHANT_VIEW_FLAG = decode( p_MERCHANT_VIEW_FLAG, FND_API.G_MISS_CHAR, MERCHANT_VIEW_FLAG, p_MERCHANT_VIEW_FLAG),
SELLABLE_FLAG = decode( p_SELLABLE_FLAG, FND_API.G_MISS_CHAR, SELLABLE_FLAG, p_SELLABLE_FLAG),
SYSTEM_ID = decode( p_SYSTEM_ID, FND_API.G_MISS_NUM, SYSTEM_ID, p_SYSTEM_ID),
INSTANCE_TYPE_CODE = decode( p_INSTANCE_TYPE_CODE, FND_API.G_MISS_CHAR, INSTANCE_TYPE_CODE, p_INSTANCE_TYPE_CODE),
ACTIVE_START_DATE = decode( p_ACTIVE_START_DATE, FND_API.G_MISS_DATE, ACTIVE_START_DATE, p_ACTIVE_START_DATE),
ACTIVE_END_DATE = decode( p_ACTIVE_END_DATE, FND_API.G_MISS_DATE, ACTIVE_END_DATE, p_ACTIVE_END_DATE),
LOCATION_TYPE_CODE = decode( p_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, LOCATION_TYPE_CODE, p_LOCATION_TYPE_CODE),
LOCATION_ID = decode( p_LOCATION_ID, FND_API.G_MISS_NUM, LOCATION_ID, p_LOCATION_ID),
INV_ORGANIZATION_ID = decode( p_INV_ORGANIZATION_ID, FND_API.G_MISS_NUM, INV_ORGANIZATION_ID, p_INV_ORGANIZATION_ID),
INV_SUBINVENTORY_NAME = decode( p_INV_SUBINVENTORY_NAME, FND_API.G_MISS_CHAR, INV_SUBINVENTORY_NAME, p_INV_SUBINVENTORY_NAME),
INV_LOCATOR_ID = decode( p_INV_LOCATOR_ID, FND_API.G_MISS_NUM, INV_LOCATOR_ID, p_INV_LOCATOR_ID),
PA_PROJECT_ID = decode( p_PA_PROJECT_ID, FND_API.G_MISS_NUM, PA_PROJECT_ID, p_PA_PROJECT_ID),
PA_PROJECT_TASK_ID = decode( p_PA_PROJECT_TASK_ID, FND_API.G_MISS_NUM, PA_PROJECT_TASK_ID, p_PA_PROJECT_TASK_ID),
IN_TRANSIT_ORDER_LINE_ID = decode( p_IN_TRANSIT_ORDER_LINE_ID, FND_API.G_MISS_NUM, IN_TRANSIT_ORDER_LINE_ID, p_IN_TRANSIT_ORDER_LINE_ID),
WIP_JOB_ID = decode( p_WIP_JOB_ID, FND_API.G_MISS_NUM, WIP_JOB_ID, p_WIP_JOB_ID),
PO_ORDER_LINE_ID = decode( p_PO_ORDER_LINE_ID, FND_API.G_MISS_NUM, PO_ORDER_LINE_ID, p_PO_ORDER_LINE_ID),
LAST_OE_ORDER_LINE_ID = decode( p_LAST_OE_ORDER_LINE_ID, FND_API.G_MISS_NUM, LAST_OE_ORDER_LINE_ID, p_LAST_OE_ORDER_LINE_ID),
LAST_OE_RMA_LINE_ID = decode( p_LAST_OE_RMA_LINE_ID, FND_API.G_MISS_NUM, LAST_OE_RMA_LINE_ID, p_LAST_OE_RMA_LINE_ID),
LAST_PO_PO_LINE_ID = decode( p_LAST_PO_PO_LINE_ID, FND_API.G_MISS_NUM, LAST_PO_PO_LINE_ID, p_LAST_PO_PO_LINE_ID),
LAST_OE_PO_NUMBER = decode( p_LAST_OE_PO_NUMBER, FND_API.G_MISS_CHAR, LAST_OE_PO_NUMBER, p_LAST_OE_PO_NUMBER),
LAST_WIP_JOB_ID = decode( p_LAST_WIP_JOB_ID, FND_API.G_MISS_NUM, LAST_WIP_JOB_ID, p_LAST_WIP_JOB_ID),
LAST_PA_PROJECT_ID = decode( p_LAST_PA_PROJECT_ID, FND_API.G_MISS_NUM, LAST_PA_PROJECT_ID, p_LAST_PA_PROJECT_ID),
LAST_PA_TASK_ID = decode( p_LAST_PA_TASK_ID, FND_API.G_MISS_NUM, LAST_PA_TASK_ID, p_LAST_PA_TASK_ID),
LAST_OE_AGREEMENT_ID = decode( p_LAST_OE_AGREEMENT_ID, FND_API.G_MISS_NUM, LAST_OE_AGREEMENT_ID, p_LAST_OE_AGREEMENT_ID),
INSTALL_DATE = decode( p_INSTALL_DATE, FND_API.G_MISS_DATE, INSTALL_DATE, p_INSTALL_DATE),
MANUALLY_CREATED_FLAG = decode( p_MANUALLY_CREATED_FLAG, FND_API.G_MISS_CHAR, MANUALLY_CREATED_FLAG, p_MANUALLY_CREATED_FLAG),
RETURN_BY_DATE = decode( p_RETURN_BY_DATE, FND_API.G_MISS_DATE, RETURN_BY_DATE, p_RETURN_BY_DATE),
ACTUAL_RETURN_DATE = decode( p_ACTUAL_RETURN_DATE, FND_API.G_MISS_DATE, ACTUAL_RETURN_DATE, p_ACTUAL_RETURN_DATE),
CREATION_COMPLETE_FLAG = decode( p_CREATION_COMPLETE_FLAG, FND_API.G_MISS_CHAR, CREATION_COMPLETE_FLAG, p_CREATION_COMPLETE_FLAG),
COMPLETENESS_FLAG = decode( p_COMPLETENESS_FLAG, FND_API.G_MISS_CHAR, COMPLETENESS_FLAG, p_COMPLETENESS_FLAG),
CONTEXT = decode( p_CONTEXT, FND_API.G_MISS_CHAR, CONTEXT, p_CONTEXT),
ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_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),
LAST_TXN_LINE_DETAIL_ID = decode( p_LAST_TXN_LINE_DETAIL_ID, FND_API.G_MISS_NUM, LAST_TXN_LINE_DETAIL_ID, p_LAST_TXN_LINE_DETAIL_ID),
INSTALL_LOCATION_TYPE_CODE = decode( p_INSTALL_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, INSTALL_LOCATION_TYPE_CODE, p_INSTALL_LOCATION_TYPE_CODE),
INSTALL_LOCATION_ID = decode( p_INSTALL_LOCATION_ID, FND_API.G_MISS_NUM, INSTALL_LOCATION_ID, p_INSTALL_LOCATION_ID),
INSTANCE_USAGE_CODE = decode( p_INSTANCE_USAGE_CODE, FND_API.G_MISS_CHAR, INSTANCE_USAGE_CODE, p_INSTANCE_USAGE_CODE),
last_vld_organization_id = decode( p_last_vld_organization_id, FND_API.G_MISS_NUM, last_vld_organization_id, p_last_vld_organization_id),
CONFIG_INST_HDR_ID= decode( p_CONFIG_INST_HDR_ID, FND_API.G_MISS_NUM, CONFIG_INST_HDR_ID, p_CONFIG_INST_HDR_ID),
CONFIG_INST_REV_NUM=decode( p_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, CONFIG_INST_REV_NUM, p_CONFIG_INST_REV_NUM),
CONFIG_INST_ITEM_ID=decode( p_CONFIG_INST_ITEM_ID, FND_API.G_MISS_NUM, CONFIG_INST_ITEM_ID, p_CONFIG_INST_ITEM_ID),
CONFIG_VALID_STATUS= decode( p_CONFIG_VALID_STATUS, FND_API.G_MISS_CHAR, CONFIG_VALID_STATUS, p_CONFIG_VALID_STATUS),
INSTANCE_DESCRIPTION= decode( p_INSTANCE_DESCRIPTION, FND_API.G_MISS_CHAR, INSTANCE_DESCRIPTION, p_INSTANCE_DESCRIPTION),
request_id = decode(p_request_id,fnd_api.g_miss_num,request_id,p_request_id),
program_application_id = decode(p_program_application_id,fnd_api.g_miss_num,program_application_id,p_program_application_id),
program_id = decode(p_program_id,fnd_api.g_miss_num,program_id,p_program_id),
program_update_date = decode( p_program_update_date, fnd_api.g_miss_date, program_update_date, p_program_update_date),
--start of eam integration changes--
NETWORK_ASSET_FLAG = decode( p_NETWORK_ASSET_FLAG, FND_API.G_MISS_CHAR, NETWORK_ASSET_FLAG, p_NETWORK_ASSET_FLAG),
MAINTAINABLE_FLAG = decode( p_MAINTAINABLE_FLAG, FND_API.G_MISS_CHAR, MAINTAINABLE_FLAG, p_MAINTAINABLE_FLAG),
PN_LOCATION_ID = decode( p_PN_LOCATION_ID, FND_API.G_MISS_NUM, PN_LOCATION_ID, p_PN_LOCATION_ID),
ASSET_CRITICALITY_CODE = decode( p_ASSET_CRITICALITY_CODE, FND_API.G_MISS_CHAR, ASSET_CRITICALITY_CODE, p_ASSET_CRITICALITY_CODE),
CATEGORY_ID = decode( p_CATEGORY_ID, FND_API.G_MISS_NUM, CATEGORY_ID, p_CATEGORY_ID),
EQUIPMENT_GEN_OBJECT_ID = decode( p_EQUIPMENT_GEN_OBJECT_ID, FND_API.G_MISS_NUM, EQUIPMENT_GEN_OBJECT_ID, p_EQUIPMENT_GEN_OBJECT_ID),
INSTANTIATION_FLAG = decode( p_INSTANTIATION_FLAG, FND_API.G_MISS_CHAR, INSTANTIATION_FLAG, p_INSTANTIATION_FLAG),
LINEAR_LOCATION_ID = decode( p_LINEAR_LOCATION_ID, FND_API.G_MISS_NUM, LINEAR_LOCATION_ID, p_LINEAR_LOCATION_ID),
OPERATIONAL_LOG_FLAG = decode( p_OPERATIONAL_LOG_FLAG, FND_API.G_MISS_CHAR, OPERATIONAL_LOG_FLAG, p_OPERATIONAL_LOG_FLAG),
CHECKIN_STATUS = decode( p_CHECKIN_STATUS, FND_API.G_MISS_NUM, CHECKIN_STATUS, p_CHECKIN_STATUS),
SUPPLIER_WARRANTY_EXP_DATE = decode( p_SUPPLIER_WARRANTY_EXP_DATE, FND_API.G_MISS_DATE, SUPPLIER_WARRANTY_EXP_DATE, p_SUPPLIER_WARRANTY_EXP_DATE),
ATTRIBUTE16 = decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, ATTRIBUTE16, p_ATTRIBUTE16),
ATTRIBUTE17 = decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, ATTRIBUTE17, p_ATTRIBUTE17),
ATTRIBUTE18 = decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, ATTRIBUTE18, p_ATTRIBUTE18),
ATTRIBUTE19 = decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, ATTRIBUTE19, p_ATTRIBUTE19),
ATTRIBUTE20 = decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, ATTRIBUTE20, p_ATTRIBUTE20),
ATTRIBUTE21 = decode( p_ATTRIBUTE21, FND_API.G_MISS_CHAR, ATTRIBUTE21, p_ATTRIBUTE21),
ATTRIBUTE22 = decode( p_ATTRIBUTE22, FND_API.G_MISS_CHAR, ATTRIBUTE22, p_ATTRIBUTE22),
ATTRIBUTE23 = decode( p_ATTRIBUTE23, FND_API.G_MISS_CHAR, ATTRIBUTE23, p_ATTRIBUTE23),
ATTRIBUTE24 = decode( p_ATTRIBUTE24, FND_API.G_MISS_CHAR, ATTRIBUTE24, p_ATTRIBUTE24),
ATTRIBUTE25 = decode( p_ATTRIBUTE25, FND_API.G_MISS_CHAR, ATTRIBUTE25, p_ATTRIBUTE25),
ATTRIBUTE26 = decode( p_ATTRIBUTE26, FND_API.G_MISS_CHAR, ATTRIBUTE26, p_ATTRIBUTE26),
ATTRIBUTE27 = decode( p_ATTRIBUTE27, FND_API.G_MISS_CHAR, ATTRIBUTE27, p_ATTRIBUTE27),
ATTRIBUTE28 = decode( p_ATTRIBUTE28, FND_API.G_MISS_CHAR, ATTRIBUTE28, p_ATTRIBUTE28),
ATTRIBUTE29 = decode( p_ATTRIBUTE29, FND_API.G_MISS_CHAR, ATTRIBUTE29, p_ATTRIBUTE29),
ATTRIBUTE30 = decode( p_ATTRIBUTE30, FND_API.G_MISS_CHAR, ATTRIBUTE30, p_ATTRIBUTE30),
--end of eam integration changes--
-- Addition of columns for FA Integration
PURCHASE_UNIT_PRICE = decode( p_PURCHASE_UNIT_PRICE, FND_API.G_MISS_NUM, PURCHASE_UNIT_PRICE, p_PURCHASE_UNIT_PRICE),
PURCHASE_CURRENCY_CODE = decode( p_PURCHASE_CURRENCY_CODE, FND_API.G_MISS_CHAR, PURCHASE_CURRENCY_CODE, p_PURCHASE_CURRENCY_CODE),
PAYABLES_UNIT_PRICE = decode( p_PAYABLES_UNIT_PRICE, FND_API.G_MISS_NUM, PAYABLES_UNIT_PRICE, p_PAYABLES_UNIT_PRICE),
PAYABLES_CURRENCY_CODE = decode( p_PAYABLES_CURRENCY_CODE, FND_API.G_MISS_CHAR, PAYABLES_CURRENCY_CODE, p_PAYABLES_CURRENCY_CODE),
SALES_UNIT_PRICE = decode( p_SALES_UNIT_PRICE, FND_API.G_MISS_NUM, SALES_UNIT_PRICE, p_SALES_UNIT_PRICE),
SALES_CURRENCY_CODE = decode( p_SALES_CURRENCY_CODE, FND_API.G_MISS_CHAR, SALES_CURRENCY_CODE, p_SALES_CURRENCY_CODE),
OPERATIONAL_STATUS_CODE = decode( p_OPERATIONAL_STATUS_CODE, FND_API.G_MISS_CHAR, OPERATIONAL_STATUS_CODE, p_OPERATIONAL_STATUS_CODE),
-- End addition of columns for FA Integration
SOURCE_CODE = decode(p_SOURCE_CODE,fnd_api.g_miss_char,SOURCE_CODE,p_SOURCE_CODE) -- Added Code for Siebel Genesis Project
where INSTANCE_ID = p_INSTANCE_ID;
END Update_Row;
PROCEDURE Delete_Row(
p_INSTANCE_ID NUMBER)
IS
BEGIN
DELETE FROM CSI_ITEM_INSTANCES
WHERE INSTANCE_ID = p_INSTANCE_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_LAST_TXN_LINE_DETAIL_ID NUMBER,
p_INSTALL_LOCATION_TYPE_CODE VARCHAR2,
p_INSTALL_LOCATION_ID NUMBER,
p_INSTANCE_USAGE_CODE VARCHAR2,
p_CONFIG_INST_HDR_ID NUMBER,
p_CONFIG_INST_REV_NUM NUMBER,
p_CONFIG_INST_ITEM_ID NUMBER,
p_CONFIG_VALID_STATUS VARCHAR2,
p_INSTANCE_DESCRIPTION VARCHAR2,
--start of eam integration changes--
p_NETWORK_ASSET_FLAG VARCHAR2,
p_MAINTAINABLE_FLAG VARCHAR2,
p_PN_LOCATION_ID NUMBER,
p_ASSET_CRITICALITY_CODE VARCHAR2,
p_CATEGORY_ID NUMBER,
p_EQUIPMENT_GEN_OBJECT_ID NUMBER,
p_INSTANTIATION_FLAG VARCHAR2,
p_LINEAR_LOCATION_ID NUMBER,
p_OPERATIONAL_LOG_FLAG VARCHAR2,
p_CHECKIN_STATUS NUMBER,
p_SUPPLIER_WARRANTY_EXP_DATE DATE,
p_ATTRIBUTE16 VARCHAR2,
p_ATTRIBUTE17 VARCHAR2,
p_ATTRIBUTE18 VARCHAR2,
p_ATTRIBUTE19 VARCHAR2,
p_ATTRIBUTE20 VARCHAR2,
p_ATTRIBUTE21 VARCHAR2,
p_ATTRIBUTE22 VARCHAR2,
p_ATTRIBUTE23 VARCHAR2,
p_ATTRIBUTE24 VARCHAR2,
p_ATTRIBUTE25 VARCHAR2,
p_ATTRIBUTE26 VARCHAR2,
p_ATTRIBUTE27 VARCHAR2,
p_ATTRIBUTE28 VARCHAR2,
p_ATTRIBUTE29 VARCHAR2,
p_ATTRIBUTE30 VARCHAR2,
--end of eam integration changes--
-- Addition of columns for FA Integration
p_PURCHASE_UNIT_PRICE NUMBER,
p_PURCHASE_CURRENCY_CODE VARCHAR2,
p_PAYABLES_UNIT_PRICE NUMBER,
p_PAYABLES_CURRENCY_CODE VARCHAR2,
p_SALES_UNIT_PRICE NUMBER,
p_SALES_CURRENCY_CODE VARCHAR2,
p_OPERATIONAL_STATUS_CODE VARCHAR2,
-- End addition of columns for FA Integration
p_SOURCE_CODE VARCHAR2 -- Added Code for Siebel Genesis Project
)
IS
CURSOR C IS
SELECT *
FROM CSI_ITEM_INSTANCES
WHERE INSTANCE_ID = p_INSTANCE_ID
FOR UPDATE of INSTANCE_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.LAST_TXN_LINE_DETAIL_ID = p_LAST_TXN_LINE_DETAIL_ID)
OR ( ( Recinfo.LAST_TXN_LINE_DETAIL_ID IS NULL )
AND ( p_LAST_TXN_LINE_DETAIL_ID IS NULL )))
AND ( ( Recinfo.INSTALL_LOCATION_TYPE_CODE = p_INSTALL_LOCATION_TYPE_CODE)
OR ( ( Recinfo.INSTALL_LOCATION_TYPE_CODE IS NULL )
AND ( p_INSTALL_LOCATION_TYPE_CODE IS NULL )))
AND ( ( Recinfo.INSTALL_LOCATION_ID = p_INSTALL_LOCATION_ID)
OR ( ( Recinfo.INSTALL_LOCATION_ID IS NULL )
AND ( p_INSTALL_LOCATION_ID IS NULL )))
AND ( ( Recinfo.INSTANCE_USAGE_CODE = p_INSTANCE_USAGE_CODE)
OR ( ( Recinfo.INSTANCE_USAGE_CODE IS NULL )
AND ( p_INSTANCE_USAGE_CODE IS NULL )))
AND ( ( Recinfo.CONFIG_INST_HDR_ID = p_CONFIG_INST_HDR_ID)
OR ( ( Recinfo.CONFIG_INST_HDR_ID IS NULL )
AND ( p_CONFIG_INST_HDR_ID IS NULL )))
AND ( ( Recinfo.CONFIG_INST_REV_NUM = p_CONFIG_INST_REV_NUM)
OR ( ( Recinfo.CONFIG_INST_REV_NUM IS NULL )
AND ( p_CONFIG_INST_REV_NUM IS NULL )))
AND ( ( Recinfo.CONFIG_INST_ITEM_ID = p_CONFIG_INST_ITEM_ID)
OR ( ( Recinfo.CONFIG_INST_ITEM_ID IS NULL )
AND ( p_CONFIG_INST_ITEM_ID IS NULL )))
AND ( ( Recinfo.CONFIG_VALID_STATUS = p_CONFIG_VALID_STATUS)
OR ( ( Recinfo.CONFIG_VALID_STATUS IS NULL )
AND ( p_CONFIG_VALID_STATUS IS NULL )))
AND ( ( Recinfo.INSTANCE_DESCRIPTION = p_INSTANCE_DESCRIPTION)
OR ( ( Recinfo.INSTANCE_DESCRIPTION IS NULL )
AND ( p_INSTANCE_DESCRIPTION IS NULL )))
--start of eam integration changes--
AND ( ( Recinfo.NETWORK_ASSET_FLAG = p_NETWORK_ASSET_FLAG)
OR ( ( Recinfo.NETWORK_ASSET_FLAG IS NULL )
AND ( p_NETWORK_ASSET_FLAG IS NULL )))
AND ( ( Recinfo.MAINTAINABLE_FLAG = p_MAINTAINABLE_FLAG)
OR ( ( Recinfo.MAINTAINABLE_FLAG IS NULL )
AND ( p_MAINTAINABLE_FLAG IS NULL )))
AND ( ( Recinfo.PN_LOCATION_ID = p_PN_LOCATION_ID)
OR ( ( Recinfo.PN_LOCATION_ID IS NULL )
AND ( p_PN_LOCATION_ID IS NULL )))
AND ( ( Recinfo.ASSET_CRITICALITY_CODE = p_ASSET_CRITICALITY_CODE)
OR ( ( Recinfo.ASSET_CRITICALITY_CODE IS NULL )
AND ( p_ASSET_CRITICALITY_CODE IS NULL )))
AND ( ( Recinfo.CATEGORY_ID = p_CATEGORY_ID)
OR ( ( Recinfo.CATEGORY_ID IS NULL )
AND ( p_CATEGORY_ID IS NULL )))
AND ( ( Recinfo.EQUIPMENT_GEN_OBJECT_ID = p_EQUIPMENT_GEN_OBJECT_ID)
OR ( ( Recinfo.EQUIPMENT_GEN_OBJECT_ID IS NULL )
AND ( p_EQUIPMENT_GEN_OBJECT_ID IS NULL )))
AND ( ( Recinfo.INSTANTIATION_FLAG = p_INSTANTIATION_FLAG)
OR ( ( Recinfo.INSTANTIATION_FLAG IS NULL )
AND ( p_INSTANTIATION_FLAG IS NULL )))
AND ( ( Recinfo.LINEAR_LOCATION_ID = p_LINEAR_LOCATION_ID)
OR ( ( Recinfo.LINEAR_LOCATION_ID IS NULL )
AND ( p_LINEAR_LOCATION_ID IS NULL )))
AND ( ( Recinfo.OPERATIONAL_LOG_FLAG = p_OPERATIONAL_LOG_FLAG)
OR ( ( Recinfo.OPERATIONAL_LOG_FLAG IS NULL )
AND ( p_OPERATIONAL_LOG_FLAG IS NULL )))
AND ( ( Recinfo.CHECKIN_STATUS = p_CHECKIN_STATUS)
OR ( ( Recinfo.CHECKIN_STATUS IS NULL )
AND ( p_CHECKIN_STATUS IS NULL )))
AND ( ( Recinfo.SUPPLIER_WARRANTY_EXP_DATE = p_SUPPLIER_WARRANTY_EXP_DATE)
OR ( ( Recinfo.SUPPLIER_WARRANTY_EXP_DATE IS NULL )
AND ( p_SUPPLIER_WARRANTY_EXP_DATE IS NULL )))
AND ( ( Recinfo.ATTRIBUTE16 = p_ATTRIBUTE16)
OR ( ( Recinfo.ATTRIBUTE16 IS NULL )
AND ( p_ATTRIBUTE16 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE17 = p_ATTRIBUTE17)
OR ( ( Recinfo.ATTRIBUTE17 IS NULL )
AND ( p_ATTRIBUTE17 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE18 = p_ATTRIBUTE18)
OR ( ( Recinfo.ATTRIBUTE18 IS NULL )
AND ( p_ATTRIBUTE18 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE19 = p_ATTRIBUTE19)
OR ( ( Recinfo.ATTRIBUTE19 IS NULL )
AND ( p_ATTRIBUTE19 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE20 = p_ATTRIBUTE20)
OR ( ( Recinfo.ATTRIBUTE20 IS NULL )
AND ( p_ATTRIBUTE20 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE21 = p_ATTRIBUTE21)
OR ( ( Recinfo.ATTRIBUTE21 IS NULL )
AND ( p_ATTRIBUTE21 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE22 = p_ATTRIBUTE22)
OR ( ( Recinfo.ATTRIBUTE22 IS NULL )
AND ( p_ATTRIBUTE22 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE23 = p_ATTRIBUTE23)
OR ( ( Recinfo.ATTRIBUTE23 IS NULL )
AND ( p_ATTRIBUTE23 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE24 = p_ATTRIBUTE24)
OR ( ( Recinfo.ATTRIBUTE24 IS NULL )
AND ( p_ATTRIBUTE24 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE25 = p_ATTRIBUTE25)
OR ( ( Recinfo.ATTRIBUTE25 IS NULL )
AND ( p_ATTRIBUTE25 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE26 = p_ATTRIBUTE26)
OR ( ( Recinfo.ATTRIBUTE26 IS NULL )
AND ( p_ATTRIBUTE26 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE27 = p_ATTRIBUTE27)
OR ( ( Recinfo.ATTRIBUTE27 IS NULL )
AND ( p_ATTRIBUTE27 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE28 = p_ATTRIBUTE28)
OR ( ( Recinfo.ATTRIBUTE28 IS NULL )
AND ( p_ATTRIBUTE28 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE29 = p_ATTRIBUTE29)
OR ( ( Recinfo.ATTRIBUTE29 IS NULL )
AND ( p_ATTRIBUTE29 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE30 = p_ATTRIBUTE30)
OR ( ( Recinfo.ATTRIBUTE30 IS NULL )
AND ( p_ATTRIBUTE30 IS NULL )))
--end of eam integration changes--
-- Addition of columns for FA Integration
AND ( ( Recinfo.PURCHASE_UNIT_PRICE = p_PURCHASE_UNIT_PRICE)
OR ( ( Recinfo.PURCHASE_UNIT_PRICE IS NULL )
AND ( p_PURCHASE_UNIT_PRICE IS NULL )))
AND ( ( Recinfo.PURCHASE_CURRENCY_CODE = p_PURCHASE_CURRENCY_CODE)
OR ( ( Recinfo.PURCHASE_CURRENCY_CODE IS NULL )
AND ( p_PURCHASE_CURRENCY_CODE IS NULL )))
AND ( ( Recinfo.PAYABLES_UNIT_PRICE = p_PAYABLES_UNIT_PRICE)
OR ( ( Recinfo.PAYABLES_UNIT_PRICE IS NULL )
AND ( p_PAYABLES_UNIT_PRICE IS NULL )))
AND ( ( Recinfo.PAYABLES_CURRENCY_CODE = p_PAYABLES_CURRENCY_CODE)
OR ( ( Recinfo.PAYABLES_CURRENCY_CODE IS NULL )
AND ( p_PAYABLES_CURRENCY_CODE IS NULL )))
AND ( ( Recinfo.SALES_UNIT_PRICE = p_SALES_UNIT_PRICE)
OR ( ( Recinfo.SALES_UNIT_PRICE IS NULL )
AND ( p_SALES_UNIT_PRICE IS NULL )))
AND ( ( Recinfo.SALES_CURRENCY_CODE = p_SALES_CURRENCY_CODE)
OR ( ( Recinfo.SALES_CURRENCY_CODE IS NULL )
AND ( p_SALES_CURRENCY_CODE IS NULL )))
AND ( ( Recinfo.OPERATIONAL_STATUS_CODE = p_OPERATIONAL_STATUS_CODE)
OR ( ( Recinfo.OPERATIONAL_STATUS_CODE IS NULL )
AND ( p_OPERATIONAL_STATUS_CODE IS NULL )))
-- End addition of columns for FA Integration
-- Begin Add Code for Siebel Genesis Project
AND ( ( Recinfo.SOURCE_CODE = p_SOURCE_CODE)
OR ( ( Recinfo.SOURCE_CODE IS NULL )
AND ( p_SOURCE_CODE IS NULL )))
-- End Add Code for Siebel Genesis Project
) THEN
RETURN;