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

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

Line: 34


PROCEDURE Insert_Row(
          px_placement_citem_id   IN OUT NOCOPY NUMBER,
          p_placement_mp_id    NUMBER,
          p_content_item_id    NUMBER,
          p_citem_version_id    NUMBER,
          p_created_by    NUMBER,
          p_creation_date    DATE,
          p_last_updated_by    NUMBER,
          p_last_update_date    DATE,
          p_last_update_login    NUMBER,
          px_object_version_number   IN OUT NOCOPY NUMBER,
          p_return_status          OUT NOCOPY VARCHAR2,
          p_msg_count             OUT  NOCOPY  NUMBER,
          p_msg_data                OUT  NOCOPY  VARCHAR2
          )

IS
   x_rowid    VARCHAR2(30);

Line: 59


   INSERT INTO ams_web_plce_citem_assoc(
          placement_citem_id,
          placement_mp_id,
          content_item_id,
          citem_version_id,
          created_by,
          creation_date,
          last_updated_by,
          last_update_date,
          last_update_login,
          object_version_number
   ) VALUES (
           DECODE( px_placement_citem_id, FND_API.g_miss_num, NULL, px_placement_citem_id),
           DECODE( p_placement_mp_id, FND_API.g_miss_num, NULL, p_placement_mp_id),
           DECODE( p_content_item_id, FND_API.g_miss_num, NULL, p_content_item_id),
           DECODE( p_citem_version_id, FND_API.g_miss_num, NULL, p_citem_version_id),
           DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
           DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
           DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
           DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
           DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
           DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number));

Line: 83


END Insert_Row;

Line: 98


PROCEDURE  Update_Row(
          p_placement_citem_id  NUMBER,
          p_placement_mp_id    NUMBER,
          p_content_item_id    NUMBER,
          p_citem_version_id    NUMBER,
          p_created_by    NUMBER,
          p_creation_date    DATE,
          p_last_updated_by   NUMBER,
          p_last_update_date  DATE,
          p_last_update_login    NUMBER,
          p_object_version_number    NUMBER
	  )
	IS
	BEGIN

	   IF (AMS_DEBUG_HIGH_ON) THEN
	      AMS_UTILITY_PVT.debug_message('table handler : before update p_placement_citem_id =' || p_placement_citem_id );

Line: 118


	    UPDATE ams_web_plce_citem_assoc
	    SET
              last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
              last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
              last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
	      placement_mp_id = DECODE( p_placement_mp_id, FND_API.g_miss_num, NULL, p_placement_mp_id),
	      content_item_id = DECODE( p_content_item_id, FND_API.g_miss_num, NULL, p_content_item_id),
              citem_version_id = DECODE( p_citem_version_id, FND_API.g_miss_num, NULL, p_citem_version_id)
	   WHERE placement_citem_id = p_placement_citem_id;

Line: 133


END Update_Row;

Line: 147


PROCEDURE Delete_Row(
    p_placement_citem_id  NUMBER,
    p_object_version_number NUMBER)
 IS
BEGIN
   IF (AMS_DEBUG_HIGH_ON) THEN

   AMS_UTILITY_PVT.debug_message('table handler : before delete of b; placement_citem_id = ' || p_placement_citem_id || ' object_version_num = ' || p_object_version_number);

Line: 156


   DELETE FROM ams_web_plce_citem_assoc
   WHERE placement_citem_id = p_placement_citem_id
   AND   object_version_number = p_object_version_number;

Line: 164


   AMS_UTILITY_PVT.debug_message('table handler : After delete of b; placement_citem_id = ' || p_placement_citem_id || ' object_version_num = ' || p_object_version_number);

Line: 173


END Delete_Row ;

Line: 195


          p_last_updated_by    NUMBER,
          p_last_update_date    DATE,
          p_last_update_login    NUMBER,
          p_object_version_number    NUMBER
)

 IS
   CURSOR C IS
        SELECT *
         FROM ams_web_plce_citem_assoc
        WHERE PLACEMENT_CITEM_ID =  p_placement_citem_id
        FOR UPDATE of PLACEMENT_CITEM_ID NOWAIT;

Line: 213


        FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');

Line: 238


       AND (    ( Recinfo.last_updated_by = p_last_updated_by)
            OR (    ( Recinfo.last_updated_by IS NULL )
                AND (  p_last_updated_by IS NULL )))
       AND (    ( Recinfo.last_update_date = p_last_update_date)
            OR (    ( Recinfo.last_update_date IS NULL )
                AND (  p_last_update_date IS NULL )))
       AND (    ( Recinfo.last_update_login = p_last_update_login)
            OR (    ( Recinfo.last_update_login IS NULL )
                AND (  p_last_update_login IS NULL )))
       AND (    ( Recinfo.object_version_number = p_object_version_number)
            OR (    ( Recinfo.object_version_number IS NULL )
                AND (  p_object_version_number IS NULL )))
       ) THEN
       RETURN;

Line: 266


         x_p_last_updated_by  IN  NUMBER,
         x_p_last_update_date  IN  DATE,
         x_p_last_update_login  IN  NUMBER,
         x_p_object_version_number   IN NUMBER,
	  x_owner               IN VARCHAR2,
	 x_custom_mode IN VARCHAR2
)
IS
   l_user_id      number :=1;

Line: 285


     select last_updated_by, nvl(object_version_number,1)
     from ams_web_plce_citem_assoc
     where placement_citem_id =  x_placement_citem_id;

Line: 290


     select 'x'
     from   ams_web_plce_citem_assoc
     where placement_citem_id =  x_placement_citem_id;

Line: 295


      select ams_web_plce_citem_assoc_s.nextval
      from dual;

Line: 318


      AMS_WEB_CITEM_ASSOC_PKG.Insert_Row (
         px_placement_citem_id => l_placement_citem_id,
	 p_placement_mp_id   => x_placement_mp_id,
         p_content_item_id  => x_content_item_id,
         p_citem_version_id =>   x_citem_version_id,
         p_created_by => l_user_id,
         p_creation_date => SYSDATE,
         p_last_updated_by => l_user_id,
         p_last_update_date => SYSDATE,
         p_last_update_login => 1,
         px_object_version_number => l_obj_verno,
	 p_return_status       => l_return_status,
	 p_msg_count         => l_msg_count,
	 p_msg_data            => l_msg_data
          );

Line: 340


      AMS_WEB_CITEM_ASSOC_PKG.Update_Row (
         p_placement_citem_id => l_placement_citem_id,
	 p_placement_mp_id   => x_placement_mp_id ,
         p_content_item_id  => x_content_item_id,
         p_citem_version_id =>   x_citem_version_id,
         p_created_by => l_user_id,
         p_creation_date => SYSDATE,
         p_last_updated_by => l_user_id,
         p_last_update_date => SYSDATE,
         p_last_update_login => 1,
         p_object_version_number => l_obj_verno
      );