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 DUAL

Line 80: and mem.resource_type = 'INDIVIDUAL'

76: rlt.end_date_active
77: from jtf_rs_role_relations rlt,
78: jtf_rs_team_members mem
79: where mem.team_resource_id = p_resource_id
80: and mem.resource_type = 'INDIVIDUAL'
81: and nvl(mem.delete_flag, 'N') <> 'Y'
82: and rlt.role_resource_id = mem.team_member_id
83: and rlt.role_id = p_role_id --added vide bug#2474811
84: and rlt.role_resource_type = 'RS_TEAM_MEMBER'

Line 300: WHERE role_resource_type = 'RS_INDIVIDUAL'

296: ll_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE )
297: IS
298: SELECT 'X'
299: FROM jtf_rs_role_relations
300: WHERE role_resource_type = 'RS_INDIVIDUAL'
301: AND role_resource_id = ll_role_resource_id
302: AND role_id = ll_role_id
303: AND nvl(delete_flag, '0') <> 'Y'
304: AND to_date(to_char(start_date_active , 'dd-MM-yyyy'),'dd-MM-yyyy') <=

Line 625: l_role_resource_type = 'RS_INDIVIDUAL')

621: END IF;
622:
623: IF(l_role_resource_type = 'RS_TEAM' or
624: l_role_resource_type = 'RS_GROUP' or
625: l_role_resource_type = 'RS_INDIVIDUAL')
626: THEN
627: validate_role_type(l_role_id,
628: l_start_date_active,
629: l_end_date_active,

Line 722: (l_team_resource_type = 'INDIVIDUAL')))

718:
719: --valid role for the resource if being entered as a group member and team member
720: IF((l_role_resource_type = 'RS_GROUP_MEMBER') OR
721: ((l_role_resource_type = 'RS_TEAM_MEMBER') AND
722: (l_team_resource_type = 'INDIVIDUAL')))
723: THEN
724: --if team member is of type resource or it is group member
725: --then check for valid role and st date , end date for the resource
726: --in role relations

Line 841: ELSIF(l_role_resource_type = 'RS_INDIVIDUAL')

837: END IF;
838:
839: close c_exclusive_group_check_cur;
840:
841: ELSIF(l_role_resource_type = 'RS_INDIVIDUAL')
842: --check against res start and end dates
843: THEN
844: open rsc_cur(l_role_resource_id);
845: fetch rsc_cur INTO rsc_rec;

Line 894: from dual;

890:
891: --get the primary key sequence value
892: select jtf_rs_role_relations_s.nextval
893: into l_role_relate_id
894: from dual;
895:
896:
897: --call audit api for insert
898: jtf_rs_role_relate_aud_pvt.insert_role_relate(

Line 1418: WHERE role_resource_type = 'RS_INDIVIDUAL'

1414: ll_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE )
1415: IS
1416: SELECT 'X'
1417: FROM jtf_rs_role_relations
1418: WHERE role_resource_type = 'RS_INDIVIDUAL'
1419: AND role_resource_id = ll_role_resource_id
1420: AND role_id = ll_role_id
1421: AND to_date(to_char(start_date_active , 'dd-MM-yyyy'),'dd-MM-yyyy') <=
1422: to_date(to_char(ll_start_date_active, 'dd-MM-yyyy'),'dd-MM-yyyy')

Line 1570: AND mem.resource_type = 'INDIVIDUAL'

1566: SELECT 'X'
1567: FROM jtf_rs_team_members mem,
1568: jtf_rs_role_relations rlt
1569: WHERE mem.team_resource_id = l_resource_id
1570: AND mem.resource_type = 'INDIVIDUAL'
1571: AND nvl(mem.delete_flag, 'N') <> 'Y'
1572: AND mem.team_member_id = rlt.role_resource_id
1573: AND rlt.role_resource_type = 'RS_TEAM_MEMBER'
1574: AND nvl(rlt.delete_flag, 'N') <> 'Y'

Line 1910: l_role_resource_type = 'RS_INDIVIDUAL')

1906:
1907:
1908: IF(l_role_resource_type = 'RS_TEAM' or
1909: l_role_resource_type = 'RS_GROUP' or
1910: l_role_resource_type = 'RS_INDIVIDUAL')
1911: THEN
1912: validate_role_type(l_role_id,
1913: l_start_date_active,
1914: l_end_date_active,

Line 2011: (l_team_resource_type = 'INDIVIDUAL')))

2007:
2008: --valid role for the resource if being entered as a group member and team member
2009: IF((l_role_resource_type = 'RS_GROUP_MEMBER') OR
2010: ((l_role_resource_type = 'RS_TEAM_MEMBER') AND
2011: (l_team_resource_type = 'INDIVIDUAL')))
2012: THEN
2013: --if team member is of type resource or it is group member
2014: --then check for valid role and st date , end date for the resource
2015: --in role relations

Line 2123: ELSIF(l_role_resource_type = 'RS_INDIVIDUAL')

2119: RAISE fnd_api.g_exc_error;
2120: END IF;
2121:
2122: close c_exclusive_group_check_cur;
2123: ELSIF(l_role_resource_type = 'RS_INDIVIDUAL')
2124: THEN
2125:
2126: open rsc_cur(l_role_resource_id);
2127: fetch rsc_cur INTO rsc_rec;

Line 2172: --if resource type is RS_INDIVIDUAL then check whether the start and end dates do not

2168: RAISE fnd_api.g_exc_error;
2169: END IF;
2170: END IF;
2171:
2172: --if resource type is RS_INDIVIDUAL then check whether the start and end dates do not
2173: --fall within the start and end dates if this resource is a team member or group member
2174: IF(l_role_resource_type = 'RS_INDIVIDUAL')
2175: THEN
2176: open res_team_cur(l_role_resource_id,

Line 2174: IF(l_role_resource_type = 'RS_INDIVIDUAL')

2170: END IF;
2171:
2172: --if resource type is RS_INDIVIDUAL then check whether the start and end dates do not
2173: --fall within the start and end dates if this resource is a team member or group member
2174: IF(l_role_resource_type = 'RS_INDIVIDUAL')
2175: THEN
2176: open res_team_cur(l_role_resource_id,
2177: l_start_date_active,
2178: l_end_date_active,

Line 2877: --If resource type is individual then check whether this resource with the same role

2873: -- end of user hook call
2874:
2875:
2876: --check the resource type
2877: --If resource type is individual then check whether this resource with the same role
2878: --is existing as a current team/group member
2879:
2880: OPEN chk_type_cur(l_role_relate_id);
2881: FETCH chk_type_cur INTO chk_type_rec;

Line 2903: IF chk_type_rec.role_resource_type = 'RS_INDIVIDUAL' THEN

2899: L_ATTRIBUTE15 := chk_type_rec.attribute15;
2900: L_ATTRIBUTE_CATEGORY := chk_type_rec.attribute_category;
2901:
2902:
2903: IF chk_type_rec.role_resource_type = 'RS_INDIVIDUAL' THEN
2904: OPEN chk_team_cur (chk_type_rec.role_resource_id ,
2905: chk_type_rec.role_id,
2906: chk_type_rec.start_date_active,
2907: chk_type_rec.end_date_active);