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 178: p_event_obj in out nocopy WF_Event_Obj)

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

Line 196: p_event_obj in WF_Event_Obj)

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

Line 207: -- wf_event_obj instance

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

Line 209: p_event_obj in out nocopy wf_event_obj)

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

Line 215: FROM wf_events

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

Line 220: wf_event_obj.Initialize(p_event_obj);

216: WHERE name = cp_event_name;
217:
218: begin
219: if (p_event_obj is null) then
220: wf_event_obj.Initialize(p_event_obj);
221: end if;
222:
223: open c_get_event(p_event_name);
224: fetch c_get_event into p_event_obj.guid, p_event_obj.name, p_event_obj.type,

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

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

Line 242: -- into the wf_event_obj

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

Line 247: p_event_obj in out nocopy wf_event_obj)

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

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

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

Line 312: from wf_event_subscriptions sub,

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

Line 313: wf_events evt

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

Line 314: where sub.system_guid = wf_event.local_system_guid

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

Line 328: l_subscription WF_Event_Subs_Obj;

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

Line 343: WF_Event_Subs_Obj.Initialize(l_subscription);

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

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

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

Line 454: return wf_event_obj

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

Line 456: l_event_obj wf_event_obj;

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

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

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

Line 535: return wf_event_subs_tab

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

Line 537: l_event_obj wf_event_obj;

533: p_source_type in varchar2,
534: p_source_agent in raw)
535: return wf_event_subs_tab
536: is
537: l_event_obj wf_event_obj;
538: l_any_data anyData;
539: l_dummy pls_integer;
540: l_subs_count number;
541: begin

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

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

Line 604: return wf_event_subs_obj

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

Line 606: l_event_obj WF_Event_Obj;

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

Line 801: WHERE a.system_guid = wf_event.local_system_guid

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