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

Line 28: ,x_project_start_date OUT NOCOPY pa_projects_all.start_date%TYPE --File.Sql.39 bug 4440895

24: ,x_period_profile_id OUT NOCOPY pa_budget_versions.period_profile_id%TYPE --File.Sql.39 bug 4440895
25: ,x_time_phased_code OUT NOCOPY pa_proj_fp_options.cost_time_phased_code%TYPE --File.Sql.39 bug 4440895
26: ,x_fin_plan_version_id OUT NOCOPY pa_proj_fp_options.fin_plan_version_id%TYPE --File.Sql.39 bug 4440895
27: ,x_fin_plan_level_code OUT NOCOPY pa_proj_fp_options.cost_fin_plan_level_code%TYPE --File.Sql.39 bug 4440895
28: ,x_project_start_date OUT NOCOPY pa_projects_all.start_date%TYPE --File.Sql.39 bug 4440895
29: ,x_project_end_date OUT NOCOPY pa_projects_all.start_date%TYPE --File.Sql.39 bug 4440895
30: ,x_task_start_date OUT NOCOPY pa_projects_all.start_date%TYPE --File.Sql.39 bug 4440895
31: ,x_task_end_date OUT NOCOPY pa_projects_all.start_date%TYPE --File.Sql.39 bug 4440895
32: ,x_plan_period_type OUT NOCOPY pa_proj_period_profiles.plan_period_type%TYPE --File.Sql.39 bug 4440895

Line 29: ,x_project_end_date OUT NOCOPY pa_projects_all.start_date%TYPE --File.Sql.39 bug 4440895

25: ,x_time_phased_code OUT NOCOPY pa_proj_fp_options.cost_time_phased_code%TYPE --File.Sql.39 bug 4440895
26: ,x_fin_plan_version_id OUT NOCOPY pa_proj_fp_options.fin_plan_version_id%TYPE --File.Sql.39 bug 4440895
27: ,x_fin_plan_level_code OUT NOCOPY pa_proj_fp_options.cost_fin_plan_level_code%TYPE --File.Sql.39 bug 4440895
28: ,x_project_start_date OUT NOCOPY pa_projects_all.start_date%TYPE --File.Sql.39 bug 4440895
29: ,x_project_end_date OUT NOCOPY pa_projects_all.start_date%TYPE --File.Sql.39 bug 4440895
30: ,x_task_start_date OUT NOCOPY pa_projects_all.start_date%TYPE --File.Sql.39 bug 4440895
31: ,x_task_end_date OUT NOCOPY pa_projects_all.start_date%TYPE --File.Sql.39 bug 4440895
32: ,x_plan_period_type OUT NOCOPY pa_proj_period_profiles.plan_period_type%TYPE --File.Sql.39 bug 4440895
33: ,x_period_set_name OUT NOCOPY pa_proj_period_profiles.period_set_name%TYPE --File.Sql.39 bug 4440895

Line 30: ,x_task_start_date OUT NOCOPY pa_projects_all.start_date%TYPE --File.Sql.39 bug 4440895

26: ,x_fin_plan_version_id OUT NOCOPY pa_proj_fp_options.fin_plan_version_id%TYPE --File.Sql.39 bug 4440895
27: ,x_fin_plan_level_code OUT NOCOPY pa_proj_fp_options.cost_fin_plan_level_code%TYPE --File.Sql.39 bug 4440895
28: ,x_project_start_date OUT NOCOPY pa_projects_all.start_date%TYPE --File.Sql.39 bug 4440895
29: ,x_project_end_date OUT NOCOPY pa_projects_all.start_date%TYPE --File.Sql.39 bug 4440895
30: ,x_task_start_date OUT NOCOPY pa_projects_all.start_date%TYPE --File.Sql.39 bug 4440895
31: ,x_task_end_date OUT NOCOPY pa_projects_all.start_date%TYPE --File.Sql.39 bug 4440895
32: ,x_plan_period_type OUT NOCOPY pa_proj_period_profiles.plan_period_type%TYPE --File.Sql.39 bug 4440895
33: ,x_period_set_name OUT NOCOPY pa_proj_period_profiles.period_set_name%TYPE --File.Sql.39 bug 4440895
34: ,x_project_currency_code OUT NOCOPY pa_projects_all.project_currency_code%TYPE --File.Sql.39 bug 4440895

Line 31: ,x_task_end_date OUT NOCOPY pa_projects_all.start_date%TYPE --File.Sql.39 bug 4440895

27: ,x_fin_plan_level_code OUT NOCOPY pa_proj_fp_options.cost_fin_plan_level_code%TYPE --File.Sql.39 bug 4440895
28: ,x_project_start_date OUT NOCOPY pa_projects_all.start_date%TYPE --File.Sql.39 bug 4440895
29: ,x_project_end_date OUT NOCOPY pa_projects_all.start_date%TYPE --File.Sql.39 bug 4440895
30: ,x_task_start_date OUT NOCOPY pa_projects_all.start_date%TYPE --File.Sql.39 bug 4440895
31: ,x_task_end_date OUT NOCOPY pa_projects_all.start_date%TYPE --File.Sql.39 bug 4440895
32: ,x_plan_period_type OUT NOCOPY pa_proj_period_profiles.plan_period_type%TYPE --File.Sql.39 bug 4440895
33: ,x_period_set_name OUT NOCOPY pa_proj_period_profiles.period_set_name%TYPE --File.Sql.39 bug 4440895
34: ,x_project_currency_code OUT NOCOPY pa_projects_all.project_currency_code%TYPE --File.Sql.39 bug 4440895
35: ,x_projfunc_currency_code OUT NOCOPY pa_projects_all.projfunc_currency_code%TYPE --File.Sql.39 bug 4440895

Line 34: ,x_project_currency_code OUT NOCOPY pa_projects_all.project_currency_code%TYPE --File.Sql.39 bug 4440895

30: ,x_task_start_date OUT NOCOPY pa_projects_all.start_date%TYPE --File.Sql.39 bug 4440895
31: ,x_task_end_date OUT NOCOPY pa_projects_all.start_date%TYPE --File.Sql.39 bug 4440895
32: ,x_plan_period_type OUT NOCOPY pa_proj_period_profiles.plan_period_type%TYPE --File.Sql.39 bug 4440895
33: ,x_period_set_name OUT NOCOPY pa_proj_period_profiles.period_set_name%TYPE --File.Sql.39 bug 4440895
34: ,x_project_currency_code OUT NOCOPY pa_projects_all.project_currency_code%TYPE --File.Sql.39 bug 4440895
35: ,x_projfunc_currency_code OUT NOCOPY pa_projects_all.projfunc_currency_code%TYPE --File.Sql.39 bug 4440895
36: ,x_project_id OUT NOCOPY pa_projects_all.project_id%TYPE --File.Sql.39 bug 4440895
37: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
38: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 35: ,x_projfunc_currency_code OUT NOCOPY pa_projects_all.projfunc_currency_code%TYPE --File.Sql.39 bug 4440895

31: ,x_task_end_date OUT NOCOPY pa_projects_all.start_date%TYPE --File.Sql.39 bug 4440895
32: ,x_plan_period_type OUT NOCOPY pa_proj_period_profiles.plan_period_type%TYPE --File.Sql.39 bug 4440895
33: ,x_period_set_name OUT NOCOPY pa_proj_period_profiles.period_set_name%TYPE --File.Sql.39 bug 4440895
34: ,x_project_currency_code OUT NOCOPY pa_projects_all.project_currency_code%TYPE --File.Sql.39 bug 4440895
35: ,x_projfunc_currency_code OUT NOCOPY pa_projects_all.projfunc_currency_code%TYPE --File.Sql.39 bug 4440895
36: ,x_project_id OUT NOCOPY pa_projects_all.project_id%TYPE --File.Sql.39 bug 4440895
37: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
38: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
39: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 36: ,x_project_id OUT NOCOPY pa_projects_all.project_id%TYPE --File.Sql.39 bug 4440895

32: ,x_plan_period_type OUT NOCOPY pa_proj_period_profiles.plan_period_type%TYPE --File.Sql.39 bug 4440895
33: ,x_period_set_name OUT NOCOPY pa_proj_period_profiles.period_set_name%TYPE --File.Sql.39 bug 4440895
34: ,x_project_currency_code OUT NOCOPY pa_projects_all.project_currency_code%TYPE --File.Sql.39 bug 4440895
35: ,x_projfunc_currency_code OUT NOCOPY pa_projects_all.projfunc_currency_code%TYPE --File.Sql.39 bug 4440895
36: ,x_project_id OUT NOCOPY pa_projects_all.project_id%TYPE --File.Sql.39 bug 4440895
37: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
38: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
39: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
40: IS

Line 197: FROM pa_projects_all p

193: INTO x_project_start_date
194: ,x_project_end_date
195: ,x_project_currency_code
196: ,x_projfunc_currency_code
197: FROM pa_projects_all p
198: WHERE p.project_id = x_project_id;
199:
200: END IF;
201:

Line 292: l_project_id PA_PROJECTS_ALL.project_id%TYPE;

288: l_msg_data VARCHAR2(2000);
289: l_msg_index_out NUMBER;
290: l_dummy_pd_name VARCHAR2(30);
291:
292: l_project_id PA_PROJECTS_ALL.project_id%TYPE;
293: l_budget_version_id PA_BUDGET_VERSIONS.budget_version_id%TYPE;
294: l_time_phased_code PA_PROJ_FP_OPTIONS.all_time_phased_code%TYPE;
295: l_project_start_date DATE;
296: l_project_end_date DATE;

Line 434: FROM pa_projects_all p

430: SELECT start_date
431: ,completion_date
432: INTO l_project_start_date
433: ,l_project_end_date
434: FROM pa_projects_all p
435: WHERE p.project_id = l_project_id;
436: EXCEPTION
437: WHEN OTHERS THEN
438: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 700: l_project_start_date pa_projects_all.start_date%TYPE;

696: l_period_profile_id pa_budget_versions.period_profile_id%TYPE;
697: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
698: l_fin_plan_version_id pa_proj_fp_options.fin_plan_version_id%TYPE;
699: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
700: l_project_start_date pa_projects_all.start_date%TYPE;
701: l_project_end_date pa_projects_all.start_date%TYPE;
702: l_task_start_date pa_projects_all.start_date%TYPE;
703: l_task_end_date pa_projects_all.start_date%TYPE;
704: l_plan_period_type pa_proj_period_profiles.plan_period_type%TYPE;

Line 701: l_project_end_date pa_projects_all.start_date%TYPE;

697: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
698: l_fin_plan_version_id pa_proj_fp_options.fin_plan_version_id%TYPE;
699: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
700: l_project_start_date pa_projects_all.start_date%TYPE;
701: l_project_end_date pa_projects_all.start_date%TYPE;
702: l_task_start_date pa_projects_all.start_date%TYPE;
703: l_task_end_date pa_projects_all.start_date%TYPE;
704: l_plan_period_type pa_proj_period_profiles.plan_period_type%TYPE;
705: l_period_set_name pa_proj_period_profiles.period_set_name%TYPE;

Line 702: l_task_start_date pa_projects_all.start_date%TYPE;

698: l_fin_plan_version_id pa_proj_fp_options.fin_plan_version_id%TYPE;
699: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
700: l_project_start_date pa_projects_all.start_date%TYPE;
701: l_project_end_date pa_projects_all.start_date%TYPE;
702: l_task_start_date pa_projects_all.start_date%TYPE;
703: l_task_end_date pa_projects_all.start_date%TYPE;
704: l_plan_period_type pa_proj_period_profiles.plan_period_type%TYPE;
705: l_period_set_name pa_proj_period_profiles.period_set_name%TYPE;
706: l_project_currency_code pa_projects_all.project_currency_code%TYPE;

Line 703: l_task_end_date pa_projects_all.start_date%TYPE;

699: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
700: l_project_start_date pa_projects_all.start_date%TYPE;
701: l_project_end_date pa_projects_all.start_date%TYPE;
702: l_task_start_date pa_projects_all.start_date%TYPE;
703: l_task_end_date pa_projects_all.start_date%TYPE;
704: l_plan_period_type pa_proj_period_profiles.plan_period_type%TYPE;
705: l_period_set_name pa_proj_period_profiles.period_set_name%TYPE;
706: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
707: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;

