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 138: wf_event.AddParameterToList('TRANSACTION_ID',p_transaction_id,l_parameter_list);

134: CLOSE okl_key_csr;
135:
136: l_key := p_event_name ||l_seq ;
137:
138: wf_event.AddParameterToList('TRANSACTION_ID',p_transaction_id,l_parameter_list);
139: --added by akrangan as part of MOAC changes
140: if p_event_name in ('oracle.apps.okl.am.approveassetrepair',
141: 'oracle.apps.okl.am.acceptrestquote',
142: 'oracle.apps.okl.am.preproceeds',

Line 166: wf_event.AddParameterToList('ORG_ID',l_org_id ,l_parameter_list);

162: OPEN c_get_org_id(p_transaction_id);
163: FETCH c_get_org_id INTO l_org_id;
164: CLOSE c_get_org_id;
165: END IF;
166: wf_event.AddParameterToList('ORG_ID',l_org_id ,l_parameter_list);
167: --added by akrangan
168: -- wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
169: end if ;
170:

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

164: CLOSE c_get_org_id;
165: END IF;
166: wf_event.AddParameterToList('ORG_ID',l_org_id ,l_parameter_list);
167: --added by akrangan
168: -- wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
169: end if ;
170:
171: -- 20-OCT-10 sechawla 10194171 : begin
172: -- Set the workflow attributes (user_id/responsibility_id/appl_id) to the current user_id/responsibility_id/appl_id

Line 184: wf_event.AddParameterToList('USER_ID',Fnd_Global.User_Id,l_parameter_list);

180: -- rmunjulu added oracle.apps.okl.cs.transferandassumption for bug 11717591
181: if p_event_name in ( 'oracle.apps.okl.am.preproceeds',
182: 'oracle.apps.okl.am.postproceeds',
183: 'oracle.apps.okl.cs.transferandassumption') then
184: wf_event.AddParameterToList('USER_ID',Fnd_Global.User_Id,l_parameter_list);
185: wf_event.AddParameterToList('RESPONSIBILITY_ID',Fnd_Global.Resp_Id,l_parameter_list);
186: wf_event.AddParameterToList('APPL_ID',Fnd_Global.Resp_Appl_Id,l_parameter_list);
187:
188: IF (is_debug_procedure_on) THEN

Line 185: wf_event.AddParameterToList('RESPONSIBILITY_ID',Fnd_Global.Resp_Id,l_parameter_list);

181: if p_event_name in ( 'oracle.apps.okl.am.preproceeds',
182: 'oracle.apps.okl.am.postproceeds',
183: 'oracle.apps.okl.cs.transferandassumption') then
184: wf_event.AddParameterToList('USER_ID',Fnd_Global.User_Id,l_parameter_list);
185: wf_event.AddParameterToList('RESPONSIBILITY_ID',Fnd_Global.Resp_Id,l_parameter_list);
186: wf_event.AddParameterToList('APPL_ID',Fnd_Global.Resp_Appl_Id,l_parameter_list);
187:
188: IF (is_debug_procedure_on) THEN
189: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'raise BE : USER_ID '||Fnd_Global.User_Id);

Line 186: wf_event.AddParameterToList('APPL_ID',Fnd_Global.Resp_Appl_Id,l_parameter_list);

182: 'oracle.apps.okl.am.postproceeds',
183: 'oracle.apps.okl.cs.transferandassumption') then
184: wf_event.AddParameterToList('USER_ID',Fnd_Global.User_Id,l_parameter_list);
185: wf_event.AddParameterToList('RESPONSIBILITY_ID',Fnd_Global.Resp_Id,l_parameter_list);
186: wf_event.AddParameterToList('APPL_ID',Fnd_Global.Resp_Appl_Id,l_parameter_list);
187:
188: IF (is_debug_procedure_on) THEN
189: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'raise BE : USER_ID '||Fnd_Global.User_Id);
190: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'raise BE : RESPONSIBILITY_ID '||Fnd_Global.Resp_Id);

Line 198: wf_event.AddParameterToList('USER_ID',Fnd_Global.User_Id,l_parameter_list);

194:
195: --vsgandhi
196: if p_event_name in ( 'oracle.apps.okl.am.sendquote' ,
197: 'oracle.apps.okl.am.submitquoteforapproval') then
198: wf_event.AddParameterToList('USER_ID',Fnd_Global.User_Id,l_parameter_list);
199: wf_event.AddParameterToList('RESPONSIBILITY_ID',Fnd_Global.Resp_Id,l_parameter_list);
200: wf_event.AddParameterToList('APPLICATION_ID',Fnd_Global.Resp_Appl_Id,l_parameter_list);
201:
202: IF (is_debug_procedure_on) THEN

Line 199: wf_event.AddParameterToList('RESPONSIBILITY_ID',Fnd_Global.Resp_Id,l_parameter_list);

195: --vsgandhi
196: if p_event_name in ( 'oracle.apps.okl.am.sendquote' ,
197: 'oracle.apps.okl.am.submitquoteforapproval') then
198: wf_event.AddParameterToList('USER_ID',Fnd_Global.User_Id,l_parameter_list);
199: wf_event.AddParameterToList('RESPONSIBILITY_ID',Fnd_Global.Resp_Id,l_parameter_list);
200: wf_event.AddParameterToList('APPLICATION_ID',Fnd_Global.Resp_Appl_Id,l_parameter_list);
201:
202: IF (is_debug_procedure_on) THEN
203: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,' USER_ID

Line 200: wf_event.AddParameterToList('APPLICATION_ID',Fnd_Global.Resp_Appl_Id,l_parameter_list);

196: if p_event_name in ( 'oracle.apps.okl.am.sendquote' ,
197: 'oracle.apps.okl.am.submitquoteforapproval') then
198: wf_event.AddParameterToList('USER_ID',Fnd_Global.User_Id,l_parameter_list);
199: wf_event.AddParameterToList('RESPONSIBILITY_ID',Fnd_Global.Resp_Id,l_parameter_list);
200: wf_event.AddParameterToList('APPLICATION_ID',Fnd_Global.Resp_Appl_Id,l_parameter_list);
201:
202: IF (is_debug_procedure_on) THEN
203: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,' USER_ID
204: '||Fnd_Global.User_Id);

