1 PACKAGE AP_TE_EIS_PKG AUTHID CURRENT_USER AS
2 /* $Header: apteeiss.pls 120.2 2004/10/25 22:39:29 pjena noship $ */
3
4 PROCEDURE GetInvoiceTotal(
5 P_Start_Date IN Date,
6 P_End_Date IN Date,
7 P_Result IN OUT NOCOPY NUMBER);
8
9 PROCEDURE GetInvoiceCount(
10 P_Payables IN NUMBER,
11 P_Project IN NUMBER,
12 P_Selfserve IN NUMBER,
13 P_Result IN OUT NOCOPY NUMBER);
14
15 PROCEDURE GetInvoiceAverage(
16 P_Total IN NUMBER,
17 P_Count IN NUMBER,
18 P_Result IN OUT NOCOPY NUMBER);
19
20 PROCEDURE GetPaymentTotal(
21 P_Set_Of_Books_Id IN VARCHAR2 ,
22 P_Start_Date IN Date,
23 P_End_Date IN Date,
24 P_Result IN OUT NOCOPY NUMBER);
25
26 PROCEDURE GetPaymentCount(
27 P_Set_Of_Books_Id IN VARCHAR2 ,
28 P_Start_Date IN Date,
29 P_End_Date IN Date,
30 P_Result IN OUT NOCOPY NUMBER);
31 PROCEDURE GetPaymentAverage(
32 P_Set_Of_Books_Id IN VARCHAR2 ,
33 P_Start_Date IN Date,
34 P_End_Date IN Date,
35 P_Result IN OUT NOCOPY NUMBER);
36
37
38 PROCEDURE GetPayablesInvoiceCount(
39 P_Set_Of_Books_Id IN VARCHAR2 ,
40 P_Start_Date IN Date,
41 P_End_Date IN Date,
42 P_Result IN OUT NOCOPY NUMBER);
43
44 PROCEDURE GetProjectInvoiceCount(
45 P_Set_Of_Books_Id IN VARCHAR2 ,
46 P_Start_Date IN Date,
47 P_End_Date IN Date,
48 P_Result IN OUT NOCOPY NUMBER);
49
50 PROCEDURE GetSelfServeInvoiceCount(
51 P_Set_Of_Books_Id IN VARCHAR2 ,
52 P_Start_Date IN Date,
53 P_End_Date IN Date,
54 P_Result IN OUT NOCOPY NUMBER);
55
56
57 END AP_TE_EIS_PKG;