eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_JP_ITAX_ARCHIVE_PKG dependencies on FND_NUMBER

Line 119: g_payroll_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAYROLL_ID', l_legislative_parameters));

115: -- at the moment.
116: --
117: g_soy := trunc(g_effective_date, 'YYYY');
118: g_eoy := add_months(g_soy, 12) - 1;
119: g_payroll_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAYROLL_ID', l_legislative_parameters));
120: g_itax_organization_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ITAX_ORGANIZATION_ID', l_legislative_parameters));
121: g_include_terminated_flag := nvl(pay_core_utils.get_parameter('INCLUDE_TERMINATED_FLAG', l_legislative_parameters), 'Y');
122: g_termination_date_from := fnd_date.canonical_to_date(pay_core_utils.get_parameter('TERMINATION_DATE_FROM', l_legislative_parameters));
123: g_termination_date_to := fnd_date.canonical_to_date(pay_core_utils.get_parameter('TERMINATION_DATE_TO', l_legislative_parameters));

Line 120: g_itax_organization_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ITAX_ORGANIZATION_ID', l_legislative_parameters));

116: --
117: g_soy := trunc(g_effective_date, 'YYYY');
118: g_eoy := add_months(g_soy, 12) - 1;
119: g_payroll_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAYROLL_ID', l_legislative_parameters));
120: g_itax_organization_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ITAX_ORGANIZATION_ID', l_legislative_parameters));
121: g_include_terminated_flag := nvl(pay_core_utils.get_parameter('INCLUDE_TERMINATED_FLAG', l_legislative_parameters), 'Y');
122: g_termination_date_from := fnd_date.canonical_to_date(pay_core_utils.get_parameter('TERMINATION_DATE_FROM', l_legislative_parameters));
123: g_termination_date_to := fnd_date.canonical_to_date(pay_core_utils.get_parameter('TERMINATION_DATE_TO', l_legislative_parameters));
124: g_inherit_archive_flag := nvl(pay_core_utils.get_parameter('INHERIT_ARCHIVE_FLAG', l_legislative_parameters), 'Y');

Line 838: l_person_rec.action_information7 := fnd_number.number_to_canonical(l_per_rec.address_id);

834: l_person_rec.action_information3 := l_per_rec.first_name_kana;
835: l_person_rec.action_information4 := l_per_rec.last_name_kanji;
836: l_person_rec.action_information5 := l_per_rec.first_name_kanji;
837: l_person_rec.action_information6 := l_per_rec.sex;
838: l_person_rec.action_information7 := fnd_number.number_to_canonical(l_per_rec.address_id);
839: l_person_rec.action_information8 := l_per_rec.address_kana;
840: l_person_rec.action_information9 := l_per_rec.address_kanji;
841: l_person_rec.action_information10 := l_per_rec.country;
842: l_person_rec.action_information11 := fnd_date.date_to_canonical(l_wic_rec.date_start);

Line 870: l_person_rec.action_information24 := fnd_number.number_to_canonical(l_wic_rec.itax_organization_id);

866: p_day => l_person_rec.action_information23);
867: --
868: */
869: --
870: l_person_rec.action_information24 := fnd_number.number_to_canonical(l_wic_rec.itax_organization_id);
871: l_person_rec.action_information25 := fnd_date.date_to_canonical(l_wic_rec.actual_termination_date);
872: l_person_rec.action_information26 := fnd_number.number_to_canonical(l_per_rec.organization_id);
873: l_person_rec.action_information28 := l_per_rec.district_code;
874: --

Line 872: l_person_rec.action_information26 := fnd_number.number_to_canonical(l_per_rec.organization_id);

868: */
869: --
870: l_person_rec.action_information24 := fnd_number.number_to_canonical(l_wic_rec.itax_organization_id);
871: l_person_rec.action_information25 := fnd_date.date_to_canonical(l_wic_rec.actual_termination_date);
872: l_person_rec.action_information26 := fnd_number.number_to_canonical(l_per_rec.organization_id);
873: l_person_rec.action_information28 := l_per_rec.district_code;
874: --
875: -- JP_ITAX_ARCH
876: --

Line 882: l_arch_rec.action_information1 := fnd_number.number_to_canonical(l_wic_rec.person_id);

878: l_arch_rec.action_context_type := 'AAP';
879: l_arch_rec.action_information_category := 'JP_ITAX_ARCH';
880: l_arch_rec.effective_date := l_wic_rec.effective_date;
881: l_arch_rec.assignment_id := l_assignment_id;
882: l_arch_rec.action_information1 := fnd_number.number_to_canonical(l_wic_rec.person_id);
883: l_arch_rec.action_information2 := fnd_number.number_to_canonical(l_wic_rec.assignment_action_id);
884: l_arch_rec.action_information3 := fnd_number.number_to_canonical(l_wic_rec.payroll_id);
885: l_arch_rec.action_information4 := l_swot_rec.reference_number;
886: l_arch_rec.action_information5 := l_swot_rec.reference_number1;

Line 883: l_arch_rec.action_information2 := fnd_number.number_to_canonical(l_wic_rec.assignment_action_id);

879: l_arch_rec.action_information_category := 'JP_ITAX_ARCH';
880: l_arch_rec.effective_date := l_wic_rec.effective_date;
881: l_arch_rec.assignment_id := l_assignment_id;
882: l_arch_rec.action_information1 := fnd_number.number_to_canonical(l_wic_rec.person_id);
883: l_arch_rec.action_information2 := fnd_number.number_to_canonical(l_wic_rec.assignment_action_id);
884: l_arch_rec.action_information3 := fnd_number.number_to_canonical(l_wic_rec.payroll_id);
885: l_arch_rec.action_information4 := l_swot_rec.reference_number;
886: l_arch_rec.action_information5 := l_swot_rec.reference_number1;
887: l_arch_rec.action_information6 := l_swot_rec.reference_number2;

Line 884: l_arch_rec.action_information3 := fnd_number.number_to_canonical(l_wic_rec.payroll_id);

