[Home] [Help]
560: p_payroll_action_id,
561: p_action_context_type,
562: p_effective_date,
563: p_action_information_category,
564: fnd_number.number_to_canonical(p_payroll_id),
565: fnd_number.number_to_canonical(p_organization_id),
566: fnd_number.number_to_canonical(p_assignment_set_id),
567: p_submission_period_status,
568: fnd_date.date_to_canonical(p_submission_start_date),
561: p_action_context_type,
562: p_effective_date,
563: p_action_information_category,
564: fnd_number.number_to_canonical(p_payroll_id),
565: fnd_number.number_to_canonical(p_organization_id),
566: fnd_number.number_to_canonical(p_assignment_set_id),
567: p_submission_period_status,
568: fnd_date.date_to_canonical(p_submission_start_date),
569: fnd_date.date_to_canonical(p_submission_end_date),
562: p_effective_date,
563: p_action_information_category,
564: fnd_number.number_to_canonical(p_payroll_id),
565: fnd_number.number_to_canonical(p_organization_id),
566: fnd_number.number_to_canonical(p_assignment_set_id),
567: p_submission_period_status,
568: fnd_date.date_to_canonical(p_submission_start_date),
569: fnd_date.date_to_canonical(p_submission_end_date),
570: p_tax_office_name,
679: p_action_information_category,
680: p_tax_type,
681: p_transaction_status,
682: fnd_date.date_to_canonical(p_finalized_date),
683: fnd_number.number_to_canonical(p_finalized_by),
684: p_user_comments,
685: p_admin_comments,
686: p_transfer_status,
687: fnd_date.date_to_canonical(p_transfer_date),
727: update pay_jp_isdf_assact_dml_v
728: set object_version_number = p_object_version_number,
729: transaction_status = p_transaction_status,
730: finalized_date = fnd_date.date_to_canonical(p_finalized_date),
731: finalized_by = fnd_number.number_to_canonical(p_finalized_by),
732: user_comments = p_user_comments,
733: admin_comments = p_admin_comments,
734: transfer_status = p_transfer_status,
735: transfer_date = fnd_date.date_to_canonical(p_transfer_date),
932: p_effective_date,
933: p_action_information_category,
934: p_status,
935: p_ins_datetrack_update_mode,
936: fnd_number.number_to_canonical(p_ins_element_entry_id),
937: fnd_number.number_to_canonical(p_ins_ee_object_version_number),
938: fnd_number.number_to_canonical(p_life_gen_ins_prem),
939: fnd_number.number_to_canonical(p_life_gen_ins_prem_o),
940: fnd_number.number_to_canonical(p_life_pens_ins_prem),
933: p_action_information_category,
934: p_status,
935: p_ins_datetrack_update_mode,
936: fnd_number.number_to_canonical(p_ins_element_entry_id),
937: fnd_number.number_to_canonical(p_ins_ee_object_version_number),
938: fnd_number.number_to_canonical(p_life_gen_ins_prem),
939: fnd_number.number_to_canonical(p_life_gen_ins_prem_o),
940: fnd_number.number_to_canonical(p_life_pens_ins_prem),
941: fnd_number.number_to_canonical(p_life_pens_ins_prem_o),
934: p_status,
935: p_ins_datetrack_update_mode,
936: fnd_number.number_to_canonical(p_ins_element_entry_id),
937: fnd_number.number_to_canonical(p_ins_ee_object_version_number),
938: fnd_number.number_to_canonical(p_life_gen_ins_prem),
939: fnd_number.number_to_canonical(p_life_gen_ins_prem_o),
940: fnd_number.number_to_canonical(p_life_pens_ins_prem),
941: fnd_number.number_to_canonical(p_life_pens_ins_prem_o),
942: fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
935: p_ins_datetrack_update_mode,
936: fnd_number.number_to_canonical(p_ins_element_entry_id),
937: fnd_number.number_to_canonical(p_ins_ee_object_version_number),
938: fnd_number.number_to_canonical(p_life_gen_ins_prem),
939: fnd_number.number_to_canonical(p_life_gen_ins_prem_o),
940: fnd_number.number_to_canonical(p_life_pens_ins_prem),
941: fnd_number.number_to_canonical(p_life_pens_ins_prem_o),
942: fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
943: fnd_number.number_to_canonical(p_nonlife_long_ins_prem_o),
936: fnd_number.number_to_canonical(p_ins_element_entry_id),
937: fnd_number.number_to_canonical(p_ins_ee_object_version_number),
938: fnd_number.number_to_canonical(p_life_gen_ins_prem),
939: fnd_number.number_to_canonical(p_life_gen_ins_prem_o),
940: fnd_number.number_to_canonical(p_life_pens_ins_prem),
941: fnd_number.number_to_canonical(p_life_pens_ins_prem_o),
942: fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
943: fnd_number.number_to_canonical(p_nonlife_long_ins_prem_o),
944: fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
937: fnd_number.number_to_canonical(p_ins_ee_object_version_number),
938: fnd_number.number_to_canonical(p_life_gen_ins_prem),
939: fnd_number.number_to_canonical(p_life_gen_ins_prem_o),
940: fnd_number.number_to_canonical(p_life_pens_ins_prem),
941: fnd_number.number_to_canonical(p_life_pens_ins_prem_o),
942: fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
943: fnd_number.number_to_canonical(p_nonlife_long_ins_prem_o),
944: fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
945: fnd_number.number_to_canonical(p_nonlife_short_ins_prem_o),
938: fnd_number.number_to_canonical(p_life_gen_ins_prem),
939: fnd_number.number_to_canonical(p_life_gen_ins_prem_o),
940: fnd_number.number_to_canonical(p_life_pens_ins_prem),
941: fnd_number.number_to_canonical(p_life_pens_ins_prem_o),
942: fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
943: fnd_number.number_to_canonical(p_nonlife_long_ins_prem_o),
944: fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
945: fnd_number.number_to_canonical(p_nonlife_short_ins_prem_o),
946: fnd_number.number_to_canonical(p_earthquake_ins_prem),
939: fnd_number.number_to_canonical(p_life_gen_ins_prem_o),
940: fnd_number.number_to_canonical(p_life_pens_ins_prem),
941: fnd_number.number_to_canonical(p_life_pens_ins_prem_o),
942: fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
943: fnd_number.number_to_canonical(p_nonlife_long_ins_prem_o),
944: fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
945: fnd_number.number_to_canonical(p_nonlife_short_ins_prem_o),
946: fnd_number.number_to_canonical(p_earthquake_ins_prem),
947: fnd_number.number_to_canonical(p_earthquake_ins_prem_o),
940: fnd_number.number_to_canonical(p_life_pens_ins_prem),
941: fnd_number.number_to_canonical(p_life_pens_ins_prem_o),
942: fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
943: fnd_number.number_to_canonical(p_nonlife_long_ins_prem_o),
944: fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
945: fnd_number.number_to_canonical(p_nonlife_short_ins_prem_o),
946: fnd_number.number_to_canonical(p_earthquake_ins_prem),
947: fnd_number.number_to_canonical(p_earthquake_ins_prem_o),
948: p_is_datetrack_update_mode,
941: fnd_number.number_to_canonical(p_life_pens_ins_prem_o),
942: fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
943: fnd_number.number_to_canonical(p_nonlife_long_ins_prem_o),
944: fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
945: fnd_number.number_to_canonical(p_nonlife_short_ins_prem_o),
946: fnd_number.number_to_canonical(p_earthquake_ins_prem),
947: fnd_number.number_to_canonical(p_earthquake_ins_prem_o),
948: p_is_datetrack_update_mode,
949: fnd_number.number_to_canonical(p_is_element_entry_id),
942: fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
943: fnd_number.number_to_canonical(p_nonlife_long_ins_prem_o),
944: fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
945: fnd_number.number_to_canonical(p_nonlife_short_ins_prem_o),
946: fnd_number.number_to_canonical(p_earthquake_ins_prem),
947: fnd_number.number_to_canonical(p_earthquake_ins_prem_o),
948: p_is_datetrack_update_mode,
949: fnd_number.number_to_canonical(p_is_element_entry_id),
950: fnd_number.number_to_canonical(p_is_ee_object_version_number),
943: fnd_number.number_to_canonical(p_nonlife_long_ins_prem_o),
944: fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
945: fnd_number.number_to_canonical(p_nonlife_short_ins_prem_o),
946: fnd_number.number_to_canonical(p_earthquake_ins_prem),
947: fnd_number.number_to_canonical(p_earthquake_ins_prem_o),
948: p_is_datetrack_update_mode,
949: fnd_number.number_to_canonical(p_is_element_entry_id),
950: fnd_number.number_to_canonical(p_is_ee_object_version_number),
951: fnd_number.number_to_canonical(p_social_ins_prem),
945: fnd_number.number_to_canonical(p_nonlife_short_ins_prem_o),
946: fnd_number.number_to_canonical(p_earthquake_ins_prem),
947: fnd_number.number_to_canonical(p_earthquake_ins_prem_o),
948: p_is_datetrack_update_mode,
949: fnd_number.number_to_canonical(p_is_element_entry_id),
950: fnd_number.number_to_canonical(p_is_ee_object_version_number),
951: fnd_number.number_to_canonical(p_social_ins_prem),
952: fnd_number.number_to_canonical(p_social_ins_prem_o),
953: fnd_number.number_to_canonical(p_mutual_aid_prem),
946: fnd_number.number_to_canonical(p_earthquake_ins_prem),
947: fnd_number.number_to_canonical(p_earthquake_ins_prem_o),
948: p_is_datetrack_update_mode,
949: fnd_number.number_to_canonical(p_is_element_entry_id),
950: fnd_number.number_to_canonical(p_is_ee_object_version_number),
951: fnd_number.number_to_canonical(p_social_ins_prem),
952: fnd_number.number_to_canonical(p_social_ins_prem_o),
953: fnd_number.number_to_canonical(p_mutual_aid_prem),
954: fnd_number.number_to_canonical(p_mutual_aid_prem_o),
947: fnd_number.number_to_canonical(p_earthquake_ins_prem_o),
948: p_is_datetrack_update_mode,
949: fnd_number.number_to_canonical(p_is_element_entry_id),
950: fnd_number.number_to_canonical(p_is_ee_object_version_number),
951: fnd_number.number_to_canonical(p_social_ins_prem),
952: fnd_number.number_to_canonical(p_social_ins_prem_o),
953: fnd_number.number_to_canonical(p_mutual_aid_prem),
954: fnd_number.number_to_canonical(p_mutual_aid_prem_o),
955: fnd_number.number_to_canonical(p_spouse_income),
948: p_is_datetrack_update_mode,
949: fnd_number.number_to_canonical(p_is_element_entry_id),
950: fnd_number.number_to_canonical(p_is_ee_object_version_number),
951: fnd_number.number_to_canonical(p_social_ins_prem),
952: fnd_number.number_to_canonical(p_social_ins_prem_o),
953: fnd_number.number_to_canonical(p_mutual_aid_prem),
954: fnd_number.number_to_canonical(p_mutual_aid_prem_o),
955: fnd_number.number_to_canonical(p_spouse_income),
956: fnd_number.number_to_canonical(p_spouse_income_o),
949: fnd_number.number_to_canonical(p_is_element_entry_id),
950: fnd_number.number_to_canonical(p_is_ee_object_version_number),
951: fnd_number.number_to_canonical(p_social_ins_prem),
952: fnd_number.number_to_canonical(p_social_ins_prem_o),
953: fnd_number.number_to_canonical(p_mutual_aid_prem),
954: fnd_number.number_to_canonical(p_mutual_aid_prem_o),
955: fnd_number.number_to_canonical(p_spouse_income),
956: fnd_number.number_to_canonical(p_spouse_income_o),
957: fnd_number.number_to_canonical(p_national_pens_ins_prem),
950: fnd_number.number_to_canonical(p_is_ee_object_version_number),
951: fnd_number.number_to_canonical(p_social_ins_prem),
952: fnd_number.number_to_canonical(p_social_ins_prem_o),
953: fnd_number.number_to_canonical(p_mutual_aid_prem),
954: fnd_number.number_to_canonical(p_mutual_aid_prem_o),
955: fnd_number.number_to_canonical(p_spouse_income),
956: fnd_number.number_to_canonical(p_spouse_income_o),
957: fnd_number.number_to_canonical(p_national_pens_ins_prem),
958: fnd_number.number_to_canonical(p_national_pens_ins_prem_o));
951: fnd_number.number_to_canonical(p_social_ins_prem),
952: fnd_number.number_to_canonical(p_social_ins_prem_o),
953: fnd_number.number_to_canonical(p_mutual_aid_prem),
954: fnd_number.number_to_canonical(p_mutual_aid_prem_o),
955: fnd_number.number_to_canonical(p_spouse_income),
956: fnd_number.number_to_canonical(p_spouse_income_o),
957: fnd_number.number_to_canonical(p_national_pens_ins_prem),
958: fnd_number.number_to_canonical(p_national_pens_ins_prem_o));
959: --
952: fnd_number.number_to_canonical(p_social_ins_prem_o),
953: fnd_number.number_to_canonical(p_mutual_aid_prem),
954: fnd_number.number_to_canonical(p_mutual_aid_prem_o),
955: fnd_number.number_to_canonical(p_spouse_income),
956: fnd_number.number_to_canonical(p_spouse_income_o),
957: fnd_number.number_to_canonical(p_national_pens_ins_prem),
958: fnd_number.number_to_canonical(p_national_pens_ins_prem_o));
959: --
960: if g_debug then
953: fnd_number.number_to_canonical(p_mutual_aid_prem),
954: fnd_number.number_to_canonical(p_mutual_aid_prem_o),
955: fnd_number.number_to_canonical(p_spouse_income),
956: fnd_number.number_to_canonical(p_spouse_income_o),
957: fnd_number.number_to_canonical(p_national_pens_ins_prem),
958: fnd_number.number_to_canonical(p_national_pens_ins_prem_o));
959: --
960: if g_debug then
961: hr_utility.set_location(l_proc,1000);
954: fnd_number.number_to_canonical(p_mutual_aid_prem_o),
955: fnd_number.number_to_canonical(p_spouse_income),
956: fnd_number.number_to_canonical(p_spouse_income_o),
957: fnd_number.number_to_canonical(p_national_pens_ins_prem),
958: fnd_number.number_to_canonical(p_national_pens_ins_prem_o));
959: --
960: if g_debug then
961: hr_utility.set_location(l_proc,1000);
962: end if;
1007: --
1008: update pay_jp_isdf_entry_dml_v
1009: set object_version_number = p_object_version_number,
1010: status = p_status,
1011: life_gen_ins_prem = fnd_number.number_to_canonical(p_life_gen_ins_prem),
1012: life_gen_ins_prem_o = fnd_number.number_to_canonical(p_life_gen_ins_prem_o),
1013: life_pens_ins_prem = fnd_number.number_to_canonical(p_life_pens_ins_prem),
1014: life_pens_ins_prem_o = fnd_number.number_to_canonical(p_life_pens_ins_prem_o),
1015: nonlife_long_ins_prem = fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
1008: update pay_jp_isdf_entry_dml_v
1009: set object_version_number = p_object_version_number,
1010: status = p_status,
1011: life_gen_ins_prem = fnd_number.number_to_canonical(p_life_gen_ins_prem),
1012: life_gen_ins_prem_o = fnd_number.number_to_canonical(p_life_gen_ins_prem_o),
1013: life_pens_ins_prem = fnd_number.number_to_canonical(p_life_pens_ins_prem),
1014: life_pens_ins_prem_o = fnd_number.number_to_canonical(p_life_pens_ins_prem_o),
1015: nonlife_long_ins_prem = fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
1016: nonlife_long_ins_prem_o = fnd_number.number_to_canonical(p_nonlife_long_ins_prem_o),
1009: set object_version_number = p_object_version_number,
1010: status = p_status,
1011: life_gen_ins_prem = fnd_number.number_to_canonical(p_life_gen_ins_prem),
1012: life_gen_ins_prem_o = fnd_number.number_to_canonical(p_life_gen_ins_prem_o),
1013: life_pens_ins_prem = fnd_number.number_to_canonical(p_life_pens_ins_prem),
1014: life_pens_ins_prem_o = fnd_number.number_to_canonical(p_life_pens_ins_prem_o),
1015: nonlife_long_ins_prem = fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
1016: nonlife_long_ins_prem_o = fnd_number.number_to_canonical(p_nonlife_long_ins_prem_o),
1017: nonlife_short_ins_prem = fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
1010: status = p_status,
1011: life_gen_ins_prem = fnd_number.number_to_canonical(p_life_gen_ins_prem),
1012: life_gen_ins_prem_o = fnd_number.number_to_canonical(p_life_gen_ins_prem_o),
1013: life_pens_ins_prem = fnd_number.number_to_canonical(p_life_pens_ins_prem),
1014: life_pens_ins_prem_o = fnd_number.number_to_canonical(p_life_pens_ins_prem_o),
1015: nonlife_long_ins_prem = fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
1016: nonlife_long_ins_prem_o = fnd_number.number_to_canonical(p_nonlife_long_ins_prem_o),
1017: nonlife_short_ins_prem = fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
1018: nonlife_short_ins_prem_o = fnd_number.number_to_canonical(p_nonlife_short_ins_prem_o),
1011: life_gen_ins_prem = fnd_number.number_to_canonical(p_life_gen_ins_prem),
1012: life_gen_ins_prem_o = fnd_number.number_to_canonical(p_life_gen_ins_prem_o),
1013: life_pens_ins_prem = fnd_number.number_to_canonical(p_life_pens_ins_prem),
1014: life_pens_ins_prem_o = fnd_number.number_to_canonical(p_life_pens_ins_prem_o),
1015: nonlife_long_ins_prem = fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
1016: nonlife_long_ins_prem_o = fnd_number.number_to_canonical(p_nonlife_long_ins_prem_o),
1017: nonlife_short_ins_prem = fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
1018: nonlife_short_ins_prem_o = fnd_number.number_to_canonical(p_nonlife_short_ins_prem_o),
1019: earthquake_ins_prem = fnd_number.number_to_canonical(p_earthquake_ins_prem),
1012: life_gen_ins_prem_o = fnd_number.number_to_canonical(p_life_gen_ins_prem_o),
1013: life_pens_ins_prem = fnd_number.number_to_canonical(p_life_pens_ins_prem),
1014: life_pens_ins_prem_o = fnd_number.number_to_canonical(p_life_pens_ins_prem_o),
1015: nonlife_long_ins_prem = fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
1016: nonlife_long_ins_prem_o = fnd_number.number_to_canonical(p_nonlife_long_ins_prem_o),
1017: nonlife_short_ins_prem = fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
1018: nonlife_short_ins_prem_o = fnd_number.number_to_canonical(p_nonlife_short_ins_prem_o),
1019: earthquake_ins_prem = fnd_number.number_to_canonical(p_earthquake_ins_prem),
1020: earthquake_ins_prem_o = fnd_number.number_to_canonical(p_earthquake_ins_prem_o),
1013: life_pens_ins_prem = fnd_number.number_to_canonical(p_life_pens_ins_prem),
1014: life_pens_ins_prem_o = fnd_number.number_to_canonical(p_life_pens_ins_prem_o),
1015: nonlife_long_ins_prem = fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
1016: nonlife_long_ins_prem_o = fnd_number.number_to_canonical(p_nonlife_long_ins_prem_o),
1017: nonlife_short_ins_prem = fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
1018: nonlife_short_ins_prem_o = fnd_number.number_to_canonical(p_nonlife_short_ins_prem_o),
1019: earthquake_ins_prem = fnd_number.number_to_canonical(p_earthquake_ins_prem),
1020: earthquake_ins_prem_o = fnd_number.number_to_canonical(p_earthquake_ins_prem_o),
1021: social_ins_prem = fnd_number.number_to_canonical(p_social_ins_prem),
1014: life_pens_ins_prem_o = fnd_number.number_to_canonical(p_life_pens_ins_prem_o),
1015: nonlife_long_ins_prem = fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
1016: nonlife_long_ins_prem_o = fnd_number.number_to_canonical(p_nonlife_long_ins_prem_o),
1017: nonlife_short_ins_prem = fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
1018: nonlife_short_ins_prem_o = fnd_number.number_to_canonical(p_nonlife_short_ins_prem_o),
1019: earthquake_ins_prem = fnd_number.number_to_canonical(p_earthquake_ins_prem),
1020: earthquake_ins_prem_o = fnd_number.number_to_canonical(p_earthquake_ins_prem_o),
1021: social_ins_prem = fnd_number.number_to_canonical(p_social_ins_prem),
1022: social_ins_prem_o = fnd_number.number_to_canonical(p_social_ins_prem_o),
1015: nonlife_long_ins_prem = fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
1016: nonlife_long_ins_prem_o = fnd_number.number_to_canonical(p_nonlife_long_ins_prem_o),
1017: nonlife_short_ins_prem = fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
1018: nonlife_short_ins_prem_o = fnd_number.number_to_canonical(p_nonlife_short_ins_prem_o),
1019: earthquake_ins_prem = fnd_number.number_to_canonical(p_earthquake_ins_prem),
1020: earthquake_ins_prem_o = fnd_number.number_to_canonical(p_earthquake_ins_prem_o),
1021: social_ins_prem = fnd_number.number_to_canonical(p_social_ins_prem),
1022: social_ins_prem_o = fnd_number.number_to_canonical(p_social_ins_prem_o),
1023: mutual_aid_prem = fnd_number.number_to_canonical(p_mutual_aid_prem),
1016: nonlife_long_ins_prem_o = fnd_number.number_to_canonical(p_nonlife_long_ins_prem_o),
1017: nonlife_short_ins_prem = fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
1018: nonlife_short_ins_prem_o = fnd_number.number_to_canonical(p_nonlife_short_ins_prem_o),
1019: earthquake_ins_prem = fnd_number.number_to_canonical(p_earthquake_ins_prem),
1020: earthquake_ins_prem_o = fnd_number.number_to_canonical(p_earthquake_ins_prem_o),
1021: social_ins_prem = fnd_number.number_to_canonical(p_social_ins_prem),
1022: social_ins_prem_o = fnd_number.number_to_canonical(p_social_ins_prem_o),
1023: mutual_aid_prem = fnd_number.number_to_canonical(p_mutual_aid_prem),
1024: mutual_aid_prem_o = fnd_number.number_to_canonical(p_mutual_aid_prem_o),
1017: nonlife_short_ins_prem = fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
1018: nonlife_short_ins_prem_o = fnd_number.number_to_canonical(p_nonlife_short_ins_prem_o),
1019: earthquake_ins_prem = fnd_number.number_to_canonical(p_earthquake_ins_prem),
1020: earthquake_ins_prem_o = fnd_number.number_to_canonical(p_earthquake_ins_prem_o),
1021: social_ins_prem = fnd_number.number_to_canonical(p_social_ins_prem),
1022: social_ins_prem_o = fnd_number.number_to_canonical(p_social_ins_prem_o),
1023: mutual_aid_prem = fnd_number.number_to_canonical(p_mutual_aid_prem),
1024: mutual_aid_prem_o = fnd_number.number_to_canonical(p_mutual_aid_prem_o),
1025: spouse_income = fnd_number.number_to_canonical(p_spouse_income),
1018: nonlife_short_ins_prem_o = fnd_number.number_to_canonical(p_nonlife_short_ins_prem_o),
1019: earthquake_ins_prem = fnd_number.number_to_canonical(p_earthquake_ins_prem),
1020: earthquake_ins_prem_o = fnd_number.number_to_canonical(p_earthquake_ins_prem_o),
1021: social_ins_prem = fnd_number.number_to_canonical(p_social_ins_prem),
1022: social_ins_prem_o = fnd_number.number_to_canonical(p_social_ins_prem_o),
1023: mutual_aid_prem = fnd_number.number_to_canonical(p_mutual_aid_prem),
1024: mutual_aid_prem_o = fnd_number.number_to_canonical(p_mutual_aid_prem_o),
1025: spouse_income = fnd_number.number_to_canonical(p_spouse_income),
1026: spouse_income_o = fnd_number.number_to_canonical(p_spouse_income_o),
1019: earthquake_ins_prem = fnd_number.number_to_canonical(p_earthquake_ins_prem),
1020: earthquake_ins_prem_o = fnd_number.number_to_canonical(p_earthquake_ins_prem_o),
1021: social_ins_prem = fnd_number.number_to_canonical(p_social_ins_prem),
1022: social_ins_prem_o = fnd_number.number_to_canonical(p_social_ins_prem_o),
1023: mutual_aid_prem = fnd_number.number_to_canonical(p_mutual_aid_prem),
1024: mutual_aid_prem_o = fnd_number.number_to_canonical(p_mutual_aid_prem_o),
1025: spouse_income = fnd_number.number_to_canonical(p_spouse_income),
1026: spouse_income_o = fnd_number.number_to_canonical(p_spouse_income_o),
1027: national_pens_ins_prem = fnd_number.number_to_canonical(p_national_pens_ins_prem),
1020: earthquake_ins_prem_o = fnd_number.number_to_canonical(p_earthquake_ins_prem_o),
1021: social_ins_prem = fnd_number.number_to_canonical(p_social_ins_prem),
1022: social_ins_prem_o = fnd_number.number_to_canonical(p_social_ins_prem_o),
1023: mutual_aid_prem = fnd_number.number_to_canonical(p_mutual_aid_prem),
1024: mutual_aid_prem_o = fnd_number.number_to_canonical(p_mutual_aid_prem_o),
1025: spouse_income = fnd_number.number_to_canonical(p_spouse_income),
1026: spouse_income_o = fnd_number.number_to_canonical(p_spouse_income_o),
1027: national_pens_ins_prem = fnd_number.number_to_canonical(p_national_pens_ins_prem),
1028: national_pens_ins_prem_o = fnd_number.number_to_canonical(p_national_pens_ins_prem_o)
1021: social_ins_prem = fnd_number.number_to_canonical(p_social_ins_prem),
1022: social_ins_prem_o = fnd_number.number_to_canonical(p_social_ins_prem_o),
1023: mutual_aid_prem = fnd_number.number_to_canonical(p_mutual_aid_prem),
1024: mutual_aid_prem_o = fnd_number.number_to_canonical(p_mutual_aid_prem_o),
1025: spouse_income = fnd_number.number_to_canonical(p_spouse_income),
1026: spouse_income_o = fnd_number.number_to_canonical(p_spouse_income_o),
1027: national_pens_ins_prem = fnd_number.number_to_canonical(p_national_pens_ins_prem),
1028: national_pens_ins_prem_o = fnd_number.number_to_canonical(p_national_pens_ins_prem_o)
1029: where row_id = l_rec.row_id;
1022: social_ins_prem_o = fnd_number.number_to_canonical(p_social_ins_prem_o),
1023: mutual_aid_prem = fnd_number.number_to_canonical(p_mutual_aid_prem),
1024: mutual_aid_prem_o = fnd_number.number_to_canonical(p_mutual_aid_prem_o),
1025: spouse_income = fnd_number.number_to_canonical(p_spouse_income),
1026: spouse_income_o = fnd_number.number_to_canonical(p_spouse_income_o),
1027: national_pens_ins_prem = fnd_number.number_to_canonical(p_national_pens_ins_prem),
1028: national_pens_ins_prem_o = fnd_number.number_to_canonical(p_national_pens_ins_prem_o)
1029: where row_id = l_rec.row_id;
1030: --
1023: mutual_aid_prem = fnd_number.number_to_canonical(p_mutual_aid_prem),
1024: mutual_aid_prem_o = fnd_number.number_to_canonical(p_mutual_aid_prem_o),
1025: spouse_income = fnd_number.number_to_canonical(p_spouse_income),
1026: spouse_income_o = fnd_number.number_to_canonical(p_spouse_income_o),
1027: national_pens_ins_prem = fnd_number.number_to_canonical(p_national_pens_ins_prem),
1028: national_pens_ins_prem_o = fnd_number.number_to_canonical(p_national_pens_ins_prem_o)
1029: where row_id = l_rec.row_id;
1030: --
1031: if g_debug then
1024: mutual_aid_prem_o = fnd_number.number_to_canonical(p_mutual_aid_prem_o),
1025: spouse_income = fnd_number.number_to_canonical(p_spouse_income),
1026: spouse_income_o = fnd_number.number_to_canonical(p_spouse_income_o),
1027: national_pens_ins_prem = fnd_number.number_to_canonical(p_national_pens_ins_prem),
1028: national_pens_ins_prem_o = fnd_number.number_to_canonical(p_national_pens_ins_prem_o)
1029: where row_id = l_rec.row_id;
1030: --
1031: if g_debug then
1032: hr_utility.set_location(l_proc,1000);
1123: p_assignment_id,
1124: p_effective_date,
1125: p_action_information_category,
1126: p_status,
1127: fnd_number.number_to_canonical(p_life_gen_ins_prem),
1128: fnd_number.number_to_canonical(p_life_pens_ins_prem),
1129: fnd_number.number_to_canonical(p_life_gen_ins_calc_prem),
1130: fnd_number.number_to_canonical(p_life_pens_ins_calc_prem),
1131: fnd_number.number_to_canonical(p_life_ins_deduction),
1124: p_effective_date,
1125: p_action_information_category,
1126: p_status,
1127: fnd_number.number_to_canonical(p_life_gen_ins_prem),
1128: fnd_number.number_to_canonical(p_life_pens_ins_prem),
1129: fnd_number.number_to_canonical(p_life_gen_ins_calc_prem),
1130: fnd_number.number_to_canonical(p_life_pens_ins_calc_prem),
1131: fnd_number.number_to_canonical(p_life_ins_deduction),
1132: fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
1125: p_action_information_category,
1126: p_status,
1127: fnd_number.number_to_canonical(p_life_gen_ins_prem),
1128: fnd_number.number_to_canonical(p_life_pens_ins_prem),
1129: fnd_number.number_to_canonical(p_life_gen_ins_calc_prem),
1130: fnd_number.number_to_canonical(p_life_pens_ins_calc_prem),
1131: fnd_number.number_to_canonical(p_life_ins_deduction),
1132: fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
1133: fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
1126: p_status,
1127: fnd_number.number_to_canonical(p_life_gen_ins_prem),
1128: fnd_number.number_to_canonical(p_life_pens_ins_prem),
1129: fnd_number.number_to_canonical(p_life_gen_ins_calc_prem),
1130: fnd_number.number_to_canonical(p_life_pens_ins_calc_prem),
1131: fnd_number.number_to_canonical(p_life_ins_deduction),
1132: fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
1133: fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
1134: fnd_number.number_to_canonical(p_earthquake_ins_prem),
1127: fnd_number.number_to_canonical(p_life_gen_ins_prem),
1128: fnd_number.number_to_canonical(p_life_pens_ins_prem),
1129: fnd_number.number_to_canonical(p_life_gen_ins_calc_prem),
1130: fnd_number.number_to_canonical(p_life_pens_ins_calc_prem),
1131: fnd_number.number_to_canonical(p_life_ins_deduction),
1132: fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
1133: fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
1134: fnd_number.number_to_canonical(p_earthquake_ins_prem),
1135: fnd_number.number_to_canonical(p_nonlife_long_ins_calc_prem),
1128: fnd_number.number_to_canonical(p_life_pens_ins_prem),
1129: fnd_number.number_to_canonical(p_life_gen_ins_calc_prem),
1130: fnd_number.number_to_canonical(p_life_pens_ins_calc_prem),
1131: fnd_number.number_to_canonical(p_life_ins_deduction),
1132: fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
1133: fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
1134: fnd_number.number_to_canonical(p_earthquake_ins_prem),
1135: fnd_number.number_to_canonical(p_nonlife_long_ins_calc_prem),
1136: fnd_number.number_to_canonical(p_nonlife_short_ins_calc_prem),
1129: fnd_number.number_to_canonical(p_life_gen_ins_calc_prem),
1130: fnd_number.number_to_canonical(p_life_pens_ins_calc_prem),
1131: fnd_number.number_to_canonical(p_life_ins_deduction),
1132: fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
1133: fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
1134: fnd_number.number_to_canonical(p_earthquake_ins_prem),
1135: fnd_number.number_to_canonical(p_nonlife_long_ins_calc_prem),
1136: fnd_number.number_to_canonical(p_nonlife_short_ins_calc_prem),
1137: fnd_number.number_to_canonical(p_earthquake_ins_calc_prem),
1130: fnd_number.number_to_canonical(p_life_pens_ins_calc_prem),
1131: fnd_number.number_to_canonical(p_life_ins_deduction),
1132: fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
1133: fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
1134: fnd_number.number_to_canonical(p_earthquake_ins_prem),
1135: fnd_number.number_to_canonical(p_nonlife_long_ins_calc_prem),
1136: fnd_number.number_to_canonical(p_nonlife_short_ins_calc_prem),
1137: fnd_number.number_to_canonical(p_earthquake_ins_calc_prem),
1138: fnd_number.number_to_canonical(p_nonlife_ins_deduction),
1131: fnd_number.number_to_canonical(p_life_ins_deduction),
1132: fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
1133: fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
1134: fnd_number.number_to_canonical(p_earthquake_ins_prem),
1135: fnd_number.number_to_canonical(p_nonlife_long_ins_calc_prem),
1136: fnd_number.number_to_canonical(p_nonlife_short_ins_calc_prem),
1137: fnd_number.number_to_canonical(p_earthquake_ins_calc_prem),
1138: fnd_number.number_to_canonical(p_nonlife_ins_deduction),
1139: fnd_number.number_to_canonical(p_social_ins_deduction),
1132: fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
1133: fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
1134: fnd_number.number_to_canonical(p_earthquake_ins_prem),
1135: fnd_number.number_to_canonical(p_nonlife_long_ins_calc_prem),
1136: fnd_number.number_to_canonical(p_nonlife_short_ins_calc_prem),
1137: fnd_number.number_to_canonical(p_earthquake_ins_calc_prem),
1138: fnd_number.number_to_canonical(p_nonlife_ins_deduction),
1139: fnd_number.number_to_canonical(p_social_ins_deduction),
1140: fnd_number.number_to_canonical(p_mutual_aid_deduction),
1133: fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
1134: fnd_number.number_to_canonical(p_earthquake_ins_prem),
1135: fnd_number.number_to_canonical(p_nonlife_long_ins_calc_prem),
1136: fnd_number.number_to_canonical(p_nonlife_short_ins_calc_prem),
1137: fnd_number.number_to_canonical(p_earthquake_ins_calc_prem),
1138: fnd_number.number_to_canonical(p_nonlife_ins_deduction),
1139: fnd_number.number_to_canonical(p_social_ins_deduction),
1140: fnd_number.number_to_canonical(p_mutual_aid_deduction),
1141: fnd_number.number_to_canonical(p_sp_earned_income_calc),
1134: fnd_number.number_to_canonical(p_earthquake_ins_prem),
1135: fnd_number.number_to_canonical(p_nonlife_long_ins_calc_prem),
1136: fnd_number.number_to_canonical(p_nonlife_short_ins_calc_prem),
1137: fnd_number.number_to_canonical(p_earthquake_ins_calc_prem),
1138: fnd_number.number_to_canonical(p_nonlife_ins_deduction),
1139: fnd_number.number_to_canonical(p_social_ins_deduction),
1140: fnd_number.number_to_canonical(p_mutual_aid_deduction),
1141: fnd_number.number_to_canonical(p_sp_earned_income_calc),
1142: fnd_number.number_to_canonical(p_sp_business_income_calc),
1135: fnd_number.number_to_canonical(p_nonlife_long_ins_calc_prem),
1136: fnd_number.number_to_canonical(p_nonlife_short_ins_calc_prem),
1137: fnd_number.number_to_canonical(p_earthquake_ins_calc_prem),
1138: fnd_number.number_to_canonical(p_nonlife_ins_deduction),
1139: fnd_number.number_to_canonical(p_social_ins_deduction),
1140: fnd_number.number_to_canonical(p_mutual_aid_deduction),
1141: fnd_number.number_to_canonical(p_sp_earned_income_calc),
1142: fnd_number.number_to_canonical(p_sp_business_income_calc),
1143: fnd_number.number_to_canonical(p_sp_miscellaneous_income_calc),
1136: fnd_number.number_to_canonical(p_nonlife_short_ins_calc_prem),
1137: fnd_number.number_to_canonical(p_earthquake_ins_calc_prem),
1138: fnd_number.number_to_canonical(p_nonlife_ins_deduction),
1139: fnd_number.number_to_canonical(p_social_ins_deduction),
1140: fnd_number.number_to_canonical(p_mutual_aid_deduction),
1141: fnd_number.number_to_canonical(p_sp_earned_income_calc),
1142: fnd_number.number_to_canonical(p_sp_business_income_calc),
1143: fnd_number.number_to_canonical(p_sp_miscellaneous_income_calc),
1144: fnd_number.number_to_canonical(p_sp_dividend_income_calc),
1137: fnd_number.number_to_canonical(p_earthquake_ins_calc_prem),
1138: fnd_number.number_to_canonical(p_nonlife_ins_deduction),
1139: fnd_number.number_to_canonical(p_social_ins_deduction),
1140: fnd_number.number_to_canonical(p_mutual_aid_deduction),
1141: fnd_number.number_to_canonical(p_sp_earned_income_calc),
1142: fnd_number.number_to_canonical(p_sp_business_income_calc),
1143: fnd_number.number_to_canonical(p_sp_miscellaneous_income_calc),
1144: fnd_number.number_to_canonical(p_sp_dividend_income_calc),
1145: fnd_number.number_to_canonical(p_sp_real_estate_income_calc),
1138: fnd_number.number_to_canonical(p_nonlife_ins_deduction),
1139: fnd_number.number_to_canonical(p_social_ins_deduction),
1140: fnd_number.number_to_canonical(p_mutual_aid_deduction),
1141: fnd_number.number_to_canonical(p_sp_earned_income_calc),
1142: fnd_number.number_to_canonical(p_sp_business_income_calc),
1143: fnd_number.number_to_canonical(p_sp_miscellaneous_income_calc),
1144: fnd_number.number_to_canonical(p_sp_dividend_income_calc),
1145: fnd_number.number_to_canonical(p_sp_real_estate_income_calc),
1146: fnd_number.number_to_canonical(p_sp_retirement_income_calc),
1139: fnd_number.number_to_canonical(p_social_ins_deduction),
1140: fnd_number.number_to_canonical(p_mutual_aid_deduction),
1141: fnd_number.number_to_canonical(p_sp_earned_income_calc),
1142: fnd_number.number_to_canonical(p_sp_business_income_calc),
1143: fnd_number.number_to_canonical(p_sp_miscellaneous_income_calc),
1144: fnd_number.number_to_canonical(p_sp_dividend_income_calc),
1145: fnd_number.number_to_canonical(p_sp_real_estate_income_calc),
1146: fnd_number.number_to_canonical(p_sp_retirement_income_calc),
1147: fnd_number.number_to_canonical(p_sp_other_income_calc),
1140: fnd_number.number_to_canonical(p_mutual_aid_deduction),
1141: fnd_number.number_to_canonical(p_sp_earned_income_calc),
1142: fnd_number.number_to_canonical(p_sp_business_income_calc),
1143: fnd_number.number_to_canonical(p_sp_miscellaneous_income_calc),
1144: fnd_number.number_to_canonical(p_sp_dividend_income_calc),
1145: fnd_number.number_to_canonical(p_sp_real_estate_income_calc),
1146: fnd_number.number_to_canonical(p_sp_retirement_income_calc),
1147: fnd_number.number_to_canonical(p_sp_other_income_calc),
1148: fnd_number.number_to_canonical(p_sp_income_calc),
1141: fnd_number.number_to_canonical(p_sp_earned_income_calc),
1142: fnd_number.number_to_canonical(p_sp_business_income_calc),
1143: fnd_number.number_to_canonical(p_sp_miscellaneous_income_calc),
1144: fnd_number.number_to_canonical(p_sp_dividend_income_calc),
1145: fnd_number.number_to_canonical(p_sp_real_estate_income_calc),
1146: fnd_number.number_to_canonical(p_sp_retirement_income_calc),
1147: fnd_number.number_to_canonical(p_sp_other_income_calc),
1148: fnd_number.number_to_canonical(p_sp_income_calc),
1149: fnd_number.number_to_canonical(p_spouse_income),
1142: fnd_number.number_to_canonical(p_sp_business_income_calc),
1143: fnd_number.number_to_canonical(p_sp_miscellaneous_income_calc),
1144: fnd_number.number_to_canonical(p_sp_dividend_income_calc),
1145: fnd_number.number_to_canonical(p_sp_real_estate_income_calc),
1146: fnd_number.number_to_canonical(p_sp_retirement_income_calc),
1147: fnd_number.number_to_canonical(p_sp_other_income_calc),
1148: fnd_number.number_to_canonical(p_sp_income_calc),
1149: fnd_number.number_to_canonical(p_spouse_income),
1150: fnd_number.number_to_canonical(p_spouse_deduction),
1143: fnd_number.number_to_canonical(p_sp_miscellaneous_income_calc),
1144: fnd_number.number_to_canonical(p_sp_dividend_income_calc),
1145: fnd_number.number_to_canonical(p_sp_real_estate_income_calc),
1146: fnd_number.number_to_canonical(p_sp_retirement_income_calc),
1147: fnd_number.number_to_canonical(p_sp_other_income_calc),
1148: fnd_number.number_to_canonical(p_sp_income_calc),
1149: fnd_number.number_to_canonical(p_spouse_income),
1150: fnd_number.number_to_canonical(p_spouse_deduction),
1151: fnd_number.number_to_canonical(p_national_pens_ins_prem));
1144: fnd_number.number_to_canonical(p_sp_dividend_income_calc),
1145: fnd_number.number_to_canonical(p_sp_real_estate_income_calc),
1146: fnd_number.number_to_canonical(p_sp_retirement_income_calc),
1147: fnd_number.number_to_canonical(p_sp_other_income_calc),
1148: fnd_number.number_to_canonical(p_sp_income_calc),
1149: fnd_number.number_to_canonical(p_spouse_income),
1150: fnd_number.number_to_canonical(p_spouse_deduction),
1151: fnd_number.number_to_canonical(p_national_pens_ins_prem));
1152: --
1145: fnd_number.number_to_canonical(p_sp_real_estate_income_calc),
1146: fnd_number.number_to_canonical(p_sp_retirement_income_calc),
1147: fnd_number.number_to_canonical(p_sp_other_income_calc),
1148: fnd_number.number_to_canonical(p_sp_income_calc),
1149: fnd_number.number_to_canonical(p_spouse_income),
1150: fnd_number.number_to_canonical(p_spouse_deduction),
1151: fnd_number.number_to_canonical(p_national_pens_ins_prem));
1152: --
1153: if g_debug then
1146: fnd_number.number_to_canonical(p_sp_retirement_income_calc),
1147: fnd_number.number_to_canonical(p_sp_other_income_calc),
1148: fnd_number.number_to_canonical(p_sp_income_calc),
1149: fnd_number.number_to_canonical(p_spouse_income),
1150: fnd_number.number_to_canonical(p_spouse_deduction),
1151: fnd_number.number_to_canonical(p_national_pens_ins_prem));
1152: --
1153: if g_debug then
1154: hr_utility.set_location(l_proc,1000);
1147: fnd_number.number_to_canonical(p_sp_other_income_calc),
1148: fnd_number.number_to_canonical(p_sp_income_calc),
1149: fnd_number.number_to_canonical(p_spouse_income),
1150: fnd_number.number_to_canonical(p_spouse_deduction),
1151: fnd_number.number_to_canonical(p_national_pens_ins_prem));
1152: --
1153: if g_debug then
1154: hr_utility.set_location(l_proc,1000);
1155: end if;
1207: --
1208: update pay_jp_isdf_calc_dct_dml_v
1209: set object_version_number = p_object_version_number,
1210: status = p_status,
1211: life_gen_ins_prem = fnd_number.number_to_canonical(p_life_gen_ins_prem),
1212: life_pens_ins_prem = fnd_number.number_to_canonical(p_life_pens_ins_prem),
1213: life_gen_ins_calc_prem = fnd_number.number_to_canonical(p_life_gen_ins_calc_prem),
1214: life_pens_ins_calc_prem = fnd_number.number_to_canonical(p_life_pens_ins_calc_prem),
1215: life_ins_deduction = fnd_number.number_to_canonical(p_life_ins_deduction),
1208: update pay_jp_isdf_calc_dct_dml_v
1209: set object_version_number = p_object_version_number,
1210: status = p_status,
1211: life_gen_ins_prem = fnd_number.number_to_canonical(p_life_gen_ins_prem),
1212: life_pens_ins_prem = fnd_number.number_to_canonical(p_life_pens_ins_prem),
1213: life_gen_ins_calc_prem = fnd_number.number_to_canonical(p_life_gen_ins_calc_prem),
1214: life_pens_ins_calc_prem = fnd_number.number_to_canonical(p_life_pens_ins_calc_prem),
1215: life_ins_deduction = fnd_number.number_to_canonical(p_life_ins_deduction),
1216: nonlife_long_ins_prem = fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
1209: set object_version_number = p_object_version_number,
1210: status = p_status,
1211: life_gen_ins_prem = fnd_number.number_to_canonical(p_life_gen_ins_prem),
1212: life_pens_ins_prem = fnd_number.number_to_canonical(p_life_pens_ins_prem),
1213: life_gen_ins_calc_prem = fnd_number.number_to_canonical(p_life_gen_ins_calc_prem),
1214: life_pens_ins_calc_prem = fnd_number.number_to_canonical(p_life_pens_ins_calc_prem),
1215: life_ins_deduction = fnd_number.number_to_canonical(p_life_ins_deduction),
1216: nonlife_long_ins_prem = fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
1217: nonlife_short_ins_prem = fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
1210: status = p_status,
1211: life_gen_ins_prem = fnd_number.number_to_canonical(p_life_gen_ins_prem),
1212: life_pens_ins_prem = fnd_number.number_to_canonical(p_life_pens_ins_prem),
1213: life_gen_ins_calc_prem = fnd_number.number_to_canonical(p_life_gen_ins_calc_prem),
1214: life_pens_ins_calc_prem = fnd_number.number_to_canonical(p_life_pens_ins_calc_prem),
1215: life_ins_deduction = fnd_number.number_to_canonical(p_life_ins_deduction),
1216: nonlife_long_ins_prem = fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
1217: nonlife_short_ins_prem = fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
1218: earthquake_ins_prem = fnd_number.number_to_canonical(p_earthquake_ins_prem),
1211: life_gen_ins_prem = fnd_number.number_to_canonical(p_life_gen_ins_prem),
1212: life_pens_ins_prem = fnd_number.number_to_canonical(p_life_pens_ins_prem),
1213: life_gen_ins_calc_prem = fnd_number.number_to_canonical(p_life_gen_ins_calc_prem),
1214: life_pens_ins_calc_prem = fnd_number.number_to_canonical(p_life_pens_ins_calc_prem),
1215: life_ins_deduction = fnd_number.number_to_canonical(p_life_ins_deduction),
1216: nonlife_long_ins_prem = fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
1217: nonlife_short_ins_prem = fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
1218: earthquake_ins_prem = fnd_number.number_to_canonical(p_earthquake_ins_prem),
1219: nonlife_long_ins_calc_prem = fnd_number.number_to_canonical(p_nonlife_long_ins_calc_prem),
1212: life_pens_ins_prem = fnd_number.number_to_canonical(p_life_pens_ins_prem),
1213: life_gen_ins_calc_prem = fnd_number.number_to_canonical(p_life_gen_ins_calc_prem),
1214: life_pens_ins_calc_prem = fnd_number.number_to_canonical(p_life_pens_ins_calc_prem),
1215: life_ins_deduction = fnd_number.number_to_canonical(p_life_ins_deduction),
1216: nonlife_long_ins_prem = fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
1217: nonlife_short_ins_prem = fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
1218: earthquake_ins_prem = fnd_number.number_to_canonical(p_earthquake_ins_prem),
1219: nonlife_long_ins_calc_prem = fnd_number.number_to_canonical(p_nonlife_long_ins_calc_prem),
1220: nonlife_short_ins_calc_prem = fnd_number.number_to_canonical(p_nonlife_short_ins_calc_prem),
1213: life_gen_ins_calc_prem = fnd_number.number_to_canonical(p_life_gen_ins_calc_prem),
1214: life_pens_ins_calc_prem = fnd_number.number_to_canonical(p_life_pens_ins_calc_prem),
1215: life_ins_deduction = fnd_number.number_to_canonical(p_life_ins_deduction),
1216: nonlife_long_ins_prem = fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
1217: nonlife_short_ins_prem = fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
1218: earthquake_ins_prem = fnd_number.number_to_canonical(p_earthquake_ins_prem),
1219: nonlife_long_ins_calc_prem = fnd_number.number_to_canonical(p_nonlife_long_ins_calc_prem),
1220: nonlife_short_ins_calc_prem = fnd_number.number_to_canonical(p_nonlife_short_ins_calc_prem),
1221: earthquake_ins_calc_prem = fnd_number.number_to_canonical(p_earthquake_ins_calc_prem),
1214: life_pens_ins_calc_prem = fnd_number.number_to_canonical(p_life_pens_ins_calc_prem),
1215: life_ins_deduction = fnd_number.number_to_canonical(p_life_ins_deduction),
1216: nonlife_long_ins_prem = fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
1217: nonlife_short_ins_prem = fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
1218: earthquake_ins_prem = fnd_number.number_to_canonical(p_earthquake_ins_prem),
1219: nonlife_long_ins_calc_prem = fnd_number.number_to_canonical(p_nonlife_long_ins_calc_prem),
1220: nonlife_short_ins_calc_prem = fnd_number.number_to_canonical(p_nonlife_short_ins_calc_prem),
1221: earthquake_ins_calc_prem = fnd_number.number_to_canonical(p_earthquake_ins_calc_prem),
1222: nonlife_ins_deduction = fnd_number.number_to_canonical(p_nonlife_ins_deduction),
1215: life_ins_deduction = fnd_number.number_to_canonical(p_life_ins_deduction),
1216: nonlife_long_ins_prem = fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
1217: nonlife_short_ins_prem = fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
1218: earthquake_ins_prem = fnd_number.number_to_canonical(p_earthquake_ins_prem),
1219: nonlife_long_ins_calc_prem = fnd_number.number_to_canonical(p_nonlife_long_ins_calc_prem),
1220: nonlife_short_ins_calc_prem = fnd_number.number_to_canonical(p_nonlife_short_ins_calc_prem),
1221: earthquake_ins_calc_prem = fnd_number.number_to_canonical(p_earthquake_ins_calc_prem),
1222: nonlife_ins_deduction = fnd_number.number_to_canonical(p_nonlife_ins_deduction),
1223: social_ins_deduction = fnd_number.number_to_canonical(p_social_ins_deduction),
1216: nonlife_long_ins_prem = fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
1217: nonlife_short_ins_prem = fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
1218: earthquake_ins_prem = fnd_number.number_to_canonical(p_earthquake_ins_prem),
1219: nonlife_long_ins_calc_prem = fnd_number.number_to_canonical(p_nonlife_long_ins_calc_prem),
1220: nonlife_short_ins_calc_prem = fnd_number.number_to_canonical(p_nonlife_short_ins_calc_prem),
1221: earthquake_ins_calc_prem = fnd_number.number_to_canonical(p_earthquake_ins_calc_prem),
1222: nonlife_ins_deduction = fnd_number.number_to_canonical(p_nonlife_ins_deduction),
1223: social_ins_deduction = fnd_number.number_to_canonical(p_social_ins_deduction),
1224: mutual_aid_deduction = fnd_number.number_to_canonical(p_mutual_aid_deduction),
1217: nonlife_short_ins_prem = fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
1218: earthquake_ins_prem = fnd_number.number_to_canonical(p_earthquake_ins_prem),
1219: nonlife_long_ins_calc_prem = fnd_number.number_to_canonical(p_nonlife_long_ins_calc_prem),
1220: nonlife_short_ins_calc_prem = fnd_number.number_to_canonical(p_nonlife_short_ins_calc_prem),
1221: earthquake_ins_calc_prem = fnd_number.number_to_canonical(p_earthquake_ins_calc_prem),
1222: nonlife_ins_deduction = fnd_number.number_to_canonical(p_nonlife_ins_deduction),
1223: social_ins_deduction = fnd_number.number_to_canonical(p_social_ins_deduction),
1224: mutual_aid_deduction = fnd_number.number_to_canonical(p_mutual_aid_deduction),
1225: sp_earned_income_calc = fnd_number.number_to_canonical(p_sp_earned_income_calc),
1218: earthquake_ins_prem = fnd_number.number_to_canonical(p_earthquake_ins_prem),
1219: nonlife_long_ins_calc_prem = fnd_number.number_to_canonical(p_nonlife_long_ins_calc_prem),
1220: nonlife_short_ins_calc_prem = fnd_number.number_to_canonical(p_nonlife_short_ins_calc_prem),
1221: earthquake_ins_calc_prem = fnd_number.number_to_canonical(p_earthquake_ins_calc_prem),
1222: nonlife_ins_deduction = fnd_number.number_to_canonical(p_nonlife_ins_deduction),
1223: social_ins_deduction = fnd_number.number_to_canonical(p_social_ins_deduction),
1224: mutual_aid_deduction = fnd_number.number_to_canonical(p_mutual_aid_deduction),
1225: sp_earned_income_calc = fnd_number.number_to_canonical(p_sp_earned_income_calc),
1226: sp_business_income_calc = fnd_number.number_to_canonical(p_sp_business_income_calc),
1219: nonlife_long_ins_calc_prem = fnd_number.number_to_canonical(p_nonlife_long_ins_calc_prem),
1220: nonlife_short_ins_calc_prem = fnd_number.number_to_canonical(p_nonlife_short_ins_calc_prem),
1221: earthquake_ins_calc_prem = fnd_number.number_to_canonical(p_earthquake_ins_calc_prem),
1222: nonlife_ins_deduction = fnd_number.number_to_canonical(p_nonlife_ins_deduction),
1223: social_ins_deduction = fnd_number.number_to_canonical(p_social_ins_deduction),
1224: mutual_aid_deduction = fnd_number.number_to_canonical(p_mutual_aid_deduction),
1225: sp_earned_income_calc = fnd_number.number_to_canonical(p_sp_earned_income_calc),
1226: sp_business_income_calc = fnd_number.number_to_canonical(p_sp_business_income_calc),
1227: sp_miscellaneous_income_calc = fnd_number.number_to_canonical(p_sp_miscellaneous_income_calc),
1220: nonlife_short_ins_calc_prem = fnd_number.number_to_canonical(p_nonlife_short_ins_calc_prem),
1221: earthquake_ins_calc_prem = fnd_number.number_to_canonical(p_earthquake_ins_calc_prem),
1222: nonlife_ins_deduction = fnd_number.number_to_canonical(p_nonlife_ins_deduction),
1223: social_ins_deduction = fnd_number.number_to_canonical(p_social_ins_deduction),
1224: mutual_aid_deduction = fnd_number.number_to_canonical(p_mutual_aid_deduction),
1225: sp_earned_income_calc = fnd_number.number_to_canonical(p_sp_earned_income_calc),
1226: sp_business_income_calc = fnd_number.number_to_canonical(p_sp_business_income_calc),
1227: sp_miscellaneous_income_calc = fnd_number.number_to_canonical(p_sp_miscellaneous_income_calc),
1228: sp_dividend_income_calc = fnd_number.number_to_canonical(p_sp_dividend_income_calc),
1221: earthquake_ins_calc_prem = fnd_number.number_to_canonical(p_earthquake_ins_calc_prem),
1222: nonlife_ins_deduction = fnd_number.number_to_canonical(p_nonlife_ins_deduction),
1223: social_ins_deduction = fnd_number.number_to_canonical(p_social_ins_deduction),
1224: mutual_aid_deduction = fnd_number.number_to_canonical(p_mutual_aid_deduction),
1225: sp_earned_income_calc = fnd_number.number_to_canonical(p_sp_earned_income_calc),
1226: sp_business_income_calc = fnd_number.number_to_canonical(p_sp_business_income_calc),
1227: sp_miscellaneous_income_calc = fnd_number.number_to_canonical(p_sp_miscellaneous_income_calc),
1228: sp_dividend_income_calc = fnd_number.number_to_canonical(p_sp_dividend_income_calc),
1229: sp_real_estate_income_calc = fnd_number.number_to_canonical(p_sp_real_estate_income_calc),
1222: nonlife_ins_deduction = fnd_number.number_to_canonical(p_nonlife_ins_deduction),
1223: social_ins_deduction = fnd_number.number_to_canonical(p_social_ins_deduction),
1224: mutual_aid_deduction = fnd_number.number_to_canonical(p_mutual_aid_deduction),
1225: sp_earned_income_calc = fnd_number.number_to_canonical(p_sp_earned_income_calc),
1226: sp_business_income_calc = fnd_number.number_to_canonical(p_sp_business_income_calc),
1227: sp_miscellaneous_income_calc = fnd_number.number_to_canonical(p_sp_miscellaneous_income_calc),
1228: sp_dividend_income_calc = fnd_number.number_to_canonical(p_sp_dividend_income_calc),
1229: sp_real_estate_income_calc = fnd_number.number_to_canonical(p_sp_real_estate_income_calc),
1230: sp_retirement_income_calc = fnd_number.number_to_canonical(p_sp_retirement_income_calc),
1223: social_ins_deduction = fnd_number.number_to_canonical(p_social_ins_deduction),
1224: mutual_aid_deduction = fnd_number.number_to_canonical(p_mutual_aid_deduction),
1225: sp_earned_income_calc = fnd_number.number_to_canonical(p_sp_earned_income_calc),
1226: sp_business_income_calc = fnd_number.number_to_canonical(p_sp_business_income_calc),
1227: sp_miscellaneous_income_calc = fnd_number.number_to_canonical(p_sp_miscellaneous_income_calc),
1228: sp_dividend_income_calc = fnd_number.number_to_canonical(p_sp_dividend_income_calc),
1229: sp_real_estate_income_calc = fnd_number.number_to_canonical(p_sp_real_estate_income_calc),
1230: sp_retirement_income_calc = fnd_number.number_to_canonical(p_sp_retirement_income_calc),
1231: sp_other_income_calc = fnd_number.number_to_canonical(p_sp_other_income_calc),
1224: mutual_aid_deduction = fnd_number.number_to_canonical(p_mutual_aid_deduction),
1225: sp_earned_income_calc = fnd_number.number_to_canonical(p_sp_earned_income_calc),
1226: sp_business_income_calc = fnd_number.number_to_canonical(p_sp_business_income_calc),
1227: sp_miscellaneous_income_calc = fnd_number.number_to_canonical(p_sp_miscellaneous_income_calc),
1228: sp_dividend_income_calc = fnd_number.number_to_canonical(p_sp_dividend_income_calc),
1229: sp_real_estate_income_calc = fnd_number.number_to_canonical(p_sp_real_estate_income_calc),
1230: sp_retirement_income_calc = fnd_number.number_to_canonical(p_sp_retirement_income_calc),
1231: sp_other_income_calc = fnd_number.number_to_canonical(p_sp_other_income_calc),
1232: sp_income_calc = fnd_number.number_to_canonical(p_sp_income_calc),
1225: sp_earned_income_calc = fnd_number.number_to_canonical(p_sp_earned_income_calc),
1226: sp_business_income_calc = fnd_number.number_to_canonical(p_sp_business_income_calc),
1227: sp_miscellaneous_income_calc = fnd_number.number_to_canonical(p_sp_miscellaneous_income_calc),
1228: sp_dividend_income_calc = fnd_number.number_to_canonical(p_sp_dividend_income_calc),
1229: sp_real_estate_income_calc = fnd_number.number_to_canonical(p_sp_real_estate_income_calc),
1230: sp_retirement_income_calc = fnd_number.number_to_canonical(p_sp_retirement_income_calc),
1231: sp_other_income_calc = fnd_number.number_to_canonical(p_sp_other_income_calc),
1232: sp_income_calc = fnd_number.number_to_canonical(p_sp_income_calc),
1233: spouse_income = fnd_number.number_to_canonical(p_spouse_income),
1226: sp_business_income_calc = fnd_number.number_to_canonical(p_sp_business_income_calc),
1227: sp_miscellaneous_income_calc = fnd_number.number_to_canonical(p_sp_miscellaneous_income_calc),
1228: sp_dividend_income_calc = fnd_number.number_to_canonical(p_sp_dividend_income_calc),
1229: sp_real_estate_income_calc = fnd_number.number_to_canonical(p_sp_real_estate_income_calc),
1230: sp_retirement_income_calc = fnd_number.number_to_canonical(p_sp_retirement_income_calc),
1231: sp_other_income_calc = fnd_number.number_to_canonical(p_sp_other_income_calc),
1232: sp_income_calc = fnd_number.number_to_canonical(p_sp_income_calc),
1233: spouse_income = fnd_number.number_to_canonical(p_spouse_income),
1234: spouse_deduction = fnd_number.number_to_canonical(p_spouse_deduction),
1227: sp_miscellaneous_income_calc = fnd_number.number_to_canonical(p_sp_miscellaneous_income_calc),
1228: sp_dividend_income_calc = fnd_number.number_to_canonical(p_sp_dividend_income_calc),
1229: sp_real_estate_income_calc = fnd_number.number_to_canonical(p_sp_real_estate_income_calc),
1230: sp_retirement_income_calc = fnd_number.number_to_canonical(p_sp_retirement_income_calc),
1231: sp_other_income_calc = fnd_number.number_to_canonical(p_sp_other_income_calc),
1232: sp_income_calc = fnd_number.number_to_canonical(p_sp_income_calc),
1233: spouse_income = fnd_number.number_to_canonical(p_spouse_income),
1234: spouse_deduction = fnd_number.number_to_canonical(p_spouse_deduction),
1235: national_pens_ins_prem = fnd_number.number_to_canonical(p_national_pens_ins_prem)
1228: sp_dividend_income_calc = fnd_number.number_to_canonical(p_sp_dividend_income_calc),
1229: sp_real_estate_income_calc = fnd_number.number_to_canonical(p_sp_real_estate_income_calc),
1230: sp_retirement_income_calc = fnd_number.number_to_canonical(p_sp_retirement_income_calc),
1231: sp_other_income_calc = fnd_number.number_to_canonical(p_sp_other_income_calc),
1232: sp_income_calc = fnd_number.number_to_canonical(p_sp_income_calc),
1233: spouse_income = fnd_number.number_to_canonical(p_spouse_income),
1234: spouse_deduction = fnd_number.number_to_canonical(p_spouse_deduction),
1235: national_pens_ins_prem = fnd_number.number_to_canonical(p_national_pens_ins_prem)
1236: where row_id = l_rec.row_id;
1229: sp_real_estate_income_calc = fnd_number.number_to_canonical(p_sp_real_estate_income_calc),
1230: sp_retirement_income_calc = fnd_number.number_to_canonical(p_sp_retirement_income_calc),
1231: sp_other_income_calc = fnd_number.number_to_canonical(p_sp_other_income_calc),
1232: sp_income_calc = fnd_number.number_to_canonical(p_sp_income_calc),
1233: spouse_income = fnd_number.number_to_canonical(p_spouse_income),
1234: spouse_deduction = fnd_number.number_to_canonical(p_spouse_deduction),
1235: national_pens_ins_prem = fnd_number.number_to_canonical(p_national_pens_ins_prem)
1236: where row_id = l_rec.row_id;
1237: --
1230: sp_retirement_income_calc = fnd_number.number_to_canonical(p_sp_retirement_income_calc),
1231: sp_other_income_calc = fnd_number.number_to_canonical(p_sp_other_income_calc),
1232: sp_income_calc = fnd_number.number_to_canonical(p_sp_income_calc),
1233: spouse_income = fnd_number.number_to_canonical(p_spouse_income),
1234: spouse_deduction = fnd_number.number_to_canonical(p_spouse_deduction),
1235: national_pens_ins_prem = fnd_number.number_to_canonical(p_national_pens_ins_prem)
1236: where row_id = l_rec.row_id;
1237: --
1238: if g_debug then
1231: sp_other_income_calc = fnd_number.number_to_canonical(p_sp_other_income_calc),
1232: sp_income_calc = fnd_number.number_to_canonical(p_sp_income_calc),
1233: spouse_income = fnd_number.number_to_canonical(p_spouse_income),
1234: spouse_deduction = fnd_number.number_to_canonical(p_spouse_deduction),
1235: national_pens_ins_prem = fnd_number.number_to_canonical(p_national_pens_ins_prem)
1236: where row_id = l_rec.row_id;
1237: --
1238: if g_debug then
1239: hr_utility.set_location(l_proc,1000);
1302: p_assignment_id,
1303: p_effective_date,
1304: p_action_information_category,
1305: p_status,
1306: fnd_number.number_to_canonical(p_assignment_extra_info_id),
1307: fnd_number.number_to_canonical(p_aei_object_version_number),
1308: p_gen_ins_class,
1309: p_gen_ins_company_code,
1310: p_ins_company_name,
1303: p_effective_date,
1304: p_action_information_category,
1305: p_status,
1306: fnd_number.number_to_canonical(p_assignment_extra_info_id),
1307: fnd_number.number_to_canonical(p_aei_object_version_number),
1308: p_gen_ins_class,
1309: p_gen_ins_company_code,
1310: p_ins_company_name,
1311: p_ins_type,
1312: p_ins_period,
1313: p_contractor_name,
1314: p_beneficiary_name,
1315: p_beneficiary_relship,
1316: fnd_number.number_to_canonical(p_annual_prem));
1317: --
1318: if g_debug then
1319: hr_utility.set_location(l_proc,1000);
1320: end if;
1360: ins_period = p_ins_period,
1361: contractor_name = p_contractor_name,
1362: beneficiary_name = p_beneficiary_name,
1363: beneficiary_relship = p_beneficiary_relship,
1364: annual_prem = fnd_number.number_to_canonical(p_annual_prem)
1365: where row_id = l_rec.row_id;
1366: --
1367: if g_debug then
1368: hr_utility.set_location(l_proc,1000);
1475: p_assignment_id,
1476: p_effective_date,
1477: p_action_information_category,
1478: p_status,
1479: fnd_number.number_to_canonical(p_assignment_extra_info_id),
1480: fnd_number.number_to_canonical(p_aei_object_version_number),
1481: p_pens_ins_class,
1482: p_pens_ins_company_code,
1483: p_ins_company_name,
1476: p_effective_date,
1477: p_action_information_category,
1478: p_status,
1479: fnd_number.number_to_canonical(p_assignment_extra_info_id),
1480: fnd_number.number_to_canonical(p_aei_object_version_number),
1481: p_pens_ins_class,
1482: p_pens_ins_company_code,
1483: p_ins_company_name,
1484: p_ins_type,
1486: p_ins_period,
1487: p_contractor_name,
1488: p_beneficiary_name,
1489: p_beneficiary_relship,
1490: fnd_number.number_to_canonical(p_annual_prem));
1491: --
1492: if g_debug then
1493: hr_utility.set_location(l_proc,1000);
1494: end if;
1536: ins_period = p_ins_period,
1537: contractor_name = p_contractor_name,
1538: beneficiary_name = p_beneficiary_name,
1539: beneficiary_relship = p_beneficiary_relship,
1540: annual_prem = fnd_number.number_to_canonical(p_annual_prem)
1541: where row_id = l_rec.row_id;
1542: --
1543: if g_debug then
1544: hr_utility.set_location(l_proc,1000);
1654: p_assignment_id,
1655: p_effective_date,
1656: p_action_information_category,
1657: p_status,
1658: fnd_number.number_to_canonical(p_assignment_extra_info_id),
1659: fnd_number.number_to_canonical(p_aei_object_version_number),
1660: p_nonlife_ins_class,
1661: p_nonlife_ins_term_type,
1662: p_nonlife_ins_company_code,
1655: p_effective_date,
1656: p_action_information_category,
1657: p_status,
1658: fnd_number.number_to_canonical(p_assignment_extra_info_id),
1659: fnd_number.number_to_canonical(p_aei_object_version_number),
1660: p_nonlife_ins_class,
1661: p_nonlife_ins_term_type,
1662: p_nonlife_ins_company_code,
1663: p_ins_company_name,
1666: p_contractor_name,
1667: p_beneficiary_name,
1668: p_beneficiary_relship,
1669: p_maturity_repayment,
1670: fnd_number.number_to_canonical(p_annual_prem));
1671: --
1672: if g_debug then
1673: hr_utility.set_location(l_proc,1000);
1674: end if;
1717: contractor_name = p_contractor_name,
1718: beneficiary_name = p_beneficiary_name,
1719: beneficiary_relship = p_beneficiary_relship,
1720: maturity_repayment = p_maturity_repayment,
1721: annual_prem = fnd_number.number_to_canonical(p_annual_prem)
1722: where row_id = l_rec.row_id;
1723: --
1724: if g_debug then
1725: hr_utility.set_location(l_proc,1000);
1825: p_ins_type,
1826: p_ins_payee_name,
1827: p_debtor_name,
1828: p_beneficiary_relship,
1829: fnd_number.number_to_canonical(p_annual_prem),
1830: p_national_pens_flag);
1831: --
1832: if g_debug then
1833: hr_utility.set_location(l_proc,1000);
1871: ins_type = p_ins_type,
1872: ins_payee_name = p_ins_payee_name,
1873: debtor_name = p_debtor_name,
1874: beneficiary_relship = p_beneficiary_relship,
1875: annual_prem = fnd_number.number_to_canonical(p_annual_prem),
1876: national_pens_flag = p_national_pens_flag
1877: where row_id = l_rec.row_id;
1878: --
1879: if g_debug then
1970: p_assignment_id,
1971: p_effective_date,
1972: p_action_information_category,
1973: p_status,
1974: fnd_number.number_to_canonical(p_enterprise_contract_prem),
1975: fnd_number.number_to_canonical(p_pension_prem),
1976: fnd_number.number_to_canonical(p_disable_sup_contract_prem));
1977: --
1978: if g_debug then
1971: p_effective_date,
1972: p_action_information_category,
1973: p_status,
1974: fnd_number.number_to_canonical(p_enterprise_contract_prem),
1975: fnd_number.number_to_canonical(p_pension_prem),
1976: fnd_number.number_to_canonical(p_disable_sup_contract_prem));
1977: --
1978: if g_debug then
1979: hr_utility.set_location(l_proc,1000);
1972: p_action_information_category,
1973: p_status,
1974: fnd_number.number_to_canonical(p_enterprise_contract_prem),
1975: fnd_number.number_to_canonical(p_pension_prem),
1976: fnd_number.number_to_canonical(p_disable_sup_contract_prem));
1977: --
1978: if g_debug then
1979: hr_utility.set_location(l_proc,1000);
1980: end if;
2010: --
2011: update pay_jp_isdf_mutual_aid_dml_v
2012: set object_version_number = p_object_version_number,
2013: status = p_status,
2014: enterprise_contract_prem = fnd_number.number_to_canonical(p_enterprise_contract_prem),
2015: pension_prem = fnd_number.number_to_canonical(p_pension_prem),
2016: disable_sup_contract_prem = fnd_number.number_to_canonical(p_disable_sup_contract_prem)
2017: where row_id = l_rec.row_id;
2018: --
2011: update pay_jp_isdf_mutual_aid_dml_v
2012: set object_version_number = p_object_version_number,
2013: status = p_status,
2014: enterprise_contract_prem = fnd_number.number_to_canonical(p_enterprise_contract_prem),
2015: pension_prem = fnd_number.number_to_canonical(p_pension_prem),
2016: disable_sup_contract_prem = fnd_number.number_to_canonical(p_disable_sup_contract_prem)
2017: where row_id = l_rec.row_id;
2018: --
2019: if g_debug then
2012: set object_version_number = p_object_version_number,
2013: status = p_status,
2014: enterprise_contract_prem = fnd_number.number_to_canonical(p_enterprise_contract_prem),
2015: pension_prem = fnd_number.number_to_canonical(p_pension_prem),
2016: disable_sup_contract_prem = fnd_number.number_to_canonical(p_disable_sup_contract_prem)
2017: where row_id = l_rec.row_id;
2018: --
2019: if g_debug then
2020: hr_utility.set_location(l_proc,1000);
2138: --p_last_name,
2139: --p_first_name,
2140: p_postal_code,
2141: p_address,
2142: fnd_number.number_to_canonical(p_emp_income),
2143: p_spouse_type,
2144: p_widow_type,
2145: p_spouse_dct_exclude,
2146: fnd_number.number_to_canonical(p_spouse_income_entry));
2142: fnd_number.number_to_canonical(p_emp_income),
2143: p_spouse_type,
2144: p_widow_type,
2145: p_spouse_dct_exclude,
2146: fnd_number.number_to_canonical(p_spouse_income_entry));
2147: --
2148: if g_debug then
2149: hr_utility.set_location(l_proc,1000);
2150: end if;
2198: --last_name = p_last_name,
2199: --first_name = p_first_name,
2200: postal_code = p_postal_code,
2201: address = p_address,
2202: emp_income = fnd_number.number_to_canonical(p_emp_income),
2203: spouse_type = p_spouse_type,
2204: widow_type = p_widow_type,
2205: spouse_dct_exclude = p_spouse_dct_exclude,
2206: spouse_income_entry = fnd_number.number_to_canonical(p_spouse_income_entry)
2202: emp_income = fnd_number.number_to_canonical(p_emp_income),
2203: spouse_type = p_spouse_type,
2204: widow_type = p_widow_type,
2205: spouse_dct_exclude = p_spouse_dct_exclude,
2206: spouse_income_entry = fnd_number.number_to_canonical(p_spouse_income_entry)
2207: where row_id = l_rec.row_id;
2208: --
2209: if g_debug then
2210: hr_utility.set_location(l_proc,1000);
2328: p_assignment_id,
2329: p_effective_date,
2330: p_action_information_category,
2331: p_status,
2332: fnd_number.number_to_canonical(p_sp_earned_income),
2333: fnd_number.number_to_canonical(p_sp_earned_income_exp),
2334: fnd_number.number_to_canonical(p_sp_business_income),
2335: fnd_number.number_to_canonical(p_sp_business_income_exp),
2336: fnd_number.number_to_canonical(p_sp_miscellaneous_income),
2329: p_effective_date,
2330: p_action_information_category,
2331: p_status,
2332: fnd_number.number_to_canonical(p_sp_earned_income),
2333: fnd_number.number_to_canonical(p_sp_earned_income_exp),
2334: fnd_number.number_to_canonical(p_sp_business_income),
2335: fnd_number.number_to_canonical(p_sp_business_income_exp),
2336: fnd_number.number_to_canonical(p_sp_miscellaneous_income),
2337: fnd_number.number_to_canonical(p_sp_miscellaneous_income_exp),
2330: p_action_information_category,
2331: p_status,
2332: fnd_number.number_to_canonical(p_sp_earned_income),
2333: fnd_number.number_to_canonical(p_sp_earned_income_exp),
2334: fnd_number.number_to_canonical(p_sp_business_income),
2335: fnd_number.number_to_canonical(p_sp_business_income_exp),
2336: fnd_number.number_to_canonical(p_sp_miscellaneous_income),
2337: fnd_number.number_to_canonical(p_sp_miscellaneous_income_exp),
2338: fnd_number.number_to_canonical(p_sp_dividend_income),
2331: p_status,
2332: fnd_number.number_to_canonical(p_sp_earned_income),
2333: fnd_number.number_to_canonical(p_sp_earned_income_exp),
2334: fnd_number.number_to_canonical(p_sp_business_income),
2335: fnd_number.number_to_canonical(p_sp_business_income_exp),
2336: fnd_number.number_to_canonical(p_sp_miscellaneous_income),
2337: fnd_number.number_to_canonical(p_sp_miscellaneous_income_exp),
2338: fnd_number.number_to_canonical(p_sp_dividend_income),
2339: fnd_number.number_to_canonical(p_sp_dividend_income_exp),
2332: fnd_number.number_to_canonical(p_sp_earned_income),
2333: fnd_number.number_to_canonical(p_sp_earned_income_exp),
2334: fnd_number.number_to_canonical(p_sp_business_income),
2335: fnd_number.number_to_canonical(p_sp_business_income_exp),
2336: fnd_number.number_to_canonical(p_sp_miscellaneous_income),
2337: fnd_number.number_to_canonical(p_sp_miscellaneous_income_exp),
2338: fnd_number.number_to_canonical(p_sp_dividend_income),
2339: fnd_number.number_to_canonical(p_sp_dividend_income_exp),
2340: fnd_number.number_to_canonical(p_sp_real_estate_income),
2333: fnd_number.number_to_canonical(p_sp_earned_income_exp),
2334: fnd_number.number_to_canonical(p_sp_business_income),
2335: fnd_number.number_to_canonical(p_sp_business_income_exp),
2336: fnd_number.number_to_canonical(p_sp_miscellaneous_income),
2337: fnd_number.number_to_canonical(p_sp_miscellaneous_income_exp),
2338: fnd_number.number_to_canonical(p_sp_dividend_income),
2339: fnd_number.number_to_canonical(p_sp_dividend_income_exp),
2340: fnd_number.number_to_canonical(p_sp_real_estate_income),
2341: fnd_number.number_to_canonical(p_sp_real_estate_income_exp),
2334: fnd_number.number_to_canonical(p_sp_business_income),
2335: fnd_number.number_to_canonical(p_sp_business_income_exp),
2336: fnd_number.number_to_canonical(p_sp_miscellaneous_income),
2337: fnd_number.number_to_canonical(p_sp_miscellaneous_income_exp),
2338: fnd_number.number_to_canonical(p_sp_dividend_income),
2339: fnd_number.number_to_canonical(p_sp_dividend_income_exp),
2340: fnd_number.number_to_canonical(p_sp_real_estate_income),
2341: fnd_number.number_to_canonical(p_sp_real_estate_income_exp),
2342: fnd_number.number_to_canonical(p_sp_retirement_income),
2335: fnd_number.number_to_canonical(p_sp_business_income_exp),
2336: fnd_number.number_to_canonical(p_sp_miscellaneous_income),
2337: fnd_number.number_to_canonical(p_sp_miscellaneous_income_exp),
2338: fnd_number.number_to_canonical(p_sp_dividend_income),
2339: fnd_number.number_to_canonical(p_sp_dividend_income_exp),
2340: fnd_number.number_to_canonical(p_sp_real_estate_income),
2341: fnd_number.number_to_canonical(p_sp_real_estate_income_exp),
2342: fnd_number.number_to_canonical(p_sp_retirement_income),
2343: fnd_number.number_to_canonical(p_sp_retirement_income_exp),
2336: fnd_number.number_to_canonical(p_sp_miscellaneous_income),
2337: fnd_number.number_to_canonical(p_sp_miscellaneous_income_exp),
2338: fnd_number.number_to_canonical(p_sp_dividend_income),
2339: fnd_number.number_to_canonical(p_sp_dividend_income_exp),
2340: fnd_number.number_to_canonical(p_sp_real_estate_income),
2341: fnd_number.number_to_canonical(p_sp_real_estate_income_exp),
2342: fnd_number.number_to_canonical(p_sp_retirement_income),
2343: fnd_number.number_to_canonical(p_sp_retirement_income_exp),
2344: fnd_number.number_to_canonical(p_sp_other_income),
2337: fnd_number.number_to_canonical(p_sp_miscellaneous_income_exp),
2338: fnd_number.number_to_canonical(p_sp_dividend_income),
2339: fnd_number.number_to_canonical(p_sp_dividend_income_exp),
2340: fnd_number.number_to_canonical(p_sp_real_estate_income),
2341: fnd_number.number_to_canonical(p_sp_real_estate_income_exp),
2342: fnd_number.number_to_canonical(p_sp_retirement_income),
2343: fnd_number.number_to_canonical(p_sp_retirement_income_exp),
2344: fnd_number.number_to_canonical(p_sp_other_income),
2345: fnd_number.number_to_canonical(p_sp_other_income_exp),
2338: fnd_number.number_to_canonical(p_sp_dividend_income),
2339: fnd_number.number_to_canonical(p_sp_dividend_income_exp),
2340: fnd_number.number_to_canonical(p_sp_real_estate_income),
2341: fnd_number.number_to_canonical(p_sp_real_estate_income_exp),
2342: fnd_number.number_to_canonical(p_sp_retirement_income),
2343: fnd_number.number_to_canonical(p_sp_retirement_income_exp),
2344: fnd_number.number_to_canonical(p_sp_other_income),
2345: fnd_number.number_to_canonical(p_sp_other_income_exp),
2346: fnd_number.number_to_canonical(p_sp_other_income_exp_dct),
2339: fnd_number.number_to_canonical(p_sp_dividend_income_exp),
2340: fnd_number.number_to_canonical(p_sp_real_estate_income),
2341: fnd_number.number_to_canonical(p_sp_real_estate_income_exp),
2342: fnd_number.number_to_canonical(p_sp_retirement_income),
2343: fnd_number.number_to_canonical(p_sp_retirement_income_exp),
2344: fnd_number.number_to_canonical(p_sp_other_income),
2345: fnd_number.number_to_canonical(p_sp_other_income_exp),
2346: fnd_number.number_to_canonical(p_sp_other_income_exp_dct),
2347: fnd_number.number_to_canonical(p_sp_other_income_exp_temp),
2340: fnd_number.number_to_canonical(p_sp_real_estate_income),
2341: fnd_number.number_to_canonical(p_sp_real_estate_income_exp),
2342: fnd_number.number_to_canonical(p_sp_retirement_income),
2343: fnd_number.number_to_canonical(p_sp_retirement_income_exp),
2344: fnd_number.number_to_canonical(p_sp_other_income),
2345: fnd_number.number_to_canonical(p_sp_other_income_exp),
2346: fnd_number.number_to_canonical(p_sp_other_income_exp_dct),
2347: fnd_number.number_to_canonical(p_sp_other_income_exp_temp),
2348: fnd_number.number_to_canonical(p_sp_other_income_exp_temp_exp));
2341: fnd_number.number_to_canonical(p_sp_real_estate_income_exp),
2342: fnd_number.number_to_canonical(p_sp_retirement_income),
2343: fnd_number.number_to_canonical(p_sp_retirement_income_exp),
2344: fnd_number.number_to_canonical(p_sp_other_income),
2345: fnd_number.number_to_canonical(p_sp_other_income_exp),
2346: fnd_number.number_to_canonical(p_sp_other_income_exp_dct),
2347: fnd_number.number_to_canonical(p_sp_other_income_exp_temp),
2348: fnd_number.number_to_canonical(p_sp_other_income_exp_temp_exp));
2349: --
2342: fnd_number.number_to_canonical(p_sp_retirement_income),
2343: fnd_number.number_to_canonical(p_sp_retirement_income_exp),
2344: fnd_number.number_to_canonical(p_sp_other_income),
2345: fnd_number.number_to_canonical(p_sp_other_income_exp),
2346: fnd_number.number_to_canonical(p_sp_other_income_exp_dct),
2347: fnd_number.number_to_canonical(p_sp_other_income_exp_temp),
2348: fnd_number.number_to_canonical(p_sp_other_income_exp_temp_exp));
2349: --
2350: if g_debug then
2343: fnd_number.number_to_canonical(p_sp_retirement_income_exp),
2344: fnd_number.number_to_canonical(p_sp_other_income),
2345: fnd_number.number_to_canonical(p_sp_other_income_exp),
2346: fnd_number.number_to_canonical(p_sp_other_income_exp_dct),
2347: fnd_number.number_to_canonical(p_sp_other_income_exp_temp),
2348: fnd_number.number_to_canonical(p_sp_other_income_exp_temp_exp));
2349: --
2350: if g_debug then
2351: hr_utility.set_location(l_proc,1000);
2344: fnd_number.number_to_canonical(p_sp_other_income),
2345: fnd_number.number_to_canonical(p_sp_other_income_exp),
2346: fnd_number.number_to_canonical(p_sp_other_income_exp_dct),
2347: fnd_number.number_to_canonical(p_sp_other_income_exp_temp),
2348: fnd_number.number_to_canonical(p_sp_other_income_exp_temp_exp));
2349: --
2350: if g_debug then
2351: hr_utility.set_location(l_proc,1000);
2352: end if;
2396: --
2397: update pay_jp_isdf_spouse_inc_dml_v
2398: set object_version_number = p_object_version_number,
2399: status = p_status,
2400: sp_earned_income = fnd_number.number_to_canonical(p_sp_earned_income),
2401: sp_earned_income_exp = fnd_number.number_to_canonical(p_sp_earned_income_exp),
2402: sp_business_income = fnd_number.number_to_canonical(p_sp_business_income),
2403: sp_business_income_exp = fnd_number.number_to_canonical(p_sp_business_income_exp),
2404: sp_miscellaneous_income = fnd_number.number_to_canonical(p_sp_miscellaneous_income),
2397: update pay_jp_isdf_spouse_inc_dml_v
2398: set object_version_number = p_object_version_number,
2399: status = p_status,
2400: sp_earned_income = fnd_number.number_to_canonical(p_sp_earned_income),
2401: sp_earned_income_exp = fnd_number.number_to_canonical(p_sp_earned_income_exp),
2402: sp_business_income = fnd_number.number_to_canonical(p_sp_business_income),
2403: sp_business_income_exp = fnd_number.number_to_canonical(p_sp_business_income_exp),
2404: sp_miscellaneous_income = fnd_number.number_to_canonical(p_sp_miscellaneous_income),
2405: sp_miscellaneous_income_exp = fnd_number.number_to_canonical(p_sp_miscellaneous_income_exp),
2398: set object_version_number = p_object_version_number,
2399: status = p_status,
2400: sp_earned_income = fnd_number.number_to_canonical(p_sp_earned_income),
2401: sp_earned_income_exp = fnd_number.number_to_canonical(p_sp_earned_income_exp),
2402: sp_business_income = fnd_number.number_to_canonical(p_sp_business_income),
2403: sp_business_income_exp = fnd_number.number_to_canonical(p_sp_business_income_exp),
2404: sp_miscellaneous_income = fnd_number.number_to_canonical(p_sp_miscellaneous_income),
2405: sp_miscellaneous_income_exp = fnd_number.number_to_canonical(p_sp_miscellaneous_income_exp),
2406: sp_dividend_income = fnd_number.number_to_canonical(p_sp_dividend_income),
2399: status = p_status,
2400: sp_earned_income = fnd_number.number_to_canonical(p_sp_earned_income),
2401: sp_earned_income_exp = fnd_number.number_to_canonical(p_sp_earned_income_exp),
2402: sp_business_income = fnd_number.number_to_canonical(p_sp_business_income),
2403: sp_business_income_exp = fnd_number.number_to_canonical(p_sp_business_income_exp),
2404: sp_miscellaneous_income = fnd_number.number_to_canonical(p_sp_miscellaneous_income),
2405: sp_miscellaneous_income_exp = fnd_number.number_to_canonical(p_sp_miscellaneous_income_exp),
2406: sp_dividend_income = fnd_number.number_to_canonical(p_sp_dividend_income),
2407: sp_dividend_income_exp = fnd_number.number_to_canonical(p_sp_dividend_income_exp),
2400: sp_earned_income = fnd_number.number_to_canonical(p_sp_earned_income),
2401: sp_earned_income_exp = fnd_number.number_to_canonical(p_sp_earned_income_exp),
2402: sp_business_income = fnd_number.number_to_canonical(p_sp_business_income),
2403: sp_business_income_exp = fnd_number.number_to_canonical(p_sp_business_income_exp),
2404: sp_miscellaneous_income = fnd_number.number_to_canonical(p_sp_miscellaneous_income),
2405: sp_miscellaneous_income_exp = fnd_number.number_to_canonical(p_sp_miscellaneous_income_exp),
2406: sp_dividend_income = fnd_number.number_to_canonical(p_sp_dividend_income),
2407: sp_dividend_income_exp = fnd_number.number_to_canonical(p_sp_dividend_income_exp),
2408: sp_real_estate_income = fnd_number.number_to_canonical(p_sp_real_estate_income),
2401: sp_earned_income_exp = fnd_number.number_to_canonical(p_sp_earned_income_exp),
2402: sp_business_income = fnd_number.number_to_canonical(p_sp_business_income),
2403: sp_business_income_exp = fnd_number.number_to_canonical(p_sp_business_income_exp),
2404: sp_miscellaneous_income = fnd_number.number_to_canonical(p_sp_miscellaneous_income),
2405: sp_miscellaneous_income_exp = fnd_number.number_to_canonical(p_sp_miscellaneous_income_exp),
2406: sp_dividend_income = fnd_number.number_to_canonical(p_sp_dividend_income),
2407: sp_dividend_income_exp = fnd_number.number_to_canonical(p_sp_dividend_income_exp),
2408: sp_real_estate_income = fnd_number.number_to_canonical(p_sp_real_estate_income),
2409: sp_real_estate_income_exp = fnd_number.number_to_canonical(p_sp_real_estate_income_exp),
2402: sp_business_income = fnd_number.number_to_canonical(p_sp_business_income),
2403: sp_business_income_exp = fnd_number.number_to_canonical(p_sp_business_income_exp),
2404: sp_miscellaneous_income = fnd_number.number_to_canonical(p_sp_miscellaneous_income),
2405: sp_miscellaneous_income_exp = fnd_number.number_to_canonical(p_sp_miscellaneous_income_exp),
2406: sp_dividend_income = fnd_number.number_to_canonical(p_sp_dividend_income),
2407: sp_dividend_income_exp = fnd_number.number_to_canonical(p_sp_dividend_income_exp),
2408: sp_real_estate_income = fnd_number.number_to_canonical(p_sp_real_estate_income),
2409: sp_real_estate_income_exp = fnd_number.number_to_canonical(p_sp_real_estate_income_exp),
2410: sp_retirement_income = fnd_number.number_to_canonical(p_sp_retirement_income),
2403: sp_business_income_exp = fnd_number.number_to_canonical(p_sp_business_income_exp),
2404: sp_miscellaneous_income = fnd_number.number_to_canonical(p_sp_miscellaneous_income),
2405: sp_miscellaneous_income_exp = fnd_number.number_to_canonical(p_sp_miscellaneous_income_exp),
2406: sp_dividend_income = fnd_number.number_to_canonical(p_sp_dividend_income),
2407: sp_dividend_income_exp = fnd_number.number_to_canonical(p_sp_dividend_income_exp),
2408: sp_real_estate_income = fnd_number.number_to_canonical(p_sp_real_estate_income),
2409: sp_real_estate_income_exp = fnd_number.number_to_canonical(p_sp_real_estate_income_exp),
2410: sp_retirement_income = fnd_number.number_to_canonical(p_sp_retirement_income),
2411: sp_retirement_income_exp = fnd_number.number_to_canonical(p_sp_retirement_income_exp),
2404: sp_miscellaneous_income = fnd_number.number_to_canonical(p_sp_miscellaneous_income),
2405: sp_miscellaneous_income_exp = fnd_number.number_to_canonical(p_sp_miscellaneous_income_exp),
2406: sp_dividend_income = fnd_number.number_to_canonical(p_sp_dividend_income),
2407: sp_dividend_income_exp = fnd_number.number_to_canonical(p_sp_dividend_income_exp),
2408: sp_real_estate_income = fnd_number.number_to_canonical(p_sp_real_estate_income),
2409: sp_real_estate_income_exp = fnd_number.number_to_canonical(p_sp_real_estate_income_exp),
2410: sp_retirement_income = fnd_number.number_to_canonical(p_sp_retirement_income),
2411: sp_retirement_income_exp = fnd_number.number_to_canonical(p_sp_retirement_income_exp),
2412: sp_other_income = fnd_number.number_to_canonical(p_sp_other_income),
2405: sp_miscellaneous_income_exp = fnd_number.number_to_canonical(p_sp_miscellaneous_income_exp),
2406: sp_dividend_income = fnd_number.number_to_canonical(p_sp_dividend_income),
2407: sp_dividend_income_exp = fnd_number.number_to_canonical(p_sp_dividend_income_exp),
2408: sp_real_estate_income = fnd_number.number_to_canonical(p_sp_real_estate_income),
2409: sp_real_estate_income_exp = fnd_number.number_to_canonical(p_sp_real_estate_income_exp),
2410: sp_retirement_income = fnd_number.number_to_canonical(p_sp_retirement_income),
2411: sp_retirement_income_exp = fnd_number.number_to_canonical(p_sp_retirement_income_exp),
2412: sp_other_income = fnd_number.number_to_canonical(p_sp_other_income),
2413: sp_other_income_exp = fnd_number.number_to_canonical(p_sp_other_income_exp),
2406: sp_dividend_income = fnd_number.number_to_canonical(p_sp_dividend_income),
2407: sp_dividend_income_exp = fnd_number.number_to_canonical(p_sp_dividend_income_exp),
2408: sp_real_estate_income = fnd_number.number_to_canonical(p_sp_real_estate_income),
2409: sp_real_estate_income_exp = fnd_number.number_to_canonical(p_sp_real_estate_income_exp),
2410: sp_retirement_income = fnd_number.number_to_canonical(p_sp_retirement_income),
2411: sp_retirement_income_exp = fnd_number.number_to_canonical(p_sp_retirement_income_exp),
2412: sp_other_income = fnd_number.number_to_canonical(p_sp_other_income),
2413: sp_other_income_exp = fnd_number.number_to_canonical(p_sp_other_income_exp),
2414: sp_other_income_exp_dct = fnd_number.number_to_canonical(p_sp_other_income_exp_dct),
2407: sp_dividend_income_exp = fnd_number.number_to_canonical(p_sp_dividend_income_exp),
2408: sp_real_estate_income = fnd_number.number_to_canonical(p_sp_real_estate_income),
2409: sp_real_estate_income_exp = fnd_number.number_to_canonical(p_sp_real_estate_income_exp),
2410: sp_retirement_income = fnd_number.number_to_canonical(p_sp_retirement_income),
2411: sp_retirement_income_exp = fnd_number.number_to_canonical(p_sp_retirement_income_exp),
2412: sp_other_income = fnd_number.number_to_canonical(p_sp_other_income),
2413: sp_other_income_exp = fnd_number.number_to_canonical(p_sp_other_income_exp),
2414: sp_other_income_exp_dct = fnd_number.number_to_canonical(p_sp_other_income_exp_dct),
2415: sp_other_income_exp_temp = fnd_number.number_to_canonical(p_sp_other_income_exp_temp),
2408: sp_real_estate_income = fnd_number.number_to_canonical(p_sp_real_estate_income),
2409: sp_real_estate_income_exp = fnd_number.number_to_canonical(p_sp_real_estate_income_exp),
2410: sp_retirement_income = fnd_number.number_to_canonical(p_sp_retirement_income),
2411: sp_retirement_income_exp = fnd_number.number_to_canonical(p_sp_retirement_income_exp),
2412: sp_other_income = fnd_number.number_to_canonical(p_sp_other_income),
2413: sp_other_income_exp = fnd_number.number_to_canonical(p_sp_other_income_exp),
2414: sp_other_income_exp_dct = fnd_number.number_to_canonical(p_sp_other_income_exp_dct),
2415: sp_other_income_exp_temp = fnd_number.number_to_canonical(p_sp_other_income_exp_temp),
2416: sp_other_income_exp_temp_exp = fnd_number.number_to_canonical(p_sp_other_income_exp_temp_exp)
2409: sp_real_estate_income_exp = fnd_number.number_to_canonical(p_sp_real_estate_income_exp),
2410: sp_retirement_income = fnd_number.number_to_canonical(p_sp_retirement_income),
2411: sp_retirement_income_exp = fnd_number.number_to_canonical(p_sp_retirement_income_exp),
2412: sp_other_income = fnd_number.number_to_canonical(p_sp_other_income),
2413: sp_other_income_exp = fnd_number.number_to_canonical(p_sp_other_income_exp),
2414: sp_other_income_exp_dct = fnd_number.number_to_canonical(p_sp_other_income_exp_dct),
2415: sp_other_income_exp_temp = fnd_number.number_to_canonical(p_sp_other_income_exp_temp),
2416: sp_other_income_exp_temp_exp = fnd_number.number_to_canonical(p_sp_other_income_exp_temp_exp)
2417: where row_id = l_rec.row_id;
2410: sp_retirement_income = fnd_number.number_to_canonical(p_sp_retirement_income),
2411: sp_retirement_income_exp = fnd_number.number_to_canonical(p_sp_retirement_income_exp),
2412: sp_other_income = fnd_number.number_to_canonical(p_sp_other_income),
2413: sp_other_income_exp = fnd_number.number_to_canonical(p_sp_other_income_exp),
2414: sp_other_income_exp_dct = fnd_number.number_to_canonical(p_sp_other_income_exp_dct),
2415: sp_other_income_exp_temp = fnd_number.number_to_canonical(p_sp_other_income_exp_temp),
2416: sp_other_income_exp_temp_exp = fnd_number.number_to_canonical(p_sp_other_income_exp_temp_exp)
2417: where row_id = l_rec.row_id;
2418: --
2411: sp_retirement_income_exp = fnd_number.number_to_canonical(p_sp_retirement_income_exp),
2412: sp_other_income = fnd_number.number_to_canonical(p_sp_other_income),
2413: sp_other_income_exp = fnd_number.number_to_canonical(p_sp_other_income_exp),
2414: sp_other_income_exp_dct = fnd_number.number_to_canonical(p_sp_other_income_exp_dct),
2415: sp_other_income_exp_temp = fnd_number.number_to_canonical(p_sp_other_income_exp_temp),
2416: sp_other_income_exp_temp_exp = fnd_number.number_to_canonical(p_sp_other_income_exp_temp_exp)
2417: where row_id = l_rec.row_id;
2418: --
2419: if g_debug then
2412: sp_other_income = fnd_number.number_to_canonical(p_sp_other_income),
2413: sp_other_income_exp = fnd_number.number_to_canonical(p_sp_other_income_exp),
2414: sp_other_income_exp_dct = fnd_number.number_to_canonical(p_sp_other_income_exp_dct),
2415: sp_other_income_exp_temp = fnd_number.number_to_canonical(p_sp_other_income_exp_temp),
2416: sp_other_income_exp_temp_exp = fnd_number.number_to_canonical(p_sp_other_income_exp_temp_exp)
2417: where row_id = l_rec.row_id;
2418: --
2419: if g_debug then
2420: hr_utility.set_location(l_proc,1000);