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_PUB dependencies on PA_PERIODS

Line 5300: l_pa_start_period pa_periods_all.period_name%TYPE;

5296: l_res_list_control_flag VARCHAR2(1);
5297: l_gl_start_period gl_periods.period_name%TYPE;
5298: l_gl_end_period gl_periods.period_name%TYPE;
5299: l_gl_start_Date VARCHAR2(100);
5300: l_pa_start_period pa_periods_all.period_name%TYPE;
5301: l_pa_end_period pa_periods_all.period_name%TYPE;
5302: l_pa_start_date VARCHAR2(100);
5303: l_plan_version_exists_flag VARCHAR2(1);
5304: l_prj_start_date VARCHAR2(100);

Line 5301: l_pa_end_period pa_periods_all.period_name%TYPE;

5297: l_gl_start_period gl_periods.period_name%TYPE;
5298: l_gl_end_period gl_periods.period_name%TYPE;
5299: l_gl_start_Date VARCHAR2(100);
5300: l_pa_start_period pa_periods_all.period_name%TYPE;
5301: l_pa_end_period pa_periods_all.period_name%TYPE;
5302: l_pa_start_date VARCHAR2(100);
5303: l_plan_version_exists_flag VARCHAR2(1);
5304: l_prj_start_date VARCHAR2(100);
5305: l_prj_end_date VARCHAR2(100);

Line 6778: FROM PA_PERIODS

6774:
6775: BEGIN
6776: SELECT start_date
6777: INTO x_start_period_start_date
6778: FROM PA_PERIODS
6779: WHERE p_profile_start_date BETWEEN start_date AND end_date;
6780: EXCEPTION
6781: WHEN NO_DATA_FOUND THEN
6782: SELECT MIN(START_DATE)

Line 6784: FROM PA_PERIODS;

6780: EXCEPTION
6781: WHEN NO_DATA_FOUND THEN
6782: SELECT MIN(START_DATE)
6783: INTO x_start_period_start_date
6784: FROM PA_PERIODS;
6785: END;
6786:
6787: BEGIN
6788: SELECT end_date

Line 6790: FROM PA_PERIODS

6786:
6787: BEGIN
6788: SELECT end_date
6789: INTO x_end_period_end_date
6790: FROM PA_PERIODS
6791: WHERE p_profile_end_date BETWEEN start_date AND end_date;
6792: EXCEPTION
6793: WHEN NO_DATA_FOUND THEN
6794: SELECT MAX(end_date)

Line 6796: FROM PA_PERIODS;

6792: EXCEPTION
6793: WHEN NO_DATA_FOUND THEN
6794: SELECT MAX(end_date)
6795: INTO x_end_period_end_date
6796: FROM PA_PERIODS;
6797: END;
6798:
6799: ELSIF P_PERIOD_TYPE = PA_FP_CONSTANTS_PKG.G_PERIOD_TYPE_GL THEN
6800:

Line 6857: l_profile_start_date pa_periods.start_date%TYPE;

6853: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
6854: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
6855: ,x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
6856: AS
6857: l_profile_start_date pa_periods.start_date%TYPE;
6858: -- l_end_period_start_date pa_periods.end_date%TYPE;
6859:
6860: BEGIN
6861: /*

Line 6858: -- l_end_period_start_date pa_periods.end_date%TYPE;

6854: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
6855: ,x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
6856: AS
6857: l_profile_start_date pa_periods.start_date%TYPE;
6858: -- l_end_period_start_date pa_periods.end_date%TYPE;
6859:
6860: BEGIN
6861: /*
6862: pa_debug.g_err_stage := 'Entered get_profile_start_date';

Line 6881: FROM pa_periods a

6877: BEGIN
6878: --Select start date of period which is 51 periods before end period
6879: SELECT start_date
6880: INTO l_profile_start_date
6881: FROM pa_periods a
6882: WHERE 51= (SELECT COUNT(*) FROM pa_periods b
6883: WHERE a.start_date < b.start_date
6884: AND b.start_date <= p_profile_end_date );
6885: EXCEPTION

Line 6882: WHERE 51= (SELECT COUNT(*) FROM pa_periods b

6878: --Select start date of period which is 51 periods before end period
6879: SELECT start_date
6880: INTO l_profile_start_date
6881: FROM pa_periods a
6882: WHERE 51= (SELECT COUNT(*) FROM pa_periods b
6883: WHERE a.start_date < b.start_date
6884: AND b.start_date <= p_profile_end_date );
6885: EXCEPTION
6886: WHEN NO_DATA_FOUND THEN

Line 6896: FROM pa_periods;

6892: END IF;
6893: */
6894: SELECT MIN(start_date)
6895: INTO l_profile_start_date
6896: FROM pa_periods;
6897: END;
6898:
6899: ELSIF p_period_type = PA_FP_CONSTANTS_PKG.G_PERIOD_TYPE_GL THEN
6900:

Line 6972: l_profile_end_date pa_periods.end_date%TYPE;

6968: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
6969: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
6970: ,x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
6971: AS
6972: l_profile_end_date pa_periods.end_date%TYPE;
6973: BEGIN
6974: /*
6975: pa_debug.g_err_stage := 'Entered get_profile_end_date';
6976: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 7039: FROM pa_periods a

7035: END IF;
7036:
7037: SELECT end_date
7038: INTO l_profile_end_date
7039: FROM pa_periods a
7040: WHERE 51= (SELECT COUNT(*) FROM pa_periods b
7041: WHERE a.start_date > b.start_date
7042: AND b.start_date >= p_profile_start_date );
7043:

Line 7040: WHERE 51= (SELECT COUNT(*) FROM pa_periods b

7036:
7037: SELECT end_date
7038: INTO l_profile_end_date
7039: FROM pa_periods a
7040: WHERE 51= (SELECT COUNT(*) FROM pa_periods b
7041: WHERE a.start_date > b.start_date
7042: AND b.start_date >= p_profile_start_date );
7043:
7044: EXCEPTION

Line 7056: FROM pa_periods;

7052: END IF;
7053: */
7054: SELECT MAX(end_date)
7055: INTO l_profile_end_date
7056: FROM pa_periods;
7057: END;
7058: END IF;
7059:
7060: x_profile_end_date := l_profile_end_date;

Line 7263: FROM PA_PERIODS

7259: IF p_period_type = PA_FP_CONSTANTS_PKG.G_PERIOD_TYPE_PA THEN
7260:
7261: SELECT count(*)
7262: INTO l_number_of_periods
7263: FROM PA_PERIODS
7264: WHERE start_date BETWEEN TRUNC(SYSDATE) AND l_end_date; /*2690087*/
7265:
7266: ELSIF p_period_type = PA_FP_CONSTANTS_PKG.G_PERIOD_TYPE_GL THEN
7267:

Line 7332: FROM PA_PERIODS

7328: ELSIF p_period_type = PA_FP_CONSTANTS_PKG.G_PERIOD_TYPE_PA THEN
7329:
7330: SELECT start_date
7331: INTO l_profile_start_date
7332: FROM PA_PERIODS
7333: WHERE TRUNC(SYSDATE) BETWEEN start_date AND end_date; /* Bug:- 2690087 */
7334:
7335: END IF;
7336: