DBA Data[Home] [Help]

APPS.OKL_VP_OA_WF dependencies on WF_ENGINE

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 620: wf_engine.SetItemAttrText (itemtype => itemtype

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

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

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

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

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