APPS.OKL_SO_CREDIT_APP_WF dependencies on WF_EVENT

Line 22: FROM wf_event_subscriptions a,

18: -----------------------------------------------------------------------
19: IS
20: CURSOR cu0 IS
21: SELECT 'Y'
22: FROM wf_event_subscriptions a,
23: wf_events b
24: WHERE a.event_filter_guid = b.guid
25: AND a.status = 'ENABLED'
26: AND b.name = p_event_name

Line 23: wf_events b

19: IS
20: CURSOR cu0 IS
21: SELECT 'Y'
22: FROM wf_event_subscriptions a,
23: wf_events b
24: WHERE a.event_filter_guid = b.guid
25: AND a.status = 'ENABLED'
26: AND b.name = p_event_name
27: AND rownum = 1;

Line 65: wf_event.AddParameterToList('QUOTE_ID',TO_CHAR(p_quote_id),l_parameter_list);

61: select okl_wf_item_s.nextval INTO l_seq FROM DUAL ;
62: l_key := l_event_name ||l_seq ;
63:
64: --Set Parameters
65: wf_event.AddParameterToList('QUOTE_ID',TO_CHAR(p_quote_id),l_parameter_list);
66: wf_event.AddParameterToList('REQUESTED_ID',TO_CHAR(p_requestor_id),l_parameter_list);
67: --added by akrangan
68: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
69: -- Call it again if you have more than one parameter

Line 66: wf_event.AddParameterToList('REQUESTED_ID',TO_CHAR(p_requestor_id),l_parameter_list);

62: l_key := l_event_name ||l_seq ;
63:
64: --Set Parameters
65: wf_event.AddParameterToList('QUOTE_ID',TO_CHAR(p_quote_id),l_parameter_list);
66: wf_event.AddParameterToList('REQUESTED_ID',TO_CHAR(p_requestor_id),l_parameter_list);
67: --added by akrangan
68: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
69: -- Call it again if you have more than one parameter
70: -- Keep data type (text) only

Line 68: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);

64: --Set Parameters
65: wf_event.AddParameterToList('QUOTE_ID',TO_CHAR(p_quote_id),l_parameter_list);
66: wf_event.AddParameterToList('REQUESTED_ID',TO_CHAR(p_requestor_id),l_parameter_list);
67: --added by akrangan
68: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
69: -- Call it again if you have more than one parameter
70: -- Keep data type (text) only
71:
72: -- Raise Event

Line 74: wf_event.raise( p_event_name => l_event_name

70: -- Keep data type (text) only
71:
72: -- Raise Event
73: -- It is overloaded function so use according to requirement
74: wf_event.raise( p_event_name => l_event_name
75: ,p_event_key => l_key
76: ,p_parameters => l_parameter_list);
77: l_parameter_list.DELETE;
78:

Line 1467: wf_event.addparametertolist('LAPP_ID'

1463: END IF;-- For l_lap_status is not null condition
1464: -- Bug#4741121 - viselvar - Modified - Start
1465: -- raise the business event passing the lease application id added to the parameter list
1466:
1467: wf_event.addparametertolist('LAPP_ID'
1468: ,l_lap_id
1469: ,l_parameter_list);
1470:
1471: okl_wf_pvt.raise_event(p_api_version => l_api_version