The following lines contain the word 'select', 'insert', 'update' or 'delete':
CSP_MTL_TRANSACTIONS_PKG.Insert_Row(
p_TRANSACTION_HEADER_ID => p_CSP_rec.TRANSACTION_HEADER_ID,
px_TRANSACTION_TEMP_ID => x_TRANSACTION_TEMP_ID,
p_SOURCE_CODE => p_CSP_rec.SOURCE_CODE,
p_SOURCE_LINE_ID => p_CSP_rec.SOURCE_LINE_ID,
p_TRANSACTION_MODE => p_CSP_rec.TRANSACTION_MODE,
p_LOCK_FLAG => p_CSP_rec.LOCK_FLAG,
p_LAST_UPDATE_DATE => p_CSP_rec.LAST_UPDATE_DATE,
p_LAST_UPDATED_BY => p_CSP_rec.LAST_UPDATED_BY,
p_CREATION_DATE => p_CSP_rec.CREATION_DATE,
p_CREATED_BY => p_CSP_rec.CREATED_BY,
p_LAST_UPDATE_LOGIN => p_CSP_rec.LAST_UPDATE_LOGIN,
p_REQUEST_ID => p_CSP_rec.REQUEST_ID,
p_PROGRAM_APPLICATION_ID => p_CSP_rec.PROGRAM_APPLICATION_ID,
p_PROGRAM_ID => p_CSP_rec.PROGRAM_ID,
p_PROGRAM_UPDATE_DATE => p_CSP_rec.PROGRAM_UPDATE_DATE,
p_INVENTORY_ITEM_ID => p_CSP_rec.INVENTORY_ITEM_ID,
p_REVISION => p_CSP_rec.REVISION,
p_ORGANIZATION_ID => p_CSP_rec.ORGANIZATION_ID,
p_SUBINVENTORY_CODE => p_CSP_rec.SUBINVENTORY_CODE,
p_LOCATOR_ID => p_CSP_rec.LOCATOR_ID,
p_TRANSACTION_QUANTITY => p_CSP_rec.TRANSACTION_QUANTITY,
p_PRIMARY_QUANTITY => p_CSP_rec.PRIMARY_QUANTITY,
p_TRANSACTION_UOM => p_CSP_rec.TRANSACTION_UOM,
p_TRANSACTION_COST => p_CSP_rec.TRANSACTION_COST,
p_TRANSACTION_TYPE_ID => p_CSP_rec.TRANSACTION_TYPE_ID,
p_TRANSACTION_ACTION_ID => p_CSP_rec.TRANSACTION_ACTION_ID,
p_TRANSACTION_SOURCE_TYPE_ID => p_CSP_rec.TRANSACTION_SOURCE_TYPE_ID,
p_TRANSACTION_SOURCE_ID => p_CSP_rec.TRANSACTION_SOURCE_ID,
p_TRANSACTION_SOURCE_NAME => p_CSP_rec.TRANSACTION_SOURCE_NAME,
p_TRANSACTION_DATE => p_CSP_rec.TRANSACTION_DATE,
p_ACCT_PERIOD_ID => p_CSP_rec.ACCT_PERIOD_ID,
p_DISTRIBUTION_ACCOUNT_ID => p_CSP_rec.DISTRIBUTION_ACCOUNT_ID,
p_TRANSACTION_REFERENCE => p_CSP_rec.TRANSACTION_REFERENCE,
p_REQUISITION_LINE_ID => p_CSP_rec.REQUISITION_LINE_ID,
p_REQUISITION_DISTRIBUTION_ID => p_CSP_rec.REQUISITION_DISTRIBUTION_ID,
p_REASON_ID => p_CSP_rec.REASON_ID,
p_LOT_NUMBER => p_CSP_rec.LOT_NUMBER,
p_LOT_EXPIRATION_DATE => p_CSP_rec.LOT_EXPIRATION_DATE,
p_SERIAL_NUMBER => p_CSP_rec.SERIAL_NUMBER,
p_RECEIVING_DOCUMENT => p_CSP_rec.RECEIVING_DOCUMENT,
p_DEMAND_ID => p_CSP_rec.DEMAND_ID,
p_RCV_TRANSACTION_ID => p_CSP_rec.RCV_TRANSACTION_ID,
p_MOVE_TRANSACTION_ID => p_CSP_rec.MOVE_TRANSACTION_ID,
p_COMPLETION_TRANSACTION_ID => p_CSP_rec.COMPLETION_TRANSACTION_ID,
p_WIP_ENTITY_TYPE => p_CSP_rec.WIP_ENTITY_TYPE,
p_SCHEDULE_ID => p_CSP_rec.SCHEDULE_ID,
p_REPETITIVE_LINE_ID => p_CSP_rec.REPETITIVE_LINE_ID,
p_EMPLOYEE_CODE => p_CSP_rec.EMPLOYEE_CODE,
p_PRIMARY_SWITCH => p_CSP_rec.PRIMARY_SWITCH,
p_SCHEDULE_UPDATE_CODE => p_CSP_rec.SCHEDULE_UPDATE_CODE,
p_SETUP_TEARDOWN_CODE => p_CSP_rec.SETUP_TEARDOWN_CODE,
p_ITEM_ORDERING => p_CSP_rec.ITEM_ORDERING,
p_NEGATIVE_REQ_FLAG => p_CSP_rec.NEGATIVE_REQ_FLAG,
p_OPERATION_SEQ_NUM => p_CSP_rec.OPERATION_SEQ_NUM,
p_PICKING_LINE_ID => p_CSP_rec.PICKING_LINE_ID,
p_TRX_SOURCE_LINE_ID => p_CSP_rec.TRX_SOURCE_LINE_ID,
p_TRX_SOURCE_DELIVERY_ID => p_CSP_rec.TRX_SOURCE_DELIVERY_ID,
p_PHYSICAL_ADJUSTMENT_ID => p_CSP_rec.PHYSICAL_ADJUSTMENT_ID,
p_CYCLE_COUNT_ID => p_CSP_rec.CYCLE_COUNT_ID,
p_RMA_LINE_ID => p_CSP_rec.RMA_LINE_ID,
p_CUSTOMER_SHIP_ID => p_CSP_rec.CUSTOMER_SHIP_ID,
p_CURRENCY_CODE => p_CSP_rec.CURRENCY_CODE,
p_CURRENCY_CONVERSION_RATE => p_CSP_rec.CURRENCY_CONVERSION_RATE,
p_CURRENCY_CONVERSION_TYPE => p_CSP_rec.CURRENCY_CONVERSION_TYPE,
p_CURRENCY_CONVERSION_DATE => p_CSP_rec.CURRENCY_CONVERSION_DATE,
p_USSGL_TRANSACTION_CODE => p_CSP_rec.USSGL_TRANSACTION_CODE,
p_VENDOR_LOT_NUMBER => p_CSP_rec.VENDOR_LOT_NUMBER,
p_ENCUMBRANCE_ACCOUNT => p_CSP_rec.ENCUMBRANCE_ACCOUNT,
p_ENCUMBRANCE_AMOUNT => p_CSP_rec.ENCUMBRANCE_AMOUNT,
p_SHIP_TO_LOCATION => p_CSP_rec.SHIP_TO_LOCATION,
p_SHIPMENT_NUMBER => p_CSP_rec.SHIPMENT_NUMBER,
p_TRANSFER_COST => p_CSP_rec.TRANSFER_COST,
p_TRANSPORTATION_COST => p_CSP_rec.TRANSPORTATION_COST,
p_TRANSPORTATION_ACCOUNT => p_CSP_rec.TRANSPORTATION_ACCOUNT,
p_FREIGHT_CODE => p_CSP_rec.FREIGHT_CODE,
p_CONTAINERS => p_CSP_rec.CONTAINERS,
p_WAYBILL_AIRBILL => p_CSP_rec.WAYBILL_AIRBILL,
p_EXPECTED_ARRIVAL_DATE => p_CSP_rec.EXPECTED_ARRIVAL_DATE,
p_TRANSFER_SUBINVENTORY => p_CSP_rec.TRANSFER_SUBINVENTORY,
p_TRANSFER_ORGANIZATION => p_CSP_rec.TRANSFER_ORGANIZATION,
p_TRANSFER_TO_LOCATION => p_CSP_rec.TRANSFER_TO_LOCATION,
p_NEW_AVERAGE_COST => p_CSP_rec.NEW_AVERAGE_COST,
p_VALUE_CHANGE => p_CSP_rec.VALUE_CHANGE,
p_PERCENTAGE_CHANGE => p_CSP_rec.PERCENTAGE_CHANGE,
p_MATERIAL_ALLOCATION_TEMP_ID => p_CSP_rec.MATERIAL_ALLOCATION_TEMP_ID,
p_DEMAND_SOURCE_HEADER_ID => p_CSP_rec.DEMAND_SOURCE_HEADER_ID,
p_DEMAND_SOURCE_LINE => p_CSP_rec.DEMAND_SOURCE_LINE,
p_DEMAND_SOURCE_DELIVERY => p_CSP_rec.DEMAND_SOURCE_DELIVERY,
p_ITEM_SEGMENTS => p_CSP_rec.ITEM_SEGMENTS,
p_ITEM_DESCRIPTION => p_CSP_rec.ITEM_DESCRIPTION,
p_ITEM_TRX_ENABLED_FLAG => p_CSP_rec.ITEM_TRX_ENABLED_FLAG,
p_ITEM_LOCATION_CONTROL_CODE => p_CSP_rec.ITEM_LOCATION_CONTROL_CODE,
p_ITEM_RESTRICT_SUBINV_CODE => p_CSP_rec.ITEM_RESTRICT_SUBINV_CODE,
p_ITEM_RESTRICT_LOCATORS_CODE => p_CSP_rec.ITEM_RESTRICT_LOCATORS_CODE,
p_ITEM_REV_QTY_CONTROL_CODE => p_CSP_rec.ITEM_REVISION_QTY_CONTROL_CODE,
p_ITEM_PRIMARY_UOM_CODE => p_CSP_rec.ITEM_PRIMARY_UOM_CODE,
p_ITEM_UOM_CLASS => p_CSP_rec.ITEM_UOM_CLASS,
p_ITEM_SHELF_LIFE_CODE => p_CSP_rec.ITEM_SHELF_LIFE_CODE,
p_ITEM_SHELF_LIFE_DAYS => p_CSP_rec.ITEM_SHELF_LIFE_DAYS,
p_ITEM_LOT_CONTROL_CODE => p_CSP_rec.ITEM_LOT_CONTROL_CODE,
p_ITEM_SERIAL_CONTROL_CODE => p_CSP_rec.ITEM_SERIAL_CONTROL_CODE,
p_ITEM_INVENTORY_ASSET_FLAG => p_CSP_rec.ITEM_INVENTORY_ASSET_FLAG,
p_ALLOWED_UNITS_LOOKUP_CODE => p_CSP_rec.ALLOWED_UNITS_LOOKUP_CODE,
p_DEPARTMENT_ID => p_CSP_rec.DEPARTMENT_ID,
p_DEPARTMENT_CODE => p_CSP_rec.DEPARTMENT_CODE,
p_WIP_SUPPLY_TYPE => p_CSP_rec.WIP_SUPPLY_TYPE,
p_SUPPLY_SUBINVENTORY => p_CSP_rec.SUPPLY_SUBINVENTORY,
p_SUPPLY_LOCATOR_ID => p_CSP_rec.SUPPLY_LOCATOR_ID,
p_VALID_SUBINVENTORY_FLAG => p_CSP_rec.VALID_SUBINVENTORY_FLAG,
p_VALID_LOCATOR_FLAG => p_CSP_rec.VALID_LOCATOR_FLAG,
p_LOCATOR_SEGMENTS => p_CSP_rec.LOCATOR_SEGMENTS,
p_CURRENT_LOCATOR_CONTROL_CODE => p_CSP_rec.CURRENT_LOCATOR_CONTROL_CODE,
p_NUMBER_OF_LOTS_ENTERED => p_CSP_rec.NUMBER_OF_LOTS_ENTERED,
p_WIP_COMMIT_FLAG => p_CSP_rec.WIP_COMMIT_FLAG,
p_NEXT_LOT_NUMBER => p_CSP_rec.NEXT_LOT_NUMBER,
p_LOT_ALPHA_PREFIX => p_CSP_rec.LOT_ALPHA_PREFIX,
p_NEXT_SERIAL_NUMBER => p_CSP_rec.NEXT_SERIAL_NUMBER,
p_SERIAL_ALPHA_PREFIX => p_CSP_rec.SERIAL_ALPHA_PREFIX,
p_SHIPPABLE_FLAG => p_CSP_rec.SHIPPABLE_FLAG,
p_POSTING_FLAG => p_CSP_rec.POSTING_FLAG,
p_REQUIRED_FLAG => p_CSP_rec.REQUIRED_FLAG,
p_PROCESS_FLAG => p_CSP_rec.PROCESS_FLAG,
p_ERROR_CODE => p_CSP_rec.ERROR_CODE,
p_ERROR_EXPLANATION => p_CSP_rec.ERROR_EXPLANATION,
p_ATTRIBUTE_CATEGORY => p_CSP_rec.ATTRIBUTE_CATEGORY,
p_ATTRIBUTE1 => p_CSP_rec.ATTRIBUTE1,
p_ATTRIBUTE2 => p_CSP_rec.ATTRIBUTE2,
p_ATTRIBUTE3 => p_CSP_rec.ATTRIBUTE3,
p_ATTRIBUTE4 => p_CSP_rec.ATTRIBUTE4,
p_ATTRIBUTE5 => p_CSP_rec.ATTRIBUTE5,
p_ATTRIBUTE6 => p_CSP_rec.ATTRIBUTE6,
p_ATTRIBUTE7 => p_CSP_rec.ATTRIBUTE7,
p_ATTRIBUTE8 => p_CSP_rec.ATTRIBUTE8,
p_ATTRIBUTE9 => p_CSP_rec.ATTRIBUTE9,
p_ATTRIBUTE10 => p_CSP_rec.ATTRIBUTE10,
p_ATTRIBUTE11 => p_CSP_rec.ATTRIBUTE11,
p_ATTRIBUTE12 => p_CSP_rec.ATTRIBUTE12,
p_ATTRIBUTE13 => p_CSP_rec.ATTRIBUTE13,
p_ATTRIBUTE14 => p_CSP_rec.ATTRIBUTE14,
p_ATTRIBUTE15 => p_CSP_rec.ATTRIBUTE15,
p_MOVEMENT_ID => p_CSP_rec.MOVEMENT_ID,
p_RESERVATION_QUANTITY => p_CSP_rec.RESERVATION_QUANTITY,
p_SHIPPED_QUANTITY => p_CSP_rec.SHIPPED_QUANTITY,
p_TRANSACTION_LINE_NUMBER => p_CSP_rec.TRANSACTION_LINE_NUMBER,
p_TASK_ID => p_CSP_rec.TASK_ID,
p_TO_TASK_ID => p_CSP_rec.TO_TASK_ID,
p_SOURCE_TASK_ID => p_CSP_rec.SOURCE_TASK_ID,
p_PROJECT_ID => p_CSP_rec.PROJECT_ID,
p_SOURCE_PROJECT_ID => p_CSP_rec.SOURCE_PROJECT_ID,
p_PA_EXPENDITURE_ORG_ID => p_CSP_rec.PA_EXPENDITURE_ORG_ID,
p_TO_PROJECT_ID => p_CSP_rec.TO_PROJECT_ID,
p_EXPENDITURE_TYPE => p_CSP_rec.EXPENDITURE_TYPE,
p_FINAL_COMPLETION_FLAG => p_CSP_rec.FINAL_COMPLETION_FLAG,
p_TRANSFER_PERCENTAGE => p_CSP_rec.TRANSFER_PERCENTAGE,
p_TRANSACTION_SEQUENCE_ID => p_CSP_rec.TRANSACTION_SEQUENCE_ID,
p_MATERIAL_ACCOUNT => p_CSP_rec.MATERIAL_ACCOUNT,
p_MATERIAL_OVERHEAD_ACCOUNT => p_CSP_rec.MATERIAL_OVERHEAD_ACCOUNT,
p_RESOURCE_ACCOUNT => p_CSP_rec.RESOURCE_ACCOUNT,
p_OUTSIDE_PROCESSING_ACCOUNT => p_CSP_rec.OUTSIDE_PROCESSING_ACCOUNT,
p_OVERHEAD_ACCOUNT => p_CSP_rec.OVERHEAD_ACCOUNT,
p_FLOW_SCHEDULE => p_CSP_rec.FLOW_SCHEDULE,
p_COST_GROUP_ID => p_CSP_rec.COST_GROUP_ID,
p_DEMAND_CLASS => p_CSP_rec.DEMAND_CLASS,
p_QA_COLLECTION_ID => p_CSP_rec.QA_COLLECTION_ID,
p_KANBAN_CARD_ID => p_CSP_rec.KANBAN_CARD_ID,
p_OVERCOMPLETION_TXN_ID => p_CSP_rec.OVERCOMPLETION_TRANSACTION_ID,
p_OVERCOMPLETION_PRIMARY_QTY => p_CSP_rec.OVERCOMPLETION_PRIMARY_QTY,
p_OVERCOMPLETION_TXN_QTY => p_CSP_rec.OVERCOMPLETION_TRANSACTION_QTY,
-- p_PROCESS_TYPE => p_CSP_rec.PROCESS_TYPE,
p_END_ITEM_UNIT_NUMBER => p_CSP_rec.END_ITEM_UNIT_NUMBER,
p_SCHEDULED_PAYBACK_DATE => p_CSP_rec.SCHEDULED_PAYBACK_DATE,
p_LINE_TYPE_CODE => p_CSP_rec.LINE_TYPE_CODE,
p_PARENT_TRANSACTION_TEMP_ID => p_CSP_rec.PARENT_TRANSACTION_TEMP_ID,
p_PUT_AWAY_STRATEGY_ID => p_CSP_rec.PUT_AWAY_STRATEGY_ID,
p_PUT_AWAY_RULE_ID => p_CSP_rec.PUT_AWAY_RULE_ID,
p_PICK_STRATEGY_ID => p_CSP_rec.PICK_STRATEGY_ID,
p_PICK_RULE_ID => p_CSP_rec.PICK_RULE_ID,
p_COMMON_BOM_SEQ_ID => p_CSP_rec.COMMON_BOM_SEQ_ID,
p_COMMON_ROUTING_SEQ_ID => p_CSP_rec.COMMON_ROUTING_SEQ_ID,
p_COST_TYPE_ID => p_CSP_rec.COST_TYPE_ID,
p_ORG_COST_GROUP_ID => p_CSP_rec.ORG_COST_GROUP_ID,
p_MOVE_ORDER_LINE_ID => p_CSP_rec.MOVE_ORDER_LINE_ID,
p_TASK_GROUP_ID => p_CSP_rec.TASK_GROUP_ID,
p_PICK_SLIP_NUMBER => p_CSP_rec.PICK_SLIP_NUMBER,
p_RESERVATION_ID => p_CSP_rec.RESERVATION_ID,
p_TRANSACTION_STATUS => p_CSP_rec.TRANSACTION_STATUS,
p_STANDARD_OPERATION_ID => p_CSP_rec.STANDARD_OPERATION_ID,
p_TASK_PRIORITY => p_CSP_rec.TASK_PRIORITY,
p_WMS_TASK_TYPE => p_CSP_rec.WMS_TASK_TYPE,
p_PARENT_LINE_ID => p_CSP_rec.PARENT_LINE_ID);
PROCEDURE Update_material_transactions(
P_Api_Version_Number IN NUMBER,
P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
P_Commit IN VARCHAR2 := FND_API.G_FALSE,
p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
P_CSP_Rec IN CSP_Rec_Type,
X_Return_Status OUT NOCOPY VARCHAR2,
X_Msg_Count OUT NOCOPY NUMBER,
X_Msg_Data OUT NOCOPY VARCHAR2
)
IS
/*
Cursor C_Get_material_transactions(TRANSACTION_HEADER_ID Number) IS
Select rowid,
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
From MTL_MATERIAL_TRANSACTIONS_TEMP
-- Hint: Developer need to provide Where clause
For Update NOWAIT;
l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_MATERIAL_TXN';
SAVEPOINT UPDATE_MATERIAL_TXN_PVT;
AS_CALLOUT_PKG.Update_material_transactions_BU(
p_api_version_number => 2.0,
p_init_msg_list => FND_API.G_FALSE,
p_commit => FND_API.G_FALSE,
p_validation_level => p_validation_level,
p_identity_salesforce_id => p_identity_salesforce_id,
P_CSP_Rec => P_CSP_Rec,
-- Hint: Add detail tables as parameter lists if it's master-detail relationship.
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);
l_ref_CSP_rec.LAST_UPDATE_DATE,
l_ref_CSP_rec.LAST_UPDATED_BY,
l_ref_CSP_rec.CREATION_DATE,
l_ref_CSP_rec.CREATED_BY,
l_ref_CSP_rec.LAST_UPDATE_LOGIN,
l_ref_CSP_rec.REQUEST_ID,
l_ref_CSP_rec.PROGRAM_APPLICATION_ID,
l_ref_CSP_rec.PROGRAM_ID,
l_ref_CSP_rec.PROGRAM_UPDATE_DATE,
l_ref_CSP_rec.INVENTORY_ITEM_ID,
l_ref_CSP_rec.REVISION,
l_ref_CSP_rec.ORGANIZATION_ID,
l_ref_CSP_rec.SUBINVENTORY_CODE,
l_ref_CSP_rec.LOCATOR_ID,
l_ref_CSP_rec.TRANSACTION_QUANTITY,
l_ref_CSP_rec.PRIMARY_QUANTITY,
l_ref_CSP_rec.TRANSACTION_UOM,
l_ref_CSP_rec.TRANSACTION_COST,
l_ref_CSP_rec.TRANSACTION_TYPE_ID,
l_ref_CSP_rec.TRANSACTION_ACTION_ID,
l_ref_CSP_rec.TRANSACTION_SOURCE_TYPE_ID,
l_ref_CSP_rec.TRANSACTION_SOURCE_ID,
l_ref_CSP_rec.TRANSACTION_SOURCE_NAME,
l_ref_CSP_rec.TRANSACTION_DATE,
l_ref_CSP_rec.ACCT_PERIOD_ID,
l_ref_CSP_rec.DISTRIBUTION_ACCOUNT_ID,
l_ref_CSP_rec.TRANSACTION_REFERENCE,
l_ref_CSP_rec.REQUISITION_LINE_ID,
l_ref_CSP_rec.REQUISITION_DISTRIBUTION_ID,
l_ref_CSP_rec.REASON_ID,
l_ref_CSP_rec.LOT_NUMBER,
l_ref_CSP_rec.LOT_EXPIRATION_DATE,
l_ref_CSP_rec.SERIAL_NUMBER,
l_ref_CSP_rec.RECEIVING_DOCUMENT,
l_ref_CSP_rec.DEMAND_ID,
l_ref_CSP_rec.RCV_TRANSACTION_ID,
l_ref_CSP_rec.MOVE_TRANSACTION_ID,
l_ref_CSP_rec.COMPLETION_TRANSACTION_ID,
l_ref_CSP_rec.WIP_ENTITY_TYPE,
l_ref_CSP_rec.SCHEDULE_ID,
l_ref_CSP_rec.REPETITIVE_LINE_ID,
l_ref_CSP_rec.EMPLOYEE_CODE,
l_ref_CSP_rec.PRIMARY_SWITCH,
l_ref_CSP_rec.SCHEDULE_UPDATE_CODE,
l_ref_CSP_rec.SETUP_TEARDOWN_CODE,
l_ref_CSP_rec.ITEM_ORDERING,
l_ref_CSP_rec.NEGATIVE_REQ_FLAG,
l_ref_CSP_rec.OPERATION_SEQ_NUM,
l_ref_CSP_rec.PICKING_LINE_ID,
l_ref_CSP_rec.TRX_SOURCE_LINE_ID,
l_ref_CSP_rec.TRX_SOURCE_DELIVERY_ID,
l_ref_CSP_rec.PHYSICAL_ADJUSTMENT_ID,
l_ref_CSP_rec.CYCLE_COUNT_ID,
l_ref_CSP_rec.RMA_LINE_ID,
l_ref_CSP_rec.CUSTOMER_SHIP_ID,
l_ref_CSP_rec.CURRENCY_CODE,
l_ref_CSP_rec.CURRENCY_CONVERSION_RATE,
l_ref_CSP_rec.CURRENCY_CONVERSION_TYPE,
l_ref_CSP_rec.CURRENCY_CONVERSION_DATE,
l_ref_CSP_rec.USSGL_TRANSACTION_CODE,
l_ref_CSP_rec.VENDOR_LOT_NUMBER,
l_ref_CSP_rec.ENCUMBRANCE_ACCOUNT,
l_ref_CSP_rec.ENCUMBRANCE_AMOUNT,
l_ref_CSP_rec.SHIP_TO_LOCATION,
l_ref_CSP_rec.SHIPMENT_NUMBER,
l_ref_CSP_rec.TRANSFER_COST,
l_ref_CSP_rec.TRANSPORTATION_COST,
l_ref_CSP_rec.TRANSPORTATION_ACCOUNT,
l_ref_CSP_rec.FREIGHT_CODE,
l_ref_CSP_rec.CONTAINERS,
l_ref_CSP_rec.WAYBILL_AIRBILL,
l_ref_CSP_rec.EXPECTED_ARRIVAL_DATE,
l_ref_CSP_rec.TRANSFER_SUBINVENTORY,
l_ref_CSP_rec.TRANSFER_ORGANIZATION,
l_ref_CSP_rec.TRANSFER_TO_LOCATION,
l_ref_CSP_rec.NEW_AVERAGE_COST,
l_ref_CSP_rec.VALUE_CHANGE,
l_ref_CSP_rec.PERCENTAGE_CHANGE,
l_ref_CSP_rec.MATERIAL_ALLOCATION_TEMP_ID,
l_ref_CSP_rec.DEMAND_SOURCE_HEADER_ID,
l_ref_CSP_rec.DEMAND_SOURCE_LINE,
l_ref_CSP_rec.DEMAND_SOURCE_DELIVERY,
l_ref_CSP_rec.ITEM_SEGMENTS,
l_ref_CSP_rec.ITEM_DESCRIPTION,
l_ref_CSP_rec.ITEM_TRX_ENABLED_FLAG,
l_ref_CSP_rec.ITEM_LOCATION_CONTROL_CODE,
l_ref_CSP_rec.ITEM_RESTRICT_SUBINV_CODE,
l_ref_CSP_rec.ITEM_RESTRICT_LOCATORS_CODE,
l_ref_CSP_rec.ITEM_REVISION_QTY_CONTROL_CODE,
l_ref_CSP_rec.ITEM_PRIMARY_UOM_CODE,
l_ref_CSP_rec.ITEM_UOM_CLASS,
l_ref_CSP_rec.ITEM_SHELF_LIFE_CODE,
l_ref_CSP_rec.ITEM_SHELF_LIFE_DAYS,
l_ref_CSP_rec.ITEM_LOT_CONTROL_CODE,
l_ref_CSP_rec.ITEM_SERIAL_CONTROL_CODE,
l_ref_CSP_rec.ITEM_INVENTORY_ASSET_FLAG,
l_ref_CSP_rec.ALLOWED_UNITS_LOOKUP_CODE,
l_ref_CSP_rec.DEPARTMENT_ID,
l_ref_CSP_rec.DEPARTMENT_CODE,
l_ref_CSP_rec.WIP_SUPPLY_TYPE,
l_ref_CSP_rec.SUPPLY_SUBINVENTORY,
l_ref_CSP_rec.SUPPLY_LOCATOR_ID,
l_ref_CSP_rec.VALID_SUBINVENTORY_FLAG,
l_ref_CSP_rec.VALID_LOCATOR_FLAG,
l_ref_CSP_rec.LOCATOR_SEGMENTS,
l_ref_CSP_rec.CURRENT_LOCATOR_CONTROL_CODE,
l_ref_CSP_rec.NUMBER_OF_LOTS_ENTERED,
l_ref_CSP_rec.WIP_COMMIT_FLAG,
l_ref_CSP_rec.NEXT_LOT_NUMBER,
l_ref_CSP_rec.LOT_ALPHA_PREFIX,
l_ref_CSP_rec.NEXT_SERIAL_NUMBER,
l_ref_CSP_rec.SERIAL_ALPHA_PREFIX,
l_ref_CSP_rec.SHIPPABLE_FLAG,
l_ref_CSP_rec.POSTING_FLAG,
l_ref_CSP_rec.REQUIRED_FLAG,
l_ref_CSP_rec.PROCESS_FLAG,
l_ref_CSP_rec.ERROR_CODE,
l_ref_CSP_rec.ERROR_EXPLANATION,
l_ref_CSP_rec.ATTRIBUTE_CATEGORY,
l_ref_CSP_rec.ATTRIBUTE1,
l_ref_CSP_rec.ATTRIBUTE2,
l_ref_CSP_rec.ATTRIBUTE3,
l_ref_CSP_rec.ATTRIBUTE4,
l_ref_CSP_rec.ATTRIBUTE5,
l_ref_CSP_rec.ATTRIBUTE6,
l_ref_CSP_rec.ATTRIBUTE7,
l_ref_CSP_rec.ATTRIBUTE8,
l_ref_CSP_rec.ATTRIBUTE9,
l_ref_CSP_rec.ATTRIBUTE10,
l_ref_CSP_rec.ATTRIBUTE11,
l_ref_CSP_rec.ATTRIBUTE12,
l_ref_CSP_rec.ATTRIBUTE13,
l_ref_CSP_rec.ATTRIBUTE14,
l_ref_CSP_rec.ATTRIBUTE15,
l_ref_CSP_rec.MOVEMENT_ID,
l_ref_CSP_rec.RESERVATION_QUANTITY,
l_ref_CSP_rec.SHIPPED_QUANTITY,
l_ref_CSP_rec.TRANSACTION_LINE_NUMBER,
l_ref_CSP_rec.TASK_ID,
l_ref_CSP_rec.TO_TASK_ID,
l_ref_CSP_rec.SOURCE_TASK_ID,
l_ref_CSP_rec.PROJECT_ID,
l_ref_CSP_rec.SOURCE_PROJECT_ID,
l_ref_CSP_rec.PA_EXPENDITURE_ORG_ID,
l_ref_CSP_rec.TO_PROJECT_ID,
l_ref_CSP_rec.EXPENDITURE_TYPE,
l_ref_CSP_rec.FINAL_COMPLETION_FLAG,
l_ref_CSP_rec.TRANSFER_PERCENTAGE,
l_ref_CSP_rec.TRANSACTION_SEQUENCE_ID,
l_ref_CSP_rec.MATERIAL_ACCOUNT,
l_ref_CSP_rec.MATERIAL_OVERHEAD_ACCOUNT,
l_ref_CSP_rec.RESOURCE_ACCOUNT,
l_ref_CSP_rec.OUTSIDE_PROCESSING_ACCOUNT,
l_ref_CSP_rec.OVERHEAD_ACCOUNT,
l_ref_CSP_rec.FLOW_SCHEDULE,
l_ref_CSP_rec.COST_GROUP_ID,
l_ref_CSP_rec.DEMAND_CLASS,
l_ref_CSP_rec.QA_COLLECTION_ID,
l_ref_CSP_rec.KANBAN_CARD_ID,
l_ref_CSP_rec.OVERCOMPLETION_TRANSACTION_ID,
l_ref_CSP_rec.OVERCOMPLETION_PRIMARY_QTY,
l_ref_CSP_rec.OVERCOMPLETION_TRANSACTION_QTY,
l_ref_CSP_rec.PROCESS_TYPE,
l_ref_CSP_rec.END_ITEM_UNIT_NUMBER,
l_ref_CSP_rec.SCHEDULED_PAYBACK_DATE,
l_ref_CSP_rec.LINE_TYPE_CODE,
l_ref_CSP_rec.PARENT_TRANSACTION_TEMP_ID,
l_ref_CSP_rec.PUT_AWAY_STRATEGY_ID,
l_ref_CSP_rec.PUT_AWAY_RULE_ID,
l_ref_CSP_rec.PICK_STRATEGY_ID,
l_ref_CSP_rec.PICK_RULE_ID,
l_ref_CSP_rec.COMMON_BOM_SEQ_ID,
l_ref_CSP_rec.COMMON_ROUTING_SEQ_ID,
l_ref_CSP_rec.COST_TYPE_ID,
l_ref_CSP_rec.ORG_COST_GROUP_ID,
l_ref_CSP_rec.MOVE_ORDER_LINE_ID,
l_ref_CSP_rec.TASK_GROUP_ID,
l_ref_CSP_rec.PICK_SLIP_NUMBER,
l_ref_CSP_rec.RESERVATION_ID,
l_ref_CSP_rec.TRANSACTION_STATUS;
FND_MESSAGE.Set_Name('CSP', 'API_MISSING_UPDATE_TARGET');
/* If (l_tar_CSP_rec.last_update_date is NULL or
l_tar_CSP_rec.last_update_date = FND_API.G_MISS_Date ) Then
IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
THEN
FND_MESSAGE.Set_Name('CSP', 'API_MISSING_ID');
FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
If (l_tar_CSP_rec.last_update_date <> l_ref_CSP_rec.last_update_date) Then
IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
THEN
FND_MESSAGE.Set_Name('CSP', 'API_RECORD_CHANGED');
p_validation_mode => JTF_PLSQL_API.G_UPDATE,
P_CSP_Rec => P_CSP_Rec,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);
CSP_MTL_TRANSACTIONS_PKG.Update_Row(
p_TRANSACTION_HEADER_ID => p_CSP_rec.TRANSACTION_HEADER_ID,
p_TRANSACTION_TEMP_ID => p_CSP_rec.TRANSACTION_TEMP_ID,
p_SOURCE_CODE => p_CSP_rec.SOURCE_CODE,
p_SOURCE_LINE_ID => p_CSP_rec.SOURCE_LINE_ID,
p_TRANSACTION_MODE => p_CSP_rec.TRANSACTION_MODE,
p_LOCK_FLAG => p_CSP_rec.LOCK_FLAG,
p_LAST_UPDATE_DATE => p_CSP_rec.LAST_UPDATE_DATE,
p_LAST_UPDATED_BY => p_CSP_rec.LAST_UPDATED_BY,
p_CREATION_DATE => p_CSP_rec.CREATION_DATE,
p_CREATED_BY => p_CSP_rec.CREATED_BY,
p_LAST_UPDATE_LOGIN => p_CSP_rec.LAST_UPDATE_LOGIN,
p_REQUEST_ID => p_CSP_rec.REQUEST_ID,
p_PROGRAM_APPLICATION_ID => p_CSP_rec.PROGRAM_APPLICATION_ID,
p_PROGRAM_ID => p_CSP_rec.PROGRAM_ID,
p_PROGRAM_UPDATE_DATE => p_CSP_rec.PROGRAM_UPDATE_DATE,
p_INVENTORY_ITEM_ID => p_CSP_rec.INVENTORY_ITEM_ID,
p_REVISION => p_CSP_rec.REVISION,
p_ORGANIZATION_ID => p_CSP_rec.ORGANIZATION_ID,
p_SUBINVENTORY_CODE => p_CSP_rec.SUBINVENTORY_CODE,
p_LOCATOR_ID => p_CSP_rec.LOCATOR_ID,
p_TRANSACTION_QUANTITY => p_CSP_rec.TRANSACTION_QUANTITY,
p_PRIMARY_QUANTITY => p_CSP_rec.PRIMARY_QUANTITY,
p_TRANSACTION_UOM => p_CSP_rec.TRANSACTION_UOM,
p_TRANSACTION_COST => p_CSP_rec.TRANSACTION_COST,
p_TRANSACTION_TYPE_ID => p_CSP_rec.TRANSACTION_TYPE_ID,
p_TRANSACTION_ACTION_ID => p_CSP_rec.TRANSACTION_ACTION_ID,
p_TRANSACTION_SOURCE_TYPE_ID => p_CSP_rec.TRANSACTION_SOURCE_TYPE_ID,
p_TRANSACTION_SOURCE_ID => p_CSP_rec.TRANSACTION_SOURCE_ID,
p_TRANSACTION_SOURCE_NAME => p_CSP_rec.TRANSACTION_SOURCE_NAME,
p_TRANSACTION_DATE => p_CSP_rec.TRANSACTION_DATE,
p_ACCT_PERIOD_ID => p_CSP_rec.ACCT_PERIOD_ID,
p_DISTRIBUTION_ACCOUNT_ID => p_CSP_rec.DISTRIBUTION_ACCOUNT_ID,
p_TRANSACTION_REFERENCE => p_CSP_rec.TRANSACTION_REFERENCE,
p_REQUISITION_LINE_ID => p_CSP_rec.REQUISITION_LINE_ID,
p_REQUISITION_DISTRIBUTION_ID => p_CSP_rec.REQUISITION_DISTRIBUTION_ID,
p_REASON_ID => p_CSP_rec.REASON_ID,
p_LOT_NUMBER => p_CSP_rec.LOT_NUMBER,
p_LOT_EXPIRATION_DATE => p_CSP_rec.LOT_EXPIRATION_DATE,
p_SERIAL_NUMBER => p_CSP_rec.SERIAL_NUMBER,
p_RECEIVING_DOCUMENT => p_CSP_rec.RECEIVING_DOCUMENT,
p_DEMAND_ID => p_CSP_rec.DEMAND_ID,
p_RCV_TRANSACTION_ID => p_CSP_rec.RCV_TRANSACTION_ID,
p_MOVE_TRANSACTION_ID => p_CSP_rec.MOVE_TRANSACTION_ID,
p_COMPLETION_TRANSACTION_ID => p_CSP_rec.COMPLETION_TRANSACTION_ID,
p_WIP_ENTITY_TYPE => p_CSP_rec.WIP_ENTITY_TYPE,
p_SCHEDULE_ID => p_CSP_rec.SCHEDULE_ID,
p_REPETITIVE_LINE_ID => p_CSP_rec.REPETITIVE_LINE_ID,
p_EMPLOYEE_CODE => p_CSP_rec.EMPLOYEE_CODE,
p_PRIMARY_SWITCH => p_CSP_rec.PRIMARY_SWITCH,
p_SCHEDULE_UPDATE_CODE => p_CSP_rec.SCHEDULE_UPDATE_CODE,
p_SETUP_TEARDOWN_CODE => p_CSP_rec.SETUP_TEARDOWN_CODE,
p_ITEM_ORDERING => p_CSP_rec.ITEM_ORDERING,
p_NEGATIVE_REQ_FLAG => p_CSP_rec.NEGATIVE_REQ_FLAG,
p_OPERATION_SEQ_NUM => p_CSP_rec.OPERATION_SEQ_NUM,
p_PICKING_LINE_ID => p_CSP_rec.PICKING_LINE_ID,
p_TRX_SOURCE_LINE_ID => p_CSP_rec.TRX_SOURCE_LINE_ID,
p_TRX_SOURCE_DELIVERY_ID => p_CSP_rec.TRX_SOURCE_DELIVERY_ID,
p_PHYSICAL_ADJUSTMENT_ID => p_CSP_rec.PHYSICAL_ADJUSTMENT_ID,
p_CYCLE_COUNT_ID => p_CSP_rec.CYCLE_COUNT_ID,
p_RMA_LINE_ID => p_CSP_rec.RMA_LINE_ID,
p_CUSTOMER_SHIP_ID => p_CSP_rec.CUSTOMER_SHIP_ID,
p_CURRENCY_CODE => p_CSP_rec.CURRENCY_CODE,
p_CURRENCY_CONVERSION_RATE => p_CSP_rec.CURRENCY_CONVERSION_RATE,
p_CURRENCY_CONVERSION_TYPE => p_CSP_rec.CURRENCY_CONVERSION_TYPE,
p_CURRENCY_CONVERSION_DATE => p_CSP_rec.CURRENCY_CONVERSION_DATE,
p_USSGL_TRANSACTION_CODE => p_CSP_rec.USSGL_TRANSACTION_CODE,
p_VENDOR_LOT_NUMBER => p_CSP_rec.VENDOR_LOT_NUMBER,
p_ENCUMBRANCE_ACCOUNT => p_CSP_rec.ENCUMBRANCE_ACCOUNT,
p_ENCUMBRANCE_AMOUNT => p_CSP_rec.ENCUMBRANCE_AMOUNT,
p_SHIP_TO_LOCATION => p_CSP_rec.SHIP_TO_LOCATION,
p_SHIPMENT_NUMBER => p_CSP_rec.SHIPMENT_NUMBER,
p_TRANSFER_COST => p_CSP_rec.TRANSFER_COST,
p_TRANSPORTATION_COST => p_CSP_rec.TRANSPORTATION_COST,
p_TRANSPORTATION_ACCOUNT => p_CSP_rec.TRANSPORTATION_ACCOUNT,
p_FREIGHT_CODE => p_CSP_rec.FREIGHT_CODE,
p_CONTAINERS => p_CSP_rec.CONTAINERS,
p_WAYBILL_AIRBILL => p_CSP_rec.WAYBILL_AIRBILL,
p_EXPECTED_ARRIVAL_DATE => p_CSP_rec.EXPECTED_ARRIVAL_DATE,
p_TRANSFER_SUBINVENTORY => p_CSP_rec.TRANSFER_SUBINVENTORY,
p_TRANSFER_ORGANIZATION => p_CSP_rec.TRANSFER_ORGANIZATION,
p_TRANSFER_TO_LOCATION => p_CSP_rec.TRANSFER_TO_LOCATION,
p_NEW_AVERAGE_COST => p_CSP_rec.NEW_AVERAGE_COST,
p_VALUE_CHANGE => p_CSP_rec.VALUE_CHANGE,
p_PERCENTAGE_CHANGE => p_CSP_rec.PERCENTAGE_CHANGE,
p_MATERIAL_ALLOCATION_TEMP_ID => p_CSP_rec.MATERIAL_ALLOCATION_TEMP_ID,
p_DEMAND_SOURCE_HEADER_ID => p_CSP_rec.DEMAND_SOURCE_HEADER_ID,
p_DEMAND_SOURCE_LINE => p_CSP_rec.DEMAND_SOURCE_LINE,
p_DEMAND_SOURCE_DELIVERY => p_CSP_rec.DEMAND_SOURCE_DELIVERY,
p_ITEM_SEGMENTS => p_CSP_rec.ITEM_SEGMENTS,
p_ITEM_DESCRIPTION => p_CSP_rec.ITEM_DESCRIPTION,
p_ITEM_TRX_ENABLED_FLAG => p_CSP_rec.ITEM_TRX_ENABLED_FLAG,
p_ITEM_LOCATION_CONTROL_CODE => p_CSP_rec.ITEM_LOCATION_CONTROL_CODE,
p_ITEM_RESTRICT_SUBINV_CODE => p_CSP_rec.ITEM_RESTRICT_SUBINV_CODE,
p_ITEM_RESTRICT_LOCATORS_CODE => p_CSP_rec.ITEM_RESTRICT_LOCATORS_CODE,
p_ITEM_REV_QTY_CONTROL_CODE => p_CSP_rec.ITEM_REVISION_QTY_CONTROL_CODE,
p_ITEM_PRIMARY_UOM_CODE => p_CSP_rec.ITEM_PRIMARY_UOM_CODE,
p_ITEM_UOM_CLASS => p_CSP_rec.ITEM_UOM_CLASS,
p_ITEM_SHELF_LIFE_CODE => p_CSP_rec.ITEM_SHELF_LIFE_CODE,
p_ITEM_SHELF_LIFE_DAYS => p_CSP_rec.ITEM_SHELF_LIFE_DAYS,
p_ITEM_LOT_CONTROL_CODE => p_CSP_rec.ITEM_LOT_CONTROL_CODE,
p_ITEM_SERIAL_CONTROL_CODE => p_CSP_rec.ITEM_SERIAL_CONTROL_CODE,
p_ITEM_INVENTORY_ASSET_FLAG => p_CSP_rec.ITEM_INVENTORY_ASSET_FLAG,
p_ALLOWED_UNITS_LOOKUP_CODE => p_CSP_rec.ALLOWED_UNITS_LOOKUP_CODE,
p_DEPARTMENT_ID => p_CSP_rec.DEPARTMENT_ID,
p_DEPARTMENT_CODE => p_CSP_rec.DEPARTMENT_CODE,
p_WIP_SUPPLY_TYPE => p_CSP_rec.WIP_SUPPLY_TYPE,
p_SUPPLY_SUBINVENTORY => p_CSP_rec.SUPPLY_SUBINVENTORY,
p_SUPPLY_LOCATOR_ID => p_CSP_rec.SUPPLY_LOCATOR_ID,
p_VALID_SUBINVENTORY_FLAG => p_CSP_rec.VALID_SUBINVENTORY_FLAG,
p_VALID_LOCATOR_FLAG => p_CSP_rec.VALID_LOCATOR_FLAG,
p_LOCATOR_SEGMENTS => p_CSP_rec.LOCATOR_SEGMENTS,
p_CURRENT_LOCATOR_CONTROL_CODE => p_CSP_rec.CURRENT_LOCATOR_CONTROL_CODE,
p_NUMBER_OF_LOTS_ENTERED => p_CSP_rec.NUMBER_OF_LOTS_ENTERED,
p_WIP_COMMIT_FLAG => p_CSP_rec.WIP_COMMIT_FLAG,
p_NEXT_LOT_NUMBER => p_CSP_rec.NEXT_LOT_NUMBER,
p_LOT_ALPHA_PREFIX => p_CSP_rec.LOT_ALPHA_PREFIX,
p_NEXT_SERIAL_NUMBER => p_CSP_rec.NEXT_SERIAL_NUMBER,
p_SERIAL_ALPHA_PREFIX => p_CSP_rec.SERIAL_ALPHA_PREFIX,
p_SHIPPABLE_FLAG => p_CSP_rec.SHIPPABLE_FLAG,
p_POSTING_FLAG => p_CSP_rec.POSTING_FLAG,
p_REQUIRED_FLAG => p_CSP_rec.REQUIRED_FLAG,
p_PROCESS_FLAG => p_CSP_rec.PROCESS_FLAG,
p_ERROR_CODE => p_CSP_rec.ERROR_CODE,
p_ERROR_EXPLANATION => p_CSP_rec.ERROR_EXPLANATION,
p_ATTRIBUTE_CATEGORY => p_CSP_rec.ATTRIBUTE_CATEGORY,
p_ATTRIBUTE1 => p_CSP_rec.ATTRIBUTE1,
p_ATTRIBUTE2 => p_CSP_rec.ATTRIBUTE2,
p_ATTRIBUTE3 => p_CSP_rec.ATTRIBUTE3,
p_ATTRIBUTE4 => p_CSP_rec.ATTRIBUTE4,
p_ATTRIBUTE5 => p_CSP_rec.ATTRIBUTE5,
p_ATTRIBUTE6 => p_CSP_rec.ATTRIBUTE6,
p_ATTRIBUTE7 => p_CSP_rec.ATTRIBUTE7,
p_ATTRIBUTE8 => p_CSP_rec.ATTRIBUTE8,
p_ATTRIBUTE9 => p_CSP_rec.ATTRIBUTE9,
p_ATTRIBUTE10 => p_CSP_rec.ATTRIBUTE10,
p_ATTRIBUTE11 => p_CSP_rec.ATTRIBUTE11,
p_ATTRIBUTE12 => p_CSP_rec.ATTRIBUTE12,
p_ATTRIBUTE13 => p_CSP_rec.ATTRIBUTE13,
p_ATTRIBUTE14 => p_CSP_rec.ATTRIBUTE14,
p_ATTRIBUTE15 => p_CSP_rec.ATTRIBUTE15,
p_MOVEMENT_ID => p_CSP_rec.MOVEMENT_ID,
p_RESERVATION_QUANTITY => p_CSP_rec.RESERVATION_QUANTITY,
p_SHIPPED_QUANTITY => p_CSP_rec.SHIPPED_QUANTITY,
p_TRANSACTION_LINE_NUMBER => p_CSP_rec.TRANSACTION_LINE_NUMBER,
p_TASK_ID => p_CSP_rec.TASK_ID,
p_TO_TASK_ID => p_CSP_rec.TO_TASK_ID,
p_SOURCE_TASK_ID => p_CSP_rec.SOURCE_TASK_ID,
p_PROJECT_ID => p_CSP_rec.PROJECT_ID,
p_SOURCE_PROJECT_ID => p_CSP_rec.SOURCE_PROJECT_ID,
p_PA_EXPENDITURE_ORG_ID => p_CSP_rec.PA_EXPENDITURE_ORG_ID,
p_TO_PROJECT_ID => p_CSP_rec.TO_PROJECT_ID,
p_EXPENDITURE_TYPE => p_CSP_rec.EXPENDITURE_TYPE,
p_FINAL_COMPLETION_FLAG => p_CSP_rec.FINAL_COMPLETION_FLAG,
p_TRANSFER_PERCENTAGE => p_CSP_rec.TRANSFER_PERCENTAGE,
p_TRANSACTION_SEQUENCE_ID => p_CSP_rec.TRANSACTION_SEQUENCE_ID,
p_MATERIAL_ACCOUNT => p_CSP_rec.MATERIAL_ACCOUNT,
p_MATERIAL_OVERHEAD_ACCOUNT => p_CSP_rec.MATERIAL_OVERHEAD_ACCOUNT,
p_RESOURCE_ACCOUNT => p_CSP_rec.RESOURCE_ACCOUNT,
p_OUTSIDE_PROCESSING_ACCOUNT => p_CSP_rec.OUTSIDE_PROCESSING_ACCOUNT,
p_OVERHEAD_ACCOUNT => p_CSP_rec.OVERHEAD_ACCOUNT,
p_FLOW_SCHEDULE => p_CSP_rec.FLOW_SCHEDULE,
p_COST_GROUP_ID => p_CSP_rec.COST_GROUP_ID,
p_DEMAND_CLASS => p_CSP_rec.DEMAND_CLASS,
p_QA_COLLECTION_ID => p_CSP_rec.QA_COLLECTION_ID,
p_KANBAN_CARD_ID => p_CSP_rec.KANBAN_CARD_ID,
p_OVERCOMPLETION_TXN_ID => p_CSP_rec.OVERCOMPLETION_TRANSACTION_ID,
p_OVERCOMPLETION_PRIMARY_QTY => p_CSP_rec.OVERCOMPLETION_PRIMARY_QTY,
p_OVERCOMPLETION_TXN_QTY => p_CSP_rec.OVERCOMPLETION_TRANSACTION_QTY,
-- p_PROCESS_TYPE => p_CSP_rec.PROCESS_TYPE,
p_END_ITEM_UNIT_NUMBER => p_CSP_rec.END_ITEM_UNIT_NUMBER,
p_SCHEDULED_PAYBACK_DATE => p_CSP_rec.SCHEDULED_PAYBACK_DATE,
p_LINE_TYPE_CODE => p_CSP_rec.LINE_TYPE_CODE,
p_PARENT_TRANSACTION_TEMP_ID => p_CSP_rec.PARENT_TRANSACTION_TEMP_ID,
p_PUT_AWAY_STRATEGY_ID => p_CSP_rec.PUT_AWAY_STRATEGY_ID,
p_PUT_AWAY_RULE_ID => p_CSP_rec.PUT_AWAY_RULE_ID,
p_PICK_STRATEGY_ID => p_CSP_rec.PICK_STRATEGY_ID,
p_PICK_RULE_ID => p_CSP_rec.PICK_RULE_ID,
p_COMMON_BOM_SEQ_ID => p_CSP_rec.COMMON_BOM_SEQ_ID,
p_COMMON_ROUTING_SEQ_ID => p_CSP_rec.COMMON_ROUTING_SEQ_ID,
p_COST_TYPE_ID => p_CSP_rec.COST_TYPE_ID,
p_ORG_COST_GROUP_ID => p_CSP_rec.ORG_COST_GROUP_ID,
p_MOVE_ORDER_LINE_ID => p_CSP_rec.MOVE_ORDER_LINE_ID,
p_TASK_GROUP_ID => p_CSP_rec.TASK_GROUP_ID,
p_PICK_SLIP_NUMBER => p_CSP_rec.PICK_SLIP_NUMBER,
p_RESERVATION_ID => p_CSP_rec.RESERVATION_ID,
p_TRANSACTION_STATUS => p_CSP_rec.TRANSACTION_STATUS,
p_STANDARD_OPERATION_ID => p_CSP_rec.STANDARD_OPERATION_ID,
p_TASK_PRIORITY => p_CSP_rec.TASK_PRIORITY,
p_WMS_TASK_TYPE => p_CSP_rec.WMS_TASK_TYPE,
p_PARENT_LINE_ID => p_CSP_rec.PARENT_LINE_ID);
AS_CALLOUT_PKG.Update_material_transactions_AU(
p_api_version_number => 2.0,
p_init_msg_list => FND_API.G_FALSE,
p_commit => FND_API.G_FALSE,
p_validation_level => p_validation_level,
p_identity_salesforce_id => p_identity_salesforce_id,
P_CSP_Rec => P_CSP_Rec,
-- Hint: Add detail tables as parameter lists if it's master-detail relationship.
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);
End Update_material_transactions;
PROCEDURE Delete_material_transactions(
P_Api_Version_Number IN NUMBER,
P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
P_Commit IN VARCHAR2 := FND_API.G_FALSE,
p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
-- P_identity_salesforce_id IN NUMBER := NULL,
P_CSP_Rec IN CSP_Rec_Type,
X_Return_Status OUT NOCOPY VARCHAR2,
X_Msg_Count OUT NOCOPY NUMBER,
X_Msg_Data OUT NOCOPY VARCHAR2
)
IS
l_api_name CONSTANT VARCHAR2(30) := 'DELETE_MATERIAL_TXN';
SAVEPOINT DELETE_MATERIAL_TXN_PVT;
AS_CALLOUT_PKG.Delete_material_transactions_BD(
p_api_version_number => 2.0,
p_init_msg_list => FND_API.G_FALSE,
p_commit => FND_API.G_FALSE,
p_validation_level => p_validation_level,
p_identity_salesforce_id => p_identity_salesforce_id,
P_CSP_Rec => P_CSP_Rec,
-- Hint: Add detail tables as parameter lists if it's master-detail relationship.
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);
CSP_MTL_TRANSACTIONS_PKG.Delete_Row(
p_TRANSACTION_TEMP_ID => p_CSP_rec.TRANSACTION_TEMP_ID);
AS_CALLOUT_PKG.Delete_material_transactions_AD(
p_api_version_number => 2.0,
p_init_msg_list => FND_API.G_FALSE,
p_commit => FND_API.G_FALSE,
p_validation_level => p_validation_level,
p_identity_salesforce_id => p_identity_salesforce_id,
P_CSP_Rec => P_CSP_Rec,
-- Hint: Add detail tables as parameter lists if it's master-detail relationship.
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);
End Delete_material_transactions;
dbms_sql.define_column(p_cur_get_CSP, 42, P_CSP_Rec.SCHEDULE_UPDATE_CODE);
dbms_sql.column_value(p_cur_get_CSP, 42, X_CSP_Rec.SCHEDULE_UPDATE_CODE);
PROCEDURE Gen_Select(
x_select_cl OUT NOCOPY VARCHAR2
)
IS
BEGIN
-- Debug Message
JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Generate Select Begins');
x_select_cl := 'Select ' ||
'CSP_MATERIAL_TRANSACTIONS_V.TRANSACTION_HEADER_ID,' ||
'CSP_MATERIAL_TRANSACTIONS_V.TRANSACTION_TEMP_ID,' ||
'CSP_MATERIAL_TRANSACTIONS_V.SOURCE_CODE,' ||
'CSP_MATERIAL_TRANSACTIONS_V.SOURCE_LINE_ID,' ||
'CSP_MATERIAL_TRANSACTIONS_V.TRANSACTION_MODE,' ||
'CSP_MATERIAL_TRANSACTIONS_V.LOCK_FLAG,' ||
'CSP_MATERIAL_TRANSACTIONS_V.LAST_UPDATE_DATE,' ||
'CSP_MATERIAL_TRANSACTIONS_V.LAST_UPDATED_BY,' ||
'CSP_MATERIAL_TRANSACTIONS_V.CREATION_DATE,' ||
'CSP_MATERIAL_TRANSACTIONS_V.CREATED_BY,' ||
'CSP_MATERIAL_TRANSACTIONS_V.LAST_UPDATE_LOGIN,' ||
'CSP_MATERIAL_TRANSACTIONS_V.REQUEST_ID,' ||
'CSP_MATERIAL_TRANSACTIONS_V.PROGRAM_APPLICATION_ID,' ||
'CSP_MATERIAL_TRANSACTIONS_V.PROGRAM_ID,' ||
'CSP_MATERIAL_TRANSACTIONS_V.PROGRAM_UPDATE_DATE,' ||
'CSP_MATERIAL_TRANSACTIONS_V.INVENTORY_ITEM_ID,' ||
'CSP_MATERIAL_TRANSACTIONS_V.REVISION,' ||
'CSP_MATERIAL_TRANSACTIONS_V.ORGANIZATION_ID,' ||
'CSP_MATERIAL_TRANSACTIONS_V.SUBINVENTORY_CODE,' ||
'CSP_MATERIAL_TRANSACTIONS_V.LOCATOR_ID,' ||
'CSP_MATERIAL_TRANSACTIONS_V.TRANSACTION_QUANTITY,' ||
'CSP_MATERIAL_TRANSACTIONS_V.PRIMARY_QUANTITY,' ||
'CSP_MATERIAL_TRANSACTIONS_V.TRANSACTION_UOM,' ||
'CSP_MATERIAL_TRANSACTIONS_V.TRANSACTION_COST,' ||
'CSP_MATERIAL_TRANSACTIONS_V.TRANSACTION_TYPE_ID,' ||
'CSP_MATERIAL_TRANSACTIONS_V.TRANSACTION_ACTION_ID,' ||
'CSP_MATERIAL_TRANSACTIONS_V.TRANSACTION_SOURCE_TYPE_ID,' ||
'CSP_MATERIAL_TRANSACTIONS_V.TRANSACTION_SOURCE_ID,' ||
'CSP_MATERIAL_TRANSACTIONS_V.TRANSACTION_SOURCE_NAME,' ||
'CSP_MATERIAL_TRANSACTIONS_V.TRANSACTION_DATE,' ||
'CSP_MATERIAL_TRANSACTIONS_V.ACCT_PERIOD_ID,' ||
'CSP_MATERIAL_TRANSACTIONS_V.DISTRIBUTION_ACCOUNT_ID,' ||
'CSP_MATERIAL_TRANSACTIONS_V.TRANSACTION_REFERENCE,' ||
'CSP_MATERIAL_TRANSACTIONS_V.REQUISITION_LINE_ID,' ||
'CSP_MATERIAL_TRANSACTIONS_V.REQUISITION_DISTRIBUTION_ID,' ||
'CSP_MATERIAL_TRANSACTIONS_V.REASON_ID,' ||
'CSP_MATERIAL_TRANSACTIONS_V.LOT_NUMBER,' ||
'CSP_MATERIAL_TRANSACTIONS_V.LOT_EXPIRATION_DATE,' ||
'CSP_MATERIAL_TRANSACTIONS_V.SERIAL_NUMBER,' ||
'CSP_MATERIAL_TRANSACTIONS_V.RECEIVING_DOCUMENT,' ||
'CSP_MATERIAL_TRANSACTIONS_V.DEMAND_ID,' ||
'CSP_MATERIAL_TRANSACTIONS_V.RCV_TRANSACTION_ID,' ||
'CSP_MATERIAL_TRANSACTIONS_V.MOVE_TRANSACTION_ID,' ||
'CSP_MATERIAL_TRANSACTIONS_V.COMPLETION_TRANSACTION_ID,' ||
'CSP_MATERIAL_TRANSACTIONS_V.WIP_ENTITY_TYPE,' ||
'CSP_MATERIAL_TRANSACTIONS_V.SCHEDULE_ID,' ||
'CSP_MATERIAL_TRANSACTIONS_V.REPETITIVE_LINE_ID,' ||
'CSP_MATERIAL_TRANSACTIONS_V.EMPLOYEE_CODE,' ||
'CSP_MATERIAL_TRANSACTIONS_V.PRIMARY_SWITCH,' ||
'CSP_MATERIAL_TRANSACTIONS_V.SCHEDULE_UPDATE_CODE,' ||
'CSP_MATERIAL_TRANSACTIONS_V.SETUP_TEARDOWN_CODE,' ||
'CSP_MATERIAL_TRANSACTIONS_V.ITEM_ORDERING,' ||
'CSP_MATERIAL_TRANSACTIONS_V.NEGATIVE_REQ_FLAG,' ||
'CSP_MATERIAL_TRANSACTIONS_V.OPERATION_SEQ_NUM,' ||
'CSP_MATERIAL_TRANSACTIONS_V.PICKING_LINE_ID,' ||
'CSP_MATERIAL_TRANSACTIONS_V.TRX_SOURCE_LINE_ID,' ||
'CSP_MATERIAL_TRANSACTIONS_V.TRX_SOURCE_DELIVERY_ID,' ||
'CSP_MATERIAL_TRANSACTIONS_V.PHYSICAL_ADJUSTMENT_ID,' ||
'CSP_MATERIAL_TRANSACTIONS_V.CYCLE_COUNT_ID,' ||
'CSP_MATERIAL_TRANSACTIONS_V.RMA_LINE_ID,' ||
'CSP_MATERIAL_TRANSACTIONS_V.CUSTOMER_SHIP_ID,' ||
'CSP_MATERIAL_TRANSACTIONS_V.CURRENCY_CODE,' ||
'CSP_MATERIAL_TRANSACTIONS_V.CURRENCY_CONVERSION_RATE,' ||
'CSP_MATERIAL_TRANSACTIONS_V.CURRENCY_CONVERSION_TYPE,' ||
'CSP_MATERIAL_TRANSACTIONS_V.CURRENCY_CONVERSION_DATE,' ||
'CSP_MATERIAL_TRANSACTIONS_V.USSGL_TRANSACTION_CODE,' ||
'CSP_MATERIAL_TRANSACTIONS_V.VENDOR_LOT_NUMBER,' ||
'CSP_MATERIAL_TRANSACTIONS_V.ENCUMBRANCE_ACCOUNT,' ||
'CSP_MATERIAL_TRANSACTIONS_V.ENCUMBRANCE_AMOUNT,' ||
'CSP_MATERIAL_TRANSACTIONS_V.SHIP_TO_LOCATION,' ||
'CSP_MATERIAL_TRANSACTIONS_V.SHIPMENT_NUMBER,' ||
'CSP_MATERIAL_TRANSACTIONS_V.TRANSFER_COST,' ||
'CSP_MATERIAL_TRANSACTIONS_V.TRANSPORTATION_COST,' ||
'CSP_MATERIAL_TRANSACTIONS_V.TRANSPORTATION_ACCOUNT,' ||
'CSP_MATERIAL_TRANSACTIONS_V.FREIGHT_CODE,' ||
'CSP_MATERIAL_TRANSACTIONS_V.CONTAINERS,' ||
'CSP_MATERIAL_TRANSACTIONS_V.WAYBILL_AIRBILL,' ||
'CSP_MATERIAL_TRANSACTIONS_V.EXPECTED_ARRIVAL_DATE,' ||
'CSP_MATERIAL_TRANSACTIONS_V.TRANSFER_SUBINVENTORY,' ||
'CSP_MATERIAL_TRANSACTIONS_V.TRANSFER_ORGANIZATION,' ||
'CSP_MATERIAL_TRANSACTIONS_V.TRANSFER_TO_LOCATION,' ||
'CSP_MATERIAL_TRANSACTIONS_V.NEW_AVERAGE_COST,' ||
'CSP_MATERIAL_TRANSACTIONS_V.VALUE_CHANGE,' ||
'CSP_MATERIAL_TRANSACTIONS_V.PERCENTAGE_CHANGE,' ||
'CSP_MATERIAL_TRANSACTIONS_V.MATERIAL_ALLOCATION_TEMP_ID,' ||
'CSP_MATERIAL_TRANSACTIONS_V.DEMAND_SOURCE_HEADER_ID,' ||
'CSP_MATERIAL_TRANSACTIONS_V.DEMAND_SOURCE_LINE,' ||
'CSP_MATERIAL_TRANSACTIONS_V.DEMAND_SOURCE_DELIVERY,' ||
'CSP_MATERIAL_TRANSACTIONS_V.ITEM_SEGMENTS,' ||
'CSP_MATERIAL_TRANSACTIONS_V.ITEM_DESCRIPTION,' ||
'CSP_MATERIAL_TRANSACTIONS_V.ITEM_TRX_ENABLED_FLAG,' ||
'CSP_MATERIAL_TRANSACTIONS_V.ITEM_LOCATION_CONTROL_CODE,' ||
'CSP_MATERIAL_TRANSACTIONS_V.ITEM_RESTRICT_SUBINV_CODE,' ||
'CSP_MATERIAL_TRANSACTIONS_V.ITEM_RESTRICT_LOCATORS_CODE,' ||
'CSP_MATERIAL_TRANSACTIONS_V.ITEM_REVISION_QTY_CONTROL_CODE,' ||
'CSP_MATERIAL_TRANSACTIONS_V.ITEM_PRIMARY_UOM_CODE,' ||
'CSP_MATERIAL_TRANSACTIONS_V.ITEM_UOM_CLASS,' ||
'CSP_MATERIAL_TRANSACTIONS_V.ITEM_SHELF_LIFE_CODE,' ||
'CSP_MATERIAL_TRANSACTIONS_V.ITEM_SHELF_LIFE_DAYS,' ||
'CSP_MATERIAL_TRANSACTIONS_V.ITEM_LOT_CONTROL_CODE,' ||
'CSP_MATERIAL_TRANSACTIONS_V.ITEM_SERIAL_CONTROL_CODE,' ||
'CSP_MATERIAL_TRANSACTIONS_V.ITEM_INVENTORY_ASSET_FLAG,' ||
'CSP_MATERIAL_TRANSACTIONS_V.ALLOWED_UNITS_LOOKUP_CODE,' ||
'CSP_MATERIAL_TRANSACTIONS_V.DEPARTMENT_ID,' ||
'CSP_MATERIAL_TRANSACTIONS_V.DEPARTMENT_CODE,' ||
'CSP_MATERIAL_TRANSACTIONS_V.WIP_SUPPLY_TYPE,' ||
'CSP_MATERIAL_TRANSACTIONS_V.SUPPLY_SUBINVENTORY,' ||
'CSP_MATERIAL_TRANSACTIONS_V.SUPPLY_LOCATOR_ID,' ||
'CSP_MATERIAL_TRANSACTIONS_V.VALID_SUBINVENTORY_FLAG,' ||
'CSP_MATERIAL_TRANSACTIONS_V.VALID_LOCATOR_FLAG,' ||
'CSP_MATERIAL_TRANSACTIONS_V.LOCATOR_SEGMENTS,' ||
'CSP_MATERIAL_TRANSACTIONS_V.CURRENT_LOCATOR_CONTROL_CODE,' ||
'CSP_MATERIAL_TRANSACTIONS_V.NUMBER_OF_LOTS_ENTERED,' ||
'CSP_MATERIAL_TRANSACTIONS_V.WIP_COMMIT_FLAG,' ||
'CSP_MATERIAL_TRANSACTIONS_V.NEXT_LOT_NUMBER,' ||
'CSP_MATERIAL_TRANSACTIONS_V.LOT_ALPHA_PREFIX,' ||
'CSP_MATERIAL_TRANSACTIONS_V.NEXT_SERIAL_NUMBER,' ||
'CSP_MATERIAL_TRANSACTIONS_V.SERIAL_ALPHA_PREFIX,' ||
'CSP_MATERIAL_TRANSACTIONS_V.SHIPPABLE_FLAG,' ||
'CSP_MATERIAL_TRANSACTIONS_V.POSTING_FLAG,' ||
'CSP_MATERIAL_TRANSACTIONS_V.REQUIRED_FLAG,' ||
'CSP_MATERIAL_TRANSACTIONS_V.PROCESS_FLAG,' ||
'CSP_MATERIAL_TRANSACTIONS_V.ERROR_CODE,' ||
'CSP_MATERIAL_TRANSACTIONS_V.ERROR_EXPLANATION,' ||
'CSP_MATERIAL_TRANSACTIONS_V.ATTRIBUTE_CATEGORY,' ||
'CSP_MATERIAL_TRANSACTIONS_V.ATTRIBUTE1,' ||
'CSP_MATERIAL_TRANSACTIONS_V.ATTRIBUTE2,' ||
'CSP_MATERIAL_TRANSACTIONS_V.ATTRIBUTE3,' ||
'CSP_MATERIAL_TRANSACTIONS_V.ATTRIBUTE4,' ||
'CSP_MATERIAL_TRANSACTIONS_V.ATTRIBUTE5,' ||
'CSP_MATERIAL_TRANSACTIONS_V.ATTRIBUTE6,' ||
'CSP_MATERIAL_TRANSACTIONS_V.ATTRIBUTE7,' ||
'CSP_MATERIAL_TRANSACTIONS_V.ATTRIBUTE8,' ||
'CSP_MATERIAL_TRANSACTIONS_V.ATTRIBUTE9,' ||
'CSP_MATERIAL_TRANSACTIONS_V.ATTRIBUTE10,' ||
'CSP_MATERIAL_TRANSACTIONS_V.ATTRIBUTE11,' ||
'CSP_MATERIAL_TRANSACTIONS_V.ATTRIBUTE12,' ||
'CSP_MATERIAL_TRANSACTIONS_V.ATTRIBUTE13,' ||
'CSP_MATERIAL_TRANSACTIONS_V.ATTRIBUTE14,' ||
'CSP_MATERIAL_TRANSACTIONS_V.ATTRIBUTE15,' ||
'CSP_MATERIAL_TRANSACTIONS_V.MOVEMENT_ID,' ||
'CSP_MATERIAL_TRANSACTIONS_V.RESERVATION_QUANTITY,' ||
'CSP_MATERIAL_TRANSACTIONS_V.SHIPPED_QUANTITY,' ||
'CSP_MATERIAL_TRANSACTIONS_V.TRANSACTION_LINE_NUMBER,' ||
'CSP_MATERIAL_TRANSACTIONS_V.TASK_ID,' ||
'CSP_MATERIAL_TRANSACTIONS_V.TO_TASK_ID,' ||
'CSP_MATERIAL_TRANSACTIONS_V.SOURCE_TASK_ID,' ||
'CSP_MATERIAL_TRANSACTIONS_V.PROJECT_ID,' ||
'CSP_MATERIAL_TRANSACTIONS_V.SOURCE_PROJECT_ID,' ||
'CSP_MATERIAL_TRANSACTIONS_V.PA_EXPENDITURE_ORG_ID,' ||
'CSP_MATERIAL_TRANSACTIONS_V.TO_PROJECT_ID,' ||
'CSP_MATERIAL_TRANSACTIONS_V.EXPENDITURE_TYPE,' ||
'CSP_MATERIAL_TRANSACTIONS_V.FINAL_COMPLETION_FLAG,' ||
'CSP_MATERIAL_TRANSACTIONS_V.TRANSFER_PERCENTAGE,' ||
'CSP_MATERIAL_TRANSACTIONS_V.TRANSACTION_SEQUENCE_ID,' ||
'CSP_MATERIAL_TRANSACTIONS_V.MATERIAL_ACCOUNT,' ||
'CSP_MATERIAL_TRANSACTIONS_V.MATERIAL_OVERHEAD_ACCOUNT,' ||
'CSP_MATERIAL_TRANSACTIONS_V.RESOURCE_ACCOUNT,' ||
'CSP_MATERIAL_TRANSACTIONS_V.OUTSIDE_PROCESSING_ACCOUNT,' ||
'CSP_MATERIAL_TRANSACTIONS_V.OVERHEAD_ACCOUNT,' ||
'CSP_MATERIAL_TRANSACTIONS_V.FLOW_SCHEDULE,' ||
'CSP_MATERIAL_TRANSACTIONS_V.COST_GROUP_ID,' ||
'CSP_MATERIAL_TRANSACTIONS_V.DEMAND_CLASS,' ||
'CSP_MATERIAL_TRANSACTIONS_V.QA_COLLECTION_ID,' ||
'CSP_MATERIAL_TRANSACTIONS_V.KANBAN_CARD_ID,' ||
'CSP_MATERIAL_TRANSACTIONS_V.OVERCOMPLETION_TRANSACTION_ID,' ||
'CSP_MATERIAL_TRANSACTIONS_V.OVERCOMPLETION_PRIMARY_QTY,' ||
'CSP_MATERIAL_TRANSACTIONS_V.OVERCOMPLETION_TRANSACTION_QTY,' ||
'CSP_MATERIAL_TRANSACTIONS_V.PROCESS_TYPE,' ||
'CSP_MATERIAL_TRANSACTIONS_V.END_ITEM_UNIT_NUMBER,' ||
'CSP_MATERIAL_TRANSACTIONS_V.SCHEDULED_PAYBACK_DATE,' ||
'CSP_MATERIAL_TRANSACTIONS_V.LINE_TYPE_CODE,' ||
'CSP_MATERIAL_TRANSACTIONS_V.PARENT_TRANSACTION_TEMP_ID,' ||
'CSP_MATERIAL_TRANSACTIONS_V.PUT_AWAY_STRATEGY_ID,' ||
'CSP_MATERIAL_TRANSACTIONS_V.PUT_AWAY_RULE_ID,' ||
'CSP_MATERIAL_TRANSACTIONS_V.PICK_STRATEGY_ID,' ||
'CSP_MATERIAL_TRANSACTIONS_V.PICK_RULE_ID,' ||
'CSP_MATERIAL_TRANSACTIONS_V.COMMON_BOM_SEQ_ID,' ||
'CSP_MATERIAL_TRANSACTIONS_V.COMMON_ROUTING_SEQ_ID,' ||
'CSP_MATERIAL_TRANSACTIONS_V.COST_TYPE_ID,' ||
'CSP_MATERIAL_TRANSACTIONS_V.ORG_COST_GROUP_ID,' ||
'CSP_MATERIAL_TRANSACTIONS_V.MOVE_ORDER_LINE_ID,' ||
'CSP_MATERIAL_TRANSACTIONS_V.TASK_GROUP_ID,' ||
'CSP_MATERIAL_TRANSACTIONS_V.PICK_SLIP_NUMBER,' ||
'CSP_MATERIAL_TRANSACTIONS_V.RESERVATION_ID,' ||
'CSP_MATERIAL_TRANSACTIONS_V.TRANSACTION_STATUS,' ||
'from CSP_MATERIAL_TRANSACTIONS_V';
JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Generate Select Ends');
END Gen_Select;
SELECT INSTR(p_rec_item, '%', 1, 1)
FROM DUAL;
SELECT INSTR(p_rec_item, '_', 1, 1)
FROM DUAL;
IF( (P_CSP_Rec.LAST_UPDATE_DATE IS NOT NULL) AND (P_CSP_Rec.LAST_UPDATE_DATE <> FND_API.G_MISS_DATE) )
THEN
-- check if item value contains '%' wildcard
OPEN c_chk_str1(P_CSP_Rec.LAST_UPDATE_DATE);
OPEN c_chk_str2(P_CSP_Rec.LAST_UPDATE_DATE);
x_CSP_where := x_CSP_where || 'P_CSP_Rec.LAST_UPDATE_DATE ' || l_operator || ' :p_LAST_UPDATE_DATE';
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_TRANSACTION_HEADER_ID <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_TRANSACTION_TEMP_ID <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_SOURCE_CODE <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_SOURCE_LINE_ID <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_TRANSACTION_MODE <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_LOCK_FLAG <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_REQUEST_ID <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_INVENTORY_ITEM_ID <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_REVISION <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_ORGANIZATION_ID <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_SUBINVENTORY_CODE <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_LOCATOR_ID <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_TRANSACTION_QUANTITY <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_PRIMARY_QUANTITY <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_TRANSACTION_UOM <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_TRANSACTION_COST <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_TRANSACTION_TYPE_ID <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_TRANSACTION_ACTION_ID <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_TRANSACTION_SOURCE_TYPE_ID <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_TRANSACTION_SOURCE_ID <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_TRANSACTION_SOURCE_NAME <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_TRANSACTION_DATE <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_ACCT_PERIOD_ID <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_DISTRIBUTION_ACCOUNT_ID <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_TRANSACTION_REFERENCE <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_REQUISITION_LINE_ID <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_REQUISITION_DISTRIBUTION_ID <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_REASON_ID <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_LOT_NUMBER <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_LOT_EXPIRATION_DATE <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_SERIAL_NUMBER <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_RECEIVING_DOCUMENT <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_DEMAND_ID <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_RCV_TRANSACTION_ID <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_MOVE_TRANSACTION_ID <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_COMPLETION_TRANSACTION_ID <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_WIP_ENTITY_TYPE <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_SCHEDULE_ID <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_REPETITIVE_LINE_ID <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_EMPLOYEE_CODE <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_PRIMARY_SWITCH <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
PROCEDURE Validate_SCHEDULE_UPDATE_CODE (
P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
P_Validation_mode IN VARCHAR2,
P_SCHEDULE_UPDATE_CODE IN NUMBER,
-- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
X_Return_Status OUT NOCOPY VARCHAR2,
X_Msg_Count OUT NOCOPY NUMBER,
X_Msg_Data OUT NOCOPY VARCHAR2
)
IS
BEGIN
-- Initialize message list if p_init_msg_list is set to TRUE.
IF FND_API.to_Boolean( p_init_msg_list )
THEN
FND_MSG_PUB.initialize;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_SCHEDULE_UPDATE_CODE <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
END Validate_SCHEDULE_UPDATE_CODE;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_SETUP_TEARDOWN_CODE <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_ITEM_ORDERING <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_NEGATIVE_REQ_FLAG <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_OPERATION_SEQ_NUM <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_PICKING_LINE_ID <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_TRX_SOURCE_LINE_ID <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_TRX_SOURCE_DELIVERY_ID <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_PHYSICAL_ADJUSTMENT_ID <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_CYCLE_COUNT_ID <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_RMA_LINE_ID <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_CUSTOMER_SHIP_ID <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_CURRENCY_CODE <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_CURRENCY_CONVERSION_RATE <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_CURRENCY_CONVERSION_TYPE <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_CURRENCY_CONVERSION_DATE <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_USSGL_TRANSACTION_CODE <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_VENDOR_LOT_NUMBER <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_ENCUMBRANCE_ACCOUNT <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_ENCUMBRANCE_AMOUNT <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_SHIP_TO_LOCATION <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_SHIPMENT_NUMBER <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_TRANSFER_COST <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_TRANSPORTATION_COST <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_TRANSPORTATION_ACCOUNT <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_FREIGHT_CODE <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_CONTAINERS <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_WAYBILL_AIRBILL <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_EXPECTED_ARRIVAL_DATE <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_TRANSFER_SUBINVENTORY <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_TRANSFER_ORGANIZATION <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_TRANSFER_TO_LOCATION <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_NEW_AVERAGE_COST <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_VALUE_CHANGE <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_PERCENTAGE_CHANGE <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_MATERIAL_ALLOCATION_TEMP_ID <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_DEMAND_SOURCE_HEADER_ID <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_DEMAND_SOURCE_LINE <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_DEMAND_SOURCE_DELIVERY <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_ITEM_SEGMENTS <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_ITEM_DESCRIPTION <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_ITEM_TRX_ENABLED_FLAG <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_ITEM_LOCATION_CONTROL_CODE <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_ITEM_RESTRICT_SUBINV_CODE <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_ITEM_RESTRICT_LOCATORS_CODE <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_ITEM_REVISION_QTY_CONTROL_CODE <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_ITEM_PRIMARY_UOM_CODE <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_ITEM_UOM_CLASS <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_ITEM_SHELF_LIFE_CODE <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_ITEM_SHELF_LIFE_DAYS <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_ITEM_LOT_CONTROL_CODE <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_ITEM_SERIAL_CONTROL_CODE <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_ITEM_INVENTORY_ASSET_FLAG <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_ALLOWED_UNITS_LOOKUP_CODE <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_DEPARTMENT_ID <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_DEPARTMENT_CODE <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_WIP_SUPPLY_TYPE <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_SUPPLY_SUBINVENTORY <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_SUPPLY_LOCATOR_ID <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_VALID_SUBINVENTORY_FLAG <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_VALID_LOCATOR_FLAG <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_LOCATOR_SEGMENTS <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_CURRENT_LOCATOR_CONTROL_CODE <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_NUMBER_OF_LOTS_ENTERED <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_WIP_COMMIT_FLAG <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_NEXT_LOT_NUMBER <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_LOT_ALPHA_PREFIX <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_NEXT_SERIAL_NUMBER <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_SERIAL_ALPHA_PREFIX <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_SHIPPABLE_FLAG <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_POSTING_FLAG <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_REQUIRED_FLAG <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_PROCESS_FLAG <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_ERROR_CODE <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_ERROR_EXPLANATION <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_MOVEMENT_ID <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_RESERVATION_QUANTITY <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_SHIPPED_QUANTITY <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_TRANSACTION_LINE_NUMBER <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_TASK_ID <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_TO_TASK_ID <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_SOURCE_TASK_ID <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_PROJECT_ID <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_SOURCE_PROJECT_ID <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_PA_EXPENDITURE_ORG_ID <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_TO_PROJECT_ID <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_EXPENDITURE_TYPE <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_FINAL_COMPLETION_FLAG <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_TRANSFER_PERCENTAGE <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_TRANSACTION_SEQUENCE_ID <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_MATERIAL_ACCOUNT <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_MATERIAL_OVERHEAD_ACCOUNT <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_RESOURCE_ACCOUNT <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_OUTSIDE_PROCESSING_ACCOUNT <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_OVERHEAD_ACCOUNT <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_FLOW_SCHEDULE <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_COST_GROUP_ID <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_DEMAND_CLASS <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_QA_COLLECTION_ID <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_KANBAN_CARD_ID <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_OVERCOMPLETION_TRANSACTION_ID <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_OVERCOMPLETION_PRIMARY_QTY <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_OVERCOMPLETION_TRANSACTION_QTY <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_PROCESS_TYPE <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_END_ITEM_UNIT_NUMBER <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_SCHEDULED_PAYBACK_DATE <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_LINE_TYPE_CODE <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_PARENT_TRANSACTION_TEMP_ID <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_PUT_AWAY_STRATEGY_ID <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_PUT_AWAY_RULE_ID <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_PICK_STRATEGY_ID <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_PICK_RULE_ID <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_COMMON_BOM_SEQ_ID <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_COMMON_ROUTING_SEQ_ID <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_COST_TYPE_ID <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_ORG_COST_GROUP_ID <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_MOVE_ORDER_LINE_ID <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_TASK_GROUP_ID <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_PICK_SLIP_NUMBER <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_RESERVATION_ID <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_TRANSACTION_STATUS <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
Validate_SCHEDULE_UPDATE_CODE(
p_init_msg_list => FND_API.G_FALSE,
p_validation_mode => p_validation_mode,
p_SCHEDULE_UPDATE_CODE => P_CSP_Rec.SCHEDULE_UPDATE_CODE,
-- Hint: You may add x_item_property_rec as one of your OUT parameter if you'd like to pass back item property.
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);