[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure INSERT_ROW (
X_ROWID in out nocopy ROWID ,
X_TRANSACTION_INTERFACE_ID in NUMBER,
X_PLANNING_ORGANIZATION_ID in NUMBER,
X_PLANNING_TP_TYPE in NUMBER,
X_XFR_PLANNING_ORGANIZATION_ID in NUMBER,
X_TRANSFER_PLANNING_TP_TYPE in NUMBER,
X_SECONDARY_UOM_CODE in VARCHAR2,
X_SECONDARY_TRANSACTION_QUANTI in NUMBER,
X_TRANSACTION_GROUP_ID in NUMBER,
X_TRANSACTION_GROUP_SEQ in NUMBER,
X_REPRESENTATIVE_LOT_NUMBER in VARCHAR2,
X_TRANSACTION_BATCH_ID in NUMBER,
X_TRANSACTION_BATCH_SEQ in NUMBER,
X_REBUILD_ITEM_ID in NUMBER,
X_REBUILD_SERIAL_NUMBER in VARCHAR2,
X_REBUILD_ACTIVITY_ID in NUMBER,
X_REBUILD_JOB_NAME in VARCHAR2,
X_MOVE_TRANSACTION_ID in NUMBER,
X_COMPLETION_TRANSACTION_ID in NUMBER,
X_WIP_SUPPLY_TYPE in NUMBER,
X_XFER_LOC_SEGMENT6 in VARCHAR2,
X_XFER_LOC_SEGMENT7 in VARCHAR2,
X_XFER_LOC_SEGMENT8 in VARCHAR2,
X_XFER_LOC_SEGMENT9 in VARCHAR2,
X_XFER_LOC_SEGMENT10 in VARCHAR2,
X_XFER_LOC_SEGMENT11 in VARCHAR2,
X_XFER_LOC_SEGMENT12 in VARCHAR2,
X_XFER_LOC_SEGMENT13 in VARCHAR2,
X_XFER_LOC_SEGMENT14 in VARCHAR2,
X_XFER_LOC_SEGMENT15 in VARCHAR2,
X_XFER_LOC_SEGMENT16 in VARCHAR2,
X_XFER_LOC_SEGMENT17 in VARCHAR2,
X_XFER_LOC_SEGMENT18 in VARCHAR2,
X_XFER_LOC_SEGMENT19 in VARCHAR2,
X_XFER_LOC_SEGMENT20 in VARCHAR2,
X_SHIPMENT_NUMBER in VARCHAR2,
X_TRANSPORTATION_COST in NUMBER,
X_TRANSPORTATION_ACCOUNT in NUMBER,
X_TRANSFER_COST in NUMBER,
X_FREIGHT_CODE in VARCHAR2,
X_CONTAINERS in NUMBER,
X_WAYBILL_AIRBILL in VARCHAR2,
X_EXPECTED_ARRIVAL_DATE in DATE,
X_NEW_AVERAGE_COST in NUMBER,
X_VALUE_CHANGE in NUMBER,
X_PERCENTAGE_CHANGE in NUMBER,
X_DEMAND_SOURCE_HEADER_ID in NUMBER,
X_DEMAND_SOURCE_LINE in VARCHAR2,
X_DEMAND_SOURCE_DELIVERY in VARCHAR2,
X_NEGATIVE_REQ_FLAG in NUMBER,
X_ERROR_EXPLANATION in VARCHAR2,
X_SHIPPABLE_FLAG in VARCHAR2,
X_REQUIRED_FLAG in VARCHAR2,
X_ATTRIBUTE_CATEGORY in VARCHAR2,
X_ATTRIBUTE1 in VARCHAR2,
X_ATTRIBUTE2 in VARCHAR2,
X_ATTRIBUTE3 in VARCHAR2,
X_ATTRIBUTE4 in VARCHAR2,
X_ATTRIBUTE5 in VARCHAR2,
X_ATTRIBUTE6 in VARCHAR2,
X_ATTRIBUTE7 in VARCHAR2,
X_ATTRIBUTE8 in VARCHAR2,
X_ATTRIBUTE9 in VARCHAR2,
X_ATTRIBUTE10 in VARCHAR2,
X_ATTRIBUTE11 in VARCHAR2,
X_ATTRIBUTE12 in VARCHAR2,
X_ATTRIBUTE13 in VARCHAR2,
X_ATTRIBUTE14 in VARCHAR2,
X_ATTRIBUTE15 in VARCHAR2,
X_REQUISITION_DISTRIBUTION_ID in NUMBER,
X_MOVEMENT_ID in NUMBER,
X_RESERVATION_QUANTITY in NUMBER,
X_SHIPPED_QUANTITY in NUMBER,
X_INVENTORY_ITEM in VARCHAR2,
X_LOCATOR_NAME in VARCHAR2,
X_TASK_ID in NUMBER,
X_TO_TASK_ID in NUMBER,
X_SOURCE_TASK_ID in NUMBER,
X_PROJECT_ID in NUMBER,
X_TO_PROJECT_ID in NUMBER,
X_SOURCE_PROJECT_ID in NUMBER,
X_PA_EXPENDITURE_ORG_ID in NUMBER,
X_EXPENDITURE_TYPE in VARCHAR2,
X_FINAL_COMPLETION_FLAG in VARCHAR2,
X_TRANSFER_PERCENTAGE in NUMBER,
X_TRANSACTION_SEQUENCE_ID in NUMBER,
X_MATERIAL_ACCOUNT in NUMBER,
X_MATERIAL_OVERHEAD_ACCOUNT in NUMBER,
X_RESOURCE_ACCOUNT in NUMBER,
X_OUTSIDE_PROCESSING_ACCOUNT in NUMBER,
X_OVERHEAD_ACCOUNT in NUMBER,
X_BOM_REVISION in VARCHAR2,
X_ROUTING_REVISION in VARCHAR2,
X_BOM_REVISION_DATE in DATE,
X_ROUTING_REVISION_DATE in DATE,
X_ALTERNATE_BOM_DESIGNATOR in VARCHAR2,
X_ALTERNATE_ROUTING_DESIGNATOR in VARCHAR2,
X_ACCOUNTING_CLASS in VARCHAR2,
X_DEMAND_CLASS in VARCHAR2,
X_PARENT_ID in NUMBER,
X_SUBSTITUTION_TYPE_ID in NUMBER,
X_SUBSTITUTION_ITEM_ID in NUMBER,
X_SCHEDULE_GROUP in NUMBER,
X_BUILD_SEQUENCE in NUMBER,
X_SCHEDULE_NUMBER in VARCHAR2,
X_SCHEDULED_FLAG in NUMBER,
X_FLOW_SCHEDULE in VARCHAR2,
X_COST_GROUP_ID in NUMBER,
X_KANBAN_CARD_ID in NUMBER,
X_QA_COLLECTION_ID in NUMBER,
X_OVERCOMPLETION_TRANSACTION_Q in NUMBER,
X_OVERCOMPLETION_PRIMARY_QTY in NUMBER,
X_OVERCOMPLETION_TRANSACTION_I in NUMBER,
X_END_ITEM_UNIT_NUMBER in VARCHAR2,
X_SCHEDULED_PAYBACK_DATE in DATE,
X_ORG_COST_GROUP_ID in NUMBER,
X_COST_TYPE_ID in NUMBER,
X_SOURCE_LOT_NUMBER in VARCHAR2,
X_TRANSFER_COST_GROUP_ID in NUMBER,
X_LPN_ID in NUMBER,
X_TRANSFER_LPN_ID in NUMBER,
X_CONTENT_LPN_ID in NUMBER,
X_XML_DOCUMENT_ID in VARCHAR2,
X_ORGANIZATION_TYPE in NUMBER,
X_TRANSFER_ORGANIZATION_TYPE in NUMBER,
X_OWNING_ORGANIZATION_ID in NUMBER,
X_OWNING_TP_TYPE in NUMBER,
X_XFR_OWNING_ORGANIZATION_ID in NUMBER,
X_TRANSFER_OWNING_TP_TYPE in NUMBER,
X_LOC_SEGMENT12 in VARCHAR2,
X_LOC_SEGMENT13 in VARCHAR2,
X_LOC_SEGMENT14 in VARCHAR2,
X_LOC_SEGMENT15 in VARCHAR2,
X_LOC_SEGMENT16 in VARCHAR2,
X_LOC_SEGMENT17 in VARCHAR2,
X_LOC_SEGMENT18 in VARCHAR2,
X_LOC_SEGMENT19 in VARCHAR2,
X_LOC_SEGMENT20 in VARCHAR2,
X_TRANSACTION_SOURCE_ID in NUMBER,
X_DSP_SEGMENT1 in VARCHAR2,
X_DSP_SEGMENT2 in VARCHAR2,
X_DSP_SEGMENT3 in VARCHAR2,
X_DSP_SEGMENT4 in VARCHAR2,
X_DSP_SEGMENT5 in VARCHAR2,
X_DSP_SEGMENT6 in VARCHAR2,
X_DSP_SEGMENT7 in VARCHAR2,
X_DSP_SEGMENT8 in VARCHAR2,
X_DSP_SEGMENT9 in VARCHAR2,
X_DSP_SEGMENT10 in VARCHAR2,
X_DSP_SEGMENT11 in VARCHAR2,
X_DSP_SEGMENT12 in VARCHAR2,
X_DSP_SEGMENT13 in VARCHAR2,
X_DSP_SEGMENT14 in VARCHAR2,
X_DSP_SEGMENT15 in VARCHAR2,
X_DSP_SEGMENT16 in VARCHAR2,
X_DSP_SEGMENT17 in VARCHAR2,
X_DSP_SEGMENT18 in VARCHAR2,
X_DSP_SEGMENT19 in VARCHAR2,
X_DSP_SEGMENT20 in VARCHAR2,
X_DSP_SEGMENT21 in VARCHAR2,
X_DSP_SEGMENT22 in VARCHAR2,
X_DSP_SEGMENT23 in VARCHAR2,
X_DSP_SEGMENT24 in VARCHAR2,
X_DSP_SEGMENT25 in VARCHAR2,
X_DSP_SEGMENT26 in VARCHAR2,
X_DSP_SEGMENT27 in VARCHAR2,
X_DSP_SEGMENT28 in VARCHAR2,
X_DSP_SEGMENT29 in VARCHAR2,
X_DSP_SEGMENT30 in VARCHAR2,
X_TRANSACTION_SOURCE_NAME in VARCHAR2,
X_TRANSACTION_SOURCE_TYPE_ID in NUMBER,
X_TRANSACTION_ACTION_ID in NUMBER,
X_TRANSACTION_TYPE_ID in NUMBER,
X_REASON_ID in NUMBER,
X_TRANSACTION_REFERENCE in VARCHAR2,
X_TRANSACTION_COST in NUMBER,
X_DISTRIBUTION_ACCOUNT_ID in NUMBER,
X_DST_SEGMENT1 in VARCHAR2,
X_DST_SEGMENT2 in VARCHAR2,
X_DST_SEGMENT3 in VARCHAR2,
X_DST_SEGMENT4 in VARCHAR2,
X_DST_SEGMENT5 in VARCHAR2,
X_DST_SEGMENT6 in VARCHAR2,
X_DST_SEGMENT7 in VARCHAR2,
X_DST_SEGMENT8 in VARCHAR2,
X_DST_SEGMENT9 in VARCHAR2,
X_DST_SEGMENT10 in VARCHAR2,
X_DST_SEGMENT11 in VARCHAR2,
X_DST_SEGMENT12 in VARCHAR2,
X_DST_SEGMENT13 in VARCHAR2,
X_DST_SEGMENT14 in VARCHAR2,
X_DST_SEGMENT15 in VARCHAR2,
X_DST_SEGMENT16 in VARCHAR2,
X_DST_SEGMENT17 in VARCHAR2,
X_DST_SEGMENT18 in VARCHAR2,
X_DST_SEGMENT19 in VARCHAR2,
X_DST_SEGMENT20 in VARCHAR2,
X_DST_SEGMENT21 in VARCHAR2,
X_DST_SEGMENT22 in VARCHAR2,
X_DST_SEGMENT23 in VARCHAR2,
X_DST_SEGMENT24 in VARCHAR2,
X_DST_SEGMENT25 in VARCHAR2,
X_DST_SEGMENT26 in VARCHAR2,
X_DST_SEGMENT27 in VARCHAR2,
X_DST_SEGMENT28 in VARCHAR2,
X_DST_SEGMENT29 in VARCHAR2,
X_DST_SEGMENT30 in VARCHAR2,
X_REQUISITION_LINE_ID in NUMBER,
X_CURRENCY_CODE in VARCHAR2,
X_CURRENCY_CONVERSION_DATE in DATE,
X_CURRENCY_CONVERSION_TYPE in VARCHAR2,
X_CURRENCY_CONVERSION_RATE in NUMBER,
X_USSGL_TRANSACTION_CODE in VARCHAR2,
X_WIP_ENTITY_TYPE in NUMBER,
X_SCHEDULE_ID in NUMBER,
X_EMPLOYEE_CODE in VARCHAR2,
X_DEPARTMENT_ID in NUMBER,
X_SCHEDULE_UPDATE_CODE in NUMBER,
X_SETUP_TEARDOWN_CODE in NUMBER,
X_PRIMARY_SWITCH in NUMBER,
X_MRP_CODE in NUMBER,
X_OPERATION_SEQ_NUM in NUMBER,
X_REPETITIVE_LINE_ID in NUMBER,
X_PICKING_LINE_ID in NUMBER,
X_TRX_SOURCE_LINE_ID in NUMBER,
X_TRX_SOURCE_DELIVERY_ID in NUMBER,
X_DEMAND_ID in NUMBER,
X_CUSTOMER_SHIP_ID in NUMBER,
X_LINE_ITEM_NUM in NUMBER,
X_RECEIVING_DOCUMENT in VARCHAR2,
X_RCV_TRANSACTION_ID in NUMBER,
X_SHIP_TO_LOCATION_ID in NUMBER,
X_ENCUMBRANCE_ACCOUNT in NUMBER,
X_ENCUMBRANCE_AMOUNT in NUMBER,
X_VENDOR_LOT_NUMBER in VARCHAR2,
X_TRANSFER_SUBINVENTORY in VARCHAR2,
X_TRANSFER_ORGANIZATION in NUMBER,
X_TRANSFER_LOCATOR in NUMBER,
X_XFER_LOC_SEGMENT1 in VARCHAR2,
X_XFER_LOC_SEGMENT2 in VARCHAR2,
X_XFER_LOC_SEGMENT3 in VARCHAR2,
X_XFER_LOC_SEGMENT4 in VARCHAR2,
X_XFER_LOC_SEGMENT5 in VARCHAR2,
X_TRANSACTION_HEADER_ID in NUMBER,
X_SOURCE_CODE in VARCHAR2,
X_SOURCE_LINE_ID in NUMBER,
X_SOURCE_HEADER_ID in NUMBER,
X_PROCESS_FLAG in NUMBER,
X_VALIDATION_REQUIRED in NUMBER,
X_TRANSACTION_MODE in NUMBER,
X_LOCK_FLAG in NUMBER,
X_REQUEST_ID in NUMBER,
X_INVENTORY_ITEM_ID in NUMBER,
X_ITEM_SEGMENT1 in VARCHAR2,
X_ITEM_SEGMENT2 in VARCHAR2,
X_ITEM_SEGMENT3 in VARCHAR2,
X_ITEM_SEGMENT4 in VARCHAR2,
X_ITEM_SEGMENT5 in VARCHAR2,
X_ITEM_SEGMENT6 in VARCHAR2,
X_ITEM_SEGMENT7 in VARCHAR2,
X_ITEM_SEGMENT8 in VARCHAR2,
X_ITEM_SEGMENT9 in VARCHAR2,
X_ITEM_SEGMENT10 in VARCHAR2,
X_ITEM_SEGMENT11 in VARCHAR2,
X_ITEM_SEGMENT12 in VARCHAR2,
X_ITEM_SEGMENT13 in VARCHAR2,
X_ITEM_SEGMENT14 in VARCHAR2,
X_ITEM_SEGMENT15 in VARCHAR2,
X_ITEM_SEGMENT16 in VARCHAR2,
X_ITEM_SEGMENT17 in VARCHAR2,
X_ITEM_SEGMENT18 in VARCHAR2,
X_ITEM_SEGMENT19 in VARCHAR2,
X_ITEM_SEGMENT20 in VARCHAR2,
X_REVISION in VARCHAR2,
X_ORGANIZATION_ID in NUMBER,
X_TRANSACTION_QUANTITY in NUMBER,
X_PRIMARY_QUANTITY in NUMBER,
X_TRANSACTION_UOM in VARCHAR2,
X_TRANSACTION_DATE in DATE,
X_ACCT_PERIOD_ID in NUMBER,
X_SUBINVENTORY_CODE in VARCHAR2,
X_LOCATOR_ID in NUMBER,
X_LOC_SEGMENT1 in VARCHAR2,
X_LOC_SEGMENT2 in VARCHAR2,
X_LOC_SEGMENT3 in VARCHAR2,
X_LOC_SEGMENT4 in VARCHAR2,
X_LOC_SEGMENT5 in VARCHAR2,
X_LOC_SEGMENT6 in VARCHAR2,
X_LOC_SEGMENT7 in VARCHAR2,
X_LOC_SEGMENT8 in VARCHAR2,
X_LOC_SEGMENT9 in VARCHAR2,
X_LOC_SEGMENT10 in VARCHAR2,
X_LOC_SEGMENT11 in VARCHAR2,
X_ERROR_CODE in VARCHAR2,
X_CREATION_DATE in DATE,
X_CREATED_BY in NUMBER,
X_LAST_UPDATE_DATE in DATE,
X_LAST_UPDATED_BY in NUMBER,
X_LAST_UPDATE_LOGIN in NUMBER
) is
cursor C is select ROWID from MTL_TRANSACTIONS_INTERFACE
where TRANSACTION_INTERFACE_ID = X_TRANSACTION_INTERFACE_ID
;
insert into MTL_TRANSACTIONS_INTERFACE (
PLANNING_ORGANIZATION_ID,
PLANNING_TP_TYPE,
XFR_PLANNING_ORGANIZATION_ID,
TRANSFER_PLANNING_TP_TYPE,
SECONDARY_UOM_CODE,
SECONDARY_TRANSACTION_QUANTITY,
--TRANSACTION_GROUP_ID,
--TRANSACTION_GROUP_SEQ,
REPRESENTATIVE_LOT_NUMBER,
TRANSACTION_BATCH_ID,
TRANSACTION_BATCH_SEQ,
REBUILD_ITEM_ID,
REBUILD_SERIAL_NUMBER,
REBUILD_ACTIVITY_ID,
REBUILD_JOB_NAME,
MOVE_TRANSACTION_ID,
COMPLETION_TRANSACTION_ID,
WIP_SUPPLY_TYPE,
XFER_LOC_SEGMENT6,
XFER_LOC_SEGMENT7,
XFER_LOC_SEGMENT8,
XFER_LOC_SEGMENT9,
XFER_LOC_SEGMENT10,
XFER_LOC_SEGMENT11,
XFER_LOC_SEGMENT12,
XFER_LOC_SEGMENT13,
XFER_LOC_SEGMENT14,
XFER_LOC_SEGMENT15,
XFER_LOC_SEGMENT16,
XFER_LOC_SEGMENT17,
XFER_LOC_SEGMENT18,
XFER_LOC_SEGMENT19,
XFER_LOC_SEGMENT20,
SHIPMENT_NUMBER,
TRANSPORTATION_COST,
TRANSPORTATION_ACCOUNT,
TRANSFER_COST,
FREIGHT_CODE,
CONTAINERS,
WAYBILL_AIRBILL,
EXPECTED_ARRIVAL_DATE,
NEW_AVERAGE_COST,
VALUE_CHANGE,
PERCENTAGE_CHANGE,
DEMAND_SOURCE_HEADER_ID,
DEMAND_SOURCE_LINE,
DEMAND_SOURCE_DELIVERY,
NEGATIVE_REQ_FLAG,
ERROR_EXPLANATION,
SHIPPABLE_FLAG,
REQUIRED_FLAG,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
REQUISITION_DISTRIBUTION_ID,
MOVEMENT_ID,
RESERVATION_QUANTITY,
SHIPPED_QUANTITY,
INVENTORY_ITEM,
LOCATOR_NAME,
TASK_ID,
TO_TASK_ID,
SOURCE_TASK_ID,
PROJECT_ID,
TO_PROJECT_ID,
SOURCE_PROJECT_ID,
PA_EXPENDITURE_ORG_ID,
EXPENDITURE_TYPE,
FINAL_COMPLETION_FLAG,
TRANSFER_PERCENTAGE,
TRANSACTION_SEQUENCE_ID,
MATERIAL_ACCOUNT,
MATERIAL_OVERHEAD_ACCOUNT,
RESOURCE_ACCOUNT,
OUTSIDE_PROCESSING_ACCOUNT,
OVERHEAD_ACCOUNT,
BOM_REVISION,
ROUTING_REVISION,
BOM_REVISION_DATE,
ROUTING_REVISION_DATE,
ALTERNATE_BOM_DESIGNATOR,
ALTERNATE_ROUTING_DESIGNATOR,
ACCOUNTING_CLASS,
DEMAND_CLASS,
PARENT_ID,
SUBSTITUTION_TYPE_ID,
SUBSTITUTION_ITEM_ID,
SCHEDULE_GROUP,
BUILD_SEQUENCE,
SCHEDULE_NUMBER,
SCHEDULED_FLAG,
FLOW_SCHEDULE,
COST_GROUP_ID,
KANBAN_CARD_ID,
QA_COLLECTION_ID,
OVERCOMPLETION_TRANSACTION_QTY,
OVERCOMPLETION_PRIMARY_QTY,
OVERCOMPLETION_TRANSACTION_ID,
END_ITEM_UNIT_NUMBER,
SCHEDULED_PAYBACK_DATE,
ORG_COST_GROUP_ID,
COST_TYPE_ID,
SOURCE_LOT_NUMBER,
TRANSFER_COST_GROUP_ID,
LPN_ID,
TRANSFER_LPN_ID,
CONTENT_LPN_ID,
XML_DOCUMENT_ID,
ORGANIZATION_TYPE,
TRANSFER_ORGANIZATION_TYPE,
OWNING_ORGANIZATION_ID,
OWNING_TP_TYPE,
XFR_OWNING_ORGANIZATION_ID,
TRANSFER_OWNING_TP_TYPE,
LOC_SEGMENT12,
LOC_SEGMENT13,
LOC_SEGMENT14,
LOC_SEGMENT15,
LOC_SEGMENT16,
LOC_SEGMENT17,
LOC_SEGMENT18,
LOC_SEGMENT19,
LOC_SEGMENT20,
TRANSACTION_SOURCE_ID,
DSP_SEGMENT1,
DSP_SEGMENT2,
DSP_SEGMENT3,
DSP_SEGMENT4,
DSP_SEGMENT5,
DSP_SEGMENT6,
DSP_SEGMENT7,
DSP_SEGMENT8,
DSP_SEGMENT9,
DSP_SEGMENT10,
DSP_SEGMENT11,
DSP_SEGMENT12,
DSP_SEGMENT13,
DSP_SEGMENT14,
DSP_SEGMENT15,
DSP_SEGMENT16,
DSP_SEGMENT17,
DSP_SEGMENT18,
DSP_SEGMENT19,
DSP_SEGMENT20,
DSP_SEGMENT21,
DSP_SEGMENT22,
DSP_SEGMENT23,
DSP_SEGMENT24,
DSP_SEGMENT25,
DSP_SEGMENT26,
DSP_SEGMENT27,
DSP_SEGMENT28,
DSP_SEGMENT29,
DSP_SEGMENT30,
TRANSACTION_SOURCE_NAME,
TRANSACTION_SOURCE_TYPE_ID,
TRANSACTION_ACTION_ID,
TRANSACTION_TYPE_ID,
REASON_ID,
TRANSACTION_REFERENCE,
TRANSACTION_COST,
DISTRIBUTION_ACCOUNT_ID,
DST_SEGMENT1,
DST_SEGMENT2,
DST_SEGMENT3,
DST_SEGMENT4,
DST_SEGMENT5,
DST_SEGMENT6,
DST_SEGMENT7,
DST_SEGMENT8,
DST_SEGMENT9,
DST_SEGMENT10,
DST_SEGMENT11,
DST_SEGMENT12,
DST_SEGMENT13,
DST_SEGMENT14,
DST_SEGMENT15,
DST_SEGMENT16,
DST_SEGMENT17,
DST_SEGMENT18,
DST_SEGMENT19,
DST_SEGMENT20,
DST_SEGMENT21,
DST_SEGMENT22,
DST_SEGMENT23,
DST_SEGMENT24,
DST_SEGMENT25,
DST_SEGMENT26,
DST_SEGMENT27,
DST_SEGMENT28,
DST_SEGMENT29,
DST_SEGMENT30,
REQUISITION_LINE_ID,
CURRENCY_CODE,
CURRENCY_CONVERSION_DATE,
CURRENCY_CONVERSION_TYPE,
CURRENCY_CONVERSION_RATE,
USSGL_TRANSACTION_CODE,
WIP_ENTITY_TYPE,
SCHEDULE_ID,
EMPLOYEE_CODE,
DEPARTMENT_ID,
SCHEDULE_UPDATE_CODE,
SETUP_TEARDOWN_CODE,
PRIMARY_SWITCH,
MRP_CODE,
OPERATION_SEQ_NUM,
REPETITIVE_LINE_ID,
PICKING_LINE_ID,
TRX_SOURCE_LINE_ID,
TRX_SOURCE_DELIVERY_ID,
DEMAND_ID,
CUSTOMER_SHIP_ID,
LINE_ITEM_NUM,
RECEIVING_DOCUMENT,
RCV_TRANSACTION_ID,
SHIP_TO_LOCATION_ID,
ENCUMBRANCE_ACCOUNT,
ENCUMBRANCE_AMOUNT,
VENDOR_LOT_NUMBER,
TRANSFER_SUBINVENTORY,
TRANSFER_ORGANIZATION,
TRANSFER_LOCATOR,
XFER_LOC_SEGMENT1,
XFER_LOC_SEGMENT2,
XFER_LOC_SEGMENT3,
XFER_LOC_SEGMENT4,
XFER_LOC_SEGMENT5,
TRANSACTION_INTERFACE_ID,
TRANSACTION_HEADER_ID,
SOURCE_CODE,
SOURCE_LINE_ID,
SOURCE_HEADER_ID,
PROCESS_FLAG,
VALIDATION_REQUIRED,
TRANSACTION_MODE,
LOCK_FLAG,
REQUEST_ID,
INVENTORY_ITEM_ID,
ITEM_SEGMENT1,
ITEM_SEGMENT2,
ITEM_SEGMENT3,
ITEM_SEGMENT4,
ITEM_SEGMENT5,
ITEM_SEGMENT6,
ITEM_SEGMENT7,
ITEM_SEGMENT8,
ITEM_SEGMENT9,
ITEM_SEGMENT10,
ITEM_SEGMENT11,
ITEM_SEGMENT12,
ITEM_SEGMENT13,
ITEM_SEGMENT14,
ITEM_SEGMENT15,
ITEM_SEGMENT16,
ITEM_SEGMENT17,
ITEM_SEGMENT18,
ITEM_SEGMENT19,
ITEM_SEGMENT20,
REVISION,
ORGANIZATION_ID,
TRANSACTION_QUANTITY,
PRIMARY_QUANTITY,
TRANSACTION_UOM,
TRANSACTION_DATE,
ACCT_PERIOD_ID,
SUBINVENTORY_CODE,
LOCATOR_ID,
LOC_SEGMENT1,
LOC_SEGMENT2,
LOC_SEGMENT3,
LOC_SEGMENT4,
LOC_SEGMENT5,
LOC_SEGMENT6,
LOC_SEGMENT7,
LOC_SEGMENT8,
LOC_SEGMENT9,
LOC_SEGMENT10,
LOC_SEGMENT11,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN
) values (
X_PLANNING_ORGANIZATION_ID,
X_PLANNING_TP_TYPE,
X_XFR_PLANNING_ORGANIZATION_ID,
X_TRANSFER_PLANNING_TP_TYPE,
X_SECONDARY_UOM_CODE,
X_SECONDARY_TRANSACTION_QUANTI,
--X_TRANSACTION_GROUP_ID,
--X_TRANSACTION_GROUP_SEQ,
X_REPRESENTATIVE_LOT_NUMBER,
X_TRANSACTION_BATCH_ID,
X_TRANSACTION_BATCH_SEQ,
X_REBUILD_ITEM_ID,
X_REBUILD_SERIAL_NUMBER,
X_REBUILD_ACTIVITY_ID,
X_REBUILD_JOB_NAME,
X_MOVE_TRANSACTION_ID,
X_COMPLETION_TRANSACTION_ID,
X_WIP_SUPPLY_TYPE,
X_XFER_LOC_SEGMENT6,
X_XFER_LOC_SEGMENT7,
X_XFER_LOC_SEGMENT8,
X_XFER_LOC_SEGMENT9,
X_XFER_LOC_SEGMENT10,
X_XFER_LOC_SEGMENT11,
X_XFER_LOC_SEGMENT12,
X_XFER_LOC_SEGMENT13,
X_XFER_LOC_SEGMENT14,
X_XFER_LOC_SEGMENT15,
X_XFER_LOC_SEGMENT16,
X_XFER_LOC_SEGMENT17,
X_XFER_LOC_SEGMENT18,
X_XFER_LOC_SEGMENT19,
X_XFER_LOC_SEGMENT20,
X_SHIPMENT_NUMBER,
X_TRANSPORTATION_COST,
X_TRANSPORTATION_ACCOUNT,
X_TRANSFER_COST,
X_FREIGHT_CODE,
X_CONTAINERS,
X_WAYBILL_AIRBILL,
X_EXPECTED_ARRIVAL_DATE,
X_NEW_AVERAGE_COST,
X_VALUE_CHANGE,
X_PERCENTAGE_CHANGE,
X_DEMAND_SOURCE_HEADER_ID,
X_DEMAND_SOURCE_LINE,
X_DEMAND_SOURCE_DELIVERY,
X_NEGATIVE_REQ_FLAG,
X_ERROR_EXPLANATION,
X_SHIPPABLE_FLAG,
X_REQUIRED_FLAG,
X_ATTRIBUTE_CATEGORY,
X_ATTRIBUTE1,
X_ATTRIBUTE2,
X_ATTRIBUTE3,
X_ATTRIBUTE4,
X_ATTRIBUTE5,
X_ATTRIBUTE6,
X_ATTRIBUTE7,
X_ATTRIBUTE8,
X_ATTRIBUTE9,
X_ATTRIBUTE10,
X_ATTRIBUTE11,
X_ATTRIBUTE12,
X_ATTRIBUTE13,
X_ATTRIBUTE14,
X_ATTRIBUTE15,
X_REQUISITION_DISTRIBUTION_ID,
X_MOVEMENT_ID,
X_RESERVATION_QUANTITY,
X_SHIPPED_QUANTITY,
X_INVENTORY_ITEM,
X_LOCATOR_NAME,
X_TASK_ID,
X_TO_TASK_ID,
X_SOURCE_TASK_ID,
X_PROJECT_ID,
X_TO_PROJECT_ID,
X_SOURCE_PROJECT_ID,
X_PA_EXPENDITURE_ORG_ID,
X_EXPENDITURE_TYPE,
X_FINAL_COMPLETION_FLAG,
X_TRANSFER_PERCENTAGE,
X_TRANSACTION_SEQUENCE_ID,
X_MATERIAL_ACCOUNT,
X_MATERIAL_OVERHEAD_ACCOUNT,
X_RESOURCE_ACCOUNT,
X_OUTSIDE_PROCESSING_ACCOUNT,
X_OVERHEAD_ACCOUNT,
X_BOM_REVISION,
X_ROUTING_REVISION,
X_BOM_REVISION_DATE,
X_ROUTING_REVISION_DATE,
X_ALTERNATE_BOM_DESIGNATOR,
X_ALTERNATE_ROUTING_DESIGNATOR,
X_ACCOUNTING_CLASS,
X_DEMAND_CLASS,
X_PARENT_ID,
X_SUBSTITUTION_TYPE_ID,
X_SUBSTITUTION_ITEM_ID,
X_SCHEDULE_GROUP,
X_BUILD_SEQUENCE,
X_SCHEDULE_NUMBER,
X_SCHEDULED_FLAG,
X_FLOW_SCHEDULE,
X_COST_GROUP_ID,
X_KANBAN_CARD_ID,
X_QA_COLLECTION_ID,
X_OVERCOMPLETION_TRANSACTION_Q,
X_OVERCOMPLETION_PRIMARY_QTY,
X_OVERCOMPLETION_TRANSACTION_I,
X_END_ITEM_UNIT_NUMBER,
X_SCHEDULED_PAYBACK_DATE,
X_ORG_COST_GROUP_ID,
X_COST_TYPE_ID,
X_SOURCE_LOT_NUMBER,
X_TRANSFER_COST_GROUP_ID,
X_LPN_ID,
X_TRANSFER_LPN_ID,
X_CONTENT_LPN_ID,
X_XML_DOCUMENT_ID,
X_ORGANIZATION_TYPE,
X_TRANSFER_ORGANIZATION_TYPE,
X_OWNING_ORGANIZATION_ID,
X_OWNING_TP_TYPE,
X_XFR_OWNING_ORGANIZATION_ID,
X_TRANSFER_OWNING_TP_TYPE,
X_LOC_SEGMENT12,
X_LOC_SEGMENT13,
X_LOC_SEGMENT14,
X_LOC_SEGMENT15,
X_LOC_SEGMENT16,
X_LOC_SEGMENT17,
X_LOC_SEGMENT18,
X_LOC_SEGMENT19,
X_LOC_SEGMENT20,
X_TRANSACTION_SOURCE_ID,
X_DSP_SEGMENT1,
X_DSP_SEGMENT2,
X_DSP_SEGMENT3,
X_DSP_SEGMENT4,
X_DSP_SEGMENT5,
X_DSP_SEGMENT6,
X_DSP_SEGMENT7,
X_DSP_SEGMENT8,
X_DSP_SEGMENT9,
X_DSP_SEGMENT10,
X_DSP_SEGMENT11,
X_DSP_SEGMENT12,
X_DSP_SEGMENT13,
X_DSP_SEGMENT14,
X_DSP_SEGMENT15,
X_DSP_SEGMENT16,
X_DSP_SEGMENT17,
X_DSP_SEGMENT18,
X_DSP_SEGMENT19,
X_DSP_SEGMENT20,
X_DSP_SEGMENT21,
X_DSP_SEGMENT22,
X_DSP_SEGMENT23,
X_DSP_SEGMENT24,
X_DSP_SEGMENT25,
X_DSP_SEGMENT26,
X_DSP_SEGMENT27,
X_DSP_SEGMENT28,
X_DSP_SEGMENT29,
X_DSP_SEGMENT30,
X_TRANSACTION_SOURCE_NAME,
X_TRANSACTION_SOURCE_TYPE_ID,
X_TRANSACTION_ACTION_ID,
X_TRANSACTION_TYPE_ID,
X_REASON_ID,
X_TRANSACTION_REFERENCE,
X_TRANSACTION_COST,
X_DISTRIBUTION_ACCOUNT_ID,
X_DST_SEGMENT1,
X_DST_SEGMENT2,
X_DST_SEGMENT3,
X_DST_SEGMENT4,
X_DST_SEGMENT5,
X_DST_SEGMENT6,
X_DST_SEGMENT7,
X_DST_SEGMENT8,
X_DST_SEGMENT9,
X_DST_SEGMENT10,
X_DST_SEGMENT11,
X_DST_SEGMENT12,
X_DST_SEGMENT13,
X_DST_SEGMENT14,
X_DST_SEGMENT15,
X_DST_SEGMENT16,
X_DST_SEGMENT17,
X_DST_SEGMENT18,
X_DST_SEGMENT19,
X_DST_SEGMENT20,
X_DST_SEGMENT21,
X_DST_SEGMENT22,
X_DST_SEGMENT23,
X_DST_SEGMENT24,
X_DST_SEGMENT25,
X_DST_SEGMENT26,
X_DST_SEGMENT27,
X_DST_SEGMENT28,
X_DST_SEGMENT29,
X_DST_SEGMENT30,
X_REQUISITION_LINE_ID,
X_CURRENCY_CODE,
X_CURRENCY_CONVERSION_DATE,
X_CURRENCY_CONVERSION_TYPE,
X_CURRENCY_CONVERSION_RATE,
X_USSGL_TRANSACTION_CODE,
X_WIP_ENTITY_TYPE,
X_SCHEDULE_ID,
X_EMPLOYEE_CODE,
X_DEPARTMENT_ID,
X_SCHEDULE_UPDATE_CODE,
X_SETUP_TEARDOWN_CODE,
X_PRIMARY_SWITCH,
X_MRP_CODE,
X_OPERATION_SEQ_NUM,
X_REPETITIVE_LINE_ID,
X_PICKING_LINE_ID,
X_TRX_SOURCE_LINE_ID,
X_TRX_SOURCE_DELIVERY_ID,
X_DEMAND_ID,
X_CUSTOMER_SHIP_ID,
X_LINE_ITEM_NUM,
X_RECEIVING_DOCUMENT,
X_RCV_TRANSACTION_ID,
X_SHIP_TO_LOCATION_ID,
X_ENCUMBRANCE_ACCOUNT,
X_ENCUMBRANCE_AMOUNT,
X_VENDOR_LOT_NUMBER,
X_TRANSFER_SUBINVENTORY,
X_TRANSFER_ORGANIZATION,
X_TRANSFER_LOCATOR,
X_XFER_LOC_SEGMENT1,
X_XFER_LOC_SEGMENT2,
X_XFER_LOC_SEGMENT3,
X_XFER_LOC_SEGMENT4,
X_XFER_LOC_SEGMENT5,
X_TRANSACTION_INTERFACE_ID,
X_TRANSACTION_HEADER_ID,
X_SOURCE_CODE,
X_SOURCE_LINE_ID,
X_SOURCE_HEADER_ID,
X_PROCESS_FLAG,
X_VALIDATION_REQUIRED,
X_TRANSACTION_MODE,
X_LOCK_FLAG,
X_REQUEST_ID,
X_INVENTORY_ITEM_ID,
X_ITEM_SEGMENT1,
X_ITEM_SEGMENT2,
X_ITEM_SEGMENT3,
X_ITEM_SEGMENT4,
X_ITEM_SEGMENT5,
X_ITEM_SEGMENT6,
X_ITEM_SEGMENT7,
X_ITEM_SEGMENT8,
X_ITEM_SEGMENT9,
X_ITEM_SEGMENT10,
X_ITEM_SEGMENT11,
X_ITEM_SEGMENT12,
X_ITEM_SEGMENT13,
X_ITEM_SEGMENT14,
X_ITEM_SEGMENT15,
X_ITEM_SEGMENT16,
X_ITEM_SEGMENT17,
X_ITEM_SEGMENT18,
X_ITEM_SEGMENT19,
X_ITEM_SEGMENT20,
X_REVISION,
X_ORGANIZATION_ID,
X_TRANSACTION_QUANTITY,
X_PRIMARY_QUANTITY,
X_TRANSACTION_UOM,
X_TRANSACTION_DATE,
X_ACCT_PERIOD_ID,
X_SUBINVENTORY_CODE,
X_LOCATOR_ID,
X_LOC_SEGMENT1,
X_LOC_SEGMENT2,
X_LOC_SEGMENT3,
X_LOC_SEGMENT4,
X_LOC_SEGMENT5,
X_LOC_SEGMENT6,
X_LOC_SEGMENT7,
X_LOC_SEGMENT8,
X_LOC_SEGMENT9,
X_LOC_SEGMENT10,
X_LOC_SEGMENT11,
sysdate,
fnd_global.user_id,
sysdate,
fnd_global.user_id,
fnd_global.login_id
);
end INSERT_ROW;
X_SCHEDULE_UPDATE_CODE in NUMBER,
X_SETUP_TEARDOWN_CODE in NUMBER,
X_PRIMARY_SWITCH in NUMBER,
X_MRP_CODE in NUMBER,
X_OPERATION_SEQ_NUM in NUMBER,
X_REPETITIVE_LINE_ID in NUMBER,
X_PICKING_LINE_ID in NUMBER,
X_TRX_SOURCE_LINE_ID in NUMBER,
X_TRX_SOURCE_DELIVERY_ID in NUMBER,
X_DEMAND_ID in NUMBER,
X_CUSTOMER_SHIP_ID in NUMBER,
X_LINE_ITEM_NUM in NUMBER,
X_RECEIVING_DOCUMENT in VARCHAR2,
X_RCV_TRANSACTION_ID in NUMBER,
X_SHIP_TO_LOCATION_ID in NUMBER,
X_ENCUMBRANCE_ACCOUNT in NUMBER,
X_ENCUMBRANCE_AMOUNT in NUMBER,
X_VENDOR_LOT_NUMBER in VARCHAR2,
X_TRANSFER_SUBINVENTORY in VARCHAR2,
X_TRANSFER_ORGANIZATION in NUMBER,
X_TRANSFER_LOCATOR in NUMBER,
X_XFER_LOC_SEGMENT1 in VARCHAR2,
X_XFER_LOC_SEGMENT2 in VARCHAR2,
X_XFER_LOC_SEGMENT3 in VARCHAR2,
X_XFER_LOC_SEGMENT4 in VARCHAR2,
X_XFER_LOC_SEGMENT5 in VARCHAR2,
X_TRANSACTION_HEADER_ID in NUMBER,
X_SOURCE_CODE in VARCHAR2,
X_SOURCE_LINE_ID in NUMBER,
X_SOURCE_HEADER_ID in NUMBER,
X_PROCESS_FLAG in NUMBER,
X_VALIDATION_REQUIRED in NUMBER,
X_TRANSACTION_MODE in NUMBER,
X_LOCK_FLAG in NUMBER,
X_REQUEST_ID in NUMBER,
X_INVENTORY_ITEM_ID in NUMBER,
X_ITEM_SEGMENT1 in VARCHAR2,
X_ITEM_SEGMENT2 in VARCHAR2,
X_ITEM_SEGMENT3 in VARCHAR2,
X_ITEM_SEGMENT4 in VARCHAR2,
X_ITEM_SEGMENT5 in VARCHAR2,
X_ITEM_SEGMENT6 in VARCHAR2,
X_ITEM_SEGMENT7 in VARCHAR2,
X_ITEM_SEGMENT8 in VARCHAR2,
X_ITEM_SEGMENT9 in VARCHAR2,
X_ITEM_SEGMENT10 in VARCHAR2,
X_ITEM_SEGMENT11 in VARCHAR2,
X_ITEM_SEGMENT12 in VARCHAR2,
X_ITEM_SEGMENT13 in VARCHAR2,
X_ITEM_SEGMENT14 in VARCHAR2,
X_ITEM_SEGMENT15 in VARCHAR2,
X_ITEM_SEGMENT16 in VARCHAR2,
X_ITEM_SEGMENT17 in VARCHAR2,
X_ITEM_SEGMENT18 in VARCHAR2,
X_ITEM_SEGMENT19 in VARCHAR2,
X_ITEM_SEGMENT20 in VARCHAR2,
X_REVISION in VARCHAR2,
X_ORGANIZATION_ID in NUMBER,
X_TRANSACTION_QUANTITY in NUMBER,
X_PRIMARY_QUANTITY in NUMBER,
X_TRANSACTION_UOM in VARCHAR2,
X_TRANSACTION_DATE in DATE,
X_ACCT_PERIOD_ID in NUMBER,
X_SUBINVENTORY_CODE in VARCHAR2,
X_LOCATOR_ID in NUMBER,
X_LOC_SEGMENT1 in VARCHAR2,
X_LOC_SEGMENT2 in VARCHAR2,
X_LOC_SEGMENT3 in VARCHAR2,
X_LOC_SEGMENT4 in VARCHAR2,
X_LOC_SEGMENT5 in VARCHAR2,
X_LOC_SEGMENT6 in VARCHAR2,
X_LOC_SEGMENT7 in VARCHAR2,
X_LOC_SEGMENT8 in VARCHAR2,
X_LOC_SEGMENT9 in VARCHAR2,
X_LOC_SEGMENT10 in VARCHAR2,
X_LOC_SEGMENT11 in VARCHAR2,
X_ERROR_CODE in VARCHAR2
) is
cursor c is select
PLANNING_ORGANIZATION_ID,
PLANNING_TP_TYPE,
XFR_PLANNING_ORGANIZATION_ID,
TRANSFER_PLANNING_TP_TYPE,
SECONDARY_UOM_CODE,
SECONDARY_TRANSACTION_QUANTITY,
--TRANSACTION_GROUP_ID,
--TRANSACTION_GROUP_SEQ,
REPRESENTATIVE_LOT_NUMBER,
TRANSACTION_BATCH_ID,
TRANSACTION_BATCH_SEQ,
REBUILD_ITEM_ID,
REBUILD_SERIAL_NUMBER,
REBUILD_ACTIVITY_ID,
REBUILD_JOB_NAME,
MOVE_TRANSACTION_ID,
COMPLETION_TRANSACTION_ID,
WIP_SUPPLY_TYPE,
XFER_LOC_SEGMENT6,
XFER_LOC_SEGMENT7,
XFER_LOC_SEGMENT8,
XFER_LOC_SEGMENT9,
XFER_LOC_SEGMENT10,
XFER_LOC_SEGMENT11,
XFER_LOC_SEGMENT12,
XFER_LOC_SEGMENT13,
XFER_LOC_SEGMENT14,
XFER_LOC_SEGMENT15,
XFER_LOC_SEGMENT16,
XFER_LOC_SEGMENT17,
XFER_LOC_SEGMENT18,
XFER_LOC_SEGMENT19,
XFER_LOC_SEGMENT20,
SHIPMENT_NUMBER,
TRANSPORTATION_COST,
TRANSPORTATION_ACCOUNT,
TRANSFER_COST,
FREIGHT_CODE,
CONTAINERS,
WAYBILL_AIRBILL,
EXPECTED_ARRIVAL_DATE,
NEW_AVERAGE_COST,
VALUE_CHANGE,
PERCENTAGE_CHANGE,
DEMAND_SOURCE_HEADER_ID,
DEMAND_SOURCE_LINE,
DEMAND_SOURCE_DELIVERY,
NEGATIVE_REQ_FLAG,
ERROR_EXPLANATION,
SHIPPABLE_FLAG,
REQUIRED_FLAG,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
REQUISITION_DISTRIBUTION_ID,
MOVEMENT_ID,
RESERVATION_QUANTITY,
SHIPPED_QUANTITY,
INVENTORY_ITEM,
LOCATOR_NAME,
TASK_ID,
TO_TASK_ID,
SOURCE_TASK_ID,
PROJECT_ID,
TO_PROJECT_ID,
SOURCE_PROJECT_ID,
PA_EXPENDITURE_ORG_ID,
EXPENDITURE_TYPE,
FINAL_COMPLETION_FLAG,
TRANSFER_PERCENTAGE,
TRANSACTION_SEQUENCE_ID,
MATERIAL_ACCOUNT,
MATERIAL_OVERHEAD_ACCOUNT,
RESOURCE_ACCOUNT,
OUTSIDE_PROCESSING_ACCOUNT,
OVERHEAD_ACCOUNT,
BOM_REVISION,
ROUTING_REVISION,
BOM_REVISION_DATE,
ROUTING_REVISION_DATE,
ALTERNATE_BOM_DESIGNATOR,
ALTERNATE_ROUTING_DESIGNATOR,
ACCOUNTING_CLASS,
DEMAND_CLASS,
PARENT_ID,
SUBSTITUTION_TYPE_ID,
SUBSTITUTION_ITEM_ID,
SCHEDULE_GROUP,
BUILD_SEQUENCE,
SCHEDULE_NUMBER,
SCHEDULED_FLAG,
FLOW_SCHEDULE,
COST_GROUP_ID,
KANBAN_CARD_ID,
QA_COLLECTION_ID,
OVERCOMPLETION_TRANSACTION_QTY,
OVERCOMPLETION_PRIMARY_QTY,
OVERCOMPLETION_TRANSACTION_ID,
END_ITEM_UNIT_NUMBER,
SCHEDULED_PAYBACK_DATE,
ORG_COST_GROUP_ID,
COST_TYPE_ID,
SOURCE_LOT_NUMBER,
TRANSFER_COST_GROUP_ID,
LPN_ID,
TRANSFER_LPN_ID,
CONTENT_LPN_ID,
XML_DOCUMENT_ID,
ORGANIZATION_TYPE,
TRANSFER_ORGANIZATION_TYPE,
OWNING_ORGANIZATION_ID,
OWNING_TP_TYPE,
XFR_OWNING_ORGANIZATION_ID,
TRANSFER_OWNING_TP_TYPE,
LOC_SEGMENT12,
LOC_SEGMENT13,
LOC_SEGMENT14,
LOC_SEGMENT15,
LOC_SEGMENT16,
LOC_SEGMENT17,
LOC_SEGMENT18,
LOC_SEGMENT19,
LOC_SEGMENT20,
TRANSACTION_SOURCE_ID,
DSP_SEGMENT1,
DSP_SEGMENT2,
DSP_SEGMENT3,
DSP_SEGMENT4,
DSP_SEGMENT5,
DSP_SEGMENT6,
DSP_SEGMENT7,
DSP_SEGMENT8,
DSP_SEGMENT9,
DSP_SEGMENT10,
DSP_SEGMENT11,
DSP_SEGMENT12,
DSP_SEGMENT13,
DSP_SEGMENT14,
DSP_SEGMENT15,
DSP_SEGMENT16,
DSP_SEGMENT17,
DSP_SEGMENT18,
DSP_SEGMENT19,
DSP_SEGMENT20,
DSP_SEGMENT21,
DSP_SEGMENT22,
DSP_SEGMENT23,
DSP_SEGMENT24,
DSP_SEGMENT25,
DSP_SEGMENT26,
DSP_SEGMENT27,
DSP_SEGMENT28,
DSP_SEGMENT29,
DSP_SEGMENT30,
TRANSACTION_SOURCE_NAME,
TRANSACTION_SOURCE_TYPE_ID,
TRANSACTION_ACTION_ID,
TRANSACTION_TYPE_ID,
REASON_ID,
TRANSACTION_REFERENCE,
TRANSACTION_COST,
DISTRIBUTION_ACCOUNT_ID,
DST_SEGMENT1,
DST_SEGMENT2,
DST_SEGMENT3,
DST_SEGMENT4,
DST_SEGMENT5,
DST_SEGMENT6,
DST_SEGMENT7,
DST_SEGMENT8,
DST_SEGMENT9,
DST_SEGMENT10,
DST_SEGMENT11,
DST_SEGMENT12,
DST_SEGMENT13,
DST_SEGMENT14,
DST_SEGMENT15,
DST_SEGMENT16,
DST_SEGMENT17,
DST_SEGMENT18,
DST_SEGMENT19,
DST_SEGMENT20,
DST_SEGMENT21,
DST_SEGMENT22,
DST_SEGMENT23,
DST_SEGMENT24,
DST_SEGMENT25,
DST_SEGMENT26,
DST_SEGMENT27,
DST_SEGMENT28,
DST_SEGMENT29,
DST_SEGMENT30,
REQUISITION_LINE_ID,
CURRENCY_CODE,
CURRENCY_CONVERSION_DATE,
CURRENCY_CONVERSION_TYPE,
CURRENCY_CONVERSION_RATE,
USSGL_TRANSACTION_CODE,
WIP_ENTITY_TYPE,
SCHEDULE_ID,
EMPLOYEE_CODE,
DEPARTMENT_ID,
SCHEDULE_UPDATE_CODE,
SETUP_TEARDOWN_CODE,
PRIMARY_SWITCH,
MRP_CODE,
OPERATION_SEQ_NUM,
REPETITIVE_LINE_ID,
PICKING_LINE_ID,
TRX_SOURCE_LINE_ID,
TRX_SOURCE_DELIVERY_ID,
DEMAND_ID,
CUSTOMER_SHIP_ID,
LINE_ITEM_NUM,
RECEIVING_DOCUMENT,
RCV_TRANSACTION_ID,
SHIP_TO_LOCATION_ID,
ENCUMBRANCE_ACCOUNT,
ENCUMBRANCE_AMOUNT,
VENDOR_LOT_NUMBER,
TRANSFER_SUBINVENTORY,
TRANSFER_ORGANIZATION,
TRANSFER_LOCATOR,
XFER_LOC_SEGMENT1,
XFER_LOC_SEGMENT2,
XFER_LOC_SEGMENT3,
XFER_LOC_SEGMENT4,
XFER_LOC_SEGMENT5,
TRANSACTION_HEADER_ID,
SOURCE_CODE,
SOURCE_LINE_ID,
SOURCE_HEADER_ID,
PROCESS_FLAG,
VALIDATION_REQUIRED,
TRANSACTION_MODE,
LOCK_FLAG,
REQUEST_ID,
INVENTORY_ITEM_ID,
ITEM_SEGMENT1,
ITEM_SEGMENT2,
ITEM_SEGMENT3,
ITEM_SEGMENT4,
ITEM_SEGMENT5,
ITEM_SEGMENT6,
ITEM_SEGMENT7,
ITEM_SEGMENT8,
ITEM_SEGMENT9,
ITEM_SEGMENT10,
ITEM_SEGMENT11,
ITEM_SEGMENT12,
ITEM_SEGMENT13,
ITEM_SEGMENT14,
ITEM_SEGMENT15,
ITEM_SEGMENT16,
ITEM_SEGMENT17,
ITEM_SEGMENT18,
ITEM_SEGMENT19,
ITEM_SEGMENT20,
REVISION,
ORGANIZATION_ID,
TRANSACTION_QUANTITY,
PRIMARY_QUANTITY,
TRANSACTION_UOM,
TRANSACTION_DATE,
ACCT_PERIOD_ID,
SUBINVENTORY_CODE,
LOCATOR_ID,
LOC_SEGMENT1,
LOC_SEGMENT2,
LOC_SEGMENT3,
LOC_SEGMENT4,
LOC_SEGMENT5,
LOC_SEGMENT6,
LOC_SEGMENT7,
LOC_SEGMENT8,
LOC_SEGMENT9,
LOC_SEGMENT10,
LOC_SEGMENT11
from MTL_TRANSACTIONS_INTERFACE
where TRANSACTION_INTERFACE_ID = X_TRANSACTION_INTERFACE_ID
for update of TRANSACTION_INTERFACE_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.SETUP_TEARDOWN_CODE = X_SETUP_TEARDOWN_CODE)
OR ((recinfo.SETUP_TEARDOWN_CODE is null) AND (X_SETUP_TEARDOWN_CODE is null)))
AND ((recinfo.PRIMARY_SWITCH = X_PRIMARY_SWITCH)
OR ((recinfo.PRIMARY_SWITCH is null) AND (X_PRIMARY_SWITCH is null)))
AND ((recinfo.MRP_CODE = X_MRP_CODE)
OR ((recinfo.MRP_CODE is null) AND (X_MRP_CODE is null)))
AND ((recinfo.OPERATION_SEQ_NUM = X_OPERATION_SEQ_NUM)
OR ((recinfo.OPERATION_SEQ_NUM is null) AND (X_OPERATION_SEQ_NUM is null)))
AND ((recinfo.REPETITIVE_LINE_ID = X_REPETITIVE_LINE_ID)
OR ((recinfo.REPETITIVE_LINE_ID is null) AND (X_REPETITIVE_LINE_ID is null)))
AND ((recinfo.PICKING_LINE_ID = X_PICKING_LINE_ID)
OR ((recinfo.PICKING_LINE_ID is null) AND (X_PICKING_LINE_ID is null)))
AND ((recinfo.TRX_SOURCE_LINE_ID = X_TRX_SOURCE_LINE_ID)
OR ((recinfo.TRX_SOURCE_LINE_ID is null) AND (X_TRX_SOURCE_LINE_ID is null)))
AND ((recinfo.TRX_SOURCE_DELIVERY_ID = X_TRX_SOURCE_DELIVERY_ID)
OR ((recinfo.TRX_SOURCE_DELIVERY_ID is null) AND (X_TRX_SOURCE_DELIVERY_ID is null)))
AND ((recinfo.DEMAND_ID = X_DEMAND_ID)
OR ((recinfo.DEMAND_ID is null) AND (X_DEMAND_ID is null)))
AND ((recinfo.CUSTOMER_SHIP_ID = X_CUSTOMER_SHIP_ID)
OR ((recinfo.CUSTOMER_SHIP_ID is null) AND (X_CUSTOMER_SHIP_ID is null)))
AND ((recinfo.LINE_ITEM_NUM = X_LINE_ITEM_NUM)
OR ((recinfo.LINE_ITEM_NUM is null) AND (X_LINE_ITEM_NUM is null)))
AND ((recinfo.RECEIVING_DOCUMENT = X_RECEIVING_DOCUMENT)
OR ((recinfo.RECEIVING_DOCUMENT is null) AND (X_RECEIVING_DOCUMENT is null)))
AND ((recinfo.RCV_TRANSACTION_ID = X_RCV_TRANSACTION_ID)
OR ((recinfo.RCV_TRANSACTION_ID is null) AND (X_RCV_TRANSACTION_ID is null)))
AND ((recinfo.SHIP_TO_LOCATION_ID = X_SHIP_TO_LOCATION_ID)
OR ((recinfo.SHIP_TO_LOCATION_ID is null) AND (X_SHIP_TO_LOCATION_ID is null)))
AND ((recinfo.ENCUMBRANCE_ACCOUNT = X_ENCUMBRANCE_ACCOUNT)
OR ((recinfo.ENCUMBRANCE_ACCOUNT is null) AND (X_ENCUMBRANCE_ACCOUNT is null)))
AND ((recinfo.ENCUMBRANCE_AMOUNT = X_ENCUMBRANCE_AMOUNT)
OR ((recinfo.ENCUMBRANCE_AMOUNT is null) AND (X_ENCUMBRANCE_AMOUNT is null)))
AND ((recinfo.VENDOR_LOT_NUMBER = X_VENDOR_LOT_NUMBER)
OR ((recinfo.VENDOR_LOT_NUMBER is null) AND (X_VENDOR_LOT_NUMBER is null)))
AND ((recinfo.TRANSFER_SUBINVENTORY = X_TRANSFER_SUBINVENTORY)
OR ((recinfo.TRANSFER_SUBINVENTORY is null) AND (X_TRANSFER_SUBINVENTORY is null)))
AND ((recinfo.TRANSFER_ORGANIZATION = X_TRANSFER_ORGANIZATION)
OR ((recinfo.TRANSFER_ORGANIZATION is null) AND (X_TRANSFER_ORGANIZATION is null)))
AND ((recinfo.TRANSFER_LOCATOR = X_TRANSFER_LOCATOR)
OR ((recinfo.TRANSFER_LOCATOR is null) AND (X_TRANSFER_LOCATOR is null)))
AND ((recinfo.XFER_LOC_SEGMENT1 = X_XFER_LOC_SEGMENT1)
OR ((recinfo.XFER_LOC_SEGMENT1 is null) AND (X_XFER_LOC_SEGMENT1 is null)))
AND ((recinfo.XFER_LOC_SEGMENT2 = X_XFER_LOC_SEGMENT2)
OR ((recinfo.XFER_LOC_SEGMENT2 is null) AND (X_XFER_LOC_SEGMENT2 is null)))
AND ((recinfo.XFER_LOC_SEGMENT3 = X_XFER_LOC_SEGMENT3)
OR ((recinfo.XFER_LOC_SEGMENT3 is null) AND (X_XFER_LOC_SEGMENT3 is null)))
AND ((recinfo.XFER_LOC_SEGMENT4 = X_XFER_LOC_SEGMENT4)
OR ((recinfo.XFER_LOC_SEGMENT4 is null) AND (X_XFER_LOC_SEGMENT4 is null)))
AND ((recinfo.XFER_LOC_SEGMENT5 = X_XFER_LOC_SEGMENT5)
OR ((recinfo.XFER_LOC_SEGMENT5 is null) AND (X_XFER_LOC_SEGMENT5 is null)))
AND ((recinfo.TRANSACTION_HEADER_ID = X_TRANSACTION_HEADER_ID)
OR ((recinfo.TRANSACTION_HEADER_ID is null) AND (X_TRANSACTION_HEADER_ID is null)))
AND (recinfo.SOURCE_CODE = X_SOURCE_CODE)
AND (recinfo.SOURCE_LINE_ID = X_SOURCE_LINE_ID)
AND (recinfo.SOURCE_HEADER_ID = X_SOURCE_HEADER_ID)
AND (recinfo.PROCESS_FLAG = X_PROCESS_FLAG)
AND ((recinfo.VALIDATION_REQUIRED = X_VALIDATION_REQUIRED)
OR ((recinfo.VALIDATION_REQUIRED is null) AND (X_VALIDATION_REQUIRED is null)))
AND (recinfo.TRANSACTION_MODE = X_TRANSACTION_MODE)
AND ((recinfo.LOCK_FLAG = X_LOCK_FLAG)
OR ((recinfo.LOCK_FLAG is null) AND (X_LOCK_FLAG is null)))
AND ((recinfo.REQUEST_ID = X_REQUEST_ID)
OR ((recinfo.REQUEST_ID is null) AND (X_REQUEST_ID is null)))
AND ((recinfo.INVENTORY_ITEM_ID = X_INVENTORY_ITEM_ID)
OR ((recinfo.INVENTORY_ITEM_ID is null) AND (X_INVENTORY_ITEM_ID is null)))
AND ((recinfo.ITEM_SEGMENT1 = X_ITEM_SEGMENT1)
OR ((recinfo.ITEM_SEGMENT1 is null) AND (X_ITEM_SEGMENT1 is null)))
AND ((recinfo.ITEM_SEGMENT2 = X_ITEM_SEGMENT2)
OR ((recinfo.ITEM_SEGMENT2 is null) AND (X_ITEM_SEGMENT2 is null)))
AND ((recinfo.ITEM_SEGMENT3 = X_ITEM_SEGMENT3)
OR ((recinfo.ITEM_SEGMENT3 is null) AND (X_ITEM_SEGMENT3 is null)))
AND ((recinfo.ITEM_SEGMENT4 = X_ITEM_SEGMENT4)
OR ((recinfo.ITEM_SEGMENT4 is null) AND (X_ITEM_SEGMENT4 is null)))
AND ((recinfo.ITEM_SEGMENT5 = X_ITEM_SEGMENT5)
OR ((recinfo.ITEM_SEGMENT5 is null) AND (X_ITEM_SEGMENT5 is null)))
AND ((recinfo.ITEM_SEGMENT6 = X_ITEM_SEGMENT6)
OR ((recinfo.ITEM_SEGMENT6 is null) AND (X_ITEM_SEGMENT6 is null)))
AND ((recinfo.ITEM_SEGMENT7 = X_ITEM_SEGMENT7)
OR ((recinfo.ITEM_SEGMENT7 is null) AND (X_ITEM_SEGMENT7 is null)))
AND ((recinfo.ITEM_SEGMENT8 = X_ITEM_SEGMENT8)
OR ((recinfo.ITEM_SEGMENT8 is null) AND (X_ITEM_SEGMENT8 is null)))
AND ((recinfo.ITEM_SEGMENT9 = X_ITEM_SEGMENT9)
OR ((recinfo.ITEM_SEGMENT9 is null) AND (X_ITEM_SEGMENT9 is null)))
AND ((recinfo.ITEM_SEGMENT10 = X_ITEM_SEGMENT10)
OR ((recinfo.ITEM_SEGMENT10 is null) AND (X_ITEM_SEGMENT10 is null)))
AND ((recinfo.ITEM_SEGMENT11 = X_ITEM_SEGMENT11)
OR ((recinfo.ITEM_SEGMENT11 is null) AND (X_ITEM_SEGMENT11 is null)))
AND ((recinfo.ITEM_SEGMENT12 = X_ITEM_SEGMENT12)
OR ((recinfo.ITEM_SEGMENT12 is null) AND (X_ITEM_SEGMENT12 is null)))
AND ((recinfo.ITEM_SEGMENT13 = X_ITEM_SEGMENT13)
OR ((recinfo.ITEM_SEGMENT13 is null) AND (X_ITEM_SEGMENT13 is null)))
AND ((recinfo.ITEM_SEGMENT14 = X_ITEM_SEGMENT14)
OR ((recinfo.ITEM_SEGMENT14 is null) AND (X_ITEM_SEGMENT14 is null)))
AND ((recinfo.ITEM_SEGMENT15 = X_ITEM_SEGMENT15)
OR ((recinfo.ITEM_SEGMENT15 is null) AND (X_ITEM_SEGMENT15 is null)))
AND ((recinfo.ITEM_SEGMENT16 = X_ITEM_SEGMENT16)
OR ((recinfo.ITEM_SEGMENT16 is null) AND (X_ITEM_SEGMENT16 is null)))
AND ((recinfo.ITEM_SEGMENT17 = X_ITEM_SEGMENT17)
OR ((recinfo.ITEM_SEGMENT17 is null) AND (X_ITEM_SEGMENT17 is null)))
AND ((recinfo.ITEM_SEGMENT18 = X_ITEM_SEGMENT18)
OR ((recinfo.ITEM_SEGMENT18 is null) AND (X_ITEM_SEGMENT18 is null)))
AND ((recinfo.ITEM_SEGMENT19 = X_ITEM_SEGMENT19)
OR ((recinfo.ITEM_SEGMENT19 is null) AND (X_ITEM_SEGMENT19 is null)))
AND ((recinfo.ITEM_SEGMENT20 = X_ITEM_SEGMENT20)
OR ((recinfo.ITEM_SEGMENT20 is null) AND (X_ITEM_SEGMENT20 is null)))
AND ((recinfo.REVISION = X_REVISION)
OR ((recinfo.REVISION is null) AND (X_REVISION is null)))
AND (recinfo.ORGANIZATION_ID = X_ORGANIZATION_ID)
AND (recinfo.TRANSACTION_QUANTITY = X_TRANSACTION_QUANTITY)
AND ((recinfo.PRIMARY_QUANTITY = X_PRIMARY_QUANTITY)
OR ((recinfo.PRIMARY_QUANTITY is null) AND (X_PRIMARY_QUANTITY is null)))
AND (recinfo.TRANSACTION_UOM = X_TRANSACTION_UOM)
AND (recinfo.TRANSACTION_DATE = X_TRANSACTION_DATE)
AND ((recinfo.ACCT_PERIOD_ID = X_ACCT_PERIOD_ID)
OR ((recinfo.ACCT_PERIOD_ID is null) AND (X_ACCT_PERIOD_ID is null)))
AND ((recinfo.SUBINVENTORY_CODE = X_SUBINVENTORY_CODE)
OR ((recinfo.SUBINVENTORY_CODE is null) AND (X_SUBINVENTORY_CODE is null)))
AND ((recinfo.LOCATOR_ID = X_LOCATOR_ID)
OR ((recinfo.LOCATOR_ID is null) AND (X_LOCATOR_ID is null)))
AND ((recinfo.LOC_SEGMENT1 = X_LOC_SEGMENT1)
OR ((recinfo.LOC_SEGMENT1 is null) AND (X_LOC_SEGMENT1 is null)))
AND ((recinfo.LOC_SEGMENT2 = X_LOC_SEGMENT2)
OR ((recinfo.LOC_SEGMENT2 is null) AND (X_LOC_SEGMENT2 is null)))
AND ((recinfo.LOC_SEGMENT3 = X_LOC_SEGMENT3)
OR ((recinfo.LOC_SEGMENT3 is null) AND (X_LOC_SEGMENT3 is null)))
AND ((recinfo.LOC_SEGMENT4 = X_LOC_SEGMENT4)
OR ((recinfo.LOC_SEGMENT4 is null) AND (X_LOC_SEGMENT4 is null)))
AND ((recinfo.LOC_SEGMENT5 = X_LOC_SEGMENT5)
OR ((recinfo.LOC_SEGMENT5 is null) AND (X_LOC_SEGMENT5 is null)))
AND ((recinfo.LOC_SEGMENT6 = X_LOC_SEGMENT6)
OR ((recinfo.LOC_SEGMENT6 is null) AND (X_LOC_SEGMENT6 is null)))
AND ((recinfo.LOC_SEGMENT7 = X_LOC_SEGMENT7)
OR ((recinfo.LOC_SEGMENT7 is null) AND (X_LOC_SEGMENT7 is null)))
AND ((recinfo.LOC_SEGMENT8 = X_LOC_SEGMENT8)
OR ((recinfo.LOC_SEGMENT8 is null) AND (X_LOC_SEGMENT8 is null)))
AND ((recinfo.LOC_SEGMENT9 = X_LOC_SEGMENT9)
OR ((recinfo.LOC_SEGMENT9 is null) AND (X_LOC_SEGMENT9 is null)))
AND ((recinfo.LOC_SEGMENT10 = X_LOC_SEGMENT10)
OR ((recinfo.LOC_SEGMENT10 is null) AND (X_LOC_SEGMENT10 is null)))
AND ((recinfo.LOC_SEGMENT11 = X_LOC_SEGMENT11)
OR ((recinfo.LOC_SEGMENT11 is null) AND (X_LOC_SEGMENT11 is null)))
) then
null;
procedure UPDATE_ROW (
X_TRANSACTION_INTERFACE_ID in NUMBER,
X_PLANNING_ORGANIZATION_ID in NUMBER,
X_PLANNING_TP_TYPE in NUMBER,
X_XFR_PLANNING_ORGANIZATION_ID in NUMBER,
X_TRANSFER_PLANNING_TP_TYPE in NUMBER,
X_SECONDARY_UOM_CODE in VARCHAR2,
X_SECONDARY_TRANSACTION_QUANTI in NUMBER,
X_TRANSACTION_GROUP_ID in NUMBER,
X_TRANSACTION_GROUP_SEQ in NUMBER,
X_REPRESENTATIVE_LOT_NUMBER in VARCHAR2,
X_TRANSACTION_BATCH_ID in NUMBER,
X_TRANSACTION_BATCH_SEQ in NUMBER,
X_REBUILD_ITEM_ID in NUMBER,
X_REBUILD_SERIAL_NUMBER in VARCHAR2,
X_REBUILD_ACTIVITY_ID in NUMBER,
X_REBUILD_JOB_NAME in VARCHAR2,
X_MOVE_TRANSACTION_ID in NUMBER,
X_COMPLETION_TRANSACTION_ID in NUMBER,
X_WIP_SUPPLY_TYPE in NUMBER,
X_XFER_LOC_SEGMENT6 in VARCHAR2,
X_XFER_LOC_SEGMENT7 in VARCHAR2,
X_XFER_LOC_SEGMENT8 in VARCHAR2,
X_XFER_LOC_SEGMENT9 in VARCHAR2,
X_XFER_LOC_SEGMENT10 in VARCHAR2,
X_XFER_LOC_SEGMENT11 in VARCHAR2,
X_XFER_LOC_SEGMENT12 in VARCHAR2,
X_XFER_LOC_SEGMENT13 in VARCHAR2,
X_XFER_LOC_SEGMENT14 in VARCHAR2,
X_XFER_LOC_SEGMENT15 in VARCHAR2,
X_XFER_LOC_SEGMENT16 in VARCHAR2,
X_XFER_LOC_SEGMENT17 in VARCHAR2,
X_XFER_LOC_SEGMENT18 in VARCHAR2,
X_XFER_LOC_SEGMENT19 in VARCHAR2,
X_XFER_LOC_SEGMENT20 in VARCHAR2,
X_SHIPMENT_NUMBER in VARCHAR2,
X_TRANSPORTATION_COST in NUMBER,
X_TRANSPORTATION_ACCOUNT in NUMBER,
X_TRANSFER_COST in NUMBER,
X_FREIGHT_CODE in VARCHAR2,
X_CONTAINERS in NUMBER,
X_WAYBILL_AIRBILL in VARCHAR2,
X_EXPECTED_ARRIVAL_DATE in DATE,
X_NEW_AVERAGE_COST in NUMBER,
X_VALUE_CHANGE in NUMBER,
X_PERCENTAGE_CHANGE in NUMBER,
X_DEMAND_SOURCE_HEADER_ID in NUMBER,
X_DEMAND_SOURCE_LINE in VARCHAR2,
X_DEMAND_SOURCE_DELIVERY in VARCHAR2,
X_NEGATIVE_REQ_FLAG in NUMBER,
X_ERROR_EXPLANATION in VARCHAR2,
X_SHIPPABLE_FLAG in VARCHAR2,
X_REQUIRED_FLAG in VARCHAR2,
X_ATTRIBUTE_CATEGORY in VARCHAR2,
X_ATTRIBUTE1 in VARCHAR2,
X_ATTRIBUTE2 in VARCHAR2,
X_ATTRIBUTE3 in VARCHAR2,
X_ATTRIBUTE4 in VARCHAR2,
X_ATTRIBUTE5 in VARCHAR2,
X_ATTRIBUTE6 in VARCHAR2,
X_ATTRIBUTE7 in VARCHAR2,
X_ATTRIBUTE8 in VARCHAR2,
X_ATTRIBUTE9 in VARCHAR2,
X_ATTRIBUTE10 in VARCHAR2,
X_ATTRIBUTE11 in VARCHAR2,
X_ATTRIBUTE12 in VARCHAR2,
X_ATTRIBUTE13 in VARCHAR2,
X_ATTRIBUTE14 in VARCHAR2,
X_ATTRIBUTE15 in VARCHAR2,
X_REQUISITION_DISTRIBUTION_ID in NUMBER,
X_MOVEMENT_ID in NUMBER,
X_RESERVATION_QUANTITY in NUMBER,
X_SHIPPED_QUANTITY in NUMBER,
X_INVENTORY_ITEM in VARCHAR2,
X_LOCATOR_NAME in VARCHAR2,
X_TASK_ID in NUMBER,
X_TO_TASK_ID in NUMBER,
X_SOURCE_TASK_ID in NUMBER,
X_PROJECT_ID in NUMBER,
X_TO_PROJECT_ID in NUMBER,
X_SOURCE_PROJECT_ID in NUMBER,
X_PA_EXPENDITURE_ORG_ID in NUMBER,
X_EXPENDITURE_TYPE in VARCHAR2,
X_FINAL_COMPLETION_FLAG in VARCHAR2,
X_TRANSFER_PERCENTAGE in NUMBER,
X_TRANSACTION_SEQUENCE_ID in NUMBER,
X_MATERIAL_ACCOUNT in NUMBER,
X_MATERIAL_OVERHEAD_ACCOUNT in NUMBER,
X_RESOURCE_ACCOUNT in NUMBER,
X_OUTSIDE_PROCESSING_ACCOUNT in NUMBER,
X_OVERHEAD_ACCOUNT in NUMBER,
X_BOM_REVISION in VARCHAR2,
X_ROUTING_REVISION in VARCHAR2,
X_BOM_REVISION_DATE in DATE,
X_ROUTING_REVISION_DATE in DATE,
X_ALTERNATE_BOM_DESIGNATOR in VARCHAR2,
X_ALTERNATE_ROUTING_DESIGNATOR in VARCHAR2,
X_ACCOUNTING_CLASS in VARCHAR2,
X_DEMAND_CLASS in VARCHAR2,
X_PARENT_ID in NUMBER,
X_SUBSTITUTION_TYPE_ID in NUMBER,
X_SUBSTITUTION_ITEM_ID in NUMBER,
X_SCHEDULE_GROUP in NUMBER,
X_BUILD_SEQUENCE in NUMBER,
X_SCHEDULE_NUMBER in VARCHAR2,
X_SCHEDULED_FLAG in NUMBER,
X_FLOW_SCHEDULE in VARCHAR2,
X_COST_GROUP_ID in NUMBER,
X_KANBAN_CARD_ID in NUMBER,
X_QA_COLLECTION_ID in NUMBER,
X_OVERCOMPLETION_TRANSACTION_Q in NUMBER,
X_OVERCOMPLETION_PRIMARY_QTY in NUMBER,
X_OVERCOMPLETION_TRANSACTION_I in NUMBER,
X_END_ITEM_UNIT_NUMBER in VARCHAR2,
X_SCHEDULED_PAYBACK_DATE in DATE,
X_ORG_COST_GROUP_ID in NUMBER,
X_COST_TYPE_ID in NUMBER,
X_SOURCE_LOT_NUMBER in VARCHAR2,
X_TRANSFER_COST_GROUP_ID in NUMBER,
X_LPN_ID in NUMBER,
X_TRANSFER_LPN_ID in NUMBER,
X_CONTENT_LPN_ID in NUMBER,
X_XML_DOCUMENT_ID in VARCHAR2,
X_ORGANIZATION_TYPE in NUMBER,
X_TRANSFER_ORGANIZATION_TYPE in NUMBER,
X_OWNING_ORGANIZATION_ID in NUMBER,
X_OWNING_TP_TYPE in NUMBER,
X_XFR_OWNING_ORGANIZATION_ID in NUMBER,
X_TRANSFER_OWNING_TP_TYPE in NUMBER,
X_LOC_SEGMENT12 in VARCHAR2,
X_LOC_SEGMENT13 in VARCHAR2,
X_LOC_SEGMENT14 in VARCHAR2,
X_LOC_SEGMENT15 in VARCHAR2,
X_LOC_SEGMENT16 in VARCHAR2,
X_LOC_SEGMENT17 in VARCHAR2,
X_LOC_SEGMENT18 in VARCHAR2,
X_LOC_SEGMENT19 in VARCHAR2,
X_LOC_SEGMENT20 in VARCHAR2,
X_TRANSACTION_SOURCE_ID in NUMBER,
X_DSP_SEGMENT1 in VARCHAR2,
X_DSP_SEGMENT2 in VARCHAR2,
X_DSP_SEGMENT3 in VARCHAR2,
X_DSP_SEGMENT4 in VARCHAR2,
X_DSP_SEGMENT5 in VARCHAR2,
X_DSP_SEGMENT6 in VARCHAR2,
X_DSP_SEGMENT7 in VARCHAR2,
X_DSP_SEGMENT8 in VARCHAR2,
X_DSP_SEGMENT9 in VARCHAR2,
X_DSP_SEGMENT10 in VARCHAR2,
X_DSP_SEGMENT11 in VARCHAR2,
X_DSP_SEGMENT12 in VARCHAR2,
X_DSP_SEGMENT13 in VARCHAR2,
X_DSP_SEGMENT14 in VARCHAR2,
X_DSP_SEGMENT15 in VARCHAR2,
X_DSP_SEGMENT16 in VARCHAR2,
X_DSP_SEGMENT17 in VARCHAR2,
X_DSP_SEGMENT18 in VARCHAR2,
X_DSP_SEGMENT19 in VARCHAR2,
X_DSP_SEGMENT20 in VARCHAR2,
X_DSP_SEGMENT21 in VARCHAR2,
X_DSP_SEGMENT22 in VARCHAR2,
X_DSP_SEGMENT23 in VARCHAR2,
X_DSP_SEGMENT24 in VARCHAR2,
X_DSP_SEGMENT25 in VARCHAR2,
X_DSP_SEGMENT26 in VARCHAR2,
X_DSP_SEGMENT27 in VARCHAR2,
X_DSP_SEGMENT28 in VARCHAR2,
X_DSP_SEGMENT29 in VARCHAR2,
X_DSP_SEGMENT30 in VARCHAR2,
X_TRANSACTION_SOURCE_NAME in VARCHAR2,
X_TRANSACTION_SOURCE_TYPE_ID in NUMBER,
X_TRANSACTION_ACTION_ID in NUMBER,
X_TRANSACTION_TYPE_ID in NUMBER,
X_REASON_ID in NUMBER,
X_TRANSACTION_REFERENCE in VARCHAR2,
X_TRANSACTION_COST in NUMBER,
X_DISTRIBUTION_ACCOUNT_ID in NUMBER,
X_DST_SEGMENT1 in VARCHAR2,
X_DST_SEGMENT2 in VARCHAR2,
X_DST_SEGMENT3 in VARCHAR2,
X_DST_SEGMENT4 in VARCHAR2,
X_DST_SEGMENT5 in VARCHAR2,
X_DST_SEGMENT6 in VARCHAR2,
X_DST_SEGMENT7 in VARCHAR2,
X_DST_SEGMENT8 in VARCHAR2,
X_DST_SEGMENT9 in VARCHAR2,
X_DST_SEGMENT10 in VARCHAR2,
X_DST_SEGMENT11 in VARCHAR2,
X_DST_SEGMENT12 in VARCHAR2,
X_DST_SEGMENT13 in VARCHAR2,
X_DST_SEGMENT14 in VARCHAR2,
X_DST_SEGMENT15 in VARCHAR2,
X_DST_SEGMENT16 in VARCHAR2,
X_DST_SEGMENT17 in VARCHAR2,
X_DST_SEGMENT18 in VARCHAR2,
X_DST_SEGMENT19 in VARCHAR2,
X_DST_SEGMENT20 in VARCHAR2,
X_DST_SEGMENT21 in VARCHAR2,
X_DST_SEGMENT22 in VARCHAR2,
X_DST_SEGMENT23 in VARCHAR2,
X_DST_SEGMENT24 in VARCHAR2,
X_DST_SEGMENT25 in VARCHAR2,
X_DST_SEGMENT26 in VARCHAR2,
X_DST_SEGMENT27 in VARCHAR2,
X_DST_SEGMENT28 in VARCHAR2,
X_DST_SEGMENT29 in VARCHAR2,
X_DST_SEGMENT30 in VARCHAR2,
X_REQUISITION_LINE_ID in NUMBER,
X_CURRENCY_CODE in VARCHAR2,
X_CURRENCY_CONVERSION_DATE in DATE,
X_CURRENCY_CONVERSION_TYPE in VARCHAR2,
X_CURRENCY_CONVERSION_RATE in NUMBER,
X_USSGL_TRANSACTION_CODE in VARCHAR2,
X_WIP_ENTITY_TYPE in NUMBER,
X_SCHEDULE_ID in NUMBER,
X_EMPLOYEE_CODE in VARCHAR2,
X_DEPARTMENT_ID in NUMBER,
X_SCHEDULE_UPDATE_CODE in NUMBER,
X_SETUP_TEARDOWN_CODE in NUMBER,
X_PRIMARY_SWITCH in NUMBER,
X_MRP_CODE in NUMBER,
X_OPERATION_SEQ_NUM in NUMBER,
X_REPETITIVE_LINE_ID in NUMBER,
X_PICKING_LINE_ID in NUMBER,
X_TRX_SOURCE_LINE_ID in NUMBER,
X_TRX_SOURCE_DELIVERY_ID in NUMBER,
X_DEMAND_ID in NUMBER,
X_CUSTOMER_SHIP_ID in NUMBER,
X_LINE_ITEM_NUM in NUMBER,
X_RECEIVING_DOCUMENT in VARCHAR2,
X_RCV_TRANSACTION_ID in NUMBER,
X_SHIP_TO_LOCATION_ID in NUMBER,
X_ENCUMBRANCE_ACCOUNT in NUMBER,
X_ENCUMBRANCE_AMOUNT in NUMBER,
X_VENDOR_LOT_NUMBER in VARCHAR2,
X_TRANSFER_SUBINVENTORY in VARCHAR2,
X_TRANSFER_ORGANIZATION in NUMBER,
X_TRANSFER_LOCATOR in NUMBER,
X_XFER_LOC_SEGMENT1 in VARCHAR2,
X_XFER_LOC_SEGMENT2 in VARCHAR2,
X_XFER_LOC_SEGMENT3 in VARCHAR2,
X_XFER_LOC_SEGMENT4 in VARCHAR2,
X_XFER_LOC_SEGMENT5 in VARCHAR2,
X_TRANSACTION_HEADER_ID in NUMBER,
X_SOURCE_CODE in VARCHAR2,
X_SOURCE_LINE_ID in NUMBER,
X_SOURCE_HEADER_ID in NUMBER,
X_PROCESS_FLAG in NUMBER,
X_VALIDATION_REQUIRED in NUMBER,
X_TRANSACTION_MODE in NUMBER,
X_LOCK_FLAG in NUMBER,
X_REQUEST_ID in NUMBER,
X_INVENTORY_ITEM_ID in NUMBER,
X_ITEM_SEGMENT1 in VARCHAR2,
X_ITEM_SEGMENT2 in VARCHAR2,
X_ITEM_SEGMENT3 in VARCHAR2,
X_ITEM_SEGMENT4 in VARCHAR2,
X_ITEM_SEGMENT5 in VARCHAR2,
X_ITEM_SEGMENT6 in VARCHAR2,
X_ITEM_SEGMENT7 in VARCHAR2,
X_ITEM_SEGMENT8 in VARCHAR2,
X_ITEM_SEGMENT9 in VARCHAR2,
X_ITEM_SEGMENT10 in VARCHAR2,
X_ITEM_SEGMENT11 in VARCHAR2,
X_ITEM_SEGMENT12 in VARCHAR2,
X_ITEM_SEGMENT13 in VARCHAR2,
X_ITEM_SEGMENT14 in VARCHAR2,
X_ITEM_SEGMENT15 in VARCHAR2,
X_ITEM_SEGMENT16 in VARCHAR2,
X_ITEM_SEGMENT17 in VARCHAR2,
X_ITEM_SEGMENT18 in VARCHAR2,
X_ITEM_SEGMENT19 in VARCHAR2,
X_ITEM_SEGMENT20 in VARCHAR2,
X_REVISION in VARCHAR2,
X_ORGANIZATION_ID in NUMBER,
X_TRANSACTION_QUANTITY in NUMBER,
X_PRIMARY_QUANTITY in NUMBER,
X_TRANSACTION_UOM in VARCHAR2,
X_TRANSACTION_DATE in DATE,
X_ACCT_PERIOD_ID in NUMBER,
X_SUBINVENTORY_CODE in VARCHAR2,
X_LOCATOR_ID in NUMBER,
X_LOC_SEGMENT1 in VARCHAR2,
X_LOC_SEGMENT2 in VARCHAR2,
X_LOC_SEGMENT3 in VARCHAR2,
X_LOC_SEGMENT4 in VARCHAR2,
X_LOC_SEGMENT5 in VARCHAR2,
X_LOC_SEGMENT6 in VARCHAR2,
X_LOC_SEGMENT7 in VARCHAR2,
X_LOC_SEGMENT8 in VARCHAR2,
X_LOC_SEGMENT9 in VARCHAR2,
X_LOC_SEGMENT10 in VARCHAR2,
X_LOC_SEGMENT11 in VARCHAR2,
X_ERROR_CODE in VARCHAR2,
X_LAST_UPDATE_DATE in DATE,
X_LAST_UPDATED_BY in NUMBER,
X_LAST_UPDATE_LOGIN in NUMBER
) IS
l_item_id NUMBER := NULL;
update MTL_TRANSACTIONS_INTERFACE set
PLANNING_ORGANIZATION_ID = X_PLANNING_ORGANIZATION_ID,
PLANNING_TP_TYPE = X_PLANNING_TP_TYPE,
XFR_PLANNING_ORGANIZATION_ID = X_XFR_PLANNING_ORGANIZATION_ID,
TRANSFER_PLANNING_TP_TYPE = X_TRANSFER_PLANNING_TP_TYPE,
SECONDARY_UOM_CODE = X_SECONDARY_UOM_CODE,
SECONDARY_TRANSACTION_QUANTITY = X_SECONDARY_TRANSACTION_QUANTI,
--TRANSACTION_GROUP_ID = X_TRANSACTION_GROUP_ID,
--TRANSACTION_GROUP_SEQ = X_TRANSACTION_GROUP_SEQ,
REPRESENTATIVE_LOT_NUMBER = X_REPRESENTATIVE_LOT_NUMBER,
TRANSACTION_BATCH_ID = X_TRANSACTION_BATCH_ID,
TRANSACTION_BATCH_SEQ = X_TRANSACTION_BATCH_SEQ,
REBUILD_ITEM_ID = X_REBUILD_ITEM_ID,
REBUILD_SERIAL_NUMBER = X_REBUILD_SERIAL_NUMBER,
REBUILD_ACTIVITY_ID = X_REBUILD_ACTIVITY_ID,
REBUILD_JOB_NAME = X_REBUILD_JOB_NAME,
MOVE_TRANSACTION_ID = X_MOVE_TRANSACTION_ID,
COMPLETION_TRANSACTION_ID = X_COMPLETION_TRANSACTION_ID,
WIP_SUPPLY_TYPE = X_WIP_SUPPLY_TYPE,
XFER_LOC_SEGMENT6 = X_XFER_LOC_SEGMENT6,
XFER_LOC_SEGMENT7 = X_XFER_LOC_SEGMENT7,
XFER_LOC_SEGMENT8 = X_XFER_LOC_SEGMENT8,
XFER_LOC_SEGMENT9 = X_XFER_LOC_SEGMENT9,
XFER_LOC_SEGMENT10 = X_XFER_LOC_SEGMENT10,
XFER_LOC_SEGMENT11 = X_XFER_LOC_SEGMENT11,
XFER_LOC_SEGMENT12 = X_XFER_LOC_SEGMENT12,
XFER_LOC_SEGMENT13 = X_XFER_LOC_SEGMENT13,
XFER_LOC_SEGMENT14 = X_XFER_LOC_SEGMENT14,
XFER_LOC_SEGMENT15 = X_XFER_LOC_SEGMENT15,
XFER_LOC_SEGMENT16 = X_XFER_LOC_SEGMENT16,
XFER_LOC_SEGMENT17 = X_XFER_LOC_SEGMENT17,
XFER_LOC_SEGMENT18 = X_XFER_LOC_SEGMENT18,
XFER_LOC_SEGMENT19 = X_XFER_LOC_SEGMENT19,
XFER_LOC_SEGMENT20 = X_XFER_LOC_SEGMENT20,
SHIPMENT_NUMBER = X_SHIPMENT_NUMBER,
TRANSPORTATION_COST = X_TRANSPORTATION_COST,
TRANSPORTATION_ACCOUNT = X_TRANSPORTATION_ACCOUNT,
TRANSFER_COST = X_TRANSFER_COST,
FREIGHT_CODE = X_FREIGHT_CODE,
CONTAINERS = X_CONTAINERS,
WAYBILL_AIRBILL = X_WAYBILL_AIRBILL,
EXPECTED_ARRIVAL_DATE = X_EXPECTED_ARRIVAL_DATE,
NEW_AVERAGE_COST = X_NEW_AVERAGE_COST,
VALUE_CHANGE = X_VALUE_CHANGE,
PERCENTAGE_CHANGE = X_PERCENTAGE_CHANGE,
DEMAND_SOURCE_HEADER_ID = X_DEMAND_SOURCE_HEADER_ID,
DEMAND_SOURCE_LINE = X_DEMAND_SOURCE_LINE,
DEMAND_SOURCE_DELIVERY = X_DEMAND_SOURCE_DELIVERY,
NEGATIVE_REQ_FLAG = X_NEGATIVE_REQ_FLAG,
ERROR_EXPLANATION = X_ERROR_EXPLANATION,
SHIPPABLE_FLAG = X_SHIPPABLE_FLAG,
REQUIRED_FLAG = X_REQUIRED_FLAG,
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,
REQUISITION_DISTRIBUTION_ID = X_REQUISITION_DISTRIBUTION_ID,
MOVEMENT_ID = X_MOVEMENT_ID,
RESERVATION_QUANTITY = X_RESERVATION_QUANTITY,
SHIPPED_QUANTITY = X_SHIPPED_QUANTITY,
INVENTORY_ITEM = X_INVENTORY_ITEM,
LOCATOR_NAME = X_LOCATOR_NAME,
TASK_ID = X_TASK_ID,
TO_TASK_ID = X_TO_TASK_ID,
SOURCE_TASK_ID = X_SOURCE_TASK_ID,
PROJECT_ID = X_PROJECT_ID,
TO_PROJECT_ID = X_TO_PROJECT_ID,
SOURCE_PROJECT_ID = X_SOURCE_PROJECT_ID,
PA_EXPENDITURE_ORG_ID = X_PA_EXPENDITURE_ORG_ID,
EXPENDITURE_TYPE = X_EXPENDITURE_TYPE,
FINAL_COMPLETION_FLAG = X_FINAL_COMPLETION_FLAG,
TRANSFER_PERCENTAGE = X_TRANSFER_PERCENTAGE,
TRANSACTION_SEQUENCE_ID = X_TRANSACTION_SEQUENCE_ID,
MATERIAL_ACCOUNT = X_MATERIAL_ACCOUNT,
MATERIAL_OVERHEAD_ACCOUNT = X_MATERIAL_OVERHEAD_ACCOUNT,
RESOURCE_ACCOUNT = X_RESOURCE_ACCOUNT,
OUTSIDE_PROCESSING_ACCOUNT = X_OUTSIDE_PROCESSING_ACCOUNT,
OVERHEAD_ACCOUNT = X_OVERHEAD_ACCOUNT,
BOM_REVISION = X_BOM_REVISION,
ROUTING_REVISION = X_ROUTING_REVISION,
BOM_REVISION_DATE = X_BOM_REVISION_DATE,
ROUTING_REVISION_DATE = X_ROUTING_REVISION_DATE,
ALTERNATE_BOM_DESIGNATOR = X_ALTERNATE_BOM_DESIGNATOR,
ALTERNATE_ROUTING_DESIGNATOR = X_ALTERNATE_ROUTING_DESIGNATOR,
ACCOUNTING_CLASS = X_ACCOUNTING_CLASS,
DEMAND_CLASS = X_DEMAND_CLASS,
PARENT_ID = X_PARENT_ID,
SUBSTITUTION_TYPE_ID = X_SUBSTITUTION_TYPE_ID,
SUBSTITUTION_ITEM_ID = X_SUBSTITUTION_ITEM_ID,
SCHEDULE_GROUP = X_SCHEDULE_GROUP,
BUILD_SEQUENCE = X_BUILD_SEQUENCE,
SCHEDULE_NUMBER = X_SCHEDULE_NUMBER,
SCHEDULED_FLAG = X_SCHEDULED_FLAG,
FLOW_SCHEDULE = X_FLOW_SCHEDULE,
COST_GROUP_ID = X_COST_GROUP_ID,
KANBAN_CARD_ID = X_KANBAN_CARD_ID,
QA_COLLECTION_ID = X_QA_COLLECTION_ID,
OVERCOMPLETION_TRANSACTION_QTY = X_OVERCOMPLETION_TRANSACTION_Q,
OVERCOMPLETION_PRIMARY_QTY = X_OVERCOMPLETION_PRIMARY_QTY,
OVERCOMPLETION_TRANSACTION_ID = X_OVERCOMPLETION_TRANSACTION_I,
END_ITEM_UNIT_NUMBER = X_END_ITEM_UNIT_NUMBER,
SCHEDULED_PAYBACK_DATE = X_SCHEDULED_PAYBACK_DATE,
ORG_COST_GROUP_ID = X_ORG_COST_GROUP_ID,
COST_TYPE_ID = X_COST_TYPE_ID,
SOURCE_LOT_NUMBER = X_SOURCE_LOT_NUMBER,
TRANSFER_COST_GROUP_ID = X_TRANSFER_COST_GROUP_ID,
LPN_ID = X_LPN_ID,
TRANSFER_LPN_ID = X_TRANSFER_LPN_ID,
CONTENT_LPN_ID = X_CONTENT_LPN_ID,
XML_DOCUMENT_ID = X_XML_DOCUMENT_ID,
ORGANIZATION_TYPE = X_ORGANIZATION_TYPE,
TRANSFER_ORGANIZATION_TYPE = X_TRANSFER_ORGANIZATION_TYPE,
OWNING_ORGANIZATION_ID = X_OWNING_ORGANIZATION_ID,
OWNING_TP_TYPE = X_OWNING_TP_TYPE,
XFR_OWNING_ORGANIZATION_ID = X_XFR_OWNING_ORGANIZATION_ID,
TRANSFER_OWNING_TP_TYPE = X_TRANSFER_OWNING_TP_TYPE,
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,
TRANSACTION_SOURCE_ID = X_TRANSACTION_SOURCE_ID,
DSP_SEGMENT1 = X_DSP_SEGMENT1,
DSP_SEGMENT2 = X_DSP_SEGMENT2,
DSP_SEGMENT3 = X_DSP_SEGMENT3,
DSP_SEGMENT4 = X_DSP_SEGMENT4,
DSP_SEGMENT5 = X_DSP_SEGMENT5,
DSP_SEGMENT6 = X_DSP_SEGMENT6,
DSP_SEGMENT7 = X_DSP_SEGMENT7,
DSP_SEGMENT8 = X_DSP_SEGMENT8,
DSP_SEGMENT9 = X_DSP_SEGMENT9,
DSP_SEGMENT10 = X_DSP_SEGMENT10,
DSP_SEGMENT11 = X_DSP_SEGMENT11,
DSP_SEGMENT12 = X_DSP_SEGMENT12,
DSP_SEGMENT13 = X_DSP_SEGMENT13,
DSP_SEGMENT14 = X_DSP_SEGMENT14,
DSP_SEGMENT15 = X_DSP_SEGMENT15,
DSP_SEGMENT16 = X_DSP_SEGMENT16,
DSP_SEGMENT17 = X_DSP_SEGMENT17,
DSP_SEGMENT18 = X_DSP_SEGMENT18,
DSP_SEGMENT19 = X_DSP_SEGMENT19,
DSP_SEGMENT20 = X_DSP_SEGMENT20,
DSP_SEGMENT21 = X_DSP_SEGMENT21,
DSP_SEGMENT22 = X_DSP_SEGMENT22,
DSP_SEGMENT23 = X_DSP_SEGMENT23,
DSP_SEGMENT24 = X_DSP_SEGMENT24,
DSP_SEGMENT25 = X_DSP_SEGMENT25,
DSP_SEGMENT26 = X_DSP_SEGMENT26,
DSP_SEGMENT27 = X_DSP_SEGMENT27,
DSP_SEGMENT28 = X_DSP_SEGMENT28,
DSP_SEGMENT29 = X_DSP_SEGMENT29,
DSP_SEGMENT30 = X_DSP_SEGMENT30,
TRANSACTION_SOURCE_NAME = X_TRANSACTION_SOURCE_NAME,
TRANSACTION_SOURCE_TYPE_ID = X_TRANSACTION_SOURCE_TYPE_ID,
TRANSACTION_ACTION_ID = X_TRANSACTION_ACTION_ID,
TRANSACTION_TYPE_ID = X_TRANSACTION_TYPE_ID,
REASON_ID = X_REASON_ID,
TRANSACTION_REFERENCE = X_TRANSACTION_REFERENCE,
TRANSACTION_COST = X_TRANSACTION_COST,
DISTRIBUTION_ACCOUNT_ID = X_DISTRIBUTION_ACCOUNT_ID,
DST_SEGMENT1 = X_DST_SEGMENT1,
DST_SEGMENT2 = X_DST_SEGMENT2,
DST_SEGMENT3 = X_DST_SEGMENT3,
DST_SEGMENT4 = X_DST_SEGMENT4,
DST_SEGMENT5 = X_DST_SEGMENT5,
DST_SEGMENT6 = X_DST_SEGMENT6,
DST_SEGMENT7 = X_DST_SEGMENT7,
DST_SEGMENT8 = X_DST_SEGMENT8,
DST_SEGMENT9 = X_DST_SEGMENT9,
DST_SEGMENT10 = X_DST_SEGMENT10,
DST_SEGMENT11 = X_DST_SEGMENT11,
DST_SEGMENT12 = X_DST_SEGMENT12,
DST_SEGMENT13 = X_DST_SEGMENT13,
DST_SEGMENT14 = X_DST_SEGMENT14,
DST_SEGMENT15 = X_DST_SEGMENT15,
DST_SEGMENT16 = X_DST_SEGMENT16,
DST_SEGMENT17 = X_DST_SEGMENT17,
DST_SEGMENT18 = X_DST_SEGMENT18,
DST_SEGMENT19 = X_DST_SEGMENT19,
DST_SEGMENT20 = X_DST_SEGMENT20,
DST_SEGMENT21 = X_DST_SEGMENT21,
DST_SEGMENT22 = X_DST_SEGMENT22,
DST_SEGMENT23 = X_DST_SEGMENT23,
DST_SEGMENT24 = X_DST_SEGMENT24,
DST_SEGMENT25 = X_DST_SEGMENT25,
DST_SEGMENT26 = X_DST_SEGMENT26,
DST_SEGMENT27 = X_DST_SEGMENT27,
DST_SEGMENT28 = X_DST_SEGMENT28,
DST_SEGMENT29 = X_DST_SEGMENT29,
DST_SEGMENT30 = X_DST_SEGMENT30,
REQUISITION_LINE_ID = X_REQUISITION_LINE_ID,
CURRENCY_CODE = X_CURRENCY_CODE,
CURRENCY_CONVERSION_DATE = X_CURRENCY_CONVERSION_DATE,
CURRENCY_CONVERSION_TYPE = X_CURRENCY_CONVERSION_TYPE,
CURRENCY_CONVERSION_RATE = X_CURRENCY_CONVERSION_RATE,
USSGL_TRANSACTION_CODE = X_USSGL_TRANSACTION_CODE,
WIP_ENTITY_TYPE = X_WIP_ENTITY_TYPE,
SCHEDULE_ID = X_SCHEDULE_ID,
EMPLOYEE_CODE = X_EMPLOYEE_CODE,
DEPARTMENT_ID = X_DEPARTMENT_ID,
SCHEDULE_UPDATE_CODE = X_SCHEDULE_UPDATE_CODE,
SETUP_TEARDOWN_CODE = X_SETUP_TEARDOWN_CODE,
PRIMARY_SWITCH = X_PRIMARY_SWITCH,
MRP_CODE = X_MRP_CODE,
OPERATION_SEQ_NUM = X_OPERATION_SEQ_NUM,
REPETITIVE_LINE_ID = X_REPETITIVE_LINE_ID,
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,
DEMAND_ID = X_DEMAND_ID,
CUSTOMER_SHIP_ID = X_CUSTOMER_SHIP_ID,
LINE_ITEM_NUM = X_LINE_ITEM_NUM,
RECEIVING_DOCUMENT = X_RECEIVING_DOCUMENT,
RCV_TRANSACTION_ID = X_RCV_TRANSACTION_ID,
SHIP_TO_LOCATION_ID = X_SHIP_TO_LOCATION_ID,
ENCUMBRANCE_ACCOUNT = X_ENCUMBRANCE_ACCOUNT,
ENCUMBRANCE_AMOUNT = X_ENCUMBRANCE_AMOUNT,
VENDOR_LOT_NUMBER = X_VENDOR_LOT_NUMBER,
TRANSFER_SUBINVENTORY = X_TRANSFER_SUBINVENTORY,
TRANSFER_ORGANIZATION = X_TRANSFER_ORGANIZATION,
TRANSFER_LOCATOR = X_TRANSFER_LOCATOR,
XFER_LOC_SEGMENT1 = X_XFER_LOC_SEGMENT1,
XFER_LOC_SEGMENT2 = X_XFER_LOC_SEGMENT2,
XFER_LOC_SEGMENT3 = X_XFER_LOC_SEGMENT3,
XFER_LOC_SEGMENT4 = X_XFER_LOC_SEGMENT4,
XFER_LOC_SEGMENT5 = X_XFER_LOC_SEGMENT5,
TRANSACTION_HEADER_ID = X_TRANSACTION_HEADER_ID,
SOURCE_CODE = X_SOURCE_CODE,
SOURCE_LINE_ID = X_SOURCE_LINE_ID,
SOURCE_HEADER_ID = X_SOURCE_HEADER_ID,
PROCESS_FLAG = X_PROCESS_FLAG,
VALIDATION_REQUIRED = X_VALIDATION_REQUIRED,
TRANSACTION_MODE = X_TRANSACTION_MODE,
LOCK_FLAG = X_LOCK_FLAG,
REQUEST_ID = X_REQUEST_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,
REVISION = X_REVISION,
ORGANIZATION_ID = X_ORGANIZATION_ID,
TRANSACTION_QUANTITY = X_TRANSACTION_QUANTITY,
PRIMARY_QUANTITY = X_PRIMARY_QUANTITY,
TRANSACTION_UOM = X_TRANSACTION_UOM,
TRANSACTION_DATE = X_TRANSACTION_DATE,
ACCT_PERIOD_ID = X_ACCT_PERIOD_ID,
SUBINVENTORY_CODE = X_SUBINVENTORY_CODE,
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,
LAST_UPDATE_DATE = sysdate,
LAST_UPDATED_BY = fnd_global.user_id,
LAST_UPDATE_LOGIN = fnd_global.login_id
where TRANSACTION_INTERFACE_ID = x_transaction_interface_id
returning inventory_item_id INTO l_item_id;
insert_row
(l_rowid,
x_transaction_interface_id,
x_planning_organization_id,
x_planning_tp_type,
x_xfr_planning_organization_id,
x_transfer_planning_tp_type,
x_secondary_uom_code,
x_secondary_transaction_quanti,
x_transaction_group_id,
x_transaction_group_seq,
x_representative_lot_number,
x_transaction_batch_id,
x_transaction_batch_seq,
x_rebuild_item_id,
x_rebuild_serial_number,
x_rebuild_activity_id,
x_rebuild_job_name,
x_move_transaction_id,
x_completion_transaction_id,
x_wip_supply_type,
x_xfer_loc_segment6,
x_xfer_loc_segment7,
x_xfer_loc_segment8,
x_xfer_loc_segment9,
x_xfer_loc_segment10,
x_xfer_loc_segment11,
x_xfer_loc_segment12,
x_xfer_loc_segment13,
x_xfer_loc_segment14,
x_xfer_loc_segment15,
x_xfer_loc_segment16,
x_xfer_loc_segment17,
x_xfer_loc_segment18,
x_xfer_loc_segment19,
x_xfer_loc_segment20,
x_shipment_number,
x_transportation_cost,
x_transportation_account,
x_transfer_cost,
x_freight_code,
x_containers,
x_waybill_airbill,
x_expected_arrival_date,
x_new_average_cost,
x_value_change,
x_percentage_change,
x_demand_source_header_id,
x_demand_source_line,
x_demand_source_delivery,
x_negative_req_flag,
x_error_explanation,
x_shippable_flag,
x_required_flag,
x_attribute_category,
x_attribute1,
x_attribute2,
x_attribute3,
x_attribute4,
x_attribute5,
x_attribute6,
x_attribute7,
x_attribute8,
x_attribute9,
x_attribute10,
x_attribute11,
x_attribute12,
x_attribute13,
x_attribute14,
x_attribute15,
x_requisition_distribution_id,
x_movement_id,
x_reservation_quantity,
x_shipped_quantity,
x_inventory_item,
x_locator_name,
x_task_id,
x_to_task_id,
x_source_task_id,
x_project_id,
x_to_project_id,
x_source_project_id,
x_pa_expenditure_org_id,
x_expenditure_type,
x_final_completion_flag,
x_transfer_percentage,
x_transaction_sequence_id,
x_material_account,
x_material_overhead_account,
x_resource_account,
x_outside_processing_account,
x_overhead_account,
x_bom_revision,
x_routing_revision,
x_bom_revision_date,
x_routing_revision_date,
x_alternate_bom_designator,
x_alternate_routing_designator,
x_accounting_class,
x_demand_class,
x_parent_id,
x_substitution_type_id,
x_substitution_item_id,
x_schedule_group,
x_build_sequence,
x_schedule_number,
x_scheduled_flag,
x_flow_schedule,
x_cost_group_id,
x_kanban_card_id,
x_qa_collection_id,
x_overcompletion_transaction_q,
x_overcompletion_primary_qty,
x_overcompletion_transaction_i,
x_end_item_unit_number,
x_scheduled_payback_date,
x_org_cost_group_id,
x_cost_type_id,
x_source_lot_number,
x_transfer_cost_group_id,
x_lpn_id,
x_transfer_lpn_id,
x_content_lpn_id,
x_xml_document_id,
x_organization_type,
x_transfer_organization_type,
x_owning_organization_id,
x_owning_tp_type,
x_xfr_owning_organization_id,
x_transfer_owning_tp_type,
x_loc_segment12,
x_loc_segment13,
x_loc_segment14,
x_loc_segment15,
x_loc_segment16,
x_loc_segment17,
x_loc_segment18,
x_loc_segment19,
x_loc_segment20,
x_transaction_source_id,
x_dsp_segment1,
x_dsp_segment2,
x_dsp_segment3,
x_dsp_segment4,
x_dsp_segment5,
x_dsp_segment6,
x_dsp_segment7,
x_dsp_segment8,
x_dsp_segment9,
x_dsp_segment10,
x_dsp_segment11,
x_dsp_segment12,
x_dsp_segment13,
x_dsp_segment14,
x_dsp_segment15,
x_dsp_segment16,
x_dsp_segment17,
x_dsp_segment18,
x_dsp_segment19,
x_dsp_segment20,
x_dsp_segment21,
x_dsp_segment22,
x_dsp_segment23,
x_dsp_segment24,
x_dsp_segment25,
x_dsp_segment26,
x_dsp_segment27,
x_dsp_segment28,
x_dsp_segment29,
x_dsp_segment30,
x_transaction_source_name,
x_transaction_source_type_id,
x_transaction_action_id,
x_transaction_type_id,
x_reason_id,
x_transaction_reference,
x_transaction_cost,
x_distribution_account_id,
x_dst_segment1,
x_dst_segment2,
x_dst_segment3,
x_dst_segment4,
x_dst_segment5,
x_dst_segment6,
x_dst_segment7,
x_dst_segment8,
x_dst_segment9,
x_dst_segment10,
x_dst_segment11,
x_dst_segment12,
x_dst_segment13,
x_dst_segment14,
x_dst_segment15,
x_dst_segment16,
x_dst_segment17,
x_dst_segment18,
x_dst_segment19,
x_dst_segment20,
x_dst_segment21,
x_dst_segment22,
x_dst_segment23,
x_dst_segment24,
x_dst_segment25,
x_dst_segment26,
x_dst_segment27,
x_dst_segment28,
x_dst_segment29,
x_dst_segment30,
x_requisition_line_id,
x_currency_code,
x_currency_conversion_date,
x_currency_conversion_type,
x_currency_conversion_rate,
x_ussgl_transaction_code,
x_wip_entity_type,
x_schedule_id,
x_employee_code,
x_department_id,
x_schedule_update_code,
x_setup_teardown_code,
x_primary_switch,
x_mrp_code,
x_operation_seq_num,
x_repetitive_line_id,
x_picking_line_id,
x_trx_source_line_id,
x_trx_source_delivery_id,
x_demand_id,
x_customer_ship_id,
x_line_item_num,
x_receiving_document,
x_rcv_transaction_id,
x_ship_to_location_id,
x_encumbrance_account,
x_encumbrance_amount,
x_vendor_lot_number,
x_transfer_subinventory,
x_transfer_organization,
x_transfer_locator,
x_xfer_loc_segment1,
x_xfer_loc_segment2,
x_xfer_loc_segment3,
x_xfer_loc_segment4,
x_xfer_loc_segment5,
x_transaction_header_id,
x_source_code,
x_source_line_id,
x_source_header_id,
x_process_flag,
x_validation_required,
x_transaction_mode,
x_lock_flag,
x_request_id,
x_inventory_item_id,
x_item_segment1,
x_item_segment2,
x_item_segment3,
x_item_segment4,
x_item_segment5,
x_item_segment6,
x_item_segment7,
x_item_segment8,
x_item_segment9,
x_item_segment10,
x_item_segment11,
x_item_segment12,
x_item_segment13,
x_item_segment14,
x_item_segment15,
x_item_segment16,
x_item_segment17,
x_item_segment18,
x_item_segment19,
x_item_segment20,
x_revision,
x_organization_id,
x_transaction_quantity,
x_primary_quantity,
x_transaction_uom,
x_transaction_date,
x_acct_period_id,
x_subinventory_code,
x_locator_id,
x_loc_segment1,
x_loc_segment2,
x_loc_segment3,
x_loc_segment4,
x_loc_segment5,
x_loc_segment6,
x_loc_segment7,
x_loc_segment8,
x_loc_segment9,
x_loc_segment10,
x_loc_segment11,
x_error_code,
sysdate,
fnd_global.user_id,
sysdate,
fnd_global.user_id,
fnd_global.login_id
);
end UPDATE_ROW;
procedure DELETE_ROW (
X_TRANSACTION_INTERFACE_ID in NUMBER
) is
begin
delete from MTL_TRANSACTIONS_INTERFACE
where TRANSACTION_INTERFACE_ID = X_TRANSACTION_INTERFACE_ID;
end DELETE_ROW;