The following lines contain the word 'select', 'insert', 'update' or 'delete':
| 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;
arp_util.debug('arp_process_invoice.header_post_insert()+');
arp_ctls_pkg.insert_p(l_srep_rec,
l_cust_trx_line_salesrep_id);
arp_util.debug('arp_process_invoice.header_post_insert()-');
arp_util.debug('EXCEPTION: arp_process_invoice.header_post_insert()');
| 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()+');
arp_util.debug('arp_process_invoice.tax_post_update()-');
arp_util.debug('EXCEPTION: arp_process_invoice.tax_post_update()');
| 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;
arp_util.debug('arp_process_invoice.freight_post_update()+');
arp_util.debug('arp_process_invoice.freight_post_update()-');
arp_util.debug('EXCEPTION: arp_process_invoice.freight_post_update()');