DBA Data[Home] [Help]

APPS.OZF_OFFR_QUAL_PVT SQL Statements

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

Line: 98

       SELECT ozf_offer_qualifiers_s.NEXTVAL
       FROM dual;
Line: 102

       SELECT 1
       FROM OZF_OFFER_QUALIFIERS
       WHERE qualifier_id = l_id;
Line: 196

       Ozf_Offr_Qual_Pkg.Insert_Row(
           px_qualifier_id  => l_qualifier_id,
           p_creation_date  => SYSDATE,
           p_created_by  => FND_GLOBAL.USER_ID,
           p_last_update_date  => SYSDATE,
           p_last_updated_by  => FND_GLOBAL.USER_ID,
           p_last_update_login  => FND_GLOBAL.conc_login_id,
           p_qualifier_grouping_no  => p_ozf_offr_qual_rec.qualifier_grouping_no,
           p_qualifier_context  => p_ozf_offr_qual_rec.qualifier_context,
           p_qualifier_attribute  => p_ozf_offr_qual_rec.qualifier_attribute,
           p_qualifier_attr_value  => p_ozf_offr_qual_rec.qualifier_attr_value,
           p_start_date_active  => p_ozf_offr_qual_rec.start_date_active,
           p_end_date_active  => p_ozf_offr_qual_rec.end_date_active,
           p_offer_id  => p_ozf_offr_qual_rec.offer_id,
           p_offer_discount_line_id  => p_ozf_offr_qual_rec.offer_discount_line_id,
           p_context  => p_ozf_offr_qual_rec.context,
           p_attribute1  => p_ozf_offr_qual_rec.attribute1,
           p_attribute2  => p_ozf_offr_qual_rec.attribute2,
           p_attribute3  => p_ozf_offr_qual_rec.attribute3,
           p_attribute4  => p_ozf_offr_qual_rec.attribute4,
           p_attribute5  => p_ozf_offr_qual_rec.attribute5,
           p_attribute6  => p_ozf_offr_qual_rec.attribute6,
           p_attribute7  => p_ozf_offr_qual_rec.attribute7,
           p_attribute8  => p_ozf_offr_qual_rec.attribute8,
           p_attribute9  => p_ozf_offr_qual_rec.attribute9,
           p_attribute10  => p_ozf_offr_qual_rec.attribute10,
           p_attribute11  => p_ozf_offr_qual_rec.attribute11,
           p_attribute12  => p_ozf_offr_qual_rec.attribute12,
           p_attribute13  => p_ozf_offr_qual_rec.attribute13,
           p_attribute14  => p_ozf_offr_qual_rec.attribute14,
           p_attribute15  => p_ozf_offr_qual_rec.attribute15,
           p_active_flag  => p_ozf_offr_qual_rec.active_flag,
           p_object_version_number => 1
 );
Line: 330

 PROCEDURE Update_Offr_Qual(
     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_ozf_offr_qual_rec               IN    ozf_offr_qual_rec_type
     )

  IS


 CURSOR c_get_offr_qual(qualifier_id NUMBER) IS
     SELECT *
     FROM  OZF_OFFER_QUALIFIERS
     WHERE  qualifier_id = p_ozf_offr_qual_rec.qualifier_id;
Line: 353

 L_API_NAME                  CONSTANT VARCHAR2(30) := 'Update_Offr_Qual';
Line: 364

       SAVEPOINT update_offr_qual_pvt;
Line: 393

       OZF_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
Line: 400

   OZF_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
    p_token_name   => 'INFO',
  p_token_value  => 'Offr_Qual') ;
Line: 414

  p_token_value  => 'Last_Update_Date') ;
Line: 436

             p_validation_mode => JTF_PLSQL_API.g_update,
             p_ozf_offr_qual_rec  =>  p_ozf_offr_qual_rec,
             x_return_status    => x_return_status,
             x_msg_count        => x_msg_count,
             x_msg_data         => x_msg_data);
Line: 448

       OZF_UTILITY_PVT.debug_message( 'Private API: Calling update table handler');
Line: 451

       Ozf_Offr_Qual_Pkg.Update_Row(
           p_qualifier_id  => p_ozf_offr_qual_rec.qualifier_id,
           p_last_update_date  => SYSDATE,
           p_last_updated_by  => FND_GLOBAL.USER_ID,
           p_last_update_login  => FND_GLOBAL.conc_login_id,
           p_qualifier_grouping_no  => p_ozf_offr_qual_rec.qualifier_grouping_no,
           p_qualifier_context  => p_ozf_offr_qual_rec.qualifier_context,
           p_qualifier_attribute  => p_ozf_offr_qual_rec.qualifier_attribute,
           p_qualifier_attr_value  => p_ozf_offr_qual_rec.qualifier_attr_value,
           p_start_date_active  =>  p_ozf_offr_qual_rec.start_date_active,
           p_end_date_active  => p_ozf_offr_qual_rec.end_date_active,
           p_offer_id  => p_ozf_offr_qual_rec.offer_id,
           p_offer_discount_line_id  => p_ozf_offr_qual_rec.offer_discount_line_id,
           p_context  => p_ozf_offr_qual_rec.context,
           p_attribute1  => p_ozf_offr_qual_rec.attribute1,
           p_attribute2  => p_ozf_offr_qual_rec.attribute2,
           p_attribute3  => p_ozf_offr_qual_rec.attribute3,
           p_attribute4  => p_ozf_offr_qual_rec.attribute4,
           p_attribute5  => p_ozf_offr_qual_rec.attribute5,
           p_attribute6  => p_ozf_offr_qual_rec.attribute6,
           p_attribute7  => p_ozf_offr_qual_rec.attribute7,
           p_attribute8  => p_ozf_offr_qual_rec.attribute8,
           p_attribute9  => p_ozf_offr_qual_rec.attribute9,
           p_attribute10  => p_ozf_offr_qual_rec.attribute10,
           p_attribute11  => p_ozf_offr_qual_rec.attribute11,
           p_attribute12  => p_ozf_offr_qual_rec.attribute12,
           p_attribute13  => p_ozf_offr_qual_rec.attribute13,
           p_attribute14  => p_ozf_offr_qual_rec.attribute14,
           p_attribute15  => p_ozf_offr_qual_rec.attribute15,
           p_active_flag  => p_ozf_offr_qual_rec.active_flag,
           p_object_version_number => p_ozf_offr_qual_rec.object_version_number
 );
Line: 510

      ROLLBACK TO UPDATE_Offr_Qual_PVT;
Line: 520

      ROLLBACK TO UPDATE_Offr_Qual_PVT;
Line: 530

      ROLLBACK TO UPDATE_Offr_Qual_PVT;
Line: 542

 End Update_Offr_Qual;
Line: 579

 PROCEDURE Delete_Offr_Qual(
     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_qualifier_id                   IN  NUMBER,
     p_object_version_number      IN   NUMBER
     )

  IS
 L_API_NAME                  CONSTANT VARCHAR2(30) := 'Delete_Offr_Qual';
Line: 598

       SAVEPOINT delete_offr_qual_pvt;
Line: 630

       OZF_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
Line: 633

       Ozf_Offr_Qual_Pkg.Delete_Row(
           p_qualifier_id  => p_qualifier_id,
           p_object_version_number => p_object_version_number     );
Line: 663

      ROLLBACK TO DELETE_Offr_Qual_PVT;
Line: 673

      ROLLBACK TO DELETE_Offr_Qual_PVT;
Line: 683

      ROLLBACK TO DELETE_Offr_Qual_PVT;
Line: 695

 End Delete_Offr_Qual;
Line: 1037

       SELECT *
       FROM ozf_offer_qualifiers
       WHERE qualifier_id = p_ozf_offr_qual_rec.qualifier_id;
Line: 1064

    IF p_ozf_offr_qual_rec.last_update_date IS NULL THEN
       x_complete_rec.last_update_date := l_ozf_offr_qual_rec.last_update_date;
Line: 1069

    IF p_ozf_offr_qual_rec.last_updated_by IS NULL THEN
       x_complete_rec.last_updated_by := l_ozf_offr_qual_rec.last_updated_by;
Line: 1074

    IF p_ozf_offr_qual_rec.last_update_login IS NULL THEN
       x_complete_rec.last_update_login := l_ozf_offr_qual_rec.last_update_login;