APPS.ARP_TBAT_PKG dependencies on RA_BATCH_SOURCES

Line 1837: IN ra_batch_sources.batch_source_id%type) IS

1833: +===========================================================================*/
1834:
1835: PROCEDURE update_f_bs_id( p_batch_rec IN ra_batches%rowtype,
1836: p_batch_source_id
1837: IN ra_batch_sources.batch_source_id%type) IS
1838:
1839:
1840: BEGIN
1841:

Line 1929: FROM ra_batch_sources

1925: IF (p_batch_rec.name is null)
1926: THEN
1927: SELECT to_char(last_batch_num + 1)
1928: INTO l_batch_name
1929: FROM ra_batch_sources
1930: WHERE batch_source_id = p_batch_rec.batch_source_id
1931: AND auto_batch_numbering_flag = 'Y'
1932: FOR UPDATE OF last_batch_num NOWAIT;
1933:

Line 1934: UPDATE ra_batch_sources

1930: WHERE batch_source_id = p_batch_rec.batch_source_id
1931: AND auto_batch_numbering_flag = 'Y'
1932: FOR UPDATE OF last_batch_num NOWAIT;
1933:
1934: UPDATE ra_batch_sources
1935: SET last_batch_num = l_batch_name
1936: WHERE batch_source_id = p_batch_rec.batch_source_id;
1937: ELSE
1938: l_batch_name := p_batch_rec.name;