eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_REQAPPROVAL_FINDAPPRV1 dependencies on WF_ENGINE

Line 82: if (funcmode <> wf_engine.eng_run) then

78:
79:
80: -- Do nothing in cancel or timeout mode
81: --
82: if (funcmode <> wf_engine.eng_run) then
83:
84: resultout := wf_engine.eng_null;
85: return;
86:

Line 84: resultout := wf_engine.eng_null;

80: -- Do nothing in cancel or timeout mode
81: --
82: if (funcmode <> wf_engine.eng_run) then
83:
84: resultout := wf_engine.eng_null;
85: return;
86:
87: end if;
88:

Line 91: l_error_msg := wf_engine.GetItemAttrText (itemtype => itemtype,

87: end if;
88:
89: --Start of code changes.
90: IF itemtype in ('POAPPRV') THEN
91: l_error_msg := wf_engine.GetItemAttrText (itemtype => itemtype,
92: itemkey => itemkey,
93: aname => 'WRONG_FORWARD_TO_MSG');
94: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Set_Forward_To_From_App_fwd: l_error_msg: ';
95: IF (g_po_wf_debug = 'Y') THEN

Line 100: l_forward_to_username_response := wf_engine.GetItemAttrText(itemtype => itemtype,

96: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress || l_error_msg);
97: END IF;
98:
99: IF l_error_msg is NULL THEN
100: l_forward_to_username_response := wf_engine.GetItemAttrText(itemtype => itemtype,
101: itemkey => itemkey,
102: aname => 'FORWARD_TO_USERNAME_RESPONSE');
103: l_forward_to_username_response := UPPER(l_forward_to_username_response);
104:

Line 105: l_forward_to_username:= wf_engine.GetItemAttrText (itemtype => itemtype,

101: itemkey => itemkey,
102: aname => 'FORWARD_TO_USERNAME_RESPONSE');
103: l_forward_to_username_response := UPPER(l_forward_to_username_response);
104:
105: l_forward_to_username:= wf_engine.GetItemAttrText (itemtype => itemtype,
106: itemkey => itemkey,
107: aname => 'FORWARD_TO_USERNAME');
108: IF (g_po_wf_debug = 'Y') THEN
109: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,

Line 115: l_forward_to_username_disp:= wf_engine.GetItemAttrText (itemtype => itemtype,

111: END IF;
112:
113: IF l_forward_to_username is NOT NULL THEN
114:
115: l_forward_to_username_disp:= wf_engine.GetItemAttrText (itemtype => itemtype,
116: itemkey => itemkey,
117: aname => 'FORWARD_TO_DISPLAY_NAME');
118:
119: ELSE /* get the approver name who took this action */

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

116: itemkey => itemkey,
117: aname => 'FORWARD_TO_DISPLAY_NAME');
118:
119: ELSE /* get the approver name who took this action */
120: l_forward_to_username:= wf_engine.GetItemAttrText (itemtype => itemtype,
121: itemkey => itemkey,
122: aname => 'APPROVER_USER_NAME');
123:
124: l_forward_to_username_disp:= wf_engine.GetItemAttrText (itemtype => itemtype,

Line 124: l_forward_to_username_disp:= wf_engine.GetItemAttrText (itemtype => itemtype,

120: l_forward_to_username:= wf_engine.GetItemAttrText (itemtype => itemtype,
121: itemkey => itemkey,
122: aname => 'APPROVER_USER_NAME');
123:
124: l_forward_to_username_disp:= wf_engine.GetItemAttrText (itemtype => itemtype,
125: itemkey => itemkey,
126: aname => 'APPROVER_DISPLAY_NAME');
127: END IF;
128:

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

126: aname => 'APPROVER_DISPLAY_NAME');
127: END IF;
128:
129: /* Set the FORWARD_FROM */
130: wf_engine.SetItemAttrText ( itemtype => itemtype,
131: itemkey => itemkey,
132: aname => 'FORWARD_FROM_USER_NAME',
133: avalue => l_forward_to_username);
134:

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

131: itemkey => itemkey,
132: aname => 'FORWARD_FROM_USER_NAME',
133: avalue => l_forward_to_username);
134:
135: wf_engine.SetItemAttrText ( itemtype => itemtype,
136: itemkey => itemkey,
137: aname => 'FORWARD_FROM_DISP_NAME',
138: avalue => l_forward_to_username_disp);
139:

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

139:
140: /* Set the approver to the person who took the action on the notification,
141: ** i.e. the old forward-to person
142: */
143: wf_engine.SetItemAttrText ( itemtype => itemtype,
144: itemkey => itemkey,
145: aname => 'APPROVER_USER_NAME',
146: avalue => l_forward_to_username);
147:

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

144: itemkey => itemkey,
145: aname => 'APPROVER_USER_NAME',
146: avalue => l_forward_to_username);
147:
148: wf_engine.SetItemAttrText ( itemtype => itemtype,
149: itemkey => itemkey,
150: aname => 'APPROVER_DISPLAY_NAME',
151: avalue => l_forward_to_username_disp);
152:

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

150: aname => 'APPROVER_DISPLAY_NAME',
151: avalue => l_forward_to_username_disp);
152:
153: /* Set the FORWARD-TO */
154: wf_engine.SetItemAttrText ( itemtype => itemtype,
155: itemkey => itemkey,
156: aname => 'FORWARD_TO_USERNAME',
157: avalue => l_forward_to_username_response);
158:

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

157: avalue => l_forward_to_username_response);
158:
159:
160: /* Get the Display name for the user from the WF Directory */
161: wf_engine.SetItemAttrText ( itemtype => itemtype,
162: itemkey => itemkey,
163: aname => 'FORWARD_TO_DISPLAY_NAME',
164: avalue =>
165: wf_directory.GetRoleDisplayName(l_forward_to_username_response));

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

164: avalue =>
165: wf_directory.GetRoleDisplayName(l_forward_to_username_response));
166:
167: /* Reset the FORWARD_TO_USERNAME_RESPONSE attribute */
168: wf_engine.SetItemAttrText (itemtype => itemtype,
169: itemkey => itemkey,
170: aname => 'FORWARD_TO_USERNAME_RESPONSE',
171: avalue => NULL);
172:

Line 194: -- resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';

190: itemkey => itemkey,
191: aname => 'RESPONDER_APPL_ID',
192: avalue => fnd_global.RESP_APPL_ID);
193:
194: -- resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
195:
196: resultout := 'COMPLETE' ;
197:
198: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Set_Forward_To_From_App_fwd: 02';

Line 246: if (funcmode <> wf_engine.eng_run) then

242:
243:
244: -- Do nothing in cancel or timeout mode
245: --
246: if (funcmode <> wf_engine.eng_run) then
247:
248: resultout := wf_engine.eng_null;
249: return;
250:

Line 248: resultout := wf_engine.eng_null;

244: -- Do nothing in cancel or timeout mode
245: --
246: if (funcmode <> wf_engine.eng_run) then
247:
248: resultout := wf_engine.eng_null;
249: return;
250:
251: end if;
252:

Line 273: l_approver_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

