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_DIRECTORY

Line 71: WF_DIRECTORY.AddUsersToAdHocRole.

67: longer organization names to be accepted.
68: 31-Mar-2006 posingha Bug 5027098, Added code to set the 'From' role attribute
69: value for notifications.
70: 22-Feb-2007 posingha Bug 5716959: Changed calls to deprecated
71: WF_DIRECTORY.AddUsersToAdHocRole.
72: instead directly called
73: WF_DIRECTORY.AddUsersToAdHocRole2 API
74: Changes done in : Start_Workflow
75: Set_report_Approver

Line 73: WF_DIRECTORY.AddUsersToAdHocRole2 API

69: value for notifications.
70: 22-Feb-2007 posingha Bug 5716959: Changed calls to deprecated
71: WF_DIRECTORY.AddUsersToAdHocRole.
72: instead directly called
73: WF_DIRECTORY.AddUsersToAdHocRole2 API
74: Changes done in : Start_Workflow
75: Set_report_Approver
76: Set_report_notification_party
77: 26-Apr-2007 vvjoshi Bug#5962410 : Set an expiration date in CreateAdhocRole

Line 208: -- add user the adhoc role by calling WF_DIRECTORY.AddUsersToAdHocRole

204:
205: -- add user name to a user list. This user list can not have duplicate.
206: -- so remove any duplicate if necessary.
207:
208: -- add user the adhoc role by calling WF_DIRECTORY.AddUsersToAdHocRole
209: -- you can look at the original code in the procedure for example.
210:
211: -- set the item attribute REPORT_APPROVER_FULL_NAME and
212: -- REPORT_APPROVER_USER_NAME

Line 288: -- add user the adhoc role by calling WF_DIRECTORY.AddUsersToAdHocRole

284:
285: -- add user name to a user list. This user list can not have duplicate.
286: -- so remove any duplicate if necessary.
287:
288: -- add user the adhoc role by calling WF_DIRECTORY.AddUsersToAdHocRole
289: -- you can look at the original code in the procedure for example.
290:
291: -- set the item attribute REPORT_NOTFY_NAME
292:

Line 339: l_role_users_table WF_DIRECTORY.UserTable; /bug 5716959/

335: l_user_id NUMBER;
336: l_approval_required VARCHAR2(10);
337: l_submitted_by_user_name VARCHAR2(100);
338: l_project_id NUMBER;
339: l_role_users_table WF_DIRECTORY.UserTable; /*bug 5716959*/
340: l_reporter_role_users_table WF_DIRECTORY.UserTable; /*bug 5716959*/
341: l_count NUMBER := 1; /*bug 5716959*/
342:
343: CURSOR get_report_info IS

Line 340: l_reporter_role_users_table WF_DIRECTORY.UserTable; /bug 5716959/

336: l_approval_required VARCHAR2(10);
337: l_submitted_by_user_name VARCHAR2(100);
338: l_project_id NUMBER;
339: l_role_users_table WF_DIRECTORY.UserTable; /*bug 5716959*/
340: l_reporter_role_users_table WF_DIRECTORY.UserTable; /*bug 5716959*/
341: l_count NUMBER := 1; /*bug 5716959*/
342:
343: CURSOR get_report_info IS
344: SELECT pprv.*, pl.meaning progress_status FROM

Line 617: WF_DIRECTORY.CreateAdHocRole( role_name => l_reporter_role

613: -- Role must be less than 30 chars and all uppsercase
614: l_reporter_role := 'RPTBY_' || p_item_type || p_item_key;
615:
616:
617: WF_DIRECTORY.CreateAdHocRole( role_name => l_reporter_role
618: , role_display_name => l_reporter_role
619: , expiration_date => sysdate+1); -- Set expiration_date for bug#5962410
620:
621: -- l_reporter_role_users := NULL; /* Commented for bug 5716959 */

Line 631: wf_directory.getroleinfo(Upper(v_reporters.user_name),display_name,

627: -- l_reporter_role_users := l_reporter_role_users || ',';
628: -- end if; */ /* Commented for Bug 5716959*/
629:
630: -- Create adhoc users
631: wf_directory.getroleinfo(Upper(v_reporters.user_name),display_name,
632: email_address,notification_preference,language,territory);
633: if display_name is null THEN
634:
635:

Line 636: WF_DIRECTORY.CreateAdHocUser( name => v_reporters.user_name

632: email_address,notification_preference,language,territory);
633: if display_name is null THEN
634:
635:
636: WF_DIRECTORY.CreateAdHocUser( name => v_reporters.user_name
637: , display_name => v_reporters.person_name
638: --, notification_preference => 'MAILTEXT'
639: , EMAIL_ADDRESS =>v_reporters.email_address);
640:

Line 653: -- WF_DIRECTORY.AddUsersToAdHocRole( l_reporter_role

649: -- IF (l_reporter_role_users is NOT NULL) THEN /* commented out for Bug 5716959 */
650: IF (l_reporter_role_users_table.COUNT > 0 ) THEN /*bug 5716959*/
651:
652:
653: -- WF_DIRECTORY.AddUsersToAdHocRole( l_reporter_role
654: -- , l_reporter_role_users); -- /*Commented for Bug 5716959*/
655: WF_DIRECTORY.AddUsersToAdHocRole2( l_reporter_role
656: , l_reporter_role_users_table); /*bug 5716959 */
657:

Line 655: WF_DIRECTORY.AddUsersToAdHocRole2( l_reporter_role

651:
652:
653: -- WF_DIRECTORY.AddUsersToAdHocRole( l_reporter_role
654: -- , l_reporter_role_users); -- /*Commented for Bug 5716959*/
655: WF_DIRECTORY.AddUsersToAdHocRole2( l_reporter_role
656: , l_reporter_role_users_table); /*bug 5716959 */
657:
658:
659: wf_engine.SetItemAttrText( p_item_type

Line 722: WF_DIRECTORY.CreateAdHocRole( role_name => l_submitter_role

718: -- Role must be less than 30 chars and all uppsercase
719: l_submitter_role := 'RPT_' || p_item_type || p_item_key;
720:
721:
722: WF_DIRECTORY.CreateAdHocRole( role_name => l_submitter_role
723: , role_display_name => l_submitter_role
724: , expiration_date => sysdate+1); -- Set expiration_date for bug#5962410
725:
726: l_count := 1; /*Bug 5716959*/

Line 734: wf_directory.getroleinfo(Upper(v_submitters.user_name),display_name,

730: l_role_users := l_role_users || ',';
731: end if;
732:
733: -- Create adhoc users
734: wf_directory.getroleinfo(Upper(v_submitters.user_name),display_name,
735: email_address,notification_preference,language,territory);
736: if display_name is null THEN
737:
738:

Line 739: WF_DIRECTORY.CreateAdHocUser( name => v_submitters.user_name

735: email_address,notification_preference,language,territory);
736: if display_name is null THEN
737:
738:
739: WF_DIRECTORY.CreateAdHocUser( name => v_submitters.user_name
740: , display_name => v_submitters.person_name
741: --, notification_preference => 'MAILTEXT'
742: , EMAIL_ADDRESS =>v_submitters.email_address);
743: END IF;

Line 774: wf_directory.getroleinfo(Upper(v_reporters.user_name),display_name,

770: l_role_users := l_role_users || ',';
771: end if;
772:
773: -- Create adhoc users
774: wf_directory.getroleinfo(Upper(v_reporters.user_name),display_name,
775: email_address,notification_preference,language,territory);
776: if display_name is null THEN
777:
778: WF_DIRECTORY.CreateAdHocUser( name => v_reporters.user_name

Line 778: WF_DIRECTORY.CreateAdHocUser( name => v_reporters.user_name

774: wf_directory.getroleinfo(Upper(v_reporters.user_name),display_name,
775: email_address,notification_preference,language,territory);
776: if display_name is null THEN
777:
778: WF_DIRECTORY.CreateAdHocUser( name => v_reporters.user_name
779: , display_name => v_reporters.person_name
780: --, notification_preference => 'MAILTEXT'
781: , EMAIL_ADDRESS =>v_reporters.email_address);
782:

Line 796: -- WF_DIRECTORY.AddUsersToAdHocRole( l_submitter_role

792: -- IF (l_role_users is NOT NULL) THEN /* commented for bug 5716959 */
793: IF (l_role_users_table.COUNT > 0) THEN /*bug 5716959*/
794:
795:
796: -- WF_DIRECTORY.AddUsersToAdHocRole( l_submitter_role
797: -- , l_role_users); /* commented for bug 5716959 */
798: WF_DIRECTORY.AddUsersToAdHocRole2( l_submitter_role
799: , l_role_users_table); /*bug 5716959*/
800:

Line 798: WF_DIRECTORY.AddUsersToAdHocRole2( l_submitter_role

794:
795:
796: -- WF_DIRECTORY.AddUsersToAdHocRole( l_submitter_role
797: -- , l_role_users); /* commented for bug 5716959 */
798: WF_DIRECTORY.AddUsersToAdHocRole2( l_submitter_role
799: , l_role_users_table); /*bug 5716959*/
800:
801:
802: wf_engine.SetItemAttrText( p_item_type

Line 850: l_role_users_table WF_DIRECTORY.UserTable; /bug 5716959/

846: l_approver_source_type NUMBER;
847: l_approver_name per_all_people_f.full_name%type; --Added for bug 4165764.
848:
849: l_user_name VARCHAR2(250);
850: l_role_users_table WF_DIRECTORY.UserTable; /*bug 5716959*/
851: l_count NUMBER := 1; /*bug 5716959*/
852: CURSOR get_user_name
853: IS
854: SELECT user_name

Line 942: WF_DIRECTORY.CreateAdHocRole( role_name => l_approval_role

938:
939: l_approval_role := 'APVR_' ||p_item_type || p_item_key;
940:
941: /* Commented for bug 4165764
942: WF_DIRECTORY.CreateAdHocRole( role_name => l_approval_role
943: , role_display_name => l_approval_role
944: , expiration_date => null
945: ); */
946:

Line 968: wf_directory.getroleinfo(Upper(v_approvers.user_name),display_name,

964: -- l_role_users := l_role_users || ',';
965: -- end if; /* commented for bug 5716959 */
966:
967: -- Create adhoc users
968: wf_directory.getroleinfo(Upper(v_approvers.user_name),display_name,
969: email_address,notification_preference,language,territory);
970: if display_name is null THEN
971:
972:

Line 973: WF_DIRECTORY.CreateAdHocUser( name => v_approvers.user_name

969: email_address,notification_preference,language,territory);
970: if display_name is null THEN
971:
972:
973: WF_DIRECTORY.CreateAdHocUser( name => v_approvers.user_name
974: , display_name => v_approvers.person_name
975: --, notification_preference => 'MAILTEXT'
976: , EMAIL_ADDRESS =>v_approvers.email_address);
977:

Line 1011: wf_directory.getroleinfo(Upper(v_approvers.user_name),display_name,

1007: -- l_role_users := l_role_users || ',';
1008: -- end if; /* commented for bug 5716959 */
1009:
1010: -- Create adhoc users
1011: wf_directory.getroleinfo(Upper(v_approvers.user_name),display_name,
1012: email_address,notification_preference,language,territory);
1013: if display_name is null THEN
1014:
1015:

Line 1016: WF_DIRECTORY.CreateAdHocUser( name => v_approvers.user_name

1012: email_address,notification_preference,language,territory);
1013: if display_name is null THEN
1014:
1015:
1016: WF_DIRECTORY.CreateAdHocUser( name => v_approvers.user_name
1017: , display_name => v_approvers.person_name
1018: --, notification_preference => 'MAILTEXT'
1019: , EMAIL_ADDRESS =>v_approvers.email_address);
1020:

Line 1044: wf_directory.getroleinfo(Upper(v_approvers.user_name),display_name,

1040: -- l_role_users := l_role_users || ',';
1041: -- end if; /* commented for bug 5716959 */
1042:
1043: -- Create adhoc users
1044: wf_directory.getroleinfo(Upper(v_approvers.user_name),display_name,
1045: email_address,notification_preference,language,territory);
1046: if display_name is null THEN
1047:
1048:

Line 1049: WF_DIRECTORY.CreateAdHocUser( name => v_approvers.user_name

1045: email_address,notification_preference,language,territory);
1046: if display_name is null THEN
1047:
1048:
1049: WF_DIRECTORY.CreateAdHocUser( name => v_approvers.user_name
1050: , display_name => v_approvers.person_name
1051: --, notification_preference => 'MAILTEXT'
1052: , EMAIL_ADDRESS =>v_approvers.email_address);
1053: END IF;

Line 1078: WF_DIRECTORY.CreateAdHocRole( role_name => l_approval_role

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
1079: , role_display_name => l_approver_name
1080: , expiration_date => sysdate+1 -- Set expiration_date for bug#5962410
1081: );
1082:

Line 1087: -- WF_DIRECTORY.AddUsersToAdHocRole( l_approval_role

1083: -- End of Addition for bug 4165764
1084:
1085: -- IF (l_role_users is NOT NULL) THEN /* commented for bug 5716959 */
1086: IF (l_role_users_table.COUNT > 0 ) THEN /* bug 5716959 */
1087: -- WF_DIRECTORY.AddUsersToAdHocRole( l_approval_role
1088: -- , l_role_users); /* commented for bug 5716959 */
1089:
1090: WF_DIRECTORY.AddUsersToAdHocRole2( l_approval_role
1091: , l_role_users_table); /*bug 5716959 */

Line 1090: WF_DIRECTORY.AddUsersToAdHocRole2( l_approval_role

1086: IF (l_role_users_table.COUNT > 0 ) THEN /* bug 5716959 */
1087: -- WF_DIRECTORY.AddUsersToAdHocRole( l_approval_role
1088: -- , l_role_users); /* commented for bug 5716959 */
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

Line 1162: l_role_users_table WF_DIRECTORY.UserTable; /bug 5716959/

1158: l_msg_count NUMBER;
1159: l_msg_data VARCHAR2(2000);
1160: i INTEGER;
1161:
1162: l_role_users_table WF_DIRECTORY.UserTable; /*bug 5716959*/
1163: l_count NUMBER := 1 ; /*bug 5716959 */
1164:
1165: CURSOR get_object_page_layout_id
1166: IS

Line 1230: WF_DIRECTORY.CreateAdHocRole( role_name => l_notify_role

1226:
1227:
1228:
1229:
1230: WF_DIRECTORY.CreateAdHocRole( role_name => l_notify_role
1231: , role_display_name => l_notify_role
1232: , expiration_date => sysdate+1); -- Set expiration_date for bug#5962410
1233:
1234:

Line 1270: wf_directory.getroleinfo(Upper(l_user_names(i)),display_name,

1266: end if;
1267:
1268:
1269:
1270: wf_directory.getroleinfo(Upper(l_user_names(i)),display_name,
1271: email_address,notification_preference,language,territory);
1272: if display_name is null THEN
1273:
1274:

Line 1275: WF_DIRECTORY.CreateAdHocUser( name => l_user_names(i)

1271: email_address,notification_preference,language,territory);
1272: if display_name is null THEN
1273:
1274:
1275: WF_DIRECTORY.CreateAdHocUser( name => l_user_names(i)
1276: , display_name => l_full_names(i)
1277: , EMAIL_ADDRESS =>l_email_addresses(i));
1278: END IF;
1279: l_role_users := l_role_users || l_user_names(i);

Line 1290: -- WF_DIRECTORY.AddUsersToAdHocRole( l_notify_role

1286:
1287: -- IF (l_role_users is NOT NULL) THEN /* commented out for bug 5716959 */
1288: IF (l_role_users_table.COUNT > 0) THEN /* bug 5716959 */
1289:
1290: -- WF_DIRECTORY.AddUsersToAdHocRole( l_notify_role
1291: -- , l_role_users); /* commented for bug 5716959 */
1292: WF_DIRECTORY.AddUsersToAdHocRole2( l_notify_role
1293: , l_role_users_table); /*bug 5716959 */
1294:

Line 1292: WF_DIRECTORY.AddUsersToAdHocRole2( l_notify_role

1288: IF (l_role_users_table.COUNT > 0) THEN /* bug 5716959 */
1289:
1290: -- WF_DIRECTORY.AddUsersToAdHocRole( l_notify_role
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

Line 1322: WF_DIRECTORY.CreateAdHocRole( role_name => l_notify_role

1318: -- Role must be less than 30 chars and all uppsercase
1319: l_notify_role := 'RNT_' || p_item_type || p_item_key;
1320:
1321:
1322: WF_DIRECTORY.CreateAdHocRole( role_name => l_notify_role
1323: , role_display_name => l_notify_role
1324: , expiration_date => sysdate+1); -- Set expiration_date for bug#5962410
1325:
1326: -- Bug 6843694 : Changed call to procedure get_dist_list_email

Line 1357: wf_directory.getroleinfo(Upper(l_user_names(i)),display_name,

1353: l_role_users := l_role_users || ',';
1354: end if;
1355:
1356:
1357: wf_directory.getroleinfo(Upper(l_user_names(i)),display_name,
1358: email_address,notification_preference,language,territory);
1359: if display_name is null THEN
1360:
1361: WF_DIRECTORY.CreateAdHocUser( name => l_user_names(i)

Line 1361: WF_DIRECTORY.CreateAdHocUser( name => l_user_names(i)

1357: wf_directory.getroleinfo(Upper(l_user_names(i)),display_name,
1358: email_address,notification_preference,language,territory);
1359: if display_name is null THEN
1360:
1361: WF_DIRECTORY.CreateAdHocUser( name => l_user_names(i)
1362: , display_name => l_full_names(i)
1363: , EMAIL_ADDRESS =>l_email_addresses(i));
1364: END IF;
1365: l_role_users := l_role_users || l_user_names(i);

Line 1408: wf_directory.getroleinfo(Upper(v_people.user_name),

1404: end if;
1405:
1406:
1407: -- Create adhoc users
1408: wf_directory.getroleinfo(Upper(v_people.user_name),
1409: display_name,
1410: email_address,
1411: notification_preference,
1412: language,territory);

Line 1415: WF_DIRECTORY.CreateAdHocUser( name => v_people.user_name

1411: notification_preference,
1412: language,territory);
1413: if display_name is null THEN
1414:
1415: WF_DIRECTORY.CreateAdHocUser( name => v_people.user_name
1416: , display_name => v_people.person_name
1417: --, notification_preference => 'MAILTEXT'
1418: , EMAIL_ADDRESS =>v_people.email_address);
1419: END IF;

Line 1429: -- WF_DIRECTORY.AddUsersToAdHocRole( l_notify_role

1425: end loop;
1426:
1427: -- IF (l_role_users is NOT NULL) THEN /* commented for bug 5716959 */
1428: IF (l_role_users_table.COUNT > 0) THEN /*bug 5716959*/
1429: -- WF_DIRECTORY.AddUsersToAdHocRole( l_notify_role
1430: -- , l_role_users); /* commented for bug 5716959 */
1431: WF_DIRECTORY.AddUsersToAdHocRole2( l_notify_role
1432: , l_role_users_table); /*bug 5716959*/
1433:

Line 1431: WF_DIRECTORY.AddUsersToAdHocRole2( l_notify_role

1427: -- IF (l_role_users is NOT NULL) THEN /* commented for bug 5716959 */
1428: IF (l_role_users_table.COUNT > 0) THEN /*bug 5716959*/
1429: -- WF_DIRECTORY.AddUsersToAdHocRole( l_notify_role
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