DBA Data[Home] [Help]

APPS.PA_FIN_PLAN_UTILS dependencies on PA_PERIODS_ALL

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

4563: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4564:
4565: END Get_Max_Budget_Version_Number;
4566:
4567: FUNCTION get_period_start_date (p_input_date IN pa_periods_all.start_date%TYPE,
4568: p_time_phased_code IN pa_proj_fp_options.cost_time_phased_Code%TYPE) RETURN DATE
4569: IS
4570: l_start_date pa_periods_all.start_date%TYPE;
4571: BEGIN

Line 4570: l_start_date pa_periods_all.start_date%TYPE;

4566:
4567: FUNCTION get_period_start_date (p_input_date IN pa_periods_all.start_date%TYPE,
4568: p_time_phased_code IN pa_proj_fp_options.cost_time_phased_Code%TYPE) RETURN DATE
4569: IS
4570: l_start_date pa_periods_all.start_date%TYPE;
4571: BEGIN
4572: IF P_PA_DEBUG_MODE = 'Y' THEN
4573: pa_debug.g_err_stage := 'Inside get_period_start_date and input date is '||p_input_date||' time phasing is : '||p_time_phased_code;
4574: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);

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

4598: WHEN NO_DATA_FOUND THEN
4599: return NULL;
4600: END;
4601:
4602: FUNCTION get_period_end_date (p_input_date IN pa_periods_all.end_date%TYPE,
4603: p_time_phased_code IN pa_proj_fp_options.cost_time_phased_Code%TYPE) RETURN DATE
4604: IS
4605: l_end_date pa_periods_all.end_date%TYPE;
4606: BEGIN

Line 4605: l_end_date pa_periods_all.end_date%TYPE;

4601:
4602: FUNCTION get_period_end_date (p_input_date IN pa_periods_all.end_date%TYPE,
4603: p_time_phased_code IN pa_proj_fp_options.cost_time_phased_Code%TYPE) RETURN DATE
4604: IS
4605: l_end_date pa_periods_all.end_date%TYPE;
4606: BEGIN
4607: IF P_PA_DEBUG_MODE = 'Y' THEN
4608: pa_debug.g_err_stage := 'Inside get_period_end_date and input date is '||p_input_date||' time phasing is : '||p_time_phased_code;
4609: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);

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

10228: PROCEDURE GET_ACTUAL_AMTS_THRU_PERIOD(
10229: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
10230: ,x_record_version_number OUT NOCOPY pa_budget_versions.record_version_number%TYPE --File.Sql.39 bug 4440895
10231: ,x_actual_amts_thru_period OUT NOCOPY pa_budget_versions.actual_amts_thru_period%TYPE --File.Sql.39 bug 4440895
10232: ,x_first_future_pa_period OUT NOCOPY pa_periods_all.period_name%TYPE --File.Sql.39 bug 4440895
10233: ,x_first_future_gl_period OUT NOCOPY pa_periods_all.period_name%TYPE --File.Sql.39 bug 4440895
10234: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
10235: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
10236: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

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

10229: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
10230: ,x_record_version_number OUT NOCOPY pa_budget_versions.record_version_number%TYPE --File.Sql.39 bug 4440895
10231: ,x_actual_amts_thru_period OUT NOCOPY pa_budget_versions.actual_amts_thru_period%TYPE --File.Sql.39 bug 4440895
10232: ,x_first_future_pa_period OUT NOCOPY pa_periods_all.period_name%TYPE --File.Sql.39 bug 4440895
10233: ,x_first_future_gl_period OUT NOCOPY pa_periods_all.period_name%TYPE --File.Sql.39 bug 4440895
10234: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
10235: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
10236: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
10237: AS