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

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

4743: AND ps.location_id = loc_id;
4744:
4745: --Cursor to get address for error
4746: CURSOR l_address_csr (pty_site_id IN NUMBER ) IS
4747: 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)
4748: FROM hz_locations hl,
4749: hz_party_sites ps
4750: WHERE hl.location_id = ps.location_id
4751: AND ps.party_site_id = pty_site_id;

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

4750: WHERE hl.location_id = ps.location_id
4751: AND ps.party_site_id = pty_site_id;
4752:
4753: CURSOR l_address_csr2 (loc_id IN NUMBER) IS
4754: 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)
4755: FROM hz_locations hl
4756: WHERE hl.location_id = loc_id;
4757:
4758: l_address VARCHAR2(80);

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

5344: AND psu.site_use_type = 'INSTALL_AT'
5345: AND ps.location_id = loc_id;
5346:
5347: CURSOR l_address_csr (pty_site_id IN NUMBER ) IS
5348: 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)
5349: FROM hz_locations hl,
5350: hz_party_sites ps
5351: WHERE hl.location_id = ps.location_id
5352: AND ps.party_site_id = pty_site_id;

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

5351: WHERE hl.location_id = ps.location_id
5352: AND ps.party_site_id = pty_site_id;
5353:
5354: CURSOR l_address_csr2 (loc_id IN NUMBER) IS
5355: 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)
5356: FROM hz_locations hl
5357: WHERE hl.location_id = loc_id;
5358:
5359: l_address VARCHAR2(80);