APPS.ARP_CTL_SUM_PKG dependencies on ARP_CTL_SUM_PKG

Line 1: PACKAGE BODY ARP_CTL_SUM_PKG AS

1: PACKAGE BODY ARP_CTL_SUM_PKG AS
2: /* $Header: ARTUCTLB.pls 115.4 2003/10/10 14:29:29 mraymond ship $ */
3:
4: /*===========================================================================+
5: | PROCEDURE |

Line 42: -- arp_util.debug('arp_ctl_sum_pkg.select_summary()+');

38: p_line_type IN varchar2,
39: p_amount_total OUT NOCOPY number,
40: p_amount_total_rtot_db OUT NOCOPY number) IS
41: BEGIN
42: -- arp_util.debug('arp_ctl_sum_pkg.select_summary()+');
43: if ( p_line_type = 'ALL')
44: THEN
45: SELECT NVL( SUM( NVL(extended_amount, 0 ) ), 0),
46: NVL( SUM( NVL(extended_amount, 0 ) ), 0)

Line 60: -- arp_util.debug('arp_ctl_sum_pkg.select_summary()-');

56: FROM ra_customer_trx_lines
57: WHERE customer_trx_id = p_customer_trx_id
58: AND line_type = p_line_type;
59:
60: -- arp_util.debug('arp_ctl_sum_pkg.select_summary()-');
61: END IF;
62: EXCEPTION
63: WHEN OTHERS THEN
64: -- arp_util.debug('EXCEPTION: arp_ctl_sum_pkg.select_summary()');

Line 64: -- arp_util.debug('EXCEPTION: arp_ctl_sum_pkg.select_summary()');

60: -- arp_util.debug('arp_ctl_sum_pkg.select_summary()-');
61: END IF;
62: EXCEPTION
63: WHEN OTHERS THEN
64: -- arp_util.debug('EXCEPTION: arp_ctl_sum_pkg.select_summary()');
65: RAISE;
66:
67: END select_summary;
68:

Line 107: -- arp_util.debug('arp_ctl_sum_pkg.geT_summary()+');

103: p_amount_total NUMBER;
104: p_amount_total_rtot NUMBER;
105: BEGIN
106:
107: -- arp_util.debug('arp_ctl_sum_pkg.geT_summary()+');
108:
109: select_summary( p_customer_trx_id,
110: p_line_type,
111: p_amount_total,

Line 114: -- arp_util.debug('arp_ctl_sum_pkg.get_summary()-');

110: p_line_type,
111: p_amount_total,
112: p_amount_total_rtot);
113:
114: -- arp_util.debug('arp_ctl_sum_pkg.get_summary()-');
115: return p_amount_total;
116:
117: EXCEPTION
118:

Line 120: -- arp_util.debug('EXCEPTION: arp_ctl_sum_pkg.get_summary()');

116:
117: EXCEPTION
118:
119: WHEN OTHERS THEN
120: -- arp_util.debug('EXCEPTION: arp_ctl_sum_pkg.get_summary()');
121: RAISE;
122:
123: END get_summary;
124:

Line 126: END ARP_CTL_SUM_PKG;

122:
123: END get_summary;
124:
125:
126: END ARP_CTL_SUM_PKG;