173: ,p_effective_date => p_effective_date
174: ,p_assignment_id => p_assignment_id
175: ,p_action_information_category => 'JP_PRE_TAX_1'
176: ,p_action_information1 => p_locked_assignment_action_id
177: ,p_action_information2 => fnd_number.number_to_canonical(p_value.taxable_sal_amt)
178: ,p_action_information3 => fnd_number.number_to_canonical(p_value.taxable_mat_amt)
179: ,p_action_information4 => fnd_number.number_to_canonical(l_person_id)
180: ,p_action_information5 => p_value.hi_org_id
181: ,p_action_information6 => fnd_number.number_to_canonical(p_value.hi_prem_ee)
174: ,p_assignment_id => p_assignment_id
175: ,p_action_information_category => 'JP_PRE_TAX_1'
176: ,p_action_information1 => p_locked_assignment_action_id
177: ,p_action_information2 => fnd_number.number_to_canonical(p_value.taxable_sal_amt)
178: ,p_action_information3 => fnd_number.number_to_canonical(p_value.taxable_mat_amt)
179: ,p_action_information4 => fnd_number.number_to_canonical(l_person_id)
180: ,p_action_information5 => p_value.hi_org_id
181: ,p_action_information6 => fnd_number.number_to_canonical(p_value.hi_prem_ee)
182: ,p_action_information7 => fnd_number.number_to_canonical(p_value.hi_prem_er)
175: ,p_action_information_category => 'JP_PRE_TAX_1'
176: ,p_action_information1 => p_locked_assignment_action_id
177: ,p_action_information2 => fnd_number.number_to_canonical(p_value.taxable_sal_amt)
178: ,p_action_information3 => fnd_number.number_to_canonical(p_value.taxable_mat_amt)
179: ,p_action_information4 => fnd_number.number_to_canonical(l_person_id)
180: ,p_action_information5 => p_value.hi_org_id
181: ,p_action_information6 => fnd_number.number_to_canonical(p_value.hi_prem_ee)
182: ,p_action_information7 => fnd_number.number_to_canonical(p_value.hi_prem_er)
183: ,p_action_information8 => p_value.wp_org_id
177: ,p_action_information2 => fnd_number.number_to_canonical(p_value.taxable_sal_amt)
178: ,p_action_information3 => fnd_number.number_to_canonical(p_value.taxable_mat_amt)
179: ,p_action_information4 => fnd_number.number_to_canonical(l_person_id)
180: ,p_action_information5 => p_value.hi_org_id
181: ,p_action_information6 => fnd_number.number_to_canonical(p_value.hi_prem_ee)
182: ,p_action_information7 => fnd_number.number_to_canonical(p_value.hi_prem_er)
183: ,p_action_information8 => p_value.wp_org_id
184: ,p_action_information9 => fnd_number.number_to_canonical(p_value.wp_prem_ee)
185: ,p_action_information10 => fnd_number.number_to_canonical(p_value.wp_prem_er)
178: ,p_action_information3 => fnd_number.number_to_canonical(p_value.taxable_mat_amt)
179: ,p_action_information4 => fnd_number.number_to_canonical(l_person_id)
180: ,p_action_information5 => p_value.hi_org_id
181: ,p_action_information6 => fnd_number.number_to_canonical(p_value.hi_prem_ee)
182: ,p_action_information7 => fnd_number.number_to_canonical(p_value.hi_prem_er)
183: ,p_action_information8 => p_value.wp_org_id
184: ,p_action_information9 => fnd_number.number_to_canonical(p_value.wp_prem_ee)
185: ,p_action_information10 => fnd_number.number_to_canonical(p_value.wp_prem_er)
186: ,p_action_information11 => p_value.wpf_org_id
180: ,p_action_information5 => p_value.hi_org_id
181: ,p_action_information6 => fnd_number.number_to_canonical(p_value.hi_prem_ee)
182: ,p_action_information7 => fnd_number.number_to_canonical(p_value.hi_prem_er)
183: ,p_action_information8 => p_value.wp_org_id
184: ,p_action_information9 => fnd_number.number_to_canonical(p_value.wp_prem_ee)
185: ,p_action_information10 => fnd_number.number_to_canonical(p_value.wp_prem_er)
186: ,p_action_information11 => p_value.wpf_org_id
187: ,p_action_information12 => fnd_number.number_to_canonical(p_value.wpf_prem_ee)
188: ,p_action_information13 => p_value.salary_category
181: ,p_action_information6 => fnd_number.number_to_canonical(p_value.hi_prem_ee)
182: ,p_action_information7 => fnd_number.number_to_canonical(p_value.hi_prem_er)
183: ,p_action_information8 => p_value.wp_org_id
184: ,p_action_information9 => fnd_number.number_to_canonical(p_value.wp_prem_ee)
185: ,p_action_information10 => fnd_number.number_to_canonical(p_value.wp_prem_er)
186: ,p_action_information11 => p_value.wpf_org_id
187: ,p_action_information12 => fnd_number.number_to_canonical(p_value.wpf_prem_ee)
188: ,p_action_information13 => p_value.salary_category
189: ,p_action_information14 => fnd_number.number_to_canonical(p_value.mutual_aid)
183: ,p_action_information8 => p_value.wp_org_id
184: ,p_action_information9 => fnd_number.number_to_canonical(p_value.wp_prem_ee)
185: ,p_action_information10 => fnd_number.number_to_canonical(p_value.wp_prem_er)
186: ,p_action_information11 => p_value.wpf_org_id
187: ,p_action_information12 => fnd_number.number_to_canonical(p_value.wpf_prem_ee)
188: ,p_action_information13 => p_value.salary_category
189: ,p_action_information14 => fnd_number.number_to_canonical(p_value.mutual_aid)
190: ,p_action_information15 => fnd_number.number_to_canonical(l_period_of_service_id)
191: ,p_action_information16 => fnd_date.date_to_canonical(l_date_start)
185: ,p_action_information10 => fnd_number.number_to_canonical(p_value.wp_prem_er)
186: ,p_action_information11 => p_value.wpf_org_id
187: ,p_action_information12 => fnd_number.number_to_canonical(p_value.wpf_prem_ee)
188: ,p_action_information13 => p_value.salary_category
189: ,p_action_information14 => fnd_number.number_to_canonical(p_value.mutual_aid)
190: ,p_action_information15 => fnd_number.number_to_canonical(l_period_of_service_id)
191: ,p_action_information16 => fnd_date.date_to_canonical(l_date_start)
192: ,p_action_information17 => l_leaving_reason
193: ,p_action_information18 => fnd_date.date_to_canonical(l_actual_termination_date)
186: ,p_action_information11 => p_value.wpf_org_id
187: ,p_action_information12 => fnd_number.number_to_canonical(p_value.wpf_prem_ee)
188: ,p_action_information13 => p_value.salary_category
189: ,p_action_information14 => fnd_number.number_to_canonical(p_value.mutual_aid)
190: ,p_action_information15 => fnd_number.number_to_canonical(l_period_of_service_id)
191: ,p_action_information16 => fnd_date.date_to_canonical(l_date_start)
192: ,p_action_information17 => l_leaving_reason
193: ,p_action_information18 => fnd_date.date_to_canonical(l_actual_termination_date)
194: ,p_action_information19 => p_value.ui_org_id
191: ,p_action_information16 => fnd_date.date_to_canonical(l_date_start)
192: ,p_action_information17 => l_leaving_reason
193: ,p_action_information18 => fnd_date.date_to_canonical(l_actual_termination_date)
194: ,p_action_information19 => p_value.ui_org_id
195: ,p_action_information20 => fnd_number.number_to_canonical(p_value.ui_prem_ee)
196: ,p_action_information21 => p_value.itax_org_id
197: ,p_action_information22 => p_value.itax_category
198: ,p_action_information23 => p_value.itax_yea_category
199: ,p_action_information24 => fnd_number.number_to_canonical(p_value.itax)
195: ,p_action_information20 => fnd_number.number_to_canonical(p_value.ui_prem_ee)
196: ,p_action_information21 => p_value.itax_org_id
197: ,p_action_information22 => p_value.itax_category
198: ,p_action_information23 => p_value.itax_yea_category
199: ,p_action_information24 => fnd_number.number_to_canonical(p_value.itax)
200: ,p_action_information25 => fnd_number.number_to_canonical(p_value.itax_adjustment)
201: ,p_action_information29 => fnd_number.number_to_canonical(p_value.disaster_tax_reduction)
202: ,p_action_information30 => l_employment_category
203: );
196: ,p_action_information21 => p_value.itax_org_id
197: ,p_action_information22 => p_value.itax_category
198: ,p_action_information23 => p_value.itax_yea_category
199: ,p_action_information24 => fnd_number.number_to_canonical(p_value.itax)
200: ,p_action_information25 => fnd_number.number_to_canonical(p_value.itax_adjustment)
201: ,p_action_information29 => fnd_number.number_to_canonical(p_value.disaster_tax_reduction)
202: ,p_action_information30 => l_employment_category
203: );
204:
197: ,p_action_information22 => p_value.itax_category
198: ,p_action_information23 => p_value.itax_yea_category
199: ,p_action_information24 => fnd_number.number_to_canonical(p_value.itax)
200: ,p_action_information25 => fnd_number.number_to_canonical(p_value.itax_adjustment)
201: ,p_action_information29 => fnd_number.number_to_canonical(p_value.disaster_tax_reduction)
202: ,p_action_information30 => l_employment_category
203: );
204:
205: pay_action_information_api.create_action_information
212: ,p_assignment_id => p_assignment_id
213: ,p_action_information_category => 'JP_PRE_TAX_2'
214: ,p_action_information1 => p_locked_assignment_action_id
215: ,p_action_information3 => p_value.ltax_district_code
216: ,p_action_information5 => fnd_number.number_to_canonical(p_value.ltax)
217: ,p_action_information6 => fnd_number.number_to_canonical(p_value.ltax_lumpsum)
218: ,p_action_information7 => fnd_number.number_to_canonical(p_value.sp_ltax)
219: ,p_action_information8 => fnd_number.number_to_canonical(p_value.sp_ltax_income)
220: ,p_action_information9 => fnd_number.number_to_canonical(p_value.sp_ltax_shi)
213: ,p_action_information_category => 'JP_PRE_TAX_2'
214: ,p_action_information1 => p_locked_assignment_action_id
215: ,p_action_information3 => p_value.ltax_district_code
216: ,p_action_information5 => fnd_number.number_to_canonical(p_value.ltax)
217: ,p_action_information6 => fnd_number.number_to_canonical(p_value.ltax_lumpsum)
218: ,p_action_information7 => fnd_number.number_to_canonical(p_value.sp_ltax)
219: ,p_action_information8 => fnd_number.number_to_canonical(p_value.sp_ltax_income)
220: ,p_action_information9 => fnd_number.number_to_canonical(p_value.sp_ltax_shi)
221: ,p_action_information10 => fnd_number.number_to_canonical(p_value.sp_ltax_to)
214: ,p_action_information1 => p_locked_assignment_action_id
215: ,p_action_information3 => p_value.ltax_district_code
216: ,p_action_information5 => fnd_number.number_to_canonical(p_value.ltax)
217: ,p_action_information6 => fnd_number.number_to_canonical(p_value.ltax_lumpsum)
218: ,p_action_information7 => fnd_number.number_to_canonical(p_value.sp_ltax)
219: ,p_action_information8 => fnd_number.number_to_canonical(p_value.sp_ltax_income)
220: ,p_action_information9 => fnd_number.number_to_canonical(p_value.sp_ltax_shi)
221: ,p_action_information10 => fnd_number.number_to_canonical(p_value.sp_ltax_to)
222: ,p_action_information11 => fnd_number.number_to_canonical(p_value.ci_prem_ee)
215: ,p_action_information3 => p_value.ltax_district_code
216: ,p_action_information5 => fnd_number.number_to_canonical(p_value.ltax)
217: ,p_action_information6 => fnd_number.number_to_canonical(p_value.ltax_lumpsum)
218: ,p_action_information7 => fnd_number.number_to_canonical(p_value.sp_ltax)
219: ,p_action_information8 => fnd_number.number_to_canonical(p_value.sp_ltax_income)
220: ,p_action_information9 => fnd_number.number_to_canonical(p_value.sp_ltax_shi)
221: ,p_action_information10 => fnd_number.number_to_canonical(p_value.sp_ltax_to)
222: ,p_action_information11 => fnd_number.number_to_canonical(p_value.ci_prem_ee)
223: ,p_action_information12 => fnd_number.number_to_canonical(p_value.ci_prem_er)
216: ,p_action_information5 => fnd_number.number_to_canonical(p_value.ltax)
217: ,p_action_information6 => fnd_number.number_to_canonical(p_value.ltax_lumpsum)
218: ,p_action_information7 => fnd_number.number_to_canonical(p_value.sp_ltax)
219: ,p_action_information8 => fnd_number.number_to_canonical(p_value.sp_ltax_income)
220: ,p_action_information9 => fnd_number.number_to_canonical(p_value.sp_ltax_shi)
221: ,p_action_information10 => fnd_number.number_to_canonical(p_value.sp_ltax_to)
222: ,p_action_information11 => fnd_number.number_to_canonical(p_value.ci_prem_ee)
223: ,p_action_information12 => fnd_number.number_to_canonical(p_value.ci_prem_er)
224: ,p_action_information14 => p_value.ui_category
217: ,p_action_information6 => fnd_number.number_to_canonical(p_value.ltax_lumpsum)
218: ,p_action_information7 => fnd_number.number_to_canonical(p_value.sp_ltax)
219: ,p_action_information8 => fnd_number.number_to_canonical(p_value.sp_ltax_income)
220: ,p_action_information9 => fnd_number.number_to_canonical(p_value.sp_ltax_shi)
221: ,p_action_information10 => fnd_number.number_to_canonical(p_value.sp_ltax_to)
222: ,p_action_information11 => fnd_number.number_to_canonical(p_value.ci_prem_ee)
223: ,p_action_information12 => fnd_number.number_to_canonical(p_value.ci_prem_er)
224: ,p_action_information14 => p_value.ui_category
225: ,p_action_information15 => p_value.sp_ltax_district_code
218: ,p_action_information7 => fnd_number.number_to_canonical(p_value.sp_ltax)
219: ,p_action_information8 => fnd_number.number_to_canonical(p_value.sp_ltax_income)
220: ,p_action_information9 => fnd_number.number_to_canonical(p_value.sp_ltax_shi)
221: ,p_action_information10 => fnd_number.number_to_canonical(p_value.sp_ltax_to)
222: ,p_action_information11 => fnd_number.number_to_canonical(p_value.ci_prem_ee)
223: ,p_action_information12 => fnd_number.number_to_canonical(p_value.ci_prem_er)
224: ,p_action_information14 => p_value.ui_category
225: ,p_action_information15 => p_value.sp_ltax_district_code
226: ,p_action_information16 => fnd_number.number_to_canonical(p_value.ui_sal_amt)
219: ,p_action_information8 => fnd_number.number_to_canonical(p_value.sp_ltax_income)
220: ,p_action_information9 => fnd_number.number_to_canonical(p_value.sp_ltax_shi)
221: ,p_action_information10 => fnd_number.number_to_canonical(p_value.sp_ltax_to)
222: ,p_action_information11 => fnd_number.number_to_canonical(p_value.ci_prem_ee)
223: ,p_action_information12 => fnd_number.number_to_canonical(p_value.ci_prem_er)
224: ,p_action_information14 => p_value.ui_category
225: ,p_action_information15 => p_value.sp_ltax_district_code
226: ,p_action_information16 => fnd_number.number_to_canonical(p_value.ui_sal_amt)
227: ,p_action_information17 => p_value.wai_org_id
222: ,p_action_information11 => fnd_number.number_to_canonical(p_value.ci_prem_ee)
223: ,p_action_information12 => fnd_number.number_to_canonical(p_value.ci_prem_er)
224: ,p_action_information14 => p_value.ui_category
225: ,p_action_information15 => p_value.sp_ltax_district_code
226: ,p_action_information16 => fnd_number.number_to_canonical(p_value.ui_sal_amt)
227: ,p_action_information17 => p_value.wai_org_id
228: ,p_action_information18 => p_value.wai_category
229: ,p_action_information19 => fnd_number.number_to_canonical(p_value.wai_sal_amt)
230: ,p_action_information20 => fnd_number.number_to_canonical(p_value.wpf_prem_er)
225: ,p_action_information15 => p_value.sp_ltax_district_code
226: ,p_action_information16 => fnd_number.number_to_canonical(p_value.ui_sal_amt)
227: ,p_action_information17 => p_value.wai_org_id
228: ,p_action_information18 => p_value.wai_category
229: ,p_action_information19 => fnd_number.number_to_canonical(p_value.wai_sal_amt)
230: ,p_action_information20 => fnd_number.number_to_canonical(p_value.wpf_prem_er)
231: );
232:
233: end if;
226: ,p_action_information16 => fnd_number.number_to_canonical(p_value.ui_sal_amt)
227: ,p_action_information17 => p_value.wai_org_id
228: ,p_action_information18 => p_value.wai_category
229: ,p_action_information19 => fnd_number.number_to_canonical(p_value.wai_sal_amt)
230: ,p_action_information20 => fnd_number.number_to_canonical(p_value.wpf_prem_er)
231: );
232:
233: end if;
234: