PACKAGE: APPS.SSP_SSPRPSPB_XMLP_PKG

Source

1 PACKAGE SSP_SSPRPSPB_XMLP_PKG AS
2 /* $Header: SSPRPSPBS.pls 120.2 2008/01/07 15:17:44 srikrish noship $ */
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   C_EWC DATE;
21 
22   C_WQ DATE;
23 
24   C_AVG_EARNINGS NUMBER := 0.00;
25 
26   C_BUSINESS_GROUP_NAME VARCHAR2(240);
27 
28   C_REPORT_SUBTITLE VARCHAR2(60);
29 
30   C_PAYROLL_NAME VARCHAR2(30);
31 
32   C_PERSON_NAME VARCHAR2(80);
33 
34   FUNCTION BEFOREREPORT RETURN BOOLEAN;
35 
36   FUNCTION C_SPPBFORMULA(M_DUE_DATE IN DATE
37                         ,M_PERSON_ID IN NUMBER) RETURN VARCHAR2;
38 
39   FUNCTION C_PROCESSEDFORMULA(E_ELEMENT_ENTRY_ID IN NUMBER) RETURN VARCHAR2;
40 
41   FUNCTION C_AMOUNT_PROCESSEDFORMULA(C_PROCESSED IN VARCHAR2
42                                     ,E_AMOUNT IN NUMBER) RETURN NUMBER;
43 
44   FUNCTION C_RECOVERABLE_PROCESSEDFORMULA(C_PROCESSED IN VARCHAR2
45                                          ,E_RECOVERABLE IN NUMBER) RETURN NUMBER;
46 
47   FUNCTION AFTERREPORT RETURN BOOLEAN;
48 
49   FUNCTION C_EWC_P RETURN DATE;
50 
51   FUNCTION C_WQ_P RETURN DATE;
52 
53   FUNCTION C_AVG_EARNINGS_P RETURN NUMBER;
54 
55   FUNCTION C_BUSINESS_GROUP_NAME_P RETURN VARCHAR2;
56 
57   FUNCTION C_REPORT_SUBTITLE_P RETURN VARCHAR2;
58 
59   FUNCTION C_PAYROLL_NAME_P RETURN VARCHAR2;
60 
61   FUNCTION C_PERSON_NAME_P RETURN VARCHAR2;
62 
63 END SSP_SSPRPSPB_XMLP_PKG;