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_ASSET_PVT dependencies on ARP_ADDR_LABEL_PKG

Line 4255: 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)

4251: l_site_use_rec l_site_use_csr%ROWTYPE;
4252:
4253: --Cursor to get address for error
4254: Cursor l_address_csr (pty_site_id in number ) is
4255: 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)
4256: from hz_locations hl,
4257: hz_party_sites ps
4258: where hl.location_id = ps.location_id
4259: and ps.party_site_id = pty_site_id;

Line 4262: 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)

4258: where hl.location_id = ps.location_id
4259: and ps.party_site_id = pty_site_id;
4260:
4261: Cursor l_address_csr2 (loc_id in number) is
4262: 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)
4263: from hz_locations hl
4264: where hl.location_id = loc_id;
4265:
4266: l_address varchar2(80);