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 2727: FROM pa_fp_txn_currencies

2723: d_project_cost_exc_rate_tab,
2724: d_project_rev_exc_rate_tab,
2725: d_projfunc_cost_exc_rate_tab,
2726: d_projfunc_rev_exc_rate_tab
2727: FROM pa_fp_txn_currencies
2728: WHERE proj_fp_options_id = p_version_info_rec.x_proj_fp_options_id;
2729: EXCEPTION
2730: WHEN OTHERS THEN
2731: IF l_debug_mode = 'Y' THEN

Line 12111: pa_fp_txn_currencies pftc,

12107: (select COST_CODE from pa_rbs_elements where RBS_ELEMENT_ID = pra.cbs_element_id) cost_code, -- cbs enhancement changes bug#16445106
12108: (select COST_CODE_NAME from pa_rbs_elements where RBS_ELEMENT_ID = pra.cbs_element_id) cost_code_name -- cbs enhancement changes bug#16445106
12109: FROM pa_resource_assignments pra,
12110: pa_resource_asgn_curr prac,
12111: pa_fp_txn_currencies pftc,
12112: pa_proj_elements pe,
12113: pa_proj_element_versions pev,
12114: pa_resource_list_members prlm,
12115: pa_lookups uom,

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

12213:
12214: --Commented out the below for bug 5330532
12215: /*
12216: --This Record is used to store the Transaction Currencies Associated with the budget version.
12217: TYPE txn_curr_rec IS RECORD(txn_currency_code pa_fp_txn_currencies.txn_currency_code%TYPE,
12218: project_cost_exchange_rate pa_fp_txn_currencies.project_cost_exchange_rate%TYPE,
12219: project_rev_exchange_rate pa_fp_txn_currencies.project_rev_exchange_rate%TYPE,
12220: projfunc_cost_exchange_rate pa_fp_txn_currencies.projfunc_cost_exchange_rate%TYPE,
12221: projfunc_rev_exchange_rate pa_fp_txn_currencies.projfunc_rev_exchange_rate%TYPE);

Line 12218: project_cost_exchange_rate pa_fp_txn_currencies.project_cost_exchange_rate%TYPE,

12214: --Commented out the below for bug 5330532
12215: /*
12216: --This Record is used to store the Transaction Currencies Associated with the budget version.
12217: TYPE txn_curr_rec IS RECORD(txn_currency_code pa_fp_txn_currencies.txn_currency_code%TYPE,
12218: project_cost_exchange_rate pa_fp_txn_currencies.project_cost_exchange_rate%TYPE,
12219: project_rev_exchange_rate pa_fp_txn_currencies.project_rev_exchange_rate%TYPE,
12220: projfunc_cost_exchange_rate pa_fp_txn_currencies.projfunc_cost_exchange_rate%TYPE,
12221: projfunc_rev_exchange_rate pa_fp_txn_currencies.projfunc_rev_exchange_rate%TYPE);
12222: --PL/SQL table created based on txn_curr_rec.

Line 12219: project_rev_exchange_rate pa_fp_txn_currencies.project_rev_exchange_rate%TYPE,

12215: /*
12216: --This Record is used to store the Transaction Currencies Associated with the budget version.
12217: TYPE txn_curr_rec IS RECORD(txn_currency_code pa_fp_txn_currencies.txn_currency_code%TYPE,
12218: project_cost_exchange_rate pa_fp_txn_currencies.project_cost_exchange_rate%TYPE,
12219: project_rev_exchange_rate pa_fp_txn_currencies.project_rev_exchange_rate%TYPE,
12220: projfunc_cost_exchange_rate pa_fp_txn_currencies.projfunc_cost_exchange_rate%TYPE,
12221: projfunc_rev_exchange_rate pa_fp_txn_currencies.projfunc_rev_exchange_rate%TYPE);
12222: --PL/SQL table created based on txn_curr_rec.
12223: TYPE txn_curr_tbl IS TABLE OF txn_curr_rec;

Line 12220: projfunc_cost_exchange_rate pa_fp_txn_currencies.projfunc_cost_exchange_rate%TYPE,

12216: --This Record is used to store the Transaction Currencies Associated with the budget version.
12217: TYPE txn_curr_rec IS RECORD(txn_currency_code pa_fp_txn_currencies.txn_currency_code%TYPE,
12218: project_cost_exchange_rate pa_fp_txn_currencies.project_cost_exchange_rate%TYPE,
12219: project_rev_exchange_rate pa_fp_txn_currencies.project_rev_exchange_rate%TYPE,
12220: projfunc_cost_exchange_rate pa_fp_txn_currencies.projfunc_cost_exchange_rate%TYPE,
12221: projfunc_rev_exchange_rate pa_fp_txn_currencies.projfunc_rev_exchange_rate%TYPE);
12222: --PL/SQL table created based on txn_curr_rec.
12223: TYPE txn_curr_tbl IS TABLE OF txn_curr_rec;
12224: */

Line 12221: projfunc_rev_exchange_rate pa_fp_txn_currencies.projfunc_rev_exchange_rate%TYPE);