880: l_arch_rec.effective_date := l_wic_rec.effective_date;
881: l_arch_rec.assignment_id := l_assignment_id;
882: l_arch_rec.action_information1 := fnd_number.number_to_canonical(l_wic_rec.person_id);
883: l_arch_rec.action_information2 := fnd_number.number_to_canonical(l_wic_rec.assignment_action_id);
884: l_arch_rec.action_information3 := fnd_number.number_to_canonical(l_wic_rec.payroll_id);
885: l_arch_rec.action_information4 := l_swot_rec.reference_number;
886: l_arch_rec.action_information5 := l_swot_rec.reference_number1;
887: l_arch_rec.action_information6 := l_swot_rec.reference_number2;
888: l_arch_rec.action_information7 := fnd_number.number_to_canonical(l_wic_rec.action_sequence);

Line 888: l_arch_rec.action_information7 := fnd_number.number_to_canonical(l_wic_rec.action_sequence);

884: l_arch_rec.action_information3 := fnd_number.number_to_canonical(l_wic_rec.payroll_id);
885: l_arch_rec.action_information4 := l_swot_rec.reference_number;
886: l_arch_rec.action_information5 := l_swot_rec.reference_number1;
887: l_arch_rec.action_information6 := l_swot_rec.reference_number2;
888: l_arch_rec.action_information7 := fnd_number.number_to_canonical(l_wic_rec.action_sequence);
889: l_arch_rec.action_information8 := l_swot_rec.salary_payer_address_kanji;
890: l_arch_rec.action_information9 := l_swot_rec.salary_payer_name_kanji;
891: l_arch_rec.action_information10 := l_swot_rec.salary_payer_telephone_number;
892: l_arch_rec.action_information11 := l_swot_rec.tax_office_number;

Line 906: l_tax_rec.action_information1 := fnd_number.number_to_canonical(l_certificate_info.tax_info.taxable_income);

902: l_tax_rec.action_context_type := 'AAP';
903: l_tax_rec.action_information_category := 'JP_ITAX_TAX';
904: l_tax_rec.effective_date := l_wic_rec.effective_date;
905: l_tax_rec.assignment_id := l_assignment_id;
906: l_tax_rec.action_information1 := fnd_number.number_to_canonical(l_certificate_info.tax_info.taxable_income);
907: l_tax_rec.action_information2 := fnd_number.number_to_canonical(l_certificate_info.net_taxable_income);
908: l_tax_rec.action_information3 := fnd_number.number_to_canonical(l_certificate_info.total_income_exempt);
909: l_tax_rec.action_information4 := fnd_number.number_to_canonical(l_certificate_info.tax_info.withholding_itax);
910: l_tax_rec.action_information5 := fnd_number.number_to_canonical(l_withholding_tax_info.withholding_itax);

Line 907: l_tax_rec.action_information2 := fnd_number.number_to_canonical(l_certificate_info.net_taxable_income);

903: l_tax_rec.action_information_category := 'JP_ITAX_TAX';
904: l_tax_rec.effective_date := l_wic_rec.effective_date;
905: l_tax_rec.assignment_id := l_assignment_id;
906: l_tax_rec.action_information1 := fnd_number.number_to_canonical(l_certificate_info.tax_info.taxable_income);
907: l_tax_rec.action_information2 := fnd_number.number_to_canonical(l_certificate_info.net_taxable_income);
908: l_tax_rec.action_information3 := fnd_number.number_to_canonical(l_certificate_info.total_income_exempt);
909: l_tax_rec.action_information4 := fnd_number.number_to_canonical(l_certificate_info.tax_info.withholding_itax);
910: l_tax_rec.action_information5 := fnd_number.number_to_canonical(l_withholding_tax_info.withholding_itax);
911: l_tax_rec.action_information6 := fnd_number.number_to_canonical(l_certificate_info.spouse_sp_exempt);

Line 908: l_tax_rec.action_information3 := fnd_number.number_to_canonical(l_certificate_info.total_income_exempt);

904: l_tax_rec.effective_date := l_wic_rec.effective_date;
905: l_tax_rec.assignment_id := l_assignment_id;
906: l_tax_rec.action_information1 := fnd_number.number_to_canonical(l_certificate_info.tax_info.taxable_income);
907: l_tax_rec.action_information2 := fnd_number.number_to_canonical(l_certificate_info.net_taxable_income);
908: l_tax_rec.action_information3 := fnd_number.number_to_canonical(l_certificate_info.total_income_exempt);
909: l_tax_rec.action_information4 := fnd_number.number_to_canonical(l_certificate_info.tax_info.withholding_itax);
910: l_tax_rec.action_information5 := fnd_number.number_to_canonical(l_withholding_tax_info.withholding_itax);
911: l_tax_rec.action_information6 := fnd_number.number_to_canonical(l_certificate_info.spouse_sp_exempt);
912: l_tax_rec.action_information7 := fnd_number.number_to_canonical(l_certificate_info.tax_info.si_prem);

Line 909: l_tax_rec.action_information4 := fnd_number.number_to_canonical(l_certificate_info.tax_info.withholding_itax);

905: l_tax_rec.assignment_id := l_assignment_id;
906: l_tax_rec.action_information1 := fnd_number.number_to_canonical(l_certificate_info.tax_info.taxable_income);
907: l_tax_rec.action_information2 := fnd_number.number_to_canonical(l_certificate_info.net_taxable_income);
908: l_tax_rec.action_information3 := fnd_number.number_to_canonical(l_certificate_info.total_income_exempt);
909: l_tax_rec.action_information4 := fnd_number.number_to_canonical(l_certificate_info.tax_info.withholding_itax);
910: l_tax_rec.action_information5 := fnd_number.number_to_canonical(l_withholding_tax_info.withholding_itax);
911: l_tax_rec.action_information6 := fnd_number.number_to_canonical(l_certificate_info.spouse_sp_exempt);
912: l_tax_rec.action_information7 := fnd_number.number_to_canonical(l_certificate_info.tax_info.si_prem);
913: l_tax_rec.action_information8 := fnd_number.number_to_canonical(l_certificate_info.tax_info.mutual_aid_prem);

Line 910: l_tax_rec.action_information5 := fnd_number.number_to_canonical(l_withholding_tax_info.withholding_itax);

906: l_tax_rec.action_information1 := fnd_number.number_to_canonical(l_certificate_info.tax_info.taxable_income);
907: l_tax_rec.action_information2 := fnd_number.number_to_canonical(l_certificate_info.net_taxable_income);
908: l_tax_rec.action_information3 := fnd_number.number_to_canonical(l_certificate_info.total_income_exempt);
909: l_tax_rec.action_information4 := fnd_number.number_to_canonical(l_certificate_info.tax_info.withholding_itax);
910: l_tax_rec.action_information5 := fnd_number.number_to_canonical(l_withholding_tax_info.withholding_itax);
911: l_tax_rec.action_information6 := fnd_number.number_to_canonical(l_certificate_info.spouse_sp_exempt);
912: l_tax_rec.action_information7 := fnd_number.number_to_canonical(l_certificate_info.tax_info.si_prem);
913: l_tax_rec.action_information8 := fnd_number.number_to_canonical(l_certificate_info.tax_info.mutual_aid_prem);
914: l_tax_rec.action_information9 := fnd_number.number_to_canonical(l_certificate_info.li_prem_exempt);

Line 911: l_tax_rec.action_information6 := fnd_number.number_to_canonical(l_certificate_info.spouse_sp_exempt);

907: l_tax_rec.action_information2 := fnd_number.number_to_canonical(l_certificate_info.net_taxable_income);
908: l_tax_rec.action_information3 := fnd_number.number_to_canonical(l_certificate_info.total_income_exempt);
909: l_tax_rec.action_information4 := fnd_number.number_to_canonical(l_certificate_info.tax_info.withholding_itax);
910: l_tax_rec.action_information5 := fnd_number.number_to_canonical(l_withholding_tax_info.withholding_itax);
911: l_tax_rec.action_information6 := fnd_number.number_to_canonical(l_certificate_info.spouse_sp_exempt);
912: l_tax_rec.action_information7 := fnd_number.number_to_canonical(l_certificate_info.tax_info.si_prem);
913: l_tax_rec.action_information8 := fnd_number.number_to_canonical(l_certificate_info.tax_info.mutual_aid_prem);
914: l_tax_rec.action_information9 := fnd_number.number_to_canonical(l_certificate_info.li_prem_exempt);
915: l_tax_rec.action_information10 := fnd_number.number_to_canonical(l_certificate_info.ai_prem_exempt);

Line 912: l_tax_rec.action_information7 := fnd_number.number_to_canonical(l_certificate_info.tax_info.si_prem);

908: l_tax_rec.action_information3 := fnd_number.number_to_canonical(l_certificate_info.total_income_exempt);
909: l_tax_rec.action_information4 := fnd_number.number_to_canonical(l_certificate_info.tax_info.withholding_itax);
910: l_tax_rec.action_information5 := fnd_number.number_to_canonical(l_withholding_tax_info.withholding_itax);
911: l_tax_rec.action_information6 := fnd_number.number_to_canonical(l_certificate_info.spouse_sp_exempt);
912: l_tax_rec.action_information7 := fnd_number.number_to_canonical(l_certificate_info.tax_info.si_prem);
913: l_tax_rec.action_information8 := fnd_number.number_to_canonical(l_certificate_info.tax_info.mutual_aid_prem);
914: l_tax_rec.action_information9 := fnd_number.number_to_canonical(l_certificate_info.li_prem_exempt);
915: l_tax_rec.action_information10 := fnd_number.number_to_canonical(l_certificate_info.ai_prem_exempt);
916: l_tax_rec.action_information11 := fnd_number.number_to_canonical(l_certificate_info.housing_tax_reduction);

Line 913: l_tax_rec.action_information8 := fnd_number.number_to_canonical(l_certificate_info.tax_info.mutual_aid_prem);

909: l_tax_rec.action_information4 := fnd_number.number_to_canonical(l_certificate_info.tax_info.withholding_itax);
910: l_tax_rec.action_information5 := fnd_number.number_to_canonical(l_withholding_tax_info.withholding_itax);
911: l_tax_rec.action_information6 := fnd_number.number_to_canonical(l_certificate_info.spouse_sp_exempt);
912: l_tax_rec.action_information7 := fnd_number.number_to_canonical(l_certificate_info.tax_info.si_prem);
913: l_tax_rec.action_information8 := fnd_number.number_to_canonical(l_certificate_info.tax_info.mutual_aid_prem);
914: l_tax_rec.action_information9 := fnd_number.number_to_canonical(l_certificate_info.li_prem_exempt);
915: l_tax_rec.action_information10 := fnd_number.number_to_canonical(l_certificate_info.ai_prem_exempt);
916: l_tax_rec.action_information11 := fnd_number.number_to_canonical(l_certificate_info.housing_tax_reduction);
917: l_tax_rec.action_information12 := fnd_number.number_to_canonical(l_withholding_tax_info.itax_adjustment);

Line 914: l_tax_rec.action_information9 := fnd_number.number_to_canonical(l_certificate_info.li_prem_exempt);

910: l_tax_rec.action_information5 := fnd_number.number_to_canonical(l_withholding_tax_info.withholding_itax);
911: l_tax_rec.action_information6 := fnd_number.number_to_canonical(l_certificate_info.spouse_sp_exempt);
912: l_tax_rec.action_information7 := fnd_number.number_to_canonical(l_certificate_info.tax_info.si_prem);
913: l_tax_rec.action_information8 := fnd_number.number_to_canonical(l_certificate_info.tax_info.mutual_aid_prem);
914: l_tax_rec.action_information9 := fnd_number.number_to_canonical(l_certificate_info.li_prem_exempt);
915: l_tax_rec.action_information10 := fnd_number.number_to_canonical(l_certificate_info.ai_prem_exempt);
916: l_tax_rec.action_information11 := fnd_number.number_to_canonical(l_certificate_info.housing_tax_reduction);
917: l_tax_rec.action_information12 := fnd_number.number_to_canonical(l_withholding_tax_info.itax_adjustment);
918: l_tax_rec.action_information13 := fnd_number.number_to_canonical(l_certificate_info.spouse_net_taxable_income);

Line 915: l_tax_rec.action_information10 := fnd_number.number_to_canonical(l_certificate_info.ai_prem_exempt);

911: l_tax_rec.action_information6 := fnd_number.number_to_canonical(l_certificate_info.spouse_sp_exempt);
912: l_tax_rec.action_information7 := fnd_number.number_to_canonical(l_certificate_info.tax_info.si_prem);
913: l_tax_rec.action_information8 := fnd_number.number_to_canonical(l_certificate_info.tax_info.mutual_aid_prem);
914: l_tax_rec.action_information9 := fnd_number.number_to_canonical(l_certificate_info.li_prem_exempt);
915: l_tax_rec.action_information10 := fnd_number.number_to_canonical(l_certificate_info.ai_prem_exempt);
916: l_tax_rec.action_information11 := fnd_number.number_to_canonical(l_certificate_info.housing_tax_reduction);
917: l_tax_rec.action_information12 := fnd_number.number_to_canonical(l_withholding_tax_info.itax_adjustment);
918: l_tax_rec.action_information13 := fnd_number.number_to_canonical(l_certificate_info.spouse_net_taxable_income);
919: l_tax_rec.action_information14 := fnd_number.number_to_canonical(l_certificate_info.pp_prem);

Line 916: l_tax_rec.action_information11 := fnd_number.number_to_canonical(l_certificate_info.housing_tax_reduction);

912: l_tax_rec.action_information7 := fnd_number.number_to_canonical(l_certificate_info.tax_info.si_prem);
913: l_tax_rec.action_information8 := fnd_number.number_to_canonical(l_certificate_info.tax_info.mutual_aid_prem);
914: l_tax_rec.action_information9 := fnd_number.number_to_canonical(l_certificate_info.li_prem_exempt);
915: l_tax_rec.action_information10 := fnd_number.number_to_canonical(l_certificate_info.ai_prem_exempt);
916: l_tax_rec.action_information11 := fnd_number.number_to_canonical(l_certificate_info.housing_tax_reduction);
917: l_tax_rec.action_information12 := fnd_number.number_to_canonical(l_withholding_tax_info.itax_adjustment);
918: l_tax_rec.action_information13 := fnd_number.number_to_canonical(l_certificate_info.spouse_net_taxable_income);
919: l_tax_rec.action_information14 := fnd_number.number_to_canonical(l_certificate_info.pp_prem);
920: l_tax_rec.action_information15 := fnd_number.number_to_canonical(l_certificate_info.long_ai_prem);

Line 917: l_tax_rec.action_information12 := fnd_number.number_to_canonical(l_withholding_tax_info.itax_adjustment);

913: l_tax_rec.action_information8 := fnd_number.number_to_canonical(l_certificate_info.tax_info.mutual_aid_prem);
914: l_tax_rec.action_information9 := fnd_number.number_to_canonical(l_certificate_info.li_prem_exempt);
915: l_tax_rec.action_information10 := fnd_number.number_to_canonical(l_certificate_info.ai_prem_exempt);
916: l_tax_rec.action_information11 := fnd_number.number_to_canonical(l_certificate_info.housing_tax_reduction);
917: l_tax_rec.action_information12 := fnd_number.number_to_canonical(l_withholding_tax_info.itax_adjustment);
918: l_tax_rec.action_information13 := fnd_number.number_to_canonical(l_certificate_info.spouse_net_taxable_income);
919: l_tax_rec.action_information14 := fnd_number.number_to_canonical(l_certificate_info.pp_prem);
920: l_tax_rec.action_information15 := fnd_number.number_to_canonical(l_certificate_info.long_ai_prem);
921: l_tax_rec.action_information16 := fnd_number.number_to_canonical(l_certificate_info.tax_info.disaster_tax_reduction);

Line 918: l_tax_rec.action_information13 := fnd_number.number_to_canonical(l_certificate_info.spouse_net_taxable_income);

914: l_tax_rec.action_information9 := fnd_number.number_to_canonical(l_certificate_info.li_prem_exempt);
915: l_tax_rec.action_information10 := fnd_number.number_to_canonical(l_certificate_info.ai_prem_exempt);
916: l_tax_rec.action_information11 := fnd_number.number_to_canonical(l_certificate_info.housing_tax_reduction);
917: l_tax_rec.action_information12 := fnd_number.number_to_canonical(l_withholding_tax_info.itax_adjustment);
918: l_tax_rec.action_information13 := fnd_number.number_to_canonical(l_certificate_info.spouse_net_taxable_income);
919: l_tax_rec.action_information14 := fnd_number.number_to_canonical(l_certificate_info.pp_prem);
920: l_tax_rec.action_information15 := fnd_number.number_to_canonical(l_certificate_info.long_ai_prem);
921: l_tax_rec.action_information16 := fnd_number.number_to_canonical(l_certificate_info.tax_info.disaster_tax_reduction);
922: l_tax_rec.action_information17 := l_prev_job_info.salary_payer_address_kana;

Line 919: l_tax_rec.action_information14 := fnd_number.number_to_canonical(l_certificate_info.pp_prem);

915: l_tax_rec.action_information10 := fnd_number.number_to_canonical(l_certificate_info.ai_prem_exempt);
916: l_tax_rec.action_information11 := fnd_number.number_to_canonical(l_certificate_info.housing_tax_reduction);
917: l_tax_rec.action_information12 := fnd_number.number_to_canonical(l_withholding_tax_info.itax_adjustment);
918: l_tax_rec.action_information13 := fnd_number.number_to_canonical(l_certificate_info.spouse_net_taxable_income);
919: l_tax_rec.action_information14 := fnd_number.number_to_canonical(l_certificate_info.pp_prem);
920: l_tax_rec.action_information15 := fnd_number.number_to_canonical(l_certificate_info.long_ai_prem);
921: l_tax_rec.action_information16 := fnd_number.number_to_canonical(l_certificate_info.tax_info.disaster_tax_reduction);
922: l_tax_rec.action_information17 := l_prev_job_info.salary_payer_address_kana;
923: l_tax_rec.action_information18 := l_prev_job_info.salary_payer_address_kanji;

Line 920: l_tax_rec.action_information15 := fnd_number.number_to_canonical(l_certificate_info.long_ai_prem);

