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_FIN_PLAN_UTILS dependencies on PA_PERIODS_ALL

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

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

Line 4572: l_start_date pa_periods_all.start_date%TYPE;

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

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

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

Line 4607: l_end_date pa_periods_all.end_date%TYPE;

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

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

10234: PROCEDURE GET_ACTUAL_AMTS_THRU_PERIOD(
10235: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
10236: ,x_record_version_number OUT NOCOPY pa_budget_versions.record_version_number%TYPE --File.Sql.39 bug 4440895
10237: ,x_actual_amts_thru_period OUT NOCOPY pa_budget_versions.actual_amts_thru_period%TYPE --File.Sql.39 bug 4440895
10238: ,x_first_future_pa_period OUT NOCOPY pa_periods_all.period_name%TYPE --File.Sql.39 bug 4440895
10239: ,x_first_future_gl_period OUT NOCOPY pa_periods_all.period_name%TYPE --File.Sql.39 bug 4440895
10240: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
10241: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
10242: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

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

10235: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
10236: ,x_record_version_number OUT NOCOPY pa_budget_versions.record_version_number%TYPE --File.Sql.39 bug 4440895
10237: ,x_actual_amts_thru_period OUT NOCOPY pa_budget_versions.actual_amts_thru_period%TYPE --File.Sql.39 bug 4440895
10238: ,x_first_future_pa_period OUT NOCOPY pa_periods_all.period_name%TYPE --File.Sql.39 bug 4440895
10239: ,x_first_future_gl_period OUT NOCOPY pa_periods_all.period_name%TYPE --File.Sql.39 bug 4440895
10240: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
10241: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
10242: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
10243: AS