22: | |
23: | SCOPE - PRIVATE |
24: | |
25: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
26: | arp_util.debug |
27: | |
28: | ARGUMENTS : IN: |
29: | p_batch_source_id |
30: | p_ctt_class |
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;
156: | |
157: | SCOPE - PRIVATE |
158: | |
159: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
160: | arp_util.debug |
161: | |
162: | ARGUMENTS : IN: |
163: | p_cust_trx_type_id |
164: | p_trx_date |
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;