APPS.GL_TRANSACTION_DATES_PKG dependencies on GL_CONCURRENCY_CONTROL

Line 42: -- Lock GL_CONCURRENCY_CONTROL table in the row share mode using

38: CLOSE check_new_year;
39: RETURN;
40: END IF;
41:
42: -- Lock GL_CONCURRENCY_CONTROL table in the row share mode using
43: -- CONCURRENCY_CLASS = EXTEND_TRANSACTION_CALENDAR. This is to
44: -- indicate that the GL_TRANSACTION_DATES table is locked for INSERT/UPDATE
45: -- but can be used for SELECT.
46:

Line 49: FROM gl_concurrency_control

45: -- but can be used for SELECT.
46:
47: SELECT concurrency_class
48: INTO dummy
49: FROM gl_concurrency_control
50: WHERE concurrency_class = 'EXTEND_TRANSACTION_CALENDAR'
51: FOR UPDATE OF concurrency_class;
52:
53:

Line 160: -- Lock GL_CONCURRENCY_CONTROL table in the row share mode using

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
163: -- can be used for SELECT.
164: SELECT concurrency_class

Line 166: FROM gl_concurrency_control

162: -- indicate that the GL_TRANSACTION_DATES table is locked for INSERT/UPDATE but
163: -- can be used for SELECT.
164: SELECT concurrency_class
165: INTO dummy
166: FROM gl_concurrency_control
167: WHERE concurrency_class = 'EXTEND_TRANSACTION_CALENDAR'
168: FOR UPDATE OF concurrency_class;
169:
170: -- Insert records for all transaction calendars into the