[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
X_LAST_UPDATE_DATE DATE,
X_LAST_UPDATED_BY NUMBER,
X_CREATION_DATE DATE,
X_CREATED_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_INVENTORY_ITEM_ID NUMBER,
X_REVISION VARCHAR2,
X_ORGANIZATION_ID NUMBER,
X_SUBINVENTORY_CODE VARCHAR2,
X_LOCATOR_ID NUMBER,
X_TRANSACTION_QUANTITY NUMBER,
X_PRIMARY_QUANTITY NUMBER,
X_TRANSACTION_UOM VARCHAR2,
X_TRANSACTION_COST NUMBER,
X_COST_GROUP_ID NUMBER,
X_TRANSACTION_TYPE_ID NUMBER,
X_TRANSACTION_ACTION_ID NUMBER,
X_TRANSACTION_SOURCE_TYPE_ID NUMBER,
X_TRANSACTION_SOURCE_ID NUMBER,
X_TRANSACTION_SOURCE_NAME VARCHAR2,
X_TRANSACTION_DATE DATE,
X_ACCT_PERIOD_ID NUMBER,
X_DISTRIBUTION_ACCOUNT_ID NUMBER,
X_TRANSACTION_REFERENCE VARCHAR2,
X_REASON_ID NUMBER,
X_LOT_NUMBER VARCHAR2,
X_LOT_EXPIRATION_DATE DATE,
X_SERIAL_NUMBER VARCHAR2,
X_RECEIVING_DOCUMENT VARCHAR2,
X_RCV_TRANSACTION_ID NUMBER,
X_MOVE_TRANSACTION_ID NUMBER,
X_COMPLETION_TRANSACTION_ID NUMBER,
X_WIP_ENTITY_TYPE NUMBER,
X_SCHEDULE_ID NUMBER,
X_EMPLOYEE_CODE VARCHAR2,
X_SCHEDULE_UPDATE_CODE NUMBER,
X_SETUP_TEARDOWN_CODE NUMBER,
X_OPERATION_SEQ_NUM NUMBER,
X_PICKING_LINE_ID NUMBER,
X_TRX_SOURCE_LINE_ID NUMBER,
X_TRX_SOURCE_DELIVERY_ID NUMBER,
X_PHYSICAL_ADJUSTMENT_ID NUMBER,
X_CYCLE_COUNT_ID NUMBER,
X_RMA_LINE_ID NUMBER,
X_CUSTOMER_SHIP_ID NUMBER,
X_CURRENCY_CODE VARCHAR2,
X_CURRENCY_CONVERSION_RATE NUMBER,
X_CURRENCY_CONVERSION_TYPE VARCHAR2,
X_CURRENCY_CONVERSION_DATE DATE,
X_USSGL_TRANSACTION_CODE VARCHAR2,
X_VENDOR_LOT_NUMBER VARCHAR2,
X_ENCUMBRANCE_ACCOUNT NUMBER,
X_ENCUMBRANCE_AMOUNT NUMBER,
X_SHIPMENT_NUMBER VARCHAR2,
X_TRANSFER_COST NUMBER,
X_TRANSPORTATION_COST NUMBER,
X_TRANSPORTATION_ACCOUNT NUMBER,
X_FREIGHT_CODE VARCHAR2,
X_CONTAINERS NUMBER,
X_WAYBILL_AIRBILL VARCHAR2,
X_EXPECTED_ARRIVAL_DATE DATE,
X_TRANSFER_SUBINVENTORY VARCHAR2,
X_TRANSFER_ORGANIZATION NUMBER,
X_TRANSFER_TO_LOCATION NUMBER,
X_NEW_AVERAGE_COST NUMBER,
X_VALUE_CHANGE NUMBER,
X_PERCENTAGE_CHANGE NUMBER,
X_MATERIAL_ALLOCATION_TEMP_ID NUMBER,
X_DEMAND_SOURCE_HEADER_ID NUMBER,
X_DEMAND_SOURCE_LINE VARCHAR2,
X_DEMAND_SOURCE_DELIVERY VARCHAR2,
X_ITEM_DESCRIPTION VARCHAR2,
X_WIP_SUPPLY_TYPE NUMBER,
X_POSTING_FLAG VARCHAR2,
X_PROCESS_FLAG VARCHAR2,
X_ERROR_CODE VARCHAR2,
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,
X_PRIMARY_SWITCH NUMBER,
X_DEPARTMENT_CODE VARCHAR2,
X_ERROR_EXPLANATION VARCHAR2,
X_DEMAND_ID NUMBER,
X_REQUISITION_LINE_ID NUMBER,
X_REQUISITION_DISTRIBUTION_ID NUMBER,
X_MOVEMENT_ID NUMBER,
X_SOURCE_PROJECT_ID NUMBER,
X_SOURCE_TASK_ID NUMBER,
X_PROJECT_ID NUMBER,
X_TASK_ID NUMBER,
X_TO_PROJECT_ID NUMBER,
X_TO_TASK_ID NUMBER,
X_PA_EXPENDITURE_ORG_ID NUMBER,
X_EXPENDITURE_TYPE VARCHAR2,
X_LPN_ID NUMBER,
X_TRANSFER_LPN_ID NUMBER,
X_TRANSFER_COST_GROUP_ID NUMBER,
X_CONTENT_LPN_ID NUMBER
) IS
CURSOR C IS
SELECT *
FROM mtl_material_transactions_temp
WHERE rowid = X_Rowid
FOR UPDATE of Transaction_Header_Id NOWAIT;
FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
AND ( (Recinfo.schedule_update_code = X_Schedule_Update_Code)
OR ( (Recinfo.schedule_update_code IS NULL)
AND (X_Schedule_Update_Code IS NULL)))
AND ( (Recinfo.lpn_id = X_lpn_id)
OR ( (Recinfo.lpn_id IS NULL)
AND (X_lpn_id IS NULL)))
AND ( (Recinfo.content_lpn_id = X_content_lpn_id)
OR ( (Recinfo.content_lpn_id IS NULL)
AND (X_content_lpn_id IS NULL)))
AND ( (Recinfo.transfer_lpn_id = X_transfer_lpn_id)
OR ( (Recinfo.transfer_lpn_id IS NULL)
AND (X_transfer_lpn_id IS NULL)))
AND ( (Recinfo.transfer_cost_group_id = X_transfer_cost_group_id)
OR ( (Recinfo.transfer_cost_group_id IS NULL)
AND (X_transfer_cost_group_id IS NULL)))
) then
RAISE RECORD_CHANGED;
PROCEDURE Update_Row(
X_ROWID VARCHAR2,
X_TRANSACTION_HEADER_ID NUMBER,
X_TRANSACTION_TEMP_ID NUMBER,
X_SOURCE_CODE VARCHAR2,
X_SOURCE_LINE_ID NUMBER,
X_TRANSACTION_MODE NUMBER,
X_LOCK_FLAG VARCHAR2,
X_LAST_UPDATE_DATE DATE,
X_LAST_UPDATED_BY NUMBER,
X_CREATION_DATE DATE,
X_CREATED_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_INVENTORY_ITEM_ID NUMBER,
X_REVISION VARCHAR2,
X_ORGANIZATION_ID NUMBER,
X_SUBINVENTORY_CODE VARCHAR2,
X_LOCATOR_ID NUMBER,
X_TRANSACTION_QUANTITY NUMBER,
X_PRIMARY_QUANTITY NUMBER,
X_TRANSACTION_UOM VARCHAR2,
X_TRANSACTION_COST NUMBER,
X_COST_GROUP_ID NUMBER,
X_TRANSACTION_TYPE_ID NUMBER,
X_TRANSACTION_ACTION_ID NUMBER,
X_TRANSACTION_SOURCE_TYPE_ID NUMBER,
X_TRANSACTION_SOURCE_ID NUMBER,
X_TRANSACTION_SOURCE_NAME VARCHAR2,
X_TRANSACTION_DATE DATE,
X_ACCT_PERIOD_ID NUMBER,
X_DISTRIBUTION_ACCOUNT_ID NUMBER,
X_TRANSACTION_REFERENCE VARCHAR2,
X_REASON_ID NUMBER,
X_LOT_NUMBER VARCHAR2,
X_LOT_EXPIRATION_DATE DATE,
X_SERIAL_NUMBER VARCHAR2,
X_RECEIVING_DOCUMENT VARCHAR2,
X_RCV_TRANSACTION_ID NUMBER,
X_MOVE_TRANSACTION_ID NUMBER,
X_COMPLETION_TRANSACTION_ID NUMBER,
X_WIP_ENTITY_TYPE NUMBER,
X_SCHEDULE_ID NUMBER,
X_EMPLOYEE_CODE VARCHAR2,
X_SCHEDULE_UPDATE_CODE NUMBER,
X_SETUP_TEARDOWN_CODE NUMBER,
X_OPERATION_SEQ_NUM NUMBER,
X_PICKING_LINE_ID NUMBER,
X_TRX_SOURCE_LINE_ID NUMBER,
X_TRX_SOURCE_DELIVERY_ID NUMBER,
X_PHYSICAL_ADJUSTMENT_ID NUMBER,
X_CYCLE_COUNT_ID NUMBER,
X_RMA_LINE_ID NUMBER,
X_CUSTOMER_SHIP_ID NUMBER,
X_CURRENCY_CODE VARCHAR2,
X_CURRENCY_CONVERSION_RATE NUMBER,
X_CURRENCY_CONVERSION_TYPE VARCHAR2,
X_CURRENCY_CONVERSION_DATE DATE,
X_USSGL_TRANSACTION_CODE VARCHAR2,
X_VENDOR_LOT_NUMBER VARCHAR2,
X_ENCUMBRANCE_ACCOUNT NUMBER,
X_ENCUMBRANCE_AMOUNT NUMBER,
X_SHIPMENT_NUMBER VARCHAR2,
X_TRANSFER_COST NUMBER,
X_TRANSPORTATION_COST NUMBER,
X_TRANSPORTATION_ACCOUNT NUMBER,
X_FREIGHT_CODE VARCHAR2,
X_CONTAINERS NUMBER,
X_WAYBILL_AIRBILL VARCHAR2,
X_EXPECTED_ARRIVAL_DATE DATE,
X_TRANSFER_SUBINVENTORY VARCHAR2,
X_TRANSFER_ORGANIZATION NUMBER,
X_TRANSFER_TO_LOCATION NUMBER,
X_NEW_AVERAGE_COST NUMBER,
X_VALUE_CHANGE NUMBER,
X_PERCENTAGE_CHANGE NUMBER,
X_MATERIAL_ALLOCATION_TEMP_ID NUMBER,
X_DEMAND_SOURCE_HEADER_ID NUMBER,
X_DEMAND_SOURCE_LINE VARCHAR2,
X_DEMAND_SOURCE_DELIVERY VARCHAR2,
X_ITEM_DESCRIPTION VARCHAR2,
X_WIP_SUPPLY_TYPE NUMBER,
X_POSTING_FLAG VARCHAR2,
X_PROCESS_FLAG VARCHAR2,
X_ERROR_CODE VARCHAR2,
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,
X_PRIMARY_SWITCH NUMBER,
X_DEPARTMENT_CODE VARCHAR2,
X_ERROR_EXPLANATION VARCHAR2,
X_DEMAND_ID NUMBER,
X_REQUISITION_LINE_ID NUMBER,
X_REQUISITION_DISTRIBUTION_ID NUMBER,
X_MOVEMENT_ID NUMBER,
X_SOURCE_PROJECT_ID NUMBER,
X_SOURCE_TASK_ID NUMBER,
X_PROJECT_ID NUMBER,
X_TASK_ID NUMBER,
X_TO_PROJECT_ID NUMBER,
X_TO_TASK_ID NUMBER,
X_PA_EXPENDITURE_ORG_ID NUMBER,
X_EXPENDITURE_TYPE VARCHAR2,
X_LPN_ID NUMBER,
X_TRANSFER_LPN_ID NUMBER,
X_TRANSFER_COST_GROUP_ID NUMBER,
X_CONTENT_LPN_ID NUMBER
) IS
BEGIN
UPDATE mtl_material_transactions_temp
SET
transaction_header_id = X_Transaction_Header_Id,
transaction_temp_id = X_Transaction_Temp_Id,
source_code = X_Source_Code,
source_line_id = X_Source_Line_Id,
transaction_mode = X_Transaction_Mode,
lock_flag = X_Lock_Flag,
last_update_date = X_Last_Update_Date,
last_updated_by = X_Last_Updated_By,
last_update_login = X_Last_Update_Login,
inventory_item_id = X_Inventory_Item_Id,
revision = X_Revision,
organization_id = X_Organization_Id,
subinventory_code = X_Subinventory_Code,
locator_id = X_Locator_Id,
transaction_quantity = X_Transaction_Quantity,
primary_quantity = X_Primary_Quantity,
transaction_uom = X_Transaction_Uom,
transaction_cost = X_Transaction_Cost,
cost_group_id = X_cost_group_id,
transaction_type_id = X_Transaction_Type_Id,
transaction_action_id = X_Transaction_Action_Id,
transaction_source_type_id = X_Transaction_Source_Type_Id,
transaction_source_id = X_Transaction_Source_Id,
transaction_source_name = X_Transaction_Source_Name,
transaction_date = X_Transaction_Date,
acct_period_id = X_Acct_Period_Id,
distribution_account_id = X_Distribution_Account_Id,
transaction_reference = X_Transaction_Reference,
reason_id = X_Reason_Id,
lot_number = X_Lot_Number,
lot_expiration_date = X_Lot_Expiration_Date,
serial_number = X_Serial_Number,
receiving_document = X_Receiving_Document,
rcv_transaction_id = X_Rcv_Transaction_Id,
move_transaction_id = X_Move_Transaction_Id,
completion_transaction_id = X_Completion_Transaction_Id,
wip_entity_type = X_Wip_Entity_Type,
schedule_id = X_Schedule_Id,
employee_code = X_Employee_Code,
schedule_update_code = X_Schedule_Update_Code,
setup_teardown_code = X_Setup_Teardown_Code,
operation_seq_num = X_Operation_Seq_Num,
picking_line_id = X_Picking_Line_Id,
trx_source_line_id = X_Trx_Source_Line_Id,
trx_source_delivery_id = X_Trx_Source_Delivery_Id,
physical_adjustment_id = X_Physical_Adjustment_Id,
cycle_count_id = X_Cycle_Count_Id,
rma_line_id = X_Rma_Line_Id,
customer_ship_id = X_Customer_Ship_Id,
currency_code = X_Currency_Code,
currency_conversion_rate = X_Currency_Conversion_Rate,
currency_conversion_type = X_Currency_Conversion_Type,
currency_conversion_date = X_Currency_Conversion_Date,
ussgl_transaction_code = X_Ussgl_Transaction_Code,
vendor_lot_number = X_Vendor_Lot_Number,
encumbrance_account = X_Encumbrance_Account,
encumbrance_amount = X_Encumbrance_Amount,
shipment_number = X_Shipment_Number,
transfer_cost = X_Transfer_Cost,
transportation_cost = X_Transportation_Cost,
transportation_account = X_Transportation_Account,
freight_code = X_Freight_Code,
containers = X_Containers,
waybill_airbill = X_Waybill_Airbill,
expected_arrival_date = X_Expected_Arrival_Date,
transfer_subinventory = X_Transfer_Subinventory,
transfer_organization = X_Transfer_Organization,
transfer_to_location = X_Transfer_To_Location,
new_average_cost = X_New_Average_Cost,
value_change = X_Value_Change,
percentage_change = X_Percentage_Change,
material_allocation_temp_id = X_Material_Allocation_Temp_Id,
demand_source_header_id = X_Demand_Source_Header_Id,
demand_source_line = X_Demand_Source_Line,
demand_source_delivery = X_Demand_Source_Delivery,
item_description = X_Item_Description,
wip_supply_type = X_Wip_Supply_Type,
posting_flag = X_Posting_Flag,
process_flag = X_Process_Flag,
error_code = X_Error_Code,
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,
primary_switch = X_Primary_Switch,
department_code = X_Department_Code,
error_explanation = X_Error_Explanation,
demand_id = X_Demand_Id,
requisition_line_id = X_Requisition_Line_Id,
requisition_distribution_id = X_Requisition_Distribution_Id,
movement_id = X_Movement_Id,
source_project_id = X_Source_Project_Id,
source_task_id = X_Source_Task_Id,
project_id = X_Project_Id,
task_id = X_Task_Id,
to_project_id = X_To_Project_Id,
to_task_id = X_To_Task_Id,
pa_expenditure_org_id = X_Pa_Expenditure_Org_Id,
expenditure_type = X_Expenditure_Type,
lpn_id = X_lpn_id,
transfer_lpn_id = X_transfer_lpn_id,
transfer_cost_group_id = X_transfer_cost_group_id,
content_lpn_id = X_content_lpn_id
WHERE rowid = X_Rowid;
END Update_Row;