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

Line 125: wf_engine.SetItemAttrNumber( p_item_type

121: -- workflow approval process to work properly. For example, item_type,
122: -- item_key, etc. The best way to override this procedure is to copy the
123: -- code from start_workflow procedure and add your logic to the very end.
124:
125: wf_engine.SetItemAttrNumber( p_item_type
126: , p_item_key
127: , 'VERSION_ID'
128: , p_version_id
129: );

Line 132: wf_engine.SetItemAttrNumber( p_item_type

128: , p_version_id
129: );
130:
131:
132: wf_engine.SetItemAttrNumber( p_item_type
133: , p_item_key
134: , 'WF_OBJECT_ID'
135: , p_version_id
136: );

Line 138: wf_engine.SetItemAttrText(itemtype => p_item_type,

134: , 'WF_OBJECT_ID'
135: , p_version_id
136: );
137:
138: wf_engine.SetItemAttrText(itemtype => p_item_type,
139: itemkey => p_item_key,
140: aname => 'HISTORY',
141: avalue =>
142: 'PLSQL:PA_WORKFLOW_HISTORY.show_history/'||

Line 218: -- set return result to wf_engine.eng_completed||':'||'T';

214: -- set item attribute REPORT_APPROVER_NAME
215: -- this is very important, with out this attribute set, the approval process
216: -- will not work
217:
218: -- set return result to wf_engine.eng_completed||':'||'T';
219:
220: -- save the comment history to record info such as
221: -- "Submitter zzzz submit report xxx on this date"
222:

Line 441: wf_engine.SetItemAttrNumber( p_item_type

437:
438: x_return_status := FND_API.G_RET_STS_SUCCESS;
439:
440:
441: wf_engine.SetItemAttrNumber( p_item_type
442: , p_item_key
443: , 'VERSION_ID'
444: , p_version_id
445: );

Line 448: wf_engine.SetItemAttrNumber( p_item_type

444: , p_version_id
445: );
446:
447:
448: wf_engine.SetItemAttrNumber( p_item_type
449: , p_item_key
450: , 'WF_OBJECT_ID'
451: , p_version_id
452: );

Line 454: wf_engine.SetItemAttrText(itemtype => p_item_type,

450: , 'WF_OBJECT_ID'
451: , p_version_id
452: );
453:
454: wf_engine.SetItemAttrText(itemtype => p_item_type,
455: itemkey => p_item_key,
456: aname => 'HISTORY',
457: avalue =>
458: 'PLSQL:PA_WORKFLOW_HISTORY.show_history/'||

Line 469: wf_engine.SetItemAttrText( p_item_type

465: OPEN get_approval_required;
466: FETCH get_approval_required INTO l_approval_required;
467: CLOSE get_approval_required;
468:
469: wf_engine.SetItemAttrText( p_item_type
470: , p_item_key
471: , 'AUTO_APPROVED'
472: , l_approval_required
473: );

Line 480: wf_engine.SetItemAttrText( p_item_type

476: FOR rec IN get_report_info LOOP
477:
478:
479: -- set project id
480: wf_engine.SetItemAttrText( p_item_type
481: , p_item_key
482: , 'REPORT_TYPE'
483: , rec.report_type_name);
484:

Line 485: wf_engine.SetItemAttrText( p_item_type

481: , p_item_key
482: , 'REPORT_TYPE'
483: , rec.report_type_name);
484:
485: wf_engine.SetItemAttrText( p_item_type
486: , p_item_key
487: , 'LAST_UPDATED_BY'
488: , rec.last_updated_by);
489:

Line 491: wf_engine.SetItemAttrText( p_item_type

487: , 'LAST_UPDATED_BY'
488: , rec.last_updated_by);
489:
490:
491: wf_engine.SetItemAttrText( p_item_type
492: , p_item_key
493: , 'PROJECT_ID'
494: ,rec.object_id
495: );

Line 504: wf_engine.SetItemAttrText( p_item_type

500: l_url2 := 'JSP:/OA_HTML/OA.jsp?paReportVersionId='||p_version_id ||'&paProjectId='|| rec.object_id||
501: '&akRegionCode=PA_PROG_REP_REVIEW_LAYOUT&akRegionApplicationId=275&paPageMode=APPROVE&addBreadCrumb=RP';
502:
503:
504: wf_engine.SetItemAttrText( p_item_type
505: , p_item_key
506: , 'REPORT_LINK'
507: , l_url2
508: );

Line 518: wf_engine.SetItemAttrText( p_item_type

514:
515: FETCH get_project_info INTO l_customer,l_project_manager, l_org;
516:
517:
518: wf_engine.SetItemAttrText( p_item_type
519: , p_item_key
520: , 'PROJECT_MANAGER'
521: ,l_project_manager
522: );

Line 524: wf_engine.SetItemAttrText( p_item_type

520: , 'PROJECT_MANAGER'
521: ,l_project_manager
522: );
523:
524: wf_engine.SetItemAttrText( p_item_type
525: , p_item_key
526: , 'ORGANIZATION'
527: ,l_org
528: );

Line 529: wf_engine.SetItemAttrText( p_item_type

525: , p_item_key
526: , 'ORGANIZATION'
527: ,l_org
528: );
529: wf_engine.SetItemAttrText( p_item_type
530: , p_item_key
531: , 'CUSTOMER'
532: ,l_customer
533: );

Line 544: wf_engine.SetItemAttrText( p_item_type

540: -- set project name and number
541: pa_utils.getprojinfo(rec.object_id, l_project_number, l_project_name);
542:
543:
544: wf_engine.SetItemAttrText( p_item_type
545: , p_item_key
546: , 'PROJECT_NAME'
547: ,l_project_name
548: );

Line 550: wf_engine.SetItemAttrText( p_item_type

546: , 'PROJECT_NAME'
547: ,l_project_name
548: );
549:
550: wf_engine.SetItemAttrText( p_item_type
551: , p_item_key
552: , 'PROJECT_NUMBER'
553: ,l_project_number
554: );

Line 559: wf_engine.SetItemAttrText( p_item_type

555:
556:
557:
558: -- set record_version_number
559: wf_engine.SetItemAttrText( p_item_type
560: , p_item_key
561: , 'RECORD_VERSION_NUMBER'
562: ,rec.record_version_number
563: );

Line 567: wf_engine.SetItemAttrDate( p_item_type

563: );
564:
565:
566: -- set report start date
567: wf_engine.SetItemAttrDate( p_item_type
568: , p_item_key
569: , 'REPORT_START_DATE'
570: ,rec.report_start_date
571: );

Line 574: wf_engine.SetItemAttrText( p_item_type

570: ,rec.report_start_date
571: );
572:
573: -- set progress status
574: wf_engine.SetItemAttrText( p_item_type
575: , p_item_key
576: , 'PROGRESS_STATUS'
577: ,rec.progress_status
578: );

Line 582: wf_engine.SetItemAttrText( p_item_type

578: );
579:
580:
581: -- set report status code
582: wf_engine.SetItemAttrText( p_item_type
583: , p_item_key
584: , 'REPORT_STATUS'
585: ,rec.report_status_code
586: );

Line 590: wf_engine.SetItemAttrDate( p_item_type

586: );
587:
588:
589: -- set report end date
590: wf_engine.SetItemAttrDate( p_item_type
591: , p_item_key
592: , 'REPORT_END_DATE'
593: ,rec.report_end_date
594: );

Line 604: wf_engine.SetItemAttrNumber( p_item_type

600:
601: l_reported_by_id := pa_resource_utils.get_person_id(rec.reported_by);
602:
603:
604: wf_engine.SetItemAttrNumber( p_item_type
605: , p_item_key
606: , 'REPORTED_BY_ID'
607: ,l_reported_by_id
608: );

Line 659: wf_engine.SetItemAttrText( p_item_type

655: WF_DIRECTORY.AddUsersToAdHocRole2( l_reporter_role
656: , l_reporter_role_users_table); /*bug 5716959 */
657:
658:
659: wf_engine.SetItemAttrText( p_item_type
660: , p_item_key
661: , 'REPORTED_BY_NAME'
662: , l_reporter_role);
663: END IF;

Line 669: wf_engine.SetItemAttrText( p_item_type

665:
666: OPEN get_full_name_csr(l_reported_by_id);
667: FETCH get_full_name_csr INTO l_name ;
668:
669: wf_engine.SetItemAttrText( p_item_type
670: , p_item_key
671: , 'REPORTED_BY_FULL_NAME'
672: , l_name
673: );

Line 684: wf_engine.SetItemAttrNumber( p_item_type

680:
681: l_user_id := FND_GLOBAL.user_id;
682:
683:
684: wf_engine.SetItemAttrNumber( p_item_type
685: , p_item_key
686: , 'SUBMITTER_ID'
687: , l_user_id
688: );

Line 694: wf_engine.SetItemAttrText( p_item_type

690: OPEN get_full_name_csr(l_user_id);
691: FETCH get_full_name_csr INTO l_name;
692:
693:
694: wf_engine.SetItemAttrText( p_item_type
695: , p_item_key
696: , 'SUBMITTER_FULL_NAME'
697: , l_name
698: );

Line 704: wf_engine.SetItemAttrText( p_item_type

700: CLOSE get_full_name_csr;
701:
702:
703: /*Start of addition for bug 5027098 */
704: wf_engine.SetItemAttrText( p_item_type
705: , p_item_key
706: , 'FROM_ROLE_VALUE'
707: , FND_GLOBAL.USER_NAME);
708: /* End of addition for bug 5027098 */

Line 802: wf_engine.SetItemAttrText( p_item_type

798: WF_DIRECTORY.AddUsersToAdHocRole2( l_submitter_role
799: , l_role_users_table); /*bug 5716959*/
800:
801:
802: wf_engine.SetItemAttrText( p_item_type
803: , p_item_key
804: , 'REPORT_NOTFY_NAME'
805: , l_submitter_role);
806:

Line 807: wf_engine.SetItemAttrText( p_item_type

803: , p_item_key
804: , 'REPORT_NOTFY_NAME'
805: , l_submitter_role);
806:
807: wf_engine.SetItemAttrText( p_item_type
808: , p_item_key
809: , 'REPORT_SUBMITTER'
810: , l_submitter_role);
811:

Line 929: l_version_id := wf_engine.GetItemAttrNumber

925: territory VARCHAR2(2000);
926:
927: BEGIN
928:
929: l_version_id := wf_engine.GetItemAttrNumber
930: ( itemtype => p_item_type,
931: itemkey => p_item_key,
932: aname => 'VERSION_ID');
933:

Line 934: l_reported_by_id := wf_engine.GetItemAttrNumber

930: ( itemtype => p_item_type,
931: itemkey => p_item_key,
932: aname => 'VERSION_ID');
933:
934: l_reported_by_id := wf_engine.GetItemAttrNumber
935: ( itemtype => p_item_type,
936: itemkey => p_item_key,
937: aname => 'REPORTED_BY_ID');
938:

Line 982: wf_engine.SetItemAttrText( p_item_type

978:
979: END IF;
980:
981:
982: wf_engine.SetItemAttrText( p_item_type
983: , p_item_key
984: , 'REPORT_APPROVER_FULL_NAME'
985: , v_approvers.person_name);
986:

Line 988: wf_engine.SetItemAttrText( p_item_type

984: , 'REPORT_APPROVER_FULL_NAME'
985: , v_approvers.person_name);
986:
987:
988: wf_engine.SetItemAttrText( p_item_type
989: , p_item_key
990: , 'REPORT_APPROVER_USER_NAME'
991: , v_approvers.user_name);
992:

Line 1022: wf_engine.SetItemAttrText( p_item_type

1018: --, notification_preference => 'MAILTEXT'
1019: , EMAIL_ADDRESS =>v_approvers.email_address);
1020:
1021: END IF;
1022: wf_engine.SetItemAttrText( p_item_type
1023: , p_item_key
1024: , 'REPORT_APPROVER_FULL_NAME'
1025: , v_approvers.person_name);
1026:

Line 1027: wf_engine.SetItemAttrText( p_item_type

1023: , p_item_key
1024: , 'REPORT_APPROVER_FULL_NAME'
1025: , v_approvers.person_name);
1026:
1027: wf_engine.SetItemAttrText( p_item_type
1028: , p_item_key
1029: , 'REPORT_APPROVER_USER_NAME'
1030: , v_approvers.user_name);
1031:

Line 1055: wf_engine.SetItemAttrText( p_item_type

1051: --, notification_preference => 'MAILTEXT'
1052: , EMAIL_ADDRESS =>v_approvers.email_address);
1053: END IF;
1054:
1055: wf_engine.SetItemAttrText( p_item_type
1056: , p_item_key
1057: , 'REPORT_APPROVER_FULL_NAME'
1058: , v_approvers.person_name);
1059: wf_engine.SetItemAttrText( p_item_type

Line 1059: wf_engine.SetItemAttrText( p_item_type

1055: wf_engine.SetItemAttrText( p_item_type
1056: , p_item_key
1057: , 'REPORT_APPROVER_FULL_NAME'
1058: , v_approvers.person_name);
1059: wf_engine.SetItemAttrText( p_item_type
1060: , p_item_key
1061: , 'REPORT_APPROVER_USER_NAME'
1062: , v_approvers.user_name);
1063:

Line 1074: l_approver_name :=wf_engine.GetItemAttrText( p_item_type

1070:
1071: END IF;
1072:
1073: --Start of addition for bug 4165764
1074: l_approver_name :=wf_engine.GetItemAttrText( p_item_type
1075: , p_item_key
1076: , 'REPORT_APPROVER_FULL_NAME'
1077: );
1078: WF_DIRECTORY.CreateAdHocRole( role_name => l_approval_role

Line 1093: wf_engine.SetItemAttrText( p_item_type

1089:
1090: WF_DIRECTORY.AddUsersToAdHocRole2( l_approval_role
1091: , l_role_users_table); /*bug 5716959 */
1092:
1093: wf_engine.SetItemAttrText( p_item_type
1094: , p_item_key
1095: , 'REPORT_APPROVER_NAME'
1096: , l_approval_role);
1097:

Line 1099: resultout := wf_engine.eng_completed||':'||'T';

1095: , 'REPORT_APPROVER_NAME'
1096: , l_approval_role);
1097:
1098:
1099: resultout := wf_engine.eng_completed||':'||'T';
1100:
1101: OPEN get_user_name;
1102: FETCH get_user_name INTO l_user_name;
1103: CLOSE get_user_name;

Line 1117: resultout := wf_engine.eng_completed||':'||'F';

1113: ,'');
1114:
1115: ELSE
1116:
1117: resultout := wf_engine.eng_completed||':'||'F';
1118: END IF;
1119:
1120:
1121:

Line 1202: l_version_id := wf_engine.GetItemAttrNumber

1198: language VARCHAR2(2000);
1199: territory VARCHAR2(2000);
1200: BEGIN
1201:
1202: l_version_id := wf_engine.GetItemAttrNumber
1203: ( itemtype => p_item_type,
1204: itemkey => p_item_key,
1205: aname => 'VERSION_ID');
1206:

Line 1208: l_project_id := wf_engine.GetItemAttrNumber

1204: itemkey => p_item_key,
1205: aname => 'VERSION_ID');
1206:
1207:
1208: l_project_id := wf_engine.GetItemAttrNumber
1209: ( itemtype => p_item_type,
1210: itemkey => p_item_key,
1211: aname => 'PROJECT_ID');
1212:

Line 1295: wf_engine.SetItemAttrText( p_item_type

1291: -- , l_role_users); /* commented for bug 5716959 */
1292: WF_DIRECTORY.AddUsersToAdHocRole2( l_notify_role
1293: , l_role_users_table); /*bug 5716959 */
1294:
1295: wf_engine.SetItemAttrText( p_item_type
1296: , p_item_key
1297: , 'REPORT_NOTFY_NAME'
1298: , l_notify_role);
1299: END IF;

Line 1302: resultout := wf_engine.eng_completed||':'||'CANCELED';

1298: , l_notify_role);
1299: END IF;
1300:
1301: IF p_status = 'PROGRESS_REPORT_CANCELED' THEN
1302: resultout := wf_engine.eng_completed||':'||'CANCELED';
1303: ELSIF p_status = 'PROGRESS_REPORT_PUBLISHED' then
1304: resultout := wf_engine.eng_completed||':'||'PUBLISHED';
1305: END IF;
1306:

Line 1304: resultout := wf_engine.eng_completed||':'||'PUBLISHED';

1300:
1301: IF p_status = 'PROGRESS_REPORT_CANCELED' THEN
1302: resultout := wf_engine.eng_completed||':'||'CANCELED';
1303: ELSIF p_status = 'PROGRESS_REPORT_PUBLISHED' then
1304: resultout := wf_engine.eng_completed||':'||'PUBLISHED';
1305: END IF;
1306:
1307: ELSIF (p_status = 'PROGRESS_REPORT_REJECTED' or
1308: p_status = 'PROGRESS_REPORT_APPROVED' )THEN

Line 1311: resultout := wf_engine.eng_completed||':'||'REJECTED';

1307: ELSIF (p_status = 'PROGRESS_REPORT_REJECTED' or
1308: p_status = 'PROGRESS_REPORT_APPROVED' )THEN
1309:
1310: IF p_status = 'PROGRESS_REPORT_REJECTED' then
1311: resultout := wf_engine.eng_completed||':'||'REJECTED';
1312: ELSIF p_status = 'PROGRESS_REPORT_APPROVED' THEN
1313: resultout := wf_engine.eng_completed||':'||'APPROVED';
1314: END IF;
1315:

Line 1313: resultout := wf_engine.eng_completed||':'||'APPROVED';

1309:
1310: IF p_status = 'PROGRESS_REPORT_REJECTED' then
1311: resultout := wf_engine.eng_completed||':'||'REJECTED';
1312: ELSIF p_status = 'PROGRESS_REPORT_APPROVED' THEN
1313: resultout := wf_engine.eng_completed||':'||'APPROVED';
1314: END IF;
1315:
1316:
1317: -- Create adhoc role

Line 1434: wf_engine.SetItemAttrText( p_item_type

1430: -- , l_role_users); /* commented for bug 5716959 */
1431: WF_DIRECTORY.AddUsersToAdHocRole2( l_notify_role
1432: , l_role_users_table); /*bug 5716959*/
1433:
1434: wf_engine.SetItemAttrText( p_item_type
1435: , p_item_key
1436: , 'REPORT_NOTFY_NAME'
1437: , l_notify_role);
1438: END IF;