APPS.QP_SSC_UTIL SQL Statements

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

Line: 152

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

Line: 155

            l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_LAST_UPDATED_BY;

Line: 158

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

Line: 161

            l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_LAST_UPDATE_DATE;

Line: 164

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

Line: 167

            l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_LAST_UPDATE_LOGIN;

Line: 182

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

Line: 185

            l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_PROGRAM_UPDATE_DATE;

Line: 260

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

Line: 262

        l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_LAST_UPDATED_BY;

Line: 263

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

Line: 265

        l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_LAST_UPDATE_DATE;

Line: 266

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

Line: 268

        l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_LAST_UPDATE_LOGIN;

Line: 275

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

Line: 277

        l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_PROGRAM_UPDATE_DATE;

Line: 403

    IF NOT QP_GLOBALS.Equal(p_SSC_rec.last_updated_by,p_old_SSC_rec.last_updated_by)
    THEN
        NULL;

Line: 408

    IF NOT QP_GLOBALS.Equal(p_SSC_rec.last_update_date,p_old_SSC_rec.last_update_date)
    THEN
        NULL;

Line: 413

    IF NOT QP_GLOBALS.Equal(p_SSC_rec.last_update_login,p_old_SSC_rec.last_update_login)
    THEN
        NULL;

Line: 428

    IF NOT QP_GLOBALS.Equal(p_SSC_rec.program_update_date,p_old_SSC_rec.program_update_date)
    THEN
        NULL;

Line: 535

    IF l_SSC_rec.last_updated_by = FND_API.G_MISS_NUM THEN
        l_SSC_rec.last_updated_by := p_old_SSC_rec.last_updated_by;

Line: 539

    IF l_SSC_rec.last_update_date = FND_API.G_MISS_DATE THEN
        l_SSC_rec.last_update_date := p_old_SSC_rec.last_update_date;

Line: 543

    IF l_SSC_rec.last_update_login = FND_API.G_MISS_NUM THEN
        l_SSC_rec.last_update_login := p_old_SSC_rec.last_update_login;

Line: 555

    IF l_SSC_rec.program_update_date = FND_API.G_MISS_DATE THEN
        l_SSC_rec.program_update_date := p_old_SSC_rec.program_update_date;

Line: 660

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

Line: 664

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

Line: 668

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

Line: 680

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

Line: 698

PROCEDURE Update_Row
(   p_SSC_rec                       IN  QP_Attr_Map_PUB.Ssc_Rec_Type
)
IS
BEGIN

    UPDATE  QP_PTE_SOURCE_SYSTEMS
    SET     APPLICATION_SHORT_NAME         = p_SSC_rec.application_short_name
    ,       ATTRIBUTE1                     = p_SSC_rec.attribute1
    ,       ATTRIBUTE10                    = p_SSC_rec.attribute10
    ,       ATTRIBUTE11                    = p_SSC_rec.attribute11
    ,       ATTRIBUTE12                    = p_SSC_rec.attribute12
    ,       ATTRIBUTE13                    = p_SSC_rec.attribute13
    ,       ATTRIBUTE14                    = p_SSC_rec.attribute14
    ,       ATTRIBUTE15                    = p_SSC_rec.attribute15
    ,       ATTRIBUTE2                     = p_SSC_rec.attribute2
    ,       ATTRIBUTE3                     = p_SSC_rec.attribute3
    ,       ATTRIBUTE4                     = p_SSC_rec.attribute4
    ,       ATTRIBUTE5                     = p_SSC_rec.attribute5
    ,       ATTRIBUTE6                     = p_SSC_rec.attribute6
    ,       ATTRIBUTE7                     = p_SSC_rec.attribute7
    ,       ATTRIBUTE8                     = p_SSC_rec.attribute8
    ,       ATTRIBUTE9                     = p_SSC_rec.attribute9
    ,       CONTEXT                        = p_SSC_rec.context
    ,       CREATED_BY                     = p_SSC_rec.created_by
    ,       CREATION_DATE                  = p_SSC_rec.creation_date
    ,       ENABLED_FLAG                   = p_SSC_rec.enabled_flag
    ,       LAST_UPDATED_BY                = p_SSC_rec.last_updated_by
    ,       LAST_UPDATE_DATE               = p_SSC_rec.last_update_date
    ,       LAST_UPDATE_LOGIN              = p_SSC_rec.last_update_login
    ,       PROGRAM_APPLICATION_ID         = p_SSC_rec.program_application_id
    ,       PROGRAM_ID                     = p_SSC_rec.program_id
    ,       PROGRAM_UPDATE_DATE            = p_SSC_rec.program_update_date
    ,       PTE_CODE                       = p_SSC_rec.pte_code
    ,       PTE_SOURCE_SYSTEM_ID           = p_SSC_rec.pte_source_system_id
    WHERE   PTE_SOURCE_SYSTEM_ID = p_SSC_rec.pte_source_system_id
    ;

Line: 744

            ,   'Update_Row'
            );

Line: 750

END Update_Row;

Line: 754

PROCEDURE Insert_Row
(   p_SSC_rec                       IN  QP_Attr_Map_PUB.Ssc_Rec_Type
)
IS
BEGIN

    INSERT  INTO QP_PTE_SOURCE_SYSTEMS
    (       APPLICATION_SHORT_NAME
    ,       ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       CONTEXT
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       ENABLED_FLAG
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       PTE_CODE
    ,       PTE_SOURCE_SYSTEM_ID
    )
    VALUES
    (       p_SSC_rec.application_short_name
    ,       p_SSC_rec.attribute1
    ,       p_SSC_rec.attribute10
    ,       p_SSC_rec.attribute11
    ,       p_SSC_rec.attribute12
    ,       p_SSC_rec.attribute13
    ,       p_SSC_rec.attribute14
    ,       p_SSC_rec.attribute15
    ,       p_SSC_rec.attribute2
    ,       p_SSC_rec.attribute3
    ,       p_SSC_rec.attribute4
    ,       p_SSC_rec.attribute5
    ,       p_SSC_rec.attribute6
    ,       p_SSC_rec.attribute7
    ,       p_SSC_rec.attribute8
    ,       p_SSC_rec.attribute9
    ,       p_SSC_rec.context
    ,       p_SSC_rec.created_by
    ,       p_SSC_rec.creation_date
    ,       p_SSC_rec.enabled_flag
    ,       p_SSC_rec.last_updated_by
    ,       p_SSC_rec.last_update_date
    ,       p_SSC_rec.last_update_login
    ,       p_SSC_rec.program_application_id
    ,       p_SSC_rec.program_id
    ,       p_SSC_rec.program_update_date
    ,       p_SSC_rec.pte_code
    ,       p_SSC_rec.pte_source_system_id
    );

Line: 829

            ,   'Insert_Row'
            );

Line: 835

END Insert_Row;

Line: 839

PROCEDURE Delete_Row
(   p_pte_source_system_id          IN  NUMBER
)
IS
BEGIN

    DELETE  FROM QP_PTE_SOURCE_SYSTEMS
    WHERE   PTE_SOURCE_SYSTEM_ID = p_pte_source_system_id
    ;

Line: 857

            ,   'Delete_Row'
            );

Line: 863

END Delete_Row;

Line: 894

    SELECT  APPLICATION_SHORT_NAME
    ,       ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       CONTEXT
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       ENABLED_FLAG
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       PTE_CODE
    ,       PTE_SOURCE_SYSTEM_ID
    FROM    QP_PTE_SOURCE_SYSTEMS
    WHERE ( PTE_SOURCE_SYSTEM_ID = p_pte_source_system_id
    )
    --**OR (    LOOKUP_CODE = p_lookup_code
    OR (    PTE_CODE = p_lookup_code
    );

Line: 978

        l_SSC_rec.last_updated_by      := l_implicit_rec.LAST_UPDATED_BY;

Line: 979

        l_SSC_rec.last_update_date     := l_implicit_rec.LAST_UPDATE_DATE;

Line: 980

        l_SSC_rec.last_update_login    := l_implicit_rec.LAST_UPDATE_LOGIN;

Line: 983

        l_SSC_rec.program_update_date  := l_implicit_rec.PROGRAM_UPDATE_DATE;

Line: 1041

    SELECT  APPLICATION_SHORT_NAME
    ,       ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       CONTEXT
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       ENABLED_FLAG
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       PTE_CODE
    ,       PTE_SOURCE_SYSTEM_ID
    INTO    l_SSC_rec.application_short_name
    ,       l_SSC_rec.attribute1
    ,       l_SSC_rec.attribute10
    ,       l_SSC_rec.attribute11
    ,       l_SSC_rec.attribute12
    ,       l_SSC_rec.attribute13
    ,       l_SSC_rec.attribute14
    ,       l_SSC_rec.attribute15
    ,       l_SSC_rec.attribute2
    ,       l_SSC_rec.attribute3
    ,       l_SSC_rec.attribute4
    ,       l_SSC_rec.attribute5
    ,       l_SSC_rec.attribute6
    ,       l_SSC_rec.attribute7
    ,       l_SSC_rec.attribute8
    ,       l_SSC_rec.attribute9
    ,       l_SSC_rec.context
    ,       l_SSC_rec.created_by
    ,       l_SSC_rec.creation_date
    ,       l_SSC_rec.enabled_flag
    ,       l_SSC_rec.last_updated_by
    ,       l_SSC_rec.last_update_date
    ,       l_SSC_rec.last_update_login
    ,       l_SSC_rec.program_application_id
    ,       l_SSC_rec.program_id
    ,       l_SSC_rec.program_update_date
    ,       l_SSC_rec.pte_code
    ,       l_SSC_rec.pte_source_system_id
    FROM    QP_PTE_SOURCE_SYSTEMS
    WHERE   PTE_SOURCE_SYSTEM_ID = p_SSC_rec.pte_source_system_id
        FOR UPDATE NOWAIT;

Line: 1143

    AND QP_GLOBALS.Equal(p_SSC_rec.last_updated_by,
                         l_SSC_rec.last_updated_by)
    AND QP_GLOBALS.Equal(p_SSC_rec.last_update_date,
                         l_SSC_rec.last_update_date)
    AND QP_GLOBALS.Equal(p_SSC_rec.last_update_login,
                         l_SSC_rec.last_update_login)
    AND QP_GLOBALS.Equal(p_SSC_rec.program_application_id,
                         l_SSC_rec.program_application_id)
    AND QP_GLOBALS.Equal(p_SSC_rec.program_id,
                         l_SSC_rec.program_id)
    AND QP_GLOBALS.Equal(p_SSC_rec.program_update_date,
                         l_SSC_rec.program_update_date)
    AND QP_GLOBALS.Equal(p_SSC_rec.pte_code,
                         l_SSC_rec.pte_code)
    AND QP_GLOBALS.Equal(p_SSC_rec.pte_source_system_id,
                         l_SSC_rec.pte_source_system_id)
    THEN

        --  Row has not changed. Set out parameter.

        x_SSC_rec                      := l_SSC_rec;

Line: 1197

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