DBA Data[Home] [Help]

APPS.HZ_CUSTOMER_INT dependencies on ARP_FLEX

Line 1530: l_struct := (replace (replace (replace (arp_flex.expand(arp_flex.location,'ALLREV','.','%QUALIFIER%'),'EXEMPT_LEVEL',null),'TAX_ACCOUNT',null),' ',null));

1526: AND p_postal_code BETWEEN r.from_postal_code AND r.to_postal_code
1527: ;
1528: BEGIN
1529:
1530: l_struct := (replace (replace (replace (arp_flex.expand(arp_flex.location,'ALLREV','.','%QUALIFIER%'),'EXEMPT_LEVEL',null),'TAX_ACCOUNT',null),' ',null));
1531:
1532: l_no_segments := arp_flex.active_segments(arp_flex.location);
1533:
1534: IF l_no_segments = 1 THEN

Line 1532: l_no_segments := arp_flex.active_segments(arp_flex.location);

1528: BEGIN
1529:
1530: l_struct := (replace (replace (replace (arp_flex.expand(arp_flex.location,'ALLREV','.','%QUALIFIER%'),'EXEMPT_LEVEL',null),'TAX_ACCOUNT',null),' ',null));
1531:
1532: l_no_segments := arp_flex.active_segments(arp_flex.location);
1533:
1534: IF l_no_segments = 1 THEN
1535: IF l_struct = 'CITY' THEN
1536: l_child_value := p_city;