APPS.PA_FP_PLANNING_TRANSACTION_PUB dependencies on PA_FP_TXN_CURRENCIES

Line 8199: -- scan on PA_FP_TXN_CURRENCIES

8195: -- we need to ensure all the txn currencies are available in pa fp txn ccurrencies.
8196: IF p_src_project_id<>p_target_project_id THEN
8197:
8198: -- Bug 4872216 changes - performance fix to remove full table
8199: -- scan on PA_FP_TXN_CURRENCIES
8200: SELECT DISTINCT BL.TXN_CURRENCY_CODE
8201: BULK COLLECT
8202: INTO l_txn_curr_code_tbl
8203: FROM PA_BUDGET_LINES BL

Line 8207: FROM PA_FP_TXN_CURRENCIES TC

8203: FROM PA_BUDGET_LINES BL
8204: WHERE BL.BUDGET_VERSION_ID = l_targ_budget_version_id
8205: AND NOT EXISTS
8206: (SELECT 1
8207: FROM PA_FP_TXN_CURRENCIES TC
8208: ,PA_PROJ_FP_OPTIONS pfo -- Bug 4872216
8209: WHERE tc.fin_plan_version_id =
8210: l_targ_budget_version_id
8211: AND pfo.project_id = p_target_project_id --4872216

Line 8229: INSERT INTO PA_FP_TXN_CURRENCIES

8225: from pa_projects_all
8226: WHERE project_id = l_project_id;
8227:
8228: FORALL j IN 1..l_txn_curr_code_tbl.count
8229: INSERT INTO PA_FP_TXN_CURRENCIES
8230: (
8231: FP_TXN_CURRENCY_ID,
8232: PROJ_FP_OPTIONS_ID,
8233: PROJECT_ID,

Line 8250: PA_FP_TXN_CURRENCIES_S.NEXTVAL,

8246: LAST_UPDATE_DATE
8247: )
8248: VALUES
8249: (
8250: PA_FP_TXN_CURRENCIES_S.NEXTVAL,
8251: l_proj_fp_options_id ,
8252: l_project_id,
8253: l_fin_plan_type_id,
8254: l_targ_budget_version_id,

Line 10184: pa_debug.g_err_stage:='Calling API pa_fp_txn_currencies_pub.Copy_Fp_Txn_Currencies';

10180: FROM pa_proj_fp_options
10181: WHERE proj_fp_options_id = l_proj_fp_options_id;
10182:
10183: IF l_debug_mode = 'Y' THEN
10184: pa_debug.g_err_stage:='Calling API pa_fp_txn_currencies_pub.Copy_Fp_Txn_Currencies';
10185: pa_debug.write('Add_wp_plan_type: ' || g_module_name,pa_debug.g_err_stage,3);
10186: END IF;
10187:
10188: PA_FP_TXN_CURRENCIES_PUB.COPY_FP_TXN_CURRENCIES (

Line 10188: PA_FP_TXN_CURRENCIES_PUB.COPY_FP_TXN_CURRENCIES (

10184: pa_debug.g_err_stage:='Calling API pa_fp_txn_currencies_pub.Copy_Fp_Txn_Currencies';
10185: pa_debug.write('Add_wp_plan_type: ' || g_module_name,pa_debug.g_err_stage,3);
10186: END IF;
10187:
10188: PA_FP_TXN_CURRENCIES_PUB.COPY_FP_TXN_CURRENCIES (
10189: p_source_fp_option_id => l_src_fp_option_id
10190: ,p_target_fp_option_id => l_proj_fp_options_id
10191: ,p_target_fp_preference_code => null
10192: ,p_plan_in_multi_curr_flag => l_plan_in_multi_curr_flag

Line 10199: pa_debug.g_err_stage:='Called API PA_FP_TXN_CURRENCIES_PUB.COPY_FP_TXN_CURRENCIES returned error';

10195: ,x_msg_data => l_msg_data );
10196:
10197: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
10198: IF l_debug_mode = 'Y' THEN
10199: pa_debug.g_err_stage:='Called API PA_FP_TXN_CURRENCIES_PUB.COPY_FP_TXN_CURRENCIES returned error';
10200: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.Add_wp_plan_type: ' || g_module_name,pa_debug.g_err_stage,5);
10201: END IF;
10202: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
10203: END IF;

Line 12160: PA_FP_TXN_CURRENCIES_PUB.copy_fp_txn_currencies (

12156: LOOP
12157: -- For each of the workplan versions, MC currencies should also be copied
12158: -- from plan type
12159:
12160: PA_FP_TXN_CURRENCIES_PUB.copy_fp_txn_currencies (
12161: p_source_fp_option_id => parent_plan_type_rec.proj_fp_options_id
12162: ,p_target_fp_option_id => l_proj_fp_options_id_tbl(i)
12163: ,p_target_fp_preference_code => NULL
12164: ,p_plan_in_multi_curr_flag => parent_plan_type_rec.plan_in_multi_curr_flag

Line 12171: pa_debug.g_err_stage:='Called API PA_FP_TXN_CURRENCIES_PUB.copy_fp_txn_currencies api returned error';

12167: ,x_msg_data => x_msg_data );
12168:
12169: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
12170: IF l_debug_mode = 'Y' THEN
12171: pa_debug.g_err_stage:='Called API PA_FP_TXN_CURRENCIES_PUB.copy_fp_txn_currencies api returned error';
12172: pa_debug.write('REFRESH_WP_SETTINGS: ' || g_module_name,pa_debug.g_err_stage,5);
12173: END IF;
12174: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
12175: END IF;