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

APPS.PAY_JP_ISDF_ARCHIVE_PKG dependencies on FND_NUMBER

Line 118: g_payroll_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAYROLL_ID',l_csr_action.legislative_parameters));

114: g_payroll_action_id := p_payroll_action_id;
115: g_effective_date := l_csr_action.effective_date;
116: g_business_group_id := l_csr_action.business_group_id;
117: g_legislation_code := l_csr_action.legislation_code;
118: g_payroll_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAYROLL_ID',l_csr_action.legislative_parameters));
119: g_organization_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ORGANIZATION_ID',l_csr_action.legislative_parameters));
120: g_assignment_set_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',l_csr_action.legislative_parameters));
121: g_process_assignments_flag := pay_core_utils.get_parameter('PROCESS_ASSIGNMENTS_FLAG',l_csr_action.legislative_parameters);
122: g_archive_default_flag := pay_core_utils.get_parameter('ARCHIVE_DEFAULT_FLAG',l_csr_action.legislative_parameters);

Line 119: g_organization_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ORGANIZATION_ID',l_csr_action.legislative_parameters));

115: g_effective_date := l_csr_action.effective_date;
116: g_business_group_id := l_csr_action.business_group_id;
117: g_legislation_code := l_csr_action.legislation_code;
118: g_payroll_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAYROLL_ID',l_csr_action.legislative_parameters));
119: g_organization_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ORGANIZATION_ID',l_csr_action.legislative_parameters));
120: g_assignment_set_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',l_csr_action.legislative_parameters));
121: g_process_assignments_flag := pay_core_utils.get_parameter('PROCESS_ASSIGNMENTS_FLAG',l_csr_action.legislative_parameters);
122: g_archive_default_flag := pay_core_utils.get_parameter('ARCHIVE_DEFAULT_FLAG',l_csr_action.legislative_parameters);
123: g_copy_archive_pact_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('COPY_ARCHIVE_PACT_ID',l_csr_action.legislative_parameters));

Line 120: g_assignment_set_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',l_csr_action.legislative_parameters));

116: g_business_group_id := l_csr_action.business_group_id;
117: g_legislation_code := l_csr_action.legislation_code;
118: g_payroll_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAYROLL_ID',l_csr_action.legislative_parameters));
119: g_organization_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ORGANIZATION_ID',l_csr_action.legislative_parameters));
120: g_assignment_set_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',l_csr_action.legislative_parameters));
121: g_process_assignments_flag := pay_core_utils.get_parameter('PROCESS_ASSIGNMENTS_FLAG',l_csr_action.legislative_parameters);
122: g_archive_default_flag := pay_core_utils.get_parameter('ARCHIVE_DEFAULT_FLAG',l_csr_action.legislative_parameters);
123: g_copy_archive_pact_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('COPY_ARCHIVE_PACT_ID',l_csr_action.legislative_parameters));
124: --

Line 123: g_copy_archive_pact_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('COPY_ARCHIVE_PACT_ID',l_csr_action.legislative_parameters));

119: g_organization_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ORGANIZATION_ID',l_csr_action.legislative_parameters));
120: g_assignment_set_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',l_csr_action.legislative_parameters));
121: g_process_assignments_flag := pay_core_utils.get_parameter('PROCESS_ASSIGNMENTS_FLAG',l_csr_action.legislative_parameters);
122: g_archive_default_flag := pay_core_utils.get_parameter('ARCHIVE_DEFAULT_FLAG',l_csr_action.legislative_parameters);
123: g_copy_archive_pact_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('COPY_ARCHIVE_PACT_ID',l_csr_action.legislative_parameters));
124: --
125: open csr_bg_itax_dpnt_ref_type;
126: fetch csr_bg_itax_dpnt_ref_type into g_bg_itax_dpnt_ref_type;
127: close csr_bg_itax_dpnt_ref_type;

Line 435: pay_balance_pkg.set_context('ASSIGNMENT_ID',fnd_number.number_to_canonical(l_assignment_id));

431: hr_utility.set_location(l_proc,50);
432: end if;
433: --
434: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(g_effective_date));
435: pay_balance_pkg.set_context('ASSIGNMENT_ID',fnd_number.number_to_canonical(l_assignment_id));
436: l_organization_id := pay_balance_pkg.run_db_item(c_org_iv_name,g_business_group_id,g_legislation_code);
437: --
438: if g_debug and l_debug_cnt < 1 then
439: l_debug_cnt := l_debug_cnt + 1;

Line 610: l_inputs(i).value := fnd_number.number_to_canonical(g_business_group_id);

606: --
607: for i in l_inputs.first..l_inputs.last loop
608: --
609: if l_inputs(i).name = 'BUSINESS_GROUP_ID' then
610: l_inputs(i).value := fnd_number.number_to_canonical(g_business_group_id);
611: elsif l_inputs(i).name = 'PAYROLL_ID' then
612: l_inputs(i).value := fnd_number.number_to_canonical(g_payroll_id);
613: elsif l_inputs(i).name = 'PAYROLL_ACTION_ID' then
614: l_inputs(i).value := fnd_number.number_to_canonical(g_payroll_action_id);

Line 612: l_inputs(i).value := fnd_number.number_to_canonical(g_payroll_id);

608: --
609: if l_inputs(i).name = 'BUSINESS_GROUP_ID' then
610: l_inputs(i).value := fnd_number.number_to_canonical(g_business_group_id);
611: elsif l_inputs(i).name = 'PAYROLL_ID' then
612: l_inputs(i).value := fnd_number.number_to_canonical(g_payroll_id);
613: elsif l_inputs(i).name = 'PAYROLL_ACTION_ID' then
614: l_inputs(i).value := fnd_number.number_to_canonical(g_payroll_action_id);
615: elsif l_inputs(i).name = 'ASSIGNMENT_ID' then
616: l_inputs(i).value := fnd_number.number_to_canonical(g_assignment_id);

Line 614: l_inputs(i).value := fnd_number.number_to_canonical(g_payroll_action_id);

610: l_inputs(i).value := fnd_number.number_to_canonical(g_business_group_id);
611: elsif l_inputs(i).name = 'PAYROLL_ID' then
612: l_inputs(i).value := fnd_number.number_to_canonical(g_payroll_id);
613: elsif l_inputs(i).name = 'PAYROLL_ACTION_ID' then
614: l_inputs(i).value := fnd_number.number_to_canonical(g_payroll_action_id);
615: elsif l_inputs(i).name = 'ASSIGNMENT_ID' then
616: l_inputs(i).value := fnd_number.number_to_canonical(g_assignment_id);
617: elsif l_inputs(i).name = 'ASSIGNMENT_ACTION_ID' then
618: l_inputs(i).value := fnd_number.number_to_canonical(g_assignment_action_id);

Line 616: l_inputs(i).value := fnd_number.number_to_canonical(g_assignment_id);

612: l_inputs(i).value := fnd_number.number_to_canonical(g_payroll_id);
613: elsif l_inputs(i).name = 'PAYROLL_ACTION_ID' then
614: l_inputs(i).value := fnd_number.number_to_canonical(g_payroll_action_id);
615: elsif l_inputs(i).name = 'ASSIGNMENT_ID' then
616: l_inputs(i).value := fnd_number.number_to_canonical(g_assignment_id);
617: elsif l_inputs(i).name = 'ASSIGNMENT_ACTION_ID' then
618: l_inputs(i).value := fnd_number.number_to_canonical(g_assignment_action_id);
619: elsif l_inputs(i).name = 'DATE_EARNED' then
620: l_inputs(i).value := fnd_date.date_to_canonical(g_effective_date);

Line 618: l_inputs(i).value := fnd_number.number_to_canonical(g_assignment_action_id);

614: l_inputs(i).value := fnd_number.number_to_canonical(g_payroll_action_id);
615: elsif l_inputs(i).name = 'ASSIGNMENT_ID' then
616: l_inputs(i).value := fnd_number.number_to_canonical(g_assignment_id);
617: elsif l_inputs(i).name = 'ASSIGNMENT_ACTION_ID' then
618: l_inputs(i).value := fnd_number.number_to_canonical(g_assignment_action_id);
619: elsif l_inputs(i).name = 'DATE_EARNED' then
620: l_inputs(i).value := fnd_date.date_to_canonical(g_effective_date);
621: --
622: elsif l_inputs(i).name = 'I_ASSIGNMENT_ID' then

Line 623: l_inputs(i).value := fnd_number.number_to_canonical(g_assignment_id);

619: elsif l_inputs(i).name = 'DATE_EARNED' then
620: l_inputs(i).value := fnd_date.date_to_canonical(g_effective_date);
621: --
622: elsif l_inputs(i).name = 'I_ASSIGNMENT_ID' then
623: l_inputs(i).value := fnd_number.number_to_canonical(g_assignment_id);
624: elsif l_inputs(i).name = 'I_ASSIGNMENT_ACTION_ID' then
625: l_inputs(i).value := fnd_number.number_to_canonical(g_assignment_action_id);
626: elsif l_inputs(i).name = 'I_INFO_TYPE' then
627: l_inputs(i).value := p_ins_info_rec.info_type;

Line 625: l_inputs(i).value := fnd_number.number_to_canonical(g_assignment_action_id);

621: --
622: elsif l_inputs(i).name = 'I_ASSIGNMENT_ID' then
623: l_inputs(i).value := fnd_number.number_to_canonical(g_assignment_id);
624: elsif l_inputs(i).name = 'I_ASSIGNMENT_ACTION_ID' then
625: l_inputs(i).value := fnd_number.number_to_canonical(g_assignment_action_id);
626: elsif l_inputs(i).name = 'I_INFO_TYPE' then
627: l_inputs(i).value := p_ins_info_rec.info_type;
628: elsif l_inputs(i).name = 'I_INS_CLASS' then
629: l_inputs(i).value := p_ins_info_rec.ins_class;

Line 651: l_inputs(i).value := fnd_number.number_to_canonical(p_ins_info_rec.linc_prem);

647: l_inputs(i).value := p_ins_info_rec.cmi_prem_mth_ele;
648: elsif l_inputs(i).name = 'I_CMI_PREM_BON_ELE' then
649: l_inputs(i).value := p_ins_info_rec.cmi_prem_bon_ele;
650: elsif l_inputs(i).name = 'I_LINC_PREM' then
651: l_inputs(i).value := fnd_number.number_to_canonical(p_ins_info_rec.linc_prem);
652: end if;
653: --
654: end loop;
655: --

Line 694: p_lig_prem := fnd_number.canonical_to_number(ltrim(rtrim(l_outputs(j).value)));

690: --
691: for j in l_outputs.first..l_outputs.last loop
692: --
693: if l_outputs(j).name = 'O_LIG_PREM' then
694: p_lig_prem := fnd_number.canonical_to_number(ltrim(rtrim(l_outputs(j).value)));
695: elsif l_outputs(j).name = 'O_LIP_PREM' then
696: p_lip_prem := fnd_number.canonical_to_number(ltrim(rtrim(l_outputs(j).value)));
697: elsif l_outputs(j).name = 'O_CMI_PREM' then
698: p_cmi_prem := fnd_number.canonical_to_number(ltrim(rtrim(l_outputs(j).value)));

Line 696: p_lip_prem := fnd_number.canonical_to_number(ltrim(rtrim(l_outputs(j).value)));

692: --
693: if l_outputs(j).name = 'O_LIG_PREM' then
694: p_lig_prem := fnd_number.canonical_to_number(ltrim(rtrim(l_outputs(j).value)));
695: elsif l_outputs(j).name = 'O_LIP_PREM' then
696: p_lip_prem := fnd_number.canonical_to_number(ltrim(rtrim(l_outputs(j).value)));
697: elsif l_outputs(j).name = 'O_CMI_PREM' then
698: p_cmi_prem := fnd_number.canonical_to_number(ltrim(rtrim(l_outputs(j).value)));
699: elsif l_outputs(j).name = 'O_MESSAGE' then
700: p_message := ltrim(rtrim(l_outputs(j).value));

Line 698: p_cmi_prem := fnd_number.canonical_to_number(ltrim(rtrim(l_outputs(j).value)));

694: p_lig_prem := fnd_number.canonical_to_number(ltrim(rtrim(l_outputs(j).value)));
695: elsif l_outputs(j).name = 'O_LIP_PREM' then
696: p_lip_prem := fnd_number.canonical_to_number(ltrim(rtrim(l_outputs(j).value)));
697: elsif l_outputs(j).name = 'O_CMI_PREM' then
698: p_cmi_prem := fnd_number.canonical_to_number(ltrim(rtrim(l_outputs(j).value)));
699: elsif l_outputs(j).name = 'O_MESSAGE' then
700: p_message := ltrim(rtrim(l_outputs(j).value));
701: end if;
702: --

Line 719: fnd_file.put_line(fnd_file.output,'Assignment Id : '||fnd_number.number_to_canonical(g_assignment_id));

715: if g_debug then
716: hr_utility.set_location(l_proc,60);
717: end if;
718: --
719: fnd_file.put_line(fnd_file.output,'Assignment Id : '||fnd_number.number_to_canonical(g_assignment_id));
720: fnd_file.put_line(fnd_file.output,'----------------------------------------------------------------------------------------------------');
721: fnd_file.put_line(fnd_file.output,p_message);
722: fnd_file.put_line(fnd_file.output,' ');
723: --

Line 798: l_inputs(i).value := fnd_number.number_to_canonical(g_business_group_id);

794: --
795: for i in l_inputs.first..l_inputs.last loop
796: --
797: if l_inputs(i).name = 'BUSINESS_GROUP_ID' then
798: l_inputs(i).value := fnd_number.number_to_canonical(g_business_group_id);
799: elsif l_inputs(i).name = 'PAYROLL_ID' then
800: l_inputs(i).value := fnd_number.number_to_canonical(g_payroll_id);
801: elsif l_inputs(i).name = 'PAYROLL_ACTION_ID' then
802: l_inputs(i).value := fnd_number.number_to_canonical(g_payroll_action_id);

Line 800: l_inputs(i).value := fnd_number.number_to_canonical(g_payroll_id);

796: --
797: if l_inputs(i).name = 'BUSINESS_GROUP_ID' then
798: l_inputs(i).value := fnd_number.number_to_canonical(g_business_group_id);
799: elsif l_inputs(i).name = 'PAYROLL_ID' then
800: l_inputs(i).value := fnd_number.number_to_canonical(g_payroll_id);
801: elsif l_inputs(i).name = 'PAYROLL_ACTION_ID' then
802: l_inputs(i).value := fnd_number.number_to_canonical(g_payroll_action_id);
803: elsif l_inputs(i).name = 'ASSIGNMENT_ID' then
804: l_inputs(i).value := fnd_number.number_to_canonical(g_assignment_id);

Line 802: l_inputs(i).value := fnd_number.number_to_canonical(g_payroll_action_id);

798: l_inputs(i).value := fnd_number.number_to_canonical(g_business_group_id);
799: elsif l_inputs(i).name = 'PAYROLL_ID' then
800: l_inputs(i).value := fnd_number.number_to_canonical(g_payroll_id);
801: elsif l_inputs(i).name = 'PAYROLL_ACTION_ID' then
802: l_inputs(i).value := fnd_number.number_to_canonical(g_payroll_action_id);
803: elsif l_inputs(i).name = 'ASSIGNMENT_ID' then
804: l_inputs(i).value := fnd_number.number_to_canonical(g_assignment_id);
805: elsif l_inputs(i).name = 'ASSIGNMENT_ACTION_ID' then
806: l_inputs(i).value := fnd_number.number_to_canonical(g_assignment_action_id);

Line 804: l_inputs(i).value := fnd_number.number_to_canonical(g_assignment_id);

800: l_inputs(i).value := fnd_number.number_to_canonical(g_payroll_id);
801: elsif l_inputs(i).name = 'PAYROLL_ACTION_ID' then
802: l_inputs(i).value := fnd_number.number_to_canonical(g_payroll_action_id);
803: elsif l_inputs(i).name = 'ASSIGNMENT_ID' then
804: l_inputs(i).value := fnd_number.number_to_canonical(g_assignment_id);
805: elsif l_inputs(i).name = 'ASSIGNMENT_ACTION_ID' then
806: l_inputs(i).value := fnd_number.number_to_canonical(g_assignment_action_id);
807: elsif l_inputs(i).name = 'DATE_EARNED' then
808: l_inputs(i).value := fnd_date.date_to_canonical(g_effective_date);

Line 806: l_inputs(i).value := fnd_number.number_to_canonical(g_assignment_action_id);

802: l_inputs(i).value := fnd_number.number_to_canonical(g_payroll_action_id);
803: elsif l_inputs(i).name = 'ASSIGNMENT_ID' then
804: l_inputs(i).value := fnd_number.number_to_canonical(g_assignment_id);
805: elsif l_inputs(i).name = 'ASSIGNMENT_ACTION_ID' then
806: l_inputs(i).value := fnd_number.number_to_canonical(g_assignment_action_id);
807: elsif l_inputs(i).name = 'DATE_EARNED' then
808: l_inputs(i).value := fnd_date.date_to_canonical(g_effective_date);
809: --
810: elsif l_inputs(i).name = 'I_ASSIGNMENT_ID' then

Line 811: l_inputs(i).value := fnd_number.number_to_canonical(g_assignment_id);

807: elsif l_inputs(i).name = 'DATE_EARNED' then
808: l_inputs(i).value := fnd_date.date_to_canonical(g_effective_date);
809: --
810: elsif l_inputs(i).name = 'I_ASSIGNMENT_ID' then
811: l_inputs(i).value := fnd_number.number_to_canonical(g_assignment_id);
812: elsif l_inputs(i).name = 'I_ASSIGNMENT_ACTION_ID' then
813: l_inputs(i).value := fnd_number.number_to_canonical(g_assignment_action_id);
814: elsif l_inputs(i).name = 'I_INFO_TYPE' then
815: l_inputs(i).value := p_ins_info_rec.info_type;

