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

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

Line: 146


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

Line: 149


            l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_LAST_UPDATED_BY;

Line: 152


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

Line: 155


            l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_LAST_UPDATE_DATE;

Line: 158


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

Line: 161


            l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_LAST_UPDATE_LOGIN;

Line: 182


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

Line: 185


            l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_PROGRAM_UPDATE_DATE;

Line: 257


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

Line: 259


        l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_LAST_UPDATED_BY;

Line: 260


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

Line: 262


        l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_LAST_UPDATE_DATE;

Line: 263


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

Line: 265


        l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_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_QUALIFIER_RULES_UTIL.G_PROGRAM_UPDATE_DATE;

Line: 398


    IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.last_updated_by,p_old_QUALIFIER_RULES_rec.last_updated_by)
    THEN
        NULL;

Line: 403


    IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.last_update_date,p_old_QUALIFIER_RULES_rec.last_update_date)
    THEN
        NULL;

Line: 408


    IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.last_update_login,p_old_QUALIFIER_RULES_rec.last_update_login)
    THEN
        NULL;

Line: 428


    IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.program_update_date,p_old_QUALIFIER_RULES_rec.program_update_date)
    THEN
        NULL;

Line: 531


    IF l_QUALIFIER_RULES_rec.last_updated_by = FND_API.G_MISS_NUM THEN
        l_QUALIFIER_RULES_rec.last_updated_by := p_old_QUALIFIER_RULES_rec.last_updated_by;

Line: 535


    IF l_QUALIFIER_RULES_rec.last_update_date = FND_API.G_MISS_DATE THEN
        l_QUALIFIER_RULES_rec.last_update_date := p_old_QUALIFIER_RULES_rec.last_update_date;

Line: 539


    IF l_QUALIFIER_RULES_rec.last_update_login = FND_API.G_MISS_NUM THEN
        l_QUALIFIER_RULES_rec.last_update_login := p_old_QUALIFIER_RULES_rec.last_update_login;

Line: 555


    IF l_QUALIFIER_RULES_rec.program_update_date = FND_API.G_MISS_DATE THEN
        l_QUALIFIER_RULES_rec.program_update_date := p_old_QUALIFIER_RULES_rec.program_update_date;

Line: 656


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

Line: 660


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

Line: 664


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

Line: 680


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

Line: 698


PROCEDURE Update_Row
(   p_QUALIFIER_RULES_rec           IN  QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
)
IS
BEGIN

    UPDATE  QP_QUALIFIER_RULES
    SET     ATTRIBUTE1                     = p_QUALIFIER_RULES_rec.attribute1
    ,       ATTRIBUTE10                    = p_QUALIFIER_RULES_rec.attribute10
    ,       ATTRIBUTE11                    = p_QUALIFIER_RULES_rec.attribute11
    ,       ATTRIBUTE12                    = p_QUALIFIER_RULES_rec.attribute12
    ,       ATTRIBUTE13                    = p_QUALIFIER_RULES_rec.attribute13
    ,       ATTRIBUTE14                    = p_QUALIFIER_RULES_rec.attribute14
    ,       ATTRIBUTE15                    = p_QUALIFIER_RULES_rec.attribute15
    ,       ATTRIBUTE2                     = p_QUALIFIER_RULES_rec.attribute2
    ,       ATTRIBUTE3                     = p_QUALIFIER_RULES_rec.attribute3
    ,       ATTRIBUTE4                     = p_QUALIFIER_RULES_rec.attribute4
    ,       ATTRIBUTE5                     = p_QUALIFIER_RULES_rec.attribute5
    ,       ATTRIBUTE6                     = p_QUALIFIER_RULES_rec.attribute6
    ,       ATTRIBUTE7                     = p_QUALIFIER_RULES_rec.attribute7
    ,       ATTRIBUTE8                     = p_QUALIFIER_RULES_rec.attribute8
    ,       ATTRIBUTE9                     = p_QUALIFIER_RULES_rec.attribute9
    ,       CONTEXT                        = p_QUALIFIER_RULES_rec.context
    ,       CREATED_BY                     = p_QUALIFIER_RULES_rec.created_by
    ,       CREATION_DATE                  = p_QUALIFIER_RULES_rec.creation_date
    ,       DESCRIPTION                    = p_QUALIFIER_RULES_rec.description
    ,       LAST_UPDATED_BY                = p_QUALIFIER_RULES_rec.last_updated_by
    ,       LAST_UPDATE_DATE               = p_QUALIFIER_RULES_rec.last_update_date
    ,       LAST_UPDATE_LOGIN              = p_QUALIFIER_RULES_rec.last_update_login
    ,       NAME                           = p_QUALIFIER_RULES_rec.name
    ,       PROGRAM_APPLICATION_ID         = p_QUALIFIER_RULES_rec.program_application_id
    ,       PROGRAM_ID                     = p_QUALIFIER_RULES_rec.program_id
    ,       PROGRAM_UPDATE_DATE            = p_QUALIFIER_RULES_rec.program_update_date
    ,       QUALIFIER_RULE_ID              = p_QUALIFIER_RULES_rec.qualifier_rule_id
    ,       REQUEST_ID                     = p_QUALIFIER_RULES_rec.request_id
    WHERE   QUALIFIER_RULE_ID = p_QUALIFIER_RULES_rec.qualifier_rule_id
    ;

Line: 744


            ,   'Update_Row'
            );

Line: 750


END Update_Row;

Line: 754


PROCEDURE Insert_Row
(   p_QUALIFIER_RULES_rec           IN  QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
)
IS
BEGIN


   oe_debug_pub.add('executing insert row');

Line: 763


    INSERT  INTO QP_QUALIFIER_RULES
    (       ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       CONTEXT
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       DESCRIPTION
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       NAME
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       QUALIFIER_RULE_ID
    ,       REQUEST_ID
    )
    VALUES
    (       p_QUALIFIER_RULES_rec.attribute1
    ,       p_QUALIFIER_RULES_rec.attribute10
    ,       p_QUALIFIER_RULES_rec.attribute11
    ,       p_QUALIFIER_RULES_rec.attribute12
    ,       p_QUALIFIER_RULES_rec.attribute13
    ,       p_QUALIFIER_RULES_rec.attribute14
    ,       p_QUALIFIER_RULES_rec.attribute15
    ,       p_QUALIFIER_RULES_rec.attribute2
    ,       p_QUALIFIER_RULES_rec.attribute3
    ,       p_QUALIFIER_RULES_rec.attribute4
    ,       p_QUALIFIER_RULES_rec.attribute5
    ,       p_QUALIFIER_RULES_rec.attribute6
    ,       p_QUALIFIER_RULES_rec.attribute7
    ,       p_QUALIFIER_RULES_rec.attribute8
    ,       p_QUALIFIER_RULES_rec.attribute9
    ,       p_QUALIFIER_RULES_rec.context
    ,       p_QUALIFIER_RULES_rec.created_by
    ,       p_QUALIFIER_RULES_rec.creation_date
    ,       p_QUALIFIER_RULES_rec.description
    ,       p_QUALIFIER_RULES_rec.last_updated_by
    ,       p_QUALIFIER_RULES_rec.last_update_date
    ,       p_QUALIFIER_RULES_rec.last_update_login
    ,       p_QUALIFIER_RULES_rec.name
    ,       p_QUALIFIER_RULES_rec.program_application_id
    ,       p_QUALIFIER_RULES_rec.program_id
    ,       p_QUALIFIER_RULES_rec.program_update_date
    ,       p_QUALIFIER_RULES_rec.qualifier_rule_id
    ,       p_QUALIFIER_RULES_rec.request_id
    );

Line: 832


            ,   'Insert_Row'
            );

Line: 838


END Insert_Row;

Line: 842


PROCEDURE Delete_Row
(   p_qualifier_rule_id             IN  NUMBER
)
IS
BEGIN

    -- added by svdeshmu on 1-dec-99 for cascade delete

    QP_Qualifiers_util.Delete_Row(p_qualifier_rule_id=>p_qualifier_rule_id);

Line: 855


    DELETE  FROM QP_QUALIFIER_RULES
    WHERE   QUALIFIER_RULE_ID = p_qualifier_rule_id
    ;

Line: 867


            ,   'Delete_Row'
            );

Line: 873


END Delete_Row;

Line: 884


    SELECT  ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       CONTEXT
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       DESCRIPTION
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       NAME
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       QUALIFIER_RULE_ID
    ,       REQUEST_ID
    INTO    l_QUALIFIER_RULES_rec.attribute1
    ,       l_QUALIFIER_RULES_rec.attribute10
    ,       l_QUALIFIER_RULES_rec.attribute11
    ,       l_QUALIFIER_RULES_rec.attribute12
    ,       l_QUALIFIER_RULES_rec.attribute13
    ,       l_QUALIFIER_RULES_rec.attribute14
    ,       l_QUALIFIER_RULES_rec.attribute15
    ,       l_QUALIFIER_RULES_rec.attribute2
    ,       l_QUALIFIER_RULES_rec.attribute3
    ,       l_QUALIFIER_RULES_rec.attribute4
    ,       l_QUALIFIER_RULES_rec.attribute5
    ,       l_QUALIFIER_RULES_rec.attribute6
    ,       l_QUALIFIER_RULES_rec.attribute7
    ,       l_QUALIFIER_RULES_rec.attribute8
    ,       l_QUALIFIER_RULES_rec.attribute9
    ,       l_QUALIFIER_RULES_rec.context
    ,       l_QUALIFIER_RULES_rec.created_by
    ,       l_QUALIFIER_RULES_rec.creation_date
    ,       l_QUALIFIER_RULES_rec.description
    ,       l_QUALIFIER_RULES_rec.last_updated_by
    ,       l_QUALIFIER_RULES_rec.last_update_date
    ,       l_QUALIFIER_RULES_rec.last_update_login
    ,       l_QUALIFIER_RULES_rec.name
    ,       l_QUALIFIER_RULES_rec.program_application_id
    ,       l_QUALIFIER_RULES_rec.program_id
    ,       l_QUALIFIER_RULES_rec.program_update_date
    ,       l_QUALIFIER_RULES_rec.qualifier_rule_id
    ,       l_QUALIFIER_RULES_rec.request_id
    FROM    QP_QUALIFIER_RULES
    WHERE   QUALIFIER_RULE_ID = p_qualifier_rule_id
    ;

Line: 978


    SELECT  ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       CONTEXT
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       DESCRIPTION
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       NAME
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       QUALIFIER_RULE_ID
    ,       REQUEST_ID
    INTO    l_QUALIFIER_RULES_rec.attribute1
    ,       l_QUALIFIER_RULES_rec.attribute10
    ,       l_QUALIFIER_RULES_rec.attribute11
    ,       l_QUALIFIER_RULES_rec.attribute12
    ,       l_QUALIFIER_RULES_rec.attribute13
    ,       l_QUALIFIER_RULES_rec.attribute14
    ,       l_QUALIFIER_RULES_rec.attribute15
    ,       l_QUALIFIER_RULES_rec.attribute2
    ,       l_QUALIFIER_RULES_rec.attribute3
    ,       l_QUALIFIER_RULES_rec.attribute4
    ,       l_QUALIFIER_RULES_rec.attribute5
    ,       l_QUALIFIER_RULES_rec.attribute6
    ,       l_QUALIFIER_RULES_rec.attribute7
    ,       l_QUALIFIER_RULES_rec.attribute8
    ,       l_QUALIFIER_RULES_rec.attribute9
    ,       l_QUALIFIER_RULES_rec.context
    ,       l_QUALIFIER_RULES_rec.created_by
    ,       l_QUALIFIER_RULES_rec.creation_date
    ,       l_QUALIFIER_RULES_rec.description
    ,       l_QUALIFIER_RULES_rec.last_updated_by
    ,       l_QUALIFIER_RULES_rec.last_update_date
    ,       l_QUALIFIER_RULES_rec.last_update_login
    ,       l_QUALIFIER_RULES_rec.name
    ,       l_QUALIFIER_RULES_rec.program_application_id
    ,       l_QUALIFIER_RULES_rec.program_id
    ,       l_QUALIFIER_RULES_rec.program_update_date
    ,       l_QUALIFIER_RULES_rec.qualifier_rule_id
    ,       l_QUALIFIER_RULES_rec.request_id
    FROM    QP_QUALIFIER_RULES
    WHERE   QUALIFIER_RULE_ID = p_QUALIFIER_RULES_rec.qualifier_rule_id
        FOR UPDATE NOWAIT;

Line: 1078


    AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.last_updated_by,
                         l_QUALIFIER_RULES_rec.last_updated_by)
    AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.last_update_date,
                         l_QUALIFIER_RULES_rec.last_update_date)
    AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.last_update_login,
                         l_QUALIFIER_RULES_rec.last_update_login)
    AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.name,
                         l_QUALIFIER_RULES_rec.name)
    AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.program_application_id,
                         l_QUALIFIER_RULES_rec.program_application_id)
    AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.program_id,
                         l_QUALIFIER_RULES_rec.program_id)
    AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.program_update_date,
                         l_QUALIFIER_RULES_rec.program_update_date)
    AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.qualifier_rule_id,
                         l_QUALIFIER_RULES_rec.qualifier_rule_id)
    AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.request_id,
                         l_QUALIFIER_RULES_rec.request_id)
    THEN

        --  Row has not changed. Set out NOCOPY /* file.sql.39 change */ parameter.
        oe_debug_pub.add('row not changed');

Line: 1136


            oe_debug_pub.add('row  deleted');

Line: 1137


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