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,
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,
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:
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,
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
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,
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,
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: