APPS.IBE_WF_NOTIF_SETUP_PVT SQL Statements

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

Line: 16

procedure INSERT_ROW (

  X_ROWID in out NOCOPY VARCHAR2,
  P_NOTIF_SETUP_ID in NUMBER,
  P_ORG_ID_FLAG in VARCHAR2,
  P_MSITE_ID_FLAG in VARCHAR2,
  P_USER_TYPE_FLAG in VARCHAR2,
  P_ENABLED_FLAG in VARCHAR2,
  P_DEFAULT_MESSAGE_NAME in VARCHAR2,
  P_UPDATE_ENABLED_FLAG in VARCHAR2,
  P_OBJECT_VERSION_NUMBER in NUMBER,
  P_NOTIFICATION_NAME in VARCHAR2,
  p_customized_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
  cursor C is
    select ROWID
    from IBE_WF_NOTIF_SETUP
    where NOTIF_SETUP_ID = p_NOTIF_SETUP_ID;

Line: 40

  insert into IBE_WF_NOTIF_SETUP (
    NOTIF_SETUP_ID,
    NOTIFICATION_NAME,
    ORG_ID_FLAG,
    MSITE_ID_FLAG,
    USER_TYPE_FLAG,
    ENABLED_FLAG,
    DEFAULT_MESSAGE_NAME,
    UPDATE_ENABLED_FLAG,
    CUSTOMIZED_FLAG,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    OBJECT_VERSION_NUMBER
  ) select
    P_NOTIF_SETUP_ID,
    P_NOTIFICATION_NAME,
    P_ORG_ID_FLAG,
    P_MSITE_ID_FLAG,
    P_USER_TYPE_FLAG,
    P_ENABLED_FLAG,
    P_DEFAULT_MESSAGE_NAME,
    P_UPDATE_ENABLED_FLAG,
    P_CUSTOMIZED_FLAG,
    P_CREATED_BY,
    P_CREATION_DATE,
    P_LAST_UPDATED_BY,
    P_LAST_UPDATE_DATE,
    P_LAST_UPDATE_LOGIN,
    P_OBJECT_VERSION_NUMBER
 FROM DUAL
 WHERE not exists
    (select NULL
    from IBE_WF_NOTIF_SETUP T
    where T.NOTIF_SETUP_ID = P_NOTIF_SETUP_ID);

Line: 85

end INSERT_ROW;

Line: 94

  P_UPDATE_ENABLED_FLAG in VARCHAR2,
  P_OBJECT_VERSION_NUMBER in NUMBER,
  P_NOTIFICATION_NAME in VARCHAR2,
  P_CUSTOMIZED_FLAG  IN VARCHAR2
) is
  cursor c1 is select
      ORG_ID_FLAG,
      MSITE_ID_FLAG,
      USER_TYPE_FLAG,
      ENABLED_FLAG,
      DEFAULT_MESSAGE_NAME,
      UPDATE_ENABLED_FLAG,
      OBJECT_VERSION_NUMBER,
      NOTIFICATION_NAME,
      CUSTOMIZED_FLAG
    from IBE_WF_NOTIF_SETUP
    where NOTIF_SETUP_ID = p_NOTIF_SETUP_ID
    for update of NOTIF_SETUP_ID nowait;

Line: 121

          AND (tlinfo.UPDATE_ENABLED_FLAG = P_UPDATE_ENABLED_FLAG)
          AND ((tlinfo.OBJECT_VERSION_NUMBER = P_OBJECT_VERSION_NUMBER)
               OR ((tlinfo.OBJECT_VERSION_NUMBER is null) AND (P_OBJECT_VERSION_NUMBER is null)))
      ) then
        null;

Line: 134

procedure UPDATE_ROW (
  P_NOTIF_SETUP_ID in NUMBER,
  P_ORG_ID_FLAG in VARCHAR2,
  P_MSITE_ID_FLAG in VARCHAR2,
  P_USER_TYPE_FLAG in VARCHAR2,
  P_ENABLED_FLAG in VARCHAR2,
  P_DEFAULT_MESSAGE_NAME in VARCHAR2,
  P_UPDATE_ENABLED_FLAG in VARCHAR2,
  P_OBJECT_VERSION_NUMBER in NUMBER,
  P_NOTIFICATION_NAME in VARCHAR2,
  P_CUSTOMIZED_FLAG IN VARCHAR2,
  P_LAST_UPDATE_DATE in DATE,
  P_LAST_UPDATED_BY in NUMBER,
  P_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  --debug('update_row 1');

Line: 153

  update IBE_WF_NOTIF_SETUP set
    ORG_ID_FLAG = P_ORG_ID_FLAG,
    MSITE_ID_FLAG = P_MSITE_ID_FLAG,
    USER_TYPE_FLAG = p_USER_TYPE_FLAG,
    ENABLED_FLAG = P_ENABLED_FLAG,
    DEFAULT_MESSAGE_NAME = P_DEFAULT_MESSAGE_NAME,
    UPDATE_ENABLED_FLAG = P_UPDATE_ENABLED_FLAG,
    OBJECT_VERSION_NUMBER = P_OBJECT_VERSION_NUMBER,
    NOTIFICATION_NAME = P_NOTIFICATION_NAME,
    CUSTOMIZED_FLAG = P_CUSTOMIZED_FLAG,
    LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = P_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = P_LAST_UPDATE_LOGIN
  where NOTIF_SETUP_ID = P_NOTIF_SETUP_ID;

Line: 177

end UPDATE_ROW;

Line: 179

procedure DELETE_ROW (
  P_NOTIF_SETUP_ID in NUMBER
) is
begin
  delete from IBE_WF_NOTIF_SETUP
  where NOTIF_SETUP_ID = p_NOTIF_SETUP_ID;

Line: 194

end DELETE_ROW;

Line: 204

  P_UPDATE_ENABLED_FLAG in VARCHAR2,
  P_OBJECT_VERSION_NUMBER in NUMBER,
  p_customized_flag IN VARCHAR2,
  P_NOTIFICATION_NAME in VARCHAR2,
  P_LAST_UPDATE_DATE in varchar2,
  P_CUSTOM_MODE  in Varchar2) IS

 l_row_id VARCHAR2(64);

Line: 215

 f_ludate  date;    -- entity update date in file

Line: 217

 db_ludate date;    -- entity update date in db

Line: 224

 f_ludate := nvl(to_date(P_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);

Line: 226

 select LAST_UPDATED_BY, LAST_UPDATE_DATE
   	into db_luby, db_ludate
  	from IBE_WF_NOTIF_SETUP
   	where notif_setup_id = P_NOTIF_SETUP_ID;

Line: 236

	       select enabled_flag
	       into l_enabled_flag
	       from ibe_wf_notif_setup
	       where notif_setup_id = p_notif_setup_id;

Line: 244

     update_row(
	   p_notif_setup_id	=> p_notif_Setup_id,
	   p_org_id_flag		=> p_org_id_flag,
	   p_msite_id_flag		=> p_msite_id_flag,
	   p_user_type_flag	=> p_user_type_flag,
	   p_enabled_flag		=> l_enabled_flag,
	   p_default_message_name	=> p_default_message_name,
	   p_update_enabled_flag	=> p_update_enabled_flag,
	   p_object_version_number => p_object_version_number,
	   p_notification_name	=> p_notification_name,
	   p_customized_flag	=> p_customized_flag,
	   p_last_update_date	=> f_ludate, --sysdate,
	   p_last_updated_by	=> f_luby,--user_id,
	   p_last_update_login	=> f_luby);--user_id);

Line: 259

      update_row(
	   p_notif_setup_id	=> p_notif_Setup_id,
	   p_org_id_flag		=> p_org_id_flag,
	   p_msite_id_flag		=> p_msite_id_flag,
	   p_user_type_flag	=> p_user_type_flag,
	   p_enabled_flag		=> p_enabled_flag,
	   p_default_message_name	=> p_default_message_name,
	   p_update_enabled_flag	=> p_update_enabled_flag,
	   p_object_version_number => p_object_version_number,
	   p_notification_name	=> p_notification_name,
	   p_customized_flag	=> p_customized_flag,
	   p_last_update_date	=> f_ludate, --sysdate,
	   p_last_updated_by	=> f_luby,--user_id,
	   p_last_update_login	=> f_luby);--user_id);

Line: 278

     insert_row(
        X_ROWID 		    => l_row_id,
        P_NOTIF_SETUP_ID 	=> p_notif_Setup_id,
        P_ORG_ID_FLAG 		=> p_org_id_flag,
        P_MSITE_ID_FLAG 	=> p_msite_id_flag,
        P_USER_TYPE_FLAG 	=> p_user_type_flag,
        P_ENABLED_FLAG 		=> p_enabled_flag,
        P_DEFAULT_MESSAGE_NAME  => p_default_message_name,
        P_UPDATE_ENABLED_FLAG 	=> p_update_enabled_flag,
        P_OBJECT_VERSION_NUMBER => p_object_version_number,
        P_NOTIFICATION_NAME 	=> p_notification_name,
        p_customized_flag 	=> p_customized_flag,
        P_CREATION_DATE 	=> f_ludate, --sysdate,
        P_CREATED_BY 		=> f_luby,--user_id,
        P_LAST_UPDATE_DATE 	=> f_ludate, --sysdate,
        P_LAST_UPDATED_BY 	=> f_luby,--user_id,
        P_LAST_UPDATE_LOGIN => f_luby);--user_id);

Line: 305

   select '1'
   into l_exists
   from dual
   where exists(
	  select distinct notification_name
	  from ibe_wf_notif_setup
	  where notification_name = p_notification_name);

Line: 334

      select '1'
      into l_exists
      From Dual
      where exists(
          select notif_setup_id, object_version_number, notification_name
          from ibe_wf_notif_setup
          where notif_setup_id = p_notif_setup_id);

Line: 351

      select '1'
      into l_exists
      From Dual
      where exists(
          select notif_setup_id, object_version_number, notification_name
          from ibe_wf_notif_setup
          where notif_setup_id = p_notif_setup_id
	  And object_version_number = p_object_version_number);

Line: 392

   P_UPDATE_ENABLED_FLAG 	in VARCHAR2,
   p_object_version_number	IN NUMBER := FND_API.G_MISS_NUM,
   P_NOTIFICATION_NAME 		in VARCHAR2,
   p_customized_flag		IN VARCHAR2
) IS
   l_api_name 		CONSTANT VARCHAR2(30) := 'save_wf_notif_setup';

Line: 399

   l_operation_type 	VARCHAR2(10) := 'INSERT';

Line: 408

	select ibe_wf_notif_setup_s1.nextval
        From dual;

Line: 431

         l_operation_type :='UPDATE';

Line: 433

             select object_version_number
	     into l_object_version_number
    	     from ibe_wf_notif_setup
             where notif_setup_id = p_notif_setup_id;

Line: 446

   if( p_notification_name is not null AND l_operation_type = 'INSERT') then
   --debug('Save_wf_notif_setup 6');

Line: 454

   elsif( p_notification_name is null AND l_operation_type = 'INSERT') then

          --debug('save_wf_notif_setup 9');

Line: 493

   if( l_operation_type = 'INSERT' ) THEN
          --debug('save_wf_notif_setup 11');

Line: 502

	       select nvl(max(notif_setup_id) , 0)
	       into l_notif_setup_id
	       from ibe_wf_notif_setup;

Line: 513

        insert_row(
  	    X_ROWID 			=> l_rowid,
            P_NOTIF_SETUP_ID 		=> l_notif_setup_id,
            P_ORG_ID_FLAG 		=> p_org_id_flag,
            P_MSITE_ID_FLAG 		=> p_msite_id_flag,
            P_USER_TYPE_FLAG 		=> p_user_type_flag,
            P_ENABLED_FLAG 		=> p_enabled_flag,
            P_DEFAULT_MESSAGE_NAME 	=> p_default_MESSAGE_NAME,
            P_UPDATE_ENABLED_FLAG 	=> p_UPDATE_ENABLED_FLAG,
            P_OBJECT_VERSION_NUMBER 	=> 1,
            P_NOTIFICATION_NAME 	=> p_notification_name,
	    p_customized_flag		=> p_customized_flag,
            P_CREATION_DATE 		=> sysdate,
            P_CREATED_BY 		=> FND_GLOBAL.user_id,
            P_LAST_UPDATE_DATE 		=> sysdate,
            P_LAST_UPDATED_BY 		=> FND_GLOBAL.user_id,
            P_LAST_UPDATE_LOGIN 	=> FND_GLOBAL.user_id
        );

Line: 532

    elsif( l_operation_type = 'UPDATE') then
          --debug('save_wf_notif_setup 14');

Line: 535

	update_row(
  	    P_NOTIF_SETUP_ID 		=> l_notif_setup_id,
            P_ORG_ID_FLAG 		=> p_org_id_flag,
            P_MSITE_ID_FLAG 		=> p_msite_id_flag,
            P_USER_TYPE_FLAG 		=> p_user_type_flag,
            P_ENABLED_FLAG 		=> p_enabled_flag,
            P_DEFAULT_MESSAGE_NAME 	=> p_default_MESSAGE_NAME,
            P_UPDATE_ENABLED_FLAG 	=> p_UPDATE_ENABLED_FLAG,
            P_OBJECT_VERSION_NUMBER 	=> l_object_version_number,
            P_NOTIFICATION_NAME 	=> p_notification_name,
	    p_customized_flag		=> p_customized_flag,
            P_LAST_UPDATE_DATE 		=> sysdate,
            P_LAST_UPDATED_BY 		=> FND_GLOBAL.user_id,
            P_LAST_UPDATE_LOGIN 	=> FND_GLOBAL.user_id
        );

Line: 594

PROCEDURE delete_wf_notif_setup
(
	p_api_version		IN NUMBER,
	p_init_msg_list		IN VARCHAR2 := FND_API.G_FALSE,
	p_commit		IN VARCHAR2 := FND_API.G_FALSE,
	x_return_status		OUT NOCOPY VARCHAR2,
	x_msg_count		OUT NOCOPY NUMBER,
	x_msg_data		OUT NOCOPY VARCHAR2,
	p_notification_name	IN VARCHAR2
) IS
  cursor wf_notif_setup(p_notification_name in VARCHAR2) is
     select notif_setup_id
     From IBE_WF_NOTIF_SETUP
     where notification_name = p_notification_name;

Line: 610

     select notif_msg_map_id, notification_name, message_name
     From ibe_wf_notif_msg_maps
     where notif_setup_id = p_notif_setup_id;

Line: 616

   l_api_name 		CONSTANT VARCHAR2(30) := 'delete_wf_notif_setup';

Line: 623

  savepoint delete_wf_notif_setup;

Line: 645

        IBE_WF_NOTIF_MSG_MAPS_PVT.Delete_Wf_Notif_Msg_MAPS(
	   p_api_version		=> 1.0,
	   p_init_msg_list		=> FND_API.G_FALSE,
	   p_commit			=> FND_API.G_FALSE,
	   x_return_status		=> l_return_status,
	   x_msg_count			=> x_msg_count,
	   x_msg_data			=> x_msg_data,
	   p_notification_name		=> p_notification_name,
           p_notif_msg_map_id		=> l_notif_msg_map_id,
	   p_message_name		=> l_message_name);

Line: 661

     Delete_Row(p_notif_setup_id => l_notif_setup_id);

Line: 670

     ROLLBACK TO delete_wf_notif_setup;

Line: 678

     ROLLBACK TO delete_wf_notif_setup;

Line: 685

     ROLLBACK TO delete_wf_notif_setup;

Line: 694

END Delete_wf_notif_setup;

Line: 696

procedure Update_Wf_notif_setup(
    x_return_status 	OUT NOCOPY JTF_VARCHAR2_TABLE_100,
    x_msg_count		OUT NOCOPY NUMBER,
    x_msg_data		OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
    p_notif_name_tbl	IN JTF_VARCHAR2_TABLE_100,
    p_enabled_flag_tbl  IN JTF_VARCHAR2_TABLE_100)
IS
    l_notif_name_tbl JTF_VARCHAR2_TABLE_100;

Line: 708

    l_update_enabled_flag VARCHAR2(1);

Line: 731

	x_msg_data(1) := FND_MESSAGE.GET_STRING('IBE', 'IBE_WF_NOTIF_UPDATE_ERROR');

Line: 734

        update ibe_wf_notif_setup
	set enabled_flag = 'Y'
	where enabled_flag <> 'Y';

Line: 746

	      select msite_id_flag, org_id_flag, user_type_flag, default_message_name, update_enabled_flag,
		     customized_flag, notif_setup_id, object_version_number
	      into l_msite_flag, l_org_flag, l_user_type_flag, l_default_message_name, l_update_enabled_flag,
	           l_customized_Flag, l_notif_setup_id, l_object_version_number
	      from ibe_Wf_notif_setup
	      where notification_name = p_notif_name_tbl(i);

Line: 776

		   p_update_enabled_flag	=> l_update_enabled_flag,
		   p_object_version_number	=> l_object_version_number,
		   p_notification_name		=> p_notif_name_tbl(i),
		   p_customized_flag		=> l_customized_flag);

Line: 793

end update_wf_notif_setup;

Line: 798

   select enabled_flag
   into l_enabled_flag
   from ibe_wf_notif_setup
   where notification_name = p_notification_name;

Line: 815

  P_UPDATE_ENABLED_FLAG 	in VARCHAR2,
  P_OBJECT_VERSION_NUMBER 	in NUMBER,
  p_customized_flag 		IN VARCHAR2,
  P_NOTIFICATION_NAME 		in VARCHAR2,
  P_LAST_UPDATE_DATE		in VARCHAR2,
  P_CUSTOM_MODE             in VARCHAR2,
  P_UPLOAD_MODE             in VARCHAR2)
is

Begin
	 if ( p_upload_mode = 'NLS') then
             null;

Line: 836

	      P_UPDATE_ENABLED_FLAG,
		  P_OBJECT_VERSION_NUMBER,
		  P_CUSTOMIZED_FLAG,
		  P_NOTIFICATION_NAME,
          P_LAST_UPDATE_DATE,
          P_CUSTOM_MODE);