PACKAGE: APPS.SSP_SSPRPSPA_XMLP_PKG

Source

1 PACKAGE SSP_SSPRPSPA_XMLP_PKG AS
2 /* $Header: SSPRPSPAS.pls 120.1 2008/01/07 14:41:45 srikrish noship $ */
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   AA_P_DATE_FROM varchar2(25);
19 
20   AA_P_DATE_TO varchar2(25);
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   FUNCTION BEFOREREPORT RETURN BOOLEAN;
37 
38   FUNCTION C_SPPAFORMULA(M_DUE_DATE IN DATE
39                         ,M_MATCHING_DATE IN DATE
40                         ,M_PERSON_ID IN NUMBER) RETURN VARCHAR2;
41 
42   FUNCTION C_PROCESSEDFORMULA(E_ELEMENT_ENTRY_ID IN NUMBER) RETURN VARCHAR2;
43 
44   FUNCTION C_AMOUNT_PROCESSEDFORMULA(C_PROCESSED IN VARCHAR2
45                                     ,E_AMOUNT IN NUMBER) RETURN NUMBER;
46 
47   FUNCTION C_RECOVERABLE_PROCESSEDFORMULA(C_PROCESSED IN VARCHAR2
48                                          ,E_RECOVERABLE IN NUMBER) RETURN NUMBER;
49 
50   FUNCTION AFTERREPORT RETURN BOOLEAN;
51 
52   FUNCTION C_EWC_P RETURN DATE;
53 
54   FUNCTION C_WQ_P RETURN DATE;
55 
56   FUNCTION C_AVG_EARNINGS_P RETURN NUMBER;
57 
58   FUNCTION C_BUSINESS_GROUP_NAME_P RETURN VARCHAR2;
59 
60   FUNCTION C_REPORT_SUBTITLE_P RETURN VARCHAR2;
61 
62   FUNCTION C_PAYROLL_NAME_P RETURN VARCHAR2;
63 
64   FUNCTION C_PERSON_NAME_P RETURN VARCHAR2;
65 
66 END SSP_SSPRPSPA_XMLP_PKG;