APPS.ARP_RECUR_PKG dependencies on RA_BATCH_SOURCES

Line 12: p_batch_source_id IN ra_batch_sources.batch_source_id%type,

8: pg_conc_program_id number;
9:
10: PROCEDURE insert_p(
11: p_rec_rec IN ra_recur_interim%rowtype,
12: p_batch_source_id IN ra_batch_sources.batch_source_id%type,
13: p_trx_number OUT NOCOPY ra_recur_interim.trx_number%type
14: ) IS
15: l_trx_num_cursor integer;
16: l_dummy integer;

Line 41: 'from ra_batch_sources ' ||

37: l_trx_str := 'select ra_trx_number_' ||
38: REPLACE(p_batch_source_id, '-', 'N') ||
39: l_org_str||
40: '_s.nextval trx_number ' ||
41: 'from ra_batch_sources ' ||
42: 'where batch_source_id = ' ||
43: p_batch_source_id ||
44: ' and auto_trx_numbering_flag = ''Y''';
45:

Line 57: 'from ra_batch_sources ' ||

53: 'select ra_trx_number_' ||
54: REPLACE(p_batch_source_id, '-', 'N') ||
55: l_org_str||
56: '_s.nextval trx_number ' ||
57: 'from ra_batch_sources ' ||
58: 'where batch_source_id = ' ||
59: p_batch_source_id ||
60: ' and auto_trx_numbering_flag = ''Y''',
61: dbms_sql.v7);