APPS.PA_FP_PLANNING_TRANSACTION_PUB dependencies on PA_FP_TXN_CURRENCIES

Line 9025: -- scan on PA_FP_TXN_CURRENCIES

9021: -- we need to ensure all the txn currencies are available in pa fp txn ccurrencies.
9022: IF p_src_project_id<>p_target_project_id THEN
9023:
9024: -- Bug 4872216 changes - performance fix to remove full table
9025: -- scan on PA_FP_TXN_CURRENCIES
9026: SELECT DISTINCT BL.TXN_CURRENCY_CODE
9027: BULK COLLECT
9028: INTO l_txn_curr_code_tbl
9029: FROM PA_BUDGET_LINES BL

Line 9033: FROM PA_FP_TXN_CURRENCIES TC

9029: FROM PA_BUDGET_LINES BL
9030: WHERE BL.BUDGET_VERSION_ID = l_targ_budget_version_id
9031: AND NOT EXISTS
9032: (SELECT 1
9033: FROM PA_FP_TXN_CURRENCIES TC
9034: ,PA_PROJ_FP_OPTIONS pfo -- Bug 4872216
9035: WHERE tc.fin_plan_version_id =
9036: l_targ_budget_version_id
9037: AND pfo.project_id = p_target_project_id --4872216

Line 9055: INSERT INTO PA_FP_TXN_CURRENCIES

9051: from pa_projects_all
9052: WHERE project_id = l_project_id;
9053:
9054: FORALL j IN 1..l_txn_curr_code_tbl.count
9055: INSERT INTO PA_FP_TXN_CURRENCIES
9056: (
9057: FP_TXN_CURRENCY_ID,
9058: PROJ_FP_OPTIONS_ID,
9059: PROJECT_ID,

Line 9076: PA_FP_TXN_CURRENCIES_S.NEXTVAL,

9072: LAST_UPDATE_DATE
9073: )
9074: VALUES
9075: (
9076: PA_FP_TXN_CURRENCIES_S.NEXTVAL,
9077: l_proj_fp_options_id ,
9078: l_project_id,
9079: l_fin_plan_type_id,
9080: l_targ_budget_version_id,

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

11046: FROM pa_proj_fp_options
11047: WHERE proj_fp_options_id = l_proj_fp_options_id;
11048:
11049: IF l_debug_mode = 'Y' THEN
11050: pa_debug.g_err_stage:='Calling API pa_fp_txn_currencies_pub.Copy_Fp_Txn_Currencies';
11051: pa_debug.write('Add_wp_plan_type: ' || g_module_name,pa_debug.g_err_stage,3);
11052: END IF;
11053:
11054: PA_FP_TXN_CURRENCIES_PUB.COPY_FP_TXN_CURRENCIES (

Line 11054: PA_FP_TXN_CURRENCIES_PUB.COPY_FP_TXN_CURRENCIES (

11050: pa_debug.g_err_stage:='Calling API pa_fp_txn_currencies_pub.Copy_Fp_Txn_Currencies';
11051: pa_debug.write('Add_wp_plan_type: ' || g_module_name,pa_debug.g_err_stage,3);
11052: END IF;
11053:
11054: PA_FP_TXN_CURRENCIES_PUB.COPY_FP_TXN_CURRENCIES (
11055: p_source_fp_option_id => l_src_fp_option_id
11056: ,p_target_fp_option_id => l_proj_fp_options_id
11057: ,p_target_fp_preference_code => null
11058: ,p_plan_in_multi_curr_flag => l_plan_in_multi_curr_flag

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

11061: ,x_msg_data => l_msg_data );
11062:
11063: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
11064: IF l_debug_mode = 'Y' THEN
11065: pa_debug.g_err_stage:='Called API PA_FP_TXN_CURRENCIES_PUB.COPY_FP_TXN_CURRENCIES returned error';
11066: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.Add_wp_plan_type: ' || g_module_name,pa_debug.g_err_stage,5);
11067: END IF;
11068: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
11069: END IF;

Line 13047: PA_FP_TXN_CURRENCIES_PUB.copy_fp_txn_currencies (

13043: LOOP
13044: -- For each of the workplan versions, MC currencies should also be copied
13045: -- from plan type
13046:
13047: PA_FP_TXN_CURRENCIES_PUB.copy_fp_txn_currencies (
13048: p_source_fp_option_id => parent_plan_type_rec.proj_fp_options_id
13049: ,p_target_fp_option_id => l_proj_fp_options_id_tbl(i)
13050: ,p_target_fp_preference_code => NULL
13051: ,p_plan_in_multi_curr_flag => parent_plan_type_rec.plan_in_multi_curr_flag

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

13054: ,x_msg_data => x_msg_data );
13055:
13056: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
13057: IF l_debug_mode = 'Y' THEN
13058: pa_debug.g_err_stage:='Called API PA_FP_TXN_CURRENCIES_PUB.copy_fp_txn_currencies api returned error';
13059: pa_debug.write('REFRESH_WP_SETTINGS: ' || g_module_name,pa_debug.g_err_stage,5);
13060: END IF;
13061: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
13062: END IF;