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 66: CURSOR other_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,

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

Line 116: l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,

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

Line 134: l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1239: l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,

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

Line 1257: l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2837: WHERE denorm_grp_id = l_denorm_group_id;
2838:
2839: denorm_rec denorm_cur%rowtype;
2840:
2841: CURSOR par_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 2854: CURSOR child_role_relate_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE)

2850: AND nvl(mem.delete_flag,'N') <> 'Y';
2851:
2852: par_role_relate_rec par_role_relate_cur%rowtype;
2853:
2854: CURSOR child_role_relate_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE)
2855: IS
2856: SELECT role_relate_id
2857: FROM JTF_RS_ROLE_RELATIONS rlt,
2858: jtf_rs_group_members mem

Line 3066: l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,

3062:
3063: --cursor for duplicate check
3064: CURSOR dup_cur(l_person_id JTF_RS_GROUP_MEMBERS.PERSON_ID%TYPE,
3065: l_manager_person_id JTF_RS_GROUP_MEMBERS.PERSON_ID%TYPE,
3066: l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,
3067: l_resource_id JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
3068: l_start_date_active DATE,
3069: l_end_date_active DATE)
3070: IS

Line 3084: l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE)

3080: OR ( end_date_active IS NULL AND l_end_date_active IS NULL));
3081:
3082: CURSOR dup_cur2(l_par_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
3083: l_child_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
3084: l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE)
3085: IS
3086: SELECT person_id
3087: FROM jtf_rs_rep_managers
3088: WHERE par_role_relate_id = l_par_role_relate_id

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

3093:
3094: dup NUMBER := 0;
3095:
3096: --cursor for parent groups
3097: CURSOR par_grp_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,
3098: l_start_date_active DATE,
3099: l_end_date_active DATE)
3100: IS
3101: SELECT parent_group_id,

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

3113: par_grp_rec par_grp_cur%ROWTYPE;
3114:
3115:
3116: --cursor to fetch admin for a group
3117: CURSOR admin_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,
3118: l_start_date_active DATE,
3119: l_end_date_active DATE)
3120: IS
3121: SELECT /*+ ordered use_nl(MEM,RLT,ROL) */

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

3143:
3144: admin_rec admin_cur%rowtype;
3145:
3146: --cursor to fetch managers for a group
3147: CURSOR mgr_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,
3148: l_start_date_active DATE,
3149: l_end_date_active DATE)
3150: IS
3151: SELECT /*+ ordered use_nl(MEM,RLT,ROL) */

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

4021: rel_grp_rec rel_grp_cur%rowtype;
4022:
4023: l_related_group_id JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE;
4024:
4025: CURSOR par_mgr_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,
4026: l_start_date_active DATE,
4027: l_end_date_active DATE)
4028: IS
4029: SELECT mem.resource_id,

Line 4064: p_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,

4060:
4061: TYPE MGR_TYPE IS RECORD
4062: ( p_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
4063: p_person_id JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE,
4064: p_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,
4065: p_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
4066: p_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE,
4067: p_start_date_active DATE,
4068: p_end_date_active DATE,

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

4075: query_str VARCHAR2(20000);
4076: i BINARY_INTEGER := 0;
4077:
4078:
4079: CURSOR child_grp_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE)
4080: IS
4081: SELECT group_id,
4082: start_date_active,
4083: end_date_active,

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

4087: AND group_id NOT IN (l_group_id);
4088:
4089: child_grp_rec child_grp_cur%ROWTYPE;
4090:
4091: CURSOR member_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,
4092: l_start_date_active DATE,
4093: l_end_date_active DATE)
4094: IS
4095: SELECT mem.resource_id,

Line 4171: l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE)

4167: --dupliacte check cursor to be added
4168:
4169: CURSOR dup_cur2(l_par_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
4170: l_child_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
4171: l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE)
4172: IS
4173: SELECT person_id
4174: FROM jtf_rs_rep_managers
4175: WHERE par_role_relate_id = l_par_role_relate_id