[Home] [Help]
27: IS
28: l_start_date DATE := '';
29: l_end_date DATE := '';
30: l_available_date DATE := '';
31: l_avl_profile VARCHAR2(240) := FND_NUMBER.CANONICAL_TO_NUMBER(fnd_profile.value('PA_RES_CAPACITY_PERCENTAGE'));
32:
33: -- new cursor to get available from date using pa_res_availability
34: -- table (PA.K enhancements)
35: CURSOR get_available_from IS
1514: p_avl_from_date IN DATE)
1515: RETURN DATE
1516: IS
1517: l_avl_to_date DATE;
1518: l_avl_profile NUMBER := FND_NUMBER.CANONICAL_TO_NUMBER(fnd_profile.value('PA_RES_CAPACITY_PERCENTAGE')); -- 4725606
1519: BEGIN
1520:
1521: IF p_avl_from_date is not null THEN
1522:
1525: from pa_res_availability
1526: where resource_id = p_resource_id
1527: and record_type = 'C'
1528: and start_date > p_avl_from_date
1529: -- Commented for 4725606 and percent < FND_NUMBER.CANONICAL_TO_NUMBER(fnd_profile.value('PA_RES_CAPACITY_PERCENTAGE'));
1530: and percent < l_avl_profile ; -- 4725606
1531:
1532: ELSE
1533: l_avl_to_date := null;
1561: p_ovc_from_date IN DATE)
1562: RETURN DATE
1563: IS
1564: l_ovc_to_date DATE;
1565: l_ovc_profile NUMBER := FND_NUMBER.CANONICAL_TO_NUMBER(fnd_profile.value('PA_OVERCOMMITMENT_PERCENTAGE')); -- 4725606
1566: BEGIN
1567:
1568: IF p_ovc_from_date is not null THEN
1569: select min(start_date)-1
1571: from pa_res_availability
1572: where resource_id = p_resource_id
1573: and record_type = 'C'
1574: and start_date > p_ovc_from_date
1575: -- Commented for 4725606 and -1 * percent < FND_NUMBER.CANONICAL_TO_NUMBER(fnd_profile.value('PA_OVERCOMMITMENT_PERCENTAGE'));
1576: and -1 * percent < l_ovc_profile ; -- 4725606
1577: ELSE
1578: l_ovc_to_date := null;
1579: END IF;