DBA Data[Home] [Help]

APPS.ARP_ALLOCATION_PKG dependencies on RA_AR_GT

Line 926: arp_standard.debug('Exceeded upper limit for maximum number of rows in ra_ar_gt');

922: * periodically delete the data from GT tables for every 1000 applications*
923: * for a receipt. * */
924: IF arp_det_dist_pkg.g_appln_count >= PG_DEL_FRM_GT_CNT THEN
925: IF PG_DEBUG in ('Y', 'C') THEN
926: arp_standard.debug('Exceeded upper limit for maximum number of rows in ra_ar_gt');
927: arp_standard.debug('PG_DEL_FRM_GT_CNT : ' || PG_DEL_FRM_GT_CNT);
928: arp_standard.debug('Clear all gt tables');
929: END IF;
930:

Line 939: DELETE FROM ra_ar_gt;

935: l_cnt := sql%rowcount;
936: arp_standard.debug('No of rows deleted from ra_customer_trx_lines_gt : '||l_cnt);
937: END IF;
938:
939: DELETE FROM ra_ar_gt;
940: IF PG_DEBUG in ('Y', 'C') THEN
941: l_cnt := SQL%ROWCOUNT;
942: arp_standard.debug('No of rows deleted from ra_ar_gt : '||l_cnt);
943: END IF;

Line 942: arp_standard.debug('No of rows deleted from ra_ar_gt : '||l_cnt);

938:
939: DELETE FROM ra_ar_gt;
940: IF PG_DEBUG in ('Y', 'C') THEN
941: l_cnt := SQL%ROWCOUNT;
942: arp_standard.debug('No of rows deleted from ra_ar_gt : '||l_cnt);
943: END IF;
944:
945: DELETE FROM ra_ar_amounts_gt;
946: IF PG_DEBUG in ('Y', 'C') THEN