APPS.OZF_OFFER_MARKET_OPTIONS_PVT SQL Statements

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

Line: 11

SELECT count(distinct(volume_type)) FROM ozf_offer_discount_lines
WHERE offer_id = p_offer_id
AND tier_type = 'PBH';

Line: 17

SELECT count(distinct(uom_code)) FROM ozf_offer_discount_lines
WHERE offer_id = p_offer_id
AND tier_type = 'PBH';

Line: 52

SELECT  QP_QP_Form_Pricing_Attr.Get_Attribute_Value('QP_ATTR_DEFNS_QUALIFIER',qpl.qualifier_context, qpl.qualifier_attribute, qpl.qualifier_attr_value)
FROM qp_qualifiers qpl
WHERE list_header_id = p_qp_list_header_id
AND qualifier_grouping_no = p_qualifier_grouping_no
AND qualifier_context IN ('CUSTOMER', 'CUSTOMER_GROUP','TERRITORY','SOLD_BY')
and qualifier_id = (select min(qualifier_id) from qp_qualifiers WHERE list_header_id = qpl.list_header_id and qualifier_grouping_no = qpl.qualifier_grouping_no);

Line: 83

SELECT 1 FROM dual
      WHERE EXISTS
                (SELECT 'X'
                    FROM ozf_offr_market_options
                    WHERE offer_id = p_offer_id --p_mo_rec.offer_id
                    AND group_number = p_group_number); --p_mo_rec.group_number);

Line: 231

SELECT 1 FROM dual WHERE EXISTS( SELECT 'X' FROM qp_qualifiers WHERE list_header_id = p_list_header_id AND qualifier_grouping_no = p_group_number);

Line: 498

      IF p_validation_mode = JTF_PLSQL_API.g_update THEN
/*      Complete_mo_Rec(
         p_vo_disc_rec        => l_vo_disc_rec,
         x_complete_rec        => l_vo_disc_rec
      );

Line: 626

      SELECT ozf_offr_market_options_s.NEXTVAL
      FROM dual;

Line: 629

      SELECT 1
      FROM ozf_offr_market_options
      WHERE offer_market_option_id = l_id;

Line: 706

OZF_OFFR_MARKET_OPTION_PKG.Insert_Row(
          px_offer_market_option_id => l_market_option_id
          , p_offer_id => l_mo_rec.offer_id
          , p_qp_list_header_id => l_mo_rec.qp_list_header_id
          , p_group_number => l_mo_rec.group_number
          , p_retroactive_flag => l_mo_rec.retroactive_flag
          , p_beneficiary_party_id => l_mo_rec.beneficiary_party_id
          , p_combine_schedule_flag => l_mo_rec.combine_schedule_flag
          , p_volume_tracking_level_code => l_mo_rec.volume_tracking_level_code
          , p_accrue_to_code  => l_mo_rec.accrue_to_code
          , p_precedence => l_mo_rec.precedence
          , px_object_version_number  => l_object_version_number
          , p_creation_date           => SYSDATE
          , p_created_by              => FND_GLOBAL.USER_ID
          , p_last_updated_by         => FND_GLOBAL.USER_ID
          , p_last_update_date        => SYSDATE
          , p_last_update_login       => FND_GLOBAL.conc_login_id
          );

Line: 820

PROCEDURE Update_market_options(
    p_api_version_number         IN   NUMBER,
    p_init_msg_list              IN   VARCHAR2     := FND_API.G_FALSE,
    p_commit                     IN   VARCHAR2     := FND_API.G_FALSE,
    p_validation_level           IN   NUMBER       := FND_API.G_VALID_LEVEL_FULL,

    x_return_status              OUT NOCOPY  VARCHAR2,
    x_msg_count                  OUT NOCOPY  NUMBER,
    x_msg_data                   OUT NOCOPY  VARCHAR2,

    p_mo_rec                     IN   vo_mo_rec_type
)
IS
CURSOR c_get_mo(p_market_option_id NUMBER, p_object_version_number NUMBER) IS
    SELECT *
    FROM ozf_offr_market_options
    WHERE offer_market_option_id = p_market_option_id
    AND object_version_number = p_object_version_number;

Line: 840

l_api_name                  CONSTANT VARCHAR2(30) := 'Update_market_options';

Line: 851

      SAVEPOINT Update_market_options_pvt;

Line: 874

          OZF_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET'
                                           , p_token_name   => 'INFO'
                                           , p_token_value  => 'OZF_MARKET_OPTIONS') ;

Line: 885

                                           , p_token_value  => 'Last_Update_Date') ;

Line: 901

    , p_validation_mode         => JTF_PLSQL_API.g_update
    , x_return_status           => x_return_status
    , x_msg_count               => x_msg_count
    , x_msg_data                => x_msg_data
    , p_mo_rec                  => l_tar_mo_rec
    );

Line: 912

OZF_OFFR_MARKET_OPTION_PKG.Update_Row(
          p_offer_market_option_id => l_tar_mo_rec.offer_market_option_id
          , p_offer_id => l_tar_mo_rec.offer_id
          , p_qp_list_header_id => l_tar_mo_rec.qp_list_header_id
          , p_group_number => l_tar_mo_rec.group_number
          , p_retroactive_flag => l_tar_mo_rec.retroactive_flag
          , p_beneficiary_party_id => l_tar_mo_rec.beneficiary_party_id
          , p_combine_schedule_flag => l_tar_mo_rec.combine_schedule_flag
          , p_volume_tracking_level_code => l_tar_mo_rec.volume_tracking_level_code
          , p_accrue_to_code  => l_tar_mo_rec.accrue_to_code
          , p_precedence => l_tar_mo_rec.precedence
          , p_object_version_number  => l_tar_mo_rec.object_version_number
          , p_creation_date           => SYSDATE
          , p_created_by              => FND_GLOBAL.USER_ID
          , p_last_updated_by         => FND_GLOBAL.USER_ID
          , p_last_update_date        => SYSDATE
          , p_last_update_login       => FND_GLOBAL.conc_login_id
          );

Line: 955

     ROLLBACK TO Update_market_options_pvt;

Line: 965

     ROLLBACK TO Update_market_options_pvt;

Line: 975

     ROLLBACK TO Update_market_options_pvt;

Line: 988

END Update_market_options;

Line: 1023

PROCEDURE Delete_market_options(
    p_api_version_number         IN   NUMBER,
    p_init_msg_list              IN   VARCHAR2     := FND_API.G_FALSE,
    p_commit                     IN   VARCHAR2     := FND_API.G_FALSE,
    p_validation_level           IN   NUMBER       := FND_API.G_VALID_LEVEL_FULL,
    x_return_status              OUT NOCOPY  VARCHAR2,
    x_msg_count                  OUT NOCOPY  NUMBER,
    x_msg_data                   OUT NOCOPY  VARCHAR2,
    p_offer_market_option_id    IN  NUMBER,
    p_object_version_number      IN   NUMBER
    )
    IS
l_api_name                  CONSTANT VARCHAR2(30) := 'Delete_market_options';

Line: 1040

      SAVEPOINT Delete_market_options_PVT;

Line: 1065

      OZF_OFFR_MARKET_OPTION_PKG.Delete_row(
                                                    p_offer_market_option_id  => p_offer_market_option_id
                                                    , p_object_version_number    => p_object_version_number
                                                  );

Line: 1092

     ROLLBACK TO Delete_market_options_PVT;

Line: 1102

     ROLLBACK TO Delete_market_options_PVT;

Line: 1112

     ROLLBACK TO Delete_market_options_PVT;

Line: 1125

    END Delete_market_options;