[Home] [Help]
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'
295: ll_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE )
296: IS
297: SELECT 'X'
298: FROM jtf_rs_role_relations
299: WHERE role_resource_type = 'RS_INDIVIDUAL'
300: AND role_resource_id = ll_role_resource_id
301: AND role_id = ll_role_id
302: AND nvl(delete_flag, '0') <> 'Y'
303: AND to_date(to_char(start_date_active , 'dd-MM-yyyy'),'dd-MM-yyyy') <=
619: END IF;
620:
621: IF(l_role_resource_type = 'RS_TEAM' or
622: l_role_resource_type = 'RS_GROUP' or
623: l_role_resource_type = 'RS_INDIVIDUAL')
624: THEN
625: validate_role_type(l_role_id,
626: l_start_date_active,
627: l_end_date_active,
709:
710: --valid role for the resource if being entered as a group member and team member
711: IF((l_role_resource_type = 'RS_GROUP_MEMBER') OR
712: ((l_role_resource_type = 'RS_TEAM_MEMBER') AND
713: (l_team_resource_type = 'INDIVIDUAL')))
714: THEN
715: --if team member is of type resource or it is group member
716: --then check for valid role and st date , end date for the resource
717: --in role relations
823: END IF;
824:
825: close c_exclusive_group_check_cur;
826:
827: ELSIF(l_role_resource_type = 'RS_INDIVIDUAL')
828: --check against res start and end dates
829: THEN
830: open rsc_cur(l_role_resource_id);
831: fetch rsc_cur INTO rsc_rec;
876:
877: --get the primary key sequence value
878: select jtf_rs_role_relations_s.nextval
879: into l_role_relate_id
880: from dual;
881:
882:
883: --call audit api for insert
884: jtf_rs_role_relate_aud_pvt.insert_role_relate(
1400: ll_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE )
1401: IS
1402: SELECT 'X'
1403: FROM jtf_rs_role_relations
1404: WHERE role_resource_type = 'RS_INDIVIDUAL'
1405: AND role_resource_id = ll_role_resource_id
1406: AND role_id = ll_role_id
1407: AND to_date(to_char(start_date_active , 'dd-MM-yyyy'),'dd-MM-yyyy') <=
1408: to_date(to_char(ll_start_date_active, 'dd-MM-yyyy'),'dd-MM-yyyy')
1552: SELECT 'X'
1553: FROM jtf_rs_team_members mem,
1554: jtf_rs_role_relations rlt
1555: WHERE mem.team_resource_id = l_resource_id
1556: AND mem.resource_type = 'INDIVIDUAL'
1557: AND nvl(mem.delete_flag, 'N') <> 'Y'
1558: AND mem.team_member_id = rlt.role_resource_id
1559: AND rlt.role_resource_type = 'RS_TEAM_MEMBER'
1560: AND nvl(rlt.delete_flag, 'N') <> 'Y'
1889:
1890:
1891: IF(l_role_resource_type = 'RS_TEAM' or
1892: l_role_resource_type = 'RS_GROUP' or
1893: l_role_resource_type = 'RS_INDIVIDUAL')
1894: THEN
1895: validate_role_type(l_role_id,
1896: l_start_date_active,
1897: l_end_date_active,
1983:
1984: --valid role for the resource if being entered as a group member and team member
1985: IF((l_role_resource_type = 'RS_GROUP_MEMBER') OR
1986: ((l_role_resource_type = 'RS_TEAM_MEMBER') AND
1987: (l_team_resource_type = 'INDIVIDUAL')))
1988: THEN
1989: --if team member is of type resource or it is group member
1990: --then check for valid role and st date , end date for the resource
1991: --in role relations
2093: RAISE fnd_api.g_exc_error;
2094: END IF;
2095:
2096: close c_exclusive_group_check_cur;
2097: ELSIF(l_role_resource_type = 'RS_INDIVIDUAL')
2098: THEN
2099:
2100: open rsc_cur(l_role_resource_id);
2101: fetch rsc_cur INTO rsc_rec;
2142: RAISE fnd_api.g_exc_error;
2143: END IF;
2144: END IF;
2145:
2146: --if resource type is RS_INDIVIDUAL then check whether the start and end dates do not
2147: --fall within the start and end dates if this resource is a team member or group member
2148: IF(l_role_resource_type = 'RS_INDIVIDUAL')
2149: THEN
2150: open res_team_cur(l_role_resource_id,
2144: END IF;
2145:
2146: --if resource type is RS_INDIVIDUAL then check whether the start and end dates do not
2147: --fall within the start and end dates if this resource is a team member or group member
2148: IF(l_role_resource_type = 'RS_INDIVIDUAL')
2149: THEN
2150: open res_team_cur(l_role_resource_id,
2151: l_start_date_active,
2152: l_end_date_active,
2847: -- end of user hook call
2848:
2849:
2850: --check the resource type
2851: --If resource type is individual then check whether this resource with the same role
2852: --is existing as a current team/group member
2853:
2854: OPEN chk_type_cur(l_role_relate_id);
2855: FETCH chk_type_cur INTO chk_type_rec;
2873: L_ATTRIBUTE15 := chk_type_rec.attribute15;
2874: L_ATTRIBUTE_CATEGORY := chk_type_rec.attribute_category;
2875:
2876:
2877: IF chk_type_rec.role_resource_type = 'RS_INDIVIDUAL' THEN
2878: OPEN chk_team_cur (chk_type_rec.role_resource_id ,
2879: chk_type_rec.role_id,
2880: chk_type_rec.start_date_active,
2881: chk_type_rec.end_date_active);