2474: -- Check if period is open or future enterable
2475: BEGIN
2476: SELECT 1
2477: INTO dummy
2478: FROM gl_period_statuses
2479: WHERE application_id = 101
2480: AND set_of_books_id = l_src_ledger_id
2481: AND adjustment_period_flag = 'N'
2482: AND closing_status in ('O','F')
2485: log_msg(l_debug_proc,'Source period is open');
2486:
2487: SELECT 1
2488: INTO dummy
2489: FROM gl_period_statuses
2490: WHERE application_id = 101
2491: AND set_of_books_id = l_dest_ledger_id
2492: AND adjustment_period_flag = 'N'
2493: AND closing_status in ('O','F')