DBA Data[Home] [Help]

APPS.OKL_VP_PA_WF dependencies on WF_EVENT

Line 7: G_PROGRAM_AGRMNT_EVENT CONSTANT wf_events.name%TYPE DEFAULT 'oracle.apps.okl.la.vp.approve_program_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_PROGRAM_AGRMNT_EVENT CONSTANT wf_events.name%TYPE DEFAULT 'oracle.apps.okl.la.vp.approve_program_agreement';
8:
9: G_AGRMNT_APPROVAL_WF CONSTANT VARCHAR2(2) DEFAULT 'WF';
10: G_AGRMNT_APPROVAL_AME CONSTANT VARCHAR2(3) DEFAULT 'AME';
11:

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

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

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

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

Line 339: wf_event.AddParameterToList(G_WF_ITM_AGREEMENT_ID, cv_get_pa_num.id, l_parameter_list);

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

Line 340: wf_event.AddParameterToList(G_WF_ITM_AGREEMENT_NUMBER, cv_get_pa_num.contract_number, l_parameter_list);

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

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

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

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

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

Line 347: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,cv_get_pa_num.id,l_parameter_list);

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

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

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

Line 353: wf_event.RAISE(p_event_name => G_PROGRAM_AGRMNT_EVENT,

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