APPS.IBU_SUBS_EMAIL_PKG SQL Statements

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

Line: 8

procedure ibu_create_or_update_role (user_id in NUMBER, email_address_in in varchar2, planguage in varchar2)
as
	user_name      varchar2(100):=NULL;

Line: 106

       get_seq varchar2(50) := 'select ' || 'IBU_WF_ITEM_KEY_S' || '.nextval from dual';

Line: 118

				 select user into l_user from dual;

Line: 121

                     /* select count(*)
				  into cnt
				  from all_objects
				  where object_name like 'IBU_NOTIFICATION_S'
				  and object_type = 'SEQUENCE'
				  and owner = l_user;

Line: 217

       procedure ibu_update_role (role_name in varchar2,
                      role_display_name in varchar2,
                      notification_preference in varchar2,
                      language in varchar2,
                      territory in varchar2,
                      email_address in varchar2,
                      fax in varchar2) is
       begin
		  WF_Directory.SetAdHocRoleAttr (role_name, role_display_name, notification_preference, language, territory, email_address, fax);

Line: 226

       end ibu_update_role;