APPS.OKL_SO_CREDIT_APP_WF dependencies on WF_EVENT

Line 19: FROM wf_event_subscriptions a,

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

Line 20: wf_events b

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

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

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

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

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

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

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

Line 71: wf_event.raise( p_event_name => l_event_name

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

Line 1289: wf_event.addparametertolist('LAPP_ID'

1285: END IF;-- For l_lap_status is not null condition
1286: -- Bug#4741121 - viselvar - Modified - Start
1287: -- raise the business event passing the lease application id added to the parameter list
1288:
1289: wf_event.addparametertolist('LAPP_ID'
1290: ,l_lap_id
1291: ,l_parameter_list);
1292:
1293: okl_wf_pvt.raise_event(p_api_version => l_api_version