APPS.WF_RULE dependencies on WF_EVENT_SUBSCRIPTIONS

Line 6: ** column from the wf_event_subscriptions

2: /* $Header: wfruleb.pls 120.5.12020000.3 2012/08/10 14:20:14 skandepu ship $ */
3: --------------------------------------------------------------------------
4: /*
5: ** get_sub_parameters (PRIVATE) - retrieve the value of the PARAMETERS
6: ** column from the wf_event_subscriptions
7: ** table for the specified guid
8: */
9: FUNCTION get_sub_parameters(p_subscription_guid in raw) return varchar2
10: is

Line 14: from wf_event_subscriptions

10: is
11: parm varchar2(4000);
12: begin
13: select parameters into parm
14: from wf_event_subscriptions
15: where guid = p_subscription_guid;
16:
17: return parm;
18: exception

Line 101: select source_type into srctype from wf_event_subscriptions

97: 'Event Name: '||p_event.getEventName());
98: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_rule.log.event_key',
99: 'Event Key: '||p_event.getEventKey());
100:
101: select source_type into srctype from wf_event_subscriptions
102: where guid = p_subscription_guid;
103:
104: -- Need to check if clob is temporary instead of null
105: IsTmp := dbms_lob.istemporary(p_event.GetEventData());

Line 217: from wf_event_subscriptions

213: begin
214: select out_agent_guid,to_agent_guid,wf_process_type,wf_process_name,priority
215: , parameters
216: into out_guid, to_guid, wftype, wfname, pri, subparams
217: from wf_event_subscriptions
218: where guid = p_subscription_guid;
219:
220: -- Check if need to generate Unique Correlation Id
221: if subparams is not null then

Line 344: from wf_event_subscriptions

340: begin
341:
342: select wf_process_type,wf_process_name,priority,parameters
343: into wftype, wfname, pri, param
344: from wf_event_subscriptions
345: where guid = p_subscription_guid;
346:
347: -- Workflow --
348: if (wftype is not null) then

Line 418: from wf_event_subscriptions

414: ikey varchar2(240);
415: begin
416: select out_agent_guid,to_agent_guid,wf_process_type,wf_process_name,priority
417: into out_guid, to_guid, wftype, wfname, pri
418: from wf_event_subscriptions
419: where guid = p_subscription_guid;
420:
421: -- Workflow --
422: if (wftype is not null) then

Line 500: FROM wf_event_subscriptions

496: l_equalpos number;
497:
498: CURSOR c_parameters IS
499: SELECT parameters
500: FROM wf_event_subscriptions
501: WHERE guid = p_subscription_guid;
502:
503: begin
504:

Line 752: from wf_event_subscriptions

748:
749: select out_agent_guid,to_agent_guid,wf_process_type,wf_process_name,priority
750: , parameters
751: into out_guid, to_guid, wftype, wfname, pri, subparams
752: from wf_event_subscriptions
753: where guid = p_subscription_guid;
754:
755: l_result := setParametersIntoParameterList(p_subscription_guid,p_event);
756: