eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WIP_WIP_ENTITIES_UTIL SQL Statements

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

Line: 35


    IF l_Wip_Entities_rec.last_updated_by = FND_API.G_MISS_NUM THEN
        l_Wip_Entities_rec.last_updated_by := p_old_Wip_Entities_rec.last_updated_by;

Line: 39


    IF l_Wip_Entities_rec.last_update_date = FND_API.G_MISS_DATE THEN
        l_Wip_Entities_rec.last_update_date := p_old_Wip_Entities_rec.last_update_date;

Line: 43


    IF l_Wip_Entities_rec.last_update_login = FND_API.G_MISS_NUM THEN
        l_Wip_Entities_rec.last_update_login := p_old_Wip_Entities_rec.last_update_login;

Line: 63


    IF l_Wip_Entities_rec.program_update_date = FND_API.G_MISS_DATE THEN
        l_Wip_Entities_rec.program_update_date := p_old_Wip_Entities_rec.program_update_date;

Line: 108


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

Line: 112


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

Line: 116


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

Line: 136


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

Line: 158


PROCEDURE Update_Row
(   p_Wip_Entities_rec              IN  WIP_Work_Order_PUB.Wip_Entities_Rec_Type
)
IS
BEGIN

    UPDATE  WIP_ENTITIES
    SET     CREATED_BY                     = p_Wip_Entities_rec.created_by
    ,       CREATION_DATE                  = p_Wip_Entities_rec.creation_date
    ,       DESCRIPTION                    = p_Wip_Entities_rec.description
    ,       ENTITY_TYPE                    = p_Wip_Entities_rec.entity_type
    ,       LAST_UPDATED_BY                = p_Wip_Entities_rec.last_updated_by
    ,       LAST_UPDATE_DATE               = p_Wip_Entities_rec.last_update_date
    ,       LAST_UPDATE_LOGIN              = p_Wip_Entities_rec.last_update_login
    ,       ORGANIZATION_ID                = p_Wip_Entities_rec.organization_id
    ,       PRIMARY_ITEM_ID                = p_Wip_Entities_rec.primary_item_id
    ,       PROGRAM_APPLICATION_ID         = p_Wip_Entities_rec.program_application_id
    ,       PROGRAM_ID                     = p_Wip_Entities_rec.program_id
    ,       PROGRAM_UPDATE_DATE            = p_Wip_Entities_rec.program_update_date
    ,       REQUEST_ID                     = p_Wip_Entities_rec.request_id
    ,       WIP_ENTITY_ID                  = p_Wip_Entities_rec.wip_entity_id
    ,       WIP_ENTITY_NAME                = p_Wip_Entities_rec.wip_entity_name
    WHERE   WIP_ENTITY_ID = p_Wip_Entities_rec.wip_entity_id
    ;

Line: 191


            ,   'Update_Row'
            );

Line: 197


END Update_Row;

Line: 201


PROCEDURE Insert_Row
(   p_Wip_Entities_rec              IN  WIP_Work_Order_PUB.Wip_Entities_Rec_Type
)
IS
BEGIN

    INSERT  INTO WIP_ENTITIES
    (       CREATED_BY
    ,       CREATION_DATE
    ,       DESCRIPTION
    ,       ENTITY_TYPE
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       ORGANIZATION_ID
    ,       PRIMARY_ITEM_ID
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       REQUEST_ID
    ,       WIP_ENTITY_ID
    ,       WIP_ENTITY_NAME
    )
    VALUES
    (       p_Wip_Entities_rec.created_by
    ,       p_Wip_Entities_rec.creation_date
    ,       p_Wip_Entities_rec.description
    ,       p_Wip_Entities_rec.entity_type
    ,       p_Wip_Entities_rec.last_updated_by
    ,       p_Wip_Entities_rec.last_update_date
    ,       p_Wip_Entities_rec.last_update_login
    ,       p_Wip_Entities_rec.organization_id
    ,       p_Wip_Entities_rec.primary_item_id
    ,       p_Wip_Entities_rec.program_application_id
    ,       p_Wip_Entities_rec.program_id
    ,       p_Wip_Entities_rec.program_update_date
    ,       p_Wip_Entities_rec.request_id
    ,       p_Wip_Entities_rec.wip_entity_id
    ,       p_Wip_Entities_rec.wip_entity_name
    );

