APPS.AR_AUTOREC_API dependencies on ARP_RW_BATCHES_PKG

Line 646: l_batch_lock_flag := ARP_RW_BATCHES_PKG.request_lock(o_batch_id ,l_batch_lock_msg);

642:
643: /*lock the batch record to prevent multiple submissions for the same batch while a request
644: is running.In case the request is spanned from master process,master will hold the lock*/
645: IF l_total_workers = 0 AND p_approve_flag = 'Y' THEN
646: l_batch_lock_flag := ARP_RW_BATCHES_PKG.request_lock(o_batch_id ,l_batch_lock_msg);
647:
648: IF l_batch_app_status = 'STARTED_APPROVAL' THEN
649: process_incomplete_receipts( o_batch_id );
650: END IF;

Line 812: ARP_RW_BATCHES_PKG.release_lock(o_batch_id ,l_batch_lock_msg);

808: where batch_id = o_batch_id;
809:
810: --release the lock on batch record
811: l_batch_lock_flag :=
812: ARP_RW_BATCHES_PKG.release_lock(o_batch_id ,l_batch_lock_msg);
813:
814: IF PG_DEBUG in ('Y','C')
815: THEN
816: arp_debug.debug('Releasing lock - ' || l_batch_lock_msg);

Line 899: l_batch_lock_flag := ARP_RW_BATCHES_PKG.release_lock(o_batch_id ,l_batch_lock_msg);

895:
896: IF p_approve_flag = 'Y'
897: THEN
898: /* release the lock */
899: l_batch_lock_flag := ARP_RW_BATCHES_PKG.release_lock(o_batch_id ,l_batch_lock_msg);
900:
901: IF PG_DEBUG in ('Y','C')
902: THEN
903: arp_debug.debug('Releasing lock - ' || l_batch_lock_msg);

Line 1180: l_batch_lock_flag := ARP_RW_BATCHES_PKG.request_lock(o_batch_id ,l_batch_lock_msg);

1176: END IF;
1177:
1178: /*lock the batch record to prevent multiple submissions for the same batch while a request
1179: is running.In case the request is spanned from master process,master will hold the lock*/
1180: l_batch_lock_flag := ARP_RW_BATCHES_PKG.request_lock(o_batch_id ,l_batch_lock_msg);
1181:
1182: IF l_batch_lock_flag = FALSE THEN
1183: RAISE l_batch_lock_excp;
1184: END IF;

Line 1323: l_batch_lock_flag := ARP_RW_BATCHES_PKG.release_lock( o_batch_id, l_batch_lock_msg);

1319: delete
1320: from ar_autorec_interim
1321: where batch_id = o_batch_id;
1322:
1323: l_batch_lock_flag := ARP_RW_BATCHES_PKG.release_lock( o_batch_id, l_batch_lock_msg);
1324:
1325: fnd_file.put_line( FND_FILE.LOG, 'submit_autorec_parallel()-');
1326:
1327: EXCEPTION

Line 1337: ARP_RW_BATCHES_PKG.release_lock(o_batch_id ,l_batch_lock_msg);

1333: where batch_id = o_batch_id;
1334:
1335: --release the lock on batch record
1336: l_batch_lock_flag :=
1337: ARP_RW_BATCHES_PKG.release_lock(o_batch_id ,l_batch_lock_msg);
1338:
1339: IF PG_DEBUG in ('Y','C')
1340: THEN
1341: arp_debug.debug('Releasing lock - ' || l_batch_lock_msg);

Line 1432: arp_rw_batches_pkg.insert_auto_batch(

1428: l_batch_rec.exchange_date := p_exchange_date;
1429: l_batch_rec.exchange_rate := p_exchange_rate;
1430: l_batch_rec.exchange_rate_type := p_exchange_rate_type;
1431:
1432: arp_rw_batches_pkg.insert_auto_batch(
1433: l_row_id,
1434: l_batch_id,
1435: l_batch_rec.batch_date,
1436: l_batch_rec.currency_code,