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.CN_ACC_PERIODS_PVT dependencies on GL_PERIOD_STATUSES

Line 76: FROM gl_period_statuses gl,

72: 'O' closing_status_meaning,
73: cp.meaning processing_status,
74: p_freeze_flag,
75: cn.object_version_number
76: FROM gl_period_statuses gl,
77: cn_period_statuses cn,
78: cn_lookups cp
79: WHERE gl.set_of_books_id = l_set_of_books_id
80: AND gl.application_id = 283

Line 234: l_quarter_num gl_period_statuses.quarter_num%TYPE;

230: l_calendar cn_period_sets.period_set_name%TYPE;
231: l_period_set_id cn_period_sets.period_set_id%TYPE;
232: l_period_type_id cn_period_types.period_type_id%TYPE;
233: l_period_type cn_period_types.period_type%TYPE;
234: l_quarter_num gl_period_statuses.quarter_num%TYPE;
235: l_period_num gl_period_statuses.period_num%TYPE;
236: l_object_version_number cn_period_statuses.object_version_number%TYPE;
237: l_closing_status gl_period_statuses.closing_status%TYPE;
238: l_closing_status_old gl_period_statuses.closing_status%TYPE;

Line 235: l_period_num gl_period_statuses.period_num%TYPE;

231: l_period_set_id cn_period_sets.period_set_id%TYPE;
232: l_period_type_id cn_period_types.period_type_id%TYPE;
233: l_period_type cn_period_types.period_type%TYPE;
234: l_quarter_num gl_period_statuses.quarter_num%TYPE;
235: l_period_num gl_period_statuses.period_num%TYPE;
236: l_object_version_number cn_period_statuses.object_version_number%TYPE;
237: l_closing_status gl_period_statuses.closing_status%TYPE;
238: l_closing_status_old gl_period_statuses.closing_status%TYPE;
239: l_proc_status_old cn_period_statuses.processing_status_code%TYPE;

Line 237: l_closing_status gl_period_statuses.closing_status%TYPE;

233: l_period_type cn_period_types.period_type%TYPE;
234: l_quarter_num gl_period_statuses.quarter_num%TYPE;
235: l_period_num gl_period_statuses.period_num%TYPE;
236: l_object_version_number cn_period_statuses.object_version_number%TYPE;
237: l_closing_status gl_period_statuses.closing_status%TYPE;
238: l_closing_status_old gl_period_statuses.closing_status%TYPE;
239: l_proc_status_old cn_period_statuses.processing_status_code%TYPE;
240: l_freeze_flag_old cn_period_statuses.freeze_flag%TYPE;
241: l_pre_status gl_period_statuses.closing_status%TYPE;

Line 238: l_closing_status_old gl_period_statuses.closing_status%TYPE;

234: l_quarter_num gl_period_statuses.quarter_num%TYPE;
235: l_period_num gl_period_statuses.period_num%TYPE;
236: l_object_version_number cn_period_statuses.object_version_number%TYPE;
237: l_closing_status gl_period_statuses.closing_status%TYPE;
238: l_closing_status_old gl_period_statuses.closing_status%TYPE;
239: l_proc_status_old cn_period_statuses.processing_status_code%TYPE;
240: l_freeze_flag_old cn_period_statuses.freeze_flag%TYPE;
241: l_pre_status gl_period_statuses.closing_status%TYPE;
242: l_next_status gl_period_statuses.closing_status%TYPE;

Line 241: l_pre_status gl_period_statuses.closing_status%TYPE;

237: l_closing_status gl_period_statuses.closing_status%TYPE;
238: l_closing_status_old gl_period_statuses.closing_status%TYPE;
239: l_proc_status_old cn_period_statuses.processing_status_code%TYPE;
240: l_freeze_flag_old cn_period_statuses.freeze_flag%TYPE;
241: l_pre_status gl_period_statuses.closing_status%TYPE;
242: l_next_status gl_period_statuses.closing_status%TYPE;
243: l_update_flag VARCHAR2(1) := 'N';
244: -- Added as part of bug fix bug#2804029
245: l_period_status_count NUMBER := 0;

