APPS.PA_BUDGET_LINES_UTILS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 7

                      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';

Line: 46

        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);

Line: 74

SELECT resource_assignment_id
FROM pa_resource_assignments
WHERE budget_version_id = p_budget_version_id
AND rate_based_flag = 'Y';

Line: 80

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';

Line: 88

SELECT resource_assignment_id
FROM pa_resource_asgn_curr_tmp;

Line: 129

      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);

Line: 140

        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);

Line: 148

      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));

Line: 164

        UPDATE pa_budget_lines
           SET display_quantity = quantity
         WHERE budget_version_id = p_budget_version_id;

Line: 177

        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);