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_PA_WF dependencies on WF_ENGINE

Line 112: lv_agreement_number := wf_engine.GetItemAttrText(itemtype => itemtype,

108: lv_agreement_number okc_k_headers_b.contract_number%TYPE;
109: BEGIN
110: -- construct message text for the purpose of subject line of the notification,
111: -- the token is set to AGR_NUMBER for both operating agreement and program agreement
112: lv_agreement_number := wf_engine.GetItemAttrText(itemtype => itemtype,
113: itemkey => itemkey,
114: aname => G_WF_ITM_AGREEMENT_NUMBER);
115:
116: fnd_message.set_name(G_APP_NAME,message);

Line 119: wf_engine.SetItemAttrText(itemtype => itemtype,

115:
116: fnd_message.set_name(G_APP_NAME,message);
117: fnd_message.set_token('AGR_NUMBER', lv_agreement_number);
118:
119: wf_engine.SetItemAttrText(itemtype => itemtype,
120: itemkey => itemkey,
121: aname => attrib,
122: avalue => fnd_message.get
123: );

Line 202: lv_agreement_id := wf_engine.GetItemAttrText(itemtype => G_ITEM_TYPE_WF

198: document IN OUT nocopy VARCHAR2,
199: document_type IN OUT nocopy VARCHAR2) IS
200: lv_agreement_id okc_k_headers_b.id%TYPE;
201: BEGIN
202: lv_agreement_id := wf_engine.GetItemAttrText(itemtype => G_ITEM_TYPE_WF
203: ,itemkey => document_id
204: ,aname => G_WF_ITM_AGREEMENT_ID);
205: document := compile_message_body(lv_agreement_id);
206: document_type := display_type;

Line 458: l_user_id := wf_engine.GetItemAttrText(itemtype => itemtype,

454: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug call get_agrmnt_approver');
455: END IF;
456:
457: IF(funcmode = 'RUN')THEN
458: l_user_id := wf_engine.GetItemAttrText(itemtype => itemtype,
459: itemkey => itemkey,
460: aname => G_WF_ITM_REQUESTER_ID);
461:
462: resultout := 'COMPLETE:N'; -- default

Line 465: wf_engine.SetItemAttrText (itemtype => itemtype,

461:
462: resultout := 'COMPLETE:N'; -- default
463: IF l_user_id IS NOT NULL THEN
464: FOR l_fnd_users_rec IN l_fnd_users_csr(l_user_id) LOOP
465: wf_engine.SetItemAttrText (itemtype => itemtype,
466: itemkey => itemkey,
467: aname => G_WF_ITM_APPROVER,
468: avalue => l_fnd_users_rec.user_name);
469:

Line 473: wf_engine.SetItemAttrText (itemtype => itemtype,

469:
470: -- Message: "Program Agreement requires approval"
471: set_attrib_message(itemtype, itemkey, 'OKL_VN_PA_REQ_APPROVAL_SUB', G_WF_ITM_MESSAGE_SUBJECT);
472:
473: wf_engine.SetItemAttrText (itemtype => itemtype,
474: itemkey => itemkey,
475: aname => G_WF_ITM_MESSAGE_BODY,
476: avalue => 'plsql:okl_vp_pa_wf.get_msg_doc/'||itemkey
477: );

Line 522: lv_approval_status := wf_engine.GetItemAttrText(itemtype => itemtype,

518: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug update_agrmnt_status');
519: END IF;
520:
521: IF(funcmode = 'RUN')THEN
522: lv_approval_status := wf_engine.GetItemAttrText(itemtype => itemtype,
523: itemkey => itemkey,
524: aname => G_WF_ITM_RESULT);
525:
526: lv_approval_status_ame := wf_engine.GetItemAttrText(itemtype => itemtype,

Line 526: lv_approval_status_ame := wf_engine.GetItemAttrText(itemtype => itemtype,

522: lv_approval_status := wf_engine.GetItemAttrText(itemtype => itemtype,
523: itemkey => itemkey,
524: aname => G_WF_ITM_RESULT);
525:
526: lv_approval_status_ame := wf_engine.GetItemAttrText(itemtype => itemtype,
527: itemkey => itemkey,
528: aname => 'APPROVED_YN');
529: lv_agreement_id := wf_engine.GetItemAttrText(itemtype => itemtype,
530: itemkey => itemkey,

Line 529: lv_agreement_id := wf_engine.GetItemAttrText(itemtype => itemtype,

525:
526: lv_approval_status_ame := wf_engine.GetItemAttrText(itemtype => itemtype,
527: itemkey => itemkey,
528: aname => 'APPROVED_YN');
529: lv_agreement_id := wf_engine.GetItemAttrText(itemtype => itemtype,
530: itemkey => itemkey,
531: aname => G_WF_ITM_AGREEMENT_ID);
532:
533: IF(G_WF_ITM_APPROVED_YN_YES = lv_approval_status OR lv_approval_status_ame = 'Y')THEN

Line 609: lv_agreement_id := wf_engine.GetItemAttrText(itemtype => itemtype

605: l_debug_enabled VARCHAR2(10);
606: lv_agreement_id okc_k_headers_b.id%TYPE;
607: BEGIN
608: IF(funcmode = 'RUN')THEN
609: lv_agreement_id := wf_engine.GetItemAttrText(itemtype => itemtype
610: ,itemkey => itemkey
611: ,aname => G_WF_ITM_AGREEMENT_ID);
612:
613: set_attrib_message(itemtype, itemkey, 'OKL_VN_PA_REQ_APPROVAL_SUB', G_WF_ITM_APP_REQUEST_SUB);

Line 621: wf_engine.SetItemAttrText (itemtype => itemtype

617: set_attrib_message(itemtype, itemkey, 'OKL_VN_PA_REQ_APPROVED_SUB', G_WF_ITM_APP_APPROVED_HEAD);
618: set_attrib_message(itemtype, itemkey, 'OKL_VN_PA_REQ_REJECT_SUB', G_WF_ITM_APP_REJECTED_SUB);
619: set_attrib_message(itemtype, itemkey, 'OKL_VN_PA_REQ_REJECT_SUB', G_WF_ITM_APP_REJECTED_HEAD);
620:
621: wf_engine.SetItemAttrText (itemtype => itemtype
622: ,itemkey => itemkey
623: ,aname => G_WF_ITM_MESSAGE_DESCR
624: ,avalue => compile_message_body(lv_agreement_id)
625: );

Line 656: lv_approval_status := wf_engine.GetItemAttrText(itemtype => itemtype

652: l_api_name CONSTANT VARCHAR2(200) DEFAULT 'set_msg_attributes';
653: BEGIN
654: -- RUN mode
655: IF(funcmode = 'RUN')THEN
656: lv_approval_status := wf_engine.GetItemAttrText(itemtype => itemtype
657: ,itemkey => itemkey
658: ,aname => G_WF_ITM_RESULT);
659: IF(G_WF_ITM_APPROVED_YN_YES = lv_approval_status)THEN
660: set_attrib_message(itemtype, itemkey, 'OKL_VN_PA_REQ_APPROVED_SUB', G_WF_ITM_MESSAGE_SUBJECT);

Line 664: wf_engine.SetItemAttrText (itemtype => itemtype,

660: set_attrib_message(itemtype, itemkey, 'OKL_VN_PA_REQ_APPROVED_SUB', G_WF_ITM_MESSAGE_SUBJECT);
661: ELSIF(G_WF_ITM_APPROVED_YN_NO = lv_approval_status)THEN
662: set_attrib_message(itemtype, itemkey, 'OKL_VN_PA_REQ_REJECT_SUB', G_WF_ITM_MESSAGE_SUBJECT);
663: END IF;
664: wf_engine.SetItemAttrText (itemtype => itemtype,
665: itemkey => itemkey,
666: aname => G_WF_ITM_MESSAGE_BODY,
667: avalue => 'plsql:okl_vp_pa_wf.get_msg_doc/'||itemkey
668: );