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.OKS_IB_UTIL_PVT dependencies on ARP_ADDR_LABEL_PKG

Line 1011: , Arp_Addr_Label_Pkg.Format_Address(Null,L.Address1,L.Address2,L.Address3, L.Address4, L.City, L.County, L.State, L.Province, L.Postal_Code, Null, L.Country, Null, Null, Null, Null, Null, Null, Null, 'N', 'N', 300, 1, 1) Address

1007:
1008:
1009: Cursor Check_address_csr(l_site_use_id Number,l_party_id Number, l_account_id number, l_org_id number, l_site_use_code varchar2) Is
1010: Select Cs.Site_Use_Id
1011: , Arp_Addr_Label_Pkg.Format_Address(Null,L.Address1,L.Address2,L.Address3, L.Address4, L.City, L.County, L.State, L.Province, L.Postal_Code, Null, L.Country, Null, Null, Null, Null, Null, Null, Null, 'N', 'N', 300, 1, 1) Address
1012: From Hz_Party_Sites Ps,Hz_Locations L
1013: ,Hz_Cust_Acct_Sites_All Ca,
1014: Hz_Cust_Site_Uses_All Cs
1015: Where Ps.Location_Id = L.Location_Id

Line 2532: Select arp_addr_label_pkg.format_address (NULL,l.address1,l.address2,

2528:
2529: Function Get_address(P_site_use_id Number) return varchar2 Is
2530:
2531: Cursor l_get_address Is
2532: Select arp_addr_label_pkg.format_address (NULL,l.address1,l.address2,
2533: l.address3,l.address4,l.city,l.county,
2534: l.state,l.province,l.postal_code,
2535: NULL,l.country,NULL,NULL,NULL,NULL,
2536: NULL,NULL,NULL,'N','N',300,1,1)