Line 215: wf_event.raise(p_event_name => p_event_name

211: -- 20-OCT-10 sechawla 10194171 : end
212:
213:
214: -- Raise Event
215: wf_event.raise(p_event_name => p_event_name
216: ,p_event_key => l_key
217: ,p_parameters => l_parameter_list);
218: l_parameter_list.DELETE;
219:

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

335: CLOSE okl_key_csr;
336:
337: l_key := l_event_name ||l_seq ;
338:
339: wf_event.AddParameterToList('TRANSACTION_ID',l_transaction_id,l_parameter_list);
340: wf_event.AddParameterToList('PROCESS_CODE',l_process_code,l_parameter_list);
341: wf_event.AddParameterToList('RECIPIENT_TYPE',l_recipient_type,l_parameter_list);
342: wf_event.AddParameterToList('RECIPIENT_ID',l_recipient_id,l_parameter_list);
343: wf_event.AddParameterToList('RECIPIENT_DESCRIPTION',l_recipient_desc,l_parameter_list);

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

336:
337: l_key := l_event_name ||l_seq ;
338:
339: wf_event.AddParameterToList('TRANSACTION_ID',l_transaction_id,l_parameter_list);
340: wf_event.AddParameterToList('PROCESS_CODE',l_process_code,l_parameter_list);
341: wf_event.AddParameterToList('RECIPIENT_TYPE',l_recipient_type,l_parameter_list);
342: wf_event.AddParameterToList('RECIPIENT_ID',l_recipient_id,l_parameter_list);
343: wf_event.AddParameterToList('RECIPIENT_DESCRIPTION',l_recipient_desc,l_parameter_list);
344: wf_event.AddParameterToList('CREATED_BY',l_created_by,l_parameter_list);

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

337: l_key := l_event_name ||l_seq ;
338:
339: wf_event.AddParameterToList('TRANSACTION_ID',l_transaction_id,l_parameter_list);
340: wf_event.AddParameterToList('PROCESS_CODE',l_process_code,l_parameter_list);
341: wf_event.AddParameterToList('RECIPIENT_TYPE',l_recipient_type,l_parameter_list);
342: wf_event.AddParameterToList('RECIPIENT_ID',l_recipient_id,l_parameter_list);
343: wf_event.AddParameterToList('RECIPIENT_DESCRIPTION',l_recipient_desc,l_parameter_list);
344: wf_event.AddParameterToList('CREATED_BY',l_created_by,l_parameter_list);
345: -- wf_event.AddParameterToList('EXPAND_ROLES',l_expand_roles,l_parameter_list);

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

338:
339: wf_event.AddParameterToList('TRANSACTION_ID',l_transaction_id,l_parameter_list);
340: wf_event.AddParameterToList('PROCESS_CODE',l_process_code,l_parameter_list);
341: wf_event.AddParameterToList('RECIPIENT_TYPE',l_recipient_type,l_parameter_list);
342: wf_event.AddParameterToList('RECIPIENT_ID',l_recipient_id,l_parameter_list);
343: wf_event.AddParameterToList('RECIPIENT_DESCRIPTION',l_recipient_desc,l_parameter_list);
344: wf_event.AddParameterToList('CREATED_BY',l_created_by,l_parameter_list);
345: -- wf_event.AddParameterToList('EXPAND_ROLES',l_expand_roles,l_parameter_list);
346: wf_event.AddParameterToList('EMAIL_ADDRESS',l_email_address,l_parameter_list);

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

339: wf_event.AddParameterToList('TRANSACTION_ID',l_transaction_id,l_parameter_list);
340: wf_event.AddParameterToList('PROCESS_CODE',l_process_code,l_parameter_list);
341: wf_event.AddParameterToList('RECIPIENT_TYPE',l_recipient_type,l_parameter_list);
342: wf_event.AddParameterToList('RECIPIENT_ID',l_recipient_id,l_parameter_list);
343: wf_event.AddParameterToList('RECIPIENT_DESCRIPTION',l_recipient_desc,l_parameter_list);
344: wf_event.AddParameterToList('CREATED_BY',l_created_by,l_parameter_list);
345: -- wf_event.AddParameterToList('EXPAND_ROLES',l_expand_roles,l_parameter_list);
346: wf_event.AddParameterToList('EMAIL_ADDRESS',l_email_address,l_parameter_list);
347: --19-jul-2007 ansethur R12B XML Publisher Starts

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

340: wf_event.AddParameterToList('PROCESS_CODE',l_process_code,l_parameter_list);
341: wf_event.AddParameterToList('RECIPIENT_TYPE',l_recipient_type,l_parameter_list);
342: wf_event.AddParameterToList('RECIPIENT_ID',l_recipient_id,l_parameter_list);
343: wf_event.AddParameterToList('RECIPIENT_DESCRIPTION',l_recipient_desc,l_parameter_list);
344: wf_event.AddParameterToList('CREATED_BY',l_created_by,l_parameter_list);
345: -- wf_event.AddParameterToList('EXPAND_ROLES',l_expand_roles,l_parameter_list);
346: wf_event.AddParameterToList('EMAIL_ADDRESS',l_email_address,l_parameter_list);
347: --19-jul-2007 ansethur R12B XML Publisher Starts
348: wf_event.AddParameterToList('BATCH_ID',l_batch_id,l_parameter_list);

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

341: wf_event.AddParameterToList('RECIPIENT_TYPE',l_recipient_type,l_parameter_list);
342: wf_event.AddParameterToList('RECIPIENT_ID',l_recipient_id,l_parameter_list);
343: wf_event.AddParameterToList('RECIPIENT_DESCRIPTION',l_recipient_desc,l_parameter_list);
344: wf_event.AddParameterToList('CREATED_BY',l_created_by,l_parameter_list);
345: -- wf_event.AddParameterToList('EXPAND_ROLES',l_expand_roles,l_parameter_list);
346: wf_event.AddParameterToList('EMAIL_ADDRESS',l_email_address,l_parameter_list);
347: --19-jul-2007 ansethur R12B XML Publisher Starts
348: wf_event.AddParameterToList('BATCH_ID',l_batch_id,l_parameter_list);
349: wf_event.AddParameterToList('FROM_ADDRESS',l_from_address,l_parameter_list);

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

342: wf_event.AddParameterToList('RECIPIENT_ID',l_recipient_id,l_parameter_list);
343: wf_event.AddParameterToList('RECIPIENT_DESCRIPTION',l_recipient_desc,l_parameter_list);
344: wf_event.AddParameterToList('CREATED_BY',l_created_by,l_parameter_list);
345: -- wf_event.AddParameterToList('EXPAND_ROLES',l_expand_roles,l_parameter_list);
346: wf_event.AddParameterToList('EMAIL_ADDRESS',l_email_address,l_parameter_list);
347: --19-jul-2007 ansethur R12B XML Publisher Starts
348: wf_event.AddParameterToList('BATCH_ID',l_batch_id,l_parameter_list);
349: wf_event.AddParameterToList('FROM_ADDRESS',l_from_address,l_parameter_list);
350: --19-jul-2007 ansethur R12B XML Publisher Ends

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

344: wf_event.AddParameterToList('CREATED_BY',l_created_by,l_parameter_list);
345: -- wf_event.AddParameterToList('EXPAND_ROLES',l_expand_roles,l_parameter_list);
346: wf_event.AddParameterToList('EMAIL_ADDRESS',l_email_address,l_parameter_list);
347: --19-jul-2007 ansethur R12B XML Publisher Starts
348: wf_event.AddParameterToList('BATCH_ID',l_batch_id,l_parameter_list);
349: wf_event.AddParameterToList('FROM_ADDRESS',l_from_address,l_parameter_list);
350: --19-jul-2007 ansethur R12B XML Publisher Ends
351: --added by akrangan
352: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);

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

345: -- wf_event.AddParameterToList('EXPAND_ROLES',l_expand_roles,l_parameter_list);
346: wf_event.AddParameterToList('EMAIL_ADDRESS',l_email_address,l_parameter_list);
347: --19-jul-2007 ansethur R12B XML Publisher Starts
348: wf_event.AddParameterToList('BATCH_ID',l_batch_id,l_parameter_list);
349: wf_event.AddParameterToList('FROM_ADDRESS',l_from_address,l_parameter_list);
350: --19-jul-2007 ansethur R12B XML Publisher Ends
351: --added by akrangan
352: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
353:

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

348: wf_event.AddParameterToList('BATCH_ID',l_batch_id,l_parameter_list);
349: wf_event.AddParameterToList('FROM_ADDRESS',l_from_address,l_parameter_list);
350: --19-jul-2007 ansethur R12B XML Publisher Ends
351: --added by akrangan
352: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
353:
354:
355: -- Raise Event
356: wf_event.raise(p_event_name => l_event_name

Line 356: wf_event.raise(p_event_name => l_event_name

352: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
353:
354:
355: -- Raise Event
356: wf_event.raise(p_event_name => l_event_name
357: ,p_event_key => l_key
358: ,p_parameters => l_parameter_list);
359: l_parameter_list.DELETE;
360: