DBA Data[Home] [Help]

APPS.OKL_BILLING_CORR_REQ_WF dependencies on WF_ENGINE

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

79: l_approver := fnd_profile.value('OKL_BILL_REQ_REP');
80: IF l_approver IS NULL THEN
81: l_approver := 'SYSADMIN';
82: END IF;
83: wf_engine.SetItemAttrText (itemtype => itemtype,
84: itemkey => itemkey,
85: aname => 'APPROVER_ROLE',
86: avalue => l_approver);
87: l_trx_id := wf_engine.GetItemAttrText(itemtype => itemtype,

Line 87: l_trx_id := wf_engine.GetItemAttrText(itemtype => itemtype,

83: wf_engine.SetItemAttrText (itemtype => itemtype,
84: itemkey => itemkey,
85: aname => 'APPROVER_ROLE',
86: avalue => l_approver);
87: l_trx_id := wf_engine.GetItemAttrText(itemtype => itemtype,
88: itemkey => itemkey,
89: aname => 'TAS_ID');
90: l_chrv_id := wf_engine.GetItemAttrText(itemtype => itemtype,
91: itemkey => itemkey,

Line 90: l_chrv_id := wf_engine.GetItemAttrText(itemtype => itemtype,

86: avalue => l_approver);
87: l_trx_id := wf_engine.GetItemAttrText(itemtype => itemtype,
88: itemkey => itemkey,
89: aname => 'TAS_ID');
90: l_chrv_id := wf_engine.GetItemAttrText(itemtype => itemtype,
91: itemkey => itemkey,
92: aname => 'CONTRACT_ID');
93:
94: OPEN c_fetch_r_number(l_trx_id);

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

104: RAISE OKL_API.G_EXCEPTION_ERROR;
105: END IF;
106: CLOSE c_fetch_k_number;
107:
108: wf_engine.SetItemAttrText (itemtype => itemtype,
109: itemkey => itemkey,
110: aname => 'REQUEST_NUMBER',
111: avalue => l_request_num);
112: wf_engine.SetItemAttrText (itemtype => itemtype,

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

108: wf_engine.SetItemAttrText (itemtype => itemtype,
109: itemkey => itemkey,
110: aname => 'REQUEST_NUMBER',
111: avalue => l_request_num);
112: wf_engine.SetItemAttrText (itemtype => itemtype,
113: itemkey => itemkey,
114: aname => 'CONTRACT_NUMBER',
115: avalue => l_contract_num);
116: resultout := 'COMPLETE:';

Line 190: l_trx_id := wf_engine.GetItemAttrText(itemtype => itemtype,

186: l_ntf_comments VARCHAR2(4000);
187: l_rjn_code VARCHAR2(30);
188: BEGIN
189: -- We getting the request_Id from WF
190: l_trx_id := wf_engine.GetItemAttrText(itemtype => itemtype,
191: itemkey => itemkey,
192: aname => 'TAS_ID');
193: -- We need to status to Approved Pending since We are sending for approval
194: IF (funcmode = 'RESPOND') THEN

Line 195: --get notification id from wf_engine context

191: itemkey => itemkey,
192: aname => 'TAS_ID');
193: -- We need to status to Approved Pending since We are sending for approval
194: IF (funcmode = 'RESPOND') THEN
195: --get notification id from wf_engine context
196: l_nid := WF_ENGINE.CONTEXT_NID;
197: l_ntf_result := wf_notification.GetAttrText(l_nid,'RESULT');
198: --rkuttiya commented for fixing problem identified during bug:2923037
199: -- resultout := 'COMPLETE:YES';

Line 196: l_nid := WF_ENGINE.CONTEXT_NID;

192: aname => 'TAS_ID');
193: -- We need to status to Approved Pending since We are sending for approval
194: IF (funcmode = 'RESPOND') THEN
195: --get notification id from wf_engine context
196: l_nid := WF_ENGINE.CONTEXT_NID;
197: l_ntf_result := wf_notification.GetAttrText(l_nid,'RESULT');
198: --rkuttiya commented for fixing problem identified during bug:2923037
199: -- resultout := 'COMPLETE:YES';
200: -- return;

Line 211: resultout := wf_engine.eng_null;

207: return;
208: END IF;
209: --Transfer Mode
210: IF funcmode = 'TRANSFER' THEN
211: resultout := wf_engine.eng_null;
212: return;
213: END IF;
214: -- CANCEL mode
215: IF (funcmode = 'CANCEL') THEN