[Home] [Help]
294: -- Version :
295: -- Initial version 1.0
296: --
297: -- Notes: Procedure to explode the resource team or resource group upto
298: -- individual level.
299: --
300: --
301: -- End of Comments
302: PROCEDURE GET_RES_FROM_TEAM_GROUP(
418: AND tu.team_id = t.team_id
419: AND tu.usage = 'PRM'
420: AND tm.team_member_id = trr.role_resource_id
421: AND tm.delete_flag <> 'Y'
422: AND tm.resource_type = 'INDIVIDUAL'
423: AND trr.role_resource_type = 'RS_TEAM_MEMBER'
424: AND trr.delete_flag <> 'Y'
425: AND sysdate between trr.start_date_active
426: AND nvl(trr.end_date_active,sysdate)
1517: x_msg_data OUT NOCOPY VARCHAR2,
1518: x_prtnr_access_id_tbl OUT NOCOPY prtnr_aces_tbl_type)
1519: IS
1520:
1521: -- Get the Individual resource information
1522: CURSOR l_get_res_category(cv_resource_id NUMBER) IS
1523: SELECT category
1524: FROM jtf_rs_resource_extns res,
1525: jtf_rs_role_relations rr,
1525: jtf_rs_role_relations rr,
1526: jtf_rs_roles_b r
1527: WHERE res.resource_id = cv_resource_id
1528: AND res.resource_id = rr.role_resource_id
1529: AND rr.role_resource_type ='RS_INDIVIDUAL'
1530: AND NVL(rr.delete_flag,'N') <> 'Y'
1531: AND sysdate between rr.start_date_active and
1532: nvl(rr.end_date_active,sysdate)
1533: AND rr.role_id = r.role_id
1654: END IF; /* l_resource_rec.resource_id.count > 0 */
1655:
1656: ELSIF ( l_winners_rec.resource_type(i_index) = 'RS_EMPLOYEE' OR
1657: l_winners_rec.resource_type(i_index) = 'RS_PARTY' ) THEN
1658: --------------------- Portion for Individual resources -----------------------
1659: OPEN l_get_res_category(l_winners_rec.resource_id(i_index));
1660: FETCH l_get_res_category INTO l_res_category ;
1661:
1662: IF ( l_get_res_category%FOUND ) THEN
2631:
2632:
2633: -- Get the value of Profile PV_DEFAULT_CM.
2634: CURSOR l_get_default_cm_csr(cv_profile_name IN VARCHAR2) IS
2635: SELECT nvl(fnd_profile.value(cv_profile_name),0) from dual;
2636:
2637: BEGIN
2638:
2639: -- Standard call to check for call compatibility.
2999: WHERE partner_id = cv_partner_id;
3000:
3001: -- Get the value of Profile PV_TAP_ASSIGN_ONLINE.
3002: CURSOR l_get_tap_prfl_value_csr(cv_profile_name IN VARCHAR2) IS
3003: SELECT fnd_profile.value(cv_profile_name) from dual;
3004:
3005: BEGIN
3006:
3007: -- Standard Start of API savepoint