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_IBA_PLCMNT_PVT SQL Statements

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

Line: 54


      SELECT AMS_IBA_PL_PLACEMENTS_B_s.NEXTVAL
      FROM dual;

Line: 58


      SELECT 1
      FROM AMS_IBA_PL_PLACEMENTS_B
      WHERE PLACEMENT_ID = l_id;

Line: 63


        SELECT site_id
        FROM ams_iba_pl_sites_b
        WHERE site_ref_code = l_site_ref_code;

Line: 68


        SELECT page_id
        FROM ams_iba_pl_pages_b
        WHERE page_ref_code = l_page_ref_code
	AND site_ref_code = l_site_ref_code;

Line: 182


      AMS_IBA_PL_PLACEMENTS_B_PKG.Insert_Row(
          px_placement_id  => l_placement_id,
          p_site_id  => l_site_id,
          p_site_ref_code  => p_iba_plcmnt_rec.site_ref_code,
          p_page_id  => l_page_id,
          p_page_ref_code  => p_iba_plcmnt_rec.page_ref_code,
          p_location_code  => p_iba_plcmnt_rec.location_code,
          p_param1  => p_iba_plcmnt_rec.param1,
          p_param2  => p_iba_plcmnt_rec.param2,
          p_param3  => p_iba_plcmnt_rec.param3,
          p_param4  => p_iba_plcmnt_rec.param4,
          p_param5  => p_iba_plcmnt_rec.param5,
          p_stylesheet_id  => p_iba_plcmnt_rec.stylesheet_id,
          p_posting_id  => p_iba_plcmnt_rec.posting_id,
          p_status_code  => p_iba_plcmnt_rec.status_code,
          p_track_events_flag  => p_iba_plcmnt_rec.track_events_flag,
          p_created_by  => FND_GLOBAL.USER_ID,
          p_creation_date  => SYSDATE,
          p_last_updated_by  => FND_GLOBAL.USER_ID,
          p_last_update_date  => SYSDATE,
          p_last_update_login  => FND_GLOBAL.CONC_LOGIN_ID,
          px_object_version_number  => l_object_version_number,
          p_name                => p_iba_plcmnt_rec.name,
          p_description         => p_iba_plcmnt_rec.description);

Line: 274


PROCEDURE Update_Iba_Plcmnt(
    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_iba_plcmnt_rec               IN    iba_plcmnt_rec_type,
    x_object_version_number      OUT NOCOPY  NUMBER
    )

 IS
