[Home] [Help]
641: p_payroll_action_id,
642: p_action_context_type,
643: p_effective_date,
644: p_action_information_category,
645: fnd_number.number_to_canonical(p_payroll_id),
646: fnd_number.number_to_canonical(p_organization_id),
647: fnd_number.number_to_canonical(p_assignment_set_id),
648: p_submission_period_status,
649: fnd_date.date_to_canonical(p_submission_start_date),
642: p_action_context_type,
643: p_effective_date,
644: p_action_information_category,
645: fnd_number.number_to_canonical(p_payroll_id),
646: fnd_number.number_to_canonical(p_organization_id),
647: fnd_number.number_to_canonical(p_assignment_set_id),
648: p_submission_period_status,
649: fnd_date.date_to_canonical(p_submission_start_date),
650: fnd_date.date_to_canonical(p_submission_end_date),
643: p_effective_date,
644: p_action_information_category,
645: fnd_number.number_to_canonical(p_payroll_id),
646: fnd_number.number_to_canonical(p_organization_id),
647: fnd_number.number_to_canonical(p_assignment_set_id),
648: p_submission_period_status,
649: fnd_date.date_to_canonical(p_submission_start_date),
650: fnd_date.date_to_canonical(p_submission_end_date),
651: p_tax_office_name,
760: p_action_information_category,
761: p_tax_type,
762: p_transaction_status,
763: fnd_date.date_to_canonical(p_finalized_date),
764: fnd_number.number_to_canonical(p_finalized_by),
765: p_user_comments,
766: p_admin_comments,
767: p_transfer_status,
768: fnd_date.date_to_canonical(p_transfer_date),
808: update pay_jp_isdf_assact_dml_v
809: set object_version_number = p_object_version_number,
810: transaction_status = p_transaction_status,
811: finalized_date = fnd_date.date_to_canonical(p_finalized_date),
812: finalized_by = fnd_number.number_to_canonical(p_finalized_by),
813: user_comments = p_user_comments,
814: admin_comments = p_admin_comments,
815: transfer_status = p_transfer_status,
816: transfer_date = fnd_date.date_to_canonical(p_transfer_date),
1019: p_effective_date,
1020: p_action_information_category,
1021: p_status,
1022: p_ins_datetrack_update_mode,
1023: fnd_number.number_to_canonical(p_ins_element_entry_id),
1024: fnd_number.number_to_canonical(p_ins_ee_object_version_number),
1025: fnd_number.number_to_canonical(p_life_gen_ins_prem),
1026: fnd_number.number_to_canonical(p_life_gen_ins_prem_o),
1027: fnd_number.number_to_canonical(p_life_pens_ins_prem),
1020: p_action_information_category,
1021: p_status,
1022: p_ins_datetrack_update_mode,
1023: fnd_number.number_to_canonical(p_ins_element_entry_id),
1024: fnd_number.number_to_canonical(p_ins_ee_object_version_number),
1025: fnd_number.number_to_canonical(p_life_gen_ins_prem),
1026: fnd_number.number_to_canonical(p_life_gen_ins_prem_o),
1027: fnd_number.number_to_canonical(p_life_pens_ins_prem),
1028: fnd_number.number_to_canonical(p_life_pens_ins_prem_o),
1021: p_status,
1022: p_ins_datetrack_update_mode,
1023: fnd_number.number_to_canonical(p_ins_element_entry_id),
1024: fnd_number.number_to_canonical(p_ins_ee_object_version_number),
1025: fnd_number.number_to_canonical(p_life_gen_ins_prem),
1026: fnd_number.number_to_canonical(p_life_gen_ins_prem_o),
1027: fnd_number.number_to_canonical(p_life_pens_ins_prem),
1028: fnd_number.number_to_canonical(p_life_pens_ins_prem_o),
1029: fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
1022: p_ins_datetrack_update_mode,
1023: fnd_number.number_to_canonical(p_ins_element_entry_id),
1024: fnd_number.number_to_canonical(p_ins_ee_object_version_number),
1025: fnd_number.number_to_canonical(p_life_gen_ins_prem),
1026: fnd_number.number_to_canonical(p_life_gen_ins_prem_o),
1027: fnd_number.number_to_canonical(p_life_pens_ins_prem),
1028: fnd_number.number_to_canonical(p_life_pens_ins_prem_o),
1029: fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
1030: fnd_number.number_to_canonical(p_nonlife_long_ins_prem_o),
1023: fnd_number.number_to_canonical(p_ins_element_entry_id),
1024: fnd_number.number_to_canonical(p_ins_ee_object_version_number),
1025: fnd_number.number_to_canonical(p_life_gen_ins_prem),
1026: fnd_number.number_to_canonical(p_life_gen_ins_prem_o),
1027: fnd_number.number_to_canonical(p_life_pens_ins_prem),
1028: fnd_number.number_to_canonical(p_life_pens_ins_prem_o),
1029: fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
1030: fnd_number.number_to_canonical(p_nonlife_long_ins_prem_o),
1031: fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
1024: fnd_number.number_to_canonical(p_ins_ee_object_version_number),
1025: fnd_number.number_to_canonical(p_life_gen_ins_prem),
1026: fnd_number.number_to_canonical(p_life_gen_ins_prem_o),
1027: fnd_number.number_to_canonical(p_life_pens_ins_prem),
1028: fnd_number.number_to_canonical(p_life_pens_ins_prem_o),
1029: fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
1030: fnd_number.number_to_canonical(p_nonlife_long_ins_prem_o),
1031: fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
1032: fnd_number.number_to_canonical(p_nonlife_short_ins_prem_o),
1025: fnd_number.number_to_canonical(p_life_gen_ins_prem),
1026: fnd_number.number_to_canonical(p_life_gen_ins_prem_o),
1027: fnd_number.number_to_canonical(p_life_pens_ins_prem),
1028: fnd_number.number_to_canonical(p_life_pens_ins_prem_o),
1029: fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
1030: fnd_number.number_to_canonical(p_nonlife_long_ins_prem_o),
1031: fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
1032: fnd_number.number_to_canonical(p_nonlife_short_ins_prem_o),
1033: fnd_number.number_to_canonical(p_earthquake_ins_prem),
1026: fnd_number.number_to_canonical(p_life_gen_ins_prem_o),
1027: fnd_number.number_to_canonical(p_life_pens_ins_prem),
1028: fnd_number.number_to_canonical(p_life_pens_ins_prem_o),
1029: fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
1030: fnd_number.number_to_canonical(p_nonlife_long_ins_prem_o),
1031: fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
1032: fnd_number.number_to_canonical(p_nonlife_short_ins_prem_o),
1033: fnd_number.number_to_canonical(p_earthquake_ins_prem),
1034: fnd_number.number_to_canonical(p_earthquake_ins_prem_o),
1027: fnd_number.number_to_canonical(p_life_pens_ins_prem),
1028: fnd_number.number_to_canonical(p_life_pens_ins_prem_o),
1029: fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
1030: fnd_number.number_to_canonical(p_nonlife_long_ins_prem_o),
1031: fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
1032: fnd_number.number_to_canonical(p_nonlife_short_ins_prem_o),
1033: fnd_number.number_to_canonical(p_earthquake_ins_prem),
1034: fnd_number.number_to_canonical(p_earthquake_ins_prem_o),
1035: p_is_datetrack_update_mode,
1028: fnd_number.number_to_canonical(p_life_pens_ins_prem_o),
1029: fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
1030: fnd_number.number_to_canonical(p_nonlife_long_ins_prem_o),
1031: fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
1032: fnd_number.number_to_canonical(p_nonlife_short_ins_prem_o),
1033: fnd_number.number_to_canonical(p_earthquake_ins_prem),
1034: fnd_number.number_to_canonical(p_earthquake_ins_prem_o),
1035: p_is_datetrack_update_mode,
1036: fnd_number.number_to_canonical(p_is_element_entry_id),
1029: fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
1030: fnd_number.number_to_canonical(p_nonlife_long_ins_prem_o),
1031: fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
1032: fnd_number.number_to_canonical(p_nonlife_short_ins_prem_o),
1033: fnd_number.number_to_canonical(p_earthquake_ins_prem),
1034: fnd_number.number_to_canonical(p_earthquake_ins_prem_o),
1035: p_is_datetrack_update_mode,
1036: fnd_number.number_to_canonical(p_is_element_entry_id),
1037: fnd_number.number_to_canonical(p_is_ee_object_version_number),
1030: fnd_number.number_to_canonical(p_nonlife_long_ins_prem_o),
1031: fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
1032: fnd_number.number_to_canonical(p_nonlife_short_ins_prem_o),
1033: fnd_number.number_to_canonical(p_earthquake_ins_prem),
1034: fnd_number.number_to_canonical(p_earthquake_ins_prem_o),
1035: p_is_datetrack_update_mode,
1036: fnd_number.number_to_canonical(p_is_element_entry_id),
1037: fnd_number.number_to_canonical(p_is_ee_object_version_number),
1038: fnd_number.number_to_canonical(p_social_ins_prem),
1032: fnd_number.number_to_canonical(p_nonlife_short_ins_prem_o),
1033: fnd_number.number_to_canonical(p_earthquake_ins_prem),
1034: fnd_number.number_to_canonical(p_earthquake_ins_prem_o),
1035: p_is_datetrack_update_mode,
1036: fnd_number.number_to_canonical(p_is_element_entry_id),
1037: fnd_number.number_to_canonical(p_is_ee_object_version_number),
1038: fnd_number.number_to_canonical(p_social_ins_prem),
1039: fnd_number.number_to_canonical(p_social_ins_prem_o),
1040: fnd_number.number_to_canonical(p_mutual_aid_prem),
1033: fnd_number.number_to_canonical(p_earthquake_ins_prem),
1034: fnd_number.number_to_canonical(p_earthquake_ins_prem_o),
1035: p_is_datetrack_update_mode,
1036: fnd_number.number_to_canonical(p_is_element_entry_id),
1037: fnd_number.number_to_canonical(p_is_ee_object_version_number),
1038: fnd_number.number_to_canonical(p_social_ins_prem),
1039: fnd_number.number_to_canonical(p_social_ins_prem_o),
1040: fnd_number.number_to_canonical(p_mutual_aid_prem),
1041: fnd_number.number_to_canonical(p_mutual_aid_prem_o),
1034: fnd_number.number_to_canonical(p_earthquake_ins_prem_o),
1035: p_is_datetrack_update_mode,
1036: fnd_number.number_to_canonical(p_is_element_entry_id),
1037: fnd_number.number_to_canonical(p_is_ee_object_version_number),
1038: fnd_number.number_to_canonical(p_social_ins_prem),
1039: fnd_number.number_to_canonical(p_social_ins_prem_o),
1040: fnd_number.number_to_canonical(p_mutual_aid_prem),
1041: fnd_number.number_to_canonical(p_mutual_aid_prem_o),
1042: fnd_number.number_to_canonical(p_spouse_income),
1035: p_is_datetrack_update_mode,
1036: fnd_number.number_to_canonical(p_is_element_entry_id),
1037: fnd_number.number_to_canonical(p_is_ee_object_version_number),
1038: fnd_number.number_to_canonical(p_social_ins_prem),
1039: fnd_number.number_to_canonical(p_social_ins_prem_o),
1040: fnd_number.number_to_canonical(p_mutual_aid_prem),
1041: fnd_number.number_to_canonical(p_mutual_aid_prem_o),
1042: fnd_number.number_to_canonical(p_spouse_income),
1043: fnd_number.number_to_canonical(p_spouse_income_o),
1036: fnd_number.number_to_canonical(p_is_element_entry_id),
1037: fnd_number.number_to_canonical(p_is_ee_object_version_number),
1038: fnd_number.number_to_canonical(p_social_ins_prem),
1039: fnd_number.number_to_canonical(p_social_ins_prem_o),
1040: fnd_number.number_to_canonical(p_mutual_aid_prem),
1041: fnd_number.number_to_canonical(p_mutual_aid_prem_o),
1042: fnd_number.number_to_canonical(p_spouse_income),
1043: fnd_number.number_to_canonical(p_spouse_income_o),
1044: fnd_number.number_to_canonical(p_national_pens_ins_prem),
1037: fnd_number.number_to_canonical(p_is_ee_object_version_number),
1038: fnd_number.number_to_canonical(p_social_ins_prem),
1039: fnd_number.number_to_canonical(p_social_ins_prem_o),
1040: fnd_number.number_to_canonical(p_mutual_aid_prem),
1041: fnd_number.number_to_canonical(p_mutual_aid_prem_o),
1042: fnd_number.number_to_canonical(p_spouse_income),
1043: fnd_number.number_to_canonical(p_spouse_income_o),
1044: fnd_number.number_to_canonical(p_national_pens_ins_prem),
1045: fnd_number.number_to_canonical(p_national_pens_ins_prem_o),
1038: fnd_number.number_to_canonical(p_social_ins_prem),
1039: fnd_number.number_to_canonical(p_social_ins_prem_o),
1040: fnd_number.number_to_canonical(p_mutual_aid_prem),
1041: fnd_number.number_to_canonical(p_mutual_aid_prem_o),
1042: fnd_number.number_to_canonical(p_spouse_income),
1043: fnd_number.number_to_canonical(p_spouse_income_o),
1044: fnd_number.number_to_canonical(p_national_pens_ins_prem),
1045: fnd_number.number_to_canonical(p_national_pens_ins_prem_o),
1046: fnd_number.number_to_canonical(p_life_gen_ins_prem_new),
1039: fnd_number.number_to_canonical(p_social_ins_prem_o),
1040: fnd_number.number_to_canonical(p_mutual_aid_prem),
1041: fnd_number.number_to_canonical(p_mutual_aid_prem_o),
1042: fnd_number.number_to_canonical(p_spouse_income),
1043: fnd_number.number_to_canonical(p_spouse_income_o),
1044: fnd_number.number_to_canonical(p_national_pens_ins_prem),
1045: fnd_number.number_to_canonical(p_national_pens_ins_prem_o),
1046: fnd_number.number_to_canonical(p_life_gen_ins_prem_new),
1047: fnd_number.number_to_canonical(p_life_pens_ins_prem_new),
1040: fnd_number.number_to_canonical(p_mutual_aid_prem),
1041: fnd_number.number_to_canonical(p_mutual_aid_prem_o),
1042: fnd_number.number_to_canonical(p_spouse_income),
1043: fnd_number.number_to_canonical(p_spouse_income_o),
1044: fnd_number.number_to_canonical(p_national_pens_ins_prem),
1045: fnd_number.number_to_canonical(p_national_pens_ins_prem_o),
1046: fnd_number.number_to_canonical(p_life_gen_ins_prem_new),
1047: fnd_number.number_to_canonical(p_life_pens_ins_prem_new),
1048: fnd_number.number_to_canonical(p_care_med_ins_prem_new));
1041: fnd_number.number_to_canonical(p_mutual_aid_prem_o),
1042: fnd_number.number_to_canonical(p_spouse_income),
1043: fnd_number.number_to_canonical(p_spouse_income_o),
1044: fnd_number.number_to_canonical(p_national_pens_ins_prem),
1045: fnd_number.number_to_canonical(p_national_pens_ins_prem_o),
1046: fnd_number.number_to_canonical(p_life_gen_ins_prem_new),
1047: fnd_number.number_to_canonical(p_life_pens_ins_prem_new),
1048: fnd_number.number_to_canonical(p_care_med_ins_prem_new));
1049: --
1042: fnd_number.number_to_canonical(p_spouse_income),
1043: fnd_number.number_to_canonical(p_spouse_income_o),
1044: fnd_number.number_to_canonical(p_national_pens_ins_prem),
1045: fnd_number.number_to_canonical(p_national_pens_ins_prem_o),
1046: fnd_number.number_to_canonical(p_life_gen_ins_prem_new),
1047: fnd_number.number_to_canonical(p_life_pens_ins_prem_new),
1048: fnd_number.number_to_canonical(p_care_med_ins_prem_new));
1049: --
1050: if g_debug then
1043: fnd_number.number_to_canonical(p_spouse_income_o),
1044: fnd_number.number_to_canonical(p_national_pens_ins_prem),
1045: fnd_number.number_to_canonical(p_national_pens_ins_prem_o),
1046: fnd_number.number_to_canonical(p_life_gen_ins_prem_new),
1047: fnd_number.number_to_canonical(p_life_pens_ins_prem_new),
1048: fnd_number.number_to_canonical(p_care_med_ins_prem_new));
1049: --
1050: if g_debug then
1051: hr_utility.set_location(l_proc,1000);
1044: fnd_number.number_to_canonical(p_national_pens_ins_prem),
1045: fnd_number.number_to_canonical(p_national_pens_ins_prem_o),
1046: fnd_number.number_to_canonical(p_life_gen_ins_prem_new),
1047: fnd_number.number_to_canonical(p_life_pens_ins_prem_new),
1048: fnd_number.number_to_canonical(p_care_med_ins_prem_new));
1049: --
1050: if g_debug then
1051: hr_utility.set_location(l_proc,1000);
1052: end if;
1100: --
1101: update pay_jp_isdf_entry_dml_v
1102: set object_version_number = p_object_version_number,
1103: status = p_status,
1104: life_gen_ins_prem = fnd_number.number_to_canonical(p_life_gen_ins_prem),
1105: life_gen_ins_prem_o = fnd_number.number_to_canonical(p_life_gen_ins_prem_o),
1106: life_pens_ins_prem = fnd_number.number_to_canonical(p_life_pens_ins_prem),
1107: life_pens_ins_prem_o = fnd_number.number_to_canonical(p_life_pens_ins_prem_o),
1108: nonlife_long_ins_prem = fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
1101: update pay_jp_isdf_entry_dml_v
1102: set object_version_number = p_object_version_number,
1103: status = p_status,
1104: life_gen_ins_prem = fnd_number.number_to_canonical(p_life_gen_ins_prem),
1105: life_gen_ins_prem_o = fnd_number.number_to_canonical(p_life_gen_ins_prem_o),
1106: life_pens_ins_prem = fnd_number.number_to_canonical(p_life_pens_ins_prem),
1107: life_pens_ins_prem_o = fnd_number.number_to_canonical(p_life_pens_ins_prem_o),
1108: nonlife_long_ins_prem = fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
1109: nonlife_long_ins_prem_o = fnd_number.number_to_canonical(p_nonlife_long_ins_prem_o),
1102: set object_version_number = p_object_version_number,
1103: status = p_status,
1104: life_gen_ins_prem = fnd_number.number_to_canonical(p_life_gen_ins_prem),
1105: life_gen_ins_prem_o = fnd_number.number_to_canonical(p_life_gen_ins_prem_o),
1106: life_pens_ins_prem = fnd_number.number_to_canonical(p_life_pens_ins_prem),
1107: life_pens_ins_prem_o = fnd_number.number_to_canonical(p_life_pens_ins_prem_o),
1108: nonlife_long_ins_prem = fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
1109: nonlife_long_ins_prem_o = fnd_number.number_to_canonical(p_nonlife_long_ins_prem_o),
1110: nonlife_short_ins_prem = fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
1103: status = p_status,
1104: life_gen_ins_prem = fnd_number.number_to_canonical(p_life_gen_ins_prem),
1105: life_gen_ins_prem_o = fnd_number.number_to_canonical(p_life_gen_ins_prem_o),
1106: life_pens_ins_prem = fnd_number.number_to_canonical(p_life_pens_ins_prem),
1107: life_pens_ins_prem_o = fnd_number.number_to_canonical(p_life_pens_ins_prem_o),
1108: nonlife_long_ins_prem = fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
1109: nonlife_long_ins_prem_o = fnd_number.number_to_canonical(p_nonlife_long_ins_prem_o),
1110: nonlife_short_ins_prem = fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
1111: nonlife_short_ins_prem_o = fnd_number.number_to_canonical(p_nonlife_short_ins_prem_o),
1104: life_gen_ins_prem = fnd_number.number_to_canonical(p_life_gen_ins_prem),
1105: life_gen_ins_prem_o = fnd_number.number_to_canonical(p_life_gen_ins_prem_o),
1106: life_pens_ins_prem = fnd_number.number_to_canonical(p_life_pens_ins_prem),
1107: life_pens_ins_prem_o = fnd_number.number_to_canonical(p_life_pens_ins_prem_o),
1108: nonlife_long_ins_prem = fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
1109: nonlife_long_ins_prem_o = fnd_number.number_to_canonical(p_nonlife_long_ins_prem_o),
1110: nonlife_short_ins_prem = fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
1111: nonlife_short_ins_prem_o = fnd_number.number_to_canonical(p_nonlife_short_ins_prem_o),
1112: earthquake_ins_prem = fnd_number.number_to_canonical(p_earthquake_ins_prem),
1105: life_gen_ins_prem_o = fnd_number.number_to_canonical(p_life_gen_ins_prem_o),
1106: life_pens_ins_prem = fnd_number.number_to_canonical(p_life_pens_ins_prem),
1107: life_pens_ins_prem_o = fnd_number.number_to_canonical(p_life_pens_ins_prem_o),
1108: nonlife_long_ins_prem = fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
1109: nonlife_long_ins_prem_o = fnd_number.number_to_canonical(p_nonlife_long_ins_prem_o),
1110: nonlife_short_ins_prem = fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
1111: nonlife_short_ins_prem_o = fnd_number.number_to_canonical(p_nonlife_short_ins_prem_o),
1112: earthquake_ins_prem = fnd_number.number_to_canonical(p_earthquake_ins_prem),
1113: earthquake_ins_prem_o = fnd_number.number_to_canonical(p_earthquake_ins_prem_o),
1106: life_pens_ins_prem = fnd_number.number_to_canonical(p_life_pens_ins_prem),
1107: life_pens_ins_prem_o = fnd_number.number_to_canonical(p_life_pens_ins_prem_o),
1108: nonlife_long_ins_prem = fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
1109: nonlife_long_ins_prem_o = fnd_number.number_to_canonical(p_nonlife_long_ins_prem_o),
1110: nonlife_short_ins_prem = fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
1111: nonlife_short_ins_prem_o = fnd_number.number_to_canonical(p_nonlife_short_ins_prem_o),
1112: earthquake_ins_prem = fnd_number.number_to_canonical(p_earthquake_ins_prem),
1113: earthquake_ins_prem_o = fnd_number.number_to_canonical(p_earthquake_ins_prem_o),
1114: social_ins_prem = fnd_number.number_to_canonical(p_social_ins_prem),
1107: life_pens_ins_prem_o = fnd_number.number_to_canonical(p_life_pens_ins_prem_o),
1108: nonlife_long_ins_prem = fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
1109: nonlife_long_ins_prem_o = fnd_number.number_to_canonical(p_nonlife_long_ins_prem_o),
1110: nonlife_short_ins_prem = fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
1111: nonlife_short_ins_prem_o = fnd_number.number_to_canonical(p_nonlife_short_ins_prem_o),
1112: earthquake_ins_prem = fnd_number.number_to_canonical(p_earthquake_ins_prem),
1113: earthquake_ins_prem_o = fnd_number.number_to_canonical(p_earthquake_ins_prem_o),
1114: social_ins_prem = fnd_number.number_to_canonical(p_social_ins_prem),
1115: social_ins_prem_o = fnd_number.number_to_canonical(p_social_ins_prem_o),
1108: nonlife_long_ins_prem = fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
1109: nonlife_long_ins_prem_o = fnd_number.number_to_canonical(p_nonlife_long_ins_prem_o),
1110: nonlife_short_ins_prem = fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
1111: nonlife_short_ins_prem_o = fnd_number.number_to_canonical(p_nonlife_short_ins_prem_o),
1112: earthquake_ins_prem = fnd_number.number_to_canonical(p_earthquake_ins_prem),
1113: earthquake_ins_prem_o = fnd_number.number_to_canonical(p_earthquake_ins_prem_o),
1114: social_ins_prem = fnd_number.number_to_canonical(p_social_ins_prem),
1115: social_ins_prem_o = fnd_number.number_to_canonical(p_social_ins_prem_o),
1116: mutual_aid_prem = fnd_number.number_to_canonical(p_mutual_aid_prem),
1109: nonlife_long_ins_prem_o = fnd_number.number_to_canonical(p_nonlife_long_ins_prem_o),
1110: nonlife_short_ins_prem = fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
1111: nonlife_short_ins_prem_o = fnd_number.number_to_canonical(p_nonlife_short_ins_prem_o),
1112: earthquake_ins_prem = fnd_number.number_to_canonical(p_earthquake_ins_prem),
1113: earthquake_ins_prem_o = fnd_number.number_to_canonical(p_earthquake_ins_prem_o),
1114: social_ins_prem = fnd_number.number_to_canonical(p_social_ins_prem),
1115: social_ins_prem_o = fnd_number.number_to_canonical(p_social_ins_prem_o),
1116: mutual_aid_prem = fnd_number.number_to_canonical(p_mutual_aid_prem),
1117: mutual_aid_prem_o = fnd_number.number_to_canonical(p_mutual_aid_prem_o),
1110: nonlife_short_ins_prem = fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
1111: nonlife_short_ins_prem_o = fnd_number.number_to_canonical(p_nonlife_short_ins_prem_o),
1112: earthquake_ins_prem = fnd_number.number_to_canonical(p_earthquake_ins_prem),
1113: earthquake_ins_prem_o = fnd_number.number_to_canonical(p_earthquake_ins_prem_o),
1114: social_ins_prem = fnd_number.number_to_canonical(p_social_ins_prem),
1115: social_ins_prem_o = fnd_number.number_to_canonical(p_social_ins_prem_o),
1116: mutual_aid_prem = fnd_number.number_to_canonical(p_mutual_aid_prem),
1117: mutual_aid_prem_o = fnd_number.number_to_canonical(p_mutual_aid_prem_o),
1118: spouse_income = fnd_number.number_to_canonical(p_spouse_income),
1111: nonlife_short_ins_prem_o = fnd_number.number_to_canonical(p_nonlife_short_ins_prem_o),
1112: earthquake_ins_prem = fnd_number.number_to_canonical(p_earthquake_ins_prem),
1113: earthquake_ins_prem_o = fnd_number.number_to_canonical(p_earthquake_ins_prem_o),
1114: social_ins_prem = fnd_number.number_to_canonical(p_social_ins_prem),
1115: social_ins_prem_o = fnd_number.number_to_canonical(p_social_ins_prem_o),
1116: mutual_aid_prem = fnd_number.number_to_canonical(p_mutual_aid_prem),
1117: mutual_aid_prem_o = fnd_number.number_to_canonical(p_mutual_aid_prem_o),
1118: spouse_income = fnd_number.number_to_canonical(p_spouse_income),
1119: spouse_income_o = fnd_number.number_to_canonical(p_spouse_income_o),
1112: earthquake_ins_prem = fnd_number.number_to_canonical(p_earthquake_ins_prem),
1113: earthquake_ins_prem_o = fnd_number.number_to_canonical(p_earthquake_ins_prem_o),
1114: social_ins_prem = fnd_number.number_to_canonical(p_social_ins_prem),
1115: social_ins_prem_o = fnd_number.number_to_canonical(p_social_ins_prem_o),
1116: mutual_aid_prem = fnd_number.number_to_canonical(p_mutual_aid_prem),
1117: mutual_aid_prem_o = fnd_number.number_to_canonical(p_mutual_aid_prem_o),
1118: spouse_income = fnd_number.number_to_canonical(p_spouse_income),
1119: spouse_income_o = fnd_number.number_to_canonical(p_spouse_income_o),
1120: national_pens_ins_prem = fnd_number.number_to_canonical(p_national_pens_ins_prem),
1113: earthquake_ins_prem_o = fnd_number.number_to_canonical(p_earthquake_ins_prem_o),
1114: social_ins_prem = fnd_number.number_to_canonical(p_social_ins_prem),
1115: social_ins_prem_o = fnd_number.number_to_canonical(p_social_ins_prem_o),
1116: mutual_aid_prem = fnd_number.number_to_canonical(p_mutual_aid_prem),
1117: mutual_aid_prem_o = fnd_number.number_to_canonical(p_mutual_aid_prem_o),
1118: spouse_income = fnd_number.number_to_canonical(p_spouse_income),
1119: spouse_income_o = fnd_number.number_to_canonical(p_spouse_income_o),
1120: national_pens_ins_prem = fnd_number.number_to_canonical(p_national_pens_ins_prem),
1121: national_pens_ins_prem_o = fnd_number.number_to_canonical(p_national_pens_ins_prem_o),
1114: social_ins_prem = fnd_number.number_to_canonical(p_social_ins_prem),
1115: social_ins_prem_o = fnd_number.number_to_canonical(p_social_ins_prem_o),
1116: mutual_aid_prem = fnd_number.number_to_canonical(p_mutual_aid_prem),
1117: mutual_aid_prem_o = fnd_number.number_to_canonical(p_mutual_aid_prem_o),
1118: spouse_income = fnd_number.number_to_canonical(p_spouse_income),
1119: spouse_income_o = fnd_number.number_to_canonical(p_spouse_income_o),
1120: national_pens_ins_prem = fnd_number.number_to_canonical(p_national_pens_ins_prem),
1121: national_pens_ins_prem_o = fnd_number.number_to_canonical(p_national_pens_ins_prem_o),
1122: life_gen_ins_prem_new = fnd_number.number_to_canonical(p_life_gen_ins_prem_new),
1115: social_ins_prem_o = fnd_number.number_to_canonical(p_social_ins_prem_o),
1116: mutual_aid_prem = fnd_number.number_to_canonical(p_mutual_aid_prem),
1117: mutual_aid_prem_o = fnd_number.number_to_canonical(p_mutual_aid_prem_o),
1118: spouse_income = fnd_number.number_to_canonical(p_spouse_income),
1119: spouse_income_o = fnd_number.number_to_canonical(p_spouse_income_o),
1120: national_pens_ins_prem = fnd_number.number_to_canonical(p_national_pens_ins_prem),
1121: national_pens_ins_prem_o = fnd_number.number_to_canonical(p_national_pens_ins_prem_o),
1122: life_gen_ins_prem_new = fnd_number.number_to_canonical(p_life_gen_ins_prem_new),
1123: life_pens_ins_prem_new = fnd_number.number_to_canonical(p_life_pens_ins_prem_new),
1116: mutual_aid_prem = fnd_number.number_to_canonical(p_mutual_aid_prem),
1117: mutual_aid_prem_o = fnd_number.number_to_canonical(p_mutual_aid_prem_o),
1118: spouse_income = fnd_number.number_to_canonical(p_spouse_income),
1119: spouse_income_o = fnd_number.number_to_canonical(p_spouse_income_o),
1120: national_pens_ins_prem = fnd_number.number_to_canonical(p_national_pens_ins_prem),
1121: national_pens_ins_prem_o = fnd_number.number_to_canonical(p_national_pens_ins_prem_o),
1122: life_gen_ins_prem_new = fnd_number.number_to_canonical(p_life_gen_ins_prem_new),
1123: life_pens_ins_prem_new = fnd_number.number_to_canonical(p_life_pens_ins_prem_new),
1124: care_med_ins_prem_new = fnd_number.number_to_canonical(p_care_med_ins_prem_new)
1117: mutual_aid_prem_o = fnd_number.number_to_canonical(p_mutual_aid_prem_o),
1118: spouse_income = fnd_number.number_to_canonical(p_spouse_income),
1119: spouse_income_o = fnd_number.number_to_canonical(p_spouse_income_o),
1120: national_pens_ins_prem = fnd_number.number_to_canonical(p_national_pens_ins_prem),
1121: national_pens_ins_prem_o = fnd_number.number_to_canonical(p_national_pens_ins_prem_o),
1122: life_gen_ins_prem_new = fnd_number.number_to_canonical(p_life_gen_ins_prem_new),
1123: life_pens_ins_prem_new = fnd_number.number_to_canonical(p_life_pens_ins_prem_new),
1124: care_med_ins_prem_new = fnd_number.number_to_canonical(p_care_med_ins_prem_new)
1125: where row_id = l_rec.row_id;
1118: spouse_income = fnd_number.number_to_canonical(p_spouse_income),
1119: spouse_income_o = fnd_number.number_to_canonical(p_spouse_income_o),
1120: national_pens_ins_prem = fnd_number.number_to_canonical(p_national_pens_ins_prem),
1121: national_pens_ins_prem_o = fnd_number.number_to_canonical(p_national_pens_ins_prem_o),
1122: life_gen_ins_prem_new = fnd_number.number_to_canonical(p_life_gen_ins_prem_new),
1123: life_pens_ins_prem_new = fnd_number.number_to_canonical(p_life_pens_ins_prem_new),
1124: care_med_ins_prem_new = fnd_number.number_to_canonical(p_care_med_ins_prem_new)
1125: where row_id = l_rec.row_id;
1126: --
1119: spouse_income_o = fnd_number.number_to_canonical(p_spouse_income_o),
1120: national_pens_ins_prem = fnd_number.number_to_canonical(p_national_pens_ins_prem),
1121: national_pens_ins_prem_o = fnd_number.number_to_canonical(p_national_pens_ins_prem_o),
1122: life_gen_ins_prem_new = fnd_number.number_to_canonical(p_life_gen_ins_prem_new),
1123: life_pens_ins_prem_new = fnd_number.number_to_canonical(p_life_pens_ins_prem_new),
1124: care_med_ins_prem_new = fnd_number.number_to_canonical(p_care_med_ins_prem_new)
1125: where row_id = l_rec.row_id;
1126: --
1127: if g_debug then
1120: national_pens_ins_prem = fnd_number.number_to_canonical(p_national_pens_ins_prem),
1121: national_pens_ins_prem_o = fnd_number.number_to_canonical(p_national_pens_ins_prem_o),
1122: life_gen_ins_prem_new = fnd_number.number_to_canonical(p_life_gen_ins_prem_new),
1123: life_pens_ins_prem_new = fnd_number.number_to_canonical(p_life_pens_ins_prem_new),
1124: care_med_ins_prem_new = fnd_number.number_to_canonical(p_care_med_ins_prem_new)
1125: where row_id = l_rec.row_id;
1126: --
1127: if g_debug then
1128: hr_utility.set_location(l_proc,1000);
1227: p_assignment_id,
1228: p_effective_date,
1229: p_action_information_category,
1230: p_status,
1231: fnd_number.number_to_canonical(p_life_gen_ins_prem),
1232: fnd_number.number_to_canonical(p_life_pens_ins_prem),
1233: fnd_number.number_to_canonical(p_life_gen_ins_calc_prem),
1234: fnd_number.number_to_canonical(p_life_pens_ins_calc_prem),
1235: fnd_number.number_to_canonical(p_life_ins_deduction),
1228: p_effective_date,
1229: p_action_information_category,
1230: p_status,
1231: fnd_number.number_to_canonical(p_life_gen_ins_prem),
1232: fnd_number.number_to_canonical(p_life_pens_ins_prem),
1233: fnd_number.number_to_canonical(p_life_gen_ins_calc_prem),
1234: fnd_number.number_to_canonical(p_life_pens_ins_calc_prem),
1235: fnd_number.number_to_canonical(p_life_ins_deduction),
1236: fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
1229: p_action_information_category,
1230: p_status,
1231: fnd_number.number_to_canonical(p_life_gen_ins_prem),
1232: fnd_number.number_to_canonical(p_life_pens_ins_prem),
1233: fnd_number.number_to_canonical(p_life_gen_ins_calc_prem),
1234: fnd_number.number_to_canonical(p_life_pens_ins_calc_prem),
1235: fnd_number.number_to_canonical(p_life_ins_deduction),
1236: fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
1237: fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
1230: p_status,
1231: fnd_number.number_to_canonical(p_life_gen_ins_prem),
1232: fnd_number.number_to_canonical(p_life_pens_ins_prem),
1233: fnd_number.number_to_canonical(p_life_gen_ins_calc_prem),
1234: fnd_number.number_to_canonical(p_life_pens_ins_calc_prem),
1235: fnd_number.number_to_canonical(p_life_ins_deduction),
1236: fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
1237: fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
1238: fnd_number.number_to_canonical(p_earthquake_ins_prem),
1231: fnd_number.number_to_canonical(p_life_gen_ins_prem),
1232: fnd_number.number_to_canonical(p_life_pens_ins_prem),
1233: fnd_number.number_to_canonical(p_life_gen_ins_calc_prem),
1234: fnd_number.number_to_canonical(p_life_pens_ins_calc_prem),
1235: fnd_number.number_to_canonical(p_life_ins_deduction),
1236: fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
1237: fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
1238: fnd_number.number_to_canonical(p_earthquake_ins_prem),
1239: fnd_number.number_to_canonical(p_nonlife_long_ins_calc_prem),
1232: fnd_number.number_to_canonical(p_life_pens_ins_prem),
1233: fnd_number.number_to_canonical(p_life_gen_ins_calc_prem),
1234: fnd_number.number_to_canonical(p_life_pens_ins_calc_prem),
1235: fnd_number.number_to_canonical(p_life_ins_deduction),
1236: fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
1237: fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
1238: fnd_number.number_to_canonical(p_earthquake_ins_prem),
1239: fnd_number.number_to_canonical(p_nonlife_long_ins_calc_prem),
1240: fnd_number.number_to_canonical(p_nonlife_short_ins_calc_prem),
1233: fnd_number.number_to_canonical(p_life_gen_ins_calc_prem),
1234: fnd_number.number_to_canonical(p_life_pens_ins_calc_prem),
1235: fnd_number.number_to_canonical(p_life_ins_deduction),
1236: fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
1237: fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
1238: fnd_number.number_to_canonical(p_earthquake_ins_prem),
1239: fnd_number.number_to_canonical(p_nonlife_long_ins_calc_prem),
1240: fnd_number.number_to_canonical(p_nonlife_short_ins_calc_prem),
1241: fnd_number.number_to_canonical(p_earthquake_ins_calc_prem),
1234: fnd_number.number_to_canonical(p_life_pens_ins_calc_prem),
1235: fnd_number.number_to_canonical(p_life_ins_deduction),
1236: fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
1237: fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
1238: fnd_number.number_to_canonical(p_earthquake_ins_prem),
1239: fnd_number.number_to_canonical(p_nonlife_long_ins_calc_prem),
1240: fnd_number.number_to_canonical(p_nonlife_short_ins_calc_prem),
1241: fnd_number.number_to_canonical(p_earthquake_ins_calc_prem),
1242: fnd_number.number_to_canonical(p_nonlife_ins_deduction),
1235: fnd_number.number_to_canonical(p_life_ins_deduction),
1236: fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
1237: fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
1238: fnd_number.number_to_canonical(p_earthquake_ins_prem),
1239: fnd_number.number_to_canonical(p_nonlife_long_ins_calc_prem),
1240: fnd_number.number_to_canonical(p_nonlife_short_ins_calc_prem),
1241: fnd_number.number_to_canonical(p_earthquake_ins_calc_prem),
1242: fnd_number.number_to_canonical(p_nonlife_ins_deduction),
1243: fnd_number.number_to_canonical(p_social_ins_deduction),
1236: fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
1237: fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
1238: fnd_number.number_to_canonical(p_earthquake_ins_prem),
1239: fnd_number.number_to_canonical(p_nonlife_long_ins_calc_prem),
1240: fnd_number.number_to_canonical(p_nonlife_short_ins_calc_prem),
1241: fnd_number.number_to_canonical(p_earthquake_ins_calc_prem),
1242: fnd_number.number_to_canonical(p_nonlife_ins_deduction),
1243: fnd_number.number_to_canonical(p_social_ins_deduction),
1244: fnd_number.number_to_canonical(p_mutual_aid_deduction),
1237: fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
1238: fnd_number.number_to_canonical(p_earthquake_ins_prem),
1239: fnd_number.number_to_canonical(p_nonlife_long_ins_calc_prem),
1240: fnd_number.number_to_canonical(p_nonlife_short_ins_calc_prem),
1241: fnd_number.number_to_canonical(p_earthquake_ins_calc_prem),
1242: fnd_number.number_to_canonical(p_nonlife_ins_deduction),
1243: fnd_number.number_to_canonical(p_social_ins_deduction),
1244: fnd_number.number_to_canonical(p_mutual_aid_deduction),
1245: fnd_number.number_to_canonical(p_sp_earned_income_calc),
1238: fnd_number.number_to_canonical(p_earthquake_ins_prem),
1239: fnd_number.number_to_canonical(p_nonlife_long_ins_calc_prem),
1240: fnd_number.number_to_canonical(p_nonlife_short_ins_calc_prem),
1241: fnd_number.number_to_canonical(p_earthquake_ins_calc_prem),
1242: fnd_number.number_to_canonical(p_nonlife_ins_deduction),
1243: fnd_number.number_to_canonical(p_social_ins_deduction),
1244: fnd_number.number_to_canonical(p_mutual_aid_deduction),
1245: fnd_number.number_to_canonical(p_sp_earned_income_calc),
1246: fnd_number.number_to_canonical(p_sp_business_income_calc),
1239: fnd_number.number_to_canonical(p_nonlife_long_ins_calc_prem),
1240: fnd_number.number_to_canonical(p_nonlife_short_ins_calc_prem),
1241: fnd_number.number_to_canonical(p_earthquake_ins_calc_prem),
1242: fnd_number.number_to_canonical(p_nonlife_ins_deduction),
1243: fnd_number.number_to_canonical(p_social_ins_deduction),
1244: fnd_number.number_to_canonical(p_mutual_aid_deduction),
1245: fnd_number.number_to_canonical(p_sp_earned_income_calc),
1246: fnd_number.number_to_canonical(p_sp_business_income_calc),
1247: fnd_number.number_to_canonical(p_sp_miscellaneous_income_calc),
1240: fnd_number.number_to_canonical(p_nonlife_short_ins_calc_prem),
1241: fnd_number.number_to_canonical(p_earthquake_ins_calc_prem),
1242: fnd_number.number_to_canonical(p_nonlife_ins_deduction),
1243: fnd_number.number_to_canonical(p_social_ins_deduction),
1244: fnd_number.number_to_canonical(p_mutual_aid_deduction),
1245: fnd_number.number_to_canonical(p_sp_earned_income_calc),
1246: fnd_number.number_to_canonical(p_sp_business_income_calc),
1247: fnd_number.number_to_canonical(p_sp_miscellaneous_income_calc),
1248: fnd_number.number_to_canonical(p_sp_dividend_income_calc),
1241: fnd_number.number_to_canonical(p_earthquake_ins_calc_prem),
1242: fnd_number.number_to_canonical(p_nonlife_ins_deduction),
1243: fnd_number.number_to_canonical(p_social_ins_deduction),
1244: fnd_number.number_to_canonical(p_mutual_aid_deduction),
1245: fnd_number.number_to_canonical(p_sp_earned_income_calc),
1246: fnd_number.number_to_canonical(p_sp_business_income_calc),
1247: fnd_number.number_to_canonical(p_sp_miscellaneous_income_calc),
1248: fnd_number.number_to_canonical(p_sp_dividend_income_calc),
1249: fnd_number.number_to_canonical(p_sp_real_estate_income_calc),
1242: fnd_number.number_to_canonical(p_nonlife_ins_deduction),
1243: fnd_number.number_to_canonical(p_social_ins_deduction),
1244: fnd_number.number_to_canonical(p_mutual_aid_deduction),
1245: fnd_number.number_to_canonical(p_sp_earned_income_calc),
1246: fnd_number.number_to_canonical(p_sp_business_income_calc),
1247: fnd_number.number_to_canonical(p_sp_miscellaneous_income_calc),
1248: fnd_number.number_to_canonical(p_sp_dividend_income_calc),
1249: fnd_number.number_to_canonical(p_sp_real_estate_income_calc),
1250: fnd_number.number_to_canonical(p_sp_retirement_income_calc),
1243: fnd_number.number_to_canonical(p_social_ins_deduction),
1244: fnd_number.number_to_canonical(p_mutual_aid_deduction),
1245: fnd_number.number_to_canonical(p_sp_earned_income_calc),
1246: fnd_number.number_to_canonical(p_sp_business_income_calc),
1247: fnd_number.number_to_canonical(p_sp_miscellaneous_income_calc),
1248: fnd_number.number_to_canonical(p_sp_dividend_income_calc),
1249: fnd_number.number_to_canonical(p_sp_real_estate_income_calc),
1250: fnd_number.number_to_canonical(p_sp_retirement_income_calc),
1251: fnd_number.number_to_canonical(p_sp_other_income_calc),
1244: fnd_number.number_to_canonical(p_mutual_aid_deduction),
1245: fnd_number.number_to_canonical(p_sp_earned_income_calc),
1246: fnd_number.number_to_canonical(p_sp_business_income_calc),
1247: fnd_number.number_to_canonical(p_sp_miscellaneous_income_calc),
1248: fnd_number.number_to_canonical(p_sp_dividend_income_calc),
1249: fnd_number.number_to_canonical(p_sp_real_estate_income_calc),
1250: fnd_number.number_to_canonical(p_sp_retirement_income_calc),
1251: fnd_number.number_to_canonical(p_sp_other_income_calc),
1252: fnd_number.number_to_canonical(p_sp_income_calc),
1245: fnd_number.number_to_canonical(p_sp_earned_income_calc),
1246: fnd_number.number_to_canonical(p_sp_business_income_calc),
1247: fnd_number.number_to_canonical(p_sp_miscellaneous_income_calc),
1248: fnd_number.number_to_canonical(p_sp_dividend_income_calc),
1249: fnd_number.number_to_canonical(p_sp_real_estate_income_calc),
1250: fnd_number.number_to_canonical(p_sp_retirement_income_calc),
1251: fnd_number.number_to_canonical(p_sp_other_income_calc),
1252: fnd_number.number_to_canonical(p_sp_income_calc),
1253: fnd_number.number_to_canonical(p_spouse_income),
1246: fnd_number.number_to_canonical(p_sp_business_income_calc),
1247: fnd_number.number_to_canonical(p_sp_miscellaneous_income_calc),
1248: fnd_number.number_to_canonical(p_sp_dividend_income_calc),
1249: fnd_number.number_to_canonical(p_sp_real_estate_income_calc),
1250: fnd_number.number_to_canonical(p_sp_retirement_income_calc),
1251: fnd_number.number_to_canonical(p_sp_other_income_calc),
1252: fnd_number.number_to_canonical(p_sp_income_calc),
1253: fnd_number.number_to_canonical(p_spouse_income),
1254: fnd_number.number_to_canonical(p_spouse_deduction),
1247: fnd_number.number_to_canonical(p_sp_miscellaneous_income_calc),
1248: fnd_number.number_to_canonical(p_sp_dividend_income_calc),
1249: fnd_number.number_to_canonical(p_sp_real_estate_income_calc),
1250: fnd_number.number_to_canonical(p_sp_retirement_income_calc),
1251: fnd_number.number_to_canonical(p_sp_other_income_calc),
1252: fnd_number.number_to_canonical(p_sp_income_calc),
1253: fnd_number.number_to_canonical(p_spouse_income),
1254: fnd_number.number_to_canonical(p_spouse_deduction),
1255: fnd_number.number_to_canonical(p_national_pens_ins_prem),
1248: fnd_number.number_to_canonical(p_sp_dividend_income_calc),
1249: fnd_number.number_to_canonical(p_sp_real_estate_income_calc),
1250: fnd_number.number_to_canonical(p_sp_retirement_income_calc),
1251: fnd_number.number_to_canonical(p_sp_other_income_calc),
1252: fnd_number.number_to_canonical(p_sp_income_calc),
1253: fnd_number.number_to_canonical(p_spouse_income),
1254: fnd_number.number_to_canonical(p_spouse_deduction),
1255: fnd_number.number_to_canonical(p_national_pens_ins_prem),
1256: fnd_number.number_to_canonical(p_life_gen_new_ins_prem),
1249: fnd_number.number_to_canonical(p_sp_real_estate_income_calc),
1250: fnd_number.number_to_canonical(p_sp_retirement_income_calc),
1251: fnd_number.number_to_canonical(p_sp_other_income_calc),
1252: fnd_number.number_to_canonical(p_sp_income_calc),
1253: fnd_number.number_to_canonical(p_spouse_income),
1254: fnd_number.number_to_canonical(p_spouse_deduction),
1255: fnd_number.number_to_canonical(p_national_pens_ins_prem),
1256: fnd_number.number_to_canonical(p_life_gen_new_ins_prem),
1257: fnd_number.number_to_canonical(p_life_pens_new_ins_prem),
1250: fnd_number.number_to_canonical(p_sp_retirement_income_calc),
1251: fnd_number.number_to_canonical(p_sp_other_income_calc),
1252: fnd_number.number_to_canonical(p_sp_income_calc),
1253: fnd_number.number_to_canonical(p_spouse_income),
1254: fnd_number.number_to_canonical(p_spouse_deduction),
1255: fnd_number.number_to_canonical(p_national_pens_ins_prem),
1256: fnd_number.number_to_canonical(p_life_gen_new_ins_prem),
1257: fnd_number.number_to_canonical(p_life_pens_new_ins_prem),
1258: fnd_number.number_to_canonical(p_life_gen_new_ins_calc_prem),
1251: fnd_number.number_to_canonical(p_sp_other_income_calc),
1252: fnd_number.number_to_canonical(p_sp_income_calc),
1253: fnd_number.number_to_canonical(p_spouse_income),
1254: fnd_number.number_to_canonical(p_spouse_deduction),
1255: fnd_number.number_to_canonical(p_national_pens_ins_prem),
1256: fnd_number.number_to_canonical(p_life_gen_new_ins_prem),
1257: fnd_number.number_to_canonical(p_life_pens_new_ins_prem),
1258: fnd_number.number_to_canonical(p_life_gen_new_ins_calc_prem),
1259: fnd_number.number_to_canonical(p_life_pens_new_ins_calc_prem));
1252: fnd_number.number_to_canonical(p_sp_income_calc),
1253: fnd_number.number_to_canonical(p_spouse_income),
1254: fnd_number.number_to_canonical(p_spouse_deduction),
1255: fnd_number.number_to_canonical(p_national_pens_ins_prem),
1256: fnd_number.number_to_canonical(p_life_gen_new_ins_prem),
1257: fnd_number.number_to_canonical(p_life_pens_new_ins_prem),
1258: fnd_number.number_to_canonical(p_life_gen_new_ins_calc_prem),
1259: fnd_number.number_to_canonical(p_life_pens_new_ins_calc_prem));
1260: --
1253: fnd_number.number_to_canonical(p_spouse_income),
1254: fnd_number.number_to_canonical(p_spouse_deduction),
1255: fnd_number.number_to_canonical(p_national_pens_ins_prem),
1256: fnd_number.number_to_canonical(p_life_gen_new_ins_prem),
1257: fnd_number.number_to_canonical(p_life_pens_new_ins_prem),
1258: fnd_number.number_to_canonical(p_life_gen_new_ins_calc_prem),
1259: fnd_number.number_to_canonical(p_life_pens_new_ins_calc_prem));
1260: --
1261: if g_debug then
1254: fnd_number.number_to_canonical(p_spouse_deduction),
1255: fnd_number.number_to_canonical(p_national_pens_ins_prem),
1256: fnd_number.number_to_canonical(p_life_gen_new_ins_prem),
1257: fnd_number.number_to_canonical(p_life_pens_new_ins_prem),
1258: fnd_number.number_to_canonical(p_life_gen_new_ins_calc_prem),
1259: fnd_number.number_to_canonical(p_life_pens_new_ins_calc_prem));
1260: --
1261: if g_debug then
1262: hr_utility.set_location(l_proc,1000);
1255: fnd_number.number_to_canonical(p_national_pens_ins_prem),
1256: fnd_number.number_to_canonical(p_life_gen_new_ins_prem),
1257: fnd_number.number_to_canonical(p_life_pens_new_ins_prem),
1258: fnd_number.number_to_canonical(p_life_gen_new_ins_calc_prem),
1259: fnd_number.number_to_canonical(p_life_pens_new_ins_calc_prem));
1260: --
1261: if g_debug then
1262: hr_utility.set_location(l_proc,1000);
1263: end if;
1319: --
1320: update pay_jp_isdf_calc_dct_dml_v
1321: set object_version_number = p_object_version_number,
1322: status = p_status,
1323: life_gen_ins_prem = fnd_number.number_to_canonical(p_life_gen_ins_prem),
1324: life_pens_ins_prem = fnd_number.number_to_canonical(p_life_pens_ins_prem),
1325: life_gen_ins_calc_prem = fnd_number.number_to_canonical(p_life_gen_ins_calc_prem),
1326: life_pens_ins_calc_prem = fnd_number.number_to_canonical(p_life_pens_ins_calc_prem),
1327: life_ins_deduction = fnd_number.number_to_canonical(p_life_ins_deduction),
1320: update pay_jp_isdf_calc_dct_dml_v
1321: set object_version_number = p_object_version_number,
1322: status = p_status,
1323: life_gen_ins_prem = fnd_number.number_to_canonical(p_life_gen_ins_prem),
1324: life_pens_ins_prem = fnd_number.number_to_canonical(p_life_pens_ins_prem),
1325: life_gen_ins_calc_prem = fnd_number.number_to_canonical(p_life_gen_ins_calc_prem),
1326: life_pens_ins_calc_prem = fnd_number.number_to_canonical(p_life_pens_ins_calc_prem),
1327: life_ins_deduction = fnd_number.number_to_canonical(p_life_ins_deduction),
1328: nonlife_long_ins_prem = fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
1321: set object_version_number = p_object_version_number,
1322: status = p_status,
1323: life_gen_ins_prem = fnd_number.number_to_canonical(p_life_gen_ins_prem),
1324: life_pens_ins_prem = fnd_number.number_to_canonical(p_life_pens_ins_prem),
1325: life_gen_ins_calc_prem = fnd_number.number_to_canonical(p_life_gen_ins_calc_prem),
1326: life_pens_ins_calc_prem = fnd_number.number_to_canonical(p_life_pens_ins_calc_prem),
1327: life_ins_deduction = fnd_number.number_to_canonical(p_life_ins_deduction),
1328: nonlife_long_ins_prem = fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
1329: nonlife_short_ins_prem = fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
1322: status = p_status,
1323: life_gen_ins_prem = fnd_number.number_to_canonical(p_life_gen_ins_prem),
1324: life_pens_ins_prem = fnd_number.number_to_canonical(p_life_pens_ins_prem),
1325: life_gen_ins_calc_prem = fnd_number.number_to_canonical(p_life_gen_ins_calc_prem),
1326: life_pens_ins_calc_prem = fnd_number.number_to_canonical(p_life_pens_ins_calc_prem),
1327: life_ins_deduction = fnd_number.number_to_canonical(p_life_ins_deduction),
1328: nonlife_long_ins_prem = fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
1329: nonlife_short_ins_prem = fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
1330: earthquake_ins_prem = fnd_number.number_to_canonical(p_earthquake_ins_prem),
1323: life_gen_ins_prem = fnd_number.number_to_canonical(p_life_gen_ins_prem),
1324: life_pens_ins_prem = fnd_number.number_to_canonical(p_life_pens_ins_prem),
1325: life_gen_ins_calc_prem = fnd_number.number_to_canonical(p_life_gen_ins_calc_prem),
1326: life_pens_ins_calc_prem = fnd_number.number_to_canonical(p_life_pens_ins_calc_prem),
1327: life_ins_deduction = fnd_number.number_to_canonical(p_life_ins_deduction),
1328: nonlife_long_ins_prem = fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
1329: nonlife_short_ins_prem = fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
1330: earthquake_ins_prem = fnd_number.number_to_canonical(p_earthquake_ins_prem),
1331: nonlife_long_ins_calc_prem = fnd_number.number_to_canonical(p_nonlife_long_ins_calc_prem),
1324: life_pens_ins_prem = fnd_number.number_to_canonical(p_life_pens_ins_prem),
1325: life_gen_ins_calc_prem = fnd_number.number_to_canonical(p_life_gen_ins_calc_prem),
1326: life_pens_ins_calc_prem = fnd_number.number_to_canonical(p_life_pens_ins_calc_prem),
1327: life_ins_deduction = fnd_number.number_to_canonical(p_life_ins_deduction),
1328: nonlife_long_ins_prem = fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
1329: nonlife_short_ins_prem = fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
1330: earthquake_ins_prem = fnd_number.number_to_canonical(p_earthquake_ins_prem),
1331: nonlife_long_ins_calc_prem = fnd_number.number_to_canonical(p_nonlife_long_ins_calc_prem),
1332: nonlife_short_ins_calc_prem = fnd_number.number_to_canonical(p_nonlife_short_ins_calc_prem),
1325: life_gen_ins_calc_prem = fnd_number.number_to_canonical(p_life_gen_ins_calc_prem),
1326: life_pens_ins_calc_prem = fnd_number.number_to_canonical(p_life_pens_ins_calc_prem),
1327: life_ins_deduction = fnd_number.number_to_canonical(p_life_ins_deduction),
1328: nonlife_long_ins_prem = fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
1329: nonlife_short_ins_prem = fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
1330: earthquake_ins_prem = fnd_number.number_to_canonical(p_earthquake_ins_prem),
1331: nonlife_long_ins_calc_prem = fnd_number.number_to_canonical(p_nonlife_long_ins_calc_prem),
1332: nonlife_short_ins_calc_prem = fnd_number.number_to_canonical(p_nonlife_short_ins_calc_prem),
1333: earthquake_ins_calc_prem = fnd_number.number_to_canonical(p_earthquake_ins_calc_prem),
1326: life_pens_ins_calc_prem = fnd_number.number_to_canonical(p_life_pens_ins_calc_prem),
1327: life_ins_deduction = fnd_number.number_to_canonical(p_life_ins_deduction),
1328: nonlife_long_ins_prem = fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
1329: nonlife_short_ins_prem = fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
1330: earthquake_ins_prem = fnd_number.number_to_canonical(p_earthquake_ins_prem),
1331: nonlife_long_ins_calc_prem = fnd_number.number_to_canonical(p_nonlife_long_ins_calc_prem),
1332: nonlife_short_ins_calc_prem = fnd_number.number_to_canonical(p_nonlife_short_ins_calc_prem),
1333: earthquake_ins_calc_prem = fnd_number.number_to_canonical(p_earthquake_ins_calc_prem),
1334: nonlife_ins_deduction = fnd_number.number_to_canonical(p_nonlife_ins_deduction),
1327: life_ins_deduction = fnd_number.number_to_canonical(p_life_ins_deduction),
1328: nonlife_long_ins_prem = fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
1329: nonlife_short_ins_prem = fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
1330: earthquake_ins_prem = fnd_number.number_to_canonical(p_earthquake_ins_prem),
1331: nonlife_long_ins_calc_prem = fnd_number.number_to_canonical(p_nonlife_long_ins_calc_prem),
1332: nonlife_short_ins_calc_prem = fnd_number.number_to_canonical(p_nonlife_short_ins_calc_prem),
1333: earthquake_ins_calc_prem = fnd_number.number_to_canonical(p_earthquake_ins_calc_prem),
1334: nonlife_ins_deduction = fnd_number.number_to_canonical(p_nonlife_ins_deduction),
1335: social_ins_deduction = fnd_number.number_to_canonical(p_social_ins_deduction),
1328: nonlife_long_ins_prem = fnd_number.number_to_canonical(p_nonlife_long_ins_prem),
1329: nonlife_short_ins_prem = fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
1330: earthquake_ins_prem = fnd_number.number_to_canonical(p_earthquake_ins_prem),
1331: nonlife_long_ins_calc_prem = fnd_number.number_to_canonical(p_nonlife_long_ins_calc_prem),
1332: nonlife_short_ins_calc_prem = fnd_number.number_to_canonical(p_nonlife_short_ins_calc_prem),
1333: earthquake_ins_calc_prem = fnd_number.number_to_canonical(p_earthquake_ins_calc_prem),
1334: nonlife_ins_deduction = fnd_number.number_to_canonical(p_nonlife_ins_deduction),
1335: social_ins_deduction = fnd_number.number_to_canonical(p_social_ins_deduction),
1336: mutual_aid_deduction = fnd_number.number_to_canonical(p_mutual_aid_deduction),
1329: nonlife_short_ins_prem = fnd_number.number_to_canonical(p_nonlife_short_ins_prem),
1330: earthquake_ins_prem = fnd_number.number_to_canonical(p_earthquake_ins_prem),
1331: nonlife_long_ins_calc_prem = fnd_number.number_to_canonical(p_nonlife_long_ins_calc_prem),
1332: nonlife_short_ins_calc_prem = fnd_number.number_to_canonical(p_nonlife_short_ins_calc_prem),
1333: earthquake_ins_calc_prem = fnd_number.number_to_canonical(p_earthquake_ins_calc_prem),
1334: nonlife_ins_deduction = fnd_number.number_to_canonical(p_nonlife_ins_deduction),
1335: social_ins_deduction = fnd_number.number_to_canonical(p_social_ins_deduction),
1336: mutual_aid_deduction = fnd_number.number_to_canonical(p_mutual_aid_deduction),
1337: sp_earned_income_calc = fnd_number.number_to_canonical(p_sp_earned_income_calc),
1330: earthquake_ins_prem = fnd_number.number_to_canonical(p_earthquake_ins_prem),
1331: nonlife_long_ins_calc_prem = fnd_number.number_to_canonical(p_nonlife_long_ins_calc_prem),
1332: nonlife_short_ins_calc_prem = fnd_number.number_to_canonical(p_nonlife_short_ins_calc_prem),
1333: earthquake_ins_calc_prem = fnd_number.number_to_canonical(p_earthquake_ins_calc_prem),
1334: nonlife_ins_deduction = fnd_number.number_to_canonical(p_nonlife_ins_deduction),
1335: social_ins_deduction = fnd_number.number_to_canonical(p_social_ins_deduction),
1336: mutual_aid_deduction = fnd_number.number_to_canonical(p_mutual_aid_deduction),
1337: sp_earned_income_calc = fnd_number.number_to_canonical(p_sp_earned_income_calc),
1338: sp_business_income_calc = fnd_number.number_to_canonical(p_sp_business_income_calc),
1331: nonlife_long_ins_calc_prem = fnd_number.number_to_canonical(p_nonlife_long_ins_calc_prem),
1332: nonlife_short_ins_calc_prem = fnd_number.number_to_canonical(p_nonlife_short_ins_calc_prem),
1333: earthquake_ins_calc_prem = fnd_number.number_to_canonical(p_earthquake_ins_calc_prem),
1334: nonlife_ins_deduction = fnd_number.number_to_canonical(p_nonlife_ins_deduction),
1335: social_ins_deduction = fnd_number.number_to_canonical(p_social_ins_deduction),
1336: mutual_aid_deduction = fnd_number.number_to_canonical(p_mutual_aid_deduction),
1337: sp_earned_income_calc = fnd_number.number_to_canonical(p_sp_earned_income_calc),
1338: sp_business_income_calc = fnd_number.number_to_canonical(p_sp_business_income_calc),
1339: sp_miscellaneous_income_calc = fnd_number.number_to_canonical(p_sp_miscellaneous_income_calc),
1332: nonlife_short_ins_calc_prem = fnd_number.number_to_canonical(p_nonlife_short_ins_calc_prem),
1333: earthquake_ins_calc_prem = fnd_number.number_to_canonical(p_earthquake_ins_calc_prem),
1334: nonlife_ins_deduction = fnd_number.number_to_canonical(p_nonlife_ins_deduction),
1335: social_ins_deduction = fnd_number.number_to_canonical(p_social_ins_deduction),
1336: mutual_aid_deduction = fnd_number.number_to_canonical(p_mutual_aid_deduction),
1337: sp_earned_income_calc = fnd_number.number_to_canonical(p_sp_earned_income_calc),
1338: sp_business_income_calc = fnd_number.number_to_canonical(p_sp_business_income_calc),
1339: sp_miscellaneous_income_calc = fnd_number.number_to_canonical(p_sp_miscellaneous_income_calc),
1340: sp_dividend_income_calc = fnd_number.number_to_canonical(p_sp_dividend_income_calc),
1333: earthquake_ins_calc_prem = fnd_number.number_to_canonical(p_earthquake_ins_calc_prem),
1334: nonlife_ins_deduction = fnd_number.number_to_canonical(p_nonlife_ins_deduction),
1335: social_ins_deduction = fnd_number.number_to_canonical(p_social_ins_deduction),
1336: mutual_aid_deduction = fnd_number.number_to_canonical(p_mutual_aid_deduction),
1337: sp_earned_income_calc = fnd_number.number_to_canonical(p_sp_earned_income_calc),
1338: sp_business_income_calc = fnd_number.number_to_canonical(p_sp_business_income_calc),
1339: sp_miscellaneous_income_calc = fnd_number.number_to_canonical(p_sp_miscellaneous_income_calc),
1340: sp_dividend_income_calc = fnd_number.number_to_canonical(p_sp_dividend_income_calc),
1341: sp_real_estate_income_calc = fnd_number.number_to_canonical(p_sp_real_estate_income_calc),
1334: nonlife_ins_deduction = fnd_number.number_to_canonical(p_nonlife_ins_deduction),
1335: social_ins_deduction = fnd_number.number_to_canonical(p_social_ins_deduction),
1336: mutual_aid_deduction = fnd_number.number_to_canonical(p_mutual_aid_deduction),
1337: sp_earned_income_calc = fnd_number.number_to_canonical(p_sp_earned_income_calc),
1338: sp_business_income_calc = fnd_number.number_to_canonical(p_sp_business_income_calc),
1339: sp_miscellaneous_income_calc = fnd_number.number_to_canonical(p_sp_miscellaneous_income_calc),
1340: sp_dividend_income_calc = fnd_number.number_to_canonical(p_sp_dividend_income_calc),
1341: sp_real_estate_income_calc = fnd_number.number_to_canonical(p_sp_real_estate_income_calc),
1342: sp_retirement_income_calc = fnd_number.number_to_canonical(p_sp_retirement_income_calc),
1335: social_ins_deduction = fnd_number.number_to_canonical(p_social_ins_deduction),
1336: mutual_aid_deduction = fnd_number.number_to_canonical(p_mutual_aid_deduction),
1337: sp_earned_income_calc = fnd_number.number_to_canonical(p_sp_earned_income_calc),
1338: sp_business_income_calc = fnd_number.number_to_canonical(p_sp_business_income_calc),
1339: sp_miscellaneous_income_calc = fnd_number.number_to_canonical(p_sp_miscellaneous_income_calc),
1340: sp_dividend_income_calc = fnd_number.number_to_canonical(p_sp_dividend_income_calc),
1341: sp_real_estate_income_calc = fnd_number.number_to_canonical(p_sp_real_estate_income_calc),
1342: sp_retirement_income_calc = fnd_number.number_to_canonical(p_sp_retirement_income_calc),
1343: sp_other_income_calc = fnd_number.number_to_canonical(p_sp_other_income_calc),
1336: mutual_aid_deduction = fnd_number.number_to_canonical(p_mutual_aid_deduction),
1337: sp_earned_income_calc = fnd_number.number_to_canonical(p_sp_earned_income_calc),
1338: sp_business_income_calc = fnd_number.number_to_canonical(p_sp_business_income_calc),
1339: sp_miscellaneous_income_calc = fnd_number.number_to_canonical(p_sp_miscellaneous_income_calc),
1340: sp_dividend_income_calc = fnd_number.number_to_canonical(p_sp_dividend_income_calc),
1341: sp_real_estate_income_calc = fnd_number.number_to_canonical(p_sp_real_estate_income_calc),
1342: sp_retirement_income_calc = fnd_number.number_to_canonical(p_sp_retirement_income_calc),
1343: sp_other_income_calc = fnd_number.number_to_canonical(p_sp_other_income_calc),
1344: sp_income_calc = fnd_number.number_to_canonical(p_sp_income_calc),
1337: sp_earned_income_calc = fnd_number.number_to_canonical(p_sp_earned_income_calc),
1338: sp_business_income_calc = fnd_number.number_to_canonical(p_sp_business_income_calc),
1339: sp_miscellaneous_income_calc = fnd_number.number_to_canonical(p_sp_miscellaneous_income_calc),
1340: sp_dividend_income_calc = fnd_number.number_to_canonical(p_sp_dividend_income_calc),
1341: sp_real_estate_income_calc = fnd_number.number_to_canonical(p_sp_real_estate_income_calc),
1342: sp_retirement_income_calc = fnd_number.number_to_canonical(p_sp_retirement_income_calc),
1343: sp_other_income_calc = fnd_number.number_to_canonical(p_sp_other_income_calc),
1344: sp_income_calc = fnd_number.number_to_canonical(p_sp_income_calc),
1345: spouse_income = fnd_number.number_to_canonical(p_spouse_income),
1338: sp_business_income_calc = fnd_number.number_to_canonical(p_sp_business_income_calc),
1339: sp_miscellaneous_income_calc = fnd_number.number_to_canonical(p_sp_miscellaneous_income_calc),
1340: sp_dividend_income_calc = fnd_number.number_to_canonical(p_sp_dividend_income_calc),
1341: sp_real_estate_income_calc = fnd_number.number_to_canonical(p_sp_real_estate_income_calc),
1342: sp_retirement_income_calc = fnd_number.number_to_canonical(p_sp_retirement_income_calc),
1343: sp_other_income_calc = fnd_number.number_to_canonical(p_sp_other_income_calc),
1344: sp_income_calc = fnd_number.number_to_canonical(p_sp_income_calc),
1345: spouse_income = fnd_number.number_to_canonical(p_spouse_income),
1346: spouse_deduction = fnd_number.number_to_canonical(p_spouse_deduction),
1339: sp_miscellaneous_income_calc = fnd_number.number_to_canonical(p_sp_miscellaneous_income_calc),
1340: sp_dividend_income_calc = fnd_number.number_to_canonical(p_sp_dividend_income_calc),
1341: sp_real_estate_income_calc = fnd_number.number_to_canonical(p_sp_real_estate_income_calc),
1342: sp_retirement_income_calc = fnd_number.number_to_canonical(p_sp_retirement_income_calc),
1343: sp_other_income_calc = fnd_number.number_to_canonical(p_sp_other_income_calc),
1344: sp_income_calc = fnd_number.number_to_canonical(p_sp_income_calc),
1345: spouse_income = fnd_number.number_to_canonical(p_spouse_income),
1346: spouse_deduction = fnd_number.number_to_canonical(p_spouse_deduction),
1347: national_pens_ins_prem = fnd_number.number_to_canonical(p_national_pens_ins_prem),
1340: sp_dividend_income_calc = fnd_number.number_to_canonical(p_sp_dividend_income_calc),
1341: sp_real_estate_income_calc = fnd_number.number_to_canonical(p_sp_real_estate_income_calc),
1342: sp_retirement_income_calc = fnd_number.number_to_canonical(p_sp_retirement_income_calc),
1343: sp_other_income_calc = fnd_number.number_to_canonical(p_sp_other_income_calc),
1344: sp_income_calc = fnd_number.number_to_canonical(p_sp_income_calc),
1345: spouse_income = fnd_number.number_to_canonical(p_spouse_income),
1346: spouse_deduction = fnd_number.number_to_canonical(p_spouse_deduction),
1347: national_pens_ins_prem = fnd_number.number_to_canonical(p_national_pens_ins_prem),
1348: life_gen_new_ins_prem = fnd_number.number_to_canonical(p_life_gen_new_ins_prem),
1341: sp_real_estate_income_calc = fnd_number.number_to_canonical(p_sp_real_estate_income_calc),
1342: sp_retirement_income_calc = fnd_number.number_to_canonical(p_sp_retirement_income_calc),
1343: sp_other_income_calc = fnd_number.number_to_canonical(p_sp_other_income_calc),
1344: sp_income_calc = fnd_number.number_to_canonical(p_sp_income_calc),
1345: spouse_income = fnd_number.number_to_canonical(p_spouse_income),
1346: spouse_deduction = fnd_number.number_to_canonical(p_spouse_deduction),
1347: national_pens_ins_prem = fnd_number.number_to_canonical(p_national_pens_ins_prem),
1348: life_gen_new_ins_prem = fnd_number.number_to_canonical(p_life_gen_new_ins_prem),
1349: life_pens_new_ins_prem = fnd_number.number_to_canonical(p_life_pens_new_ins_prem),
1342: sp_retirement_income_calc = fnd_number.number_to_canonical(p_sp_retirement_income_calc),
1343: sp_other_income_calc = fnd_number.number_to_canonical(p_sp_other_income_calc),
1344: sp_income_calc = fnd_number.number_to_canonical(p_sp_income_calc),
1345: spouse_income = fnd_number.number_to_canonical(p_spouse_income),
1346: spouse_deduction = fnd_number.number_to_canonical(p_spouse_deduction),
1347: national_pens_ins_prem = fnd_number.number_to_canonical(p_national_pens_ins_prem),
1348: life_gen_new_ins_prem = fnd_number.number_to_canonical(p_life_gen_new_ins_prem),
1349: life_pens_new_ins_prem = fnd_number.number_to_canonical(p_life_pens_new_ins_prem),
1350: life_gen_new_ins_calc_prem = fnd_number.number_to_canonical(p_life_gen_new_ins_calc_prem),
1343: sp_other_income_calc = fnd_number.number_to_canonical(p_sp_other_income_calc),
1344: sp_income_calc = fnd_number.number_to_canonical(p_sp_income_calc),
1345: spouse_income = fnd_number.number_to_canonical(p_spouse_income),
1346: spouse_deduction = fnd_number.number_to_canonical(p_spouse_deduction),
1347: national_pens_ins_prem = fnd_number.number_to_canonical(p_national_pens_ins_prem),
1348: life_gen_new_ins_prem = fnd_number.number_to_canonical(p_life_gen_new_ins_prem),
1349: life_pens_new_ins_prem = fnd_number.number_to_canonical(p_life_pens_new_ins_prem),
1350: life_gen_new_ins_calc_prem = fnd_number.number_to_canonical(p_life_gen_new_ins_calc_prem),
1351: life_pens_new_ins_calc_prem = fnd_number.number_to_canonical(p_life_pens_new_ins_calc_prem)
1344: sp_income_calc = fnd_number.number_to_canonical(p_sp_income_calc),
1345: spouse_income = fnd_number.number_to_canonical(p_spouse_income),
1346: spouse_deduction = fnd_number.number_to_canonical(p_spouse_deduction),
1347: national_pens_ins_prem = fnd_number.number_to_canonical(p_national_pens_ins_prem),
1348: life_gen_new_ins_prem = fnd_number.number_to_canonical(p_life_gen_new_ins_prem),
1349: life_pens_new_ins_prem = fnd_number.number_to_canonical(p_life_pens_new_ins_prem),
1350: life_gen_new_ins_calc_prem = fnd_number.number_to_canonical(p_life_gen_new_ins_calc_prem),
1351: life_pens_new_ins_calc_prem = fnd_number.number_to_canonical(p_life_pens_new_ins_calc_prem)
1352: where row_id = l_rec.row_id;
1345: spouse_income = fnd_number.number_to_canonical(p_spouse_income),
1346: spouse_deduction = fnd_number.number_to_canonical(p_spouse_deduction),
1347: national_pens_ins_prem = fnd_number.number_to_canonical(p_national_pens_ins_prem),
1348: life_gen_new_ins_prem = fnd_number.number_to_canonical(p_life_gen_new_ins_prem),
1349: life_pens_new_ins_prem = fnd_number.number_to_canonical(p_life_pens_new_ins_prem),
1350: life_gen_new_ins_calc_prem = fnd_number.number_to_canonical(p_life_gen_new_ins_calc_prem),
1351: life_pens_new_ins_calc_prem = fnd_number.number_to_canonical(p_life_pens_new_ins_calc_prem)
1352: where row_id = l_rec.row_id;
1353: --
1346: spouse_deduction = fnd_number.number_to_canonical(p_spouse_deduction),
1347: national_pens_ins_prem = fnd_number.number_to_canonical(p_national_pens_ins_prem),
1348: life_gen_new_ins_prem = fnd_number.number_to_canonical(p_life_gen_new_ins_prem),
1349: life_pens_new_ins_prem = fnd_number.number_to_canonical(p_life_pens_new_ins_prem),
1350: life_gen_new_ins_calc_prem = fnd_number.number_to_canonical(p_life_gen_new_ins_calc_prem),
1351: life_pens_new_ins_calc_prem = fnd_number.number_to_canonical(p_life_pens_new_ins_calc_prem)
1352: where row_id = l_rec.row_id;
1353: --
1354: if g_debug then
1347: national_pens_ins_prem = fnd_number.number_to_canonical(p_national_pens_ins_prem),
1348: life_gen_new_ins_prem = fnd_number.number_to_canonical(p_life_gen_new_ins_prem),
1349: life_pens_new_ins_prem = fnd_number.number_to_canonical(p_life_pens_new_ins_prem),
1350: life_gen_new_ins_calc_prem = fnd_number.number_to_canonical(p_life_gen_new_ins_calc_prem),
1351: life_pens_new_ins_calc_prem = fnd_number.number_to_canonical(p_life_pens_new_ins_calc_prem)
1352: where row_id = l_rec.row_id;
1353: --
1354: if g_debug then
1355: hr_utility.set_location(l_proc,1000);
1400: p_assignment_id,
1401: p_effective_date,
1402: p_action_information_category,
1403: p_status,
1404: fnd_number.number_to_canonical(p_care_med_new_ins_prem),
1405: fnd_number.number_to_canonical(p_care_med_new_ins_calc_prem));
1406: --
1407: if g_debug then
1408: hr_utility.set_location(l_proc,1000);
1401: p_effective_date,
1402: p_action_information_category,
1403: p_status,
1404: fnd_number.number_to_canonical(p_care_med_new_ins_prem),
1405: fnd_number.number_to_canonical(p_care_med_new_ins_calc_prem));
1406: --
1407: if g_debug then
1408: hr_utility.set_location(l_proc,1000);
1409: end if;
1438: --
1439: update pay_jp_isdf_calc_dct_dml_v2
1440: set object_version_number = p_object_version_number,
1441: status = p_status,
1442: care_med_new_ins_prem = fnd_number.number_to_canonical(p_care_med_new_ins_prem),
1443: care_med_new_ins_calc_prem = fnd_number.number_to_canonical(p_care_med_new_ins_calc_prem)
1444: where row_id = l_rec.row_id;
1445: --
1446: if g_debug then
1439: update pay_jp_isdf_calc_dct_dml_v2
1440: set object_version_number = p_object_version_number,
1441: status = p_status,
1442: care_med_new_ins_prem = fnd_number.number_to_canonical(p_care_med_new_ins_prem),
1443: care_med_new_ins_calc_prem = fnd_number.number_to_canonical(p_care_med_new_ins_calc_prem)
1444: where row_id = l_rec.row_id;
1445: --
1446: if g_debug then
1447: hr_utility.set_location(l_proc,1000);
1512: p_assignment_id,
1513: p_effective_date,
1514: p_action_information_category,
1515: p_status,
1516: fnd_number.number_to_canonical(p_assignment_extra_info_id),
1517: fnd_number.number_to_canonical(p_aei_object_version_number),
1518: p_gen_ins_class,
1519: p_gen_ins_company_code,
1520: p_ins_company_name,
1513: p_effective_date,
1514: p_action_information_category,
1515: p_status,
1516: fnd_number.number_to_canonical(p_assignment_extra_info_id),
1517: fnd_number.number_to_canonical(p_aei_object_version_number),
1518: p_gen_ins_class,
1519: p_gen_ins_company_code,
1520: p_ins_company_name,
1521: p_ins_type,
1522: p_ins_period,
1523: p_contractor_name,
1524: p_beneficiary_name,
1525: p_beneficiary_relship,
1526: fnd_number.number_to_canonical(p_annual_prem),
1527: p_gen_ins_old_new);
1528: --
1529: if g_debug then
1530: hr_utility.set_location(l_proc,1000);
1572: ins_period = p_ins_period,
1573: contractor_name = p_contractor_name,
1574: beneficiary_name = p_beneficiary_name,
1575: beneficiary_relship = p_beneficiary_relship,
1576: annual_prem = fnd_number.number_to_canonical(p_annual_prem),
1577: gen_ins_class_old_new = p_ins_old_new
1578: where row_id = l_rec.row_id;
1579: --
1580: if g_debug then
1689: p_assignment_id,
1690: p_effective_date,
1691: p_action_information_category,
1692: p_status,
1693: fnd_number.number_to_canonical(p_assignment_extra_info_id),
1694: fnd_number.number_to_canonical(p_aei_object_version_number),
1695: p_care_ins_class,
1696: p_care_ins_company_code,
1697: p_ins_company_name,
1690: p_effective_date,
1691: p_action_information_category,
1692: p_status,
1693: fnd_number.number_to_canonical(p_assignment_extra_info_id),
1694: fnd_number.number_to_canonical(p_aei_object_version_number),
1695: p_care_ins_class,
1696: p_care_ins_company_code,
1697: p_ins_company_name,
1698: p_ins_type,
1699: p_ins_period,
1700: p_contractor_name,
1701: p_beneficiary_name,
1702: p_beneficiary_relship,
1703: fnd_number.number_to_canonical(p_annual_prem),
1704: p_care_ins_old_new);
1705: --
1706: if g_debug then
1707: hr_utility.set_location(l_proc,1000);
1749: ins_period = p_ins_period,
1750: contractor_name = p_contractor_name,
1751: beneficiary_name = p_beneficiary_name,
1752: beneficiary_relship = p_beneficiary_relship,
1753: annual_prem = fnd_number.number_to_canonical(p_annual_prem),
1754: care_ins_class_old_new = p_ins_old_new
1755: where row_id = l_rec.row_id;
1756: --
1757: if g_debug then
1868: p_assignment_id,
1869: p_effective_date,
1870: p_action_information_category,
1871: p_status,
1872: fnd_number.number_to_canonical(p_assignment_extra_info_id),
1873: fnd_number.number_to_canonical(p_aei_object_version_number),
1874: p_pens_ins_class,
1875: p_pens_ins_company_code,
1876: p_ins_company_name,
1869: p_effective_date,
1870: p_action_information_category,
1871: p_status,
1872: fnd_number.number_to_canonical(p_assignment_extra_info_id),
1873: fnd_number.number_to_canonical(p_aei_object_version_number),
1874: p_pens_ins_class,
1875: p_pens_ins_company_code,
1876: p_ins_company_name,
1877: p_ins_type,
1879: p_ins_period,
1880: p_contractor_name,
1881: p_beneficiary_name,
1882: p_beneficiary_relship,
1883: fnd_number.number_to_canonical(p_annual_prem),
1884: p_pens_ins_old_new);
1885: --
1886: if g_debug then
1887: hr_utility.set_location(l_proc,1000);
1931: ins_period = p_ins_period,
1932: contractor_name = p_contractor_name,
1933: beneficiary_name = p_beneficiary_name,
1934: beneficiary_relship = p_beneficiary_relship,
1935: annual_prem = fnd_number.number_to_canonical(p_annual_prem),
1936: pens_ins_class_old_new = p_ins_old_new
1937: where row_id = l_rec.row_id;
1938: --
1939: if g_debug then
2050: p_assignment_id,
2051: p_effective_date,
2052: p_action_information_category,
2053: p_status,
2054: fnd_number.number_to_canonical(p_assignment_extra_info_id),
2055: fnd_number.number_to_canonical(p_aei_object_version_number),
2056: p_nonlife_ins_class,
2057: p_nonlife_ins_term_type,
2058: p_nonlife_ins_company_code,
2051: p_effective_date,
2052: p_action_information_category,
2053: p_status,
2054: fnd_number.number_to_canonical(p_assignment_extra_info_id),
2055: fnd_number.number_to_canonical(p_aei_object_version_number),
2056: p_nonlife_ins_class,
2057: p_nonlife_ins_term_type,
2058: p_nonlife_ins_company_code,
2059: p_ins_company_name,
2062: p_contractor_name,
2063: p_beneficiary_name,
2064: p_beneficiary_relship,
2065: p_maturity_repayment,
2066: fnd_number.number_to_canonical(p_annual_prem));
2067: --
2068: if g_debug then
2069: hr_utility.set_location(l_proc,1000);
2070: end if;
2113: contractor_name = p_contractor_name,
2114: beneficiary_name = p_beneficiary_name,
2115: beneficiary_relship = p_beneficiary_relship,
2116: maturity_repayment = p_maturity_repayment,
2117: annual_prem = fnd_number.number_to_canonical(p_annual_prem)
2118: where row_id = l_rec.row_id;
2119: --
2120: if g_debug then
2121: hr_utility.set_location(l_proc,1000);
2221: p_ins_type,
2222: p_ins_payee_name,
2223: p_debtor_name,
2224: p_beneficiary_relship,
2225: fnd_number.number_to_canonical(p_annual_prem),
2226: p_national_pens_flag);
2227: --
2228: if g_debug then
2229: hr_utility.set_location(l_proc,1000);
2267: ins_type = p_ins_type,
2268: ins_payee_name = p_ins_payee_name,
2269: debtor_name = p_debtor_name,
2270: beneficiary_relship = p_beneficiary_relship,
2271: annual_prem = fnd_number.number_to_canonical(p_annual_prem),
2272: national_pens_flag = p_national_pens_flag
2273: where row_id = l_rec.row_id;
2274: --
2275: if g_debug then
2366: p_assignment_id,
2367: p_effective_date,
2368: p_action_information_category,
2369: p_status,
2370: fnd_number.number_to_canonical(p_enterprise_contract_prem),
2371: fnd_number.number_to_canonical(p_pension_prem),
2372: fnd_number.number_to_canonical(p_disable_sup_contract_prem));
2373: --
2374: if g_debug then
2367: p_effective_date,
2368: p_action_information_category,
2369: p_status,
2370: fnd_number.number_to_canonical(p_enterprise_contract_prem),
2371: fnd_number.number_to_canonical(p_pension_prem),
2372: fnd_number.number_to_canonical(p_disable_sup_contract_prem));
2373: --
2374: if g_debug then
2375: hr_utility.set_location(l_proc,1000);
2368: p_action_information_category,
2369: p_status,
2370: fnd_number.number_to_canonical(p_enterprise_contract_prem),
2371: fnd_number.number_to_canonical(p_pension_prem),
2372: fnd_number.number_to_canonical(p_disable_sup_contract_prem));
2373: --
2374: if g_debug then
2375: hr_utility.set_location(l_proc,1000);
2376: end if;
2406: --
2407: update pay_jp_isdf_mutual_aid_dml_v
2408: set object_version_number = p_object_version_number,
2409: status = p_status,
2410: enterprise_contract_prem = fnd_number.number_to_canonical(p_enterprise_contract_prem),
2411: pension_prem = fnd_number.number_to_canonical(p_pension_prem),
2412: disable_sup_contract_prem = fnd_number.number_to_canonical(p_disable_sup_contract_prem)
2413: where row_id = l_rec.row_id;
2414: --
2407: update pay_jp_isdf_mutual_aid_dml_v
2408: set object_version_number = p_object_version_number,
2409: status = p_status,
2410: enterprise_contract_prem = fnd_number.number_to_canonical(p_enterprise_contract_prem),
2411: pension_prem = fnd_number.number_to_canonical(p_pension_prem),
2412: disable_sup_contract_prem = fnd_number.number_to_canonical(p_disable_sup_contract_prem)
2413: where row_id = l_rec.row_id;
2414: --
2415: if g_debug then
2408: set object_version_number = p_object_version_number,
2409: status = p_status,
2410: enterprise_contract_prem = fnd_number.number_to_canonical(p_enterprise_contract_prem),
2411: pension_prem = fnd_number.number_to_canonical(p_pension_prem),
2412: disable_sup_contract_prem = fnd_number.number_to_canonical(p_disable_sup_contract_prem)
2413: where row_id = l_rec.row_id;
2414: --
2415: if g_debug then
2416: hr_utility.set_location(l_proc,1000);
2534: --p_last_name,
2535: --p_first_name,
2536: p_postal_code,
2537: p_address,
2538: fnd_number.number_to_canonical(p_emp_income),
2539: p_spouse_type,
2540: p_widow_type,
2541: p_spouse_dct_exclude,
2542: fnd_number.number_to_canonical(p_spouse_income_entry));
2538: fnd_number.number_to_canonical(p_emp_income),
2539: p_spouse_type,
2540: p_widow_type,
2541: p_spouse_dct_exclude,
2542: fnd_number.number_to_canonical(p_spouse_income_entry));
2543: --
2544: if g_debug then
2545: hr_utility.set_location(l_proc,1000);
2546: end if;
2594: --last_name = p_last_name,
2595: --first_name = p_first_name,
2596: postal_code = p_postal_code,
2597: address = p_address,
2598: emp_income = fnd_number.number_to_canonical(p_emp_income),
2599: spouse_type = p_spouse_type,
2600: widow_type = p_widow_type,
2601: spouse_dct_exclude = p_spouse_dct_exclude,
2602: spouse_income_entry = fnd_number.number_to_canonical(p_spouse_income_entry)
2598: emp_income = fnd_number.number_to_canonical(p_emp_income),
2599: spouse_type = p_spouse_type,
2600: widow_type = p_widow_type,
2601: spouse_dct_exclude = p_spouse_dct_exclude,
2602: spouse_income_entry = fnd_number.number_to_canonical(p_spouse_income_entry)
2603: where row_id = l_rec.row_id;
2604: --
2605: if g_debug then
2606: hr_utility.set_location(l_proc,1000);
2724: p_assignment_id,
2725: p_effective_date,
2726: p_action_information_category,
2727: p_status,
2728: fnd_number.number_to_canonical(p_sp_earned_income),
2729: fnd_number.number_to_canonical(p_sp_earned_income_exp),
2730: fnd_number.number_to_canonical(p_sp_business_income),
2731: fnd_number.number_to_canonical(p_sp_business_income_exp),
2732: fnd_number.number_to_canonical(p_sp_miscellaneous_income),
2725: p_effective_date,
2726: p_action_information_category,
2727: p_status,
2728: fnd_number.number_to_canonical(p_sp_earned_income),
2729: fnd_number.number_to_canonical(p_sp_earned_income_exp),
2730: fnd_number.number_to_canonical(p_sp_business_income),
2731: fnd_number.number_to_canonical(p_sp_business_income_exp),
2732: fnd_number.number_to_canonical(p_sp_miscellaneous_income),
2733: fnd_number.number_to_canonical(p_sp_miscellaneous_income_exp),
2726: p_action_information_category,
2727: p_status,
2728: fnd_number.number_to_canonical(p_sp_earned_income),
2729: fnd_number.number_to_canonical(p_sp_earned_income_exp),
2730: fnd_number.number_to_canonical(p_sp_business_income),
2731: fnd_number.number_to_canonical(p_sp_business_income_exp),
2732: fnd_number.number_to_canonical(p_sp_miscellaneous_income),
2733: fnd_number.number_to_canonical(p_sp_miscellaneous_income_exp),
2734: fnd_number.number_to_canonical(p_sp_dividend_income),
2727: p_status,
2728: fnd_number.number_to_canonical(p_sp_earned_income),
2729: fnd_number.number_to_canonical(p_sp_earned_income_exp),
2730: fnd_number.number_to_canonical(p_sp_business_income),
2731: fnd_number.number_to_canonical(p_sp_business_income_exp),
2732: fnd_number.number_to_canonical(p_sp_miscellaneous_income),
2733: fnd_number.number_to_canonical(p_sp_miscellaneous_income_exp),
2734: fnd_number.number_to_canonical(p_sp_dividend_income),
2735: fnd_number.number_to_canonical(p_sp_dividend_income_exp),
2728: fnd_number.number_to_canonical(p_sp_earned_income),
2729: fnd_number.number_to_canonical(p_sp_earned_income_exp),
2730: fnd_number.number_to_canonical(p_sp_business_income),
2731: fnd_number.number_to_canonical(p_sp_business_income_exp),
2732: fnd_number.number_to_canonical(p_sp_miscellaneous_income),
2733: fnd_number.number_to_canonical(p_sp_miscellaneous_income_exp),
2734: fnd_number.number_to_canonical(p_sp_dividend_income),
2735: fnd_number.number_to_canonical(p_sp_dividend_income_exp),
2736: fnd_number.number_to_canonical(p_sp_real_estate_income),
2729: fnd_number.number_to_canonical(p_sp_earned_income_exp),
2730: fnd_number.number_to_canonical(p_sp_business_income),
2731: fnd_number.number_to_canonical(p_sp_business_income_exp),
2732: fnd_number.number_to_canonical(p_sp_miscellaneous_income),
2733: fnd_number.number_to_canonical(p_sp_miscellaneous_income_exp),
2734: fnd_number.number_to_canonical(p_sp_dividend_income),
2735: fnd_number.number_to_canonical(p_sp_dividend_income_exp),
2736: fnd_number.number_to_canonical(p_sp_real_estate_income),
2737: fnd_number.number_to_canonical(p_sp_real_estate_income_exp),
2730: fnd_number.number_to_canonical(p_sp_business_income),
2731: fnd_number.number_to_canonical(p_sp_business_income_exp),
2732: fnd_number.number_to_canonical(p_sp_miscellaneous_income),
2733: fnd_number.number_to_canonical(p_sp_miscellaneous_income_exp),
2734: fnd_number.number_to_canonical(p_sp_dividend_income),
2735: fnd_number.number_to_canonical(p_sp_dividend_income_exp),
2736: fnd_number.number_to_canonical(p_sp_real_estate_income),
2737: fnd_number.number_to_canonical(p_sp_real_estate_income_exp),
2738: fnd_number.number_to_canonical(p_sp_retirement_income),
2731: fnd_number.number_to_canonical(p_sp_business_income_exp),
2732: fnd_number.number_to_canonical(p_sp_miscellaneous_income),
2733: fnd_number.number_to_canonical(p_sp_miscellaneous_income_exp),
2734: fnd_number.number_to_canonical(p_sp_dividend_income),
2735: fnd_number.number_to_canonical(p_sp_dividend_income_exp),
2736: fnd_number.number_to_canonical(p_sp_real_estate_income),
2737: fnd_number.number_to_canonical(p_sp_real_estate_income_exp),
2738: fnd_number.number_to_canonical(p_sp_retirement_income),
2739: fnd_number.number_to_canonical(p_sp_retirement_income_exp),
2732: fnd_number.number_to_canonical(p_sp_miscellaneous_income),
2733: fnd_number.number_to_canonical(p_sp_miscellaneous_income_exp),
2734: fnd_number.number_to_canonical(p_sp_dividend_income),
2735: fnd_number.number_to_canonical(p_sp_dividend_income_exp),
2736: fnd_number.number_to_canonical(p_sp_real_estate_income),
2737: fnd_number.number_to_canonical(p_sp_real_estate_income_exp),
2738: fnd_number.number_to_canonical(p_sp_retirement_income),
2739: fnd_number.number_to_canonical(p_sp_retirement_income_exp),
2740: fnd_number.number_to_canonical(p_sp_other_income),
2733: fnd_number.number_to_canonical(p_sp_miscellaneous_income_exp),
2734: fnd_number.number_to_canonical(p_sp_dividend_income),
2735: fnd_number.number_to_canonical(p_sp_dividend_income_exp),
2736: fnd_number.number_to_canonical(p_sp_real_estate_income),
2737: fnd_number.number_to_canonical(p_sp_real_estate_income_exp),
2738: fnd_number.number_to_canonical(p_sp_retirement_income),
2739: fnd_number.number_to_canonical(p_sp_retirement_income_exp),
2740: fnd_number.number_to_canonical(p_sp_other_income),
2741: fnd_number.number_to_canonical(p_sp_other_income_exp),
2734: fnd_number.number_to_canonical(p_sp_dividend_income),
2735: fnd_number.number_to_canonical(p_sp_dividend_income_exp),
2736: fnd_number.number_to_canonical(p_sp_real_estate_income),
2737: fnd_number.number_to_canonical(p_sp_real_estate_income_exp),
2738: fnd_number.number_to_canonical(p_sp_retirement_income),
2739: fnd_number.number_to_canonical(p_sp_retirement_income_exp),
2740: fnd_number.number_to_canonical(p_sp_other_income),
2741: fnd_number.number_to_canonical(p_sp_other_income_exp),
2742: fnd_number.number_to_canonical(p_sp_other_income_exp_dct),
2735: fnd_number.number_to_canonical(p_sp_dividend_income_exp),
2736: fnd_number.number_to_canonical(p_sp_real_estate_income),
2737: fnd_number.number_to_canonical(p_sp_real_estate_income_exp),
2738: fnd_number.number_to_canonical(p_sp_retirement_income),
2739: fnd_number.number_to_canonical(p_sp_retirement_income_exp),
2740: fnd_number.number_to_canonical(p_sp_other_income),
2741: fnd_number.number_to_canonical(p_sp_other_income_exp),
2742: fnd_number.number_to_canonical(p_sp_other_income_exp_dct),
2743: fnd_number.number_to_canonical(p_sp_other_income_exp_temp),
2736: fnd_number.number_to_canonical(p_sp_real_estate_income),
2737: fnd_number.number_to_canonical(p_sp_real_estate_income_exp),
2738: fnd_number.number_to_canonical(p_sp_retirement_income),
2739: fnd_number.number_to_canonical(p_sp_retirement_income_exp),
2740: fnd_number.number_to_canonical(p_sp_other_income),
2741: fnd_number.number_to_canonical(p_sp_other_income_exp),
2742: fnd_number.number_to_canonical(p_sp_other_income_exp_dct),
2743: fnd_number.number_to_canonical(p_sp_other_income_exp_temp),
2744: fnd_number.number_to_canonical(p_sp_other_income_exp_temp_exp));
2737: fnd_number.number_to_canonical(p_sp_real_estate_income_exp),
2738: fnd_number.number_to_canonical(p_sp_retirement_income),
2739: fnd_number.number_to_canonical(p_sp_retirement_income_exp),
2740: fnd_number.number_to_canonical(p_sp_other_income),
2741: fnd_number.number_to_canonical(p_sp_other_income_exp),
2742: fnd_number.number_to_canonical(p_sp_other_income_exp_dct),
2743: fnd_number.number_to_canonical(p_sp_other_income_exp_temp),
2744: fnd_number.number_to_canonical(p_sp_other_income_exp_temp_exp));
2745: --
2738: fnd_number.number_to_canonical(p_sp_retirement_income),
2739: fnd_number.number_to_canonical(p_sp_retirement_income_exp),
2740: fnd_number.number_to_canonical(p_sp_other_income),
2741: fnd_number.number_to_canonical(p_sp_other_income_exp),
2742: fnd_number.number_to_canonical(p_sp_other_income_exp_dct),
2743: fnd_number.number_to_canonical(p_sp_other_income_exp_temp),
2744: fnd_number.number_to_canonical(p_sp_other_income_exp_temp_exp));
2745: --
2746: if g_debug then
2739: fnd_number.number_to_canonical(p_sp_retirement_income_exp),
2740: fnd_number.number_to_canonical(p_sp_other_income),
2741: fnd_number.number_to_canonical(p_sp_other_income_exp),
2742: fnd_number.number_to_canonical(p_sp_other_income_exp_dct),
2743: fnd_number.number_to_canonical(p_sp_other_income_exp_temp),
2744: fnd_number.number_to_canonical(p_sp_other_income_exp_temp_exp));
2745: --
2746: if g_debug then
2747: hr_utility.set_location(l_proc,1000);
2740: fnd_number.number_to_canonical(p_sp_other_income),
2741: fnd_number.number_to_canonical(p_sp_other_income_exp),
2742: fnd_number.number_to_canonical(p_sp_other_income_exp_dct),
2743: fnd_number.number_to_canonical(p_sp_other_income_exp_temp),
2744: fnd_number.number_to_canonical(p_sp_other_income_exp_temp_exp));
2745: --
2746: if g_debug then
2747: hr_utility.set_location(l_proc,1000);
2748: end if;
2792: --
2793: update pay_jp_isdf_spouse_inc_dml_v
2794: set object_version_number = p_object_version_number,
2795: status = p_status,
2796: sp_earned_income = fnd_number.number_to_canonical(p_sp_earned_income),
2797: sp_earned_income_exp = fnd_number.number_to_canonical(p_sp_earned_income_exp),
2798: sp_business_income = fnd_number.number_to_canonical(p_sp_business_income),
2799: sp_business_income_exp = fnd_number.number_to_canonical(p_sp_business_income_exp),
2800: sp_miscellaneous_income = fnd_number.number_to_canonical(p_sp_miscellaneous_income),
2793: update pay_jp_isdf_spouse_inc_dml_v
2794: set object_version_number = p_object_version_number,
2795: status = p_status,
2796: sp_earned_income = fnd_number.number_to_canonical(p_sp_earned_income),
2797: sp_earned_income_exp = fnd_number.number_to_canonical(p_sp_earned_income_exp),
2798: sp_business_income = fnd_number.number_to_canonical(p_sp_business_income),
2799: sp_business_income_exp = fnd_number.number_to_canonical(p_sp_business_income_exp),
2800: sp_miscellaneous_income = fnd_number.number_to_canonical(p_sp_miscellaneous_income),
2801: sp_miscellaneous_income_exp = fnd_number.number_to_canonical(p_sp_miscellaneous_income_exp),
2794: set object_version_number = p_object_version_number,
2795: status = p_status,
2796: sp_earned_income = fnd_number.number_to_canonical(p_sp_earned_income),
2797: sp_earned_income_exp = fnd_number.number_to_canonical(p_sp_earned_income_exp),
2798: sp_business_income = fnd_number.number_to_canonical(p_sp_business_income),
2799: sp_business_income_exp = fnd_number.number_to_canonical(p_sp_business_income_exp),
2800: sp_miscellaneous_income = fnd_number.number_to_canonical(p_sp_miscellaneous_income),
2801: sp_miscellaneous_income_exp = fnd_number.number_to_canonical(p_sp_miscellaneous_income_exp),
2802: sp_dividend_income = fnd_number.number_to_canonical(p_sp_dividend_income),
2795: status = p_status,
2796: sp_earned_income = fnd_number.number_to_canonical(p_sp_earned_income),
2797: sp_earned_income_exp = fnd_number.number_to_canonical(p_sp_earned_income_exp),
2798: sp_business_income = fnd_number.number_to_canonical(p_sp_business_income),
2799: sp_business_income_exp = fnd_number.number_to_canonical(p_sp_business_income_exp),
2800: sp_miscellaneous_income = fnd_number.number_to_canonical(p_sp_miscellaneous_income),
2801: sp_miscellaneous_income_exp = fnd_number.number_to_canonical(p_sp_miscellaneous_income_exp),
2802: sp_dividend_income = fnd_number.number_to_canonical(p_sp_dividend_income),
2803: sp_dividend_income_exp = fnd_number.number_to_canonical(p_sp_dividend_income_exp),
2796: sp_earned_income = fnd_number.number_to_canonical(p_sp_earned_income),
2797: sp_earned_income_exp = fnd_number.number_to_canonical(p_sp_earned_income_exp),
2798: sp_business_income = fnd_number.number_to_canonical(p_sp_business_income),
2799: sp_business_income_exp = fnd_number.number_to_canonical(p_sp_business_income_exp),
2800: sp_miscellaneous_income = fnd_number.number_to_canonical(p_sp_miscellaneous_income),
2801: sp_miscellaneous_income_exp = fnd_number.number_to_canonical(p_sp_miscellaneous_income_exp),
2802: sp_dividend_income = fnd_number.number_to_canonical(p_sp_dividend_income),
2803: sp_dividend_income_exp = fnd_number.number_to_canonical(p_sp_dividend_income_exp),
2804: sp_real_estate_income = fnd_number.number_to_canonical(p_sp_real_estate_income),
2797: sp_earned_income_exp = fnd_number.number_to_canonical(p_sp_earned_income_exp),
2798: sp_business_income = fnd_number.number_to_canonical(p_sp_business_income),
2799: sp_business_income_exp = fnd_number.number_to_canonical(p_sp_business_income_exp),
2800: sp_miscellaneous_income = fnd_number.number_to_canonical(p_sp_miscellaneous_income),
2801: sp_miscellaneous_income_exp = fnd_number.number_to_canonical(p_sp_miscellaneous_income_exp),
2802: sp_dividend_income = fnd_number.number_to_canonical(p_sp_dividend_income),
2803: sp_dividend_income_exp = fnd_number.number_to_canonical(p_sp_dividend_income_exp),
2804: sp_real_estate_income = fnd_number.number_to_canonical(p_sp_real_estate_income),
2805: sp_real_estate_income_exp = fnd_number.number_to_canonical(p_sp_real_estate_income_exp),
2798: sp_business_income = fnd_number.number_to_canonical(p_sp_business_income),
2799: sp_business_income_exp = fnd_number.number_to_canonical(p_sp_business_income_exp),
2800: sp_miscellaneous_income = fnd_number.number_to_canonical(p_sp_miscellaneous_income),
2801: sp_miscellaneous_income_exp = fnd_number.number_to_canonical(p_sp_miscellaneous_income_exp),
2802: sp_dividend_income = fnd_number.number_to_canonical(p_sp_dividend_income),
2803: sp_dividend_income_exp = fnd_number.number_to_canonical(p_sp_dividend_income_exp),
2804: sp_real_estate_income = fnd_number.number_to_canonical(p_sp_real_estate_income),
2805: sp_real_estate_income_exp = fnd_number.number_to_canonical(p_sp_real_estate_income_exp),
2806: sp_retirement_income = fnd_number.number_to_canonical(p_sp_retirement_income),
2799: sp_business_income_exp = fnd_number.number_to_canonical(p_sp_business_income_exp),
2800: sp_miscellaneous_income = fnd_number.number_to_canonical(p_sp_miscellaneous_income),
2801: sp_miscellaneous_income_exp = fnd_number.number_to_canonical(p_sp_miscellaneous_income_exp),
2802: sp_dividend_income = fnd_number.number_to_canonical(p_sp_dividend_income),
2803: sp_dividend_income_exp = fnd_number.number_to_canonical(p_sp_dividend_income_exp),
2804: sp_real_estate_income = fnd_number.number_to_canonical(p_sp_real_estate_income),
2805: sp_real_estate_income_exp = fnd_number.number_to_canonical(p_sp_real_estate_income_exp),
2806: sp_retirement_income = fnd_number.number_to_canonical(p_sp_retirement_income),
2807: sp_retirement_income_exp = fnd_number.number_to_canonical(p_sp_retirement_income_exp),
2800: sp_miscellaneous_income = fnd_number.number_to_canonical(p_sp_miscellaneous_income),
2801: sp_miscellaneous_income_exp = fnd_number.number_to_canonical(p_sp_miscellaneous_income_exp),
2802: sp_dividend_income = fnd_number.number_to_canonical(p_sp_dividend_income),
2803: sp_dividend_income_exp = fnd_number.number_to_canonical(p_sp_dividend_income_exp),
2804: sp_real_estate_income = fnd_number.number_to_canonical(p_sp_real_estate_income),
2805: sp_real_estate_income_exp = fnd_number.number_to_canonical(p_sp_real_estate_income_exp),
2806: sp_retirement_income = fnd_number.number_to_canonical(p_sp_retirement_income),
2807: sp_retirement_income_exp = fnd_number.number_to_canonical(p_sp_retirement_income_exp),
2808: sp_other_income = fnd_number.number_to_canonical(p_sp_other_income),
2801: sp_miscellaneous_income_exp = fnd_number.number_to_canonical(p_sp_miscellaneous_income_exp),
2802: sp_dividend_income = fnd_number.number_to_canonical(p_sp_dividend_income),
2803: sp_dividend_income_exp = fnd_number.number_to_canonical(p_sp_dividend_income_exp),
2804: sp_real_estate_income = fnd_number.number_to_canonical(p_sp_real_estate_income),
2805: sp_real_estate_income_exp = fnd_number.number_to_canonical(p_sp_real_estate_income_exp),
2806: sp_retirement_income = fnd_number.number_to_canonical(p_sp_retirement_income),
2807: sp_retirement_income_exp = fnd_number.number_to_canonical(p_sp_retirement_income_exp),
2808: sp_other_income = fnd_number.number_to_canonical(p_sp_other_income),
2809: sp_other_income_exp = fnd_number.number_to_canonical(p_sp_other_income_exp),
2802: sp_dividend_income = fnd_number.number_to_canonical(p_sp_dividend_income),
2803: sp_dividend_income_exp = fnd_number.number_to_canonical(p_sp_dividend_income_exp),
2804: sp_real_estate_income = fnd_number.number_to_canonical(p_sp_real_estate_income),
2805: sp_real_estate_income_exp = fnd_number.number_to_canonical(p_sp_real_estate_income_exp),
2806: sp_retirement_income = fnd_number.number_to_canonical(p_sp_retirement_income),
2807: sp_retirement_income_exp = fnd_number.number_to_canonical(p_sp_retirement_income_exp),
2808: sp_other_income = fnd_number.number_to_canonical(p_sp_other_income),
2809: sp_other_income_exp = fnd_number.number_to_canonical(p_sp_other_income_exp),
2810: sp_other_income_exp_dct = fnd_number.number_to_canonical(p_sp_other_income_exp_dct),
2803: sp_dividend_income_exp = fnd_number.number_to_canonical(p_sp_dividend_income_exp),
2804: sp_real_estate_income = fnd_number.number_to_canonical(p_sp_real_estate_income),
2805: sp_real_estate_income_exp = fnd_number.number_to_canonical(p_sp_real_estate_income_exp),
2806: sp_retirement_income = fnd_number.number_to_canonical(p_sp_retirement_income),
2807: sp_retirement_income_exp = fnd_number.number_to_canonical(p_sp_retirement_income_exp),
2808: sp_other_income = fnd_number.number_to_canonical(p_sp_other_income),
2809: sp_other_income_exp = fnd_number.number_to_canonical(p_sp_other_income_exp),
2810: sp_other_income_exp_dct = fnd_number.number_to_canonical(p_sp_other_income_exp_dct),
2811: sp_other_income_exp_temp = fnd_number.number_to_canonical(p_sp_other_income_exp_temp),
2804: sp_real_estate_income = fnd_number.number_to_canonical(p_sp_real_estate_income),
2805: sp_real_estate_income_exp = fnd_number.number_to_canonical(p_sp_real_estate_income_exp),
2806: sp_retirement_income = fnd_number.number_to_canonical(p_sp_retirement_income),
2807: sp_retirement_income_exp = fnd_number.number_to_canonical(p_sp_retirement_income_exp),
2808: sp_other_income = fnd_number.number_to_canonical(p_sp_other_income),
2809: sp_other_income_exp = fnd_number.number_to_canonical(p_sp_other_income_exp),
2810: sp_other_income_exp_dct = fnd_number.number_to_canonical(p_sp_other_income_exp_dct),
2811: sp_other_income_exp_temp = fnd_number.number_to_canonical(p_sp_other_income_exp_temp),
2812: sp_other_income_exp_temp_exp = fnd_number.number_to_canonical(p_sp_other_income_exp_temp_exp)
2805: sp_real_estate_income_exp = fnd_number.number_to_canonical(p_sp_real_estate_income_exp),
2806: sp_retirement_income = fnd_number.number_to_canonical(p_sp_retirement_income),
2807: sp_retirement_income_exp = fnd_number.number_to_canonical(p_sp_retirement_income_exp),
2808: sp_other_income = fnd_number.number_to_canonical(p_sp_other_income),
2809: sp_other_income_exp = fnd_number.number_to_canonical(p_sp_other_income_exp),
2810: sp_other_income_exp_dct = fnd_number.number_to_canonical(p_sp_other_income_exp_dct),
2811: sp_other_income_exp_temp = fnd_number.number_to_canonical(p_sp_other_income_exp_temp),
2812: sp_other_income_exp_temp_exp = fnd_number.number_to_canonical(p_sp_other_income_exp_temp_exp)
2813: where row_id = l_rec.row_id;
2806: sp_retirement_income = fnd_number.number_to_canonical(p_sp_retirement_income),
2807: sp_retirement_income_exp = fnd_number.number_to_canonical(p_sp_retirement_income_exp),
2808: sp_other_income = fnd_number.number_to_canonical(p_sp_other_income),
2809: sp_other_income_exp = fnd_number.number_to_canonical(p_sp_other_income_exp),
2810: sp_other_income_exp_dct = fnd_number.number_to_canonical(p_sp_other_income_exp_dct),
2811: sp_other_income_exp_temp = fnd_number.number_to_canonical(p_sp_other_income_exp_temp),
2812: sp_other_income_exp_temp_exp = fnd_number.number_to_canonical(p_sp_other_income_exp_temp_exp)
2813: where row_id = l_rec.row_id;
2814: --
2807: sp_retirement_income_exp = fnd_number.number_to_canonical(p_sp_retirement_income_exp),
2808: sp_other_income = fnd_number.number_to_canonical(p_sp_other_income),
2809: sp_other_income_exp = fnd_number.number_to_canonical(p_sp_other_income_exp),
2810: sp_other_income_exp_dct = fnd_number.number_to_canonical(p_sp_other_income_exp_dct),
2811: sp_other_income_exp_temp = fnd_number.number_to_canonical(p_sp_other_income_exp_temp),
2812: sp_other_income_exp_temp_exp = fnd_number.number_to_canonical(p_sp_other_income_exp_temp_exp)
2813: where row_id = l_rec.row_id;
2814: --
2815: if g_debug then
2808: sp_other_income = fnd_number.number_to_canonical(p_sp_other_income),
2809: sp_other_income_exp = fnd_number.number_to_canonical(p_sp_other_income_exp),
2810: sp_other_income_exp_dct = fnd_number.number_to_canonical(p_sp_other_income_exp_dct),
2811: sp_other_income_exp_temp = fnd_number.number_to_canonical(p_sp_other_income_exp_temp),
2812: sp_other_income_exp_temp_exp = fnd_number.number_to_canonical(p_sp_other_income_exp_temp_exp)
2813: where row_id = l_rec.row_id;
2814: --
2815: if g_debug then
2816: hr_utility.set_location(l_proc,1000);