APPS.PA_FP_MULTI_CURRENCY_PKG dependencies on PA_BUDGET_VERSIONS

Line 1743: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

1739: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1740: END conv_mc_bulk;
1741:
1742: PROCEDURE convert_txn_currency
1743: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
1744: ,p_entire_version IN VARCHAR2 DEFAULT 'N'
1745: ,p_budget_line_id IN NUMBER DEFAULT NULL
1746: ,p_source_context IN VARCHAR2 DEFAULT 'BUDGET_VERSION'
1747: ,p_calling_module IN VARCHAR2 DEFAULT 'UPDATE_PLAN_TRANSACTION'-- Added for Bug#5395732

Line 1837: ,pa_budget_versions v

1833: ,o.project_rev_rate_type
1834: ,o.project_rev_rate_date_type
1835: ,o.project_rev_rate_date
1836: from pa_proj_fp_options o
1837: ,pa_budget_versions v
1838: where v.budget_version_id = p_budget_version_id
1839: and o.project_id = v.project_id
1840: and nvl(o.fin_plan_type_id,0) = nvl(v.fin_plan_type_id,0)
1841: and o.fin_plan_version_id = v.budget_version_id;

Line 1936: ,pa_budget_versions bv

1932: ,a.project_init_raw_cost
1933: ,a.project_init_burdened_cost
1934: ,a.project_init_revenue
1935: from pa_budget_lines a
1936: ,pa_budget_versions bv
1937: --,pa_fp_txn_currencies c
1938: where a.budget_version_id = p_budget_version_id
1939: and bv.budget_version_id = a.budget_version_id
1940: and EXISTS (select null

Line 2676: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

2672: Tracking bug No: 4035856 Rravipat Initial creation
2673: ==============================================================================*/
2674:
2675: PROCEDURE Round_Budget_Line_Amounts(
2676: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
2677: ,p_bls_inserted_after_id IN pa_budget_lines.budget_line_id%TYPE DEFAULT NULL
2678: ,p_calling_context IN VARCHAR2
2679: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2680: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 2743: l_version_type pa_budget_versions.version_type%TYPE;

2739: --Code changes for bug 4200168 ends here.
2740:
2741: --Bug 4052403
2742: l_rate_based_flag_tab pa_plsql_datatypes.Char1TabTyp;
2743: l_version_type pa_budget_versions.version_type%TYPE;
2744:
2745: -- cursor to fetch budget line amounts
2746: -- Changes in this cursor might have to be done in budget_line_amounts_cur1 also
2747: -- Bug 4052403. Selected rate_based_flag

Line 2847: FROM pa_budget_versions

2843:
2844: --Bug 4052403. Select the version type of the budget version for which the API is called
2845: SELECT version_type
2846: INTO l_version_type
2847: FROM pa_budget_versions
2848: WHERE budget_version_id=p_budget_version_id;
2849:
2850: -- open and fetch PC,PFC and txn cur amounts of the budget version
2851: IF p_calling_context='CHANGE_ORDER_MERGE' THEN