Line: 250


            ,   'Insert_Row'
            );

Line: 256


END Insert_Row;

Line: 260


PROCEDURE Delete_Row
(   p_wip_entity_id                 IN  NUMBER
)
IS
BEGIN

    DELETE  FROM WIP_ENTITIES
    WHERE   WIP_ENTITY_ID = p_wip_entity_id
    ;

Line: 278


            ,   'Delete_Row'
            );

Line: 284


END Delete_Row;

Line: 295


    SELECT  CREATED_BY
    ,       CREATION_DATE
    ,       DESCRIPTION
    ,       ENTITY_TYPE
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       ORGANIZATION_ID
    ,       PRIMARY_ITEM_ID
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       REQUEST_ID
    ,       WIP_ENTITY_ID
    ,       WIP_ENTITY_NAME
    INTO    l_Wip_Entities_rec.created_by
    ,       l_Wip_Entities_rec.creation_date
    ,       l_Wip_Entities_rec.description
    ,       l_Wip_Entities_rec.entity_type
    ,       l_Wip_Entities_rec.last_updated_by
    ,       l_Wip_Entities_rec.last_update_date
    ,       l_Wip_Entities_rec.last_update_login
    ,       l_Wip_Entities_rec.organization_id
    ,       l_Wip_Entities_rec.primary_item_id
    ,       l_Wip_Entities_rec.program_application_id
    ,       l_Wip_Entities_rec.program_id
    ,       l_Wip_Entities_rec.program_update_date
    ,       l_Wip_Entities_rec.request_id
    ,       l_Wip_Entities_rec.wip_entity_id
    ,       l_Wip_Entities_rec.wip_entity_name
    FROM    WIP_ENTITIES
    WHERE   WIP_ENTITY_ID = p_wip_entity_id
    ;

Line: 359


    SELECT  CREATED_BY
    ,       CREATION_DATE
    ,       DESCRIPTION
    ,       ENTITY_TYPE
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       ORGANIZATION_ID
    ,       PRIMARY_ITEM_ID
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       REQUEST_ID
    ,       WIP_ENTITY_ID
    ,       WIP_ENTITY_NAME
    INTO    l_Wip_Entities_rec.created_by
    ,       l_Wip_Entities_rec.creation_date
    ,       l_Wip_Entities_rec.description
    ,       l_Wip_Entities_rec.entity_type
    ,       l_Wip_Entities_rec.last_updated_by
    ,       l_Wip_Entities_rec.last_update_date
    ,       l_Wip_Entities_rec.last_update_login
    ,       l_Wip_Entities_rec.organization_id
    ,       l_Wip_Entities_rec.primary_item_id
    ,       l_Wip_Entities_rec.program_application_id
    ,       l_Wip_Entities_rec.program_id
    ,       l_Wip_Entities_rec.program_update_date
    ,       l_Wip_Entities_rec.request_id
    ,       l_Wip_Entities_rec.wip_entity_id
    ,       l_Wip_Entities_rec.wip_entity_name
    FROM    WIP_ENTITIES
    WHERE   WIP_ENTITY_ID = p_Wip_Entities_rec.wip_entity_id
        FOR UPDATE NOWAIT;

Line: 403


    AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.last_updated_by,
                         l_Wip_Entities_rec.last_updated_by)
    AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.last_update_date,
                         l_Wip_Entities_rec.last_update_date)
    AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.last_update_login,
                         l_Wip_Entities_rec.last_update_login)
    AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.organization_id,
                         l_Wip_Entities_rec.organization_id)
    AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.primary_item_id,
                         l_Wip_Entities_rec.primary_item_id)
    AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.program_application_id,
                         l_Wip_Entities_rec.program_application_id)
    AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.program_id,
                         l_Wip_Entities_rec.program_id)
    AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.program_update_date,
                         l_Wip_Entities_rec.program_update_date)
    AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.request_id,
                         l_Wip_Entities_rec.request_id)
    AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.wip_entity_id,
                         l_Wip_Entities_rec.wip_entity_id)
    AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.wip_entity_name,
                         l_Wip_Entities_rec.wip_entity_name)
    THEN

        --  Row has not changed. Set out parameter.

        x_Wip_Entities_rec             := l_Wip_Entities_rec;

Line: 462


            FND_MESSAGE.SET_NAME('WIP','OE_LOCK_ROW_DELETED');