[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Row(
p_TRANSACTION_HEADER_ID NUMBER,
px_TRANSACTION_TEMP_ID IN OUT NOCOPY NUMBER,
p_SOURCE_CODE VARCHAR2,
p_SOURCE_LINE_ID NUMBER,
p_TRANSACTION_MODE NUMBER,
p_LOCK_FLAG VARCHAR2,
p_LAST_UPDATE_DATE DATE,
p_LAST_UPDATED_BY NUMBER,
p_CREATION_DATE DATE,
p_CREATED_BY NUMBER,
p_LAST_UPDATE_LOGIN NUMBER,
p_REQUEST_ID NUMBER,
p_PROGRAM_APPLICATION_ID NUMBER,
p_PROGRAM_ID NUMBER,
p_PROGRAM_UPDATE_DATE DATE,
p_INVENTORY_ITEM_ID NUMBER,
p_REVISION VARCHAR2,
p_ORGANIZATION_ID NUMBER,
p_SUBINVENTORY_CODE VARCHAR2,
p_LOCATOR_ID NUMBER,
p_TRANSACTION_QUANTITY NUMBER,
p_PRIMARY_QUANTITY NUMBER,
p_TRANSACTION_UOM VARCHAR2,
p_TRANSACTION_COST NUMBER,
p_TRANSACTION_TYPE_ID NUMBER,
p_TRANSACTION_ACTION_ID NUMBER,
p_TRANSACTION_SOURCE_TYPE_ID NUMBER,
p_TRANSACTION_SOURCE_ID NUMBER,
p_TRANSACTION_SOURCE_NAME VARCHAR2,
p_TRANSACTION_DATE DATE,
p_ACCT_PERIOD_ID NUMBER,
p_DISTRIBUTION_ACCOUNT_ID NUMBER,
p_TRANSACTION_REFERENCE VARCHAR2,
p_REQUISITION_LINE_ID NUMBER,
p_REQUISITION_DISTRIBUTION_ID NUMBER,
p_REASON_ID NUMBER,
p_LOT_NUMBER VARCHAR2,
p_LOT_EXPIRATION_DATE DATE,
p_SERIAL_NUMBER VARCHAR2,
p_RECEIVING_DOCUMENT VARCHAR2,
p_DEMAND_ID NUMBER,
p_RCV_TRANSACTION_ID NUMBER,
p_MOVE_TRANSACTION_ID NUMBER,
p_COMPLETION_TRANSACTION_ID NUMBER,
p_WIP_ENTITY_TYPE NUMBER,
p_SCHEDULE_ID NUMBER,
p_REPETITIVE_LINE_ID NUMBER,
p_EMPLOYEE_CODE VARCHAR2,
p_PRIMARY_SWITCH NUMBER,
p_SCHEDULE_UPDATE_CODE NUMBER,
p_SETUP_TEARDOWN_CODE NUMBER,
p_ITEM_ORDERING NUMBER,
p_NEGATIVE_REQ_FLAG NUMBER,
p_OPERATION_SEQ_NUM NUMBER,
p_PICKING_LINE_ID NUMBER,
p_TRX_SOURCE_LINE_ID NUMBER,
p_TRX_SOURCE_DELIVERY_ID NUMBER,
p_PHYSICAL_ADJUSTMENT_ID NUMBER,
p_CYCLE_COUNT_ID NUMBER,
p_RMA_LINE_ID NUMBER,
p_CUSTOMER_SHIP_ID NUMBER,
p_CURRENCY_CODE VARCHAR2,
p_CURRENCY_CONVERSION_RATE NUMBER,
p_CURRENCY_CONVERSION_TYPE VARCHAR2,
p_CURRENCY_CONVERSION_DATE DATE,
p_USSGL_TRANSACTION_CODE VARCHAR2,
p_VENDOR_LOT_NUMBER VARCHAR2,
p_ENCUMBRANCE_ACCOUNT NUMBER,
p_ENCUMBRANCE_AMOUNT NUMBER,
p_SHIP_TO_LOCATION NUMBER,
p_SHIPMENT_NUMBER VARCHAR2,
p_TRANSFER_COST NUMBER,
p_TRANSPORTATION_COST NUMBER,
p_TRANSPORTATION_ACCOUNT NUMBER,
p_FREIGHT_CODE VARCHAR2,
p_CONTAINERS NUMBER,
p_WAYBILL_AIRBILL VARCHAR2,
p_EXPECTED_ARRIVAL_DATE DATE,
p_TRANSFER_SUBINVENTORY VARCHAR2,
p_TRANSFER_ORGANIZATION NUMBER,
p_TRANSFER_TO_LOCATION NUMBER,
p_NEW_AVERAGE_COST NUMBER,
p_VALUE_CHANGE NUMBER,
p_PERCENTAGE_CHANGE NUMBER,
p_MATERIAL_ALLOCATION_TEMP_ID NUMBER,
p_DEMAND_SOURCE_HEADER_ID NUMBER,
p_DEMAND_SOURCE_LINE VARCHAR2,
p_DEMAND_SOURCE_DELIVERY VARCHAR2,
p_ITEM_SEGMENTS VARCHAR2,
p_ITEM_DESCRIPTION VARCHAR2,
p_ITEM_TRX_ENABLED_FLAG VARCHAR2,
p_ITEM_LOCATION_CONTROL_CODE NUMBER,
p_ITEM_RESTRICT_SUBINV_CODE NUMBER,
p_ITEM_RESTRICT_LOCATORS_CODE NUMBER,
p_ITEM_REV_QTY_CONTROL_CODE NUMBER,
p_ITEM_PRIMARY_UOM_CODE VARCHAR2,
p_ITEM_UOM_CLASS VARCHAR2,
p_ITEM_SHELF_LIFE_CODE NUMBER,
p_ITEM_SHELF_LIFE_DAYS NUMBER,
p_ITEM_LOT_CONTROL_CODE NUMBER,
p_ITEM_SERIAL_CONTROL_CODE NUMBER,
p_ITEM_INVENTORY_ASSET_FLAG VARCHAR2,
p_ALLOWED_UNITS_LOOKUP_CODE NUMBER,
p_DEPARTMENT_ID NUMBER,
p_DEPARTMENT_CODE VARCHAR2,
p_WIP_SUPPLY_TYPE NUMBER,
p_SUPPLY_SUBINVENTORY VARCHAR2,
p_SUPPLY_LOCATOR_ID NUMBER,
p_VALID_SUBINVENTORY_FLAG VARCHAR2,
p_VALID_LOCATOR_FLAG VARCHAR2,
p_LOCATOR_SEGMENTS VARCHAR2,
p_CURRENT_LOCATOR_CONTROL_CODE NUMBER,
p_NUMBER_OF_LOTS_ENTERED NUMBER,
p_WIP_COMMIT_FLAG VARCHAR2,
p_NEXT_LOT_NUMBER VARCHAR2,
p_LOT_ALPHA_PREFIX VARCHAR2,
p_NEXT_SERIAL_NUMBER VARCHAR2,
p_SERIAL_ALPHA_PREFIX VARCHAR2,
p_SHIPPABLE_FLAG VARCHAR2,
p_POSTING_FLAG VARCHAR2,
p_REQUIRED_FLAG VARCHAR2,
p_PROCESS_FLAG VARCHAR2,
p_ERROR_CODE VARCHAR2,
p_ERROR_EXPLANATION VARCHAR2,
p_ATTRIBUTE_CATEGORY 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_MOVEMENT_ID NUMBER,
p_RESERVATION_QUANTITY NUMBER,
p_SHIPPED_QUANTITY NUMBER,
p_TRANSACTION_LINE_NUMBER NUMBER,
p_TASK_ID NUMBER,
p_TO_TASK_ID NUMBER,
p_SOURCE_TASK_ID NUMBER,
p_PROJECT_ID NUMBER,
p_SOURCE_PROJECT_ID NUMBER,
p_PA_EXPENDITURE_ORG_ID NUMBER,
p_TO_PROJECT_ID NUMBER,
p_EXPENDITURE_TYPE VARCHAR2,
p_FINAL_COMPLETION_FLAG VARCHAR2,
p_TRANSFER_PERCENTAGE NUMBER,
p_TRANSACTION_SEQUENCE_ID NUMBER,
p_MATERIAL_ACCOUNT NUMBER,
p_MATERIAL_OVERHEAD_ACCOUNT NUMBER,
p_RESOURCE_ACCOUNT NUMBER,
p_OUTSIDE_PROCESSING_ACCOUNT NUMBER,
p_OVERHEAD_ACCOUNT NUMBER,
p_FLOW_SCHEDULE VARCHAR2,
p_COST_GROUP_ID NUMBER,
p_DEMAND_CLASS VARCHAR2,
p_QA_COLLECTION_ID NUMBER,
p_KANBAN_CARD_ID NUMBER,
p_OVERCOMPLETION_TXN_ID NUMBER,
p_OVERCOMPLETION_PRIMARY_QTY NUMBER,
p_OVERCOMPLETION_TXN_QTY NUMBER,
--p_PROCESS_TYPE NUMBER,
p_END_ITEM_UNIT_NUMBER VARCHAR2,
p_SCHEDULED_PAYBACK_DATE DATE,
p_LINE_TYPE_CODE NUMBER,
p_PARENT_TRANSACTION_TEMP_ID NUMBER,
p_PUT_AWAY_STRATEGY_ID NUMBER,
p_PUT_AWAY_RULE_ID NUMBER,
p_PICK_STRATEGY_ID NUMBER,
p_PICK_RULE_ID NUMBER,
p_COMMON_BOM_SEQ_ID NUMBER,
p_COMMON_ROUTING_SEQ_ID NUMBER,
p_COST_TYPE_ID NUMBER,
p_ORG_COST_GROUP_ID NUMBER,
p_MOVE_ORDER_LINE_ID NUMBER,
p_TASK_GROUP_ID NUMBER,
p_PICK_SLIP_NUMBER NUMBER,
p_RESERVATION_ID NUMBER,
p_TRANSACTION_STATUS NUMBER,
p_STANDARD_OPERATION_ID NUMBER,
p_TASK_PRIORITY NUMBER,
p_WMS_TASK_TYPE NUMBER,
p_PARENT_LINE_ID NUMBER)
-- P_SOURCE_LOT_NUMBER NUMBER)
IS
CURSOR C2 IS SELECT MTL_MATERIAL_TRANSACTIONS_S.nextval FROM sys.dual;
INSERT INTO MTL_MATERIAL_TRANSACTIONS_TEMP(
TRANSACTION_HEADER_ID,
TRANSACTION_TEMP_ID,
SOURCE_CODE,
SOURCE_LINE_ID,
TRANSACTION_MODE,
LOCK_FLAG,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_LOGIN,
REQUEST_ID,
PROGRAM_APPLICATION_ID,
PROGRAM_ID,
PROGRAM_UPDATE_DATE,
INVENTORY_ITEM_ID,
REVISION,
ORGANIZATION_ID,
SUBINVENTORY_CODE,
LOCATOR_ID,
TRANSACTION_QUANTITY,
PRIMARY_QUANTITY,
TRANSACTION_UOM,
TRANSACTION_COST,
TRANSACTION_TYPE_ID,
TRANSACTION_ACTION_ID,
TRANSACTION_SOURCE_TYPE_ID,
TRANSACTION_SOURCE_ID,
TRANSACTION_SOURCE_NAME,
TRANSACTION_DATE,
ACCT_PERIOD_ID,
DISTRIBUTION_ACCOUNT_ID,
TRANSACTION_REFERENCE,
REQUISITION_LINE_ID,
REQUISITION_DISTRIBUTION_ID,
REASON_ID,
LOT_NUMBER,
LOT_EXPIRATION_DATE,
SERIAL_NUMBER,
RECEIVING_DOCUMENT,
DEMAND_ID,
RCV_TRANSACTION_ID,
MOVE_TRANSACTION_ID,
COMPLETION_TRANSACTION_ID,
WIP_ENTITY_TYPE,
SCHEDULE_ID,
REPETITIVE_LINE_ID,
EMPLOYEE_CODE,
PRIMARY_SWITCH,
SCHEDULE_UPDATE_CODE,
SETUP_TEARDOWN_CODE,
ITEM_ORDERING,
NEGATIVE_REQ_FLAG,
OPERATION_SEQ_NUM,
PICKING_LINE_ID,
TRX_SOURCE_LINE_ID,
TRX_SOURCE_DELIVERY_ID,
PHYSICAL_ADJUSTMENT_ID,
CYCLE_COUNT_ID,
RMA_LINE_ID,
CUSTOMER_SHIP_ID,
CURRENCY_CODE,
CURRENCY_CONVERSION_RATE,
CURRENCY_CONVERSION_TYPE,
CURRENCY_CONVERSION_DATE,
USSGL_TRANSACTION_CODE,
VENDOR_LOT_NUMBER,
ENCUMBRANCE_ACCOUNT,
ENCUMBRANCE_AMOUNT,
SHIP_TO_LOCATION,
SHIPMENT_NUMBER,
TRANSFER_COST,
TRANSPORTATION_COST,
TRANSPORTATION_ACCOUNT,
FREIGHT_CODE,
CONTAINERS,
WAYBILL_AIRBILL,
EXPECTED_ARRIVAL_DATE,
TRANSFER_SUBINVENTORY,
TRANSFER_ORGANIZATION,
TRANSFER_TO_LOCATION,
NEW_AVERAGE_COST,
VALUE_CHANGE,
PERCENTAGE_CHANGE,
MATERIAL_ALLOCATION_TEMP_ID,
DEMAND_SOURCE_HEADER_ID,
DEMAND_SOURCE_LINE,
DEMAND_SOURCE_DELIVERY,
ITEM_SEGMENTS,
ITEM_DESCRIPTION,
ITEM_TRX_ENABLED_FLAG,
ITEM_LOCATION_CONTROL_CODE,
ITEM_RESTRICT_SUBINV_CODE,
ITEM_RESTRICT_LOCATORS_CODE,
ITEM_REVISION_QTY_CONTROL_CODE,
ITEM_PRIMARY_UOM_CODE,
ITEM_UOM_CLASS,
ITEM_SHELF_LIFE_CODE,
ITEM_SHELF_LIFE_DAYS,
ITEM_LOT_CONTROL_CODE,
ITEM_SERIAL_CONTROL_CODE,
ITEM_INVENTORY_ASSET_FLAG,
ALLOWED_UNITS_LOOKUP_CODE,
DEPARTMENT_ID,
DEPARTMENT_CODE,
WIP_SUPPLY_TYPE,
SUPPLY_SUBINVENTORY,
SUPPLY_LOCATOR_ID,
VALID_SUBINVENTORY_FLAG,
VALID_LOCATOR_FLAG,
LOCATOR_SEGMENTS,
CURRENT_LOCATOR_CONTROL_CODE,
NUMBER_OF_LOTS_ENTERED,
WIP_COMMIT_FLAG,
NEXT_LOT_NUMBER,
LOT_ALPHA_PREFIX,
NEXT_SERIAL_NUMBER,
SERIAL_ALPHA_PREFIX,
SHIPPABLE_FLAG,
POSTING_FLAG,
REQUIRED_FLAG,
PROCESS_FLAG,
ERROR_CODE,
ERROR_EXPLANATION,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
MOVEMENT_ID,
RESERVATION_QUANTITY,
SHIPPED_QUANTITY,
TRANSACTION_LINE_NUMBER,
TASK_ID,
TO_TASK_ID,
SOURCE_TASK_ID,
PROJECT_ID,
SOURCE_PROJECT_ID,
PA_EXPENDITURE_ORG_ID,
TO_PROJECT_ID,
EXPENDITURE_TYPE,
FINAL_COMPLETION_FLAG,
TRANSFER_PERCENTAGE,
TRANSACTION_SEQUENCE_ID,
MATERIAL_ACCOUNT,
MATERIAL_OVERHEAD_ACCOUNT,
RESOURCE_ACCOUNT,
OUTSIDE_PROCESSING_ACCOUNT,
OVERHEAD_ACCOUNT,
FLOW_SCHEDULE,
COST_GROUP_ID,
DEMAND_CLASS,
QA_COLLECTION_ID,
KANBAN_CARD_ID,
OVERCOMPLETION_TRANSACTION_ID,
OVERCOMPLETION_PRIMARY_QTY,
OVERCOMPLETION_TRANSACTION_QTY,
--PROCESS_TYPE,
END_ITEM_UNIT_NUMBER,
SCHEDULED_PAYBACK_DATE,
LINE_TYPE_CODE,
PARENT_TRANSACTION_TEMP_ID,
PUT_AWAY_STRATEGY_ID,
PUT_AWAY_RULE_ID,
PICK_STRATEGY_ID,
PICK_RULE_ID,
COMMON_BOM_SEQ_ID,
COMMON_ROUTING_SEQ_ID,
COST_TYPE_ID,
ORG_COST_GROUP_ID,
MOVE_ORDER_LINE_ID,
TASK_GROUP_ID,
PICK_SLIP_NUMBER,
RESERVATION_ID,
TRANSACTION_STATUS,
STANDARD_OPERATION_ID,
TASK_PRIORITY,
WMS_TASK_TYPE,
PARENT_LINE_ID
--SOURCE_LOT_NUMBER
) VALUES (
decode( p_TRANSACTION_HEADER_ID, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_HEADER_ID),
px_TRANSACTION_TEMP_ID,
decode( p_SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_CODE),
decode( p_SOURCE_LINE_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_LINE_ID),
decode( p_TRANSACTION_MODE, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_MODE),
decode( p_LOCK_FLAG, FND_API.G_MISS_CHAR, NULL, p_LOCK_FLAG),
decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_CHAR, to_date(NULL), p_last_update_date),
decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
decode( p_creation_date, FND_API.G_MISS_CHAR, to_date(NULL), p_creation_date),
decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
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),
decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID),
decode( p_REVISION, FND_API.G_MISS_CHAR, NULL, p_REVISION),
decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID),
decode( p_SUBINVENTORY_CODE, FND_API.G_MISS_CHAR, NULL, p_SUBINVENTORY_CODE),
decode( p_LOCATOR_ID, FND_API.G_MISS_NUM, NULL, p_LOCATOR_ID),
decode( p_TRANSACTION_QUANTITY, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_QUANTITY),
decode( p_PRIMARY_QUANTITY, FND_API.G_MISS_NUM, NULL, p_PRIMARY_QUANTITY),
decode( p_TRANSACTION_UOM, FND_API.G_MISS_CHAR, NULL, p_TRANSACTION_UOM),
decode( p_TRANSACTION_COST, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_COST),
decode( p_TRANSACTION_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_TYPE_ID),
decode( p_TRANSACTION_ACTION_ID, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_ACTION_ID),
decode( p_TRANSACTION_SOURCE_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_SOURCE_TYPE_ID),
decode( p_TRANSACTION_SOURCE_ID, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_SOURCE_ID),
decode( p_TRANSACTION_SOURCE_NAME, FND_API.G_MISS_CHAR, NULL, p_TRANSACTION_SOURCE_NAME),
decode( p_TRANSACTION_DATE, FND_API.G_MISS_DATE, to_date(NULL), p_TRANSACTION_DATE),
decode( p_ACCT_PERIOD_ID, FND_API.G_MISS_NUM, NULL, p_ACCT_PERIOD_ID),
decode( p_DISTRIBUTION_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, p_DISTRIBUTION_ACCOUNT_ID),
decode( p_TRANSACTION_REFERENCE, FND_API.G_MISS_CHAR, NULL, p_TRANSACTION_REFERENCE),
decode( p_REQUISITION_LINE_ID, FND_API.G_MISS_NUM, NULL, p_REQUISITION_LINE_ID),
decode( p_REQUISITION_DISTRIBUTION_ID, FND_API.G_MISS_NUM, NULL, p_REQUISITION_DISTRIBUTION_ID),
decode( p_REASON_ID, FND_API.G_MISS_NUM, NULL, p_REASON_ID),
decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, NULL, p_LOT_NUMBER),
decode( p_LOT_EXPIRATION_DATE, FND_API.G_MISS_DATE, to_date(null), p_LOT_EXPIRATION_DATE),
decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NULL, p_SERIAL_NUMBER),
decode( p_RECEIVING_DOCUMENT, FND_API.G_MISS_CHAR, NULL, p_RECEIVING_DOCUMENT),
decode( p_DEMAND_ID, FND_API.G_MISS_NUM, NULL, p_DEMAND_ID),
decode( p_RCV_TRANSACTION_ID, FND_API.G_MISS_NUM, NULL, p_RCV_TRANSACTION_ID),
decode( p_MOVE_TRANSACTION_ID, FND_API.G_MISS_NUM, NULL, p_MOVE_TRANSACTION_ID),
decode( p_COMPLETION_TRANSACTION_ID, FND_API.G_MISS_NUM, NULL, p_COMPLETION_TRANSACTION_ID),
decode( p_WIP_ENTITY_TYPE, FND_API.G_MISS_NUM, NULL, p_WIP_ENTITY_TYPE),
decode( p_SCHEDULE_ID, FND_API.G_MISS_NUM, NULL, p_SCHEDULE_ID),
decode( p_REPETITIVE_LINE_ID, FND_API.G_MISS_NUM, NULL, p_REPETITIVE_LINE_ID),
decode( p_EMPLOYEE_CODE, FND_API.G_MISS_CHAR, NULL, p_EMPLOYEE_CODE),
decode( p_PRIMARY_SWITCH, FND_API.G_MISS_NUM, NULL, p_PRIMARY_SWITCH),
decode( p_SCHEDULE_UPDATE_CODE, FND_API.G_MISS_NUM, NULL, p_SCHEDULE_UPDATE_CODE),
decode( p_SETUP_TEARDOWN_CODE, FND_API.G_MISS_NUM, NULL, p_SETUP_TEARDOWN_CODE),
decode( p_ITEM_ORDERING, FND_API.G_MISS_NUM, NULL, p_ITEM_ORDERING),
decode( p_NEGATIVE_REQ_FLAG, FND_API.G_MISS_NUM, NULL, p_NEGATIVE_REQ_FLAG),
decode( p_OPERATION_SEQ_NUM, FND_API.G_MISS_NUM, NULL, p_OPERATION_SEQ_NUM),
decode( p_PICKING_LINE_ID, FND_API.G_MISS_NUM, NULL, p_PICKING_LINE_ID),
decode( p_TRX_SOURCE_LINE_ID, FND_API.G_MISS_NUM, NULL, p_TRX_SOURCE_LINE_ID),
decode( p_TRX_SOURCE_DELIVERY_ID, FND_API.G_MISS_NUM, NULL, p_TRX_SOURCE_DELIVERY_ID),
decode( p_PHYSICAL_ADJUSTMENT_ID, FND_API.G_MISS_NUM, NULL, p_PHYSICAL_ADJUSTMENT_ID),
decode( p_CYCLE_COUNT_ID, FND_API.G_MISS_NUM, NULL, p_CYCLE_COUNT_ID),
decode( p_RMA_LINE_ID, FND_API.G_MISS_NUM, NULL, p_RMA_LINE_ID),
decode( p_CUSTOMER_SHIP_ID, FND_API.G_MISS_NUM, NULL, p_CUSTOMER_SHIP_ID),
decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_CURRENCY_CODE),
decode( p_CURRENCY_CONVERSION_RATE, FND_API.G_MISS_NUM, NULL, p_CURRENCY_CONVERSION_RATE),
decode( p_CURRENCY_CONVERSION_TYPE, FND_API.G_MISS_CHAR, NULL, p_CURRENCY_CONVERSION_TYPE),
decode( p_CURRENCY_CONVERSION_DATE, FND_API.G_MISS_DATE, to_date(null), p_CURRENCY_CONVERSION_DATE),
decode( p_USSGL_TRANSACTION_CODE, FND_API.G_MISS_CHAR, NULL, p_USSGL_TRANSACTION_CODE),
decode( p_VENDOR_LOT_NUMBER, FND_API.G_MISS_CHAR, NULL, p_VENDOR_LOT_NUMBER),
decode( p_ENCUMBRANCE_ACCOUNT, FND_API.G_MISS_NUM, NULL, p_ENCUMBRANCE_ACCOUNT),
decode( p_ENCUMBRANCE_AMOUNT, FND_API.G_MISS_NUM, NULL, p_ENCUMBRANCE_AMOUNT),
decode( p_SHIP_TO_LOCATION, FND_API.G_MISS_NUM, NULL, p_SHIP_TO_LOCATION),
decode( p_SHIPMENT_NUMBER, FND_API.G_MISS_CHAR, NULL, p_SHIPMENT_NUMBER),
decode( p_TRANSFER_COST, FND_API.G_MISS_NUM, NULL, p_TRANSFER_COST),
decode( p_TRANSPORTATION_COST, FND_API.G_MISS_NUM, NULL, p_TRANSPORTATION_COST),
decode( p_TRANSPORTATION_ACCOUNT, FND_API.G_MISS_NUM, NULL, p_TRANSPORTATION_ACCOUNT),
decode( p_FREIGHT_CODE, FND_API.G_MISS_CHAR, NULL, p_FREIGHT_CODE),
decode( p_CONTAINERS, FND_API.G_MISS_NUM, NULL, p_CONTAINERS),
decode( p_WAYBILL_AIRBILL, FND_API.G_MISS_CHAR, NULL, p_WAYBILL_AIRBILL),
decode( p_EXPECTED_ARRIVAL_DATE, FND_API.G_MISS_DATE, to_date(null), p_EXPECTED_ARRIVAL_DATE),
decode( p_TRANSFER_SUBINVENTORY, FND_API.G_MISS_CHAR, NULL, p_TRANSFER_SUBINVENTORY),
decode( p_TRANSFER_ORGANIZATION, FND_API.G_MISS_NUM, NULL, p_TRANSFER_ORGANIZATION),
decode( p_TRANSFER_TO_LOCATION, FND_API.G_MISS_NUM, NULL, p_TRANSFER_TO_LOCATION),
decode( p_NEW_AVERAGE_COST, FND_API.G_MISS_NUM, NULL, p_NEW_AVERAGE_COST),
decode( p_VALUE_CHANGE, FND_API.G_MISS_NUM, NULL, p_VALUE_CHANGE),
decode( p_PERCENTAGE_CHANGE, FND_API.G_MISS_NUM, NULL, p_PERCENTAGE_CHANGE),
decode( p_MATERIAL_ALLOCATION_TEMP_ID, FND_API.G_MISS_NUM, NULL, p_MATERIAL_ALLOCATION_TEMP_ID),
decode( p_DEMAND_SOURCE_HEADER_ID, FND_API.G_MISS_NUM, NULL, p_DEMAND_SOURCE_HEADER_ID),
decode( p_DEMAND_SOURCE_LINE, FND_API.G_MISS_CHAR, NULL, p_DEMAND_SOURCE_LINE),
decode( p_DEMAND_SOURCE_DELIVERY, FND_API.G_MISS_CHAR, NULL, p_DEMAND_SOURCE_DELIVERY),
decode( p_ITEM_SEGMENTS, FND_API.G_MISS_CHAR, NULL, p_ITEM_SEGMENTS),
decode( p_ITEM_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_ITEM_DESCRIPTION),
decode( p_ITEM_TRX_ENABLED_FLAG, FND_API.G_MISS_CHAR, NULL, p_ITEM_TRX_ENABLED_FLAG),
decode( p_ITEM_LOCATION_CONTROL_CODE, FND_API.G_MISS_NUM, NULL, p_ITEM_LOCATION_CONTROL_CODE),
decode( p_ITEM_RESTRICT_SUBINV_CODE, FND_API.G_MISS_NUM, NULL, p_ITEM_RESTRICT_SUBINV_CODE),
decode( p_ITEM_RESTRICT_LOCATORS_CODE, FND_API.G_MISS_NUM, NULL, p_ITEM_RESTRICT_LOCATORS_CODE),
decode( p_ITEM_REV_QTY_CONTROL_CODE, FND_API.G_MISS_NUM, NULL, p_ITEM_REV_QTY_CONTROL_CODE),
decode( p_ITEM_PRIMARY_UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_ITEM_PRIMARY_UOM_CODE),
decode( p_ITEM_UOM_CLASS, FND_API.G_MISS_CHAR, NULL, p_ITEM_UOM_CLASS),
decode( p_ITEM_SHELF_LIFE_CODE, FND_API.G_MISS_NUM, NULL, p_ITEM_SHELF_LIFE_CODE),
decode( p_ITEM_SHELF_LIFE_DAYS, FND_API.G_MISS_NUM, NULL, p_ITEM_SHELF_LIFE_DAYS),
decode( p_ITEM_LOT_CONTROL_CODE, FND_API.G_MISS_NUM, NULL, p_ITEM_LOT_CONTROL_CODE),
decode( p_ITEM_SERIAL_CONTROL_CODE, FND_API.G_MISS_NUM, NULL, p_ITEM_SERIAL_CONTROL_CODE),
decode( p_ITEM_INVENTORY_ASSET_FLAG, FND_API.G_MISS_CHAR, NULL, p_ITEM_INVENTORY_ASSET_FLAG),
decode( p_ALLOWED_UNITS_LOOKUP_CODE, FND_API.G_MISS_NUM, NULL, p_ALLOWED_UNITS_LOOKUP_CODE),
decode( p_DEPARTMENT_ID, FND_API.G_MISS_NUM, NULL, p_DEPARTMENT_ID),
decode( p_DEPARTMENT_CODE, FND_API.G_MISS_CHAR, NULL, p_DEPARTMENT_CODE),
decode( p_WIP_SUPPLY_TYPE, FND_API.G_MISS_NUM, NULL, p_WIP_SUPPLY_TYPE),
decode( p_SUPPLY_SUBINVENTORY, FND_API.G_MISS_CHAR, NULL, p_SUPPLY_SUBINVENTORY),
decode( p_SUPPLY_LOCATOR_ID, FND_API.G_MISS_NUM, NULL, p_SUPPLY_LOCATOR_ID),
decode( p_VALID_SUBINVENTORY_FLAG, FND_API.G_MISS_CHAR, NULL, p_VALID_SUBINVENTORY_FLAG),
decode( p_VALID_LOCATOR_FLAG, FND_API.G_MISS_CHAR, NULL, p_VALID_LOCATOR_FLAG),
decode( p_LOCATOR_SEGMENTS, FND_API.G_MISS_CHAR, NULL, p_LOCATOR_SEGMENTS),
decode( p_CURRENT_LOCATOR_CONTROL_CODE, FND_API.G_MISS_NUM, NULL, p_CURRENT_LOCATOR_CONTROL_CODE),
decode( p_NUMBER_OF_LOTS_ENTERED, FND_API.G_MISS_NUM, NULL, p_NUMBER_OF_LOTS_ENTERED),
decode( p_WIP_COMMIT_FLAG, FND_API.G_MISS_CHAR, NULL, p_WIP_COMMIT_FLAG),
decode( p_NEXT_LOT_NUMBER, FND_API.G_MISS_CHAR, NULL, p_NEXT_LOT_NUMBER),
decode( p_LOT_ALPHA_PREFIX, FND_API.G_MISS_CHAR, NULL, p_LOT_ALPHA_PREFIX),
decode( p_NEXT_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NULL, p_NEXT_SERIAL_NUMBER),
decode( p_SERIAL_ALPHA_PREFIX, FND_API.G_MISS_CHAR, NULL, p_SERIAL_ALPHA_PREFIX),
decode( p_SHIPPABLE_FLAG, FND_API.G_MISS_CHAR, NULL, p_SHIPPABLE_FLAG),
decode( p_POSTING_FLAG, FND_API.G_MISS_CHAR, NULL, p_POSTING_FLAG),
decode( p_REQUIRED_FLAG, FND_API.G_MISS_CHAR, NULL, p_REQUIRED_FLAG),
decode( p_PROCESS_FLAG, FND_API.G_MISS_CHAR, NULL, p_PROCESS_FLAG),
decode( p_ERROR_CODE, FND_API.G_MISS_CHAR, NULL, p_ERROR_CODE),
decode( p_ERROR_EXPLANATION, FND_API.G_MISS_CHAR, NULL, p_ERROR_EXPLANATION),
decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
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_MOVEMENT_ID, FND_API.G_MISS_NUM, NULL, p_MOVEMENT_ID),
decode( p_RESERVATION_QUANTITY, FND_API.G_MISS_NUM, NULL, p_RESERVATION_QUANTITY),
decode( p_SHIPPED_QUANTITY, FND_API.G_MISS_NUM, NULL, p_SHIPPED_QUANTITY),
decode( p_TRANSACTION_LINE_NUMBER, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_LINE_NUMBER),
decode( p_TASK_ID, FND_API.G_MISS_NUM, NULL, p_TASK_ID),
decode( p_TO_TASK_ID, FND_API.G_MISS_NUM, NULL, p_TO_TASK_ID),
decode( p_SOURCE_TASK_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_TASK_ID),
decode( p_PROJECT_ID, FND_API.G_MISS_NUM, NULL, p_PROJECT_ID),
decode( p_SOURCE_PROJECT_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_PROJECT_ID),
decode( p_PA_EXPENDITURE_ORG_ID, FND_API.G_MISS_NUM, NULL, p_PA_EXPENDITURE_ORG_ID),
decode( p_TO_PROJECT_ID, FND_API.G_MISS_NUM, NULL, p_TO_PROJECT_ID),
decode( p_EXPENDITURE_TYPE, FND_API.G_MISS_CHAR, NULL, p_EXPENDITURE_TYPE),
decode( p_FINAL_COMPLETION_FLAG, FND_API.G_MISS_CHAR, NULL, p_FINAL_COMPLETION_FLAG),
decode( p_TRANSFER_PERCENTAGE, FND_API.G_MISS_NUM, NULL, p_TRANSFER_PERCENTAGE),
decode( p_TRANSACTION_SEQUENCE_ID, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_SEQUENCE_ID),
decode( p_MATERIAL_ACCOUNT, FND_API.G_MISS_NUM, NULL, p_MATERIAL_ACCOUNT),
decode( p_MATERIAL_OVERHEAD_ACCOUNT, FND_API.G_MISS_NUM, NULL, p_MATERIAL_OVERHEAD_ACCOUNT),
decode( p_RESOURCE_ACCOUNT, FND_API.G_MISS_NUM, NULL, p_RESOURCE_ACCOUNT),
decode( p_OUTSIDE_PROCESSING_ACCOUNT, FND_API.G_MISS_NUM, NULL, p_OUTSIDE_PROCESSING_ACCOUNT),
decode( p_OVERHEAD_ACCOUNT, FND_API.G_MISS_NUM, NULL, p_OVERHEAD_ACCOUNT),
decode( p_FLOW_SCHEDULE, FND_API.G_MISS_CHAR, NULL, p_FLOW_SCHEDULE),
decode( p_COST_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_COST_GROUP_ID),
decode( p_DEMAND_CLASS, FND_API.G_MISS_CHAR, NULL, p_DEMAND_CLASS),
decode( p_QA_COLLECTION_ID, FND_API.G_MISS_NUM, NULL, p_QA_COLLECTION_ID),
decode( p_KANBAN_CARD_ID, FND_API.G_MISS_NUM, NULL, p_KANBAN_CARD_ID),
decode( p_OVERCOMPLETION_TXN_ID, FND_API.G_MISS_NUM, NULL, p_OVERCOMPLETION_TXN_ID),
decode( p_OVERCOMPLETION_PRIMARY_QTY, FND_API.G_MISS_NUM, NULL, p_OVERCOMPLETION_PRIMARY_QTY),
decode( p_OVERCOMPLETION_TXN_QTY, FND_API.G_MISS_NUM, NULL, p_OVERCOMPLETION_TXN_QTY),
--decode( p_PROCESS_TYPE, FND_API.G_MISS_NUM, NULL, p_PROCESS_TYPE),
decode( p_END_ITEM_UNIT_NUMBER, FND_API.G_MISS_CHAR, NULL, p_END_ITEM_UNIT_NUMBER),
decode( p_SCHEDULED_PAYBACK_DATE, FND_API.G_MISS_DATE, to_date(null), p_SCHEDULED_PAYBACK_DATE),
decode( p_LINE_TYPE_CODE, FND_API.G_MISS_NUM, NULL, p_LINE_TYPE_CODE),
decode( p_PARENT_TRANSACTION_TEMP_ID, FND_API.G_MISS_NUM, NULL, p_PARENT_TRANSACTION_TEMP_ID),
decode( p_PUT_AWAY_STRATEGY_ID, FND_API.G_MISS_NUM, NULL, p_PUT_AWAY_STRATEGY_ID),
decode( p_PUT_AWAY_RULE_ID, FND_API.G_MISS_NUM, NULL, p_PUT_AWAY_RULE_ID),
decode( p_PICK_STRATEGY_ID, FND_API.G_MISS_NUM, NULL, p_PICK_STRATEGY_ID),
decode( p_PICK_RULE_ID, FND_API.G_MISS_NUM, NULL, p_PICK_RULE_ID),
decode( p_COMMON_BOM_SEQ_ID, FND_API.G_MISS_NUM, NULL, p_COMMON_BOM_SEQ_ID),
decode( p_COMMON_ROUTING_SEQ_ID, FND_API.G_MISS_NUM, NULL, p_COMMON_ROUTING_SEQ_ID),
decode( p_COST_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_COST_TYPE_ID),
decode( p_ORG_COST_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_ORG_COST_GROUP_ID),
decode( p_MOVE_ORDER_LINE_ID, FND_API.G_MISS_NUM, NULL, p_MOVE_ORDER_LINE_ID),
decode( p_TASK_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_TASK_GROUP_ID),
decode( p_PICK_SLIP_NUMBER, FND_API.G_MISS_NUM, NULL, p_PICK_SLIP_NUMBER),
decode( p_RESERVATION_ID, FND_API.G_MISS_NUM, NULL, p_RESERVATION_ID),
decode( p_TRANSACTION_STATUS, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_STATUS),
decode( p_STANDARD_OPERATION_ID, FND_API.G_MISS_NUM, NULL, p_STANDARD_OPERATION_ID),
decode( p_TASK_PRIORITY, FND_API.G_MISS_NUM, NULL, p_TASK_PRIORITY),
decode( p_WMS_TASK_TYPE, FND_API.G_MISS_NUM, NULL, p_WMS_TASK_TYPE),
decode( p_PARENT_LINE_ID, FND_API.G_MISS_NUM, NULL, p_PARENT_LINE_ID)
-- decode( P_SOURCE_LOT_NUMBER, FND_API.G_MISS_NUM, NULL, p_SOURCE_LOT_NUMBER)
);
End Insert_Row;
PROCEDURE Update_Row(
p_TRANSACTION_HEADER_ID NUMBER,
p_TRANSACTION_TEMP_ID NUMBER,
p_SOURCE_CODE VARCHAR2,
p_SOURCE_LINE_ID NUMBER,
p_TRANSACTION_MODE NUMBER,
p_LOCK_FLAG VARCHAR2,
p_LAST_UPDATE_DATE DATE,
p_LAST_UPDATED_BY NUMBER,
p_CREATION_DATE DATE,
p_CREATED_BY NUMBER,
p_LAST_UPDATE_LOGIN NUMBER,
p_REQUEST_ID NUMBER,
p_PROGRAM_APPLICATION_ID NUMBER,
p_PROGRAM_ID NUMBER,
p_PROGRAM_UPDATE_DATE DATE,
p_INVENTORY_ITEM_ID NUMBER,
p_REVISION VARCHAR2,
p_ORGANIZATION_ID NUMBER,
p_SUBINVENTORY_CODE VARCHAR2,
p_LOCATOR_ID NUMBER,
p_TRANSACTION_QUANTITY NUMBER,
p_PRIMARY_QUANTITY NUMBER,
p_TRANSACTION_UOM VARCHAR2,
p_TRANSACTION_COST NUMBER,
p_TRANSACTION_TYPE_ID NUMBER,
p_TRANSACTION_ACTION_ID NUMBER,
p_TRANSACTION_SOURCE_TYPE_ID NUMBER,
p_TRANSACTION_SOURCE_ID NUMBER,
p_TRANSACTION_SOURCE_NAME VARCHAR2,
p_TRANSACTION_DATE DATE,
p_ACCT_PERIOD_ID NUMBER,
p_DISTRIBUTION_ACCOUNT_ID NUMBER,
p_TRANSACTION_REFERENCE VARCHAR2,
p_REQUISITION_LINE_ID NUMBER,
p_REQUISITION_DISTRIBUTION_ID NUMBER,
p_REASON_ID NUMBER,
p_LOT_NUMBER VARCHAR2,
p_LOT_EXPIRATION_DATE DATE,
p_SERIAL_NUMBER VARCHAR2,
p_RECEIVING_DOCUMENT VARCHAR2,
p_DEMAND_ID NUMBER,
p_RCV_TRANSACTION_ID NUMBER,
p_MOVE_TRANSACTION_ID NUMBER,
p_COMPLETION_TRANSACTION_ID NUMBER,
p_WIP_ENTITY_TYPE NUMBER,
p_SCHEDULE_ID NUMBER,
p_REPETITIVE_LINE_ID NUMBER,
p_EMPLOYEE_CODE VARCHAR2,
p_PRIMARY_SWITCH NUMBER,
p_SCHEDULE_UPDATE_CODE NUMBER,
p_SETUP_TEARDOWN_CODE NUMBER,
p_ITEM_ORDERING NUMBER,
p_NEGATIVE_REQ_FLAG NUMBER,
p_OPERATION_SEQ_NUM NUMBER,
p_PICKING_LINE_ID NUMBER,
p_TRX_SOURCE_LINE_ID NUMBER,
p_TRX_SOURCE_DELIVERY_ID NUMBER,
p_PHYSICAL_ADJUSTMENT_ID NUMBER,
p_CYCLE_COUNT_ID NUMBER,
p_RMA_LINE_ID NUMBER,
p_CUSTOMER_SHIP_ID NUMBER,
p_CURRENCY_CODE VARCHAR2,
p_CURRENCY_CONVERSION_RATE NUMBER,
p_CURRENCY_CONVERSION_TYPE VARCHAR2,
p_CURRENCY_CONVERSION_DATE DATE,
p_USSGL_TRANSACTION_CODE VARCHAR2,
p_VENDOR_LOT_NUMBER VARCHAR2,
p_ENCUMBRANCE_ACCOUNT NUMBER,
p_ENCUMBRANCE_AMOUNT NUMBER,
p_SHIP_TO_LOCATION NUMBER,
p_SHIPMENT_NUMBER VARCHAR2,
p_TRANSFER_COST NUMBER,
p_TRANSPORTATION_COST NUMBER,
p_TRANSPORTATION_ACCOUNT NUMBER,
p_FREIGHT_CODE VARCHAR2,
p_CONTAINERS NUMBER,
p_WAYBILL_AIRBILL VARCHAR2,
p_EXPECTED_ARRIVAL_DATE DATE,
p_TRANSFER_SUBINVENTORY VARCHAR2,
p_TRANSFER_ORGANIZATION NUMBER,
p_TRANSFER_TO_LOCATION NUMBER,
p_NEW_AVERAGE_COST NUMBER,
p_VALUE_CHANGE NUMBER,
p_PERCENTAGE_CHANGE NUMBER,
p_MATERIAL_ALLOCATION_TEMP_ID NUMBER,
p_DEMAND_SOURCE_HEADER_ID NUMBER,
p_DEMAND_SOURCE_LINE VARCHAR2,
p_DEMAND_SOURCE_DELIVERY VARCHAR2,
p_ITEM_SEGMENTS VARCHAR2,
p_ITEM_DESCRIPTION VARCHAR2,
p_ITEM_TRX_ENABLED_FLAG VARCHAR2,
p_ITEM_LOCATION_CONTROL_CODE NUMBER,
p_ITEM_RESTRICT_SUBINV_CODE NUMBER,
p_ITEM_RESTRICT_LOCATORS_CODE NUMBER,
p_ITEM_REV_QTY_CONTROL_CODE NUMBER,
p_ITEM_PRIMARY_UOM_CODE VARCHAR2,
p_ITEM_UOM_CLASS VARCHAR2,
p_ITEM_SHELF_LIFE_CODE NUMBER,
p_ITEM_SHELF_LIFE_DAYS NUMBER,
p_ITEM_LOT_CONTROL_CODE NUMBER,
p_ITEM_SERIAL_CONTROL_CODE NUMBER,
p_ITEM_INVENTORY_ASSET_FLAG VARCHAR2,
p_ALLOWED_UNITS_LOOKUP_CODE NUMBER,
p_DEPARTMENT_ID NUMBER,
p_DEPARTMENT_CODE VARCHAR2,
p_WIP_SUPPLY_TYPE NUMBER,
p_SUPPLY_SUBINVENTORY VARCHAR2,
p_SUPPLY_LOCATOR_ID NUMBER,
p_VALID_SUBINVENTORY_FLAG VARCHAR2,
p_VALID_LOCATOR_FLAG VARCHAR2,
p_LOCATOR_SEGMENTS VARCHAR2,
p_CURRENT_LOCATOR_CONTROL_CODE NUMBER,
p_NUMBER_OF_LOTS_ENTERED NUMBER,
p_WIP_COMMIT_FLAG VARCHAR2,
p_NEXT_LOT_NUMBER VARCHAR2,
p_LOT_ALPHA_PREFIX VARCHAR2,
p_NEXT_SERIAL_NUMBER VARCHAR2,
p_SERIAL_ALPHA_PREFIX VARCHAR2,
p_SHIPPABLE_FLAG VARCHAR2,
p_POSTING_FLAG VARCHAR2,
p_REQUIRED_FLAG VARCHAR2,
p_PROCESS_FLAG VARCHAR2,
p_ERROR_CODE VARCHAR2,
p_ERROR_EXPLANATION VARCHAR2,
p_ATTRIBUTE_CATEGORY 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_MOVEMENT_ID NUMBER,
p_RESERVATION_QUANTITY NUMBER,
p_SHIPPED_QUANTITY NUMBER,
p_TRANSACTION_LINE_NUMBER NUMBER,
p_TASK_ID NUMBER,
p_TO_TASK_ID NUMBER,
p_SOURCE_TASK_ID NUMBER,
p_PROJECT_ID NUMBER,
p_SOURCE_PROJECT_ID NUMBER,
p_PA_EXPENDITURE_ORG_ID NUMBER,
p_TO_PROJECT_ID NUMBER,
p_EXPENDITURE_TYPE VARCHAR2,
p_FINAL_COMPLETION_FLAG VARCHAR2,
p_TRANSFER_PERCENTAGE NUMBER,
p_TRANSACTION_SEQUENCE_ID NUMBER,
p_MATERIAL_ACCOUNT NUMBER,
p_MATERIAL_OVERHEAD_ACCOUNT NUMBER,
p_RESOURCE_ACCOUNT NUMBER,
p_OUTSIDE_PROCESSING_ACCOUNT NUMBER,
p_OVERHEAD_ACCOUNT NUMBER,
p_FLOW_SCHEDULE VARCHAR2,
p_COST_GROUP_ID NUMBER,
p_DEMAND_CLASS VARCHAR2,
p_QA_COLLECTION_ID NUMBER,
p_KANBAN_CARD_ID NUMBER,
p_OVERCOMPLETION_TXN_ID NUMBER,
p_OVERCOMPLETION_PRIMARY_QTY NUMBER,
p_OVERCOMPLETION_TXN_QTY NUMBER,
--p_PROCESS_TYPE NUMBER,
p_END_ITEM_UNIT_NUMBER VARCHAR2,
p_SCHEDULED_PAYBACK_DATE DATE,
p_LINE_TYPE_CODE NUMBER,
p_PARENT_TRANSACTION_TEMP_ID NUMBER,
p_PUT_AWAY_STRATEGY_ID NUMBER,
p_PUT_AWAY_RULE_ID NUMBER,
p_PICK_STRATEGY_ID NUMBER,
p_PICK_RULE_ID NUMBER,
p_COMMON_BOM_SEQ_ID NUMBER,
p_COMMON_ROUTING_SEQ_ID NUMBER,
p_COST_TYPE_ID NUMBER,
p_ORG_COST_GROUP_ID NUMBER,
p_MOVE_ORDER_LINE_ID NUMBER,
p_TASK_GROUP_ID NUMBER,
p_PICK_SLIP_NUMBER NUMBER,
p_RESERVATION_ID NUMBER,
p_TRANSACTION_STATUS NUMBER,
p_STANDARD_OPERATION_ID NUMBER,
P_TASK_PRIORITY NUMBER,
p_WMS_TASK_TYPE NUMBER,
p_PARENT_LINE_ID NUMBER)
-- P_SOURCE_LOT_NUMBER NUMBER)
IS
BEGIN
Update MTL_MATERIAL_TRANSACTIONS_TEMP
SET
TRANSACTION_HEADER_ID = decode( p_TRANSACTION_HEADER_ID, FND_API.G_MISS_NUM, TRANSACTION_HEADER_ID, p_TRANSACTION_HEADER_ID),
SOURCE_CODE = decode( p_SOURCE_CODE, FND_API.G_MISS_CHAR, SOURCE_CODE, p_SOURCE_CODE),
SOURCE_LINE_ID = decode( p_SOURCE_LINE_ID, FND_API.G_MISS_NUM, SOURCE_LINE_ID, p_SOURCE_LINE_ID),
TRANSACTION_MODE = decode( p_TRANSACTION_MODE, FND_API.G_MISS_NUM, TRANSACTION_MODE, p_TRANSACTION_MODE),
LOCK_FLAG = decode( p_LOCK_FLAG, FND_API.G_MISS_CHAR, LOCK_FLAG, p_LOCK_FLAG),
LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, fnd_api.g_miss_date,last_update_date,p_last_update_date),
LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
CREATION_DATE = decode(p_CREATION_DATE,fnd_api.g_miss_date,creation_date,p_creation_date),
CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
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),
INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID),
REVISION = decode( p_REVISION, FND_API.G_MISS_CHAR, REVISION, p_REVISION),
ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, p_ORGANIZATION_ID),
SUBINVENTORY_CODE = decode( p_SUBINVENTORY_CODE, FND_API.G_MISS_CHAR, SUBINVENTORY_CODE, p_SUBINVENTORY_CODE),
LOCATOR_ID = decode( p_LOCATOR_ID, FND_API.G_MISS_NUM, LOCATOR_ID, p_LOCATOR_ID),
TRANSACTION_QUANTITY = decode( p_TRANSACTION_QUANTITY, FND_API.G_MISS_NUM, TRANSACTION_QUANTITY, p_TRANSACTION_QUANTITY),
PRIMARY_QUANTITY = decode( p_PRIMARY_QUANTITY, FND_API.G_MISS_NUM, PRIMARY_QUANTITY, p_PRIMARY_QUANTITY),
TRANSACTION_UOM = decode( p_TRANSACTION_UOM, FND_API.G_MISS_CHAR, TRANSACTION_UOM, p_TRANSACTION_UOM),
TRANSACTION_COST = decode( p_TRANSACTION_COST, FND_API.G_MISS_NUM, TRANSACTION_COST, p_TRANSACTION_COST),
TRANSACTION_TYPE_ID = decode( p_TRANSACTION_TYPE_ID, FND_API.G_MISS_NUM, TRANSACTION_TYPE_ID, p_TRANSACTION_TYPE_ID),
TRANSACTION_ACTION_ID = decode( p_TRANSACTION_ACTION_ID, FND_API.G_MISS_NUM, TRANSACTION_ACTION_ID, p_TRANSACTION_ACTION_ID),
TRANSACTION_SOURCE_TYPE_ID = decode( p_TRANSACTION_SOURCE_TYPE_ID, FND_API.G_MISS_NUM, TRANSACTION_SOURCE_TYPE_ID, p_TRANSACTION_SOURCE_TYPE_ID),
TRANSACTION_SOURCE_ID = decode( p_TRANSACTION_SOURCE_ID, FND_API.G_MISS_NUM, TRANSACTION_SOURCE_ID, p_TRANSACTION_SOURCE_ID),
TRANSACTION_SOURCE_NAME = decode( p_TRANSACTION_SOURCE_NAME, FND_API.G_MISS_CHAR, TRANSACTION_SOURCE_NAME, p_TRANSACTION_SOURCE_NAME),
TRANSACTION_DATE = decode( p_TRANSACTION_DATE, FND_API.G_MISS_DATE, TRANSACTION_DATE, p_TRANSACTION_DATE),
ACCT_PERIOD_ID = decode( p_ACCT_PERIOD_ID, FND_API.G_MISS_NUM, ACCT_PERIOD_ID, p_ACCT_PERIOD_ID),
DISTRIBUTION_ACCOUNT_ID = decode( p_DISTRIBUTION_ACCOUNT_ID, FND_API.G_MISS_NUM, DISTRIBUTION_ACCOUNT_ID, p_DISTRIBUTION_ACCOUNT_ID),
TRANSACTION_REFERENCE = decode( p_TRANSACTION_REFERENCE, FND_API.G_MISS_CHAR, TRANSACTION_REFERENCE, p_TRANSACTION_REFERENCE),
REQUISITION_LINE_ID = decode( p_REQUISITION_LINE_ID, FND_API.G_MISS_NUM, REQUISITION_LINE_ID, p_REQUISITION_LINE_ID),
REQUISITION_DISTRIBUTION_ID = decode( p_REQUISITION_DISTRIBUTION_ID, FND_API.G_MISS_NUM, REQUISITION_DISTRIBUTION_ID, p_REQUISITION_DISTRIBUTION_ID),
REASON_ID = decode( p_REASON_ID, FND_API.G_MISS_NUM, REASON_ID, p_REASON_ID),
LOT_NUMBER = decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, LOT_NUMBER, p_LOT_NUMBER),
LOT_EXPIRATION_DATE = decode( p_LOT_EXPIRATION_DATE, FND_API.G_MISS_DATE, LOT_EXPIRATION_DATE, p_LOT_EXPIRATION_DATE),
SERIAL_NUMBER = decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, SERIAL_NUMBER, p_SERIAL_NUMBER),
RECEIVING_DOCUMENT = decode( p_RECEIVING_DOCUMENT, FND_API.G_MISS_CHAR, RECEIVING_DOCUMENT, p_RECEIVING_DOCUMENT),
DEMAND_ID = decode( p_DEMAND_ID, FND_API.G_MISS_NUM, DEMAND_ID, p_DEMAND_ID),
RCV_TRANSACTION_ID = decode( p_RCV_TRANSACTION_ID, FND_API.G_MISS_NUM, RCV_TRANSACTION_ID, p_RCV_TRANSACTION_ID),
MOVE_TRANSACTION_ID = decode( p_MOVE_TRANSACTION_ID, FND_API.G_MISS_NUM, MOVE_TRANSACTION_ID, p_MOVE_TRANSACTION_ID),
COMPLETION_TRANSACTION_ID = decode( p_COMPLETION_TRANSACTION_ID, FND_API.G_MISS_NUM, COMPLETION_TRANSACTION_ID, p_COMPLETION_TRANSACTION_ID),
WIP_ENTITY_TYPE = decode( p_WIP_ENTITY_TYPE, FND_API.G_MISS_NUM, WIP_ENTITY_TYPE, p_WIP_ENTITY_TYPE),
SCHEDULE_ID = decode( p_SCHEDULE_ID, FND_API.G_MISS_NUM, SCHEDULE_ID, p_SCHEDULE_ID),
REPETITIVE_LINE_ID = decode( p_REPETITIVE_LINE_ID, FND_API.G_MISS_NUM, REPETITIVE_LINE_ID, p_REPETITIVE_LINE_ID),
EMPLOYEE_CODE = decode( p_EMPLOYEE_CODE, FND_API.G_MISS_CHAR, EMPLOYEE_CODE, p_EMPLOYEE_CODE),
PRIMARY_SWITCH = decode( p_PRIMARY_SWITCH, FND_API.G_MISS_NUM, PRIMARY_SWITCH, p_PRIMARY_SWITCH),
SCHEDULE_UPDATE_CODE = decode( p_SCHEDULE_UPDATE_CODE, FND_API.G_MISS_NUM, SCHEDULE_UPDATE_CODE, p_SCHEDULE_UPDATE_CODE),
SETUP_TEARDOWN_CODE = decode( p_SETUP_TEARDOWN_CODE, FND_API.G_MISS_NUM, SETUP_TEARDOWN_CODE, p_SETUP_TEARDOWN_CODE),
ITEM_ORDERING = decode( p_ITEM_ORDERING, FND_API.G_MISS_NUM, ITEM_ORDERING, p_ITEM_ORDERING),
NEGATIVE_REQ_FLAG = decode( p_NEGATIVE_REQ_FLAG, FND_API.G_MISS_NUM, NEGATIVE_REQ_FLAG, p_NEGATIVE_REQ_FLAG),
OPERATION_SEQ_NUM = decode( p_OPERATION_SEQ_NUM, FND_API.G_MISS_NUM, OPERATION_SEQ_NUM, p_OPERATION_SEQ_NUM),
PICKING_LINE_ID = decode( p_PICKING_LINE_ID, FND_API.G_MISS_NUM, PICKING_LINE_ID, p_PICKING_LINE_ID),
TRX_SOURCE_LINE_ID = decode( p_TRX_SOURCE_LINE_ID, FND_API.G_MISS_NUM, TRX_SOURCE_LINE_ID, p_TRX_SOURCE_LINE_ID),
TRX_SOURCE_DELIVERY_ID = decode( p_TRX_SOURCE_DELIVERY_ID, FND_API.G_MISS_NUM, TRX_SOURCE_DELIVERY_ID, p_TRX_SOURCE_DELIVERY_ID),
PHYSICAL_ADJUSTMENT_ID = decode( p_PHYSICAL_ADJUSTMENT_ID, FND_API.G_MISS_NUM, PHYSICAL_ADJUSTMENT_ID, p_PHYSICAL_ADJUSTMENT_ID),
CYCLE_COUNT_ID = decode( p_CYCLE_COUNT_ID, FND_API.G_MISS_NUM, CYCLE_COUNT_ID, p_CYCLE_COUNT_ID),
RMA_LINE_ID = decode( p_RMA_LINE_ID, FND_API.G_MISS_NUM, RMA_LINE_ID, p_RMA_LINE_ID),
CUSTOMER_SHIP_ID = decode( p_CUSTOMER_SHIP_ID, FND_API.G_MISS_NUM, CUSTOMER_SHIP_ID, p_CUSTOMER_SHIP_ID),
CURRENCY_CODE = decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR, CURRENCY_CODE, p_CURRENCY_CODE),
CURRENCY_CONVERSION_RATE = decode( p_CURRENCY_CONVERSION_RATE, FND_API.G_MISS_NUM, CURRENCY_CONVERSION_RATE, p_CURRENCY_CONVERSION_RATE),
CURRENCY_CONVERSION_TYPE = decode( p_CURRENCY_CONVERSION_TYPE, FND_API.G_MISS_CHAR, CURRENCY_CONVERSION_TYPE, p_CURRENCY_CONVERSION_TYPE),
CURRENCY_CONVERSION_DATE = decode( p_CURRENCY_CONVERSION_DATE, FND_API.G_MISS_DATE, CURRENCY_CONVERSION_DATE, p_CURRENCY_CONVERSION_DATE),
USSGL_TRANSACTION_CODE = decode( p_USSGL_TRANSACTION_CODE, FND_API.G_MISS_CHAR, USSGL_TRANSACTION_CODE, p_USSGL_TRANSACTION_CODE),
VENDOR_LOT_NUMBER = decode( p_VENDOR_LOT_NUMBER, FND_API.G_MISS_CHAR, VENDOR_LOT_NUMBER, p_VENDOR_LOT_NUMBER),
ENCUMBRANCE_ACCOUNT = decode( p_ENCUMBRANCE_ACCOUNT, FND_API.G_MISS_NUM, ENCUMBRANCE_ACCOUNT, p_ENCUMBRANCE_ACCOUNT),
ENCUMBRANCE_AMOUNT = decode( p_ENCUMBRANCE_AMOUNT, FND_API.G_MISS_NUM, ENCUMBRANCE_AMOUNT, p_ENCUMBRANCE_AMOUNT),
SHIP_TO_LOCATION = decode( p_SHIP_TO_LOCATION, FND_API.G_MISS_NUM, SHIP_TO_LOCATION, p_SHIP_TO_LOCATION),
SHIPMENT_NUMBER = decode( p_SHIPMENT_NUMBER, FND_API.G_MISS_CHAR, SHIPMENT_NUMBER, p_SHIPMENT_NUMBER),
TRANSFER_COST = decode( p_TRANSFER_COST, FND_API.G_MISS_NUM, TRANSFER_COST, p_TRANSFER_COST),
TRANSPORTATION_COST = decode( p_TRANSPORTATION_COST, FND_API.G_MISS_NUM, TRANSPORTATION_COST, p_TRANSPORTATION_COST),
TRANSPORTATION_ACCOUNT = decode( p_TRANSPORTATION_ACCOUNT, FND_API.G_MISS_NUM, TRANSPORTATION_ACCOUNT, p_TRANSPORTATION_ACCOUNT),
FREIGHT_CODE = decode( p_FREIGHT_CODE, FND_API.G_MISS_CHAR, FREIGHT_CODE, p_FREIGHT_CODE),
CONTAINERS = decode( p_CONTAINERS, FND_API.G_MISS_NUM, CONTAINERS, p_CONTAINERS),
WAYBILL_AIRBILL = decode( p_WAYBILL_AIRBILL, FND_API.G_MISS_CHAR, WAYBILL_AIRBILL, p_WAYBILL_AIRBILL),
EXPECTED_ARRIVAL_DATE = decode( p_EXPECTED_ARRIVAL_DATE, FND_API.G_MISS_DATE, EXPECTED_ARRIVAL_DATE, p_EXPECTED_ARRIVAL_DATE),
TRANSFER_SUBINVENTORY = decode( p_TRANSFER_SUBINVENTORY, FND_API.G_MISS_CHAR, TRANSFER_SUBINVENTORY, p_TRANSFER_SUBINVENTORY),
TRANSFER_ORGANIZATION = decode( p_TRANSFER_ORGANIZATION, FND_API.G_MISS_NUM, TRANSFER_ORGANIZATION, p_TRANSFER_ORGANIZATION),
TRANSFER_TO_LOCATION = decode( p_TRANSFER_TO_LOCATION, FND_API.G_MISS_NUM, TRANSFER_TO_LOCATION, p_TRANSFER_TO_LOCATION),
NEW_AVERAGE_COST = decode( p_NEW_AVERAGE_COST, FND_API.G_MISS_NUM, NEW_AVERAGE_COST, p_NEW_AVERAGE_COST),
VALUE_CHANGE = decode( p_VALUE_CHANGE, FND_API.G_MISS_NUM, VALUE_CHANGE, p_VALUE_CHANGE),
PERCENTAGE_CHANGE = decode( p_PERCENTAGE_CHANGE, FND_API.G_MISS_NUM, PERCENTAGE_CHANGE, p_PERCENTAGE_CHANGE),
MATERIAL_ALLOCATION_TEMP_ID = decode( p_MATERIAL_ALLOCATION_TEMP_ID, FND_API.G_MISS_NUM, MATERIAL_ALLOCATION_TEMP_ID, p_MATERIAL_ALLOCATION_TEMP_ID),
DEMAND_SOURCE_HEADER_ID = decode( p_DEMAND_SOURCE_HEADER_ID, FND_API.G_MISS_NUM, DEMAND_SOURCE_HEADER_ID, p_DEMAND_SOURCE_HEADER_ID),
DEMAND_SOURCE_LINE = decode( p_DEMAND_SOURCE_LINE, FND_API.G_MISS_CHAR, DEMAND_SOURCE_LINE, p_DEMAND_SOURCE_LINE),
DEMAND_SOURCE_DELIVERY = decode( p_DEMAND_SOURCE_DELIVERY, FND_API.G_MISS_CHAR, DEMAND_SOURCE_DELIVERY, p_DEMAND_SOURCE_DELIVERY),
ITEM_SEGMENTS = decode( p_ITEM_SEGMENTS, FND_API.G_MISS_CHAR, ITEM_SEGMENTS, p_ITEM_SEGMENTS),
ITEM_DESCRIPTION = decode( p_ITEM_DESCRIPTION, FND_API.G_MISS_CHAR, ITEM_DESCRIPTION, p_ITEM_DESCRIPTION),
ITEM_TRX_ENABLED_FLAG = decode( p_ITEM_TRX_ENABLED_FLAG, FND_API.G_MISS_CHAR, ITEM_TRX_ENABLED_FLAG, p_ITEM_TRX_ENABLED_FLAG),
ITEM_LOCATION_CONTROL_CODE = decode( p_ITEM_LOCATION_CONTROL_CODE, FND_API.G_MISS_NUM, ITEM_LOCATION_CONTROL_CODE, p_ITEM_LOCATION_CONTROL_CODE),
ITEM_RESTRICT_SUBINV_CODE = decode( p_ITEM_RESTRICT_SUBINV_CODE, FND_API.G_MISS_NUM, ITEM_RESTRICT_SUBINV_CODE, p_ITEM_RESTRICT_SUBINV_CODE),
ITEM_RESTRICT_LOCATORS_CODE = decode( p_ITEM_RESTRICT_LOCATORS_CODE, FND_API.G_MISS_NUM, ITEM_RESTRICT_LOCATORS_CODE, p_ITEM_RESTRICT_LOCATORS_CODE),
ITEM_REVISION_QTY_CONTROL_CODE = decode( p_ITEM_REV_QTY_CONTROL_CODE, FND_API.G_MISS_NUM, ITEM_REVISION_QTY_CONTROL_CODE, p_ITEM_REV_QTY_CONTROL_CODE),
ITEM_PRIMARY_UOM_CODE = decode( p_ITEM_PRIMARY_UOM_CODE, FND_API.G_MISS_CHAR, ITEM_PRIMARY_UOM_CODE, p_ITEM_PRIMARY_UOM_CODE),
ITEM_UOM_CLASS = decode( p_ITEM_UOM_CLASS, FND_API.G_MISS_CHAR, ITEM_UOM_CLASS, p_ITEM_UOM_CLASS),
ITEM_SHELF_LIFE_CODE = decode( p_ITEM_SHELF_LIFE_CODE, FND_API.G_MISS_NUM, ITEM_SHELF_LIFE_CODE, p_ITEM_SHELF_LIFE_CODE),
ITEM_SHELF_LIFE_DAYS = decode( p_ITEM_SHELF_LIFE_DAYS, FND_API.G_MISS_NUM, ITEM_SHELF_LIFE_DAYS, p_ITEM_SHELF_LIFE_DAYS),
ITEM_LOT_CONTROL_CODE = decode( p_ITEM_LOT_CONTROL_CODE, FND_API.G_MISS_NUM, ITEM_LOT_CONTROL_CODE, p_ITEM_LOT_CONTROL_CODE),
ITEM_SERIAL_CONTROL_CODE = decode( p_ITEM_SERIAL_CONTROL_CODE, FND_API.G_MISS_NUM, ITEM_SERIAL_CONTROL_CODE, p_ITEM_SERIAL_CONTROL_CODE),
ITEM_INVENTORY_ASSET_FLAG = decode( p_ITEM_INVENTORY_ASSET_FLAG, FND_API.G_MISS_CHAR, ITEM_INVENTORY_ASSET_FLAG, p_ITEM_INVENTORY_ASSET_FLAG),
ALLOWED_UNITS_LOOKUP_CODE = decode( p_ALLOWED_UNITS_LOOKUP_CODE, FND_API.G_MISS_NUM, ALLOWED_UNITS_LOOKUP_CODE, p_ALLOWED_UNITS_LOOKUP_CODE),
DEPARTMENT_ID = decode( p_DEPARTMENT_ID, FND_API.G_MISS_NUM, DEPARTMENT_ID, p_DEPARTMENT_ID),
DEPARTMENT_CODE = decode( p_DEPARTMENT_CODE, FND_API.G_MISS_CHAR, DEPARTMENT_CODE, p_DEPARTMENT_CODE),
WIP_SUPPLY_TYPE = decode( p_WIP_SUPPLY_TYPE, FND_API.G_MISS_NUM, WIP_SUPPLY_TYPE, p_WIP_SUPPLY_TYPE),
SUPPLY_SUBINVENTORY = decode( p_SUPPLY_SUBINVENTORY, FND_API.G_MISS_CHAR, SUPPLY_SUBINVENTORY, p_SUPPLY_SUBINVENTORY),
SUPPLY_LOCATOR_ID = decode( p_SUPPLY_LOCATOR_ID, FND_API.G_MISS_NUM, SUPPLY_LOCATOR_ID, p_SUPPLY_LOCATOR_ID),
VALID_SUBINVENTORY_FLAG = decode( p_VALID_SUBINVENTORY_FLAG, FND_API.G_MISS_CHAR, VALID_SUBINVENTORY_FLAG, p_VALID_SUBINVENTORY_FLAG),
VALID_LOCATOR_FLAG = decode( p_VALID_LOCATOR_FLAG, FND_API.G_MISS_CHAR, VALID_LOCATOR_FLAG, p_VALID_LOCATOR_FLAG),
LOCATOR_SEGMENTS = decode( p_LOCATOR_SEGMENTS, FND_API.G_MISS_CHAR, LOCATOR_SEGMENTS, p_LOCATOR_SEGMENTS),
CURRENT_LOCATOR_CONTROL_CODE = decode( p_CURRENT_LOCATOR_CONTROL_CODE, FND_API.G_MISS_NUM, CURRENT_LOCATOR_CONTROL_CODE, p_CURRENT_LOCATOR_CONTROL_CODE),
NUMBER_OF_LOTS_ENTERED = decode( p_NUMBER_OF_LOTS_ENTERED, FND_API.G_MISS_NUM, NUMBER_OF_LOTS_ENTERED, p_NUMBER_OF_LOTS_ENTERED),
WIP_COMMIT_FLAG = decode( p_WIP_COMMIT_FLAG, FND_API.G_MISS_CHAR, WIP_COMMIT_FLAG, p_WIP_COMMIT_FLAG),
NEXT_LOT_NUMBER = decode( p_NEXT_LOT_NUMBER, FND_API.G_MISS_CHAR, NEXT_LOT_NUMBER, p_NEXT_LOT_NUMBER),
LOT_ALPHA_PREFIX = decode( p_LOT_ALPHA_PREFIX, FND_API.G_MISS_CHAR, LOT_ALPHA_PREFIX, p_LOT_ALPHA_PREFIX),
NEXT_SERIAL_NUMBER = decode( p_NEXT_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NEXT_SERIAL_NUMBER, p_NEXT_SERIAL_NUMBER),
SERIAL_ALPHA_PREFIX = decode( p_SERIAL_ALPHA_PREFIX, FND_API.G_MISS_CHAR, SERIAL_ALPHA_PREFIX, p_SERIAL_ALPHA_PREFIX),
SHIPPABLE_FLAG = decode( p_SHIPPABLE_FLAG, FND_API.G_MISS_CHAR, SHIPPABLE_FLAG, p_SHIPPABLE_FLAG),
POSTING_FLAG = decode( p_POSTING_FLAG, FND_API.G_MISS_CHAR, POSTING_FLAG, p_POSTING_FLAG),
REQUIRED_FLAG = decode( p_REQUIRED_FLAG, FND_API.G_MISS_CHAR, REQUIRED_FLAG, p_REQUIRED_FLAG),
PROCESS_FLAG = decode( p_PROCESS_FLAG, FND_API.G_MISS_CHAR, PROCESS_FLAG, p_PROCESS_FLAG),
ERROR_CODE = decode( p_ERROR_CODE, FND_API.G_MISS_CHAR, ERROR_CODE, p_ERROR_CODE),
ERROR_EXPLANATION = decode( p_ERROR_EXPLANATION, FND_API.G_MISS_CHAR, ERROR_EXPLANATION, p_ERROR_EXPLANATION),
ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
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),
MOVEMENT_ID = decode( p_MOVEMENT_ID, FND_API.G_MISS_NUM, MOVEMENT_ID, p_MOVEMENT_ID),
RESERVATION_QUANTITY = decode( p_RESERVATION_QUANTITY, FND_API.G_MISS_NUM, RESERVATION_QUANTITY, p_RESERVATION_QUANTITY),
SHIPPED_QUANTITY = decode( p_SHIPPED_QUANTITY, FND_API.G_MISS_NUM, SHIPPED_QUANTITY, p_SHIPPED_QUANTITY),
TRANSACTION_LINE_NUMBER = decode( p_TRANSACTION_LINE_NUMBER, FND_API.G_MISS_NUM, TRANSACTION_LINE_NUMBER, p_TRANSACTION_LINE_NUMBER),
TASK_ID = decode( p_TASK_ID, FND_API.G_MISS_NUM, TASK_ID, p_TASK_ID),
TO_TASK_ID = decode( p_TO_TASK_ID, FND_API.G_MISS_NUM, TO_TASK_ID, p_TO_TASK_ID),
SOURCE_TASK_ID = decode( p_SOURCE_TASK_ID, FND_API.G_MISS_NUM, SOURCE_TASK_ID, p_SOURCE_TASK_ID),
PROJECT_ID = decode( p_PROJECT_ID, FND_API.G_MISS_NUM, PROJECT_ID, p_PROJECT_ID),
SOURCE_PROJECT_ID = decode( p_SOURCE_PROJECT_ID, FND_API.G_MISS_NUM, SOURCE_PROJECT_ID, p_SOURCE_PROJECT_ID),
PA_EXPENDITURE_ORG_ID = decode( p_PA_EXPENDITURE_ORG_ID, FND_API.G_MISS_NUM, PA_EXPENDITURE_ORG_ID, p_PA_EXPENDITURE_ORG_ID),
TO_PROJECT_ID = decode( p_TO_PROJECT_ID, FND_API.G_MISS_NUM, TO_PROJECT_ID, p_TO_PROJECT_ID),
EXPENDITURE_TYPE = decode( p_EXPENDITURE_TYPE, FND_API.G_MISS_CHAR, EXPENDITURE_TYPE, p_EXPENDITURE_TYPE),
FINAL_COMPLETION_FLAG = decode( p_FINAL_COMPLETION_FLAG, FND_API.G_MISS_CHAR, FINAL_COMPLETION_FLAG, p_FINAL_COMPLETION_FLAG),
TRANSFER_PERCENTAGE = decode( p_TRANSFER_PERCENTAGE, FND_API.G_MISS_NUM, TRANSFER_PERCENTAGE, p_TRANSFER_PERCENTAGE),
TRANSACTION_SEQUENCE_ID = decode( p_TRANSACTION_SEQUENCE_ID, FND_API.G_MISS_NUM, TRANSACTION_SEQUENCE_ID, p_TRANSACTION_SEQUENCE_ID),
MATERIAL_ACCOUNT = decode( p_MATERIAL_ACCOUNT, FND_API.G_MISS_NUM, MATERIAL_ACCOUNT, p_MATERIAL_ACCOUNT),
MATERIAL_OVERHEAD_ACCOUNT = decode( p_MATERIAL_OVERHEAD_ACCOUNT, FND_API.G_MISS_NUM, MATERIAL_OVERHEAD_ACCOUNT, p_MATERIAL_OVERHEAD_ACCOUNT),
RESOURCE_ACCOUNT = decode( p_RESOURCE_ACCOUNT, FND_API.G_MISS_NUM, RESOURCE_ACCOUNT, p_RESOURCE_ACCOUNT),
OUTSIDE_PROCESSING_ACCOUNT = decode( p_OUTSIDE_PROCESSING_ACCOUNT, FND_API.G_MISS_NUM, OUTSIDE_PROCESSING_ACCOUNT, p_OUTSIDE_PROCESSING_ACCOUNT),
OVERHEAD_ACCOUNT = decode( p_OVERHEAD_ACCOUNT, FND_API.G_MISS_NUM, OVERHEAD_ACCOUNT, p_OVERHEAD_ACCOUNT),
FLOW_SCHEDULE = decode( p_FLOW_SCHEDULE, FND_API.G_MISS_CHAR, FLOW_SCHEDULE, p_FLOW_SCHEDULE),
COST_GROUP_ID = decode( p_COST_GROUP_ID, FND_API.G_MISS_NUM, COST_GROUP_ID, p_COST_GROUP_ID),
DEMAND_CLASS = decode( p_DEMAND_CLASS, FND_API.G_MISS_CHAR, DEMAND_CLASS, p_DEMAND_CLASS),
QA_COLLECTION_ID = decode( p_QA_COLLECTION_ID, FND_API.G_MISS_NUM, QA_COLLECTION_ID, p_QA_COLLECTION_ID),
KANBAN_CARD_ID = decode( p_KANBAN_CARD_ID, FND_API.G_MISS_NUM, KANBAN_CARD_ID, p_KANBAN_CARD_ID),
OVERCOMPLETION_TRANSACTION_ID = decode( p_OVERCOMPLETION_TXN_ID, FND_API.G_MISS_NUM, OVERCOMPLETION_TRANSACTION_ID, p_OVERCOMPLETION_TXN_ID),
OVERCOMPLETION_PRIMARY_QTY = decode( p_OVERCOMPLETION_PRIMARY_QTY, FND_API.G_MISS_NUM, OVERCOMPLETION_PRIMARY_QTY, p_OVERCOMPLETION_PRIMARY_QTY),
OVERCOMPLETION_TRANSACTION_QTY = decode( p_OVERCOMPLETION_TXN_QTY, FND_API.G_MISS_NUM, OVERCOMPLETION_TRANSACTION_QTY, p_OVERCOMPLETION_TXN_QTY),
-- PROCESS_TYPE = decode( p_PROCESS_TYPE, FND_API.G_MISS_NUM, PROCESS_TYPE, p_PROCESS_TYPE),
END_ITEM_UNIT_NUMBER = decode( p_END_ITEM_UNIT_NUMBER, FND_API.G_MISS_CHAR, END_ITEM_UNIT_NUMBER, p_END_ITEM_UNIT_NUMBER),
SCHEDULED_PAYBACK_DATE = decode( p_SCHEDULED_PAYBACK_DATE, FND_API.G_MISS_DATE, SCHEDULED_PAYBACK_DATE, p_SCHEDULED_PAYBACK_DATE),
LINE_TYPE_CODE = decode( p_LINE_TYPE_CODE, FND_API.G_MISS_NUM, LINE_TYPE_CODE, p_LINE_TYPE_CODE),
PARENT_TRANSACTION_TEMP_ID = decode( p_PARENT_TRANSACTION_TEMP_ID, FND_API.G_MISS_NUM, PARENT_TRANSACTION_TEMP_ID, p_PARENT_TRANSACTION_TEMP_ID),
PUT_AWAY_STRATEGY_ID = decode( p_PUT_AWAY_STRATEGY_ID, FND_API.G_MISS_NUM, PUT_AWAY_STRATEGY_ID, p_PUT_AWAY_STRATEGY_ID),
PUT_AWAY_RULE_ID = decode( p_PUT_AWAY_RULE_ID, FND_API.G_MISS_NUM, PUT_AWAY_RULE_ID, p_PUT_AWAY_RULE_ID),
PICK_STRATEGY_ID = decode( p_PICK_STRATEGY_ID, FND_API.G_MISS_NUM, PICK_STRATEGY_ID, p_PICK_STRATEGY_ID),
PICK_RULE_ID = decode( p_PICK_RULE_ID, FND_API.G_MISS_NUM, PICK_RULE_ID, p_PICK_RULE_ID),
COMMON_BOM_SEQ_ID = decode( p_COMMON_BOM_SEQ_ID, FND_API.G_MISS_NUM, COMMON_BOM_SEQ_ID, p_COMMON_BOM_SEQ_ID),
COMMON_ROUTING_SEQ_ID = decode( p_COMMON_ROUTING_SEQ_ID, FND_API.G_MISS_NUM, COMMON_ROUTING_SEQ_ID, p_COMMON_ROUTING_SEQ_ID),
COST_TYPE_ID = decode( p_COST_TYPE_ID, FND_API.G_MISS_NUM, COST_TYPE_ID, p_COST_TYPE_ID),
ORG_COST_GROUP_ID = decode( p_ORG_COST_GROUP_ID, FND_API.G_MISS_NUM, ORG_COST_GROUP_ID, p_ORG_COST_GROUP_ID),
MOVE_ORDER_LINE_ID = decode( p_MOVE_ORDER_LINE_ID, FND_API.G_MISS_NUM, MOVE_ORDER_LINE_ID, p_MOVE_ORDER_LINE_ID),
TASK_GROUP_ID = decode( p_TASK_GROUP_ID, FND_API.G_MISS_NUM, TASK_GROUP_ID, p_TASK_GROUP_ID),
PICK_SLIP_NUMBER = decode( p_PICK_SLIP_NUMBER, FND_API.G_MISS_NUM, PICK_SLIP_NUMBER, p_PICK_SLIP_NUMBER),
RESERVATION_ID = decode( p_RESERVATION_ID, FND_API.G_MISS_NUM, RESERVATION_ID, p_RESERVATION_ID),
TRANSACTION_STATUS = decode( p_TRANSACTION_STATUS, FND_API.G_MISS_NUM, TRANSACTION_STATUS, p_TRANSACTION_STATUS),
STANDARD_OPERATION_ID = decode( p_STANDARD_OPERATION_ID, FND_API.G_MISS_NUM, STANDARD_OPERATION_ID, p_STANDARD_OPERATION_ID),
TASK_PRIORITY = decode( p_TASK_PRIORITY, FND_API.G_MISS_NUM, TASK_PRIORITY, p_TASK_PRIORITY),
WMS_TASK_TYPE = decode( p_WMS_TASK_TYPE, FND_API.G_MISS_NUM, WMS_TASK_TYPE, p_WMS_TASK_TYPE),
PARENT_LINE_ID = decode( p_PARENT_LINE_ID, FND_API.G_MISS_NUM, PARENT_LINE_ID, p_PARENT_LINE_ID)
-- SOURCE_LOT_NUMBER = decode( P_SOURCE_LOT_NUMBER, FND_API.G_MISS_NUM, SOURCE_LOT_NUMBER, p_SOURCE_LOT_NUMBER)
where TRANSACTION_TEMP_ID = p_TRANSACTION_TEMP_ID;
END Update_Row;
PROCEDURE Delete_Row(
p_TRANSACTION_TEMP_ID NUMBER)
IS
BEGIN
DELETE FROM MTL_MATERIAL_TRANSACTIONS_TEMP
WHERE TRANSACTION_TEMP_ID = p_TRANSACTION_TEMP_ID;
END Delete_Row;
p_LAST_UPDATE_DATE DATE,
p_LAST_UPDATED_BY NUMBER,
p_CREATION_DATE DATE,
p_CREATED_BY NUMBER,
p_LAST_UPDATE_LOGIN NUMBER,
p_REQUEST_ID NUMBER,
p_PROGRAM_APPLICATION_ID NUMBER,
p_PROGRAM_ID NUMBER,
p_PROGRAM_UPDATE_DATE DATE,
p_INVENTORY_ITEM_ID NUMBER,
p_REVISION VARCHAR2,
p_ORGANIZATION_ID NUMBER,
p_SUBINVENTORY_CODE VARCHAR2,
p_LOCATOR_ID NUMBER,
p_TRANSACTION_QUANTITY NUMBER,
p_PRIMARY_QUANTITY NUMBER,
p_TRANSACTION_UOM VARCHAR2,
p_TRANSACTION_COST NUMBER,
p_TRANSACTION_TYPE_ID NUMBER,
p_TRANSACTION_ACTION_ID NUMBER,
p_TRANSACTION_SOURCE_TYPE_ID NUMBER,
p_TRANSACTION_SOURCE_ID NUMBER,
p_TRANSACTION_SOURCE_NAME VARCHAR2,
p_TRANSACTION_DATE DATE,
p_ACCT_PERIOD_ID NUMBER,
p_DISTRIBUTION_ACCOUNT_ID NUMBER,
p_TRANSACTION_REFERENCE VARCHAR2,
p_REQUISITION_LINE_ID NUMBER,
p_REQUISITION_DISTRIBUTION_ID NUMBER,
p_REASON_ID NUMBER,
p_LOT_NUMBER VARCHAR2,
p_LOT_EXPIRATION_DATE DATE,
p_SERIAL_NUMBER VARCHAR2,
p_RECEIVING_DOCUMENT VARCHAR2,
p_DEMAND_ID NUMBER,
p_RCV_TRANSACTION_ID NUMBER,
p_MOVE_TRANSACTION_ID NUMBER,
p_COMPLETION_TRANSACTION_ID NUMBER,
p_WIP_ENTITY_TYPE NUMBER,
p_SCHEDULE_ID NUMBER,
p_REPETITIVE_LINE_ID NUMBER,
p_EMPLOYEE_CODE VARCHAR2,
p_PRIMARY_SWITCH NUMBER,
p_SCHEDULE_UPDATE_CODE NUMBER,
p_SETUP_TEARDOWN_CODE NUMBER,
p_ITEM_ORDERING NUMBER,
p_NEGATIVE_REQ_FLAG NUMBER,
p_OPERATION_SEQ_NUM NUMBER,
p_PICKING_LINE_ID NUMBER,
p_TRX_SOURCE_LINE_ID NUMBER,
p_TRX_SOURCE_DELIVERY_ID NUMBER,
p_PHYSICAL_ADJUSTMENT_ID NUMBER,
p_CYCLE_COUNT_ID NUMBER,
p_RMA_LINE_ID NUMBER,
p_CUSTOMER_SHIP_ID NUMBER,
p_CURRENCY_CODE VARCHAR2,
p_CURRENCY_CONVERSION_RATE NUMBER,
p_CURRENCY_CONVERSION_TYPE VARCHAR2,
p_CURRENCY_CONVERSION_DATE DATE,
p_USSGL_TRANSACTION_CODE VARCHAR2,
p_VENDOR_LOT_NUMBER VARCHAR2,
p_ENCUMBRANCE_ACCOUNT NUMBER,
p_ENCUMBRANCE_AMOUNT NUMBER,
p_SHIP_TO_LOCATION NUMBER,
p_SHIPMENT_NUMBER VARCHAR2,
p_TRANSFER_COST NUMBER,
p_TRANSPORTATION_COST NUMBER,
p_TRANSPORTATION_ACCOUNT NUMBER,
p_FREIGHT_CODE VARCHAR2,
p_CONTAINERS NUMBER,
p_WAYBILL_AIRBILL VARCHAR2,
p_EXPECTED_ARRIVAL_DATE DATE,
p_TRANSFER_SUBINVENTORY VARCHAR2,
p_TRANSFER_ORGANIZATION NUMBER,
p_TRANSFER_TO_LOCATION NUMBER,
p_NEW_AVERAGE_COST NUMBER,
p_VALUE_CHANGE NUMBER,
p_PERCENTAGE_CHANGE NUMBER,
p_MATERIAL_ALLOCATION_TEMP_ID NUMBER,
p_DEMAND_SOURCE_HEADER_ID NUMBER,
p_DEMAND_SOURCE_LINE VARCHAR2,
p_DEMAND_SOURCE_DELIVERY VARCHAR2,
p_ITEM_SEGMENTS VARCHAR2,
p_ITEM_DESCRIPTION VARCHAR2,
p_ITEM_TRX_ENABLED_FLAG VARCHAR2,
p_ITEM_LOCATION_CONTROL_CODE NUMBER,
p_ITEM_RESTRICT_SUBINV_CODE NUMBER,
p_ITEM_RESTRICT_LOCATORS_CODE NUMBER,
p_ITEM_REV_QTY_CONTROL_CODE NUMBER,
p_ITEM_PRIMARY_UOM_CODE VARCHAR2,
p_ITEM_UOM_CLASS VARCHAR2,
p_ITEM_SHELF_LIFE_CODE NUMBER,
p_ITEM_SHELF_LIFE_DAYS NUMBER,
p_ITEM_LOT_CONTROL_CODE NUMBER,
p_ITEM_SERIAL_CONTROL_CODE NUMBER,
p_ITEM_INVENTORY_ASSET_FLAG VARCHAR2,
p_ALLOWED_UNITS_LOOKUP_CODE NUMBER,
p_DEPARTMENT_ID NUMBER,
p_DEPARTMENT_CODE VARCHAR2,
p_WIP_SUPPLY_TYPE NUMBER,
p_SUPPLY_SUBINVENTORY VARCHAR2,
p_SUPPLY_LOCATOR_ID NUMBER,
p_VALID_SUBINVENTORY_FLAG VARCHAR2,
p_VALID_LOCATOR_FLAG VARCHAR2,
p_LOCATOR_SEGMENTS VARCHAR2,
p_CURRENT_LOCATOR_CONTROL_CODE NUMBER,
p_NUMBER_OF_LOTS_ENTERED NUMBER,
p_WIP_COMMIT_FLAG VARCHAR2,
p_NEXT_LOT_NUMBER VARCHAR2,
p_LOT_ALPHA_PREFIX VARCHAR2,
p_NEXT_SERIAL_NUMBER VARCHAR2,
p_SERIAL_ALPHA_PREFIX VARCHAR2,
p_SHIPPABLE_FLAG VARCHAR2,
p_POSTING_FLAG VARCHAR2,
p_REQUIRED_FLAG VARCHAR2,
p_PROCESS_FLAG VARCHAR2,
p_ERROR_CODE VARCHAR2,
p_ERROR_EXPLANATION VARCHAR2,
p_ATTRIBUTE_CATEGORY 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_MOVEMENT_ID NUMBER,
p_RESERVATION_QUANTITY NUMBER,
p_SHIPPED_QUANTITY NUMBER,
p_TRANSACTION_LINE_NUMBER NUMBER,
p_TASK_ID NUMBER,
p_TO_TASK_ID NUMBER,
p_SOURCE_TASK_ID NUMBER,
p_PROJECT_ID NUMBER,
p_SOURCE_PROJECT_ID NUMBER,
p_PA_EXPENDITURE_ORG_ID NUMBER,
p_TO_PROJECT_ID NUMBER,
p_EXPENDITURE_TYPE VARCHAR2,
p_FINAL_COMPLETION_FLAG VARCHAR2,
p_TRANSFER_PERCENTAGE NUMBER,
p_TRANSACTION_SEQUENCE_ID NUMBER,
p_MATERIAL_ACCOUNT NUMBER,
p_MATERIAL_OVERHEAD_ACCOUNT NUMBER,
p_RESOURCE_ACCOUNT NUMBER,
p_OUTSIDE_PROCESSING_ACCOUNT NUMBER,
p_OVERHEAD_ACCOUNT NUMBER,
p_FLOW_SCHEDULE VARCHAR2,
p_COST_GROUP_ID NUMBER,
p_DEMAND_CLASS VARCHAR2,
p_QA_COLLECTION_ID NUMBER,
p_KANBAN_CARD_ID NUMBER,
p_OVERCOMPLETION_TXN_ID NUMBER,
p_OVERCOMPLETION_PRIMARY_QTY NUMBER,
p_OVERCOMPLETION_TXN_QTY NUMBER,
-- p_PROCESS_TYPE NUMBER,
p_END_ITEM_UNIT_NUMBER VARCHAR2,
p_SCHEDULED_PAYBACK_DATE DATE,
p_LINE_TYPE_CODE NUMBER,
p_PARENT_TRANSACTION_TEMP_ID NUMBER,
p_PUT_AWAY_STRATEGY_ID NUMBER,
p_PUT_AWAY_RULE_ID NUMBER,
p_PICK_STRATEGY_ID NUMBER,
p_PICK_RULE_ID NUMBER,
p_COMMON_BOM_SEQ_ID NUMBER,
p_COMMON_ROUTING_SEQ_ID NUMBER,
p_COST_TYPE_ID NUMBER,
p_ORG_COST_GROUP_ID NUMBER,
p_MOVE_ORDER_LINE_ID NUMBER,
p_TASK_GROUP_ID NUMBER,
p_PICK_SLIP_NUMBER NUMBER,
p_RESERVATION_ID NUMBER,
p_TRANSACTION_STATUS NUMBER,
P_STANDARD_OPERATION_ID NUMBER,
P_TASK_PRIORITY NUMBER,
p_WMS_TASK_TYPE NUMBER,
p_PARENT_LINE_ID NUMBER)
-- P_SOURCE_LOT_NUMBER NUMBER)
IS
CURSOR C IS
SELECT *
FROM MTL_MATERIAL_TRANSACTIONS_TEMP
WHERE TRANSACTION_TEMP_ID = p_TRANSACTION_TEMP_ID
FOR UPDATE of TRANSACTION_TEMP_ID NOWAIT;
FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
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_UPDATED_BY = p_LAST_UPDATED_BY)
OR ( ( Recinfo.LAST_UPDATED_BY IS NULL )
AND ( p_LAST_UPDATED_BY IS NULL )))
AND ( ( Recinfo.CREATION_DATE = p_CREATION_DATE)
OR ( ( Recinfo.CREATION_DATE IS NULL )
AND ( p_CREATION_DATE IS NULL )))
AND ( ( Recinfo.CREATED_BY = p_CREATED_BY)
OR ( ( Recinfo.CREATED_BY IS NULL )
AND ( p_CREATED_BY 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.REQUEST_ID = p_REQUEST_ID)
OR ( ( Recinfo.REQUEST_ID IS NULL )
AND ( p_REQUEST_ID IS NULL )))
AND ( ( Recinfo.PROGRAM_APPLICATION_ID = p_PROGRAM_APPLICATION_ID)
OR ( ( Recinfo.PROGRAM_APPLICATION_ID IS NULL )
AND ( p_PROGRAM_APPLICATION_ID IS NULL )))
AND ( ( Recinfo.PROGRAM_ID = p_PROGRAM_ID)
OR ( ( Recinfo.PROGRAM_ID IS NULL )
AND ( p_PROGRAM_ID IS NULL )))
AND ( ( Recinfo.PROGRAM_UPDATE_DATE = p_PROGRAM_UPDATE_DATE)
OR ( ( Recinfo.PROGRAM_UPDATE_DATE IS NULL )
AND ( p_PROGRAM_UPDATE_DATE IS NULL )))
AND ( ( Recinfo.INVENTORY_ITEM_ID = p_INVENTORY_ITEM_ID)
OR ( ( Recinfo.INVENTORY_ITEM_ID IS NULL )
AND ( p_INVENTORY_ITEM_ID IS NULL )))
AND ( ( Recinfo.REVISION = p_REVISION)
OR ( ( Recinfo.REVISION IS NULL )
AND ( p_REVISION IS NULL )))
AND ( ( Recinfo.ORGANIZATION_ID = p_ORGANIZATION_ID)
OR ( ( Recinfo.ORGANIZATION_ID IS NULL )
AND ( p_ORGANIZATION_ID IS NULL )))
AND ( ( Recinfo.SUBINVENTORY_CODE = p_SUBINVENTORY_CODE)
OR ( ( Recinfo.SUBINVENTORY_CODE IS NULL )
AND ( p_SUBINVENTORY_CODE IS NULL )))
AND ( ( Recinfo.LOCATOR_ID = p_LOCATOR_ID)
OR ( ( Recinfo.LOCATOR_ID IS NULL )
AND ( p_LOCATOR_ID IS NULL )))
AND ( ( Recinfo.TRANSACTION_QUANTITY = p_TRANSACTION_QUANTITY)
OR ( ( Recinfo.TRANSACTION_QUANTITY IS NULL )
AND ( p_TRANSACTION_QUANTITY IS NULL )))
AND ( ( Recinfo.PRIMARY_QUANTITY = p_PRIMARY_QUANTITY)
OR ( ( Recinfo.PRIMARY_QUANTITY IS NULL )
AND ( p_PRIMARY_QUANTITY IS NULL )))
AND ( ( Recinfo.TRANSACTION_UOM = p_TRANSACTION_UOM)
OR ( ( Recinfo.TRANSACTION_UOM IS NULL )
AND ( p_TRANSACTION_UOM IS NULL )))
AND ( ( Recinfo.TRANSACTION_COST = p_TRANSACTION_COST)
OR ( ( Recinfo.TRANSACTION_COST IS NULL )
AND ( p_TRANSACTION_COST IS NULL )))
AND ( ( Recinfo.TRANSACTION_TYPE_ID = p_TRANSACTION_TYPE_ID)
OR ( ( Recinfo.TRANSACTION_TYPE_ID IS NULL )
AND ( p_TRANSACTION_TYPE_ID IS NULL )))
AND ( ( Recinfo.TRANSACTION_ACTION_ID = p_TRANSACTION_ACTION_ID)
OR ( ( Recinfo.TRANSACTION_ACTION_ID IS NULL )
AND ( p_TRANSACTION_ACTION_ID IS NULL )))
AND ( ( Recinfo.TRANSACTION_SOURCE_TYPE_ID = p_TRANSACTION_SOURCE_TYPE_ID)
OR ( ( Recinfo.TRANSACTION_SOURCE_TYPE_ID IS NULL )
AND ( p_TRANSACTION_SOURCE_TYPE_ID IS NULL )))
AND ( ( Recinfo.TRANSACTION_SOURCE_ID = p_TRANSACTION_SOURCE_ID)
OR ( ( Recinfo.TRANSACTION_SOURCE_ID IS NULL )
AND ( p_TRANSACTION_SOURCE_ID IS NULL )))
AND ( ( Recinfo.TRANSACTION_SOURCE_NAME = p_TRANSACTION_SOURCE_NAME)
OR ( ( Recinfo.TRANSACTION_SOURCE_NAME IS NULL )
AND ( p_TRANSACTION_SOURCE_NAME IS NULL )))
AND ( ( Recinfo.TRANSACTION_DATE = p_TRANSACTION_DATE)
OR ( ( Recinfo.TRANSACTION_DATE IS NULL )
AND ( p_TRANSACTION_DATE IS NULL )))
AND ( ( Recinfo.ACCT_PERIOD_ID = p_ACCT_PERIOD_ID)
OR ( ( Recinfo.ACCT_PERIOD_ID IS NULL )
AND ( p_ACCT_PERIOD_ID IS NULL )))
AND ( ( Recinfo.DISTRIBUTION_ACCOUNT_ID = p_DISTRIBUTION_ACCOUNT_ID)
OR ( ( Recinfo.DISTRIBUTION_ACCOUNT_ID IS NULL )
AND ( p_DISTRIBUTION_ACCOUNT_ID IS NULL )))
AND ( ( Recinfo.TRANSACTION_REFERENCE = p_TRANSACTION_REFERENCE)
OR ( ( Recinfo.TRANSACTION_REFERENCE IS NULL )
AND ( p_TRANSACTION_REFERENCE IS NULL )))
AND ( ( Recinfo.REQUISITION_LINE_ID = p_REQUISITION_LINE_ID)
OR ( ( Recinfo.REQUISITION_LINE_ID IS NULL )
AND ( p_REQUISITION_LINE_ID IS NULL )))
AND ( ( Recinfo.REQUISITION_DISTRIBUTION_ID = p_REQUISITION_DISTRIBUTION_ID)
OR ( ( Recinfo.REQUISITION_DISTRIBUTION_ID IS NULL )
AND ( p_REQUISITION_DISTRIBUTION_ID IS NULL )))
AND ( ( Recinfo.REASON_ID = p_REASON_ID)
OR ( ( Recinfo.REASON_ID IS NULL )
AND ( p_REASON_ID IS NULL )))
AND ( ( Recinfo.LOT_NUMBER = p_LOT_NUMBER)
OR ( ( Recinfo.LOT_NUMBER IS NULL )
AND ( p_LOT_NUMBER IS NULL )))
AND ( ( Recinfo.LOT_EXPIRATION_DATE = p_LOT_EXPIRATION_DATE)
OR ( ( Recinfo.LOT_EXPIRATION_DATE IS NULL )
AND ( p_LOT_EXPIRATION_DATE IS NULL )))
AND ( ( Recinfo.SERIAL_NUMBER = p_SERIAL_NUMBER)
OR ( ( Recinfo.SERIAL_NUMBER IS NULL )
AND ( p_SERIAL_NUMBER IS NULL )))
AND ( ( Recinfo.RECEIVING_DOCUMENT = p_RECEIVING_DOCUMENT)
OR ( ( Recinfo.RECEIVING_DOCUMENT IS NULL )
AND ( p_RECEIVING_DOCUMENT IS NULL )))
AND ( ( Recinfo.DEMAND_ID = p_DEMAND_ID)
OR ( ( Recinfo.DEMAND_ID IS NULL )
AND ( p_DEMAND_ID IS NULL )))
AND ( ( Recinfo.RCV_TRANSACTION_ID = p_RCV_TRANSACTION_ID)
OR ( ( Recinfo.RCV_TRANSACTION_ID IS NULL )
AND ( p_RCV_TRANSACTION_ID IS NULL )))
AND ( ( Recinfo.MOVE_TRANSACTION_ID = p_MOVE_TRANSACTION_ID)
OR ( ( Recinfo.MOVE_TRANSACTION_ID IS NULL )
AND ( p_MOVE_TRANSACTION_ID IS NULL )))
AND ( ( Recinfo.COMPLETION_TRANSACTION_ID = p_COMPLETION_TRANSACTION_ID)
OR ( ( Recinfo.COMPLETION_TRANSACTION_ID IS NULL )
AND ( p_COMPLETION_TRANSACTION_ID IS NULL )))
AND ( ( Recinfo.WIP_ENTITY_TYPE = p_WIP_ENTITY_TYPE)
OR ( ( Recinfo.WIP_ENTITY_TYPE IS NULL )
AND ( p_WIP_ENTITY_TYPE IS NULL )))
AND ( ( Recinfo.SCHEDULE_ID = p_SCHEDULE_ID)
OR ( ( Recinfo.SCHEDULE_ID IS NULL )
AND ( p_SCHEDULE_ID IS NULL )))
AND ( ( Recinfo.REPETITIVE_LINE_ID = p_REPETITIVE_LINE_ID)
OR ( ( Recinfo.REPETITIVE_LINE_ID IS NULL )
AND ( p_REPETITIVE_LINE_ID IS NULL )))
AND ( ( Recinfo.EMPLOYEE_CODE = p_EMPLOYEE_CODE)
OR ( ( Recinfo.EMPLOYEE_CODE IS NULL )
AND ( p_EMPLOYEE_CODE IS NULL )))
AND ( ( Recinfo.PRIMARY_SWITCH = p_PRIMARY_SWITCH)
OR ( ( Recinfo.PRIMARY_SWITCH IS NULL )
AND ( p_PRIMARY_SWITCH IS NULL )))
AND ( ( Recinfo.SCHEDULE_UPDATE_CODE = p_SCHEDULE_UPDATE_CODE)
OR ( ( Recinfo.SCHEDULE_UPDATE_CODE IS NULL )
AND ( p_SCHEDULE_UPDATE_CODE IS NULL )))
AND ( ( Recinfo.SETUP_TEARDOWN_CODE = p_SETUP_TEARDOWN_CODE)
OR ( ( Recinfo.SETUP_TEARDOWN_CODE IS NULL )
AND ( p_SETUP_TEARDOWN_CODE IS NULL )))
AND ( ( Recinfo.ITEM_ORDERING = p_ITEM_ORDERING)
OR ( ( Recinfo.ITEM_ORDERING IS NULL )
AND ( p_ITEM_ORDERING IS NULL )))
AND ( ( Recinfo.NEGATIVE_REQ_FLAG = p_NEGATIVE_REQ_FLAG)
OR ( ( Recinfo.NEGATIVE_REQ_FLAG IS NULL )
AND ( p_NEGATIVE_REQ_FLAG IS NULL )))
AND ( ( Recinfo.OPERATION_SEQ_NUM = p_OPERATION_SEQ_NUM)
OR ( ( Recinfo.OPERATION_SEQ_NUM IS NULL )
AND ( p_OPERATION_SEQ_NUM IS NULL )))
AND ( ( Recinfo.PICKING_LINE_ID = p_PICKING_LINE_ID)
OR ( ( Recinfo.PICKING_LINE_ID IS NULL )
AND ( p_PICKING_LINE_ID IS NULL )))
AND ( ( Recinfo.TRX_SOURCE_LINE_ID = p_TRX_SOURCE_LINE_ID)
OR ( ( Recinfo.TRX_SOURCE_LINE_ID IS NULL )
AND ( p_TRX_SOURCE_LINE_ID IS NULL )))
AND ( ( Recinfo.TRX_SOURCE_DELIVERY_ID = p_TRX_SOURCE_DELIVERY_ID)
OR ( ( Recinfo.TRX_SOURCE_DELIVERY_ID IS NULL )
AND ( p_TRX_SOURCE_DELIVERY_ID IS NULL )))
AND ( ( Recinfo.PHYSICAL_ADJUSTMENT_ID = p_PHYSICAL_ADJUSTMENT_ID)
OR ( ( Recinfo.PHYSICAL_ADJUSTMENT_ID IS NULL )
AND ( p_PHYSICAL_ADJUSTMENT_ID IS NULL )))
AND ( ( Recinfo.CYCLE_COUNT_ID = p_CYCLE_COUNT_ID)
OR ( ( Recinfo.CYCLE_COUNT_ID IS NULL )
AND ( p_CYCLE_COUNT_ID IS NULL )))
AND ( ( Recinfo.RMA_LINE_ID = p_RMA_LINE_ID)
OR ( ( Recinfo.RMA_LINE_ID IS NULL )
AND ( p_RMA_LINE_ID IS NULL )))
AND ( ( Recinfo.CUSTOMER_SHIP_ID = p_CUSTOMER_SHIP_ID)
OR ( ( Recinfo.CUSTOMER_SHIP_ID IS NULL )
AND ( p_CUSTOMER_SHIP_ID IS NULL )))
AND ( ( Recinfo.CURRENCY_CODE = p_CURRENCY_CODE)
OR ( ( Recinfo.CURRENCY_CODE IS NULL )
AND ( p_CURRENCY_CODE IS NULL )))
AND ( ( Recinfo.CURRENCY_CONVERSION_RATE = p_CURRENCY_CONVERSION_RATE)
OR ( ( Recinfo.CURRENCY_CONVERSION_RATE IS NULL )
AND ( p_CURRENCY_CONVERSION_RATE IS NULL )))
AND ( ( Recinfo.CURRENCY_CONVERSION_TYPE = p_CURRENCY_CONVERSION_TYPE)
OR ( ( Recinfo.CURRENCY_CONVERSION_TYPE IS NULL )
AND ( p_CURRENCY_CONVERSION_TYPE IS NULL )))
AND ( ( Recinfo.CURRENCY_CONVERSION_DATE = p_CURRENCY_CONVERSION_DATE)
OR ( ( Recinfo.CURRENCY_CONVERSION_DATE IS NULL )
AND ( p_CURRENCY_CONVERSION_DATE IS NULL )))
AND ( ( Recinfo.USSGL_TRANSACTION_CODE = p_USSGL_TRANSACTION_CODE)
OR ( ( Recinfo.USSGL_TRANSACTION_CODE IS NULL )
AND ( p_USSGL_TRANSACTION_CODE IS NULL )))
AND ( ( Recinfo.VENDOR_LOT_NUMBER = p_VENDOR_LOT_NUMBER)
OR ( ( Recinfo.VENDOR_LOT_NUMBER IS NULL )
AND ( p_VENDOR_LOT_NUMBER IS NULL )))
AND ( ( Recinfo.ENCUMBRANCE_ACCOUNT = p_ENCUMBRANCE_ACCOUNT)
OR ( ( Recinfo.ENCUMBRANCE_ACCOUNT IS NULL )
AND ( p_ENCUMBRANCE_ACCOUNT IS NULL )))
AND ( ( Recinfo.ENCUMBRANCE_AMOUNT = p_ENCUMBRANCE_AMOUNT)
OR ( ( Recinfo.ENCUMBRANCE_AMOUNT IS NULL )
AND ( p_ENCUMBRANCE_AMOUNT IS NULL )))
AND ( ( Recinfo.SHIP_TO_LOCATION = p_SHIP_TO_LOCATION)
OR ( ( Recinfo.SHIP_TO_LOCATION IS NULL )
AND ( p_SHIP_TO_LOCATION IS NULL )))
AND ( ( Recinfo.SHIPMENT_NUMBER = p_SHIPMENT_NUMBER)
OR ( ( Recinfo.SHIPMENT_NUMBER IS NULL )
AND ( p_SHIPMENT_NUMBER IS NULL )))
AND ( ( Recinfo.TRANSFER_COST = p_TRANSFER_COST)
OR ( ( Recinfo.TRANSFER_COST IS NULL )
AND ( p_TRANSFER_COST IS NULL )))
AND ( ( Recinfo.TRANSPORTATION_COST = p_TRANSPORTATION_COST)
OR ( ( Recinfo.TRANSPORTATION_COST IS NULL )
AND ( p_TRANSPORTATION_COST IS NULL )))
AND ( ( Recinfo.TRANSPORTATION_ACCOUNT = p_TRANSPORTATION_ACCOUNT)
OR ( ( Recinfo.TRANSPORTATION_ACCOUNT IS NULL )
AND ( p_TRANSPORTATION_ACCOUNT IS NULL )))
AND ( ( Recinfo.FREIGHT_CODE = p_FREIGHT_CODE)
OR ( ( Recinfo.FREIGHT_CODE IS NULL )
AND ( p_FREIGHT_CODE IS NULL )))
AND ( ( Recinfo.CONTAINERS = p_CONTAINERS)
OR ( ( Recinfo.CONTAINERS IS NULL )
AND ( p_CONTAINERS IS NULL )))
AND ( ( Recinfo.WAYBILL_AIRBILL = p_WAYBILL_AIRBILL)
OR ( ( Recinfo.WAYBILL_AIRBILL IS NULL )
AND ( p_WAYBILL_AIRBILL IS NULL )))
AND ( ( Recinfo.EXPECTED_ARRIVAL_DATE = p_EXPECTED_ARRIVAL_DATE)
OR ( ( Recinfo.EXPECTED_ARRIVAL_DATE IS NULL )
AND ( p_EXPECTED_ARRIVAL_DATE IS NULL )))
AND ( ( Recinfo.TRANSFER_SUBINVENTORY = p_TRANSFER_SUBINVENTORY)
OR ( ( Recinfo.TRANSFER_SUBINVENTORY IS NULL )
AND ( p_TRANSFER_SUBINVENTORY IS NULL )))
AND ( ( Recinfo.TRANSFER_ORGANIZATION = p_TRANSFER_ORGANIZATION)
OR ( ( Recinfo.TRANSFER_ORGANIZATION IS NULL )
AND ( p_TRANSFER_ORGANIZATION IS NULL )))
AND ( ( Recinfo.TRANSFER_TO_LOCATION = p_TRANSFER_TO_LOCATION)
OR ( ( Recinfo.TRANSFER_TO_LOCATION IS NULL )
AND ( p_TRANSFER_TO_LOCATION IS NULL )))
AND ( ( Recinfo.NEW_AVERAGE_COST = p_NEW_AVERAGE_COST)
OR ( ( Recinfo.NEW_AVERAGE_COST IS NULL )
AND ( p_NEW_AVERAGE_COST IS NULL )))
AND ( ( Recinfo.VALUE_CHANGE = p_VALUE_CHANGE)
OR ( ( Recinfo.VALUE_CHANGE IS NULL )
AND ( p_VALUE_CHANGE IS NULL )))
AND ( ( Recinfo.PERCENTAGE_CHANGE = p_PERCENTAGE_CHANGE)
OR ( ( Recinfo.PERCENTAGE_CHANGE IS NULL )
AND ( p_PERCENTAGE_CHANGE IS NULL )))
AND ( ( Recinfo.MATERIAL_ALLOCATION_TEMP_ID = p_MATERIAL_ALLOCATION_TEMP_ID)
OR ( ( Recinfo.MATERIAL_ALLOCATION_TEMP_ID IS NULL )
AND ( p_MATERIAL_ALLOCATION_TEMP_ID IS NULL )))
AND ( ( Recinfo.DEMAND_SOURCE_HEADER_ID = p_DEMAND_SOURCE_HEADER_ID)
OR ( ( Recinfo.DEMAND_SOURCE_HEADER_ID IS NULL )
AND ( p_DEMAND_SOURCE_HEADER_ID IS NULL )))
AND ( ( Recinfo.DEMAND_SOURCE_LINE = p_DEMAND_SOURCE_LINE)
OR ( ( Recinfo.DEMAND_SOURCE_LINE IS NULL )
AND ( p_DEMAND_SOURCE_LINE IS NULL )))
AND ( ( Recinfo.DEMAND_SOURCE_DELIVERY = p_DEMAND_SOURCE_DELIVERY)
OR ( ( Recinfo.DEMAND_SOURCE_DELIVERY IS NULL )
AND ( p_DEMAND_SOURCE_DELIVERY IS NULL )))
AND ( ( Recinfo.ITEM_SEGMENTS = p_ITEM_SEGMENTS)
OR ( ( Recinfo.ITEM_SEGMENTS IS NULL )
AND ( p_ITEM_SEGMENTS IS NULL )))
AND ( ( Recinfo.ITEM_DESCRIPTION = p_ITEM_DESCRIPTION)
OR ( ( Recinfo.ITEM_DESCRIPTION IS NULL )
AND ( p_ITEM_DESCRIPTION IS NULL )))
AND ( ( Recinfo.ITEM_TRX_ENABLED_FLAG = p_ITEM_TRX_ENABLED_FLAG)
OR ( ( Recinfo.ITEM_TRX_ENABLED_FLAG IS NULL )
AND ( p_ITEM_TRX_ENABLED_FLAG IS NULL )))
AND ( ( Recinfo.ITEM_LOCATION_CONTROL_CODE = p_ITEM_LOCATION_CONTROL_CODE)
OR ( ( Recinfo.ITEM_LOCATION_CONTROL_CODE IS NULL )
AND ( p_ITEM_LOCATION_CONTROL_CODE IS NULL )))
AND ( ( Recinfo.ITEM_RESTRICT_SUBINV_CODE = p_ITEM_RESTRICT_SUBINV_CODE)
OR ( ( Recinfo.ITEM_RESTRICT_SUBINV_CODE IS NULL )
AND ( p_ITEM_RESTRICT_SUBINV_CODE IS NULL )))
AND ( ( Recinfo.ITEM_RESTRICT_LOCATORS_CODE = p_ITEM_RESTRICT_LOCATORS_CODE)
OR ( ( Recinfo.ITEM_RESTRICT_LOCATORS_CODE IS NULL )
AND ( p_ITEM_RESTRICT_LOCATORS_CODE IS NULL )))
AND ( ( Recinfo.ITEM_REVISION_QTY_CONTROL_CODE = p_ITEM_REV_QTY_CONTROL_CODE)
OR ( ( Recinfo.ITEM_REVISION_QTY_CONTROL_CODE IS NULL )
AND ( p_ITEM_REV_QTY_CONTROL_CODE IS NULL )))
AND ( ( Recinfo.ITEM_PRIMARY_UOM_CODE = p_ITEM_PRIMARY_UOM_CODE)
OR ( ( Recinfo.ITEM_PRIMARY_UOM_CODE IS NULL )
AND ( p_ITEM_PRIMARY_UOM_CODE IS NULL )))
AND ( ( Recinfo.ITEM_UOM_CLASS = p_ITEM_UOM_CLASS)
OR ( ( Recinfo.ITEM_UOM_CLASS IS NULL )
AND ( p_ITEM_UOM_CLASS IS NULL )))
AND ( ( Recinfo.ITEM_SHELF_LIFE_CODE = p_ITEM_SHELF_LIFE_CODE)
OR ( ( Recinfo.ITEM_SHELF_LIFE_CODE IS NULL )
AND ( p_ITEM_SHELF_LIFE_CODE IS NULL )))
AND ( ( Recinfo.ITEM_SHELF_LIFE_DAYS = p_ITEM_SHELF_LIFE_DAYS)
OR ( ( Recinfo.ITEM_SHELF_LIFE_DAYS IS NULL )
AND ( p_ITEM_SHELF_LIFE_DAYS IS NULL )))
AND ( ( Recinfo.ITEM_LOT_CONTROL_CODE = p_ITEM_LOT_CONTROL_CODE)
OR ( ( Recinfo.ITEM_LOT_CONTROL_CODE IS NULL )
AND ( p_ITEM_LOT_CONTROL_CODE IS NULL )))
AND ( ( Recinfo.ITEM_SERIAL_CONTROL_CODE = p_ITEM_SERIAL_CONTROL_CODE)
OR ( ( Recinfo.ITEM_SERIAL_CONTROL_CODE IS NULL )
AND ( p_ITEM_SERIAL_CONTROL_CODE IS NULL )))
AND ( ( Recinfo.ITEM_INVENTORY_ASSET_FLAG = p_ITEM_INVENTORY_ASSET_FLAG)
OR ( ( Recinfo.ITEM_INVENTORY_ASSET_FLAG IS NULL )
AND ( p_ITEM_INVENTORY_ASSET_FLAG IS NULL )))
AND ( ( Recinfo.ALLOWED_UNITS_LOOKUP_CODE = p_ALLOWED_UNITS_LOOKUP_CODE)
OR ( ( Recinfo.ALLOWED_UNITS_LOOKUP_CODE IS NULL )
AND ( p_ALLOWED_UNITS_LOOKUP_CODE IS NULL )))
AND ( ( Recinfo.DEPARTMENT_ID = p_DEPARTMENT_ID)
OR ( ( Recinfo.DEPARTMENT_ID IS NULL )
AND ( p_DEPARTMENT_ID IS NULL )))
AND ( ( Recinfo.DEPARTMENT_CODE = p_DEPARTMENT_CODE)
OR ( ( Recinfo.DEPARTMENT_CODE IS NULL )
AND ( p_DEPARTMENT_CODE IS NULL )))
AND ( ( Recinfo.WIP_SUPPLY_TYPE = p_WIP_SUPPLY_TYPE)
OR ( ( Recinfo.WIP_SUPPLY_TYPE IS NULL )
AND ( p_WIP_SUPPLY_TYPE IS NULL )))
AND ( ( Recinfo.SUPPLY_SUBINVENTORY = p_SUPPLY_SUBINVENTORY)
OR ( ( Recinfo.SUPPLY_SUBINVENTORY IS NULL )
AND ( p_SUPPLY_SUBINVENTORY IS NULL )))
AND ( ( Recinfo.SUPPLY_LOCATOR_ID = p_SUPPLY_LOCATOR_ID)
OR ( ( Recinfo.SUPPLY_LOCATOR_ID IS NULL )
AND ( p_SUPPLY_LOCATOR_ID IS NULL )))
AND ( ( Recinfo.VALID_SUBINVENTORY_FLAG = p_VALID_SUBINVENTORY_FLAG)
OR ( ( Recinfo.VALID_SUBINVENTORY_FLAG IS NULL )
AND ( p_VALID_SUBINVENTORY_FLAG IS NULL )))
AND ( ( Recinfo.VALID_LOCATOR_FLAG = p_VALID_LOCATOR_FLAG)
OR ( ( Recinfo.VALID_LOCATOR_FLAG IS NULL )
AND ( p_VALID_LOCATOR_FLAG IS NULL )))
AND ( ( Recinfo.LOCATOR_SEGMENTS = p_LOCATOR_SEGMENTS)
OR ( ( Recinfo.LOCATOR_SEGMENTS IS NULL )
AND ( p_LOCATOR_SEGMENTS IS NULL )))
AND ( ( Recinfo.CURRENT_LOCATOR_CONTROL_CODE = p_CURRENT_LOCATOR_CONTROL_CODE)
OR ( ( Recinfo.CURRENT_LOCATOR_CONTROL_CODE IS NULL )
AND ( p_CURRENT_LOCATOR_CONTROL_CODE IS NULL )))
AND ( ( Recinfo.NUMBER_OF_LOTS_ENTERED = p_NUMBER_OF_LOTS_ENTERED)
OR ( ( Recinfo.NUMBER_OF_LOTS_ENTERED IS NULL )
AND ( p_NUMBER_OF_LOTS_ENTERED IS NULL )))
AND ( ( Recinfo.WIP_COMMIT_FLAG = p_WIP_COMMIT_FLAG)
OR ( ( Recinfo.WIP_COMMIT_FLAG IS NULL )
AND ( p_WIP_COMMIT_FLAG IS NULL )))
AND ( ( Recinfo.NEXT_LOT_NUMBER = p_NEXT_LOT_NUMBER)
OR ( ( Recinfo.NEXT_LOT_NUMBER IS NULL )
AND ( p_NEXT_LOT_NUMBER IS NULL )))
AND ( ( Recinfo.LOT_ALPHA_PREFIX = p_LOT_ALPHA_PREFIX)
OR ( ( Recinfo.LOT_ALPHA_PREFIX IS NULL )
AND ( p_LOT_ALPHA_PREFIX IS NULL )))
AND ( ( Recinfo.NEXT_SERIAL_NUMBER = p_NEXT_SERIAL_NUMBER)
OR ( ( Recinfo.NEXT_SERIAL_NUMBER IS NULL )
AND ( p_NEXT_SERIAL_NUMBER IS NULL )))
AND ( ( Recinfo.SERIAL_ALPHA_PREFIX = p_SERIAL_ALPHA_PREFIX)
OR ( ( Recinfo.SERIAL_ALPHA_PREFIX IS NULL )
AND ( p_SERIAL_ALPHA_PREFIX IS NULL )))
AND ( ( Recinfo.SHIPPABLE_FLAG = p_SHIPPABLE_FLAG)
OR ( ( Recinfo.SHIPPABLE_FLAG IS NULL )
AND ( p_SHIPPABLE_FLAG IS NULL )))
AND ( ( Recinfo.POSTING_FLAG = p_POSTING_FLAG)
OR ( ( Recinfo.POSTING_FLAG IS NULL )
AND ( p_POSTING_FLAG IS NULL )))
AND ( ( Recinfo.REQUIRED_FLAG = p_REQUIRED_FLAG)
OR ( ( Recinfo.REQUIRED_FLAG IS NULL )
AND ( p_REQUIRED_FLAG IS NULL )))
AND ( ( Recinfo.PROCESS_FLAG = p_PROCESS_FLAG)
OR ( ( Recinfo.PROCESS_FLAG IS NULL )
AND ( p_PROCESS_FLAG IS NULL )))
AND ( ( Recinfo.ERROR_CODE = p_ERROR_CODE)
OR ( ( Recinfo.ERROR_CODE IS NULL )
AND ( p_ERROR_CODE IS NULL )))
AND ( ( Recinfo.ERROR_EXPLANATION = p_ERROR_EXPLANATION)
OR ( ( Recinfo.ERROR_EXPLANATION IS NULL )
AND ( p_ERROR_EXPLANATION IS NULL )))
AND ( ( Recinfo.ATTRIBUTE_CATEGORY = p_ATTRIBUTE_CATEGORY)
OR ( ( Recinfo.ATTRIBUTE_CATEGORY IS NULL )
AND ( p_ATTRIBUTE_CATEGORY IS NULL )))
AND ( ( Recinfo.ATTRIBUTE1 = p_ATTRIBUTE1)
OR ( ( Recinfo.ATTRIBUTE1 IS NULL )
AND ( p_ATTRIBUTE1 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE2 = p_ATTRIBUTE2)
OR ( ( Recinfo.ATTRIBUTE2 IS NULL )
AND ( p_ATTRIBUTE2 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE3 = p_ATTRIBUTE3)
OR ( ( Recinfo.ATTRIBUTE3 IS NULL )
AND ( p_ATTRIBUTE3 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE4 = p_ATTRIBUTE4)
OR ( ( Recinfo.ATTRIBUTE4 IS NULL )
AND ( p_ATTRIBUTE4 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE5 = p_ATTRIBUTE5)
OR ( ( Recinfo.ATTRIBUTE5 IS NULL )
AND ( p_ATTRIBUTE5 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE6 = p_ATTRIBUTE6)
OR ( ( Recinfo.ATTRIBUTE6 IS NULL )
AND ( p_ATTRIBUTE6 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE7 = p_ATTRIBUTE7)
OR ( ( Recinfo.ATTRIBUTE7 IS NULL )
AND ( p_ATTRIBUTE7 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE8 = p_ATTRIBUTE8)
OR ( ( Recinfo.ATTRIBUTE8 IS NULL )
AND ( p_ATTRIBUTE8 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE9 = p_ATTRIBUTE9)
OR ( ( Recinfo.ATTRIBUTE9 IS NULL )
AND ( p_ATTRIBUTE9 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE10 = p_ATTRIBUTE10)
OR ( ( Recinfo.ATTRIBUTE10 IS NULL )
AND ( p_ATTRIBUTE10 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE11 = p_ATTRIBUTE11)
OR ( ( Recinfo.ATTRIBUTE11 IS NULL )
AND ( p_ATTRIBUTE11 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE12 = p_ATTRIBUTE12)
OR ( ( Recinfo.ATTRIBUTE12 IS NULL )
AND ( p_ATTRIBUTE12 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE13 = p_ATTRIBUTE13)
OR ( ( Recinfo.ATTRIBUTE13 IS NULL )
AND ( p_ATTRIBUTE13 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE14 = p_ATTRIBUTE14)
OR ( ( Recinfo.ATTRIBUTE14 IS NULL )
AND ( p_ATTRIBUTE14 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE15 = p_ATTRIBUTE15)
OR ( ( Recinfo.ATTRIBUTE15 IS NULL )
AND ( p_ATTRIBUTE15 IS NULL )))
AND ( ( Recinfo.MOVEMENT_ID = p_MOVEMENT_ID)
OR ( ( Recinfo.MOVEMENT_ID IS NULL )
AND ( p_MOVEMENT_ID IS NULL )))
AND ( ( Recinfo.RESERVATION_QUANTITY = p_RESERVATION_QUANTITY)
OR ( ( Recinfo.RESERVATION_QUANTITY IS NULL )
AND ( p_RESERVATION_QUANTITY IS NULL )))
AND ( ( Recinfo.SHIPPED_QUANTITY = p_SHIPPED_QUANTITY)
OR ( ( Recinfo.SHIPPED_QUANTITY IS NULL )
AND ( p_SHIPPED_QUANTITY IS NULL )))
AND ( ( Recinfo.TRANSACTION_LINE_NUMBER = p_TRANSACTION_LINE_NUMBER)
OR ( ( Recinfo.TRANSACTION_LINE_NUMBER IS NULL )
AND ( p_TRANSACTION_LINE_NUMBER IS NULL )))
AND ( ( Recinfo.TASK_ID = p_TASK_ID)
OR ( ( Recinfo.TASK_ID IS NULL )
AND ( p_TASK_ID IS NULL )))
AND ( ( Recinfo.TO_TASK_ID = p_TO_TASK_ID)
OR ( ( Recinfo.TO_TASK_ID IS NULL )
AND ( p_TO_TASK_ID IS NULL )))
AND ( ( Recinfo.SOURCE_TASK_ID = p_SOURCE_TASK_ID)
OR ( ( Recinfo.SOURCE_TASK_ID IS NULL )
AND ( p_SOURCE_TASK_ID IS NULL )))
AND ( ( Recinfo.PROJECT_ID = p_PROJECT_ID)
OR ( ( Recinfo.PROJECT_ID IS NULL )
AND ( p_PROJECT_ID IS NULL )))
AND ( ( Recinfo.SOURCE_PROJECT_ID = p_SOURCE_PROJECT_ID)
OR ( ( Recinfo.SOURCE_PROJECT_ID IS NULL )
AND ( p_SOURCE_PROJECT_ID IS NULL )))
AND ( ( Recinfo.PA_EXPENDITURE_ORG_ID = p_PA_EXPENDITURE_ORG_ID)
OR ( ( Recinfo.PA_EXPENDITURE_ORG_ID IS NULL )
AND ( p_PA_EXPENDITURE_ORG_ID IS NULL )))
AND ( ( Recinfo.TO_PROJECT_ID = p_TO_PROJECT_ID)
OR ( ( Recinfo.TO_PROJECT_ID IS NULL )
AND ( p_TO_PROJECT_ID IS NULL )))
AND ( ( Recinfo.EXPENDITURE_TYPE = p_EXPENDITURE_TYPE)
OR ( ( Recinfo.EXPENDITURE_TYPE IS NULL )
AND ( p_EXPENDITURE_TYPE IS NULL )))
AND ( ( Recinfo.FINAL_COMPLETION_FLAG = p_FINAL_COMPLETION_FLAG)
OR ( ( Recinfo.FINAL_COMPLETION_FLAG IS NULL )
AND ( p_FINAL_COMPLETION_FLAG IS NULL )))
AND ( ( Recinfo.TRANSFER_PERCENTAGE = p_TRANSFER_PERCENTAGE)
OR ( ( Recinfo.TRANSFER_PERCENTAGE IS NULL )
AND ( p_TRANSFER_PERCENTAGE IS NULL )))
AND ( ( Recinfo.TRANSACTION_SEQUENCE_ID = p_TRANSACTION_SEQUENCE_ID)
OR ( ( Recinfo.TRANSACTION_SEQUENCE_ID IS NULL )
AND ( p_TRANSACTION_SEQUENCE_ID IS NULL )))
AND ( ( Recinfo.MATERIAL_ACCOUNT = p_MATERIAL_ACCOUNT)
OR ( ( Recinfo.MATERIAL_ACCOUNT IS NULL )
AND ( p_MATERIAL_ACCOUNT IS NULL )))
AND ( ( Recinfo.MATERIAL_OVERHEAD_ACCOUNT = p_MATERIAL_OVERHEAD_ACCOUNT)
OR ( ( Recinfo.MATERIAL_OVERHEAD_ACCOUNT IS NULL )
AND ( p_MATERIAL_OVERHEAD_ACCOUNT IS NULL )))
AND ( ( Recinfo.RESOURCE_ACCOUNT = p_RESOURCE_ACCOUNT)
OR ( ( Recinfo.RESOURCE_ACCOUNT IS NULL )
AND ( p_RESOURCE_ACCOUNT IS NULL )))
AND ( ( Recinfo.OUTSIDE_PROCESSING_ACCOUNT = p_OUTSIDE_PROCESSING_ACCOUNT)
OR ( ( Recinfo.OUTSIDE_PROCESSING_ACCOUNT IS NULL )
AND ( p_OUTSIDE_PROCESSING_ACCOUNT IS NULL )))
AND ( ( Recinfo.OVERHEAD_ACCOUNT = p_OVERHEAD_ACCOUNT)
OR ( ( Recinfo.OVERHEAD_ACCOUNT IS NULL )
AND ( p_OVERHEAD_ACCOUNT IS NULL )))
AND ( ( Recinfo.FLOW_SCHEDULE = p_FLOW_SCHEDULE)
OR ( ( Recinfo.FLOW_SCHEDULE IS NULL )
AND ( p_FLOW_SCHEDULE IS NULL )))
AND ( ( Recinfo.COST_GROUP_ID = p_COST_GROUP_ID)
OR ( ( Recinfo.COST_GROUP_ID IS NULL )
AND ( p_COST_GROUP_ID IS NULL )))
AND ( ( Recinfo.DEMAND_CLASS = p_DEMAND_CLASS)
OR ( ( Recinfo.DEMAND_CLASS IS NULL )
AND ( p_DEMAND_CLASS IS NULL )))
AND ( ( Recinfo.QA_COLLECTION_ID = p_QA_COLLECTION_ID)
OR ( ( Recinfo.QA_COLLECTION_ID IS NULL )
AND ( p_QA_COLLECTION_ID IS NULL )))
AND ( ( Recinfo.KANBAN_CARD_ID = p_KANBAN_CARD_ID)
OR ( ( Recinfo.KANBAN_CARD_ID IS NULL )
AND ( p_KANBAN_CARD_ID IS NULL )))
AND ( ( Recinfo.OVERCOMPLETION_TRANSACTION_ID = p_OVERCOMPLETION_TXN_ID)
OR ( ( Recinfo.OVERCOMPLETION_TRANSACTION_ID IS NULL )
AND ( p_OVERCOMPLETION_TXN_ID IS NULL )))
AND ( ( Recinfo.OVERCOMPLETION_PRIMARY_QTY = p_OVERCOMPLETION_PRIMARY_QTY)
OR ( ( Recinfo.OVERCOMPLETION_PRIMARY_QTY IS NULL )
AND ( p_OVERCOMPLETION_PRIMARY_QTY IS NULL )))
AND ( ( Recinfo.OVERCOMPLETION_TRANSACTION_QTY = p_OVERCOMPLETION_TXN_QTY)
OR ( ( Recinfo.OVERCOMPLETION_TRANSACTION_QTY IS NULL )
AND ( p_OVERCOMPLETION_TXN_QTY IS NULL )))
/*AND ( ( Recinfo.PROCESS_TYPE = p_PROCESS_TYPE)
OR ( ( Recinfo.PROCESS_TYPE IS NULL )
AND ( p_PROCESS_TYPE IS NULL )))*/
AND ( ( Recinfo.END_ITEM_UNIT_NUMBER = p_END_ITEM_UNIT_NUMBER)
OR ( ( Recinfo.END_ITEM_UNIT_NUMBER IS NULL )
AND ( p_END_ITEM_UNIT_NUMBER IS NULL )))
AND ( ( Recinfo.SCHEDULED_PAYBACK_DATE = p_SCHEDULED_PAYBACK_DATE)
OR ( ( Recinfo.SCHEDULED_PAYBACK_DATE IS NULL )
AND ( p_SCHEDULED_PAYBACK_DATE IS NULL )))
AND ( ( Recinfo.LINE_TYPE_CODE = p_LINE_TYPE_CODE)
OR ( ( Recinfo.LINE_TYPE_CODE IS NULL )
AND ( p_LINE_TYPE_CODE IS NULL )))
AND ( ( Recinfo.PARENT_TRANSACTION_TEMP_ID = p_PARENT_TRANSACTION_TEMP_ID)
OR ( ( Recinfo.PARENT_TRANSACTION_TEMP_ID IS NULL )
AND ( p_PARENT_TRANSACTION_TEMP_ID IS NULL )))
AND ( ( Recinfo.PUT_AWAY_STRATEGY_ID = p_PUT_AWAY_STRATEGY_ID)
OR ( ( Recinfo.PUT_AWAY_STRATEGY_ID IS NULL )
AND ( p_PUT_AWAY_STRATEGY_ID IS NULL )))
AND ( ( Recinfo.PUT_AWAY_RULE_ID = p_PUT_AWAY_RULE_ID)
OR ( ( Recinfo.PUT_AWAY_RULE_ID IS NULL )
AND ( p_PUT_AWAY_RULE_ID IS NULL )))
AND ( ( Recinfo.PICK_STRATEGY_ID = p_PICK_STRATEGY_ID)
OR ( ( Recinfo.PICK_STRATEGY_ID IS NULL )
AND ( p_PICK_STRATEGY_ID IS NULL )))
AND ( ( Recinfo.PICK_RULE_ID = p_PICK_RULE_ID)
OR ( ( Recinfo.PICK_RULE_ID IS NULL )
AND ( p_PICK_RULE_ID IS NULL )))
AND ( ( Recinfo.COMMON_BOM_SEQ_ID = p_COMMON_BOM_SEQ_ID)
OR ( ( Recinfo.COMMON_BOM_SEQ_ID IS NULL )
AND ( p_COMMON_BOM_SEQ_ID IS NULL )))
AND ( ( Recinfo.COMMON_ROUTING_SEQ_ID = p_COMMON_ROUTING_SEQ_ID)
OR ( ( Recinfo.COMMON_ROUTING_SEQ_ID IS NULL )
AND ( p_COMMON_ROUTING_SEQ_ID IS NULL )))
AND ( ( Recinfo.COST_TYPE_ID = p_COST_TYPE_ID)
OR ( ( Recinfo.COST_TYPE_ID IS NULL )
AND ( p_COST_TYPE_ID IS NULL )))
AND ( ( Recinfo.ORG_COST_GROUP_ID = p_ORG_COST_GROUP_ID)
OR ( ( Recinfo.ORG_COST_GROUP_ID IS NULL )
AND ( p_ORG_COST_GROUP_ID IS NULL )))
AND ( ( Recinfo.MOVE_ORDER_LINE_ID = p_MOVE_ORDER_LINE_ID)
OR ( ( Recinfo.MOVE_ORDER_LINE_ID IS NULL )
AND ( p_MOVE_ORDER_LINE_ID IS NULL )))
AND ( ( Recinfo.TASK_GROUP_ID = p_TASK_GROUP_ID)
OR ( ( Recinfo.TASK_GROUP_ID IS NULL )
AND ( p_TASK_GROUP_ID IS NULL )))
AND ( ( Recinfo.PICK_SLIP_NUMBER = p_PICK_SLIP_NUMBER)
OR ( ( Recinfo.PICK_SLIP_NUMBER IS NULL )
AND ( p_PICK_SLIP_NUMBER IS NULL )))
AND ( ( Recinfo.RESERVATION_ID = p_RESERVATION_ID)
OR ( ( Recinfo.RESERVATION_ID IS NULL )
AND ( p_RESERVATION_ID IS NULL )))
AND ( ( Recinfo.TRANSACTION_STATUS = p_TRANSACTION_STATUS)
OR ( ( Recinfo.TRANSACTION_STATUS IS NULL )
AND ( p_TRANSACTION_STATUS IS NULL )))
AND ( ( Recinfo.STANDARD_OPERATION_ID = p_STANDARD_OPERATION_ID)
OR ( ( Recinfo.STANDARD_OPERATION_ID IS NULL )
AND ( p_STANDARD_OPERATION_ID IS NULL )))
AND ( ( Recinfo.TASK_PRIORITY = p_TASK_PRIORITY)
OR ( ( Recinfo.TASK_PRIORITY IS NULL )
AND ( p_TASK_PRIORITY IS NULL )))
AND ( ( Recinfo.WMS_TASK_TYPE = p_WMS_TASK_TYPE)
OR ( ( Recinfo.WMS_TASK_TYPE IS NULL )
AND ( p_WMS_TASK_TYPE IS NULL )))
AND ( ( Recinfo.PARENT_LINE_ID = p_PARENT_LINE_ID)
OR ( ( Recinfo.PARENT_LINE_ID IS NULL )
AND ( p_PARENT_LINE_ID IS NULL )))
/*AND ( ( Recinfo.SOURCE_LOT_NUMBER = p_SOURCE_LOT_NUMBER)
OR ( ( Recinfo.SOURCE_LOT_NUMBER IS NULL )
AND ( p_SOURCE_LOT_NUMBER IS NULL ))) */
) then
return;