APPS.CSP_MATERIAL_TRANSACTIONS_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 142

      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);

Line: 413

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;

Line: 618

l_api_name                CONSTANT VARCHAR2(30) := 'UPDATE_MATERIAL_TXN';

Line: 627

      SAVEPOINT UPDATE_MATERIAL_TXN_PVT;

Line: 661

          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);

Line: 701

               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;

Line: 885

               FND_MESSAGE.Set_Name('CSP', 'API_MISSING_UPDATE_TARGET');

Line: 897

/*      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');

Line: 902

              FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);

Line: 908

      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');

Line: 928

              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);

Line: 945

      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);

Line: 1163

          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);

Line: 1206

End Update_material_transactions;

Line: 1211

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';

Line: 1231

      SAVEPOINT DELETE_MATERIAL_TXN_PVT;

Line: 1266

          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);

Line: 1297

	 CSP_MTL_TRANSACTIONS_PKG.Delete_Row(
          p_TRANSACTION_TEMP_ID  => p_CSP_rec.TRANSACTION_TEMP_ID);

Line: 1322

          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);

Line: 1365

End Delete_material_transactions;

Line: 1420

      dbms_sql.define_column(p_cur_get_CSP, 42, P_CSP_Rec.SCHEDULE_UPDATE_CODE);

Line: 1614

      dbms_sql.column_value(p_cur_get_CSP, 42, X_CSP_Rec.SCHEDULE_UPDATE_CODE);

Line: 1822

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');

Line: 1830

      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';

Line: 2019

      JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Generate Select Ends');

Line: 2021

END Gen_Select;

Line: 2031

    SELECT INSTR(p_rec_item, '%', 1, 1)
    FROM DUAL;

Line: 2034

    SELECT INSTR(p_rec_item, '_', 1, 1)
    FROM DUAL;

Line: 2061

      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);

Line: 2075

          OPEN c_chk_str2(P_CSP_Rec.LAST_UPDATE_DATE);

Line: 2090

          x_CSP_where := x_CSP_where || 'P_CSP_Rec.LAST_UPDATE_DATE ' || l_operator || ' :p_LAST_UPDATE_DATE';

Line: 2163

      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;

Line: 2210

      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;

Line: 2257

      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;

Line: 2304

      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;

Line: 2351

      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;

Line: 2398

      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;

Line: 2445

      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;

Line: 2499

      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;

Line: 2546

      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;

Line: 2600

      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;

Line: 2647

      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;

Line: 2694

      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;

Line: 2748

      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;

Line: 2802

      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;

Line: 2856

      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;

Line: 2903

      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;

Line: 2957

      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;

Line: 3011

      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;

Line: 3065

      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;

Line: 3112

      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;

Line: 3159

      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;

Line: 3213

      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;

Line: 3267

      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;

Line: 3314

      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;

Line: 3361

      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;

Line: 3408

      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;

Line: 3455

      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;

Line: 3502

      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;

Line: 3549

      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;

Line: 3596

      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;

Line: 3643

      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;

Line: 3690

      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;

Line: 3737

      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;

Line: 3784

      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;

Line: 3831

      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;

Line: 3878

      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;

Line: 3925

      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;

Line: 3972

      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;

Line: 4019

      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;

Line: 4066

      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;

Line: 4113

      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;

Line: 4131

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;

Line: 4160

      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;

Line: 4175

END Validate_SCHEDULE_UPDATE_CODE;

Line: 4207

      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;

Line: 4254

      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;

Line: 4301

      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;

Line: 4348

      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;

Line: 4395

      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;

Line: 4442

      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;

Line: 4489

      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;

Line: 4536

      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;

Line: 4583

      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;

Line: 4630

      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;

Line: 4677

      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;

Line: 4724

      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;

Line: 4771

      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;

Line: 4818

      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;

Line: 4865

      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;

Line: 4912

      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;

Line: 4959

      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;

Line: 5006

      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;

Line: 5053

      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;

Line: 5100

      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;

Line: 5147

      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;

Line: 5194

      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;

Line: 5241

      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;

Line: 5288

      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;

Line: 5335

      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;

Line: 5382

      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;

Line: 5429

      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;

Line: 5476

      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;

Line: 5523

      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;

Line: 5570

      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;

Line: 5617

      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;

Line: 5664

      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;

Line: 5711

      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;

Line: 5758

      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;

Line: 5805

      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;

Line: 5852

      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;

Line: 5899

      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;

Line: 5946

      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;

Line: 5993

      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;

Line: 6040

      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;

Line: 6087

      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;

Line: 6134

      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;

Line: 6181

      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;

Line: 6228

      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;

Line: 6275

      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;

Line: 6322

      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;

Line: 6369

      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;

Line: 6416

      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;

Line: 6463

      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;

Line: 6510

      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;

Line: 6557

      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;

Line: 6604

      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;

Line: 6651

      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;

Line: 6698

      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;

Line: 6745

      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;

Line: 6792

      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;

Line: 6839

      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;

Line: 6886

      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;

Line: 6933

      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;

Line: 6980

      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;

Line: 7027

      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;

Line: 7074

      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;

Line: 7121

      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;

Line: 7168

      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;

Line: 7215

      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;

Line: 7262

      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;

Line: 7309

      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;

Line: 7356

      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;

Line: 7403

      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;

Line: 7450

      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;

Line: 7497

      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;

Line: 7544

      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;

Line: 7591

      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;

Line: 7638

      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;

Line: 7685

      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;

Line: 7732

      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;

Line: 7779

      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;

Line: 7826

      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;

Line: 7873

      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;

Line: 7920

      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;

Line: 7967

      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;

Line: 8014

      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;

Line: 8061

      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;

Line: 8108

      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;

Line: 8155

      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;

Line: 8202

      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;

Line: 8249

      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;

Line: 8296

      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;

Line: 8343

      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;

Line: 8390

      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;

Line: 8437

      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;

Line: 8484

      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;

Line: 8531

      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;

Line: 8578

      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;

Line: 8625

      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;

Line: 8672

      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;

Line: 8719

      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;

Line: 8766

      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;

Line: 8813

      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;

Line: 8860

      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;

Line: 8907

      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;

Line: 8954

      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;

Line: 9001

      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;

Line: 9048

      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;

Line: 9095

      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;

Line: 9142

      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;

Line: 9189

      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;

Line: 9236

      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;

Line: 9283

      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;

Line: 9330

      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;

Line: 9377

      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;

Line: 9424

      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;

Line: 9471

      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;

Line: 9518

      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;

Line: 9565

      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;

Line: 9612

      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;

Line: 9659

      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;

Line: 9706

      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;

Line: 9753

      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;

Line: 9800

      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;

Line: 10374

          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);