APPS.GMI_WF_ITEM_ACTIVATION SQL Statements

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

Line: 69

		select
			user_name
		into
			l_name
		from
			fnd_user
		where
			user_id = p_created_by;

Line: 84

                /* Added the ROWNUM condition to avoid the ON-INSERT error. */
		select
			display_name
		into
			l_display_name
		from
			wf_users
		where
			name = l_name
                and
                        rownum =1;

Line: 148

	procedure select_approver
	(
		p_itemtype in varchar2,
		p_itemkey in varchar2,
		p_actid in number,
		p_funcmode in varchar2,
		p_result out nocopy varchar2
	)
	is
		l_item_no varchar2(32) :=
			wf_engine.getitemattrtext (p_itemtype, p_itemkey,
				'ITEM_NO');

Line: 177

		selection_cancelled exception;

Line: 178

		selection_timeout  exception;

Line: 179

		pragma exception_init(selection_cancelled, -20101);

Line: 180

		pragma exception_init(selection_timeout,  -20102);

Line: 192

			   select c.user_name,wu.display_name
			   into   l_approver_name,l_approver_display_name
			   from   per_assignments_f a, fnd_user b, fnd_user c,	wf_roles wu
			   where  a.person_id=b.employee_id
                                  and a.supervisor_id=c.employee_id
                                  and b.user_name = l_requestor_name
			          and wu.name = c.user_name
                           group by c.user_name,wu.display_name;

Line: 201

                           SELECT supervisor_user_name, wu.display_name
                             into l_approver_name,l_approver_display_name
                             from ic_item_hierarchy , wf_roles wu
                            where creator_user_name = l_requestor_name
                              and rownum = 1
                              and supervisor_user_name=wu.name;

Line: 209

                           Select ITEM_DESC1 into l_item_desc
                            from  IC_ITEM_MST
                            where ITEM_NO=l_ITEM_NO;

Line: 236

                    raise selection_cancelled;

Line: 240

                    raise selection_timeout;

Line: 244

		when selection_cancelled then
			wf_engine.setitemattrtext (p_itemtype,
				p_itemkey, 'ERRMSG',
	'The workflow approver selection process was cancelled for item ' ||
					l_item_no || '.');

Line: 251

		when selection_timeout then
			wf_engine.setitemattrtext (p_itemtype,
				p_itemkey, 'ERRMSG',
		'The workflow approver selection process timed out for item ' ||
					l_item_no || '.');

Line: 266

                         select  display_name into l_approver_display_name
                         from wf_roles where name =l_approver_name;

Line: 299

				'the workflow approver selection ' ||
				'process for item ' || l_item_no ||
				'.  Message text: ' || l_errmsg);

Line: 304

	end select_approver;

Line: 334

			update
				ic_item_mst
			set
				inactive_ind = 0, trans_cnt = -99
			where
				item_id = l_item_id;