APPS.IBE_WF_MSG_MAPPING_PVT SQL Statements

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

Line: 31

           select value
           into l_dbgdir
           from v$PARAMETER
           where name = 'utl_file_dir';

Line: 43

           select to_char(sysdate, 'DD-MON-YY:HH.MI.SS') into l_err_msg from dual;

Line: 63

       select notif_msg_map_id, notif_setup_id, message_name, enabled_flag, msite_id, org_id, user_type,
		all_msite_flag, all_org_flag, all_user_Type_flag
       from ibe_wf_notif_msg_maps
       where notif_setup_id = p_notif_setup_id
       and msite_id = p_msite_id
       and enabled_flag = 'Y';  -- bug 7720550, scnagara

Line: 71

       select notif_msg_map_id, notif_setup_id, message_name, enabled_flag, msite_id, org_id, user_type,
		all_msite_flag, all_org_flag, all_user_Type_flag
       from ibe_wf_notif_msg_maps
       where notif_setup_id = p_notif_setup_id
       and msite_id is null
       and enabled_flag = 'Y';  -- bug 7720550, scnagara

Line: 112

       select notif_msg_map_id, notif_setup_id, message_name, enabled_flag, msite_id, org_id, user_type,
		all_msite_flag, all_org_flag, all_user_Type_flag
       from ibe_wf_notif_msg_maps
       where notif_setup_id = p_notif_setup_id
       and all_msite_flag = 'Y'
       and enabled_flag = 'Y' ; -- bug 7720550, scnagara

Line: 217

	select message_name, enabled_flag
	from IBE_WF_NOTIF_MSG_MAPS
	WHERE notif_setup_id = p_notif_setup_id
	and default_msg_map_flag = 'Y';

Line: 373

       select notif_msg_map_id, notif_setup_id, message_name, enabled_flag, msite_id, org_id, user_type,
		all_msite_flag, all_org_flag, all_user_Type_flag
       from ibe_wf_notif_msg_maps
       where notif_setup_id = p_notif_setup_id
       and org_id is null;

Line: 379

       select notif_msg_map_id, notif_setup_id, message_name, enabled_flag, msite_id, org_id, user_type,
		all_msite_flag, all_org_flag, all_user_Type_flag
       from ibe_wf_notif_msg_maps
       where notif_setup_id = p_notif_setup_id
       and org_id = p_org_id;

Line: 418

       select notif_msg_map_id, notif_setup_id, message_name, enabled_flag, msite_id, org_id, user_type,
		all_msite_flag, all_org_flag, all_user_Type_flag
       from ibe_wf_notif_msg_maps
       where notif_setup_id = p_notif_setup_id
       and all_org_flag = 'Y';

Line: 445

       select notif_msg_map_id, notif_setup_id, message_name, enabled_flag, msite_id, org_id, user_type,
		all_msite_flag, all_org_flag, all_user_Type_flag
       from ibe_wf_notif_msg_maps
       where notif_setup_id = p_notif_setup_id
       and user_type = p_user_type;

Line: 471

       select notif_msg_map_id, notif_setup_id, message_name, enabled_flag, msite_id, org_id, user_type,
		all_msite_flag, all_org_flag, all_user_Type_flag
       from ibe_wf_notif_msg_maps
       where notif_setup_id = p_notif_setup_id
       and all_user_type_flag = 'Y';

Line: 647

	   select message_name, enabled_flag
	   into l_wf_msg_name, l_enabled_flag
	   from IBE_WF_NOTIF_MSG_MAPS
	   where notif_setup_id = l_notif_setup_id
	   AND default_msg_map_flag <> 'Y'
	   and rownum < 2;

Line: 714

    select org_id_flag, msite_id_flag, enabled_flag, notif_setup_id, user_type_flag
    into l_org_id_flag, l_msite_id_flag, l_enabled_flag, l_notif_setup_id, l_user_type_flag
    from ibe_wf_notif_setup
    where notification_name = p_notification_name;