APPS.PA_FP_MULTI_CURRENCY_PKG dependencies on PA_BUDGET_VERSIONS

Line 1776: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

1772: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1773: END conv_mc_bulk;
1774:
1775: PROCEDURE convert_txn_currency
1776: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
1777: ,p_entire_version IN VARCHAR2 DEFAULT 'N'
1778: ,p_budget_line_id IN NUMBER DEFAULT NULL
1779: ,p_source_context IN VARCHAR2 DEFAULT 'BUDGET_VERSION'
1780: ,p_calling_module IN VARCHAR2 DEFAULT 'UPDATE_PLAN_TRANSACTION'-- Added for Bug#5395732

Line 1870: ,pa_budget_versions v

1866: ,o.project_rev_rate_type
1867: ,o.project_rev_rate_date_type
1868: ,o.project_rev_rate_date
1869: from pa_proj_fp_options o
1870: ,pa_budget_versions v
1871: where v.budget_version_id = p_budget_version_id
1872: and o.project_id = v.project_id
1873: and nvl(o.fin_plan_type_id,0) = nvl(v.fin_plan_type_id,0)
1874: and o.fin_plan_version_id = v.budget_version_id;

Line 1969: ,pa_budget_versions bv

1965: ,a.project_init_raw_cost
1966: ,a.project_init_burdened_cost
1967: ,a.project_init_revenue
1968: from pa_budget_lines a
1969: ,pa_budget_versions bv
1970: --,pa_fp_txn_currencies c
1971: where a.budget_version_id = p_budget_version_id
1972: and bv.budget_version_id = a.budget_version_id
1973: and EXISTS (select null

Line 2709: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

2705: Tracking bug No: 4035856 Rravipat Initial creation
2706: ==============================================================================*/
2707:
2708: PROCEDURE Round_Budget_Line_Amounts(
2709: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
2710: ,p_bls_inserted_after_id IN pa_budget_lines.budget_line_id%TYPE DEFAULT NULL
2711: ,p_calling_context IN VARCHAR2
2712: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2713: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 2776: l_version_type pa_budget_versions.version_type%TYPE;

2772: --Code changes for bug 4200168 ends here.
2773:
2774: --Bug 4052403
2775: l_rate_based_flag_tab pa_plsql_datatypes.Char1TabTyp;
2776: l_version_type pa_budget_versions.version_type%TYPE;
2777:
2778: -- cursor to fetch budget line amounts
2779: -- Changes in this cursor might have to be done in budget_line_amounts_cur1 also
2780: -- Bug 4052403. Selected rate_based_flag

Line 2880: FROM pa_budget_versions

2876:
2877: --Bug 4052403. Select the version type of the budget version for which the API is called
2878: SELECT version_type
2879: INTO l_version_type
2880: FROM pa_budget_versions
2881: WHERE budget_version_id=p_budget_version_id;
2882:
2883: -- open and fetch PC,PFC and txn cur amounts of the budget version
2884: IF p_calling_context='CHANGE_ORDER_MERGE' THEN