APPS.WF_PUB_ICC SQL Statements

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

Line: 13

	select instr(p_mail_to,':',1) INTO l_sep_index from dual;

Line: 17

		select user_name into l_receiver
		from ego_people_v
		where user_name=l_name
		and rownum=1;

Line: 22

		select 'HZ_GROUP:'||group_id into l_receiver
		from EGO_GROUPS_V
		where group_name=l_name
		and rownum=1;

Line: 46

 		is select system_code
		from EGO_PUB_BAT_SYSTEMS_B
		where batch_id=l_batch_id;

Line: 93

	select parameters
	into   l_subparams
	from   wf_event_subscriptions
	where  guid = p_subscription;

Line: 169

select instr(l_receiver,':',1) INTO l_sep_index from dual;

Line: 217

	select pk1_value,pk2_value
	from EGO_PUB_BAT_ENT_OBJS_B
	where batch_id=p_batch_id;

Line: 222

	select SEGMENT1,description,start_date_active,end_date_active
	from MTL_ITEM_CATALOG_GROUPS
	where item_catalog_group_id=l_icc_id;

Line: 239

		select start_active_date,end_active_date
		into l_start_date,l_end_date
		from EGO_MTL_CATALOG_GRP_VERS_B
		where item_catalog_group_id=l_icc_id
			and version_seq_id=l_version;

Line: 275

*The procedure is used to update the status of the batch system
*/
procedure UPDATE_SYS_STATUS(
    itemtype  in varchar2,
    itemkey   in varchar2,
    actid     in number,
    funcmode  in varchar2,
    resultout in out NOCOPY varchar2)
IS
l_pub_system varchar2(50);

Line: 305

	update EGO_PUB_BAT_STATUS_B
		set status_code =l_sys_status,
				message =l_message
		where batch_id=l_batch_id
					and system_code=l_pub_system;

Line: 318

    wf_core.context('WFPUBICC', 'UPDATE_SYS_STATUS',
		    itemtype, itemkey, to_char(actid), funcmode,SQLERRM);

Line: 321

END UPDATE_SYS_STATUS;