--/*
CURSOR c_get_iba_plcmnt(placement_id NUMBER) IS
    SELECT *
    FROM  AMS_IBA_PL_PLACEMENTS_B;

Line: 295


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

Line: 306


      SAVEPOINT UPDATE_Iba_Plcmnt_PVT;

Line: 336


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

Line: 345


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

Line: 363


 p_token_value  => 'Last_Update_Date') ;

Line: 390


	    , p_validation_mode  => JTF_PLSQL_API.g_update
	  );

Line: 403


      AMS_IBA_PL_PLACEMENTS_B_PKG.Update_Row(
          p_placement_id  => p_iba_plcmnt_rec.placement_id,
          p_site_id  => p_iba_plcmnt_rec.site_id,
          p_site_ref_code  => p_iba_plcmnt_rec.site_ref_code,
          p_page_id  => p_iba_plcmnt_rec.page_id,
          p_page_ref_code  => p_iba_plcmnt_rec.page_ref_code,
          p_location_code  => p_iba_plcmnt_rec.location_code,
          p_param1  => p_iba_plcmnt_rec.param1,
          p_param2  => p_iba_plcmnt_rec.param2,
          p_param3  => p_iba_plcmnt_rec.param3,
          p_param4  => p_iba_plcmnt_rec.param4,
          p_param5  => p_iba_plcmnt_rec.param5,
          p_stylesheet_id  => p_iba_plcmnt_rec.stylesheet_id,
          p_posting_id  => p_iba_plcmnt_rec.posting_id,
          p_status_code  => p_iba_plcmnt_rec.status_code,
          p_track_events_flag  => p_iba_plcmnt_rec.track_events_flag,
          p_created_by  => FND_GLOBAL.USER_ID,
          p_creation_date  => SYSDATE,
          p_last_updated_by  => FND_GLOBAL.USER_ID,
          p_last_update_date  => SYSDATE,
          p_last_update_login  => FND_GLOBAL.CONC_LOGIN_ID,
          p_object_version_number  => p_iba_plcmnt_rec.object_version_number,
          p_name                => p_iba_plcmnt_rec.name,
          p_description         => p_iba_plcmnt_rec.description);

Line: 457


     ROLLBACK TO UPDATE_Iba_Plcmnt_PVT;

Line: 467


     ROLLBACK TO UPDATE_Iba_Plcmnt_PVT;

Line: 477


     ROLLBACK TO UPDATE_Iba_Plcmnt_PVT;

Line: 489


End Update_Iba_Plcmnt;

Line: 492


PROCEDURE Delete_Iba_Plcmnt(
    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_placement_id                   IN  NUMBER,
    p_object_version_number      IN   NUMBER
    )

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

Line: 511


      SAVEPOINT DELETE_Iba_Plcmnt_PVT;

Line: 544


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

Line: 548


      AMS_IBA_PL_PLACEMENTS_B_PKG.Delete_Row(
          p_PLACEMENT_ID  => p_PLACEMENT_ID);

Line: 579


     ROLLBACK TO DELETE_Iba_Plcmnt_PVT;

Line: 589


     ROLLBACK TO DELETE_Iba_Plcmnt_PVT;

Line: 599


     ROLLBACK TO DELETE_Iba_Plcmnt_PVT;

Line: 611


End Delete_Iba_Plcmnt;

Line: 635


   SELECT PLACEMENT_ID
   FROM AMS_IBA_PL_PLACEMENTS_B
   WHERE PLACEMENT_ID = p_PLACEMENT_ID
   AND object_version_number = p_object_version
   FOR UPDATE NOWAIT;

Line: 762


   IF p_validation_mode = JTF_PLSQL_API.g_update THEN
   	if p_iba_plcmnt_rec.site_ref_code = 'ISTORE' then
		if p_iba_plcmnt_rec.page_ref_code = 'SHOPPING_CART' then
		   select count(*) into l_plcmnt_count
		   from ams_iba_pl_placements_b
		   where site_ref_code = p_iba_plcmnt_rec.site_ref_code
		    and page_ref_code = p_iba_plcmnt_rec.page_ref_code
		    and location_code = p_iba_plcmnt_rec.location_code
                    and NVL(param1,'-1') = NVL(p_iba_plcmnt_rec.param1,'-1')
		    and placement_id <> p_iba_plcmnt_rec.placement_id;

Line: 775


		   select count(*) into l_plcmnt_count
		   from ams_iba_pl_placements_b
		   where site_ref_code = p_iba_plcmnt_rec.site_ref_code
		    and page_ref_code = p_iba_plcmnt_rec.page_ref_code
		    and location_code = p_iba_plcmnt_rec.location_code
                    and NVL(param1,'-1') = NVL(p_iba_plcmnt_rec.param1,'-1')
                    and NVL(param2,'-1') = NVL(p_iba_plcmnt_rec.param2,'-1')
		    and placement_id <> p_iba_plcmnt_rec.placement_id;

Line: 787


		   select count(*) into l_plcmnt_count
		   from ams_iba_pl_placements_b
		   where site_ref_code = p_iba_plcmnt_rec.site_ref_code
		    and page_ref_code = p_iba_plcmnt_rec.page_ref_code
		    and location_code = p_iba_plcmnt_rec.location_code
		    and placement_id <> p_iba_plcmnt_rec.placement_id;

Line: 799


		   select count(*) into l_plcmnt_count
		   from ams_iba_pl_placements_b
		   where site_ref_code = p_iba_plcmnt_rec.site_ref_code
		    and page_ref_code = p_iba_plcmnt_rec.page_ref_code
		    and location_code = p_iba_plcmnt_rec.location_code
		    and NVL(param1,'-1') = NVL(p_iba_plcmnt_rec.param1,'-1');

Line: 808


		   select count(*) into l_plcmnt_count
		   from ams_iba_pl_placements_b
		   where site_ref_code = p_iba_plcmnt_rec.site_ref_code
		    and page_ref_code = p_iba_plcmnt_rec.page_ref_code
		    and location_code = p_iba_plcmnt_rec.location_code
		    and NVL(param1,'-1') = NVL(p_iba_plcmnt_rec.param1,'-1')
		    and NVL(param2,'-1') = NVL(p_iba_plcmnt_rec.param2,'-1');

Line: 819


		   select count(*) into l_plcmnt_count
		   from ams_iba_pl_placements_b
		   where site_ref_code = p_iba_plcmnt_rec.site_ref_code
		    and page_ref_code = p_iba_plcmnt_rec.page_ref_code
		    and location_code = p_iba_plcmnt_rec.location_code;

Line: 972


      IF p_iba_plcmnt_rec.last_updated_by = FND_API.g_miss_num OR p_iba_plcmnt_rec.last_updated_by IS NULL THEN
 AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_plcmnt_NO_last_updated_by');

Line: 979


      IF p_iba_plcmnt_rec.last_update_date = FND_API.g_miss_date OR p_iba_plcmnt_rec.last_update_date IS NULL THEN
 AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_plcmnt_NO_last_update_date');

Line: 1050


      IF p_iba_plcmnt_rec.last_updated_by IS NULL THEN
 AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_plcmnt_NO_last_updated_by');

Line: 1057


      IF p_iba_plcmnt_rec.last_update_date IS NULL THEN
 AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_plcmnt_NO_last_update_date');

Line: 1152


      SELECT *
      FROM ams_iba_pl_placements_b
      WHERE placement_id = p_iba_plcmnt_rec.placement_id;

Line: 1250


   IF p_iba_plcmnt_rec.last_updated_by = FND_API.g_miss_num THEN
      x_complete_rec.last_updated_by := l_iba_plcmnt_rec.last_updated_by;

Line: 1255


   IF p_iba_plcmnt_rec.last_update_date = FND_API.g_miss_date THEN
      x_complete_rec.last_update_date := l_iba_plcmnt_rec.last_update_date;

Line: 1260


   IF p_iba_plcmnt_rec.last_update_login = FND_API.g_miss_num THEN
      x_complete_rec.last_update_login := l_iba_plcmnt_rec.last_update_login;