APPS.OKL_AUTO_INSURANCE_PVT dependencies on WF_EVENT

Line 257: FROM wf_event_subscriptions a,

253: -----------------------------------------------------------------------
254: IS
255: CURSOR cu0 IS
256: SELECT 'Y'
257: FROM wf_event_subscriptions a,
258: wf_events b
259: WHERE a.event_filter_guid = b.guid
260: AND a.status = 'ENABLED'
261: AND b.name = p_event_name

Line 258: wf_events b

254: IS
255: CURSOR cu0 IS
256: SELECT 'Y'
257: FROM wf_event_subscriptions a,
258: wf_events b
259: WHERE a.event_filter_guid = b.guid
260: AND a.status = 'ENABLED'
261: AND b.name = p_event_name
262: AND rownum = 1;

Line 302: wf_event.AddParameterToList('CONTRACT_ID',p_contract_id,l_parameter_list);

298: select okl_wf_item_s.nextval INTO l_seq FROM DUAL ;
299: l_key := l_event_name ||l_seq ;
300:
301: --Set Parameters
302: wf_event.AddParameterToList('CONTRACT_ID',p_contract_id,l_parameter_list);
303: -- Call it again if you have more than one parameter
304: -- Keep data type (text) only
305: --added by akrangan
306: wf_event.AddParameterToList('ORG_ID',p_org_id ,l_parameter_list);

Line 306: wf_event.AddParameterToList('ORG_ID',p_org_id ,l_parameter_list);

302: wf_event.AddParameterToList('CONTRACT_ID',p_contract_id,l_parameter_list);
303: -- Call it again if you have more than one parameter
304: -- Keep data type (text) only
305: --added by akrangan
306: wf_event.AddParameterToList('ORG_ID',p_org_id ,l_parameter_list);
307: -- Raise Event
308: -- It is overloaded function so use according to requirement
309: wf_event.raise( p_event_name => l_event_name
310: ,p_event_key => l_key

Line 309: wf_event.raise( p_event_name => l_event_name

305: --added by akrangan
306: wf_event.AddParameterToList('ORG_ID',p_org_id ,l_parameter_list);
307: -- Raise Event
308: -- It is overloaded function so use according to requirement
309: wf_event.raise( p_event_name => l_event_name
310: ,p_event_key => l_key
311: ,p_parameters => l_parameter_list);
312: l_parameter_list.DELETE;
313: