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.QP_PSG_UTIL SQL Statements

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

Line: 140


        IF NOT QP_GLOBALS.Equal(p_PSG_rec.last_updated_by,p_old_PSG_rec.last_updated_by)
        THEN
            l_index := l_index + 1;

Line: 143


            l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_LAST_UPDATED_BY;

Line: 146


        IF NOT QP_GLOBALS.Equal(p_PSG_rec.last_update_date,p_old_PSG_rec.last_update_date)
        THEN
            l_index := l_index + 1;

Line: 149


            l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_LAST_UPDATE_DATE;

Line: 152


        IF NOT QP_GLOBALS.Equal(p_PSG_rec.last_update_login,p_old_PSG_rec.last_update_login)
        THEN
            l_index := l_index + 1;

Line: 155


            l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_LAST_UPDATE_LOGIN;

Line: 182


        IF NOT QP_GLOBALS.Equal(p_PSG_rec.program_update_date,p_old_PSG_rec.program_update_date)
        THEN
            l_index := l_index + 1;

Line: 185


            l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_PROGRAM_UPDATE_DATE;

Line: 290


    ELSIF p_attr_id = G_LAST_UPDATED_BY THEN
        l_index := l_index + 1;

Line: 292


        l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_LAST_UPDATED_BY;

Line: 293


    ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN
        l_index := l_index + 1;

Line: 295


        l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_LAST_UPDATE_DATE;

Line: 296


    ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN
        l_index := l_index + 1;

Line: 298


        l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_LAST_UPDATE_LOGIN;

Line: 311


    ELSIF p_attr_id = G_PROGRAM_UPDATE_DATE THEN
        l_index := l_index + 1;

Line: 313


        l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_PROGRAM_UPDATE_DATE;

Line: 447


    IF NOT QP_GLOBALS.Equal(p_PSG_rec.last_updated_by,p_old_PSG_rec.last_updated_by)
    THEN
        NULL;

Line: 452


    IF NOT QP_GLOBALS.Equal(p_PSG_rec.last_update_date,p_old_PSG_rec.last_update_date)
    THEN
        NULL;

Line: 457


    IF NOT QP_GLOBALS.Equal(p_PSG_rec.last_update_login,p_old_PSG_rec.last_update_login)
    THEN
        NULL;

Line: 482


    IF NOT QP_GLOBALS.Equal(p_PSG_rec.program_update_date,p_old_PSG_rec.program_update_date)
    THEN
        NULL;

Line: 611


    IF l_PSG_rec.last_updated_by = FND_API.G_MISS_NUM THEN
        l_PSG_rec.last_updated_by := p_old_PSG_rec.last_updated_by;

Line: 615


    IF l_PSG_rec.last_update_date = FND_API.G_MISS_DATE THEN
        l_PSG_rec.last_update_date := p_old_PSG_rec.last_update_date;

Line: 619


    IF l_PSG_rec.last_update_login = FND_API.G_MISS_NUM THEN
        l_PSG_rec.last_update_login := p_old_PSG_rec.last_update_login;

Line: 639


    IF l_PSG_rec.program_update_date = FND_API.G_MISS_DATE THEN
        l_PSG_rec.program_update_date := p_old_PSG_rec.program_update_date;

Line: 760


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

Line: 764


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

Line: 768


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

Line: 788


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

Line: 830


PROCEDURE Update_Row
(   p_PSG_rec                       IN  QP_Attr_Map_PUB.Psg_Rec_Type
)
IS
BEGIN

    UPDATE  QP_PTE_SEGMENTS
    SET     ATTRIBUTE1                     = p_PSG_rec.attribute1
    ,       ATTRIBUTE10                    = p_PSG_rec.attribute10
    ,       ATTRIBUTE11                    = p_PSG_rec.attribute11
    ,       ATTRIBUTE12                    = p_PSG_rec.attribute12
    ,       ATTRIBUTE13                    = p_PSG_rec.attribute13
    ,       ATTRIBUTE14                    = p_PSG_rec.attribute14
    ,       ATTRIBUTE15                    = p_PSG_rec.attribute15
    ,       ATTRIBUTE2                     = p_PSG_rec.attribute2
    ,       ATTRIBUTE3                     = p_PSG_rec.attribute3
    ,       ATTRIBUTE4                     = p_PSG_rec.attribute4
    ,       ATTRIBUTE5                     = p_PSG_rec.attribute5
    ,       ATTRIBUTE6                     = p_PSG_rec.attribute6
    ,       ATTRIBUTE7                     = p_PSG_rec.attribute7
    ,       ATTRIBUTE8                     = p_PSG_rec.attribute8
    ,       ATTRIBUTE9                     = p_PSG_rec.attribute9
    ,       CONTEXT                        = p_PSG_rec.context
    ,       CREATED_BY                     = p_PSG_rec.created_by
    ,       CREATION_DATE                  = p_PSG_rec.creation_date
    ,       LAST_UPDATED_BY                = p_PSG_rec.last_updated_by
    ,       LAST_UPDATE_DATE               = p_PSG_rec.last_update_date
    ,       LAST_UPDATE_LOGIN              = p_PSG_rec.last_update_login
    ,       LIMITS_ENABLED                 = p_PSG_rec.limits_enabled
    ,       LOV_ENABLED                    = p_PSG_rec.lov_enabled
    ,       PROGRAM_APPLICATION_ID         = p_PSG_rec.program_application_id
    ,       PROGRAM_ID                     = p_PSG_rec.program_id
    ,       PROGRAM_UPDATE_DATE            = p_PSG_rec.program_update_date
    ,       PTE_CODE                       = p_PSG_rec.pte_code
    ,       SEEDED_SOURCING_METHOD         = p_PSG_rec.seeded_sourcing_method
    ,       SEGMENT_ID                     = p_PSG_rec.segment_id
    ,       SEGMENT_LEVEL                  = p_PSG_rec.segment_level
    ,       SEGMENT_PTE_ID                 = p_PSG_rec.segment_pte_id
    ,       SOURCING_ENABLED               = p_PSG_rec.sourcing_enabled
    ,       SOURCING_STATUS                = p_PSG_rec.sourcing_status
    ,       USER_SOURCING_METHOD           = p_PSG_rec.user_sourcing_method
    WHERE   SEGMENT_PTE_ID = p_PSG_rec.segment_pte_id
    ;

Line: 882


            ,   'Update_Row'
            );

Line: 888


END Update_Row;

Line: 892


PROCEDURE Insert_Row
(   p_PSG_rec                       IN  QP_Attr_Map_PUB.Psg_Rec_Type
)
IS
BEGIN
    oe_debug_pub.add('inserting data in psg ..............................');

Line: 899


    INSERT  INTO QP_PTE_SEGMENTS
    (       ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       CONTEXT
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       LIMITS_ENABLED
    ,       LOV_ENABLED
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       PTE_CODE
    ,       SEEDED_SOURCING_METHOD
    ,       SEGMENT_ID
    ,       SEGMENT_LEVEL
    ,       SEGMENT_PTE_ID
    ,       SOURCING_ENABLED
    ,       SOURCING_STATUS
    ,       USER_SOURCING_METHOD
    )
    VALUES
    (       p_PSG_rec.attribute1
    ,       p_PSG_rec.attribute10
    ,       p_PSG_rec.attribute11
    ,       p_PSG_rec.attribute12
    ,       p_PSG_rec.attribute13
    ,       p_PSG_rec.attribute14
    ,       p_PSG_rec.attribute15
    ,       p_PSG_rec.attribute2
    ,       p_PSG_rec.attribute3
    ,       p_PSG_rec.attribute4
    ,       p_PSG_rec.attribute5
    ,       p_PSG_rec.attribute6
    ,       p_PSG_rec.attribute7
    ,       p_PSG_rec.attribute8
    ,       p_PSG_rec.attribute9
    ,       p_PSG_rec.context
    ,       p_PSG_rec.created_by
    ,       p_PSG_rec.creation_date
    ,       p_PSG_rec.last_updated_by
    ,       p_PSG_rec.last_update_date
    ,       p_PSG_rec.last_update_login
    ,       p_PSG_rec.limits_enabled
    ,       p_PSG_rec.lov_enabled
    ,       p_PSG_rec.program_application_id
    ,       p_PSG_rec.program_id
    ,       p_PSG_rec.program_update_date
    ,       p_PSG_rec.pte_code
    ,       p_PSG_rec.seeded_sourcing_method
    ,       p_PSG_rec.segment_id
    ,       p_PSG_rec.segment_level
    ,       p_PSG_rec.segment_pte_id
    ,       p_PSG_rec.sourcing_enabled
    ,       p_PSG_rec.sourcing_status
    ,       p_PSG_rec.user_sourcing_method
    );

Line: 980


            ,   'Insert_Row'
            );

Line: 986


END Insert_Row;

Line: 990


PROCEDURE Delete_Row
(   p_segment_pte_id                IN  NUMBER
)
IS
BEGIN

    DELETE  FROM QP_PTE_SEGMENTS
    WHERE   SEGMENT_PTE_ID = p_segment_pte_id
    ;

Line: 1008


            ,   'Delete_Row'
            );

Line: 1014


END Delete_Row;

Line: 1045


    SELECT  ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       CONTEXT
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       LIMITS_ENABLED
    ,       LOV_ENABLED
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       PTE_CODE
    ,       SEEDED_SOURCING_METHOD
    ,       SEGMENT_ID
    ,       SEGMENT_LEVEL
    ,       SEGMENT_PTE_ID
    ,       SOURCING_ENABLED
    ,       SOURCING_STATUS
    ,       USER_SOURCING_METHOD
    FROM    QP_PTE_SEGMENTS
    WHERE ( SEGMENT_PTE_ID = p_segment_pte_id
    )
    --**OR (    LOOKUP_CODE = p_lookup_code
    OR (    PTE_CODE = p_lookup_code
    );

Line: 1133


        l_PSG_rec.last_updated_by      := l_implicit_rec.LAST_UPDATED_BY;

Line: 1134


        l_PSG_rec.last_update_date     := l_implicit_rec.LAST_UPDATE_DATE;

Line: 1135


        l_PSG_rec.last_update_login    := l_implicit_rec.LAST_UPDATE_LOGIN;

Line: 1140


        l_PSG_rec.program_update_date  := l_implicit_rec.PROGRAM_UPDATE_DATE;

Line: 1204


    SELECT  ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       CONTEXT
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       LIMITS_ENABLED
    ,       LOV_ENABLED
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       PTE_CODE
    ,       SEEDED_SOURCING_METHOD
    ,       SEGMENT_ID
    ,       SEGMENT_LEVEL
    ,       SEGMENT_PTE_ID
    ,       SOURCING_ENABLED
    ,       SOURCING_STATUS
    ,       USER_SOURCING_METHOD
    INTO    l_PSG_rec.attribute1
    ,       l_PSG_rec.attribute10
    ,       l_PSG_rec.attribute11
    ,       l_PSG_rec.attribute12
    ,       l_PSG_rec.attribute13
    ,       l_PSG_rec.attribute14
    ,       l_PSG_rec.attribute15
    ,       l_PSG_rec.attribute2
    ,       l_PSG_rec.attribute3
    ,       l_PSG_rec.attribute4
    ,       l_PSG_rec.attribute5
    ,       l_PSG_rec.attribute6
    ,       l_PSG_rec.attribute7
    ,       l_PSG_rec.attribute8
    ,       l_PSG_rec.attribute9
    ,       l_PSG_rec.context
    ,       l_PSG_rec.created_by
    ,       l_PSG_rec.creation_date
    ,       l_PSG_rec.last_updated_by
    ,       l_PSG_rec.last_update_date
    ,       l_PSG_rec.last_update_login
    ,       l_PSG_rec.limits_enabled
    ,       l_PSG_rec.lov_enabled
    ,       l_PSG_rec.program_application_id
    ,       l_PSG_rec.program_id
    ,       l_PSG_rec.program_update_date
    ,       l_PSG_rec.pte_code
    ,       l_PSG_rec.seeded_sourcing_method
    ,       l_PSG_rec.segment_id
    ,       l_PSG_rec.segment_level
    ,       l_PSG_rec.segment_pte_id
    ,       l_PSG_rec.sourcing_enabled
    ,       l_PSG_rec.sourcing_status
    ,       l_PSG_rec.user_sourcing_method
    FROM    QP_PTE_SEGMENTS
    WHERE   SEGMENT_PTE_ID = p_PSG_rec.segment_pte_id
        FOR UPDATE NOWAIT;

Line: 1314


    AND QP_GLOBALS.Equal(p_PSG_rec.last_updated_by,
                         l_PSG_rec.last_updated_by)
    AND QP_GLOBALS.Equal(p_PSG_rec.last_update_date,
                         l_PSG_rec.last_update_date)
    AND QP_GLOBALS.Equal(p_PSG_rec.last_update_login,
                         l_PSG_rec.last_update_login)
    AND QP_GLOBALS.Equal(p_PSG_rec.limits_enabled,
                         l_PSG_rec.limits_enabled)
    AND QP_GLOBALS.Equal(p_PSG_rec.lov_enabled,
                         l_PSG_rec.lov_enabled)
    AND QP_GLOBALS.Equal(p_PSG_rec.program_application_id,
                         l_PSG_rec.program_application_id)
    AND QP_GLOBALS.Equal(p_PSG_rec.program_id,
                         l_PSG_rec.program_id)
    AND QP_GLOBALS.Equal(p_PSG_rec.program_update_date,
                         l_PSG_rec.program_update_date)
    AND QP_GLOBALS.Equal(p_PSG_rec.pte_code,
                         l_PSG_rec.pte_code)
    AND QP_GLOBALS.Equal(p_PSG_rec.seeded_sourcing_method,
                         l_PSG_rec.seeded_sourcing_method)
    AND QP_GLOBALS.Equal(p_PSG_rec.segment_id,
                         l_PSG_rec.segment_id)
    AND QP_GLOBALS.Equal(p_PSG_rec.segment_level,
                         l_PSG_rec.segment_level)
    AND QP_GLOBALS.Equal(p_PSG_rec.segment_pte_id,
                         l_PSG_rec.segment_pte_id)
    AND QP_GLOBALS.Equal(p_PSG_rec.sourcing_enabled,
                         l_PSG_rec.sourcing_enabled)
    AND QP_GLOBALS.Equal(p_PSG_rec.sourcing_status,
                         l_PSG_rec.sourcing_status)
    AND QP_GLOBALS.Equal(p_PSG_rec.user_sourcing_method,
                         l_PSG_rec.user_sourcing_method)
    THEN

        --  Row has not changed. Set out parameter.

        x_PSG_rec                      := l_PSG_rec;

Line: 1384


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