APPS.AR_GTA_BATCH_NUMBER_UTIL dependencies on AR_GTA_BATCH_NUMBERING

Line 72: FROM ar_gta_batch_numbering

68:
69: CURSOR c_chk_seq_exist IS
70: SELECT
71: COUNT(*)
72: FROM ar_gta_batch_numbering
73: WHERE org_id = p_org_id;
74:
75: BEGIN
76: --logging for debug

Line 97: INSERT INTO ar_gta_batch_numbering

93: ELSE
94: l_next_value := 1;
95: END IF;
96:
97: INSERT INTO ar_gta_batch_numbering
98: ( org_id
99: , next_value
100: , last_update_date
101: , last_updated_by

Line 169: FROM ar_gta_batch_numbering

165: l_proc_level NUMBER := fnd_log.level_procedure;
166:
167: CURSOR c_chk_seq_exist IS
168: SELECT COUNT(*)
169: FROM ar_gta_batch_numbering
170: WHERE org_id = p_org_id;
171:
172: BEGIN
173: --logging for debug

Line 187: UPDATE ar_gta_batch_numbering

183: CLOSE c_chk_seq_exist;
184:
185: IF l_count = 1
186: THEN
187: UPDATE ar_gta_batch_numbering
188: SET next_value = p_next_value
189: , last_update_date = SYSDATE
190: , last_updated_by = fnd_global.LOGIN_ID()
191: , last_update_login = fnd_global.LOGIN_ID()

Line 253: FROM ar_gta_batch_numbering

249: WHERE org_id = p_org_id;
250:
251: CURSOR c_next_val IS
252: SELECT next_value
253: FROM ar_gta_batch_numbering
254: WHERE org_id = p_org_id
255: FOR UPDATE OF next_value NOWAIT;
256:
257: BEGIN

Line 281: UPDATE ar_gta_batch_numbering

277: FETCH c_next_val INTO l_next_val;
278:
279: IF c_next_val%FOUND
280: THEN
281: UPDATE ar_gta_batch_numbering
282: SET next_value = l_next_val + 1
283: , last_update_date = SYSDATE
284: , last_updated_by = fnd_global.LOGIN_ID()
285: , last_update_login = fnd_global.LOGIN_ID()

Line 337: FROM ar_gta_batch_numbering

333: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
334: l_proc_level NUMBER := fnd_log.level_procedure;
335: CURSOR c_chk_seq_exist IS
336: SELECT COUNT(*)
337: FROM ar_gta_batch_numbering
338: WHERE org_id = p_org_id;
339: BEGIN
340:
341: --logging for debug

Line 355: DELETE FROM ar_gta_batch_numbering

351: CLOSE c_chk_seq_exist;
352:
353: IF l_count = 1
354: THEN
355: DELETE FROM ar_gta_batch_numbering
356: WHERE org_id = p_org_id;
357:
358: COMMIT;
359: x_return_status := 'S';

Line 545: ar_gta_batch_numbering

541: CURSOR c_chk_seq_exist IS
542: SELECT
543: COUNT(*)
544: FROM
545: ar_gta_batch_numbering
546: WHERE org_id = p_org_id;
547: BEGIN
548: --logging for debug
549: IF (l_proc_level >= l_dbg_level)

Line 610: ar_gta_batch_numbering

606: CURSOR c_seq IS
607: SELECT
608: next_value
609: FROM
610: ar_gta_batch_numbering
611: WHERE org_id = p_org_id;
612: BEGIN
613: --logging for debug
614: IF (l_proc_level >= l_dbg_level)