CREATE OR REPLACE PACKAGE "MAIN"."B2B_WEB" AS
TYPE T_CURSOR IS REF CURSOR;
--Reyon Bilgileri Al Reyon no parametreli  (SOZTEMIR /24.08.2015)
PROCEDURE REYONBILGILERI (P_SIRKET IN NUMBER,P_REYON IN NUMBER,P_MUSNO IN VARCHAR2,P_TALINO IN VARCHAR2,CUR_RETURN OUT T_CURSOR);

--Ay Bilgileri Sorgusu  (SOZTEMIR /24.08.2015)
PROCEDURE AYBILGILERI (CUR_RETURN OUT T_CURSOR);

--Reyon Bilgileri Hepsi  (SOZTEMIR /24.08.2015)
PROCEDURE REYONBILGILERIHEPSI (P_SIRKET IN NUMBER,P_MUSNO IN VARCHAR2,P_TALINO IN VARCHAR2,CUR_RETURN OUT T_CURSOR);

--Bolge  Bilgileri sorgusu (SOZTEMIR /24.08.2015)
PROCEDURE MAGAZABILGILERI (P_SIRKET IN NUMBER,P_BOLGENO IN NUMBER,P_MUSNO IN VARCHAR2,P_TALINO IN VARCHAR2,CUR_RETURN OUT T_CURSOR);

--Magaza Bilgileri sorgusu bolgeno Parametreli  (SOZTEMIR /24.08.2015)
PROCEDURE BOLGEBILGILERI (P_SIRKET IN NUMBER,P_MUSNO IN VARCHAR2,P_TALINO IN VARCHAR2,CUR_RETURN OUT T_CURSOR);

--Urun Bilgileri Reyon Bazli Reyon no parametreli (SOZTEMIR /24.08.2015)
PROCEDURE URUNBILGILERIREYON (P_SIRKET IN NUMBER,P_REYON IN NUMBER,P_MUSNO IN VARCHAR2,P_TALINO IN VARCHAR2,CUR_RETURN OUT T_CURSOR);

--Hareket Tipleri Sorgusu (SOZTEMIR /24.08.2015)
PROCEDURE HAREKETTIPLERI (CUR_RETURN OUT T_CURSOR);

--Siparis Karsilama ekraninin master sorgusu(SOZTEMIR /24.08.2015)
PROCEDURE KARSILANANMASTER (P_MUSNO IN VARCHAR2,P_TALINO IN VARCHAR2,P_YIL IN VARCHAR2,CUR_RETURN OUT T_CURSOR);
--Siparis Karsilama ekraninin detay sorgusu,sipno ve birimno parametre olarak geliyor(SOZTEMIR /24.08.2015)
PROCEDURE KARSILANANDETAY (P_SIPNO IN VARCHAR2,P_MAGAZANO IN NUMBER,P_MUSNO IN VARCHAR2,P_TALINO IN VARCHAR2,P_YIL IN VARCHAR2,CUR_RETURN OUT T_CURSOR);
--Yil bazinda firma alis ve satislari icin sorgu(SOZTEMIR /24.08.2015)
PROCEDURE FIRMAISTATISTIK (P_SIRKET IN NUMBER,P_OLD_YIL IN NUMBER,P_NEW_YIL IN NUMBER,P_MUSNO IN VARCHAR2,P_TALINO IN VARCHAR2,CUR_RETURN OUT T_CURSOR);
--Magaza Genel Istatistik sorgusu(SOZTEMIR /24.08.2015)
PROCEDURE MAGAZAISTATISTIK (P_SIRKET IN NUMBER,P_YIL IN NUMBER,P_MUSNO IN VARCHAR2,P_TALINO IN VARCHAR2,CUR_RETURN OUT T_CURSOR);
--Magaza Istatiksikleri Detay Sorgusu, BIRIMNO Parametre aliyor. (SOZTEMIR /24.08.2015)
PROCEDURE MAGAZAISTATISTIK_DETAY (P_SIRKET IN NUMBER,P_BIRIMNO IN NUMBER,P_YIL IN NUMBER,P_MUSNO IN VARCHAR2,P_TALINO IN VARCHAR2,CUR_RETURN OUT T_CURSOR);
--En coksatan urun listesi. (SOZTEMIR /24.08.2015)
PROCEDURE ENCOKSATAN (P_SIRKET IN NUMBER,P_YIL IN NUMBER,P_AY IN NUMBER,P_MUSNO IN VARCHAR2,P_TALINO IN VARCHAR2,CUR_RETURN OUT T_CURSOR);
--Online Ciro Magaza Bazinda (SOZTEMIR /24.08.2015)
PROCEDURE ONLINECIRO (P_SIRKET IN NUMBER,P_YIL IN NUMBER,P_MUSNO IN VARCHAR2,P_TALINO IN VARCHAR2,CUR_RETURN OUT T_CURSOR);

--Onaylanmis siparisleri topluyoruz (Count) (SOZTEMIR /24.08.2015)
PROCEDURE ONAYLANMIS_SIPARIS_COUNT (P_SIRKET IN NUMBER,P_YIL IN NUMBER,P_SIPGUN IN NUMBER,P_MUSNO IN VARCHAR2,P_TALINO IN VARCHAR2,CUR_RETURN OUT T_CURSOR);

--Onay Bekleyen siparisleri topluyoruz (Count) (SOZTEMIR /24.08.2015)
PROCEDURE ONAY_BEKLEYEN_SIPARIS_COUNT (P_SIRKET IN NUMBER,P_YIL IN NUMBER,P_SIPGUN IN NUMBER,P_MUSNO IN VARCHAR2,P_TALINO IN VARCHAR2,CUR_RETURN OUT T_CURSOR);

--Onaylanmis Siparislarin Master Ekran sorgusu  (SOZTEMIR /24.08.2015)
PROCEDURE ONAYLANMIS_SIPARISLER_MASTER (P_SIRKET IN NUMBER,P_YIL IN NUMBER,P_SIPGUN IN NUMBER,P_MUSNO IN VARCHAR2,P_TALINO IN VARCHAR2,CUR_RETURN OUT T_CURSOR);

--Onaylanmis Siparis Tarih Bazli Sorgusu  (SOZTEMIR /24.08.2015)
PROCEDURE ONAYLANMIS_SIPARISLER_DETAY (P_SIRKET IN NUMBER,P_BIRIMNO IN NUMBER,P_SIPNO IN NUMBER,P_MUSNO IN VARCHAR2,P_TALINO IN VARCHAR2,CUR_RETURN OUT T_CURSOR) ;

--Onaylanmis Siparislarin Master Ekran sorgusu  (SOZTEMIR /24.08.2015)
PROCEDURE ONAYLANMIS_SIPARISLER_TARIH (P_SIRKET IN NUMBER,P_YIL IN NUMBER,P_BIRIMNO IN NUMBER,P_T1 IN DATE,P_T2 IN DATE,P_MUSNO IN VARCHAR2,P_TALINO IN VARCHAR2,CUR_RETURN OUT T_CURSOR);

--Siparis Onaylayan Satinalamaci Bilgileri  (SOZTEMIR /24.08.2015)
PROCEDURE ONAYLAYAN_SATINALACI (P_SIRKET IN NUMBER,P_BIRIMNO IN NUMBER,P_SIPNO IN NUMBER,P_MUSNO IN VARCHAR2,P_TALINO IN VARCHAR2,CUR_RETURN OUT T_CURSOR);

--Depo ve Magaza Iade depolari Master  (SOZTEMIR /24.08.2015)
PROCEDURE IADE_DEPOLARI (P_SIRKET IN NUMBER,P_YIL IN NUMBER,P_MUSNO IN VARCHAR2,P_TALINO IN VARCHAR2,CUR_RETURN OUT T_CURSOR);

--Depo ve Magaza Iade depolari Detay  (SOZTEMIR /24.08.2015)
PROCEDURE IADE_DEPOLARI_DETAY (P_SIRKET IN NUMBER,P_BIRIMNO IN NUMBER,P_YIL IN NUMBER,P_MUSNO IN VARCHAR2,P_TALINO IN VARCHAR2,CUR_RETURN OUT T_CURSOR);

--Cari Borc Alacak Detay Sayfasi (SOZTEMIR /24.08.2015)
PROCEDURE CARI_BORC_ALACAK (P_SIRKET IN NUMBER,P_YIL IN NUMBER,P_MUSNO IN VARCHAR2,P_TALINO IN VARCHAR2,CUR_RETURN OUT T_CURSOR);

--Cari Borc Alacak Ana Ekran Master  (SOZTEMIR /24.08.2015)
PROCEDURE CARI_BORC_ALACAK_DETAY (P_SIRKET IN NUMBER,P_YIL IN NUMBER,P_MUSNO IN VARCHAR2,P_TALINO IN VARCHAR2,CUR_RETURN OUT T_CURSOR);

--Satis Tarih bazli ve magaza parametreli (SOZTEMIR /24.08.2015)
PROCEDURE SATISTARIHBAZLI (P_SIRKET IN NUMBER,P_YIL IN NUMBER,P_BIRIMNO IN NUMBER,P_T1 IN DATE,P_T2 IN DATE,P_MUSNO IN VARCHAR2,P_TALINO IN VARCHAR2,CUR_RETURN OUT T_CURSOR);

--Satis Tarih bazli ve magaza parametreli ve urun (SOZTEMIR /24.08.2015)
PROCEDURE SATISTARIHBAZLIURUN (P_SIRKET IN NUMBER,P_YIL IN NUMBER,P_BIRIMNO IN NUMBER,P_EMTIANO IN VARCHAR2,P_T1 IN DATE,P_T2 IN DATE,P_MUSNO IN VARCHAR2,P_TALINO IN VARCHAR2,CUR_RETURN OUT T_CURSOR);

--Satis Tarih bazli reyon parametreli (SOZTEMIR /24.08.2015)
PROCEDURE SATISTARIHBAZLIREYON (P_SIRKET IN NUMBER,P_YIL IN NUMBER,P_BIRIMNO IN NUMBER,P_REYON IN VARCHAR2,P_T1 IN DATE,P_T2 IN DATE,P_MUSNO IN VARCHAR2,P_TALINO IN VARCHAR2,CUR_RETURN OUT T_CURSOR);

--Ay BazindaSatis Sorgusu (SOZTEMIR /24.08.2015)
PROCEDURE AYBAZINDASATIS (P_SIRKET IN NUMBER,P_YIL IN NUMBER,P_BIRIMNO IN NUMBER,P_A1 IN NUMBER,P_A2 IN NUMBER,P_MUSNO IN VARCHAR2,P_TALINO IN VARCHAR2,CUR_RETURN OUT T_CURSOR);

--Satis Ay Bazinda Tutarsal ve Miktarsal Satis Sorgusu (SOZTEMIR /24.08.2015)
PROCEDURE SATISAYBAZLIMATRIS (P_VALUE IN NUMBER,P_SIRKET IN NUMBER,P_YIL IN NUMBER,P_BIRIMNO IN NUMBER,P_MUSNO IN VARCHAR2,P_TALINO IN VARCHAR2,CUR_RETURN OUT T_CURSOR);

--Hareket Tipine gore sorgu (SOZTEMIR /24.08.2015)
PROCEDURE HAREKETTIPIBAZINDA (P_SIRKET IN NUMBER,P_YIL IN NUMBER,P_BIRIMNO IN NUMBER,P_HARTIP IN NUMBER,P_T1 IN DATE,P_T2 IN DATE,P_MUSNO IN VARCHAR2,P_TALINO IN VARCHAR2,CUR_RETURN OUT T_CURSOR);

--Stok Raporu magaza ve depoya gore sorgu (SOZTEMIR /25.08.2015)
PROCEDURE SONSTOK (P_SIRKET IN NUMBER,P_YIL IN NUMBER,P_BIRIMNO IN NUMBER,P_DURUM IN NUMBER,P_REYON IN NUMBER,P_MUSNO IN VARCHAR2,P_TALINO IN VARCHAR2,CUR_RETURN OUT T_CURSOR);

--Urun Aktif Pasif Sorgusu (SOZTEMIR /25.08.2015)
PROCEDURE AKTIFPASIF (P_SIRKET IN NUMBER,P_YIL IN NUMBER,P_MUSNO IN VARCHAR2,P_TALINO IN VARCHAR2,CUR_RETURN OUT T_CURSOR);

--Miktar ve tutar bazinda toplam stok (SOZTEMIR /25.08.2015)
PROCEDURE URUNTOPLAMSTOK (P_SIRKET IN NUMBER,P_YIL IN NUMBER,P_BIRIMNO IN NUMBER,P_MUSNO IN VARCHAR2,P_TALINO IN VARCHAR2,CUR_RETURN OUT T_CURSOR);

--Stok Devir Gun Hizi (SOZTEMIR /25.08.2015)
PROCEDURE STOKDEVIRHIZI (P_SIRKET IN NUMBER,P_YIL IN NUMBER,P_BIRIMNO IN NUMBER,P_GUN IN NUMBER,P_MUSNO IN VARCHAR2,P_TALINO IN VARCHAR2,CUR_RETURN OUT T_CURSOR);


--Alis Tarih Bazli (SOZTEMIR /25.08.2015)
PROCEDURE ALISTARIH (P_SIRKET IN NUMBER,P_YIL IN NUMBER,P_BIRIMNO IN NUMBER,P_T1 IN DATE,P_T2 IN DATE,P_MUSNO IN VARCHAR2,P_TALINO IN VARCHAR2,CUR_RETURN OUT T_CURSOR);

--Alis Tarih Bazl Detay Sogusui (SOZTEMIR /25.08.2015)
PROCEDURE ALISTARIHDETAY (P_SIRKET IN NUMBER,P_YIL IN NUMBER,P_BIRIMNO IN NUMBER,P_FATNO IN NUMBER,P_MUSNO IN VARCHAR2,P_TALINO IN VARCHAR2,CUR_RETURN OUT T_CURSOR);

-- Cari Genel Alis Kosullari (SOZTEMIR /25.08.2015)
PROCEDURE GENELALISKOSULLARI (P_SIRKET IN NUMBER,P_YIL IN NUMBER,P_MUSNO IN VARCHAR2,P_TALINO IN VARCHAR2,CUR_RETURN OUT T_CURSOR);

-- Fiyat farki faturalari master sorgusu (SOZTEMIR /25.08.2015)
PROCEDURE KFFMASTER (P_SIRKET IN NUMBER,P_YIL IN NUMBER,P_MUSNO IN VARCHAR2,P_TALINO IN VARCHAR2,CUR_RETURN OUT T_CURSOR);

-- Fiyat farki faturalari Detay sorgusu (SOZTEMIR /25.08.2015)
PROCEDURE KFFDETAY (P_SIRKET IN NUMBER,P_YIL IN NUMBER,P_BIRIMNO IN NUMBER,P_FATNO IN NUMBER,P_MUSNO IN VARCHAR2,P_TALINO IN VARCHAR2,CUR_RETURN OUT T_CURSOR);

-- Faturalanmamis evraklar sorgusu (SOZTEMIR /25.08.2015)
PROCEDURE FATEVRAKLAR (P_SIRKET IN NUMBER,P_YIL IN NUMBER,P_MUSNO IN VARCHAR2,P_TALINO IN VARCHAR2,CUR_RETURN OUT T_CURSOR);

-- Iade Evraklari Master sorgusu (SOZTEMIR /25.08.2015)
PROCEDURE IADEMASTER (P_SIRKET IN NUMBER,P_YIL IN NUMBER,P_MUSNO IN VARCHAR2,P_TALINO IN VARCHAR2,CUR_RETURN OUT T_CURSOR);

-- Iade Evraklari DETAY sorgusu (SOZTEMIR /25.08.2015)
PROCEDURE IADEDETAY (P_SIRKET IN NUMBER,P_YIL IN NUMBER,P_BIRIMNO IN NUMBER,P_ISNO IN NUMBER,P_FATNO IN NUMBER,P_MUSNO IN VARCHAR2,P_TALINO IN VARCHAR2,CUR_RETURN OUT T_CURSOR);

-- Master Page Grafik Satis Sorgusu (SOZTEMIR /01.09.2015)
PROCEDURE GRAFIKSATIS (P_SIRKET IN NUMBER,P_YIL IN NUMBER,P_AY IN NUMBER,P_MUSNO IN VARCHAR2,P_TALINO IN VARCHAR2,CUR_RETURN OUT T_CURSOR);

-- Master Page Grafik Stok Sorgusu (SOZTEMIR /01.09.2015)
PROCEDURE GRAFIKSTOK (P_SIRKET IN NUMBER,P_YIL IN NUMBER,P_MUSNO IN VARCHAR2,P_TALINO IN VARCHAR2,CUR_RETURN OUT T_CURSOR);

--Cari Borc Alacak Sorgusu Firma Tarafi Admin Panelinde (SOZTEMIR /01.09.2015)
PROCEDURE BORCALACAK (P_SIRKET IN NUMBER,P_YIL IN NUMBER ,CUR_RETURN OUT T_CURSOR);

END B2B_WEB;