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_ROLES

Line 66: -- table (wf_local_roles) are still active.

62: AND NVL(TRUNC(wlur.expiration_date),l_sysdate) >= l_sysdate;
63:
64: -- Select all inactive records from resource teams table
65: -- whose corresponding records in the workflow local roles
66: -- table (wf_local_roles) are still active.
67: -- These workflow local role records have to be inactivated.
68:
69: CURSOR c_team_wf_del IS
70: SELECT team.team_id, team.team_name, team.email_address

Line 72: FROM jtf_rs_teams_vl team, wf_local_roles wlr

68:
69: CURSOR c_team_wf_del IS
70: SELECT team.team_id, team.team_name, team.email_address
71: ,team.start_date_active, team.end_date_active
72: FROM jtf_rs_teams_vl team, wf_local_roles wlr
73: WHERE NVL(TRUNC(team.end_date_active),l_sysdate) < l_sysdate
74: AND wlr.orig_system_id = team.team_id
75: AND wlr.orig_system = l_team_orig_system
76: AND wlr.name = l_team_orig_system||':'||to_char(team.team_id)

Line 82: -- local roles table (wf_local_roles) has been modified (not in sync).

78: OR NVL(TRUNC(wlr.expiration_date),l_sysdate) >= l_sysdate);
79:
80: -- Select all active team records from resource teams table where one
81: -- of the matching columns to the corresponding records in workflow
82: -- local roles table (wf_local_roles) has been modified (not in sync).
83: -- These workflow role records have to be updated with new values.
84:
85: CURSOR c_team_wf_upd IS
86: SELECT team.team_id, team.team_name, team.email_address

Line 89: FROM jtf_rs_teams_vl team, wf_local_roles wlr

85: CURSOR c_team_wf_upd IS
86: SELECT team.team_id, team.team_name, team.email_address
87: ,team.end_date_active, team.start_date_active
88: ,wlr.start_date wlr_start_date, wlr.expiration_date wlr_exp_date
89: FROM jtf_rs_teams_vl team, wf_local_roles wlr
90: WHERE NVL(TRUNC(team.end_date_active),l_sysdate) >= l_sysdate
91: AND wlr.orig_system_id = team.team_id
92: AND wlr.orig_system = l_team_orig_system
93: AND wlr.name = l_team_orig_system||':'||to_char(team.team_id)

Line 120: -- that are still not defined in workflow roles table (wf_local_roles).

116: (wlur.expiration_date IS NOT NULL AND team.end_date_active IS NULL) OR
117: wlur.expiration_date <> team.end_date_active);
118:
119: -- Select all the team records from the resource teams table
120: -- that are still not defined in workflow roles table (wf_local_roles).
121: -- A new record to be created in Workflow roles table, for each team record.
122:
123: CURSOR c_team_wf_crt IS
124: SELECT team.team_id, team.team_name, team.email_address

Line 128: AND NOT EXISTS (SELECT 1 FROM wf_local_roles wlr

124: SELECT team.team_id, team.team_name, team.email_address
125: ,team.end_date_active, team.start_date_active
126: FROM jtf_rs_teams_vl team
127: WHERE NVL(TRUNC(team.end_date_active),l_sysdate) >= l_sysdate
128: AND NOT EXISTS (SELECT 1 FROM wf_local_roles wlr
129: WHERE wlr.orig_system_id = team.team_id
130: AND wlr.orig_system = l_team_orig_system
131: AND wlr.name = l_team_orig_system||':'||to_char(team.team_id));
132:

Line 409: -- table (wf_local_roles) are still active.

405: AND NVL(TRUNC(wlur.expiration_date),l_sysdate) >= l_sysdate;
406:
407: -- Select all inactive records from resource groups table
408: -- whose corresponding records in the workflow local roles
409: -- table (wf_local_roles) are still active.
410: -- These workflow local role records have to be inactivated.
411:
412: CURSOR c_grp_wf_del IS
413: -- Hints provided based on Perf. Team's recommendations (Jaikumar Bathija).

Line 417: FROM jtf_rs_groups_vl grp, wf_local_roles wlr

413: -- Hints provided based on Perf. Team's recommendations (Jaikumar Bathija).
414: SELECT /*+ use_hash(grp.t) use_hash(grp.b) use_hash(wlr) parallel(grp) parallel(wlr) */
415: grp.group_id, grp.group_name, grp.email_address
416: ,grp.start_date_active, grp.end_date_active
417: FROM jtf_rs_groups_vl grp, wf_local_roles wlr
418: WHERE NVL(TRUNC(grp.end_date_active),l_sysdate) < l_sysdate
419: AND wlr.orig_system_id = grp.group_id
420: AND wlr.orig_system = l_grp_orig_system
421: AND wlr.name = l_grp_orig_system||':'||to_char(grp.group_id)

Line 436: FROM jtf_rs_groups_vl grp, wf_local_roles wlr

432: SELECT /*+ use_hash(grp.t) use_hash(grp.b) use_hash(wlr) parallel(grp) parallel(wlr) */
433: grp.group_id, grp.group_name, grp.email_address
434: ,grp.end_date_active, grp.start_date_active
435: ,wlr.start_date wlr_start_date, wlr.expiration_date wlr_exp_date
436: FROM jtf_rs_groups_vl grp, wf_local_roles wlr
437: WHERE NVL(TRUNC(grp.end_date_active),l_sysdate) >= l_sysdate
438: AND wlr.orig_system_id = grp.group_id
439: AND wlr.orig_system = l_grp_orig_system
440: AND wlr.name = l_grp_orig_system||':'||to_char(grp.group_id)

Line 471: -- that are still not defined in workflow roles table (wf_local_roles).

467: (wlur.expiration_date IS NOT NULL AND grp.end_date_active IS NULL) OR
468: wlur.expiration_date <> grp.end_date_active);
469:
470: -- Select all the group records from the resource groups table
471: -- that are still not defined in workflow roles table (wf_local_roles).
472: -- A new record to be created in Workflow roles table, for each group record.
473:
474: CURSOR c_grp_wf_crt IS
475: -- Hints provided based on Perf. Team's recommendations (Jaikumar Bathija).

