[Home] [Help]
809: l_vendor_site_id VARCHAR2(1);
810: l_row_not_found BOOLEAN := FALSE;
811: CURSOR c1(p_vendor_site_id NUMBER) IS
812: SELECT '1'
813: FROM ap_supplier_sites
814: WHERE vendor_site_id = p_vendor_site_id ;
815: BEGIN
816: IF ( p_vendor_site_id IS NOT NULL) THEN
817: -- initialize return status