916: l_tax_rec.action_information11 := fnd_number.number_to_canonical(l_certificate_info.housing_tax_reduction);
917: l_tax_rec.action_information12 := fnd_number.number_to_canonical(l_withholding_tax_info.itax_adjustment);
918: l_tax_rec.action_information13 := fnd_number.number_to_canonical(l_certificate_info.spouse_net_taxable_income);
919: l_tax_rec.action_information14 := fnd_number.number_to_canonical(l_certificate_info.pp_prem);
920: l_tax_rec.action_information15 := fnd_number.number_to_canonical(l_certificate_info.long_ai_prem);
921: l_tax_rec.action_information16 := fnd_number.number_to_canonical(l_certificate_info.tax_info.disaster_tax_reduction);
922: l_tax_rec.action_information17 := l_prev_job_info.salary_payer_address_kana;
923: l_tax_rec.action_information18 := l_prev_job_info.salary_payer_address_kanji;
924: l_tax_rec.action_information19 := l_prev_job_info.salary_payer_name_kana;

Line 921: l_tax_rec.action_information16 := fnd_number.number_to_canonical(l_certificate_info.tax_info.disaster_tax_reduction);

917: l_tax_rec.action_information12 := fnd_number.number_to_canonical(l_withholding_tax_info.itax_adjustment);
918: l_tax_rec.action_information13 := fnd_number.number_to_canonical(l_certificate_info.spouse_net_taxable_income);
919: l_tax_rec.action_information14 := fnd_number.number_to_canonical(l_certificate_info.pp_prem);
920: l_tax_rec.action_information15 := fnd_number.number_to_canonical(l_certificate_info.long_ai_prem);
921: l_tax_rec.action_information16 := fnd_number.number_to_canonical(l_certificate_info.tax_info.disaster_tax_reduction);
922: l_tax_rec.action_information17 := l_prev_job_info.salary_payer_address_kana;
923: l_tax_rec.action_information18 := l_prev_job_info.salary_payer_address_kanji;
924: l_tax_rec.action_information19 := l_prev_job_info.salary_payer_name_kana;
925: l_tax_rec.action_information20 := l_prev_job_info.salary_payer_name_kanji;

Line 939: l_tax_rec.action_information22 := fnd_number.number_to_canonical(l_prev_job_info.taxable_income);

935: else
936: l_tax_rec.action_information21 := null;
937: end if;
938: --
939: l_tax_rec.action_information22 := fnd_number.number_to_canonical(l_prev_job_info.taxable_income);
940: l_tax_rec.action_information23 := fnd_number.number_to_canonical(l_prev_job_info.itax);
941: l_tax_rec.action_information24 := fnd_number.number_to_canonical(l_prev_job_info.si_prem);
942: --
943: jp_date(

Line 940: l_tax_rec.action_information23 := fnd_number.number_to_canonical(l_prev_job_info.itax);

936: l_tax_rec.action_information21 := null;
937: end if;
938: --
939: l_tax_rec.action_information22 := fnd_number.number_to_canonical(l_prev_job_info.taxable_income);
940: l_tax_rec.action_information23 := fnd_number.number_to_canonical(l_prev_job_info.itax);
941: l_tax_rec.action_information24 := fnd_number.number_to_canonical(l_prev_job_info.si_prem);
942: --
943: jp_date(
944: p_date => l_prev_job_info.termination_date,

Line 941: l_tax_rec.action_information24 := fnd_number.number_to_canonical(l_prev_job_info.si_prem);

937: end if;
938: --
939: l_tax_rec.action_information22 := fnd_number.number_to_canonical(l_prev_job_info.taxable_income);
940: l_tax_rec.action_information23 := fnd_number.number_to_canonical(l_prev_job_info.itax);
941: l_tax_rec.action_information24 := fnd_number.number_to_canonical(l_prev_job_info.si_prem);
942: --
943: jp_date(
944: p_date => l_prev_job_info.termination_date,
945: p_meiji => l_dummy,

Line 971: l_tax_rec1.action_information1 := fnd_number.number_to_canonical(l_certificate_info.old_life_ins_prem);

967: l_tax_rec1.action_context_type := 'AAP';
968: l_tax_rec1.action_information_category := 'JP_ITAX_TAX1';
969: l_tax_rec1.effective_date := l_wic_rec.effective_date;
970: l_tax_rec1.assignment_id := l_assignment_id;
971: l_tax_rec1.action_information1 := fnd_number.number_to_canonical(l_certificate_info.old_life_ins_prem);
972: l_tax_rec1.action_information2 := fnd_number.number_to_canonical(l_certificate_info.new_life_ins_prem);
973: l_tax_rec1.action_information3 := fnd_number.number_to_canonical(l_certificate_info.care_med_ins_prem);
974: l_tax_rec1.action_information4 := fnd_number.number_to_canonical(l_certificate_info.new_pen_ins_prem);
975:

Line 972: l_tax_rec1.action_information2 := fnd_number.number_to_canonical(l_certificate_info.new_life_ins_prem);

968: l_tax_rec1.action_information_category := 'JP_ITAX_TAX1';
969: l_tax_rec1.effective_date := l_wic_rec.effective_date;
970: l_tax_rec1.assignment_id := l_assignment_id;
971: l_tax_rec1.action_information1 := fnd_number.number_to_canonical(l_certificate_info.old_life_ins_prem);
972: l_tax_rec1.action_information2 := fnd_number.number_to_canonical(l_certificate_info.new_life_ins_prem);
973: l_tax_rec1.action_information3 := fnd_number.number_to_canonical(l_certificate_info.care_med_ins_prem);
974: l_tax_rec1.action_information4 := fnd_number.number_to_canonical(l_certificate_info.new_pen_ins_prem);
975:
976: -- JP_ITAX_OTHER

Line 973: l_tax_rec1.action_information3 := fnd_number.number_to_canonical(l_certificate_info.care_med_ins_prem);

969: l_tax_rec1.effective_date := l_wic_rec.effective_date;
970: l_tax_rec1.assignment_id := l_assignment_id;
971: l_tax_rec1.action_information1 := fnd_number.number_to_canonical(l_certificate_info.old_life_ins_prem);
972: l_tax_rec1.action_information2 := fnd_number.number_to_canonical(l_certificate_info.new_life_ins_prem);
973: l_tax_rec1.action_information3 := fnd_number.number_to_canonical(l_certificate_info.care_med_ins_prem);
974: l_tax_rec1.action_information4 := fnd_number.number_to_canonical(l_certificate_info.new_pen_ins_prem);
975:
976: -- JP_ITAX_OTHER
977: --

Line 974: l_tax_rec1.action_information4 := fnd_number.number_to_canonical(l_certificate_info.new_pen_ins_prem);

970: l_tax_rec1.assignment_id := l_assignment_id;
971: l_tax_rec1.action_information1 := fnd_number.number_to_canonical(l_certificate_info.old_life_ins_prem);
972: l_tax_rec1.action_information2 := fnd_number.number_to_canonical(l_certificate_info.new_life_ins_prem);
973: l_tax_rec1.action_information3 := fnd_number.number_to_canonical(l_certificate_info.care_med_ins_prem);
974: l_tax_rec1.action_information4 := fnd_number.number_to_canonical(l_certificate_info.new_pen_ins_prem);
975:
976: -- JP_ITAX_OTHER
977: --
978: l_other_rec.action_context_id := p_assignment_action_id;

Line 990: l_other_rec.action_information6 := fnd_number.number_to_canonical(l_certificate_info.num_specifieds_kou);

986: l_other_rec.action_information3 := check_when_true(l_certificate_info.dep_spouse_exists_otsu = 'Y');
987: l_other_rec.action_information4 := check_when_true(l_certificate_info.dep_spouse_not_exist_otsu = 'Y');
988: l_other_rec.action_information5 := check_when_true(l_certificate_info.aged_spouse_exists = 'Y');
989: -- Dependents
990: l_other_rec.action_information6 := fnd_number.number_to_canonical(l_certificate_info.num_specifieds_kou);
991: l_other_rec.action_information7 := fnd_number.number_to_canonical(l_certificate_info.num_specifieds_otsu);
992: l_other_rec.action_information8 := fnd_number.number_to_canonical(l_certificate_info.num_aged_parents_lt);
993: l_other_rec.action_information9 := fnd_number.number_to_canonical(l_certificate_info.num_ageds_kou);
994: l_other_rec.action_information10 := fnd_number.number_to_canonical(l_certificate_info.num_ageds_otsu);

Line 991: l_other_rec.action_information7 := fnd_number.number_to_canonical(l_certificate_info.num_specifieds_otsu);

987: l_other_rec.action_information4 := check_when_true(l_certificate_info.dep_spouse_not_exist_otsu = 'Y');
988: l_other_rec.action_information5 := check_when_true(l_certificate_info.aged_spouse_exists = 'Y');
989: -- Dependents
990: l_other_rec.action_information6 := fnd_number.number_to_canonical(l_certificate_info.num_specifieds_kou);
991: l_other_rec.action_information7 := fnd_number.number_to_canonical(l_certificate_info.num_specifieds_otsu);
992: l_other_rec.action_information8 := fnd_number.number_to_canonical(l_certificate_info.num_aged_parents_lt);
993: l_other_rec.action_information9 := fnd_number.number_to_canonical(l_certificate_info.num_ageds_kou);
994: l_other_rec.action_information10 := fnd_number.number_to_canonical(l_certificate_info.num_ageds_otsu);
995: l_other_rec.action_information11 := fnd_number.number_to_canonical(l_certificate_info.num_deps_kou);

Line 992: l_other_rec.action_information8 := fnd_number.number_to_canonical(l_certificate_info.num_aged_parents_lt);

988: l_other_rec.action_information5 := check_when_true(l_certificate_info.aged_spouse_exists = 'Y');
989: -- Dependents
990: l_other_rec.action_information6 := fnd_number.number_to_canonical(l_certificate_info.num_specifieds_kou);
991: l_other_rec.action_information7 := fnd_number.number_to_canonical(l_certificate_info.num_specifieds_otsu);
992: l_other_rec.action_information8 := fnd_number.number_to_canonical(l_certificate_info.num_aged_parents_lt);
993: l_other_rec.action_information9 := fnd_number.number_to_canonical(l_certificate_info.num_ageds_kou);
994: l_other_rec.action_information10 := fnd_number.number_to_canonical(l_certificate_info.num_ageds_otsu);
995: l_other_rec.action_information11 := fnd_number.number_to_canonical(l_certificate_info.num_deps_kou);
996: l_other_rec.action_information12 := fnd_number.number_to_canonical(l_certificate_info.num_deps_otsu);

Line 993: l_other_rec.action_information9 := fnd_number.number_to_canonical(l_certificate_info.num_ageds_kou);

989: -- Dependents
990: l_other_rec.action_information6 := fnd_number.number_to_canonical(l_certificate_info.num_specifieds_kou);
991: l_other_rec.action_information7 := fnd_number.number_to_canonical(l_certificate_info.num_specifieds_otsu);
992: l_other_rec.action_information8 := fnd_number.number_to_canonical(l_certificate_info.num_aged_parents_lt);
993: l_other_rec.action_information9 := fnd_number.number_to_canonical(l_certificate_info.num_ageds_kou);
994: l_other_rec.action_information10 := fnd_number.number_to_canonical(l_certificate_info.num_ageds_otsu);
995: l_other_rec.action_information11 := fnd_number.number_to_canonical(l_certificate_info.num_deps_kou);
996: l_other_rec.action_information12 := fnd_number.number_to_canonical(l_certificate_info.num_deps_otsu);
997: -- Disableds

Line 994: l_other_rec.action_information10 := fnd_number.number_to_canonical(l_certificate_info.num_ageds_otsu);

990: l_other_rec.action_information6 := fnd_number.number_to_canonical(l_certificate_info.num_specifieds_kou);
991: l_other_rec.action_information7 := fnd_number.number_to_canonical(l_certificate_info.num_specifieds_otsu);
992: l_other_rec.action_information8 := fnd_number.number_to_canonical(l_certificate_info.num_aged_parents_lt);
993: l_other_rec.action_information9 := fnd_number.number_to_canonical(l_certificate_info.num_ageds_kou);
994: l_other_rec.action_information10 := fnd_number.number_to_canonical(l_certificate_info.num_ageds_otsu);
995: l_other_rec.action_information11 := fnd_number.number_to_canonical(l_certificate_info.num_deps_kou);
996: l_other_rec.action_information12 := fnd_number.number_to_canonical(l_certificate_info.num_deps_otsu);
997: -- Disableds
998: l_other_rec.action_information13 := fnd_number.number_to_canonical(l_certificate_info.num_svr_disableds_lt);

Line 995: l_other_rec.action_information11 := fnd_number.number_to_canonical(l_certificate_info.num_deps_kou);

991: l_other_rec.action_information7 := fnd_number.number_to_canonical(l_certificate_info.num_specifieds_otsu);
992: l_other_rec.action_information8 := fnd_number.number_to_canonical(l_certificate_info.num_aged_parents_lt);
993: l_other_rec.action_information9 := fnd_number.number_to_canonical(l_certificate_info.num_ageds_kou);
994: l_other_rec.action_information10 := fnd_number.number_to_canonical(l_certificate_info.num_ageds_otsu);
995: l_other_rec.action_information11 := fnd_number.number_to_canonical(l_certificate_info.num_deps_kou);
996: l_other_rec.action_information12 := fnd_number.number_to_canonical(l_certificate_info.num_deps_otsu);
997: -- Disableds
998: l_other_rec.action_information13 := fnd_number.number_to_canonical(l_certificate_info.num_svr_disableds_lt);
999: l_other_rec.action_information14 := fnd_number.number_to_canonical(l_certificate_info.num_svr_disableds);

Line 996: l_other_rec.action_information12 := fnd_number.number_to_canonical(l_certificate_info.num_deps_otsu);

992: l_other_rec.action_information8 := fnd_number.number_to_canonical(l_certificate_info.num_aged_parents_lt);
993: l_other_rec.action_information9 := fnd_number.number_to_canonical(l_certificate_info.num_ageds_kou);
994: l_other_rec.action_information10 := fnd_number.number_to_canonical(l_certificate_info.num_ageds_otsu);
995: l_other_rec.action_information11 := fnd_number.number_to_canonical(l_certificate_info.num_deps_kou);
996: l_other_rec.action_information12 := fnd_number.number_to_canonical(l_certificate_info.num_deps_otsu);
997: -- Disableds
998: l_other_rec.action_information13 := fnd_number.number_to_canonical(l_certificate_info.num_svr_disableds_lt);
999: l_other_rec.action_information14 := fnd_number.number_to_canonical(l_certificate_info.num_svr_disableds);
1000: l_other_rec.action_information15 := fnd_number.number_to_canonical(l_certificate_info.num_disableds);

Line 998: l_other_rec.action_information13 := fnd_number.number_to_canonical(l_certificate_info.num_svr_disableds_lt);

994: l_other_rec.action_information10 := fnd_number.number_to_canonical(l_certificate_info.num_ageds_otsu);
995: l_other_rec.action_information11 := fnd_number.number_to_canonical(l_certificate_info.num_deps_kou);
996: l_other_rec.action_information12 := fnd_number.number_to_canonical(l_certificate_info.num_deps_otsu);
997: -- Disableds
998: l_other_rec.action_information13 := fnd_number.number_to_canonical(l_certificate_info.num_svr_disableds_lt);
999: l_other_rec.action_information14 := fnd_number.number_to_canonical(l_certificate_info.num_svr_disableds);
1000: l_other_rec.action_information15 := fnd_number.number_to_canonical(l_certificate_info.num_disableds);
1001: -- Other Additional Info
1002: l_other_rec.action_information16 := check_when_true(l_certificate_info.husband_exists = 'Y');

Line 999: l_other_rec.action_information14 := fnd_number.number_to_canonical(l_certificate_info.num_svr_disableds);

995: l_other_rec.action_information11 := fnd_number.number_to_canonical(l_certificate_info.num_deps_kou);
996: l_other_rec.action_information12 := fnd_number.number_to_canonical(l_certificate_info.num_deps_otsu);
997: -- Disableds
998: l_other_rec.action_information13 := fnd_number.number_to_canonical(l_certificate_info.num_svr_disableds_lt);
999: l_other_rec.action_information14 := fnd_number.number_to_canonical(l_certificate_info.num_svr_disableds);
1000: l_other_rec.action_information15 := fnd_number.number_to_canonical(l_certificate_info.num_disableds);
1001: -- Other Additional Info
1002: l_other_rec.action_information16 := check_when_true(l_certificate_info.husband_exists = 'Y');
1003: l_other_rec.action_information17 := check_when_true(l_certificate_info.minor_flag = 'Y');

Line 1000: l_other_rec.action_information15 := fnd_number.number_to_canonical(l_certificate_info.num_disableds);

996: l_other_rec.action_information12 := fnd_number.number_to_canonical(l_certificate_info.num_deps_otsu);
997: -- Disableds
998: l_other_rec.action_information13 := fnd_number.number_to_canonical(l_certificate_info.num_svr_disableds_lt);
999: l_other_rec.action_information14 := fnd_number.number_to_canonical(l_certificate_info.num_svr_disableds);
1000: l_other_rec.action_information15 := fnd_number.number_to_canonical(l_certificate_info.num_disableds);
1001: -- Other Additional Info
1002: l_other_rec.action_information16 := check_when_true(l_certificate_info.husband_exists = 'Y');
1003: l_other_rec.action_information17 := check_when_true(l_certificate_info.minor_flag = 'Y');
1004: l_other_rec.action_information18 := check_when_true(l_certificate_info.otsu_flag = 'Y');

Line 1026: l_dep_rec.action_information1 := fnd_number.number_to_canonical(l_certificate_info.num_junior_deps);

1022: l_dep_rec.action_context_type := 'AAP';
1023: l_dep_rec.assignment_id := l_assignment_id;
1024: l_dep_rec.effective_date := l_wic_rec.effective_date;
1025: l_dep_rec.action_information_category := 'JP_ITAX_DEP';
1026: l_dep_rec.action_information1 := fnd_number.number_to_canonical(l_certificate_info.num_junior_deps);
1027: --
1028: -- JP_ITAX_OTHER2
1029: --
1030: l_other2_rec.action_context_id := p_assignment_action_id;

Line 1035: l_other2_rec.action_information1 := fnd_number.canonical_to_number(g_business_group_id);

1031: l_other2_rec.action_context_type := 'AAP';
1032: l_other2_rec.action_information_category := 'JP_ITAX_OTHER2';
1033: l_other2_rec.effective_date := l_wic_rec.effective_date;
1034: l_other2_rec.assignment_id := l_assignment_id;
1035: l_other2_rec.action_information1 := fnd_number.canonical_to_number(g_business_group_id);
1036: --
1037: hr_utility.set_location(c_proc, 80);
1038: --
1039: -- Construct ITW description

Line 1169: l_housing_rec.action_information1 := fnd_number.number_to_canonical(l_housing_info.payable_loan);

1165: l_housing_rec.action_context_type := 'AAP';
1166: l_housing_rec.assignment_id := l_assignment_id;
1167: l_housing_rec.effective_date := l_wic_rec.effective_date;
1168: l_housing_rec.action_information_category := 'JP_ITAX_HOUSING';
1169: l_housing_rec.action_information1 := fnd_number.number_to_canonical(l_housing_info.payable_loan);
1170: l_housing_rec.action_information2 := fnd_number.number_to_canonical(l_housing_info.loan_count);
1171: l_housing_rec.action_information3 := fnd_date.date_to_canonical(l_housing_info.residence_date_1);
1172: l_housing_rec.action_information4 := l_housing_info.loan_type_1;
1173: l_housing_rec.action_information5 := fnd_number.number_to_canonical(l_housing_info.loan_balance_1);

Line 1170: l_housing_rec.action_information2 := fnd_number.number_to_canonical(l_housing_info.loan_count);

1166: l_housing_rec.assignment_id := l_assignment_id;
1167: l_housing_rec.effective_date := l_wic_rec.effective_date;
1168: l_housing_rec.action_information_category := 'JP_ITAX_HOUSING';
1169: l_housing_rec.action_information1 := fnd_number.number_to_canonical(l_housing_info.payable_loan);
1170: l_housing_rec.action_information2 := fnd_number.number_to_canonical(l_housing_info.loan_count);
1171: l_housing_rec.action_information3 := fnd_date.date_to_canonical(l_housing_info.residence_date_1);
1172: l_housing_rec.action_information4 := l_housing_info.loan_type_1;
1173: l_housing_rec.action_information5 := fnd_number.number_to_canonical(l_housing_info.loan_balance_1);
1174: l_housing_rec.action_information6 := fnd_date.date_to_canonical(l_housing_info.residence_date_2);

Line 1173: l_housing_rec.action_information5 := fnd_number.number_to_canonical(l_housing_info.loan_balance_1);

1169: l_housing_rec.action_information1 := fnd_number.number_to_canonical(l_housing_info.payable_loan);
1170: l_housing_rec.action_information2 := fnd_number.number_to_canonical(l_housing_info.loan_count);
1171: l_housing_rec.action_information3 := fnd_date.date_to_canonical(l_housing_info.residence_date_1);
1172: l_housing_rec.action_information4 := l_housing_info.loan_type_1;
1173: l_housing_rec.action_information5 := fnd_number.number_to_canonical(l_housing_info.loan_balance_1);
1174: l_housing_rec.action_information6 := fnd_date.date_to_canonical(l_housing_info.residence_date_2);
1175: l_housing_rec.action_information7 := l_housing_info.loan_type_2;
1176: l_housing_rec.action_information8 := fnd_number.number_to_canonical(l_housing_info.loan_balance_2);
1177: --

Line 1176: l_housing_rec.action_information8 := fnd_number.number_to_canonical(l_housing_info.loan_balance_2);

1172: l_housing_rec.action_information4 := l_housing_info.loan_type_1;
1173: l_housing_rec.action_information5 := fnd_number.number_to_canonical(l_housing_info.loan_balance_1);
1174: l_housing_rec.action_information6 := fnd_date.date_to_canonical(l_housing_info.residence_date_2);
1175: l_housing_rec.action_information7 := l_housing_info.loan_type_2;
1176: l_housing_rec.action_information8 := fnd_number.number_to_canonical(l_housing_info.loan_balance_2);
1177: --
1178: -- Create the data
1179: --
1180: create_action_information(l_person_rec);

Line 1254: l_pact_rec.action_information1 := fnd_number.number_to_canonical(g_payroll_id);

1250: l_pact_rec.action_context_id := p_payroll_action_id;
1251: l_pact_rec.action_context_type := 'PA';
1252: l_pact_rec.action_information_category := 'JP_ITAX_PACT';
1253: l_pact_rec.effective_date := g_effective_date;
1254: l_pact_rec.action_information1 := fnd_number.number_to_canonical(g_payroll_id);
1255: l_pact_rec.action_information2 := fnd_number.number_to_canonical(g_itax_organization_id);
1256: l_pact_rec.action_information3 := g_include_terminated_flag;
1257: l_pact_rec.action_information4 := fnd_date.date_to_canonical(g_termination_date_from);
1258: l_pact_rec.action_information5 := fnd_date.date_to_canonical(g_termination_date_to);

Line 1255: l_pact_rec.action_information2 := fnd_number.number_to_canonical(g_itax_organization_id);

1251: l_pact_rec.action_context_type := 'PA';
1252: l_pact_rec.action_information_category := 'JP_ITAX_PACT';
1253: l_pact_rec.effective_date := g_effective_date;
1254: l_pact_rec.action_information1 := fnd_number.number_to_canonical(g_payroll_id);
1255: l_pact_rec.action_information2 := fnd_number.number_to_canonical(g_itax_organization_id);
1256: l_pact_rec.action_information3 := g_include_terminated_flag;
1257: l_pact_rec.action_information4 := fnd_date.date_to_canonical(g_termination_date_from);
1258: l_pact_rec.action_information5 := fnd_date.date_to_canonical(g_termination_date_to);
1259: l_pact_rec.action_information6 := g_publication_period_status;