APPS.WF_BES_CLEANUP dependencies on WF_EVENT

Line 151: x_payload WF_EVENT_T;

147: x_have_msg out nocopy boolean)
148: is
149: l_dequeue_options dbms_aq.dequeue_options_t;
150: x_message_properties dbms_aq.message_properties_t;
151: x_payload WF_EVENT_T;
152: x_msgid RAW(16);
153: no_messages exception;
154: pragma exception_init(no_messages, -25228);
155: snap_too_old exception;

Line 323: and system_guid = WF_EVENT.local_system_guid;

319: select queue_name
320: INTO l_queue_name
321: from wf_agents
322: where name = p_agent_name
323: and system_guid = WF_EVENT.local_system_guid;
324:
325: if(l_queue_name is not null) then
326: -- derive the queue name and the schema
327: l_pos := instr(l_queue_name,'.');

Line 334: l_owner := wf_event.schema_name;

330: if (l_pos > 0) then
331: l_owner := substr(l_queue_name, 1, l_pos - 1);
332: else
333: -- if queue_name does not contain schema we will look in WF_SCHEMA
334: l_owner := wf_event.schema_name;
335: end if;
336:
337: SELECT queue_table
338: into l_queue_table

Line 482: wf_event.raise(p_event_name => 'oracle.apps.wf.bes.control.ping',

478: end loop;
479:
480: -- raise the ping event
481:
482: wf_event.raise(p_event_name => 'oracle.apps.wf.bes.control.ping',
483: p_event_key => l_ping_number);
484: end if;
485:
486: -- remove the data older than G_MAX_RETENTION_TIME