APPS.OZF_QP_DISCOUNTS_PKG SQL Statements

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

Line: 31

PROCEDURE Insert_Row(
          px_qp_discount_id IN OUT NOCOPY NUMBER
          , p_list_line_id NUMBER
          , p_offer_discount_line_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: 45

          INSERT INTO ozf_qp_discounts
          (
          ozf_qp_discount_id
          , list_line_id
          , offer_discount_line_id
          , object_version_number
          , creation_date
          , created_by
          , last_updated_by
          , last_update_date
          , last_update_login
          )
          VALUES
          (
          DECODE(px_qp_discount_id, FND_API.G_MISS_NUM, NULL,px_qp_discount_id)
          , DECODE(p_list_line_id, FND_API.G_MISS_NUM, NULL, p_list_line_id)
          , DECODE(p_offer_discount_line_id, FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id)
          , DECODE(px_object_version_number,FND_API.G_MISS_NUM, 1, px_object_version_number)
          , 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_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id, p_last_updated_by)
          , DECODE(p_last_update_date, FND_API.G_MISS_DATE, sysdate, p_last_update_date)
          , DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.conc_login_id,p_last_update_login)
          );

Line: 69

          END Insert_Row;

Line: 83

PROCEDURE Update_Row(
          p_qp_discount_id NUMBER
          , p_list_line_id NUMBER
          , p_offer_discount_line_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_discounts
          SET
          ozf_qp_discount_id = DECODE(p_qp_discount_id, NULL, ozf_qp_discount_id, FND_API.G_MISS_NUM, NULL,  p_qp_discount_id)
          , list_line_id = DECODE(p_list_line_id , NULL, list_line_id, FND_API.G_MISS_NUM, NULL, p_list_line_id)
          , offer_discount_line_id = DECODE(p_offer_discount_line_id, NULL, offer_discount_line_id,FND_API.G_MISS_NUM, null, p_offer_discount_line_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 ozf_qp_discount_id = p_qp_discount_id
          AND object_version_number = p_object_version_number;

Line: 110

          END Update_Row;

Line: 125

PROCEDURE Delete_Row(
    p_qp_discount_id NUMBER
    , p_object_version_number  NUMBER)
    IS
    BEGIN
        DELETE FROM ozf_qp_discounts
        WHERE ozf_qp_discount_id = p_qp_discount_id
        AND object_version_number = p_object_version_number;

Line: 137

    END Delete_Row;

Line: 159

    SELECT * FROM ozf_qp_discounts
    WHERE ozf_qp_discount_id = p_qp_discount_id
    AND object_version_number = p_object_version_number
    FOR UPDATE OF ozf_qp_discount_id NOWAIT;