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

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

Line: 4


procedure INSERT_ROW (
  px_status_notification_id	 in out nocopy NUMBER,
  px_object_version_number	 in out nocopy NUMBER,
  p_status_type			 in VARCHAR2,
  p_status_code			 in VARCHAR2,
  p_enabled_flag		 in VARCHAR2,
  p_notify_pt_flag		 in VARCHAR2,
  p_notify_cm_flag		 in VARCHAR2,
  p_notify_am_flag		 in VARCHAR2,
  p_notify_others_flag		 in VARCHAR2,
  p_creation_date		 in DATE,
  p_created_by			 in NUMBER,
  p_last_update_date		 in DATE,
  p_last_updated_by		 in NUMBER,
  p_last_update_login		 in NUMBER) IS

begin
    px_object_version_number := 1;

Line: 23


  insert into PV_STATUS_NOTIFICATIONS (
    status_notification_id,
    object_version_number,
    status_type,
    status_code,
    enabled_flag,
    notify_pt_flag,
    notify_cm_flag,
    notify_am_flag,
    notify_others_flag,
    creation_date,
    created_by,
    last_update_date,
    last_updated_by,
    last_update_login)
    VALUES
    (
     DECODE ( px_status_notification_id,FND_API.g_miss_num,NULL,px_status_notification_id ),
     DECODE ( px_object_version_number,FND_API.g_miss_num,NULL,px_object_version_number ),
     DECODE ( p_status_type,FND_API.g_miss_char, NULL,p_status_type ),
     DECODE ( p_status_code,FND_API.g_miss_char, NULL,p_status_code ),
     DECODE ( p_enabled_flag,FND_API.g_miss_char, NULL,p_enabled_flag ),
     DECODE ( p_notify_pt_flag,FND_API.g_miss_char, NULL,p_notify_pt_flag ),
     DECODE ( p_notify_cm_flag,FND_API.g_miss_char, NULL,p_notify_cm_flag ),
     DECODE ( p_notify_am_flag,FND_API.g_miss_char, NULL,p_notify_am_flag ),
     DECODE ( p_notify_others_flag,FND_API.g_miss_char, NULL,p_notify_others_flag ),
     DECODE ( p_creation_date,FND_API.g_miss_char, NULL,p_creation_date ),
     DECODE ( p_created_by,FND_API.g_miss_num,NULL,p_created_by ),
     DECODE ( p_last_update_date,FND_API.g_miss_char, NULL,p_last_update_date ),
     DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by ),
     DECODE ( p_last_update_login,FND_API.g_miss_num,NULL,p_last_update_login ));

Line: 57


end INSERT_ROW;

Line: 70


  CURSOR c IS SELECT
      object_version_number,
      status_type,
      status_code,
      enabled_flag,
      notify_pt_flag,
      notify_cm_flag,
      notify_am_flag,
      notify_others_flag
    FROM pv_status_notifications
    WHERE status_notification_id = p_status_notification_id
    FOR UPDATE OF status_notification_id NOWAIT;

Line: 90


    fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

Line: 115


procedure UPDATE_ROW (
  p_status_notification_id	 in NUMBER,
  p_object_version_number	 in NUMBER,
  p_status_type			 in VARCHAR2,
  p_status_code			 in VARCHAR2,
  p_enabled_flag		 in VARCHAR2,
  p_notify_pt_flag		 in VARCHAR2,
  p_notify_cm_flag		 in VARCHAR2,
  p_notify_am_flag		 in VARCHAR2,
  p_notify_others_flag		 in VARCHAR2,
  p_last_update_date		 in DATE,
  p_last_updated_by		 in NUMBER,
  p_last_update_login		 in NUMBER
) IS
BEGIN
  UPDATE pv_status_notifications
  SET
    object_version_number = DECODE ( p_object_version_number,FND_API.g_miss_num,NULL,p_object_version_number+1 ) ,
   status_type		  = DECODE ( p_status_type,FND_API.g_miss_char, NULL,p_status_type ),
    status_code		  = DECODE ( p_status_code,FND_API.g_miss_char, NULL,p_status_code ),
    enabled_flag	  = DECODE ( p_enabled_flag,FND_API.g_miss_char, NULL,p_enabled_flag ),
    notify_pt_flag	  = DECODE ( p_notify_pt_flag,FND_API.g_miss_char, NULL,p_notify_pt_flag ),
    notify_cm_flag	  = DECODE ( p_notify_cm_flag,FND_API.g_miss_char, NULL,p_notify_cm_flag ),
    notify_am_flag	  = DECODE ( p_notify_am_flag,FND_API.g_miss_char, NULL,p_notify_am_flag ),
    notify_others_flag	  = DECODE ( p_notify_others_flag,FND_API.g_miss_char, NULL,p_notify_others_flag ),
    last_update_date	  = DECODE ( p_last_update_date,FND_API.g_miss_char, NULL,p_last_update_date ),
    last_updated_by	  = DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by ),
    last_update_login	  = DECODE ( p_last_update_login,FND_API.g_miss_num,NULL,p_last_update_login )
  WHERE status_notification_id = p_status_notification_id;

Line: 149


end UPDATE_ROW;

Line: 151


procedure SEED_UPDATE_ROW (
  p_status_notification_id	 in NUMBER,
  p_object_version_number	 in NUMBER,
  p_status_type			 in VARCHAR2,
  p_status_code			 in VARCHAR2,
  p_last_update_date		 in DATE,
  p_last_updated_by		 in NUMBER,
  p_last_update_login		 in NUMBER
) IS
BEGIN
  UPDATE pv_status_notifications
  SET
    object_version_number = DECODE ( p_object_version_number,FND_API.g_miss_num,NULL,p_object_version_number+1 ),
    status_type		  = DECODE ( p_status_type,FND_API.g_miss_char, NULL,p_status_type ),
    status_code		  = DECODE ( p_status_code,FND_API.g_miss_char, NULL,p_status_code ),
    last_update_date	  = DECODE ( p_last_update_date,FND_API.g_miss_char, NULL,p_last_update_date ),
    last_updated_by	  = DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by ),
    last_update_login	  = DECODE ( p_last_update_login,FND_API.g_miss_num,NULL,p_last_update_login )
  WHERE status_notification_id = p_status_notification_id;

Line: 175


end SEED_UPDATE_ROW;

Line: 177


procedure UPDATE_ROW_SEED (
  p_status_notification_id	 in NUMBER,
  p_object_version_number	 in NUMBER,
  p_status_type			 in VARCHAR2,
  p_status_code			 in VARCHAR2,
  p_enabled_flag		 in VARCHAR2,
  p_notify_pt_flag		 in VARCHAR2,
  p_notify_cm_flag		 in VARCHAR2,
  p_notify_am_flag		 in VARCHAR2,
  p_notify_others_flag		 in VARCHAR2,
  p_last_update_date		 in DATE,
  p_last_updated_by		 in NUMBER,
  p_last_update_login		 in NUMBER
)  IS

  CURSOR  c_updated_by
  IS
  SELECT last_updated_by
  FROM   pv_status_notifications
  WHERE  status_notification_id = p_status_notification_id;

Line: 198


  l_last_updated_by NUMBER;

Line: 203


    FOR x IN c_updated_by
     LOOP
		l_last_updated_by :=  x.last_updated_by;

Line: 212


      IF ( l_last_updated_by = 1) THEN

        PV_STATUS_NOTIFICATIONS_PKG.UPDATE_ROW(
         p_status_notification_id	  =>   p_status_notification_id,
         p_object_version_number	  =>   p_object_version_number,
         p_status_type			  =>   p_status_type,
         p_status_code			  =>   p_status_code,
         p_enabled_flag			  =>   p_enabled_flag,
         p_notify_pt_flag		  =>   p_notify_pt_flag,
         p_notify_cm_flag		  =>   p_notify_cm_flag,
         p_notify_am_flag		  =>   p_notify_am_flag,
         p_notify_others_flag		  =>   p_notify_others_flag,
         p_last_update_date		  =>   p_last_update_date,
         p_last_updated_by		  =>   p_last_updated_by,
         p_last_update_login		  =>   p_last_update_login);

Line: 231


        PV_STATUS_NOTIFICATIONS_PKG.SEED_UPDATE_ROW(
         p_status_notification_id	  =>   p_status_notification_id,
         p_object_version_number	  =>   p_object_version_number,
         p_status_type			  =>   p_status_type,
         p_status_code			  =>   p_status_code,
         p_last_update_date		  =>   p_last_update_date,
         p_last_updated_by		  =>   p_last_updated_by,
         p_last_update_login		  =>   p_last_update_login);

Line: 243


 END Update_Row_Seed;

Line: 267


  SELECT object_version_number
  FROM   pv_status_notifications
  WHERE  status_notification_id =  p_status_notification_id;

Line: 272


  SELECT 'x'
  FROM   pv_status_notifications
  WHERE  status_notification_id =  p_status_notification_id;

Line: 292


	     PV_STATUS_NOTIFICATIONS_PKG.INSERT_ROW(
		 px_status_notification_id	  =>   l_status_notification_id,
		 px_object_version_number	  =>   l_obj_verno,
		 p_status_type			  =>   p_status_type,
		 p_status_code			  =>   p_status_code,
		 p_enabled_flag			  =>   p_enabled_flag,
		 p_notify_pt_flag		  =>   p_notify_pt_flag,
		 p_notify_cm_flag		  =>   p_notify_cm_flag,
		 p_notify_am_flag		  =>   p_notify_am_flag,
		 p_notify_others_flag		  =>   p_notify_others_flag,
		 p_creation_date                  =>   SYSDATE,
		 p_created_by                     =>   l_user_id,
		 p_last_update_date		  =>   SYSDATE,
		 p_last_updated_by		  =>   l_user_id,
		 p_last_update_login		  =>   0);

Line: 313


	     PV_STATUS_NOTIFICATIONS_PKG.UPDATE_ROW_SEED(
		 p_status_notification_id	  =>   p_status_notification_id,
		 p_object_version_number	  =>   l_obj_verno,
		 p_status_type			  =>   p_status_type,
		 p_status_code			  =>   p_status_code,
		 p_enabled_flag			  =>   p_enabled_flag,
		 p_notify_pt_flag		  =>   p_notify_pt_flag,
		 p_notify_cm_flag		  =>   p_notify_cm_flag,
		 p_notify_am_flag		  =>   p_notify_am_flag,
		 p_notify_others_flag		  =>   p_notify_others_flag,
		 p_last_update_date		  =>   SYSDATE,
		 p_last_updated_by		  =>   l_user_id,
		 p_last_update_login		  =>   0);

Line: 331


PROCEDURE DELETE_ROW (
  p_status_notification_id in NUMBER
)
IS
BEGIN

  DELETE FROM pv_status_notifications
  WHERE status_notification_id = p_status_notification_id;

Line: 344


END DELETE_ROW;