695: IS
696: l_formatted_address VARCHAR2(32000);
697:
698: BEGIN
699: FOR x IN (SELECT ARP_ADDR_LABEL_PKG.FORMAT_ADDRESS_LABEL(
700: Null,
701: CUSTOMER_ADDRESS1,
702: CUSTOMER_ADDRESS2,
703: CUSTOMER_ADDRESS3,
752: IS
753: l_formatted_address VARCHAR2(32000);
754:
755: BEGIN
756: FOR x IN (SELECT ARP_ADDR_LABEL_PKG.FORMAT_ADDRESS_LABEL(
757: Null,
758: a.ADDRESS1,
759: a.ADDRESS2,
760: a.ADDRESS3,
812: IS
813: l_formatted_address VARCHAR2(32000);
814:
815: BEGIN
816: FOR x IN (SELECT ARP_ADDR_LABEL_PKG.FORMAT_ADDRESS_LABEL(
817: Null,
818: ADDRESS1,
819: ADDRESS2,
820: ADDRESS3,