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 133: wf_engine.SetItemAttrNumber( p_item_type

129: -- workflow approval process to work properly. For example, item_type,
130: -- item_key, etc. The best way to override this procedure is to copy the
131: -- code from start_workflow procedure and add your logic to the very end.
132:
133: wf_engine.SetItemAttrNumber( p_item_type
134: , p_item_key
135: , 'VERSION_ID'
136: , p_version_id
137: );

Line 140: wf_engine.SetItemAttrNumber( p_item_type

136: , p_version_id
137: );
138:
139:
140: wf_engine.SetItemAttrNumber( p_item_type
141: , p_item_key
142: , 'WF_OBJECT_ID'
143: , p_version_id
144: );

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

142: , 'WF_OBJECT_ID'
143: , p_version_id
144: );
145:
146: wf_engine.SetItemAttrText(itemtype => p_item_type,
147: itemkey => p_item_key,
148: aname => 'HISTORY',
149: avalue =>
150: 'PLSQL:PA_WORKFLOW_HISTORY.show_history/'||

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

222: -- set item attribute REPORT_APPROVER_NAME
223: -- this is very important, with out this attribute set, the approval process
224: -- will not work
225:
226: -- set return result to wf_engine.eng_completed||':'||'T';
227:
228: -- save the comment history to record info such as
229: -- "Submitter zzzz submit report xxx on this date"
230:

Line 455: wf_engine.SetItemAttrNumber( p_item_type

451:
452: x_return_status := FND_API.G_RET_STS_SUCCESS;
453:
454:
455: wf_engine.SetItemAttrNumber( p_item_type
456: , p_item_key
457: , 'VERSION_ID'
458: , p_version_id
459: );

Line 462: wf_engine.SetItemAttrNumber( p_item_type

458: , p_version_id
459: );
460:
461:
462: wf_engine.SetItemAttrNumber( p_item_type
463: , p_item_key
464: , 'WF_OBJECT_ID'
465: , p_version_id
466: );

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

464: , 'WF_OBJECT_ID'
465: , p_version_id
466: );
467:
468: wf_engine.SetItemAttrText(itemtype => p_item_type,
469: itemkey => p_item_key,
470: aname => 'HISTORY',
471: avalue =>
472: 'PLSQL:PA_WORKFLOW_HISTORY.show_history/'||

Line 483: wf_engine.SetItemAttrText( p_item_type

479: OPEN get_approval_required;
480: FETCH get_approval_required INTO l_approval_required;
481: CLOSE get_approval_required;
482:
483: wf_engine.SetItemAttrText( p_item_type
484: , p_item_key
485: , 'AUTO_APPROVED'
486: , l_approval_required
487: );

Line 494: wf_engine.SetItemAttrText( p_item_type

490: FOR rec IN get_report_info LOOP
491:
492:
493: -- set project id
494: wf_engine.SetItemAttrText( p_item_type
495: , p_item_key
496: , 'REPORT_TYPE'
497: , rec.report_type_name);
498:

Line 499: wf_engine.SetItemAttrText( p_item_type

495: , p_item_key
496: , 'REPORT_TYPE'
497: , rec.report_type_name);
498:
499: wf_engine.SetItemAttrText( p_item_type
500: , p_item_key
501: , 'LAST_UPDATED_BY'
502: , rec.last_updated_by);
503:

Line 505: wf_engine.SetItemAttrText( p_item_type

501: , 'LAST_UPDATED_BY'
502: , rec.last_updated_by);
503:
504:
505: wf_engine.SetItemAttrText( p_item_type
506: , p_item_key
507: , 'PROJECT_ID'
508: ,rec.object_id
509: );

Line 518: wf_engine.SetItemAttrText( p_item_type

514: l_url2 := 'JSP:/OA_HTML/OA.jsp?paReportVersionId='||p_version_id ||'&paProjectId='|| rec.object_id||
515: '&akRegionCode=PA_PROG_REP_REVIEW_LAYOUT&akRegionApplicationId=275&paPageMode=APPROVE&addBreadCrumb=RP';
516:
517:
518: wf_engine.SetItemAttrText( p_item_type
519: , p_item_key
520: , 'REPORT_LINK'
521: , l_url2
522: );

Line 532: wf_engine.SetItemAttrText( p_item_type

528:
529: FETCH get_project_info INTO l_customer,l_project_manager, l_org;
530:
531:
532: wf_engine.SetItemAttrText( p_item_type
533: , p_item_key
534: , 'PROJECT_MANAGER'
535: ,l_project_manager
536: );

Line 538: wf_engine.SetItemAttrText( p_item_type

534: , 'PROJECT_MANAGER'
535: ,l_project_manager
536: );
537:
538: wf_engine.SetItemAttrText( p_item_type
539: , p_item_key
540: , 'ORGANIZATION'
541: ,l_org
542: );

Line 543: wf_engine.SetItemAttrText( p_item_type

539: , p_item_key
540: , 'ORGANIZATION'
541: ,l_org
542: );
543: wf_engine.SetItemAttrText( p_item_type
544: , p_item_key
545: , 'CUSTOMER'
546: ,l_customer
547: );

Line 558: wf_engine.SetItemAttrText( p_item_type

554: -- set project name and number
555: pa_utils.getprojinfo(rec.object_id, l_project_number, l_project_name);
556:
557:
558: wf_engine.SetItemAttrText( p_item_type
559: , p_item_key
560: , 'PROJECT_NAME'
561: ,l_project_name
562: );

Line 564: wf_engine.SetItemAttrText( p_item_type

560: , 'PROJECT_NAME'
561: ,l_project_name
562: );
563:
564: wf_engine.SetItemAttrText( p_item_type
565: , p_item_key
566: , 'PROJECT_NUMBER'
567: ,l_project_number
568: );

Line 573: wf_engine.SetItemAttrText( p_item_type

569:
570:
571:
572: -- set record_version_number
573: wf_engine.SetItemAttrText( p_item_type
574: , p_item_key
575: , 'RECORD_VERSION_NUMBER'
576: ,rec.record_version_number
577: );

Line 581: wf_engine.SetItemAttrDate( p_item_type

577: );
578:
579:
580: -- set report start date
581: wf_engine.SetItemAttrDate( p_item_type
582: , p_item_key
583: , 'REPORT_START_DATE'
584: ,rec.report_start_date
585: );

Line 588: wf_engine.SetItemAttrText( p_item_type

584: ,rec.report_start_date
585: );
586:
587: -- set progress status
588: wf_engine.SetItemAttrText( p_item_type
589: , p_item_key
590: , 'PROGRESS_STATUS'
591: ,rec.progress_status
592: );

Line 596: wf_engine.SetItemAttrText( p_item_type

592: );
593:
594:
595: -- set report status code
596: wf_engine.SetItemAttrText( p_item_type
597: , p_item_key
598: , 'REPORT_STATUS'
599: ,rec.report_status_code
600: );

Line 604: wf_engine.SetItemAttrDate( p_item_type

600: );
601:
602:
603: -- set report end date
604: wf_engine.SetItemAttrDate( p_item_type
605: , p_item_key
606: , 'REPORT_END_DATE'
607: ,rec.report_end_date
608: );

Line 618: wf_engine.SetItemAttrNumber( p_item_type

614:
615: l_reported_by_id := pa_resource_utils.get_person_id(rec.reported_by);
616:
617:
618: wf_engine.SetItemAttrNumber( p_item_type
619: , p_item_key
620: , 'REPORTED_BY_ID'
621: ,l_reported_by_id
622: );

Line 673: wf_engine.SetItemAttrText( p_item_type

669: WF_DIRECTORY.AddUsersToAdHocRole2( l_reporter_role
670: , l_reporter_role_users_table); /*bug 5716959 */
671:
672:
673: wf_engine.SetItemAttrText( p_item_type
674: , p_item_key
675: , 'REPORTED_BY_NAME'
676: , l_reporter_role);
677: END IF;

Line 683: wf_engine.SetItemAttrText( p_item_type

679:
680: OPEN get_full_name_csr(l_reported_by_id);
681: FETCH get_full_name_csr INTO l_name ;
682:
683: wf_engine.SetItemAttrText( p_item_type
684: , p_item_key
685: , 'REPORTED_BY_FULL_NAME'
686: , l_name
687: );

Line 698: wf_engine.SetItemAttrNumber( p_item_type

694:
695: l_user_id := FND_GLOBAL.user_id;
696:
697:
698: wf_engine.SetItemAttrNumber( p_item_type
699: , p_item_key
700: , 'SUBMITTER_ID'
701: , l_user_id
702: );

Line 708: wf_engine.SetItemAttrText( p_item_type

704: OPEN get_full_name_csr(l_user_id);
705: FETCH get_full_name_csr INTO l_name;
706:
707:
708: wf_engine.SetItemAttrText( p_item_type
709: , p_item_key
710: , 'SUBMITTER_FULL_NAME'
711: , l_name
712: );

Line 718: wf_engine.SetItemAttrText( p_item_type

714: CLOSE get_full_name_csr;
715:
716:
717: /*Start of addition for bug 5027098 */
718: wf_engine.SetItemAttrText( p_item_type
719: , p_item_key
720: , 'FROM_ROLE_VALUE'
721: , FND_GLOBAL.USER_NAME);
722: /* End of addition for bug 5027098 */

Line 734: wf_engine.SetItemAttrText( p_item_type

730: if (l_doc_attach_count > 0 ) then
731: l_attachment_url := 'JSP:/OA_HTML/OA.jsp?page=/oracle/apps/pa/progress/webui/PaProgRepAttachPG'
732: ||'&'||'paReportVersionId='||p_version_id
733: ||'&'||'addBreadCrumb=Y';
734: wf_engine.SetItemAttrText( p_item_type
735: , p_item_key
736: , 'ATTACHMENT_URL'
737: , l_attachment_url);
738: end if;

Line 831: wf_engine.SetItemAttrText( p_item_type

827: WF_DIRECTORY.AddUsersToAdHocRole2( l_submitter_role
828: , l_role_users_table); /*bug 5716959*/
829:
830:
831: wf_engine.SetItemAttrText( p_item_type
832: , p_item_key
833: , 'REPORT_NOTFY_NAME'
834: , l_submitter_role);
835:

Line 836: wf_engine.SetItemAttrText( p_item_type

832: , p_item_key
833: , 'REPORT_NOTFY_NAME'
834: , l_submitter_role);
835:
836: wf_engine.SetItemAttrText( p_item_type
837: , p_item_key
838: , 'REPORT_SUBMITTER'
839: , l_submitter_role);
840:

Line 964: l_version_id := wf_engine.GetItemAttrNumber

960: territory VARCHAR2(2000);
961:
962: BEGIN
963:
964: l_version_id := wf_engine.GetItemAttrNumber
965: ( itemtype => p_item_type,
966: itemkey => p_item_key,
967: aname => 'VERSION_ID');
968:

Line 969: l_reported_by_id := wf_engine.GetItemAttrNumber

965: ( itemtype => p_item_type,
966: itemkey => p_item_key,
967: aname => 'VERSION_ID');
968:
969: l_reported_by_id := wf_engine.GetItemAttrNumber
970: ( itemtype => p_item_type,
971: itemkey => p_item_key,
972: aname => 'REPORTED_BY_ID');
973:

Line 1031: wf_engine.SetItemAttrText( p_item_type

1027:
1028: END IF;
1029:
1030:
1031: wf_engine.SetItemAttrText( p_item_type
1032: , p_item_key
1033: , 'REPORT_APPROVER_FULL_NAME'
1034: , v_approvers.person_name);
1035:

Line 1037: wf_engine.SetItemAttrText( p_item_type

1033: , 'REPORT_APPROVER_FULL_NAME'
1034: , v_approvers.person_name);
1035:
1036:
1037: wf_engine.SetItemAttrText( p_item_type
1038: , p_item_key
1039: , 'REPORT_APPROVER_USER_NAME'
1040: , v_approvers.user_name);
1041:

Line 1071: wf_engine.SetItemAttrText( p_item_type

1067: --, notification_preference => 'MAILTEXT'
1068: , EMAIL_ADDRESS =>v_approvers.email_address);
1069:
1070: END IF;
1071: wf_engine.SetItemAttrText( p_item_type
1072: , p_item_key
1073: , 'REPORT_APPROVER_FULL_NAME'
1074: , v_approvers.person_name);
1075:

Line 1076: wf_engine.SetItemAttrText( p_item_type

1072: , p_item_key
1073: , 'REPORT_APPROVER_FULL_NAME'
1074: , v_approvers.person_name);
1075:
1076: wf_engine.SetItemAttrText( p_item_type
1077: , p_item_key
1078: , 'REPORT_APPROVER_USER_NAME'
1079: , v_approvers.user_name);
1080:

Line 1106: wf_engine.SetItemAttrText( p_item_type

1102: --, notification_preference => 'MAILTEXT'
1103: , EMAIL_ADDRESS =>v_approvers.email_address);
1104: END IF;
1105:
1106: wf_engine.SetItemAttrText( p_item_type
1107: , p_item_key
1108: , 'REPORT_APPROVER_FULL_NAME'
1109: , v_approvers.person_name);
1110: wf_engine.SetItemAttrText( p_item_type

Line 1110: wf_engine.SetItemAttrText( p_item_type

1106: wf_engine.SetItemAttrText( p_item_type
1107: , p_item_key
1108: , 'REPORT_APPROVER_FULL_NAME'
1109: , v_approvers.person_name);
1110: wf_engine.SetItemAttrText( p_item_type
1111: , p_item_key
1112: , 'REPORT_APPROVER_USER_NAME'
1113: , v_approvers.user_name);
1114:

Line 1125: l_approver_name :=wf_engine.GetItemAttrText( p_item_type

1121: END LOOP;
1122: END IF;
1123:
1124: END IF;
1125: l_approver_name :=wf_engine.GetItemAttrText( p_item_type
1126: , p_item_key
1127: , 'REPORT_APPROVER_FULL_NAME'
1128: );
1129: WF_DIRECTORY.CreateAdHocRole( role_name => l_approval_role

Line 1142: wf_engine.SetItemAttrText( p_item_type

1138:
1139: WF_DIRECTORY.AddUsersToAdHocRole2( l_approval_role
1140: , l_role_users_table); /*bug 5716959 */
1141:
1142: wf_engine.SetItemAttrText( p_item_type
1143: , p_item_key
1144: , 'REPORT_APPROVER_NAME'
1145: , l_approval_role);
1146:

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

1144: , 'REPORT_APPROVER_NAME'
1145: , l_approval_role);
1146:
1147:
1148: resultout := wf_engine.eng_completed||':'||'T';
1149:
1150: OPEN get_user_name;
1151: FETCH get_user_name INTO l_user_name;
1152: CLOSE get_user_name;

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

1162: ,'');
1163:
1164: ELSE
1165:
1166: resultout := wf_engine.eng_completed||':'||'F';
1167: END IF;
1168:
1169: end if;
1170: close role_info; -- Bug 14326815

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

1167: END IF;
1168:
1169: end if;
1170: close role_info; -- Bug 14326815
1171: resultout := wf_engine.eng_completed||':'||'T';
1172: commit;
1173:
1174:
1175:

Line 1252: l_version_id := wf_engine.GetItemAttrNumber

1248: language VARCHAR2(2000);
1249: territory VARCHAR2(2000);
1250: BEGIN
1251:
1252: l_version_id := wf_engine.GetItemAttrNumber
1253: ( itemtype => p_item_type,
1254: itemkey => p_item_key,
1255: aname => 'VERSION_ID');
1256:

Line 1258: l_project_id := wf_engine.GetItemAttrNumber

1254: itemkey => p_item_key,
1255: aname => 'VERSION_ID');
1256:
1257:
1258: l_project_id := wf_engine.GetItemAttrNumber
1259: ( itemtype => p_item_type,
1260: itemkey => p_item_key,
1261: aname => 'PROJECT_ID');
1262:

Line 1345: wf_engine.SetItemAttrText( p_item_type

1341: -- , l_role_users); /* commented for bug 5716959 */
1342: WF_DIRECTORY.AddUsersToAdHocRole2( l_notify_role
1343: , l_role_users_table); /*bug 5716959 */
1344:
1345: wf_engine.SetItemAttrText( p_item_type
1346: , p_item_key
1347: , 'REPORT_NOTFY_NAME'
1348: , l_notify_role);
1349: END IF;

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

1348: , l_notify_role);
1349: END IF;
1350:
1351: IF p_status = 'PROGRESS_REPORT_CANCELED' THEN
1352: resultout := wf_engine.eng_completed||':'||'CANCELED';
1353: ELSIF p_status = 'PROGRESS_REPORT_PUBLISHED' then
1354: resultout := wf_engine.eng_completed||':'||'PUBLISHED';
1355: END IF;
1356:

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

1350:
1351: IF p_status = 'PROGRESS_REPORT_CANCELED' THEN
1352: resultout := wf_engine.eng_completed||':'||'CANCELED';
1353: ELSIF p_status = 'PROGRESS_REPORT_PUBLISHED' then
1354: resultout := wf_engine.eng_completed||':'||'PUBLISHED';
1355: END IF;
1356:
1357: ELSIF (p_status = 'PROGRESS_REPORT_REJECTED' or
1358: p_status = 'PROGRESS_REPORT_APPROVED' )THEN

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

1357: ELSIF (p_status = 'PROGRESS_REPORT_REJECTED' or
1358: p_status = 'PROGRESS_REPORT_APPROVED' )THEN
1359:
1360: IF p_status = 'PROGRESS_REPORT_REJECTED' then
1361: resultout := wf_engine.eng_completed||':'||'REJECTED';
1362: ELSIF p_status = 'PROGRESS_REPORT_APPROVED' THEN
1363: resultout := wf_engine.eng_completed||':'||'APPROVED';
1364: END IF;
1365:

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

1359:
1360: IF p_status = 'PROGRESS_REPORT_REJECTED' then
1361: resultout := wf_engine.eng_completed||':'||'REJECTED';
1362: ELSIF p_status = 'PROGRESS_REPORT_APPROVED' THEN
1363: resultout := wf_engine.eng_completed||':'||'APPROVED';
1364: END IF;
1365:
1366:
1367: -- Create adhoc role

Line 1484: wf_engine.SetItemAttrText( p_item_type

1480: -- , l_role_users); /* commented for bug 5716959 */
1481: WF_DIRECTORY.AddUsersToAdHocRole2( l_notify_role
1482: , l_role_users_table); /*bug 5716959*/
1483:
1484: wf_engine.SetItemAttrText( p_item_type
1485: , p_item_key
1486: , 'REPORT_NOTFY_NAME'
1487: , l_notify_role);
1488: END IF;