APPS.PA_FIN_PLAN_PUB dependencies on PA_FP_TXN_CURRENCIES

Line 1703: pa_fp_txn_currencies

1699: */
1700: FORALL i IN 1..l_proj_fp_options_id_tbl.COUNT
1701: delete
1702: from
1703: pa_fp_txn_currencies
1704: where
1705: proj_fp_options_id = l_proj_fp_options_id_tbl(i); -- bug 2779637
1706:
1707: --IPM Arch Enhancement Bug 4865563 Start

Line 2335: PA_FP_TXN_CURRENCIES_PUB.copy_fp_txn_currencies (

2331: pa_debug.g_err_stage := 'Calling copy_fp_txn_currencies api';
2332: pa_debug.write('Copy_Version: ' || l_module_name,pa_debug.g_err_stage,3);
2333: END IF;
2334:
2335: PA_FP_TXN_CURRENCIES_PUB.copy_fp_txn_currencies (
2336: p_source_fp_option_id => l_source_proj_fp_options_id
2337: ,p_target_fp_option_id => l_target_proj_fp_options_id
2338: ,p_target_fp_preference_code => NULL
2339: ,p_plan_in_multi_curr_flag => l_plan_in_multi_curr_flag --bug 2706430

Line 5136: pa_fp_txn_currencies and pa_budget_versions.

5132: Bug No. 2331201 For finplan this api has been added
5133: This api Creates a working fin plan version.The version inherits its
5134: properties from plan type.This api creates records in
5135: pa_proj_fp_options , pa_resource_assignments,
5136: pa_fp_txn_currencies and pa_budget_versions.
5137: If px_budget_version_id is passed it is assumed that new version
5138: id is created and passed to the api, else new value is created.
5139:
5140: -- 26-JUN-2003 jwhite - Plannable Task Dev Effort:

Line 6302: -- Insert the agreement_currency into pa_fp_txn_currencies table

6298: --Calling copy_fp_txn_currencies api
6299:
6300: IF p_agreement_id IS NOT NULL THEN
6301:
6302: -- Insert the agreement_currency into pa_fp_txn_currencies table
6303:
6304: PA_FP_TXN_CURRENCIES_PUB.enter_agreement_curr_for_ci
6305: ( p_project_id => p_project_id
6306: ,p_fin_plan_version_id => l_new_budget_version_id

Line 6304: PA_FP_TXN_CURRENCIES_PUB.enter_agreement_curr_for_ci

6300: IF p_agreement_id IS NOT NULL THEN
6301:
6302: -- Insert the agreement_currency into pa_fp_txn_currencies table
6303:
6304: PA_FP_TXN_CURRENCIES_PUB.enter_agreement_curr_for_ci
6305: ( p_project_id => p_project_id
6306: ,p_fin_plan_version_id => l_new_budget_version_id
6307: ,p_ci_id => p_ci_id
6308: ,p_project_currency_code => l_project_currency_code

Line 6325: PA_FP_TXN_CURRENCIES_PUB.COPY_FP_TXN_CURRENCIES (

6321: pa_debug.g_err_stage:='Calling COPY_FP_TXN_CURRENCIES api';
6322: pa_debug.write('Create_Version: ' || l_module_name,pa_debug.g_err_stage,3);
6323: END IF;
6324:
6325: PA_FP_TXN_CURRENCIES_PUB.COPY_FP_TXN_CURRENCIES (
6326: p_source_fp_option_id => new_version_info_rec.source_fp_options_id
6327: ,p_target_fp_option_id => l_new_proj_fp_options_id
6328: ,p_target_fp_preference_code => null
6329: ,p_plan_in_multi_curr_flag => new_version_info_rec.plan_in_multi_curr_flag

Line 6431: update pa_fp_txn_currencies

6427: l_project_bil_rate_date_code := PA_FP_CONSTANTS_PKG.G_RATE_DATE_TYPE_START_DATE;
6428:
6429: ELSIF l_project_bil_rate_type = PA_FP_CONSTANTS_PKG.G_RATE_TYPE_USER THEN --USER rate type.
6430:
6431: update pa_fp_txn_currencies
6432: set project_rev_exchange_rate = l_project_bil_exchange_rate
6433: where proj_fp_options_id = l_new_proj_fp_options_id
6434: and txn_currency_code = l_agreement_currency_code;
6435:

Line 6450: update pa_fp_txn_currencies

6446: l_projfunc_bil_rate_date_code := PA_FP_CONSTANTS_PKG.G_RATE_DATE_TYPE_START_DATE;
6447:
6448: ELSIF l_projfunc_bil_rate_type = PA_FP_CONSTANTS_PKG.G_RATE_TYPE_USER then --USER rate type.
6449:
6450: update pa_fp_txn_currencies
6451: set projfunc_rev_exchange_rate = l_projfunc_bil_exchange_rate
6452: where proj_fp_options_id = l_new_proj_fp_options_id
6453: and txn_currency_code = l_agreement_currency_code;
6454: