Meddata Teletip Pacs_list Kos Esitleme


MEddata kos gonderilm bilgisine bakarak pacs_list tablosunu güncelleer



--KOD--




DECLARE
TYPE TR IS TABLE OF meddatapacs.KOS_LIST %ROWTYPE;
T TR;
i NUMBER;
BEGIN
i:=1;
SELECT i.* BULK COLLECT INTO T from meddatapacs.KOS_LIST i WHERE i.KOS_SEND_STATUS='S' ;
FOR i IN T.first..T.last
LOOP
UPDATE PACS_LIST r SET R.durumu =T(i).KOS_SEND_STATUS where R.ACCESS_NO =T(i).ACCESS_NO and R.DURUMU='B' ;
commit;
END LOOP;
END;


meddata,pacs,kos_list,pacs_list



Fastreport,meddata,convert,IntToStr

meddata server kurulum,meddata user script,oracle scriptler

meddata,pl sql,kurum bazli indirim,grup bazli indirim

meddata,islemtipi, Check-up,

meddata,icmal,çift kayit

meddata,barkot,fr3

meddata,efatura,efatura programi

medula,dönem sonlandirma,

e fatura kurumlari,efatura kurum bilgileri

meddata,dogum sonrasi muayene,dogum sonrasi gelen hasta

Bizi Takip Edin :