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_US_PAYSLIP_SIMULATION_MAIN dependencies on FND_NUMBER

Line 881: ,p_fit_override_amount => NVL(fnd_number.canonical_to_number(lct_region2.aei_information6),0)

877: ,p_datetrack_update_mode => lv_datetrack_update_mode
878: ,p_emp_fed_tax_rule_id => ln_emp_fed_tax_rule_id
879: ,p_object_version_number => ln_ft_object_version_number
880: ,p_filing_status_code => lct_region2.aei_information1
881: ,p_fit_override_amount => NVL(fnd_number.canonical_to_number(lct_region2.aei_information6),0)
882: ,p_fit_override_rate => NVL(fnd_number.canonical_to_number(lct_region2.aei_information5),0)
883: ,p_withholding_allowances => NVL(fnd_number.canonical_to_number(lct_region2.aei_information3),0)
884: ,p_fit_additional_tax => NVL(fnd_number.canonical_to_number(lct_region2.aei_information4),0)
885: ,p_fit_exempt => lct_region2.aei_information2

Line 882: ,p_fit_override_rate => NVL(fnd_number.canonical_to_number(lct_region2.aei_information5),0)

878: ,p_emp_fed_tax_rule_id => ln_emp_fed_tax_rule_id
879: ,p_object_version_number => ln_ft_object_version_number
880: ,p_filing_status_code => lct_region2.aei_information1
881: ,p_fit_override_amount => NVL(fnd_number.canonical_to_number(lct_region2.aei_information6),0)
882: ,p_fit_override_rate => NVL(fnd_number.canonical_to_number(lct_region2.aei_information5),0)
883: ,p_withholding_allowances => NVL(fnd_number.canonical_to_number(lct_region2.aei_information3),0)
884: ,p_fit_additional_tax => NVL(fnd_number.canonical_to_number(lct_region2.aei_information4),0)
885: ,p_fit_exempt => lct_region2.aei_information2
886: ,p_supp_tax_override_rate => NVL(fnd_number.canonical_to_number(lct_region2.aei_information7),0)

Line 883: ,p_withholding_allowances => NVL(fnd_number.canonical_to_number(lct_region2.aei_information3),0)

879: ,p_object_version_number => ln_ft_object_version_number
880: ,p_filing_status_code => lct_region2.aei_information1
881: ,p_fit_override_amount => NVL(fnd_number.canonical_to_number(lct_region2.aei_information6),0)
882: ,p_fit_override_rate => NVL(fnd_number.canonical_to_number(lct_region2.aei_information5),0)
883: ,p_withholding_allowances => NVL(fnd_number.canonical_to_number(lct_region2.aei_information3),0)
884: ,p_fit_additional_tax => NVL(fnd_number.canonical_to_number(lct_region2.aei_information4),0)
885: ,p_fit_exempt => lct_region2.aei_information2
886: ,p_supp_tax_override_rate => NVL(fnd_number.canonical_to_number(lct_region2.aei_information7),0)
887: ,p_effective_start_date => ld_effective_start_date

Line 884: ,p_fit_additional_tax => NVL(fnd_number.canonical_to_number(lct_region2.aei_information4),0)

880: ,p_filing_status_code => lct_region2.aei_information1
881: ,p_fit_override_amount => NVL(fnd_number.canonical_to_number(lct_region2.aei_information6),0)
882: ,p_fit_override_rate => NVL(fnd_number.canonical_to_number(lct_region2.aei_information5),0)
883: ,p_withholding_allowances => NVL(fnd_number.canonical_to_number(lct_region2.aei_information3),0)
884: ,p_fit_additional_tax => NVL(fnd_number.canonical_to_number(lct_region2.aei_information4),0)
885: ,p_fit_exempt => lct_region2.aei_information2
886: ,p_supp_tax_override_rate => NVL(fnd_number.canonical_to_number(lct_region2.aei_information7),0)
887: ,p_effective_start_date => ld_effective_start_date
888: ,p_effective_end_date => ld_effective_end_date

Line 886: ,p_supp_tax_override_rate => NVL(fnd_number.canonical_to_number(lct_region2.aei_information7),0)

882: ,p_fit_override_rate => NVL(fnd_number.canonical_to_number(lct_region2.aei_information5),0)
883: ,p_withholding_allowances => NVL(fnd_number.canonical_to_number(lct_region2.aei_information3),0)
884: ,p_fit_additional_tax => NVL(fnd_number.canonical_to_number(lct_region2.aei_information4),0)
885: ,p_fit_exempt => lct_region2.aei_information2
886: ,p_supp_tax_override_rate => NVL(fnd_number.canonical_to_number(lct_region2.aei_information7),0)
887: ,p_effective_start_date => ld_effective_start_date
888: ,p_effective_end_date => ld_effective_end_date
889: );
890:

Line 906: ,p_sit_additional_tax => NVL(fnd_number.canonical_to_number(lct_region2.aei_information11),0)

902: ,p_datetrack_update_mode => lv_datetrack_update_mode
903: ,p_emp_state_tax_rule_id => ln_emp_state_tax_rule_id
904: ,p_object_version_number => ln_st_object_version_number
905: ,p_filing_status_code => LPAD(lct_region2.aei_information8,2,'0')
906: ,p_sit_additional_tax => NVL(fnd_number.canonical_to_number(lct_region2.aei_information11),0)
907: ,p_sit_override_amount => NVL(fnd_number.canonical_to_number(lct_region2.aei_information13),0)
908: ,p_sit_override_rate => NVL(fnd_number.canonical_to_number(lct_region2.aei_information12),0)
909: ,p_withholding_allowances => NVL(fnd_number.canonical_to_number(lct_region2.aei_information10),0)
910: ,p_sit_exempt => lct_region2.aei_information9

Line 907: ,p_sit_override_amount => NVL(fnd_number.canonical_to_number(lct_region2.aei_information13),0)

903: ,p_emp_state_tax_rule_id => ln_emp_state_tax_rule_id
904: ,p_object_version_number => ln_st_object_version_number
905: ,p_filing_status_code => LPAD(lct_region2.aei_information8,2,'0')
906: ,p_sit_additional_tax => NVL(fnd_number.canonical_to_number(lct_region2.aei_information11),0)
907: ,p_sit_override_amount => NVL(fnd_number.canonical_to_number(lct_region2.aei_information13),0)
908: ,p_sit_override_rate => NVL(fnd_number.canonical_to_number(lct_region2.aei_information12),0)
909: ,p_withholding_allowances => NVL(fnd_number.canonical_to_number(lct_region2.aei_information10),0)
910: ,p_sit_exempt => lct_region2.aei_information9
911: ,p_supp_tax_override_rate => NVL(fnd_number.canonical_to_number(lct_region2.aei_information14),0)

Line 908: ,p_sit_override_rate => NVL(fnd_number.canonical_to_number(lct_region2.aei_information12),0)

904: ,p_object_version_number => ln_st_object_version_number
905: ,p_filing_status_code => LPAD(lct_region2.aei_information8,2,'0')
906: ,p_sit_additional_tax => NVL(fnd_number.canonical_to_number(lct_region2.aei_information11),0)
907: ,p_sit_override_amount => NVL(fnd_number.canonical_to_number(lct_region2.aei_information13),0)
908: ,p_sit_override_rate => NVL(fnd_number.canonical_to_number(lct_region2.aei_information12),0)
909: ,p_withholding_allowances => NVL(fnd_number.canonical_to_number(lct_region2.aei_information10),0)
910: ,p_sit_exempt => lct_region2.aei_information9
911: ,p_supp_tax_override_rate => NVL(fnd_number.canonical_to_number(lct_region2.aei_information14),0)
912: ,p_effective_start_date => ld_effective_start_date

Line 909: ,p_withholding_allowances => NVL(fnd_number.canonical_to_number(lct_region2.aei_information10),0)

905: ,p_filing_status_code => LPAD(lct_region2.aei_information8,2,'0')
906: ,p_sit_additional_tax => NVL(fnd_number.canonical_to_number(lct_region2.aei_information11),0)
907: ,p_sit_override_amount => NVL(fnd_number.canonical_to_number(lct_region2.aei_information13),0)
908: ,p_sit_override_rate => NVL(fnd_number.canonical_to_number(lct_region2.aei_information12),0)
909: ,p_withholding_allowances => NVL(fnd_number.canonical_to_number(lct_region2.aei_information10),0)
910: ,p_sit_exempt => lct_region2.aei_information9
911: ,p_supp_tax_override_rate => NVL(fnd_number.canonical_to_number(lct_region2.aei_information14),0)
912: ,p_effective_start_date => ld_effective_start_date
913: ,p_effective_end_date => ld_effective_end_date

Line 911: ,p_supp_tax_override_rate => NVL(fnd_number.canonical_to_number(lct_region2.aei_information14),0)

907: ,p_sit_override_amount => NVL(fnd_number.canonical_to_number(lct_region2.aei_information13),0)
908: ,p_sit_override_rate => NVL(fnd_number.canonical_to_number(lct_region2.aei_information12),0)
909: ,p_withholding_allowances => NVL(fnd_number.canonical_to_number(lct_region2.aei_information10),0)
910: ,p_sit_exempt => lct_region2.aei_information9
911: ,p_supp_tax_override_rate => NVL(fnd_number.canonical_to_number(lct_region2.aei_information14),0)
912: ,p_effective_start_date => ld_effective_start_date
913: ,p_effective_end_date => ld_effective_end_date
914: );
915:

Line 931: ,p_sit_additional_tax => NVL(fnd_number.canonical_to_number(lct_region2.aei_information18),0)

927: ,p_datetrack_update_mode => lv_datetrack_update_mode
928: ,p_emp_state_tax_rule_id => ln_emp_state_tax_rule_id
929: ,p_object_version_number => ln_st_object_version_number
930: ,p_filing_status_code => LPAD(lct_region2.aei_information15,2,'0')
931: ,p_sit_additional_tax => NVL(fnd_number.canonical_to_number(lct_region2.aei_information18),0)
932: ,p_sit_override_amount => NVL(fnd_number.canonical_to_number(lct_region2.aei_information20),0)
933: ,p_sit_override_rate => NVL(fnd_number.canonical_to_number(lct_region2.aei_information19),0)
934: ,p_withholding_allowances => NVL(fnd_number.canonical_to_number(lct_region2.aei_information17),0)
935: ,p_sit_exempt => lct_region2.aei_information16

Line 932: ,p_sit_override_amount => NVL(fnd_number.canonical_to_number(lct_region2.aei_information20),0)

928: ,p_emp_state_tax_rule_id => ln_emp_state_tax_rule_id
929: ,p_object_version_number => ln_st_object_version_number
930: ,p_filing_status_code => LPAD(lct_region2.aei_information15,2,'0')
931: ,p_sit_additional_tax => NVL(fnd_number.canonical_to_number(lct_region2.aei_information18),0)
932: ,p_sit_override_amount => NVL(fnd_number.canonical_to_number(lct_region2.aei_information20),0)
933: ,p_sit_override_rate => NVL(fnd_number.canonical_to_number(lct_region2.aei_information19),0)
934: ,p_withholding_allowances => NVL(fnd_number.canonical_to_number(lct_region2.aei_information17),0)
935: ,p_sit_exempt => lct_region2.aei_information16
936: ,p_supp_tax_override_rate => NVL(fnd_number.canonical_to_number(lct_region2.aei_information21),0)

Line 933: ,p_sit_override_rate => NVL(fnd_number.canonical_to_number(lct_region2.aei_information19),0)

929: ,p_object_version_number => ln_st_object_version_number
930: ,p_filing_status_code => LPAD(lct_region2.aei_information15,2,'0')
931: ,p_sit_additional_tax => NVL(fnd_number.canonical_to_number(lct_region2.aei_information18),0)
932: ,p_sit_override_amount => NVL(fnd_number.canonical_to_number(lct_region2.aei_information20),0)
933: ,p_sit_override_rate => NVL(fnd_number.canonical_to_number(lct_region2.aei_information19),0)
934: ,p_withholding_allowances => NVL(fnd_number.canonical_to_number(lct_region2.aei_information17),0)
935: ,p_sit_exempt => lct_region2.aei_information16
936: ,p_supp_tax_override_rate => NVL(fnd_number.canonical_to_number(lct_region2.aei_information21),0)
937: ,p_effective_start_date => ld_effective_start_date

Line 934: ,p_withholding_allowances => NVL(fnd_number.canonical_to_number(lct_region2.aei_information17),0)

930: ,p_filing_status_code => LPAD(lct_region2.aei_information15,2,'0')
931: ,p_sit_additional_tax => NVL(fnd_number.canonical_to_number(lct_region2.aei_information18),0)
932: ,p_sit_override_amount => NVL(fnd_number.canonical_to_number(lct_region2.aei_information20),0)
933: ,p_sit_override_rate => NVL(fnd_number.canonical_to_number(lct_region2.aei_information19),0)
934: ,p_withholding_allowances => NVL(fnd_number.canonical_to_number(lct_region2.aei_information17),0)
935: ,p_sit_exempt => lct_region2.aei_information16
936: ,p_supp_tax_override_rate => NVL(fnd_number.canonical_to_number(lct_region2.aei_information21),0)
937: ,p_effective_start_date => ld_effective_start_date
938: ,p_effective_end_date => ld_effective_end_date

Line 936: ,p_supp_tax_override_rate => NVL(fnd_number.canonical_to_number(lct_region2.aei_information21),0)

932: ,p_sit_override_amount => NVL(fnd_number.canonical_to_number(lct_region2.aei_information20),0)
933: ,p_sit_override_rate => NVL(fnd_number.canonical_to_number(lct_region2.aei_information19),0)
934: ,p_withholding_allowances => NVL(fnd_number.canonical_to_number(lct_region2.aei_information17),0)
935: ,p_sit_exempt => lct_region2.aei_information16
936: ,p_supp_tax_override_rate => NVL(fnd_number.canonical_to_number(lct_region2.aei_information21),0)
937: ,p_effective_start_date => ld_effective_start_date
938: ,p_effective_end_date => ld_effective_end_date
939: );
940:

Line 1687: := fnd_number.number_to_canonical(ln_proposed_salary) ;

1683: := lv_hourly_salaried_desc;
1684: pay_emp_action_arch.lrr_act_tab(ln_index).act_info27
1685: := lv_step ;
1686: pay_emp_action_arch.lrr_act_tab(ln_index).act_info28
1687: := fnd_number.number_to_canonical(ln_proposed_salary) ;
1688: pay_emp_action_arch.lrr_act_tab(ln_index).act_info29
1689: := fnd_number.number_to_canonical(ln_pay_annualization_factor) ;
1690: pay_emp_action_arch.lrr_act_tab(ln_index).act_info30
1691: := lv_location_code ;

Line 1689: := fnd_number.number_to_canonical(ln_pay_annualization_factor) ;

1685: := lv_step ;
1686: pay_emp_action_arch.lrr_act_tab(ln_index).act_info28
1687: := fnd_number.number_to_canonical(ln_proposed_salary) ;
1688: pay_emp_action_arch.lrr_act_tab(ln_index).act_info29
1689: := fnd_number.number_to_canonical(ln_pay_annualization_factor) ;
1690: pay_emp_action_arch.lrr_act_tab(ln_index).act_info30
1691: := lv_location_code ;
1692:
1693: hr_utility.set_location(gv_package || lv_procedure_name, 190);

Line 2044: := fnd_number.number_to_canonical(ln_current_hours);

2040:
2041: lv_action_category := 'AC EARNINGS';
2042:
2043: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info11
2044: := fnd_number.number_to_canonical(ln_current_hours);
2045:
2046: IF ln_current_hours <> 0 AND ln_current_amount <> 0 THEN
2047:
2048: hr_utility.set_location(gv_package || lv_procedure_name, 240);

Line 2089: := fnd_number.number_to_canonical(ln_ytd_hours);

2085:
2086: END IF;
2087:
2088: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info12
2089: := fnd_number.number_to_canonical(ln_ytd_hours);
2090:
2091: END IF; /*p_element_classification_name IF*/
2092:
2093: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).action_info_category

Line 2109: := fnd_number.number_to_canonical(NVL(ln_current_amount,0));

2105: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info7
2106: := p_processing_priority;
2107:
2108: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info8
2109: := fnd_number.number_to_canonical(NVL(ln_current_amount,0));
2110: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info9
2111: := fnd_number.number_to_canonical(NVL(ln_ytd_amount,0));
2112:
2113: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info10

Line 2111: := fnd_number.number_to_canonical(NVL(ln_ytd_amount,0));

2107:
2108: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info8
2109: := fnd_number.number_to_canonical(NVL(ln_current_amount,0));
2110: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info9
2111: := fnd_number.number_to_canonical(NVL(ln_ytd_amount,0));
2112:
2113: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info10
2114: := p_reporting_name;
2115:

Line 2845: := fnd_number.number_to_canonical(ln_rate);

2841: := ln_element_type_id;
2842: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
2843: := lv_element_name;
2844: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
2845: := fnd_number.number_to_canonical(ln_rate);
2846: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
2847: := fnd_number.number_to_canonical(ln_hours);
2848: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
2849: := lv_processing_priority;

Line 2847: := fnd_number.number_to_canonical(ln_hours);

2843: := lv_element_name;
2844: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
2845: := fnd_number.number_to_canonical(ln_rate);
2846: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
2847: := fnd_number.number_to_canonical(ln_hours);
2848: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
2849: := lv_processing_priority;
2850: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
2851: := fnd_number.number_to_canonical(ln_multiple);

Line 2851: := fnd_number.number_to_canonical(ln_multiple);

2847: := fnd_number.number_to_canonical(ln_hours);
2848: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
2849: := lv_processing_priority;
2850: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
2851: := fnd_number.number_to_canonical(ln_multiple);
2852: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
2853: := fnd_number.number_to_canonical(ln_amount);
2854:
2855: hr_utility.set_location(gv_package || lv_procedure_name, 30);

Line 2853: := fnd_number.number_to_canonical(ln_amount);

2849: := lv_processing_priority;
2850: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
2851: := fnd_number.number_to_canonical(ln_multiple);
2852: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
2853: := fnd_number.number_to_canonical(ln_amount);
2854:
2855: hr_utility.set_location(gv_package || lv_procedure_name, 30);
2856:
2857: END LOOP;

Line 2975: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info8),0);

2971: = 'Earnings' THEN
2972:
2973: lv_earnings
2974: := lv_earnings +
2975: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info8),0);
2976: lv_ytd_earnings
2977: := lv_ytd_earnings +
2978: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);
2979:

Line 2978: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);

2974: := lv_earnings +
2975: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info8),0);
2976: lv_ytd_earnings
2977: := lv_ytd_earnings +
2978: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);
2979:
2980: ELSIF pay_us_payslip_simulation_main.lrr_act_tab(i).act_info1
2981: = 'Supplemental Earnings' THEN
2982:

Line 2985: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info8),0);

2981: = 'Supplemental Earnings' THEN
2982:
2983: lv_supplemental_earnings
2984: := lv_supplemental_earnings +
2985: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info8),0);
2986: lv_ytd_supplemental_earnings
2987: := lv_ytd_supplemental_earnings +
2988: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);
2989:

Line 2988: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);

2984: := lv_supplemental_earnings +
2985: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info8),0);
2986: lv_ytd_supplemental_earnings
2987: := lv_ytd_supplemental_earnings +
2988: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);
2989:
2990: ELSIF pay_us_payslip_simulation_main.lrr_act_tab(i).act_info1
2991: = 'Imputed Earnings' THEN
2992:

Line 2995: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info8),0);

2991: = 'Imputed Earnings' THEN
2992:
2993: lv_imputed_earnings
2994: := lv_imputed_earnings +
2995: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info8),0);
2996: lv_ytd_imputed_earnings
2997: := lv_ytd_imputed_earnings +
2998: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);
2999:

Line 2998: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);

2994: := lv_imputed_earnings +
2995: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info8),0);
2996: lv_ytd_imputed_earnings
2997: := lv_ytd_imputed_earnings +
2998: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);
2999:
3000: ELSIF pay_us_payslip_simulation_main.lrr_act_tab(i).act_info1
3001: = 'Non-payroll Payments' THEN
3002:

Line 3005: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info8),0);

3001: = 'Non-payroll Payments' THEN
3002:
3003: lv_non_payroll_payments
3004: := lv_non_payroll_payments +
3005: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info8),0);
3006: lv_ytd_non_payroll_payments
3007: := lv_ytd_non_payroll_payments +
3008: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);
3009:

Line 3008: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);

3004: := lv_non_payroll_payments +
3005: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info8),0);
3006: lv_ytd_non_payroll_payments
3007: := lv_ytd_non_payroll_payments +
3008: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);
3009:
3010: ELSIF pay_us_payslip_simulation_main.lrr_act_tab(i).act_info1
3011: = 'Taxable Benefits' THEN
3012:

Line 3015: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info8),0);

3011: = 'Taxable Benefits' THEN
3012:
3013: lv_taxable_benefits
3014: := lv_taxable_benefits +
3015: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info8),0);
3016: lv_ytd_taxable_benefits
3017: := lv_ytd_taxable_benefits +
3018: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);
3019:

Line 3018: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);

3014: := lv_taxable_benefits +
3015: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info8),0);
3016: lv_ytd_taxable_benefits
3017: := lv_ytd_taxable_benefits +
3018: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);
3019:
3020: ELSIF pay_us_payslip_simulation_main.lrr_act_tab(i).act_info1
3021: = 'Alien/Expat Earnings' THEN
3022:

Line 3025: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info8),0);

3021: = 'Alien/Expat Earnings' THEN
3022:
3023: lv_alien_expat_earnings
3024: := lv_alien_expat_earnings +
3025: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info8),0);
3026: lv_ytd_alien_expat_earnings
3027: := lv_ytd_alien_expat_earnings +
3028: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);
3029:

Line 3028: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);

3024: := lv_alien_expat_earnings +
3025: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info8),0);
3026: lv_ytd_alien_expat_earnings
3027: := lv_ytd_alien_expat_earnings +
3028: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);
3029:
3030: END IF; /* End of AC EARNINGS Section */
3031:
3032: ELSIF pay_us_payslip_simulation_main.lrr_act_tab(i).action_info_category

Line 3040: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info8),0);

3036: = 'Pre-Tax Deductions' THEN
3037:
3038: lv_pre_tax_deductions
3039: := lv_pre_tax_deductions +
3040: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info8),0);
3041: lv_ytd_pre_tax_deductions
3042: := lv_ytd_pre_tax_deductions +
3043: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);
3044:

Line 3043: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);

3039: := lv_pre_tax_deductions +
3040: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info8),0);
3041: lv_ytd_pre_tax_deductions
3042: := lv_ytd_pre_tax_deductions +
3043: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);
3044:
3045: ELSIF pay_us_payslip_simulation_main.lrr_act_tab(i).act_info1
3046: = 'Involuntary Deductions' THEN
3047:

Line 3050: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info8),0);

3046: = 'Involuntary Deductions' THEN
3047:
3048: lv_involuntary_deductions
3049: := lv_involuntary_deductions +
3050: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info8),0);
3051: lv_ytd_involuntary_deductions
3052: := lv_ytd_involuntary_deductions +
3053: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);
3054:

Line 3053: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);

3049: := lv_involuntary_deductions +
3050: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info8),0);
3051: lv_ytd_involuntary_deductions
3052: := lv_ytd_involuntary_deductions +
3053: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);
3054:
3055: ELSIF pay_us_payslip_simulation_main.lrr_act_tab(i).act_info1
3056: = 'Voluntary Deductions' THEN
3057:

Line 3060: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info8),0);

3056: = 'Voluntary Deductions' THEN
3057:
3058: lv_voluntary_deductions
3059: := lv_voluntary_deductions +
3060: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info8),0);
3061: lv_ytd_voluntary_deductions
3062: := lv_ytd_voluntary_deductions +
3063: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);
3064:

Line 3063: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);

3059: := lv_voluntary_deductions +
3060: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info8),0);
3061: lv_ytd_voluntary_deductions
3062: := lv_ytd_voluntary_deductions +
3063: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);
3064:
3065: ELSIF pay_us_payslip_simulation_main.lrr_act_tab(i).act_info1
3066: = 'Tax Deductions' THEN
3067:

Line 3070: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info8),0);

3066: = 'Tax Deductions' THEN
3067:
3068: lv_tax_deductions
3069: := lv_tax_deductions +
3070: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info8),0);
3071: lv_ytd_tax_deductions
3072: := lv_ytd_tax_deductions +
3073: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);
3074:

Line 3073: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);

3069: := lv_tax_deductions +
3070: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info8),0);
3071: lv_ytd_tax_deductions
3072: := lv_ytd_tax_deductions +
3073: NVL(fnd_number.canonical_to_number(pay_us_payslip_simulation_main.lrr_act_tab(i).act_info9),0);
3074:
3075: END IF; /* End of AC DEDUCTIONS Section */
3076:
3077: END IF; /* action_info_category IF */

Line 3119: := fnd_number.number_to_canonical(lv_earnings); /Bug 3311866/

3115: := 'AC SUMMARY CURRENT';
3116: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).jurisdiction_code
3117: := '00-000-0000';
3118: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info4
3119: := fnd_number.number_to_canonical(lv_earnings); /*Bug 3311866*/
3120: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info5
3121: := fnd_number.number_to_canonical(lv_supplemental_earnings) ;
3122: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info6
3123: := fnd_number.number_to_canonical(lv_imputed_earnings);

Line 3121: := fnd_number.number_to_canonical(lv_supplemental_earnings) ;

3117: := '00-000-0000';
3118: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info4
3119: := fnd_number.number_to_canonical(lv_earnings); /*Bug 3311866*/
3120: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info5
3121: := fnd_number.number_to_canonical(lv_supplemental_earnings) ;
3122: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info6
3123: := fnd_number.number_to_canonical(lv_imputed_earnings);
3124: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info7
3125: := fnd_number.number_to_canonical(lv_pre_tax_deductions) ;

Line 3123: := fnd_number.number_to_canonical(lv_imputed_earnings);

3119: := fnd_number.number_to_canonical(lv_earnings); /*Bug 3311866*/
3120: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info5
3121: := fnd_number.number_to_canonical(lv_supplemental_earnings) ;
3122: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info6
3123: := fnd_number.number_to_canonical(lv_imputed_earnings);
3124: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info7
3125: := fnd_number.number_to_canonical(lv_pre_tax_deductions) ;
3126: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info8
3127: := fnd_number.number_to_canonical(lv_involuntary_deductions);

Line 3125: := fnd_number.number_to_canonical(lv_pre_tax_deductions) ;

3121: := fnd_number.number_to_canonical(lv_supplemental_earnings) ;
3122: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info6
3123: := fnd_number.number_to_canonical(lv_imputed_earnings);
3124: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info7
3125: := fnd_number.number_to_canonical(lv_pre_tax_deductions) ;
3126: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info8
3127: := fnd_number.number_to_canonical(lv_involuntary_deductions);
3128: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info9
3129: := fnd_number.number_to_canonical(lv_voluntary_deductions) ;

Line 3127: := fnd_number.number_to_canonical(lv_involuntary_deductions);

3123: := fnd_number.number_to_canonical(lv_imputed_earnings);
3124: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info7
3125: := fnd_number.number_to_canonical(lv_pre_tax_deductions) ;
3126: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info8
3127: := fnd_number.number_to_canonical(lv_involuntary_deductions);
3128: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info9
3129: := fnd_number.number_to_canonical(lv_voluntary_deductions) ;
3130: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info10
3131: := fnd_number.number_to_canonical(lv_tax_deductions) ;

Line 3129: := fnd_number.number_to_canonical(lv_voluntary_deductions) ;

3125: := fnd_number.number_to_canonical(lv_pre_tax_deductions) ;
3126: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info8
3127: := fnd_number.number_to_canonical(lv_involuntary_deductions);
3128: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info9
3129: := fnd_number.number_to_canonical(lv_voluntary_deductions) ;
3130: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info10
3131: := fnd_number.number_to_canonical(lv_tax_deductions) ;
3132: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info11
3133: := fnd_number.number_to_canonical(lv_taxable_benefits);

Line 3131: := fnd_number.number_to_canonical(lv_tax_deductions) ;

3127: := fnd_number.number_to_canonical(lv_involuntary_deductions);
3128: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info9
3129: := fnd_number.number_to_canonical(lv_voluntary_deductions) ;
3130: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info10
3131: := fnd_number.number_to_canonical(lv_tax_deductions) ;
3132: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info11
3133: := fnd_number.number_to_canonical(lv_taxable_benefits);
3134: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info12
3135: := fnd_number.number_to_canonical(lv_alien_expat_earnings);

Line 3133: := fnd_number.number_to_canonical(lv_taxable_benefits);

3129: := fnd_number.number_to_canonical(lv_voluntary_deductions) ;
3130: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info10
3131: := fnd_number.number_to_canonical(lv_tax_deductions) ;
3132: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info11
3133: := fnd_number.number_to_canonical(lv_taxable_benefits);
3134: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info12
3135: := fnd_number.number_to_canonical(lv_alien_expat_earnings);
3136: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info13
3137: := fnd_number.number_to_canonical(lv_non_payroll_payments);

Line 3135: := fnd_number.number_to_canonical(lv_alien_expat_earnings);

3131: := fnd_number.number_to_canonical(lv_tax_deductions) ;
3132: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info11
3133: := fnd_number.number_to_canonical(lv_taxable_benefits);
3134: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info12
3135: := fnd_number.number_to_canonical(lv_alien_expat_earnings);
3136: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info13
3137: := fnd_number.number_to_canonical(lv_non_payroll_payments);
3138: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info14
3139: := lv_current_label;

Line 3137: := fnd_number.number_to_canonical(lv_non_payroll_payments);

3133: := fnd_number.number_to_canonical(lv_taxable_benefits);
3134: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info12
3135: := fnd_number.number_to_canonical(lv_alien_expat_earnings);
3136: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info13
3137: := fnd_number.number_to_canonical(lv_non_payroll_payments);
3138: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info14
3139: := lv_current_label;
3140: /* Determining Net Current Value below. In Regular Archiver Net value is
3141: determined based on PAYMENTS Dimension. But in Payroll Simulation, since

Line 3145: := fnd_number.number_to_canonical(lv_earnings

3141: determined based on PAYMENTS Dimension. But in Payroll Simulation, since
3142: Prepayments will not be run, the Net value will be determined based on
3143: the Earnings and Deductions */
3144: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info15
3145: := fnd_number.number_to_canonical(lv_earnings
3146: + lv_supplemental_earnings
3147: - lv_pre_tax_deductions
3148: - lv_involuntary_deductions
3149: - lv_voluntary_deductions

Line 3154: lv_estimated_net := fnd_number.canonical_to_number(

3150: - lv_tax_deductions
3151: + lv_alien_expat_earnings
3152: + lv_non_payroll_payments);
3153:
3154: lv_estimated_net := fnd_number.canonical_to_number(
3155: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info15);
3156:
3157: /* YTD Values */
3158:

Line 3166: := fnd_number.number_to_canonical(lv_ytd_earnings); /Bug 3311866/

3162: := 'AC SUMMARY YTD';
3163: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).jurisdiction_code
3164: := '00-000-0000';
3165: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info4
3166: := fnd_number.number_to_canonical(lv_ytd_earnings); /*Bug 3311866*/
3167: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info5
3168: := fnd_number.number_to_canonical(lv_ytd_supplemental_earnings) ;
3169: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info6
3170: := fnd_number.number_to_canonical(lv_ytd_imputed_earnings);

Line 3168: := fnd_number.number_to_canonical(lv_ytd_supplemental_earnings) ;

3164: := '00-000-0000';
3165: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info4
3166: := fnd_number.number_to_canonical(lv_ytd_earnings); /*Bug 3311866*/
3167: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info5
3168: := fnd_number.number_to_canonical(lv_ytd_supplemental_earnings) ;
3169: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info6
3170: := fnd_number.number_to_canonical(lv_ytd_imputed_earnings);
3171: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info7
3172: := fnd_number.number_to_canonical(lv_ytd_pre_tax_deductions) ;

Line 3170: := fnd_number.number_to_canonical(lv_ytd_imputed_earnings);

3166: := fnd_number.number_to_canonical(lv_ytd_earnings); /*Bug 3311866*/
3167: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info5
3168: := fnd_number.number_to_canonical(lv_ytd_supplemental_earnings) ;
3169: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info6
3170: := fnd_number.number_to_canonical(lv_ytd_imputed_earnings);
3171: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info7
3172: := fnd_number.number_to_canonical(lv_ytd_pre_tax_deductions) ;
3173: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info8
3174: := fnd_number.number_to_canonical(lv_ytd_involuntary_deductions);

Line 3172: := fnd_number.number_to_canonical(lv_ytd_pre_tax_deductions) ;

3168: := fnd_number.number_to_canonical(lv_ytd_supplemental_earnings) ;
3169: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info6
3170: := fnd_number.number_to_canonical(lv_ytd_imputed_earnings);
3171: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info7
3172: := fnd_number.number_to_canonical(lv_ytd_pre_tax_deductions) ;
3173: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info8
3174: := fnd_number.number_to_canonical(lv_ytd_involuntary_deductions);
3175: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info9
3176: := fnd_number.number_to_canonical(lv_ytd_voluntary_deductions) ;

Line 3174: := fnd_number.number_to_canonical(lv_ytd_involuntary_deductions);

3170: := fnd_number.number_to_canonical(lv_ytd_imputed_earnings);
3171: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info7
3172: := fnd_number.number_to_canonical(lv_ytd_pre_tax_deductions) ;
3173: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info8
3174: := fnd_number.number_to_canonical(lv_ytd_involuntary_deductions);
3175: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info9
3176: := fnd_number.number_to_canonical(lv_ytd_voluntary_deductions) ;
3177: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info10
3178: := fnd_number.number_to_canonical(lv_ytd_tax_deductions) ;

Line 3176: := fnd_number.number_to_canonical(lv_ytd_voluntary_deductions) ;

3172: := fnd_number.number_to_canonical(lv_ytd_pre_tax_deductions) ;
3173: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info8
3174: := fnd_number.number_to_canonical(lv_ytd_involuntary_deductions);
3175: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info9
3176: := fnd_number.number_to_canonical(lv_ytd_voluntary_deductions) ;
3177: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info10
3178: := fnd_number.number_to_canonical(lv_ytd_tax_deductions) ;
3179: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info11
3180: := fnd_number.number_to_canonical(lv_ytd_taxable_benefits);

Line 3178: := fnd_number.number_to_canonical(lv_ytd_tax_deductions) ;

3174: := fnd_number.number_to_canonical(lv_ytd_involuntary_deductions);
3175: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info9
3176: := fnd_number.number_to_canonical(lv_ytd_voluntary_deductions) ;
3177: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info10
3178: := fnd_number.number_to_canonical(lv_ytd_tax_deductions) ;
3179: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info11
3180: := fnd_number.number_to_canonical(lv_ytd_taxable_benefits);
3181: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info12
3182: := fnd_number.number_to_canonical(lv_ytd_alien_expat_earnings);

