885: l_asset_vendor_id VARCHAR2(1);
886: l_row_not_found BOOLEAN := FALSE;
887: CURSOR c1(p_asset_vendor_id NUMBER) IS
888: SELECT '1' 889: FROM ap_suppliers 890: WHERE vendor_id = p_asset_vendor_id ;
891: BEGIN
892: IF ( p_asset_vendor_id IS NOT NULL) THEN
893: -- initialize return status