DBA Data[Home] [Help]

APPS.RA_ADDRESSES_BRIU dependencies on ARP_STANDARD

Line 13: arp_standard.debug('T> RA_ADDRESSES_BRIU: ' || :new.address_id);

9: -- IF as_disco_addr_validation.ra_addresses_all(:new.address_id,
10: -- :new.org_id,
11: -- :new.last_updated_by) THEN
12: IF arp_adds.triggers_enabled THEN
13: arp_standard.debug('T> RA_ADDRESSES_BRIU: ' || :new.address_id);
14: IF ( :new.status <> 'I' ) THEN
15: /* IF IT'S Inactive address, then no location id */
16: IF ( :new.customer_id <> -1 ) THEN
17: /* IF IT'S A REMIT TO ADDRESS, THEN NO SALES TAX */

Line 18: IF ( :new.country = arp_standard.sysparm.default_country ) THEN

14: IF ( :new.status <> 'I' ) THEN
15: /* IF IT'S Inactive address, then no location id */
16: IF ( :new.customer_id <> -1 ) THEN
17: /* IF IT'S A REMIT TO ADDRESS, THEN NO SALES TAX */
18: IF ( :new.country = arp_standard.sysparm.default_country ) THEN
19: /* IF NULL THEN WE HAVE NO SALES TAX */
20: IF ( ( :new.location_id is null )
21: OR ( nvl( :new.country, 'NULL' ) <>
22: nvl( :old.country, 'NULL' ) )

Line 113: arp_standard.debug( 'T< RA_ADDRESSES_BRIU: ' ||

109: IF ( :new.location_id is not null ) THEN
110: :new.location_id := null;
111: END IF;
112: END IF;
113: arp_standard.debug( 'T< RA_ADDRESSES_BRIU: ' ||
114: :new.address_id || ' ' || :new.location_id );
115: END IF; /* Triggers enabled */
116: -- END IF; /* OSM has disabled address validation */
117: END;