APPS.OKS_AUTH_UTIL_PVT dependencies on FND_GLOBAL

Line 672: (NULL,HZ.ADDRESS1,HZ.ADDRESS2,HZ.ADDRESS3,HZ.ADDRESS4,HZ.CITY,HZ.COUNTY,HZ.STATE,HZ.PROVINCE,HZ.POSTAL_CODE,NULL,HZ.COUNTRY,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'N','N',80,1,1),fnd_global.local_chr(10)),1,80)

668:
669: CURSOR l_loc_site_name_csr IS
670: SELECT
671: SUBSTR(replace(arp_addr_label_pkg.format_address
672: (NULL,HZ.ADDRESS1,HZ.ADDRESS2,HZ.ADDRESS3,HZ.ADDRESS4,HZ.CITY,HZ.COUNTY,HZ.STATE,HZ.PROVINCE,HZ.POSTAL_CODE,NULL,HZ.COUNTRY,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'N','N',80,1,1),fnd_global.local_chr(10)),1,80)
673: FROM HZ_LOCATIONS HZ
674: WHERE HZ.LOCATION_ID=p_install_location_id;
675:
676:

Line 680: (NULL,vs.address_line1,vs.address_line2,vs.address_line3,vs.address_line4,vs.city,VS.COUNTY,vs.state,VS.PROVINCE, vs.zip,NULL,VS.COUNTRY,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'N','N',80,1,1),fnd_global.local_chr(10)),1,80)

676:
677: CURSOR l_vendor_site_name_csr IS
678: SELECT
679: SUBSTR(replace(arp_addr_label_pkg.format_address
680: (NULL,vs.address_line1,vs.address_line2,vs.address_line3,vs.address_line4,vs.city,VS.COUNTY,vs.state,VS.PROVINCE, vs.zip,NULL,VS.COUNTRY,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'N','N',80,1,1),fnd_global.local_chr(10)),1,80)
681: FROM PO_VENDOR_SITES_ALL vs
682: WHERE vs.VENDOR_SITE_ID =p_install_location_id;
683:
684:

Line 688: (NULL,hr.address_line_1,hr.address_line_2,hr.address_line_3,null,hr.town_or_city,null,hr.region_2,null,hr.postal_code,NULL,hr.COUNTRY,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'N','N',80,1,1),fnd_global.local_chr(10)),1,80)

684:
685: CURSOR l_int_site_name_csr IS
686: SELECT
687: SUBSTR(replace(arp_addr_label_pkg.format_address
688: (NULL,hr.address_line_1,hr.address_line_2,hr.address_line_3,null,hr.town_or_city,null,hr.region_2,null,hr.postal_code,NULL,hr.COUNTRY,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'N','N',80,1,1),fnd_global.local_chr(10)),1,80)
689: FROM hr_locations hr
690: WHERE hr.LOCATION_ID =p_install_location_id;
691:
692: BEGIN