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_SOU_UTIL SQL Statements

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

Line: 164


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

Line: 167


            l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_LAST_UPDATED_BY;

Line: 170


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

Line: 173


            l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_LAST_UPDATE_DATE;

Line: 176


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

Line: 179


            l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_LAST_UPDATE_LOGIN;

Line: 194


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

Line: 197


            l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_PROGRAM_UPDATE_DATE;

Line: 308


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

Line: 310


        l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_LAST_UPDATED_BY;

Line: 311


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

Line: 313


        l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_LAST_UPDATE_DATE;

Line: 314


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

Line: 316


        l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_LAST_UPDATE_LOGIN;

Line: 323


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

Line: 325


        l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_PROGRAM_UPDATE_DATE;

Line: 477


    IF NOT QP_GLOBALS.Equal(p_SOU_rec.last_updated_by,p_old_SOU_rec.last_updated_by)
    THEN
        NULL;

Line: 482


    IF NOT QP_GLOBALS.Equal(p_SOU_rec.last_update_date,p_old_SOU_rec.last_update_date)
    THEN
        NULL;

Line: 487


    IF NOT QP_GLOBALS.Equal(p_SOU_rec.last_update_login,p_old_SOU_rec.last_update_login)
    THEN
        NULL;

Line: 502


    IF NOT QP_GLOBALS.Equal(p_SOU_rec.program_update_date,p_old_SOU_rec.program_update_date)
    THEN
        NULL;

Line: 642


    IF l_SOU_rec.last_updated_by = FND_API.G_MISS_NUM THEN
        l_SOU_rec.last_updated_by := p_old_SOU_rec.last_updated_by;

Line: 646


    IF l_SOU_rec.last_update_date = FND_API.G_MISS_DATE THEN
        l_SOU_rec.last_update_date := p_old_SOU_rec.last_update_date;

Line: 650


    IF l_SOU_rec.last_update_login = FND_API.G_MISS_NUM THEN
        l_SOU_rec.last_update_login := p_old_SOU_rec.last_update_login;

Line: 662


    IF l_SOU_rec.program_update_date = FND_API.G_MISS_DATE THEN
        l_SOU_rec.program_update_date := p_old_SOU_rec.program_update_date;

Line: 795


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

Line: 799


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

Line: 803


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

Line: 815


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

Line: 853


PROCEDURE Update_Row
(   p_SOU_rec                       IN  QP_Attr_Map_PUB.Sou_Rec_Type
)
IS
BEGIN

    UPDATE  QP_ATTRIBUTE_SOURCING
    SET     ATTRIBUTE1                     = p_SOU_rec.attribute1
    ,       ATTRIBUTE10                    = p_SOU_rec.attribute10
    ,       ATTRIBUTE11                    = p_SOU_rec.attribute11
    ,       ATTRIBUTE12                    = p_SOU_rec.attribute12
    ,       ATTRIBUTE13                    = p_SOU_rec.attribute13
    ,       ATTRIBUTE14                    = p_SOU_rec.attribute14
    ,       ATTRIBUTE15                    = p_SOU_rec.attribute15
    ,       ATTRIBUTE2                     = p_SOU_rec.attribute2
    ,       ATTRIBUTE3                     = p_SOU_rec.attribute3
    ,       ATTRIBUTE4                     = p_SOU_rec.attribute4
    ,       ATTRIBUTE5                     = p_SOU_rec.attribute5
    ,       ATTRIBUTE6                     = p_SOU_rec.attribute6
    ,       ATTRIBUTE7                     = p_SOU_rec.attribute7
    ,       ATTRIBUTE8                     = p_SOU_rec.attribute8
    ,       ATTRIBUTE9                     = p_SOU_rec.attribute9
    ,       ATTRIBUTE_SOURCING_ID          = p_SOU_rec.attribute_sourcing_id
    ,       ATTRIBUTE_SOURCING_LEVEL       = p_SOU_rec.attribute_sourcing_level
    ,       APPLICATION_ID                 = p_SOU_rec.application_id
    ,       CONTEXT                        = p_SOU_rec.context
    ,       CREATED_BY                     = p_SOU_rec.created_by
    ,       CREATION_DATE                  = p_SOU_rec.creation_date
    ,       ENABLED_FLAG                   = p_SOU_rec.enabled_flag
    ,       LAST_UPDATED_BY                = p_SOU_rec.last_updated_by
    ,       LAST_UPDATE_DATE               = p_SOU_rec.last_update_date
    ,       LAST_UPDATE_LOGIN              = p_SOU_rec.last_update_login
    ,       PROGRAM_APPLICATION_ID         = p_SOU_rec.program_application_id
    ,       PROGRAM_ID                     = p_SOU_rec.program_id
    ,       PROGRAM_UPDATE_DATE            = p_SOU_rec.program_update_date
    ,       REQUEST_TYPE_CODE              = p_SOU_rec.request_type_code
    ,       SEEDED_FLAG                    = p_SOU_rec.seeded_flag
    ,       SEEDED_SOURCING_TYPE           = p_SOU_rec.seeded_sourcing_type
    ,       SEEDED_VALUE_STRING            = p_SOU_rec.seeded_value_string
    ,       SEGMENT_ID                     = p_SOU_rec.segment_id
    ,       USER_SOURCING_TYPE             = p_SOU_rec.user_sourcing_type
    ,       USER_VALUE_STRING              = p_SOU_rec.user_value_string
    WHERE   ATTRIBUTE_SOURCING_ID = p_SOU_rec.attribute_sourcing_id
    ;

Line: 906


            ,   'Update_Row'
            );

Line: 912


END Update_Row;

Line: 916


PROCEDURE Insert_Row
(   p_SOU_rec                       IN  QP_Attr_Map_PUB.Sou_Rec_Type
)
IS
BEGIN

    INSERT  INTO QP_ATTRIBUTE_SOURCING
    (       ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       ATTRIBUTE_SOURCING_ID
    ,       ATTRIBUTE_SOURCING_LEVEL
    ,       APPLICATION_ID
    ,       CONTEXT
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       ENABLED_FLAG
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       REQUEST_TYPE_CODE
    ,       SEEDED_FLAG
    ,       SEEDED_SOURCING_TYPE
    ,       SEEDED_VALUE_STRING
    ,       SEGMENT_ID
    ,       USER_SOURCING_TYPE
    ,       USER_VALUE_STRING
    )
    VALUES
    (       p_SOU_rec.attribute1
    ,       p_SOU_rec.attribute10
    ,       p_SOU_rec.attribute11
    ,       p_SOU_rec.attribute12
    ,       p_SOU_rec.attribute13
    ,       p_SOU_rec.attribute14
    ,       p_SOU_rec.attribute15
    ,       p_SOU_rec.attribute2
    ,       p_SOU_rec.attribute3
    ,       p_SOU_rec.attribute4
    ,       p_SOU_rec.attribute5
    ,       p_SOU_rec.attribute6
    ,       p_SOU_rec.attribute7
    ,       p_SOU_rec.attribute8
    ,       p_SOU_rec.attribute9
    ,       p_SOU_rec.attribute_sourcing_id
    ,       p_SOU_rec.attribute_sourcing_level
    ,       p_SOU_rec.application_id
    ,       p_SOU_rec.context
    ,       p_SOU_rec.created_by
    ,       p_SOU_rec.creation_date
    ,       p_SOU_rec.enabled_flag
    ,       p_SOU_rec.last_updated_by
    ,       p_SOU_rec.last_update_date
    ,       p_SOU_rec.last_update_login
    ,       p_SOU_rec.program_application_id
    ,       p_SOU_rec.program_id
    ,       p_SOU_rec.program_update_date
    ,       p_SOU_rec.request_type_code
    ,       p_SOU_rec.seeded_flag
    ,       p_SOU_rec.seeded_sourcing_type
    ,       p_SOU_rec.seeded_value_string
    ,       p_SOU_rec.segment_id
    ,       p_SOU_rec.user_sourcing_type
    ,       p_SOU_rec.user_value_string
    );

Line: 1005


            ,   'Insert_Row'
            );

Line: 1011


END Insert_Row;

Line: 1015


PROCEDURE Delete_Row
(   p_attribute_sourcing_id         IN  NUMBER
)
IS
BEGIN

    DELETE  FROM QP_ATTRIBUTE_SOURCING
    WHERE   ATTRIBUTE_SOURCING_ID = p_attribute_sourcing_id
    ;

Line: 1033


            ,   'Delete_Row'
            );

Line: 1039


END Delete_Row;

Line: 1070


    SELECT  ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       ATTRIBUTE_SOURCING_ID
    ,       ATTRIBUTE_SOURCING_LEVEL
    ,       APPLICATION_ID
    ,       CONTEXT
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       ENABLED_FLAG
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       REQUEST_TYPE_CODE
    ,       SEEDED_FLAG
    ,       SEEDED_SOURCING_TYPE
    ,       SEEDED_VALUE_STRING
    ,       SEGMENT_ID
    ,       USER_SOURCING_TYPE
    ,       USER_VALUE_STRING
    FROM    QP_ATTRIBUTE_SOURCING
    WHERE ( ATTRIBUTE_SOURCING_ID = p_attribute_sourcing_id
    );

Line: 1162


        l_SOU_rec.last_updated_by      := l_implicit_rec.LAST_UPDATED_BY;

Line: 1163


        l_SOU_rec.last_update_date     := l_implicit_rec.LAST_UPDATE_DATE;

Line: 1164


        l_SOU_rec.last_update_login    := l_implicit_rec.LAST_UPDATE_LOGIN;

Line: 1167


        l_SOU_rec.program_update_date  := l_implicit_rec.PROGRAM_UPDATE_DATE;

Line: 1230


    SELECT  ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       ATTRIBUTE_SOURCING_ID
    ,       ATTRIBUTE_SOURCING_LEVEL
    ,       APPLICATION_ID
    ,       CONTEXT
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       ENABLED_FLAG
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       REQUEST_TYPE_CODE
    ,       SEEDED_FLAG
    ,       SEEDED_SOURCING_TYPE
    ,       SEEDED_VALUE_STRING
    ,       SEGMENT_ID
    ,       USER_SOURCING_TYPE
    ,       USER_VALUE_STRING
    INTO    l_SOU_rec.attribute1
    ,       l_SOU_rec.attribute10
    ,       l_SOU_rec.attribute11
    ,       l_SOU_rec.attribute12
    ,       l_SOU_rec.attribute13
    ,       l_SOU_rec.attribute14
    ,       l_SOU_rec.attribute15
    ,       l_SOU_rec.attribute2
    ,       l_SOU_rec.attribute3
    ,       l_SOU_rec.attribute4
    ,       l_SOU_rec.attribute5
    ,       l_SOU_rec.attribute6
    ,       l_SOU_rec.attribute7
    ,       l_SOU_rec.attribute8
    ,       l_SOU_rec.attribute9
    ,       l_SOU_rec.attribute_sourcing_id
    ,       l_SOU_rec.attribute_sourcing_level
    ,       l_SOU_rec.application_id
    ,       l_SOU_rec.context
    ,       l_SOU_rec.created_by
    ,       l_SOU_rec.creation_date
    ,       l_SOU_rec.enabled_flag
    ,       l_SOU_rec.last_updated_by
    ,       l_SOU_rec.last_update_date
    ,       l_SOU_rec.last_update_login
    ,       l_SOU_rec.program_application_id
    ,       l_SOU_rec.program_id
    ,       l_SOU_rec.program_update_date
    ,       l_SOU_rec.request_type_code
    ,       l_SOU_rec.seeded_flag
    ,       l_SOU_rec.seeded_sourcing_type
    ,       l_SOU_rec.seeded_value_string
    ,       l_SOU_rec.segment_id
    ,       l_SOU_rec.user_sourcing_type
    ,       l_SOU_rec.user_value_string
    FROM    QP_ATTRIBUTE_SOURCING
    WHERE   ATTRIBUTE_SOURCING_ID = p_SOU_rec.attribute_sourcing_id
        FOR UPDATE NOWAIT;

Line: 1350


    AND QP_GLOBALS.Equal(p_SOU_rec.last_updated_by,
                         l_SOU_rec.last_updated_by)
    AND QP_GLOBALS.Equal(p_SOU_rec.last_update_date,
                         l_SOU_rec.last_update_date)
    AND QP_GLOBALS.Equal(p_SOU_rec.last_update_login,
                         l_SOU_rec.last_update_login)
    AND QP_GLOBALS.Equal(p_SOU_rec.program_application_id,
                         l_SOU_rec.program_application_id)
    AND QP_GLOBALS.Equal(p_SOU_rec.program_id,
                         l_SOU_rec.program_id)
    AND QP_GLOBALS.Equal(p_SOU_rec.program_update_date,
                         l_SOU_rec.program_update_date)
    AND QP_GLOBALS.Equal(p_SOU_rec.request_type_code,
                         l_SOU_rec.request_type_code)
    AND QP_GLOBALS.Equal(p_SOU_rec.seeded_flag,
                         l_SOU_rec.seeded_flag)
    AND QP_GLOBALS.Equal(p_SOU_rec.seeded_sourcing_type,
                         l_SOU_rec.seeded_sourcing_type)
    AND QP_GLOBALS.Equal(p_SOU_rec.seeded_value_string,
                         l_SOU_rec.seeded_value_string)
    AND QP_GLOBALS.Equal(p_SOU_rec.segment_id,
                         l_SOU_rec.segment_id)
    AND QP_GLOBALS.Equal(p_SOU_rec.user_sourcing_type,
                         l_SOU_rec.user_sourcing_type)
    AND QP_GLOBALS.Equal(p_SOU_rec.user_value_string,
                         l_SOU_rec.user_value_string)
    THEN

        --  Row has not changed. Set out parameter.

        x_SOU_rec                      := l_SOU_rec;

Line: 1414


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