269:
270: /* If the responder chooses APPROVE or the notification times out, then
271: ** Set the Approver to be the old forward-to
272: */
273: l_approver_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
274: itemkey => itemkey,
275: aname => 'FORWARD_TO_ID');
276:
277: l_approver_username := wf_engine.GetItemAttrText (itemtype => itemType,

Line 277: l_approver_username := wf_engine.GetItemAttrText (itemtype => itemType,

273: l_approver_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
274: itemkey => itemkey,
275: aname => 'FORWARD_TO_ID');
276:
277: l_approver_username := wf_engine.GetItemAttrText (itemtype => itemType,
278: itemkey => itemkey,
279: aname => 'FORWARD_TO_USERNAME');
280:
281: l_approver_disp_name := wf_engine.GetItemAttrText (itemtype => itemType,

Line 281: l_approver_disp_name := wf_engine.GetItemAttrText (itemtype => itemType,

277: l_approver_username := wf_engine.GetItemAttrText (itemtype => itemType,
278: itemkey => itemkey,
279: aname => 'FORWARD_TO_USERNAME');
280:
281: l_approver_disp_name := wf_engine.GetItemAttrText (itemtype => itemType,
282: itemkey => itemkey,
283: aname => 'FORWARD_TO_DISPLAY_NAME');
284: --
285: wf_engine.SetItemAttrNumber (itemtype => itemtype,

Line 285: wf_engine.SetItemAttrNumber (itemtype => itemtype,

281: l_approver_disp_name := wf_engine.GetItemAttrText (itemtype => itemType,
282: itemkey => itemkey,
283: aname => 'FORWARD_TO_DISPLAY_NAME');
284: --
285: wf_engine.SetItemAttrNumber (itemtype => itemtype,
286: itemkey => itemkey,
287: aname => 'APPROVER_EMPID',
288: avalue => l_approver_id);
289:

Line 290: wf_engine.SetItemAttrText ( itemtype => itemType,

286: itemkey => itemkey,
287: aname => 'APPROVER_EMPID',
288: avalue => l_approver_id);
289:
290: wf_engine.SetItemAttrText ( itemtype => itemType,
291: itemkey => itemkey,
292: aname => 'APPROVER_USER_NAME' ,
293: avalue => l_approver_username);
294:

Line 295: wf_engine.SetItemAttrText ( itemtype => itemType,

291: itemkey => itemkey,
292: aname => 'APPROVER_USER_NAME' ,
293: avalue => l_approver_username);
294:
295: wf_engine.SetItemAttrText ( itemtype => itemType,
296: itemkey => itemkey,
297: aname => 'APPROVER_DISPLAY_NAME' ,
298: avalue => l_approver_disp_name);
299:

Line 303: wf_engine.SetItemAttrNumber (itemtype => itemtype,

299:
300: /*
301: ** Reset the Forward-to and Forward-From.
302: */
303: wf_engine.SetItemAttrNumber (itemtype => itemtype,
304: itemkey => itemkey,
305: aname => 'FORWARD_TO_ID',
306: avalue => NULL);
307: --

Line 308: wf_engine.SetItemAttrText ( itemtype => itemType,

304: itemkey => itemkey,
305: aname => 'FORWARD_TO_ID',
306: avalue => NULL);
307: --
308: wf_engine.SetItemAttrText ( itemtype => itemType,
309: itemkey => itemkey,
310: aname => 'FORWARD_TO_USERNAME' ,
311: avalue => NULL);
312:

Line 313: wf_engine.SetItemAttrText ( itemtype => itemType,

309: itemkey => itemkey,
310: aname => 'FORWARD_TO_USERNAME' ,
311: avalue => NULL);
312:
313: wf_engine.SetItemAttrText ( itemtype => itemType,
314: itemkey => itemkey,
315: aname => 'FORWARD_TO_DISPLAY_NAME' ,
316: avalue => NULL);
317: --

Line 334: wf_engine.SetItemAttrNumber (itemtype => itemtype,

330: ** Set_Fwd_To_From_App_timeout procedure which is the forward to person
331: ** when the timeout occurs.
332: */
333:
334: wf_engine.SetItemAttrNumber (itemtype => itemtype,
335: itemkey => itemkey,
336: aname => 'FORWARD_FROM_ID',
337: avalue => l_approver_id);
338: --

Line 339: wf_engine.SetItemAttrText ( itemtype => itemType,

335: itemkey => itemkey,
336: aname => 'FORWARD_FROM_ID',
337: avalue => l_approver_id);
338: --
339: wf_engine.SetItemAttrText ( itemtype => itemType,
340: itemkey => itemkey,
341: aname => 'FORWARD_FROM_USER_NAME' ,
342: avalue => l_approver_username);
343:

Line 344: wf_engine.SetItemAttrText ( itemtype => itemType,

340: itemkey => itemkey,
341: aname => 'FORWARD_FROM_USER_NAME' ,
342: avalue => l_approver_username);
343:
344: wf_engine.SetItemAttrText ( itemtype => itemType,
345: itemkey => itemkey,
346: aname => 'FORWARD_FROM_DISP_NAME' ,
347: avalue => l_approver_disp_name);
348:

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

347: avalue => l_approver_disp_name);
348:
349:
350: /* Reset the FORWARD_TO_USERNAME_RESPONSE attribute */
351: wf_engine.SetItemAttrText (itemtype => itemtype,
352: itemkey => itemkey,
353: aname => 'FORWARD_TO_USERNAME_RESPONSE',
354: avalue => NULL);
355:

Line 357: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,

353: aname => 'FORWARD_TO_USERNAME_RESPONSE',
354: avalue => NULL);
355:
356: /*Bug 9593873 Reset response note*/
357: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
358: itemkey => itemkey,
359: aname => 'DOCUMENT_TYPE');
360: IF (l_document_type='PO' OR l_document_type='PA' OR l_document_type='RELEASE' ) THEN
361: l_note := PO_WF_UTIL_PKG.GetItemAttrText(itemtype=>itemtype,

Line 382: wf_engine.SetItemAttrText ( itemtype => itemType,

378: */
379: fnd_message.set_name ('PO','PO_WF_NOTIF_REQUIRES_APPROVAL');
380: l_error_msg := fnd_message.get;
381:
382: wf_engine.SetItemAttrText ( itemtype => itemType,
383: itemkey => itemkey,
384: aname => 'REQUIRES_APPROVAL_MSG' ,
385: avalue => l_error_msg);
386:

Line 387: wf_engine.SetItemAttrText ( itemtype => itemType,

383: itemkey => itemkey,
384: aname => 'REQUIRES_APPROVAL_MSG' ,
385: avalue => l_error_msg);
386:
387: wf_engine.SetItemAttrText ( itemtype => itemType,
388: itemkey => itemkey,
389: aname => 'WRONG_FORWARD_TO_MSG' ,
390: avalue => '');
391:

Line 392: -- resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';

388: itemkey => itemkey,
389: aname => 'WRONG_FORWARD_TO_MSG' ,
390: avalue => '');
391:
392: -- resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
393:
394: resultout := 'COMPLETE' ;
395:
396: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Set_Fwd_To_From_App_timeout: 02';

Line 463: if (funcmode <> wf_engine.eng_run) then

459:
460:
461: -- Do nothing in cancel or timeout mode
462: --
463: if (funcmode <> wf_engine.eng_run) then
464:
465: resultout := wf_engine.eng_null;
466: return;
467:

Line 465: resultout := wf_engine.eng_null;

461: -- Do nothing in cancel or timeout mode
462: --
463: if (funcmode <> wf_engine.eng_run) then
464:
465: resultout := wf_engine.eng_null;
466: return;
467:
468: end if;
469:

Line 482: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype,

478: ** Desc: When responding from the E-mail notifications, the forward
479: ** to failed as the org context was not set.
480: */
481:
482: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype,
483: itemkey => itemkey,
484: aname => 'ORG_ID');
485:
486: IF l_orgid is NOT NULL THEN

Line 499: l_forward_to_username_response := wf_engine.GetItemAttrText (itemtype => itemtype,

495: ** Then set the Forward-To to the one the user entered in the response.
496: */
497: /* NOTE: We take the value entered by the user and set it to ALL CAPITAL LETTERS!!!
498: */
499: l_forward_to_username_response := wf_engine.GetItemAttrText (itemtype => itemtype,
500: itemkey => itemkey,
501: aname => 'FORWARD_TO_USERNAME_RESPONSE');
502:
503: l_forward_to_username_response := UPPER(l_forward_to_username_response);

Line 523: l_forward_to_username:= wf_engine.GetItemAttrText (itemtype => itemtype,

519: /* The FORWARD-FROM is now the old FORWARD-TO and the NEW FORWARD-TO is set
520: ** to what the user entered in the response
521: */
522:
523: l_forward_to_username:= wf_engine.GetItemAttrText (itemtype => itemtype,
524: itemkey => itemkey,
525: aname => 'FORWARD_TO_USERNAME');
526:
527: /* Bug# 1352995: kagarwal

Line 546: l_forward_to_username_disp:= wf_engine.GetItemAttrText (itemtype => itemtype,

542: */
543:
544: IF l_forward_to_username is NOT NULL THEN
545:
546: l_forward_to_username_disp:= wf_engine.GetItemAttrText (itemtype => itemtype,
547: itemkey => itemkey,
548: aname => 'FORWARD_TO_DISPLAY_NAME');
549:
550: l_forward_to_id:= wf_engine.GetItemAttrNumber (itemtype => itemtype,

Line 550: l_forward_to_id:= wf_engine.GetItemAttrNumber (itemtype => itemtype,

546: l_forward_to_username_disp:= wf_engine.GetItemAttrText (itemtype => itemtype,
547: itemkey => itemkey,
548: aname => 'FORWARD_TO_DISPLAY_NAME');
549:
550: l_forward_to_id:= wf_engine.GetItemAttrNumber (itemtype => itemtype,
551: itemkey => itemkey,
552: aname => 'FORWARD_TO_ID');
553: ELSE /* get the approver name who took this action */
554: l_forward_to_username:= wf_engine.GetItemAttrText (itemtype => itemtype,

Line 554: l_forward_to_username:= wf_engine.GetItemAttrText (itemtype => itemtype,

550: l_forward_to_id:= wf_engine.GetItemAttrNumber (itemtype => itemtype,
551: itemkey => itemkey,
552: aname => 'FORWARD_TO_ID');
553: ELSE /* get the approver name who took this action */
554: l_forward_to_username:= wf_engine.GetItemAttrText (itemtype => itemtype,
555: itemkey => itemkey,
556: aname => 'APPROVER_USER_NAME');
557:
558: l_forward_to_username_disp:= wf_engine.GetItemAttrText (itemtype => itemtype,

Line 558: l_forward_to_username_disp:= wf_engine.GetItemAttrText (itemtype => itemtype,

554: l_forward_to_username:= wf_engine.GetItemAttrText (itemtype => itemtype,
555: itemkey => itemkey,
556: aname => 'APPROVER_USER_NAME');
557:
558: l_forward_to_username_disp:= wf_engine.GetItemAttrText (itemtype => itemtype,
559: itemkey => itemkey,
560: aname => 'APPROVER_DISPLAY_NAME');
561:
562: l_forward_to_id:= wf_engine.GetItemAttrNumber (itemtype => itemtype,

Line 562: l_forward_to_id:= wf_engine.GetItemAttrNumber (itemtype => itemtype,

558: l_forward_to_username_disp:= wf_engine.GetItemAttrText (itemtype => itemtype,
559: itemkey => itemkey,
560: aname => 'APPROVER_DISPLAY_NAME');
561:
562: l_forward_to_id:= wf_engine.GetItemAttrNumber (itemtype => itemtype,
563: itemkey => itemkey,
564: aname => 'APPROVER_EMPID');
565: END IF;
566:

Line 577: l_preparer_id := wf_engine.GetItemAttrText(itemtype => itemtype,

573: IF (g_po_wf_debug = 'Y') THEN
574: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
575: END IF;
576:
577: l_preparer_id := wf_engine.GetItemAttrText(itemtype => itemtype,
578: itemkey => itemkey,
579: aname => 'PREPARER_ID');
580:
581: if (x_user_id = l_preparer_id) then

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

597:
598: fnd_message.set_name('PO', 'PO_WF_NOTIF_INVALID_FORWARD');
599: l_error_msg := fnd_message.get;
600:
601: wf_engine.SetItemAttrText (itemtype => itemtype,
602: itemkey => itemkey,
603: aname => 'REQUIRES_APPROVAL_MSG',
604: avalue => '');
605:

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

602: itemkey => itemkey,
603: aname => 'REQUIRES_APPROVAL_MSG',
604: avalue => '');
605:
606: wf_engine.SetItemAttrText (itemtype => itemtype,
607: itemkey => itemkey,
608: aname => 'WRONG_FORWARD_TO_MSG',
609: avalue => l_error_msg);
610:

Line 611: resultout := wf_engine.eng_completed || ':' || 'N';

607: itemkey => itemkey,
608: aname => 'WRONG_FORWARD_TO_MSG',
609: avalue => l_error_msg);
610:
611: resultout := wf_engine.eng_completed || ':' || 'N';
612:
613: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Is_Forward_To_Valid: 050';
614: IF (g_po_wf_debug = 'Y') THEN
615: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

Line 631: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

627: END IF;
628:
629:
630: /* Set the FORWARD_FROM */
631: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
632: itemkey => itemkey,
633: aname => 'FORWARD_FROM_ID',
634: avalue => l_forward_to_id);
635:

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

632: itemkey => itemkey,
633: aname => 'FORWARD_FROM_ID',
634: avalue => l_forward_to_id);
635:
636: wf_engine.SetItemAttrText ( itemtype => itemtype,
637: itemkey => itemkey,
638: aname => 'FORWARD_FROM_USER_NAME',
639: avalue => l_forward_to_username);
640:

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

637: itemkey => itemkey,
638: aname => 'FORWARD_FROM_USER_NAME',
639: avalue => l_forward_to_username);
640:
641: wf_engine.SetItemAttrText ( itemtype => itemtype,
642: itemkey => itemkey,
643: aname => 'FORWARD_FROM_DISP_NAME',
644: avalue => l_forward_to_username_disp);
645:

Line 649: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

645:
646: /* Set the approver to the person who took the action on the notification,
647: ** i.e. the old forward-to person
648: */
649: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
650: itemkey => itemkey,
651: aname => 'APPROVER_EMPID',
652: avalue => l_forward_to_id);
653:

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

650: itemkey => itemkey,
651: aname => 'APPROVER_EMPID',
652: avalue => l_forward_to_id);
653:
654: wf_engine.SetItemAttrText ( itemtype => itemtype,
655: itemkey => itemkey,
656: aname => 'APPROVER_USER_NAME',
657: avalue => l_forward_to_username);
658:

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

655: itemkey => itemkey,
656: aname => 'APPROVER_USER_NAME',
657: avalue => l_forward_to_username);
658:
659: wf_engine.SetItemAttrText ( itemtype => itemtype,
660: itemkey => itemkey,
661: aname => 'APPROVER_DISPLAY_NAME',
662: avalue => l_forward_to_username_disp);
663:

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

662: avalue => l_forward_to_username_disp);
663:
664: /* Set the FORWARD-TO */
665:
666: wf_engine.SetItemAttrText ( itemtype => itemtype,
667: itemkey => itemkey,
668: aname => 'FORWARD_TO_USERNAME',
669: avalue => l_forward_to_username_response);
670:

Line 671: wf_engine.SetItemAttrNumber ( itemtype => itemType,

667: itemkey => itemkey,
668: aname => 'FORWARD_TO_USERNAME',
669: avalue => l_forward_to_username_response);
670:
671: wf_engine.SetItemAttrNumber ( itemtype => itemType,
672: itemkey => itemkey,
673: aname => 'FORWARD_TO_ID',
674: avalue => x_user_id);
675:

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

673: aname => 'FORWARD_TO_ID',
674: avalue => x_user_id);
675:
676: /* Get the Display name for the user from the WF Directory */
677: wf_engine.SetItemAttrText ( itemtype => itemtype,
678: itemkey => itemkey,
679: aname => 'FORWARD_TO_DISPLAY_NAME',
680: avalue =>
681: wf_directory.GetRoleDisplayName(l_forward_to_username_response));

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

680: avalue =>
681: wf_directory.GetRoleDisplayName(l_forward_to_username_response));
682:
683: /* Reset the FORWARD_TO_USERNAME_RESPONSE attribute */
684: wf_engine.SetItemAttrText (itemtype => itemtype,
685: itemkey => itemkey,
686: aname => 'FORWARD_TO_USERNAME_RESPONSE',
687: avalue => NULL);
688:

Line 690: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,

686: aname => 'FORWARD_TO_USERNAME_RESPONSE',
687: avalue => NULL);
688:
689: /*Bug 9593873 Reset response note */
690: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
691: itemkey => itemkey,
692: aname => 'DOCUMENT_TYPE');
693: IF (l_document_type='PO' OR l_document_type='PA' OR l_document_type='RELEASE' ) THEN
694: l_note := PO_WF_UTIL_PKG.GetItemAttrText(itemtype=>itemtype,

Line 715: wf_engine.SetItemAttrText ( itemtype => itemType,

711: */
712: fnd_message.set_name ('PO','PO_WF_NOTIF_REQUIRES_APPROVAL');
713: l_error_msg := fnd_message.get;
714:
715: wf_engine.SetItemAttrText ( itemtype => itemType,
716: itemkey => itemkey,
717: aname => 'REQUIRES_APPROVAL_MSG' ,
718: avalue => l_error_msg);
719:

Line 720: wf_engine.SetItemAttrText ( itemtype => itemType,

716: itemkey => itemkey,
717: aname => 'REQUIRES_APPROVAL_MSG' ,
718: avalue => l_error_msg);
719:
720: wf_engine.SetItemAttrText ( itemtype => itemType,
721: itemkey => itemkey,
722: aname => 'WRONG_FORWARD_TO_MSG' ,
723: avalue => '');
724:

Line 726: resultout := wf_engine.eng_completed || ':' || 'Y';

722: aname => 'WRONG_FORWARD_TO_MSG' ,
723: avalue => '');
724:
725: --
726: resultout := wf_engine.eng_completed || ':' || 'Y';
727: --
728:
729: ELSE
730:

Line 742: wf_engine.SetItemAttrText ( itemtype => itemType,

738: */
739: fnd_message.set_name ('PO','PO_WF_NOTIF_INVALID_FORWARD');
740: l_error_msg := fnd_message.get;
741:
742: wf_engine.SetItemAttrText ( itemtype => itemType,
743: itemkey => itemkey,
744: aname => 'REQUIRES_APPROVAL_MSG' ,
745: avalue => '');
746:

Line 747: wf_engine.SetItemAttrText ( itemtype => itemType,

743: itemkey => itemkey,
744: aname => 'REQUIRES_APPROVAL_MSG' ,
745: avalue => '');
746:
747: wf_engine.SetItemAttrText ( itemtype => itemType,
748: itemkey => itemkey,
749: aname => 'WRONG_FORWARD_TO_MSG' ,
750: avalue => l_error_msg);
751:

Line 753: resultout := wf_engine.eng_completed || ':' || 'N';

749: aname => 'WRONG_FORWARD_TO_MSG' ,
750: avalue => l_error_msg);
751:
752: --
753: resultout := wf_engine.eng_completed || ':' || 'N';
754: --
755:
756: END IF;
757:

Line 795: if (funcmode <> wf_engine.eng_run) then

791:
792:
793: -- Do nothing in cancel or timeout mode
794: --
795: if (funcmode <> wf_engine.eng_run) then
796:
797: resultout := wf_engine.eng_null;
798: return;
799:

Line 797: resultout := wf_engine.eng_null;

793: -- Do nothing in cancel or timeout mode
794: --
795: if (funcmode <> wf_engine.eng_run) then
796:
797: resultout := wf_engine.eng_null;
798: return;
799:
800: end if;
801:

Line 803: l_forward_to_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

799:
800: end if;
801:
802:
803: l_forward_to_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
804: itemkey => itemkey,
805: aname => 'FORWARD_TO_ID');
806:
807: IF l_forward_to_id is NOT NULL THEN

Line 810: wf_engine.SetItemAttrNumber (itemtype => itemtype,

806:
807: IF l_forward_to_id is NOT NULL THEN
808:
809: /* Set the Approver to be the person receiving the approval notification */
810: wf_engine.SetItemAttrNumber (itemtype => itemtype,
811: itemkey => itemkey,
812: aname => 'APPROVER_EMPID',
813: avalue => l_forward_to_id);
814:

Line 815: resultout := wf_engine.eng_completed || ':' || 'Y';

811: itemkey => itemkey,
812: aname => 'APPROVER_EMPID',
813: avalue => l_forward_to_id);
814:
815: resultout := wf_engine.eng_completed || ':' || 'Y';
816:
817: ELSE
818:
819: resultout := wf_engine.eng_completed || ':' || 'N';

Line 819: resultout := wf_engine.eng_completed || ':' || 'N';

815: resultout := wf_engine.eng_completed || ':' || 'Y';
816:
817: ELSE
818:
819: resultout := wf_engine.eng_completed || ':' || 'N';
820:
821: END IF;
822:
823:

Line 873: if (funcmode <> wf_engine.eng_run) then

869:
870:
871: -- Do nothing in cancel or timeout mode
872: --
873: if (funcmode <> wf_engine.eng_run) then
874:
875: resultout := wf_engine.eng_null;
876: return;
877:

Line 875: resultout := wf_engine.eng_null;

871: -- Do nothing in cancel or timeout mode
872: --
873: if (funcmode <> wf_engine.eng_run) then
874:
875: resultout := wf_engine.eng_null;
876: return;
877:
878: end if;
879:

Line 880: l_user_name := wf_engine.GetItemAttrText (itemtype => itemtype,

876: return;
877:
878: end if;
879:
880: l_user_name := wf_engine.GetItemAttrText (itemtype => itemtype,
881: itemkey => itemkey,
882: aname => 'FORWARD_TO_USERNAME');
883:
884: IF l_user_name is NOT NULL THEN

Line 886: resultout := wf_engine.eng_completed || ':' || 'Y';

882: aname => 'FORWARD_TO_USERNAME');
883:
884: IF l_user_name is NOT NULL THEN
885:
886: resultout := wf_engine.eng_completed || ':' || 'Y';
887:
888: ELSE
889: l_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
890: itemkey => itemkey,

Line 889: l_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

885:
886: resultout := wf_engine.eng_completed || ':' || 'Y';
887:
888: ELSE
889: l_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
890: itemkey => itemkey,
891: aname => 'FORWARD_TO_ID');
892:
893: /* Bug# 1312794: kagarwal

Line 909: wf_engine.SetItemAttrText ( itemtype => itemType,

905: WHERE person_id = l_id
906: AND trunc(sysdate) BETWEEN effective_start_date
907: AND effective_end_date;
908:
909: wf_engine.SetItemAttrText ( itemtype => itemType,
910: itemkey => itemkey,
911: aname => 'APPROVER_DISPLAY_NAME' ,
912: avalue => l_disp_name);
913:

Line 914: resultout := wf_engine.eng_completed || ':' || 'N';

910: itemkey => itemkey,
911: aname => 'APPROVER_DISPLAY_NAME' ,
912: avalue => l_disp_name);
913:
914: resultout := wf_engine.eng_completed || ':' || 'N';
915:
916: END IF;
917:
918: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Is_forward_to_user_name_valid: 02';

Line 965: if (funcmode <> wf_engine.eng_run) then

961:
962:
963: -- Do nothing in cancel or timeout mode
964: --
965: if (funcmode <> wf_engine.eng_run) then
966:
967: resultout := wf_engine.eng_null;
968: return;
969:

Line 967: resultout := wf_engine.eng_null;

963: -- Do nothing in cancel or timeout mode
964: --
965: if (funcmode <> wf_engine.eng_run) then
966:
967: resultout := wf_engine.eng_null;
968: return;
969:
970: end if;
971:

Line 973: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,

969:
970: end if;
971:
972: -- Set the multi-org context
973: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
974: itemkey => itemkey,
975: aname => 'DOCUMENT_TYPE');
976: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
977: itemkey => itemkey,

Line 976: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

972: -- Set the multi-org context
973: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
974: itemkey => itemkey,
975: aname => 'DOCUMENT_TYPE');
976: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
977: itemkey => itemkey,
978: aname => 'DOCUMENT_ID');
979:
980: -- PO_REQAPPROVAL_INIT1.get_multiorg_context (l_document_type, l_document_id, x_orgid);

Line 981: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype,

977: itemkey => itemkey,
978: aname => 'DOCUMENT_ID');
979:
980: -- PO_REQAPPROVAL_INIT1.get_multiorg_context (l_document_type, l_document_id, x_orgid);
981: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype,
982: itemkey => itemkey,
983: aname => 'ORG_ID');
984:
985: IF l_orgid is NOT NULL THEN

Line 996: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';

992: PO_REQAPPROVAL_FINDAPPRV1.GetApprovalPathId(itemtype,itemkey);
993:
994:
995: --
996: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
997: --
998: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Get_approval_path_id: 02';
999: IF (g_po_wf_debug = 'Y') THEN
1000: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

Line 1043: if (funcmode <> wf_engine.eng_run) then

1039:
1040:
1041: -- Do nothing in cancel or timeout mode
1042: --
1043: if (funcmode <> wf_engine.eng_run) then
1044:
1045: resultout := wf_engine.eng_null;
1046: return;
1047:

Line 1045: resultout := wf_engine.eng_null;

1041: -- Do nothing in cancel or timeout mode
1042: --
1043: if (funcmode <> wf_engine.eng_run) then
1044:
1045: resultout := wf_engine.eng_null;
1046: return;
1047:
1048: end if;
1049:

Line 1051: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,

1047:
1048: end if;
1049:
1050: -- Set the multi-org context
1051: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
1052: itemkey => itemkey,
1053: aname => 'DOCUMENT_TYPE');
1054: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1055: itemkey => itemkey,

Line 1054: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

1050: -- Set the multi-org context
1051: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
1052: itemkey => itemkey,
1053: aname => 'DOCUMENT_TYPE');
1054: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1055: itemkey => itemkey,
1056: aname => 'DOCUMENT_ID');
1057:
1058: -- PO_REQAPPROVAL_INIT1.get_multiorg_context (l_document_type, l_document_id,x_orgid);

Line 1060: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype,

1056: aname => 'DOCUMENT_ID');
1057:
1058: -- PO_REQAPPROVAL_INIT1.get_multiorg_context (l_document_type, l_document_id,x_orgid);
1059:
1060: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1061: itemkey => itemkey,
1062: aname => 'ORG_ID');
1063:
1064: IF l_orgid is NOT NULL THEN

Line 1075: resultout := wf_engine.eng_completed || ':' || 'DIRECT';

1071: l_forward_mode := PO_REQAPPROVAL_FINDAPPRV1.GetForwardMode(itemtype, itemkey);
1072:
1073: IF l_forward_mode = 'DIRECT' THEN
1074:
1075: resultout := wf_engine.eng_completed || ':' || 'DIRECT';
1076:
1077: ELSIF l_forward_mode = 'HIERARCHY' THEN
1078:
1079: resultout := wf_engine.eng_completed || ':' || 'HIERARCHY';

Line 1079: resultout := wf_engine.eng_completed || ':' || 'HIERARCHY';

1075: resultout := wf_engine.eng_completed || ':' || 'DIRECT';
1076:
1077: ELSIF l_forward_mode = 'HIERARCHY' THEN
1078:
1079: resultout := wf_engine.eng_completed || ':' || 'HIERARCHY';
1080:
1081: END IF;
1082:
1083: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Get_Forward_mode: 02';

Line 1127: if (funcmode <> wf_engine.eng_run) then

1123:
1124:
1125: -- Do nothing in cancel or timeout mode
1126: --
1127: if (funcmode <> wf_engine.eng_run) then
1128:
1129: resultout := wf_engine.eng_null;
1130: return;
1131:

Line 1129: resultout := wf_engine.eng_null;

1125: -- Do nothing in cancel or timeout mode
1126: --
1127: if (funcmode <> wf_engine.eng_run) then
1128:
1129: resultout := wf_engine.eng_null;
1130: return;
1131:
1132: end if;
1133:

Line 1135: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,

1131:
1132: end if;
1133:
1134: -- Set the multi-org context
1135: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
1136: itemkey => itemkey,
1137: aname => 'DOCUMENT_TYPE');
1138: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1139: itemkey => itemkey,

Line 1138: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

1134: -- Set the multi-org context
1135: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
1136: itemkey => itemkey,
1137: aname => 'DOCUMENT_TYPE');
1138: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1139: itemkey => itemkey,
1140: aname => 'DOCUMENT_ID');
1141:
1142: -- PO_REQAPPROVAL_INIT1.get_multiorg_context (l_document_type, l_document_id,x_orgid);

Line 1143: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype,

1139: itemkey => itemkey,
1140: aname => 'DOCUMENT_ID');
1141:
1142: -- PO_REQAPPROVAL_INIT1.get_multiorg_context (l_document_type, l_document_id,x_orgid);
1143: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1144: itemkey => itemkey,
1145: aname => 'ORG_ID');
1146:
1147: IF l_orgid is NOT NULL THEN

Line 1158: resultout := wf_engine.eng_completed || ':' || 'Y';

1154: l_use_positions_flag := PO_REQAPPROVAL_FINDAPPRV1.UsePositionFlag;
1155:
1156: IF l_use_positions_flag = 'Y' THEN
1157:
1158: resultout := wf_engine.eng_completed || ':' || 'Y';
1159:
1160: ELSIF l_use_positions_flag = 'N' THEN
1161:
1162: resultout := wf_engine.eng_completed || ':' || 'N';

Line 1162: resultout := wf_engine.eng_completed || ':' || 'N';

1158: resultout := wf_engine.eng_completed || ':' || 'Y';
1159:
1160: ELSIF l_use_positions_flag = 'N' THEN
1161:
1162: resultout := wf_engine.eng_completed || ':' || 'N';
1163:
1164: END IF;
1165:
1166: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Use_Position_flag: 02';

Line 1212: if (funcmode <> wf_engine.eng_run) then

1208:
1209:
1210: -- Do nothing in cancel or timeout mode
1211: --
1212: if (funcmode <> wf_engine.eng_run) then
1213:
1214: resultout := wf_engine.eng_null;
1215: return;
1216:

Line 1214: resultout := wf_engine.eng_null;

1210: -- Do nothing in cancel or timeout mode
1211: --
1212: if (funcmode <> wf_engine.eng_run) then
1213:
1214: resultout := wf_engine.eng_null;
1215: return;
1216:
1217: end if;
1218:

Line 1220: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,

1216:
1217: end if;
1218:
1219: -- Set the multi-org context
1220: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
1221: itemkey => itemkey,
1222: aname => 'DOCUMENT_TYPE');
1223: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1224: itemkey => itemkey,

Line 1223: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

1219: -- Set the multi-org context
1220: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
1221: itemkey => itemkey,
1222: aname => 'DOCUMENT_TYPE');
1223: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1224: itemkey => itemkey,
1225: aname => 'DOCUMENT_ID');
1226:
1227: -- PO_REQAPPROVAL_INIT1.get_multiorg_context (l_document_type, l_document_id,x_orgid);

Line 1229: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype,

1225: aname => 'DOCUMENT_ID');
1226:
1227: -- PO_REQAPPROVAL_INIT1.get_multiorg_context (l_document_type, l_document_id,x_orgid);
1228:
1229: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1230: itemkey => itemkey,
1231: aname => 'ORG_ID');
1232:
1233: IF l_orgid is NOT NULL THEN

Line 1245: resultout := wf_engine.eng_completed || ':' || 'Y';

1241: l_found_manager := PO_REQAPPROVAL_FINDAPPRV1.GetMgrHRHier(itemtype, itemkey);
1242:
1243: IF l_found_manager = 'Y' THEN
1244:
1245: resultout := wf_engine.eng_completed || ':' || 'Y';
1246: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.GetMgr_hr_hier: RESULT=Y';
1247:
1248: ELSIF l_found_manager = 'N' THEN
1249:

Line 1250: resultout := wf_engine.eng_completed || ':' || 'N';

1246: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.GetMgr_hr_hier: RESULT=Y';
1247:
1248: ELSIF l_found_manager = 'N' THEN
1249:
1250: resultout := wf_engine.eng_completed || ':' || 'N';
1251: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.GetMgr_hr_hier: RESULT=N';
1252:
1253: END IF;
1254:

Line 1301: if (funcmode <> wf_engine.eng_run) then

1297:
1298:
1299: -- Do nothing in cancel or timeout mode
1300: --
1301: if (funcmode <> wf_engine.eng_run) then
1302:
1303: resultout := wf_engine.eng_null;
1304: return;
1305:

Line 1303: resultout := wf_engine.eng_null;

1299: -- Do nothing in cancel or timeout mode
1300: --
1301: if (funcmode <> wf_engine.eng_run) then
1302:
1303: resultout := wf_engine.eng_null;
1304: return;
1305:
1306: end if;
1307:

Line 1309: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,

1305:
1306: end if;
1307:
1308: -- Set the multi-org context
1309: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
1310: itemkey => itemkey,
1311: aname => 'DOCUMENT_TYPE');
1312: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1313: itemkey => itemkey,

Line 1312: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

1308: -- Set the multi-org context
1309: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
1310: itemkey => itemkey,
1311: aname => 'DOCUMENT_TYPE');
1312: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1313: itemkey => itemkey,
1314: aname => 'DOCUMENT_ID');
1315:
1316: -- PO_REQAPPROVAL_INIT1.get_multiorg_context (l_document_type, l_document_id, x_orgid);

Line 1317: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype,

1313: itemkey => itemkey,
1314: aname => 'DOCUMENT_ID');
1315:
1316: -- PO_REQAPPROVAL_INIT1.get_multiorg_context (l_document_type, l_document_id, x_orgid);
1317: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1318: itemkey => itemkey,
1319: aname => 'ORG_ID');
1320:
1321: IF l_orgid is NOT NULL THEN

Line 1332: resultout := wf_engine.eng_completed || ':' || 'Y';

1328: l_found_manager := PO_REQAPPROVAL_FINDAPPRV1.GetMgrPOHier(itemtype, itemkey);
1329:
1330: IF l_found_manager = 'Y' THEN
1331:
1332: resultout := wf_engine.eng_completed || ':' || 'Y';
1333: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.GetMgr_po_hier: RESULT=Y';
1334:
1335: ELSIF l_found_manager = 'N' THEN
1336:

Line 1337: resultout := wf_engine.eng_completed || ':' || 'N';

1333: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.GetMgr_po_hier: RESULT=Y';
1334:
1335: ELSIF l_found_manager = 'N' THEN
1336:
1337: resultout := wf_engine.eng_completed || ':' || 'N';
1338: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.GetMgr_po_hier: RESULT=N';
1339:
1340: END IF;
1341:

Line 1397: l_forward_to_username_response := wf_engine.GetItemAttrText (itemtype => itemtype,

1393: ** referenced in the message attribute).
1394: ** It should also return that id.
1395: */
1396:
1397: l_forward_to_username_response := wf_engine.GetItemAttrText (itemtype => itemtype,
1398: itemkey => itemkey,
1399: aname => 'FORWARD_TO_USERNAME_RESPONSE');
1400:
1401: /* If there is no Forward-to provided in the notification, then the forward_to_id

Line 1428: wf_engine.SetItemAttrText ( itemtype => itemType,

1424: IF (g_po_wf_debug = 'Y') THEN
1425: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1426: END IF;
1427:
1428: wf_engine.SetItemAttrText ( itemtype => itemType,
1429: itemkey => itemkey,
1430: aname => 'FORWARD_TO_USERNAME',
1431: avalue => l_forward_to_username_response);
1432:

Line 1433: wf_engine.SetItemAttrNumber ( itemtype => itemType,

1429: itemkey => itemkey,
1430: aname => 'FORWARD_TO_USERNAME',
1431: avalue => l_forward_to_username_response);
1432:
1433: wf_engine.SetItemAttrNumber ( itemtype => itemType,
1434: itemkey => itemkey,
1435: aname => 'FORWARD_TO_ID',
1436: avalue => l_forward_to_id);
1437:

Line 1456: l_forward_to_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

1452: IF (g_po_wf_debug = 'Y') THEN
1453: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1454: END IF;
1455:
1456: l_forward_to_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1457: itemkey => itemkey,
1458: aname => 'FORWARD_TO_ID');
1459: END IF;
1460:

Line 1462: wf_engine.SetItemAttrText ( itemtype => itemType,

1458: aname => 'FORWARD_TO_ID');
1459: END IF;
1460:
1461: /* Reset the value of the forward_to RESPONSE attribute */
1462: wf_engine.SetItemAttrText ( itemtype => itemType,
1463: itemkey => itemkey,
1464: aname => 'FORWARD_TO_USERNAME_RESPONSE',
1465: avalue => NULL);
1466:

Line 1467: l_forward_to_id_old := wf_engine.GetItemAttrNumber (itemtype => itemtype,

1463: itemkey => itemkey,
1464: aname => 'FORWARD_TO_USERNAME_RESPONSE',
1465: avalue => NULL);
1466:
1467: l_forward_to_id_old := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1468: itemkey => itemkey,
1469: aname => 'FORWARD_TO_ID_OLD');
1470:
1471: IF ( NVL(l_forward_to_id,0) <> NVL(l_forward_to_id_old,0) ) THEN

Line 1476: wf_engine.SetItemAttrNumber ( itemtype => itemType,

1472:
1473: -- x_progress:= '006';
1474:
1475: /* Set the old value equal to the new value */
1476: wf_engine.SetItemAttrNumber ( itemtype => itemType,
1477: itemkey => itemkey,
1478: aname => 'FORWARD_TO_ID_OLD',
1479: avalue => l_forward_to_id);
1480:

Line 1591: l_approval_path_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

1587: x_progress varchar2(200) := '000';
1588: BEGIN
1589:
1590: x_progress := '001';
1591: l_approval_path_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1592: itemkey => itemkey,
1593: aname => 'APPROVAL_PATH_ID');
1594:
1595: /* If No Approval Path was specified by the user, then get the default */

Line 1599: l_document_type_code := wf_engine.GetItemAttrText (itemtype => itemtype,

1595: /* If No Approval Path was specified by the user, then get the default */
1596:
1597: IF l_approval_path_id is NULL THEN
1598:
1599: l_document_type_code := wf_engine.GetItemAttrText (itemtype => itemtype,
1600: itemkey => itemkey,
1601: aname => 'DOCUMENT_TYPE');
1602:
1603: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 1603: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,

1599: l_document_type_code := wf_engine.GetItemAttrText (itemtype => itemtype,
1600: itemkey => itemkey,
1601: aname => 'DOCUMENT_TYPE');
1602:
1603: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
1604: itemkey => itemkey,
1605: aname => 'DOCUMENT_SUBTYPE');
1606:
1607: x_progress := '002';

Line 1614: wf_engine.SetItemAttrNumber (itemtype => itemtype,

1610: FROM po_document_types podt
1611: WHERE podt.document_type_code = l_document_type_code
1612: AND podt.document_subtype = l_document_subtype;
1613:
1614: wf_engine.SetItemAttrNumber (itemtype => itemtype,
1615: itemkey => itemkey,
1616: aname => 'APPROVAL_PATH_ID',
1617: avalue => l_approval_path_id);
1618:

Line 1647: l_document_type_code := wf_engine.GetItemAttrText (itemtype => itemtype,

1643: x_progress varchar2(3) := '000';
1644: BEGIN
1645:
1646: x_progress := '001';
1647: l_document_type_code := wf_engine.GetItemAttrText (itemtype => itemtype,
1648: itemkey => itemkey,
1649: aname => 'DOCUMENT_TYPE');
1650:
1651: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 1651: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,

1647: l_document_type_code := wf_engine.GetItemAttrText (itemtype => itemtype,
1648: itemkey => itemkey,
1649: aname => 'DOCUMENT_TYPE');
1650:
1651: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
1652: itemkey => itemkey,
1653: aname => 'DOCUMENT_SUBTYPE');
1654:
1655: SELECT FORWARDING_MODE_CODE into l_forward_mode

Line 1813: l_empid := wf_engine.GetItemAttrNumber (itemtype => itemtype,

1809: /* Get the employee whos manager we need to find. This is always
1810: ** kept in APPROVER_EMPID.
1811: */
1812:
1813: l_empid := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1814: itemkey => itemkey,
1815: aname => 'APPROVER_EMPID');
1816: SELECT business_group_id
1817: INTO l_business_group_id

Line 1880: l_forward_from_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

1876: ** At this point, we find an approver, so we need to set the forward-from
1877: ** to be the last person that took the APPROVE action.
1878: */
1879:
1880: l_forward_from_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1881: itemkey => itemkey,
1882: aname => 'FORWARD_FROM_ID');
1883:
1884: IF l_forward_from_id is NULL THEN

