APPS.FUN_SEQ_UTILS dependencies on FUN_TRX_BATCHES

Line 938: -- numeric trx numbers stored in FUN_TRX_BATCHES.

934: l_header_name := '$SEQUENCE$.INTERCOMPANY';
935: l_max_number := get_max_number;
936: --
937: -- Recreate Versions when there exists one or more
938: -- numeric trx numbers stored in FUN_TRX_BATCHES.
939: --
940: IF l_max_number IS NOT NULL THEN
941: --
942: -- Lock the transaction table to prevent the creation of new records

Line 945: LOCK TABLE fun_trx_batches IN EXCLUSIVE MODE NOWAIT;

941: --
942: -- Lock the transaction table to prevent the creation of new records
943: -- during the recreation process.
944: --
945: LOCK TABLE fun_trx_batches IN EXCLUSIVE MODE NOWAIT;
946: --
947: -- Retrieve an active Version information
948: --
949: get_active_version (

Line 1453: FROM fun_trx_batches tb

1449: l_max_number fun_seq_versions.initial_value%TYPE;
1450: BEGIN
1451: SELECT max(TO_NUMBER(tb.batch_number))
1452: INTO l_max_number
1453: FROM fun_trx_batches tb
1454: WHERE TRANSLATE(tb.batch_number,'0123456789','0000000000')
1455: = RPAD('0',LENGTH(tb.batch_number),'0');
1456:
1457: RETURN l_max_number;