Line 242: l_next_status gl_period_statuses.closing_status%TYPE;

238: l_closing_status_old gl_period_statuses.closing_status%TYPE;
239: l_proc_status_old cn_period_statuses.processing_status_code%TYPE;
240: l_freeze_flag_old cn_period_statuses.freeze_flag%TYPE;
241: l_pre_status gl_period_statuses.closing_status%TYPE;
242: l_next_status gl_period_statuses.closing_status%TYPE;
243: l_update_flag VARCHAR2(1) := 'N';
244: -- Added as part of bug fix bug#2804029
245: l_period_status_count NUMBER := 0;
246: l_pre_gl_status_count NUMBER := 0;

Line 270: CURSOR period_info(p_period_name gl_period_statuses.period_name%TYPE) IS

266: AND r.org_id = p_org_id -- MOAC Change
267: AND r.org_id = ps.org_id -- MOAC Change
268: AND ps.org_id = pt.org_id; -- MOAC Change
269:
270: CURSOR period_info(p_period_name gl_period_statuses.period_name%TYPE) IS
271: SELECT nvl(cn.org_id, p_org_id) org_id, -- MOAC Change
272: gl.quarter_num,
273: gl.period_num,
274: cn.object_version_number,

Line 277: FROM gl_period_statuses gl, cn_period_statuses cn

273: gl.period_num,
274: cn.object_version_number,
275: gl.closing_status,
276: cn.freeze_flag
277: FROM gl_period_statuses gl, cn_period_statuses cn
278: WHERE gl.application_id = 283
279: AND gl.set_of_books_id = l_set_of_books_id
280: AND gl.period_name = p_period_name
281: AND gl.adjustment_period_flag = 'N'

Line 297: CURSOR pre_status_gl(p_period_year gl_period_statuses.period_year%TYPE, p_start_date DATE) IS

293: AND period_type_id = l_period_type_id
294: AND period_set_id = l_period_set_id;
295:
296: -- Changed cursor fix bug#2804029
297: CURSOR pre_status_gl(p_period_year gl_period_statuses.period_year%TYPE, p_start_date DATE) IS
298: SELECT count(gl.closing_status)
299: FROM gl_period_statuses gl
300: WHERE gl.set_of_books_id = l_set_of_books_id
301: AND gl.application_id = 283

Line 299: FROM gl_period_statuses gl

295:
296: -- Changed cursor fix bug#2804029
297: CURSOR pre_status_gl(p_period_year gl_period_statuses.period_year%TYPE, p_start_date DATE) IS
298: SELECT count(gl.closing_status)
299: FROM gl_period_statuses gl
300: WHERE gl.set_of_books_id = l_set_of_books_id
301: AND gl.application_id = 283
302: AND gl.adjustment_period_flag = 'N'
303: --AND gl.period_year = p_period_year

Line 307: -- Changed cursor to refer to cn_period_status instead of gl_period_statuses

303: --AND gl.period_year = p_period_year
304: AND gl.start_date < p_start_date
305: ORDER BY gl.start_date;
306:
307: -- Changed cursor to refer to cn_period_status instead of gl_period_statuses
308: -- as part of bug fix bug#2804029
309: CURSOR pre_status(p_start_date DATE) IS
310: SELECT 'N', start_date
311: FROM gl_period_statuses gl

Line 311: FROM gl_period_statuses gl

307: -- Changed cursor to refer to cn_period_status instead of gl_period_statuses
308: -- as part of bug fix bug#2804029
309: CURSOR pre_status(p_start_date DATE) IS
310: SELECT 'N', start_date
311: FROM gl_period_statuses gl
312: WHERE gl.set_of_books_id = l_set_of_books_id
313: AND gl.application_id = 283
314: AND gl.adjustment_period_flag = 'N'
315: AND start_date < p_start_date

Line 332: CURSOR next_status_gl(p_period_year gl_period_statuses.period_year%TYPE, p_start_date DATE) IS

328: AND cn.start_date < p_start_date
329: ORDER BY start_date DESC;
330:
331: -- Changed cursor fix bug#2804029
332: CURSOR next_status_gl(p_period_year gl_period_statuses.period_year%TYPE, p_start_date DATE) IS
333: SELECT count(gl.closing_status)
334: FROM gl_period_statuses gl
335: WHERE gl.set_of_books_id = l_set_of_books_id
336: AND gl.application_id = 283

Line 334: FROM gl_period_statuses gl

330:
331: -- Changed cursor fix bug#2804029
332: CURSOR next_status_gl(p_period_year gl_period_statuses.period_year%TYPE, p_start_date DATE) IS
333: SELECT count(gl.closing_status)
334: FROM gl_period_statuses gl
335: WHERE gl.set_of_books_id = l_set_of_books_id
336: AND gl.application_id = 283
337: AND gl.adjustment_period_flag = 'N'
338: --AND gl.period_year = p_period_year

Line 342: -- Changed cursor to refer to cn_period_status instead of gl_period_statuses

338: --AND gl.period_year = p_period_year
339: AND gl.start_date > p_start_date
340: ORDER BY gl.start_date;
341:
342: -- Changed cursor to refer to cn_period_status instead of gl_period_statuses
343: -- as part of bug fix bug#2804029
344:
345: CURSOR next_status(p_start_date DATE) IS
346: SELECT cn.period_status

Line 430: -- update the existing gl_period_statuses record

426: nvl(l_freeze_flag_old, 'N') <> nvl(p_acc_period_tbl(i).freeze_flag, 'N' ) OR
427: l_proc_status_old = 'FAILED') THEN
428: l_update_flag := 'Y';
429:
430: -- update the existing gl_period_statuses record
431: IF (i > p_acc_period_tbl.first) THEN
432: l_pre_status := get_closing_status(p_acc_period_tbl(i-1).closing_status_meaning);
433: ELSE
434: OPEN pre_status(p_acc_period_tbl(i).start_date);

Line 651: l_current_year gl_period_statuses.period_year%TYPE;

647: IS
648: l_set_of_books_id cn_repositories.set_of_books_id%TYPE;
649: l_period_set_id cn_repositories.period_set_id%TYPE;
650: l_period_type_id cn_repositories.period_type_id%TYPE;
651: l_current_year gl_period_statuses.period_year%TYPE;
652:
653: CURSOR current_year IS
654: SELECT period_year
655: FROM gl_period_statuses

Line 655: FROM gl_period_statuses

651: l_current_year gl_period_statuses.period_year%TYPE;
652:
653: CURSOR current_year IS
654: SELECT period_year
655: FROM gl_period_statuses
656: WHERE trunc(sysdate) BETWEEN start_date AND end_date
657: AND application_id = 283
658: AND adjustment_period_flag = 'N'
659: AND set_of_books_id = (SELECT set_of_books_id

Line 667: FROM gl_period_statuses

663: AND ROWNUM = 1;
664:
665: CURSOR first_year IS
666: SELECT max(period_year)
667: FROM gl_period_statuses
668: WHERE application_id = 283
669: AND adjustment_period_flag = 'N'
670: AND set_of_books_id = (SELECT set_of_books_id
671: FROM cn_repositories

Line 725: FROM gl_period_statuses gl,

721: gp.meaning closing_status_meaning,
722: cp.meaning processing_status,
723: cn.freeze_flag,
724: cn.object_version_number
725: FROM gl_period_statuses gl,
726: cn_period_statuses cn,
727: cn_lookups gp,
728: cn_lookups cp
729: WHERE gl.set_of_books_id = l_set_of_books_id