[Home] [Help]
PACKAGE: APPS.SSP_SSPRPSPB_XMLP_PKG
Source
1 PACKAGE SSP_SSPRPSPB_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: SSPRPSPBS.pls 120.4 2010/12/24 14:53:39 pprvenka ship $ */
3
4 P_BUSINESS_GROUP_ID NUMBER;
5
6 P_SESSION_DATE DATE;
7
8 P_CONC_REQUEST_ID NUMBER;
9 AA_P_DATE_FROM varchar2(25);
10
11 AA_P_DATE_TO varchar2(25);
12 P_PAYROLL_ID NUMBER;
13
14 P_PERSON_ID NUMBER;
15
16 P_DATE_FROM DATE;
17
18 P_DATE_TO DATE;
19
20 P_SPP_TYPE varchar2(10);
21
22 C_EWC DATE;
23
24 C_WQ DATE;
25
26 C_AVG_EARNINGS NUMBER := 0.00;
27
28 C_BUSINESS_GROUP_NAME VARCHAR2(240);
29
30 C_REPORT_SUBTITLE VARCHAR2(60);
31
32 C_PAYROLL_NAME VARCHAR2(30);
33
34 C_PERSON_NAME VARCHAR2(80);
35
36 C_ELEMENT_NAME VARCHAR2(80);
37
38 C_LEAVE_TYPE VARCHAR2(50);
39
40 C_VIEW_NAME VARCHAR2(50);
41
42 C_REPORT_TITLE VARCHAR2(50);
43
44 FUNCTION BEFOREREPORT RETURN BOOLEAN;
45
46 FUNCTION C_SPPBFORMULA(M_DUE_DATE IN DATE
47 ,M_PERSON_ID IN NUMBER) RETURN VARCHAR2;
48
49 FUNCTION C_PROCESSEDFORMULA(E_ELEMENT_ENTRY_ID IN NUMBER) RETURN VARCHAR2;
50
51 FUNCTION C_AMOUNT_PROCESSEDFORMULA(C_PROCESSED IN VARCHAR2
52 ,E_AMOUNT IN NUMBER) RETURN NUMBER;
53
54 FUNCTION C_RECOVERABLE_PROCESSEDFORMULA(C_PROCESSED IN VARCHAR2
55 ,E_RECOVERABLE IN NUMBER) RETURN NUMBER;
56
57 FUNCTION AFTERREPORT RETURN BOOLEAN;
58
59 FUNCTION C_EWC_P RETURN DATE;
60
61 FUNCTION C_WQ_P RETURN DATE;
62
63 FUNCTION C_AVG_EARNINGS_P RETURN NUMBER;
64
65 FUNCTION C_BUSINESS_GROUP_NAME_P RETURN VARCHAR2;
66
67 FUNCTION C_REPORT_SUBTITLE_P RETURN VARCHAR2;
68
69 FUNCTION C_PAYROLL_NAME_P RETURN VARCHAR2;
70
71 FUNCTION C_PERSON_NAME_P RETURN VARCHAR2;
72
73 END SSP_SSPRPSPB_XMLP_PKG;