DBA Data[Home] [Help]

APPS.OKL_VP_CR_WF dependencies on WF_ENGINE

Line 113: lv_change_request_num := wf_engine.GetItemAttrText(itemtype => itemtype,

109: ,attrib wf_item_attributes.name%TYPE
110: ) IS
111: lv_change_request_num okc_k_headers_b.contract_number%TYPE;
112: BEGIN
113: lv_change_request_num := wf_engine.GetItemAttrText(itemtype => itemtype,
114: itemkey => itemkey,
115: aname => G_WF_ITM_CHANGE_REQUEST_NUM);
116:
117: fnd_message.set_name(G_APP_NAME,message);

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

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

Line 251: lv_change_req_id := wf_engine.GetItemAttrText(itemtype => G_ITEM_TYPE_WF

247: document IN OUT nocopy VARCHAR2,
248: document_type IN OUT nocopy VARCHAR2) IS
249: lv_change_req_id okl_vp_change_requests.id%TYPE;
250: BEGIN
251: lv_change_req_id := wf_engine.GetItemAttrText(itemtype => G_ITEM_TYPE_WF
252: ,itemkey => document_id
253: ,aname => G_WF_ITM_CHANGE_REQUEST_ID);
254: document := compile_message_body(lv_change_req_id);
255: document_type := display_type;

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

507: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug call get_agrmnt_approver');
508: END IF;
509:
510: IF(funcmode = 'RUN')THEN
511: l_user_id := wf_engine.GetItemAttrText(itemtype => itemtype,
512: itemkey => itemkey,
513: aname => G_WF_ITM_REQUESTER_ID);
514:
515: resultout := 'COMPLETE:N'; -- default

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

514:
515: resultout := 'COMPLETE:N'; -- default
516: IF l_user_id IS NOT NULL THEN
517: FOR l_fnd_users_rec IN l_fnd_users_csr(l_user_id) LOOP
518: wf_engine.SetItemAttrText (itemtype => itemtype,
519: itemkey => itemkey,
520: aname => G_WF_ITM_APPROVER,
521: avalue => l_fnd_users_rec.user_name);
522:

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

522:
523: -- Message: "Change Request requires approval"
524: set_attrib_message(itemtype, itemkey, 'OKL_VN_CR_REQ_APPROVAL_SUB', G_WF_ITM_MESSAGE_SUBJECT);
525:
526: wf_engine.SetItemAttrText (itemtype => itemtype,
527: itemkey => itemkey,
528: aname => G_WF_ITM_MESSAGE_BODY,
529: avalue => 'plsql:okl_vp_cr_wf.get_msg_doc/'||itemkey
530: );

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

583: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug update_cr_status');
584: END IF;
585:
586: IF(funcmode = 'RUN')THEN
587: lv_approval_status := wf_engine.GetItemAttrText(itemtype => itemtype,
588: itemkey => itemkey,
589: aname => G_WF_ITM_RESULT);
590: lv_approval_status_ame := wf_engine.GetItemAttrText(itemtype => itemtype,
591: itemkey => itemkey,

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

586: IF(funcmode = 'RUN')THEN
587: lv_approval_status := wf_engine.GetItemAttrText(itemtype => itemtype,
588: itemkey => itemkey,
589: aname => G_WF_ITM_RESULT);
590: lv_approval_status_ame := wf_engine.GetItemAttrText(itemtype => itemtype,
591: itemkey => itemkey,
592: aname => 'APPROVED_YN');
593: lv_change_req_id := wf_engine.GetItemAttrText(itemtype => itemtype,
594: itemkey => itemkey,

Line 593: lv_change_req_id := wf_engine.GetItemAttrText(itemtype => itemtype,

589: aname => G_WF_ITM_RESULT);
590: lv_approval_status_ame := wf_engine.GetItemAttrText(itemtype => itemtype,
591: itemkey => itemkey,
592: aname => 'APPROVED_YN');
593: lv_change_req_id := wf_engine.GetItemAttrText(itemtype => itemtype,
594: itemkey => itemkey,
595: aname => G_WF_ITM_CHANGE_REQUEST_ID);
596:
597: -- cursor that fetches the change request type and the agreement associated with the change request

Line 712: lv_change_req_id := wf_engine.GetItemAttrText(itemtype => itemtype

708: l_debug_enabled VARCHAR2(10);
709: lv_change_req_id okl_vp_change_requests.id%TYPE;
710: BEGIN
711: IF(funcmode = 'RUN')THEN
712: lv_change_req_id := wf_engine.GetItemAttrText(itemtype => itemtype
713: ,itemkey => itemkey
714: ,aname => G_WF_ITM_CHANGE_REQUEST_ID);
715:
716: set_attrib_message(itemtype, itemkey, 'OKL_VN_CR_REQ_APPROVAL_SUB', G_WF_ITM_APP_REQUEST_SUB);

Line 724: wf_engine.SetItemAttrText (itemtype => itemtype

720: set_attrib_message(itemtype, itemkey, 'OKL_VN_CR_REQ_APPROVED_SUB', G_WF_ITM_APP_APPROVED_HEAD);
721: set_attrib_message(itemtype, itemkey, 'OKL_VN_CR_REQ_REJECT_SUB', G_WF_ITM_APP_REJECTED_SUB);
722: set_attrib_message(itemtype, itemkey, 'OKL_VN_CR_REQ_REJECT_SUB', G_WF_ITM_APP_REJECTED_HEAD);
723:
724: wf_engine.SetItemAttrText (itemtype => itemtype
725: ,itemkey => itemkey
726: ,aname => G_WF_ITM_MESSAGE_DESCR
727: ,avalue => compile_message_body(lv_change_req_id)
728: );

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

755: l_api_name CONSTANT VARCHAR2(200) DEFAULT 'set_msg_attributes';
756: BEGIN
757: -- RUN mode
758: IF(funcmode = 'RUN')THEN
759: lv_approval_status := wf_engine.GetItemAttrText(itemtype => itemtype
760: ,itemkey => itemkey
761: ,aname => G_WF_ITM_RESULT);
762: IF(G_WF_ITM_APPROVED_YN_YES = lv_approval_status)THEN
763: set_attrib_message(itemtype, itemkey, 'OKL_VN_CR_REQ_APPROVED_SUB', G_WF_ITM_MESSAGE_SUBJECT);

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

763: set_attrib_message(itemtype, itemkey, 'OKL_VN_CR_REQ_APPROVED_SUB', G_WF_ITM_MESSAGE_SUBJECT);
764: ELSIF(G_WF_ITM_APPROVED_YN_NO = lv_approval_status)THEN
765: set_attrib_message(itemtype, itemkey, 'OKL_VN_CR_REQ_REJECT_SUB', G_WF_ITM_MESSAGE_SUBJECT);
766: END IF;
767: wf_engine.SetItemAttrText (itemtype => itemtype,
768: itemkey => itemkey,
769: aname => G_WF_ITM_MESSAGE_BODY,
770: avalue => 'plsql:okl_vp_cr_wf.get_msg_doc/'||itemkey
771: );