APPS.ARP_CTL_SUM_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 6

 |    select_summary                                                         |
 |                                                                           |
 | DESCRIPTION                                                               |
 |    Selects the total trx,tax and freight amount for a given transaction   |
 |                                                                           |
 | SCOPE - PUBLIC                                                            |
 |                                                                           |
 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED                                   |
 |    arp_util.debug                                                         |
 |                                                                           |
 | ARGUMENTS  : IN:                                                          |
 |                    p_customer_trx_id                                      |
 |                    p_line_type                                            |
 |              OUT:                                                         |
 |                    p_amount_total                                         |
 |                    p_amount_total_rtot_db                                 |
 |          IN/ OUT:                                                         |
 |                    None                                                   |
 |                                                                           |
 | RETURNS    : NONE                                                         |
 |                                                                           |
 |                                                                           |
 | NOTES                                                                     |
 |                                                                           |
 | MODIFICATION HISTORY                                                      |
 |     28-DEC-95  Vikas  Mahajan  Created                                    |
 |                                                                           |
 +===========================================================================*/
PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

Line: 36

PROCEDURE select_summary(
   p_customer_trx_id        IN  number,
   p_line_type              IN  varchar2,
   p_amount_total          OUT NOCOPY  number,
   p_amount_total_rtot_db  OUT NOCOPY  number) IS
BEGIN
--   arp_util.debug('arp_ctl_sum_pkg.select_summary()+');

Line: 45

     SELECT NVL( SUM( NVL(extended_amount,  0 ) ), 0),
            NVL( SUM( NVL(extended_amount,  0 ) ), 0)
     INTO   p_amount_total,
            p_amount_total_rtot_db
     FROM   ra_customer_trx_lines
     WHERE  customer_trx_id = p_customer_trx_id;

Line: 52

     SELECT NVL( SUM( NVL(extended_amount,  0 ) ), 0),
            NVL( SUM( NVL(extended_amount,  0 ) ), 0)
     INTO   p_amount_total,
            p_amount_total_rtot_db
     FROM   ra_customer_trx_lines
     WHERE  customer_trx_id = p_customer_trx_id
     AND    line_type       = p_line_type;

Line: 67

END select_summary;

Line: 109

     select_summary( p_customer_trx_id,
                     p_line_type,
                     p_amount_total,
                     p_amount_total_rtot);