Line 813: l_inputs(i).value := fnd_number.number_to_canonical(g_assignment_action_id);

809: --
810: elsif l_inputs(i).name = 'I_ASSIGNMENT_ID' then
811: l_inputs(i).value := fnd_number.number_to_canonical(g_assignment_id);
812: elsif l_inputs(i).name = 'I_ASSIGNMENT_ACTION_ID' then
813: l_inputs(i).value := fnd_number.number_to_canonical(g_assignment_action_id);
814: elsif l_inputs(i).name = 'I_INFO_TYPE' then
815: l_inputs(i).value := p_ins_info_rec.info_type;
816: elsif l_inputs(i).name = 'I_INS_CLASS' then
817: l_inputs(i).value := p_ins_info_rec.ins_class;

Line 835: l_inputs(i).value := fnd_number.number_to_canonical(p_ins_info_rec.annual_prem);

831: l_inputs(i).value := p_ins_info_rec.ai_prem_mth_ele;
832: elsif l_inputs(i).name = 'I_AI_PREM_BON_ELE' then
833: l_inputs(i).value := p_ins_info_rec.ai_prem_bon_ele;
834: elsif l_inputs(i).name = 'I_AI_PREM' then
835: l_inputs(i).value := fnd_number.number_to_canonical(p_ins_info_rec.annual_prem);
836: end if;
837: --
838: end loop;
839: --

Line 875: p_eqi_prem := fnd_number.canonical_to_number(ltrim(rtrim(l_outputs(j).value)));

871: --
872: for j in l_outputs.first..l_outputs.last loop
873: --
874: if l_outputs(j).name = 'O_EQI_PREM' then
875: p_eqi_prem := fnd_number.canonical_to_number(ltrim(rtrim(l_outputs(j).value)));
876: elsif l_outputs(j).name = 'O_AI_PREM' then
877: p_ai_prem := fnd_number.canonical_to_number(ltrim(rtrim(l_outputs(j).value)));
878: elsif l_outputs(j).name = 'O_MESSAGE' then
879: p_message := ltrim(rtrim(l_outputs(j).value));

Line 877: p_ai_prem := fnd_number.canonical_to_number(ltrim(rtrim(l_outputs(j).value)));

873: --
874: if l_outputs(j).name = 'O_EQI_PREM' then
875: p_eqi_prem := fnd_number.canonical_to_number(ltrim(rtrim(l_outputs(j).value)));
876: elsif l_outputs(j).name = 'O_AI_PREM' then
877: p_ai_prem := fnd_number.canonical_to_number(ltrim(rtrim(l_outputs(j).value)));
878: elsif l_outputs(j).name = 'O_MESSAGE' then
879: p_message := ltrim(rtrim(l_outputs(j).value));
880: end if;
881: --

Line 897: fnd_file.put_line(fnd_file.output,'Assignment Id : '||fnd_number.number_to_canonical(g_assignment_id));

893: if g_debug then
894: hr_utility.set_location(l_proc,60);
895: end if;
896: --
897: fnd_file.put_line(fnd_file.output,'Assignment Id : '||fnd_number.number_to_canonical(g_assignment_id));
898: fnd_file.put_line(fnd_file.output,'----------------------------------------------------------------------------------------------------');
899: fnd_file.put_line(fnd_file.output,p_message);
900: fnd_file.put_line(fnd_file.output,' ');
901: --

Line 1051: p_entry_rec.life_gen_ins_prem := fnd_number.canonical_to_number(l_csr_entry.screen_entry_value);

1047: end if;
1048: --
1049: if l_csr_entry.input_value_id = c_life_gen_iv_id then
1050: --
1051: p_entry_rec.life_gen_ins_prem := fnd_number.canonical_to_number(l_csr_entry.screen_entry_value);
1052: --
1053: elsif l_csr_entry.input_value_id = c_life_pens_iv_id then
1054: --
1055: p_entry_rec.life_pens_ins_prem := fnd_number.canonical_to_number(l_csr_entry.screen_entry_value);

Line 1055: p_entry_rec.life_pens_ins_prem := fnd_number.canonical_to_number(l_csr_entry.screen_entry_value);

1051: p_entry_rec.life_gen_ins_prem := fnd_number.canonical_to_number(l_csr_entry.screen_entry_value);
1052: --
1053: elsif l_csr_entry.input_value_id = c_life_pens_iv_id then
1054: --
1055: p_entry_rec.life_pens_ins_prem := fnd_number.canonical_to_number(l_csr_entry.screen_entry_value);
1056: --
1057: elsif l_csr_entry.input_value_id = c_nonlife_long_iv_id then
1058: --
1059: p_entry_rec.nonlife_long_ins_prem := fnd_number.canonical_to_number(l_csr_entry.screen_entry_value);

Line 1059: p_entry_rec.nonlife_long_ins_prem := fnd_number.canonical_to_number(l_csr_entry.screen_entry_value);

1055: p_entry_rec.life_pens_ins_prem := fnd_number.canonical_to_number(l_csr_entry.screen_entry_value);
1056: --
1057: elsif l_csr_entry.input_value_id = c_nonlife_long_iv_id then
1058: --
1059: p_entry_rec.nonlife_long_ins_prem := fnd_number.canonical_to_number(l_csr_entry.screen_entry_value);
1060: --
1061: elsif l_csr_entry.input_value_id = c_nonlife_short_iv_id then
1062: --
1063: p_entry_rec.nonlife_short_ins_prem := fnd_number.canonical_to_number(l_csr_entry.screen_entry_value);

Line 1063: p_entry_rec.nonlife_short_ins_prem := fnd_number.canonical_to_number(l_csr_entry.screen_entry_value);

1059: p_entry_rec.nonlife_long_ins_prem := fnd_number.canonical_to_number(l_csr_entry.screen_entry_value);
1060: --
1061: elsif l_csr_entry.input_value_id = c_nonlife_short_iv_id then
1062: --
1063: p_entry_rec.nonlife_short_ins_prem := fnd_number.canonical_to_number(l_csr_entry.screen_entry_value);
1064: --
1065: elsif l_csr_entry.input_value_id = c_earthquake_iv_id then
1066: --
1067: p_entry_rec.earthquake_ins_prem := fnd_number.canonical_to_number(l_csr_entry.screen_entry_value);

Line 1067: p_entry_rec.earthquake_ins_prem := fnd_number.canonical_to_number(l_csr_entry.screen_entry_value);

1063: p_entry_rec.nonlife_short_ins_prem := fnd_number.canonical_to_number(l_csr_entry.screen_entry_value);
1064: --
1065: elsif l_csr_entry.input_value_id = c_earthquake_iv_id then
1066: --
1067: p_entry_rec.earthquake_ins_prem := fnd_number.canonical_to_number(l_csr_entry.screen_entry_value);
1068: --
1069: elsif l_csr_entry.input_value_id = c_life_gen_new_iv_id then
1070: --
1071: p_entry_rec.life_gen_ins_prem_new := fnd_number.canonical_to_number(l_csr_entry.screen_entry_value);

Line 1071: p_entry_rec.life_gen_ins_prem_new := fnd_number.canonical_to_number(l_csr_entry.screen_entry_value);

1067: p_entry_rec.earthquake_ins_prem := fnd_number.canonical_to_number(l_csr_entry.screen_entry_value);
1068: --
1069: elsif l_csr_entry.input_value_id = c_life_gen_new_iv_id then
1070: --
1071: p_entry_rec.life_gen_ins_prem_new := fnd_number.canonical_to_number(l_csr_entry.screen_entry_value);
1072: --
1073: elsif l_csr_entry.input_value_id = c_life_pens_new_iv_id then
1074: --
1075: p_entry_rec.life_pens_ins_prem_new := fnd_number.canonical_to_number(l_csr_entry.screen_entry_value);

Line 1075: p_entry_rec.life_pens_ins_prem_new := fnd_number.canonical_to_number(l_csr_entry.screen_entry_value);

1071: p_entry_rec.life_gen_ins_prem_new := fnd_number.canonical_to_number(l_csr_entry.screen_entry_value);
1072: --
1073: elsif l_csr_entry.input_value_id = c_life_pens_new_iv_id then
1074: --
1075: p_entry_rec.life_pens_ins_prem_new := fnd_number.canonical_to_number(l_csr_entry.screen_entry_value);
1076: --
1077: elsif l_csr_entry.input_value_id = c_care_med_new_iv_id then
1078: --
1079: p_entry_rec.care_med_ins_prem_new := fnd_number.canonical_to_number(l_csr_entry.screen_entry_value);

Line 1079: p_entry_rec.care_med_ins_prem_new := fnd_number.canonical_to_number(l_csr_entry.screen_entry_value);

1075: p_entry_rec.life_pens_ins_prem_new := fnd_number.canonical_to_number(l_csr_entry.screen_entry_value);
1076: --
1077: elsif l_csr_entry.input_value_id = c_care_med_new_iv_id then
1078: --
1079: p_entry_rec.care_med_ins_prem_new := fnd_number.canonical_to_number(l_csr_entry.screen_entry_value);
1080: --
1081: end if;
1082: --
1083: end loop;

Line 1102: p_entry_rec.social_ins_prem := fnd_number.canonical_to_number(l_csr_entry.screen_entry_value);

1098: end if;
1099: --
1100: if l_csr_entry.input_value_id = c_social_iv_id then
1101: --
1102: p_entry_rec.social_ins_prem := fnd_number.canonical_to_number(l_csr_entry.screen_entry_value);
1103: --
1104: elsif l_csr_entry.input_value_id = c_mutual_aid_iv_id then
1105: --
1106: p_entry_rec.mutual_aid_prem := fnd_number.canonical_to_number(l_csr_entry.screen_entry_value);

Line 1106: p_entry_rec.mutual_aid_prem := fnd_number.canonical_to_number(l_csr_entry.screen_entry_value);

1102: p_entry_rec.social_ins_prem := fnd_number.canonical_to_number(l_csr_entry.screen_entry_value);
1103: --
1104: elsif l_csr_entry.input_value_id = c_mutual_aid_iv_id then
1105: --
1106: p_entry_rec.mutual_aid_prem := fnd_number.canonical_to_number(l_csr_entry.screen_entry_value);
1107: --
1108: elsif l_csr_entry.input_value_id = c_spouse_iv_id then
1109: --
1110: p_entry_rec.spouse_income := fnd_number.canonical_to_number(l_csr_entry.screen_entry_value);

Line 1110: p_entry_rec.spouse_income := fnd_number.canonical_to_number(l_csr_entry.screen_entry_value);

1106: p_entry_rec.mutual_aid_prem := fnd_number.canonical_to_number(l_csr_entry.screen_entry_value);
1107: --
1108: elsif l_csr_entry.input_value_id = c_spouse_iv_id then
1109: --
1110: p_entry_rec.spouse_income := fnd_number.canonical_to_number(l_csr_entry.screen_entry_value);
1111: --
1112: elsif l_csr_entry.input_value_id = c_sp_dct_exclude_iv_id then
1113: --
1114: p_entry_rec.sp_dct_exclude := l_csr_entry.screen_entry_value;

Line 1118: p_entry_rec.national_pens_ins_prem := fnd_number.canonical_to_number(l_csr_entry.screen_entry_value);

1114: p_entry_rec.sp_dct_exclude := l_csr_entry.screen_entry_value;
1115: --
1116: elsif l_csr_entry.input_value_id = c_national_pens_iv_id then
1117: --
1118: p_entry_rec.national_pens_ins_prem := fnd_number.canonical_to_number(l_csr_entry.screen_entry_value);
1119: --
1120: end if;
1121: --
1122: end loop;

Line 1223: fnd_number.canonical_to_number(paei.aei_information10) linc_prem

1219: paei.aei_information6 ins_period,
1220: paei.aei_information7 contractor_name,
1221: paei.aei_information8 beneficiary_name,
1222: paei.aei_information9 beneficiary_relship,
1223: fnd_number.canonical_to_number(paei.aei_information10) linc_prem
1224: from per_assignment_extra_info paei,
1225: hr_organization_information hoi
1226: where paei.assignment_id = p_assignment_id
1227: and paei.information_type = 'JP_ASS_LIG_INFO'

Line 1279: fnd_number.canonical_to_number(paei.aei_information10) linc_prem

1275: paei.aei_information6 ins_period,
1276: paei.aei_information7 contractor_name,
1277: paei.aei_information8 beneficiary_name,
1278: paei.aei_information9 beneficiary_relship,
1279: fnd_number.canonical_to_number(paei.aei_information10) linc_prem
1280: from per_assignment_extra_info paei,
1281: hr_organization_information hoi
1282: where paei.assignment_id = p_assignment_id
1283: and paei.information_type = 'JP_ASS_CMI_INFO'

Line 1335: fnd_number.canonical_to_number(paei.aei_information11) linc_prem

1331: paei.aei_information7 ins_period,
1332: paei.aei_information8 contractor_name,
1333: paei.aei_information9 beneficiary_name,
1334: paei.aei_information10 beneficiary_relship,
1335: fnd_number.canonical_to_number(paei.aei_information11) linc_prem
1336: from per_assignment_extra_info paei,
1337: hr_organization_information hoi
1338: where paei.assignment_id = p_assignment_id
1339: and paei.information_type = 'JP_ASS_LIP_INFO'

Line 1388: fnd_number.canonical_to_number(paei.aei_information11) annual_prem

1384: paei.aei_information7 contractor_name,
1385: paei.aei_information8 beneficiary_name,
1386: paei.aei_information9 beneficiary_relship,
1387: decode(to_char(sign(g_effective_date - c_st_upd_date_2007)),'-1',paei.aei_information10,null) maturity_repayment,
1388: fnd_number.canonical_to_number(paei.aei_information11) annual_prem
1389: from per_assignment_extra_info paei,
1390: hr_organization_information hoi
1391: where paei.assignment_id = p_assignment_id
1392: and paei.information_type = 'JP_ASS_AI_INFO'

Line 1639: hr_utility.trace('linc_prem : '||fnd_number.number_to_canonical(l_li_info_rec.linc_prem));

1635: hr_utility.trace('ins_period : '||l_li_info_rec.ins_period);
1636: hr_utility.trace('contractor_name : '||l_li_info_rec.contractor_name);
1637: hr_utility.trace('beneficiary_name : '||l_li_info_rec.beneficiary_name);
1638: hr_utility.trace('beneficiary_relship : '||l_li_info_rec.beneficiary_relship);
1639: hr_utility.trace('linc_prem : '||fnd_number.number_to_canonical(l_li_info_rec.linc_prem));
1640: end if;
1641: --
1642: l_lig_prem := null;
1643: --

Line 1723: hr_utility.trace('linc_prem : '||fnd_number.number_to_canonical(l_li_info_rec.linc_prem));

1719: hr_utility.trace('ins_period : '||l_li_info_rec.ins_period);
1720: hr_utility.trace('contractor_name : '||l_li_info_rec.contractor_name);
1721: hr_utility.trace('beneficiary_name : '||l_li_info_rec.beneficiary_name);
1722: hr_utility.trace('beneficiary_relship : '||l_li_info_rec.beneficiary_relship);
1723: hr_utility.trace('linc_prem : '||fnd_number.number_to_canonical(l_li_info_rec.linc_prem));
1724: end if;
1725: --
1726: l_cmi_prem := null;
1727: --

Line 1807: hr_utility.trace('linc_prem : '||fnd_number.number_to_canonical(l_li_info_rec.linc_prem));

1803: hr_utility.trace('ins_period : '||l_li_info_rec.ins_period);
1804: hr_utility.trace('contractor_name : '||l_li_info_rec.contractor_name);
1805: hr_utility.trace('beneficiary_name : '||l_li_info_rec.beneficiary_name);
1806: hr_utility.trace('beneficiary_relship : '||l_li_info_rec.beneficiary_relship);
1807: hr_utility.trace('linc_prem : '||fnd_number.number_to_canonical(l_li_info_rec.linc_prem));
1808: end if;
1809: --
1810: l_lip_prem := null;
1811: --

Line 1894: hr_utility.trace('annual_prem : '||fnd_number.number_to_canonical(l_ai_info_rec.annual_prem));

1890: hr_utility.trace('contractor_name : '||l_ai_info_rec.contractor_name);
1891: hr_utility.trace('beneficiary_name : '||l_ai_info_rec.beneficiary_name);
1892: hr_utility.trace('beneficiary_relship : '||l_ai_info_rec.beneficiary_relship);
1893: hr_utility.trace('maturity_repayment : '||l_ai_info_rec.maturity_repayment);
1894: hr_utility.trace('annual_prem : '||fnd_number.number_to_canonical(l_ai_info_rec.annual_prem));
1895: end if;
1896: --
1897: l_ai_prem := null;
1898: l_eqi_prem := null;

Line 2430: pay_balance_pkg.set_context('ASSIGNMENT_ID',fnd_number.number_to_canonical(l_assignment_id));

2426: end if;
2427: --
2428: -- set context.
2429: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(p_effective_date));
2430: pay_balance_pkg.set_context('ASSIGNMENT_ID',fnd_number.number_to_canonical(l_assignment_id));
2431: l_tax_type := pay_balance_pkg.run_db_item(c_tax_type_iv_name,g_business_group_id,g_legislation_code);
2432: --
2433: if g_debug then
2434: hr_utility.set_location(l_proc,20);