eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_PROCESS_BR_LINE SQL Statements

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

Line: 6


 |    insert_line							     |
 |                                                                           |
 | DESCRIPTION                                                               |
 |    Inserts a record into ra_customer_trx_lines for bills receivable       |
 |    transaction.			                                     |
 |                                                                           |
 | SCOPE - PUBLIC                                                            |
 |                                                                           |
 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED                                   |
 |    arp_util.debug                                                         |
 |                                                                           |
 | ARGUMENTS  : IN:   p_line_rec					     |
 |              OUT:  p_customer_trx_line_id				     |
 |          IN/ OUT:							     |
 |                                                                           |
 | RETURNS    : NONE                                                         |
 |                                                                           |
 | MODIFICATION HISTORY                                                      |
 |      28-MAR-2000  Jani Rautiainen Created                                 |
 |                                                                           |
 +===========================================================================*/


PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

Line: 31


PROCEDURE insert_line(p_line_rec		IN OUT NOCOPY ra_customer_trx_lines%rowtype,
                      p_customer_trx_line_id    OUT NOCOPY    ra_customer_trx_lines.customer_trx_line_id%type) IS

BEGIN

  IF PG_DEBUG in ('Y', 'C') THEN
     arp_util.debug('arp_process_br_line.insert_line()+');

Line: 52


   |  Call the table handler to insert the line   |
   +----------------------------------------------*/

  arp_ctl_pkg.insert_p( p_line_rec,
                        p_customer_trx_line_id);

Line: 75


     arp_util.debug('arp_process_br_line.insert_line()-');

Line: 81


           arp_util.debug('EXCEPTION:  arp_process_br_line.insert_line()');

Line: 86


END insert_line;

Line: 91


 |    update_line			                                     |
 |                                                                           |
 | DESCRIPTION                                                               |
 |    Updates a ra_customer_trx_lines record for Bills Receivable            |
 |    transaction lines.                                                     |
 |                                                                           |
 | SCOPE - PUBLIC                                                            |
 |                                                                           |
 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED                                   |
 |    arp_util.debug                                                         |
 |                                                                           |
 | ARGUMENTS  : IN:   p_customer_trx_line_id 				     |
 |                    p_line_rec					     |
 |              OUT:                                                         |
 |           IN OUT:                                                         |
 |                                                                           |
 | RETURNS    : NONE                                                         |
 |                                                                           |
 | MODIFICATION HISTORY                                                      |
 |      28-MAR-2000  Jani Rautiainen Created                                 |
 |                                                                           |
 +===========================================================================*/


PROCEDURE update_line(p_customer_trx_line_id  IN     ra_customer_trx_lines.customer_trx_line_id%type,
                      p_line_rec              IN OUT NOCOPY ra_customer_trx_lines%rowtype) IS


BEGIN

  IF PG_DEBUG in ('Y', 'C') THEN
     arp_util.debug('arp_process_br_line.update_line()+');

Line: 138


   |  Call the table handler to update the line  |
   +---------------------------------------------*/

  arp_ctl_pkg.update_p( p_line_rec,
                        p_customer_trx_line_id,
                        NULL);

Line: 163


     arp_util.debug('arp_process_br_line.update_line()-');

Line: 169


       arp_util.debug('EXCEPTION:  arp_process_br_line.update_line()');

Line: 174


END update_line;

Line: 178


 |    delete_line			                                     |
 |                                                                           |
 | DESCRIPTION                                                               |
 |    Deletes records from ra_customer_trx_lines for Bills Receivable        |
 |    transaction lines                                                      |
 |                                                                           |
 | SCOPE - PUBLIC                                                            |
 |                                                                           |
 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED                                   |
 |    arp_util.debug                                                         |
 |                                                                           |
 | ARGUMENTS  : IN:   p_customer_trx_line_id				     |
 |                    p_line_rec 					     |
 |              IN / OUT:                                                    |
 |              OUT:                                                         |
 |                                                                           |
 | RETURNS    : NONE                                                         |
 |                                                                           |
 | MODIFICATION HISTORY                                                      |
 |      28-MAR-2000  Jani Rautiainen Created                                 |
 |                                                                           |
 +===========================================================================*/

PROCEDURE delete_line(p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type,
                      p_customer_trx_id      IN ra_customer_trx.customer_trx_id%type) IS

BEGIN
  IF PG_DEBUG in ('Y', 'C') THEN
     arp_util.debug('arp_process_br_line.delete_line()+');

Line: 221


   |  call the table-handler to delete the line record   |
   +-----------------------------------------------------*/

  arp_ctl_pkg.delete_p( p_customer_trx_line_id );

Line: 242


     arp_util.debug('arp_process_br_line.delete_line()-');

Line: 248


       arp_util.debug('EXCEPTION:  arp_process_br_line.delete_line()');

Line: 249


       arp_util.debug('delete_line: ' || 'p_customer_trx_line_id      = ' || p_customer_trx_line_id);

Line: 253


END delete_line;