PACKAGE: APPS.SSP_SSPRPSPA_XMLP_PKG

Source

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