DBA Data[Home] [Help]

APPS.OKC_WF_CHK_APPROVE dependencies on WF_ENGINE

Line 68: x_role := wf_engine.GetItemAttrText(

64: where p_current is NULL
65: order by num;
66: begin
67: if (p_role_type = 'ADMINISTRATOR') then
68: x_role := wf_engine.GetItemAttrText(
69: itemtype => itemtype,
70: itemkey => itemkey,
71: aname => 'INITIATOR_NAME');
72: x_name := wf_engine.GetItemAttrText(

Line 72: x_name := wf_engine.GetItemAttrText(

68: x_role := wf_engine.GetItemAttrText(
69: itemtype => itemtype,
70: itemkey => itemkey,
71: aname => 'INITIATOR_NAME');
72: x_name := wf_engine.GetItemAttrText(
73: itemtype => itemtype,
74: itemkey => itemkey,
75: aname => 'INITIATOR_DISPLAY_NAME');
76: elsif (p_role_type = 'SIGNATORY') then

Line 77: x_role := wf_engine.GetItemAttrText(

73: itemtype => itemtype,
74: itemkey => itemkey,
75: aname => 'INITIATOR_DISPLAY_NAME');
76: elsif (p_role_type = 'SIGNATORY') then
77: x_role := wf_engine.GetItemAttrText(
78: itemtype => itemtype,
79: itemkey => itemkey,
80: aname => 'INITIATOR_NAME');
81: x_name := wf_engine.GetItemAttrText(

Line 81: x_name := wf_engine.GetItemAttrText(

77: x_role := wf_engine.GetItemAttrText(
78: itemtype => itemtype,
79: itemkey => itemkey,
80: aname => 'INITIATOR_NAME');
81: x_name := wf_engine.GetItemAttrText(
82: itemtype => itemtype,
83: itemkey => itemkey,
84: aname => 'INITIATOR_DISPLAY_NAME');
85: elsif (p_role_type = 'APPROVER') then

Line 208: l_id := wf_engine.GetItemAttrNumber(

204: if (funcmode = 'RUN') then
205: --
206: -- Initiator/Initial
207: --
208: l_id := wf_engine.GetItemAttrNumber(
209: itemtype => itemtype,
210: itemkey => itemkey,
211: aname => 'USER_ID');
212: open C_INITIATOR_DISPLAY_NAME(l_id);

Line 215: wf_engine.SetItemAttrText (

211: aname => 'USER_ID');
212: open C_INITIATOR_DISPLAY_NAME(l_id);
213: fetch C_INITIATOR_DISPLAY_NAME into L_INITIATOR_NAME,L_INITIATOR_DISPLAY_NAME;
214: close C_INITIATOR_DISPLAY_NAME;
215: wf_engine.SetItemAttrText (
216: itemtype => itemtype,
217: itemkey => itemkey,
218: aname => 'INITIATOR_NAME',
219: avalue => L_INITIATOR_NAME);

Line 220: wf_engine.SetItemAttrText (

216: itemtype => itemtype,
217: itemkey => itemkey,
218: aname => 'INITIATOR_NAME',
219: avalue => L_INITIATOR_NAME);
220: wf_engine.SetItemAttrText (
221: itemtype => itemtype,
222: itemkey => itemkey,
223: aname => 'INITIATOR_DISPLAY_NAME',
224: avalue => L_INITIATOR_DISPLAY_NAME);

Line 233: wf_engine.SetItemAttrText (

229: itemkey => itemkey,
230: p_role_type => 'ADMINISTRATOR',
231: x_role => L_CONTRACT_ADMIN_USERNAME,
232: x_name => V_DUMMY);
233: wf_engine.SetItemAttrText (
234: itemtype => itemtype,
235: itemkey => itemkey,
236: aname => 'CONTRACT_ADMIN_USERNAME',
237: avalue => L_CONTRACT_ADMIN_USERNAME);

Line 294: L_NEXT_PERFORMER_USERNAME := wf_engine.GetItemAttrText(

290: --
291: -- RUN mode - normal process execution
292: --
293: if (funcmode = 'RUN') then
294: L_NEXT_PERFORMER_USERNAME := wf_engine.GetItemAttrText(
295: itemtype => itemtype,
296: itemkey => itemkey,
297: aname => 'NEXT_PERFORMER_USERNAME');
298: if (L_NEXT_PERFORMER_USERNAME is NULL)

Line 300: L_INITIATOR_DISPLAY_NAME := wf_engine.GetItemAttrText(

296: itemkey => itemkey,
297: aname => 'NEXT_PERFORMER_USERNAME');
298: if (L_NEXT_PERFORMER_USERNAME is NULL)
299: then -- just start
300: L_INITIATOR_DISPLAY_NAME := wf_engine.GetItemAttrText(
301: itemtype => itemtype,
302: itemkey => itemkey,
303: aname => 'INITIATOR_DISPLAY_NAME');
304: select_next(itemtype => itemtype,

Line 313: wf_engine.SetItemAttrText (

309: x_name => L_N_PERFORMER_DISPLAY_NAME);
310: -- just for common situation if no approvers at all
311: -- then Change Contract is considered as approved by initiator
312: if (L_NEXT_PERFORMER_USERNAME is NULL) then
313: wf_engine.SetItemAttrText (
314: itemtype => itemtype,
315: itemkey => itemkey,
316: aname => 'N_PERFORMER_DISPLAY_NAME',
317: avalue => L_INITIATOR_DISPLAY_NAME);

Line 320: wf_engine.SetItemAttrText (

316: aname => 'N_PERFORMER_DISPLAY_NAME',
317: avalue => L_INITIATOR_DISPLAY_NAME);
318: resultout := 'COMPLETE:F';
319: else
320: wf_engine.SetItemAttrText (
321: itemtype => itemtype,
322: itemkey => itemkey,
323: aname => 'P_PERFORMER_DISPLAY_NAME',
324: avalue => L_INITIATOR_DISPLAY_NAME);

Line 325: wf_engine.SetItemAttrText (

321: itemtype => itemtype,
322: itemkey => itemkey,
323: aname => 'P_PERFORMER_DISPLAY_NAME',
324: avalue => L_INITIATOR_DISPLAY_NAME);
325: wf_engine.SetItemAttrText (
326: itemtype => itemtype,
327: itemkey => itemkey,
328: aname => 'NEXT_PERFORMER_USERNAME',
329: avalue => L_NEXT_PERFORMER_USERNAME);

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

326: itemtype => itemtype,
327: itemkey => itemkey,
328: aname => 'NEXT_PERFORMER_USERNAME',
329: avalue => L_NEXT_PERFORMER_USERNAME);
330: wf_engine.SetItemAttrText(itemtype => itemtype,
331: itemkey => itemkey,
332: aname => 'N_PERFORMER_DISPLAY_NAME',
333: avalue => L_N_PERFORMER_DISPLAY_NAME);
334: resultout := 'COMPLETE:T';

Line 338: wf_engine.SetItemAttrText

334: resultout := 'COMPLETE:T';
335: end if;
336: return;
337: else
338: wf_engine.SetItemAttrText
339: (
340: itemtype => itemtype,
341: itemkey => itemkey,
342: aname => 'P_PERFORMER_DISPLAY_NAME',

Line 343: avalue => wf_engine.GetItemAttrText(

339: (
340: itemtype => itemtype,
341: itemkey => itemkey,
342: aname => 'P_PERFORMER_DISPLAY_NAME',
343: avalue => wf_engine.GetItemAttrText(
344: itemtype => itemtype,
345: itemkey => itemkey,
346: aname => 'N_PERFORMER_DISPLAY_NAME')
347: );

Line 355: wf_engine.SetItemAttrText (

351: p_current => L_NEXT_PERFORMER_USERNAME,
352: x_role => L_NEXT_PERFORMER_USERNAME,
353: x_name => L_N_PERFORMER_DISPLAY_NAME);
354: if (L_NEXT_PERFORMER_USERNAME is NULL) then
355: wf_engine.SetItemAttrText (
356: itemtype => itemtype,
357: itemkey => itemkey,
358: aname => 'NEXT_PERFORMER_USERNAME',
359: avalue => NULL);

Line 362: wf_engine.SetItemAttrText (

358: aname => 'NEXT_PERFORMER_USERNAME',
359: avalue => NULL);
360: resultout := 'COMPLETE:F';
361: else
362: wf_engine.SetItemAttrText (
363: itemtype => itemtype,
364: itemkey => itemkey,
365: aname => 'NEXT_PERFORMER_USERNAME',
366: avalue => L_NEXT_PERFORMER_USERNAME);

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

363: itemtype => itemtype,
364: itemkey => itemkey,
365: aname => 'NEXT_PERFORMER_USERNAME',
366: avalue => L_NEXT_PERFORMER_USERNAME);
367: wf_engine.SetItemAttrText(itemtype => itemtype,
368: itemkey => itemkey,
369: aname => 'N_PERFORMER_DISPLAY_NAME',
370: avalue => L_N_PERFORMER_DISPLAY_NAME);
371: resultout := 'COMPLETE:T';

Line 427: L_NEXT_INFORMED_USERNAME := wf_engine.GetItemAttrText(

423: --
424: -- RUN mode - normal process execution
425: --
426: if (funcmode = 'RUN') then
427: L_NEXT_INFORMED_USERNAME := wf_engine.GetItemAttrText(
428: itemtype => itemtype,
429: itemkey => itemkey,
430: aname => 'NEXT_INFORMED_USERNAME');
431: select_next(itemtype => itemtype,

Line 437: wf_engine.SetItemAttrText (

433: p_role_type => 'INFORMED',
434: p_current => L_NEXT_INFORMED_USERNAME,
435: x_role => L_NEXT_INFORMED_USERNAME,
436: x_name => V_DUMMY);
437: wf_engine.SetItemAttrText (
438: itemtype => itemtype,
439: itemkey => itemkey,
440: aname => 'NEXT_INFORMED_USERNAME',
441: avalue => L_NEXT_INFORMED_USERNAME);

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

488: itemkey in varchar2) is
489: i integer;
490: begin
491: FOR I IN 1..9 LOOP
492: wf_engine.SetItemAttrText (itemtype => itemtype,
493: itemkey => itemkey,
494: aname => 'MESSAGE'||i,
495: avalue => '');
496: END LOOP;

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

513: j := NVL(FND_MSG_PUB.Count_Msg,0);
514: if (j=0) then return; end if;
515: if (j>9) then j:=9; end if;
516: FOR I IN 1..J LOOP
517: wf_engine.SetItemAttrText (itemtype => itemtype,
518: itemkey => itemkey,
519: aname => 'MESSAGE'||i,
520: avalue => FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
521: END LOOP;

Line 548: L_CHANGE_REQUEST_ID := wf_engine.GetItemAttrNumber(

544: if (funcmode = 'RUN') then
545: --
546: empty_mess( itemtype,
547: itemkey );
548: L_CHANGE_REQUEST_ID := wf_engine.GetItemAttrNumber(
549: itemtype => itemtype,
550: itemkey => itemkey,
551: aname => 'CHANGE_REQUEST_ID');
552: OKC_CHANGE_CONTRACT_PUB.change_request_approved(

Line 622: L_CHANGE_REQUEST_ID := wf_engine.GetItemAttrNumber(

618: if (funcmode = 'RUN') then
619: --
620: empty_mess( itemtype,
621: itemkey );
622: L_CHANGE_REQUEST_ID := wf_engine.GetItemAttrNumber(
623: itemtype => itemtype,
624: itemkey => itemkey,
625: aname => 'CHANGE_REQUEST_ID');
626: OKC_CHANGE_CONTRACT_PUB.change_request_rejected(

Line 691: if (wf_engine.GetItemAttrText(itemtype,itemkey,'NOTE') is NULL) then

687: --
688: -- RUN mode - normal process execution
689: --
690: if (funcmode = 'RUN') then
691: if (wf_engine.GetItemAttrText(itemtype,itemkey,'NOTE') is NULL) then
692: resultout := 'COMPLETE:F';
693: else
694: resultout := 'COMPLETE:T';
695: end if;