APPS.AR_BR_CANCEL_UNPAID_API_PUB SQL Statements

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

Line: 87

        |   Update BR to UNPAID                 |
        |                                       |
        +=======================================*/
  IF PG_DEBUG in ('Y', 'C') THEN
     arp_standard.debug('CANCEL_OR_UNPAID: ' || '>>> Calling AR_BILLS_MAINTAIN_PUB.unpaid_br');

Line: 128

        |   Update BR to CANCELLED              |
        |                                       |
        +=======================================*/
  IF p_reason IS NOT NULL then
    IF PG_DEBUG in ('Y', 'C') THEN
       arp_standard.debug('CANCEL_OR_UNPAID: ' || '>>> WARNING >>> Cancel_BR requires no reason, Bill '||p_customer_trx_id||' reason not used.');