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_REP_MGR_DENORM_PVT dependencies on JTF_RS_GROUPS_B

Line 65: CURSOR other_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,

61: mem_dtls_rec mem_dtls_cur%rowtype;
62:
63: --CURSOR for other members in same group
64:
65: CURSOR other_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,
66: l_start_date_active DATE,
67: l_end_date_active DATE,
68: l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE)
69: IS

Line 115: l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,

111:
112: --cursor for duplicate check
113: CURSOR dup_cur(l_person_id JTF_RS_GROUP_MEMBERS.PERSON_ID%TYPE,
114: l_manager_person_id JTF_RS_GROUP_MEMBERS.PERSON_ID%TYPE,
115: l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,
116: l_resource_id JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
117: l_start_date_active DATE,
118: l_end_date_active DATE)
119: IS

Line 133: l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,

129: OR ( end_date_active IS NULL AND l_end_date_active IS NULL));
130:
131: CURSOR dup_cur2(l_par_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
132: l_child_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
133: l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,
134: l_start_date_active date,
135: l_end_date_active date)
136: IS
137: SELECT person_id

Line 155: CURSOR same_grp_mgr_admin_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,

151:
152: dup NUMBER := 0;
153:
154: --cursor for same group manager
155: CURSOR same_grp_mgr_admin_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,
156: l_start_date_active DATE,
157: l_end_date_active DATE,
158: l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE)
159: IS

Line 191: CURSOR par_grp_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,

187: same_grp_mgr_admin_rec same_grp_mgr_admin_cur%ROWTYPE;
188:
189:
190: --cursor for parent groups
191: CURSOR par_grp_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,
192: l_start_date_active DATE,
193: l_end_date_active DATE)
194: IS
195: SELECT parent_group_id,

Line 215: CURSOR admin_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,

211: par_grp_rec par_grp_cur%ROWTYPE;
212:
213:
214: --cursor to fetch admin for a group
215: CURSOR admin_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,
216: l_start_date_active DATE,
217: l_end_date_active DATE)
218: IS
219: SELECT /*+ ordered use_nl(MEM,RLT,ROL) */

Line 245: CURSOR mgr_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,

241:
242: admin_rec admin_cur%rowtype;
243:
244: --cursor to fetch managers for a group
245: CURSOR mgr_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,
246: l_start_date_active DATE,
247: l_end_date_active DATE)
248: IS
249: SELECT /*+ ordered use_nl(MEM,RLT,ROL) */

Line 276: CURSOR child_grp_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,

272:
273: mgr_rec mgr_cur%rowtype;
274:
275: --cursor for child groups
276: CURSOR child_grp_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,
277: l_start_date_active DATE,
278: l_end_date_active DATE)
279: IS
280: SELECT group_id,

Line 299: CURSOR child_mem_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,

295: child_grp_rec child_grp_cur%rowtype;
296:
297:
298: --cursor for child group members
299: CURSOR child_mem_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,
300: l_start_date_active DATE,
301: l_end_date_active DATE)
302: IS
303: SELECT mem.resource_id,

Line 1195: CURSOR other_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,

1191: mem_dtls_rec mem_dtls_cur%rowtype;
1192:
1193: --CURSOR for other members in same group
1194:
1195: CURSOR other_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,
1196: l_start_date_active DATE,
1197: l_end_date_active DATE,
1198: l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE)
1199: IS

Line 1238: l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,

1234:
1235: --cursor for duplicate check
1236: CURSOR dup_cur(l_person_id JTF_RS_GROUP_MEMBERS.PERSON_ID%TYPE,
1237: l_manager_person_id JTF_RS_GROUP_MEMBERS.PERSON_ID%TYPE,
1238: l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,
1239: l_resource_id JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
1240: l_start_date_active DATE,
1241: l_end_date_active DATE)
1242: IS

Line 1256: l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE)

1252: OR ( end_date_active IS NULL AND l_end_date_active IS NULL));
1253:
1254: CURSOR dup_cur2(l_par_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
1255: l_child_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
1256: l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE)
1257: IS
1258: SELECT person_id
1259: FROM jtf_rs_rep_managers
1260: WHERE par_role_relate_id = l_par_role_relate_id

Line 1269: CURSOR same_grp_mgr_admin_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,

1265:
1266: dup NUMBER := 0;
1267:
1268: --cursor for same group manager and admin
1269: CURSOR same_grp_mgr_admin_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,
1270: l_start_date_active DATE,
1271: l_end_date_active DATE,
1272: l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE)
1273: IS

Line 1306: CURSOR par_grp_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,

1302:
1303: same_grp_mgr_admin_rec same_grp_mgr_admin_cur%ROWTYPE;
1304:
1305: --cursor for parent groups
1306: CURSOR par_grp_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,
1307: l_start_date_active DATE,
1308: l_end_date_active DATE)
1309: IS
1310: SELECT parent_group_id,

Line 1326: CURSOR admin_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,

1322: par_grp_rec par_grp_cur%ROWTYPE;
1323:
1324:
1325: --cursor to fetch admin for a group
1326: CURSOR admin_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,
1327: l_start_date_active DATE,
1328: l_end_date_active DATE)
1329: IS
1330: SELECT /*+ ordered use_nl(MEM,RLT,ROL) */

Line 1356: CURSOR mgr_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,

