The following lines contain the word 'select', 'insert', 'update' or 'delete':
in which pa_budget_lines are updated directly without going
through calculate API.
End of Comments
*/
-- bug 5067200: Added this private API to null out display_quantity for
-- non rate based planning txns. It is called from populate_display_qty.
PROCEDURE clear_non_rate_res_disp_qty
(p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
x_return_status OUT NOCOPY VARCHAR2)
IS
CURSOR get_non_rate_based_asgn
IS
SELECT resource_assignment_id
FROM pa_resource_assignments
WHERE budget_version_id = p_budget_version_id
AND rate_based_flag = 'N';
UPDATE pa_budget_lines
SET display_quantity = null
WHERE budget_version_id = p_budget_version_id
AND resource_assignment_id = l_non_rate_based_asgmt_id_tab(i);
SELECT resource_assignment_id
FROM pa_resource_assignments
WHERE budget_version_id = p_budget_version_id
AND rate_based_flag = 'Y';
SELECT ra.resource_assignment_id
FROM pa_resource_assignments ra,
pa_resource_asgn_curr_tmp ract
WHERE ra.budget_version_id = p_budget_version_id
AND ra.resource_assignment_id = ract.resource_assignment_id
AND ra.rate_based_flag = 'Y';
SELECT resource_assignment_id
FROM pa_resource_asgn_curr_tmp;
UPDATE pa_budget_lines
SET display_quantity = quantity
WHERE budget_version_id = p_budget_version_id
AND resource_assignment_id = l_rate_based_asgmt_id_tab(i);
UPDATE pa_budget_lines
SET display_quantity = quantity
WHERE budget_version_id = p_budget_version_id
AND resource_assignment_id = p_resource_assignment_id_tab(i);
UPDATE pa_budget_lines
SET display_quantity = quantity
WHERE budget_version_id = p_budget_version_id
AND resource_assignment_id = p_resource_assignment_id_tab(i)
AND resource_assignment_id in
(select resource_assignment_id
from pa_resource_assignments
where rate_based_flag = 'Y'
and budget_version_id = p_budget_version_id
and resource_assignment_id = p_resource_assignment_id_tab(i));
UPDATE pa_budget_lines
SET display_quantity = quantity
WHERE budget_version_id = p_budget_version_id;
UPDATE pa_budget_lines
SET display_quantity = quantity
WHERE budget_version_id = p_budget_version_id
AND resource_assignment_id = l_rate_based_asgmt_id_tab(i);