DBA Data[Home] [Help]

APPS.PA_FP_EDIT_LINE_PKG dependencies on PA_PROJ_PERIOD_PROFILES

Line 32: ,x_plan_period_type OUT NOCOPY pa_proj_period_profiles.plan_period_type%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
36: ,x_project_id OUT NOCOPY pa_projects_all.project_id%TYPE --File.Sql.39 bug 4440895

Line 33: ,x_period_set_name OUT NOCOPY pa_proj_period_profiles.period_set_name%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
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

Line 42: l_period_profile_type pa_proj_period_profiles.period_profile_type%type;

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
41:
42: l_period_profile_type pa_proj_period_profiles.period_profile_type%type;
43: l_gl_period_type pa_proj_period_profiles.gl_period_type%TYPE;
44: l_number_of_periods pa_proj_period_profiles.number_of_periods%TYPE;
45:
46: l_task_id pa_tasks.task_id%TYPE;

Line 43: l_gl_period_type pa_proj_period_profiles.gl_period_type%TYPE;

39: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
40: IS
41:
42: l_period_profile_type pa_proj_period_profiles.period_profile_type%type;
43: l_gl_period_type pa_proj_period_profiles.gl_period_type%TYPE;
44: l_number_of_periods pa_proj_period_profiles.number_of_periods%TYPE;
45:
46: l_task_id pa_tasks.task_id%TYPE;
47:

Line 44: l_number_of_periods pa_proj_period_profiles.number_of_periods%TYPE;

40: IS
41:
42: l_period_profile_type pa_proj_period_profiles.period_profile_type%type;
43: l_gl_period_type pa_proj_period_profiles.gl_period_type%TYPE;
44: l_number_of_periods pa_proj_period_profiles.number_of_periods%TYPE;
45:
46: l_task_id pa_tasks.task_id%TYPE;
47:
48: l_dummy_pd_name pa_budget_lines.period_name%TYPE; /* webadi */

Line 273: ,p_plan_period_type IN pa_proj_period_profiles.plan_period_type%TYPE

269: PROCEDURE DERIVE_PD_SD_START_END_DATES
270: (p_calling_context IN VARCHAR2
271: ,p_pp_st_dt IN pa_budget_lines.start_date%TYPE
272: ,p_pp_end_dt IN pa_budget_lines.start_date%TYPE
273: ,p_plan_period_type IN pa_proj_period_profiles.plan_period_type%TYPE
274: ,p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE
275: ,p_transaction_currency_code IN pa_budget_lines.txn_currency_code%TYPE
276: ,x_pd_st_dt OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895
277: ,x_pd_end_dt OUT NOCOPY pa_budget_lines.start_date%TYPE --File.Sql.39 bug 4440895

Line 704: l_plan_period_type pa_proj_period_profiles.plan_period_type%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;
708: l_project_id pa_projects_all.project_id%TYPE;

Line 705: l_period_set_name pa_proj_period_profiles.period_set_name%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;
708: l_project_id pa_projects_all.project_id%TYPE;
709: l_dummy_period_name pa_periods_all.period_name%TYPE;

Line 2404: ,x_plan_period_type OUT NOCOPY pa_proj_period_profiles.PLAN_PERIOD_TYPE%TYPE --File.Sql.39 bug 4440895

2400: ,x_cost_rate_flag OUT NOCOPY pa_fin_plan_amount_sets.cost_rate_flag%TYPE --File.Sql.39 bug 4440895
2401: ,x_burden_multiplier_flag OUT NOCOPY pa_fin_plan_amount_sets.burden_rate_flag%TYPE --File.Sql.39 bug 4440895
2402: /* Changes for FP.M, Tracking Bug No - 3354518. End here*/
2403: ,x_period_profile_id OUT NOCOPY pa_proj_periods_denorm.PERIOD_PROFILE_ID%TYPE --File.Sql.39 bug 4440895
2404: ,x_plan_period_type OUT NOCOPY pa_proj_period_profiles.PLAN_PERIOD_TYPE%TYPE --File.Sql.39 bug 4440895
2405: ,x_quantity OUT NOCOPY pa_budget_lines.QUANTITY%TYPE --File.Sql.39 bug 4440895
2406: ,x_project_raw_cost OUT NOCOPY pa_budget_lines.RAW_COST%TYPE --File.Sql.39 bug 4440895
2407: ,x_project_burdened_cost OUT NOCOPY pa_budget_lines.BURDENED_COST%TYPE --File.Sql.39 bug 4440895
2408: ,x_project_revenue OUT NOCOPY pa_budget_lines.REVENUE%TYPE --File.Sql.39 bug 4440895

Line 2464: l_plan_period_type pa_proj_period_profiles.plan_period_type%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;
2468: l_margin_derived_from_code pa_proj_fp_options.margin_derived_from_code%TYPE;

Line 2465: l_period_set_name pa_proj_period_profiles.period_set_name%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;
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;