[Home] [Help]
PACKAGE: APPS.PAY_PAYGBP45_XMLP_PKG
Source
1 PACKAGE PAY_PAYGBP45_XMLP_PKG AS
2 /* $Header: PAYGBP45S.pls 120.0 2008/01/07 15:33:54 srikrish noship $ */
3 P_SESSION_DATE DATE;
4
5 P_REPORT_TITLE VARCHAR2(60);
6
7 P_CONC_REQUEST_ID NUMBER;
8
9 P_DATE_TODAY DATE;
10
11 P_ACTION_RESTRICTION VARCHAR2(100);
12
13 P_ASSIGNMENT_ACTION_ID NUMBER;
14
15 P_PAYROLL_ACTION_ID NUMBER;
16
17 C_TITLE VARCHAR2(32767);
18
19 C_NI12 VARCHAR2(2);
20
21 C_NI34 VARCHAR2(2);
22
23 C_NI56 VARCHAR2(2);
24
25 C_NI78 VARCHAR2(2);
26
27 C_NI9 VARCHAR2(1);
28
29 C_DATE_OF_LEAVING_DD VARCHAR2(2);
30
31 C_DATE_OF_LEAVING_MM VARCHAR2(2);
32
33 C_DATE_OF_LEAVING_YYYY VARCHAR2(4);
34
35 C_TOTAL_TAX_TD NUMBER;
36
37 C_TOTAL_PAY_TD NUMBER;
38
39 C_PER_ADDRESS_LINE1 VARCHAR2(60);
40
41 C_PER_ADDRESS_LINE2 VARCHAR2(60);
42
43 C_PER_ADDRESS_LINE3 VARCHAR2(60);
44
45 C_PER_ADDRESS_LINE4 VARCHAR2(60);
46
47 C_PAY_IN_EMP_POUNDS NUMBER := 0;
48
49 C_PAY_IN_EMP_PENCE NUMBER := 00;
50
51 C_TAX_IN_EMP_POUNDS NUMBER := 0;
52
53 C_TAX_IN_EMP_PENCE NUMBER := 00;
54
55 C_PAY_TD_POUNDS NUMBER := 0;
56
57 C_PAY_TD_PENCE NUMBER := 00;
58
59 C_TAX_TD_POUNDS NUMBER := 0;
60
61 C_TAX_TD_PENCE NUMBER := 00;
62
63 C_BUSINESS_GROUP_NAME VARCHAR2(60);
64
65 C_REPORT_SUBTITLE VARCHAR2(60);
66
67 C_FORMULA_ID NUMBER;
68
69 C_MESSAGE VARCHAR2(80);
70
71 C_ERS_ADDR_LINE1 VARCHAR2(38);
72
73 C_ERS_ADDR_LINE2 VARCHAR2(38);
74
75 C_ERS_ADDR_LINE3 VARCHAR2(38);
76
77 C_ERS_NAME VARCHAR2(40);
78
79 C_TAX_DIST_NO VARCHAR2(3);
80
81 C_TAX_DIST_REF VARCHAR2(32767);
82
83 FUNCTION BEFOREREPORT RETURN BOOLEAN;
84
85 FUNCTION C_FORMAT_DATA_FORMULA(TITLE IN VARCHAR2
86 ,ADDRESS_LINE1 IN VARCHAR2
87 ,ADDRESS_LINE2 IN VARCHAR2
88 ,ADDRESS_LINE3 IN VARCHAR2
89 ,TOWN_OR_CITY IN VARCHAR2
90 ,COUNTY IN VARCHAR2
91 ,COUNTRY IN VARCHAR2
92 ,POST_CODE IN VARCHAR2
93 ,TAXABLE_PAY IN NUMBER
94 ,PREVIOUS_TAXABLE_PAY IN NUMBER
95 ,TAX_PAID IN NUMBER
96 ,PREVIOUS_TAX_PAID IN NUMBER
97 ,NI_NUMBER IN VARCHAR2
98 ,TERMINATION_DATE IN DATE
99 ,C_3_PART IN VARCHAR2
100 ,W1_M1_INDICATOR IN VARCHAR2) RETURN VARCHAR2;
101
102 PROCEDURE GET_POUNDS_PENCE(P_TOTAL IN NUMBER
103 ,P_POUNDS IN OUT NOCOPY NUMBER
104 ,P_PENCE IN OUT NOCOPY NUMBER);
105
106 PROCEDURE SPLIT_EMPLOYER_ADDRESS(P_EMPLOYER_ADDRESS IN VARCHAR2
107 ,P_EMP_ADDR_LINE_1 IN OUT NOCOPY VARCHAR2
108 ,P_EMP_ADDR_LINE_2 IN OUT NOCOPY VARCHAR2
109 ,P_EMP_ADDR_LINE_3 IN OUT NOCOPY VARCHAR2);
110
111 FUNCTION C_3_PARTFORMULA RETURN VARCHAR2;
112
113 FUNCTION AFTERREPORT RETURN BOOLEAN;
114
115 FUNCTION C_TITLE_P RETURN VARCHAR2;
116
117 FUNCTION C_NI12_P RETURN VARCHAR2;
118
119 FUNCTION C_NI34_P RETURN VARCHAR2;
120
121 FUNCTION C_NI56_P RETURN VARCHAR2;
122
123 FUNCTION C_NI78_P RETURN VARCHAR2;
124
125 FUNCTION C_NI9_P RETURN VARCHAR2;
126
127 FUNCTION C_DATE_OF_LEAVING_DD_P RETURN VARCHAR2;
128
129 FUNCTION C_DATE_OF_LEAVING_MM_P RETURN VARCHAR2;
130
131 FUNCTION C_DATE_OF_LEAVING_YYYY_P RETURN VARCHAR2;
132
133 FUNCTION C_TOTAL_TAX_TD_P RETURN NUMBER;
134
135 FUNCTION C_TOTAL_PAY_TD_P RETURN NUMBER;
136
137 FUNCTION C_PER_ADDRESS_LINE1_P RETURN VARCHAR2;
138
139 FUNCTION C_PER_ADDRESS_LINE2_P RETURN VARCHAR2;
140
141 FUNCTION C_PER_ADDRESS_LINE3_P RETURN VARCHAR2;
142
143 FUNCTION C_PER_ADDRESS_LINE4_P RETURN VARCHAR2;
144
145 FUNCTION C_PAY_IN_EMP_POUNDS_P RETURN NUMBER;
146
147 FUNCTION C_PAY_IN_EMP_PENCE_P RETURN NUMBER;
148
149 FUNCTION C_TAX_IN_EMP_POUNDS_P RETURN NUMBER;
150
151 FUNCTION C_TAX_IN_EMP_PENCE_P RETURN NUMBER;
152
153 FUNCTION C_PAY_TD_POUNDS_P RETURN NUMBER;
154
155 FUNCTION C_PAY_TD_PENCE_P RETURN NUMBER;
156
157 FUNCTION C_TAX_TD_POUNDS_P RETURN NUMBER;
158
159 FUNCTION C_TAX_TD_PENCE_P RETURN NUMBER;
160
161 FUNCTION C_BUSINESS_GROUP_NAME_P RETURN VARCHAR2;
162
163 FUNCTION C_REPORT_SUBTITLE_P RETURN VARCHAR2;
164
165 FUNCTION C_FORMULA_ID_P RETURN NUMBER;
166
167 FUNCTION C_MESSAGE_P RETURN VARCHAR2;
168
169 FUNCTION C_ERS_ADDR_LINE1_P RETURN VARCHAR2;
170
171 FUNCTION C_ERS_ADDR_LINE2_P RETURN VARCHAR2;
172
173 FUNCTION C_ERS_ADDR_LINE3_P RETURN VARCHAR2;
174
175 FUNCTION C_ERS_NAME_P RETURN VARCHAR2;
176
177 FUNCTION C_TAX_DIST_NO_P RETURN VARCHAR2;
178
179 FUNCTION C_TAX_DIST_REF_P RETURN VARCHAR2;
180
181 END PAY_PAYGBP45_XMLP_PKG;