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

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

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

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

Line 5479: ( p_period_name IN pa_periods.period_name%TYPE

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

Line 5529: FROM pa_periods

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

Line 5625: p_period_name IN pa_periods.period_name%TYPE

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

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

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

Line 5644: l_start_date pa_periods.start_date%TYPE;

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

Line 5645: l_end_date pa_periods.end_date%TYPE;

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

Line 5699: FROM pa_periods a

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

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

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

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

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

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

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

Line 5715: FROM pa_periods a

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

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

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

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

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

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

Line 10260: CURSOR future_pa_periods_cur IS

10256: AND gl.adjustment_period_flag = 'N'
10257: AND closing_status = 'F'
10258: ORDER BY gl.start_date;
10259:
10260: CURSOR future_pa_periods_cur IS
10261: SELECT period_name
10262: FROM pa_periods
10263: WHERE status = 'F'
10264: ORDER BY start_date;

Line 10262: FROM pa_periods

10258: ORDER BY gl.start_date;
10259:
10260: CURSOR future_pa_periods_cur IS
10261: SELECT period_name
10262: FROM pa_periods
10263: WHERE status = 'F'
10264: ORDER BY start_date;
10265:
10266: BEGIN

Line 10321: OPEN future_pa_periods_cur;

10317: pa_debug.write('GET_ACTUAL_AMTS_THRU_PERIOD: ' || l_module_name,pa_debug.g_err_stage,3);
10318: END IF;
10319:
10320: -- Fetch the first period. There might not be any future period
10321: OPEN future_pa_periods_cur;
10322: FETCH future_pa_periods_cur INTO x_first_future_pa_period;
10323: CLOSE future_pa_periods_cur;
10324:
10325: -- Fetch first future GL period

Line 10322: FETCH future_pa_periods_cur INTO x_first_future_pa_period;

10318: END IF;
10319:
10320: -- Fetch the first period. There might not be any future period
10321: OPEN future_pa_periods_cur;
10322: FETCH future_pa_periods_cur INTO x_first_future_pa_period;
10323: CLOSE future_pa_periods_cur;
10324:
10325: -- Fetch first future GL period
10326: IF l_debug_mode = 'Y' THEN

Line 10323: CLOSE future_pa_periods_cur;

10319:
10320: -- Fetch the first period. There might not be any future period
10321: OPEN future_pa_periods_cur;
10322: FETCH future_pa_periods_cur INTO x_first_future_pa_period;
10323: CLOSE future_pa_periods_cur;
10324:
10325: -- Fetch first future GL period
10326: IF l_debug_mode = 'Y' THEN
10327: pa_debug.g_err_stage:='first future PA period = '|| x_first_future_pa_period;

Line 10334: OPEN future_pa_periods_cur;

10330: pa_debug.write('GET_ACTUAL_AMTS_THRU_PERIOD: ' || l_module_name,pa_debug.g_err_stage,3);
10331: END IF;
10332:
10333: -- Fetch first gl period, there might not be any gl period
10334: OPEN future_pa_periods_cur;
10335: FETCH future_pa_periods_cur INTO x_first_future_gl_period;
10336: CLOSE future_pa_periods_cur;
10337:
10338: IF l_debug_mode = 'Y' THEN

Line 10335: FETCH future_pa_periods_cur INTO x_first_future_gl_period;

10331: END IF;
10332:
10333: -- Fetch first gl period, there might not be any gl period
10334: OPEN future_pa_periods_cur;
10335: FETCH future_pa_periods_cur INTO x_first_future_gl_period;
10336: CLOSE future_pa_periods_cur;
10337:
10338: IF l_debug_mode = 'Y' THEN
10339: pa_debug.g_err_stage:='first future GL period = '||x_first_future_gl_period;

Line 10336: CLOSE future_pa_periods_cur;

10332:
10333: -- Fetch first gl period, there might not be any gl period
10334: OPEN future_pa_periods_cur;
10335: FETCH future_pa_periods_cur INTO x_first_future_gl_period;
10336: CLOSE future_pa_periods_cur;
10337:
10338: IF l_debug_mode = 'Y' THEN
10339: pa_debug.g_err_stage:='first future GL period = '||x_first_future_gl_period;
10340: pa_debug.write('GET_ACTUAL_AMTS_THRU_PERIOD: ' || l_module_name,pa_debug.g_err_stage,3);