APPS.PA_FIN_PLAN_PUB dependencies on PA_FP_TXN_CURRENCIES

Line 1687: pa_fp_txn_currencies

1683: */
1684: FORALL i IN 1..l_proj_fp_options_id_tbl.COUNT
1685: delete
1686: from
1687: pa_fp_txn_currencies
1688: where
1689: proj_fp_options_id = l_proj_fp_options_id_tbl(i); -- bug 2779637
1690:
1691: --IPM Arch Enhancement Bug 4865563 Start

Line 2319: PA_FP_TXN_CURRENCIES_PUB.copy_fp_txn_currencies (

2315: pa_debug.g_err_stage := 'Calling copy_fp_txn_currencies api';
2316: pa_debug.write('Copy_Version: ' || l_module_name,pa_debug.g_err_stage,3);
2317: END IF;
2318:
2319: PA_FP_TXN_CURRENCIES_PUB.copy_fp_txn_currencies (
2320: p_source_fp_option_id => l_source_proj_fp_options_id
2321: ,p_target_fp_option_id => l_target_proj_fp_options_id
2322: ,p_target_fp_preference_code => NULL
2323: ,p_plan_in_multi_curr_flag => l_plan_in_multi_curr_flag --bug 2706430

Line 5120: pa_fp_txn_currencies and pa_budget_versions.

5116: Bug No. 2331201 For finplan this api has been added
5117: This api Creates a working fin plan version.The version inherits its
5118: properties from plan type.This api creates records in
5119: pa_proj_fp_options , pa_resource_assignments,
5120: pa_fp_txn_currencies and pa_budget_versions.
5121: If px_budget_version_id is passed it is assumed that new version
5122: id is created and passed to the api, else new value is created.
5123:
5124: -- 26-JUN-2003 jwhite - Plannable Task Dev Effort:

Line 6282: -- Insert the agreement_currency into pa_fp_txn_currencies table

6278: --Calling copy_fp_txn_currencies api
6279:
6280: IF p_agreement_id IS NOT NULL THEN
6281:
6282: -- Insert the agreement_currency into pa_fp_txn_currencies table
6283:
6284: PA_FP_TXN_CURRENCIES_PUB.enter_agreement_curr_for_ci
6285: ( p_project_id => p_project_id
6286: ,p_fin_plan_version_id => l_new_budget_version_id

Line 6284: PA_FP_TXN_CURRENCIES_PUB.enter_agreement_curr_for_ci

6280: IF p_agreement_id IS NOT NULL THEN
6281:
6282: -- Insert the agreement_currency into pa_fp_txn_currencies table
6283:
6284: PA_FP_TXN_CURRENCIES_PUB.enter_agreement_curr_for_ci
6285: ( p_project_id => p_project_id
6286: ,p_fin_plan_version_id => l_new_budget_version_id
6287: ,p_ci_id => p_ci_id
6288: ,p_project_currency_code => l_project_currency_code

Line 6305: PA_FP_TXN_CURRENCIES_PUB.COPY_FP_TXN_CURRENCIES (

6301: pa_debug.g_err_stage:='Calling COPY_FP_TXN_CURRENCIES api';
6302: pa_debug.write('Create_Version: ' || l_module_name,pa_debug.g_err_stage,3);
6303: END IF;
6304:
6305: PA_FP_TXN_CURRENCIES_PUB.COPY_FP_TXN_CURRENCIES (
6306: p_source_fp_option_id => new_version_info_rec.source_fp_options_id
6307: ,p_target_fp_option_id => l_new_proj_fp_options_id
6308: ,p_target_fp_preference_code => null
6309: ,p_plan_in_multi_curr_flag => new_version_info_rec.plan_in_multi_curr_flag

Line 6411: update pa_fp_txn_currencies

6407: l_project_bil_rate_date_code := PA_FP_CONSTANTS_PKG.G_RATE_DATE_TYPE_START_DATE;
6408:
6409: ELSIF l_project_bil_rate_type = PA_FP_CONSTANTS_PKG.G_RATE_TYPE_USER THEN --USER rate type.
6410:
6411: update pa_fp_txn_currencies
6412: set project_rev_exchange_rate = l_project_bil_exchange_rate
6413: where proj_fp_options_id = l_new_proj_fp_options_id
6414: and txn_currency_code = l_agreement_currency_code;
6415:

Line 6430: update pa_fp_txn_currencies

6426: l_projfunc_bil_rate_date_code := PA_FP_CONSTANTS_PKG.G_RATE_DATE_TYPE_START_DATE;
6427:
6428: ELSIF l_projfunc_bil_rate_type = PA_FP_CONSTANTS_PKG.G_RATE_TYPE_USER then --USER rate type.
6429:
6430: update pa_fp_txn_currencies
6431: set projfunc_rev_exchange_rate = l_projfunc_bil_exchange_rate
6432: where proj_fp_options_id = l_new_proj_fp_options_id
6433: and txn_currency_code = l_agreement_currency_code;
6434: