671:
672: rowcount NUMBER ;
673: l_display_name VARCHAR2(2000); -- 4915711 --
674: j NUMBER;
675: l_uom_desc OKx_UNITS_OF_MEASURE_v.unit_of_measure_tl%TYPE;
676:
677: CURSOR l_site_name_csr(l_install_site_id NUMBER) IS
678: SELECT S.DESCRIPTION
679: FROM OKX_PARTY_SITES_V S
681:
682: CURSOR l_csr_uom_desc(p_uom_code IN VARCHAR2)
683: IS
684: SELECT unit_of_measure_tl
685: FROM OKX_UNITS_OF_MEASURE_V
686: WHERE uom_code = p_uom_code ;
687:
688:
689: l_gen_name OKX_SYSTEM_ITEMS_V.name%TYPE;