Line 3180: := fnd_number.number_to_canonical(lv_ytd_taxable_benefits);

3176: := fnd_number.number_to_canonical(lv_ytd_voluntary_deductions) ;
3177: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info10
3178: := fnd_number.number_to_canonical(lv_ytd_tax_deductions) ;
3179: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info11
3180: := fnd_number.number_to_canonical(lv_ytd_taxable_benefits);
3181: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info12
3182: := fnd_number.number_to_canonical(lv_ytd_alien_expat_earnings);
3183: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info13
3184: := fnd_number.number_to_canonical(lv_ytd_non_payroll_payments);

Line 3182: := fnd_number.number_to_canonical(lv_ytd_alien_expat_earnings);

3178: := fnd_number.number_to_canonical(lv_ytd_tax_deductions) ;
3179: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info11
3180: := fnd_number.number_to_canonical(lv_ytd_taxable_benefits);
3181: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info12
3182: := fnd_number.number_to_canonical(lv_ytd_alien_expat_earnings);
3183: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info13
3184: := fnd_number.number_to_canonical(lv_ytd_non_payroll_payments);
3185: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info14
3186: := lv_ytd_label;

Line 3184: := fnd_number.number_to_canonical(lv_ytd_non_payroll_payments);

3180: := fnd_number.number_to_canonical(lv_ytd_taxable_benefits);
3181: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info12
3182: := fnd_number.number_to_canonical(lv_ytd_alien_expat_earnings);
3183: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info13
3184: := fnd_number.number_to_canonical(lv_ytd_non_payroll_payments);
3185: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info14
3186: := lv_ytd_label;
3187: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info15
3188: := fnd_number.number_to_canonical(lv_ytd_earnings

Line 3188: := fnd_number.number_to_canonical(lv_ytd_earnings

3184: := fnd_number.number_to_canonical(lv_ytd_non_payroll_payments);
3185: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info14
3186: := lv_ytd_label;
3187: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info15
3188: := fnd_number.number_to_canonical(lv_ytd_earnings
3189: + lv_ytd_supplemental_earnings
3190: - lv_ytd_pre_tax_deductions
3191: - lv_ytd_involuntary_deductions
3192: - lv_ytd_voluntary_deductions

Line 3208: := fnd_number.number_to_canonical(lv_pre_tax_deductions);

3204: := 'AC SIM GRAPH ESTIMATED';
3205: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).jurisdiction_code
3206: := '00-000-0000';
3207: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info1
3208: := fnd_number.number_to_canonical(lv_pre_tax_deductions);
3209: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info2
3210: := fnd_number.number_to_canonical(lv_involuntary_deductions +
3211: lv_voluntary_deductions);
3212: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info3

Line 3210: := fnd_number.number_to_canonical(lv_involuntary_deductions +

3206: := '00-000-0000';
3207: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info1
3208: := fnd_number.number_to_canonical(lv_pre_tax_deductions);
3209: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info2
3210: := fnd_number.number_to_canonical(lv_involuntary_deductions +
3211: lv_voluntary_deductions);
3212: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info3
3213: := fnd_number.number_to_canonical(lv_tax_deductions);
3214: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info4

Line 3213: := fnd_number.number_to_canonical(lv_tax_deductions);

3209: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info2
3210: := fnd_number.number_to_canonical(lv_involuntary_deductions +
3211: lv_voluntary_deductions);
3212: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info3
3213: := fnd_number.number_to_canonical(lv_tax_deductions);
3214: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info4
3215: := fnd_number.number_to_canonical(lv_estimated_net);
3216:
3217: /* Archive Current Values for Summary */

Line 3215: := fnd_number.number_to_canonical(lv_estimated_net);

3211: lv_voluntary_deductions);
3212: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info3
3213: := fnd_number.number_to_canonical(lv_tax_deductions);
3214: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info4
3215: := fnd_number.number_to_canonical(lv_estimated_net);
3216:
3217: /* Archive Current Values for Summary */
3218: /* Archived values are stored in Canonical Form. So we are directly
3219: assigning them without conversion. Only when calculation is to be

Line 3250: := fnd_number.number_to_canonical(

3246: := '00-000-0000';
3247: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info1
3248: := lv_prev_pre_tax_deductions;
3249: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info2
3250: := fnd_number.number_to_canonical(
3251: fnd_number.canonical_to_number(lv_prev_involuntary_deductions) +
3252: fnd_number.canonical_to_number(lv_prev_voluntary_deductions));
3253: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info3
3254: := lv_prev_tax_deductions;

Line 3251: fnd_number.canonical_to_number(lv_prev_involuntary_deductions) +

3247: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info1
3248: := lv_prev_pre_tax_deductions;
3249: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info2
3250: := fnd_number.number_to_canonical(
3251: fnd_number.canonical_to_number(lv_prev_involuntary_deductions) +
3252: fnd_number.canonical_to_number(lv_prev_voluntary_deductions));
3253: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info3
3254: := lv_prev_tax_deductions;
3255: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info4

Line 3252: fnd_number.canonical_to_number(lv_prev_voluntary_deductions));

3248: := lv_prev_pre_tax_deductions;
3249: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info2
3250: := fnd_number.number_to_canonical(
3251: fnd_number.canonical_to_number(lv_prev_involuntary_deductions) +
3252: fnd_number.canonical_to_number(lv_prev_voluntary_deductions));
3253: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info3
3254: := lv_prev_tax_deductions;
3255: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info4
3256: := fnd_number.number_to_canonical(

Line 3256: := fnd_number.number_to_canonical(

3252: fnd_number.canonical_to_number(lv_prev_voluntary_deductions));
3253: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info3
3254: := lv_prev_tax_deductions;
3255: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info4
3256: := fnd_number.number_to_canonical(
3257: fnd_number.canonical_to_number(lv_prev_earnings)
3258: + fnd_number.canonical_to_number(lv_prev_supplemental_earnings)
3259: - fnd_number.canonical_to_number(lv_prev_pre_tax_deductions)
3260: - fnd_number.canonical_to_number(lv_prev_involuntary_deductions)

Line 3257: fnd_number.canonical_to_number(lv_prev_earnings)

3253: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info3
3254: := lv_prev_tax_deductions;
3255: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info4
3256: := fnd_number.number_to_canonical(
3257: fnd_number.canonical_to_number(lv_prev_earnings)
3258: + fnd_number.canonical_to_number(lv_prev_supplemental_earnings)
3259: - fnd_number.canonical_to_number(lv_prev_pre_tax_deductions)
3260: - fnd_number.canonical_to_number(lv_prev_involuntary_deductions)
3261: - fnd_number.canonical_to_number(lv_prev_voluntary_deductions)

Line 3258: + fnd_number.canonical_to_number(lv_prev_supplemental_earnings)

3254: := lv_prev_tax_deductions;
3255: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info4
3256: := fnd_number.number_to_canonical(
3257: fnd_number.canonical_to_number(lv_prev_earnings)
3258: + fnd_number.canonical_to_number(lv_prev_supplemental_earnings)
3259: - fnd_number.canonical_to_number(lv_prev_pre_tax_deductions)
3260: - fnd_number.canonical_to_number(lv_prev_involuntary_deductions)
3261: - fnd_number.canonical_to_number(lv_prev_voluntary_deductions)
3262: - fnd_number.canonical_to_number(lv_prev_tax_deductions)

Line 3259: - fnd_number.canonical_to_number(lv_prev_pre_tax_deductions)

3255: pay_us_payslip_simulation_main.lrr_act_tab(ln_index).act_info4
3256: := fnd_number.number_to_canonical(
3257: fnd_number.canonical_to_number(lv_prev_earnings)
3258: + fnd_number.canonical_to_number(lv_prev_supplemental_earnings)
3259: - fnd_number.canonical_to_number(lv_prev_pre_tax_deductions)
3260: - fnd_number.canonical_to_number(lv_prev_involuntary_deductions)
3261: - fnd_number.canonical_to_number(lv_prev_voluntary_deductions)
3262: - fnd_number.canonical_to_number(lv_prev_tax_deductions)
3263: + fnd_number.canonical_to_number(lv_prev_alien_expat_earnings)

Line 3260: - fnd_number.canonical_to_number(lv_prev_involuntary_deductions)

3256: := fnd_number.number_to_canonical(
3257: fnd_number.canonical_to_number(lv_prev_earnings)
3258: + fnd_number.canonical_to_number(lv_prev_supplemental_earnings)
3259: - fnd_number.canonical_to_number(lv_prev_pre_tax_deductions)
3260: - fnd_number.canonical_to_number(lv_prev_involuntary_deductions)
3261: - fnd_number.canonical_to_number(lv_prev_voluntary_deductions)
3262: - fnd_number.canonical_to_number(lv_prev_tax_deductions)
3263: + fnd_number.canonical_to_number(lv_prev_alien_expat_earnings)
3264: + fnd_number.canonical_to_number(lv_prev_non_payroll_payments));

Line 3261: - fnd_number.canonical_to_number(lv_prev_voluntary_deductions)

3257: fnd_number.canonical_to_number(lv_prev_earnings)
3258: + fnd_number.canonical_to_number(lv_prev_supplemental_earnings)
3259: - fnd_number.canonical_to_number(lv_prev_pre_tax_deductions)
3260: - fnd_number.canonical_to_number(lv_prev_involuntary_deductions)
3261: - fnd_number.canonical_to_number(lv_prev_voluntary_deductions)
3262: - fnd_number.canonical_to_number(lv_prev_tax_deductions)
3263: + fnd_number.canonical_to_number(lv_prev_alien_expat_earnings)
3264: + fnd_number.canonical_to_number(lv_prev_non_payroll_payments));
3265:

Line 3262: - fnd_number.canonical_to_number(lv_prev_tax_deductions)

3258: + fnd_number.canonical_to_number(lv_prev_supplemental_earnings)
3259: - fnd_number.canonical_to_number(lv_prev_pre_tax_deductions)
3260: - fnd_number.canonical_to_number(lv_prev_involuntary_deductions)
3261: - fnd_number.canonical_to_number(lv_prev_voluntary_deductions)
3262: - fnd_number.canonical_to_number(lv_prev_tax_deductions)
3263: + fnd_number.canonical_to_number(lv_prev_alien_expat_earnings)
3264: + fnd_number.canonical_to_number(lv_prev_non_payroll_payments));
3265:
3266: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);

Line 3263: + fnd_number.canonical_to_number(lv_prev_alien_expat_earnings)

3259: - fnd_number.canonical_to_number(lv_prev_pre_tax_deductions)
3260: - fnd_number.canonical_to_number(lv_prev_involuntary_deductions)
3261: - fnd_number.canonical_to_number(lv_prev_voluntary_deductions)
3262: - fnd_number.canonical_to_number(lv_prev_tax_deductions)
3263: + fnd_number.canonical_to_number(lv_prev_alien_expat_earnings)
3264: + fnd_number.canonical_to_number(lv_prev_non_payroll_payments));
3265:
3266: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);
3267:

Line 3264: + fnd_number.canonical_to_number(lv_prev_non_payroll_payments));

3260: - fnd_number.canonical_to_number(lv_prev_involuntary_deductions)
3261: - fnd_number.canonical_to_number(lv_prev_voluntary_deductions)
3262: - fnd_number.canonical_to_number(lv_prev_tax_deductions)
3263: + fnd_number.canonical_to_number(lv_prev_alien_expat_earnings)
3264: + fnd_number.canonical_to_number(lv_prev_non_payroll_payments));
3265:
3266: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);
3267:
3268: END populate_summary;