APPS.JTF_RS_RESOURCE_UTL_PUB dependencies on JTF_RS_ROLE_RELATE_PUB

Line 189: jtf_rs_role_relate_pub.delete_resource_role_relate

185: --if start date > sysdate -1 then delete the role
186: IF(trunc(res_team_rec.start_date_active) > trunc(p_end_date_active) )
187: THEN
188: --call delete role relate api
189: jtf_rs_role_relate_pub.delete_resource_role_relate
190: ( P_API_VERSION => 1.0,
191: P_ROLE_RELATE_ID => res_team_rec.role_relate_id,
192: P_OBJECT_VERSION_NUM => res_team_rec.object_version_number,
193: X_RETURN_STATUS => l_return_status,

Line 201: jtf_rs_role_relate_pub.update_resource_role_relate

197: ELSIF(nvl(l_end_date_active, l_fnd_date)
198: >= nvl(end_date_active, l_fnd_date))
199: THEN
200: --update end date with p_end_date_active -1 call update role relate api
201: jtf_rs_role_relate_pub.update_resource_role_relate
202: ( P_API_VERSION => 1.0,
203: P_ROLE_RELATE_ID => res_team_rec.role_relate_id,
204: P_END_DATE_ACTIVE => trunc(p_end_date_active) ,
205: P_OBJECT_VERSION_NUM => res_team_rec.object_version_number,

Line 229: jtf_rs_role_relate_pub.delete_resource_role_relate

225: l_end_date_active := to_date(to_char(res_group_rec.end_date_active, 'DD-MM-RRRR'), 'DD-MM-RRRR');
226: IF(trunc(res_group_rec.start_date_active) > trunc(p_end_date_active))
227: THEN
228: --call delete role relate api
229: jtf_rs_role_relate_pub.delete_resource_role_relate
230: ( P_API_VERSION => 1.0,
231: P_ROLE_RELATE_ID => res_group_rec.role_relate_id,
232: P_OBJECT_VERSION_NUM => res_group_rec.object_version_number,
233: X_RETURN_STATUS => l_return_status,

Line 241: jtf_rs_role_relate_pub.update_resource_role_relate

237: ELSIF(nvl(l_end_date_active, l_fnd_date)
238: >= nvl(end_date_active, l_fnd_date))
239: THEN
240: --update end date with p_end_date_active -1 call update role relate api
241: jtf_rs_role_relate_pub.update_resource_role_relate
242: ( P_API_VERSION => 1.0,
243: P_ROLE_RELATE_ID => res_group_rec.role_relate_id,
244: P_END_DATE_ACTIVE => trunc(p_end_date_active) ,
245: P_OBJECT_VERSION_NUM => res_group_rec.object_version_number,

Line 269: jtf_rs_role_relate_pub.delete_resource_role_relate

265: --if start date > sysdate -1 then delete the role
266: IF(trunc(res_role_rec.start_date_active) > trunc(p_end_date_active))
267: THEN
268: --call delete role relate api
269: jtf_rs_role_relate_pub.delete_resource_role_relate
270: ( P_API_VERSION => 1.0,
271: P_ROLE_RELATE_ID => res_role_rec.role_relate_id,
272: P_OBJECT_VERSION_NUM => res_role_rec.object_version_number,
273: X_RETURN_STATUS => l_return_status,

Line 280: jtf_rs_role_relate_pub.update_resource_role_relate

276: ELSIF(nvl(l_end_date_active, l_fnd_date)
277: >= nvl(end_date_active, l_fnd_date))
278: THEN
279: --update end date with sysdate -1 call update role relate api
280: jtf_rs_role_relate_pub.update_resource_role_relate
281: ( P_API_VERSION => 1.0,
282: P_ROLE_RELATE_ID => res_role_rec.role_relate_id,
283: P_END_DATE_ACTIVE => trunc(p_end_date_active) ,
284: P_OBJECT_VERSION_NUM => res_role_rec.object_version_number,

Line 859: jtf_rs_role_relate_pub.delete_resource_role_relate

855: l_end_date_active := to_date(to_char(group_mem_roles_rec.end_date_active, 'DD-MM-RRRR'), 'DD-MM-RRRR');
856: IF(trunc(group_mem_roles_rec.start_date_active) > trunc(p_end_date_active))
857: THEN
858: --call delete role relate api
859: jtf_rs_role_relate_pub.delete_resource_role_relate
860: ( P_API_VERSION => 1.0,
861: P_ROLE_RELATE_ID => group_mem_roles_rec.role_relate_id,
862: P_OBJECT_VERSION_NUM => group_mem_roles_rec.object_version_number,
863: X_RETURN_STATUS => l_return_status,

Line 871: jtf_rs_role_relate_pub.update_resource_role_relate

867: ELSIF(nvl(l_end_date_active, l_fnd_date)
868: >= nvl(end_date_active, l_fnd_date))
869: THEN
870: --update end date with p_end_date_active call update role relate api
871: jtf_rs_role_relate_pub.update_resource_role_relate
872: ( P_API_VERSION => 1.0,
873: P_ROLE_RELATE_ID => group_mem_roles_rec.role_relate_id,
874: P_END_DATE_ACTIVE => trunc(p_end_date_active) ,
875: P_OBJECT_VERSION_NUM => group_mem_roles_rec.object_version_number,