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

Line 67: x_period_name PA_PERIODS_ALL.PERIOD_NAME%TYPE;

63: FUNCTION GET_ACTUALS_THRU_PERIOD_DTLS(P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
64: P_CONTEXT IN VARCHAR2)
65: RETURN VARCHAR2 IS
66:
67: x_period_name PA_PERIODS_ALL.PERIOD_NAME%TYPE;
68: l_end_date PA_PERIODS_ALL.END_DATE%TYPE;
69: l_end_date1 PA_PERIODS_ALL.END_DATE%TYPE;
70: l_end_date2 PA_PERIODS_ALL.END_DATE%TYPE;
71: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;

Line 68: l_end_date PA_PERIODS_ALL.END_DATE%TYPE;

64: P_CONTEXT IN VARCHAR2)
65: RETURN VARCHAR2 IS
66:
67: x_period_name PA_PERIODS_ALL.PERIOD_NAME%TYPE;
68: l_end_date PA_PERIODS_ALL.END_DATE%TYPE;
69: l_end_date1 PA_PERIODS_ALL.END_DATE%TYPE;
70: l_end_date2 PA_PERIODS_ALL.END_DATE%TYPE;
71: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
72: l_ret_status VARCHAR2(100);

Line 69: l_end_date1 PA_PERIODS_ALL.END_DATE%TYPE;

65: RETURN VARCHAR2 IS
66:
67: x_period_name PA_PERIODS_ALL.PERIOD_NAME%TYPE;
68: l_end_date PA_PERIODS_ALL.END_DATE%TYPE;
69: l_end_date1 PA_PERIODS_ALL.END_DATE%TYPE;
70: l_end_date2 PA_PERIODS_ALL.END_DATE%TYPE;
71: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
72: l_ret_status VARCHAR2(100);
73: l_msg_count NUMBER;

Line 70: l_end_date2 PA_PERIODS_ALL.END_DATE%TYPE;

66:
67: x_period_name PA_PERIODS_ALL.PERIOD_NAME%TYPE;
68: l_end_date PA_PERIODS_ALL.END_DATE%TYPE;
69: l_end_date1 PA_PERIODS_ALL.END_DATE%TYPE;
70: l_end_date2 PA_PERIODS_ALL.END_DATE%TYPE;
71: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
72: l_ret_status VARCHAR2(100);
73: l_msg_count NUMBER;
74: l_msg_data VARCHAR2(2000);

Line 114: FROM PA_PERIODS_ALL

110: l_fp_cols_rec.x_time_phased_code = 'P' THEN
111:
112: SELECT PERIOD_NAME, END_DATE
113: INTO x_period_name,l_end_date
114: FROM PA_PERIODS_ALL
115: WHERE ORG_ID = l_fp_cols_rec.x_org_id
116: AND STATUS = 'C'
117: AND END_DATE = (SELECT MAX(END_DATE)
118: FROM PA_PERIODS_ALL

Line 118: FROM PA_PERIODS_ALL

114: FROM PA_PERIODS_ALL
115: WHERE ORG_ID = l_fp_cols_rec.x_org_id
116: AND STATUS = 'C'
117: AND END_DATE = (SELECT MAX(END_DATE)
118: FROM PA_PERIODS_ALL
119: WHERE ORG_ID = l_fp_cols_rec.x_org_id
120: AND END_DATE < TRUNC(SYSDATE)
121: AND STATUS = 'C');
122:

Line 146: FROM pa_periods_all

142: l_fp_cols_rec.x_time_phased_code = 'P' THEN
143:
144: SELECT period_name, end_date
145: INTO x_period_name,l_end_date
146: FROM pa_periods_all
147: WHERE end_date =
148: (SELECT max(end_date)
149: FROM pa_periods_all
150: WHERE org_id = l_fp_cols_rec.x_org_id

Line 149: FROM pa_periods_all

145: INTO x_period_name,l_end_date
146: FROM pa_periods_all
147: WHERE end_date =
148: (SELECT max(end_date)
149: FROM pa_periods_all
150: WHERE org_id = l_fp_cols_rec.x_org_id
151: AND end_date <
152: (SELECT end_date
153: FROM pa_periods_all

Line 153: FROM pa_periods_all

149: FROM pa_periods_all
150: WHERE org_id = l_fp_cols_rec.x_org_id
151: AND end_date <
152: (SELECT end_date
153: FROM pa_periods_all
154: WHERE trunc(sysdate) between start_date and end_date
155: AND org_id = l_fp_cols_rec.x_org_id) )
156: AND org_id = l_fp_cols_rec.x_org_id;
157:

Line 189: FROM pa_periods_all

185: /* Get period_name based on the l_end_date calculated for CURRENT_PERIOD bug4034021 */
186: IF l_fp_cols_rec.x_time_phased_code = 'P' THEN
187: SELECT period_name, end_date
188: INTO x_period_name, l_end_date2
189: FROM pa_periods_all
190: WHERE org_id = l_fp_cols_rec.x_org_id
191: AND l_end_date between start_date and end_date;
192:
193: ELSIF ltrim(rtrim(l_fp_cols_rec.x_time_phased_code)) = 'G' THEN

Line 224: FROM pa_periods_all

220: AND SET_OF_BOOKS_ID = l_fp_cols_rec.x_set_of_books_id
221: AND ADJUSTMENT_PERIOD_FLAG = 'N';
222: ELSIF l_fp_cols_rec.x_time_phased_code = 'P' THEN
223: SELECT end_date into l_end_date1
224: FROM pa_periods_all
225: WHERE l_end_date between start_date and end_date
226: AND org_id = l_fp_cols_rec.x_org_id;
227: END IF;
228: IF p_pa_debug_mode = 'Y' THEN

Line 251: FROM pa_periods_all

247: BEGIN
248: IF l_fp_cols_rec.x_time_phased_code = 'P' THEN
249: SELECT end_date
250: INTO l_end_date
251: FROM pa_periods_all
252: WHERE org_id = l_fp_cols_rec.x_org_id
253: AND trunc(sysdate) between start_date and end_date;
254: ELSIF l_fp_cols_rec.x_time_phased_code = 'G' THEN
255: SELECT end_date

Line 299: l_period_name PA_PERIODS_ALL.PERIOD_NAME%TYPE;

295: l_msg_count NUMBER;
296: l_msg_data VARCHAR2(2000);
297: l_data VARCHAR2(2000);
298:
299: l_period_name PA_PERIODS_ALL.PERIOD_NAME%TYPE;
300:
301: BEGIN
302: IF p_pa_debug_mode = 'Y' THEN
303: pa_debug.set_curr_function( p_function => 'GET_ACT_FRM_PERIOD',

Line 336: FROM pa_periods_all p, pa_projects_all proj

332: IF l_fp_cols_rec.x_time_phased_code = 'P' THEN
333:
334: SELECT p.period_name
335: INTO l_period_name
336: FROM pa_periods_all p, pa_projects_all proj
337: WHERE p.org_id = l_fp_cols_rec.x_org_id
338: AND proj.project_id = l_fp_cols_rec.x_project_id
339: AND proj.start_date between p.start_date and p.end_date;
340:

Line 390: l_act_to_period_name PA_PERIODS_ALL.PERIOD_NAME%TYPE;

386: l_msg_data VARCHAR2(2000);
387: l_data VARCHAR2(2000);
388:
389: l_act_to_period_date DATE;
390: l_act_to_period_name PA_PERIODS_ALL.PERIOD_NAME%TYPE;
391: l_act_from_period_name varchar2(1000); -- bug 6142328 added for comparing act_from_period with act_to_period
392:
393: BEGIN
394: IF p_pa_debug_mode = 'Y' THEN

Line 433: FROM pa_periods_all

429: IF l_fp_cols_rec.x_time_phased_code = 'P' THEN
430: BEGIN
431: SELECT period_name
432: INTO l_act_to_period_name
433: FROM pa_periods_all
434: WHERE org_id = l_fp_cols_rec.x_org_id
435: AND l_act_to_period_date BETWEEN start_date AND end_date
436: AND start_date >= (SELECT start_date -- bug6142328 added one more select query for comparing the start date of act_to_period with act_from_period
437: FROM pa_periods_all

Line 437: FROM pa_periods_all

433: FROM pa_periods_all
434: WHERE org_id = l_fp_cols_rec.x_org_id
435: AND l_act_to_period_date BETWEEN start_date AND end_date
436: AND start_date >= (SELECT start_date -- bug6142328 added one more select query for comparing the start date of act_to_period with act_from_period
437: FROM pa_periods_all
438: WHERE period_name = l_act_from_period_name
439: AND org_id = l_fp_cols_rec.x_org_id);
440: EXCEPTION
441: WHEN NO_DATA_FOUND THEN

Line 508: l_etc_from_period_name PA_PERIODS_ALL.PERIOD_NAME%TYPE;

504: l_data VARCHAR2(2000);
505: l_msg_index_out NUMBER:=0;
506:
507: l_etc_from_period_date DATE;
508: l_etc_from_period_name PA_PERIODS_ALL.PERIOD_NAME%TYPE;
509:
510: BEGIN
511: IF p_pa_debug_mode = 'Y' THEN
512: pa_debug.set_curr_function( p_function => 'GET_ETC_FRM_PERIOD',

Line 549: FROM pa_periods_all

545: IF l_fp_cols_rec.x_time_phased_code = 'P' THEN
546:
547: SELECT period_name
548: INTO l_etc_from_period_name
549: FROM pa_periods_all
550: WHERE org_id = l_fp_cols_rec.x_org_id
551: AND l_etc_from_period_date between start_date and end_date;
552:
553: IF p_pa_debug_mode = 'Y' THEN

Line 626: l_etc_to_period PA_PERIODS_ALL.PERIOD_NAME%TYPE;

622: l_msg_count NUMBER;
623: l_msg_data VARCHAR2(2000);
624: l_data VARCHAR2(2000);
625: l_proj_comp_date DATE;
626: l_etc_to_period PA_PERIODS_ALL.PERIOD_NAME%TYPE;
627: l_actual_thru_date DATE;
628:
629: BEGIN
630: IF p_pa_debug_mode = 'Y' THEN

Line 667: FROM pa_periods_all p, pa_projects_all proj

663: IF l_fp_cols_rec.x_time_phased_code = 'P' THEN
664:
665: SELECT p.period_name, NVL(proj.completion_date, trunc(SYSDATE))
666: INTO l_etc_to_period, l_proj_comp_date
667: FROM pa_periods_all p, pa_projects_all proj
668: WHERE NVL(proj.completion_date, trunc(SYSDATE)) between p.start_date and p.end_date
669: AND p.org_id = l_fp_cols_rec.x_org_id
670: AND proj.project_id = l_fp_cols_rec.x_project_id;
671:

Line 724: x_period_name PA_PERIODS_ALL.PERIOD_NAME%TYPE;

720:
721: FUNCTION GET_UNSPENT_AMT_PERIOD(P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE)
722: RETURN VARCHAR2 IS
723: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_pg_pkg.GET_UNSPENT_AMT_PERIOD';
724: x_period_name PA_PERIODS_ALL.PERIOD_NAME%TYPE;
725: BEGIN
726: x_period_name := GET_ETC_FRM_PERIOD(P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID);
727: RETURN x_period_name;
728: END;

Line 1019: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,

1015: P_ACTUALS_TO_PERIOD IN VARCHAR2,
1016: P_ETC_FROM_PERIOD IN VARCHAR2,
1017: P_ETC_TO_PERIOD IN VARCHAR2,
1018: P_ACTUALS_THRU_PERIOD IN PA_BUDGET_VERSIONS.ACTUAL_AMTS_THRU_PERIOD%TYPE,
1019: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
1020: P_WP_STRUCTURE_VERSION_ID IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
1021: P_CHECK_SRC_ERRORS_FLAG IN VARCHAR2,
1022: X_WARNING_MESSAGE OUT NOCOPY VARCHAR2,
1023: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 2093: (P_PERIOD_NAME IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,

2089: END VALIDATE_PERIODS;
2090:
2091:
2092: PROCEDURE VALIDATE_PA_GL_PERIODS
2093: (P_PERIOD_NAME IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
2094: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
2095: P_CONTEXT IN VARCHAR2,
2096: P_ERROR_MSG_CODE IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE,
2097: X_END_DATE OUT NOCOPY DATE,

Line 2123: FROM PA_PERIODS_ALL

2119:
2120: IF P_FP_COLS_REC.X_TIME_PHASED_CODE = 'P' THEN
2121: SELECT END_DATE
2122: INTO X_END_DATE
2123: FROM PA_PERIODS_ALL
2124: WHERE ORG_ID = p_fp_cols_rec.x_org_id
2125: AND PERIOD_NAME = p_period_name;
2126: --dbms_output.put_line('End date from validate_pa_gl_periods(P) api:'||X_END_DATE);
2127: