APPS.OZF_QP_PRODUCTS_PKG SQL Statements

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

Line: 31

PROCEDURE Insert_Row(
          px_qp_product_id IN OUT NOCOPY NUMBER
          , p_off_discount_product_id NUMBER
          , p_pricing_attribute_id NUMBER
          , px_object_version_number IN OUT NOCOPY NUMBER
          , p_creation_date    DATE
          , p_created_by    NUMBER
          , p_last_update_date    DATE
          , p_last_updated_by    NUMBER
          , p_last_update_login    NUMBER
          )
          IS
          BEGIN
          px_object_version_number := nvl(px_object_version_number,1);

Line: 46

          INSERT INTO ozf_qp_products
          (
            qp_product_id
            , off_discount_product_id
            , pricing_attribute_id
            , object_version_number
            , last_update_date
            , last_updated_by
            , creation_date
            , created_by
            , last_update_login
          )
          values
          (
          DECODE(px_qp_product_id , FND_API.G_MISS_NUM, null, px_qp_product_id)
          , DECODE(p_off_discount_product_id , FND_API.G_MISS_NUM , NULL, p_off_discount_product_id)
          , DECODE(p_pricing_attribute_id, FND_API.G_MISS_NUM, NULL, p_pricing_attribute_id)
          , DECODE(px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number)
          , DECODE(p_last_update_date, FND_API.G_MISS_DATE,sysdate, p_last_update_date)
          , DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id, p_last_updated_by)
          , DECODE(p_creation_date, FND_API.G_MISS_DATE, sysdate, p_creation_date)
          , DECODE(p_created_by , FND_API.G_MISS_NUM,FND_GLOBAL.user_id, p_created_by)
          , DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.conc_login_id, p_last_update_login)
          );

Line: 71

          END Insert_Row;

Line: 85

PROCEDURE Update_Row(
          p_qp_product_id NUMBER
          , p_off_discount_product_id NUMBER
          , p_pricing_attribute_id NUMBER
          , p_object_version_number NUMBER
          , p_last_update_date    DATE
          , p_last_updated_by    NUMBER
          , p_last_update_login    NUMBER
          )
          IS
          BEGIN
          UPDATE ozf_qp_products
          SET
          qp_product_id = DECODE(p_qp_product_id , NULL, qp_product_id, FND_API.G_MISS_NUM, null, p_qp_product_id)
          , off_discount_product_id = DECODE(p_off_discount_product_id, NULL , off_discount_product_id, FND_API.G_MISS_NUM, NULL, p_off_discount_product_id)
          , pricing_attribute_id = DECODE(p_pricing_attribute_id, NULL, pricing_attribute_id, FND_API.G_MISS_NUM,NULL, p_pricing_attribute_id)
          , object_version_number = nvl(p_object_version_number,0)+1
          , last_update_date = DECODE(p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), last_update_date)
          , last_updated_by = DECODE(p_last_updated_by, NULL, last_updated_by, FND_API.G_MISS_NUM,null, p_last_updated_by)
          , last_update_login = DECODE(p_last_update_login, NULL, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)
          WHERE qp_product_id = p_qp_product_id
          AND object_version_number = p_object_version_number;

Line: 112

          END Update_Row;

Line: 127

PROCEDURE Delete_Row(
    p_qp_product_id NUMBER
    , p_object_version_number  NUMBER)
    IS
    BEGIN
   DELETE FROM ozf_qp_products
    WHERE qp_product_id = p_qp_product_id
    AND object_version_number = p_object_version_number;

Line: 138

    END Delete_Row;

Line: 160

        SELECT *
         FROM ozf_qp_products
        WHERE qp_product_id = p_qp_product_id
        AND object_version_number = p_object_version_number
        FOR UPDATE OF qp_product_id NOWAIT;