Line 481: AND NOT EXISTS (SELECT 1 FROM wf_local_roles wlr

477: grp.group_id, grp.group_name, grp.email_address
478: ,grp.end_date_active, grp.start_date_active
479: FROM jtf_rs_groups_vl grp
480: WHERE NVL(TRUNC(grp.end_date_active),l_sysdate) >= l_sysdate
481: AND NOT EXISTS (SELECT 1 FROM wf_local_roles wlr
482: WHERE wlr.orig_system = l_grp_orig_system
483: AND wlr.orig_system_id = grp.group_id
484: AND wlr.name = l_grp_orig_system||':'||to_char(group_id));
485:

Line 766: FROM wf_local_roles

762: AND NVL (expiration_date, l_sysdate) >= l_sysdate;
763:
764: CURSOR c_wf_role_details (l_orig_system_id NUMBER, l_orig_system VARCHAR2, l_name VARCHAR2) IS
765: SELECT display_name, email_address, start_date, expiration_date
766: FROM wf_local_roles
767: WHERE orig_system_id = l_orig_system_id
768: AND orig_system = l_orig_system
769: AND name = l_name
770: AND NVL (expiration_date, l_sysdate) >= l_sysdate;

Line 772: l_user_name wf_local_roles.name%TYPE;

768: AND orig_system = l_orig_system
769: AND name = l_name
770: AND NVL (expiration_date, l_sysdate) >= l_sysdate;
771:
772: l_user_name wf_local_roles.name%TYPE;
773: l_ind_user_name wf_local_roles.name%TYPE;
774: l_user_orig_system wf_local_roles.orig_system%TYPE;
775: l_user_orig_system_id wf_local_roles.orig_system_id%TYPE;
776:

Line 773: l_ind_user_name wf_local_roles.name%TYPE;

769: AND name = l_name
770: AND NVL (expiration_date, l_sysdate) >= l_sysdate;
771:
772: l_user_name wf_local_roles.name%TYPE;
773: l_ind_user_name wf_local_roles.name%TYPE;
774: l_user_orig_system wf_local_roles.orig_system%TYPE;
775: l_user_orig_system_id wf_local_roles.orig_system_id%TYPE;
776:
777: l_start_date DATE;

Line 774: l_user_orig_system wf_local_roles.orig_system%TYPE;

770: AND NVL (expiration_date, l_sysdate) >= l_sysdate;
771:
772: l_user_name wf_local_roles.name%TYPE;
773: l_ind_user_name wf_local_roles.name%TYPE;
774: l_user_orig_system wf_local_roles.orig_system%TYPE;
775: l_user_orig_system_id wf_local_roles.orig_system_id%TYPE;
776:
777: l_start_date DATE;
778: l_end_date DATE;

Line 775: l_user_orig_system_id wf_local_roles.orig_system_id%TYPE;

771:
772: l_user_name wf_local_roles.name%TYPE;
773: l_ind_user_name wf_local_roles.name%TYPE;
774: l_user_orig_system wf_local_roles.orig_system%TYPE;
775: l_user_orig_system_id wf_local_roles.orig_system_id%TYPE;
776:
777: l_start_date DATE;
778: l_end_date DATE;
779:

Line 780: l_display_name wf_local_roles.display_name%TYPE;

776:
777: l_start_date DATE;
778: l_end_date DATE;
779:
780: l_display_name wf_local_roles.display_name%TYPE;
781: l_email_address wf_local_roles.email_address%TYPE;
782: l_expiration_date wf_local_roles.expiration_date%TYPE;
783:
784: log_msg_hdr2 fnd_new_messages.message_text%type := NULL;

Line 781: l_email_address wf_local_roles.email_address%TYPE;

777: l_start_date DATE;
778: l_end_date DATE;
779:
780: l_display_name wf_local_roles.display_name%TYPE;
781: l_email_address wf_local_roles.email_address%TYPE;
782: l_expiration_date wf_local_roles.expiration_date%TYPE;
783:
784: log_msg_hdr2 fnd_new_messages.message_text%type := NULL;
785: log_message40 fnd_new_messages.message_text%type := NULL;

Line 782: l_expiration_date wf_local_roles.expiration_date%TYPE;

778: l_end_date DATE;
779:
780: l_display_name wf_local_roles.display_name%TYPE;
781: l_email_address wf_local_roles.email_address%TYPE;
782: l_expiration_date wf_local_roles.expiration_date%TYPE;
783:
784: log_msg_hdr2 fnd_new_messages.message_text%type := NULL;
785: log_message40 fnd_new_messages.message_text%type := NULL;
786:

Line 1153: m_role_name wf_local_roles.name%TYPE;

1149:
1150: l_end_date_active DATE;
1151: m_end_date_active DATE;
1152: m_start_date_active DATE;
1153: m_role_name wf_local_roles.name%TYPE;
1154: l_user_name wf_local_roles.name%TYPE;
1155: m_user_orig_system wf_local_roles.orig_system%TYPE;
1156: l_user_orig_system wf_local_roles.orig_system%TYPE;
1157: m_user_orig_system_id wf_local_roles.orig_system_id%TYPE;

Line 1154: l_user_name wf_local_roles.name%TYPE;

1150: l_end_date_active DATE;
1151: m_end_date_active DATE;
1152: m_start_date_active DATE;
1153: m_role_name wf_local_roles.name%TYPE;
1154: l_user_name wf_local_roles.name%TYPE;
1155: m_user_orig_system wf_local_roles.orig_system%TYPE;
1156: l_user_orig_system wf_local_roles.orig_system%TYPE;
1157: m_user_orig_system_id wf_local_roles.orig_system_id%TYPE;
1158: l_user_orig_system_id wf_local_roles.orig_system_id%TYPE;

Line 1155: m_user_orig_system wf_local_roles.orig_system%TYPE;

1151: m_end_date_active DATE;
1152: m_start_date_active DATE;
1153: m_role_name wf_local_roles.name%TYPE;
1154: l_user_name wf_local_roles.name%TYPE;
1155: m_user_orig_system wf_local_roles.orig_system%TYPE;
1156: l_user_orig_system wf_local_roles.orig_system%TYPE;
1157: m_user_orig_system_id wf_local_roles.orig_system_id%TYPE;
1158: l_user_orig_system_id wf_local_roles.orig_system_id%TYPE;
1159:

Line 1156: l_user_orig_system wf_local_roles.orig_system%TYPE;

1152: m_start_date_active DATE;
1153: m_role_name wf_local_roles.name%TYPE;
1154: l_user_name wf_local_roles.name%TYPE;
1155: m_user_orig_system wf_local_roles.orig_system%TYPE;
1156: l_user_orig_system wf_local_roles.orig_system%TYPE;
1157: m_user_orig_system_id wf_local_roles.orig_system_id%TYPE;
1158: l_user_orig_system_id wf_local_roles.orig_system_id%TYPE;
1159:
1160: BEGIN

Line 1157: m_user_orig_system_id wf_local_roles.orig_system_id%TYPE;

1153: m_role_name wf_local_roles.name%TYPE;
1154: l_user_name wf_local_roles.name%TYPE;
1155: m_user_orig_system wf_local_roles.orig_system%TYPE;
1156: l_user_orig_system wf_local_roles.orig_system%TYPE;
1157: m_user_orig_system_id wf_local_roles.orig_system_id%TYPE;
1158: l_user_orig_system_id wf_local_roles.orig_system_id%TYPE;
1159:
1160: BEGIN
1161:

Line 1158: l_user_orig_system_id wf_local_roles.orig_system_id%TYPE;

1154: l_user_name wf_local_roles.name%TYPE;
1155: m_user_orig_system wf_local_roles.orig_system%TYPE;
1156: l_user_orig_system wf_local_roles.orig_system%TYPE;
1157: m_user_orig_system_id wf_local_roles.orig_system_id%TYPE;
1158: l_user_orig_system_id wf_local_roles.orig_system_id%TYPE;
1159:
1160: BEGIN
1161:
1162: log_msg_hdr3 := fnd_message.get_string ('JTF','JTF_RS_WF_ROLE_SYNC_LOG_HDR3');

Line 1261: Category - '||i.category||', because there was no corresponding User defined in wf_local_roles table');

1257: );
1258: IF (l_user_orig_system IS NULL OR l_user_orig_system_id IS NULL) THEN
1259: fnd_file.put_line (fnd_file.log,'Not creating Workflow User Roles for corresponding Resource Group Members whose Member
1260: Resource is Resource ID - '||i.resource_id||', Resource Name - '||i.resource_name||' and Resource
1261: Category - '||i.category||', because there was no corresponding User defined in wf_local_roles table');
1262: ELSE
1263: BEGIN
1264: Wf_local_synch.propagate_user_role (
1265: p_user_orig_system => l_user_orig_system,

Line 1417: l_user_name wf_local_roles.name%TYPE;

1413:
1414: l_end_date_active DATE;
1415: m_end_date_active DATE;
1416: m_start_date_active DATE;
1417: l_user_name wf_local_roles.name%TYPE;
1418: l_user_orig_system wf_local_roles.orig_system%TYPE;
1419: l_user_orig_system_id wf_local_roles.orig_system_id%TYPE;
1420:
1421: BEGIN

Line 1418: l_user_orig_system wf_local_roles.orig_system%TYPE;

1414: l_end_date_active DATE;
1415: m_end_date_active DATE;
1416: m_start_date_active DATE;
1417: l_user_name wf_local_roles.name%TYPE;
1418: l_user_orig_system wf_local_roles.orig_system%TYPE;
1419: l_user_orig_system_id wf_local_roles.orig_system_id%TYPE;
1420:
1421: BEGIN
1422:

Line 1419: l_user_orig_system_id wf_local_roles.orig_system_id%TYPE;

1415: m_end_date_active DATE;
1416: m_start_date_active DATE;
1417: l_user_name wf_local_roles.name%TYPE;
1418: l_user_orig_system wf_local_roles.orig_system%TYPE;
1419: l_user_orig_system_id wf_local_roles.orig_system_id%TYPE;
1420:
1421: BEGIN
1422:
1423: log_msg_hdr5 := fnd_message.get_string ('JTF','JTF_RS_WF_ROLE_SYNC_LOG_HDR5');

Line 1525: Category - '||i.category||', because there was no corresponding User defined wf_local_roles table');

1521: );
1522: IF (l_user_orig_system IS NULL OR l_user_orig_system_id IS NULL) THEN
1523: fnd_file.put_line (fnd_file.log,'Not creating Workflow User Roles for corresponding Resource Team Members whose Member
1524: Resource is Resource ID - '||i.resource_id||', Resource Name - '||i.resource_name||' and Resource
1525: Category - '||i.category||', because there was no corresponding User defined wf_local_roles table');
1526: ELSE
1527: BEGIN
1528: Wf_local_synch.propagate_user_role(
1529: p_user_orig_system => l_user_orig_system,