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_SPREAD_AMTS_PKG dependencies on PA_PROJECTS_ALL

Line 825: ,p_proj_curr_cd IN pa_projects_all.project_currency_code%TYPE

821: ,p_txn_currency_code IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE
822: ,p_txn_curr_code_ovr IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE
823: ,x_budget_line_id OUT NOCOPY pa_budget_lines.BUDGET_LINE_ID%TYPE
824: ,p_budget_version_id IN pa_budget_lines.BUDGET_VERSION_ID%TYPE
825: ,p_proj_curr_cd IN pa_projects_all.project_currency_code%TYPE
826: ,p_projfunc_curr_cd IN pa_projects_all.projfunc_currency_code%TYPE
827: ,x_return_status OUT NOCOPY VARCHAR2
828: ,x_msg_count OUT NOCOPY NUMBER
829: ,x_msg_data OUT NOCOPY VARCHAR2) IS

Line 826: ,p_projfunc_curr_cd IN pa_projects_all.projfunc_currency_code%TYPE

822: ,p_txn_curr_code_ovr IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE
823: ,x_budget_line_id OUT NOCOPY pa_budget_lines.BUDGET_LINE_ID%TYPE
824: ,p_budget_version_id IN pa_budget_lines.BUDGET_VERSION_ID%TYPE
825: ,p_proj_curr_cd IN pa_projects_all.project_currency_code%TYPE
826: ,p_projfunc_curr_cd IN pa_projects_all.projfunc_currency_code%TYPE
827: ,x_return_status OUT NOCOPY VARCHAR2
828: ,x_msg_count OUT NOCOPY NUMBER
829: ,x_msg_data OUT NOCOPY VARCHAR2) IS
830:

Line 1954: ,pa_projects_all ppa

1950: 'REVENUE',ppfo.revenue_time_phased_code,
1951: ppfo.all_time_phased_code) time_phase_code
1952: FROM gl_sets_of_books gsb
1953: ,pa_implementations_all pia
1954: ,pa_projects_all ppa
1955: ,pa_budget_versions pbv
1956: ,pa_proj_fp_options ppfo
1957: WHERE ppa.project_id = pbv.project_id
1958: AND pbv.budget_version_id = ppfo.fin_plan_version_id

Line 2250: l_project_name pa_projects_all.name%TYPE;

2246: l_stage INTEGER;
2247:
2248: l_err_msg VARCHAR2(2000);
2249:
2250: l_project_name pa_projects_all.name%TYPE;
2251: l_task_name pa_proj_elements.name%TYPE;
2252: l_resource_name pa_resource_list_members.alias%TYPE;
2253: l_proj_curr_cd pa_projects_all.project_currency_code%TYPE;
2254: l_projfunc_curr_cd pa_projects_all.projfunc_currency_code%TYPE;

Line 2253: l_proj_curr_cd pa_projects_all.project_currency_code%TYPE;

2249:
2250: l_project_name pa_projects_all.name%TYPE;
2251: l_task_name pa_proj_elements.name%TYPE;
2252: l_resource_name pa_resource_list_members.alias%TYPE;
2253: l_proj_curr_cd pa_projects_all.project_currency_code%TYPE;
2254: l_projfunc_curr_cd pa_projects_all.projfunc_currency_code%TYPE;
2255:
2256: v_spread_amounts spread_table_type;
2257: v_spread_curve spread_curve_type;

Line 2254: l_projfunc_curr_cd pa_projects_all.projfunc_currency_code%TYPE;

2250: l_project_name pa_projects_all.name%TYPE;
2251: l_task_name pa_proj_elements.name%TYPE;
2252: l_resource_name pa_resource_list_members.alias%TYPE;
2253: l_proj_curr_cd pa_projects_all.project_currency_code%TYPE;
2254: l_projfunc_curr_cd pa_projects_all.projfunc_currency_code%TYPE;
2255:
2256: v_spread_amounts spread_table_type;
2257: v_spread_curve spread_curve_type;
2258: v_start_end_date start_end_date_table_type;

Line 2496: FROM pa_projects_all ppa

2492: CURSOR get_line_info (p_resource_assignment_id IN NUMBER) IS
2493: SELECT ppa.name project_name
2494: ,pt.name task_name
2495: ,prl.alias resource_name
2496: FROM pa_projects_all ppa
2497: ,pa_proj_elements pt
2498: ,pa_resource_list_members prl
2499: ,pa_resource_assignments pra
2500: WHERE pra.resource_assignment_id = p_resource_assignment_id