APPS.WIP_SHOPFLOORMOVE_UTIL SQL Statements

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

Line: 131

    IF l_ShopFloorMove_rec.last_updated_by = FND_API.G_MISS_NUM THEN
        l_ShopFloorMove_rec.last_updated_by := p_old_ShopFloorMove_rec.last_updated_by;

Line: 135

    IF l_ShopFloorMove_rec.last_updated_by_name = FND_API.G_MISS_CHAR THEN
        l_ShopFloorMove_rec.last_updated_by_name := p_old_ShopFloorMove_rec.last_updated_by_name;

Line: 139

    IF l_ShopFloorMove_rec.last_update_date = FND_API.G_MISS_DATE THEN
        l_ShopFloorMove_rec.last_update_date := p_old_ShopFloorMove_rec.last_update_date;

Line: 143

    IF l_ShopFloorMove_rec.last_update_login = FND_API.G_MISS_NUM THEN
        l_ShopFloorMove_rec.last_update_login := p_old_ShopFloorMove_rec.last_update_login;

Line: 203

    IF l_ShopFloorMove_rec.program_update_date = FND_API.G_MISS_DATE THEN
        l_ShopFloorMove_rec.program_update_date := p_old_ShopFloorMove_rec.program_update_date;

Line: 416

    IF l_ShopFloorMove_rec.last_updated_by = FND_API.G_MISS_NUM THEN
        l_ShopFloorMove_rec.last_updated_by := NULL;

Line: 420

    IF l_ShopFloorMove_rec.last_updated_by_name = FND_API.G_MISS_CHAR THEN
        l_ShopFloorMove_rec.last_updated_by_name := NULL;

Line: 424

    IF l_ShopFloorMove_rec.last_update_date = FND_API.G_MISS_DATE THEN
        l_ShopFloorMove_rec.last_update_date := NULL;

Line: 428

    IF l_ShopFloorMove_rec.last_update_login = FND_API.G_MISS_NUM THEN
        l_ShopFloorMove_rec.last_update_login := NULL;

Line: 488

    IF l_ShopFloorMove_rec.program_update_date = FND_API.G_MISS_DATE THEN
        l_ShopFloorMove_rec.program_update_date := NULL;

Line: 585

PROCEDURE Insert_Row
(   p_ShopFloorMove_rec             IN  WIP_Transaction_PUB.Shopfloormove_Rec_Type
)
IS
BEGIN

    INSERT  INTO WIP_MOVE_TXN_INTERFACE
    (       ACCT_PERIOD_ID
    ,       ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       ATTRIBUTE_CATEGORY
    ,       CREATED_BY
    ,       CREATED_BY_NAME
    ,       CREATION_DATE
    ,       ENTITY_TYPE
    ,       FM_DEPARTMENT_CODE
    ,       FM_DEPARTMENT_ID
    ,       FM_INTRAOPERATION_STEP_TYPE
    ,       FM_OPERATION_CODE
    ,       FM_OPERATION_SEQ_NUM
    ,       GROUP_ID
    ,       KANBAN_CARD_ID
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATED_BY_NAME
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       LINE_CODE
    ,       LINE_ID
    ,       ORGANIZATION_CODE
    ,       ORGANIZATION_ID
    ,       OVERCOMPLETION_PRIMARY_QTY
    ,       OVERCOMPLETION_TRANSACTION_ID
    ,       OVERCOMPLETION_TRANSACTION_QTY
    ,       PRIMARY_ITEM_ID
    ,       PRIMARY_QUANTITY
    ,       PRIMARY_UOM
    ,       PROCESS_PHASE
    ,       PROCESS_STATUS
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       QA_COLLECTION_ID
    ,       REASON_ID
    ,       REASON_NAME
    ,       REFERENCE
    ,       REPETITIVE_SCHEDULE_ID
    ,       REQUEST_ID
    ,       SCRAP_ACCOUNT_ID
    ,       SOURCE_CODE
    ,       SOURCE_LINE_ID
    ,       TO_DEPARTMENT_CODE
    ,       TO_DEPARTMENT_ID
    ,       TO_INTRAOPERATION_STEP_TYPE
    ,       TO_OPERATION_CODE
    ,       TO_OPERATION_SEQ_NUM
    ,       TRANSACTION_DATE
    ,       TRANSACTION_ID
    ,       TRANSACTION_QUANTITY
    ,       TRANSACTION_TYPE
    ,       TRANSACTION_UOM
    ,       WIP_ENTITY_ID
    ,       WIP_ENTITY_NAME
    )
    VALUES
    (       p_ShopFloorMove_rec.acct_period_id
    ,       p_ShopFloorMove_rec.attribute1
    ,       p_ShopFloorMove_rec.attribute10
    ,       p_ShopFloorMove_rec.attribute11
    ,       p_ShopFloorMove_rec.attribute12
    ,       p_ShopFloorMove_rec.attribute13
    ,       p_ShopFloorMove_rec.attribute14
    ,       p_ShopFloorMove_rec.attribute15
    ,       p_ShopFloorMove_rec.attribute2
    ,       p_ShopFloorMove_rec.attribute3
    ,       p_ShopFloorMove_rec.attribute4
    ,       p_ShopFloorMove_rec.attribute5
    ,       p_ShopFloorMove_rec.attribute6
    ,       p_ShopFloorMove_rec.attribute7
    ,       p_ShopFloorMove_rec.attribute8
    ,       p_ShopFloorMove_rec.attribute9
    ,       p_ShopFloorMove_rec.attribute_category
    ,       p_ShopFloorMove_rec.created_by
    ,       p_ShopFloorMove_rec.created_by_name
    ,       p_ShopFloorMove_rec.creation_date
    ,       p_ShopFloorMove_rec.entity_type
    ,       p_ShopFloorMove_rec.fm_department_code
    ,       p_ShopFloorMove_rec.fm_department_id
    ,       p_ShopFloorMove_rec.fm_intraop_step_type
    ,       p_ShopFloorMove_rec.fm_operation_code
    ,       p_ShopFloorMove_rec.fm_operation_seq_num
    ,       p_ShopFloorMove_rec.group_id
    ,       p_ShopFloorMove_rec.kanban_card_id
    ,       p_ShopFloorMove_rec.last_updated_by
    ,       p_ShopFloorMove_rec.last_updated_by_name
    ,       p_ShopFloorMove_rec.last_update_date
    ,       p_ShopFloorMove_rec.last_update_login
    ,       p_ShopFloorMove_rec.line_code
    ,       p_ShopFloorMove_rec.line_id
    ,       p_ShopFloorMove_rec.organization_code
    ,       p_ShopFloorMove_rec.organization_id
    ,       p_ShopFloorMove_rec.overcpl_primary_qty
    ,       p_ShopFloorMove_rec.overcpl_transaction_id
    ,       p_ShopFloorMove_rec.overcpl_transaction_qty
    ,       p_ShopFloorMove_rec.primary_item_id
    ,       p_ShopFloorMove_rec.primary_quantity
    ,       p_ShopFloorMove_rec.primary_uom
    ,       p_ShopFloorMove_rec.process_phase
    ,       p_ShopFloorMove_rec.process_status
    ,       p_ShopFloorMove_rec.program_application_id
    ,       p_ShopFloorMove_rec.program_id
    ,       p_ShopFloorMove_rec.program_update_date
    ,       p_ShopFloorMove_rec.qa_collection_id
    ,       p_ShopFloorMove_rec.reason_id
    ,       p_ShopFloorMove_rec.reason_name
    ,       p_ShopFloorMove_rec.reference
    ,       p_ShopFloorMove_rec.repetitive_schedule_id
    ,       p_ShopFloorMove_rec.request_id
    ,       p_ShopFloorMove_rec.scrap_account_id
    ,       p_ShopFloorMove_rec.source_code
    ,       p_ShopFloorMove_rec.source_line_id
    ,       p_ShopFloorMove_rec.to_department_code
    ,       p_ShopFloorMove_rec.to_department_id
    ,       p_ShopFloorMove_rec.to_intraop_step_type
    ,       p_ShopFloorMove_rec.to_operation_code
    ,       p_ShopFloorMove_rec.to_operation_seq_num
    ,       p_ShopFloorMove_rec.transaction_date
    ,       p_ShopFloorMove_rec.transaction_id
    ,       p_ShopFloorMove_rec.transaction_quantity
    ,       p_ShopFloorMove_rec.transaction_type
    ,       p_ShopFloorMove_rec.transaction_uom
    ,       p_ShopFloorMove_rec.wip_entity_id
    ,       p_ShopFloorMove_rec.wip_entity_name
    );

Line: 740

            ,   'Insert_Row'
            );

Line: 746

END Insert_Row;

Line: 750

PROCEDURE Delete_Row
(   p_transaction_id                IN  NUMBER
)
IS
BEGIN

    DELETE  FROM WIP_MOVE_TXN_INTERFACE
    WHERE   TRANSACTION_ID = p_transaction_id
    ;

Line: 768

            ,   'Delete_Row'
            );

Line: 774

END Delete_Row;

Line: 803

    SELECT  ACCT_PERIOD_ID
    ,       ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       ATTRIBUTE_CATEGORY
    ,       CREATED_BY
    ,       CREATED_BY_NAME
    ,       CREATION_DATE
    ,       ENTITY_TYPE
    ,       FM_DEPARTMENT_CODE
    ,       FM_DEPARTMENT_ID
    ,       FM_INTRAOPERATION_STEP_TYPE
    ,       FM_OPERATION_CODE
    ,       FM_OPERATION_SEQ_NUM
    ,       GROUP_ID
    ,       KANBAN_CARD_ID
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATED_BY_NAME
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       LINE_CODE
    ,       LINE_ID
    ,       ORGANIZATION_CODE
    ,       ORGANIZATION_ID
    ,       OVERCOMPLETION_PRIMARY_QTY
    ,       OVERCOMPLETION_TRANSACTION_ID
    ,       OVERCOMPLETION_TRANSACTION_QTY
    ,       PRIMARY_ITEM_ID
    ,       PRIMARY_QUANTITY
    ,       PRIMARY_UOM
    ,       PROCESS_PHASE
    ,       PROCESS_STATUS
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       QA_COLLECTION_ID
    ,       REASON_ID
    ,       REASON_NAME
    ,       REFERENCE
    ,       REPETITIVE_SCHEDULE_ID
    ,       REQUEST_ID
    ,       SCRAP_ACCOUNT_ID
    ,       SOURCE_CODE
    ,       SOURCE_LINE_ID
    ,       TO_DEPARTMENT_CODE
    ,       TO_DEPARTMENT_ID
    ,       TO_INTRAOPERATION_STEP_TYPE
    ,       TO_OPERATION_CODE
    ,       TO_OPERATION_SEQ_NUM
    ,       TRANSACTION_DATE
    ,       TRANSACTION_ID
    ,       TRANSACTION_QUANTITY
    ,       TRANSACTION_TYPE
    ,       TRANSACTION_UOM
    ,       WIP_ENTITY_ID
    ,       WIP_ENTITY_NAME
    FROM    WIP_MOVE_TXN_INTERFACE
    WHERE ( TRANSACTION_ID = nvl(p_transaction_id,FND_API.G_MISS_NUM)
    );

Line: 910

        l_ShopFloorMove_rec.last_updated_by := l_implicit_rec.LAST_UPDATED_BY;

Line: 911

        l_ShopFloorMove_rec.last_updated_by_name := l_implicit_rec.LAST_UPDATED_BY_NAME;

Line: 912

        l_ShopFloorMove_rec.last_update_date := l_implicit_rec.LAST_UPDATE_DATE;

Line: 913

        l_ShopFloorMove_rec.last_update_login := l_implicit_rec.LAST_UPDATE_LOGIN;

Line: 928

        l_ShopFloorMove_rec.program_update_date := l_implicit_rec.PROGRAM_UPDATE_DATE;