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

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 4582: FROM pa_periods

4578: IF p_time_phased_code = PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_P THEN
4579: IF p_input_date IS NOT NULL THEN
4580: SELECT start_date
4581: INTO l_start_date
4582: FROM pa_periods
4583: WHERE p_input_date between start_date and end_date;
4584: END IF;
4585: ELSIF p_time_phased_code = PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_G THEN
4586: IF p_input_date IS NOT NULL THEN

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 4617: FROM pa_periods

4613: IF p_time_phased_code = PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_P THEN
4614: IF p_input_date IS NOT NULL THEN
4615: SELECT end_date
4616: INTO l_end_date
4617: FROM pa_periods
4618: WHERE p_input_date between start_date and end_date;
4619: END IF;
4620:
4621: ELSIF p_time_phased_code = PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_G THEN

Line 5481: ( p_period_name IN pa_periods.period_name%TYPE

5477: If the period is not found the api raises error.
5478: ==================================================================*/
5479:
5480: PROCEDURE Get_Period_Details
5481: ( p_period_name IN pa_periods.period_name%TYPE
5482: /* Changes for FPM. Tracking Bug - 3354518
5483: Modifying the datatype of parameter p_plan_period_type below to varchar2 */
5484: /* ,p_plan_period_type IN pa_proj_period_profiles.plan_period_type%TYPE */
5485: ,p_plan_period_type IN VARCHAR2

Line 5531: FROM pa_periods

5527: SELECT start_date
5528: ,end_date
5529: INTO x_start_date
5530: ,x_end_date
5531: FROM pa_periods
5532: WHERE period_name = p_period_name;
5533: EXCEPTION
5534: WHEN OTHERS THEN
5535: IF p_pa_debug_mode = 'Y' THEN

Line 5627: p_period_name IN pa_periods.period_name%TYPE

5623: Modifying the datatype of parameter p_plan_period_type below to varchar2
5624: and x_shifted_period_start_date and x_shifted_period_end_date as date*/
5625:
5626: PROCEDURE Get_Shifted_Period (
5627: p_period_name IN pa_periods.period_name%TYPE
5628: /* ,p_plan_period_type IN pa_proj_period_profiles.plan_period_type%TYPE */
5629: ,p_plan_period_type IN VARCHAR2
5630: ,p_number_of_periods IN NUMBER
5631: ,x_shifted_period OUT NOCOPY pa_periods.period_name%TYPE --File.Sql.39 bug 4440895

Line 5631: ,x_shifted_period OUT NOCOPY pa_periods.period_name%TYPE --File.Sql.39 bug 4440895

5627: p_period_name IN pa_periods.period_name%TYPE
5628: /* ,p_plan_period_type IN pa_proj_period_profiles.plan_period_type%TYPE */
5629: ,p_plan_period_type IN VARCHAR2
5630: ,p_number_of_periods IN NUMBER
5631: ,x_shifted_period OUT NOCOPY pa_periods.period_name%TYPE --File.Sql.39 bug 4440895
5632: /* ,x_shifted_period_start_date OUT pa_proj_period_profiles.period1_start_date%TYPE
5633: ,x_shifted_period_end_date OUT pa_proj_period_profiles.period1_end_date%TYPE */
5634: ,x_shifted_period_start_date OUT NOCOPY DATE --File.Sql.39 bug 4440895
5635: ,x_shifted_period_end_date OUT NOCOPY DATE --File.Sql.39 bug 4440895

Line 5646: l_start_date pa_periods.start_date%TYPE;

5642: l_msg_data VARCHAR2(2000);
5643: l_msg_index_out NUMBER;
5644: l_return_status VARCHAR2(2000);
5645:
5646: l_start_date pa_periods.start_date%TYPE;
5647: l_end_date pa_periods.end_date%TYPE;
5648:
5649: BEGIN
5650: x_msg_count := 0;

Line 5647: l_end_date pa_periods.end_date%TYPE;

5643: l_msg_index_out NUMBER;
5644: l_return_status VARCHAR2(2000);
5645:
5646: l_start_date pa_periods.start_date%TYPE;
5647: l_end_date pa_periods.end_date%TYPE;
5648:
5649: BEGIN
5650: x_msg_count := 0;
5651: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5701: FROM pa_periods a

5697: ,end_date
5698: INTO x_shifted_period
5699: ,x_shifted_period_start_date
5700: ,x_shifted_period_end_date
5701: FROM pa_periods a
5702: WHERE p_number_of_periods = (SELECT COUNT(*) FROM pa_periods b
5703: WHERE b.start_date < a.start_date
5704: AND b.start_date >= l_start_date )
5705: /* bug fix:5090115: added this to avoid FTS on pa_periods */

Line 5702: WHERE p_number_of_periods = (SELECT COUNT(*) FROM pa_periods b

5698: INTO x_shifted_period
5699: ,x_shifted_period_start_date
5700: ,x_shifted_period_end_date
5701: FROM pa_periods a
5702: WHERE p_number_of_periods = (SELECT COUNT(*) FROM pa_periods b
5703: WHERE b.start_date < a.start_date
5704: AND b.start_date >= l_start_date )
5705: /* bug fix:5090115: added this to avoid FTS on pa_periods */
5706: AND a.start_date >= l_start_date ;

Line 5705: /* bug fix:5090115: added this to avoid FTS on pa_periods */

5701: FROM pa_periods a
5702: WHERE p_number_of_periods = (SELECT COUNT(*) FROM pa_periods b
5703: WHERE b.start_date < a.start_date
5704: AND b.start_date >= l_start_date )
5705: /* bug fix:5090115: added this to avoid FTS on pa_periods */
5706: AND a.start_date >= l_start_date ;
5707:
5708: ELSIF p_number_of_periods < 0 THEN
5709:

Line 5710: SELECT /+ index(a pa_periods_u2) /

5706: AND a.start_date >= l_start_date ;
5707:
5708: ELSIF p_number_of_periods < 0 THEN
5709:
5710: SELECT /*+ index(a pa_periods_u2) */
5711: period_name
5712: ,start_date
5713: ,end_date
5714: INTO x_shifted_period

Line 5717: FROM pa_periods a

5713: ,end_date
5714: INTO x_shifted_period
5715: ,x_shifted_period_start_date
5716: ,x_shifted_period_end_date
5717: FROM pa_periods a
5718: WHERE ABS(p_number_of_periods) = (SELECT COUNT(*) FROM pa_periods b
5719: WHERE b.start_date > a.start_date
5720: AND b.start_date <= l_start_date )
5721: /* bug fix:5090115: added this to avoid FTS on pa_periods */

Line 5718: WHERE ABS(p_number_of_periods) = (SELECT COUNT(*) FROM pa_periods b

5714: INTO x_shifted_period
5715: ,x_shifted_period_start_date
5716: ,x_shifted_period_end_date
5717: FROM pa_periods a
5718: WHERE ABS(p_number_of_periods) = (SELECT COUNT(*) FROM pa_periods b
5719: WHERE b.start_date > a.start_date
5720: AND b.start_date <= l_start_date )
5721: /* bug fix:5090115: added this to avoid FTS on pa_periods */
5722: AND a.start_date <= l_start_date ;

Line 5721: /* bug fix:5090115: added this to avoid FTS on pa_periods */

5717: FROM pa_periods a
5718: WHERE ABS(p_number_of_periods) = (SELECT COUNT(*) FROM pa_periods b
5719: WHERE b.start_date > a.start_date
5720: AND b.start_date <= l_start_date )
5721: /* bug fix:5090115: added this to avoid FTS on pa_periods */
5722: AND a.start_date <= l_start_date ;
5723:
5724: ELSIF p_number_of_periods = 0 THEN
5725:

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

Line 10266: CURSOR future_pa_periods_cur IS

10262: AND gl.adjustment_period_flag = 'N'
10263: AND closing_status = 'F'
10264: ORDER BY gl.start_date;
10265:
10266: CURSOR future_pa_periods_cur IS
10267: SELECT period_name
10268: FROM pa_periods
10269: WHERE status = 'F'
10270: ORDER BY start_date;

Line 10268: FROM pa_periods

10264: ORDER BY gl.start_date;
10265:
10266: CURSOR future_pa_periods_cur IS
10267: SELECT period_name
10268: FROM pa_periods
10269: WHERE status = 'F'
10270: ORDER BY start_date;
10271:
10272: BEGIN

Line 10327: OPEN future_pa_periods_cur;

10323: pa_debug.write('GET_ACTUAL_AMTS_THRU_PERIOD: ' || l_module_name,pa_debug.g_err_stage,3);
10324: END IF;
10325:
10326: -- Fetch the first period. There might not be any future period
10327: OPEN future_pa_periods_cur;
10328: FETCH future_pa_periods_cur INTO x_first_future_pa_period;
10329: CLOSE future_pa_periods_cur;
10330:
10331: -- Fetch first future GL period

Line 10328: FETCH future_pa_periods_cur INTO x_first_future_pa_period;

10324: END IF;
10325:
10326: -- Fetch the first period. There might not be any future period
10327: OPEN future_pa_periods_cur;
10328: FETCH future_pa_periods_cur INTO x_first_future_pa_period;
10329: CLOSE future_pa_periods_cur;
10330:
10331: -- Fetch first future GL period
10332: IF l_debug_mode = 'Y' THEN

Line 10329: CLOSE future_pa_periods_cur;

10325:
10326: -- Fetch the first period. There might not be any future period
10327: OPEN future_pa_periods_cur;
10328: FETCH future_pa_periods_cur INTO x_first_future_pa_period;
10329: CLOSE future_pa_periods_cur;
10330:
10331: -- Fetch first future GL period
10332: IF l_debug_mode = 'Y' THEN
10333: pa_debug.g_err_stage:='first future PA period = '|| x_first_future_pa_period;

Line 10340: OPEN future_pa_periods_cur;

10336: pa_debug.write('GET_ACTUAL_AMTS_THRU_PERIOD: ' || l_module_name,pa_debug.g_err_stage,3);
10337: END IF;
10338:
10339: -- Fetch first gl period, there might not be any gl period
10340: OPEN future_pa_periods_cur;
10341: FETCH future_pa_periods_cur INTO x_first_future_gl_period;
10342: CLOSE future_pa_periods_cur;
10343:
10344: IF l_debug_mode = 'Y' THEN

Line 10341: FETCH future_pa_periods_cur INTO x_first_future_gl_period;

10337: END IF;
10338:
10339: -- Fetch first gl period, there might not be any gl period
10340: OPEN future_pa_periods_cur;
10341: FETCH future_pa_periods_cur INTO x_first_future_gl_period;
10342: CLOSE future_pa_periods_cur;
10343:
10344: IF l_debug_mode = 'Y' THEN
10345: pa_debug.g_err_stage:='first future GL period = '||x_first_future_gl_period;

Line 10342: CLOSE future_pa_periods_cur;

10338:
10339: -- Fetch first gl period, there might not be any gl period
10340: OPEN future_pa_periods_cur;
10341: FETCH future_pa_periods_cur INTO x_first_future_gl_period;
10342: CLOSE future_pa_periods_cur;
10343:
10344: IF l_debug_mode = 'Y' THEN
10345: pa_debug.g_err_stage:='first future GL period = '||x_first_future_gl_period;
10346: pa_debug.write('GET_ACTUAL_AMTS_THRU_PERIOD: ' || l_module_name,pa_debug.g_err_stage,3);