12217: TYPE txn_curr_rec IS RECORD(txn_currency_code pa_fp_txn_currencies.txn_currency_code%TYPE,
12218: project_cost_exchange_rate pa_fp_txn_currencies.project_cost_exchange_rate%TYPE,
12219: project_rev_exchange_rate pa_fp_txn_currencies.project_rev_exchange_rate%TYPE,
12220: projfunc_cost_exchange_rate pa_fp_txn_currencies.projfunc_cost_exchange_rate%TYPE,
12221: projfunc_rev_exchange_rate pa_fp_txn_currencies.projfunc_rev_exchange_rate%TYPE);
12222: --PL/SQL table created based on txn_curr_rec.
12223: TYPE txn_curr_tbl IS TABLE OF txn_curr_rec;
12224: */
12225:

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

12241: --PL/SQL table created based on txn_curr_cur.
12242: TYPE txn_curr_tbl IS TABLE OF txn_curr_cur%ROWTYPE;
12243:
12244: --Cursor created for fetching transaction currency rates.
12245: CURSOR txn_curr_rate_cur(c_budget_version_id pa_fp_txn_currencies.fin_plan_version_id%TYPE,
12246: c_proj_fp_options_id pa_fp_txn_currencies.proj_fp_options_id%TYPE)
12247: IS
12248: SELECT pftc.txn_currency_code,
12249: pftc.project_cost_exchange_rate,

Line 12246: c_proj_fp_options_id pa_fp_txn_currencies.proj_fp_options_id%TYPE)

12242: TYPE txn_curr_tbl IS TABLE OF txn_curr_cur%ROWTYPE;
12243:
12244: --Cursor created for fetching transaction currency rates.
12245: CURSOR txn_curr_rate_cur(c_budget_version_id pa_fp_txn_currencies.fin_plan_version_id%TYPE,
12246: c_proj_fp_options_id pa_fp_txn_currencies.proj_fp_options_id%TYPE)
12247: IS
12248: SELECT pftc.txn_currency_code,
12249: pftc.project_cost_exchange_rate,
12250: pftc.project_rev_exchange_rate,

Line 12253: FROM pa_fp_txn_currencies pftc

12249: pftc.project_cost_exchange_rate,
12250: pftc.project_rev_exchange_rate,
12251: pftc.projfunc_cost_exchange_rate,
12252: pftc.projfunc_rev_exchange_rate
12253: FROM pa_fp_txn_currencies pftc
12254: WHERE pftc.fin_plan_version_id = c_budget_version_id
12255: AND pftc.proj_fp_options_id = c_proj_fp_options_id;
12256: --PL/SQL table created based on txn_curr_rate_cur.
12257: TYPE txn_curr_rate_tbl IS TABLE OF txn_curr_rate_cur%ROWTYPE INDEX BY VARCHAR2(15);

Line 12291: l_txn_currency_code pa_fp_txn_currencies.txn_currency_code%TYPE;

12287: l_fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
12288: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
12289: l_project_name pa_projects_all.name%TYPE;
12290: l_project_number pa_projects_all.segment1%TYPE;
12291: l_txn_currency_code pa_fp_txn_currencies.txn_currency_code%TYPE;
12292: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
12293: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
12294: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
12295: l_start_date DATE;

Line 12306: projfunc_exchange_rate pa_fp_txn_currencies.projfunc_cost_exchange_rate%TYPE;

12302: l_amt_type_tbl amt_type_tbl;
12303: -- Bug 5144013: Commenting out the declaration of l_txn_curr_tbl and l_txn_curr_rate_tbl.
12304: --l_txn_curr_tbl txn_curr_tbl := txn_curr_tbl(); --Bug 5330532.
12305: --l_txn_curr_rate_tbl txn_curr_rate_tbl; --Bug 5330532.
12306: projfunc_exchange_rate pa_fp_txn_currencies.projfunc_cost_exchange_rate%TYPE;
12307: project_exchange_rate pa_fp_txn_currencies.project_cost_exchange_rate%TYPE;
12308: l_position NUMBER := 0; -- Bug 5284640.
12309: l_return NUMBER := 0; -- Bug 5284640.
12310:

Line 12307: project_exchange_rate pa_fp_txn_currencies.project_cost_exchange_rate%TYPE;

12303: -- Bug 5144013: Commenting out the declaration of l_txn_curr_tbl and l_txn_curr_rate_tbl.
12304: --l_txn_curr_tbl txn_curr_tbl := txn_curr_tbl(); --Bug 5330532.
12305: --l_txn_curr_rate_tbl txn_curr_rate_tbl; --Bug 5330532.
12306: projfunc_exchange_rate pa_fp_txn_currencies.projfunc_cost_exchange_rate%TYPE;
12307: project_exchange_rate pa_fp_txn_currencies.project_cost_exchange_rate%TYPE;
12308: l_position NUMBER := 0; -- Bug 5284640.
12309: l_return NUMBER := 0; -- Bug 5284640.
12310:
12311: l_rec_version_number NUMBER :=0; --Bug 7863205

Line 12645: pa_fp_txn_currencies pftc

12641: pftc.projfunc_cost_exchange_rate,
12642: pftc.projfunc_rev_exchange_rate
12643: BULK COLLECT INTO l_txn_curr_tbl
12644: FROM pa_budget_lines pbl,
12645: pa_fp_txn_currencies pftc
12646: WHERE pbl.budget_version_id = l_budget_version_id
12647: AND pftc.fin_plan_version_id = l_budget_version_id
12648: AND pftc.proj_fp_options_id = l_proj_fp_options_id
12649: and pbl.txn_currency_code = pftc.txn_currency_code;