APPS.IBE_WF_NOTIF_MSG_MAPS_PVT SQL Statements

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

Line: 19

procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  P_NOTIF_MSG_MAP_ID in NUMBER,
  P_NOTIF_SETUP_ID in NUMBER,
  P_NOTIFICATION_NAME in VARCHAR2,
  P_USER_TYPE in VARCHAR2,
  P_ENABLED_FLAG in VARCHAR2,
  P_DEFAULT_MSG_MAP_FLAG in VARCHAR2,
  P_OBJECT_VERSION_NUMBER in NUMBER,
  P_ALL_ORG_FLAG in VARCHAR2,
  P_ALL_MSITE_FLAG in VARCHAR2,
  P_ALL_USER_TYPE_FLAG in VARCHAR2,
  P_MSITE_ID in NUMBER,
  P_ORG_ID   IN NUMBER,
  P_MESSAGE_NAME 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_MSG_MAPS
    where NOTIF_MSG_MAP_ID = P_NOTIF_MSG_MAP_ID
    and NOTIF_SETUP_ID = P_NOTIF_SETUP_ID
    ;

Line: 45

  insert into IBE_WF_NOTIF_MSG_MAPS (
    NOTIFICATION_NAME,
    USER_TYPE,
    MESSAGE_NAME,
    ENABLED_FLAG,
    DEFAULT_MSG_MAP_FLAG,
    NOTIF_MSG_MAP_ID,
    OBJECT_VERSION_NUMBER,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    NOTIF_SETUP_ID,
    LAST_UPDATED_BY,
    ALL_ORG_FLAG,
    ALL_MSITE_FLAG,
    ALL_USER_TYPE_FLAG,
    MSITE_ID,
    ORG_ID,
    CREATION_DATE,
    CREATED_BY
  ) select
    P_NOTIFICATION_NAME,
    P_USER_TYPE,
    P_MESSAGE_NAME,
    P_ENABLED_FLAG,
    P_DEFAULT_MSG_MAP_FLAG,
    P_NOTIF_MSG_MAP_ID,
    P_OBJECT_VERSION_NUMBER,
    P_LAST_UPDATE_DATE,
    P_LAST_UPDATE_LOGIN,
    P_NOTIF_SETUP_ID,
    P_LAST_UPDATED_BY,
    P_ALL_ORG_FLAG,
    P_ALL_MSITE_FLAG,
    P_ALL_USER_TYPE_FLAG,
    P_MSITE_ID,
    P_ORG_ID,
    P_CREATION_DATE,
    P_CREATED_BY
  from DUAL
  where not exists
    (select NULL
    from IBE_WF_NOTIF_MSG_MAPS T
    where T.NOTIF_MSG_MAP_ID = P_NOTIF_MSG_MAP_ID
    and T.NOTIF_SETUP_ID = P_NOTIF_SETUP_ID);

Line: 98

end INSERT_ROW;

Line: 115

  cursor c1 is select
      NOTIFICATION_NAME,
      USER_TYPE,
      ENABLED_FLAG,
      DEFAULT_MSG_MAP_FLAG,
      OBJECT_VERSION_NUMBER,
      ALL_ORG_FLAG,
      ALL_MSITE_FLAG,
      ALL_USER_TYPE_FLAG,
      MSITE_ID,
      ORG_ID,
      MESSAGE_NAME
    from IBE_WF_NOTIF_MSG_MAPS
    where NOTIF_MSG_MAP_ID = P_NOTIF_MSG_MAP_ID
    and NOTIF_SETUP_ID = P_NOTIF_SETUP_ID
    for update of NOTIF_MSG_MAP_ID nowait;

Line: 161

procedure UPDATE_ROW (
  P_NOTIF_MSG_MAP_ID in NUMBER,
  P_NOTIF_SETUP_ID in NUMBER,
  P_NOTIFICATION_NAME in VARCHAR2,
  P_USER_TYPE in VARCHAR2,
  P_ENABLED_FLAG in VARCHAR2,
  P_DEFAULT_MSG_MAP_FLAG in VARCHAR2,
  P_OBJECT_VERSION_NUMBER in NUMBER,
  P_ALL_ORG_FLAG in VARCHAR2,
  P_ALL_MSITE_FLAG in VARCHAR2,
  P_ALL_USER_TYPE_FLAG in VARCHAR2,
  P_MSITE_ID in NUMBER,
  P_ORG_ID in NUMBER,
  P_MESSAGE_NAME 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: 181

   debug('update_row 2 ' || p_notification_name);

Line: 182

   debug('update_row 3 ' || p_notif_setup_id);

Line: 183

   debug('update_row 4 ' || p_notif_msg_map_id);

Line: 184

  update IBE_WF_NOTIF_MSG_MAPS set
    NOTIF_SETUP_ID = P_NOTIF_SETUP_ID,
    NOTIFICATION_NAME = P_NOTIFICATION_NAME,
    USER_TYPE = P_USER_TYPE,
    ENABLED_FLAG = P_ENABLED_FLAG,
    DEFAULT_MSG_MAP_FLAG = P_DEFAULT_MSG_MAP_FLAG,
    OBJECT_VERSION_NUMBER = P_OBJECT_VERSION_NUMBER,
    ALL_ORG_FLAG = P_ALL_ORG_FLAG,
    ALL_MSITE_FLAG = P_ALL_MSITE_FLAG,
    ALL_USER_TYPE_FLAG = P_ALL_USER_TYPE_FLAG,
    MSITE_ID = P_MSITE_ID,
    MESSAGE_NAME = P_MESSAGE_NAME,
    ORG_ID = P_ORG_ID,
    LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = P_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = P_LAST_UPDATE_LOGIN
  where NOTIF_MSG_MAP_ID = P_NOTIF_MSG_MAP_ID;

Line: 204

   debug('update_row 5 ' || p_notif_msg_map_id);

Line: 206

   debug('update_row 6 ' || p_notif_msg_map_id);

Line: 209

   debug('update_row 7 ' || p_notif_msg_map_id);

Line: 222

end UPDATE_ROW;

Line: 224

procedure DELETE_ROW (
  P_NOTIF_MSG_MAP_ID in NUMBER,
  P_NOTIF_SETUP_ID in NUMBER
) is
begin
  delete from IBE_WF_NOTIF_MSG_MAPS
  where NOTIF_MSG_MAP_ID = P_NOTIF_MSG_MAP_ID
  and NOTIF_SETUP_ID = P_NOTIF_SETUP_ID;

Line: 241

end DELETE_ROW;

Line: 258

	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: 286

			 p_last_update_date      => P_LAST_UPDATE_DATE,
			 p_custom_mode           => P_CUSTOM_MODE
		);

Line: 309

  P_LAST_UPDATE_DATE in VARCHAR2,
  P_CUSTOM_MODE in VARCHAR2
) IS
  user_id NUMBER;

Line: 316

  l_last_updated_by NUMBER;

Line: 317

  l_last_update_date DATE;

Line: 318

  f_last_updated_by NUMBER;

Line: 319

  f_last_update_date DATE;

Line: 328

	f_last_updated_by := fnd_load_util.owner_id(P_OWNER);

Line: 329

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

Line: 332

      select last_updated_by, last_update_date, message_name, enabled_flag
      into l_last_updated_by, l_last_update_date,l_message_name, l_enabled_flag
      from ibe_wf_notif_msg_maps
      where notif_msg_map_id = p_notif_msg_map_id;

Line: 341

  if (fnd_load_util.upload_test(f_last_updated_by,f_last_update_date,l_last_updated_by,l_last_update_date,P_CUSTOM_MODE))
  then --{
	  if( l_last_updated_by = 1 ) then --{
    	 update_row(
  	      P_NOTIF_MSG_MAP_ID 	=> p_notif_msg_map_id,
    	    P_NOTIF_SETUP_ID 	=> p_notif_setup_id,
	        P_NOTIFICATION_NAME 	=> p_notification_name,
    	    P_USER_TYPE 		=> p_user_type,
	        P_ENABLED_FLAG 		=> p_enabled_flag,
    	    P_DEFAULT_MSG_MAP_FLAG 	=> p_default_msg_map_flag,
    	    P_OBJECT_VERSION_NUMBER	=> p_object_version_number,
	        P_ALL_ORG_FLAG 		=> p_all_org_flag,
    	    P_ALL_MSITE_FLAG 	=> p_all_msite_flag,
	        P_ALL_USER_TYPE_FLAG 	=> p_all_user_type_flag,
    	    P_MSITE_ID 		=> p_msite_id,
     	    P_ORG_ID      		=> p_org_id,
      	    P_MESSAGE_NAME 		=> p_message_name,
            P_LAST_UPDATE_DATE 	=> f_last_update_date,
            P_LAST_UPDATED_BY 	=> f_last_updated_by,
            P_LAST_UPDATE_LOGIN	=> f_last_updated_by
          );

Line: 363

    	 update_row(
   	        P_NOTIF_MSG_MAP_ID 	=> p_notif_msg_map_id,
            P_NOTIF_SETUP_ID 	=> p_notif_setup_id,
            P_NOTIFICATION_NAME 	=> p_notification_name,
            P_USER_TYPE 		=> p_user_type,
            P_ENABLED_FLAG 		=> l_enabled_flag,
            P_DEFAULT_MSG_MAP_FLAG 	=> p_default_msg_map_flag,
            P_OBJECT_VERSION_NUMBER	=> p_object_version_number,
            P_ALL_ORG_FLAG 		=> p_all_org_flag,
            P_ALL_MSITE_FLAG 	=> p_all_msite_flag,
            P_ALL_USER_TYPE_FLAG 	=> p_all_user_type_flag,
            P_MSITE_ID 		=> p_msite_id,
            P_ORG_ID      		=> p_org_id,
            P_MESSAGE_NAME 		=> l_message_name,
            P_LAST_UPDATE_DATE 	=> f_last_update_date,
            P_LAST_UPDATED_BY 	=> f_last_updated_by,
            P_LAST_UPDATE_LOGIN	=> f_last_updated_by
         );

Line: 385

     insert_row(
        X_ROWID 		=> l_row_id,
        P_NOTIF_MSG_MAP_ID 	=> p_notif_msg_map_id,
        P_NOTIF_SETUP_ID 	=> p_notif_setup_id,
        P_NOTIFICATION_NAME 	=> p_notification_name,
        P_USER_TYPE 		=> p_user_type,
        P_ENABLED_FLAG 		=> p_enabled_flag,
        P_DEFAULT_MSG_MAP_FLAG 	=> p_default_msg_map_flag,
        P_OBJECT_VERSION_NUMBER => p_object_version_number,
        P_ALL_ORG_FLAG 		=> p_all_org_flag,
        P_ALL_MSITE_FLAG 	=> p_all_msite_flag,
        P_ALL_USER_TYPE_FLAG 	=> p_all_user_type_flag,
        P_MSITE_ID 		=> p_msite_id,
        P_ORG_ID   		=> p_org_id,
        P_MESSAGE_NAME 		=> p_message_name,
        P_CREATION_DATE 	=> f_last_update_date,
        P_CREATED_BY 		=> f_last_updated_by,
        P_LAST_UPDATE_DATE 	=> f_last_update_date,
        P_LAST_UPDATED_BY 	=> f_last_updated_by,
        P_LAST_UPDATE_LOGIN	=> f_last_updated_by);

Line: 414

     select '1'
     into l_exists
     from dual
     where exists (
	select notif_msg_map_id, object_version_number
        From ibe_wf_notif_msg_maps
        where notif_msg_map_id = p_notif_msg_map_id
     );

Line: 431

     select '1'
     into l_exists
     from dual
     where exists (
	select notif_msg_map_id, object_version_number
        From ibe_wf_notif_msg_maps
        where notif_msg_map_id = p_notif_msg_map_id
	and object_version_number = p_object_version_number
     );

Line: 482

    select min(notif_msg_map_id)
    into l_notif_msg_map_id
    from ibe_wf_notif_msg_maps
    where notification_name = p_notification_name
    and nvl(msite_id, -99999) = nvl(p_msite_id, -99999)
    and nvl(org_id, -99999) = nvl(p_org_id, -99999)
    and nvl(user_type, '@#$%') = nvl(p_user_type, '@#$%')
    and nvl(all_org_flag, '@#$%') = nvl(p_all_org_flag, '@#$%')
    and nvl(all_msite_flag, '@#$%') = nvl(p_all_msite_flag, '@#$%')
    and nvl(all_user_type_flag, '@#$%') = nvl(p_all_user_type_flag, '@#$%');

Line: 494

     if( p_action = 'INSERT' ) Then
         if( l_notif_msg_map_id is not null ) then
             debug('return false');

Line: 504

    elsif( p_action='UPDATE') then
        if( l_notif_msg_map_id is not null AND l_notif_msg_map_id <> p_msg_map_id ) then
             debug('return false');

Line: 546

   l_operation_type VARCHAR2(10) := 'INSERT';

Line: 570

	l_operation_type := 'UPDATE';

Line: 572

            select object_version_number
            into l_object_version_number
            from ibe_wf_notif_msg_maps
            where notif_msg_map_id = p_notif_msg_map_id
            and notif_setup_id = p_notif_setup_id;

Line: 593

    if( l_operation_type = 'INSERT') THEN
       debug('save_notif_msg_maps 4');

Line: 610

   if( l_operation_type = 'INSERT' ) then
        debug('save_notif_msg_maps 7');

Line: 612

	select ibe_wf_notif_msg_maps_s1.nextval
	into l_notif_msg_map_id
	from dual;

Line: 617

        select notif_setup_id
	into l_notif_setup_id
	from ibe_wf_notif_setup
        where notification_name = p_notification_name;

Line: 623

        insert_row(
  	    X_ROWID 			=> l_rowid,
  	    P_NOTIF_MSG_MAP_ID 		=> l_notif_msg_map_id,
  	    P_NOTIF_SETUP_ID 		=> l_notif_setup_id,
  	    P_NOTIFICATION_NAME 	=> p_notification_name,
 	    P_USER_TYPE 		=> p_user_type,
  	    P_ENABLED_FLAG 		=> p_enabled_flag,
  	    P_DEFAULT_MSG_MAP_FLAG 	=> p_default_msg_map_flag,
  	    P_OBJECT_VERSION_NUMBER 	=> 1.0,
  	    P_ALL_ORG_FLAG 		=> p_all_org_flag,
  	    P_ALL_MSITE_FLAG 		=> p_all_msite_flag,
  	    P_ALL_USER_TYPE_FLAG 	=> p_all_user_type_flag,
  	    P_MSITE_ID 			=> p_msite_id,
  	    P_ORG_ID 			=> p_org_id,
  	    P_MESSAGE_NAME 		=> p_message_name,
  	    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: 650

        update_row(
  	    P_NOTIF_MSG_MAP_ID  => l_notif_msg_map_id,
  	    P_NOTIF_SETUP_ID 	=> l_notif_setup_id,
  	    P_NOTIFICATION_NAME => p_notification_name,
  	    P_USER_TYPE 	=> p_user_type,
  	    P_ENABLED_FLAG 	=> p_enabled_flag,
  	    P_DEFAULT_MSG_MAP_FLAG => p_default_msg_map_flag,
  	    P_OBJECT_VERSION_NUMBER => l_object_version_number,
  	    P_ALL_ORG_FLAG 	=> p_all_org_flag,
  	    P_ALL_MSITE_FLAG 	=> p_all_msite_flag,
  	    P_ALL_USER_TYPE_FLAG => p_all_user_type_flag,
  	    P_MSITE_ID 		=> p_msite_id,
  	    P_ORG_ID 		=> p_ORG_id,
  	    P_MESSAGE_NAME 	=> p_message_name,
  	    P_LAST_UPDATE_DATE 	=> sysdate,
  	    P_LAST_UPDATED_BY 	=> FND_GLOBAL.user_id,
  	    P_LAST_UPDATE_LOGIN => FND_GLOBAL.user_id
        );

Line: 717

procedure delete_wf_notif_msg_maps(
   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,
   p_notif_msg_map_id		IN NUMBER,
   P_MESSAGE_NAME               in VARCHAR2
) IS
   l_notif_msg_map_id		NUMBER;

Line: 729

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

Line: 733

	select notif_setup_id
	from ibe_wf_notif_setup
	where notification_name = p_notification_name;

Line: 738

  savepoint delete_wf_notif_msg_maps;

Line: 758

          delete_row(p_notif_setup_id => l_notif_setup_id, p_notif_msg_map_id => p_notif_msg_map_id);

Line: 802

ENd delete_wf_notif_msg_maps;