eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WF_BES_CACHE dependencies on WF_EVENT

Line 19: g_event_any varchar2(240) := 'oracle.apps.wf.event.any';

15: g_src_type_local varchar2(8) := 'LOCAL';
16: g_src_type_external varchar2(8) := 'EXTERNAL';
17: g_src_type_error varchar2(8) := 'ERROR';
18:
19: g_event_any varchar2(240) := 'oracle.apps.wf.event.any';
20: g_event_unexpected varchar2(240) := 'oracle.apps.wf.event.unexpected';
21:
22: g_java_sub varchar2(240) := 'java://';
23:

Line 20: g_event_unexpected varchar2(240) := 'oracle.apps.wf.event.unexpected';

16: g_src_type_external varchar2(8) := 'EXTERNAL';
17: g_src_type_error varchar2(8) := 'ERROR';
18:
19: g_event_any varchar2(240) := 'oracle.apps.wf.event.any';
20: g_event_unexpected varchar2(240) := 'oracle.apps.wf.event.unexpected';
21:
22: g_java_sub varchar2(240) := 'java://';
23:
24: g_status_yes varchar2(1) := 'Y';

Line 182: p_event_obj in out nocopy WF_Event_Obj)

178: -- This procedure sets the given event object to the Object cache. This
179: -- procedure set the event object to the appropriate cache created for
180: -- events
181: procedure Get_Event_Object(p_event_name in varchar2,
182: p_event_obj in out nocopy WF_Event_Obj)
183: is
184: l_any_data AnyData;
185: l_dummy pls_integer;
186: begin

Line 200: p_event_obj in WF_Event_Obj)

196: -- Set_Event_Object (PRIVATE)
197: -- This procedure gets the event object from the Object cache for the given
198: -- event name.
199: procedure Set_Event_Object(p_event_name in varchar2,
200: p_event_obj in WF_Event_Obj)
201: is
202: l_any_data AnyData;
203: begin
204: -- Store this object in the cache for future use

Line 211: -- wf_event_obj instance

207: end Set_Event_Object;
208:
209: -- Load_Event (PRIVATE)
210: -- Given the event name, this procedure loads the event information to the
211: -- wf_event_obj instance
212: procedure Load_Event(p_event_name in varchar2,
213: p_event_obj in out nocopy wf_event_obj)
214: is
215:

Line 213: p_event_obj in out nocopy wf_event_obj)

209: -- Load_Event (PRIVATE)
210: -- Given the event name, this procedure loads the event information to the
211: -- wf_event_obj instance
212: procedure Load_Event(p_event_name in varchar2,
213: p_event_obj in out nocopy wf_event_obj)
214: is
215:
216: CURSOR c_get_event (cp_event_name varchar2) IS
217: SELECT guid, name, type, status, generate_function,

Line 219: FROM wf_events

215:
216: CURSOR c_get_event (cp_event_name varchar2) IS
217: SELECT guid, name, type, status, generate_function,
218: java_generate_func, licensed_flag
219: FROM wf_events
220: WHERE name = cp_event_name;
221:
222: begin
223: if (p_event_obj is null) then

Line 224: wf_event_obj.Initialize(p_event_obj);

220: WHERE name = cp_event_name;
221:
222: begin
223: if (p_event_obj is null) then
224: wf_event_obj.Initialize(p_event_obj);
225: end if;
226:
227: open c_get_event(p_event_name);
228: fetch c_get_event into p_event_obj.guid, p_event_obj.name, p_event_obj.type,

Line 237: -- If event not found in the set wf_event_obj to null

233: wf_log_pkg.string(wf_log_pkg.level_statement,
234: 'wf.plsql.WF_BES_CACHE.Load_Event.Not_Found',
235: 'Event {'||p_event_name||'} not found in the database');
236: end if;
237: -- If event not found in the set wf_event_obj to null
238: p_event_obj := null;
239: end if;
240: close c_get_event;
241:

Line 246: -- into the wf_event_obj

242: end Load_Event;
243:
244: -- Load_Subscriptions (PRIVATE)
245: -- Given the event name this procedure loads all the valid subscriptions
246: -- into the wf_event_obj
247: procedure Load_Subscriptions(p_event_name in varchar2,
248: p_source_type in varchar2,
249: p_source_agent in raw,
250: p_subs_count in out nocopy number,

Line 251: p_event_obj in out nocopy wf_event_obj)

247: procedure Load_Subscriptions(p_event_name in varchar2,
248: p_source_type in varchar2,
249: p_source_agent in raw,
250: p_subs_count in out nocopy number,
251: p_event_obj in out nocopy wf_event_obj)
252: is
253:
254: -- Cursor from wf_event.Dispatch that fetches all the valid subscriptions to the
255: -- event and the event group to which the event belongs

Line 254: -- Cursor from wf_event.Dispatch that fetches all the valid subscriptions to the

250: p_subs_count in out nocopy number,
251: p_event_obj in out nocopy wf_event_obj)
252: is
253:
254: -- Cursor from wf_event.Dispatch that fetches all the valid subscriptions to the
255: -- event and the event group to which the event belongs
256: cursor active_subs (cp_event_name varchar2,
257: cp_source_type varchar2,
258: cp_source_agent_guid raw)

Line 316: from wf_event_subscriptions sub,

312: sub.standard_type std_type,
313: sub.standard_code std_code,
314: sub.on_error_code on_error,
315: sub.action_code action
316: from wf_event_subscriptions sub,
317: wf_events evt
318: where sub.system_guid = wf_event.local_system_guid
319: and sub.status = 'ENABLED'
320: and sub.licensed_flag = 'Y'

Line 317: wf_events evt

313: sub.standard_code std_code,
314: sub.on_error_code on_error,
315: sub.action_code action
316: from wf_event_subscriptions sub,
317: wf_events evt
318: where sub.system_guid = wf_event.local_system_guid
319: and sub.status = 'ENABLED'
320: and sub.licensed_flag = 'Y'
321: and sub.source_type = cp_source_type

Line 318: where sub.system_guid = wf_event.local_system_guid

314: sub.on_error_code on_error,
315: sub.action_code action
316: from wf_event_subscriptions sub,
317: wf_events evt
318: where sub.system_guid = wf_event.local_system_guid
319: and sub.status = 'ENABLED'
320: and sub.licensed_flag = 'Y'
321: and sub.source_type = cp_source_type
322: and ((sub.source_agent_guid is NOT NULL AND

Line 332: l_subscription WF_Event_Subs_Obj;

328: and evt.status = 'ENABLED'
329: and evt.licensed_flag = 'Y')
330: order by 5;
331:
332: l_subscription WF_Event_Subs_Obj;
333: l_count number;
334: begin
335:
336: -- Check if subscriptions are already loaded for this source type

Line 347: WF_Event_Subs_Obj.Initialize(l_subscription);

343: end if;
344: return;
345: end if;
346:
347: WF_Event_Subs_Obj.Initialize(l_subscription);
348: l_count := 0;
349:
350: -- Load all LOCAL subscriptions from the Database
351: if (lower(p_event_name) in (g_event_unexpected, g_event_any)) then

Line 451: -- This function returns an instance of WF_Event_Obj object type which

447: p_subs_count := l_count;
448: end Load_Subscriptions;
449:
450: -- GetEventByName
451: -- This function returns an instance of WF_Event_Obj object type which
452: -- contains the complete event information along with valid subscriptions
453: -- to the event. The information could come from the cache memory or from
454: -- the database.
455: -- IN

Line 458: return wf_event_obj

454: -- the database.
455: -- IN
456: -- p_event_name - Event name whose information is required
457: function GetEventByName(p_event_name in varchar2)
458: return wf_event_obj
459: is
460: l_event_obj wf_event_obj;
461: l_any_data anyData;
462: l_dummy pls_integer;

Line 460: l_event_obj wf_event_obj;

456: -- p_event_name - Event name whose information is required
457: function GetEventByName(p_event_name in varchar2)
458: return wf_event_obj
459: is
460: l_event_obj wf_event_obj;
461: l_any_data anyData;
462: l_dummy pls_integer;
463: begin
464: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

Line 534: -- This function returns a table of WF_EVENT_SUBS_OBJ that are the valid

530: raise;
531: end GetEventByName;
532:
533: -- GetSubscriptions
534: -- This function returns a table of WF_EVENT_SUBS_OBJ that are the valid
535: -- subscriptions to the given event.
536: function GetSubscriptions(p_event_name in varchar2,
537: p_source_type in varchar2,
538: p_source_agent in raw)

Line 539: return wf_event_subs_tab

535: -- subscriptions to the given event.
536: function GetSubscriptions(p_event_name in varchar2,
537: p_source_type in varchar2,
538: p_source_agent in raw)
539: return wf_event_subs_tab
540: is
541: l_event_obj wf_event_obj;
542: l_any_data anyData;
543: l_dummy pls_integer;

Line 541: l_event_obj wf_event_obj;

537: p_source_type in varchar2,
538: p_source_agent in raw)
539: return wf_event_subs_tab
540: is
541: l_event_obj wf_event_obj;
542: l_any_data anyData;
543: l_dummy pls_integer;
544: l_subs_count number;
545: begin

Line 604: -- This function returns a WF_EVENT_SUBS_OBJ that contains the subscription

600: raise;
601: end GetSubscriptions;
602:
603: -- GetSubscriptionByGUID
604: -- This function returns a WF_EVENT_SUBS_OBJ that contains the subscription
605: -- to the given event and mathing the given subscription GUID.
606: function GetSubscriptionByGUID(p_event_name in varchar2,
607: p_sub_guid in raw)
608: return wf_event_subs_obj

Line 608: return wf_event_subs_obj

604: -- This function returns a WF_EVENT_SUBS_OBJ that contains the subscription
605: -- to the given event and mathing the given subscription GUID.
606: function GetSubscriptionByGUID(p_event_name in varchar2,
607: p_sub_guid in raw)
608: return wf_event_subs_obj
609: is
610: l_event_obj WF_Event_Obj;
611: l_subs_count number;
612: l_subs_loaded boolean;

Line 610: l_event_obj WF_Event_Obj;

606: function GetSubscriptionByGUID(p_event_name in varchar2,
607: p_sub_guid in raw)
608: return wf_event_subs_obj
609: is
610: l_event_obj WF_Event_Obj;
611: l_subs_count number;
612: l_subs_loaded boolean;
613: begin
614: -- If either of the parameter values are null, no info can be returned

Line 805: WHERE a.system_guid = wf_event.local_system_guid

801: SELECT a.guid, a.name, a.system_guid, s.name, a.protocol, a.address,
802: a.queue_handler, a.queue_name, a.direction, a.status,
803: a.display_name, a.type, a.java_queue_handler
804: FROM wf_agents a, wf_systems s
805: WHERE a.system_guid = wf_event.local_system_guid
806: AND a.system_guid = s.guid
807: AND a.queue_handler = cp_agent_qh
808: AND a.direction = cp_direction;
809: