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.ENG_WORKFLOW_UTIL dependencies on WF_DIRECTORY

Line 674: WF_DIRECTORY.SetAdHocRoleStatus( role_name => p_role_name

670: --
671: -- if p_role does not exist, it throws exception
672: -- So we should not write sql to check AdhocRole existence directly
673: -- For safety purpose we just don't care about this execption
674: WF_DIRECTORY.SetAdHocRoleStatus( role_name => p_role_name
675: , status => 'ACTIVE') ;
676:
677: -- l_existence := TRUE ;
678: -- OWF.G Bug3490260

Line 679: -- Added additoinal check because WF_DIRECTORY.SetAdHocRoleStatus

675: , status => 'ACTIVE') ;
676:
677: -- l_existence := TRUE ;
678: -- OWF.G Bug3490260
679: -- Added additoinal check because WF_DIRECTORY.SetAdHocRoleStatus
680: -- does not raise exception correctly
681: -- Once the bug is fixed need to remove
682: FOR l_rec IN c_role(p_role_name => p_role_name)
683: LOOP

Line 734: WF_DIRECTORY.SetAdhocRoleExpiration

730: -- So we can not write correct sql to check AdhocRole existence
731: -- before calling SetAdhocRoleExpiration
732: -- For safety purpose we just don't care about this execption
733: --
734: WF_DIRECTORY.SetAdhocRoleExpiration
735: ( role_name => p_role_name
736: , expiration_date => SYSDATE) ;
737:
738: exception

Line 747: -- WF Directory related OBSOLETE APIs for Bug4532263

743:
744: END DeleteRoleAndUsers ;
745:
746: -------------------------------------------------------------------
747: -- WF Directory related OBSOLETE APIs for Bug4532263
748: -- Replaced with new APIs with post_fix 2
749: -- Keep APIs here for any customization
750: -------------------------------------------------------------------
751: -- Set User to Role Users

Line 774: IF (WF_DIRECTORY.UserActive(l_user_role ))

770: LOOP
771:
772: l_user_role := person_rec.user_role ;
773:
774: IF (WF_DIRECTORY.UserActive(l_user_role ))
775: THEN
776:
777: -- Prevent duplicate user
778: IF x_role_users IS NULL OR

Line 814: IF (WF_DIRECTORY.UserActive(l_user_role ))

810: BEGIN
811:
812: l_user_role := GetUserRole(p_user_id => p_user_id ) ;
813:
814: IF (WF_DIRECTORY.UserActive(l_user_role ))
815: THEN
816:
817: -- Prevent duplicate user
818: IF x_role_users IS NULL OR

Line 874: IF (WF_DIRECTORY.UserActive(grp_member_rec.user_role ))

870:
871: FOR grp_member_rec in c_grp_members (p_group_id => p_group_id )
872: LOOP
873:
874: IF (WF_DIRECTORY.UserActive(grp_member_rec.user_role ))
875: THEN
876:
877: -- Prevent duplicate user
878: IF x_role_users IS NULL OR

Line 1015: IF (WF_DIRECTORY.UserActive(l_rec.user_role ))

1011:
1012: FOR l_rec in c_route_people (p_route_id => p_route_id)
1013: LOOP
1014:
1015: IF (WF_DIRECTORY.UserActive(l_rec.user_role ))
1016: THEN
1017:
1018: -- Prevent duplicate user
1019: IF x_role_users IS NULL OR

Line 1070: IF (WF_DIRECTORY.UserActive(l_rec.user_role ))

1066:
1067: FOR l_rec in c_step_people (p_route_step_id => p_route_step_id)
1068: LOOP
1069:
1070: IF (WF_DIRECTORY.UserActive(l_rec.user_role ))
1071: THEN
1072:
1073: -- Prevent duplicate user
1074: IF x_role_users IS NULL OR

Line 1106: WF_DIRECTORY.RemoveUsersFromAdhocRole

1102: -- Check if the Role already exists
1103: IF CheckRoleExistence(p_role_name => p_role_name ) THEN
1104:
1105: -- Replacing existing Users in this Adhoc Role
1106: WF_DIRECTORY.RemoveUsersFromAdhocRole
1107: ( role_name => p_role_name
1108: , role_users => NULL ) ;
1109:
1110:

Line 1111: WF_DIRECTORY.AddUsersToAdhocRole

1107: ( role_name => p_role_name
1108: , role_users => NULL ) ;
1109:
1110:
1111: WF_DIRECTORY.AddUsersToAdhocRole
1112: ( role_name => p_role_name
1113: , role_users => p_role_users ) ;
1114:
1115:

Line 1118: WF_DIRECTORY.CreateAdHocRole( role_name => p_role_name

1114:
1115:
1116: ELSE
1117:
1118: WF_DIRECTORY.CreateAdHocRole( role_name => p_role_name
1119: , role_display_name => p_role_display_name
1120: , role_users => p_role_users
1121: , expiration_date => p_expiration_date
1122: );

Line 1139: -- WF_DIRECTORY.CreateAdHocRole( role_name => l_role_name

1135: -- ( p_role_name => l_role_name);
1136:
1137: -- END IF;
1138: --
1139: -- WF_DIRECTORY.CreateAdHocRole( role_name => l_role_name
1140: -- , role_display_name => l_role_name
1141: -- , role_users => l_role_users
1142: -- , expiration_date => NULL
1143: -- );

Line 1149: -- WF Directory related OBSOLETE APIs for Bug4532263

1145:
1146: END SetWFAdhocRole ;
1147:
1148: -------------------------------------------------------------------
1149: -- WF Directory related OBSOLETE APIs for Bug4532263
1150: -- End of WF Directory related OBSOLETE APIs for Bug4532263
1151: -------------------------------------------------------------------
1152:
1153:

Line 1150: -- End of WF Directory related OBSOLETE APIs for Bug4532263

1146: END SetWFAdhocRole ;
1147:
1148: -------------------------------------------------------------------
1149: -- WF Directory related OBSOLETE APIs for Bug4532263
1150: -- End of WF Directory related OBSOLETE APIs for Bug4532263
1151: -------------------------------------------------------------------
1152:
1153:
1154: -------------------------------------------------------------------

Line 1155: -- New WF Directory related APIs for CM Bug4532263

1151: -------------------------------------------------------------------
1152:
1153:
1154: -------------------------------------------------------------------
1155: -- New WF Directory related APIs for CM Bug4532263
1156: -------------------------------------------------------------------
1157:
1158: -- Add Role to WF_DIRECTORY.UserTable
1159: PROCEDURE AddRoleToRoleUserTable

Line 1158: -- Add Role to WF_DIRECTORY.UserTable

1154: -------------------------------------------------------------------
1155: -- New WF Directory related APIs for CM Bug4532263
1156: -------------------------------------------------------------------
1157:
1158: -- Add Role to WF_DIRECTORY.UserTable
1159: PROCEDURE AddRoleToRoleUserTable
1160: ( p_role_name IN VARCHAR2
1161: , x_role_users IN OUT NOCOPY WF_DIRECTORY.UserTable
1162: )

Line 1161: , x_role_users IN OUT NOCOPY WF_DIRECTORY.UserTable

1157:
1158: -- Add Role to WF_DIRECTORY.UserTable
1159: PROCEDURE AddRoleToRoleUserTable
1160: ( p_role_name IN VARCHAR2
1161: , x_role_users IN OUT NOCOPY WF_DIRECTORY.UserTable
1162: )
1163: IS
1164: l_index NUMBER ;
1165: l_dup_flag BOOLEAN ;

Line 1177: IF (WF_DIRECTORY.UserActive(p_role_name))

1173: END IF ;
1174:
1175:
1176: -- First, check the user role is Active
1177: IF (WF_DIRECTORY.UserActive(p_role_name))
1178: THEN
1179:
1180: IF g_debug_flag THEN
1181: Write_Debug('After WF_DIRECTORY.UserActive: ' || p_role_name );

Line 1181: Write_Debug('After WF_DIRECTORY.UserActive: ' || p_role_name );

1177: IF (WF_DIRECTORY.UserActive(p_role_name))
1178: THEN
1179:
1180: IF g_debug_flag THEN
1181: Write_Debug('After WF_DIRECTORY.UserActive: ' || p_role_name );
1182: END IF ;
1183:
1184: l_dup_flag := FALSE ;
1185: l_new_index := 0 ;

Line 1235: , x_role_users IN OUT NOCOPY WF_DIRECTORY.UserTable

1231:
1232: -- Set User to Role Users2
1233: PROCEDURE SetUserToRoleUsers2
1234: ( p_party_id IN NUMBER
1235: , x_role_users IN OUT NOCOPY WF_DIRECTORY.UserTable
1236: )
1237: IS
1238:
1239: l_user_role VARCHAR2(320) ;

Line 1265: , x_role_users IN OUT NOCOPY WF_DIRECTORY.UserTable

1261:
1262: -- Set AppsUser to Role Users
1263: PROCEDURE SetAppsUserToRoleUsers2
1264: ( p_user_id IN NUMBER
1265: , x_role_users IN OUT NOCOPY WF_DIRECTORY.UserTable
1266: )
1267: IS
1268:
1269: l_user_role VARCHAR2(320) ;

Line 1282: , x_role_users IN OUT NOCOPY WF_DIRECTORY.UserTable

1278:
1279: -- Set User to Role Users
1280: PROCEDURE SetGroupToRoleUsers2
1281: ( p_group_id IN NUMBER
1282: , x_role_users IN OUT NOCOPY WF_DIRECTORY.UserTable
1283: )
1284: IS
1285: CURSOR c_grp_members (p_group_id NUMBER)
1286: IS

Line 1305: , x_role_users IN OUT NOCOPY WF_DIRECTORY.UserTable

1301:
1302: -- Set Assignee to Role Users
1303: PROCEDURE SetAssigneeToRoleUsers2
1304: ( p_assignee_party_id IN NUMBER
1305: , x_role_users IN OUT NOCOPY WF_DIRECTORY.UserTable
1306: )
1307: IS
1308: l_party_type VARCHAR2(30) ;
1309:

Line 1338: , x_role_users IN OUT NOCOPY WF_DIRECTORY.UserTable

1334:
1335: -- Set Creator to Role Users2
1336: PROCEDURE SetCreatorToRoleUsers2
1337: ( p_creator_user_id IN NUMBER
1338: , x_role_users IN OUT NOCOPY WF_DIRECTORY.UserTable
1339: )
1340: IS
1341: l_party_type VARCHAR2(30) ;
1342:

Line 1360: , x_role_users IN OUT NOCOPY WF_DIRECTORY.UserTable

1356:
1357: -- Set Requestor to Role Users2
1358: PROCEDURE SetRequestorToRoleUsers2
1359: ( p_requestor_party_id IN NUMBER
1360: , x_role_users IN OUT NOCOPY WF_DIRECTORY.UserTable
1361: )
1362: IS
1363: l_party_type VARCHAR2(30) ;
1364:

Line 1392: , x_role_users IN OUT NOCOPY WF_DIRECTORY.UserTable

1388:
1389: -- Set Step People to Role Users2
1390: PROCEDURE SetRoutePeopleToRoleUsers2
1391: ( p_route_id IN NUMBER
1392: , x_role_users IN OUT NOCOPY WF_DIRECTORY.UserTable
1393: )
1394: IS
1395:
1396: l_user_role VARCHAR2(320) ;

Line 1426: , x_role_users IN OUT NOCOPY WF_DIRECTORY.UserTable

1422:
1423: -- Set Step People to Role Users2
1424: PROCEDURE SetStepPeopleToRoleUsers2
1425: ( p_route_step_id IN NUMBER
1426: , x_role_users IN OUT NOCOPY WF_DIRECTORY.UserTable
1427: )
1428: IS
1429:
1430: l_user_role VARCHAR2(320) ;

Line 1465: -- WF_DIRECTORY.UserTable as role_users.

1461: --
1462: -- 4258267 9.2.0.5.0 MAILER 11.5.10 PRODID-174 PORTID-110 3623217
1463: -- Abstract: UNABLE TO SEND NOTIFICATION FOR USER WHOSE NAME HAS SPACES
1464: -- Need to call CreateAdHocRole2 which accepts
1465: -- WF_DIRECTORY.UserTable as role_users.
1466: -- WF base bug3623217 of wf bug4258267:
1467: --
1468: PROCEDURE SetWFAdhocRole2 (p_role_name IN OUT NOCOPY VARCHAR2,
1469: p_role_display_name IN OUT NOCOPY VARCHAR2,

Line 1470: p_role_users IN WF_DIRECTORY.UserTable,

1466: -- WF base bug3623217 of wf bug4258267:
1467: --
1468: PROCEDURE SetWFAdhocRole2 (p_role_name IN OUT NOCOPY VARCHAR2,
1469: p_role_display_name IN OUT NOCOPY VARCHAR2,
1470: p_role_users IN WF_DIRECTORY.UserTable,
1471: p_expiration_date IN DATE DEFAULT SYSDATE)
1472: IS
1473:
1474: BEGIN

Line 1480: WF_DIRECTORY.RemoveUsersFromAdhocRole

1476: -- Check if the Role already exists
1477: IF CheckRoleExistence(p_role_name => p_role_name ) THEN
1478:
1479: -- Replacing existing Users in this Adhoc Role
1480: WF_DIRECTORY.RemoveUsersFromAdhocRole
1481: ( role_name => p_role_name
1482: , role_users => NULL ) ;
1483:
1484:

Line 1486: -- WF_DIRECTORY.AddUsersToAdHocRole2(role_name in varchar2,

1482: , role_users => NULL ) ;
1483:
1484:
1485: --
1486: -- WF_DIRECTORY.AddUsersToAdHocRole2(role_name in varchar2,
1487: -- role_users in WF_DIRECTORY.UserTable);
1488: WF_DIRECTORY.AddUsersToAdhocRole2
1489: ( role_name => p_role_name
1490: , role_users => p_role_users ) ;

Line 1487: -- role_users in WF_DIRECTORY.UserTable);

1483:
1484:
1485: --
1486: -- WF_DIRECTORY.AddUsersToAdHocRole2(role_name in varchar2,
1487: -- role_users in WF_DIRECTORY.UserTable);
1488: WF_DIRECTORY.AddUsersToAdhocRole2
1489: ( role_name => p_role_name
1490: , role_users => p_role_users ) ;
1491:

Line 1488: WF_DIRECTORY.AddUsersToAdhocRole2

1484:
1485: --
1486: -- WF_DIRECTORY.AddUsersToAdHocRole2(role_name in varchar2,
1487: -- role_users in WF_DIRECTORY.UserTable);
1488: WF_DIRECTORY.AddUsersToAdhocRole2
1489: ( role_name => p_role_name
1490: , role_users => p_role_users ) ;
1491:
1492:

Line 1494: -- WF_DIRECTORY.CreateAdHocRole2(role_name in out nocopy varchar2,

1490: , role_users => p_role_users ) ;
1491:
1492:
1493: ELSE
1494: -- WF_DIRECTORY.CreateAdHocRole2(role_name in out nocopy varchar2,
1495: -- role_display_name in out nocopy varchar2,
1496: -- language in varchar2 default null,
1497: -- territory in varchar2 default null,
1498: -- role_description in varchar2 default null,

Line 1500: -- role_users in WF_DIRECTORY.UserTable,

1496: -- language in varchar2 default null,
1497: -- territory in varchar2 default null,
1498: -- role_description in varchar2 default null,
1499: -- notification_preference in varchar2 default 'MAILHTML',
1500: -- role_users in WF_DIRECTORY.UserTable,
1501: -- email_address in varchar2 default null,
1502: -- fax in varchar2 default null,
1503: -- status in varchar2 default 'ACTIVE',
1504: -- expiration_date in date default null,

Line 1509: WF_DIRECTORY.CreateAdHocRole2( role_name => p_role_name

1505: -- parent_orig_system in varchar2 default null,
1506: -- parent_orig_system_id in number default null,
1507: -- owner_tag in varchar2 default null);
1508:
1509: WF_DIRECTORY.CreateAdHocRole2( role_name => p_role_name
1510: , role_display_name => p_role_display_name
1511: , role_users => p_role_users
1512: , expiration_date => p_expiration_date
1513: );

Line 1519: -- End of New WF Directory related APIs for CM Bug4532263

1515:
1516: END SetWFAdhocRole2 ;
1517:
1518: -------------------------------------------------------------------
1519: -- End of New WF Directory related APIs for CM Bug4532263
1520: -------------------------------------------------------------------
1521:
1522:
1523:

Line 6361: l_role_users WF_DIRECTORY.UserTable ;

6357: l_role_name VARCHAR2(320) ;
6358: l_role_display_name VARCHAR2(320) ;
6359: -- Bug4532263
6360: -- l_role_users VARCHAR2(2000) ;
6361: l_role_users WF_DIRECTORY.UserTable ;
6362:
6363:
6364:
6365: c1 PLS_INTEGER;

Line 6424: -- Set Adhoc Role and Users in WF Directory Adhoc Role

6420: , 'ADHOC_PARTY_ROLE');
6421:
6422: l_role_display_name := l_role_name ;
6423:
6424: -- Set Adhoc Role and Users in WF Directory Adhoc Role
6425: SetWFAdhocRole2( p_role_name => l_role_name
6426: , p_role_display_name => l_role_display_name
6427: , p_role_users => l_role_users
6428: , p_expiration_date => NULL

Line 6474: l_role_users WF_DIRECTORY.UserTable ;

6470: l_role_display_name VARCHAR2(320) ;
6471:
6472: -- Bug4532263
6473: -- l_role_users VARCHAR2(2000) ;
6474: l_role_users WF_DIRECTORY.UserTable ;
6475:
6476:
6477:
6478: BEGIN

Line 6538: -- Set Adhoc Role and Users in WF Directory Adhoc Role

6534: , 'ASSIGNEE_ROLE');
6535:
6536: l_role_display_name := l_role_name ;
6537:
6538: -- Set Adhoc Role and Users in WF Directory Adhoc Role
6539: SetWFAdhocRole2( p_role_name => l_role_name
6540: , p_role_display_name => l_role_display_name
6541: , p_role_users => l_role_users
6542: , p_expiration_date => NULL

Line 6595: l_role_users WF_DIRECTORY.UserTable ;

6591: l_role_name VARCHAR2(320) ;
6592: l_role_display_name VARCHAR2(320) ;
6593: -- Bug4532263
6594: -- l_role_users VARCHAR2(2000) ;
6595: l_role_users WF_DIRECTORY.UserTable ;
6596:
6597:
6598: BEGIN
6599:

Line 6708: -- Set Adhoc Role and Users in WF Directory Adhoc Role

6704:
6705:
6706: l_role_display_name := l_role_name ;
6707:
6708: -- Set Adhoc Role and Users in WF Directory Adhoc Role
6709: SetWFAdhocRole2( p_role_name => l_role_name
6710: , p_role_display_name => l_role_display_name
6711: , p_role_users => l_role_users
6712: , p_expiration_date => NULL

Line 6911: l_role_users WF_DIRECTORY.UserTable ;

6907: l_role_name VARCHAR2(320) ;
6908: l_role_display_name VARCHAR2(320) ;
6909: -- Bug4532263
6910: -- l_role_users VARCHAR2(2000) ;
6911: l_role_users WF_DIRECTORY.UserTable ;
6912:
6913: BEGIN
6914:
6915:

Line 6969: -- Set Adhoc Role and Users in WF Directory Adhoc Role

6965: , 'LINE_ASSIGNEE_ROLE');
6966:
6967: l_role_display_name := l_role_name ;
6968:
6969: -- Set Adhoc Role and Users in WF Directory Adhoc Role
6970: SetWFAdhocRole2( p_role_name => l_role_name
6971: , p_role_display_name => l_role_display_name
6972: , p_role_users => l_role_users
6973: , p_expiration_date => NULL

Line 7029: l_role_users WF_DIRECTORY.UserTable ;

7025: l_role_name VARCHAR2(320) ;
7026: l_role_display_name VARCHAR2(320) ;
7027: -- Bug4532263
7028: -- l_role_users VARCHAR2(2000) ;
7029: l_role_users WF_DIRECTORY.UserTable ;
7030:
7031: BEGIN
7032:
7033:

Line 7151: -- Set Adhoc Role and Users in WF Directory Adhoc Role

7147: , 'LINE_REVIEWERS_ROLE');
7148:
7149: l_role_display_name := l_role_name ;
7150:
7151: -- Set Adhoc Role and Users in WF Directory Adhoc Role
7152: SetWFAdhocRole2( p_role_name => l_role_name
7153: , p_role_display_name => l_role_display_name
7154: , p_role_users => l_role_users
7155: , p_expiration_date => NULL

Line 7210: l_role_users WF_DIRECTORY.UserTable ;

7206: l_role_name VARCHAR2(320) ;
7207: l_role_display_name VARCHAR2(320) ;
7208: -- Bug4532263
7209: -- l_role_users VARCHAR2(2000) ;
7210: l_role_users WF_DIRECTORY.UserTable ;
7211:
7212: BEGIN
7213:
7214:

Line 7277: -- Set Adhoc Role and Users in WF Directory Adhoc Role

7273: , 'ROUTE_PEOPLE_ROLE');
7274:
7275: l_role_display_name := l_role_name ;
7276:
7277: -- Set Adhoc Role and Users in WF Directory Adhoc Role
7278: SetWFAdhocRole2( p_role_name => l_role_name
7279: , p_role_display_name => l_role_display_name
7280: , p_role_users => l_role_users
7281: , p_expiration_date => NULL

Line 7336: l_role_users WF_DIRECTORY.UserTable ;

7332: l_role_name VARCHAR2(320) ;
7333: l_role_display_name VARCHAR2(320) ;
7334: -- Bug4532263
7335: -- l_role_users VARCHAR2(2000) ;
7336: l_role_users WF_DIRECTORY.UserTable ;
7337:
7338: BEGIN
7339:
7340:

Line 7390: -- Set Adhoc Role and Users in WF Directory Adhoc Role

7386: , 'STEP_PEOPLE_ROLE');
7387:
7388: l_role_display_name := l_role_name ;
7389:
7390: -- Set Adhoc Role and Users in WF Directory Adhoc Role
7391: SetWFAdhocRole2( p_role_name => l_role_name
7392: , p_role_display_name => l_role_display_name
7393: , p_role_users => l_role_users
7394: , p_expiration_date => NULL