TRIGGER: APPS.RA_CUSTOMER_TRX_BRU

Source

Description

"APPS"."RA_CUSTOMER_TRX_BRU" 
/* $Header: arplttrx2.sql 120.1 2011/10/28 18:18:09 mraymond noship $ */
BEFORE UPDATE
 ON  "AR"."RA_CUSTOMER_TRX_ALL#"  FOR EACH ROW

Type

BEFORE EACH ROW

Event

UPDATE

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

BEGIN
   IF :new.invoicing_rule_id IS NOT NULL
   AND NVL(:old.complete_flag, 'N') = 'N'
   AND :new.complete_flag = 'Y'
   THEN
      arp_queue.enqueue(system.ar_rev_rec_typ(:new.customer_trx_id,
					  NVL(arp_global.sysparam.org_id, 0),
					  :new.created_from,
					  :new.trx_number));
   END IF;
EXCEPTION
   WHEN OTHERS THEN
      arp_standard.debug( 'Exception:ra_customer_trx_bru');
      arp_standard.debug( 'Not able to enqueue the message');
      RAISE;
END;