APPS.OZF_VOL_OFFR_PKG SQL Statements

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

Line: 38

PROCEDURE Insert_Row(
          px_volume_offer_tiers_id   IN OUT NOCOPY NUMBER,
          p_qp_list_header_id    NUMBER,
          p_discount_type_code    VARCHAR2,
          p_discount    NUMBER,
          p_break_type_code    VARCHAR2,
          p_tier_value_from    NUMBER,
          p_tier_value_to    NUMBER,
          p_volume_type    VARCHAR2,
          p_active    VARCHAR2,
          p_uom_code    VARCHAR2,
          px_object_version_number   IN OUT NOCOPY NUMBER)
 IS
   x_rowid    VARCHAR2(30);

Line: 56

   INSERT INTO ozf_volume_offer_tiers(
           volume_offer_tiers_id,
           qp_list_header_id,
           discount_type_code,
           discount,
           break_type_code,
           tier_value_from,
           tier_value_to,
           volume_type,
           active,
           uom_code,
           object_version_number
   ) VALUES (
           px_volume_offer_tiers_id,
           p_qp_list_header_id,
           p_discount_type_code,
           p_discount,
           p_break_type_code,
           p_tier_value_from,
           p_tier_value_to,
           p_volume_type,
           p_active,
           p_uom_code,
           DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number));

Line: 81

END Insert_Row;

Line: 98

PROCEDURE Update_Row(
          p_volume_offer_tiers_id    NUMBER,
          p_qp_list_header_id    NUMBER,
          p_discount_type_code    VARCHAR2,
          p_discount    NUMBER,
          p_break_type_code    VARCHAR2,
          p_tier_value_from    NUMBER,
          p_tier_value_to    NUMBER,
          p_volume_type    VARCHAR2,
          p_active    VARCHAR2,
          p_uom_code    VARCHAR2,
          px_object_version_number   IN OUT NOCOPY NUMBER
        )
 IS
 BEGIN
 OZF_UTILITY_PVT.debug_message('before inserting');

Line: 117

    Update ozf_volume_offer_tiers
    SET
              volume_offer_tiers_id = DECODE( p_volume_offer_tiers_id, null, volume_offer_tiers_id, FND_API.G_MISS_NUM, null, p_volume_offer_tiers_id),
              qp_list_header_id = DECODE( p_qp_list_header_id, null, qp_list_header_id, FND_API.G_MISS_NUM, null, p_qp_list_header_id),
              discount_type_code = DECODE( p_discount_type_code, null, discount_type_code, FND_API.g_miss_char, null, p_discount_type_code),
              discount = DECODE( p_discount, null, discount, FND_API.G_MISS_NUM, null, p_discount),
              break_type_code = DECODE( p_break_type_code, null, break_type_code, FND_API.g_miss_char, null, p_break_type_code),
              tier_value_from = DECODE( p_tier_value_from, null, tier_value_from, FND_API.G_MISS_NUM, null, p_tier_value_from),
              tier_value_to = DECODE( p_tier_value_to, null, tier_value_to, FND_API.G_MISS_NUM, null, p_tier_value_to),
              volume_type = DECODE( p_volume_type, null, volume_type, FND_API.g_miss_char, null, p_volume_type),
              active = DECODE( p_active, null, active, FND_API.g_miss_char, null, p_active),
              uom_code = DECODE( p_uom_code, null, uom_code, FND_API.g_miss_char, null, p_uom_code),
            object_version_number = object_version_number + 1
   WHERE volume_offer_tiers_id = p_volume_offer_tiers_id
   AND   object_version_number = px_object_version_number;

Line: 137

OZF_UTILITY_PVT.debug_message('after inserting');

Line: 141

END Update_Row;

Line: 158

PROCEDURE Delete_Row(
    p_volume_offer_tiers_id  NUMBER,
    p_object_version_number  NUMBER)
 IS
 BEGIN
   DELETE FROM ozf_volume_offer_tiers
    WHERE volume_offer_tiers_id = p_volume_offer_tiers_id
    AND object_version_number = p_object_version_number;

Line: 169

 END Delete_Row ;

Line: 192

        SELECT *
         FROM ozf_volume_offer_tiers
        WHERE volume_offer_tiers_id =  p_volume_offer_tiers_id
        AND object_version_number = p_object_version_number
        FOR UPDATE OF volume_offer_tiers_id NOWAIT;