Line 706: l_project_currency_code pa_projects_all.project_currency_code%TYPE;

702: l_task_start_date pa_projects_all.start_date%TYPE;
703: l_task_end_date pa_projects_all.start_date%TYPE;
704: l_plan_period_type pa_proj_period_profiles.plan_period_type%TYPE;
705: l_period_set_name pa_proj_period_profiles.period_set_name%TYPE;
706: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
707: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
708: l_project_id pa_projects_all.project_id%TYPE;
709: l_dummy_period_name pa_periods_all.period_name%TYPE;
710:

Line 707: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;

703: l_task_end_date pa_projects_all.start_date%TYPE;
704: l_plan_period_type pa_proj_period_profiles.plan_period_type%TYPE;
705: l_period_set_name pa_proj_period_profiles.period_set_name%TYPE;
706: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
707: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
708: l_project_id pa_projects_all.project_id%TYPE;
709: l_dummy_period_name pa_periods_all.period_name%TYPE;
710:
711: l_msg_count NUMBER := 0;

Line 708: l_project_id pa_projects_all.project_id%TYPE;

704: l_plan_period_type pa_proj_period_profiles.plan_period_type%TYPE;
705: l_period_set_name pa_proj_period_profiles.period_set_name%TYPE;
706: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
707: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
708: l_project_id pa_projects_all.project_id%TYPE;
709: l_dummy_period_name pa_periods_all.period_name%TYPE;
710:
711: l_msg_count NUMBER := 0;
712: l_msg_data VARCHAR2(2000);

Line 2460: l_project_start_date pa_projects_all.start_date%TYPE ;

2456: l_period_profile_end_date pa_budget_lines.start_date%TYPE;
2457: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE ;
2458: l_fin_plan_version_id pa_proj_fp_options.fin_plan_version_id%TYPE ;
2459: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE ;
2460: l_project_start_date pa_projects_all.start_date%TYPE ;
2461: l_project_end_date pa_projects_all.start_date%TYPE;
2462: l_task_start_date pa_projects_all.start_date%TYPE;
2463: l_task_end_date pa_projects_all.start_date%TYPE;
2464: l_plan_period_type pa_proj_period_profiles.plan_period_type%TYPE;

Line 2461: l_project_end_date pa_projects_all.start_date%TYPE;

2457: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE ;
2458: l_fin_plan_version_id pa_proj_fp_options.fin_plan_version_id%TYPE ;
2459: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE ;
2460: l_project_start_date pa_projects_all.start_date%TYPE ;
2461: l_project_end_date pa_projects_all.start_date%TYPE;
2462: l_task_start_date pa_projects_all.start_date%TYPE;
2463: l_task_end_date pa_projects_all.start_date%TYPE;
2464: l_plan_period_type pa_proj_period_profiles.plan_period_type%TYPE;
2465: l_period_set_name pa_proj_period_profiles.period_set_name%TYPE;

Line 2462: l_task_start_date pa_projects_all.start_date%TYPE;

2458: l_fin_plan_version_id pa_proj_fp_options.fin_plan_version_id%TYPE ;
2459: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE ;
2460: l_project_start_date pa_projects_all.start_date%TYPE ;
2461: l_project_end_date pa_projects_all.start_date%TYPE;
2462: l_task_start_date pa_projects_all.start_date%TYPE;
2463: l_task_end_date pa_projects_all.start_date%TYPE;
2464: l_plan_period_type pa_proj_period_profiles.plan_period_type%TYPE;
2465: l_period_set_name pa_proj_period_profiles.period_set_name%TYPE;
2466: l_project_currency_code pa_projects_all.project_currency_code%TYPE;

Line 2463: l_task_end_date pa_projects_all.start_date%TYPE;

2459: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE ;
2460: l_project_start_date pa_projects_all.start_date%TYPE ;
2461: l_project_end_date pa_projects_all.start_date%TYPE;
2462: l_task_start_date pa_projects_all.start_date%TYPE;
2463: l_task_end_date pa_projects_all.start_date%TYPE;
2464: l_plan_period_type pa_proj_period_profiles.plan_period_type%TYPE;
2465: l_period_set_name pa_proj_period_profiles.period_set_name%TYPE;
2466: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
2467: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;

Line 2466: l_project_currency_code pa_projects_all.project_currency_code%TYPE;

2462: l_task_start_date pa_projects_all.start_date%TYPE;
2463: l_task_end_date pa_projects_all.start_date%TYPE;
2464: l_plan_period_type pa_proj_period_profiles.plan_period_type%TYPE;
2465: l_period_set_name pa_proj_period_profiles.period_set_name%TYPE;
2466: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
2467: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
2468: l_margin_derived_from_code pa_proj_fp_options.margin_derived_from_code%TYPE;
2469: l_dummy_project_id pa_projects_all.project_id%TYPE;
2470:

Line 2467: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;

2463: l_task_end_date pa_projects_all.start_date%TYPE;
2464: l_plan_period_type pa_proj_period_profiles.plan_period_type%TYPE;
2465: l_period_set_name pa_proj_period_profiles.period_set_name%TYPE;
2466: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
2467: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
2468: l_margin_derived_from_code pa_proj_fp_options.margin_derived_from_code%TYPE;
2469: l_dummy_project_id pa_projects_all.project_id%TYPE;
2470:
2471: BEGIN

Line 2469: l_dummy_project_id pa_projects_all.project_id%TYPE;

2465: l_period_set_name pa_proj_period_profiles.period_set_name%TYPE;
2466: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
2467: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
2468: l_margin_derived_from_code pa_proj_fp_options.margin_derived_from_code%TYPE;
2469: l_dummy_project_id pa_projects_all.project_id%TYPE;
2470:
2471: BEGIN
2472: -- Set the error stack.
2473: pa_debug.set_err_stack('PA_FP_EDIT_LINE_PKG.GET_ELEMENT_AMOUNT_INFO');

Line 2746: ( p_project_id IN pa_projects_all.PROJECT_ID%TYPE

2742:
2743: END GET_ELEMENT_AMOUNT_INFO;
2744:
2745: PROCEDURE CALL_CLIENT_EXTENSIONS
2746: ( p_project_id IN pa_projects_all.PROJECT_ID%TYPE
2747: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
2748: ,p_task_id IN pa_tasks.TASK_ID%TYPE
2749: ,p_resource_list_member_id IN pa_resource_list_members.RESOURCE_LIST_MEMBER_ID%TYPE
2750: ,p_resource_list_id IN pa_resource_lists.RESOURCE_LIST_ID%TYPE

Line 3513: ( p_project_id IN pa_projects_all.project_id%TYPE

3509: return PA_FP_EDIT_LINE_PKG.G_IS_FN_SECURITY_AVAILABLE;
3510: END get_is_fn_security_available;
3511:
3512: PROCEDURE CALL_CLIENT_EXTENSIONS
3513: ( p_project_id IN pa_projects_all.project_id%TYPE
3514: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
3515: ,p_task_id_tbl IN SYSTEM.pa_num_tbl_type
3516: ,p_res_list_member_id_tbl IN SYSTEM.pa_num_tbl_type
3517: ,p_resource_list_id IN pa_resource_lists.RESOURCE_LIST_ID%TYPE

Line 3912: l_segment1 pa_projects_all.segment1%TYPE;

3908:
3909: l_res_assignment_details_rec l_res_assignment_details_csr%ROWTYPE;
3910:
3911: l_resource_alias pa_resource_list_members.alias%TYPE;
3912: l_segment1 pa_projects_all.segment1%TYPE;
3913: l_task_number pa_tasks.task_number%TYPE;
3914: l_debug_level3 CONSTANT NUMBER := 3;
3915: l_debug_level5 CONSTANT NUMBER := 5;
3916: l_module_name VARCHAR2(100) := 'pa.plsql.PA_FP_EDIT_LINE_PKG Find_dup_rows_in_rollup_tmp ';

Line 3971: FROM pa_projects_all

3967: IF l_segment1 IS NULL THEN
3968:
3969: SELECT segment1
3970: INTO l_segment1
3971: FROM pa_projects_all
3972: WHERE project_id=l_res_assignment_details_rec.project_id;
3973:
3974: END IF;
3975: