[Home] [Help]
PACKAGE: APPS.PAY_KR_YEA_SSHR_UTILS_PKG
Source
1 package pay_kr_yea_sshr_utils_pkg
2 /* $Header: pykryutl.pkh 120.7.12010000.4 2008/08/12 10:33:51 vaisriva ship $ */
3 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 -------------------------------------------------------
36 procedure submit_yea_info(p_assignment_id in varchar2,
37 p_target_year in varchar2,
38 p_effective_date in varchar2,
39 p_return_status out nocopy varchar2,
40 p_return_message out nocopy varchar2,
41 p_failed_record out nocopy varchar2
42 );
43 -------------------------------------------------------
44 function update_allowed(p_business_group_id number,
45 p_assignment_id number,
46 p_target_year number,
47 p_effective_date date)
48 return varchar2;
49 -------------------------------------------------------
50 procedure run_validation_formula
51 ( P_BUSINESS_GROUP_ID in varchar2,
52 P_ASSIGNMENT_ID in varchar2,
53 P_TARGET_YEAR in varchar2,
54 P_EFFECTIVE_DATE in varchar2,
55 P_RETURN_MESSAGE out nocopy varchar2,
56 P_RETURN_STATUS out nocopy varchar2,
57 P_FF_MESSAGE0 out nocopy varchar2,
58 P_FF_MESSAGE1 out nocopy varchar2,
59 P_FF_MESSAGE2 out nocopy varchar2,
60 P_FF_MESSAGE3 out nocopy varchar2,
61 P_FF_MESSAGE4 out nocopy varchar2,
62 P_FF_MESSAGE5 out nocopy varchar2,
63 P_FF_MESSAGE6 out nocopy varchar2,
64 P_FF_MESSAGE7 out nocopy varchar2,
65 P_FF_MESSAGE8 out nocopy varchar2,
66 P_FF_MESSAGE9 out nocopy varchar2,
67 P_FF_RETURN_STATUS out nocopy varchar2,
68 ---------------- Special tax ---------------------
69 P_EE_EDUC_EXP in varchar2,
70 P_HOUSING_SAVING_TYPE in varchar2,
71 P_HOUSING_SAVING in varchar2,
72 P_HOUSING_PURCHASE_DATE in varchar2,
73 P_HOUSING_LOAN_DATE in varchar2,
74 P_HOUSING_LOAN_REPAY in varchar2,
75 P_LT_HOUSING_LOAN_DATE in varchar2,
76 P_LT_HOUSING_LOAN_INTEREST_REP in varchar2,
77 P_DONATION1 in varchar2,
78 P_POLITICAL_DONATION1 in varchar2,
79 P_HI_PREM in varchar2,
80 P_POLITICAL_DONATION2 in varchar2,
81 P_POLITICAL_DONATION3 in varchar2,
82 P_DONATION2 in varchar2,
83 P_DONATION3 in varchar2,
84 P_MED_EXP_EMP in varchar2,
85 P_LT_HOUSING_LOAN_DATE_1 in varchar2,
86 P_LT_HOUSING_LOAN_INT_REPAY_1 in varchar2,
87 P_MFR_MARRIAGE_OCCASIONS in varchar2,
88 P_MFR_FUNERAL_OCCASIONS in varchar2,
89 P_MFR_RELOCATION_OCCASIONS in varchar2,
90 P_EI_PREM in varchar2,
91 P_ESOA_DONATION in varchar2,
92 P_PERS_INS_NAME in varchar2,
93 P_PERS_INS_PREM in varchar2,
94 P_DISABLED_INS_PREM in varchar2,
95 P_MED_EXP in varchar2,
96 P_MED_EXP_DISABLED in varchar2,
97 P_MED_EXP_AGED in varchar2,
98 P_EE_OCCUPATION_EDUC_EXP in varchar2,
99 ----------------- FW Tax Break --------------------
100 P_IMMIGRATION_PURPOSE in varchar2,
101 P_CONTRACT_DATE in varchar2,
102 P_EXPIRY_DATE in varchar2,
103 P_STAX_APPLICABLE_FLAG in varchar2,
104 P_FW_APPLICATION_DATE in varchar2,
105 P_FW_SUBMISSION_DATE in varchar2,
106 ----------------- OVS Tax Break -------------------
107 P_TAX_PAID_DATE in varchar2,
108 P_OVS_SUBMISSION_DATE in varchar2,
109 P_KR_OVS_LOCATION in varchar2,
110 P_KR_OVS_WORK_PERIOD in varchar2,
111 P_KR_OVS_RESPONSIBILITY in varchar2,
112 P_TERRITORY_CODE in varchar2,
113 P_CURRENCY_CODE in varchar2,
114 P_TAXABLE in varchar2,
115 P_TAXABLE_SUBJ_TAX_BREAK in varchar2,
116 P_TAX_BREAK_RATE in varchar2,
117 P_TAX_FOREIGN_CURRENCY in varchar2,
118 P_TAX in varchar2,
119 P_OVS_APPLICATION_DATE in varchar2,
120 ----------------- Tax Break Info ------------------
121 P_HOUSING_LOAN_INTEREST_REPAY in varchar2,
122 P_STOCK_SAVING in varchar2,
123 P_LT_STOCK_SAVING1 in varchar2,
124 P_LT_STOCK_SAVING2 in varchar2,
125 ----------------- Tax Exems ----------------------
126 P_DIRECT_CARD_EXP in varchar2,
127 P_DPNT_DIRECT_EXP in varchar2,
128 P_GIRO_TUITION_PAID_EXP in varchar2,
129 P_CASH_RECEIPT_EXP in varchar2,
130 P_NP_PREM in varchar2,
131 P_PERS_PENSION_PREM in varchar2,
132 P_PERS_PENSION_SAVING in varchar2,
133 P_INVEST_PARTNERSHIP_FIN1 in varchar2,
134 P_INVEST_PARTNERSHIP_FIN2 in varchar2,
135 P_CREDIT_CARD_EXP in varchar2,
136 P_EMP_STOCK_OWN_PLAN_CONTRI in varchar2,
137 P_CREDIT_CARD_EXP_DPNT in varchar2,
138 P_PEN_PREM in varchar2, -- Bug 6024342
139 P_LTCI_PREM in varchar2 -- Bug 7260606
140 );
141
142 -------------------------------------------------------
143 procedure change_access(P_ASSIGNMENT_ID in varchar2,
144 P_TARGET_YEAR in varchar2,
145 P_RESULT out nocopy varchar2);
146
147
148 -------------------------------------------------------
149 procedure get_balances(P_ASSIGNMENT_ID in varchar2,
150 P_TARGET_YEAR in varchar2,
151 P_EFFECTIVE_DATE in varchar2,
152 P_ITAX out nocopy varchar2,
153 P_STAX out nocopy varchar2,
154 P_RTAX out nocopy varchar2,
155 P_TAXABLE out nocopy varchar2,
156 P_OVS_PROCESSED out nocopy varchar2,
157 P_TOTAL_TAXABLE_KRW out nocopy varchar2,
158 P_HI_PREM_EE out nocopy varchar2, -- Bug 5372366
159 P_EI_PREM out nocopy varchar2, -- Bug 5372366
160 P_NP_PREM_EE out nocopy varchar2, -- Bug 5185309
161 P_PEN_PREM_BAL out nocopy varchar2, -- Bug 6024342
162 P_LTCI_PREM_EE out nocopy varchar2); -- Bug 7260606
163 -------------------------------------------------------
164 procedure delete_all_records(
165 P_ASSIGNMENT_ID in varchar2,
166 P_TARGET_YEAR in varchar2);
167 -------------------------------------------------------
168 procedure get_dependent_information(
169 P_ASSIGNMENT_ID in varchar2,
170 P_EFFECTIVE_DATE in varchar2,
171 P_SPOUSE_EXEM out nocopy varchar2,
172 P_AGED_DEPENDENTS out nocopy varchar2,
173 P_ADULT_DEPENDENTS out nocopy varchar2,
174 P_UNDERAGED_DEPENDENTS out nocopy varchar2,
175 P_TOTAL_DEPENDENTS out nocopy varchar2,
176 P_TOTAL_AGEDS out nocopy varchar2,
177 P_TOTAL_DISABLED out nocopy varchar2,
178 P_FEMALE_EXEM out nocopy varchar2,
179 P_TOTAL_CHILDREN out nocopy varchar2,
180 P_TOTAL_SUPER_AGEDS out nocopy varchar2,
181 P_NEW_BORN_ADOPTED out nocopy varchar2, -- Bug 6705170
182 P_HOUSE_HOLDER out nocopy varchar2,
183 P_HOUSE_HOLDER_CODE out nocopy varchar2);
184 -------------------------------------------------------
185 procedure update_house_holder(
186 p_person_id in varchar2,
187 p_house_holder_code in varchar2);
188 -------------------------------------------------------
189 -- Bug 6849941: Credit Card Validation Checks
190 --
191 procedure enable_credit_card(
192 p_person_id in number,
193 p_contact_person_id in number,
194 p_contact_relationship_id in number,
195 p_date_earned in varchar2,
196 p_result out nocopy varchar2);
197 -------------------------------------------------------
198
199 end pay_kr_yea_sshr_utils_pkg;