eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FP_COPY_FROM_PKG dependencies on PA_FP_TXN_CURRENCIES

Line 281: pa_fp_txn_currencies.txn_currency_code%TYPE INDEX BY BINARY_INTEGER;

277:
278: -- Start of plsql tables defined for bug#2729191
279:
280: TYPE txn_currency_code_tbl_typ IS TABLE OF
281: pa_fp_txn_currencies.txn_currency_code%TYPE INDEX BY BINARY_INTEGER;
282: TYPE default_rev_curr_flag_tbl_typ IS TABLE OF
283: pa_fp_txn_currencies.default_rev_curr_flag%TYPE INDEX BY BINARY_INTEGER;
284: TYPE default_cost_curr_flag_tbl_typ IS TABLE OF
285: pa_fp_txn_currencies.default_cost_curr_flag%TYPE INDEX BY BINARY_INTEGER;

Line 283: pa_fp_txn_currencies.default_rev_curr_flag%TYPE INDEX BY BINARY_INTEGER;

279:
280: TYPE txn_currency_code_tbl_typ IS TABLE OF
281: pa_fp_txn_currencies.txn_currency_code%TYPE INDEX BY BINARY_INTEGER;
282: TYPE default_rev_curr_flag_tbl_typ IS TABLE OF
283: pa_fp_txn_currencies.default_rev_curr_flag%TYPE INDEX BY BINARY_INTEGER;
284: TYPE default_cost_curr_flag_tbl_typ IS TABLE OF
285: pa_fp_txn_currencies.default_cost_curr_flag%TYPE INDEX BY BINARY_INTEGER;
286: TYPE default_all_curr_flag_tbl_typ IS TABLE OF
287: pa_fp_txn_currencies.default_all_curr_flag%TYPE INDEX BY BINARY_INTEGER;

Line 285: pa_fp_txn_currencies.default_cost_curr_flag%TYPE INDEX BY BINARY_INTEGER;

281: pa_fp_txn_currencies.txn_currency_code%TYPE INDEX BY BINARY_INTEGER;
282: TYPE default_rev_curr_flag_tbl_typ IS TABLE OF
283: pa_fp_txn_currencies.default_rev_curr_flag%TYPE INDEX BY BINARY_INTEGER;
284: TYPE default_cost_curr_flag_tbl_typ IS TABLE OF
285: pa_fp_txn_currencies.default_cost_curr_flag%TYPE INDEX BY BINARY_INTEGER;
286: TYPE default_all_curr_flag_tbl_typ IS TABLE OF
287: pa_fp_txn_currencies.default_all_curr_flag%TYPE INDEX BY BINARY_INTEGER;
288: TYPE project_currency_flag_tbl_typ IS TABLE OF
289: pa_fp_txn_currencies.project_currency_flag%TYPE INDEX BY BINARY_INTEGER;

Line 287: pa_fp_txn_currencies.default_all_curr_flag%TYPE INDEX BY BINARY_INTEGER;

283: pa_fp_txn_currencies.default_rev_curr_flag%TYPE INDEX BY BINARY_INTEGER;
284: TYPE default_cost_curr_flag_tbl_typ IS TABLE OF
285: pa_fp_txn_currencies.default_cost_curr_flag%TYPE INDEX BY BINARY_INTEGER;
286: TYPE default_all_curr_flag_tbl_typ IS TABLE OF
287: pa_fp_txn_currencies.default_all_curr_flag%TYPE INDEX BY BINARY_INTEGER;
288: TYPE project_currency_flag_tbl_typ IS TABLE OF
289: pa_fp_txn_currencies.project_currency_flag%TYPE INDEX BY BINARY_INTEGER;
290: TYPE projfunc_currency_flag_tbl_typ IS TABLE OF
291: pa_fp_txn_currencies.projfunc_currency_flag%TYPE INDEX BY BINARY_INTEGER;

Line 289: pa_fp_txn_currencies.project_currency_flag%TYPE INDEX BY BINARY_INTEGER;

285: pa_fp_txn_currencies.default_cost_curr_flag%TYPE INDEX BY BINARY_INTEGER;
286: TYPE default_all_curr_flag_tbl_typ IS TABLE OF
287: pa_fp_txn_currencies.default_all_curr_flag%TYPE INDEX BY BINARY_INTEGER;
288: TYPE project_currency_flag_tbl_typ IS TABLE OF
289: pa_fp_txn_currencies.project_currency_flag%TYPE INDEX BY BINARY_INTEGER;
290: TYPE projfunc_currency_flag_tbl_typ IS TABLE OF
291: pa_fp_txn_currencies.projfunc_currency_flag%TYPE INDEX BY BINARY_INTEGER;
292: TYPE pc_cost_exchange_rate_tbl_typ IS TABLE OF
293: pa_fp_txn_currencies.project_cost_exchange_rate%TYPE INDEX BY BINARY_INTEGER;

Line 291: pa_fp_txn_currencies.projfunc_currency_flag%TYPE INDEX BY BINARY_INTEGER;

287: pa_fp_txn_currencies.default_all_curr_flag%TYPE INDEX BY BINARY_INTEGER;
288: TYPE project_currency_flag_tbl_typ IS TABLE OF
289: pa_fp_txn_currencies.project_currency_flag%TYPE INDEX BY BINARY_INTEGER;
290: TYPE projfunc_currency_flag_tbl_typ IS TABLE OF
291: pa_fp_txn_currencies.projfunc_currency_flag%TYPE INDEX BY BINARY_INTEGER;
292: TYPE pc_cost_exchange_rate_tbl_typ IS TABLE OF
293: pa_fp_txn_currencies.project_cost_exchange_rate%TYPE INDEX BY BINARY_INTEGER;
294: TYPE pc_rev_exchange_rate_tbl_typ IS TABLE OF
295: pa_fp_txn_currencies.project_rev_exchange_rate%TYPE INDEX BY BINARY_INTEGER;

Line 293: pa_fp_txn_currencies.project_cost_exchange_rate%TYPE INDEX BY BINARY_INTEGER;

289: pa_fp_txn_currencies.project_currency_flag%TYPE INDEX BY BINARY_INTEGER;
290: TYPE projfunc_currency_flag_tbl_typ IS TABLE OF
291: pa_fp_txn_currencies.projfunc_currency_flag%TYPE INDEX BY BINARY_INTEGER;
292: TYPE pc_cost_exchange_rate_tbl_typ IS TABLE OF
293: pa_fp_txn_currencies.project_cost_exchange_rate%TYPE INDEX BY BINARY_INTEGER;
294: TYPE pc_rev_exchange_rate_tbl_typ IS TABLE OF
295: pa_fp_txn_currencies.project_rev_exchange_rate%TYPE INDEX BY BINARY_INTEGER;
296: TYPE pfc_cost_exchange_rate_tbl_typ IS TABLE OF
297: pa_fp_txn_currencies.projfunc_cost_exchange_rate%TYPE INDEX BY BINARY_INTEGER;

Line 295: pa_fp_txn_currencies.project_rev_exchange_rate%TYPE INDEX BY BINARY_INTEGER;

291: pa_fp_txn_currencies.projfunc_currency_flag%TYPE INDEX BY BINARY_INTEGER;
292: TYPE pc_cost_exchange_rate_tbl_typ IS TABLE OF
293: pa_fp_txn_currencies.project_cost_exchange_rate%TYPE INDEX BY BINARY_INTEGER;
294: TYPE pc_rev_exchange_rate_tbl_typ IS TABLE OF
295: pa_fp_txn_currencies.project_rev_exchange_rate%TYPE INDEX BY BINARY_INTEGER;
296: TYPE pfc_cost_exchange_rate_tbl_typ IS TABLE OF
297: pa_fp_txn_currencies.projfunc_cost_exchange_rate%TYPE INDEX BY BINARY_INTEGER;
298: TYPE pfc_rev_exchange_rate_tbl_typ IS TABLE OF
299: pa_fp_txn_currencies.projfunc_rev_exchange_rate%TYPE INDEX BY BINARY_INTEGER;

Line 297: pa_fp_txn_currencies.projfunc_cost_exchange_rate%TYPE INDEX BY BINARY_INTEGER;

293: pa_fp_txn_currencies.project_cost_exchange_rate%TYPE INDEX BY BINARY_INTEGER;
294: TYPE pc_rev_exchange_rate_tbl_typ IS TABLE OF
295: pa_fp_txn_currencies.project_rev_exchange_rate%TYPE INDEX BY BINARY_INTEGER;
296: TYPE pfc_cost_exchange_rate_tbl_typ IS TABLE OF
297: pa_fp_txn_currencies.projfunc_cost_exchange_rate%TYPE INDEX BY BINARY_INTEGER;
298: TYPE pfc_rev_exchange_rate_tbl_typ IS TABLE OF
299: pa_fp_txn_currencies.projfunc_rev_exchange_rate%TYPE INDEX BY BINARY_INTEGER;
300:
301: l_txn_currency_code_tbl txn_currency_code_tbl_typ;

Line 299: pa_fp_txn_currencies.projfunc_rev_exchange_rate%TYPE INDEX BY BINARY_INTEGER;

295: pa_fp_txn_currencies.project_rev_exchange_rate%TYPE INDEX BY BINARY_INTEGER;
296: TYPE pfc_cost_exchange_rate_tbl_typ IS TABLE OF
297: pa_fp_txn_currencies.projfunc_cost_exchange_rate%TYPE INDEX BY BINARY_INTEGER;
298: TYPE pfc_rev_exchange_rate_tbl_typ IS TABLE OF
299: pa_fp_txn_currencies.projfunc_rev_exchange_rate%TYPE INDEX BY BINARY_INTEGER;
300:
301: l_txn_currency_code_tbl txn_currency_code_tbl_typ;
302: l_default_rev_curr_flag_tbl default_rev_curr_flag_tbl_typ;
303: l_default_cost_curr_flag_tbl default_cost_curr_flag_tbl_typ;

Line 352: FROM PA_FP_TXN_CURRENCIES

348: ,project_cost_exchange_rate
349: ,project_rev_exchange_rate
350: ,projfunc_cost_exchange_rate
351: ,projfunc_rev_exchange_rate
352: FROM PA_FP_TXN_CURRENCIES
353: WHERE fin_plan_version_id = p_target_plan_version_id
354: AND proj_fp_options_id = target_fp_options_rec.proj_fp_options_id; -- bug 2779637
355:
356: -- End of cursors defined for bug#2729191

Line 627: DELETE FROM pa_fp_txn_currencies

623: pa_debug.g_err_stage:='Deleting the txn currencies of the target version after copy_version';
624: pa_debug.write('Copy_Plan: ' || g_module_name,pa_debug.g_err_stage,3);
625: END IF;
626:
627: DELETE FROM pa_fp_txn_currencies
628: WHERE fin_plan_version_id = p_target_plan_version_id
629: AND proj_fp_options_id = target_fp_options_rec.proj_fp_options_id; -- bug 2779637
630:
631: -- Update the Multi_Curr_Flag and the MC attributes of the target fp option

Line 666: INSERT INTO PA_FP_TXN_CURRENCIES (

662: pa_debug.write('Copy_Plan: ' || g_module_name,pa_debug.g_err_stage,3);
663: END IF;
664:
665: FORALL i IN l_txn_currency_code_tbl.first..l_txn_currency_code_tbl.last
666: INSERT INTO PA_FP_TXN_CURRENCIES (
667: fp_txn_currency_id
668: ,proj_fp_options_id
669: ,project_id
670: ,fin_plan_type_id

Line 688: pa_fp_txn_currencies_s.NEXTVAL

684: ,project_rev_exchange_rate
685: ,projfunc_cost_exchange_rate
686: ,projfunc_rev_exchange_rate )
687: SELECT
688: pa_fp_txn_currencies_s.NEXTVAL
689: ,target_fp_options_rec.proj_fp_options_id
690: ,target_fp_options_rec.project_id
691: ,target_fp_options_rec.fin_plan_type_id
692: ,p_target_plan_version_id

Line 6000: pa_proj_fp_options, pa_fp_txn_currencies, period profile information.

5996: PA_BUDGET_CORE.COPY_BUDGETS_FROM_PROJECT
5997: Bug# - 2981655 - Please see bug for the complete discussion about
5998: this bug. The core is, when copy_project is done with copy_budget_flag
5999: as N, we still have to copy the header level informations
6000: pa_proj_fp_options, pa_fp_txn_currencies, period profile information.
6001: Also, we should not be copying the planning elements for any of the
6002: copied options since when copy_budget_flag is N, tasks may not have
6003: been copied from the source project to the target project.
6004:

Line 6347: PA_FP_TXN_CURRENCIES_PUB.Copy_Fp_Txn_Currencies(

6343: pa_debug.g_err_stage := 'Calling Copy_Fp_Txn_Currencies api';
6344: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
6345: END IF;
6346:
6347: PA_FP_TXN_CURRENCIES_PUB.Copy_Fp_Txn_Currencies(
6348: p_source_fp_option_id => l_proj_fp_options_id_tbl(l_index)
6349: ,p_target_fp_option_id => l_target_proj_fp_options_id
6350: ,p_target_fp_preference_code => NULL
6351: ,p_plan_in_multi_curr_flag => l_plan_in_multi_curr_flag

Line 6391: PA_FP_TXN_CURRENCIES_PUB.Copy_Fp_Txn_Currencies(

6387: pa_debug.g_err_stage := 'Calling Copy_Fp_Txn_Currencies api';
6388: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
6389: END IF;
6390:
6391: PA_FP_TXN_CURRENCIES_PUB.Copy_Fp_Txn_Currencies(
6392: p_source_fp_option_id => l_proj_fp_options_id_tbl(l_index)
6393: ,p_target_fp_option_id => l_target_proj_fp_options_id
6394: ,p_target_fp_preference_code => NULL
6395: ,p_plan_in_multi_curr_flag => l_plan_in_multi_curr_flag

Line 9060: PA_FP_TXN_CURRENCIES_PUB.Copy_Fp_Txn_Currencies(

9056: pa_debug.write( l_module_name,pa_debug.g_err_stage,l_debug_level3);
9057: END IF;
9058:
9059: --Call the API to create the txn currencies
9060: PA_FP_TXN_CURRENCIES_PUB.Copy_Fp_Txn_Currencies(
9061: p_source_fp_option_id => l_src_proj_fp_options_id
9062: ,p_target_fp_option_id => l_targ_proj_fp_options_id
9063: ,p_target_fp_preference_code => NULL
9064: ,p_plan_in_multi_curr_flag => l_targ_multi_curr_flag

Line 10073: 1) pa_fp_txn_currencies

10069: api is called to synchronise all the additional workplan settings related data.
10070: This api is called from copy_wp_budget_versions api at the end of copying all
10071: the budgets related data from source published version.
10072: Synchronisation involves:
10073: 1) pa_fp_txn_currencies
10074: 2) rate schedules, generation options and plan settings data
10075: (pa_proj_fp_options)
10076:
10077: Stating some of the business rules for clarity:

Line 10295: PA_FP_TXN_CURRENCIES_PUB.copy_fp_txn_currencies (

10291: WHERE proj_fp_options_id = wp_version_options_rec.proj_fp_options_id;
10292:
10293: -- Copy MC currencies from plan type
10294:
10295: PA_FP_TXN_CURRENCIES_PUB.copy_fp_txn_currencies (
10296: p_source_fp_option_id => parent_plan_type_rec.proj_fp_options_id
10297: ,p_target_fp_option_id => wp_version_options_rec.proj_fp_options_id
10298: ,p_target_fp_preference_code => NULL
10299: ,p_plan_in_multi_curr_flag => parent_plan_type_rec.plan_in_multi_curr_flag

Line 10306: pa_debug.g_err_stage:='Called API PA_FP_TXN_CURRENCIES_PUB.copy_fp_txn_currencies

10302: ,x_msg_data => x_msg_data );
10303:
10304: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
10305: IF l_debug_mode = 'Y' THEN
10306: pa_debug.g_err_stage:='Called API PA_FP_TXN_CURRENCIES_PUB.copy_fp_txn_currencies
10307: api returned error';
10308: pa_debug.write('Update_Plan_Setup_For_WP_Copy: ' || g_module_name,pa_debug.g_err_stage,5);
10309: END IF;
10310: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;