1 PACKAGE PAY_PAYGBP35_XMLP_PKG AS
2 /* $Header: PAYGBP35S.pls 120.0 2008/01/07 15:34:43 srikrish noship $ */
3 P_REPORT_TITLE VARCHAR2(60);
4
5 P_NIP_FLAG VARCHAR2(1);
6
7 P_PAYROLL_ACTION_ID NUMBER;
8
9 P_CONC_REQUEST_ID NUMBER;
10
11 C_BUSINESS_GROUP_NAME VARCHAR2(240);
12
13 C_REQUEST_ID NUMBER;
14
15 C_TAX_DISTRICT VARCHAR2(20);
16
17 C_PERMIT_NO VARCHAR2(12);
18
19 C_START_DATE DATE;
20
21 C_END_DATE DATE;
22
23 C_DATE_FROM NUMBER;
24
25 C_DATE_FROM_TO VARCHAR2(9);
26
27 FUNCTION C_PAY_CONTRIBSFORMULA(SUM_PAY_CONTRIBS IN NUMBER) RETURN NUMBER;
28
29 FUNCTION C_PAY_SSPFORMULA(SUM_PAY_SSP IN NUMBER) RETURN NUMBER;
30
31 FUNCTION C_PAY_SMPFORMULA(SUM_PAY_SMP IN NUMBER) RETURN NUMBER;
32
33 FUNCTION C_PAY_GROSSFORMULA(SUM_PAY_GROSS IN NUMBER) RETURN NUMBER;
34
35 FUNCTION C_PAY_TAXFORMULA(SUM_PAY_TAX IN NUMBER) RETURN NUMBER;
36
37 FUNCTION C_PAY_PREV_GROSSFORMULA(SUM_PAY_PREV_GROSS IN NUMBER) RETURN NUMBER;
38
39 FUNCTION C_PAY_PREV_TAXFORMULA(SUM_PAY_PREV_TAX IN NUMBER) RETURN NUMBER;
40
41 FUNCTION C_EOY_CONTRIBSFORMULA(SUM_EOY_CONTRIBS IN NUMBER) RETURN NUMBER;
42
43 FUNCTION C_EOY_SSPFORMULA(SUM_EOY_SSP IN NUMBER) RETURN NUMBER;
44
45 FUNCTION C_EOY_SMPFORMULA(SUM_EOY_SMP IN NUMBER) RETURN NUMBER;
46
47 FUNCTION C_EOY_GROSSFORMULA(SUM_EOY_GROSS IN NUMBER) RETURN NUMBER;
48
49 FUNCTION C_EOY_TAXFORMULA(SUM_EOY_TAX IN NUMBER) RETURN NUMBER;
50
51 FUNCTION C_EOY_PREV_GROSSFORMULA(SUM_EOY_PREV_GROSS IN NUMBER) RETURN NUMBER;
52
53 FUNCTION C_EOY_PREV_TAXFORMULA(SUM_EOY_PREV_TAX IN NUMBER) RETURN NUMBER;
54
55 FUNCTION C_TOT_CONTRIBSFORMULA(SUM_TOT_CONTRIBS IN NUMBER) RETURN NUMBER;
56
57 FUNCTION C_TOT_SSPFORMULA(SUM_TOT_SSP IN NUMBER) RETURN NUMBER;
58
59 FUNCTION C_TOT_SMPFORMULA(SUM_TOT_SMP IN NUMBER) RETURN NUMBER;
60
61 FUNCTION C_TOT_GROSSFORMULA(SUM_TOT_GROSS IN NUMBER) RETURN NUMBER;
62
63 FUNCTION C_TOT_TAXFORMULA(SUM_TOT_TAX IN NUMBER) RETURN NUMBER;
64
65 FUNCTION C_TOT_PREV_GROSFORMULA(SUM_TOT_PREV_GROSS IN NUMBER) RETURN NUMBER;
66
67 FUNCTION C_TOT_PREV_TAXFORMULA(SUM_TOT_PREV_TAX IN NUMBER) RETURN NUMBER;
68
69 FUNCTION BEFOREREPORT RETURN BOOLEAN;
70
71 FUNCTION C_NI_VALUEFORMULA(NI_CODE IN VARCHAR2
72 ,SUM_CONTRIBS IN NUMBER) RETURN NUMBER;
73
74 FUNCTION C_NIP_VALUEFORMULA(NI_CODE IN VARCHAR2
75 ,SUM_CONTRIBS IN NUMBER) RETURN NUMBER;
76
77 FUNCTION C_EOY_NIPFORMULA(SUM_EOY_CONTRIBS IN NUMBER
78 ,SUM_EOY_NIP IN NUMBER) RETURN NUMBER;
79
80 FUNCTION C_TOT_NIPFORMULA(SUM_TOT_CONTRIBS IN NUMBER
81 ,SUM_TOT_NIP IN NUMBER) RETURN NUMBER;
82
83 FUNCTION C_SMP_NI_COMPFORMULA(SMP_NI_COMP IN NUMBER) RETURN NUMBER;
84
85 FUNCTION C_SMP_RECFORMULA(SMP_REC IN NUMBER) RETURN NUMBER;
86
87 FUNCTION C_SSP_RECFORMULA(SSP_REC IN NUMBER) RETURN NUMBER;
88
89 FUNCTION C_NIP_CONTRIBSFORMULA(SUM_PAY_CONTRIBS IN NUMBER
90 ,SUM_NIP_CONTRIBS IN NUMBER) RETURN NUMBER;
91
92 FUNCTION C_EOY_SMP_RECFORMULA(EOY_SMP_REC IN NUMBER) RETURN NUMBER;
93
94 FUNCTION C_EOY_SSP_RECFORMULA(EOY_SSP_REC IN NUMBER) RETURN NUMBER;
95
96 FUNCTION C_EOY_SMP_NI_COMPFORMULA(EOY_SMP_NI_COMP IN NUMBER) RETURN NUMBER;
97
98 FUNCTION C_SUM_SMP_RECFORMULA(SUM_SMP_REC IN NUMBER) RETURN NUMBER;
99
100 FUNCTION C_SUM_SMP_NI_COMPFORMULA(SUM_SMP_NI_COMP IN NUMBER) RETURN NUMBER;
101
102 FUNCTION C_SUM_SSP_RECFORMULA(SUM_SSP_REC IN NUMBER) RETURN NUMBER;
103
104 FUNCTION C_EOY_SPP_BIRTHFORMULA(SUM_EOY_SPP_BIRTH IN NUMBER) RETURN NUMBER;
105
106 FUNCTION C_EOY_SAPFORMULA(SUM_EOY_SAP IN NUMBER) RETURN NUMBER;
107
108 FUNCTION C_EOY_SPP_ADOPTFORMULA(SUM_EOY_SPP_ADOPT IN NUMBER) RETURN NUMBER;
109
110 FUNCTION C_TOT_SAPFORMULA(SUM_TOT_SAP IN NUMBER) RETURN NUMBER;
111
112 FUNCTION C_TOT_SPP_BIRTHFORMULA(SUM_TOT_SPP_BIRTH IN NUMBER) RETURN NUMBER;
113
114 FUNCTION C_TOT_SPP_ADOPTFORMULA(SUM_TOT_SPP_ADOPT IN NUMBER) RETURN NUMBER;
115
116 FUNCTION C_PAY_SAPFORMULA(SUM_PAY_SAP IN NUMBER) RETURN NUMBER;
117
118 FUNCTION C_PAY_SPPAFORMULA(SUM_PAY_SPP_ADOPT IN NUMBER) RETURN NUMBER;
119
120 FUNCTION C_PAY_SPPBFORMULA(SUM_PAY_SPP_BIRTH IN NUMBER) RETURN NUMBER;
121
122 FUNCTION C_SAP_NI_COMPFORMULA(SAP_NI_COMP IN NUMBER) RETURN NUMBER;
123
124 FUNCTION C_SPP_NI_COMPFORMULA(SPP_NI_COMP IN NUMBER) RETURN NUMBER;
125
126 FUNCTION C_SAP_RECFORMULA(SAP_REC IN NUMBER) RETURN NUMBER;
127
128 FUNCTION C_SPP_RECFORMULA(SPP_REC IN NUMBER) RETURN NUMBER;
129
130 FUNCTION C_EOY_SAP_RECFORMULA(EOY_SAP_REC IN NUMBER) RETURN NUMBER;
131
132 FUNCTION C_EOY_SPP_RECFORMULA(EOY_SPP_REC IN NUMBER) RETURN NUMBER;
133
134 FUNCTION C_EOY_SAP_NI_COMPFORMULA(EOY_SAP_NI_COMP IN NUMBER) RETURN NUMBER;
135
136 FUNCTION C_EOY_SPP_NI_COMPFORMULA(EOY_SPP_NI_COMP IN NUMBER) RETURN NUMBER;
137
138 FUNCTION C_SUM_SAP_RECFORMULA(SUM_SAP_REC IN NUMBER) RETURN NUMBER;
139
140 FUNCTION C_SUM_SPP_RECFORMULA(SUM_SPP_REC IN NUMBER) RETURN NUMBER;
141
142 FUNCTION C_SUM_SAP_NI_COMPFORMULA(SUM_SAP_NI_COMP IN NUMBER) RETURN NUMBER;
143
144 FUNCTION CSUM_SPP_NI_COMPFORMULA(SUM_SPP_NI_COMP IN NUMBER) RETURN NUMBER;
145
146 FUNCTION AFTERREPORT RETURN BOOLEAN;
147
148 FUNCTION C_NI_ARREARSFORMULA(ASSIG_ACT_ID IN NUMBER) RETURN NUMBER;
149
150 FUNCTION C_BUSINESS_GROUP_NAME_P RETURN VARCHAR2;
151
152 FUNCTION C_REQUEST_ID_P RETURN NUMBER;
153
154 FUNCTION C_TAX_DISTRICT_P RETURN VARCHAR2;
155
156 FUNCTION C_PERMIT_NO_P RETURN VARCHAR2;
157
158 FUNCTION C_START_DATE_P RETURN DATE;
159
160 FUNCTION C_END_DATE_P RETURN DATE;
161
162 FUNCTION C_DATE_FROM_P RETURN NUMBER;
163
164 FUNCTION C_DATE_FROM_TO_P RETURN VARCHAR2;
165
166 END PAY_PAYGBP35_XMLP_PKG;