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 5987: pa_proj_fp_options, pa_fp_txn_currencies, period profile information.

5983: PA_BUDGET_CORE.COPY_BUDGETS_FROM_PROJECT
5984: Bug# - 2981655 - Please see bug for the complete discussion about
5985: this bug. The core is, when copy_project is done with copy_budget_flag
5986: as N, we still have to copy the header level informations
5987: pa_proj_fp_options, pa_fp_txn_currencies, period profile information.
5988: Also, we should not be copying the planning elements for any of the
5989: copied options since when copy_budget_flag is N, tasks may not have
5990: been copied from the source project to the target project.
5991:

Line 6331: PA_FP_TXN_CURRENCIES_PUB.Copy_Fp_Txn_Currencies(

6327: pa_debug.g_err_stage := 'Calling Copy_Fp_Txn_Currencies api';
6328: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
6329: END IF;
6330:
6331: PA_FP_TXN_CURRENCIES_PUB.Copy_Fp_Txn_Currencies(
6332: p_source_fp_option_id => l_proj_fp_options_id_tbl(l_index)
6333: ,p_target_fp_option_id => l_target_proj_fp_options_id
6334: ,p_target_fp_preference_code => NULL
6335: ,p_plan_in_multi_curr_flag => l_plan_in_multi_curr_flag

Line 6374: PA_FP_TXN_CURRENCIES_PUB.Copy_Fp_Txn_Currencies(

6370: pa_debug.g_err_stage := 'Calling Copy_Fp_Txn_Currencies api';
6371: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
6372: END IF;
6373:
6374: PA_FP_TXN_CURRENCIES_PUB.Copy_Fp_Txn_Currencies(
6375: p_source_fp_option_id => l_proj_fp_options_id_tbl(l_index)
6376: ,p_target_fp_option_id => l_target_proj_fp_options_id
6377: ,p_target_fp_preference_code => NULL
6378: ,p_plan_in_multi_curr_flag => l_plan_in_multi_curr_flag

Line 9033: PA_FP_TXN_CURRENCIES_PUB.Copy_Fp_Txn_Currencies(

9029: pa_debug.write( l_module_name,pa_debug.g_err_stage,l_debug_level3);
9030: END IF;
9031:
9032: --Call the API to create the txn currencies
9033: PA_FP_TXN_CURRENCIES_PUB.Copy_Fp_Txn_Currencies(
9034: p_source_fp_option_id => l_src_proj_fp_options_id
9035: ,p_target_fp_option_id => l_targ_proj_fp_options_id
9036: ,p_target_fp_preference_code => NULL
9037: ,p_plan_in_multi_curr_flag => l_targ_multi_curr_flag

Line 10046: 1) pa_fp_txn_currencies

10042: api is called to synchronise all the additional workplan settings related data.
10043: This api is called from copy_wp_budget_versions api at the end of copying all
10044: the budgets related data from source published version.
10045: Synchronisation involves:
10046: 1) pa_fp_txn_currencies
10047: 2) rate schedules, generation options and plan settings data
10048: (pa_proj_fp_options)
10049:
10050: Stating some of the business rules for clarity:

Line 10268: PA_FP_TXN_CURRENCIES_PUB.copy_fp_txn_currencies (

10264: WHERE proj_fp_options_id = wp_version_options_rec.proj_fp_options_id;
10265:
10266: -- Copy MC currencies from plan type
10267:
10268: PA_FP_TXN_CURRENCIES_PUB.copy_fp_txn_currencies (
10269: p_source_fp_option_id => parent_plan_type_rec.proj_fp_options_id
10270: ,p_target_fp_option_id => wp_version_options_rec.proj_fp_options_id
10271: ,p_target_fp_preference_code => NULL
10272: ,p_plan_in_multi_curr_flag => parent_plan_type_rec.plan_in_multi_curr_flag

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

10275: ,x_msg_data => x_msg_data );
10276:
10277: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
10278: IF l_debug_mode = 'Y' THEN
10279: pa_debug.g_err_stage:='Called API PA_FP_TXN_CURRENCIES_PUB.copy_fp_txn_currencies
10280: api returned error';
10281: pa_debug.write('Update_Plan_Setup_For_WP_Copy: ' || g_module_name,pa_debug.g_err_stage,5);
10282: END IF;
10283: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;