The following lines contain the word 'select', 'insert', 'update' or 'delete':
X_PROGRAM_UPDATE_DATE DATE,
X_PROJECT_ID NUMBER,
X_TASK_ID NUMBER,
X_PROJECT_PLANNING_GROUP NUMBER,
X_ATTRIBUTE_CATEGORY VARCHAR2,
X_ATTRIBUTE1 VARCHAR2,
X_ATTRIBUTE2 VARCHAR2,
X_ATTRIBUTE3 VARCHAR2,
X_ATTRIBUTE4 VARCHAR2,
X_ATTRIBUTE5 VARCHAR2,
X_ATTRIBUTE6 VARCHAR2,
X_ATTRIBUTE7 VARCHAR2,
X_ATTRIBUTE8 VARCHAR2,
X_ATTRIBUTE9 VARCHAR2,
X_ATTRIBUTE10 VARCHAR2,
X_ATTRIBUTE11 VARCHAR2,
X_ATTRIBUTE12 VARCHAR2,
X_ATTRIBUTE13 VARCHAR2,
X_ATTRIBUTE14 VARCHAR2,
X_ATTRIBUTE15 VARCHAR2
) IS
CURSOR C IS
SELECT *
FROM mtl_reservations_interface
WHERE rowid = X_Rowid
FOR UPDATE NOWAIT;
FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
AND ( (Recinfo.program_update_date = X_program_update_date)
OR ( (Recinfo.program_update_date IS NULL)
AND (X_program_update_date IS NULL)))
AND ( (Recinfo.project_id = X_project_id)
OR ( (Recinfo.project_id IS NULL)
AND (X_project_id IS NULL)))
AND ( (Recinfo.task_id = X_task_id)
OR ( (Recinfo.task_id IS NULL)
AND (X_task_id IS NULL)))
AND ( (Recinfo.project_planning_group = X_project_planning_group)
OR ( (Recinfo.project_planning_group IS NULL)
AND (X_project_planning_group IS NULL)))
AND ( (Recinfo.attribute_category = X_attribute_category)
OR ( (Recinfo.attribute_category IS NULL)
AND (X_attribute_category IS NULL)))
AND ( (Recinfo.attribute1 = X_attribute1)
OR ( (Recinfo.attribute1 IS NULL)
AND (X_attribute1 IS NULL)))
AND ( (Recinfo.attribute2 = X_attribute2)
OR ( (Recinfo.attribute2 IS NULL)
AND (X_attribute2 IS NULL)))
AND ( (Recinfo.attribute3 = X_attribute3)
OR ( (Recinfo.attribute3 IS NULL)
AND (X_attribute3 IS NULL)))
AND ( (Recinfo.attribute4 = X_attribute4)
OR ( (Recinfo.attribute4 IS NULL)
AND (X_attribute4 IS NULL)))
AND ( (Recinfo.attribute5 = X_attribute5)
OR ( (Recinfo.attribute5 IS NULL)
AND (X_attribute5 IS NULL)))
AND ( (Recinfo.attribute6 = X_attribute6)
OR ( (Recinfo.attribute6 IS NULL)
AND (X_attribute6 IS NULL)))
AND ( (Recinfo.attribute7 = X_attribute7)
OR ( (Recinfo.attribute7 IS NULL)
AND (X_attribute7 IS NULL)))
AND ( (Recinfo.attribute8 = X_attribute8)
OR ( (Recinfo.attribute8 IS NULL)
AND (X_attribute8 IS NULL)))
AND ( (Recinfo.attribute9 = X_attribute9)
OR ( (Recinfo.attribute9 IS NULL)
AND (X_attribute9 IS NULL)))
AND ( (Recinfo.attribute10 = X_attribute10)
OR ( (Recinfo.attribute10 IS NULL)
AND (X_attribute10 IS NULL)))
AND ( (Recinfo.attribute11 = X_attribute11)
OR ( (Recinfo.attribute11 IS NULL)
AND (X_attribute11 IS NULL)))
AND ( (Recinfo.attribute12 = X_attribute12)
OR ( (Recinfo.attribute12 IS NULL)
AND (X_attribute12 IS NULL)))
AND ( (Recinfo.attribute13 = X_attribute13)
OR ( (Recinfo.attribute13 IS NULL)
AND (X_attribute13 IS NULL)))
AND ( (Recinfo.attribute14 = X_attribute14)
OR ( (Recinfo.attribute14 IS NULL)
AND (X_attribute14 IS NULL)))
AND ( (Recinfo.attribute15 = X_attribute15)
OR ( (Recinfo.attribute15 IS NULL)
AND (X_attribute15 IS NULL)))
) then
RAISE RECORD_CHANGED;
PROCEDURE Update_Row( X_ROWID VARCHAR2,
X_RESERVATION_INTERFACE_ID NUMBER,
X_RESERVATION_BATCH_ID NUMBER,
X_REQUIREMENT_DATE DATE,
X_ORGANIZATION_ID NUMBER,
X_TO_ORGANIZATION_ID NUMBER,
X_INVENTORY_ITEM_ID NUMBER,
X_ITEM_SEGMENT1 VARCHAR2,
X_ITEM_SEGMENT2 VARCHAR2,
X_ITEM_SEGMENT3 VARCHAR2,
X_ITEM_SEGMENT4 VARCHAR2,
X_ITEM_SEGMENT5 VARCHAR2,
X_ITEM_SEGMENT6 VARCHAR2,
X_ITEM_SEGMENT7 VARCHAR2,
X_ITEM_SEGMENT8 VARCHAR2,
X_ITEM_SEGMENT9 VARCHAR2,
X_ITEM_SEGMENT10 VARCHAR2,
X_ITEM_SEGMENT11 VARCHAR2,
X_ITEM_SEGMENT12 VARCHAR2,
X_ITEM_SEGMENT13 VARCHAR2,
X_ITEM_SEGMENT14 VARCHAR2,
X_ITEM_SEGMENT15 VARCHAR2,
X_ITEM_SEGMENT16 VARCHAR2,
X_ITEM_SEGMENT17 VARCHAR2,
X_ITEM_SEGMENT18 VARCHAR2,
X_ITEM_SEGMENT19 VARCHAR2,
X_ITEM_SEGMENT20 VARCHAR2,
X_DEMAND_SOURCE_TYPE_ID NUMBER,
X_DEMAND_SOURCE_NAME VARCHAR2,
X_DEMAND_SOURCE_HEADER_ID NUMBER,
X_DEMAND_SOURCE_LINE_ID NUMBER,
X_TO_DEMAND_SOURCE_TYPE_ID NUMBER,
X_TO_DEMAND_SOURCE_NAME VARCHAR2,
X_TO_DEMAND_SOURCE_HEADER_ID NUMBER,
X_TO_DEMAND_SOURCE_LINE_ID NUMBER,
X_PRIMARY_UOM_CODE VARCHAR2,
X_PRIMARY_UOM_ID NUMBER,
X_SECONDARY_UOM_CODE VARCHAR2, --InvConv change
X_SECONDARY_UOM_ID NUMBER, --InvConv change
X_RESERVATION_UOM_CODE VARCHAR2,
X_RESERVATION_UOM_ID NUMBER,
X_RESERVATION_QUANTITY NUMBER,
X_PRIMARY_RESERVATION_QUANTITY NUMBER,
X_SECONDARY_RSV_QUANTITY NUMBER, --InvConv change
X_EXTERNAL_SOURCE_CODE VARCHAR2,
X_EXTERNAL_SOURCE_LINE_ID NUMBER,
X_SUPPLY_SOURCE_TYPE_ID NUMBER,
X_SUPPLY_SOURCE_NAME VARCHAR2,
X_SUPPLY_SOURCE_HEADER_ID NUMBER,
X_SUPPLY_SOURCE_LINE_ID NUMBER,
X_SUPPLY_SOURCE_LINE_DETAIL NUMBER,
X_TO_SUPPLY_SOURCE_TYPE_ID NUMBER,
X_TO_SUPPLY_SOURCE_NAME VARCHAR2,
X_TO_SUPPLY_SOURCE_HEADER_ID NUMBER,
X_TO_SUPPLY_SOURCE_LINE_ID NUMBER,
X_TO_SUPPLY_SOURCE_LINE_DETAIL NUMBER,
X_ERROR_CODE NUMBER,
X_ERROR_EXPLANATION VARCHAR2,
X_REVISION VARCHAR2,
X_SUBINVENTORY_CODE VARCHAR2,
X_SUBINVENTORY_ID NUMBER,
X_LOCATOR_ID NUMBER,
X_LOC_SEGMENT1 VARCHAR2,
X_LOC_SEGMENT2 VARCHAR2,
X_LOC_SEGMENT3 VARCHAR2,
X_LOC_SEGMENT4 VARCHAR2,
X_LOC_SEGMENT5 VARCHAR2,
X_LOC_SEGMENT6 VARCHAR2,
X_LOC_SEGMENT7 VARCHAR2,
X_LOC_SEGMENT8 VARCHAR2,
X_LOC_SEGMENT9 VARCHAR2,
X_LOC_SEGMENT10 VARCHAR2,
X_LOC_SEGMENT11 VARCHAR2,
X_LOC_SEGMENT12 VARCHAR2,
X_LOC_SEGMENT13 VARCHAR2,
X_LOC_SEGMENT14 VARCHAR2,
X_LOC_SEGMENT15 VARCHAR2,
X_LOC_SEGMENT16 VARCHAR2,
X_LOC_SEGMENT17 VARCHAR2,
X_LOC_SEGMENT18 VARCHAR2,
X_LOC_SEGMENT19 VARCHAR2,
X_LOC_SEGMENT20 VARCHAR2,
X_LOT_NUMBER VARCHAR2,
X_LOT_NUMBER_ID NUMBER,
X_SERIAL_NUMBER VARCHAR2,
X_SERIAL_NUMBER_ID NUMBER,
X_TO_REVISION VARCHAR2,
X_TO_SUBINVENTORY_CODE VARCHAR2,
X_TO_SUBINVENTORY_ID NUMBER,
X_TO_LOCATOR_ID NUMBER,
X_TO_LOC_SEGMENT1 VARCHAR2,
X_TO_LOC_SEGMENT2 VARCHAR2,
X_TO_LOC_SEGMENT3 VARCHAR2,
X_TO_LOC_SEGMENT4 VARCHAR2,
X_TO_LOC_SEGMENT5 VARCHAR2,
X_TO_LOC_SEGMENT6 VARCHAR2,
X_TO_LOC_SEGMENT7 VARCHAR2,
X_TO_LOC_SEGMENT8 VARCHAR2,
X_TO_LOC_SEGMENT9 VARCHAR2,
X_TO_LOC_SEGMENT10 VARCHAR2,
X_TO_LOC_SEGMENT11 VARCHAR2,
X_TO_LOC_SEGMENT12 VARCHAR2,
X_TO_LOC_SEGMENT13 VARCHAR2,
X_TO_LOC_SEGMENT14 VARCHAR2,
X_TO_LOC_SEGMENT15 VARCHAR2,
X_TO_LOC_SEGMENT16 VARCHAR2,
X_TO_LOC_SEGMENT17 VARCHAR2,
X_TO_LOC_SEGMENT18 VARCHAR2,
X_TO_LOC_SEGMENT19 VARCHAR2,
X_TO_LOC_SEGMENT20 VARCHAR2,
X_TO_LOT_NUMBER VARCHAR2,
X_TO_LOT_NUMBER_ID NUMBER,
X_TO_SERIAL_NUMBER VARCHAR2,
X_TO_SERIAL_NUMBER_ID NUMBER,
X_ROW_STATUS_CODE NUMBER,
X_LOCK_FLAG NUMBER,
X_RESERVATION_ACTION_CODE NUMBER,
X_TRANSACTION_MODE NUMBER,
X_VALIDATION_FLAG NUMBER,
X_PARTIAL_QUANTITIES_ALLOWED NUMBER,
X_LAST_UPDATE_DATE DATE,
X_LAST_UPDATED_BY NUMBER,
X_LAST_UPDATE_LOGIN NUMBER,
X_REQUEST_ID NUMBER,
X_PROGRAM_APPLICATION_ID NUMBER,
X_PROGRAM_ID NUMBER,
X_PROGRAM_UPDATE_DATE DATE,
X_PROJECT_ID NUMBER,
X_TASK_ID NUMBER,
X_PROJECT_PLANNING_GROUP NUMBER,
X_ATTRIBUTE_CATEGORY VARCHAR2,
X_ATTRIBUTE1 VARCHAR2,
X_ATTRIBUTE2 VARCHAR2,
X_ATTRIBUTE3 VARCHAR2,
X_ATTRIBUTE4 VARCHAR2,
X_ATTRIBUTE5 VARCHAR2,
X_ATTRIBUTE6 VARCHAR2,
X_ATTRIBUTE7 VARCHAR2,
X_ATTRIBUTE8 VARCHAR2,
X_ATTRIBUTE9 VARCHAR2,
X_ATTRIBUTE10 VARCHAR2,
X_ATTRIBUTE11 VARCHAR2,
X_ATTRIBUTE12 VARCHAR2,
X_ATTRIBUTE13 VARCHAR2,
X_ATTRIBUTE14 VARCHAR2,
X_ATTRIBUTE15 VARCHAR2
) IS
BEGIN
UPDATE mtl_reservations_interface
SET
RESERVATION_INTERFACE_ID = X_RESERVATION_INTERFACE_ID,
RESERVATION_BATCH_ID = X_RESERVATION_BATCH_ID,
REQUIREMENT_DATE = X_REQUIREMENT_DATE,
ORGANIZATION_ID = X_ORGANIZATION_ID,
TO_ORGANIZATION_ID = X_TO_ORGANIZATION_ID,
INVENTORY_ITEM_ID = X_INVENTORY_ITEM_ID,
ITEM_SEGMENT1 = X_ITEM_SEGMENT1,
ITEM_SEGMENT2 = X_ITEM_SEGMENT2,
ITEM_SEGMENT3 = X_ITEM_SEGMENT3,
ITEM_SEGMENT4 = X_ITEM_SEGMENT4,
ITEM_SEGMENT5 = X_ITEM_SEGMENT5,
ITEM_SEGMENT6 = X_ITEM_SEGMENT6,
ITEM_SEGMENT7 = X_ITEM_SEGMENT7,
ITEM_SEGMENT8 = X_ITEM_SEGMENT8,
ITEM_SEGMENT9 = X_ITEM_SEGMENT9,
ITEM_SEGMENT10 = X_ITEM_SEGMENT10,
ITEM_SEGMENT11 = X_ITEM_SEGMENT11,
ITEM_SEGMENT12 = X_ITEM_SEGMENT12,
ITEM_SEGMENT13 = X_ITEM_SEGMENT13,
ITEM_SEGMENT14 = X_ITEM_SEGMENT14,
ITEM_SEGMENT15 = X_ITEM_SEGMENT15,
ITEM_SEGMENT16 = X_ITEM_SEGMENT16,
ITEM_SEGMENT17 = X_ITEM_SEGMENT17,
ITEM_SEGMENT18 = X_ITEM_SEGMENT18,
ITEM_SEGMENT19 = X_ITEM_SEGMENT19,
ITEM_SEGMENT20 = X_ITEM_SEGMENT20,
DEMAND_SOURCE_TYPE_ID = X_DEMAND_SOURCE_TYPE_ID,
DEMAND_SOURCE_NAME = X_DEMAND_SOURCE_NAME,
DEMAND_SOURCE_HEADER_ID = X_DEMAND_SOURCE_HEADER_ID,
DEMAND_SOURCE_LINE_ID = X_DEMAND_SOURCE_LINE_ID,
TO_DEMAND_SOURCE_TYPE_ID = X_TO_DEMAND_SOURCE_TYPE_ID,
TO_DEMAND_SOURCE_NAME = X_TO_DEMAND_SOURCE_NAME,
TO_DEMAND_SOURCE_HEADER_ID = X_TO_DEMAND_SOURCE_HEADER_ID,
TO_DEMAND_SOURCE_LINE_ID = X_TO_DEMAND_SOURCE_LINE_ID,
PRIMARY_UOM_CODE = X_PRIMARY_UOM_CODE,
PRIMARY_UOM_ID = X_PRIMARY_UOM_ID,
SECONDARY_UOM_CODE = X_SECONDARY_UOM_CODE, --InvConv change
SECONDARY_UOM_ID = X_SECONDARY_UOM_ID, --InvConv change
RESERVATION_UOM_CODE = X_RESERVATION_UOM_CODE,
RESERVATION_UOM_ID = X_RESERVATION_UOM_ID,
RESERVATION_QUANTITY = X_RESERVATION_QUANTITY,
PRIMARY_RESERVATION_QUANTITY = X_PRIMARY_RESERVATION_QUANTITY,
SECONDARY_RESERVATION_QUANTITY = X_SECONDARY_RSV_QUANTITY, --InvConv change
EXTERNAL_SOURCE_CODE = X_EXTERNAL_SOURCE_CODE,
EXTERNAL_SOURCE_LINE_ID = X_EXTERNAL_SOURCE_LINE_ID,
SUPPLY_SOURCE_TYPE_ID = X_SUPPLY_SOURCE_TYPE_ID,
SUPPLY_SOURCE_NAME = X_SUPPLY_SOURCE_NAME,
SUPPLY_SOURCE_HEADER_ID = X_SUPPLY_SOURCE_HEADER_ID,
SUPPLY_SOURCE_LINE_ID = X_SUPPLY_SOURCE_LINE_ID,
SUPPLY_SOURCE_LINE_DETAIL = X_SUPPLY_SOURCE_LINE_DETAIL,
TO_SUPPLY_SOURCE_TYPE_ID = X_TO_SUPPLY_SOURCE_TYPE_ID,
TO_SUPPLY_SOURCE_NAME = X_TO_SUPPLY_SOURCE_NAME,
TO_SUPPLY_SOURCE_HEADER_ID = X_TO_SUPPLY_SOURCE_HEADER_ID,
TO_SUPPLY_SOURCE_LINE_ID = X_TO_SUPPLY_SOURCE_LINE_ID,
TO_SUPPLY_SOURCE_LINE_DETAIL = X_TO_SUPPLY_SOURCE_LINE_DETAIL,
ERROR_CODE = X_ERROR_CODE,
ERROR_EXPLANATION = X_ERROR_EXPLANATION,
REVISION = X_REVISION,
SUBINVENTORY_CODE = X_SUBINVENTORY_CODE,
SUBINVENTORY_ID = X_SUBINVENTORY_ID,
LOCATOR_ID = X_LOCATOR_ID,
LOC_SEGMENT1 = X_LOC_SEGMENT1,
LOC_SEGMENT2 = X_LOC_SEGMENT2,
LOC_SEGMENT3 = X_LOC_SEGMENT3,
LOC_SEGMENT4 = X_LOC_SEGMENT4,
LOC_SEGMENT5 = X_LOC_SEGMENT5,
LOC_SEGMENT6 = X_LOC_SEGMENT6,
LOC_SEGMENT7 = X_LOC_SEGMENT7,
LOC_SEGMENT8 = X_LOC_SEGMENT8,
LOC_SEGMENT9 = X_LOC_SEGMENT9,
LOC_SEGMENT10 = X_LOC_SEGMENT10,
LOC_SEGMENT11 = X_LOC_SEGMENT11,
LOC_SEGMENT12 = X_LOC_SEGMENT12,
LOC_SEGMENT13 = X_LOC_SEGMENT13,
LOC_SEGMENT14 = X_LOC_SEGMENT14,
LOC_SEGMENT15 = X_LOC_SEGMENT15,
LOC_SEGMENT16 = X_LOC_SEGMENT16,
LOC_SEGMENT17 = X_LOC_SEGMENT17,
LOC_SEGMENT18 = X_LOC_SEGMENT18,
LOC_SEGMENT19 = X_LOC_SEGMENT19,
LOC_SEGMENT20 = X_LOC_SEGMENT20,
LOT_NUMBER = X_LOT_NUMBER,
LOT_NUMBER_ID = X_LOT_NUMBER_ID,
SERIAL_NUMBER = X_SERIAL_NUMBER,
SERIAL_NUMBER_ID = X_SERIAL_NUMBER_ID,
TO_REVISION = X_TO_REVISION,
TO_SUBINVENTORY_CODE = X_TO_SUBINVENTORY_CODE,
TO_SUBINVENTORY_ID = X_TO_SUBINVENTORY_ID,
TO_LOCATOR_ID = X_TO_LOCATOR_ID,
TO_LOC_SEGMENT1 = X_TO_LOC_SEGMENT1,
TO_LOC_SEGMENT2 = X_TO_LOC_SEGMENT2,
TO_LOC_SEGMENT3 = X_TO_LOC_SEGMENT3,
TO_LOC_SEGMENT4 = X_TO_LOC_SEGMENT4,
TO_LOC_SEGMENT5 = X_TO_LOC_SEGMENT5,
TO_LOC_SEGMENT6 = X_TO_LOC_SEGMENT6,
TO_LOC_SEGMENT7 = X_TO_LOC_SEGMENT7,
TO_LOC_SEGMENT8 = X_TO_LOC_SEGMENT8,
TO_LOC_SEGMENT9 = X_TO_LOC_SEGMENT9,
TO_LOC_SEGMENT10 = X_TO_LOC_SEGMENT10,
TO_LOC_SEGMENT11 = X_TO_LOC_SEGMENT11,
TO_LOC_SEGMENT12 = X_TO_LOC_SEGMENT12,
TO_LOC_SEGMENT13 = X_TO_LOC_SEGMENT13,
TO_LOC_SEGMENT14 = X_TO_LOC_SEGMENT14,
TO_LOC_SEGMENT15 = X_TO_LOC_SEGMENT15,
TO_LOC_SEGMENT16 = X_TO_LOC_SEGMENT16,
TO_LOC_SEGMENT17 = X_TO_LOC_SEGMENT17,
TO_LOC_SEGMENT18 = X_TO_LOC_SEGMENT18,
TO_LOC_SEGMENT19 = X_TO_LOC_SEGMENT19,
TO_LOC_SEGMENT20 = X_TO_LOC_SEGMENT20,
TO_LOT_NUMBER = X_TO_LOT_NUMBER,
TO_LOT_NUMBER_ID = X_TO_LOT_NUMBER_ID,
TO_SERIAL_NUMBER = X_TO_SERIAL_NUMBER,
TO_SERIAL_NUMBER_ID = X_TO_SERIAL_NUMBER_ID,
ROW_STATUS_CODE = X_ROW_STATUS_CODE,
LOCK_FLAG = X_LOCK_FLAG,
RESERVATION_ACTION_CODE = X_RESERVATION_ACTION_CODE,
TRANSACTION_MODE = X_TRANSACTION_MODE,
VALIDATION_FLAG = X_VALIDATION_FLAG,
PARTIAL_QUANTITIES_ALLOWED = X_PARTIAL_QUANTITIES_ALLOWED,
LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
LAST_UPDATED_BY = X_LAST_UPDATED_BY,
LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
REQUEST_ID = X_REQUEST_ID,
PROGRAM_APPLICATION_ID = X_PROGRAM_APPLICATION_ID,
PROGRAM_ID = X_PROGRAM_ID,
PROGRAM_UPDATE_DATE = X_PROGRAM_UPDATE_DATE,
PROJECT_ID = X_PROJECT_ID,
TASK_ID = X_TASK_ID,
PROJECT_PLANNING_GROUP = X_PROJECT_PLANNING_GROUP,
ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
ATTRIBUTE1 = X_ATTRIBUTE1,
ATTRIBUTE2 = X_ATTRIBUTE2,
ATTRIBUTE3 = X_ATTRIBUTE3,
ATTRIBUTE4 = X_ATTRIBUTE4,
ATTRIBUTE5 = X_ATTRIBUTE5,
ATTRIBUTE6 = X_ATTRIBUTE6,
ATTRIBUTE7 = X_ATTRIBUTE7,
ATTRIBUTE8 = X_ATTRIBUTE8,
ATTRIBUTE9 = X_ATTRIBUTE9,
ATTRIBUTE10 = X_ATTRIBUTE10,
ATTRIBUTE11 = X_ATTRIBUTE11,
ATTRIBUTE12 = X_ATTRIBUTE12,
ATTRIBUTE13 = X_ATTRIBUTE13,
ATTRIBUTE14 = X_ATTRIBUTE14,
ATTRIBUTE15 = X_ATTRIBUTE15
WHERE rowid = X_Rowid;
END Update_Row;
PROCEDURE Delete_Row( X_ROWID VARCHAR2)
IS
BEGIN
delete from mtl_reservations_interface
where rowid = X_ROWID;
END Delete_Row;