1 PACKAGE AP_WEB_MANAGEMENT_REPORTS_PKG AUTHID CURRENT_USER AS
2 /* $Header: apwmrpts.pls 120.1.12010000.3 2008/12/18 23:57:09 rveliche ship $ */
3
4
5 PROCEDURE GetBaseCurrencyInfo ( P_BaseCurrencyCode OUT NOCOPY VARCHAR2,
6 P_ExchangeRateType OUT NOCOPY VARCHAR2 );
7
8 PROCEDURE ManagerHierarchySearch ( P_EmployeeId IN VARCHAR2,
9 P_ExpenseCategory IN VARCHAR2,
10 P_ViolationType IN VARCHAR2,
11 P_PeriodType IN VARCHAR2,
12 P_Date IN VARCHAR2,
13 P_UserCurrencyCode IN VARCHAR2,
14 P_QryType IN VARCHAR2);
15
16 PROCEDURE ExpenseCategorySearch ( P_EmployeeId IN VARCHAR2,
17 P_ExpenseCategory IN VARCHAR2,
18 P_ViolationType IN VARCHAR2,
19 P_PeriodType IN VARCHAR2,
20 P_Date IN VARCHAR2,
21 P_UserCurrencyCode IN VARCHAR2,
22 P_QryType IN VARCHAR2);
23
24 PROCEDURE ViolationTypeSearch ( P_EmployeeId IN VARCHAR2,
25 P_ExpenseCategory IN VARCHAR2,
26 P_ViolationType IN VARCHAR2,
27 P_PeriodType IN VARCHAR2,
28 P_Date IN VARCHAR2,
29 P_UserCurrencyCode IN VARCHAR2,
30 P_QryType IN VARCHAR2);
31
32 FUNCTION HasPermission ( P_SupervisorId IN NUMBER,
33 P_PersonId IN NUMBER,
34 P_StartDate IN DATE,
35 P_EndDate IN DATE
36 ) RETURN VARCHAR2;
37
38 FUNCTION HasPermission ( P_SupervisorId IN NUMBER,
39 P_PersonId IN NUMBER,
40 P_PeriodType IN VARCHAR2,
41 P_Date IN DATE
42 ) RETURN VARCHAR2;
43
44 END AP_WEB_MANAGEMENT_REPORTS_PKG;