1: PACKAGE BODY ARP_TRX_DEFAULTS_2 AS
2: /* $Header: ARTUDF2B.pls 120.5.12010000.1 2008/07/24 16:57:49 appldev ship $ */
3:
4: pg_text_dummy varchar2(10);
5: pg_flag_dummy varchar2(10);
74:
75: BEGIN
76:
77: IF PG_DEBUG in ('Y', 'C') THEN
78: arp_util.debug('arp_trx_defaults_2.get_source_default()+');
79: END IF;
80:
81:
82: IF (p_batch_source_id IS NOT NULL)
132:
133: END IF;
134:
135: IF PG_DEBUG in ('Y', 'C') THEN
136: arp_util.debug('arp_trx_defaults_2.get_source_default()-');
137: END IF;
138:
139: EXCEPTION
140: WHEN OTHERS THEN
138:
139: EXCEPTION
140: WHEN OTHERS THEN
141: IF PG_DEBUG in ('Y', 'C') THEN
142: arp_util.debug('EXCEPTION: arp_trx_defaults_2.get_source_default()');
143: END IF;
144: RAISE;
145:
146: END get_source_default;
269:
270: BEGIN
271:
272: IF PG_DEBUG in ('Y', 'C') THEN
273: arp_util.debug('arp_trx_defaults_2.get_type_defaults()+');
274: END IF;
275:
276:
277: IF (p_cust_trx_type_id IS NOT NULL )
475: END IF; -- p_cust_trx_type_id IS NOT NULL case
476:
477:
478: IF PG_DEBUG in ('Y', 'C') THEN
479: arp_util.debug('arp_trx_defaults_2.get_type_defaults()-');
480: END IF;
481:
482: EXCEPTION
483: WHEN NO_DATA_FOUND THEN NULL;
482: EXCEPTION
483: WHEN NO_DATA_FOUND THEN NULL;
484: WHEN OTHERS THEN
485: IF PG_DEBUG in ('Y', 'C') THEN
486: arp_util.debug('EXCEPTION: arp_trx_defaults_2.get_type_defaults()');
487: END IF;
488: RAISE;
489:
490: END get_type_defaults;
509: END init;
510:
511: BEGIN
512: init;
513: END ARP_TRX_DEFAULTS_2;