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_WEBADI_PKG dependencies on PA_FP_TXN_CURRENCIES

Line 2679: FROM pa_fp_txn_currencies

2675: d_project_cost_exc_rate_tab,
2676: d_project_rev_exc_rate_tab,
2677: d_projfunc_cost_exc_rate_tab,
2678: d_projfunc_rev_exc_rate_tab
2679: FROM pa_fp_txn_currencies
2680: WHERE proj_fp_options_id = p_version_info_rec.x_proj_fp_options_id;
2681: EXCEPTION
2682: WHEN OTHERS THEN
2683: IF l_debug_mode = 'Y' THEN

Line 11878: pa_fp_txn_currencies pftc,

11874: pftc.projfunc_cost_exchange_rate projfunc_cost_exchange_rate,
11875: pftc.projfunc_rev_exchange_rate projfunc_rev_exchange_rate
11876: FROM pa_resource_assignments pra,
11877: pa_resource_asgn_curr prac,
11878: pa_fp_txn_currencies pftc,
11879: pa_proj_elements pe,
11880: pa_proj_element_versions pev,
11881: pa_resource_list_members prlm,
11882: pa_lookups uom,

Line 11984: TYPE txn_curr_rec IS RECORD(txn_currency_code pa_fp_txn_currencies.txn_currency_code%TYPE,

11980:
11981: --Commented out the below for bug 5330532
11982: /*
11983: --This Record is used to store the Transaction Currencies Associated with the budget version.
11984: TYPE txn_curr_rec IS RECORD(txn_currency_code pa_fp_txn_currencies.txn_currency_code%TYPE,
11985: project_cost_exchange_rate pa_fp_txn_currencies.project_cost_exchange_rate%TYPE,
11986: project_rev_exchange_rate pa_fp_txn_currencies.project_rev_exchange_rate%TYPE,
11987: projfunc_cost_exchange_rate pa_fp_txn_currencies.projfunc_cost_exchange_rate%TYPE,
11988: projfunc_rev_exchange_rate pa_fp_txn_currencies.projfunc_rev_exchange_rate%TYPE);

Line 11985: project_cost_exchange_rate pa_fp_txn_currencies.project_cost_exchange_rate%TYPE,

11981: --Commented out the below for bug 5330532
11982: /*
11983: --This Record is used to store the Transaction Currencies Associated with the budget version.
11984: TYPE txn_curr_rec IS RECORD(txn_currency_code pa_fp_txn_currencies.txn_currency_code%TYPE,
11985: project_cost_exchange_rate pa_fp_txn_currencies.project_cost_exchange_rate%TYPE,
11986: project_rev_exchange_rate pa_fp_txn_currencies.project_rev_exchange_rate%TYPE,
11987: projfunc_cost_exchange_rate pa_fp_txn_currencies.projfunc_cost_exchange_rate%TYPE,
11988: projfunc_rev_exchange_rate pa_fp_txn_currencies.projfunc_rev_exchange_rate%TYPE);
11989: --PL/SQL table created based on txn_curr_rec.

Line 11986: project_rev_exchange_rate pa_fp_txn_currencies.project_rev_exchange_rate%TYPE,

11982: /*
11983: --This Record is used to store the Transaction Currencies Associated with the budget version.
11984: TYPE txn_curr_rec IS RECORD(txn_currency_code pa_fp_txn_currencies.txn_currency_code%TYPE,
11985: project_cost_exchange_rate pa_fp_txn_currencies.project_cost_exchange_rate%TYPE,
11986: project_rev_exchange_rate pa_fp_txn_currencies.project_rev_exchange_rate%TYPE,
11987: projfunc_cost_exchange_rate pa_fp_txn_currencies.projfunc_cost_exchange_rate%TYPE,
11988: projfunc_rev_exchange_rate pa_fp_txn_currencies.projfunc_rev_exchange_rate%TYPE);
11989: --PL/SQL table created based on txn_curr_rec.
11990: TYPE txn_curr_tbl IS TABLE OF txn_curr_rec;

Line 11987: projfunc_cost_exchange_rate pa_fp_txn_currencies.projfunc_cost_exchange_rate%TYPE,

11983: --This Record is used to store the Transaction Currencies Associated with the budget version.
11984: TYPE txn_curr_rec IS RECORD(txn_currency_code pa_fp_txn_currencies.txn_currency_code%TYPE,
11985: project_cost_exchange_rate pa_fp_txn_currencies.project_cost_exchange_rate%TYPE,
11986: project_rev_exchange_rate pa_fp_txn_currencies.project_rev_exchange_rate%TYPE,
11987: projfunc_cost_exchange_rate pa_fp_txn_currencies.projfunc_cost_exchange_rate%TYPE,
11988: projfunc_rev_exchange_rate pa_fp_txn_currencies.projfunc_rev_exchange_rate%TYPE);
11989: --PL/SQL table created based on txn_curr_rec.
11990: TYPE txn_curr_tbl IS TABLE OF txn_curr_rec;
11991: */

Line 11988: projfunc_rev_exchange_rate pa_fp_txn_currencies.projfunc_rev_exchange_rate%TYPE);

