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_PERIOD_PROCESS_PKG

Line 129: WHERE APPLICATION_ID = PA_PERIOD_PROCESS_PKG.Application_id

125:
126: SELECT PERIOD_NAME, END_DATE
127: INTO x_period_name,l_end_date
128: FROM GL_PERIOD_STATUSES
129: WHERE APPLICATION_ID = PA_PERIOD_PROCESS_PKG.Application_id
130: AND SET_OF_BOOKS_ID = l_fp_cols_rec.x_set_of_books_id
131: AND ADJUSTMENT_PERIOD_FLAG = 'N'
132: AND CLOSING_STATUS = 'C'
133: AND END_DATE = (SELECT MAX(END_DATE)

Line 135: WHERE APPLICATION_ID = PA_PERIOD_PROCESS_PKG.Application_id

131: AND ADJUSTMENT_PERIOD_FLAG = 'N'
132: AND CLOSING_STATUS = 'C'
133: AND END_DATE = (SELECT MAX(END_DATE)
134: FROM GL_PERIOD_STATUSES
135: WHERE APPLICATION_ID = PA_PERIOD_PROCESS_PKG.Application_id
136: AND SET_OF_BOOKS_ID = l_fp_cols_rec.x_set_of_books_id
137: AND ADJUSTMENT_PERIOD_FLAG = 'N'
138: AND END_DATE < TRUNC(SYSDATE)
139: AND CLOSING_STATUS = 'C');

Line 167: WHERE application_id = PA_PERIOD_PROCESS_PKG.Application_id

163: FROM gl_period_statuses
164: WHERE end_date =
165: (SELECT max(end_date)
166: FROM gl_period_statuses
167: WHERE application_id = PA_PERIOD_PROCESS_PKG.Application_id
168: AND set_of_books_id = l_fp_cols_rec.x_set_of_books_id
169: AND adjustment_period_flag = 'N'
170: AND end_date <
171: (SELECT end_date

Line 174: AND APPLICATION_ID = PA_PERIOD_PROCESS_PKG.Application_id

170: AND end_date <
171: (SELECT end_date
172: FROM gl_period_statuses
173: WHERE trunc(sysdate) between start_date and end_date
174: AND APPLICATION_ID = PA_PERIOD_PROCESS_PKG.Application_id
175: AND SET_OF_BOOKS_ID = l_fp_cols_rec.x_set_of_books_id
176: AND ADJUSTMENT_PERIOD_FLAG = 'N'))
177: AND APPLICATION_ID = PA_PERIOD_PROCESS_PKG.Application_id
178: AND SET_OF_BOOKS_ID = l_fp_cols_rec.x_set_of_books_id

Line 177: AND APPLICATION_ID = PA_PERIOD_PROCESS_PKG.Application_id

173: WHERE trunc(sysdate) between start_date and end_date
174: AND APPLICATION_ID = PA_PERIOD_PROCESS_PKG.Application_id
175: AND SET_OF_BOOKS_ID = l_fp_cols_rec.x_set_of_books_id
176: AND ADJUSTMENT_PERIOD_FLAG = 'N'))
177: AND APPLICATION_ID = PA_PERIOD_PROCESS_PKG.Application_id
178: AND SET_OF_BOOKS_ID = l_fp_cols_rec.x_set_of_books_id
179: AND ADJUSTMENT_PERIOD_FLAG = 'N';
180: /* CURRENT_PERIOD - last summarization run date */
181: ELSIF l_fp_cols_rec.x_gen_actual_amts_thru_code = 'CURRENT_PERIOD' THEN

Line 197: WHERE APPLICATION_ID = PA_PERIOD_PROCESS_PKG.Application_id

193: ELSIF ltrim(rtrim(l_fp_cols_rec.x_time_phased_code)) = 'G' THEN
194: SELECT period_name, end_date
195: INTO x_period_name, l_end_date2
196: FROM gl_period_statuses
197: WHERE APPLICATION_ID = PA_PERIOD_PROCESS_PKG.Application_id
198: AND set_of_books_id = l_fp_cols_rec.x_set_of_books_id
199: AND adjustment_period_flag = 'N'
200: AND l_end_date between start_date and end_date;
201: END IF;

Line 219: AND APPLICATION_ID = PA_PERIOD_PROCESS_PKG.Application_id

215: IF l_fp_cols_rec.x_time_phased_code = 'G' THEN
216: SELECT end_date into l_end_date1
217: FROM gl_period_statuses
218: WHERE l_end_date between start_date and end_date
219: AND APPLICATION_ID = PA_PERIOD_PROCESS_PKG.Application_id
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

Line 258: WHERE APPLICATION_ID = PA_PERIOD_PROCESS_PKG.Application_id

254: ELSIF l_fp_cols_rec.x_time_phased_code = 'G' THEN
255: SELECT end_date
256: INTO l_end_date
257: FROM gl_period_statuses
258: WHERE APPLICATION_ID = PA_PERIOD_PROCESS_PKG.Application_id
259: AND set_of_books_id = l_fp_cols_rec.x_set_of_books_id
260: AND adjustment_period_flag = 'N'
261: AND trunc(sysdate) between start_date and end_date;
262: ELSE

Line 351: WHERE g.application_id = PA_PERIOD_PROCESS_PKG.Application_id

347:
348: SELECT g.period_name
349: INTO l_period_name
350: FROM gl_period_statuses g, pa_projects_all proj
351: WHERE g.application_id = PA_PERIOD_PROCESS_PKG.Application_id
352: AND g.set_of_books_id = l_fp_cols_rec.x_set_of_books_id
353: AND g.adjustment_period_flag = 'N'
354: AND proj.project_id = l_fp_cols_rec.x_project_id
355: AND proj.start_date between g.start_date and g.end_date;

Line 453: WHERE application_id = PA_PERIOD_PROCESS_PKG.Application_id

449: BEGIN
450: SELECT period_name
451: INTO l_act_to_period_name
452: FROM gl_period_statuses
453: WHERE application_id = PA_PERIOD_PROCESS_PKG.Application_id
454: AND set_of_books_id = l_fp_cols_rec.x_set_of_books_id
455: AND adjustment_period_flag = 'N'
456: AND l_act_to_period_date BETWEEN start_date AND end_date
457: AND start_date >= (SELECT start_date FROM gl_period_statuses -- bug6142328 added one more select query for comparing the start date of act_to_period with act_from_period

Line 458: WHERE application_id = PA_PERIOD_PROCESS_PKG.Application_id

454: AND set_of_books_id = l_fp_cols_rec.x_set_of_books_id
455: AND adjustment_period_flag = 'N'
456: AND l_act_to_period_date BETWEEN start_date AND end_date
457: AND start_date >= (SELECT start_date FROM gl_period_statuses -- bug6142328 added one more select query for comparing the start date of act_to_period with act_from_period
458: WHERE application_id = PA_PERIOD_PROCESS_PKG.Application_id
459: AND set_of_books_id = l_fp_cols_rec.x_set_of_books_id
460: AND period_name = l_act_from_period_name);
461:
462: EXCEPTION

Line 562: WHERE application_id = PA_PERIOD_PROCESS_PKG.Application_id

558:
559: SELECT period_name
560: INTO l_etc_from_period_name
561: FROM gl_period_statuses
562: WHERE application_id = PA_PERIOD_PROCESS_PKG.Application_id
563: AND set_of_books_id = l_fp_cols_rec.x_set_of_books_id
564: AND adjustment_period_flag = 'N'
565: AND l_etc_from_period_date between start_date and end_date;
566:

Line 686: WHERE g.application_id = PA_PERIOD_PROCESS_PKG.Application_id

682:
683: SELECT g.period_name, NVL(proj.completion_date, trunc(SYSDATE))
684: INTO l_etc_to_period, l_proj_comp_date
685: FROM gl_period_statuses g, pa_projects_all proj
686: WHERE g.application_id = PA_PERIOD_PROCESS_PKG.Application_id
687: AND g.set_of_books_id = l_fp_cols_rec.x_set_of_books_id
688: AND g.adjustment_period_flag = 'N'
689: AND proj.project_id = l_fp_cols_rec.x_project_id
690: AND NVL(proj.completion_date, trunc(SYSDATE)) between g.start_date and g.end_date;

Line 2132: WHERE APPLICATION_ID = PA_PERIOD_PROCESS_PKG.Application_id

2128: ELSIF P_FP_COLS_REC.X_TIME_PHASED_CODE = 'G' THEN
2129: SELECT END_DATE
2130: INTO X_END_DATE
2131: FROM GL_PERIOD_STATUSES
2132: WHERE APPLICATION_ID = PA_PERIOD_PROCESS_PKG.Application_id
2133: AND SET_OF_BOOKS_ID = p_fp_cols_rec.x_set_of_books_id
2134: AND ADJUSTMENT_PERIOD_FLAG = 'N'
2135: AND PERIOD_NAME = p_period_name;
2136: --dbms_output.put_line('End date from validate_pa_gl_periods(G) api:'||X_END_DATE);