APPS.GL_CONC_CONTROL_PKG dependencies on GL_CONCURRENCY_CONTROL

Line 18: LOCK TABLE GL_CONCURRENCY_CONTROL IN SHARE UPDATE MODE;

14: x_created_by NUMBER,
15: x_last_update_login NUMBER ) IS
16:
17: BEGIN
18: LOCK TABLE GL_CONCURRENCY_CONTROL IN SHARE UPDATE MODE;
19: INSERT INTO gl_concurrency_control(
20: concurrency_class,
21: concurrency_entity_name,
22: concurrency_entity_id,

Line 19: INSERT INTO gl_concurrency_control(

15: x_last_update_login NUMBER ) IS
16:
17: BEGIN
18: LOCK TABLE GL_CONCURRENCY_CONTROL IN SHARE UPDATE MODE;
19: INSERT INTO gl_concurrency_control(
20: concurrency_class,
21: concurrency_entity_name,
22: concurrency_entity_id,
23: last_update_date,

Line 43: FROM gl_concurrency_control cc

39: WHERE
40: lk.lookup_type = 'CONCURRENCY_LEDGER'
41: AND NOT EXISTS(
42: SELECT 1
43: FROM gl_concurrency_control cc
44: WHERE cc.concurrency_class = lk.lookup_code
45: AND cc.concurrency_entity_name = 'LEDGER'
46: AND cc.concurrency_entity_id = to_char( x_ledger_id ) );
47:

Line 48: INSERT INTO gl_concurrency_control(

44: WHERE cc.concurrency_class = lk.lookup_code
45: AND cc.concurrency_entity_name = 'LEDGER'
46: AND cc.concurrency_entity_id = to_char( x_ledger_id ) );
47:
48: INSERT INTO gl_concurrency_control(
49: concurrency_class,
50: concurrency_entity_name,
51: concurrency_entity_id,
52: last_update_date,

Line 71: FROM gl_concurrency_control cc

67: dual
68: WHERE
69: NOT EXISTS(
70: SELECT 1
71: FROM gl_concurrency_control cc
72: WHERE cc.concurrency_class = 'FETCH_TEMPLATE_ORDER'
73: AND cc.concurrency_entity_id = to_char( x_ledger_id ) );
74:
75: EXCEPTION

Line 98: LOCK TABLE GL_CONCURRENCY_CONTROL IN SHARE UPDATE MODE;

94: x_created_by NUMBER,
95: x_last_update_login NUMBER ) IS
96:
97: BEGIN
98: LOCK TABLE GL_CONCURRENCY_CONTROL IN SHARE UPDATE MODE;
99: INSERT INTO gl_concurrency_control(
100: concurrency_class,
101: concurrency_entity_name,
102: concurrency_entity_id,

Line 99: INSERT INTO gl_concurrency_control(

95: x_last_update_login NUMBER ) IS
96:
97: BEGIN
98: LOCK TABLE GL_CONCURRENCY_CONTROL IN SHARE UPDATE MODE;
99: INSERT INTO gl_concurrency_control(
100: concurrency_class,
101: concurrency_entity_name,
102: concurrency_entity_id,
103: last_update_date,

Line 123: FROM gl_concurrency_control cc

119: WHERE
120: lk.lookup_type = 'CONCURRENCY_SUBS'
121: AND NOT EXISTS(
122: SELECT 1
123: FROM gl_concurrency_control cc
124: WHERE cc.concurrency_class = lk.lookup_code
125: AND cc.concurrency_entity_name = 'SUBSIDIARY'
126: AND cc.concurrency_entity_id = to_char( x_subsidiary_id ) );
127: