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 812: l_person_rec.action_information7 := fnd_number.number_to_canonical(l_per_rec.address_id);

808: l_person_rec.action_information3 := l_per_rec.first_name_kana;
809: l_person_rec.action_information4 := l_per_rec.last_name_kanji;
810: l_person_rec.action_information5 := l_per_rec.first_name_kanji;
811: l_person_rec.action_information6 := l_per_rec.sex;
812: l_person_rec.action_information7 := fnd_number.number_to_canonical(l_per_rec.address_id);
813: l_person_rec.action_information8 := l_per_rec.address_kana;
814: l_person_rec.action_information9 := l_per_rec.address_kanji;
815: l_person_rec.action_information10 := l_per_rec.country;
816: l_person_rec.action_information11 := fnd_date.date_to_canonical(l_wic_rec.date_start);

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

835: p_year => l_person_rec.action_information21,
836: p_month => l_person_rec.action_information22,
837: p_day => l_person_rec.action_information23);
838: */
839: l_person_rec.action_information24 := fnd_number.number_to_canonical(l_wic_rec.itax_organization_id);
840: l_person_rec.action_information25 := fnd_date.date_to_canonical(l_wic_rec.actual_termination_date);
841: l_person_rec.action_information26 := fnd_number.number_to_canonical(l_per_rec.organization_id);
842: l_person_rec.action_information28 := l_per_rec.district_code;
843: --

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

837: p_day => l_person_rec.action_information23);
838: */
839: l_person_rec.action_information24 := fnd_number.number_to_canonical(l_wic_rec.itax_organization_id);
840: l_person_rec.action_information25 := fnd_date.date_to_canonical(l_wic_rec.actual_termination_date);
841: l_person_rec.action_information26 := fnd_number.number_to_canonical(l_per_rec.organization_id);
842: l_person_rec.action_information28 := l_per_rec.district_code;
843: --
844: -- JP_ITAX_ARCH
845: --

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

847: l_arch_rec.action_context_type := 'AAP';
848: l_arch_rec.action_information_category := 'JP_ITAX_ARCH';
849: l_arch_rec.effective_date := l_wic_rec.effective_date;
850: l_arch_rec.assignment_id := l_assignment_id;
851: l_arch_rec.action_information1 := fnd_number.number_to_canonical(l_wic_rec.person_id);
852: l_arch_rec.action_information2 := fnd_number.number_to_canonical(l_wic_rec.assignment_action_id);
853: l_arch_rec.action_information3 := fnd_number.number_to_canonical(l_wic_rec.payroll_id);
854: l_arch_rec.action_information4 := l_swot_rec.reference_number;
855: l_arch_rec.action_information5 := l_swot_rec.reference_number1;

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

848: l_arch_rec.action_information_category := 'JP_ITAX_ARCH';
849: l_arch_rec.effective_date := l_wic_rec.effective_date;
850: l_arch_rec.assignment_id := l_assignment_id;
851: l_arch_rec.action_information1 := fnd_number.number_to_canonical(l_wic_rec.person_id);
852: l_arch_rec.action_information2 := fnd_number.number_to_canonical(l_wic_rec.assignment_action_id);
853: l_arch_rec.action_information3 := fnd_number.number_to_canonical(l_wic_rec.payroll_id);
854: l_arch_rec.action_information4 := l_swot_rec.reference_number;
855: l_arch_rec.action_information5 := l_swot_rec.reference_number1;
856: l_arch_rec.action_information6 := l_swot_rec.reference_number2;

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

849: l_arch_rec.effective_date := l_wic_rec.effective_date;
850: l_arch_rec.assignment_id := l_assignment_id;
851: l_arch_rec.action_information1 := fnd_number.number_to_canonical(l_wic_rec.person_id);
852: l_arch_rec.action_information2 := fnd_number.number_to_canonical(l_wic_rec.assignment_action_id);
853: l_arch_rec.action_information3 := fnd_number.number_to_canonical(l_wic_rec.payroll_id);
854: l_arch_rec.action_information4 := l_swot_rec.reference_number;
855: l_arch_rec.action_information5 := l_swot_rec.reference_number1;
856: l_arch_rec.action_information6 := l_swot_rec.reference_number2;
857: l_arch_rec.action_information7 := fnd_number.number_to_canonical(l_wic_rec.action_sequence);

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

853: l_arch_rec.action_information3 := fnd_number.number_to_canonical(l_wic_rec.payroll_id);
854: l_arch_rec.action_information4 := l_swot_rec.reference_number;
855: l_arch_rec.action_information5 := l_swot_rec.reference_number1;
856: l_arch_rec.action_information6 := l_swot_rec.reference_number2;
857: l_arch_rec.action_information7 := fnd_number.number_to_canonical(l_wic_rec.action_sequence);
858: l_arch_rec.action_information8 := l_swot_rec.salary_payer_address_kanji;
859: l_arch_rec.action_information9 := l_swot_rec.salary_payer_name_kanji;
860: l_arch_rec.action_information10 := l_swot_rec.salary_payer_telephone_number;
861: l_arch_rec.action_information11 := l_swot_rec.tax_office_number;

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

871: l_tax_rec.action_context_type := 'AAP';
872: l_tax_rec.action_information_category := 'JP_ITAX_TAX';
873: l_tax_rec.effective_date := l_wic_rec.effective_date;
874: l_tax_rec.assignment_id := l_assignment_id;
875: l_tax_rec.action_information1 := fnd_number.number_to_canonical(l_certificate_info.tax_info.taxable_income);
876: l_tax_rec.action_information2 := fnd_number.number_to_canonical(l_certificate_info.net_taxable_income);
877: l_tax_rec.action_information3 := fnd_number.number_to_canonical(l_certificate_info.total_income_exempt);
878: l_tax_rec.action_information4 := fnd_number.number_to_canonical(l_certificate_info.tax_info.withholding_itax);
879: l_tax_rec.action_information5 := fnd_number.number_to_canonical(l_withholding_tax_info.withholding_itax);

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

872: l_tax_rec.action_information_category := 'JP_ITAX_TAX';
873: l_tax_rec.effective_date := l_wic_rec.effective_date;
874: l_tax_rec.assignment_id := l_assignment_id;
875: l_tax_rec.action_information1 := fnd_number.number_to_canonical(l_certificate_info.tax_info.taxable_income);
876: l_tax_rec.action_information2 := fnd_number.number_to_canonical(l_certificate_info.net_taxable_income);
877: l_tax_rec.action_information3 := fnd_number.number_to_canonical(l_certificate_info.total_income_exempt);
878: l_tax_rec.action_information4 := fnd_number.number_to_canonical(l_certificate_info.tax_info.withholding_itax);
879: l_tax_rec.action_information5 := fnd_number.number_to_canonical(l_withholding_tax_info.withholding_itax);
880: l_tax_rec.action_information6 := fnd_number.number_to_canonical(l_certificate_info.spouse_sp_exempt);

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

873: l_tax_rec.effective_date := l_wic_rec.effective_date;
874: l_tax_rec.assignment_id := l_assignment_id;
875: l_tax_rec.action_information1 := fnd_number.number_to_canonical(l_certificate_info.tax_info.taxable_income);
876: l_tax_rec.action_information2 := fnd_number.number_to_canonical(l_certificate_info.net_taxable_income);
877: l_tax_rec.action_information3 := fnd_number.number_to_canonical(l_certificate_info.total_income_exempt);
878: l_tax_rec.action_information4 := fnd_number.number_to_canonical(l_certificate_info.tax_info.withholding_itax);
879: l_tax_rec.action_information5 := fnd_number.number_to_canonical(l_withholding_tax_info.withholding_itax);
880: l_tax_rec.action_information6 := fnd_number.number_to_canonical(l_certificate_info.spouse_sp_exempt);
881: l_tax_rec.action_information7 := fnd_number.number_to_canonical(l_certificate_info.tax_info.si_prem);

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

874: l_tax_rec.assignment_id := l_assignment_id;
875: l_tax_rec.action_information1 := fnd_number.number_to_canonical(l_certificate_info.tax_info.taxable_income);
876: l_tax_rec.action_information2 := fnd_number.number_to_canonical(l_certificate_info.net_taxable_income);
877: l_tax_rec.action_information3 := fnd_number.number_to_canonical(l_certificate_info.total_income_exempt);
878: l_tax_rec.action_information4 := fnd_number.number_to_canonical(l_certificate_info.tax_info.withholding_itax);
879: l_tax_rec.action_information5 := fnd_number.number_to_canonical(l_withholding_tax_info.withholding_itax);
880: l_tax_rec.action_information6 := fnd_number.number_to_canonical(l_certificate_info.spouse_sp_exempt);
881: l_tax_rec.action_information7 := fnd_number.number_to_canonical(l_certificate_info.tax_info.si_prem);
882: l_tax_rec.action_information8 := fnd_number.number_to_canonical(l_certificate_info.tax_info.mutual_aid_prem);

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

875: l_tax_rec.action_information1 := fnd_number.number_to_canonical(l_certificate_info.tax_info.taxable_income);
876: l_tax_rec.action_information2 := fnd_number.number_to_canonical(l_certificate_info.net_taxable_income);
877: l_tax_rec.action_information3 := fnd_number.number_to_canonical(l_certificate_info.total_income_exempt);
878: l_tax_rec.action_information4 := fnd_number.number_to_canonical(l_certificate_info.tax_info.withholding_itax);
879: l_tax_rec.action_information5 := fnd_number.number_to_canonical(l_withholding_tax_info.withholding_itax);
880: l_tax_rec.action_information6 := fnd_number.number_to_canonical(l_certificate_info.spouse_sp_exempt);
881: l_tax_rec.action_information7 := fnd_number.number_to_canonical(l_certificate_info.tax_info.si_prem);
882: l_tax_rec.action_information8 := fnd_number.number_to_canonical(l_certificate_info.tax_info.mutual_aid_prem);
883: l_tax_rec.action_information9 := fnd_number.number_to_canonical(l_certificate_info.li_prem_exempt);

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

876: l_tax_rec.action_information2 := fnd_number.number_to_canonical(l_certificate_info.net_taxable_income);
877: l_tax_rec.action_information3 := fnd_number.number_to_canonical(l_certificate_info.total_income_exempt);
878: l_tax_rec.action_information4 := fnd_number.number_to_canonical(l_certificate_info.tax_info.withholding_itax);
879: l_tax_rec.action_information5 := fnd_number.number_to_canonical(l_withholding_tax_info.withholding_itax);
880: l_tax_rec.action_information6 := fnd_number.number_to_canonical(l_certificate_info.spouse_sp_exempt);
881: l_tax_rec.action_information7 := fnd_number.number_to_canonical(l_certificate_info.tax_info.si_prem);
882: l_tax_rec.action_information8 := fnd_number.number_to_canonical(l_certificate_info.tax_info.mutual_aid_prem);
883: l_tax_rec.action_information9 := fnd_number.number_to_canonical(l_certificate_info.li_prem_exempt);
884: l_tax_rec.action_information10 := fnd_number.number_to_canonical(l_certificate_info.ai_prem_exempt);

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

877: l_tax_rec.action_information3 := fnd_number.number_to_canonical(l_certificate_info.total_income_exempt);
878: l_tax_rec.action_information4 := fnd_number.number_to_canonical(l_certificate_info.tax_info.withholding_itax);
879: l_tax_rec.action_information5 := fnd_number.number_to_canonical(l_withholding_tax_info.withholding_itax);
880: l_tax_rec.action_information6 := fnd_number.number_to_canonical(l_certificate_info.spouse_sp_exempt);
881: l_tax_rec.action_information7 := fnd_number.number_to_canonical(l_certificate_info.tax_info.si_prem);
882: l_tax_rec.action_information8 := fnd_number.number_to_canonical(l_certificate_info.tax_info.mutual_aid_prem);
883: l_tax_rec.action_information9 := fnd_number.number_to_canonical(l_certificate_info.li_prem_exempt);
884: l_tax_rec.action_information10 := fnd_number.number_to_canonical(l_certificate_info.ai_prem_exempt);
885: l_tax_rec.action_information11 := fnd_number.number_to_canonical(l_certificate_info.housing_tax_reduction);

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

878: l_tax_rec.action_information4 := fnd_number.number_to_canonical(l_certificate_info.tax_info.withholding_itax);
879: l_tax_rec.action_information5 := fnd_number.number_to_canonical(l_withholding_tax_info.withholding_itax);
880: l_tax_rec.action_information6 := fnd_number.number_to_canonical(l_certificate_info.spouse_sp_exempt);
881: l_tax_rec.action_information7 := fnd_number.number_to_canonical(l_certificate_info.tax_info.si_prem);
882: l_tax_rec.action_information8 := fnd_number.number_to_canonical(l_certificate_info.tax_info.mutual_aid_prem);
883: l_tax_rec.action_information9 := fnd_number.number_to_canonical(l_certificate_info.li_prem_exempt);
884: l_tax_rec.action_information10 := fnd_number.number_to_canonical(l_certificate_info.ai_prem_exempt);
885: l_tax_rec.action_information11 := fnd_number.number_to_canonical(l_certificate_info.housing_tax_reduction);
886: l_tax_rec.action_information12 := fnd_number.number_to_canonical(l_withholding_tax_info.itax_adjustment);

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

879: l_tax_rec.action_information5 := fnd_number.number_to_canonical(l_withholding_tax_info.withholding_itax);
880: l_tax_rec.action_information6 := fnd_number.number_to_canonical(l_certificate_info.spouse_sp_exempt);
881: l_tax_rec.action_information7 := fnd_number.number_to_canonical(l_certificate_info.tax_info.si_prem);
882: l_tax_rec.action_information8 := fnd_number.number_to_canonical(l_certificate_info.tax_info.mutual_aid_prem);
883: l_tax_rec.action_information9 := fnd_number.number_to_canonical(l_certificate_info.li_prem_exempt);
884: l_tax_rec.action_information10 := fnd_number.number_to_canonical(l_certificate_info.ai_prem_exempt);
885: l_tax_rec.action_information11 := fnd_number.number_to_canonical(l_certificate_info.housing_tax_reduction);
886: l_tax_rec.action_information12 := fnd_number.number_to_canonical(l_withholding_tax_info.itax_adjustment);
887: l_tax_rec.action_information13 := fnd_number.number_to_canonical(l_certificate_info.spouse_net_taxable_income);

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

880: l_tax_rec.action_information6 := fnd_number.number_to_canonical(l_certificate_info.spouse_sp_exempt);
881: l_tax_rec.action_information7 := fnd_number.number_to_canonical(l_certificate_info.tax_info.si_prem);
882: l_tax_rec.action_information8 := fnd_number.number_to_canonical(l_certificate_info.tax_info.mutual_aid_prem);
883: l_tax_rec.action_information9 := fnd_number.number_to_canonical(l_certificate_info.li_prem_exempt);
884: l_tax_rec.action_information10 := fnd_number.number_to_canonical(l_certificate_info.ai_prem_exempt);
885: l_tax_rec.action_information11 := fnd_number.number_to_canonical(l_certificate_info.housing_tax_reduction);
886: l_tax_rec.action_information12 := fnd_number.number_to_canonical(l_withholding_tax_info.itax_adjustment);
887: l_tax_rec.action_information13 := fnd_number.number_to_canonical(l_certificate_info.spouse_net_taxable_income);
888: l_tax_rec.action_information14 := fnd_number.number_to_canonical(l_certificate_info.pp_prem);

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

881: l_tax_rec.action_information7 := fnd_number.number_to_canonical(l_certificate_info.tax_info.si_prem);
882: l_tax_rec.action_information8 := fnd_number.number_to_canonical(l_certificate_info.tax_info.mutual_aid_prem);
883: l_tax_rec.action_information9 := fnd_number.number_to_canonical(l_certificate_info.li_prem_exempt);
884: l_tax_rec.action_information10 := fnd_number.number_to_canonical(l_certificate_info.ai_prem_exempt);
885: l_tax_rec.action_information11 := fnd_number.number_to_canonical(l_certificate_info.housing_tax_reduction);
886: l_tax_rec.action_information12 := fnd_number.number_to_canonical(l_withholding_tax_info.itax_adjustment);
887: l_tax_rec.action_information13 := fnd_number.number_to_canonical(l_certificate_info.spouse_net_taxable_income);
888: l_tax_rec.action_information14 := fnd_number.number_to_canonical(l_certificate_info.pp_prem);
889: l_tax_rec.action_information15 := fnd_number.number_to_canonical(l_certificate_info.long_ai_prem);

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

882: l_tax_rec.action_information8 := fnd_number.number_to_canonical(l_certificate_info.tax_info.mutual_aid_prem);
883: l_tax_rec.action_information9 := fnd_number.number_to_canonical(l_certificate_info.li_prem_exempt);
884: l_tax_rec.action_information10 := fnd_number.number_to_canonical(l_certificate_info.ai_prem_exempt);
885: l_tax_rec.action_information11 := fnd_number.number_to_canonical(l_certificate_info.housing_tax_reduction);
886: l_tax_rec.action_information12 := fnd_number.number_to_canonical(l_withholding_tax_info.itax_adjustment);
887: l_tax_rec.action_information13 := fnd_number.number_to_canonical(l_certificate_info.spouse_net_taxable_income);
888: l_tax_rec.action_information14 := fnd_number.number_to_canonical(l_certificate_info.pp_prem);
889: l_tax_rec.action_information15 := fnd_number.number_to_canonical(l_certificate_info.long_ai_prem);
890: l_tax_rec.action_information16 := fnd_number.number_to_canonical(l_certificate_info.tax_info.disaster_tax_reduction);

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

883: l_tax_rec.action_information9 := fnd_number.number_to_canonical(l_certificate_info.li_prem_exempt);
884: l_tax_rec.action_information10 := fnd_number.number_to_canonical(l_certificate_info.ai_prem_exempt);
885: l_tax_rec.action_information11 := fnd_number.number_to_canonical(l_certificate_info.housing_tax_reduction);
886: l_tax_rec.action_information12 := fnd_number.number_to_canonical(l_withholding_tax_info.itax_adjustment);
887: l_tax_rec.action_information13 := fnd_number.number_to_canonical(l_certificate_info.spouse_net_taxable_income);
888: l_tax_rec.action_information14 := fnd_number.number_to_canonical(l_certificate_info.pp_prem);
889: l_tax_rec.action_information15 := fnd_number.number_to_canonical(l_certificate_info.long_ai_prem);
890: l_tax_rec.action_information16 := fnd_number.number_to_canonical(l_certificate_info.tax_info.disaster_tax_reduction);
891: l_tax_rec.action_information17 := l_prev_job_info.salary_payer_address_kana;

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

884: l_tax_rec.action_information10 := fnd_number.number_to_canonical(l_certificate_info.ai_prem_exempt);
885: l_tax_rec.action_information11 := fnd_number.number_to_canonical(l_certificate_info.housing_tax_reduction);
886: l_tax_rec.action_information12 := fnd_number.number_to_canonical(l_withholding_tax_info.itax_adjustment);
887: l_tax_rec.action_information13 := fnd_number.number_to_canonical(l_certificate_info.spouse_net_taxable_income);
888: l_tax_rec.action_information14 := fnd_number.number_to_canonical(l_certificate_info.pp_prem);
889: l_tax_rec.action_information15 := fnd_number.number_to_canonical(l_certificate_info.long_ai_prem);
890: l_tax_rec.action_information16 := fnd_number.number_to_canonical(l_certificate_info.tax_info.disaster_tax_reduction);
891: l_tax_rec.action_information17 := l_prev_job_info.salary_payer_address_kana;
892: l_tax_rec.action_information18 := l_prev_job_info.salary_payer_address_kanji;

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

885: l_tax_rec.action_information11 := fnd_number.number_to_canonical(l_certificate_info.housing_tax_reduction);
886: l_tax_rec.action_information12 := fnd_number.number_to_canonical(l_withholding_tax_info.itax_adjustment);
887: l_tax_rec.action_information13 := fnd_number.number_to_canonical(l_certificate_info.spouse_net_taxable_income);
888: l_tax_rec.action_information14 := fnd_number.number_to_canonical(l_certificate_info.pp_prem);
889: l_tax_rec.action_information15 := fnd_number.number_to_canonical(l_certificate_info.long_ai_prem);
890: l_tax_rec.action_information16 := fnd_number.number_to_canonical(l_certificate_info.tax_info.disaster_tax_reduction);
891: l_tax_rec.action_information17 := l_prev_job_info.salary_payer_address_kana;
892: l_tax_rec.action_information18 := l_prev_job_info.salary_payer_address_kanji;
893: l_tax_rec.action_information19 := l_prev_job_info.salary_payer_name_kana;

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

886: l_tax_rec.action_information12 := fnd_number.number_to_canonical(l_withholding_tax_info.itax_adjustment);
887: l_tax_rec.action_information13 := fnd_number.number_to_canonical(l_certificate_info.spouse_net_taxable_income);
888: l_tax_rec.action_information14 := fnd_number.number_to_canonical(l_certificate_info.pp_prem);
889: l_tax_rec.action_information15 := fnd_number.number_to_canonical(l_certificate_info.long_ai_prem);
890: l_tax_rec.action_information16 := fnd_number.number_to_canonical(l_certificate_info.tax_info.disaster_tax_reduction);
891: l_tax_rec.action_information17 := l_prev_job_info.salary_payer_address_kana;
892: l_tax_rec.action_information18 := l_prev_job_info.salary_payer_address_kanji;
893: l_tax_rec.action_information19 := l_prev_job_info.salary_payer_name_kana;
894: l_tax_rec.action_information20 := l_prev_job_info.salary_payer_name_kanji;

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

902: else
903: l_tax_rec.action_information21 := null;
904: end if;
905: --
906: l_tax_rec.action_information22 := fnd_number.number_to_canonical(l_prev_job_info.taxable_income);
907: l_tax_rec.action_information23 := fnd_number.number_to_canonical(l_prev_job_info.itax);
908: l_tax_rec.action_information24 := fnd_number.number_to_canonical(l_prev_job_info.si_prem);
909: jp_date(
910: p_date => l_prev_job_info.termination_date,

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

903: l_tax_rec.action_information21 := null;
904: end if;
905: --
906: l_tax_rec.action_information22 := fnd_number.number_to_canonical(l_prev_job_info.taxable_income);
907: l_tax_rec.action_information23 := fnd_number.number_to_canonical(l_prev_job_info.itax);
908: l_tax_rec.action_information24 := fnd_number.number_to_canonical(l_prev_job_info.si_prem);
909: jp_date(
910: p_date => l_prev_job_info.termination_date,
911: p_meiji => l_dummy,

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

904: end if;
905: --
906: l_tax_rec.action_information22 := fnd_number.number_to_canonical(l_prev_job_info.taxable_income);
907: l_tax_rec.action_information23 := fnd_number.number_to_canonical(l_prev_job_info.itax);
908: l_tax_rec.action_information24 := fnd_number.number_to_canonical(l_prev_job_info.si_prem);
909: jp_date(
910: p_date => l_prev_job_info.termination_date,
911: p_meiji => l_dummy,
912: p_taishou => l_dummy,

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

938: l_other_rec.action_information3 := check_when_true(l_certificate_info.dep_spouse_exists_otsu = 'Y');
939: l_other_rec.action_information4 := check_when_true(l_certificate_info.dep_spouse_not_exist_otsu = 'Y');
940: l_other_rec.action_information5 := check_when_true(l_certificate_info.aged_spouse_exists = 'Y');
941: -- Dependents
942: l_other_rec.action_information6 := fnd_number.number_to_canonical(l_certificate_info.num_specifieds_kou);
943: l_other_rec.action_information7 := fnd_number.number_to_canonical(l_certificate_info.num_specifieds_otsu);
944: l_other_rec.action_information8 := fnd_number.number_to_canonical(l_certificate_info.num_aged_parents_lt);
945: l_other_rec.action_information9 := fnd_number.number_to_canonical(l_certificate_info.num_ageds_kou);
946: l_other_rec.action_information10 := fnd_number.number_to_canonical(l_certificate_info.num_ageds_otsu);

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

939: l_other_rec.action_information4 := check_when_true(l_certificate_info.dep_spouse_not_exist_otsu = 'Y');
940: l_other_rec.action_information5 := check_when_true(l_certificate_info.aged_spouse_exists = 'Y');
941: -- Dependents
942: l_other_rec.action_information6 := fnd_number.number_to_canonical(l_certificate_info.num_specifieds_kou);
943: l_other_rec.action_information7 := fnd_number.number_to_canonical(l_certificate_info.num_specifieds_otsu);
944: l_other_rec.action_information8 := fnd_number.number_to_canonical(l_certificate_info.num_aged_parents_lt);
945: l_other_rec.action_information9 := fnd_number.number_to_canonical(l_certificate_info.num_ageds_kou);
946: l_other_rec.action_information10 := fnd_number.number_to_canonical(l_certificate_info.num_ageds_otsu);
947: l_other_rec.action_information11 := fnd_number.number_to_canonical(l_certificate_info.num_deps_kou);

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

940: l_other_rec.action_information5 := check_when_true(l_certificate_info.aged_spouse_exists = 'Y');
941: -- Dependents
942: l_other_rec.action_information6 := fnd_number.number_to_canonical(l_certificate_info.num_specifieds_kou);
943: l_other_rec.action_information7 := fnd_number.number_to_canonical(l_certificate_info.num_specifieds_otsu);
944: l_other_rec.action_information8 := fnd_number.number_to_canonical(l_certificate_info.num_aged_parents_lt);
945: l_other_rec.action_information9 := fnd_number.number_to_canonical(l_certificate_info.num_ageds_kou);
946: l_other_rec.action_information10 := fnd_number.number_to_canonical(l_certificate_info.num_ageds_otsu);
947: l_other_rec.action_information11 := fnd_number.number_to_canonical(l_certificate_info.num_deps_kou);
948: l_other_rec.action_information12 := fnd_number.number_to_canonical(l_certificate_info.num_deps_otsu);

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

941: -- Dependents
942: l_other_rec.action_information6 := fnd_number.number_to_canonical(l_certificate_info.num_specifieds_kou);
943: l_other_rec.action_information7 := fnd_number.number_to_canonical(l_certificate_info.num_specifieds_otsu);
944: l_other_rec.action_information8 := fnd_number.number_to_canonical(l_certificate_info.num_aged_parents_lt);
945: l_other_rec.action_information9 := fnd_number.number_to_canonical(l_certificate_info.num_ageds_kou);
946: l_other_rec.action_information10 := fnd_number.number_to_canonical(l_certificate_info.num_ageds_otsu);
947: l_other_rec.action_information11 := fnd_number.number_to_canonical(l_certificate_info.num_deps_kou);
948: l_other_rec.action_information12 := fnd_number.number_to_canonical(l_certificate_info.num_deps_otsu);
949: -- Disableds

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

942: l_other_rec.action_information6 := fnd_number.number_to_canonical(l_certificate_info.num_specifieds_kou);
943: l_other_rec.action_information7 := fnd_number.number_to_canonical(l_certificate_info.num_specifieds_otsu);
944: l_other_rec.action_information8 := fnd_number.number_to_canonical(l_certificate_info.num_aged_parents_lt);
945: l_other_rec.action_information9 := fnd_number.number_to_canonical(l_certificate_info.num_ageds_kou);
946: l_other_rec.action_information10 := fnd_number.number_to_canonical(l_certificate_info.num_ageds_otsu);
947: l_other_rec.action_information11 := fnd_number.number_to_canonical(l_certificate_info.num_deps_kou);
948: l_other_rec.action_information12 := fnd_number.number_to_canonical(l_certificate_info.num_deps_otsu);
949: -- Disableds
950: l_other_rec.action_information13 := fnd_number.number_to_canonical(l_certificate_info.num_svr_disableds_lt);

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

943: l_other_rec.action_information7 := fnd_number.number_to_canonical(l_certificate_info.num_specifieds_otsu);
944: l_other_rec.action_information8 := fnd_number.number_to_canonical(l_certificate_info.num_aged_parents_lt);
945: l_other_rec.action_information9 := fnd_number.number_to_canonical(l_certificate_info.num_ageds_kou);
946: l_other_rec.action_information10 := fnd_number.number_to_canonical(l_certificate_info.num_ageds_otsu);
947: l_other_rec.action_information11 := fnd_number.number_to_canonical(l_certificate_info.num_deps_kou);
948: l_other_rec.action_information12 := fnd_number.number_to_canonical(l_certificate_info.num_deps_otsu);
949: -- Disableds
950: l_other_rec.action_information13 := fnd_number.number_to_canonical(l_certificate_info.num_svr_disableds_lt);
951: l_other_rec.action_information14 := fnd_number.number_to_canonical(l_certificate_info.num_svr_disableds);

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

944: l_other_rec.action_information8 := fnd_number.number_to_canonical(l_certificate_info.num_aged_parents_lt);
945: l_other_rec.action_information9 := fnd_number.number_to_canonical(l_certificate_info.num_ageds_kou);
946: l_other_rec.action_information10 := fnd_number.number_to_canonical(l_certificate_info.num_ageds_otsu);
947: l_other_rec.action_information11 := fnd_number.number_to_canonical(l_certificate_info.num_deps_kou);
948: l_other_rec.action_information12 := fnd_number.number_to_canonical(l_certificate_info.num_deps_otsu);
949: -- Disableds
950: l_other_rec.action_information13 := fnd_number.number_to_canonical(l_certificate_info.num_svr_disableds_lt);
951: l_other_rec.action_information14 := fnd_number.number_to_canonical(l_certificate_info.num_svr_disableds);
952: l_other_rec.action_information15 := fnd_number.number_to_canonical(l_certificate_info.num_disableds);

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

946: l_other_rec.action_information10 := fnd_number.number_to_canonical(l_certificate_info.num_ageds_otsu);
947: l_other_rec.action_information11 := fnd_number.number_to_canonical(l_certificate_info.num_deps_kou);
948: l_other_rec.action_information12 := fnd_number.number_to_canonical(l_certificate_info.num_deps_otsu);
949: -- Disableds
950: l_other_rec.action_information13 := fnd_number.number_to_canonical(l_certificate_info.num_svr_disableds_lt);
951: l_other_rec.action_information14 := fnd_number.number_to_canonical(l_certificate_info.num_svr_disableds);
952: l_other_rec.action_information15 := fnd_number.number_to_canonical(l_certificate_info.num_disableds);
953: -- Other Additional Info
954: l_other_rec.action_information16 := check_when_true(l_certificate_info.husband_exists = 'Y');

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

947: l_other_rec.action_information11 := fnd_number.number_to_canonical(l_certificate_info.num_deps_kou);
948: l_other_rec.action_information12 := fnd_number.number_to_canonical(l_certificate_info.num_deps_otsu);
949: -- Disableds
950: l_other_rec.action_information13 := fnd_number.number_to_canonical(l_certificate_info.num_svr_disableds_lt);
951: l_other_rec.action_information14 := fnd_number.number_to_canonical(l_certificate_info.num_svr_disableds);
952: l_other_rec.action_information15 := fnd_number.number_to_canonical(l_certificate_info.num_disableds);
953: -- Other Additional Info
954: l_other_rec.action_information16 := check_when_true(l_certificate_info.husband_exists = 'Y');
955: l_other_rec.action_information17 := check_when_true(l_certificate_info.minor_flag = 'Y');

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

948: l_other_rec.action_information12 := fnd_number.number_to_canonical(l_certificate_info.num_deps_otsu);
949: -- Disableds
950: l_other_rec.action_information13 := fnd_number.number_to_canonical(l_certificate_info.num_svr_disableds_lt);
951: l_other_rec.action_information14 := fnd_number.number_to_canonical(l_certificate_info.num_svr_disableds);
952: l_other_rec.action_information15 := fnd_number.number_to_canonical(l_certificate_info.num_disableds);
953: -- Other Additional Info
954: l_other_rec.action_information16 := check_when_true(l_certificate_info.husband_exists = 'Y');
955: l_other_rec.action_information17 := check_when_true(l_certificate_info.minor_flag = 'Y');
956: l_other_rec.action_information18 := check_when_true(l_certificate_info.otsu_flag = 'Y');

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

974: l_other2_rec.action_context_type := 'AAP';
975: l_other2_rec.action_information_category := 'JP_ITAX_OTHER2';
976: l_other2_rec.effective_date := l_wic_rec.effective_date;
977: l_other2_rec.assignment_id := l_assignment_id;
978: l_other2_rec.action_information1 := fnd_number.canonical_to_number(g_business_group_id);
979: --
980: hr_utility.set_location(c_proc, 80);
981: --
982: -- Construct ITW description

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

1155: l_pact_rec.action_context_id := p_payroll_action_id;
1156: l_pact_rec.action_context_type := 'PA';
1157: l_pact_rec.action_information_category := 'JP_ITAX_PACT';
1158: l_pact_rec.effective_date := g_effective_date;
1159: l_pact_rec.action_information1 := fnd_number.number_to_canonical(g_payroll_id);
1160: l_pact_rec.action_information2 := fnd_number.number_to_canonical(g_itax_organization_id);
1161: l_pact_rec.action_information3 := g_include_terminated_flag;
1162: l_pact_rec.action_information4 := fnd_date.date_to_canonical(g_termination_date_from);
1163: l_pact_rec.action_information5 := fnd_date.date_to_canonical(g_termination_date_to);

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

1156: l_pact_rec.action_context_type := 'PA';
1157: l_pact_rec.action_information_category := 'JP_ITAX_PACT';
1158: l_pact_rec.effective_date := g_effective_date;
1159: l_pact_rec.action_information1 := fnd_number.number_to_canonical(g_payroll_id);
1160: l_pact_rec.action_information2 := fnd_number.number_to_canonical(g_itax_organization_id);
1161: l_pact_rec.action_information3 := g_include_terminated_flag;
1162: l_pact_rec.action_information4 := fnd_date.date_to_canonical(g_termination_date_from);
1163: l_pact_rec.action_information5 := fnd_date.date_to_canonical(g_termination_date_to);
1164: l_pact_rec.action_information6 := g_publication_period_status;