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