1 package pay_kr_ff_functions_pkg as
2 /* $Header: pykrfffc.pkh 120.10.12010000.5 2008/08/06 07:41:31 ubhat ship $ */
3 --------------------------------------------------------------------------------
4 function get_legislative_parameter(
5 p_payroll_action_id in number,
6 p_parameter_name in varchar2,
7 p_default_value in varchar2 default 'NULL',
8 p_flash_cache in varchar2 default 'N') return varchar2;
9 --------------------------------------------------------------------------------
10 function set_message_name(
11 p_application_short_name in varchar2,
12 p_message_name in varchar2) return number;
13 --------------------------------------------------------------------------------
14 function set_message_token(
15 p_token_name in varchar2,
16 p_token_value in varchar2) return number;
17 --------------------------------------------------------------------------------
18 function get_message return varchar2;
19 --------------------------------------------------------------------------------
20 procedure ni_component(
21 p_national_identifier in varchar2,
22 p_sex out NOCOPY varchar2,
23 p_date_of_birth out NOCOPY date);
24 --------------------------------------------------------------------------------
25 function ni_sex(p_national_identifier in varchar2) return varchar2;
26 --------------------------------------------------------------------------------
27 function ni_date_of_birth(p_national_identifier in varchar2) return date;
28 --------------------------------------------------------------------------------
29 -- Bug 3172960
30 function ni_nationality(p_national_identifier in varchar2) return varchar2;
31 --------------------------------------------------------------------------------
32 -- Bug 3172960
33 function ni_nationality(p_assignment_id in number,
34 p_effective_date in date) return varchar2;
35 --------------------------------------------------------------------------------
36 function eoy_age(
37 p_date_of_birth in date,
38 p_effective_date in date) return number;
39 --------------------------------------------------------------------------------
40 function dpnt_spouse_flag(p_contact_type in varchar2) return varchar2;
41 --------------------------------------------------------------------------------
42 function aged_dpnt_flag(
43 p_contact_type in varchar2,
44 p_national_identifier in varchar2,
45 p_effective_date in date) return varchar2;
46 --------------------------------------------------------------------------------
47 function adult_dpnt_flag(
48 p_contact_type in varchar2,
49 p_national_identifier in varchar2,
50 p_effective_date in date,
51 p_disabled_flag in varchar2,
52 p_age_exception_flag in varchar2) return varchar2;
53 --------------------------------------------------------------------------------
54 function underaged_dpnt_flag(
55 p_contact_type in varchar2,
56 p_national_identifier in varchar2,
57 p_effective_date in date) return varchar2;
58 --------------------------------------------------------------------------------
59 function aged_flag(
60 p_national_identifier in varchar2,
61 p_effective_date in date) return varchar2;
62 --------------------------------------------------------------------------------
63 function super_aged_flag(
64 p_national_identifier in varchar2,
65 p_effective_date in date) return varchar2;
66 --------------------------------------------------------------------------------
67 function disabled_flag(
68 p_person_id in number,
69 p_effective_date in date) return varchar2;
70 --------------------------------------------------------------------------------
71 function child_flag(
72 p_national_identifier in varchar2,
73 p_effective_date in date) return varchar2;
74 --------------------------------------------------------------------------------
75 -- National Pension Exception Reason (Formula Function)
76 -- Bug 2815425
77 --------------------------------------------------------------------------------
78 function get_np_exception_flag (
79 p_date_earned IN DATE
80 ,p_business_group_id IN NUMBER
81 ,p_assignment_id IN NUMBER ) return varchar2;
82 --------------------------------------------------------------------------------
83 /* Bug 6784288 */
84 function addtl_child_flag(
85 p_contact_type in varchar2,
86 p_national_identifier in varchar2,
87 p_effective_date in date) return varchar2;
88 --------------------------------------------------------------------------------
89 function get_dependent_info(
90 p_assignment_id in number,
91 p_date_earned in date,
92 p_non_resident_flag in varchar2,
93 p_dpnt_spouse_flag out NOCOPY varchar2,
94 p_num_of_aged_dpnts out NOCOPY number,
95 p_num_of_adult_dpnts out NOCOPY number,
96 p_num_of_underaged_dpnts out NOCOPY number,
97 p_num_of_dpnts out NOCOPY number,
98 p_num_of_ageds out NOCOPY number,
99 p_num_of_disableds out NOCOPY number,
100 p_female_ee_flag out NOCOPY varchar2,
101 p_num_of_children out NOCOPY number) return number;
102 --------------------------------------------------------------------------------
103 /* Bug 6705170 : Function get_dependent_info() has been overloaded
104 to fetch the New Born/Adopted Child count */
105 --------------------------------------------------------------------------------
106 function get_dependent_info(
107 p_assignment_id in number,
108 p_date_earned in date,
109 p_non_resident_flag in varchar2,
110 p_dpnt_spouse_flag out NOCOPY varchar2,
111 p_num_of_aged_dpnts out NOCOPY number,
112 p_num_of_adult_dpnts out NOCOPY number,
113 p_num_of_underaged_dpnts out NOCOPY number,
114 p_num_of_dpnts out NOCOPY number,
115 p_num_of_ageds out NOCOPY number,
116 p_num_of_disableds out NOCOPY number,
117 p_female_ee_flag out NOCOPY varchar2,
118 p_num_of_children out NOCOPY number,
119 p_num_of_super_ageds out NOCOPY number,
120 p_num_of_new_born_adopted out NOCOPY number,
121 p_num_of_addtl_child out NOCOPY number) return number; /* Bug 6784288 */
122 --------------------------------------------------------------------------------
123 -- Bug 3172960
124 function get_dependent_info(
125 p_assignment_id in number,
126 p_date_earned in date,
127 p_non_resident_flag in varchar2,
128 p_dpnt_spouse_flag out NOCOPY varchar2,
129 p_num_of_aged_dpnts out NOCOPY number,
130 p_num_of_adult_dpnts out NOCOPY number,
131 p_num_of_underaged_dpnts out NOCOPY number,
132 p_num_of_dpnts out NOCOPY number,
133 p_num_of_ageds out NOCOPY number,
134 p_num_of_disableds out NOCOPY number,
135 p_female_ee_flag out NOCOPY varchar2,
136 p_num_of_children out NOCOPY number,
137 p_num_of_super_ageds out NOCOPY number,
138 p_num_of_addtl_child out NOCOPY number) return number; /* Bug 6784288 */
139 --------------------------------------------------------------------------------
140 -- Bug 3172960
141 function get_dependent_info(
142 p_assignment_id in number,
143 p_date_earned in date,
144 p_non_resident_flag in varchar2,
145 p_dpnt_spouse_flag out NOCOPY varchar2,
146 p_num_of_aged_dpnts out NOCOPY number,
147 p_num_of_adult_dpnts out NOCOPY number,
148 p_num_of_underaged_dpnts out NOCOPY number,
149 p_num_of_dpnts out NOCOPY number,
150 p_num_of_ageds out NOCOPY number,
151 p_num_of_disableds out NOCOPY number,
152 p_female_ee_flag out NOCOPY varchar2,
153 p_num_of_children out NOCOPY number,
154 p_num_of_super_ageds out NOCOPY number) return number;
155 --------------------------------------------------------------------------------
156 -- Employment Insurance Exception Reasons in payroll deduction
157 -- Bug 2833174
158 --------------------------------------------------------------------------------
159 function get_ei_loss_exception_codes(
160 p_date_earned in date
161 ,p_business_group_id in number
162 ,p_assignment_id in number
163 ,p_loss_ineligible_flag out nocopy varchar2
164 ,p_exception_flag out nocopy varchar2
165 ,p_exception_type out nocopy varchar2
166 ,p_overlapped_ex_flag out nocopy varchar2
167 ) return number;
168 --------------------------------------------------------------------------------
169 -- Bug 4674552
170 function is_exempted_dependent(
171 p_cont_type in per_contact_relationships.contact_type%type,
172 p_ni in per_people_f.national_identifier%type,
173 p_itax_dpnt_flag in per_contact_relationships.cont_information2%type,
174 p_addl_tax_exem_flag in per_contact_relationships.cont_information3%type,
175 p_addl_disabled_flag in per_contact_relationships.cont_information4%type,
176 p_addl_exem_flag_child in per_contact_relationships.cont_information7%type,
177 p_age_ckh_exp_flag in per_contact_relationships.cont_information8%type,
178 p_eff_date in pay_payroll_actions.effective_date%type,
179 p_ins_prem_exem_incl_flag in per_contact_relationships.cont_information10%type, -- Bug 4931542
180 p_med_exp_exem_incl_flag in per_contact_relationships.cont_information12%type, -- Bug 4931542
181 p_edu_exp_exem_incl_flag in per_contact_relationships.cont_information13%type, -- Bug 4931542
182 p_card_exp_exem_incl_flag in per_contact_relationships.cont_information14%type, -- Bug 4931542
183 p_contact_extra_info_id in per_contact_extra_info_f.contact_extra_info_id%type -- Bug 5879106
184 ) return varchar2 ;
185 --------------------------------------------------------------------------------
186 function dpnt_eligible_for_basic_exem(
187 p_cont_type in per_contact_relationships.contact_type%type,
188 p_ni in per_people_f.national_identifier%type,
189 p_itax_dpnt_flag in per_contact_relationships.cont_information2%type,
190 p_addl_disabled_flag in per_contact_relationships.cont_information4%type,
191 p_age_ckh_exp_flag in per_contact_relationships.cont_information8%type,
192 p_eff_date in pay_payroll_actions.effective_date%type
193 ) return varchar2 ;
194 --------------------------------------------------------------------------------
195 function dpnt_addl_child_exempted(
196 p_addl_child_exem in varchar2,
197 p_ni in varchar2,
198 p_eff_date in date
199 ) return varchar2;
200 --------------------------------------------------------------------------------
201 -- procedure get_double_exem_amt
202 procedure get_double_exem_amt(p_assignment_id in per_assignments_f.assignment_id%type,
203 p_effective_year in varchar2,
204 p_double_exm_amt out nocopy number);
205 --
206 -----------------------------------------------------------------------------------
207 -- Bug 6849941: New Validation Checks for Credit Card Fields on the Income Tax Form
208 -----------------------------------------------------------------------------------
209 Function enable_credit_card(
210 p_person_id in number,
211 p_contact_person_id in number,
212 p_contact_relationship_id in number,
213 p_date_earned in date) return varchar2;
214 --
215 -----------------------------------------------------------------------------------
216 -- Bug 7164589: Long Term Treatment Insurance Premium
217 -- Bug 7228788: Added a new input parameter to the function for the Input Value Name
218 -----------------------------------------------------------------------------------
219 FUNCTION get_long_term_ins_skip_flag(
220 p_assignment_action_id in pay_assignment_actions.assignment_action_id%type
221 ,p_input_value_name in varchar2
222 ) RETURN VARCHAR2;
223 --
224 -----------------------------------------------------------------------------------
225 end pay_kr_ff_functions_pkg;