APPS.ARP_CT_PKG dependencies on RA_BATCH_SOURCES

Line 3535: FROM ra_batch_sources

3531: '15', p_trx_rec.interface_header_attribute15,
3532: NULL, p_trx_rec.ct_reference,
3533: NULL ) /* Bug fix 5330712 */
3534: INTO l_ct_reference
3535: FROM ra_batch_sources
3536: WHERE batch_source_id = p_trx_rec.batch_source_id;
3537: exception
3538: when no_data_found then
3539: l_ct_reference:=null;

Line 3743: 'from ra_batch_sources ' ||

3739: l_trx_str := 'select ra_trx_number_' ||
3740: REPLACE(p_trx_rec.batch_source_id, '-', 'N') ||
3741: l_org_str||
3742: '_s.nextval trx_number,copy_doc_number_flag ' ||
3743: 'from ra_batch_sources ' ||
3744: 'where batch_source_id = ' ||
3745: p_trx_rec.batch_source_id ||
3746: ' and auto_trx_numbering_flag = ''Y''';
3747:

Line 3759: 'from ra_batch_sources ' ||

3755: 'select ra_trx_number_' ||
3756: REPLACE(p_trx_rec.batch_source_id, '-', 'N') ||
3757: l_org_str||
3758: '_s.nextval trx_number ' ||
3759: 'from ra_batch_sources ' ||
3760: 'where batch_source_id = ' ||
3761: p_trx_rec.batch_source_id ||
3762: ' and auto_trx_numbering_flag = ''Y''',
3763: dbms_sql.v7);

Line 3813: FROM ra_batch_sources

3809: '15', p_trx_rec.interface_header_attribute15,
3810: NULL,p_trx_rec.ct_reference, /* Bug fix 5330712*/
3811: NULL )
3812: INTO l_ct_reference
3813: FROM ra_batch_sources
3814: WHERE batch_source_id = p_trx_rec.batch_source_id;
3815: exception
3816: when no_data_found then
3817: l_ct_reference:=null;