APPS.OZF_QUAL_MARKET_OPTION_PVT SQL Statements

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

Line: 40

ELSIF p_validation_mode = JTF_PLSQL_API.g_update THEN

    IF p_qual_mo_rec.qualifier_market_option_id = FND_API.G_MISS_NUM THEN
        OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','qualifier_market_option_id');

Line: 279

      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: 409

      SELECT ozf_qualifier_market_option_s.NEXTVAL
      FROM dual;

Line: 412

      SELECT 1
      FROM ozf_qualifier_market_option
      WHERE qualifier_market_option_id = l_id;

Line: 488

OZF_QUAL_MARKET_OPTION_PKG.Insert_Row(
        px_qualifier_market_option_id => l_qual_market_option_id
        , p_offer_market_option_id => l_qual_mo_rec.offer_market_option_id
        , p_qp_qualifier_id => l_qual_mo_rec.qp_qualifier_id
        , 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: 558

PROCEDURE update_qual_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 VARCHAR2    := FND_API.G_VALID_LEVEL_FULL

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

    , p_qual_mo_rec                 IN qual_mo_rec_type
    )
IS
CURSOR c_get_qual_mo(p_qualifier_market_option_id NUMBER, p_object_version_number NUMBER) IS
    SELECT *
    FROM ozf_qualifier_market_option
    WHERE qualifier_market_option_id = p_qualifier_market_option_id
    AND object_version_number = p_object_version_number;

Line: 578

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

Line: 589

      SAVEPOINT update_qual_market_options_pvt;

Line: 612

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

Line: 623

                                           , p_token_value  => 'Last_Update_Date') ;

Line: 639

, 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_qual_mo_rec         => p_qual_mo_rec
);

Line: 649

OZF_QUAL_MARKET_OPTION_PKG.Update_Row(
        p_qualifier_market_option_id => p_qual_mo_rec.qualifier_market_option_id
        , p_offer_market_option_id   => p_qual_mo_rec.offer_market_option_id
        , p_qp_qualifier_id          => p_qual_mo_rec.qp_qualifier_id
        , p_object_version_number    => p_qual_mo_rec.object_version_number
        , p_last_updated_by         => FND_GLOBAL.USER_ID
        , p_last_update_date        => SYSDATE
        , p_last_update_login       => FND_GLOBAL.conc_login_id
        );

Line: 682

     ROLLBACK TO update_qual_market_options_pvt;

Line: 692

     ROLLBACK TO update_qual_market_options_pvt;

Line: 702

     ROLLBACK TO update_qual_market_options_pvt;

Line: 715

END update_qual_market_options;

Line: 718

PROCEDURE Delete_qual_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 VARCHAR2
    , x_msg_data                OUT NOCOPY VARCHAR2
    , p_qualifier_market_option_id IN NUMBER
    , p_object_version_number    IN NUMBER
    )
IS
l_api_name                  CONSTANT VARCHAR2(30) := 'Delete_qual_market_options';

Line: 736

      SAVEPOINT Delete_qual_market_options_PVT;

Line: 757

OZF_QUAL_MARKET_OPTION_PKG.Delete_Row(
        p_qualifier_market_option_id  => p_qualifier_market_option_id
        , p_object_version_number     => p_object_version_number
    );

Line: 781

     ROLLBACK TO Delete_qual_market_options_PVT;

Line: 791

     ROLLBACK TO Delete_qual_market_options_PVT;

Line: 801

     ROLLBACK TO Delete_qual_market_options_PVT;

Line: 814

END Delete_qual_market_options;