11984: TYPE txn_curr_rec IS RECORD(txn_currency_code pa_fp_txn_currencies.txn_currency_code%TYPE,
11985: project_cost_exchange_rate pa_fp_txn_currencies.project_cost_exchange_rate%TYPE,
11986: project_rev_exchange_rate pa_fp_txn_currencies.project_rev_exchange_rate%TYPE,
11987: projfunc_cost_exchange_rate pa_fp_txn_currencies.projfunc_cost_exchange_rate%TYPE,
11988: projfunc_rev_exchange_rate pa_fp_txn_currencies.projfunc_rev_exchange_rate%TYPE);
11989: --PL/SQL table created based on txn_curr_rec.
11990: TYPE txn_curr_tbl IS TABLE OF txn_curr_rec;
11991: */
11992:

Line 12012: CURSOR txn_curr_rate_cur(c_budget_version_id pa_fp_txn_currencies.fin_plan_version_id%TYPE,

12008: --PL/SQL table created based on txn_curr_cur.
12009: TYPE txn_curr_tbl IS TABLE OF txn_curr_cur%ROWTYPE;
12010:
12011: --Cursor created for fetching transaction currency rates.
12012: CURSOR txn_curr_rate_cur(c_budget_version_id pa_fp_txn_currencies.fin_plan_version_id%TYPE,
12013: c_proj_fp_options_id pa_fp_txn_currencies.proj_fp_options_id%TYPE)
12014: IS
12015: SELECT pftc.txn_currency_code,
12016: pftc.project_cost_exchange_rate,

Line 12013: c_proj_fp_options_id pa_fp_txn_currencies.proj_fp_options_id%TYPE)

12009: TYPE txn_curr_tbl IS TABLE OF txn_curr_cur%ROWTYPE;
12010:
12011: --Cursor created for fetching transaction currency rates.
12012: CURSOR txn_curr_rate_cur(c_budget_version_id pa_fp_txn_currencies.fin_plan_version_id%TYPE,
12013: c_proj_fp_options_id pa_fp_txn_currencies.proj_fp_options_id%TYPE)
12014: IS
12015: SELECT pftc.txn_currency_code,
12016: pftc.project_cost_exchange_rate,
12017: pftc.project_rev_exchange_rate,

Line 12020: FROM pa_fp_txn_currencies pftc

12016: pftc.project_cost_exchange_rate,
12017: pftc.project_rev_exchange_rate,
12018: pftc.projfunc_cost_exchange_rate,
12019: pftc.projfunc_rev_exchange_rate
12020: FROM pa_fp_txn_currencies pftc
12021: WHERE pftc.fin_plan_version_id = c_budget_version_id
12022: AND pftc.proj_fp_options_id = c_proj_fp_options_id;
12023: --PL/SQL table created based on txn_curr_rate_cur.
12024: TYPE txn_curr_rate_tbl IS TABLE OF txn_curr_rate_cur%ROWTYPE INDEX BY VARCHAR2(15);

Line 12058: l_txn_currency_code pa_fp_txn_currencies.txn_currency_code%TYPE;

12054: l_fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
12055: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
12056: l_project_name pa_projects_all.name%TYPE;
12057: l_project_number pa_projects_all.segment1%TYPE;
12058: l_txn_currency_code pa_fp_txn_currencies.txn_currency_code%TYPE;
12059: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
12060: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
12061: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
12062: l_start_date DATE;

Line 12073: projfunc_exchange_rate pa_fp_txn_currencies.projfunc_cost_exchange_rate%TYPE;

12069: l_amt_type_tbl amt_type_tbl;
12070: -- Bug 5144013: Commenting out the declaration of l_txn_curr_tbl and l_txn_curr_rate_tbl.
12071: --l_txn_curr_tbl txn_curr_tbl := txn_curr_tbl(); --Bug 5330532.
12072: --l_txn_curr_rate_tbl txn_curr_rate_tbl; --Bug 5330532.
12073: projfunc_exchange_rate pa_fp_txn_currencies.projfunc_cost_exchange_rate%TYPE;
12074: project_exchange_rate pa_fp_txn_currencies.project_cost_exchange_rate%TYPE;
12075: l_position NUMBER := 0; -- Bug 5284640.
12076: l_return NUMBER := 0; -- Bug 5284640.
12077:

Line 12074: project_exchange_rate pa_fp_txn_currencies.project_cost_exchange_rate%TYPE;

12070: -- Bug 5144013: Commenting out the declaration of l_txn_curr_tbl and l_txn_curr_rate_tbl.
12071: --l_txn_curr_tbl txn_curr_tbl := txn_curr_tbl(); --Bug 5330532.
12072: --l_txn_curr_rate_tbl txn_curr_rate_tbl; --Bug 5330532.
12073: projfunc_exchange_rate pa_fp_txn_currencies.projfunc_cost_exchange_rate%TYPE;
12074: project_exchange_rate pa_fp_txn_currencies.project_cost_exchange_rate%TYPE;
12075: l_position NUMBER := 0; -- Bug 5284640.
12076: l_return NUMBER := 0; -- Bug 5284640.
12077:
12078: BEGIN

Line 12405: pa_fp_txn_currencies pftc

12401: pftc.projfunc_cost_exchange_rate,
12402: pftc.projfunc_rev_exchange_rate
12403: BULK COLLECT INTO l_txn_curr_tbl
12404: FROM pa_budget_lines pbl,
12405: pa_fp_txn_currencies pftc
12406: WHERE pbl.budget_version_id = l_budget_version_id
12407: AND pftc.fin_plan_version_id = l_budget_version_id
12408: AND pftc.proj_fp_options_id = l_proj_fp_options_id
12409: and pbl.txn_currency_code = pftc.txn_currency_code;