DBA Data[Home] [Help]

APPS.OKL_VP_OA_WF dependencies on WF_EVENT

Line 7: G_OPERATING_AGRMNT_EVENT CONSTANT wf_events.name%TYPE DEFAULT 'oracle.apps.okl.la.vp.approve_operating_agreement';

3:
4: G_NO_MATCHING_RECORD CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_LLA_NO_MATCHING_RECORD';
5: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
6:
7: G_OPERATING_AGRMNT_EVENT CONSTANT wf_events.name%TYPE DEFAULT 'oracle.apps.okl.la.vp.approve_operating_agreement';
8:
9: G_AGRMNT_APPROVAL_WF CONSTANT VARCHAR2(2) DEFAULT 'WF';
10: G_AGRMNT_APPROVAL_AME CONSTANT VARCHAR2(3) DEFAULT 'AME';
11:

Line 317: wf_event.AddParameterToList(G_WF_ITM_APPLICATION_ID,l_application_id,l_parameter_list);

313: RAISE OKL_API.G_EXCEPTION_ERROR;
314: END IF;
315: CLOSE c_get_trx_type_csr;
316: IF(l_application_id = l_trans_appl_id)THEN
317: wf_event.AddParameterToList(G_WF_ITM_APPLICATION_ID,l_application_id,l_parameter_list);
318: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_TYPE_ID,l_trans_type_id,l_parameter_list);
319: END IF;
320: ELSIF(NVL(l_approval_process,'NONE') = G_AGRMNT_APPROVAL_WF)THEN
321: -- log here. no action required. for common event parameters, see below

Line 318: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_TYPE_ID,l_trans_type_id,l_parameter_list);

314: END IF;
315: CLOSE c_get_trx_type_csr;
316: IF(l_application_id = l_trans_appl_id)THEN
317: wf_event.AddParameterToList(G_WF_ITM_APPLICATION_ID,l_application_id,l_parameter_list);
318: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_TYPE_ID,l_trans_type_id,l_parameter_list);
319: END IF;
320: ELSIF(NVL(l_approval_process,'NONE') = G_AGRMNT_APPROVAL_WF)THEN
321: -- log here. no action required. for common event parameters, see below
322: -- write to log

Line 337: wf_event.AddParameterToList(G_WF_ITM_AGREEMENT_ID, cv_get_oa_num.id, l_parameter_list);

333: OPEN c_get_oa_num_csr(p_chr_id); FETCH c_get_oa_num_csr INTO cv_get_oa_num;
334: CLOSE c_get_oa_num_csr;
335:
336: -- get the agreement information to put as event parameters and raise the event
337: wf_event.AddParameterToList(G_WF_ITM_AGREEMENT_ID, cv_get_oa_num.id, l_parameter_list);
338: wf_event.AddParameterToList(G_WF_ITM_AGREEMENT_NUMBER, cv_get_oa_num.contract_number, l_parameter_list);
339:
340: wf_event.AddParameterToList(G_WF_ITM_REQUESTER, l_requester, l_parameter_list);
341: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,fnd_global.user_id,l_parameter_list);

Line 338: wf_event.AddParameterToList(G_WF_ITM_AGREEMENT_NUMBER, cv_get_oa_num.contract_number, l_parameter_list);

334: CLOSE c_get_oa_num_csr;
335:
336: -- get the agreement information to put as event parameters and raise the event
337: wf_event.AddParameterToList(G_WF_ITM_AGREEMENT_ID, cv_get_oa_num.id, l_parameter_list);
338: wf_event.AddParameterToList(G_WF_ITM_AGREEMENT_NUMBER, cv_get_oa_num.contract_number, l_parameter_list);
339:
340: wf_event.AddParameterToList(G_WF_ITM_REQUESTER, l_requester, l_parameter_list);
341: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,fnd_global.user_id,l_parameter_list);
342:

Line 340: wf_event.AddParameterToList(G_WF_ITM_REQUESTER, l_requester, l_parameter_list);

336: -- get the agreement information to put as event parameters and raise the event
337: wf_event.AddParameterToList(G_WF_ITM_AGREEMENT_ID, cv_get_oa_num.id, l_parameter_list);
338: wf_event.AddParameterToList(G_WF_ITM_AGREEMENT_NUMBER, cv_get_oa_num.contract_number, l_parameter_list);
339:
340: wf_event.AddParameterToList(G_WF_ITM_REQUESTER, l_requester, l_parameter_list);
341: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,fnd_global.user_id,l_parameter_list);
342:
343: -- transaction id is the contract id (okc_k_headers_b.id) this parameter is required to write custom queries in AME
344: -- and use them in conditions and rules

Line 341: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,fnd_global.user_id,l_parameter_list);

337: wf_event.AddParameterToList(G_WF_ITM_AGREEMENT_ID, cv_get_oa_num.id, l_parameter_list);
338: wf_event.AddParameterToList(G_WF_ITM_AGREEMENT_NUMBER, cv_get_oa_num.contract_number, l_parameter_list);
339:
340: wf_event.AddParameterToList(G_WF_ITM_REQUESTER, l_requester, l_parameter_list);
341: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,fnd_global.user_id,l_parameter_list);
342:
343: -- transaction id is the contract id (okc_k_headers_b.id) this parameter is required to write custom queries in AME
344: -- and use them in conditions and rules
345: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,cv_get_oa_num.id,l_parameter_list);

Line 345: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,cv_get_oa_num.id,l_parameter_list);

341: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,fnd_global.user_id,l_parameter_list);
342:
343: -- transaction id is the contract id (okc_k_headers_b.id) this parameter is required to write custom queries in AME
344: -- and use them in conditions and rules
345: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,cv_get_oa_num.id,l_parameter_list);
346: --added by akrangan
347: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
348:
349: lv_wf_item_key := get_item_key_wf;

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

343: -- transaction id is the contract id (okc_k_headers_b.id) this parameter is required to write custom queries in AME
344: -- and use them in conditions and rules
345: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,cv_get_oa_num.id,l_parameter_list);
346: --added by akrangan
347: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
348:
349: lv_wf_item_key := get_item_key_wf;
350: -- Raise Event
351: wf_event.RAISE(p_event_name => G_OPERATING_AGRMNT_EVENT,

Line 351: wf_event.RAISE(p_event_name => G_OPERATING_AGRMNT_EVENT,

347: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
348:
349: lv_wf_item_key := get_item_key_wf;
350: -- Raise Event
351: wf_event.RAISE(p_event_name => G_OPERATING_AGRMNT_EVENT,
352: p_event_key => lv_wf_item_key,
353: p_parameters => l_parameter_list);
354:
355: l_parameter_list.DELETE;