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.JTF_RS_CONC_WF_PUB dependencies on WF_LOCAL_USER_ROLES

Line 108: -- user roles table (wf_local_user_roles) are still active.

104: PROCEDURE synchronize_teams_wf AS
105:
106: -- Select all inactive records from resource teams table whose
107: -- corresponding (Self and Member) records in the workflow local
108: -- user roles table (wf_local_user_roles) are still active.
109: -- These workflow local user role records have to be inactivated.
110:
111: CURSOR c_team_wf_ur_del IS
112: SELECT team.team_id, team.start_date_active, team.end_date_active

Line 113: FROM jtf_rs_teams_b team, wf_local_user_roles wlur

109: -- These workflow local user role records have to be inactivated.
110:
111: CURSOR c_team_wf_ur_del IS
112: SELECT team.team_id, team.start_date_active, team.end_date_active
113: FROM jtf_rs_teams_b team, wf_local_user_roles wlur
114: WHERE NVL(TRUNC(team.end_date_active),l_sysdate) < l_sysdate
115: AND wlur.role_orig_system_id = team.team_id
116: AND wlur.role_orig_system = l_team_orig_system
117: AND wlur.role_name = l_team_orig_system||':'||to_char(team.team_id)

Line 160: -- local user roles table (wf_local_user_roles) has been modified (not in sync).

156: wlr.expiration_date <> team.end_date_active);
157:
158: -- Select all active team records from resource teams table where one of
159: -- the date columns of the corresponding records (Self or Member Records) in workflow
160: -- local user roles table (wf_local_user_roles) has been modified (not in sync).
161: -- These workflow user role records have to be updated with new values.
162:
163: CURSOR c_team_wf_ur_upd IS
164: SELECT team.team_id, team.start_date_active, team.end_date_active

Line 165: FROM jtf_rs_teams_b team, wf_local_user_roles wlur

161: -- These workflow user role records have to be updated with new values.
162:
163: CURSOR c_team_wf_ur_upd IS
164: SELECT team.team_id, team.start_date_active, team.end_date_active
165: FROM jtf_rs_teams_b team, wf_local_user_roles wlur
166: WHERE NVL(TRUNC(team.end_date_active),l_sysdate) >= l_sysdate
167: AND wlur.role_orig_system_id = team.team_id
168: AND wlur.role_orig_system = l_team_orig_system
169: AND wlur.role_name = l_team_orig_system||':'||to_char(team.team_id)

Line 404: -- Create Self-Record in wf_local_user_roles for the above record

400: fnd_file.new_line (fnd_file.log,1);
401: wf_core.clear;
402: END;
403:
404: -- Create Self-Record in wf_local_user_roles for the above record
405: BEGIN
406: Wf_local_synch.propagate_user_role(
407: p_user_orig_system => l_team_orig_system,
408: p_user_orig_system_id => i.team_id,

Line 447: -- local user roles table (wf_local_user_roles) are still active.

443: PROCEDURE synchronize_groups_wf AS
444:
445: -- Select all inactive records from resource groups table
446: -- whose corresponding (self and member) records in the workflow
447: -- local user roles table (wf_local_user_roles) are still active.
448: -- These workflow local user role records have to be inactivated.
449:
450: CURSOR c_grp_wf_ur_del IS
451: SELECT grp.group_id, grp.start_date_active, grp.end_date_active

Line 452: FROM jtf_rs_groups_b grp, wf_local_user_roles wlur

448: -- These workflow local user role records have to be inactivated.
449:
450: CURSOR c_grp_wf_ur_del IS
451: SELECT grp.group_id, grp.start_date_active, grp.end_date_active
452: FROM jtf_rs_groups_b grp, wf_local_user_roles wlur
453: WHERE NVL(TRUNC(grp.end_date_active),l_sysdate) < l_sysdate
454: AND ((wlur.role_orig_system_id = grp.group_id
455: AND wlur.role_orig_system = l_grp_orig_system
456: AND wlur.role_name = l_grp_orig_system||':'||to_char(grp.group_id))

Line 507: -- local user roles table (wf_local_user_roles) has been modified (not in sync).

503: wlr.expiration_date <> grp.end_date_active);
504:
505: -- Select all active group records from resource groups table where one of
506: -- the date columns of the corresponding (self and member) records in workflow
507: -- local user roles table (wf_local_user_roles) has been modified (not in sync).
508: -- These workflow user role records have to be updated with new values.
509:
510: CURSOR c_grp_wf_ur_upd IS
511: SELECT grp.group_id, grp.start_date_active, grp.end_date_active

Line 512: FROM jtf_rs_groups_b grp, wf_local_user_roles wlur

508: -- These workflow user role records have to be updated with new values.
509:
510: CURSOR c_grp_wf_ur_upd IS
511: SELECT grp.group_id, grp.start_date_active, grp.end_date_active
512: FROM jtf_rs_groups_b grp, wf_local_user_roles wlur
513: WHERE NVL(TRUNC(grp.end_date_active),l_sysdate) >= l_sysdate
514: AND ((wlur.role_orig_system_id = grp.group_id
515: AND wlur.role_orig_system = l_grp_orig_system
516: AND wlur.role_name = l_grp_orig_system||':'||to_char(grp.group_id))

Line 756: -- Create Self-Record in wf_local_user_roles for the above record

752: fnd_file.new_line (fnd_file.log,1);
753: wf_core.clear;
754: END;
755:
756: -- Create Self-Record in wf_local_user_roles for the above record
757: BEGIN
758: Wf_local_synch.propagate_user_role(
759: p_user_orig_system => l_grp_orig_system,
760: p_user_orig_system_id => i.group_id,

Line 804: FROM wf_local_user_roles

800:
801: CURSOR c_wf_ur_details (l_user_orig_system_id NUMBER, l_user_orig_system VARCHAR2, l_user_name VARCHAR2) IS
802: SELECT role_orig_system_id, role_orig_system, role_name
803: ,start_date, expiration_date
804: FROM wf_local_user_roles
805: WHERE user_orig_system_id = l_user_orig_system_id
806: AND user_orig_system = l_user_orig_system
807: AND user_name = l_user_name
808: AND NVL (expiration_date, l_sysdate) >= l_sysdate;

Line 813: FROM wf_local_user_roles

809:
810: CURSOR c_wf_ur_mem_details (l_user_orig_system_id NUMBER, l_user_orig_system VARCHAR2, l_user_name VARCHAR2) IS
811: SELECT role_orig_system_id, role_orig_system, role_name
812: ,start_date, expiration_date
813: FROM wf_local_user_roles
814: WHERE user_orig_system_id = l_user_orig_system_id
815: AND user_orig_system = l_user_orig_system
816: AND user_name = l_user_name
817: AND role_orig_system IN ('JRES_IND','JRES_GRP','JRES_TEAM')

Line 1090: -- Create Self-Record in wf_local_user_roles for the above record

1086: fnd_file.put_line (fnd_file.log,error_stack);
1087: fnd_file.new_line (fnd_file.log,1);
1088: wf_core.clear;
1089: END;
1090: -- Create Self-Record in wf_local_user_roles for the above record
1091: BEGIN
1092: Wf_local_synch.propagate_user_role(
1093: p_user_orig_system => l_ind_orig_system,
1094: p_user_orig_system_id => i.resource_id,

Line 1131: FROM wf_local_user_roles wlur, jtf_rs_group_members mem

1127: --Bug10044172 - Added Resource_id in cursor
1128:
1129: CURSOR c_wlur_grp_mem_del IS
1130: SELECT wlur.user_orig_system, wlur.user_orig_system_id, mem.group_id,mem.resource_id
1131: FROM wf_local_user_roles wlur, jtf_rs_group_members mem
1132: WHERE NVL (mem.delete_flag,'N') = 'Y'
1133: AND wlur.role_orig_system = l_grp_orig_system
1134: AND wlur.role_orig_system_id = mem.group_id
1135: AND wlur.role_name = l_grp_orig_system ||':'|| mem.group_id

Line 1141: -- user role table (wf_local_user_roles). This is for category OTHER and TBH.

1137: AND NVL(wlur.expiration_date, l_sysdate) >= l_sysdate;
1138:
1139: -- Cursor to select all active records from resource group members table
1140: -- (jtf_rs_group_members) that are still not defined in workflow
1141: -- user role table (wf_local_user_roles). This is for category OTHER and TBH.
1142: -- These records have to be created in workflow user roles table.
1143:
1144: CURSOR c_grp_mem_wf_crt IS
1145: -- Hints provided based on Perf. Team's recommendations (Jaikumar Bathija).

Line 1160: AND NOT EXISTS (SELECT 1 FROM wf_local_user_roles wlur

1156: AND ext.resource_name IS NOT NULL
1157: AND NVL (mem.delete_flag,'N') <> 'Y'
1158: AND NVL(TRUNC(ext.end_date_active),l_sysdate) >= l_sysdate
1159: AND NVL(TRUNC(grp.end_date_active),l_sysdate) >= l_sysdate
1160: AND NOT EXISTS (SELECT 1 FROM wf_local_user_roles wlur
1161: WHERE wlur.user_orig_system_id = mem.resource_id
1162: AND wlur.role_orig_system_id = mem.group_id
1163: AND wlur.user_orig_system = l_ind_orig_system
1164: AND wlur.role_orig_system = l_grp_orig_system);

Line 1168: -- user role table (wf_local_user_roles). This is for category

1164: AND wlur.role_orig_system = l_grp_orig_system);
1165:
1166: -- Select all active records from resource group members table
1167: -- (jtf_rs_group_members) that are still not defined in workflow
1168: -- user role table (wf_local_user_roles). This is for category
1169: -- EMPLOYEE, PARTY, PARTNER and SUPPLIER_CONTACT
1170: -- These records have to be created in workflow user roles table.
1171:
1172: CURSOR c_grp_mem_wf_epps_crt IS

Line 1188: AND NOT EXISTS (SELECT 1 FROM wf_local_user_roles wlur

1184: AND NVL (mem.delete_flag,'N') <> 'Y'
1185: AND ext.resource_name IS NOT NULL
1186: AND NVL(TRUNC(ext.end_date_active),l_sysdate) >= l_sysdate
1187: AND NVL(TRUNC(grp.end_date_active),l_sysdate) >= l_sysdate
1188: AND NOT EXISTS (SELECT 1 FROM wf_local_user_roles wlur
1189: WHERE wlur.role_orig_system_id = mem.group_id
1190: AND wlur.user_orig_system = l_hz_orig_system
1191: AND wlur.role_orig_system = l_grp_orig_system);
1192:

Line 1407: FROM wf_local_user_roles wlur, jtf_rs_team_members mem

1403: -- resource team member records have been deleted (delete_flag Y).
1404:
1405: CURSOR c_wlur_team_mem_del IS
1406: SELECT wlur.user_orig_system, wlur.user_orig_system_id, mem.team_id
1407: FROM wf_local_user_roles wlur, jtf_rs_team_members mem
1408: WHERE NVL (mem.delete_flag,'N') = 'Y'
1409: AND wlur.role_orig_system = l_team_orig_system
1410: AND wlur.role_orig_system_id = mem.team_id
1411: AND wlur.role_name = l_team_orig_system ||':'|| mem.team_id

Line 1418: -- user role table (wf_local_user_roles). This is for 'INDIVIDUAL'

1414:
1415:
1416: -- Select all active records from resource team members table
1417: -- (jtf_rs_team_members) that are still not defined in workflow
1418: -- user role table (wf_local_user_roles). This is for 'INDIVIDUAL'
1419: -- resource team members whose category is OTHER or TBH.
1420: -- These records have to be created in workflow user roles table.
1421:
1422: CURSOR c_team_mem_wf_crt IS

Line 1436: AND NOT EXISTS (SELECT 1 FROM wf_local_user_roles wlur

1432: AND ext.category IN ('OTHER','TBH')
1433: AND ext.resource_name IS NOT NULL
1434: AND NVL (TRUNC (ext.end_date_active),l_sysdate) >= l_sysdate
1435: AND NVL (TRUNC (team.end_date_active),l_sysdate) >= l_sysdate
1436: AND NOT EXISTS (SELECT 1 FROM wf_local_user_roles wlur
1437: WHERE mem.resource_type = 'INDIVIDUAL'
1438: AND wlur.user_orig_system_id = mem.team_resource_id
1439: AND wlur.user_orig_system = l_ind_orig_system
1440: AND wlur.role_orig_system_id = mem.team_id

Line 1446: -- table (wf_local_user_roles). This is for 'INDIVIDUAL' resource team

1442:
1443:
1444: -- Select all active records from resource team members table
1445: -- (jtf_rs_team_members) that are still not defined in workflow user role
1446: -- table (wf_local_user_roles). This is for 'INDIVIDUAL' resource team
1447: -- members whose category is EMPLOYEE, PARTY, PARTNER or SUPPLIER_CONTACT
1448: -- These records have to be created in workflow user roles table.
1449:
1450: CURSOR c_team_mem_wf_epps_crt IS

Line 1464: AND NOT EXISTS (SELECT 1 FROM wf_local_user_roles wlur

1460: AND ext.resource_name IS NOT NULL
1461: AND ext.category IN ('EMPLOYEE','PARTY','PARTNER','SUPPLIER_CONTACT')
1462: AND NVL (TRUNC (ext.end_date_active),l_sysdate) >= l_sysdate
1463: AND NVL (TRUNC (team.end_date_active),l_sysdate) >= l_sysdate
1464: AND NOT EXISTS (SELECT 1 FROM wf_local_user_roles wlur
1465: WHERE mem.resource_type = 'INDIVIDUAL'
1466: AND wlur.role_orig_system_id = mem.team_id
1467: AND wlur.role_orig_system = l_team_orig_system
1468: AND wlur.user_orig_system = l_hz_orig_system);

Line 1472: -- user role table (wf_local_user_roles). This is for 'GROUP'

1468: AND wlur.user_orig_system = l_hz_orig_system);
1469:
1470: -- Select all active records from resource team members table
1471: -- (jtf_rs_team_members) that are still not defined in workflow
1472: -- user role table (wf_local_user_roles). This is for 'GROUP'
1473: -- resource team members.
1474: -- These records have to be created in workflow user roles table.
1475:
1476: CURSOR c_team_mem_grp_wf_crt IS

Line 1488: AND NOT EXISTS (SELECT 1 FROM wf_local_user_roles wlur

1484: AND mem.resource_type = 'GROUP'
1485: AND mem.team_id = team.team_id
1486: AND NVL (TRUNC (grp.end_date_active),l_sysdate) >= l_sysdate
1487: AND NVL (TRUNC (team.end_date_active),l_sysdate) >= l_sysdate
1488: AND NOT EXISTS (SELECT 1 FROM wf_local_user_roles wlur
1489: WHERE mem.resource_type = 'GROUP'
1490: AND wlur.user_orig_system_id = mem.team_resource_id
1491: AND wlur.user_orig_system = l_grp_orig_system
1492: AND wlur.role_orig_system_id = mem.team_id