DBA Data[Home] [Help]

APPS.PA_BUDGET_LINES_V_PKG dependencies on PA_CURRENCY

Line 393: pa_currency.round_currency_amt(X_Raw_Cost),

389: X_Last_Update_Login,
390: X_End_Date,
391: X_Period_Name,
392: (X_Quantity),
393: pa_currency.round_currency_amt(X_Raw_Cost),
394: pa_currency.round_currency_amt(X_Burdened_Cost),
395: pa_currency.round_currency_amt(X_Revenue),
396: X_Change_Reason_Code,
397: X_Description,

Line 394: pa_currency.round_currency_amt(X_Burdened_Cost),

390: X_End_Date,
391: X_Period_Name,
392: (X_Quantity),
393: pa_currency.round_currency_amt(X_Raw_Cost),
394: pa_currency.round_currency_amt(X_Burdened_Cost),
395: pa_currency.round_currency_amt(X_Revenue),
396: X_Change_Reason_Code,
397: X_Description,
398: X_Attribute_Category,

Line 395: pa_currency.round_currency_amt(X_Revenue),

391: X_Period_Name,
392: (X_Quantity),
393: pa_currency.round_currency_amt(X_Raw_Cost),
394: pa_currency.round_currency_amt(X_Burdened_Cost),
395: pa_currency.round_currency_amt(X_Revenue),
396: X_Change_Reason_Code,
397: X_Description,
398: X_Attribute_Category,
399: X_Attribute1,

Line 471: set raw_cost = pa_currency.round_currency_amt(nvl(raw_cost,0) + nvl(x_raw_cost,0)),

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 =
475: (to_number(decode(x_track_as_labor_flag,

Line 472: burdened_cost = pa_currency.round_currency_amt(nvl(burdened_cost,0) + nvl(x_burdened_cost,0) ),

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 =
475: (to_number(decode(x_track_as_labor_flag,
476: 'Y', nvl(labor_quantity,0) + nvl(x_quantity,0),

Line 473: revenue = pa_currency.round_currency_amt(nvl(revenue,0) + nvl(x_revenue,0) ),

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 =
475: (to_number(decode(x_track_as_labor_flag,
476: 'Y', nvl(labor_quantity,0) + nvl(x_quantity,0),
477: nvl(labor_quantity,0)))),

Line 958: raw_cost = pa_currency.round_currency_amt(X_Raw_Cost),

954: last_update_login = X_Last_Update_Login,
955: end_date = X_End_Date,
956: period_name = X_Period_Name,
957: quantity = (X_Quantity),
958: raw_cost = pa_currency.round_currency_amt(X_Raw_Cost),
959: burdened_cost = pa_currency.round_currency_amt(X_Burdened_Cost),
960: revenue = pa_currency.round_currency_amt(X_Revenue),
961: change_reason_code = X_Change_Reason_Code,
962: description = X_Description,

Line 959: burdened_cost = pa_currency.round_currency_amt(X_Burdened_Cost),

955: end_date = X_End_Date,
956: period_name = X_Period_Name,
957: quantity = (X_Quantity),
958: raw_cost = pa_currency.round_currency_amt(X_Raw_Cost),
959: burdened_cost = pa_currency.round_currency_amt(X_Burdened_Cost),
960: revenue = pa_currency.round_currency_amt(X_Revenue),
961: change_reason_code = X_Change_Reason_Code,
962: description = X_Description,
963: attribute_category = X_Attribute_Category,

Line 960: revenue = pa_currency.round_currency_amt(X_Revenue),

956: period_name = X_Period_Name,
957: quantity = (X_Quantity),
958: raw_cost = pa_currency.round_currency_amt(X_Raw_Cost),
959: burdened_cost = pa_currency.round_currency_amt(X_Burdened_Cost),
960: revenue = pa_currency.round_currency_amt(X_Revenue),
961: change_reason_code = X_Change_Reason_Code,
962: description = X_Description,
963: attribute_category = X_Attribute_Category,
964: attribute1 = X_Attribute1,

Line 1042: raw_cost = pa_currency.round_currency_amt(nvl(raw_cost,0) - nvl(x_raw_cost_old,0)

1038: 'Y', nvl(labor_quantity,0)
1039: - nvl(x_quantity_old,0)
1040: + nvl(x_quantity,0),
1041: nvl(labor_quantity,0))) ),
1042: raw_cost = pa_currency.round_currency_amt(nvl(raw_cost,0) - nvl(x_raw_cost_old,0)
1043: + nvl(x_raw_cost,0) ),
1044: burdened_cost = pa_currency.round_currency_amt(nvl(burdened_cost,0)
1045: - nvl(x_burdened_cost_old,0)
1046: + nvl(x_burdened_cost,0) ),

Line 1044: burdened_cost = pa_currency.round_currency_amt(nvl(burdened_cost,0)

1040: + nvl(x_quantity,0),
1041: nvl(labor_quantity,0))) ),
1042: raw_cost = pa_currency.round_currency_amt(nvl(raw_cost,0) - nvl(x_raw_cost_old,0)
1043: + nvl(x_raw_cost,0) ),
1044: burdened_cost = pa_currency.round_currency_amt(nvl(burdened_cost,0)
1045: - nvl(x_burdened_cost_old,0)
1046: + nvl(x_burdened_cost,0) ),
1047: revenue = pa_currency.round_currency_amt(nvl(revenue,0) - nvl(x_revenue_old,0)
1048: + nvl(x_revenue,0) )

Line 1047: revenue = pa_currency.round_currency_amt(nvl(revenue,0) - nvl(x_revenue_old,0)

1043: + nvl(x_raw_cost,0) ),
1044: burdened_cost = pa_currency.round_currency_amt(nvl(burdened_cost,0)
1045: - nvl(x_burdened_cost_old,0)
1046: + nvl(x_burdened_cost,0) ),
1047: revenue = pa_currency.round_currency_amt(nvl(revenue,0) - nvl(x_revenue_old,0)
1048: + nvl(x_revenue,0) )
1049: where budget_version_id = x_budget_version_id;
1050:
1051: if (SQL%NOTFOUND) then

Line 1162: set raw_cost = pa_currency.round_currency_amt(nvl(raw_cost,0) - nvl(x_raw_cost,0) ),

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(
1166: decode(x_track_as_labor_flag,

Line 1163: burdened_cost = pa_currency.round_currency_amt(nvl(burdened_cost,0) - nvl(x_burdened_cost,0) ),

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(
1166: decode(x_track_as_labor_flag,
1167: 'Y', nvl(labor_quantity,0) - nvl(x_quantity,0),

Line 1164: revenue = pa_currency.round_currency_amt(nvl(revenue,0) - nvl(x_revenue,0) ),

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(
1166: decode(x_track_as_labor_flag,
1167: 'Y', nvl(labor_quantity,0) - nvl(x_quantity,0),
1168: nvl(labor_quantity,0))) ),