eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_VP_CR_WF dependencies on WF_EVENT

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

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

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

371: RAISE OKL_API.G_EXCEPTION_ERROR;
372: END IF;
373: CLOSE c_get_trx_type_csr;
374: IF(l_application_id = l_trans_appl_id)THEN
375: wf_event.AddParameterToList(G_WF_ITM_APPLICATION_ID,l_application_id,l_parameter_list);
376: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_TYPE_ID,l_trans_type_id,l_parameter_list);
377: END IF;
378: ELSIF(NVL(l_approval_process,'NONE') = G_AGRMNT_APPROVAL_WF)THEN
379: -- log here. no action required. for common event parameters, see below

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

372: END IF;
373: CLOSE c_get_trx_type_csr;
374: IF(l_application_id = l_trans_appl_id)THEN
375: wf_event.AddParameterToList(G_WF_ITM_APPLICATION_ID,l_application_id,l_parameter_list);
376: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_TYPE_ID,l_trans_type_id,l_parameter_list);
377: END IF;
378: ELSIF(NVL(l_approval_process,'NONE') = G_AGRMNT_APPROVAL_WF)THEN
379: -- log here. no action required. for common event parameters, see below
380: -- write to log

Line 395: wf_event.AddParameterToList(G_WF_ITM_CHANGE_REQUEST_ID, cv_get_cr_num.id, l_parameter_list);

391: OPEN c_get_cr_num_csr(p_vp_crq_id); FETCH c_get_cr_num_csr INTO cv_get_cr_num;
392: CLOSE c_get_cr_num_csr;
393:
394: -- get the agreement information to put as event parameters and raise the event
395: wf_event.AddParameterToList(G_WF_ITM_CHANGE_REQUEST_ID, cv_get_cr_num.id, l_parameter_list);
396: wf_event.AddParameterToList(G_WF_ITM_CHANGE_REQUEST_NUM, cv_get_cr_num.change_request_number, l_parameter_list);
397:
398: wf_event.AddParameterToList(G_WF_ITM_REQUESTER, l_requester, l_parameter_list);
399: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,fnd_global.user_id,l_parameter_list);

Line 396: wf_event.AddParameterToList(G_WF_ITM_CHANGE_REQUEST_NUM, cv_get_cr_num.change_request_number, l_parameter_list);

392: CLOSE c_get_cr_num_csr;
393:
394: -- get the agreement information to put as event parameters and raise the event
395: wf_event.AddParameterToList(G_WF_ITM_CHANGE_REQUEST_ID, cv_get_cr_num.id, l_parameter_list);
396: wf_event.AddParameterToList(G_WF_ITM_CHANGE_REQUEST_NUM, cv_get_cr_num.change_request_number, l_parameter_list);
397:
398: wf_event.AddParameterToList(G_WF_ITM_REQUESTER, l_requester, l_parameter_list);
399: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,fnd_global.user_id,l_parameter_list);
400:

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

394: -- get the agreement information to put as event parameters and raise the event
395: wf_event.AddParameterToList(G_WF_ITM_CHANGE_REQUEST_ID, cv_get_cr_num.id, l_parameter_list);
396: wf_event.AddParameterToList(G_WF_ITM_CHANGE_REQUEST_NUM, cv_get_cr_num.change_request_number, l_parameter_list);
397:
398: wf_event.AddParameterToList(G_WF_ITM_REQUESTER, l_requester, l_parameter_list);
399: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,fnd_global.user_id,l_parameter_list);
400:
401: -- transaction id is the contract id (okc_k_headers_b.id) this parameter is required to write custom queries in AME
402: -- and use them in conditions and rules

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

395: wf_event.AddParameterToList(G_WF_ITM_CHANGE_REQUEST_ID, cv_get_cr_num.id, l_parameter_list);
396: wf_event.AddParameterToList(G_WF_ITM_CHANGE_REQUEST_NUM, cv_get_cr_num.change_request_number, l_parameter_list);
397:
398: wf_event.AddParameterToList(G_WF_ITM_REQUESTER, l_requester, l_parameter_list);
399: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,fnd_global.user_id,l_parameter_list);
400:
401: -- transaction id is the contract id (okc_k_headers_b.id) this parameter is required to write custom queries in AME
402: -- and use them in conditions and rules
403: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,cv_get_cr_num.id,l_parameter_list);

Line 403: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,cv_get_cr_num.id,l_parameter_list);

399: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,fnd_global.user_id,l_parameter_list);
400:
401: -- transaction id is the contract id (okc_k_headers_b.id) this parameter is required to write custom queries in AME
402: -- and use them in conditions and rules
403: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,cv_get_cr_num.id,l_parameter_list);
404: --added by akrangan
405: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
406: lv_wf_item_key := get_item_key_wf;
407: -- Raise Event

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

401: -- transaction id is the contract id (okc_k_headers_b.id) this parameter is required to write custom queries in AME
402: -- and use them in conditions and rules
403: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,cv_get_cr_num.id,l_parameter_list);
404: --added by akrangan
405: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
406: lv_wf_item_key := get_item_key_wf;
407: -- Raise Event
408: wf_event.RAISE(p_event_name => G_CHANGE_REQUEST_APP_EVENT,
409: p_event_key => lv_wf_item_key,

Line 408: wf_event.RAISE(p_event_name => G_CHANGE_REQUEST_APP_EVENT,

404: --added by akrangan
405: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
406: lv_wf_item_key := get_item_key_wf;
407: -- Raise Event
408: wf_event.RAISE(p_event_name => G_CHANGE_REQUEST_APP_EVENT,
409: p_event_key => lv_wf_item_key,
410: p_parameters => l_parameter_list);
411:
412: l_parameter_list.DELETE;