1352:
1353: admin_rec admin_cur%rowtype;
1354:
1355: --cursor to fetch managers for a group
1356: CURSOR mgr_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,
1357: l_start_date_active DATE,
1358: l_end_date_active DATE)
1359: IS
1360: SELECT /*+ ordered use_nl(MEM,RLT,ROL) */

Line 1387: CURSOR child_grp_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,

1383:
1384: mgr_rec mgr_cur%rowtype;
1385:
1386: --cursor for child groups
1387: CURSOR child_grp_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,
1388: l_start_date_active DATE,
1389: l_end_date_active DATE)
1390: IS
1391: SELECT group_id,

Line 1407: CURSOR child_mem_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,

1403: child_grp_rec child_grp_cur%rowtype;
1404:
1405:
1406: --cursor for child group members
1407: CURSOR child_mem_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,
1408: l_start_date_active DATE,
1409: l_end_date_active DATE)
1410: IS
1411: SELECT mem.resource_id,

Line 2828: CURSOR par_role_relate_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE)

2824: WHERE denorm_grp_id = l_denorm_group_id;
2825:
2826: denorm_rec denorm_cur%rowtype;
2827:
2828: CURSOR par_role_relate_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE)
2829: IS
2830: SELECT role_relate_id
2831: FROM JTF_RS_ROLE_RELATIONS rlt,
2832: jtf_rs_group_members mem

Line 2841: CURSOR child_role_relate_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE)

2837: AND nvl(mem.delete_flag,'N') <> 'Y';
2838:
2839: par_role_relate_rec par_role_relate_cur%rowtype;
2840:
2841: CURSOR child_role_relate_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE)
2842: IS
2843: SELECT role_relate_id
2844: FROM JTF_RS_ROLE_RELATIONS rlt,
2845: jtf_rs_group_members mem

Line 3053: l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,

3049:
3050: --cursor for duplicate check
3051: CURSOR dup_cur(l_person_id JTF_RS_GROUP_MEMBERS.PERSON_ID%TYPE,
3052: l_manager_person_id JTF_RS_GROUP_MEMBERS.PERSON_ID%TYPE,
3053: l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,
3054: l_resource_id JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
3055: l_start_date_active DATE,
3056: l_end_date_active DATE)
3057: IS

Line 3071: l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE)

3067: OR ( end_date_active IS NULL AND l_end_date_active IS NULL));
3068:
3069: CURSOR dup_cur2(l_par_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
3070: l_child_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
3071: l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE)
3072: IS
3073: SELECT person_id
3074: FROM jtf_rs_rep_managers
3075: WHERE par_role_relate_id = l_par_role_relate_id

Line 3084: CURSOR par_grp_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,

3080:
3081: dup NUMBER := 0;
3082:
3083: --cursor for parent groups
3084: CURSOR par_grp_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,
3085: l_start_date_active DATE,
3086: l_end_date_active DATE)
3087: IS
3088: SELECT parent_group_id,

Line 3104: CURSOR admin_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,

3100: par_grp_rec par_grp_cur%ROWTYPE;
3101:
3102:
3103: --cursor to fetch admin for a group
3104: CURSOR admin_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,
3105: l_start_date_active DATE,
3106: l_end_date_active DATE)
3107: IS
3108: SELECT /*+ ordered use_nl(MEM,RLT,ROL) */

Line 3134: CURSOR mgr_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,

3130:
3131: admin_rec admin_cur%rowtype;
3132:
3133: --cursor to fetch managers for a group
3134: CURSOR mgr_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,
3135: l_start_date_active DATE,
3136: l_end_date_active DATE)
3137: IS
3138: SELECT /*+ ordered use_nl(MEM,RLT,ROL) */

Line 4012: CURSOR par_mgr_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,

4008: rel_grp_rec rel_grp_cur%rowtype;
4009:
4010: l_related_group_id JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE;
4011:
4012: CURSOR par_mgr_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,
4013: l_start_date_active DATE,
4014: l_end_date_active DATE)
4015: IS
4016: SELECT mem.resource_id,

Line 4051: p_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,

4047:
4048: TYPE MGR_TYPE IS RECORD
4049: ( p_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
4050: p_person_id JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE,
4051: p_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,
4052: p_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
4053: p_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE,
4054: p_start_date_active DATE,
4055: p_end_date_active DATE,

Line 4066: CURSOR child_grp_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE)

4062: query_str VARCHAR2(20000);
4063: i BINARY_INTEGER := 0;
4064:
4065:
4066: CURSOR child_grp_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE)
4067: IS
4068: SELECT group_id,
4069: start_date_active,
4070: end_date_active,

Line 4078: CURSOR member_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,

4074: AND group_id NOT IN (l_group_id);
4075:
4076: child_grp_rec child_grp_cur%ROWTYPE;
4077:
4078: CURSOR member_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,
4079: l_start_date_active DATE,
4080: l_end_date_active DATE)
4081: IS
4082: SELECT mem.resource_id,

Line 4158: l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE)

4154: --dupliacte check cursor to be added
4155:
4156: CURSOR dup_cur2(l_par_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
4157: l_child_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
4158: l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE)
4159: IS
4160: SELECT person_id
4161: FROM jtf_rs_rep_managers
4162: WHERE par_role_relate_id = l_par_role_relate_id