eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_OFFER_PERFORMANCE_PVT SQL Statements

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

Line: 45


      SELECT OZF_OFFER_PERFORMANCES_S.NEXTVAL
      FROM dual;

Line: 49


      SELECT 1
      FROM OZF_OFFER_PERFORMANCES
      WHERE OFFER_PERFORMANCE_ID = l_id;

Line: 136


      OZF_OFFER_PERFORMANCES_PKG.Insert_Row(
          px_offer_performance_id  => l_offer_performance_id,
          p_list_header_id  => p_offer_perf_rec.list_header_id,
          p_last_update_date  => SYSDATE,
          p_last_updated_by  => FND_GLOBAL.USER_ID,
          p_creation_date  => SYSDATE,
          p_created_by  => FND_GLOBAL.USER_ID,
          p_last_update_login  => FND_GLOBAL.CONC_LOGIN_ID,
          px_object_version_number  => l_object_version_number,
          p_product_attribute_context  => p_offer_perf_rec.product_attribute_context,
          p_product_attribute  => p_offer_perf_rec.product_attribute,
          p_product_attr_value  => p_offer_perf_rec.product_attr_value,
          p_channel_id  => p_offer_perf_rec.channel_id,
          p_start_date  => p_offer_perf_rec.start_date,
          p_end_date  => p_offer_perf_rec.end_date,
          p_estimated_value  => p_offer_perf_rec.estimated_value,
          p_required_flag  => p_offer_perf_rec.required_flag,
          p_attribute_category  => p_offer_perf_rec.attribute_category,
          p_attribute1  => p_offer_perf_rec.attribute1,
          p_attribute2  => p_offer_perf_rec.attribute2,
          p_attribute3  => p_offer_perf_rec.attribute3,
          p_attribute4  => p_offer_perf_rec.attribute4,
          p_attribute5  => p_offer_perf_rec.attribute5,
          p_attribute6  => p_offer_perf_rec.attribute6,
          p_attribute7  => p_offer_perf_rec.attribute7,
          p_attribute8  => p_offer_perf_rec.attribute8,
          p_attribute9  => p_offer_perf_rec.attribute9,
          p_attribute10  => p_offer_perf_rec.attribute10,
          p_attribute11  => p_offer_perf_rec.attribute11,
          p_attribute12  => p_offer_perf_rec.attribute12,
          p_attribute13  => p_offer_perf_rec.attribute13,
          p_attribute14  => p_offer_perf_rec.attribute14,
          p_attribute15  => p_offer_perf_rec.attribute15,
          p_security_group_id  => p_offer_perf_rec.security_group_id,
          p_requirement_type => p_offer_perf_rec.requirement_type,
          p_uom_code     => p_offer_perf_rec.uom_code,
          p_description  => p_offer_perf_rec.description);

Line: 239


PROCEDURE Update_Offer_Performance(
    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_perf_rec               IN    offer_perf_rec_type,
    x_object_version_number      OUT NOCOPY  NUMBER
    )

 IS

CURSOR c_get_offer_performance(l_offer_performance_id NUMBER) IS
    SELECT *
    FROM  OZF_OFFER_PERFORMANCES
    where offer_performance_id = l_offer_performance_id;

Line: 261


L_API_NAME                  CONSTANT VARCHAR2(30) := 'Update_Offer_Performance';

Line: 273


      SAVEPOINT UPDATE_Offer_Performance_PVT;

Line: 274


       ozf_utility_pvt.debug_message('Inside update Private API: - Open Cursor to Select');

Line: 275


       ozf_utility_pvt.debug_message('Inside update Private API: - Open Cursor to Select');

Line: 300


      ozf_utility_pvt.debug_message('Private API: - Open Cursor to Select');

Line: 308


  ozf_utility_pvt.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
   p_token_name   => 'INFO',
 p_token_value  => 'Offer_Performance') ;

Line: 323


 p_token_value  => 'Last_Update_Date') ;

Line: 343


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

Line: 357


      ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW||'Private API: Calling update table handler');

