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 4775: 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)

4771: AND ps.location_id = loc_id;
4772:
4773: --Cursor to get address for error
4774: CURSOR l_address_csr (pty_site_id IN NUMBER ) IS
4775: 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)
4776: FROM hz_locations hl,
4777: hz_party_sites ps
4778: WHERE hl.location_id = ps.location_id
4779: AND ps.party_site_id = pty_site_id;

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

4778: WHERE hl.location_id = ps.location_id
4779: AND ps.party_site_id = pty_site_id;
4780:
4781: CURSOR l_address_csr2 (loc_id IN NUMBER) IS
4782: 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)
4783: FROM hz_locations hl
4784: WHERE hl.location_id = loc_id;
4785:
4786: l_address VARCHAR2(80);

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

5372: AND psu.site_use_type = 'INSTALL_AT'
5373: AND ps.location_id = loc_id;
5374:
5375: CURSOR l_address_csr (pty_site_id IN NUMBER ) IS
5376: 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)
5377: FROM hz_locations hl,
5378: hz_party_sites ps
5379: WHERE hl.location_id = ps.location_id
5380: AND ps.party_site_id = pty_site_id;

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

5379: WHERE hl.location_id = ps.location_id
5380: AND ps.party_site_id = pty_site_id;
5381:
5382: CURSOR l_address_csr2 (loc_id IN NUMBER) IS
5383: 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)
5384: FROM hz_locations hl
5385: WHERE hl.location_id = loc_id;
5386:
5387: l_address VARCHAR2(80);