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

Line 64: fnd_number.canonical_to_number

60: print instructions page type T4ERPAPER.
61: Type T4ERPAPER means report is run
62: with Employer option.
63: 28-Jul-2009 aneghosh 115.22 8635769 Replaced to_number with
64: fnd_number.canonical_to_number
65:
66: 09-Dec-2009 sneelapa 115.23 9135405 Added other info codes 66 - 69
67: Modified CURSOR c_other_info_value.
68: 21-Dec-2009 sneelapa 115.24 7835218 Modified Logic for calculating EMPLOYEE

Line 285: and fnd_number.canonical_to_number(substr(paa.serial_number,3,14)) = paa1.assignment_action_id

281: pay_payroll_actions ppa1
282: where ppa.payroll_action_id = paa.payroll_action_id
283: and ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
284: and paa.assignment_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
285: and fnd_number.canonical_to_number(substr(paa.serial_number,3,14)) = paa1.assignment_action_id
286: and paa1.payroll_action_id = ppa1.payroll_action_id
287: and ((ppa1.report_type = decode(ppa.report_type,'T4_XML','T4','PAYCAT4AMPDF','CAEOY_T4_AMEND_PP')
288: and ppa.report_type <> 'PAYCAT4CLPDF') or (ppa.report_type = 'PAYCAT4CLPDF' and
289: ppa1.report_type in ('T4_XML','PAYCAT4AMPDF')))

Line 789: lv_person_id := fnd_number.canonical_to_number(pay_ca_archive_utils.get_archive_value(p_aa_id,

785: substr(upper(pay_ca_archive_utils.get_archive_value(p_aa_id,
786: 'CAEOY_EMPLOYEE_LAST_NAME')),1,30); -- employee_last_name
787:
788:
789: lv_person_id := fnd_number.canonical_to_number(pay_ca_archive_utils.get_archive_value(p_aa_id,
790: 'CAEOY_PERSON_ID'));
791:
792: address := pay_ca_rl1_reg.get_primary_address(lv_person_id, sysdate());
793:

Line 850: if fnd_number.canonical_to_number(lv_employment_income) = 0 then

846: pay_ca_archive_utils.get_archive_value(p_aa_id,p_prov,
847: 'JURISDICTION_CODE',
848: 'CAEOY_GROSS_EARNINGS_PER_JD_GRE_YTD'); -- employment_income
849:
850: if fnd_number.canonical_to_number(lv_employment_income) = 0 then
851: lv_employment_income := null;
852: end if;
853:
854: lv_income_tax_deducted :=

Line 859: if fnd_number.canonical_to_number(lv_income_tax_deducted) = 0 then

855: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,
856: 'JURISDICTION_CODE',
857: 'CAEOY_FED_WITHHELD_PER_JD_GRE_YTD'); -- income_tax_deducted
858:
859: if fnd_number.canonical_to_number(lv_income_tax_deducted) = 0 then
860: lv_income_tax_deducted := null;
861: end if;
862:
863: lv_employees_cpp :=

Line 868: if fnd_number.canonical_to_number(lv_employees_cpp) = 0 then

864: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,
865: 'JURISDICTION_CODE',
866: 'CAEOY_CPP_EE_WITHHELD_PER_JD_GRE_YTD'); -- employees_cpp
867:
868: if fnd_number.canonical_to_number(lv_employees_cpp) = 0 then
869: lv_employees_cpp := null;
870: end if;
871:
872: lv_employees_qpp :=

Line 877: if fnd_number.canonical_to_number(lv_employees_qpp) = 0 then

873: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,
874: 'JURISDICTION_CODE',
875: 'CAEOY_QPP_EE_WITHHELD_PER_JD_GRE_YTD'); -- employees_qpp
876:
877: if fnd_number.canonical_to_number(lv_employees_qpp) = 0 then
878: lv_employees_qpp := null;
879: end if;
880:
881: lv_employees_ei :=

Line 886: if fnd_number.canonical_to_number(lv_employees_ei) = 0 then

882: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,
883: 'JURISDICTION_CODE',
884: 'CAEOY_EI_EE_WITHHELD_PER_JD_GRE_YTD'); -- employees_ei
885:
886: if fnd_number.canonical_to_number(lv_employees_ei) = 0 then
887: lv_employees_ei := null;
888: end if;
889:
890: /* Added by ssmukher for including PPIP taxes */

Line 903: if fnd_number.canonical_to_number(lv_employees_ppip) = 0 then

899: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,
900: 'JURISDICTION_CODE',
901: 'CAEOY_PPIP_EE_WITHHELD_PER_JD_GRE_YTD'); -- employees_ppip
902:
903: if fnd_number.canonical_to_number(lv_employees_ppip) = 0 then
904: lv_employees_ppip := null;
905: end if;
906:
907: open cur_max_ppip_earning;

Line 918: /* if fnd_number.canonical_to_number(lv_ppip_insurable_earnings) = 0 then

914: 'JURISDICTION_CODE',
915: 'CAEOY_PPIP_EE_TAXABLE_PER_JD_GRE_YTD'); -- ppip_insurable_earnings
916:
917: -- commented by sneelapa for bug 6434613
918: /* if fnd_number.canonical_to_number(lv_ppip_insurable_earnings) = 0 then
919: lv_ppip_insurable_earnings := null;
920: end if;
921: */
922:

Line 925: if fnd_number.canonical_to_number(lv_ppip_insurable_earnings) = 0 then

921: */
922:
923: /* commenting the below logic as per bug 5527030
924:
925: if fnd_number.canonical_to_number(lv_ppip_insurable_earnings) = 0 then
926: lv_ppip_insurable_earnings := null;
927:
928: elsif fnd_number.canonical_to_number(lv_ppip_insurable_earnings) >= lv_max_ppip_earning then
929: lv_ppip_insurable_earnings := null;

Line 928: elsif fnd_number.canonical_to_number(lv_ppip_insurable_earnings) >= lv_max_ppip_earning then

924:
925: if fnd_number.canonical_to_number(lv_ppip_insurable_earnings) = 0 then
926: lv_ppip_insurable_earnings := null;
927:
928: elsif fnd_number.canonical_to_number(lv_ppip_insurable_earnings) >= lv_max_ppip_earning then
929: lv_ppip_insurable_earnings := null;
930:
931: elsif fnd_number.canonical_to_number(lv_employment_income) = fnd_number.canonical_to_number(lv_ppip_insurable_earnings) then
932: lv_ppip_insurable_earnings := null;

Line 931: elsif fnd_number.canonical_to_number(lv_employment_income) = fnd_number.canonical_to_number(lv_ppip_insurable_earnings) then

927:
928: elsif fnd_number.canonical_to_number(lv_ppip_insurable_earnings) >= lv_max_ppip_earning then
929: lv_ppip_insurable_earnings := null;
930:
931: elsif fnd_number.canonical_to_number(lv_employment_income) = fnd_number.canonical_to_number(lv_ppip_insurable_earnings) then
932: lv_ppip_insurable_earnings := null;
933:
934: end if;
935:

Line 942: if fnd_number.canonical_to_number(lv_ppip_insurable_earnings) = 0 then

938: -- calling the commented code for bug 5527030 above,
939: -- for resolving issue for bug 6434613
940: -- changes for bug 6434613 starts here.
941:
942: if fnd_number.canonical_to_number(lv_ppip_insurable_earnings) = 0 then
943: lv_ppip_insurable_earnings := null;
944:
945: elsif fnd_number.canonical_to_number(lv_ppip_insurable_earnings) >= lv_max_ppip_earning then
946: lv_ppip_insurable_earnings := null;

Line 945: elsif fnd_number.canonical_to_number(lv_ppip_insurable_earnings) >= lv_max_ppip_earning then

941:
942: if fnd_number.canonical_to_number(lv_ppip_insurable_earnings) = 0 then
943: lv_ppip_insurable_earnings := null;
944:
945: elsif fnd_number.canonical_to_number(lv_ppip_insurable_earnings) >= lv_max_ppip_earning then
946: lv_ppip_insurable_earnings := null;
947:
948: elsif fnd_number.canonical_to_number(lv_employment_income) = fnd_number.canonical_to_number(lv_ppip_insurable_earnings) then
949: lv_ppip_insurable_earnings := null;

Line 948: elsif fnd_number.canonical_to_number(lv_employment_income) = fnd_number.canonical_to_number(lv_ppip_insurable_earnings) then

944:
945: elsif fnd_number.canonical_to_number(lv_ppip_insurable_earnings) >= lv_max_ppip_earning then
946: lv_ppip_insurable_earnings := null;
947:
948: elsif fnd_number.canonical_to_number(lv_employment_income) = fnd_number.canonical_to_number(lv_ppip_insurable_earnings) then
949: lv_ppip_insurable_earnings := null;
950:
951: end if;
952: -- changes for bug 6434613 ends here.

Line 965: if fnd_number.canonical_to_number(lv_rpp_contribution) = 0 then

961: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,
962: 'JURISDICTION_CODE',
963: 'CAEOY_T4_BOX20_PER_JD_GRE_YTD'); -- rpp_contribution
964:
965: if fnd_number.canonical_to_number(lv_rpp_contribution) = 0 then
966: lv_rpp_contribution := null;
967: end if;
968:
969: lv_pension_adjustment :=

Line 974: if fnd_number.canonical_to_number(lv_pension_adjustment) = 0 then

970: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,
971: 'JURISDICTION_CODE',
972: 'CAEOY_T4_BOX52_PER_JD_GRE_YTD'); -- pension_adjustment
973:
974: if fnd_number.canonical_to_number(lv_pension_adjustment) = 0 then
975: lv_pension_adjustment := null;
976: end if;
977:
978: lv_ei_insurable_earnings :=

Line 998: if fnd_number.canonical_to_number(lv_ei_insurable_earnings) = 0 then

994: -- Added this IF condition to display EI Insurable Earnings in case
995: -- EMPLOYEE worked in QC and NON QC province in particular year.
996:
997: -- Modification for bug 7835218 ends here.
998: if fnd_number.canonical_to_number(lv_ei_insurable_earnings) = 0 then
999: lv_ei_insurable_earnings := null;
1000:
1001: elsif fnd_number.canonical_to_number(lv_ei_insurable_earnings) >= lv_max_ei_earning then
1002: lv_ei_insurable_earnings := null;

Line 1001: elsif fnd_number.canonical_to_number(lv_ei_insurable_earnings) >= lv_max_ei_earning then

997: -- Modification for bug 7835218 ends here.
998: if fnd_number.canonical_to_number(lv_ei_insurable_earnings) = 0 then
999: lv_ei_insurable_earnings := null;
1000:
1001: elsif fnd_number.canonical_to_number(lv_ei_insurable_earnings) >= lv_max_ei_earning then
1002: lv_ei_insurable_earnings := null;
1003:
1004: elsif fnd_number.canonical_to_number(lv_employment_income) = fnd_number.canonical_to_number(lv_ei_insurable_earnings) then
1005: lv_ei_insurable_earnings := null;

Line 1004: elsif fnd_number.canonical_to_number(lv_employment_income) = fnd_number.canonical_to_number(lv_ei_insurable_earnings) then

1000:
1001: elsif fnd_number.canonical_to_number(lv_ei_insurable_earnings) >= lv_max_ei_earning then
1002: lv_ei_insurable_earnings := null;
1003:
1004: elsif fnd_number.canonical_to_number(lv_employment_income) = fnd_number.canonical_to_number(lv_ei_insurable_earnings) then
1005: lv_ei_insurable_earnings := null;
1006:
1007: end if;
1008: end if; -- if lv_ei_display_flag = 1 then

Line 1011: if fnd_number.canonical_to_number(lv_ei_insurable_earnings) = 0 then

1007: end if;
1008: end if; -- if lv_ei_display_flag = 1 then
1009:
1010: -- Modification for bug 7835218 starts here.
1011: if fnd_number.canonical_to_number(lv_ei_insurable_earnings) = 0 then
1012: lv_ei_insurable_earnings := null;
1013: end if;
1014: -- Modification for bug 7835218 ends here.
1015: end if; --to_number(lv_year) < 2011

Line 1037: if fnd_number.canonical_to_number(lv_cpp_qpp_earnings) = 0 then

1033: close cur_max_cpp_earning;
1034:
1035: /* if condition added for bug 10244185 */
1036: if to_number(lv_year) < 2011 then
1037: if fnd_number.canonical_to_number(lv_cpp_qpp_earnings) = 0 then
1038: lv_cpp_qpp_earnings := null;
1039:
1040: elsif fnd_number.canonical_to_number(lv_cpp_qpp_earnings) >= lv_max_cpp_earning then
1041: lv_cpp_qpp_earnings := null;

Line 1040: elsif fnd_number.canonical_to_number(lv_cpp_qpp_earnings) >= lv_max_cpp_earning then

1036: if to_number(lv_year) < 2011 then
1037: if fnd_number.canonical_to_number(lv_cpp_qpp_earnings) = 0 then
1038: lv_cpp_qpp_earnings := null;
1039:
1040: elsif fnd_number.canonical_to_number(lv_cpp_qpp_earnings) >= lv_max_cpp_earning then
1041: lv_cpp_qpp_earnings := null;
1042:
1043: elsif fnd_number.canonical_to_number(lv_employment_income) = fnd_number.canonical_to_number(lv_cpp_qpp_earnings) then
1044: lv_cpp_qpp_earnings := null;

Line 1043: elsif fnd_number.canonical_to_number(lv_employment_income) = fnd_number.canonical_to_number(lv_cpp_qpp_earnings) then

1039:
1040: elsif fnd_number.canonical_to_number(lv_cpp_qpp_earnings) >= lv_max_cpp_earning then
1041: lv_cpp_qpp_earnings := null;
1042:
1043: elsif fnd_number.canonical_to_number(lv_employment_income) = fnd_number.canonical_to_number(lv_cpp_qpp_earnings) then
1044: lv_cpp_qpp_earnings := null;
1045:
1046: end if;
1047: end if; --to_number(lv_year) < 2011

Line 1053: if fnd_number.canonical_to_number(lv_union_dues) = 0 then

1049: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,
1050: 'JURISDICTION_CODE',
1051: 'CAEOY_T4_BOX44_PER_JD_GRE_YTD'); -- union_dues
1052:
1053: if fnd_number.canonical_to_number(lv_union_dues) = 0 then
1054: lv_union_dues := null;
1055: end if;
1056:
1057: lv_charitable_donations :=

Line 1062: if fnd_number.canonical_to_number(lv_charitable_donations) = 0 then

1058: pay_ca_archive_utils.get_archive_value(p_aa_id, p_prov,
1059: 'JURISDICTION_CODE',
1060: 'CAEOY_T4_BOX46_PER_JD_GRE_YTD'); -- charitable_donations
1061:
1062: if fnd_number.canonical_to_number(lv_charitable_donations) = 0 then
1063: lv_charitable_donations := null;
1064: end if;
1065:
1066: store_other_information (p_aa_id, p_prov);