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_ROLE_RELATE_PVT dependencies on JTF_RS_ROLES_B

Line 175: CURSOR get_type_cur(l_role_id JTF_RS_ROLES_B.role_id%TYPE)

171: p_end_date IN DATE ,
172: p_valid OUT NOCOPY BOOLEAN)
173: is
174:
175: CURSOR get_type_cur(l_role_id JTF_RS_ROLES_B.role_id%TYPE)
176: IS
177: SELECT role_type_code
178: FROM jtf_rs_roles_b
179: WHERE role_id = l_role_id;

Line 178: FROM jtf_rs_roles_b

174:
175: CURSOR get_type_cur(l_role_id JTF_RS_ROLES_B.role_id%TYPE)
176: IS
177: SELECT role_type_code
178: FROM jtf_rs_roles_b
179: WHERE role_id = l_role_id;
180:
181: role_type_rec get_type_cur%rowtype;
182:

Line 293: ll_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE,

289: l_team_resource_type JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE;
290:
291: --changed the date comparison in the cursor 07/07/00
292: CURSOR res_role_cur(ll_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
293: ll_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE,
294: ll_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
295: ll_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE )
296: IS
297: SELECT 'X'

Line 314: ll_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE,

310:
311: res_role_rec res_role_cur%rowtype;
312:
313: CURSOR grp_role_cur(ll_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
314: ll_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE,
315: ll_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
316: ll_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE )
317: IS
318: SELECT 'X'

Line 1398: ll_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE,

1394: l_team_resource_type JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE;
1395:
1396: --changed the date comparison in the cursor 07/07/00
1397: CURSOR res_role_cur(ll_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
1398: ll_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE,
1399: ll_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
1400: ll_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE )
1401: IS
1402: SELECT 'X'

Line 1418: ll_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE,

1414:
1415: res_role_rec res_role_cur%rowtype;
1416:
1417: CURSOR grp_role_cur(ll_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
1418: ll_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE,
1419: ll_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
1420: ll_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE )
1421: IS
1422: SELECT 'X'

Line 1550: l_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE )

1546: --cursor to check for team member dates for resource
1547: CURSOR res_team_cur(l_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
1548: l_start_date_active DATE,
1549: L_end_date_active DATE ,
1550: l_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE )
1551: IS
1552: SELECT 'X'
1553: FROM jtf_rs_team_members mem,
1554: jtf_rs_role_relations rlt

Line 1574: l_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE)

1570: --cursor to check for group member dates for resource
1571: CURSOR res_group_cur(l_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
1572: l_start_date_active DATE,
1573: L_end_date_active DATE ,
1574: l_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE)
1575: IS
1576: SELECT rlt.role_relate_id
1577: FROM jtf_rs_group_members mem,
1578: jtf_rs_role_relations rlt

Line 2638: l_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE,

2634:
2635: chk_type_rec chk_type_cur%rowtype;
2636:
2637: CURSOR chk_grp_cur(l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
2638: l_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE,
2639: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
2640: l_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE)
2641: IS
2642: SELECT 'x'

Line 2657: l_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE,

2653:
2654: chk_grp_rec chk_grp_cur%rowtype;
2655:
2656: CURSOR chk_team_cur(l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
2657: l_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE,
2658: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
2659: l_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE)
2660: IS
2661: SELECT 'x'