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.PSP_ER_WORKFLOW dependencies on WF_ENGINE

Line 30: wf_engine.GetItemAttrText(itemtype => itemtype,

26: l_error_count integer;
27: begin
28: ---hr_utility.trace_on('Y','WF-1');
29: l_request_id :=
30: wf_engine.GetItemAttrText(itemtype => itemtype,
31: itemkey => itemkey,
32: aname => 'REQUEST_ID');
33:
34: l_retry_request_id := wf_engine.GetItemAttrText(itemtype => itemtype,

Line 34: l_retry_request_id := wf_engine.GetItemAttrText(itemtype => itemtype,

30: wf_engine.GetItemAttrText(itemtype => itemtype,
31: itemkey => itemkey,
32: aname => 'REQUEST_ID');
33:
34: l_retry_request_id := wf_engine.GetItemAttrText(itemtype => itemtype,
35: itemkey => itemkey,
36: aname => 'RETRY_REQUEST_ID');
37:
38: hr_utility.trace('er_workflow --> FATAL error .. request_id = '||l_request_id);

Line 152: wf_engine.GetItemAttrText(itemtype => itemtype,

148: and approval_type = 'PRE';
149: l_flag integer;
150: begin
151: l_request_id :=
152: wf_engine.GetItemAttrText(itemtype => itemtype,
153: itemkey => itemkey,
154: aname => 'REQUEST_ID');
155: update psp_report_templates_h
156: set initiator_accept_flag = 'Y'

Line 191: wf_engine.GetItemAttrText(itemtype => itemtype,

187: result out nocopy varchar2) is
188: l_request_id integer;
189: begin
190: l_request_id :=
191: wf_engine.GetItemAttrText(itemtype => itemtype,
192: itemkey => itemkey,
193: aname => 'REQUEST_ID');
194: update psp_report_templates_h
195: set initiator_accept_flag = 'N'

Line 251: wf_engine.GetItemAttrText(itemtype => itemtype,

247: ---hr_utility.trace_on('Y','WF-1');
248: hr_utility.trace('er_workflow --> 100');
249: if funcmode = 'RUN' then
250: l_initiator_rname :=
251: wf_engine.GetItemAttrText(itemtype => itemtype,
252: itemkey => itemkey,
253: aname => 'INITIATOR');
254:
255: l_request_id :=

Line 256: wf_engine.GetItemAttrText(itemtype => itemtype,

252: itemkey => itemkey,
253: aname => 'INITIATOR');
254:
255: l_request_id :=
256: wf_engine.GetItemAttrText(itemtype => itemtype,
257: itemkey => itemkey,
258: aname => 'REQUEST_ID');
259:
260: l_start_date :=

Line 261: wf_engine.GetItemAttrText(itemtype => itemtype,

257: itemkey => itemkey,
258: aname => 'REQUEST_ID');
259:
260: l_start_date :=
261: wf_engine.GetItemAttrText(itemtype => itemtype,
262: itemkey => itemkey,
263: aname => 'START_DATE');
264: l_end_date :=
265: wf_engine.GetItemAttrText(itemtype => itemtype,

Line 265: wf_engine.GetItemAttrText(itemtype => itemtype,

261: wf_engine.GetItemAttrText(itemtype => itemtype,
262: itemkey => itemkey,
263: aname => 'START_DATE');
264: l_end_date :=
265: wf_engine.GetItemAttrText(itemtype => itemtype,
266: itemkey => itemkey,
267: aname => 'END_DATE');
268:
269: l_template_name :=

Line 270: wf_engine.GetItemAttrText(itemtype => itemtype,

266: itemkey => itemkey,
267: aname => 'END_DATE');
268:
269: l_template_name :=
270: wf_engine.GetItemAttrText(itemtype => itemtype,
271: itemkey => itemkey,
272: aname => 'TEMPLATE_NAME');
273:
274: l_time_out :=

Line 275: wf_engine.GetItemAttrNumber(itemtype => itemtype,

271: itemkey => itemkey,
272: aname => 'TEMPLATE_NAME');
273:
274: l_time_out :=
275: wf_engine.GetItemAttrNumber(itemtype => itemtype,
276: itemkey => itemkey,
277: aname => 'TIMEOUT');
278:
279: l_param_string :=

Line 280: wf_engine.GetItemAttrText(itemtype => itemtype,

276: itemkey => itemkey,
277: aname => 'TIMEOUT');
278:
279: l_param_string :=
280: wf_engine.GetItemAttrText(itemtype => itemtype,
281: itemkey => itemkey,
282: aname => 'CONC_PARAM_STRING');
283:
284:

Line 319: wf_engine.CreateProcess(itemtype => 'PSPERAVL',

315: end if;
316: -- call workflow
317: --dbms_output.put_line('FROM INIT - item key ='||wf_ikey_array(k));
318:
319: wf_engine.CreateProcess(itemtype => 'PSPERAVL',
320: itemkey => wf_ikey_array(k),
321: process => 'APPROVER_WORKFLOW');
322:
323: /*Added for bug 7004679 */

Line 324: wf_engine.setitemowner(itemtype => 'PSPERAVL',

320: itemkey => wf_ikey_array(k),
321: process => 'APPROVER_WORKFLOW');
322:
323: /*Added for bug 7004679 */
324: wf_engine.setitemowner(itemtype => 'PSPERAVL',
325: itemkey => wf_ikey_array(k),
326: owner => wf_rname_array(k));
327:
328:

Line 329: wf_engine.SetItemParent(itemType => 'PSPERAVL',

325: itemkey => wf_ikey_array(k),
326: owner => wf_rname_array(k));
327:
328:
329: wf_engine.SetItemParent(itemType => 'PSPERAVL',
330: itemKey => wf_ikey_array(k),
331: parent_ItemType => itemType,
332: parent_ItemKey => itemKey,
333: parent_context => null);

Line 335: wf_engine.SetItemAttrNumber(itemtype => 'PSPERAVL',

331: parent_ItemType => itemType,
332: parent_ItemKey => itemKey,
333: parent_context => null);
334:
335: wf_engine.SetItemAttrNumber(itemtype => 'PSPERAVL',
336: itemkey => wf_ikey_array(k),
337: aname => 'REQUEST_ID',
338: avalue => l_request_id);
339:

Line 340: wf_engine.SetItemAttrNumber(itemtype => 'PSPERAVL',

336: itemkey => wf_ikey_array(k),
337: aname => 'REQUEST_ID',
338: avalue => l_request_id);
339:
340: wf_engine.SetItemAttrNumber(itemtype => 'PSPERAVL',
341: itemkey => wf_ikey_array(k),
342: aname => 'APPROVER_ORDER_NUM',
343: avalue => 1);
344:

Line 345: wf_engine.SetItemAttrNumber(itemtype => 'PSPERAVL',

341: itemkey => wf_ikey_array(k),
342: aname => 'APPROVER_ORDER_NUM',
343: avalue => 1);
344:
345: wf_engine.SetItemAttrNumber(itemtype => 'PSPERAVL',
346: itemkey => wf_ikey_array(k),
347: aname => 'TIMEOUT',
348: avalue => l_time_out);
349:

Line 350: wf_engine.SetItemAttrText(itemtype => 'PSPERAVL',

346: itemkey => wf_ikey_array(k),
347: aname => 'TIMEOUT',
348: avalue => l_time_out);
349:
350: wf_engine.SetItemAttrText(itemtype => 'PSPERAVL',
351: itemkey => wf_ikey_array(k),
352: aname => 'INITIATOR',
353: avalue => l_initiator_rname);
354:

Line 355: wf_engine.SetItemAttrText(itemtype => 'PSPERAVL',

351: itemkey => wf_ikey_array(k),
352: aname => 'INITIATOR',
353: avalue => l_initiator_rname);
354:
355: wf_engine.SetItemAttrText(itemtype => 'PSPERAVL',
356: itemkey => wf_ikey_array(k),
357: aname => 'ITEM_KEY',
358: avalue => wf_ikey_array(k));
359:

Line 360: wf_engine.SetItemAttrText(itemType => 'PSPERAVL',

356: itemkey => wf_ikey_array(k),
357: aname => 'ITEM_KEY',
358: avalue => wf_ikey_array(k));
359:
360: wf_engine.SetItemAttrText(itemType => 'PSPERAVL',
361: itemKey => wf_ikey_array(k),
362: aname => 'RECEIVER_FLAG',
363: avalue => 'AR');
364:

Line 371: wf_engine.SetItemAttrText(itemType => 'PSPERAVL',

367: fetch effort_manual_override_cur into effort_manual_override_flag;
368: close effort_manual_override_cur;
369:
370: if effort_manual_override_flag = 'N' then
371: wf_engine.SetItemAttrText(itemType => 'PSPERAVL',
372: itemKey => wf_ikey_array(k),
373: aname => 'EFFORT_MANUAL_OVERRIDE',
374: avalue => null);
375: /* else -- else part is defaulted in psperavl.wft

Line 376: wf_engine.SetItemAttrText(itemType => 'PSPERAVL',

372: itemKey => wf_ikey_array(k),
373: aname => 'EFFORT_MANUAL_OVERRIDE',
374: avalue => null);
375: /* else -- else part is defaulted in psperavl.wft
376: wf_engine.SetItemAttrText(itemType => 'PSPERAVL',
377: itemKey => wf_ikey_array(k),
378: aname => 'EFFORT_MANUAL_OVERRIDE',
379: avalue => 'JSP:/OA_HTML/OA.jsp?page=/oracle/apps/psp/effortreporting/workflow/webui/EffManualOverridePG&akRegionApplicationId=8403&requestId=-&MSG_REQUEST_ID-&wfItemKey=-&MSG_IKEY-&wfRoleName=-&APPROVER_ROLE-&approverOrderNum=-&APPROVER_ORDER-');
380: */

Line 384: wf_engine.SetItemAttrText(itemtype => 'PSPERAVL',

380: */
381: end if;
382: -- Fix for bug 4106614 : Effort Manual Override END
383:
384: wf_engine.SetItemAttrText(itemtype => 'PSPERAVL',
385: itemkey => wf_ikey_array(k),
386: aname => '#ATTACHMENTS',
387: avalue => 'FND:entity=ERDETAILS&pk1name=WF_ITEM_KEY&pk1value=' || wf_ikey_array(k));
388:

Line 390: wf_engine.SetItemAttrText(itemType => 'PSPERAVL',

386: aname => '#ATTACHMENTS',
387: avalue => 'FND:entity=ERDETAILS&pk1name=WF_ITEM_KEY&pk1value=' || wf_ikey_array(k));
388:
389: --Bug 7135471
390: wf_engine.SetItemAttrText(itemType => 'PSPERAVL',
391: itemKey => wf_ikey_array(k),
392: aname => 'PDF_ATTACHMENT',
393: avalue => 'PLSQLBLOB:psp_xmlgen.attach_pdf/' || 'PSPERAVL' || ':' || wf_ikey_array(k));
394:

Line 395: wf_engine.SetItemAttrText(itemtype => 'PSPERAVL',

391: itemKey => wf_ikey_array(k),
392: aname => 'PDF_ATTACHMENT',
393: avalue => 'PLSQLBLOB:psp_xmlgen.attach_pdf/' || 'PSPERAVL' || ':' || wf_ikey_array(k));
394:
395: wf_engine.SetItemAttrText(itemtype => 'PSPERAVL',
396: itemkey => wf_ikey_array(k),
397: aname => 'START_DATE',
398: avalue => l_start_date);
399:

Line 400: wf_engine.SetItemAttrText(itemtype => 'PSPERAVL',

396: itemkey => wf_ikey_array(k),
397: aname => 'START_DATE',
398: avalue => l_start_date);
399:
400: wf_engine.SetItemAttrText(itemtype => 'PSPERAVL',
401: itemkey => wf_ikey_array(k),
402: aname => 'END_DATE',
403: avalue => l_end_date);
404:

Line 405: wf_engine.SetItemAttrText(itemType => 'PSPERAVL',

401: itemkey => wf_ikey_array(k),
402: aname => 'END_DATE',
403: avalue => l_end_date);
404:
405: wf_engine.SetItemAttrText(itemType => 'PSPERAVL',
406: itemkey => wf_ikey_array(k),
407: aname => 'TEMPLATE_NAME',
408: avalue => l_template_name);
409:

Line 411: wf_engine.SetItemAttrText(itemType => 'PSPERAVL',

407: aname => 'TEMPLATE_NAME',
408: avalue => l_template_name);
409:
410:
411: wf_engine.SetItemAttrText(itemType => 'PSPERAVL',
412: itemkey => wf_ikey_array(k),
413: aname => 'CONC_PARAM_STRING',
414: avalue => l_param_string);
415: k := k + 1;

Line 423: wf_engine.StartProcess(itemtype => 'PSPERAVL',

419: if k > wf_rname_array.count then
420: exit;
421: end if;
422:
423: wf_engine.StartProcess(itemtype => 'PSPERAVL',
424: itemkey => wf_ikey_array(k));
425: k := k + 1;
426: end loop;
427: wf_ikey_array.delete;

Line 452: l_request_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

448: l_request_id integer;
449: begin
450:
451: if (funcmode = 'RUN') then
452: l_request_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
453: itemkey => itemkey,
454: aname => 'REQUEST_ID');
455: delete psp_eff_report_approvals
456: where effort_report_detail_id in

Line 646: wf_engine.GetItemAttrNumber(itemtype => itemtype,

642: l_user_id := fnd_global.user_id;
643: l_login_id := fnd_global.login_id;
644: if funcmode = 'RUN' then
645: l_approver_order_num :=
646: wf_engine.GetItemAttrNumber(itemtype => itemtype,
647: itemkey => itemkey,
648: aname => 'APPROVER_ORDER_NUM');
649: l_request_id :=
650: wf_engine.GetItemAttrNumber(itemtype => itemtype,

Line 650: wf_engine.GetItemAttrNumber(itemtype => itemtype,

646: wf_engine.GetItemAttrNumber(itemtype => itemtype,
647: itemkey => itemkey,
648: aname => 'APPROVER_ORDER_NUM');
649: l_request_id :=
650: wf_engine.GetItemAttrNumber(itemtype => itemtype,
651: itemkey => itemkey,
652: aname => 'REQUEST_ID');
653: open get_approval_type;
654: fetch get_approval_type into l_approval_type;

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

824: end if;
825: end if; --- same approval level flag = N
826: end if; --- approver order number > 1
827: if result = 'COMPLETE:FOUND' then
828: wf_engine.SetItemAttrText(itemtype => itemtype,
829: itemkey => itemkey,
830: aname => 'APPROVER_ROLE_NAME',
831: avalue => l_wf_rname);
832: wf_engine.SetItemAttrText(itemtype => itemtype,

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

828: wf_engine.SetItemAttrText(itemtype => itemtype,
829: itemkey => itemkey,
830: aname => 'APPROVER_ROLE_NAME',
831: avalue => l_wf_rname);
832: wf_engine.SetItemAttrText(itemtype => itemtype,
833: itemkey => itemkey,
834: aname => 'APPROVER_DISPLAY_NAME',
835: avalue => l_role_display_name);
836: wf_engine.SetItemAttrText(itemtype => itemtype,

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

832: wf_engine.SetItemAttrText(itemtype => itemtype,
833: itemkey => itemkey,
834: aname => 'APPROVER_DISPLAY_NAME',
835: avalue => l_role_display_name);
836: wf_engine.SetItemAttrText(itemtype => itemtype,
837: itemkey => itemkey,
838: aname => '#ATTACHMENTS',
839: avalue => 'FND:entity=ERDETAILS&pk1name=WF_ITEM_KEY&pk1value=' || itemkey || l_wf_rname );
840:

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

838: aname => '#ATTACHMENTS',
839: avalue => 'FND:entity=ERDETAILS&pk1name=WF_ITEM_KEY&pk1value=' || itemkey || l_wf_rname );
840:
841: --Bug 7135471
842: wf_engine.SetItemAttrText(itemType => itemtype,
843: itemKey => itemkey,
844: aname => 'PDF_ATTACHMENT',
845: avalue => 'PLSQLBLOB:psp_xmlgen.attach_pdf/' || itemtype || ':' || itemkey);
846:

Line 849: wf_engine.setitemowner(itemtype => itemtype,

845: avalue => 'PLSQLBLOB:psp_xmlgen.attach_pdf/' || itemtype || ':' || itemkey);
846:
847:
848: /*Added for bug 7004679 */
849: wf_engine.setitemowner(itemtype => itemtype,
850: itemkey => itemkey,
851: owner => l_wf_rname);
852:
853:

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

852:
853:
854:
855: /*
856: wf_engine.SetItemAttrText(itemtype => itemtype,
857: itemkey => itemkey,
858: aname => 'EMBED_WF_ER_DETAILS',
859: avalue => 'JSP:/OA_HTML/OA.jsp?OAFunc=PSP_WF_ER_DETAILS&wfItemKey='||itemkey
860: ||'&requestId='||l_request_id

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

861: ||'&wfRoleName='||l_wf_rname
862: ||'&approverOrderNum='||l_approver_order_num); */
863:
864: hr_utility.trace('GET_NEXT value for temp_approver_order ='|| l_approver_order_num);
865: wf_engine.SetItemAttrNumber(itemtype => itemtype,
866: itemkey => itemkey,
867: aname => 'TEMP_APPROVER_ORDER',
868: avalue => l_approver_order_num);
869:

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

874: ||'&approverOrderNum='||l_approver_order_num);
875:
876: if l_same_approval_level = 'N' then
877: l_approver_order_num := l_approver_order_num + 1;
878: wf_engine.SetItemAttrNumber(itemtype => itemtype,
879: itemkey => itemkey,
880: aname => 'APPROVER_ORDER_NUM',
881: avalue => l_approver_order_num);
882: end if;

Line 991: wf_engine.GetItemAttrNumber(itemtype => itemtype,

987: ---hr_utility.trace_on('Y','WF-1');
988: if funcmode = 'RUN' then
989: hr_utility.trace('er_workflow -->1 ');
990: l_request_id :=
991: wf_engine.GetItemAttrNumber(itemtype => itemtype,
992: itemkey => itemkey,
993: aname => 'REQUEST_ID');
994: l_rname :=
995: wf_engine.GetItemAttrText(itemtype => itemtype,

Line 995: wf_engine.GetItemAttrText(itemtype => itemtype,

991: wf_engine.GetItemAttrNumber(itemtype => itemtype,
992: itemkey => itemkey,
993: aname => 'REQUEST_ID');
994: l_rname :=
995: wf_engine.GetItemAttrText(itemtype => itemtype,
996: itemkey => itemkey,
997: aname => 'APPROVER_ROLE_NAME');
998:
999: l_approver_order_num :=

Line 1000: wf_engine.GetItemAttrNumber(itemtype => itemtype,

996: itemkey => itemkey,
997: aname => 'APPROVER_ROLE_NAME');
998:
999: l_approver_order_num :=
1000: wf_engine.GetItemAttrNumber(itemtype => itemtype,
1001: itemkey => itemkey,
1002: aname => 'APPROVER_ORDER_NUM');
1003: select orig_system_id,
1004: orig_system

Line 1086: wf_engine.GetItemAttrText(itemtype => itemtype,

1082: hr_utility.trace('er_workflow -->19 ');
1083: end loop;
1084:
1085: l_initiator_rname :=
1086: wf_engine.GetItemAttrText(itemtype => itemtype,
1087: itemkey => itemkey,
1088: aname => 'INITIATOR');
1089:
1090: wf_directory.createAdhocRole(l_recipnt_role,

Line 1108: wf_engine.SetItemAttrText(itemtype => 'PSPERAVL',

1104: role_users => l_rname);
1105: end loop;
1106:
1107: hr_utility.trace('er_workflow -->59 ');
1108: wf_engine.SetItemAttrText(itemtype => 'PSPERAVL',
1109: itemkey => itemkey,
1110: aname => 'NOTIFY_REJECTIONS_ROLE',
1111: avalue => l_recipnt_role);
1112: hr_utility.trace('er_workflow -->69 ');

Line 1187: wf_engine.GetItemAttrText(itemtype => itemtype,

1183: /*End of changes for the bug 10185794 */
1184:
1185: if funcmode = 'RUN' then
1186: l_rname :=
1187: wf_engine.GetItemAttrText(itemtype => itemtype,
1188: itemkey => itemkey,
1189: aname => 'APPROVER_ROLE_NAME');
1190:
1191: open get_orig_system;

Line 1419: l_result := Wf_Notification.GetAttrText(wf_engine.context_nid, 'RESULT');

1415: BEGIN
1416:
1417: /* Added for Hundred percent validation for overriden effort */
1418: IF funcmode in ('RESPOND') THEN
1419: l_result := Wf_Notification.GetAttrText(wf_engine.context_nid, 'RESULT');
1420: IF l_result = 'APPROVED' THEN
1421: l_request_id := wf_engine.GetItemAttrText(itemtype => itemtype,
1422: itemkey => itemkey,
1423: aname => 'REQUEST_ID');

Line 1421: l_request_id := wf_engine.GetItemAttrText(itemtype => itemtype,

1417: /* Added for Hundred percent validation for overriden effort */
1418: IF funcmode in ('RESPOND') THEN
1419: l_result := Wf_Notification.GetAttrText(wf_engine.context_nid, 'RESULT');
1420: IF l_result = 'APPROVED' THEN
1421: l_request_id := wf_engine.GetItemAttrText(itemtype => itemtype,
1422: itemkey => itemkey,
1423: aname => 'REQUEST_ID');
1424: l_wf_role_name := wf_engine.GetItemAttrText(itemtype => itemtype,
1425: itemkey => itemkey,

Line 1424: l_wf_role_name := wf_engine.GetItemAttrText(itemtype => itemtype,

1420: IF l_result = 'APPROVED' THEN
1421: l_request_id := wf_engine.GetItemAttrText(itemtype => itemtype,
1422: itemkey => itemkey,
1423: aname => 'REQUEST_ID');
1424: l_wf_role_name := wf_engine.GetItemAttrText(itemtype => itemtype,
1425: itemkey => itemkey,
1426: aname => 'APPROVER_ROLE_NAME');
1427: l_approver_order_num := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1428: itemkey => itemkey,

Line 1427: l_approver_order_num := wf_engine.GetItemAttrNumber(itemtype => itemtype,

1423: aname => 'REQUEST_ID');
1424: l_wf_role_name := wf_engine.GetItemAttrText(itemtype => itemtype,
1425: itemkey => itemkey,
1426: aname => 'APPROVER_ROLE_NAME');
1427: l_approver_order_num := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1428: itemkey => itemkey,
1429: aname => 'APPROVER_ORDER_NUM');
1430: l_approver_order_num := l_approver_order_num - 1;
1431: l_wf_item_key := itemkey;

Line 1498: l_rname := wf_engine.GetItemAttrText(itemtype => itemtype,

1494:
1495: if funcmode in ('TRANSFER', 'FORWARD') then
1496: ---hr_utility.trace_on('Y','WF-1');
1497: hr_utility.trace('Post Notification...TRANSFER . FORWARD');
1498: l_rname := wf_engine.GetItemAttrText(itemtype => itemtype,
1499: itemkey => itemkey,
1500: aname => 'APPROVER_ROLE_NAME');
1501: hr_utility.trace('role name from T and F = '||l_rname);
1502:

Line 1511: l_rname2 := wf_engine.context_text;

1507: approver_rec.name := l_rname;
1508: approver_rec.orig_system := l_orig_system;
1509: approver_rec.orig_system_id := l_orig_system_id;
1510: approver_rec.approval_status:= ame_util.forwardStatus;
1511: l_rname2 := wf_engine.context_text;
1512: l_nid := wf_engine.context_nid;
1513: open get_forwarde_details;
1514: fetch get_forwarde_details into l_orig_system2, l_orig_system_id2,l_role_display_name2;
1515: close get_forwarde_details;

Line 1512: l_nid := wf_engine.context_nid;

1508: approver_rec.orig_system := l_orig_system;
1509: approver_rec.orig_system_id := l_orig_system_id;
1510: approver_rec.approval_status:= ame_util.forwardStatus;
1511: l_rname2 := wf_engine.context_text;
1512: l_nid := wf_engine.context_nid;
1513: open get_forwarde_details;
1514: fetch get_forwarde_details into l_orig_system2, l_orig_system_id2,l_role_display_name2;
1515: close get_forwarde_details;
1516: forward_rec.name := l_rname2;

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

1535: where pk1_value = itemkey||l_rname;
1536:
1537:
1538:
1539: wf_engine.SetItemAttrText(itemtype => itemtype,
1540: itemkey => itemkey,
1541: aname => 'APPROVER_ROLE_NAME',
1542: avalue => l_rname2);
1543: wf_engine.SetItemAttrText(itemtype => itemtype,

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

1539: wf_engine.SetItemAttrText(itemtype => itemtype,
1540: itemkey => itemkey,
1541: aname => 'APPROVER_ROLE_NAME',
1542: avalue => l_rname2);
1543: wf_engine.SetItemAttrText(itemtype => itemtype,
1544: itemkey => itemkey,
1545: aname => 'APPROVER_DISPLAY_NAME',
1546: avalue => l_role_display_name2);
1547: wf_notification.setAttrText(nid => l_nid,

Line 1565: l_rname := wf_engine.GetItemAttrText(itemtype => itemtype,

1561: approverin => approver_rec,
1562: forwardeein => forward_rec);
1563: end loop;
1564: else
1565: l_rname := wf_engine.GetItemAttrText(itemtype => itemtype,
1566: itemkey => itemkey,
1567: aname => 'APPROVER_ROLE_NAME');
1568:
1569:

Line 1576: l_nid := wf_engine.context_nid;

1572: end if; ---funcmode
1573:
1574: -- BUG 4334816 START
1575: -- New code added to capture the Notification id in psp_eff_report_approvals table
1576: l_nid := wf_engine.context_nid;
1577: l_rname := wf_engine.GetItemAttrText(itemtype => itemtype,
1578: itemkey => itemkey,
1579: aname => 'APPROVER_ROLE_NAME');
1580:

Line 1577: l_rname := wf_engine.GetItemAttrText(itemtype => itemtype,

1573:
1574: -- BUG 4334816 START
1575: -- New code added to capture the Notification id in psp_eff_report_approvals table
1576: l_nid := wf_engine.context_nid;
1577: l_rname := wf_engine.GetItemAttrText(itemtype => itemtype,
1578: itemkey => itemkey,
1579: aname => 'APPROVER_ROLE_NAME');
1580:
1581: update psp_eff_report_approvals set NOTIFICATION_ID = l_nid

Line 1641: wf_engine.GetItemAttrText(itemtype => itemtype,

1637: and wf_role_name = l_rname));*/
1638: begin
1639: if funcmode = 'RUN' then
1640: l_rname :=
1641: wf_engine.GetItemAttrText(itemtype => itemtype,
1642: itemkey => itemkey,
1643: aname => 'APPROVER_ROLE_NAME');
1644: l_request_id :=
1645: wf_engine.GetItemAttrText(itemtype => itemtype,

Line 1645: wf_engine.GetItemAttrText(itemtype => itemtype,

1641: wf_engine.GetItemAttrText(itemtype => itemtype,
1642: itemkey => itemkey,
1643: aname => 'APPROVER_ROLE_NAME');
1644: l_request_id :=
1645: wf_engine.GetItemAttrText(itemtype => itemtype,
1646: itemkey => itemkey,
1647: aname => 'REQUEST_ID');
1648:
1649: l_pdf_request_id :=

Line 1650: wf_engine.GetItemAttrNumber(itemtype => itemtype,

1646: itemkey => itemkey,
1647: aname => 'REQUEST_ID');
1648:
1649: l_pdf_request_id :=
1650: wf_engine.GetItemAttrNumber(itemtype => itemtype,
1651: itemkey => itemkey,
1652: aname => 'PDF_REQUEST_ID');
1653:
1654: l_retry_request_id :=

Line 1655: wf_engine.GetItemAttrNumber(itemtype => itemtype,

1651: itemkey => itemkey,
1652: aname => 'PDF_REQUEST_ID');
1653:
1654: l_retry_request_id :=
1655: wf_engine.GetItemAttrNumber(itemtype => itemtype,
1656: itemkey => itemkey,
1657: aname => 'RETRY_REQUEST_ID');
1658:
1659: /*

Line 1660: wf_engine.SetItemAttrText(itemtype => 'PSPERAVL',

1656: itemkey => itemkey,
1657: aname => 'RETRY_REQUEST_ID');
1658:
1659: /*
1660: wf_engine.SetItemAttrText(itemtype => 'PSPERAVL',
1661: itemkey => itemkey,
1662: aname => 'WF_EMBED_INITIATOR',
1663: avalue => 'JSP:/OA_HTML/OA.jsp?OAFunc=PSP_ER_WF_INIT_STATUS_DETAILS&erRequestId=-&MSG_REQUEST_ID-'
1664: || '&pdfRequestId=-&PDF_REQUEST_ID-&wfItemKey=-&MSG_IKEY-&processParameters=-&PROCESS_PARAMETERS-');

Line 1666: wf_engine.SetItemAttrText(itemtype => 'PSPERAVL',

1662: aname => 'WF_EMBED_INITIATOR',
1663: avalue => 'JSP:/OA_HTML/OA.jsp?OAFunc=PSP_ER_WF_INIT_STATUS_DETAILS&erRequestId=-&MSG_REQUEST_ID-'
1664: || '&pdfRequestId=-&PDF_REQUEST_ID-&wfItemKey=-&MSG_IKEY-&processParameters=-&PROCESS_PARAMETERS-');
1665:
1666: wf_engine.SetItemAttrText(itemtype => 'PSPERAVL',
1667: itemkey => itemkey,
1668: aname => 'INITIATOR_ERROR_STATUS',
1669: avalue => '');
1670: wf_engine.SetItemAttrText(itemtype => 'PSPERAVL',

Line 1670: wf_engine.SetItemAttrText(itemtype => 'PSPERAVL',

1666: wf_engine.SetItemAttrText(itemtype => 'PSPERAVL',
1667: itemkey => itemkey,
1668: aname => 'INITIATOR_ERROR_STATUS',
1669: avalue => '');
1670: wf_engine.SetItemAttrText(itemtype => 'PSPERAVL',
1671: itemkey => itemkey,
1672: aname => 'WF_EMBED_INITIATOR_ERRORS',
1673: avalue => 'JSP:/OA_HTML/OA.jsp?OAFunc=PSP_ER_WF_INITIATOR_ERRORS&erRequestId=-&MSG_REQUEST_ID-'
1674: || '&pdfRequestId=-&PDF_REQUEST_ID-&wfItemKey=-&MSG_IKEY-&processParameters=-&PROCESS_PARAMETERS-');

Line 1833: wf_engine.CreateProcess(itemtype => 'PSPERAVL',

1829: l_time_out := l_time_out * 1440;
1830:
1831: --dbms_output.put_line('FROM START item key ='||l_wf_itemkey);
1832:
1833: wf_engine.CreateProcess(itemtype => 'PSPERAVL',
1834: itemkey => l_wf_itemkey,
1835: process => 'INITIATOR_PROCESS');
1836:
1837: hr_utility.trace('er_workflow --> start_int: reqid ='||to_char(p_request_id));

Line 1840: wf_engine.setitemowner(itemtype => 'PSPERAVL',

1836:
1837: hr_utility.trace('er_workflow --> start_int: reqid ='||to_char(p_request_id));
1838:
1839: /*Added for bug 7004679 */
1840: wf_engine.setitemowner(itemtype => 'PSPERAVL',
1841: itemkey => l_wf_itemkey,
1842: owner => l_user_name);
1843:
1844: wf_engine.SetItemAttrNumber(itemtype => 'PSPERAVL',

Line 1844: wf_engine.SetItemAttrNumber(itemtype => 'PSPERAVL',

1840: wf_engine.setitemowner(itemtype => 'PSPERAVL',
1841: itemkey => l_wf_itemkey,
1842: owner => l_user_name);
1843:
1844: wf_engine.SetItemAttrNumber(itemtype => 'PSPERAVL',
1845: itemkey => l_wf_itemkey,
1846: aname => 'REQUEST_ID',
1847: avalue => p_request_id);
1848:

Line 1849: wf_engine.SetItemAttrNumber(itemtype => 'PSPERAVL',

1845: itemkey => l_wf_itemkey,
1846: aname => 'REQUEST_ID',
1847: avalue => p_request_id);
1848:
1849: wf_engine.SetItemAttrNumber(itemtype => 'PSPERAVL',
1850: itemkey => l_wf_itemkey,
1851: aname => 'TIMEOUT',
1852: avalue => l_time_out);
1853:

Line 1854: wf_engine.SetItemAttrText(itemtype => 'PSPERAVL',

1850: itemkey => l_wf_itemkey,
1851: aname => 'TIMEOUT',
1852: avalue => l_time_out);
1853:
1854: wf_engine.SetItemAttrText(itemtype => 'PSPERAVL',
1855: itemkey => l_wf_itemkey,
1856: aname => 'INITIATOR',
1857: avalue => l_user_name);
1858:

Line 1859: wf_engine.SetItemAttrText(itemtype => 'PSPERAVL',

1855: itemkey => l_wf_itemkey,
1856: aname => 'INITIATOR',
1857: avalue => l_user_name);
1858:
1859: wf_engine.SetItemAttrText(itemtype => 'PSPERAVL',
1860: itemkey => l_wf_itemkey,
1861: aname => 'WF_EMBED_INITIATOR',
1862: avalue => 'JSP:/OA_HTML/OA.jsp?OAFunc=PSP_ER_WF_INITIATOR_DETAILS&requestId='||p_request_id);
1863:

Line 1864: wf_engine.SetItemAttrText(itemtype => 'PSPERAVL',

1860: itemkey => l_wf_itemkey,
1861: aname => 'WF_EMBED_INITIATOR',
1862: avalue => 'JSP:/OA_HTML/OA.jsp?OAFunc=PSP_ER_WF_INITIATOR_DETAILS&requestId='||p_request_id);
1863:
1864: wf_engine.SetItemAttrText(itemtype => 'PSPERAVL',
1865: itemkey => l_wf_itemkey,
1866: aname => 'WF_EMBED_FINAL_RECIPIENT',
1867: avalue => 'JSP:/OA_HTML/OA.jsp?OAFunc=PSP_ER_WF_FIN_REC_STATUS&requestId='||p_request_id);
1868:

Line 1869: wf_engine.SetItemAttrText(itemtype => 'PSPERAVL',

1865: itemkey => l_wf_itemkey,
1866: aname => 'WF_EMBED_FINAL_RECIPIENT',
1867: avalue => 'JSP:/OA_HTML/OA.jsp?OAFunc=PSP_ER_WF_FIN_REC_STATUS&requestId='||p_request_id);
1868:
1869: wf_engine.SetItemAttrText(itemtype => 'PSPERAVL',
1870: itemkey => l_wf_itemkey,
1871: aname => 'INITIATOR_ERROR_STATUS',
1872: avalue => 'JSP:/OA_HTML/OA.jsp?OAFunc=PSP_ER_WF_ERROR_STATUS&requestId='||p_request_id);
1873:

Line 1874: wf_engine.SetItemAttrText(itemtype => 'PSPERAVL',

1870: itemkey => l_wf_itemkey,
1871: aname => 'INITIATOR_ERROR_STATUS',
1872: avalue => 'JSP:/OA_HTML/OA.jsp?OAFunc=PSP_ER_WF_ERROR_STATUS&requestId='||p_request_id);
1873:
1874: wf_engine.SetItemAttrText(itemtype => 'PSPERAVL',
1875: itemkey => l_wf_itemkey,
1876: aname => 'START_DATE',
1877: avalue => l_start_date);
1878:

Line 1879: wf_engine.SetItemAttrText(itemtype => 'PSPERAVL',

1875: itemkey => l_wf_itemkey,
1876: aname => 'START_DATE',
1877: avalue => l_start_date);
1878:
1879: wf_engine.SetItemAttrText(itemtype => 'PSPERAVL',
1880: itemkey => l_wf_itemkey,
1881: aname => 'END_DATE',
1882: avalue => l_end_date);
1883:

Line 1884: wf_engine.SetItemAttrText(itemtype => 'PSPERAVL',

1880: itemkey => l_wf_itemkey,
1881: aname => 'END_DATE',
1882: avalue => l_end_date);
1883:
1884: wf_engine.SetItemAttrText(itemtype => 'PSPERAVL',
1885: itemkey => l_wf_itemkey,
1886: aname => 'ITEM_KEY',
1887: avalue => l_wf_itemkey);
1888:

Line 1889: wf_engine.SetItemAttrText(itemType => 'PSPERAVL',

1885: itemkey => l_wf_itemkey,
1886: aname => 'ITEM_KEY',
1887: avalue => l_wf_itemkey);
1888:
1889: wf_engine.SetItemAttrText(itemType => 'PSPERAVL',
1890: itemKey => l_wf_itemkey,
1891: aname => 'RECEIVER_FLAG',
1892: avalue => 'IR');
1893:

Line 1894: wf_engine.SetItemAttrText(itemType => 'PSPERAVL',

1890: itemKey => l_wf_itemkey,
1891: aname => 'RECEIVER_FLAG',
1892: avalue => 'IR');
1893:
1894: wf_engine.SetItemAttrText(itemType => 'PSPERAVL',
1895: itemKey => l_wf_itemkey,
1896: aname => 'TEMPLATE_NAME',
1897: avalue => l_template_name);
1898:

Line 1900: wf_engine.SetItemAttrText(itemtype => 'PSPERAVL',

1896: aname => 'TEMPLATE_NAME',
1897: avalue => l_template_name);
1898:
1899: IF (l_preview_flag = 'Y') THEN
1900: wf_engine.SetItemAttrText(itemtype => 'PSPERAVL',
1901: itemkey => l_wf_itemkey,
1902: aname => '#ATTACHMENTS',
1903: avalue => 'FND:entity=ERDETAILS&pk1name=WF_ITEM_KEY&pk1value=' || l_wf_itemkey || '&pk2name=RECEIVER_FLAG&pk2value=' || 'IR');
1904: --Bug 7135471

Line 1905: wf_engine.SetItemAttrText(itemType => 'PSPERAVL',

1901: itemkey => l_wf_itemkey,
1902: aname => '#ATTACHMENTS',
1903: avalue => 'FND:entity=ERDETAILS&pk1name=WF_ITEM_KEY&pk1value=' || l_wf_itemkey || '&pk2name=RECEIVER_FLAG&pk2value=' || 'IR');
1904: --Bug 7135471
1905: wf_engine.SetItemAttrText(itemType => 'PSPERAVL',
1906: itemKey => l_wf_itemkey,
1907: aname => 'PDF_ATTACHMENT',
1908: avalue => 'PLSQLBLOB:psp_xmlgen.attach_pdf/' || 'PSPERAVL' || ':' || l_wf_itemkey);
1909:

Line 1911: wf_engine.SetItemAttrText(itemtype => 'PSPERAVL',

1907: aname => 'PDF_ATTACHMENT',
1908: avalue => 'PLSQLBLOB:psp_xmlgen.attach_pdf/' || 'PSPERAVL' || ':' || l_wf_itemkey);
1909:
1910: ELSE
1911: wf_engine.SetItemAttrText(itemtype => 'PSPERAVL',
1912: itemkey => l_wf_itemkey,
1913: aname => '#ATTACHMENTS',
1914: avalue => '');
1915:

Line 1917: wf_engine.SetItemAttrText(itemType => 'PSPERAVL',

1913: aname => '#ATTACHMENTS',
1914: avalue => '');
1915:
1916: --Bug 7135471
1917: wf_engine.SetItemAttrText(itemType => 'PSPERAVL',
1918: itemKey => l_wf_itemkey,
1919: aname => 'PDF_ATTACHMENT',
1920: avalue => '');
1921:

Line 1925: wf_engine.SetItemAttrNumber(itemtype => 'PSPERAVL',

1921:
1922: END IF;
1923:
1924: IF (p_request_id <> l_retry_request_id) THEN
1925: wf_engine.SetItemAttrNumber(itemtype => 'PSPERAVL',
1926: itemkey => l_wf_itemkey,
1927: aname => 'RETRY_REQUEST_ID',
1928: avalue => l_retry_request_id);
1929: END IF;

Line 1935: wf_engine.SetItemAttrNumber(itemtype => 'PSPERAVL',

1931: OPEN emp_matching_selection_cur;
1932: FETCH emp_matching_selection_cur INTO l_emp_matching_selection;
1933: CLOSE emp_matching_selection_cur;
1934:
1935: wf_engine.SetItemAttrNumber(itemtype => 'PSPERAVL',
1936: itemkey => l_wf_itemkey,
1937: aname => 'EMP_MATCHING_SELECTION',
1938: avalue => l_emp_matching_selection);
1939:

Line 1960: wf_engine.SetItemAttrText(itemType => 'PSPERAVL',

1956: fnd_message.set_token('FOURTH_ORDER_BY', l_arg12);
1957:
1958: l_param_string := fnd_message.get;
1959:
1960: wf_engine.SetItemAttrText(itemType => 'PSPERAVL',
1961: itemKey => l_wf_itemkey,
1962: aname => 'CONC_PARAM_STRING',
1963: avalue => l_param_string);
1964:

Line 1965: wf_engine.SetItemAttrNumber(itemtype => 'PSPERAVL',

1961: itemKey => l_wf_itemkey,
1962: aname => 'CONC_PARAM_STRING',
1963: avalue => l_param_string);
1964:
1965: wf_engine.SetItemAttrNumber(itemtype => 'PSPERAVL',
1966: itemkey => l_wf_itemkey,
1967: aname => 'PAYROLL_ACTION_ID',
1968: avalue => l_payroll_action_id);
1969:

Line 1970: wf_engine.StartProcess(itemtype => 'PSPERAVL',

1966: itemkey => l_wf_itemkey,
1967: aname => 'PAYROLL_ACTION_ID',
1968: avalue => l_payroll_action_id);
1969:
1970: wf_engine.StartProcess(itemtype => 'PSPERAVL',
1971: itemkey => l_wf_itemkey);
1972: end;
1973:
1974: procedure initiator_response(itemtype in varchar2,

Line 1988: wf_engine.GetItemAttrText(itemtype => itemtype,

1984: l_response varchar2(10);
1985: begin
1986: if funcmode = 'RUN' then
1987: l_request_id :=
1988: wf_engine.GetItemAttrText(itemtype => itemtype,
1989: itemkey => itemkey,
1990: aname => 'REQUEST_ID');
1991: open get_init_response;
1992: fetch get_init_response into l_response;

Line 2041: wf_engine.GetItemAttrText(itemtype => itemtype,

2037: begin
2038: l_recipnt_role := 'PSP_FINAL_RECIPIENT_'||itemkey;
2039: l_frp_role_display := 'Effort Report Final Recipients';
2040: l_request_id :=
2041: wf_engine.GetItemAttrText(itemtype => itemtype,
2042: itemkey => itemkey,
2043: aname => 'REQUEST_ID');
2044:
2045: wf_directory.createAdhocRole(l_recipnt_role,

Line 2070: wf_engine.SetItemAttrText(itemtype => 'PSPERAVL',

2066: if i > 0 then
2067:
2068: result := 'COMPLETE:Y';
2069:
2070: wf_engine.SetItemAttrText(itemtype => 'PSPERAVL',
2071: itemkey => itemkey,
2072: aname => 'FINAL_RECIPIENT',
2073: avalue => l_recipnt_role);
2074: update psp_report_templates_h

Line 2103: wf_engine.SetItemAttrText(itemType => 'PSPERAVL',

2099: --- link the PDF using the attachment attribute
2100: --dbms_output.put_line(' attach the pdf here for the notification');
2101: /*
2102:
2103: wf_engine.SetItemAttrText(itemType => 'PSPERAVL',
2104: itemKey => itemkey,
2105: aname => 'PDF_ATTACHMENT',
2106: avalue => 'PLSQLBLOB:psp_xmlgen.attach_pdf/' || itemtype || ':' || itemkey);
2107: */

Line 2124: wf_engine.SetItemAttrText(itemType => 'PSPERAVL',

2120: actid ,
2121: funcmode ,
2122: result );
2123:
2124: wf_engine.SetItemAttrText(itemType => 'PSPERAVL',
2125: itemKey => itemkey,
2126: aname => 'PDF_ATTACHMENT',
2127: avalue => 'PLSQLBLOB:psp_xmlgen.attach_pdf/' || itemtype || ':' || itemkey);
2128:

Line 2166: wf_engine.GetItemAttrText(itemtype => itemtype,

2162: end if;
2163: /*End of changes for the bug 10185794 */
2164:
2165: l_request_id :=
2166: wf_engine.GetItemAttrText(itemtype => itemtype,
2167: itemkey => itemkey,
2168: aname => 'REQUEST_ID');
2169:
2170: open get_approval_type;

Line 2193: wf_engine.SetItemAttrText(itemType => 'PSPERAVL',

2189: -- Bug 7135471 End
2190:
2191:
2192:
2193: wf_engine.SetItemAttrText(itemType => 'PSPERAVL',
2194: itemKey => itemkey,
2195: aname => 'RECEIVER_FLAG',
2196: avalue => 'FR');
2197:

Line 2198: wf_engine.SetItemAttrText(itemtype => 'PSPERAVL',

2194: itemKey => itemkey,
2195: aname => 'RECEIVER_FLAG',
2196: avalue => 'FR');
2197:
2198: wf_engine.SetItemAttrText(itemtype => 'PSPERAVL',
2199: itemkey => itemkey,
2200: aname => '#ATTACHMENTS',
2201: avalue => 'FND:entity=ERDETAILS&pk1name=WF_ITEM_KEY&pk1value=' || itemkey || '&pk2name=RECEIVER_FLAG&pk2value=' || 'FR');
2202:

Line 2204: wf_engine.SetItemAttrText(itemType => 'PSPERAVL',

2200: aname => '#ATTACHMENTS',
2201: avalue => 'FND:entity=ERDETAILS&pk1name=WF_ITEM_KEY&pk1value=' || itemkey || '&pk2name=RECEIVER_FLAG&pk2value=' || 'FR');
2202:
2203: --Bug 7135471
2204: wf_engine.SetItemAttrText(itemType => 'PSPERAVL',
2205: itemKey => itemkey,
2206: aname => 'PDF_ATTACHMENT',
2207: avalue => 'PLSQLBLOB:psp_xmlgen.attach_pdf/' || 'PSPERAVL' || ':' || itemkey);
2208:

Line 2237: wf_engine.SetItemAttrText(itemType => 'PSPERAVL',

2233: l_set_options_success := fnd_request.set_options(datagroup=> 'Standard');
2234: end if;
2235: /*End of changes for the bug 10185794 */
2236:
2237: wf_engine.SetItemAttrText(itemType => 'PSPERAVL',
2238: itemKey => itemkey,
2239: aname => 'RECEIVER_FLAG',
2240: avalue => 'AR');
2241:

Line 2242: wf_engine.SetItemAttrText(itemtype => 'PSPERAVL',

2238: itemKey => itemkey,
2239: aname => 'RECEIVER_FLAG',
2240: avalue => 'AR');
2241:
2242: wf_engine.SetItemAttrText(itemtype => 'PSPERAVL',
2243: itemkey => itemkey,
2244: aname => '#ATTACHMENTS',
2245: avalue => 'FND:entity=ERDETAILS&pk1name=WF_ITEM_KEY&pk1value=' || itemkey || '&pk2name=RECEIVER_FLAG&pk2value=' || 'AR');
2246:

Line 2248: wf_engine.SetItemAttrText(itemType => 'PSPERAVL',

2244: aname => '#ATTACHMENTS',
2245: avalue => 'FND:entity=ERDETAILS&pk1name=WF_ITEM_KEY&pk1value=' || itemkey || '&pk2name=RECEIVER_FLAG&pk2value=' || 'AR');
2246:
2247: --Bug 7135471
2248: wf_engine.SetItemAttrText(itemType => 'PSPERAVL',
2249: itemKey => itemkey,
2250: aname => 'PDF_ATTACHMENT',
2251: avalue => 'PLSQLBLOB:psp_xmlgen.attach_pdf/' || 'PSPERAVL' || ':' || itemkey);
2252:

Line 2270: wf_engine.GetItemAttrText(itemtype => itemtype,

2266: where request_id = l_request_id;
2267: l_approval_type varchar2(100);
2268: begin
2269: l_request_id :=
2270: wf_engine.GetItemAttrText(itemtype => itemtype,
2271: itemkey => itemkey,
2272: aname => 'REQUEST_ID');
2273: open get_approval_type;
2274: fetch get_approval_type into l_approval_type;

Line 2298: l_message_name := wf_engine.GetActivityAttrText(itemtype, itemkey, actid, 'INITIATOR_MESSAGE_NAME');

2294: result OUT nocopy varchar2) IS
2295: l_message_name fnd_new_messages.message_name%TYPE;
2296: l_message_text fnd_new_messages.message_text%TYPE;
2297: BEGIN
2298: l_message_name := wf_engine.GetActivityAttrText(itemtype, itemkey, actid, 'INITIATOR_MESSAGE_NAME');
2299: fnd_message.set_name('PSP', l_message_name);
2300: l_message_text := fnd_message.get;
2301: wf_engine.SetItemAttrText(itemtype => itemtype,
2302: itemkey => itemkey,

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

2297: BEGIN
2298: l_message_name := wf_engine.GetActivityAttrText(itemtype, itemkey, actid, 'INITIATOR_MESSAGE_NAME');
2299: fnd_message.set_name('PSP', l_message_name);
2300: l_message_text := fnd_message.get;
2301: wf_engine.SetItemAttrText(itemtype => itemtype,
2302: itemkey => itemkey,
2303: aname => 'ERROR_MESSAGE',
2304: avalue => l_message_text);
2305:

Line 2326: wf_engine.GetItemAttrText(itemtype => itemtype,

2322: l_initiator_rname wf_roles.name%type;
2323:
2324: BEGIN
2325: l_initiator_rname :=
2326: wf_engine.GetItemAttrText(itemtype => itemtype,
2327: itemkey => itemkey,
2328: aname => 'INITIATOR');
2329:
2330: wf_engine.SetItemAttrText(itemtype => itemtype,

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

2326: wf_engine.GetItemAttrText(itemtype => itemtype,
2327: itemkey => itemkey,
2328: aname => 'INITIATOR');
2329:
2330: wf_engine.SetItemAttrText(itemtype => itemtype,
2331: itemkey => itemkey,
2332: aname => 'WF_ADMINISTRATOR',
2333: avalue => l_initiator_rname);
2334:

Line 2341: wf_engine.additemattr

2337:
2338: if(item_attribute_exists(itemtype,itemkey,'PDF_ATTACHMENT')) then
2339: hr_utility.trace('PDF_ATTACHMENT attribute exists');
2340: else
2341: wf_engine.additemattr
2342: (itemtype => itemtype,
2343: itemkey => itemkey,
2344: aname => 'PDF_ATTACHMENT',
2345: text_value => '');

Line 2419: l_request_id := wf_engine.GetItemAttrText(itemtype => itemtype,

2415: l_set_options_success := fnd_request.set_options(datagroup=> 'Standard');
2416: end if;
2417: /*End of changes for the bug 10185794 */
2418:
2419: l_request_id := wf_engine.GetItemAttrText(itemtype => itemtype,
2420: itemkey => itemkey,
2421: aname => 'REQUEST_ID');
2422:
2423: OPEN preview_er_cur;