APPS.GL_TRANSACTION_DATES_PKG dependencies on GL_PERIODS

Line 21: FROM gl_periods

17: CURSOR check_new_year IS
18: SELECT '1' FROM sys.dual
19: WHERE EXISTS
20: (SELECT 'Existing Year'
21: FROM gl_periods
22: WHERE
23: period_set_name = x_period_set_name
24: AND end_date BETWEEN
25: TO_DATE(x_entered_year || '/01/01', 'YYYY/MM/DD')

Line 131: 'gl_periods_pkg.extend_transaction_calendars');

127: EXCEPTION
128: WHEN OTHERS THEN
129: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
130: fnd_message.set_token('PROCEDURE',
131: 'gl_periods_pkg.extend_transaction_calendars');
132: RAISE;
133:
134: END extend_transaction_calendars;
135:

Line 153: FROM gl_periods;

149: BEGIN
150: -- get the earliest year
151: SELECT TO_NUMBER(TO_CHAR(MIN(start_date), 'YYYY'))
152: INTO earliest_year
153: FROM gl_periods;
154:
155: -- get the latest date
156: SELECT TO_NUMBER(TO_CHAR(MAX(end_date), 'YYYY'))
157: INTO latest_year

Line 158: FROM gl_periods;

154:
155: -- get the latest date
156: SELECT TO_NUMBER(TO_CHAR(MAX(end_date), 'YYYY'))
157: INTO latest_year
158: FROM gl_periods;
159:
160: -- Lock GL_CONCURRENCY_CONTROL table in the row share mode using
161: -- CONCURRENCY_CLASS = EXTEND_TRANSACTION_CALENDAR. This is to
162: -- indicate that the GL_TRANSACTION_DATES table is locked for INSERT/UPDATE but

Line 247: 'gl_periods_pkg.insert_all_years_for_calendar');

243: EXCEPTION
244: WHEN OTHERS THEN
245: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
246: fnd_message.set_token('PROCEDURE',
247: 'gl_periods_pkg.insert_all_years_for_calendar');
248: RAISE;
249: END insert_all_years_for_calendar;
250:
251: