352: employer_name_kana,
353: employer_name
354: from (
355: select /*+ ORDERED USE_NL(PEL PEE PEEV PIV) */
356: nvl(fnd_number.canonical_to_number(min(decode(piv.display_sequence, 1, peev.screen_entry_value))), 0) employment_income,
357: nvl(fnd_number.canonical_to_number(min(decode(piv.display_sequence, 2, peev.screen_entry_value))), 0) si_prems,
358: nvl(fnd_number.canonical_to_number(min(decode(piv.display_sequence, 3, peev.screen_entry_value))), 0) mutual_aid_prem,
359: nvl(fnd_number.canonical_to_number(min(decode(piv.display_sequence, 4, peev.screen_entry_value))), 0) withholding_tax,
360: fnd_date.canonical_to_date(min(decode(piv.display_sequence, 5, peev.screen_entry_value))) termination_date,
353: employer_name
354: from (
355: select /*+ ORDERED USE_NL(PEL PEE PEEV PIV) */
356: nvl(fnd_number.canonical_to_number(min(decode(piv.display_sequence, 1, peev.screen_entry_value))), 0) employment_income,
357: nvl(fnd_number.canonical_to_number(min(decode(piv.display_sequence, 2, peev.screen_entry_value))), 0) si_prems,
358: nvl(fnd_number.canonical_to_number(min(decode(piv.display_sequence, 3, peev.screen_entry_value))), 0) mutual_aid_prem,
359: nvl(fnd_number.canonical_to_number(min(decode(piv.display_sequence, 4, peev.screen_entry_value))), 0) withholding_tax,
360: fnd_date.canonical_to_date(min(decode(piv.display_sequence, 5, peev.screen_entry_value))) termination_date,
361: nvl(min(decode(piv.display_sequence, 6, peev.screen_entry_value)), 'N') foreign_flag,
354: from (
355: select /*+ ORDERED USE_NL(PEL PEE PEEV PIV) */
356: nvl(fnd_number.canonical_to_number(min(decode(piv.display_sequence, 1, peev.screen_entry_value))), 0) employment_income,
357: nvl(fnd_number.canonical_to_number(min(decode(piv.display_sequence, 2, peev.screen_entry_value))), 0) si_prems,
358: nvl(fnd_number.canonical_to_number(min(decode(piv.display_sequence, 3, peev.screen_entry_value))), 0) mutual_aid_prem,
359: nvl(fnd_number.canonical_to_number(min(decode(piv.display_sequence, 4, peev.screen_entry_value))), 0) withholding_tax,
360: fnd_date.canonical_to_date(min(decode(piv.display_sequence, 5, peev.screen_entry_value))) termination_date,
361: nvl(min(decode(piv.display_sequence, 6, peev.screen_entry_value)), 'N') foreign_flag,
362: min(decode(piv.display_sequence, 7, peev.screen_entry_value)) employer_address_kana,
355: select /*+ ORDERED USE_NL(PEL PEE PEEV PIV) */
356: nvl(fnd_number.canonical_to_number(min(decode(piv.display_sequence, 1, peev.screen_entry_value))), 0) employment_income,
357: nvl(fnd_number.canonical_to_number(min(decode(piv.display_sequence, 2, peev.screen_entry_value))), 0) si_prems,
358: nvl(fnd_number.canonical_to_number(min(decode(piv.display_sequence, 3, peev.screen_entry_value))), 0) mutual_aid_prem,
359: nvl(fnd_number.canonical_to_number(min(decode(piv.display_sequence, 4, peev.screen_entry_value))), 0) withholding_tax,
360: fnd_date.canonical_to_date(min(decode(piv.display_sequence, 5, peev.screen_entry_value))) termination_date,
361: nvl(min(decode(piv.display_sequence, 6, peev.screen_entry_value)), 'N') foreign_flag,
362: min(decode(piv.display_sequence, 7, peev.screen_entry_value)) employer_address_kana,
363: min(decode(piv.display_sequence, 8, peev.screen_entry_value)) employer_address,
517: P_EMPLOYER_COUNTRY => l_prev_employer.employer_country,
518: P_PEM_INFORMATION_CATEGORY => 'JP',
519: P_PEM_INFORMATION1 => l_prev_job.employer_name_kana,
520: P_PEM_INFORMATION2 => l_prev_job.employer_address_kana,
521: P_PEM_INFORMATION3 => fnd_number.number_to_canonical(l_prev_job.employment_income),
522: P_PEM_INFORMATION4 => fnd_number.number_to_canonical(l_prev_job.si_prems),
523: P_PEM_INFORMATION5 => fnd_number.number_to_canonical(l_prev_job.mutual_aid_prem),
524: P_PEM_INFORMATION6 => fnd_number.number_to_canonical(l_prev_job.withholding_tax),
525: P_OBJECT_VERSION_NUMBER => l_prev_employer.object_version_number);
518: P_PEM_INFORMATION_CATEGORY => 'JP',
519: P_PEM_INFORMATION1 => l_prev_job.employer_name_kana,
520: P_PEM_INFORMATION2 => l_prev_job.employer_address_kana,
521: P_PEM_INFORMATION3 => fnd_number.number_to_canonical(l_prev_job.employment_income),
522: P_PEM_INFORMATION4 => fnd_number.number_to_canonical(l_prev_job.si_prems),
523: P_PEM_INFORMATION5 => fnd_number.number_to_canonical(l_prev_job.mutual_aid_prem),
524: P_PEM_INFORMATION6 => fnd_number.number_to_canonical(l_prev_job.withholding_tax),
525: P_OBJECT_VERSION_NUMBER => l_prev_employer.object_version_number);
526: else
519: P_PEM_INFORMATION1 => l_prev_job.employer_name_kana,
520: P_PEM_INFORMATION2 => l_prev_job.employer_address_kana,
521: P_PEM_INFORMATION3 => fnd_number.number_to_canonical(l_prev_job.employment_income),
522: P_PEM_INFORMATION4 => fnd_number.number_to_canonical(l_prev_job.si_prems),
523: P_PEM_INFORMATION5 => fnd_number.number_to_canonical(l_prev_job.mutual_aid_prem),
524: P_PEM_INFORMATION6 => fnd_number.number_to_canonical(l_prev_job.withholding_tax),
525: P_OBJECT_VERSION_NUMBER => l_prev_employer.object_version_number);
526: else
527: hr_utility.trace('Inserting PER_PREVIOUS_EMPLOYERS...');
520: P_PEM_INFORMATION2 => l_prev_job.employer_address_kana,
521: P_PEM_INFORMATION3 => fnd_number.number_to_canonical(l_prev_job.employment_income),
522: P_PEM_INFORMATION4 => fnd_number.number_to_canonical(l_prev_job.si_prems),
523: P_PEM_INFORMATION5 => fnd_number.number_to_canonical(l_prev_job.mutual_aid_prem),
524: P_PEM_INFORMATION6 => fnd_number.number_to_canonical(l_prev_job.withholding_tax),
525: P_OBJECT_VERSION_NUMBER => l_prev_employer.object_version_number);
526: else
527: hr_utility.trace('Inserting PER_PREVIOUS_EMPLOYERS...');
528: --
545: P_EMPLOYER_ADDRESS => l_prev_job.employer_address,
546: P_PEM_INFORMATION_CATEGORY => 'JP',
547: P_PEM_INFORMATION1 => l_prev_job.employer_name_kana,
548: P_PEM_INFORMATION2 => l_prev_job.employer_address_kana,
549: P_PEM_INFORMATION3 => fnd_number.number_to_canonical(l_prev_job.employment_income),
550: P_PEM_INFORMATION4 => fnd_number.number_to_canonical(l_prev_job.si_prems),
551: P_PEM_INFORMATION5 => fnd_number.number_to_canonical(l_prev_job.mutual_aid_prem),
552: P_PEM_INFORMATION6 => fnd_number.number_to_canonical(l_prev_job.withholding_tax),
553: P_PREVIOUS_EMPLOYER_ID => l_prev_employer.previous_employer_id,
546: P_PEM_INFORMATION_CATEGORY => 'JP',
547: P_PEM_INFORMATION1 => l_prev_job.employer_name_kana,
548: P_PEM_INFORMATION2 => l_prev_job.employer_address_kana,
549: P_PEM_INFORMATION3 => fnd_number.number_to_canonical(l_prev_job.employment_income),
550: P_PEM_INFORMATION4 => fnd_number.number_to_canonical(l_prev_job.si_prems),
551: P_PEM_INFORMATION5 => fnd_number.number_to_canonical(l_prev_job.mutual_aid_prem),
552: P_PEM_INFORMATION6 => fnd_number.number_to_canonical(l_prev_job.withholding_tax),
553: P_PREVIOUS_EMPLOYER_ID => l_prev_employer.previous_employer_id,
554: P_OBJECT_VERSION_NUMBER => l_prev_employer.object_version_number);
547: P_PEM_INFORMATION1 => l_prev_job.employer_name_kana,
548: P_PEM_INFORMATION2 => l_prev_job.employer_address_kana,
549: P_PEM_INFORMATION3 => fnd_number.number_to_canonical(l_prev_job.employment_income),
550: P_PEM_INFORMATION4 => fnd_number.number_to_canonical(l_prev_job.si_prems),
551: P_PEM_INFORMATION5 => fnd_number.number_to_canonical(l_prev_job.mutual_aid_prem),
552: P_PEM_INFORMATION6 => fnd_number.number_to_canonical(l_prev_job.withholding_tax),
553: P_PREVIOUS_EMPLOYER_ID => l_prev_employer.previous_employer_id,
554: P_OBJECT_VERSION_NUMBER => l_prev_employer.object_version_number);
555: end if;
548: P_PEM_INFORMATION2 => l_prev_job.employer_address_kana,
549: P_PEM_INFORMATION3 => fnd_number.number_to_canonical(l_prev_job.employment_income),
550: P_PEM_INFORMATION4 => fnd_number.number_to_canonical(l_prev_job.si_prems),
551: P_PEM_INFORMATION5 => fnd_number.number_to_canonical(l_prev_job.mutual_aid_prem),
552: P_PEM_INFORMATION6 => fnd_number.number_to_canonical(l_prev_job.withholding_tax),
553: P_PREVIOUS_EMPLOYER_ID => l_prev_employer.previous_employer_id,
554: P_OBJECT_VERSION_NUMBER => l_prev_employer.object_version_number);
555: end if;
556: close csr_prev_employer;
1404: ,p_object_version_number => l_ovn
1405: ,p_effective_date => l_effective_date
1406: ,p_assignment_id => p_assignment_id
1407: ,p_action_information_category => 'JP_PRE_TAX_1'
1408: ,p_action_information1 => fnd_number.number_to_canonical(l_pre_tax.assignment_action_id)
1409: ,p_action_information2 => fnd_number.number_to_canonical(l_pre_tax.taxable_sal_amt)
1410: ,p_action_information3 => fnd_number.number_to_canonical(l_pre_tax.taxable_mat_amt)
1411: ,p_action_information4 => fnd_number.number_to_canonical(l_person_id)
1412: ,p_action_information5 => l_pre_tax.hi_organization_id
1405: ,p_effective_date => l_effective_date
1406: ,p_assignment_id => p_assignment_id
1407: ,p_action_information_category => 'JP_PRE_TAX_1'
1408: ,p_action_information1 => fnd_number.number_to_canonical(l_pre_tax.assignment_action_id)
1409: ,p_action_information2 => fnd_number.number_to_canonical(l_pre_tax.taxable_sal_amt)
1410: ,p_action_information3 => fnd_number.number_to_canonical(l_pre_tax.taxable_mat_amt)
1411: ,p_action_information4 => fnd_number.number_to_canonical(l_person_id)
1412: ,p_action_information5 => l_pre_tax.hi_organization_id
1413: ,p_action_information6 => fnd_number.number_to_canonical(l_pre_tax.hi_prem_ee)
1406: ,p_assignment_id => p_assignment_id
1407: ,p_action_information_category => 'JP_PRE_TAX_1'
1408: ,p_action_information1 => fnd_number.number_to_canonical(l_pre_tax.assignment_action_id)
1409: ,p_action_information2 => fnd_number.number_to_canonical(l_pre_tax.taxable_sal_amt)
1410: ,p_action_information3 => fnd_number.number_to_canonical(l_pre_tax.taxable_mat_amt)
1411: ,p_action_information4 => fnd_number.number_to_canonical(l_person_id)
1412: ,p_action_information5 => l_pre_tax.hi_organization_id
1413: ,p_action_information6 => fnd_number.number_to_canonical(l_pre_tax.hi_prem_ee)
1414: ,p_action_information7 => fnd_number.number_to_canonical(l_pre_tax.hi_prem_er)
1407: ,p_action_information_category => 'JP_PRE_TAX_1'
1408: ,p_action_information1 => fnd_number.number_to_canonical(l_pre_tax.assignment_action_id)
1409: ,p_action_information2 => fnd_number.number_to_canonical(l_pre_tax.taxable_sal_amt)
1410: ,p_action_information3 => fnd_number.number_to_canonical(l_pre_tax.taxable_mat_amt)
1411: ,p_action_information4 => fnd_number.number_to_canonical(l_person_id)
1412: ,p_action_information5 => l_pre_tax.hi_organization_id
1413: ,p_action_information6 => fnd_number.number_to_canonical(l_pre_tax.hi_prem_ee)
1414: ,p_action_information7 => fnd_number.number_to_canonical(l_pre_tax.hi_prem_er)
1415: ,p_action_information8 => l_pre_tax.wp_organization_id
1409: ,p_action_information2 => fnd_number.number_to_canonical(l_pre_tax.taxable_sal_amt)
1410: ,p_action_information3 => fnd_number.number_to_canonical(l_pre_tax.taxable_mat_amt)
1411: ,p_action_information4 => fnd_number.number_to_canonical(l_person_id)
1412: ,p_action_information5 => l_pre_tax.hi_organization_id
1413: ,p_action_information6 => fnd_number.number_to_canonical(l_pre_tax.hi_prem_ee)
1414: ,p_action_information7 => fnd_number.number_to_canonical(l_pre_tax.hi_prem_er)
1415: ,p_action_information8 => l_pre_tax.wp_organization_id
1416: ,p_action_information9 => fnd_number.number_to_canonical(l_pre_tax.wp_prem_ee)
1417: ,p_action_information10 => fnd_number.number_to_canonical(l_pre_tax.wp_prem_er)
1410: ,p_action_information3 => fnd_number.number_to_canonical(l_pre_tax.taxable_mat_amt)
1411: ,p_action_information4 => fnd_number.number_to_canonical(l_person_id)
1412: ,p_action_information5 => l_pre_tax.hi_organization_id
1413: ,p_action_information6 => fnd_number.number_to_canonical(l_pre_tax.hi_prem_ee)
1414: ,p_action_information7 => fnd_number.number_to_canonical(l_pre_tax.hi_prem_er)
1415: ,p_action_information8 => l_pre_tax.wp_organization_id
1416: ,p_action_information9 => fnd_number.number_to_canonical(l_pre_tax.wp_prem_ee)
1417: ,p_action_information10 => fnd_number.number_to_canonical(l_pre_tax.wp_prem_er)
1418: ,p_action_information11 => l_pre_tax.wpf_organization_id
1412: ,p_action_information5 => l_pre_tax.hi_organization_id
1413: ,p_action_information6 => fnd_number.number_to_canonical(l_pre_tax.hi_prem_ee)
1414: ,p_action_information7 => fnd_number.number_to_canonical(l_pre_tax.hi_prem_er)
1415: ,p_action_information8 => l_pre_tax.wp_organization_id
1416: ,p_action_information9 => fnd_number.number_to_canonical(l_pre_tax.wp_prem_ee)
1417: ,p_action_information10 => fnd_number.number_to_canonical(l_pre_tax.wp_prem_er)
1418: ,p_action_information11 => l_pre_tax.wpf_organization_id
1419: ,p_action_information12 => fnd_number.number_to_canonical(l_pre_tax.wpf_prem_ee)
1420: ,p_action_information13 => l_pre_tax.salary_category
1413: ,p_action_information6 => fnd_number.number_to_canonical(l_pre_tax.hi_prem_ee)
1414: ,p_action_information7 => fnd_number.number_to_canonical(l_pre_tax.hi_prem_er)
1415: ,p_action_information8 => l_pre_tax.wp_organization_id
1416: ,p_action_information9 => fnd_number.number_to_canonical(l_pre_tax.wp_prem_ee)
1417: ,p_action_information10 => fnd_number.number_to_canonical(l_pre_tax.wp_prem_er)
1418: ,p_action_information11 => l_pre_tax.wpf_organization_id
1419: ,p_action_information12 => fnd_number.number_to_canonical(l_pre_tax.wpf_prem_ee)
1420: ,p_action_information13 => l_pre_tax.salary_category
1421: ,p_action_information14 => fnd_number.number_to_canonical(l_pre_tax.mutual_aid)
1415: ,p_action_information8 => l_pre_tax.wp_organization_id
1416: ,p_action_information9 => fnd_number.number_to_canonical(l_pre_tax.wp_prem_ee)
1417: ,p_action_information10 => fnd_number.number_to_canonical(l_pre_tax.wp_prem_er)
1418: ,p_action_information11 => l_pre_tax.wpf_organization_id
1419: ,p_action_information12 => fnd_number.number_to_canonical(l_pre_tax.wpf_prem_ee)
1420: ,p_action_information13 => l_pre_tax.salary_category
1421: ,p_action_information14 => fnd_number.number_to_canonical(l_pre_tax.mutual_aid)
1422: ,p_action_information15 => fnd_number.number_to_canonical(l_period_of_service_id)
1423: ,p_action_information16 => to_char(l_date_start,'YYYY/MM/DD')
1417: ,p_action_information10 => fnd_number.number_to_canonical(l_pre_tax.wp_prem_er)
1418: ,p_action_information11 => l_pre_tax.wpf_organization_id
1419: ,p_action_information12 => fnd_number.number_to_canonical(l_pre_tax.wpf_prem_ee)
1420: ,p_action_information13 => l_pre_tax.salary_category
1421: ,p_action_information14 => fnd_number.number_to_canonical(l_pre_tax.mutual_aid)
1422: ,p_action_information15 => fnd_number.number_to_canonical(l_period_of_service_id)
1423: ,p_action_information16 => to_char(l_date_start,'YYYY/MM/DD')
1424: ,p_action_information17 => l_leaving_reason
1425: ,p_action_information18 => to_char(l_actual_termination_date,'YYYY/MM/DD')
1418: ,p_action_information11 => l_pre_tax.wpf_organization_id
1419: ,p_action_information12 => fnd_number.number_to_canonical(l_pre_tax.wpf_prem_ee)
1420: ,p_action_information13 => l_pre_tax.salary_category
1421: ,p_action_information14 => fnd_number.number_to_canonical(l_pre_tax.mutual_aid)
1422: ,p_action_information15 => fnd_number.number_to_canonical(l_period_of_service_id)
1423: ,p_action_information16 => to_char(l_date_start,'YYYY/MM/DD')
1424: ,p_action_information17 => l_leaving_reason
1425: ,p_action_information18 => to_char(l_actual_termination_date,'YYYY/MM/DD')
1426: ,p_action_information19 => l_pre_tax.ui_organization_id
1423: ,p_action_information16 => to_char(l_date_start,'YYYY/MM/DD')
1424: ,p_action_information17 => l_leaving_reason
1425: ,p_action_information18 => to_char(l_actual_termination_date,'YYYY/MM/DD')
1426: ,p_action_information19 => l_pre_tax.ui_organization_id
1427: ,p_action_information20 => fnd_number.number_to_canonical(l_pre_tax.ui_prem_ee)
1428: ,p_action_information21 => l_pre_tax.itax_organization_id
1429: ,p_action_information22 => l_pre_tax.itax_category
1430: ,p_action_information23 => l_pre_tax.itax_yea_category
1431: ,p_action_information24 => fnd_number.number_to_canonical(l_pre_tax.itax)
1427: ,p_action_information20 => fnd_number.number_to_canonical(l_pre_tax.ui_prem_ee)
1428: ,p_action_information21 => l_pre_tax.itax_organization_id
1429: ,p_action_information22 => l_pre_tax.itax_category
1430: ,p_action_information23 => l_pre_tax.itax_yea_category
1431: ,p_action_information24 => fnd_number.number_to_canonical(l_pre_tax.itax)
1432: ,p_action_information25 => fnd_number.number_to_canonical(l_pre_tax.itax_adjustment)
1433: ,p_action_information26 => fnd_number.number_to_canonical(l_pre_tax.pre_tax_id)
1434: ,p_action_information29 => fnd_number.number_to_canonical(l_pre_tax.disaster_tax_reduction)
1435: ,p_action_information30 => l_employment_category
1428: ,p_action_information21 => l_pre_tax.itax_organization_id
1429: ,p_action_information22 => l_pre_tax.itax_category
1430: ,p_action_information23 => l_pre_tax.itax_yea_category
1431: ,p_action_information24 => fnd_number.number_to_canonical(l_pre_tax.itax)
1432: ,p_action_information25 => fnd_number.number_to_canonical(l_pre_tax.itax_adjustment)
1433: ,p_action_information26 => fnd_number.number_to_canonical(l_pre_tax.pre_tax_id)
1434: ,p_action_information29 => fnd_number.number_to_canonical(l_pre_tax.disaster_tax_reduction)
1435: ,p_action_information30 => l_employment_category
1436: );
1429: ,p_action_information22 => l_pre_tax.itax_category
1430: ,p_action_information23 => l_pre_tax.itax_yea_category
1431: ,p_action_information24 => fnd_number.number_to_canonical(l_pre_tax.itax)
1432: ,p_action_information25 => fnd_number.number_to_canonical(l_pre_tax.itax_adjustment)
1433: ,p_action_information26 => fnd_number.number_to_canonical(l_pre_tax.pre_tax_id)
1434: ,p_action_information29 => fnd_number.number_to_canonical(l_pre_tax.disaster_tax_reduction)
1435: ,p_action_information30 => l_employment_category
1436: );
1437:
1430: ,p_action_information23 => l_pre_tax.itax_yea_category
1431: ,p_action_information24 => fnd_number.number_to_canonical(l_pre_tax.itax)
1432: ,p_action_information25 => fnd_number.number_to_canonical(l_pre_tax.itax_adjustment)
1433: ,p_action_information26 => fnd_number.number_to_canonical(l_pre_tax.pre_tax_id)
1434: ,p_action_information29 => fnd_number.number_to_canonical(l_pre_tax.disaster_tax_reduction)
1435: ,p_action_information30 => l_employment_category
1436: );
1437:
1438: pay_action_information_api.create_action_information
1445: ,p_assignment_id => p_assignment_id
1446: ,p_action_information_category => 'JP_PRE_TAX_2'
1447: ,p_action_information1 => l_pre_tax.assignment_action_id
1448: ,p_action_information3 => l_pre_tax.ltax_district_code
1449: ,p_action_information5 => fnd_number.number_to_canonical(l_pre_tax.ltax)
1450: ,p_action_information6 => fnd_number.number_to_canonical(l_pre_tax.ltax_lumpsum)
1451: ,p_action_information7 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax)
1452: ,p_action_information8 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax_income)
1453: ,p_action_information9 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax_shi)
1446: ,p_action_information_category => 'JP_PRE_TAX_2'
1447: ,p_action_information1 => l_pre_tax.assignment_action_id
1448: ,p_action_information3 => l_pre_tax.ltax_district_code
1449: ,p_action_information5 => fnd_number.number_to_canonical(l_pre_tax.ltax)
1450: ,p_action_information6 => fnd_number.number_to_canonical(l_pre_tax.ltax_lumpsum)
1451: ,p_action_information7 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax)
1452: ,p_action_information8 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax_income)
1453: ,p_action_information9 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax_shi)
1454: ,p_action_information10 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax_to)
1447: ,p_action_information1 => l_pre_tax.assignment_action_id
1448: ,p_action_information3 => l_pre_tax.ltax_district_code
1449: ,p_action_information5 => fnd_number.number_to_canonical(l_pre_tax.ltax)
1450: ,p_action_information6 => fnd_number.number_to_canonical(l_pre_tax.ltax_lumpsum)
1451: ,p_action_information7 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax)
1452: ,p_action_information8 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax_income)
1453: ,p_action_information9 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax_shi)
1454: ,p_action_information10 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax_to)
1455: ,p_action_information11 => fnd_number.number_to_canonical(l_pre_tax.ci_prem_ee)
1448: ,p_action_information3 => l_pre_tax.ltax_district_code
1449: ,p_action_information5 => fnd_number.number_to_canonical(l_pre_tax.ltax)
1450: ,p_action_information6 => fnd_number.number_to_canonical(l_pre_tax.ltax_lumpsum)
1451: ,p_action_information7 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax)
1452: ,p_action_information8 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax_income)
1453: ,p_action_information9 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax_shi)
1454: ,p_action_information10 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax_to)
1455: ,p_action_information11 => fnd_number.number_to_canonical(l_pre_tax.ci_prem_ee)
1456: ,p_action_information12 => fnd_number.number_to_canonical(l_pre_tax.ci_prem_er)
1449: ,p_action_information5 => fnd_number.number_to_canonical(l_pre_tax.ltax)
1450: ,p_action_information6 => fnd_number.number_to_canonical(l_pre_tax.ltax_lumpsum)
1451: ,p_action_information7 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax)
1452: ,p_action_information8 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax_income)
1453: ,p_action_information9 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax_shi)
1454: ,p_action_information10 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax_to)
1455: ,p_action_information11 => fnd_number.number_to_canonical(l_pre_tax.ci_prem_ee)
1456: ,p_action_information12 => fnd_number.number_to_canonical(l_pre_tax.ci_prem_er)
1457: ,p_action_information13 => fnd_number.number_to_canonical(0)
1450: ,p_action_information6 => fnd_number.number_to_canonical(l_pre_tax.ltax_lumpsum)
1451: ,p_action_information7 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax)
1452: ,p_action_information8 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax_income)
1453: ,p_action_information9 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax_shi)
1454: ,p_action_information10 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax_to)
1455: ,p_action_information11 => fnd_number.number_to_canonical(l_pre_tax.ci_prem_ee)
1456: ,p_action_information12 => fnd_number.number_to_canonical(l_pre_tax.ci_prem_er)
1457: ,p_action_information13 => fnd_number.number_to_canonical(0)
1458: ,p_action_information14 => l_pre_tax.ui_category
1451: ,p_action_information7 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax)
1452: ,p_action_information8 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax_income)
1453: ,p_action_information9 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax_shi)
1454: ,p_action_information10 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax_to)
1455: ,p_action_information11 => fnd_number.number_to_canonical(l_pre_tax.ci_prem_ee)
1456: ,p_action_information12 => fnd_number.number_to_canonical(l_pre_tax.ci_prem_er)
1457: ,p_action_information13 => fnd_number.number_to_canonical(0)
1458: ,p_action_information14 => l_pre_tax.ui_category
1459: ,p_action_information15 => l_pre_tax.sp_ltax_district_code
1452: ,p_action_information8 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax_income)
1453: ,p_action_information9 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax_shi)
1454: ,p_action_information10 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax_to)
1455: ,p_action_information11 => fnd_number.number_to_canonical(l_pre_tax.ci_prem_ee)
1456: ,p_action_information12 => fnd_number.number_to_canonical(l_pre_tax.ci_prem_er)
1457: ,p_action_information13 => fnd_number.number_to_canonical(0)
1458: ,p_action_information14 => l_pre_tax.ui_category
1459: ,p_action_information15 => l_pre_tax.sp_ltax_district_code
1460: ,p_action_information16 => fnd_number.number_to_canonical(l_pre_tax.ui_sal_amt)
1453: ,p_action_information9 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax_shi)
1454: ,p_action_information10 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax_to)
1455: ,p_action_information11 => fnd_number.number_to_canonical(l_pre_tax.ci_prem_ee)
1456: ,p_action_information12 => fnd_number.number_to_canonical(l_pre_tax.ci_prem_er)
1457: ,p_action_information13 => fnd_number.number_to_canonical(0)
1458: ,p_action_information14 => l_pre_tax.ui_category
1459: ,p_action_information15 => l_pre_tax.sp_ltax_district_code
1460: ,p_action_information16 => fnd_number.number_to_canonical(l_pre_tax.ui_sal_amt)
1461: ,p_action_information17 => l_pre_tax.wai_organization_id
1456: ,p_action_information12 => fnd_number.number_to_canonical(l_pre_tax.ci_prem_er)
1457: ,p_action_information13 => fnd_number.number_to_canonical(0)
1458: ,p_action_information14 => l_pre_tax.ui_category
1459: ,p_action_information15 => l_pre_tax.sp_ltax_district_code
1460: ,p_action_information16 => fnd_number.number_to_canonical(l_pre_tax.ui_sal_amt)
1461: ,p_action_information17 => l_pre_tax.wai_organization_id
1462: ,p_action_information18 => l_pre_tax.wai_category
1463: ,p_action_information19 => fnd_number.number_to_canonical(l_pre_tax.wai_sal_amt)
1464: ,p_action_information20 => fnd_number.number_to_canonical(l_pre_tax.wpf_prem_er)
1459: ,p_action_information15 => l_pre_tax.sp_ltax_district_code
1460: ,p_action_information16 => fnd_number.number_to_canonical(l_pre_tax.ui_sal_amt)
1461: ,p_action_information17 => l_pre_tax.wai_organization_id
1462: ,p_action_information18 => l_pre_tax.wai_category
1463: ,p_action_information19 => fnd_number.number_to_canonical(l_pre_tax.wai_sal_amt)
1464: ,p_action_information20 => fnd_number.number_to_canonical(l_pre_tax.wpf_prem_er)
1465: ,p_action_information21 => fnd_number.number_to_canonical(0)
1466: );
1467:
1460: ,p_action_information16 => fnd_number.number_to_canonical(l_pre_tax.ui_sal_amt)
1461: ,p_action_information17 => l_pre_tax.wai_organization_id
1462: ,p_action_information18 => l_pre_tax.wai_category
1463: ,p_action_information19 => fnd_number.number_to_canonical(l_pre_tax.wai_sal_amt)
1464: ,p_action_information20 => fnd_number.number_to_canonical(l_pre_tax.wpf_prem_er)
1465: ,p_action_information21 => fnd_number.number_to_canonical(0)
1466: );
1467:
1468: end loop;
1461: ,p_action_information17 => l_pre_tax.wai_organization_id
1462: ,p_action_information18 => l_pre_tax.wai_category
1463: ,p_action_information19 => fnd_number.number_to_canonical(l_pre_tax.wai_sal_amt)
1464: ,p_action_information20 => fnd_number.number_to_canonical(l_pre_tax.wpf_prem_er)
1465: ,p_action_information21 => fnd_number.number_to_canonical(0)
1466: );
1467:
1468: end loop;
1469: --
1731: --
1732: for l_pact in csr_pacts loop
1733: p_valid_upgrade := 'TRUE';
1734: --
1735: l_payroll_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAYROLL', l_pact.legislative_parameters));
1736: l_itax_organization_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('SWOT', l_pact.legislative_parameters));
1737: l_include_terminated_flag := 'Y';
1738: l_termination_date_from := null;
1739: l_termination_date_to := null;
1732: for l_pact in csr_pacts loop
1733: p_valid_upgrade := 'TRUE';
1734: --
1735: l_payroll_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAYROLL', l_pact.legislative_parameters));
1736: l_itax_organization_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('SWOT', l_pact.legislative_parameters));
1737: l_include_terminated_flag := 'Y';
1738: l_termination_date_from := null;
1739: l_termination_date_to := null;
1740: l_rearchive_flag := 'Y';
1743: l_publication_start_date := fnd_date.canonical_to_date(pay_core_utils.get_parameter('OPEN_DATE', l_pact.legislative_parameters));
1744: l_publication_end_date := fnd_date.canonical_to_date(pay_core_utils.get_parameter('CLOSE_DATE', l_pact.legislative_parameters));
1745: --
1746: l_legislative_parameters := null;
1747: concat_parameter('PAYROLL_ID', fnd_number.number_to_canonical(l_payroll_id));
1748: concat_parameter('ITAX_ORGANIZATION_ID', fnd_number.number_to_canonical(l_itax_organization_id));
1749: concat_parameter('INCLUDE_TERMINATED_FLAG', l_include_terminated_flag);
1750: concat_parameter('TERMINATION_DATE_FROM', fnd_date.date_to_canonical(l_termination_date_from));
1751: concat_parameter('TERMINATION_DATE_TO', fnd_date.date_to_canonical(l_termination_date_to));
1744: l_publication_end_date := fnd_date.canonical_to_date(pay_core_utils.get_parameter('CLOSE_DATE', l_pact.legislative_parameters));
1745: --
1746: l_legislative_parameters := null;
1747: concat_parameter('PAYROLL_ID', fnd_number.number_to_canonical(l_payroll_id));
1748: concat_parameter('ITAX_ORGANIZATION_ID', fnd_number.number_to_canonical(l_itax_organization_id));
1749: concat_parameter('INCLUDE_TERMINATED_FLAG', l_include_terminated_flag);
1750: concat_parameter('TERMINATION_DATE_FROM', fnd_date.date_to_canonical(l_termination_date_from));
1751: concat_parameter('TERMINATION_DATE_TO', fnd_date.date_to_canonical(l_termination_date_to));
1752: concat_parameter('REARCHIVE_FLAG', l_rearchive_flag);
1768: p_action_context_id => l_pact.payroll_action_id,
1769: p_action_context_type => 'PA',
1770: p_action_information_category => 'JP_ITAX_PACT',
1771: p_effective_date => l_pact.effective_date,
1772: p_action_information1 => fnd_number.number_to_canonical(l_payroll_id),
1773: p_action_information2 => fnd_number.number_to_canonical(l_itax_organization_id),
1774: p_action_information3 => l_include_terminated_flag,
1775: p_action_information4 => fnd_date.date_to_canonical(l_termination_date_from),
1776: p_action_information5 => fnd_date.date_to_canonical(l_termination_date_to),
1769: p_action_context_type => 'PA',
1770: p_action_information_category => 'JP_ITAX_PACT',
1771: p_effective_date => l_pact.effective_date,
1772: p_action_information1 => fnd_number.number_to_canonical(l_payroll_id),
1773: p_action_information2 => fnd_number.number_to_canonical(l_itax_organization_id),
1774: p_action_information3 => l_include_terminated_flag,
1775: p_action_information4 => fnd_date.date_to_canonical(l_termination_date_from),
1776: p_action_information5 => fnd_date.date_to_canonical(l_termination_date_to),
1777: p_action_information6 => l_publication_period_status,
2496: argument3 => 'DEFAULT', -- Rpt Qual
2497: argument4 => null, -- Start Date
2498: argument5 => null, -- End Date
2499: argument6 => 'PROCESS', -- Rpt Category
2500: argument7 => fnd_number.number_to_canonical(l_business_group_id), -- Business Grp
2501: argument8 => null, -- Mag File Nme
2502: argument9 => null, -- Rep File Nme
2503: argument10 => fnd_number.number_to_canonical(l_upgrade_def.upgrade_definition_id), -- ID
2504: argument11 => p_upgrade_short_name, -- Short Name
2499: argument6 => 'PROCESS', -- Rpt Category
2500: argument7 => fnd_number.number_to_canonical(l_business_group_id), -- Business Grp
2501: argument8 => null, -- Mag File Nme
2502: argument9 => null, -- Rep File Nme
2503: argument10 => fnd_number.number_to_canonical(l_upgrade_def.upgrade_definition_id), -- ID
2504: argument11 => p_upgrade_short_name, -- Short Name
2505: argument12 => 'UPG_DEF_NAME=' || p_upgrade_short_name); -- Upgrade Name
2506: if l_request_id = 0 then
2507: hr_utility.raise_error;