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 115: g_payroll_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAYROLL_ID',l_csr_action.legislative_parameters));

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

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

112: g_effective_date := l_csr_action.effective_date;
113: g_business_group_id := l_csr_action.business_group_id;
114: g_legislation_code := l_csr_action.legislation_code;
115: g_payroll_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAYROLL_ID',l_csr_action.legislative_parameters));
116: g_organization_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ORGANIZATION_ID',l_csr_action.legislative_parameters));
117: g_assignment_set_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',l_csr_action.legislative_parameters));
118: g_process_assignments_flag := pay_core_utils.get_parameter('PROCESS_ASSIGNMENTS_FLAG',l_csr_action.legislative_parameters);
119: g_archive_default_flag := pay_core_utils.get_parameter('ARCHIVE_DEFAULT_FLAG',l_csr_action.legislative_parameters);
120: 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 117: g_assignment_set_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',l_csr_action.legislative_parameters));

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

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

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

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

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

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

600: --
601: for i in l_inputs.first..l_inputs.last loop
602: --
603: if l_inputs(i).name = 'BUSINESS_GROUP_ID' then
604: l_inputs(i).value := fnd_number.number_to_canonical(g_business_group_id);
605: elsif l_inputs(i).name = 'PAYROLL_ID' then
606: l_inputs(i).value := fnd_number.number_to_canonical(g_payroll_id);
607: elsif l_inputs(i).name = 'PAYROLL_ACTION_ID' then
608: l_inputs(i).value := fnd_number.number_to_canonical(g_payroll_action_id);

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

602: --
603: if l_inputs(i).name = 'BUSINESS_GROUP_ID' then
604: l_inputs(i).value := fnd_number.number_to_canonical(g_business_group_id);
605: elsif l_inputs(i).name = 'PAYROLL_ID' then
606: l_inputs(i).value := fnd_number.number_to_canonical(g_payroll_id);
607: elsif l_inputs(i).name = 'PAYROLL_ACTION_ID' then
608: l_inputs(i).value := fnd_number.number_to_canonical(g_payroll_action_id);
609: elsif l_inputs(i).name = 'ASSIGNMENT_ID' then
610: l_inputs(i).value := fnd_number.number_to_canonical(g_assignment_id);

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

604: l_inputs(i).value := fnd_number.number_to_canonical(g_business_group_id);
605: elsif l_inputs(i).name = 'PAYROLL_ID' then
606: l_inputs(i).value := fnd_number.number_to_canonical(g_payroll_id);
607: elsif l_inputs(i).name = 'PAYROLL_ACTION_ID' then
608: l_inputs(i).value := fnd_number.number_to_canonical(g_payroll_action_id);
609: elsif l_inputs(i).name = 'ASSIGNMENT_ID' then
610: l_inputs(i).value := fnd_number.number_to_canonical(g_assignment_id);
611: elsif l_inputs(i).name = 'ASSIGNMENT_ACTION_ID' then
612: l_inputs(i).value := fnd_number.number_to_canonical(g_assignment_action_id);

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

606: l_inputs(i).value := fnd_number.number_to_canonical(g_payroll_id);
607: elsif l_inputs(i).name = 'PAYROLL_ACTION_ID' then
608: l_inputs(i).value := fnd_number.number_to_canonical(g_payroll_action_id);
609: elsif l_inputs(i).name = 'ASSIGNMENT_ID' then
610: l_inputs(i).value := fnd_number.number_to_canonical(g_assignment_id);
611: elsif l_inputs(i).name = 'ASSIGNMENT_ACTION_ID' then
612: l_inputs(i).value := fnd_number.number_to_canonical(g_assignment_action_id);
613: elsif l_inputs(i).name = 'DATE_EARNED' then
614: l_inputs(i).value := fnd_date.date_to_canonical(g_effective_date);

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

608: l_inputs(i).value := fnd_number.number_to_canonical(g_payroll_action_id);
609: elsif l_inputs(i).name = 'ASSIGNMENT_ID' then
610: l_inputs(i).value := fnd_number.number_to_canonical(g_assignment_id);
611: elsif l_inputs(i).name = 'ASSIGNMENT_ACTION_ID' then
612: l_inputs(i).value := fnd_number.number_to_canonical(g_assignment_action_id);
613: elsif l_inputs(i).name = 'DATE_EARNED' then
614: l_inputs(i).value := fnd_date.date_to_canonical(g_effective_date);
615: --
616: elsif l_inputs(i).name = 'I_ASSIGNMENT_ID' then

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

613: elsif l_inputs(i).name = 'DATE_EARNED' then
614: l_inputs(i).value := fnd_date.date_to_canonical(g_effective_date);
615: --
616: elsif l_inputs(i).name = 'I_ASSIGNMENT_ID' then
617: l_inputs(i).value := fnd_number.number_to_canonical(g_assignment_id);
618: elsif l_inputs(i).name = 'I_ASSIGNMENT_ACTION_ID' then
619: l_inputs(i).value := fnd_number.number_to_canonical(g_assignment_action_id);
620: elsif l_inputs(i).name = 'I_INFO_TYPE' then
621: l_inputs(i).value := p_ins_info_rec.info_type;

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

615: --
616: elsif l_inputs(i).name = 'I_ASSIGNMENT_ID' then
617: l_inputs(i).value := fnd_number.number_to_canonical(g_assignment_id);
618: elsif l_inputs(i).name = 'I_ASSIGNMENT_ACTION_ID' then
619: l_inputs(i).value := fnd_number.number_to_canonical(g_assignment_action_id);
620: elsif l_inputs(i).name = 'I_INFO_TYPE' then
621: l_inputs(i).value := p_ins_info_rec.info_type;
622: elsif l_inputs(i).name = 'I_INS_CLASS' then
623: l_inputs(i).value := p_ins_info_rec.ins_class;

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

635: l_inputs(i).value := p_ins_info_rec.lip_prem_mth_ele;
636: elsif l_inputs(i).name = 'I_LIP_PREM_BON_ELE' then
637: l_inputs(i).value := p_ins_info_rec.lip_prem_bon_ele;
638: elsif l_inputs(i).name = 'I_LINC_PREM' then
639: l_inputs(i).value := fnd_number.number_to_canonical(p_ins_info_rec.linc_prem);
640: end if;
641: --
642: end loop;
643: --

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

675: --
676: for j in l_outputs.first..l_outputs.last loop
677: --
678: if l_outputs(j).name = 'O_LIG_PREM' then
679: p_lig_prem := fnd_number.canonical_to_number(ltrim(rtrim(l_outputs(j).value)));
680: elsif l_outputs(j).name = 'O_LIP_PREM' then
681: p_lip_prem := fnd_number.canonical_to_number(ltrim(rtrim(l_outputs(j).value)));
682: elsif l_outputs(j).name = 'O_MESSAGE' then
683: p_message := ltrim(rtrim(l_outputs(j).value));

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

677: --
678: if l_outputs(j).name = 'O_LIG_PREM' then
679: p_lig_prem := fnd_number.canonical_to_number(ltrim(rtrim(l_outputs(j).value)));
680: elsif l_outputs(j).name = 'O_LIP_PREM' then
681: p_lip_prem := fnd_number.canonical_to_number(ltrim(rtrim(l_outputs(j).value)));
682: elsif l_outputs(j).name = 'O_MESSAGE' then
683: p_message := ltrim(rtrim(l_outputs(j).value));
684: end if;
685: --

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

697: if g_debug then
698: hr_utility.set_location(l_proc,60);
699: end if;
700: --
701: fnd_file.put_line(fnd_file.output,'Assignment Id : '||fnd_number.number_to_canonical(g_assignment_id));
702: fnd_file.put_line(fnd_file.output,'----------------------------------------------------------------------------------------------------');
703: fnd_file.put_line(fnd_file.output,p_message);
704: fnd_file.put_line(fnd_file.output,' ');
705: --

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

776: --
777: for i in l_inputs.first..l_inputs.last loop
778: --
779: if l_inputs(i).name = 'BUSINESS_GROUP_ID' then
780: l_inputs(i).value := fnd_number.number_to_canonical(g_business_group_id);
781: elsif l_inputs(i).name = 'PAYROLL_ID' then
782: l_inputs(i).value := fnd_number.number_to_canonical(g_payroll_id);
783: elsif l_inputs(i).name = 'PAYROLL_ACTION_ID' then
784: l_inputs(i).value := fnd_number.number_to_canonical(g_payroll_action_id);

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

778: --
779: if l_inputs(i).name = 'BUSINESS_GROUP_ID' then
780: l_inputs(i).value := fnd_number.number_to_canonical(g_business_group_id);
781: elsif l_inputs(i).name = 'PAYROLL_ID' then
782: l_inputs(i).value := fnd_number.number_to_canonical(g_payroll_id);
783: elsif l_inputs(i).name = 'PAYROLL_ACTION_ID' then
784: l_inputs(i).value := fnd_number.number_to_canonical(g_payroll_action_id);
785: elsif l_inputs(i).name = 'ASSIGNMENT_ID' then
786: l_inputs(i).value := fnd_number.number_to_canonical(g_assignment_id);

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

780: l_inputs(i).value := fnd_number.number_to_canonical(g_business_group_id);
781: elsif l_inputs(i).name = 'PAYROLL_ID' then
782: l_inputs(i).value := fnd_number.number_to_canonical(g_payroll_id);
783: elsif l_inputs(i).name = 'PAYROLL_ACTION_ID' then
784: l_inputs(i).value := fnd_number.number_to_canonical(g_payroll_action_id);
785: elsif l_inputs(i).name = 'ASSIGNMENT_ID' then
786: l_inputs(i).value := fnd_number.number_to_canonical(g_assignment_id);
787: elsif l_inputs(i).name = 'ASSIGNMENT_ACTION_ID' then
788: l_inputs(i).value := fnd_number.number_to_canonical(g_assignment_action_id);

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

782: l_inputs(i).value := fnd_number.number_to_canonical(g_payroll_id);
783: elsif l_inputs(i).name = 'PAYROLL_ACTION_ID' then
784: l_inputs(i).value := fnd_number.number_to_canonical(g_payroll_action_id);
785: elsif l_inputs(i).name = 'ASSIGNMENT_ID' then
786: l_inputs(i).value := fnd_number.number_to_canonical(g_assignment_id);
787: elsif l_inputs(i).name = 'ASSIGNMENT_ACTION_ID' then
788: l_inputs(i).value := fnd_number.number_to_canonical(g_assignment_action_id);
789: elsif l_inputs(i).name = 'DATE_EARNED' then
790: l_inputs(i).value := fnd_date.date_to_canonical(g_effective_date);

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

784: l_inputs(i).value := fnd_number.number_to_canonical(g_payroll_action_id);
785: elsif l_inputs(i).name = 'ASSIGNMENT_ID' then
786: l_inputs(i).value := fnd_number.number_to_canonical(g_assignment_id);
787: elsif l_inputs(i).name = 'ASSIGNMENT_ACTION_ID' then
788: l_inputs(i).value := fnd_number.number_to_canonical(g_assignment_action_id);
789: elsif l_inputs(i).name = 'DATE_EARNED' then
790: l_inputs(i).value := fnd_date.date_to_canonical(g_effective_date);
791: --
792: elsif l_inputs(i).name = 'I_ASSIGNMENT_ID' then

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

789: elsif l_inputs(i).name = 'DATE_EARNED' then
790: l_inputs(i).value := fnd_date.date_to_canonical(g_effective_date);
791: --
792: elsif l_inputs(i).name = 'I_ASSIGNMENT_ID' then
793: l_inputs(i).value := fnd_number.number_to_canonical(g_assignment_id);
794: elsif l_inputs(i).name = 'I_ASSIGNMENT_ACTION_ID' then
795: l_inputs(i).value := fnd_number.number_to_canonical(g_assignment_action_id);
796: elsif l_inputs(i).name = 'I_INFO_TYPE' then
797: l_inputs(i).value := p_ins_info_rec.info_type;

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

791: --
792: elsif l_inputs(i).name = 'I_ASSIGNMENT_ID' then
793: l_inputs(i).value := fnd_number.number_to_canonical(g_assignment_id);
794: elsif l_inputs(i).name = 'I_ASSIGNMENT_ACTION_ID' then
795: l_inputs(i).value := fnd_number.number_to_canonical(g_assignment_action_id);
796: elsif l_inputs(i).name = 'I_INFO_TYPE' then
797: l_inputs(i).value := p_ins_info_rec.info_type;
798: elsif l_inputs(i).name = 'I_INS_CLASS' then
799: l_inputs(i).value := p_ins_info_rec.ins_class;

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

813: l_inputs(i).value := p_ins_info_rec.ai_prem_mth_ele;
814: elsif l_inputs(i).name = 'I_AI_PREM_BON_ELE' then
815: l_inputs(i).value := p_ins_info_rec.ai_prem_bon_ele;
816: elsif l_inputs(i).name = 'I_AI_PREM' then
817: l_inputs(i).value := fnd_number.number_to_canonical(p_ins_info_rec.annual_prem);
818: end if;
819: --
820: end loop;
821: --

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

853: --
854: for j in l_outputs.first..l_outputs.last loop
855: --
856: if l_outputs(j).name = 'O_EQI_PREM' then
857: p_eqi_prem := fnd_number.canonical_to_number(ltrim(rtrim(l_outputs(j).value)));
858: elsif l_outputs(j).name = 'O_AI_PREM' then
859: p_ai_prem := fnd_number.canonical_to_number(ltrim(rtrim(l_outputs(j).value)));
860: elsif l_outputs(j).name = 'O_MESSAGE' then
861: p_message := ltrim(rtrim(l_outputs(j).value));

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

855: --
856: if l_outputs(j).name = 'O_EQI_PREM' then
857: p_eqi_prem := fnd_number.canonical_to_number(ltrim(rtrim(l_outputs(j).value)));
858: elsif l_outputs(j).name = 'O_AI_PREM' then
859: p_ai_prem := fnd_number.canonical_to_number(ltrim(rtrim(l_outputs(j).value)));
860: elsif l_outputs(j).name = 'O_MESSAGE' then
861: p_message := ltrim(rtrim(l_outputs(j).value));
862: end if;
863: --

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

875: if g_debug then
876: hr_utility.set_location(l_proc,60);
877: end if;
878: --
879: fnd_file.put_line(fnd_file.output,'Assignment Id : '||fnd_number.number_to_canonical(g_assignment_id));
880: fnd_file.put_line(fnd_file.output,'----------------------------------------------------------------------------------------------------');
881: fnd_file.put_line(fnd_file.output,p_message);
882: fnd_file.put_line(fnd_file.output,' ');
883: --

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

1026: end if;
1027: --
1028: if l_csr_entry.input_value_id = c_life_gen_iv_id then
1029: --
1030: p_entry_rec.life_gen_ins_prem := fnd_number.canonical_to_number(l_csr_entry.screen_entry_value);
1031: --
1032: elsif l_csr_entry.input_value_id = c_life_pens_iv_id then
1033: --
1034: p_entry_rec.life_pens_ins_prem := fnd_number.canonical_to_number(l_csr_entry.screen_entry_value);

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

1030: p_entry_rec.life_gen_ins_prem := fnd_number.canonical_to_number(l_csr_entry.screen_entry_value);
1031: --
1032: elsif l_csr_entry.input_value_id = c_life_pens_iv_id then
1033: --
1034: p_entry_rec.life_pens_ins_prem := fnd_number.canonical_to_number(l_csr_entry.screen_entry_value);
1035: --
1036: elsif l_csr_entry.input_value_id = c_nonlife_long_iv_id then
1037: --
1038: p_entry_rec.nonlife_long_ins_prem := fnd_number.canonical_to_number(l_csr_entry.screen_entry_value);

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

1034: p_entry_rec.life_pens_ins_prem := fnd_number.canonical_to_number(l_csr_entry.screen_entry_value);
1035: --
1036: elsif l_csr_entry.input_value_id = c_nonlife_long_iv_id then
1037: --
1038: p_entry_rec.nonlife_long_ins_prem := fnd_number.canonical_to_number(l_csr_entry.screen_entry_value);
1039: --
1040: elsif l_csr_entry.input_value_id = c_nonlife_short_iv_id then
1041: --
1042: p_entry_rec.nonlife_short_ins_prem := fnd_number.canonical_to_number(l_csr_entry.screen_entry_value);

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

1038: p_entry_rec.nonlife_long_ins_prem := fnd_number.canonical_to_number(l_csr_entry.screen_entry_value);
1039: --
1040: elsif l_csr_entry.input_value_id = c_nonlife_short_iv_id then
1041: --
1042: p_entry_rec.nonlife_short_ins_prem := fnd_number.canonical_to_number(l_csr_entry.screen_entry_value);
1043: --
1044: elsif l_csr_entry.input_value_id = c_earthquake_iv_id then
1045: --
1046: p_entry_rec.earthquake_ins_prem := fnd_number.canonical_to_number(l_csr_entry.screen_entry_value);

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

1042: p_entry_rec.nonlife_short_ins_prem := fnd_number.canonical_to_number(l_csr_entry.screen_entry_value);
1043: --
1044: elsif l_csr_entry.input_value_id = c_earthquake_iv_id then
1045: --
1046: p_entry_rec.earthquake_ins_prem := fnd_number.canonical_to_number(l_csr_entry.screen_entry_value);
1047: --
1048: end if;
1049: --
1050: end loop;

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

1065: end if;
1066: --
1067: if l_csr_entry.input_value_id = c_social_iv_id then
1068: --
1069: p_entry_rec.social_ins_prem := fnd_number.canonical_to_number(l_csr_entry.screen_entry_value);
1070: --
1071: elsif l_csr_entry.input_value_id = c_mutual_aid_iv_id then
1072: --
1073: p_entry_rec.mutual_aid_prem := fnd_number.canonical_to_number(l_csr_entry.screen_entry_value);

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

1069: p_entry_rec.social_ins_prem := fnd_number.canonical_to_number(l_csr_entry.screen_entry_value);
1070: --
1071: elsif l_csr_entry.input_value_id = c_mutual_aid_iv_id then
1072: --
1073: p_entry_rec.mutual_aid_prem := fnd_number.canonical_to_number(l_csr_entry.screen_entry_value);
1074: --
1075: elsif l_csr_entry.input_value_id = c_spouse_iv_id then
1076: --
1077: p_entry_rec.spouse_income := fnd_number.canonical_to_number(l_csr_entry.screen_entry_value);

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

1073: p_entry_rec.mutual_aid_prem := fnd_number.canonical_to_number(l_csr_entry.screen_entry_value);
1074: --
1075: elsif l_csr_entry.input_value_id = c_spouse_iv_id then
1076: --
1077: p_entry_rec.spouse_income := fnd_number.canonical_to_number(l_csr_entry.screen_entry_value);
1078: --
1079: elsif l_csr_entry.input_value_id = c_sp_dct_exclude_iv_id then
1080: --
1081: p_entry_rec.sp_dct_exclude := l_csr_entry.screen_entry_value;

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

1081: p_entry_rec.sp_dct_exclude := l_csr_entry.screen_entry_value;
1082: --
1083: elsif l_csr_entry.input_value_id = c_national_pens_iv_id then
1084: --
1085: p_entry_rec.national_pens_ins_prem := fnd_number.canonical_to_number(l_csr_entry.screen_entry_value);
1086: --
1087: end if;
1088: --
1089: end loop;

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

1181: paei.aei_information6 ins_period,
1182: paei.aei_information7 contractor_name,
1183: paei.aei_information8 beneficiary_name,
1184: paei.aei_information9 beneficiary_relship,
1185: fnd_number.canonical_to_number(paei.aei_information10) linc_prem
1186: from per_assignment_extra_info paei,
1187: hr_organization_information hoi
1188: where paei.assignment_id = p_assignment_id
1189: and paei.information_type = 'JP_ASS_LIG_INFO'

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

1231: paei.aei_information7 ins_period,
1232: paei.aei_information8 contractor_name,
1233: paei.aei_information9 beneficiary_name,
1234: paei.aei_information10 beneficiary_relship,
1235: fnd_number.canonical_to_number(paei.aei_information11) linc_prem
1236: from per_assignment_extra_info paei,
1237: hr_organization_information hoi
1238: where paei.assignment_id = p_assignment_id
1239: and paei.information_type = 'JP_ASS_LIP_INFO'

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

1282: paei.aei_information7 contractor_name,
1283: paei.aei_information8 beneficiary_name,
1284: paei.aei_information9 beneficiary_relship,
1285: decode(to_char(sign(g_effective_date - c_st_upd_date_2007)),'-1',paei.aei_information10,null) maturity_repayment,
1286: fnd_number.canonical_to_number(paei.aei_information11) annual_prem
1287: from per_assignment_extra_info paei,
1288: hr_organization_information hoi
1289: where paei.assignment_id = p_assignment_id
1290: and paei.information_type = 'JP_ASS_AI_INFO'

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

1521: hr_utility.trace('ins_period : '||l_li_info_rec.ins_period);
1522: hr_utility.trace('contractor_name : '||l_li_info_rec.contractor_name);
1523: hr_utility.trace('beneficiary_name : '||l_li_info_rec.beneficiary_name);
1524: hr_utility.trace('beneficiary_relship : '||l_li_info_rec.beneficiary_relship);
1525: hr_utility.trace('linc_prem : '||fnd_number.number_to_canonical(l_li_info_rec.linc_prem));
1526: end if;
1527: --
1528: l_lig_prem := null;
1529: --

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

1601: hr_utility.trace('ins_period : '||l_li_info_rec.ins_period);
1602: hr_utility.trace('contractor_name : '||l_li_info_rec.contractor_name);
1603: hr_utility.trace('beneficiary_name : '||l_li_info_rec.beneficiary_name);
1604: hr_utility.trace('beneficiary_relship : '||l_li_info_rec.beneficiary_relship);
1605: hr_utility.trace('linc_prem : '||fnd_number.number_to_canonical(l_li_info_rec.linc_prem));
1606: end if;
1607: --
1608: l_lip_prem := null;
1609: --

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

1686: hr_utility.trace('contractor_name : '||l_ai_info_rec.contractor_name);
1687: hr_utility.trace('beneficiary_name : '||l_ai_info_rec.beneficiary_name);
1688: hr_utility.trace('beneficiary_relship : '||l_ai_info_rec.beneficiary_relship);
1689: hr_utility.trace('maturity_repayment : '||l_ai_info_rec.maturity_repayment);
1690: hr_utility.trace('annual_prem : '||fnd_number.number_to_canonical(l_ai_info_rec.annual_prem));
1691: end if;
1692: --
1693: l_ai_prem := null;
1694: l_eqi_prem := null;

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

2182: end if;
2183: --
2184: -- set context.
2185: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(p_effective_date));
2186: pay_balance_pkg.set_context('ASSIGNMENT_ID',fnd_number.number_to_canonical(l_assignment_id));
2187: l_tax_type := pay_balance_pkg.run_db_item(c_tax_type_iv_name,g_business_group_id,g_legislation_code);
2188: --
2189: if g_debug then
2190: hr_utility.set_location(l_proc,20);