eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_COPY_CONTRACT_PVT dependencies on ARP_ADDR_LABEL_PKG

Line 19570: SELECT SUBSTR(arp_addr_label_pkg.format_address(NULL,hl.address1,hl.address2,hl.address3, hl.address4,hl.city,hl.county,hl.state,hl.province,hl.postal_code,NULL,hl.country,NULL, NULL,NULL,NULL,NULL,NULL,NULL,'n','n',80,1,1),1,80)

19566: l_site_use_rec l_site_use_csr%ROWTYPE;
19567:
19568: --Cursor to get address for error
19569: CURSOR l_address_csr (pty_site_id IN NUMBER ) IS
19570: SELECT SUBSTR(arp_addr_label_pkg.format_address(NULL,hl.address1,hl.address2,hl.address3, hl.address4,hl.city,hl.county,hl.state,hl.province,hl.postal_code,NULL,hl.country,NULL, NULL,NULL,NULL,NULL,NULL,NULL,'n','n',80,1,1),1,80)
19571: FROM hz_locations hl,
19572: hz_party_sites ps
19573: WHERE hl.location_id = ps.location_id
19574: AND ps.party_site_id = pty_site_id;

Line 19577: SELECT SUBSTR(arp_addr_label_pkg.format_address(NULL,hl.address1,hl.address2,hl.address3, hl.address4,hl.city,hl.county,hl.state,hl.province,hl.postal_code,NULL,hl.country,NULL, NULL,NULL,NULL,NULL,NULL,NULL,'n','n',80,1,1),1,80)

19573: WHERE hl.location_id = ps.location_id
19574: AND ps.party_site_id = pty_site_id;
19575:
19576: CURSOR l_address_csr2 (loc_id IN NUMBER) IS
19577: SELECT SUBSTR(arp_addr_label_pkg.format_address(NULL,hl.address1,hl.address2,hl.address3, hl.address4,hl.city,hl.county,hl.state,hl.province,hl.postal_code,NULL,hl.country,NULL, NULL,NULL,NULL,NULL,NULL,NULL,'n','n',80,1,1),1,80)
19578: FROM hz_locations hl
19579: WHERE hl.location_id = loc_id;
19580:
19581: l_address VARCHAR2(80);