APPS.ARP_PROCESS_INVOICE SQL Statements

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

Line: 6

 |    header_post_insert                                                     |
 |                                                                           |
 | DESCRIPTION                                                               |
 |    Header post-insert logic for invoices                                  |
 |                                                                           |
 | SCOPE - PRIVATE                                                           |
 |                                                                           |
 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED                                   |
 |    dbms_sql.bind_variable                                                 |
 |    arp_util.debug                                                         |
 |                                                                           |
 | ARGUMENTS  : IN:                                                          |
 |              OUT:                                                         |
 | RETURNS    : NONE                                                         |
 |                                                                           |
 | NOTES                                                                     |
 |                                                                           |
 | MODIFICATION HISTORY                                                      |
 |     12-JUL-95  Martin Johnson      Created                                |
 |                                                                           |
 +===========================================================================*/

PROCEDURE header_post_insert (p_primary_salesrep_id IN
                                ra_customer_trx.primary_salesrep_id%type,
                              p_customer_trx_id IN
                                ra_customer_trx.customer_trx_id%type,
                              p_create_default_sc_flag IN varchar2 DEFAULT 'Y'
                             )

IS

  l_srep_rec     ra_cust_trx_line_salesreps%rowtype;

Line: 44

   arp_util.debug('arp_process_invoice.header_post_insert()+');

Line: 57

       arp_ctls_pkg.insert_p(l_srep_rec,
                             l_cust_trx_line_salesrep_id);

Line: 61

   arp_util.debug('arp_process_invoice.header_post_insert()-');

Line: 65

     arp_util.debug('EXCEPTION:  arp_process_invoice.header_post_insert()');

Line: 72

 |    tax_post_update                                                        |
 |                                                                           |
 | DESCRIPTION                                                               |
 |    Tax post-update logic for invoices                                     |
 |                                                                           |
 | SCOPE - PRIVATE                                                           |
 |                                                                           |
 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED                                   |
 |    dbms_sql.bind_variable                                                 |
 |    arp_util.debug                                                         |
 |                                                                           |
 | ARGUMENTS  : IN:                                                          |
 |              OUT:                                                         |
 | RETURNS    : NONE                                                         |
 |                                                                           |
 | NOTES                                                                     |
 |                                                                           |
 | MODIFICATION HISTORY                                                      |
 |     12-JUL-95  Martin Johnson      Created                                |
 |                                                                           |
 +===========================================================================*/

PROCEDURE tax_post_update IS

BEGIN

   arp_util.debug('arp_process_invoice.tax_post_update()+');

Line: 100

   arp_util.debug('arp_process_invoice.tax_post_update()-');

Line: 104

     arp_util.debug('EXCEPTION:  arp_process_invoice.tax_post_update()');

Line: 111

 |    freight_post_update                                                    |
 |                                                                           |
 | DESCRIPTION                                                               |
 |    Freight post-update logic for invoices                                 |
 |                                                                           |
 | SCOPE - PRIVATE                                                           |
 |                                                                           |
 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED                                   |
 |    dbms_sql.bind_variable                                                 |
 |    arp_util.debug                                                         |
 |                                                                           |
 | ARGUMENTS  : IN:                                                          |
 |                p_frt_rec                                                  |
 |                p_gl_date                                                  |
 |                p_frt_ccid                                                 |
 |              OUT:                                                         |
 |                p_status                                                   |
 | RETURNS    : NONE                                                         |
 |                                                                           |
 | NOTES                                                                     |
 |                                                                           |
 | MODIFICATION HISTORY                                                      |
 |     12-JUL-95  Martin Johnson      Created                                |
 |                                                                           |
 +===========================================================================*/

PROCEDURE freight_post_update(
  p_frt_rec               IN ra_customer_trx_lines%rowtype,
  p_gl_date               IN ra_cust_trx_line_gl_dist.gl_date%type,
  p_frt_ccid              IN
                           ra_cust_trx_line_gl_dist.code_combination_id%type,
  p_status                OUT NOCOPY varchar2)
IS
  l_ccid
                        ra_cust_trx_line_gl_dist.code_combination_id%type;

Line: 153

   arp_util.debug('arp_process_invoice.freight_post_update()+');

Line: 188

   arp_util.debug('arp_process_invoice.freight_post_update()-');

Line: 192

     arp_util.debug('EXCEPTION:  arp_process_invoice.freight_post_update()');