Line: 360


      OZF_OFFER_PERFORMANCES_PKG.Update_Row(
          p_offer_performance_id  => p_offer_perf_rec.offer_performance_id,
          p_list_header_id  => p_offer_perf_rec.list_header_id,
          p_last_update_date  => SYSDATE,
          p_last_updated_by  => FND_GLOBAL.USER_ID,
	  p_creation_date  => p_offer_perf_rec.creation_date,
          p_created_by  => p_offer_perf_rec.created_by,
          p_last_update_login  => FND_GLOBAL.CONC_LOGIN_ID,
          p_object_version_number  => l_object_version_number,
          p_product_attribute_context  => p_offer_perf_rec.product_attribute_context,
          p_product_attribute  => p_offer_perf_rec.product_attribute,
          p_product_attr_value  => p_offer_perf_rec.product_attr_value,
          p_channel_id  => p_offer_perf_rec.channel_id,
          p_start_date  => p_offer_perf_rec.start_date,
          p_end_date  => p_offer_perf_rec.end_date,
          p_estimated_value  => p_offer_perf_rec.estimated_value,
         p_required_flag  => p_offer_perf_rec.required_flag,
         p_attribute_category  => p_offer_perf_rec.attribute_category,
          p_attribute1  => p_offer_perf_rec.attribute1,
          p_attribute2  => p_offer_perf_rec.attribute2,
          p_attribute3  => p_offer_perf_rec.attribute3,
          p_attribute4  => p_offer_perf_rec.attribute4,
          p_attribute5  => p_offer_perf_rec.attribute5,
          p_attribute6  => p_offer_perf_rec.attribute6,
          p_attribute7  => p_offer_perf_rec.attribute7,
          p_attribute8  => p_offer_perf_rec.attribute8,
          p_attribute9  => p_offer_perf_rec.attribute9,
          p_attribute10  => p_offer_perf_rec.attribute10,
          p_attribute11  => p_offer_perf_rec.attribute11,
          p_attribute12  => p_offer_perf_rec.attribute12,
          p_attribute13  => p_offer_perf_rec.attribute13,
          p_attribute14  => p_offer_perf_rec.attribute14,
          p_attribute15  => p_offer_perf_rec.attribute15,
          p_security_group_id  => p_offer_perf_rec.security_group_id,
          p_requirement_type => p_offer_perf_rec.requirement_type,
          p_uom_code     => p_offer_perf_rec.uom_code,
          p_description  => p_offer_perf_rec.description);

Line: 426


     ROLLBACK TO UPDATE_Offer_Performance_PVT;

Line: 436


     ROLLBACK TO UPDATE_Offer_Performance_PVT;

Line: 446


     ROLLBACK TO UPDATE_Offer_Performance_PVT;

Line: 458


End Update_Offer_Performance;

Line: 461


PROCEDURE Delete_Offer_Performance(
    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_performance_id                   IN  NUMBER,
    p_object_version_number      IN   NUMBER
    )

 IS
L_API_NAME                  CONSTANT VARCHAR2(30) := 'Delete_Offer_Performance';

Line: 481


      SAVEPOINT DELETE_Offer_Performance_PVT;

Line: 509


      ozf_utility_pvt.debug_message( 'Private API: Calling delete table handler');

Line: 512


      OZF_OFFER_PERFORMANCES_PKG.Delete_Row(
          p_OFFER_PERFORMANCE_ID  => p_OFFER_PERFORMANCE_ID);

Line: 540


     ROLLBACK TO DELETE_Offer_Performance_PVT;

Line: 550


     ROLLBACK TO DELETE_Offer_Performance_PVT;

Line: 560


     ROLLBACK TO DELETE_Offer_Performance_PVT;

Line: 572


End Delete_Offer_Performance;

Line: 596


   SELECT OFFER_PERFORMANCE_ID
   FROM OZF_OFFER_PERFORMANCES
   WHERE OFFER_PERFORMANCE_ID = p_OFFER_PERFORMANCE_ID
   AND object_version_number = p_object_version
   FOR UPDATE NOWAIT;

Line: 853


      SELECT *
      FROM OZF_offer_performances
      WHERE offer_performance_id = p_offer_perf_rec.offer_performance_id;

Line: 876


   IF p_offer_perf_rec.last_update_date = FND_API.g_miss_date THEN
      x_complete_rec.last_update_date := l_offer_perf_rec.last_update_date;

Line: 881


   IF p_offer_perf_rec.last_updated_by = FND_API.g_miss_num THEN
      x_complete_rec.last_updated_by := l_offer_perf_rec.last_updated_by;

Line: 896


   IF p_offer_perf_rec.last_update_login = FND_API.g_miss_num THEN
      x_complete_rec.last_update_login := l_offer_perf_rec.last_update_login;