1: PACKAGE BODY AR_BLK_INSRT_TRX_LINE as
2: /* $Header: ARTXBLKB.pls 120.2 2005/06/14 18:52:57 vcrisost noship $ */
3:
4:
5: PROCEDURE bulk_insert_cust_trx_lines (
132: p_cntr number := 0;
133:
134: BEGIN
135:
136: arp_standard.debug('AR_BLK_INSRT_TRX_LINE.AR_BLK_INSRT_TRX_LINE(+) ');
137:
138: IF p_customer_trx_line_id.count <> 0 then
139: forall i in p_customer_trx_line_id.first..p_customer_trx_line_id.last
140: INSERT INTO ra_customer_trx_lines (customer_trx_line_id,
385: arp_standard.sysparm.org_id);
386: p_cntr := p_cntr + 1;
387: end if;
388:
389: arp_standard.debug('AR_BLK_INSRT_TRX_LINE.number of records: '||to_char(p_cntr));
390:
391: arp_standard.debug('AR_BLK_INSRT_TRX_LINE.bulk_insert_cust_trx_lines(-) ');
392:
393: EXCEPTION
387: end if;
388:
389: arp_standard.debug('AR_BLK_INSRT_TRX_LINE.number of records: '||to_char(p_cntr));
390:
391: arp_standard.debug('AR_BLK_INSRT_TRX_LINE.bulk_insert_cust_trx_lines(-) ');
392:
393: EXCEPTION
394: WHEN OTHERS THEN
395: arp_standard.debug('EXCEPTION: bulk_insert_trx_lines()');
521: arp_standard.debug('EXCEPTION: bulk_insert_trx_lines()');
522: RAISE;
523:
524: END;
525: END AR_BLK_INSRT_TRX_LINE;
526: