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 2684: ,pa_projects_all ppa

2680: 'REVENUE',ppfo.revenue_time_phased_code,
2681: ppfo.all_time_phased_code) time_phase_code
2682: FROM gl_sets_of_books gsb
2683: ,pa_implementations_all pia
2684: ,pa_projects_all ppa
2685: ,pa_budget_versions pbv
2686: ,pa_proj_fp_options ppfo
2687: WHERE ppa.project_id = pbv.project_id
2688: AND pbv.budget_version_id = ppfo.fin_plan_version_id

Line 2980: l_project_name pa_projects_all.name%TYPE;

2976: l_stage INTEGER;
2977:
2978: l_err_msg VARCHAR2(2000);
2979:
2980: l_project_name pa_projects_all.name%TYPE;
2981: l_task_name pa_proj_elements.name%TYPE;
2982: l_resource_name pa_resource_list_members.alias%TYPE;
2983: l_proj_curr_cd pa_projects_all.project_currency_code%TYPE;
2984: l_projfunc_curr_cd pa_projects_all.projfunc_currency_code%TYPE;

Line 2983: l_proj_curr_cd pa_projects_all.project_currency_code%TYPE;

2979:
2980: l_project_name pa_projects_all.name%TYPE;
2981: l_task_name pa_proj_elements.name%TYPE;
2982: l_resource_name pa_resource_list_members.alias%TYPE;
2983: l_proj_curr_cd pa_projects_all.project_currency_code%TYPE;
2984: l_projfunc_curr_cd pa_projects_all.projfunc_currency_code%TYPE;
2985:
2986: v_spread_amounts spread_table_type;
2987: v_spread_curve spread_curve_type;

Line 2984: l_projfunc_curr_cd pa_projects_all.projfunc_currency_code%TYPE;

2980: l_project_name pa_projects_all.name%TYPE;
2981: l_task_name pa_proj_elements.name%TYPE;
2982: l_resource_name pa_resource_list_members.alias%TYPE;
2983: l_proj_curr_cd pa_projects_all.project_currency_code%TYPE;
2984: l_projfunc_curr_cd pa_projects_all.projfunc_currency_code%TYPE;
2985:
2986: v_spread_amounts spread_table_type;
2987: v_spread_curve spread_curve_type;
2988: v_start_end_date start_end_date_table_type;

Line 3226: FROM pa_projects_all ppa

3222: CURSOR get_line_info (p_resource_assignment_id IN NUMBER) IS
3223: SELECT ppa.name project_name
3224: ,pt.name task_name
3225: ,prl.alias resource_name
3226: FROM pa_projects_all ppa
3227: ,pa_proj_elements pt
3228: ,pa_resource_list_members prl
3229: ,pa_resource_assignments pra
3230: WHERE pra.resource_assignment_id = p_resource_assignment_id