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 196: WHERE APPLICATION_ID = PA_PERIOD_PROCESS_PKG.Application_id

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

Line 218: AND APPLICATION_ID = PA_PERIOD_PROCESS_PKG.Application_id

214: IF l_fp_cols_rec.x_time_phased_code = 'G' THEN
215: SELECT end_date into l_end_date1
216: FROM gl_period_statuses
217: WHERE l_end_date between start_date and end_date
218: AND APPLICATION_ID = PA_PERIOD_PROCESS_PKG.Application_id
219: AND SET_OF_BOOKS_ID = l_fp_cols_rec.x_set_of_books_id
220: AND ADJUSTMENT_PERIOD_FLAG = 'N';
221: ELSIF l_fp_cols_rec.x_time_phased_code = 'P' THEN
222: SELECT end_date into l_end_date1

Line 257: WHERE APPLICATION_ID = PA_PERIOD_PROCESS_PKG.Application_id

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

Line 350: WHERE g.application_id = PA_PERIOD_PROCESS_PKG.Application_id

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

Line 452: WHERE application_id = PA_PERIOD_PROCESS_PKG.Application_id

448: BEGIN
449: SELECT period_name
450: INTO l_act_to_period_name
451: FROM gl_period_statuses
452: WHERE application_id = PA_PERIOD_PROCESS_PKG.Application_id
453: AND set_of_books_id = l_fp_cols_rec.x_set_of_books_id
454: AND adjustment_period_flag = 'N'
455: AND l_act_to_period_date BETWEEN start_date AND end_date
456: 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 457: WHERE application_id = PA_PERIOD_PROCESS_PKG.Application_id

453: AND set_of_books_id = l_fp_cols_rec.x_set_of_books_id
454: AND adjustment_period_flag = 'N'
455: AND l_act_to_period_date BETWEEN start_date AND end_date
456: 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
457: WHERE application_id = PA_PERIOD_PROCESS_PKG.Application_id
458: AND set_of_books_id = l_fp_cols_rec.x_set_of_books_id
459: AND period_name = l_act_from_period_name);
460:
461: EXCEPTION

Line 561: WHERE application_id = PA_PERIOD_PROCESS_PKG.Application_id

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

Line 685: WHERE g.application_id = PA_PERIOD_PROCESS_PKG.Application_id

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

Line 1851: WHERE APPLICATION_ID = PA_PERIOD_PROCESS_PKG.Application_id

1847: ELSIF P_FP_COLS_REC.X_TIME_PHASED_CODE = 'G' THEN
1848: SELECT END_DATE
1849: INTO X_END_DATE
1850: FROM GL_PERIOD_STATUSES
1851: WHERE APPLICATION_ID = PA_PERIOD_PROCESS_PKG.Application_id
1852: AND SET_OF_BOOKS_ID = p_fp_cols_rec.x_set_of_books_id
1853: AND ADJUSTMENT_PERIOD_FLAG = 'N'
1854: AND PERIOD_NAME = p_period_name;
1855: --dbms_output.put_line('End date from validate_pa_gl_periods(G) api:'||X_END_DATE);