[Home] [Help]
PACKAGE: APPS.PAY_PAYGBP45_A4_PKG
Source
1 PACKAGE PAY_PAYGBP45_A4_PKG AUTHID CURRENT_USER as
2 /* $Header: paygbp45a4.pkh 120.2.12020000.3 2012/07/04 19:39:43 amnaraya ship $ */
3 /*===========================================================================+
4 | Copyright (c) 1993 Oracle Corporation |
5 | Redwood Shores, California, USA |
6 | All rights reserved. |
7 +============================================================================
8 Name
9 PAY_PAYGBP45_A4_PKG
10 Purpose
11 To generate P45 A4 XML Data
12 Notes
13
14 History
15 21-OCT-08 115.0 Initial Version
16 21-MAR-12 115.1 bug 13441825 P45 A4 Report does not print null values
17 ==============================================================================*/
18 P_SESSION_DATE DATE;
19
20 P_REPORT_TITLE VARCHAR2(60);
21
22 P_CONC_REQUEST_ID NUMBER;
23
24 P_DATE_TODAY DATE;
25
26 P_ACTION_RESTRICTION VARCHAR2(100);
27
28 P_ASSIGNMENT_ACTION_ID NUMBER;
29
30 P_PAYROLL_ACTION_ID NUMBER;
31
32 C_TITLE VARCHAR2(32767);
33
34 C_NI12 VARCHAR2(2);
35
36 C_NI34 VARCHAR2(2);
37
38 C_NI56 VARCHAR2(2);
39
40 C_NI78 VARCHAR2(2);
41
42 C_NI9 VARCHAR2(1);
43
44 C_DATE_OF_LEAVING_DD VARCHAR2(2);
45
46 C_DATE_OF_LEAVING_MM VARCHAR2(2);
47
48 C_DATE_OF_LEAVING_YYYY VARCHAR2(4);
49
50 C_TOTAL_TAX_TD NUMBER;
51
52 C_TOTAL_PAY_TD NUMBER;
53
54 C_PER_ADDRESS_LINE1 VARCHAR2(60);
55
56 C_PER_ADDRESS_LINE2 VARCHAR2(60);
57
58 C_PER_ADDRESS_LINE3 VARCHAR2(60);
59
60 C_PER_ADDRESS_LINE4 VARCHAR2(60);
61
62 C_PAY_IN_EMP_POUNDS NUMBER := 0;
63
64 C_PAY_IN_EMP_PENCE NUMBER := 00;
65
66 C_TAX_IN_EMP_POUNDS NUMBER := 0;
67
68 C_TAX_IN_EMP_PENCE NUMBER := 00;
69
70 C_PAY_TD_POUNDS NUMBER := 0;
71
72 C_PAY_TD_PENCE NUMBER := 00;
73
74 C_TAX_TD_POUNDS NUMBER := 0;
75
76 C_W1_M1_INDICATOR VARCHAR2(20); -- Bug 13441825
77
78 C_TAX_TD_PENCE NUMBER := 00;
79
80 C_BUSINESS_GROUP_NAME VARCHAR2(60);
81
82 C_REPORT_SUBTITLE VARCHAR2(60);
83
84 C_FORMULA_ID NUMBER;
85
86 C_MESSAGE VARCHAR2(80);
87
88 C_ERS_ADDR_LINE1 VARCHAR2(38);
89
90 C_ERS_ADDR_LINE2 VARCHAR2(38);
91
92 C_ERS_ADDR_LINE3 VARCHAR2(38);
93
94 C_ERS_NAME VARCHAR2(40);
95
96 C_TAX_DIST_NO VARCHAR2(3);
97
98 C_TAX_DIST_REF VARCHAR2(32767);
99
100 C_DATE_OF_BIRTH_DD VARCHAR2(2);
101
102 C_DATE_OF_BIRTH_MM VARCHAR2(2);
103
104 C_DATE_OF_BIRTH_YYYY VARCHAR2(4);
105
106 C_SEX_M VARCHAR2(1);
107
108 C_SEX_F VARCHAR2(1);
109
110 FUNCTION BEFOREREPORT RETURN BOOLEAN;
111
112 FUNCTION C_FORMAT_DATA_FORMULA(TITLE IN VARCHAR2
113 ,ADDRESS_LINE1 IN VARCHAR2
114 ,ADDRESS_LINE2 IN VARCHAR2
115 ,ADDRESS_LINE3 IN VARCHAR2
116 ,TOWN_OR_CITY IN VARCHAR2
117 ,COUNTY IN VARCHAR2
118 ,COUNTRY IN VARCHAR2
119 ,POST_CODE IN VARCHAR2
120 ,TAXABLE_PAY IN NUMBER
121 ,PREVIOUS_TAXABLE_PAY IN NUMBER
122 ,TAX_PAID IN NUMBER
123 ,PREVIOUS_TAX_PAID IN NUMBER
124 ,NI_NUMBER IN VARCHAR2
125 ,TERMINATION_DATE IN DATE
126 ,C_3_PART IN VARCHAR2
127 ,W1_M1_INDICATOR IN VARCHAR2
128 ,SEX VARCHAR2
129 ,DATE_OF_BIRTH DATE) RETURN VARCHAR2;
130
131 PROCEDURE GET_POUNDS_PENCE(P_TOTAL IN NUMBER
132 ,P_POUNDS IN OUT NOCOPY NUMBER
133 ,P_PENCE IN OUT NOCOPY NUMBER);
134
135 PROCEDURE SPLIT_EMPLOYER_ADDRESS(P_EMPLOYER_ADDRESS IN VARCHAR2
136 ,P_EMP_ADDR_LINE_1 IN OUT NOCOPY VARCHAR2
137 ,P_EMP_ADDR_LINE_2 IN OUT NOCOPY VARCHAR2
138 ,P_EMP_ADDR_LINE_3 IN OUT NOCOPY VARCHAR2);
139
140 FUNCTION C_3_PARTFORMULA RETURN VARCHAR2;
141
142 FUNCTION AFTERREPORT RETURN BOOLEAN;
143
144 FUNCTION C_TITLE_P RETURN VARCHAR2;
145
146 FUNCTION C_NI12_P RETURN VARCHAR2;
147
148 FUNCTION C_NI34_P RETURN VARCHAR2;
149
150 FUNCTION C_NI56_P RETURN VARCHAR2;
151
152 FUNCTION C_NI78_P RETURN VARCHAR2;
153
154 FUNCTION C_NI9_P RETURN VARCHAR2;
155
156 FUNCTION C_DATE_OF_BIRTH_DD_P RETURN VARCHAR2;
157
158 FUNCTION C_DATE_OF_BIRTH_MM_P RETURN VARCHAR2;
159
160 FUNCTION C_DATE_OF_BIRTH_YYYY_P RETURN VARCHAR2;
161
162 FUNCTION C_SEX_M_P RETURN VARCHAR2;
163
164 FUNCTION C_SEX_F_P RETURN VARCHAR2;
165
166 FUNCTION C_DATE_OF_LEAVING_DD_P RETURN VARCHAR2;
167
168 FUNCTION C_DATE_OF_LEAVING_MM_P RETURN VARCHAR2;
169
170 FUNCTION C_DATE_OF_LEAVING_YYYY_P RETURN VARCHAR2;
171
172 FUNCTION C_TOTAL_TAX_TD_P RETURN NUMBER;
173
174 FUNCTION C_TOTAL_PAY_TD_P RETURN NUMBER;
175
176 FUNCTION C_PER_ADDRESS_LINE1_P RETURN VARCHAR2;
177
178 FUNCTION C_PER_ADDRESS_LINE2_P RETURN VARCHAR2;
179
180 FUNCTION C_PER_ADDRESS_LINE3_P RETURN VARCHAR2;
181
182 FUNCTION C_PER_ADDRESS_LINE4_P RETURN VARCHAR2;
183
184 FUNCTION C_PAY_IN_EMP_POUNDS_P RETURN NUMBER;
185
186 FUNCTION C_PAY_IN_EMP_PENCE_P RETURN NUMBER;
187
188 FUNCTION C_TAX_IN_EMP_POUNDS_P RETURN NUMBER;
189
190 FUNCTION C_TAX_IN_EMP_PENCE_P RETURN NUMBER;
191
192 FUNCTION C_PAY_TD_POUNDS_P RETURN NUMBER;
193
194 FUNCTION C_PAY_TD_PENCE_P RETURN NUMBER;
195
196 FUNCTION C_TAX_TD_POUNDS_P RETURN NUMBER;
197
198 FUNCTION C_TAX_TD_PENCE_P RETURN NUMBER;
199
200 FUNCTION C_BUSINESS_GROUP_NAME_P RETURN VARCHAR2;
201
202 FUNCTION C_REPORT_SUBTITLE_P RETURN VARCHAR2;
203
204 FUNCTION C_FORMULA_ID_P RETURN NUMBER;
205
206 FUNCTION C_MESSAGE_P RETURN VARCHAR2;
207
208 FUNCTION C_ERS_ADDR_LINE1_P RETURN VARCHAR2;
209
210 FUNCTION C_ERS_ADDR_LINE2_P RETURN VARCHAR2;
211
212 FUNCTION C_ERS_ADDR_LINE3_P RETURN VARCHAR2;
213
214 FUNCTION C_ERS_NAME_P RETURN VARCHAR2;
215
216 FUNCTION C_TAX_DIST_NO_P RETURN VARCHAR2;
217
218 FUNCTION C_TAX_DIST_REF_P RETURN VARCHAR2;
219
220 END PAY_PAYGBP45_A4_PKG;