APPS.ARP_TRX_VALIDATE dependencies on RA_BATCH_SOURCES

Line 292: FROM ra_batch_sources

288: -- get the flags for the batchsource
289: CURSOR flags IS
290: SELECT NVL(copy_doc_number_flag, 'N'),
291: NVL(allow_duplicate_trx_num_flag, 'N')
292: FROM ra_batch_sources
293: WHERE batch_source_id = p_batch_source_id;
294:
295: -- check if the transaction number exists already
296: CURSOR duptrx IS

Line 312: FROM ra_batch_sources bs,

308: AND ri.trx_number = p_trx_number
309: AND NVL(ri.new_customer_trx_id, -98) <> NVL(p_customer_trx_id, -99)
310: UNION
311: SELECT 'Y' -- already exists in the interface table
312: FROM ra_batch_sources bs,
313: ra_interface_lines ril
314: WHERE ril.batch_source_name = bs.name
315: AND bs.batch_source_id = p_batch_source_id
316: AND ril.trx_number = p_trx_number

Line 320: l_copy_doc_num_flag ra_batch_sources_all.copy_doc_number_flag%TYPE;

316: AND ril.trx_number = p_trx_number
317: AND ril.customer_trx_id <> NVL(p_customer_trx_id, -99);
318:
319: l_temp VARCHAR2(1);
320: l_copy_doc_num_flag ra_batch_sources_all.copy_doc_number_flag%TYPE;
321: l_allow_duplicate_flag
322: ra_batch_sources_all.allow_duplicate_trx_num_flag%TYPE;
323:
324: BEGIN

Line 322: ra_batch_sources_all.allow_duplicate_trx_num_flag%TYPE;

318:
319: l_temp VARCHAR2(1);
320: l_copy_doc_num_flag ra_batch_sources_all.copy_doc_number_flag%TYPE;
321: l_allow_duplicate_flag
322: ra_batch_sources_all.allow_duplicate_trx_num_flag%TYPE;
323:
324: BEGIN
325:
326: arp_util.debug('arp_trx_validate.validate_trx_number()+');

Line 1546: FROM ra_batch_sources

1542: BEGIN
1543:
1544: SELECT 'invoice date is ok'
1545: INTO l_temp
1546: FROM ra_batch_sources
1547: WHERE batch_source_id = p_batch_source_id
1548: AND p_trx_date BETWEEN NVL(start_date, p_trx_date)
1549: AND NVL(end_date, p_trx_date);
1550: