APPS.PA_BUDGET_LINES_V_PKG dependencies on PA_BUDGET_VERSIONS

Line 115: from pa_budget_versions

111: AND start_date = X_Start_Date;
112:
113: cursor get_budget_type_code is
114: select budget_type_code
115: from pa_budget_versions
116: where budget_version_id = x_budget_version_id;
117:
118: same_uom number;
119: p_quantity number;

Line 464: -- update pa_budget_versions

460:
461: END IF;
462: */
463:
464: -- update pa_budget_versions
465: -- Update pa_budget_versions only if the denormalized totals are
466: -- not being maintained in the form. Example the Copy Actual
467: -- process.
468:

Line 465: -- Update pa_budget_versions only if the denormalized totals are

461: END IF;
462: */
463:
464: -- update pa_budget_versions
465: -- Update pa_budget_versions only if the denormalized totals are
466: -- not being maintained in the form. Example the Copy Actual
467: -- process.
468:
469: if X_Calling_Process = 'PR' then

Line 470: update pa_budget_versions

466: -- not being maintained in the form. Example the Copy Actual
467: -- process.
468:
469: if X_Calling_Process = 'PR' then
470: update pa_budget_versions
471: set raw_cost = pa_currency.round_currency_amt(nvl(raw_cost,0) + nvl(x_raw_cost,0)),
472: burdened_cost = pa_currency.round_currency_amt(nvl(burdened_cost,0) + nvl(x_burdened_cost,0) ),
473: revenue = pa_currency.round_currency_amt(nvl(revenue,0) + nvl(x_revenue,0) ),
474: labor_quantity =

Line 825: from pa_budget_versions

821: v_budget_type_code varchar2(30);
822:
823: cursor get_budget_type_code is
824: select budget_type_code
825: from pa_budget_versions
826: where budget_version_id = x_budget_version_id;
827:
828:
829: l_Return_Status VARCHAR2(1) :=NULL;

Line 1030: -- Update pa_budget_versions only if the denormalized totals are

1026: or (nvl(x_raw_cost,0) <> nvl(x_raw_cost_old,0))
1027: or (nvl(x_burdened_cost,0) <> nvl(x_burdened_cost_old,0))
1028: or (nvl(x_revenue,0) <> nvl(x_revenue_old,0))) then
1029:
1030: -- Update pa_budget_versions only if the denormalized totals are
1031: -- not being maintained in the form. Example the Copy Actual
1032: -- process.
1033:
1034: if X_Calling_Process = 'PR' then

Line 1035: update pa_budget_versions

1031: -- not being maintained in the form. Example the Copy Actual
1032: -- process.
1033:
1034: if X_Calling_Process = 'PR' then
1035: update pa_budget_versions
1036: set labor_quantity = (to_number(
1037: decode(x_track_as_labor_flag,
1038: 'Y', nvl(labor_quantity,0)
1039: - nvl(x_quantity_old,0)

Line 1156: -- Update pa_budget_versions only if the denormalized totals are

1152: (select 1
1153: from pa_budget_lines
1154: where resource_assignment_id = x_resource_assignment_id);
1155:
1156: -- Update pa_budget_versions only if the denormalized totals are
1157: -- not being maintained in the form. Example the Copy Actual
1158: -- process.
1159:
1160: if X_Calling_Process = 'PR' then

Line 1161: update pa_budget_versions

1157: -- not being maintained in the form. Example the Copy Actual
1158: -- process.
1159:
1160: if X_Calling_Process = 'PR' then
1161: update pa_budget_versions
1162: set raw_cost = pa_currency.round_currency_amt(nvl(raw_cost,0) - nvl(x_raw_cost,0) ),
1163: burdened_cost = pa_currency.round_currency_amt(nvl(burdened_cost,0) - nvl(x_burdened_cost,0) ),
1164: revenue = pa_currency.round_currency_amt(nvl(revenue,0) - nvl(x_revenue,0) ),
1165: labor_quantity = (to_number(