DBA Data[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;