[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
1415: p_avl_from_date IN DATE)
1416: RETURN DATE
1417: IS
1418: l_avl_to_date DATE;
1419: l_avl_profile NUMBER := FND_NUMBER.CANONICAL_TO_NUMBER(fnd_profile.value('PA_RES_CAPACITY_PERCENTAGE')); -- 4725606
1420: BEGIN
1421:
1422: IF p_avl_from_date is not null THEN
1423:
1426: from pa_res_availability
1427: where resource_id = p_resource_id
1428: and record_type = 'C'
1429: and start_date > p_avl_from_date
1430: -- Commented for 4725606 and percent < FND_NUMBER.CANONICAL_TO_NUMBER(fnd_profile.value('PA_RES_CAPACITY_PERCENTAGE'));
1431: and percent < l_avl_profile ; -- 4725606
1432:
1433: ELSE
1434: l_avl_to_date := null;
1462: p_ovc_from_date IN DATE)
1463: RETURN DATE
1464: IS
1465: l_ovc_to_date DATE;
1466: l_ovc_profile NUMBER := FND_NUMBER.CANONICAL_TO_NUMBER(fnd_profile.value('PA_OVERCOMMITMENT_PERCENTAGE')); -- 4725606
1467: BEGIN
1468:
1469: IF p_ovc_from_date is not null THEN
1470: select min(start_date)-1
1472: from pa_res_availability
1473: where resource_id = p_resource_id
1474: and record_type = 'C'
1475: and start_date > p_ovc_from_date
1476: -- Commented for 4725606 and -1 * percent < FND_NUMBER.CANONICAL_TO_NUMBER(fnd_profile.value('PA_OVERCOMMITMENT_PERCENTAGE'));
1477: and -1 * percent < l_ovc_profile ; -- 4725606
1478: ELSE
1479: l_ovc_to_date := null;
1480: END IF;