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.AMS_COMPETITOR_PRODUCT_PVT SQL Statements

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

Line: 54


      SELECT AMS_COMPETITOR_PRODUCTS_B_s.NEXTVAL
      FROM dual;

Line: 58


      SELECT 1
      FROM AMS_COMPETITOR_PRODUCTS_B
      WHERE COMPETITOR_PRODUCT_ID = l_id;

Line: 145


      AMS_COMPETITOR_PRODUCTS_B_PKG.Insert_Row(
          px_competitor_product_id  => l_competitor_product_id,
          px_object_version_number  => l_object_version_number,
          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,
          p_competitor_party_id  => p_comp_prod_rec.competitor_party_id,
          p_competitor_product_code  => p_comp_prod_rec.competitor_product_code,
          p_interest_type_id  => p_comp_prod_rec.interest_type_id,
          p_inventory_item_id  => p_comp_prod_rec.inventory_item_id,
          p_organization_id  => p_comp_prod_rec.organization_id,
          p_comp_product_url  => p_comp_prod_rec.comp_product_url,
          p_original_system_ref  => p_comp_prod_rec.original_system_ref,
          --p_security_group_id  => p_comp_prod_rec.security_group_id,
          p_competitor_product_name => p_comp_prod_rec.competitor_product_name,
          p_description => p_comp_prod_rec.description,
          p_start_date => p_comp_prod_rec.start_date,
          p_end_date => p_comp_prod_rec.end_date
         ,p_category_id => p_comp_prod_rec.category_id
         ,p_category_set_id => p_comp_prod_rec.category_set_id
         , p_context                      => p_comp_prod_rec.context
         , p_attribute1                   => p_comp_prod_rec.attribute1
         , p_attribute2                   => p_comp_prod_rec.attribute2
         , p_attribute3                   => p_comp_prod_rec.attribute3
         , p_attribute4                   => p_comp_prod_rec.attribute4
         , p_attribute5                   => p_comp_prod_rec.attribute5
         , p_attribute6                   => p_comp_prod_rec.attribute6
         , p_attribute7                   => p_comp_prod_rec.attribute7
         , p_attribute8                   => p_comp_prod_rec.attribute8
         , p_attribute9                   => p_comp_prod_rec.attribute9
         , p_attribute10                   => p_comp_prod_rec.attribute10
         , p_attribute11                   => p_comp_prod_rec.attribute11
         , p_attribute12                   => p_comp_prod_rec.attribute12
         , p_attribute13                   => p_comp_prod_rec.attribute13
         , p_attribute14                   => p_comp_prod_rec.attribute14
         , p_attribute15                   => p_comp_prod_rec.attribute15
          );

Line: 248


PROCEDURE Update_Comp_Product(
    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_comp_prod_rec               IN    comp_prod_rec_type,
    x_object_version_number      OUT NOCOPY  NUMBER
    )

 IS



CURSOR c_get_ams_Comp_Product(competitor_product_id NUMBER) IS
    SELECT *
    FROM  AMS_COMPETITOR_PRODUCTS_B
    WHERE competitor_product_id = p_comp_prod_rec.competitor_product_id;

Line: 271


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

Line: 282


      SAVEPOINT UPDATE_Ams_Comp_Product_PVT;

Line: 312


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

Line: 320


                AMS_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
                p_token_name   => 'INFO',
                p_token_value  => 'Ams_Competitor_Product_Pvt') ;

Line: 337


 p_token_value  => 'Last_Update_Date') ;

Line: 360


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

Line: 374


      AMS_COMPETITOR_PRODUCTS_B_PKG.Update_Row(
          p_competitor_product_id  => p_comp_prod_rec.competitor_product_id
        , p_object_version_number  => p_comp_prod_rec.object_version_number,
          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,
          p_competitor_party_id  => p_comp_prod_rec.competitor_party_id,
          p_competitor_product_code  => p_comp_prod_rec.competitor_product_code,
          p_interest_type_id  => p_comp_prod_rec.interest_type_id,
          p_inventory_item_id  => p_comp_prod_rec.inventory_item_id,
          p_organization_id  => p_comp_prod_rec.organization_id,
          p_comp_product_url  => p_comp_prod_rec.comp_product_url,
          p_original_system_ref  => p_comp_prod_rec.original_system_ref,
          --p_security_group_id  => p_comp_prod_rec.security_group_id,
          p_competitor_product_name => p_comp_prod_rec.competitor_product_name,
          p_description => p_comp_prod_rec.description,
          p_start_date => p_comp_prod_rec.start_date,
          p_end_date => p_comp_prod_rec.end_date
         ,p_category_id => p_comp_prod_rec.category_id
         ,p_category_set_id => p_comp_prod_rec.category_set_id
         , p_context                      => p_comp_prod_rec.context
         , p_attribute1                   => p_comp_prod_rec.attribute1
         , p_attribute2                   => p_comp_prod_rec.attribute2
         , p_attribute3                   => p_comp_prod_rec.attribute3
         , p_attribute4                   => p_comp_prod_rec.attribute4
         , p_attribute5                   => p_comp_prod_rec.attribute5
         , p_attribute6                   => p_comp_prod_rec.attribute6
         , p_attribute7                   => p_comp_prod_rec.attribute7
         , p_attribute8                   => p_comp_prod_rec.attribute8
         , p_attribute9                   => p_comp_prod_rec.attribute9
         , p_attribute10                   => p_comp_prod_rec.attribute10
         , p_attribute11                   => p_comp_prod_rec.attribute11
         , p_attribute12                   => p_comp_prod_rec.attribute12
         , p_attribute13                   => p_comp_prod_rec.attribute13
         , p_attribute14                   => p_comp_prod_rec.attribute14
         , p_attribute15                   => p_comp_prod_rec.attribute15
          );

Line: 442


     ROLLBACK TO UPDATE_Ams_Comp_Product_PVT;

Line: 452


     ROLLBACK TO UPDATE_Ams_Comp_Product_PVT;

Line: 462


     ROLLBACK TO UPDATE_Ams_Comp_Product_PVT;

Line: 475


End Update_Comp_Product;

Line: 478


PROCEDURE Delete_Comp_Product(
    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_competitor_product_id                   IN  NUMBER,
    p_object_version_number      IN   NUMBER
    )

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

Line: 497


      SAVEPOINT DELETE_Ams_Comp_Product_PVT;

Line: 530


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

Line: 534


      AMS_COMPETITOR_PRODUCTS_B_PKG.Delete_Row(
          p_COMPETITOR_PRODUCT_ID  => p_COMPETITOR_PRODUCT_ID,
          p_Object_Version_number => p_object_version_number
          );

Line: 567


     ROLLBACK TO DELETE_Ams_Comp_Product_PVT;

Line: 577


     ROLLBACK TO DELETE_Ams_Comp_Product_PVT;

Line: 587


     ROLLBACK TO DELETE_Ams_Comp_Product_PVT;

Line: 599


End Delete_Comp_Product;

Line: 624


   SELECT COMPETITOR_PRODUCT_ID
   FROM AMS_COMPETITOR_PRODUCTS_B
   WHERE COMPETITOR_PRODUCT_ID = p_COMPETITOR_PRODUCT_ID
   AND object_version_number = p_object_version
   FOR UPDATE NOWAIT;

Line: 742


      SELECT *
      FROM ams_competitor_products_vl
      WHERE competitor_product_id = p_comp_prod_rec.competitor_product_id;

Line: 765


   IF p_comp_prod_rec.last_update_date = FND_API.g_miss_date THEN
      x_complete_rec.last_update_date := l_comp_prod_rec_type_rec.last_update_date;

Line: 770


   IF p_comp_prod_rec.last_updated_by = FND_API.g_miss_num THEN
      x_complete_rec.last_updated_by := l_comp_prod_rec_type_rec.last_updated_by;

Line: 785


   IF p_comp_prod_rec.last_update_login = FND_API.g_miss_num THEN
      x_complete_rec.last_update_login := l_comp_prod_rec_type_rec.last_update_login;

Line: 1220


                 p_validation_mode   => p_validation_mode, --JTF_PLSQL_API.g_update,
                 x_return_status     => x_return_status
              );