DBA Data[Home] [Help]

APPS.OKL_AM_WF dependencies on WF_EVENT

Line 31: FROM WF_EVENTS WFEV,

27: CURSOR c_get_wf_details_csr (c_event_name VARCHAR2)
28: IS
29: SELECT IT.display_name
30: , RP.display_name
31: FROM WF_EVENTS WFEV,
32: WF_EVENT_SUBSCRIPTIONS WFES,
33: wf_runnable_processes_v RP,
34: wf_item_types_vl IT
35: WHERE WFEV.guid = WFES.event_filter_guid

Line 32: WF_EVENT_SUBSCRIPTIONS WFES,

28: IS
29: SELECT IT.display_name
30: , RP.display_name
31: FROM WF_EVENTS WFEV,
32: WF_EVENT_SUBSCRIPTIONS WFES,
33: wf_runnable_processes_v RP,
34: wf_item_types_vl IT
35: WHERE WFEV.guid = WFES.event_filter_guid
36: AND WFES.WF_PROCESS_TYPE = RP.ITEM_TYPE

Line 124: wf_event.AddParameterToList('TRANSACTION_ID',p_transaction_id,l_parameter_list);

120: CLOSE okl_key_csr;
121:
122: l_key := p_event_name ||l_seq ;
123:
124: wf_event.AddParameterToList('TRANSACTION_ID',p_transaction_id,l_parameter_list);
125: --added by akrangan as part of MOAC changes
126: if p_event_name in ('oracle.apps.okl.am.approveassetrepair',
127: 'oracle.apps.okl.am.acceptrestquote',
128: 'oracle.apps.okl.am.preproceeds',

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

140: 'oracle.apps.okl.am.sendquote'
141: )
142: then
143: --added by akrangan
144: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
145: end if ;
146: -- Raise Event
147: wf_event.raise(p_event_name => p_event_name
148: ,p_event_key => l_key

Line 147: wf_event.raise(p_event_name => p_event_name

143: --added by akrangan
144: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
145: end if ;
146: -- Raise Event
147: wf_event.raise(p_event_name => p_event_name
148: ,p_event_key => l_key
149: ,p_parameters => l_parameter_list);
150: l_parameter_list.DELETE;
151:

Line 271: wf_event.AddParameterToList('TRANSACTION_ID',l_transaction_id,l_parameter_list);

267: CLOSE okl_key_csr;
268:
269: l_key := l_event_name ||l_seq ;
270:
271: wf_event.AddParameterToList('TRANSACTION_ID',l_transaction_id,l_parameter_list);
272: wf_event.AddParameterToList('PROCESS_CODE',l_process_code,l_parameter_list);
273: wf_event.AddParameterToList('RECIPIENT_TYPE',l_recipient_type,l_parameter_list);
274: wf_event.AddParameterToList('RECIPIENT_ID',l_recipient_id,l_parameter_list);
275: wf_event.AddParameterToList('RECIPIENT_DESCRIPTION',l_recipient_desc,l_parameter_list);

Line 272: wf_event.AddParameterToList('PROCESS_CODE',l_process_code,l_parameter_list);

268:
269: l_key := l_event_name ||l_seq ;
270:
271: wf_event.AddParameterToList('TRANSACTION_ID',l_transaction_id,l_parameter_list);
272: wf_event.AddParameterToList('PROCESS_CODE',l_process_code,l_parameter_list);
273: wf_event.AddParameterToList('RECIPIENT_TYPE',l_recipient_type,l_parameter_list);
274: wf_event.AddParameterToList('RECIPIENT_ID',l_recipient_id,l_parameter_list);
275: wf_event.AddParameterToList('RECIPIENT_DESCRIPTION',l_recipient_desc,l_parameter_list);
276: wf_event.AddParameterToList('CREATED_BY',l_created_by,l_parameter_list);

Line 273: wf_event.AddParameterToList('RECIPIENT_TYPE',l_recipient_type,l_parameter_list);

269: l_key := l_event_name ||l_seq ;
270:
271: wf_event.AddParameterToList('TRANSACTION_ID',l_transaction_id,l_parameter_list);
272: wf_event.AddParameterToList('PROCESS_CODE',l_process_code,l_parameter_list);
273: wf_event.AddParameterToList('RECIPIENT_TYPE',l_recipient_type,l_parameter_list);
274: wf_event.AddParameterToList('RECIPIENT_ID',l_recipient_id,l_parameter_list);
275: wf_event.AddParameterToList('RECIPIENT_DESCRIPTION',l_recipient_desc,l_parameter_list);
276: wf_event.AddParameterToList('CREATED_BY',l_created_by,l_parameter_list);
277: -- wf_event.AddParameterToList('EXPAND_ROLES',l_expand_roles,l_parameter_list);

Line 274: wf_event.AddParameterToList('RECIPIENT_ID',l_recipient_id,l_parameter_list);

270:
271: wf_event.AddParameterToList('TRANSACTION_ID',l_transaction_id,l_parameter_list);
272: wf_event.AddParameterToList('PROCESS_CODE',l_process_code,l_parameter_list);
273: wf_event.AddParameterToList('RECIPIENT_TYPE',l_recipient_type,l_parameter_list);
274: wf_event.AddParameterToList('RECIPIENT_ID',l_recipient_id,l_parameter_list);
275: wf_event.AddParameterToList('RECIPIENT_DESCRIPTION',l_recipient_desc,l_parameter_list);
276: wf_event.AddParameterToList('CREATED_BY',l_created_by,l_parameter_list);
277: -- wf_event.AddParameterToList('EXPAND_ROLES',l_expand_roles,l_parameter_list);
278: wf_event.AddParameterToList('EMAIL_ADDRESS',l_email_address,l_parameter_list);

Line 275: wf_event.AddParameterToList('RECIPIENT_DESCRIPTION',l_recipient_desc,l_parameter_list);

271: wf_event.AddParameterToList('TRANSACTION_ID',l_transaction_id,l_parameter_list);
272: wf_event.AddParameterToList('PROCESS_CODE',l_process_code,l_parameter_list);
273: wf_event.AddParameterToList('RECIPIENT_TYPE',l_recipient_type,l_parameter_list);
274: wf_event.AddParameterToList('RECIPIENT_ID',l_recipient_id,l_parameter_list);
275: wf_event.AddParameterToList('RECIPIENT_DESCRIPTION',l_recipient_desc,l_parameter_list);
276: wf_event.AddParameterToList('CREATED_BY',l_created_by,l_parameter_list);
277: -- wf_event.AddParameterToList('EXPAND_ROLES',l_expand_roles,l_parameter_list);
278: wf_event.AddParameterToList('EMAIL_ADDRESS',l_email_address,l_parameter_list);
279: --19-jul-2007 ansethur R12B XML Publisher Starts

Line 276: wf_event.AddParameterToList('CREATED_BY',l_created_by,l_parameter_list);

272: wf_event.AddParameterToList('PROCESS_CODE',l_process_code,l_parameter_list);
273: wf_event.AddParameterToList('RECIPIENT_TYPE',l_recipient_type,l_parameter_list);
274: wf_event.AddParameterToList('RECIPIENT_ID',l_recipient_id,l_parameter_list);
275: wf_event.AddParameterToList('RECIPIENT_DESCRIPTION',l_recipient_desc,l_parameter_list);
276: wf_event.AddParameterToList('CREATED_BY',l_created_by,l_parameter_list);
277: -- wf_event.AddParameterToList('EXPAND_ROLES',l_expand_roles,l_parameter_list);
278: wf_event.AddParameterToList('EMAIL_ADDRESS',l_email_address,l_parameter_list);
279: --19-jul-2007 ansethur R12B XML Publisher Starts
280: wf_event.AddParameterToList('BATCH_ID',l_batch_id,l_parameter_list);

Line 277: -- wf_event.AddParameterToList('EXPAND_ROLES',l_expand_roles,l_parameter_list);

273: wf_event.AddParameterToList('RECIPIENT_TYPE',l_recipient_type,l_parameter_list);
274: wf_event.AddParameterToList('RECIPIENT_ID',l_recipient_id,l_parameter_list);
275: wf_event.AddParameterToList('RECIPIENT_DESCRIPTION',l_recipient_desc,l_parameter_list);
276: wf_event.AddParameterToList('CREATED_BY',l_created_by,l_parameter_list);
277: -- wf_event.AddParameterToList('EXPAND_ROLES',l_expand_roles,l_parameter_list);
278: wf_event.AddParameterToList('EMAIL_ADDRESS',l_email_address,l_parameter_list);
279: --19-jul-2007 ansethur R12B XML Publisher Starts
280: wf_event.AddParameterToList('BATCH_ID',l_batch_id,l_parameter_list);
281: wf_event.AddParameterToList('FROM_ADDRESS',l_from_address,l_parameter_list);

Line 278: wf_event.AddParameterToList('EMAIL_ADDRESS',l_email_address,l_parameter_list);

274: wf_event.AddParameterToList('RECIPIENT_ID',l_recipient_id,l_parameter_list);
275: wf_event.AddParameterToList('RECIPIENT_DESCRIPTION',l_recipient_desc,l_parameter_list);
276: wf_event.AddParameterToList('CREATED_BY',l_created_by,l_parameter_list);
277: -- wf_event.AddParameterToList('EXPAND_ROLES',l_expand_roles,l_parameter_list);
278: wf_event.AddParameterToList('EMAIL_ADDRESS',l_email_address,l_parameter_list);
279: --19-jul-2007 ansethur R12B XML Publisher Starts
280: wf_event.AddParameterToList('BATCH_ID',l_batch_id,l_parameter_list);
281: wf_event.AddParameterToList('FROM_ADDRESS',l_from_address,l_parameter_list);
282: --19-jul-2007 ansethur R12B XML Publisher Ends

Line 280: wf_event.AddParameterToList('BATCH_ID',l_batch_id,l_parameter_list);

276: wf_event.AddParameterToList('CREATED_BY',l_created_by,l_parameter_list);
277: -- wf_event.AddParameterToList('EXPAND_ROLES',l_expand_roles,l_parameter_list);
278: wf_event.AddParameterToList('EMAIL_ADDRESS',l_email_address,l_parameter_list);
279: --19-jul-2007 ansethur R12B XML Publisher Starts
280: wf_event.AddParameterToList('BATCH_ID',l_batch_id,l_parameter_list);
281: wf_event.AddParameterToList('FROM_ADDRESS',l_from_address,l_parameter_list);
282: --19-jul-2007 ansethur R12B XML Publisher Ends
283: --added by akrangan
284: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);

Line 281: wf_event.AddParameterToList('FROM_ADDRESS',l_from_address,l_parameter_list);

277: -- wf_event.AddParameterToList('EXPAND_ROLES',l_expand_roles,l_parameter_list);
278: wf_event.AddParameterToList('EMAIL_ADDRESS',l_email_address,l_parameter_list);
279: --19-jul-2007 ansethur R12B XML Publisher Starts
280: wf_event.AddParameterToList('BATCH_ID',l_batch_id,l_parameter_list);
281: wf_event.AddParameterToList('FROM_ADDRESS',l_from_address,l_parameter_list);
282: --19-jul-2007 ansethur R12B XML Publisher Ends
283: --added by akrangan
284: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
285:

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

280: wf_event.AddParameterToList('BATCH_ID',l_batch_id,l_parameter_list);
281: wf_event.AddParameterToList('FROM_ADDRESS',l_from_address,l_parameter_list);
282: --19-jul-2007 ansethur R12B XML Publisher Ends
283: --added by akrangan
284: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
285:
286:
287: -- Raise Event
288: wf_event.raise(p_event_name => l_event_name

Line 288: wf_event.raise(p_event_name => l_event_name

284: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
285:
286:
287: -- Raise Event
288: wf_event.raise(p_event_name => l_event_name
289: ,p_event_key => l_key
290: ,p_parameters => l_parameter_list);
291: l_parameter_list.DELETE;
292: