APPS.QP_LIMITS_PVT SQL Statements

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

Line: 50

    ELSIF l_LIMITS_rec.operation = QP_GLOBALS.G_OPR_UPDATE
    OR    l_LIMITS_rec.operation = QP_GLOBALS.G_OPR_DELETE
    THEN

        l_LIMITS_rec.db_flag := FND_API.G_TRUE;

Line: 172

           l_LIMITS_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN

            QP_Validate_Limits.Entity
            (   x_return_status               => l_return_status
            ,   p_LIMITS_rec                  => l_LIMITS_rec
            ,   p_old_LIMITS_rec              => l_old_LIMITS_rec
            );

Line: 188

        IF l_LIMITS_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

            QP_Validate_Limits.Entity_Delete
            (   x_return_status               => l_return_status
            ,   p_LIMITS_rec                  => l_LIMITS_rec
            );

Line: 195

        ELSIF l_LIMITS_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN

            QP_Validate_Limits.Entity_Update
            (   x_return_status               => l_return_status
            ,   p_LIMITS_rec                  => l_LIMITS_rec
            );

Line: 232

        IF l_LIMITS_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
        --dbms_output.put_line('Processing Limits - QP_Limits_Util.Delete_Row' || l_return_status);

Line: 234

        oe_debug_pub.add('Processing Limits - QP_Limits_Util.Delete_Row' || l_return_status);

Line: 235

            QP_Limits_Util.Delete_Row
            (   p_limit_id                    => l_LIMITS_rec.limit_id
            );

Line: 243

            l_LIMITS_rec.last_update_date  := SYSDATE;

Line: 244

            l_LIMITS_rec.last_updated_by   := FND_GLOBAL.USER_ID;

Line: 245

            l_LIMITS_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

Line: 247

            IF l_LIMITS_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
            --dbms_output.put_line('Processing Limits - QP_Limits_Util.Update_Row' || l_return_status);

Line: 249

            oe_debug_pub.add('Processing Limits - QP_Limits_Util.Update_Row' || l_return_status);

Line: 250

                QP_Limits_Util.Update_Row (l_LIMITS_rec);

Line: 257

            oe_debug_pub.add('Processing Limits - QP_Limits_Util.Insert_Row' || l_return_status);

Line: 258

                QP_Limits_Util.Insert_Row (l_LIMITS_rec);

Line: 368

        ELSIF l_LIMIT_ATTRS_rec.operation = QP_GLOBALS.G_OPR_UPDATE
        OR    l_LIMIT_ATTRS_rec.operation = QP_GLOBALS.G_OPR_DELETE
        THEN

            l_LIMIT_ATTRS_rec.db_flag := FND_API.G_TRUE;

Line: 485

               l_LIMIT_ATTRS_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN

            --dbms_output.put_line('Processing Limit Attributes- Calling QP_Validate_Limit_Attrs.Entity' || l_return_status);

Line: 506

                QP_Validate_Limit_Attrs.Entity_Insert
                (   x_return_status               => l_return_status
                ,   p_LIMIT_ATTRS_rec             => l_LIMIT_ATTRS_rec
                );

Line: 511

            ELSIF l_LIMIT_ATTRS_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

                QP_Validate_Limit_Attrs.Entity_Delete
                (   x_return_status               => l_return_status
                ,   p_LIMIT_ATTRS_rec             => l_LIMIT_ATTRS_rec
                );

Line: 518

            ELSIF l_LIMIT_ATTRS_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN

                QP_Validate_Limit_Attrs.Entity_Update
                (   x_return_status               => l_return_status
                ,   p_LIMIT_ATTRS_rec             => l_LIMIT_ATTRS_rec
                );

Line: 554

            IF l_LIMIT_ATTRS_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

                QP_Limit_Attrs_Util.Delete_Row
                (   p_limit_attribute_id          => l_LIMIT_ATTRS_rec.limit_attribute_id
                );

Line: 564

                l_LIMIT_ATTRS_rec.last_update_date := SYSDATE;

Line: 565

                l_LIMIT_ATTRS_rec.last_updated_by := FND_GLOBAL.USER_ID;

Line: 566

                l_LIMIT_ATTRS_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

Line: 568

                IF l_LIMIT_ATTRS_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN

                    QP_Limit_Attrs_Util.Update_Row (l_LIMIT_ATTRS_rec);

Line: 578

            oe_debug_pub.add('Processing Limit Attributes- Calling QP_Limit_Attrs_Util.Insert_Row' || l_return_status);

Line: 579

                    QP_Limit_Attrs_Util.Insert_Row (l_LIMIT_ATTRS_rec);

Line: 727

        ELSIF l_LIMIT_BALANCES_rec.operation = QP_GLOBALS.G_OPR_UPDATE
        OR    l_LIMIT_BALANCES_rec.operation = QP_GLOBALS.G_OPR_DELETE
        THEN

            l_LIMIT_BALANCES_rec.db_flag := FND_API.G_TRUE;

Line: 852

            IF l_LIMIT_BALANCES_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

                QP_Validate_Limit_Balances.Entity_Delete
                (   x_return_status               => l_return_status
                ,   p_LIMIT_BALANCES_rec          => l_LIMIT_BALANCES_rec
                );

Line: 885

            IF l_LIMIT_BALANCES_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

                QP_Limit_Balances_Util.Delete_Row
                (   p_limit_balance_id            => l_LIMIT_BALANCES_rec.limit_balance_id
                );

Line: 895

                l_LIMIT_BALANCES_rec.last_update_date := SYSDATE;

Line: 896

                l_LIMIT_BALANCES_rec.last_updated_by := FND_GLOBAL.USER_ID;

Line: 897

                l_LIMIT_BALANCES_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

Line: 899

                IF l_LIMIT_BALANCES_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN

                    QP_Limit_Balances_Util.Update_Row (l_LIMIT_BALANCES_rec);

Line: 909

            oe_debug_pub.add('Processing Limit Balances - Calling QP_Limit_Balances_Util.Insert_Row ' || l_return_status);

Line: 910

                    QP_Limit_Balances_Util.Insert_Row (l_LIMIT_BALANCES_rec);