DBA Data[Home] [Help]

APPS.PA_FIN_PLAN_UTILS dependencies on PA_PERIODS_ALL

Line 436: FUNCTION get_period_start_date (p_input_date IN pa_periods_all.start_date%TYPE,

432: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
433: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
434: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
435:
436: FUNCTION get_period_start_date (p_input_date IN pa_periods_all.start_date%TYPE,
437: p_time_phased_code IN pa_proj_fp_options.cost_time_phased_Code%TYPE) RETURN DATE;
438:
439: FUNCTION get_period_end_date (p_input_date IN pa_periods_all.end_date%TYPE,
440: p_time_phased_code IN pa_proj_fp_options.cost_time_phased_Code%TYPE) RETURN DATE;

Line 439: FUNCTION get_period_end_date (p_input_date IN pa_periods_all.end_date%TYPE,

435:
436: FUNCTION get_period_start_date (p_input_date IN pa_periods_all.start_date%TYPE,
437: p_time_phased_code IN pa_proj_fp_options.cost_time_phased_Code%TYPE) RETURN DATE;
438:
439: FUNCTION get_period_end_date (p_input_date IN pa_periods_all.end_date%TYPE,
440: p_time_phased_code IN pa_proj_fp_options.cost_time_phased_Code%TYPE) RETURN DATE;
441: /*==============================================================================
442: This api returns the current baselined version for a given project and
443: budget_type_code or fin_plan_type combination.

Line 807: ,x_first_future_pa_period OUT NOCOPY pa_periods_all.period_name%TYPE --File.Sql.39 bug 4440895

803: PROCEDURE GET_ACTUAL_AMTS_THRU_PERIOD(
804: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
805: ,x_record_version_number OUT NOCOPY pa_budget_versions.record_version_number%TYPE --File.Sql.39 bug 4440895
806: ,x_actual_amts_thru_period OUT NOCOPY pa_budget_versions.actual_amts_thru_period%TYPE --File.Sql.39 bug 4440895
807: ,x_first_future_pa_period OUT NOCOPY pa_periods_all.period_name%TYPE --File.Sql.39 bug 4440895
808: ,x_first_future_gl_period OUT NOCOPY pa_periods_all.period_name%TYPE --File.Sql.39 bug 4440895
809: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
810: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
811: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 808: ,x_first_future_gl_period OUT NOCOPY pa_periods_all.period_name%TYPE --File.Sql.39 bug 4440895

804: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
805: ,x_record_version_number OUT NOCOPY pa_budget_versions.record_version_number%TYPE --File.Sql.39 bug 4440895
806: ,x_actual_amts_thru_period OUT NOCOPY pa_budget_versions.actual_amts_thru_period%TYPE --File.Sql.39 bug 4440895
807: ,x_first_future_pa_period OUT NOCOPY pa_periods_all.period_name%TYPE --File.Sql.39 bug 4440895
808: ,x_first_future_gl_period OUT NOCOPY pa_periods_all.period_name%TYPE --File.Sql.39 bug 4440895
809: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
810: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
811: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
812: