[Home] [Help]
1 PACKAGE PAY_ZA_ELE_TAX_FILE AUTHID CURRENT_USER AS
2 /* $Header: PYZAIRPM.pkh 120.1.12020000.3 2012/08/24 11:00:59 nchinnam ship $ */
3
4 P_BUSINESS_GROUP_ID number;
5 P_CERTIFICATE_TYPE varchar2(30);
6 P_TAX_YEAR number;
7 P_PERIOD_RECON varchar2(30); -- 9877034 fix
8 P_LEGAL_ENTITY_ID number;
9 P_PAYROLL_ACTION_ID number;
10 P_TEST_RUN varchar2(10);
11
12 C_ACTION_CONTEXT_ID varchar2(2000):=' ';
13 C_PAYROLL_ACTION_ID varchar2(2000):=' ';
14
15 CTRL_TOTAL_REC number:=0;
16 CTRL_TOTAL_CODE number:=0;
17 CTRL_TOTAL_VALUE number:=0;
18
19 G_FLAG number:=0;
20
21 FUNCTION GET_G_FLAG return number;
22
23
24 FUNCTION BEFOREREPORT return boolean;
25
26 FUNCTION EMPLOYER_CTRL_TOTAL(TRADE_NAME varchar2,
27 TEST_LIVE varchar2,
28 PAYE_NUMBER varchar2,
29 SDL_NUMBER varchar2,
30 UIF_NUMBER varchar2,
31 EMPLOYER_CONTACT_NAME varchar2,
32 EMPLOYER_CONTACT_PHONE varchar2,
33 EMPLOYER_EMAIL varchar2,
34 PAYROLL_SOFTWARE varchar2,
35 TRANSACTION_YEAR varchar2,
36 PERIOD_OF_RECONCILIATION varchar2,
37 TRADE_CLASSIFICATION varchar2,
38 PHYSICAL_ADD_UNIT_NUM varchar2,
39 PHYSICAL_ADD_COMPLEX varchar2,
40 PHYSICAL_ADD_STREET varchar2,
41 PHYSICAL_ADD_FORM varchar2,
42 PHYSICAL_ADD_SUBURB varchar2,
43 PHYSICAL_ADD_CITY varchar2,
44 POSTAL_CODE varchar2) RETURN varchar2;
45
46 FUNCTION EMPLOYEE_CTRL_TOTAL(CERTIFICATE_NUMBER varchar2,
47 CERTIFICATE_TYPE varchar2,
48 NATURE_OF_PERSON varchar2,
49 YEAR_OF_ASSESSMENT varchar2,
50 SUR_OR_TRADING_NAME varchar2,
51 FIRST_TWO_NAMES varchar2,
52 EMP_INITIALS varchar2,
53 IDENTITY_NUMBER varchar2,
54 PASSPORT_NUMBER varchar2,
55 COUNTRY_OF_ISSUE varchar2,
56 DATE_OF_BIRTH varchar2,
57 IT_REF_NUMBER varchar2,
58 EMP_NUMBER varchar2,
59 DATE_EMPLOYED_FROM varchar2,
60 DATE_EMPLOYED_TO varchar2,
61 PAY_PERIODS_IN_YEAR varchar2,
62 PAY_PERIODS_IN_WORKED varchar2,
63 DIRECTIVE_NUMBER1 varchar2,
64 DIRECTIVE_NUMBER2 varchar2,
65 DIRECTIVE_NUMBER3 varchar2,
66 BANK_ACC_TYPE varchar2,
67 BANK_ACC_NUMBER varchar2,
68 BANK_BR_NUMBER varchar2,
69 BANK_NAME varchar2,
70 BANK_BR_NAME varchar2,
71 BANK_ACC_NAME varchar2,
72 BANK_ACC_RELATIONSHIP varchar2) RETURN varchar2;
73 FUNCTION EMPLOYEE_CONT_CTRL_TOTAL(EMP_EMAIL varchar2,
74 HOME_PHONE varchar2,
75 BUS_PHONE varchar2,
76 FAX_NUMBER varchar2,
77 CELL_NUMBER varchar2,
78 BUS_UNIT_NUMBER varchar2,
79 BUS_COMPLEX varchar2,
80 BUS_STREET_NUM varchar2,
81 BUS_FORM varchar2,
82 BUS_SUBURB varchar2,
83 BUS_CITY varchar2,
84 BUS_POSTAL_CODE varchar2,
85 RES_UNIT_NUMBER varchar2,
86 RES_COMPLEX varchar2,
87 RES_STREET_NUM varchar2,
88 RES_FORM varchar2,
89 RES_SUBURB varchar2,
90 RES_CITY varchar2,
91 RES_POSTAL_CODE varchar2,
92 POS_RES_ADD_SAME varchar2,
93 POS_LINE1 varchar2,
94 POS_LINE2 varchar2,
95 POS_LINE3 varchar2,
96 POS_CODE varchar2) RETURN varchar2;
97
98 FUNCTION EMPLOYEE_INC_CTRL_TOTAL(INC_CODE1 varchar2,
99 INC_VAL1 varchar2,
100 INC_CODE2 varchar2,
101 INC_VAL2 varchar2,
102 INC_CODE3 varchar2,
103 INC_VAL3 varchar2,
104 INC_CODE4 varchar2,
105 INC_VAL4 varchar2,
106 INC_CODE5 varchar2,
107 INC_VAL5 varchar2,
108 INC_CODE6 varchar2,
109 INC_VAL6 varchar2,
110 INC_CODE7 varchar2,
111 INC_VAL7 varchar2,
112 INC_CODE8 varchar2,
113 INC_VAL8 varchar2,
114 INC_CODE9 varchar2,
115 INC_VAL9 varchar2,
116 INC_CODE10 varchar2,
117 INC_VAL10 varchar2,
118 INC_CODE11 varchar2,
119 INC_VAL11 varchar2,
120 INC_CODE12 varchar2,
121 INC_VAL12 varchar2,
122 INC_CODE13 varchar2,
123 INC_VAL13 varchar2) RETURN varchar2;
124
125 FUNCTION EMPLOYEE_GRO_CTRL_TOTAL(NON_TAX_INCOME varchar2,
126 RFI_INCOME varchar2,
127 NRFI_INCOME varchar2) RETURN varchar2;
128
129 FUNCTION EMPLOYEE_DED_CTRL_TOTAL(DED_CODE1 varchar2,
130 DED_VAL1 varchar2,
131 DED_CODE2 varchar2,
132 DED_VAL2 varchar2,
133 DED_CODE3 varchar2,
134 DED_VAL3 varchar2,
135 DED_CODE4 varchar2,
136 DED_VAL4 varchar2,
137 DED_CODE5 varchar2,
138 DED_VAL5 varchar2,
139 DED_CODE6 varchar2,
140 DED_VAL6 varchar2,
141 DED_CODE7 varchar2,
142 DED_VAL7 varchar2,
143 DED_CODE8 varchar2,
144 DED_VAL8 varchar2,
145 DED_CODE9 varchar2,
146 DED_VAL9 varchar2,
147 DED_CODE10 varchar2,
148 DED_VAL10 varchar2,
149 DED_CODE11 varchar2,
150 DED_VAL11 varchar2,
151 DED_CODE12 varchar2,
152 DED_VAL12 varchar2,
153 DED_CODE13 varchar2,
154 DED_VAL13 varchar2,
155 DIR1 varchar2,
156 DIR2 varchar2,
157 DIR3 varchar2,
158 ACTION_CONTEXT_ID varchar2,
159 CERTIFICATE_NUMBER varchar2) RETURN varchar2;
160
161 FUNCTION EMPLOYEE_TAX_CTRL_TOTAL(TOTAL_DEDUCTION varchar2,
162 SITE varchar2,
163 PAYE varchar2,
164 PAYE_RET_LUM_BEN varchar2,
165 UIF_CONTRIBUTION varchar2,
166 SDL_CONTRIBUTION varchar2,
167 TOT_TAX_UIF_SDL varchar2,
168 REASON_CODE_IT3 varchar2,
169 MED_TAX_CR varchar2) RETURN varchar2;
170
171 END PAY_ZA_ELE_TAX_FILE;
|
|
|
|