APPS.ARP_RUN SQL Statements

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

Line: 17

  SELECT
     DISTINCT ctl.customer_trx_id,
     ct.trx_number
  FROM
     ra_customer_trx ct,
     ra_customer_trx_lines ctl
  WHERE
     ctl.autorule_complete_flag = 'N'
  AND ct.customer_trx_id         = ctl.customer_trx_id
  AND ct.complete_flag           = 'Y';

Line: 75

   select org_id
   into l_org_id
   from ar_system_parameters;

Line: 330

      l_req_status_tab.DELETE;

Line: 431

  select org_id
  into l_org_id
  from ar_system_parameters;

Line: 484

   when crediting invoices with rules.  The procedure will delete
   all non-posted REV/UNEARN/UNBILL lines (non-model ones).  It will
   then call the arp_credit_memo_module.credit_transactions function
   to rebuild them (correctly) based on the invoice's distributions. */

PROCEDURE build_credit_distributions (errbuf             OUT NOCOPY VARCHAR2,
			              retcode            OUT NOCOPY NUMBER,
                                      p_customer_trx_id  IN NUMBER,
                                      p_prev_trx_id      IN NUMBER) AS

   l_failure_count NUMBER;