Line 1887: l_forward_from_username := wf_engine.GetItemAttrText ( itemtype => itemType,

1883:
1884: IF l_forward_from_id is NULL THEN
1885:
1886: /* Get the previous approver username and display name */
1887: l_forward_from_username := wf_engine.GetItemAttrText ( itemtype => itemType,
1888: itemkey => itemkey,
1889: aname => 'APPROVER_USER_NAME');
1890:
1891: l_forward_from_disp_name := wf_engine.GetItemAttrText ( itemtype => itemType,

Line 1891: l_forward_from_disp_name := wf_engine.GetItemAttrText ( itemtype => itemType,

1887: l_forward_from_username := wf_engine.GetItemAttrText ( itemtype => itemType,
1888: itemkey => itemkey,
1889: aname => 'APPROVER_USER_NAME');
1890:
1891: l_forward_from_disp_name := wf_engine.GetItemAttrText ( itemtype => itemType,
1892: itemkey => itemkey,
1893: aname => 'APPROVER_DISPLAY_NAME');
1894:
1895: /* Set the forward-from username and display name to that of the previous

Line 1898: wf_engine.SetItemAttrText ( itemtype => itemType,

1894:
1895: /* Set the forward-from username and display name to that of the previous
1896: ** approver.
1897: */
1898: wf_engine.SetItemAttrText ( itemtype => itemType,
1899: itemkey => itemkey,
1900: aname => 'FORWARD_FROM_ID' ,
1901: avalue => l_empid);
1902:

Line 1903: wf_engine.SetItemAttrText ( itemtype => itemType,

1899: itemkey => itemkey,
1900: aname => 'FORWARD_FROM_ID' ,
1901: avalue => l_empid);
1902:
1903: wf_engine.SetItemAttrText ( itemtype => itemType,
1904: itemkey => itemkey,
1905: aname => 'FORWARD_FROM_USER_NAME' ,
1906: avalue => l_forward_from_username);
1907:

Line 1908: wf_engine.SetItemAttrText ( itemtype => itemType,

1904: itemkey => itemkey,
1905: aname => 'FORWARD_FROM_USER_NAME' ,
1906: avalue => l_forward_from_username);
1907:
1908: wf_engine.SetItemAttrText ( itemtype => itemType,
1909: itemkey => itemkey,
1910: aname => 'FORWARD_FROM_DISP_NAME' ,
1911: avalue => l_forward_from_disp_name);
1912:

Line 1924: wf_engine.SetItemAttrNumber (itemtype => itemtype,

1920: **
1921: ** NOTE: Activity "Verify Authority" always uses the APPROVER_EMPID attribute
1922: ** as the approver.
1923: */
1924: wf_engine.SetItemAttrNumber (itemtype => itemtype,
1925: itemkey => itemkey,
1926: aname => 'APPROVER_EMPID',
1927: avalue => l_superior_id);
1928:

Line 1930: wf_engine.SetItemAttrNumber (itemtype => itemtype,

1926: aname => 'APPROVER_EMPID',
1927: avalue => l_superior_id);
1928:
1929: /* Set the forward-to ID. This is the approver that will get the notification */
1930: wf_engine.SetItemAttrNumber (itemtype => itemtype,
1931: itemkey => itemkey,
1932: aname => 'FORWARD_TO_ID',
1933: avalue => l_superior_id);
1934:

Line 1938: wf_engine.SetItemAttrNumber ( itemtype => itemType,

1934:
1935: /* Set the value of FORWARD_TO_ID_OLD. This is used to determine if the responder
1936: ** to the notification entered a different USERNAME to forward the doc to.
1937: */
1938: wf_engine.SetItemAttrNumber ( itemtype => itemType,
1939: itemkey => itemkey,
1940: aname => 'FORWARD_TO_ID_OLD',
1941: avalue => l_superior_id);
1942:

Line 1949: wf_engine.SetItemAttrText ( itemtype => itemType,

1945: /* Commented out the call since we have already got the username */
1946: /*PO_REQAPPROVAL_INIT1.get_user_name(l_superior_id, x_username,
1947: x_user_display_name);*/
1948:
1949: wf_engine.SetItemAttrText ( itemtype => itemType,
1950: itemkey => itemkey,
1951: aname => 'FORWARD_TO_USERNAME' ,
1952: avalue => x_username);
1953:

Line 1954: wf_engine.SetItemAttrText ( itemtype => itemType,

1950: itemkey => itemkey,
1951: aname => 'FORWARD_TO_USERNAME' ,
1952: avalue => x_username);
1953:
1954: wf_engine.SetItemAttrText ( itemtype => itemType,
1955: itemkey => itemkey,
1956: aname => 'FORWARD_TO_DISPLAY_NAME' ,
1957: avalue => x_user_display_name);
1958:

Line 1959: wf_engine.SetItemAttrText ( itemtype => itemType,

1955: itemkey => itemkey,
1956: aname => 'FORWARD_TO_DISPLAY_NAME' ,
1957: avalue => x_user_display_name);
1958:
1959: wf_engine.SetItemAttrText ( itemtype => itemType,
1960: itemkey => itemkey,
1961: aname => 'APPROVER_USER_NAME' ,
1962: avalue => x_username);
1963:

Line 1964: wf_engine.SetItemAttrText ( itemtype => itemType,

1960: itemkey => itemkey,
1961: aname => 'APPROVER_USER_NAME' ,
1962: avalue => x_username);
1963:
1964: wf_engine.SetItemAttrText ( itemtype => itemType,
1965: itemkey => itemkey,
1966: aname => 'APPROVER_DISPLAY_NAME' ,
1967: avalue => x_user_display_name);
1968:

Line 2076: l_empid := wf_engine.GetItemAttrNumber (itemtype => itemtype,

2072: x_progress varchar2(200) := NULL;
2073: BEGIN
2074:
2075:
2076: l_empid := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2077: itemkey => itemkey,
2078: aname => 'APPROVER_EMPID');
2079:
2080: l_approval_path_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

Line 2080: l_approval_path_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

2076: l_empid := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2077: itemkey => itemkey,
2078: aname => 'APPROVER_EMPID');
2079:
2080: l_approval_path_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2081: itemkey => itemkey,
2082: aname => 'APPROVAL_PATH_ID');
2083:
2084: x_progress := '001';

Line 2134: l_forward_from_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

2130: ** At this point, we find an approver, so we need to set the forward-from
2131: ** to be the last person that took the APPROVE action.
2132: */
2133:
2134: l_forward_from_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2135: itemkey => itemkey,
2136: aname => 'FORWARD_FROM_ID');
2137:
2138: IF l_forward_from_id is NULL THEN

Line 2141: l_forward_from_username := wf_engine.GetItemAttrText ( itemtype => itemType,

2137:
2138: IF l_forward_from_id is NULL THEN
2139:
2140: /* Get the previous approver username and display name */
2141: l_forward_from_username := wf_engine.GetItemAttrText ( itemtype => itemType,
2142: itemkey => itemkey,
2143: aname => 'APPROVER_USER_NAME');
2144:
2145: l_forward_from_disp_name := wf_engine.GetItemAttrText ( itemtype => itemType,

Line 2145: l_forward_from_disp_name := wf_engine.GetItemAttrText ( itemtype => itemType,

2141: l_forward_from_username := wf_engine.GetItemAttrText ( itemtype => itemType,
2142: itemkey => itemkey,
2143: aname => 'APPROVER_USER_NAME');
2144:
2145: l_forward_from_disp_name := wf_engine.GetItemAttrText ( itemtype => itemType,
2146: itemkey => itemkey,
2147: aname => 'APPROVER_DISPLAY_NAME');
2148:
2149: /* Set the forward-from username and display name to that of the previous

Line 2152: wf_engine.SetItemAttrText ( itemtype => itemType,

2148:
2149: /* Set the forward-from username and display name to that of the previous
2150: ** approver.
2151: */
2152: wf_engine.SetItemAttrText ( itemtype => itemType,
2153: itemkey => itemkey,
2154: aname => 'FORWARD_FROM_ID' ,
2155: avalue => l_empid);
2156:

Line 2157: wf_engine.SetItemAttrText ( itemtype => itemType,

2153: itemkey => itemkey,
2154: aname => 'FORWARD_FROM_ID' ,
2155: avalue => l_empid);
2156:
2157: wf_engine.SetItemAttrText ( itemtype => itemType,
2158: itemkey => itemkey,
2159: aname => 'FORWARD_FROM_USER_NAME' ,
2160: avalue => l_forward_from_username);
2161:

Line 2162: wf_engine.SetItemAttrText ( itemtype => itemType,

2158: itemkey => itemkey,
2159: aname => 'FORWARD_FROM_USER_NAME' ,
2160: avalue => l_forward_from_username);
2161:
2162: wf_engine.SetItemAttrText ( itemtype => itemType,
2163: itemkey => itemkey,
2164: aname => 'FORWARD_FROM_DISP_NAME' ,
2165: avalue => l_forward_from_disp_name);
2166:

Line 2178: wf_engine.SetItemAttrNumber (itemtype => itemtype,

2174: **
2175: ** NOTE: Activity "Verify Authority" always uses the APPROVER_EMPID attribute
2176: ** as the approver.
2177: */
2178: wf_engine.SetItemAttrNumber (itemtype => itemtype,
2179: itemkey => itemkey,
2180: aname => 'APPROVER_EMPID',
2181: avalue => l_superior_id);
2182:

Line 2184: wf_engine.SetItemAttrNumber (itemtype => itemtype,

2180: aname => 'APPROVER_EMPID',
2181: avalue => l_superior_id);
2182:
2183: /* Set the forward-to ID. This is the approver that will get the notification */
2184: wf_engine.SetItemAttrNumber (itemtype => itemtype,
2185: itemkey => itemkey,
2186: aname => 'FORWARD_TO_ID',
2187: avalue => l_superior_id);
2188:

Line 2192: wf_engine.SetItemAttrNumber ( itemtype => itemType,

2188:
2189: /* Set the value of FORWARD_TO_ID_OLD. This is used to determine if the responder
2190: ** to the notification entered a different USERNAME to forward the doc to.
2191: */
2192: wf_engine.SetItemAttrNumber ( itemtype => itemType,
2193: itemkey => itemkey,
2194: aname => 'FORWARD_TO_ID_OLD',
2195: avalue => l_superior_id);
2196:

Line 2202: wf_engine.SetItemAttrText ( itemtype => itemType,

2198: ** performer of the notification */
2199: /*PO_REQAPPROVAL_INIT1.get_user_name(l_superior_id, x_username,
2200: x_user_display_name);*/
2201:
2202: wf_engine.SetItemAttrText ( itemtype => itemType,
2203: itemkey => itemkey,
2204: aname => 'FORWARD_TO_USERNAME' ,
2205: avalue => x_username);
2206:

Line 2207: wf_engine.SetItemAttrText ( itemtype => itemType,

2203: itemkey => itemkey,
2204: aname => 'FORWARD_TO_USERNAME' ,
2205: avalue => x_username);
2206:
2207: wf_engine.SetItemAttrText ( itemtype => itemType,
2208: itemkey => itemkey,
2209: aname => 'FORWARD_TO_DISPLAY_NAME' ,
2210: avalue => x_user_display_name);
2211:

Line 2212: wf_engine.SetItemAttrText ( itemtype => itemType,

2208: itemkey => itemkey,
2209: aname => 'FORWARD_TO_DISPLAY_NAME' ,
2210: avalue => x_user_display_name);
2211:
2212: wf_engine.SetItemAttrText ( itemtype => itemType,
2213: itemkey => itemkey,
2214: aname => 'APPROVER_USER_NAME' ,
2215: avalue => x_username);
2216:

Line 2217: wf_engine.SetItemAttrText ( itemtype => itemType,

2213: itemkey => itemkey,
2214: aname => 'APPROVER_USER_NAME' ,
2215: avalue => x_username);
2216:
2217: wf_engine.SetItemAttrText ( itemtype => itemType,
2218: itemkey => itemkey,
2219: aname => 'APPROVER_DISPLAY_NAME' ,
2220: avalue => x_user_display_name);
2221:

Line 2262: l_document_type_code := wf_engine.GetItemAttrText (itemtype => itemtype,

2258: x_progress varchar2(3):= '000';
2259:
2260: BEGIN
2261: x_progress := '001';
2262: l_document_type_code := wf_engine.GetItemAttrText (itemtype => itemtype,
2263: itemkey => itemkey,
2264: aname => 'DOCUMENT_TYPE');
2265:
2266: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 2266: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,

2262: l_document_type_code := wf_engine.GetItemAttrText (itemtype => itemtype,
2263: itemkey => itemkey,
2264: aname => 'DOCUMENT_TYPE');
2265:
2266: l_document_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
2267: itemkey => itemkey,
2268: aname => 'DOCUMENT_SUBTYPE');
2269:
2270: open C1(l_document_type_code, l_document_subtype);