APPS.OKL_BILLING_REF_WF dependencies on WF_ENGINE

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

109: l_approver := fnd_profile.value('OKL_BILL_REQ_REP');
110: IF l_approver IS NULL THEN
111: l_approver := 'SYSADMIN';
112: END IF;
113: wf_engine.SetItemAttrText (itemtype => itemtype,
114: itemkey => itemkey,
115: aname => 'APPROVER_ROLE',
116: avalue => l_approver);
117: l_trx_id := wf_engine.GetItemAttrText(itemtype => itemtype,

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

113: wf_engine.SetItemAttrText (itemtype => itemtype,
114: itemkey => itemkey,
115: aname => 'APPROVER_ROLE',
116: avalue => l_approver);
117: l_trx_id := wf_engine.GetItemAttrText(itemtype => itemtype,
118: itemkey => itemkey,
119: aname => 'TAS_ID');
120: l_chrv_id := wf_engine.GetItemAttrText(itemtype => itemtype,
121: itemkey => itemkey,

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

116: avalue => l_approver);
117: l_trx_id := wf_engine.GetItemAttrText(itemtype => itemtype,
118: itemkey => itemkey,
119: aname => 'TAS_ID');
120: l_chrv_id := wf_engine.GetItemAttrText(itemtype => itemtype,
121: itemkey => itemkey,
122: aname => 'CONTRACT_ID');
123:
124:

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

150: , p_user_id => l_created_by
151: , x_name => l_user_name
152: , x_description => l_name);
153:
154: wf_engine.SetItemAttrText (itemtype => itemtype,
155: itemkey => itemkey,
156: aname => 'REQUESTOR_ROLE',
157: avalue => l_user_name);
158: wf_engine.SetItemAttrText (itemtype => itemtype,

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

154: wf_engine.SetItemAttrText (itemtype => itemtype,
155: itemkey => itemkey,
156: aname => 'REQUESTOR_ROLE',
157: avalue => l_user_name);
158: wf_engine.SetItemAttrText (itemtype => itemtype,
159: itemkey => itemkey,
160: aname => 'CUSTOMER',
161: avalue => l_cust_name);
162: --rkuttiya

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

160: aname => 'CUSTOMER',
161: avalue => l_cust_name);
162: --rkuttiya
163:
164: wf_engine.SetItemAttrText (itemtype => itemtype,
165: itemkey => itemkey,
166: aname => 'REQUEST_NUMBER',
167: avalue => l_request_num);
168: wf_engine.SetItemAttrText (itemtype => itemtype,

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

164: wf_engine.SetItemAttrText (itemtype => itemtype,
165: itemkey => itemkey,
166: aname => 'REQUEST_NUMBER',
167: avalue => l_request_num);
168: wf_engine.SetItemAttrText (itemtype => itemtype,
169: itemkey => itemkey,
170: aname => 'CONTRACT_NUMBER',
171: avalue => l_contract_num);
172: wf_engine.SetItemAttrText (itemtype => itemtype,

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

168: wf_engine.SetItemAttrText (itemtype => itemtype,
169: itemkey => itemkey,
170: aname => 'CONTRACT_NUMBER',
171: avalue => l_contract_num);
172: wf_engine.SetItemAttrText (itemtype => itemtype,
173: itemkey => itemkey,
174: aname => 'REFUND_AMOUNT',
175: avalue => l_refund_amnt);
176: --skgautam added for fix of bug 3983938

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

186: CLOSE c_get_reason;
187: l_message :=' Please approve and process Billing Refund Request '||L_REQUEST_NUM ||', for Customer '||L_CUST_NAME||
188: ', for the refund amount '||L_REFUND_AMNT||' and for refund reason '||l_reason_desc;
189: END IF;
190: wf_engine.SetItemAttrText ( itemtype=> itemtype,
191: itemkey => itemkey,
192: aname => 'MESSAGE_DESCRIPTION',
193: avalue => l_message); --skgautam bug 3983938
194: resultout := 'COMPLETE:';

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

264: l_ntf_comments VARCHAR2(4000);
265: l_rjn_code VARCHAR2(30);
266: BEGIN
267: -- We getting the request_Id from WF
268: l_trx_id := wf_engine.GetItemAttrText(itemtype => itemtype,
269: itemkey => itemkey,
270: aname => 'TAS_ID');
271: -- We need to status to Approved Pending since We are sending for approval
272: IF (funcmode = 'RESPOND') THEN

Line 273: --get notification id from wf_engine context

269: itemkey => itemkey,
270: aname => 'TAS_ID');
271: -- We need to status to Approved Pending since We are sending for approval
272: IF (funcmode = 'RESPOND') THEN
273: --get notification id from wf_engine context
274: l_nid := WF_ENGINE.CONTEXT_NID;
275: l_ntf_result := wf_notification.GetAttrText(l_nid,'RESULT');
276:
277: --rkuttiya commented for problem identified during bug fix - 2923037

Line 274: l_nid := WF_ENGINE.CONTEXT_NID;

270: aname => 'TAS_ID');
271: -- We need to status to Approved Pending since We are sending for approval
272: IF (funcmode = 'RESPOND') THEN
273: --get notification id from wf_engine context
274: l_nid := WF_ENGINE.CONTEXT_NID;
275: l_ntf_result := wf_notification.GetAttrText(l_nid,'RESULT');
276:
277: --rkuttiya commented for problem identified during bug fix - 2923037
278: --resultout := 'COMPLETE:APPROVED';

Line 290: resultout := wf_engine.eng_null;

286: return;
287: END IF;
288: --Transfer Mode
289: IF funcmode = 'TRANSFER' THEN
290: resultout := wf_engine.eng_null;
291: return;
292: END IF;
293: -- CANCEL mode
294: IF (funcmode = 'CANCEL') THEN