APPS.OZF_MO_PRESET_TIERS_PKG SQL Statements

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

Line: 33

PROCEDURE Insert_Row(
          px_market_preset_tier_id IN OUT NOCOPY NUMBER
          , p_offer_market_option_id NUMBER
          , p_pbh_offer_discount_id NUMBER
          , p_dis_offer_discount_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: 48

          INSERT INTO ozf_market_preset_tiers
          (
            market_preset_tier_id
            , offer_market_option_id
            , pbh_offer_discount_id
            , dis_offer_discount_id
            , object_version_number
            , last_update_date
            , last_updated_by
            , creation_date
            , created_by
            , last_update_login
          )
          VALUES
          (
            DECODE(px_market_preset_tier_id, FND_API.G_MISS_NUM, null, px_market_preset_tier_id)
            , DECODE(p_offer_market_option_id , FND_API.G_MISS_NUM, null, p_offer_market_option_id)
            , DECODE(p_pbh_offer_discount_id , FND_API.G_MISS_NUM, null, p_pbh_offer_discount_id)
            , DECODE(p_dis_offer_discount_id , FND_API.G_MISS_NUM, null, p_dis_offer_discount_id)
            , DECODE(px_object_version_number, FND_API.G_MISS_NUM, null, 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_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_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login)
          );

Line: 74

          END Insert_Row;

Line: 88

PROCEDURE Update_Row(
          p_market_preset_tier_id IN OUT NOCOPY NUMBER
          , p_offer_market_option_id NUMBER
          , p_pbh_offer_discount_id NUMBER
          , p_dis_offer_discount_id NUMBER
          , p_object_version_number IN OUT NOCOPY NUMBER
          , p_last_update_date    DATE
          , p_last_updated_by    NUMBER
          , p_last_update_login    NUMBER
          )
          IS
          BEGIN
          UPDATE ozf_market_preset_tiers
          set market_preset_tier_id = DECODE(p_market_preset_tier_id, null, market_preset_tier_id, FND_API.G_MISS_NUM, null, p_market_preset_tier_id)
          , offer_market_option_id = DECODE(p_offer_market_option_id , null, offer_market_option_id, FND_API.G_MISS_NUM, null, p_offer_market_option_id)
          , pbh_offer_discount_id = DECODE(p_pbh_offer_discount_id, null, pbh_offer_discount_id, FND_API.G_MISS_NUM, null, p_pbh_offer_discount_id)
          , dis_offer_discount_id =DECODE(p_dis_offer_discount_id, null, dis_offer_discount_id, FND_API.G_MISS_NUM, null, p_dis_offer_discount_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), p_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 market_preset_tier_id = p_market_preset_tier_id
          AND object_version_number = p_object_version_number;

Line: 116

          END Update_Row;

Line: 131

PROCEDURE Delete_Row(
    p_market_preset_tier_id  NUMBER,
    p_object_version_number  NUMBER)
    IS
    BEGIN
    DELETE FROM ozf_market_preset_tiers
    WHERE market_preset_tier_id = p_market_preset_tier_id
    AND object_version_number = p_object_version_number;

Line: 144

    END Delete_Row;

Line: 166

    SELECT * FROM ozf_market_preset_tiers
    WHERE market_preset_tier_id = p_market_preset_tier_id
    AND object_version_Number = p_object_version_number
    FOR UPDATE OF market_preset_tier_id NOWAIT;