[Home] [Help]
PACKAGE: APPS.PAY_KR_YEA_SSHR_UTILS_PKG
Source
1 package pay_kr_yea_sshr_utils_pkg
2 /* $Header: pykryutl.pkh 120.20 2012/01/19 10:21:35 rpahune ship $ */
3 AUTHID CURRENT_USER as
4
5 function yea_entry_status(p_assignment_id number,
6 p_target_year varchar2)
7 return varchar2;
8 -------------------------------------------------------
9 function get_URL(p_file_type varchar2,
10 p_request_id number,
11 p_gwy_uid varchar2,
12 p_two_task varchar2) return varchar2;
13 -------------------------------------------------------
14 function get_total_taxable(p_assignment_id number,
15 p_effective_date date)
16 return number;
17 -------------------------------------------------------
18 function get_total_itax( p_assignment_id number,
19 p_effective_date date)
20 return number;
21 -------------------------------------------------------
22 function get_total_rtax( p_assignment_id number,
23 p_effective_date date)
24 return number;
25 -------------------------------------------------------
26 function get_total_stax( p_assignment_id number,
27 p_effective_date date)
28 return number;
29
30 -------------------------------------------------------
31 function get_ovs_processed( p_assignment_id number,
32 p_effective_date date)
33 return number;
34 -------------------------------------------------------
35 procedure insert_fnd_sessions ( p_effective_date in varchar2
36 );
37 -------------------------------------------------------
38 procedure submit_yea_info(p_assignment_id in varchar2,
39 p_target_year in varchar2,
40 p_effective_date in varchar2,
41 p_return_status out nocopy varchar2,
42 p_return_message out nocopy varchar2,
43 p_failed_record out nocopy varchar2
44 );
45 -------------------------------------------------------
46 function update_allowed(p_business_group_id number,
47 p_assignment_id number,
48 p_target_year number,
49 p_effective_date date)
50 return varchar2;
51 -------------------------------------------------------
52 procedure run_validation_formula
53 ( P_BUSINESS_GROUP_ID in varchar2,
54 P_ASSIGNMENT_ID in varchar2,
55 P_TARGET_YEAR in varchar2,
56 P_EFFECTIVE_DATE in varchar2,
57 P_RETURN_MESSAGE out nocopy varchar2,
58 P_RETURN_STATUS out nocopy varchar2,
59 P_FF_MESSAGE0 out nocopy varchar2,
60 P_FF_MESSAGE1 out nocopy varchar2,
61 P_FF_MESSAGE2 out nocopy varchar2,
62 P_FF_MESSAGE3 out nocopy varchar2,
63 P_FF_MESSAGE4 out nocopy varchar2,
64 P_FF_MESSAGE5 out nocopy varchar2,
65 P_FF_MESSAGE6 out nocopy varchar2,
66 P_FF_MESSAGE7 out nocopy varchar2,
67 P_FF_MESSAGE8 out nocopy varchar2,
68 P_FF_MESSAGE9 out nocopy varchar2,
69 P_FF_RETURN_STATUS out nocopy varchar2,
70 ---------------- Special tax ---------------------
71 P_EE_EDUC_EXP in varchar2,
72 P_HOUSING_SAVING_TYPE in varchar2,
73 P_HOUSING_SAVING in varchar2,
74 P_HOUSING_PURCHASE_DATE in varchar2,
75 P_HOUSING_LOAN_DATE in varchar2,
76 P_HOUSING_LOAN_REPAY in varchar2,
77 P_LT_HOUSING_LOAN_DATE in varchar2,
78 P_LT_HOUSING_LOAN_INTEREST_REP in varchar2,
79 P_DONATION1 in varchar2,
80 P_POLITICAL_DONATION1 in varchar2,
81 P_HI_PREM in varchar2,
82 P_POLITICAL_DONATION2 in varchar2,
83 P_POLITICAL_DONATION3 in varchar2,
84 P_DONATION2 in varchar2,
85 P_DONATION3 in varchar2,
86 P_MED_EXP_EMP in varchar2,
87 P_LT_HOUSING_LOAN_DATE_1 in varchar2,
88 P_LT_HOUSING_LOAN_INT_REPAY_1 in varchar2,
89 P_MFR_MARRIAGE_OCCASIONS in varchar2,
90 P_MFR_FUNERAL_OCCASIONS in varchar2,
91 P_MFR_RELOCATION_OCCASIONS in varchar2,
92 P_EI_PREM in varchar2,
93 P_ESOA_DONATION in varchar2,
94 P_PERS_INS_NAME in varchar2,
95 P_PERS_INS_PREM in varchar2,
96 P_DISABLED_INS_PREM in varchar2,
97 P_MED_EXP in varchar2,
98 P_MED_EXP_DISABLED in varchar2,
99 P_MED_EXP_AGED in varchar2,
100 P_EE_OCCUPATION_EDUC_EXP in varchar2,
101 ----------------- FW Tax Break --------------------
102 P_IMMIGRATION_PURPOSE in varchar2,
103 P_CONTRACT_DATE in varchar2,
104 P_EXPIRY_DATE in varchar2,
105 P_STAX_APPLICABLE_FLAG in varchar2,
106 P_FW_APPLICATION_DATE in varchar2,
107 P_FW_SUBMISSION_DATE in varchar2,
108 ----------------- OVS Tax Break -------------------
109 P_TAX_PAID_DATE in varchar2,
110 P_OVS_SUBMISSION_DATE in varchar2,
111 P_KR_OVS_LOCATION in varchar2,
112 P_KR_OVS_WORK_PERIOD in varchar2,
113 P_KR_OVS_RESPONSIBILITY in varchar2,
114 P_TERRITORY_CODE in varchar2,
115 P_CURRENCY_CODE in varchar2,
116 P_TAXABLE in varchar2,
117 P_TAXABLE_SUBJ_TAX_BREAK in varchar2,
118 P_TAX_BREAK_RATE in varchar2,
119 P_TAX_FOREIGN_CURRENCY in varchar2,
120 P_TAX in varchar2,
121 P_OVS_APPLICATION_DATE in varchar2,
122 ----------------- Tax Break Info ------------------
123 P_HOUSING_LOAN_INTEREST_REPAY in varchar2,
124 P_STOCK_SAVING in varchar2,
125 P_LT_STOCK_SAVING1 in varchar2,
126 P_LT_STOCK_SAVING2 in varchar2,
127 ----------------- Tax Exems ----------------------
128 P_DIRECT_CARD_EXP in varchar2,
129 P_DPNT_DIRECT_EXP in varchar2,
130 P_GIRO_TUITION_PAID_EXP in varchar2,
131 P_CASH_RECEIPT_EXP in varchar2,
132 P_NP_PREM in varchar2,
133 P_PERS_PENSION_PREM in varchar2,
134 P_PERS_PENSION_SAVING in varchar2,
135 P_INVEST_PARTNERSHIP_FIN1 in varchar2,
136 P_INVEST_PARTNERSHIP_FIN2 in varchar2,
137 P_CREDIT_CARD_EXP in varchar2,
138 P_EMP_STOCK_OWN_PLAN_CONTRI in varchar2,
139 P_CREDIT_CARD_EXP_DPNT in varchar2,
140 P_PEN_PREM in varchar2, -- Bug 6024342
141 P_LTCI_PREM in varchar2 -- Bug 7260606
142 );
143
144 -------------------------------------------------------
145 procedure change_access(P_ASSIGNMENT_ID in varchar2,
146 P_TARGET_YEAR in varchar2,
147 P_RESULT out nocopy varchar2);
148
149
150 -------------------------------------------------------
151 procedure get_balances(P_ASSIGNMENT_ID in varchar2,
152 P_TARGET_YEAR in varchar2,
153 P_EFFECTIVE_DATE in varchar2,
154 P_ITAX out nocopy varchar2,
155 P_STAX out nocopy varchar2,
156 P_RTAX out nocopy varchar2,
157 P_TAXABLE out nocopy varchar2,
158 P_OVS_PROCESSED out nocopy varchar2,
159 P_TOTAL_TAXABLE_KRW out nocopy varchar2,
160 P_HI_PREM_EE out nocopy varchar2, -- Bug 5372366
161 P_EI_PREM out nocopy varchar2, -- Bug 5372366
162 P_NP_PREM_EE out nocopy varchar2, -- Bug 5185309
163 P_PEN_PREM_BAL out nocopy varchar2, -- Bug 6024342
164 P_LTCI_PREM_EE out nocopy varchar2, -- Bug 7260606
165 P_MILITARY_PEN_PREM out nocopy varchar2, -- Bug 9737699
166 P_POST_OFFICE_PEN_PREM out nocopy varchar2, -- Bug 9737699
167 P_PVT_SCHOOL_PEN_PREM out nocopy varchar2); -- Bug 9737699
168 -------------------------------------------------------
169 procedure delete_all_records(
170 P_ASSIGNMENT_ID in varchar2,
171 P_TARGET_YEAR in varchar2);
172 -------------------------------------------------------
173 procedure get_dependent_information(
174 P_ASSIGNMENT_ID in varchar2,
175 P_EFFECTIVE_DATE in varchar2,
176 P_SPOUSE_EXEM out nocopy varchar2,
177 P_AGED_DEPENDENTS out nocopy varchar2,
178 P_ADULT_DEPENDENTS out nocopy varchar2,
179 P_UNDERAGED_DEPENDENTS out nocopy varchar2,
180 P_TOTAL_DEPENDENTS out nocopy varchar2,
181 P_TOTAL_AGEDS out nocopy varchar2,
182 P_TOTAL_DISABLED out nocopy varchar2,
183 P_FEMALE_EXEM out nocopy varchar2,
184 P_TOTAL_CHILDREN out nocopy varchar2,
185 P_TOTAL_SUPER_AGEDS out nocopy varchar2,
186 P_NEW_BORN_ADOPTED out nocopy varchar2, -- Bug 6705170
187 P_HOUSE_HOLDER out nocopy varchar2,
188 P_HOUSE_HOLDER_CODE out nocopy varchar2);
189 -------------------------------------------------------
190 procedure update_house_holder(
191 p_person_id in varchar2,
192 p_house_holder_code in varchar2);
193 -------------------------------------------------------
194 -- Bug 6849941: Credit Card Validation Checks
195 --
196 procedure enable_credit_card(
197 p_person_id in number,
198 p_contact_person_id in number,
199 p_contact_relationship_id in number,
200 p_date_earned in varchar2,
201 p_result out nocopy varchar2);
202 -------------------------------------------------------
203 -- Bug 7142612
204 --
205 procedure enable_donation_fields(
206 p_person_id in number,
207 p_contact_person_id in number,
208 p_contact_relationship_id in number,
209 p_date_earned in varchar2,
210 p_result out nocopy varchar2);
211 -------------------------------------------------------
212 -- Bug 7142612
213 --
214 procedure validate_bus_reg_num(
215 p_national_identifier in varchar2,
216 p_result out nocopy varchar2);
217 -------------------------------------------------------
218 -- Bug 7633302
219 ---------------------------------------------------------
220 procedure detail_exists(
221 p_ayi_information6 in number,
222 p_assignment_id in number,
223 p_target_year in number,
224 p_result out nocopy varchar2);
225 ---------------------------------------------------------
226 -- Bug 7633302
227 ---------------------------------------------------------
228 procedure chk_taxation_period_unique(
229 p_assignment_yea_info_id in number,
230 p_assignment_id in number,
231 p_ayi_information2 in varchar2,
232 p_ayi_information6 in varchar2, -- Bug 9213683
233 p_target_year in number,
234 p_result out nocopy varchar2);
235 ---------------------------------------------------------
236 -- Bug 9079450
237 ---------------------------------------------------------
238 procedure aged_flag(
239 p_national_identifier in varchar2,
240 p_effective_date in varchar2,
241 p_result out nocopy varchar2);
242 ---------------------------------------------------------
243 -- Bug 9737699
244 ---------------------------------------------------------
245 procedure get_lookup_meaning( p_lookup_type in varchar2,
246 p_lookup_code in varchar2,
247 p_result out nocopy varchar2);
248
249 procedure get_globalvalue(p_glbvar in varchar2,
250 p_process_date in varchar2,
251 p_result out nocopy varchar2);
252 ---------------------------------------------------------
253 --
254 -- Bug 9393732
255 --
256 --------------------------------------------------------------------------------------
257 procedure insert_don_type_data(p_assignment_id in number,
258 p_target_year in varchar2);
259 --------------------------------------------------------------------------------------
260 --
261 -- Bug 9393732
262 --
263 --------------------------------------------------------------------------------------
264 procedure sync_don_type_data(p_assignment_id in number,
265 p_target_year in number,
266 p_political in number,
267 p_statutory in number,
268 p_esoa in number,
269 p_pledt in number,
270 p_religious in number,
271 p_specified in number,
272 p_tax_law in number);
273 --
274 ---------------------------------------------------------------------------------------
275 --
276 -- Bug 9393732
277 --
278 --------------------------------------------------------------------------------------
279 procedure display_yea_info(p_assignment_id in varchar2,
280 p_target_year in varchar2,
281 p_result out nocopy varchar2);
282 --------------------------------------------------------------------------------------
283 -- Bug 9393732
284 --------------------------------------------------------------------------------------
285 procedure update_don_tot_data(
286 p_assignment_id in number,
287 p_target_year in number,
288 p_stat_self in number,
289 p_stat_spouse in number,
290 p_stat_child in number,
291 p_pol_self in number,
292 p_tax_self in number,
293 p_tax_spouse in number,
294 p_tax_child in number,
295 p_pledt_self in number,
296 p_pledt_spouse in number,
297 p_pledt_child in number,
298 p_esoa_self in number,
299 p_spec_self in number,
300 p_spec_spouse in number,
301 p_spec_child in number,
305 p_oth_self in number,
302 p_rel_self in number,
303 p_rel_spouse in number,
304 p_rel_child in number,
306 p_oth_spouse in number,
307 p_oth_child in number,
308 p_stat_parent in number,
309 p_stat_bro_sis in number,
310 p_tax_parent in number,
311 p_tax_bro_sis in number,
312 p_pledt_parent in number,
313 p_pledt_bro_sis in number,
314 p_spec_parent in number,
315 p_spec_bro_sis in number,
316 p_rel_parent in number,
317 p_rel_bro_sis in number,
318 p_oth_parent in number,
319 p_oth_bro_sis in number);
320 --
321 --------------------------------------------------------------------------------------
322 --
323 procedure calc_hou_rent_fields(p_contract_st_date in varchar2,
324 p_contract_end_date in varchar2,
328 p_eligible_amt out nocopy number);
325 p_total_monthly_rent in number,
326 p_target_year in number,
327 p_contract_days out nocopy number,
329 --
330 --------------------------------------------------------------------------------------
331 --
332 end pay_kr_yea_sshr_utils_pkg;