DBA Data[Home] [Help]

APPS.ARP_CT_PKG dependencies on RA_BATCH_SOURCES

Line 4878: FROM ra_batch_sources

4874: '15', p_trx_rec.interface_header_attribute15,
4875: NULL, p_trx_rec.ct_reference,
4876: NULL ) /* Bug fix 5330712 */
4877: INTO l_ct_reference
4878: FROM ra_batch_sources
4879: WHERE batch_source_id = p_trx_rec.batch_source_id;
4880: exception
4881: when no_data_found then
4882: l_ct_reference:=null;

Line 5088: 'from ra_batch_sources ' ||

5084: l_trx_str := 'select ra_trx_number_' ||
5085: REPLACE(p_trx_rec.batch_source_id, '-', 'N') ||
5086: l_org_str||
5087: '_s.nextval trx_number,copy_doc_number_flag ' ||
5088: 'from ra_batch_sources ' ||
5089: 'where batch_source_id = ' ||
5090: p_trx_rec.batch_source_id ||
5091: ' and auto_trx_numbering_flag = ''Y''';
5092:

Line 5104: 'from ra_batch_sources ' ||

5100: 'select ra_trx_number_' ||
5101: REPLACE(p_trx_rec.batch_source_id, '-', 'N') ||
5102: l_org_str||
5103: '_s.nextval trx_number ' ||
5104: 'from ra_batch_sources ' ||
5105: 'where batch_source_id = ' ||
5106: p_trx_rec.batch_source_id ||
5107: ' and auto_trx_numbering_flag = ''Y''',
5108: dbms_sql.v7);

Line 5158: FROM ra_batch_sources

5154: '15', p_trx_rec.interface_header_attribute15,
5155: NULL,p_trx_rec.ct_reference, /* Bug fix 5330712*/
5156: NULL )
5157: INTO l_ct_reference
5158: FROM ra_batch_sources
5159: WHERE batch_source_id = p_trx_rec.batch_source_id;
5160: exception
5161: when no_data_found then
5162: l_ct_reference:=null;