[Home] [Help]
1: PACKAGE BODY pay_us_fls_reporting_pkg AS
2: /* $Header: pyusflsp.pkb 120.7 2006/07/17 17:23:04 ahanda noship $ */
3: /*
4: ******************************************************************
5: * *
16: * 500 Oracle Parkway, Redwood City, CA, 94065. *
17: * *
18: ******************************************************************
19:
20: Name : pay_us_fls_reporting_pkg
21:
22: Description : Generate FLS periodic magnetic reports according to
23: FLS requirements.
24:
100:
101: /******************************************************************
102: ** Package Local Variables
103: ******************************************************************/
104: gv_package varchar2(50) := 'pay_us_fls_reporting_pkg';
105:
106:
107: /*******************************************************************
108: ** Procedure to return the values for the Payroll Action of
1041: BEGIN
1042: hr_utility.set_location(gv_package || '.get_fls_jd_values', 10);
1043:
1044: /* Reset the PL/SQL tables */
1045: if pay_us_fls_reporting_pkg.ltr_action_info.count > 0 then
1046: for i in pay_us_fls_reporting_pkg.ltr_action_info.first ..
1047: pay_us_fls_reporting_pkg.ltr_action_info.last loop
1048: pay_us_fls_reporting_pkg.ltr_action_info(i).jurisdiction_code := null;
1049: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information1 := null;
1042: hr_utility.set_location(gv_package || '.get_fls_jd_values', 10);
1043:
1044: /* Reset the PL/SQL tables */
1045: if pay_us_fls_reporting_pkg.ltr_action_info.count > 0 then
1046: for i in pay_us_fls_reporting_pkg.ltr_action_info.first ..
1047: pay_us_fls_reporting_pkg.ltr_action_info.last loop
1048: pay_us_fls_reporting_pkg.ltr_action_info(i).jurisdiction_code := null;
1049: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information1 := null;
1050: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information2 := null;
1043:
1044: /* Reset the PL/SQL tables */
1045: if pay_us_fls_reporting_pkg.ltr_action_info.count > 0 then
1046: for i in pay_us_fls_reporting_pkg.ltr_action_info.first ..
1047: pay_us_fls_reporting_pkg.ltr_action_info.last loop
1048: pay_us_fls_reporting_pkg.ltr_action_info(i).jurisdiction_code := null;
1049: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information1 := null;
1050: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information2 := null;
1051: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information3 := null;
1044: /* Reset the PL/SQL tables */
1045: if pay_us_fls_reporting_pkg.ltr_action_info.count > 0 then
1046: for i in pay_us_fls_reporting_pkg.ltr_action_info.first ..
1047: pay_us_fls_reporting_pkg.ltr_action_info.last loop
1048: pay_us_fls_reporting_pkg.ltr_action_info(i).jurisdiction_code := null;
1049: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information1 := null;
1050: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information2 := null;
1051: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information3 := null;
1052: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4 := null;
1045: if pay_us_fls_reporting_pkg.ltr_action_info.count > 0 then
1046: for i in pay_us_fls_reporting_pkg.ltr_action_info.first ..
1047: pay_us_fls_reporting_pkg.ltr_action_info.last loop
1048: pay_us_fls_reporting_pkg.ltr_action_info(i).jurisdiction_code := null;
1049: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information1 := null;
1050: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information2 := null;
1051: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information3 := null;
1052: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4 := null;
1053: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5 := null;
1046: for i in pay_us_fls_reporting_pkg.ltr_action_info.first ..
1047: pay_us_fls_reporting_pkg.ltr_action_info.last loop
1048: pay_us_fls_reporting_pkg.ltr_action_info(i).jurisdiction_code := null;
1049: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information1 := null;
1050: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information2 := null;
1051: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information3 := null;
1052: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4 := null;
1053: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5 := null;
1054: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information6 := null;
1047: pay_us_fls_reporting_pkg.ltr_action_info.last loop
1048: pay_us_fls_reporting_pkg.ltr_action_info(i).jurisdiction_code := null;
1049: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information1 := null;
1050: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information2 := null;
1051: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information3 := null;
1052: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4 := null;
1053: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5 := null;
1054: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information6 := null;
1055: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information7 := null;
1048: pay_us_fls_reporting_pkg.ltr_action_info(i).jurisdiction_code := null;
1049: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information1 := null;
1050: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information2 := null;
1051: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information3 := null;
1052: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4 := null;
1053: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5 := null;
1054: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information6 := null;
1055: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information7 := null;
1056: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information8 := null;
1049: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information1 := null;
1050: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information2 := null;
1051: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information3 := null;
1052: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4 := null;
1053: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5 := null;
1054: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information6 := null;
1055: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information7 := null;
1056: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information8 := null;
1057: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information9 := null;
1050: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information2 := null;
1051: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information3 := null;
1052: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4 := null;
1053: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5 := null;
1054: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information6 := null;
1055: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information7 := null;
1056: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information8 := null;
1057: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information9 := null;
1058: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information10 := null;
1051: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information3 := null;
1052: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4 := null;
1053: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5 := null;
1054: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information6 := null;
1055: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information7 := null;
1056: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information8 := null;
1057: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information9 := null;
1058: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information10 := null;
1059: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information11 := null;
1052: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4 := null;
1053: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5 := null;
1054: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information6 := null;
1055: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information7 := null;
1056: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information8 := null;
1057: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information9 := null;
1058: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information10 := null;
1059: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information11 := null;
1060: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information12 := null;
1053: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5 := null;
1054: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information6 := null;
1055: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information7 := null;
1056: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information8 := null;
1057: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information9 := null;
1058: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information10 := null;
1059: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information11 := null;
1060: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information12 := null;
1061: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information13 := null;
1054: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information6 := null;
1055: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information7 := null;
1056: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information8 := null;
1057: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information9 := null;
1058: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information10 := null;
1059: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information11 := null;
1060: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information12 := null;
1061: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information13 := null;
1062: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information14 := null;
1055: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information7 := null;
1056: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information8 := null;
1057: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information9 := null;
1058: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information10 := null;
1059: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information11 := null;
1060: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information12 := null;
1061: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information13 := null;
1062: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information14 := null;
1063: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information15 := null;
1056: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information8 := null;
1057: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information9 := null;
1058: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information10 := null;
1059: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information11 := null;
1060: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information12 := null;
1061: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information13 := null;
1062: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information14 := null;
1063: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information15 := null;
1064: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information16 := null;
1057: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information9 := null;
1058: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information10 := null;
1059: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information11 := null;
1060: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information12 := null;
1061: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information13 := null;
1062: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information14 := null;
1063: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information15 := null;
1064: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information16 := null;
1065: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information17 := null;
1058: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information10 := null;
1059: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information11 := null;
1060: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information12 := null;
1061: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information13 := null;
1062: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information14 := null;
1063: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information15 := null;
1064: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information16 := null;
1065: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information17 := null;
1066: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information18 := null;
1059: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information11 := null;
1060: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information12 := null;
1061: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information13 := null;
1062: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information14 := null;
1063: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information15 := null;
1064: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information16 := null;
1065: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information17 := null;
1066: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information18 := null;
1067: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information19 := null;
1060: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information12 := null;
1061: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information13 := null;
1062: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information14 := null;
1063: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information15 := null;
1064: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information16 := null;
1065: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information17 := null;
1066: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information18 := null;
1067: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information19 := null;
1068: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information20 := null;
1061: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information13 := null;
1062: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information14 := null;
1063: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information15 := null;
1064: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information16 := null;
1065: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information17 := null;
1066: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information18 := null;
1067: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information19 := null;
1068: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information20 := null;
1069: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information21 := null;
1062: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information14 := null;
1063: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information15 := null;
1064: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information16 := null;
1065: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information17 := null;
1066: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information18 := null;
1067: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information19 := null;
1068: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information20 := null;
1069: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information21 := null;
1070: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information22 := null;
1063: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information15 := null;
1064: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information16 := null;
1065: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information17 := null;
1066: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information18 := null;
1067: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information19 := null;
1068: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information20 := null;
1069: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information21 := null;
1070: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information22 := null;
1071: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information23 := null;
1064: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information16 := null;
1065: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information17 := null;
1066: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information18 := null;
1067: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information19 := null;
1068: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information20 := null;
1069: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information21 := null;
1070: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information22 := null;
1071: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information23 := null;
1072: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information24 := null;
1065: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information17 := null;
1066: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information18 := null;
1067: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information19 := null;
1068: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information20 := null;
1069: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information21 := null;
1070: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information22 := null;
1071: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information23 := null;
1072: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information24 := null;
1073: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information25 := null;
1066: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information18 := null;
1067: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information19 := null;
1068: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information20 := null;
1069: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information21 := null;
1070: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information22 := null;
1071: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information23 := null;
1072: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information24 := null;
1073: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information25 := null;
1074: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information26 := null;
1067: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information19 := null;
1068: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information20 := null;
1069: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information21 := null;
1070: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information22 := null;
1071: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information23 := null;
1072: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information24 := null;
1073: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information25 := null;
1074: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information26 := null;
1075: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information27 := null;
1068: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information20 := null;
1069: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information21 := null;
1070: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information22 := null;
1071: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information23 := null;
1072: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information24 := null;
1073: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information25 := null;
1074: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information26 := null;
1075: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information27 := null;
1076: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information28 := null;
1069: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information21 := null;
1070: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information22 := null;
1071: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information23 := null;
1072: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information24 := null;
1073: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information25 := null;
1074: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information26 := null;
1075: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information27 := null;
1076: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information28 := null;
1077: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information29 := null;
1070: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information22 := null;
1071: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information23 := null;
1072: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information24 := null;
1073: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information25 := null;
1074: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information26 := null;
1075: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information27 := null;
1076: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information28 := null;
1077: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information29 := null;
1078: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30 := null;
1071: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information23 := null;
1072: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information24 := null;
1073: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information25 := null;
1074: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information26 := null;
1075: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information27 := null;
1076: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information28 := null;
1077: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information29 := null;
1078: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30 := null;
1079: end loop;
1072: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information24 := null;
1073: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information25 := null;
1074: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information26 := null;
1075: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information27 := null;
1076: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information28 := null;
1077: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information29 := null;
1078: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30 := null;
1079: end loop;
1080: pay_us_fls_reporting_pkg.ltr_action_info.delete;
1073: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information25 := null;
1074: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information26 := null;
1075: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information27 := null;
1076: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information28 := null;
1077: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information29 := null;
1078: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30 := null;
1079: end loop;
1080: pay_us_fls_reporting_pkg.ltr_action_info.delete;
1081: end if;
1074: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information26 := null;
1075: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information27 := null;
1076: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information28 := null;
1077: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information29 := null;
1078: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30 := null;
1079: end loop;
1080: pay_us_fls_reporting_pkg.ltr_action_info.delete;
1081: end if;
1082:
1076: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information28 := null;
1077: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information29 := null;
1078: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30 := null;
1079: end loop;
1080: pay_us_fls_reporting_pkg.ltr_action_info.delete;
1081: end if;
1082:
1083: hr_utility.trace('Payroll Action ID=' || p_payroll_action_id);
1084: hr_utility.trace('Tax Unit ID=' || p_tax_unit_id);
1085: for action_rec in c_action_info(p_tax_unit_id, p_payroll_action_id)
1086: loop
1087: hr_utility.set_location(gv_package || '.get_fls_jd_values', 20);
1088: /* Commented out because of DB issue. Bug 1822467 */
1089: --pay_us_fls_reporting_pkg.ltr_action_info(i_count) := action_rec;
1090: pay_us_fls_reporting_pkg.ltr_action_info(i_count).jurisdiction_code
1091: := action_rec.jurisdiction_code;
1092: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information1
1093: := action_rec.action_information1;
1086: loop
1087: hr_utility.set_location(gv_package || '.get_fls_jd_values', 20);
1088: /* Commented out because of DB issue. Bug 1822467 */
1089: --pay_us_fls_reporting_pkg.ltr_action_info(i_count) := action_rec;
1090: pay_us_fls_reporting_pkg.ltr_action_info(i_count).jurisdiction_code
1091: := action_rec.jurisdiction_code;
1092: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information1
1093: := action_rec.action_information1;
1094: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information2
1088: /* Commented out because of DB issue. Bug 1822467 */
1089: --pay_us_fls_reporting_pkg.ltr_action_info(i_count) := action_rec;
1090: pay_us_fls_reporting_pkg.ltr_action_info(i_count).jurisdiction_code
1091: := action_rec.jurisdiction_code;
1092: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information1
1093: := action_rec.action_information1;
1094: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information2
1095: := action_rec.action_information2;
1096: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information3
1090: pay_us_fls_reporting_pkg.ltr_action_info(i_count).jurisdiction_code
1091: := action_rec.jurisdiction_code;
1092: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information1
1093: := action_rec.action_information1;
1094: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information2
1095: := action_rec.action_information2;
1096: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information3
1097: := action_rec.action_information3;
1098: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information4
1092: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information1
1093: := action_rec.action_information1;
1094: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information2
1095: := action_rec.action_information2;
1096: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information3
1097: := action_rec.action_information3;
1098: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information4
1099: := action_rec.action_information4;
1100: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information5
1094: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information2
1095: := action_rec.action_information2;
1096: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information3
1097: := action_rec.action_information3;
1098: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information4
1099: := action_rec.action_information4;
1100: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information5
1101: := action_rec.action_information5;
1102: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information6
1096: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information3
1097: := action_rec.action_information3;
1098: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information4
1099: := action_rec.action_information4;
1100: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information5
1101: := action_rec.action_information5;
1102: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information6
1103: := action_rec.action_information6;
1104: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information7
1098: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information4
1099: := action_rec.action_information4;
1100: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information5
1101: := action_rec.action_information5;
1102: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information6
1103: := action_rec.action_information6;
1104: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information7
1105: := action_rec.action_information7;
1106: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information8
1100: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information5
1101: := action_rec.action_information5;
1102: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information6
1103: := action_rec.action_information6;
1104: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information7
1105: := action_rec.action_information7;
1106: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information8
1107: := action_rec.action_information8;
1108: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information9
1102: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information6
1103: := action_rec.action_information6;
1104: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information7
1105: := action_rec.action_information7;
1106: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information8
1107: := action_rec.action_information8;
1108: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information9
1109: := action_rec.action_information9;
1110: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information10
1104: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information7
1105: := action_rec.action_information7;
1106: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information8
1107: := action_rec.action_information8;
1108: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information9
1109: := action_rec.action_information9;
1110: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information10
1111: := action_rec.action_information10;
1112: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information11
1106: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information8
1107: := action_rec.action_information8;
1108: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information9
1109: := action_rec.action_information9;
1110: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information10
1111: := action_rec.action_information10;
1112: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information11
1113: := action_rec.action_information11;
1114: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information12
1108: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information9
1109: := action_rec.action_information9;
1110: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information10
1111: := action_rec.action_information10;
1112: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information11
1113: := action_rec.action_information11;
1114: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information12
1115: := action_rec.action_information12;
1116: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information13
1110: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information10
1111: := action_rec.action_information10;
1112: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information11
1113: := action_rec.action_information11;
1114: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information12
1115: := action_rec.action_information12;
1116: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information13
1117: := action_rec.action_information13;
1118: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information14
1112: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information11
1113: := action_rec.action_information11;
1114: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information12
1115: := action_rec.action_information12;
1116: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information13
1117: := action_rec.action_information13;
1118: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information14
1119: := action_rec.action_information14;
1120: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information15
1114: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information12
1115: := action_rec.action_information12;
1116: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information13
1117: := action_rec.action_information13;
1118: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information14
1119: := action_rec.action_information14;
1120: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information15
1121: := action_rec.action_information15;
1122: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information16
1116: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information13
1117: := action_rec.action_information13;
1118: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information14
1119: := action_rec.action_information14;
1120: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information15
1121: := action_rec.action_information15;
1122: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information16
1123: := action_rec.action_information16;
1124: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information17
1118: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information14
1119: := action_rec.action_information14;
1120: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information15
1121: := action_rec.action_information15;
1122: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information16
1123: := action_rec.action_information16;
1124: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information17
1125: := action_rec.action_information17;
1126: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information18
1120: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information15
1121: := action_rec.action_information15;
1122: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information16
1123: := action_rec.action_information16;
1124: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information17
1125: := action_rec.action_information17;
1126: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information18
1127: := action_rec.action_information18;
1128: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information19
1122: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information16
1123: := action_rec.action_information16;
1124: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information17
1125: := action_rec.action_information17;
1126: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information18
1127: := action_rec.action_information18;
1128: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information19
1129: := action_rec.action_information19;
1130: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information20
1124: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information17
1125: := action_rec.action_information17;
1126: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information18
1127: := action_rec.action_information18;
1128: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information19
1129: := action_rec.action_information19;
1130: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information20
1131: := action_rec.action_information20;
1132: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information21
1126: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information18
1127: := action_rec.action_information18;
1128: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information19
1129: := action_rec.action_information19;
1130: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information20
1131: := action_rec.action_information20;
1132: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information21
1133: := action_rec.action_information21;
1134: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information22
1128: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information19
1129: := action_rec.action_information19;
1130: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information20
1131: := action_rec.action_information20;
1132: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information21
1133: := action_rec.action_information21;
1134: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information22
1135: := action_rec.action_information22;
1136: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information23
1130: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information20
1131: := action_rec.action_information20;
1132: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information21
1133: := action_rec.action_information21;
1134: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information22
1135: := action_rec.action_information22;
1136: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information23
1137: := action_rec.action_information23;
1138: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information24
1132: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information21
1133: := action_rec.action_information21;
1134: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information22
1135: := action_rec.action_information22;
1136: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information23
1137: := action_rec.action_information23;
1138: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information24
1139: := action_rec.action_information24;
1140: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information25
1134: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information22
1135: := action_rec.action_information22;
1136: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information23
1137: := action_rec.action_information23;
1138: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information24
1139: := action_rec.action_information24;
1140: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information25
1141: := action_rec.action_information25;
1142: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information26
1136: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information23
1137: := action_rec.action_information23;
1138: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information24
1139: := action_rec.action_information24;
1140: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information25
1141: := action_rec.action_information25;
1142: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information26
1143: := action_rec.action_information26;
1144: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information27
1138: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information24
1139: := action_rec.action_information24;
1140: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information25
1141: := action_rec.action_information25;
1142: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information26
1143: := action_rec.action_information26;
1144: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information27
1145: := action_rec.action_information27;
1146: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information28
1140: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information25
1141: := action_rec.action_information25;
1142: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information26
1143: := action_rec.action_information26;
1144: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information27
1145: := action_rec.action_information27;
1146: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information28
1147: := action_rec.action_information28;
1148: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information29
1142: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information26
1143: := action_rec.action_information26;
1144: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information27
1145: := action_rec.action_information27;
1146: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information28
1147: := action_rec.action_information28;
1148: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information29
1149: := action_rec.action_information29;
1150: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information30
1144: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information27
1145: := action_rec.action_information27;
1146: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information28
1147: := action_rec.action_information28;
1148: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information29
1149: := action_rec.action_information29;
1150: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information30
1151: := action_rec.action_information30;
1152:
1146: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information28
1147: := action_rec.action_information28;
1148: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information29
1149: := action_rec.action_information29;
1150: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information30
1151: := action_rec.action_information30;
1152:
1153: i_count := i_count + 1;
1154: hr_utility.set_location(gv_package || '.get_fls_jd_values', 30);
1154: hr_utility.set_location(gv_package || '.get_fls_jd_values', 30);
1155: end loop;
1156:
1157: hr_utility.set_location(gv_package || '.get_fls_jd_values', 40);
1158: if pay_us_fls_reporting_pkg.ltr_action_info.count > 0 then
1159: for i in pay_us_fls_reporting_pkg.ltr_action_info.first ..
1160: pay_us_fls_reporting_pkg.ltr_action_info.last loop
1161: hr_utility.trace('JD='||pay_us_fls_reporting_pkg.ltr_action_info(i).jurisdiction_code);
1162: end loop;
1155: end loop;
1156:
1157: hr_utility.set_location(gv_package || '.get_fls_jd_values', 40);
1158: if pay_us_fls_reporting_pkg.ltr_action_info.count > 0 then
1159: for i in pay_us_fls_reporting_pkg.ltr_action_info.first ..
1160: pay_us_fls_reporting_pkg.ltr_action_info.last loop
1161: hr_utility.trace('JD='||pay_us_fls_reporting_pkg.ltr_action_info(i).jurisdiction_code);
1162: end loop;
1163: end if;
1156:
1157: hr_utility.set_location(gv_package || '.get_fls_jd_values', 40);
1158: if pay_us_fls_reporting_pkg.ltr_action_info.count > 0 then
1159: for i in pay_us_fls_reporting_pkg.ltr_action_info.first ..
1160: pay_us_fls_reporting_pkg.ltr_action_info.last loop
1161: hr_utility.trace('JD='||pay_us_fls_reporting_pkg.ltr_action_info(i).jurisdiction_code);
1162: end loop;
1163: end if;
1164: hr_utility.trace('AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA');
1157: hr_utility.set_location(gv_package || '.get_fls_jd_values', 40);
1158: if pay_us_fls_reporting_pkg.ltr_action_info.count > 0 then
1159: for i in pay_us_fls_reporting_pkg.ltr_action_info.first ..
1160: pay_us_fls_reporting_pkg.ltr_action_info.last loop
1161: hr_utility.trace('JD='||pay_us_fls_reporting_pkg.ltr_action_info(i).jurisdiction_code);
1162: end loop;
1163: end if;
1164: hr_utility.trace('AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA');
1165:
1209: BEGIN
1210: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 10);
1211: hr_utility.trace('Tax Type Code=' || p_tax_type);
1212: hr_utility.trace('Jurisdiction Code=' || p_jurisdiction);
1213: hr_utility.trace('PL/SQL Count=' || pay_us_fls_reporting_pkg.ltr_action_info.count);
1214:
1215: for i in pay_us_fls_reporting_pkg.ltr_action_info.first ..
1216: pay_us_fls_reporting_pkg.ltr_action_info.last loop
1217:
1211: hr_utility.trace('Tax Type Code=' || p_tax_type);
1212: hr_utility.trace('Jurisdiction Code=' || p_jurisdiction);
1213: hr_utility.trace('PL/SQL Count=' || pay_us_fls_reporting_pkg.ltr_action_info.count);
1214:
1215: for i in pay_us_fls_reporting_pkg.ltr_action_info.first ..
1216: pay_us_fls_reporting_pkg.ltr_action_info.last loop
1217:
1218: hr_utility.trace('PL/SQL Jurisdiction Code=' ||
1219: pay_us_fls_reporting_pkg.ltr_action_info(i).jurisdiction_code);
1212: hr_utility.trace('Jurisdiction Code=' || p_jurisdiction);
1213: hr_utility.trace('PL/SQL Count=' || pay_us_fls_reporting_pkg.ltr_action_info.count);
1214:
1215: for i in pay_us_fls_reporting_pkg.ltr_action_info.first ..
1216: pay_us_fls_reporting_pkg.ltr_action_info.last loop
1217:
1218: hr_utility.trace('PL/SQL Jurisdiction Code=' ||
1219: pay_us_fls_reporting_pkg.ltr_action_info(i).jurisdiction_code);
1220:
1215: for i in pay_us_fls_reporting_pkg.ltr_action_info.first ..
1216: pay_us_fls_reporting_pkg.ltr_action_info.last loop
1217:
1218: hr_utility.trace('PL/SQL Jurisdiction Code=' ||
1219: pay_us_fls_reporting_pkg.ltr_action_info(i).jurisdiction_code);
1220:
1221: hr_utility.trace('PL/SQL Action30 is= ' ||
1222: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30);
1223:
1218: hr_utility.trace('PL/SQL Jurisdiction Code=' ||
1219: pay_us_fls_reporting_pkg.ltr_action_info(i).jurisdiction_code);
1220:
1221: hr_utility.trace('PL/SQL Action30 is= ' ||
1222: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30);
1223:
1224: hr_utility.trace('PL/SQL p_jurisdiction is= ' ||
1225: p_jurisdiction);
1226:
1226:
1227: hr_utility.trace('PL/SQL p_resident_jurisdiction is = ' ||
1228: nvl(p_resident_jurisdiction,'NOT ARCHIVED'));
1229:
1230: if pay_us_fls_reporting_pkg.ltr_action_info(i).jurisdiction_code = p_jurisdiction then
1231:
1232: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 20);
1233:
1234: if p_jurisdiction = '00-000-0000' then
1234: if p_jurisdiction = '00-000-0000' then
1235: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 30);
1236: -- Regular Earnings
1237: ln_amt1 := ln_amt1 +
1238: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information2;
1239: -- Gross Earnings
1240: ln_amt2 := ln_amt2 +
1241: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information23;
1242: -- Pre Tax Deduction
1237: ln_amt1 := ln_amt1 +
1238: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information2;
1239: -- Gross Earnings
1240: ln_amt2 := ln_amt2 +
1241: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information23;
1242: -- Pre Tax Deduction
1243: ln_amt3 := ln_amt3 +
1244: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5;
1245:
1240: ln_amt2 := ln_amt2 +
1241: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information23;
1242: -- Pre Tax Deduction
1243: ln_amt3 := ln_amt3 +
1244: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5;
1245:
1246: if p_tax_type = 'IT' then
1247: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 40);
1248: -- Supp Earning for FIT
1246: if p_tax_type = 'IT' then
1247: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 40);
1248: -- Supp Earning for FIT
1249: ln_amt4 := ln_amt4 +
1250: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information3;
1251: -- Supp Earning for NWFIT
1252: ln_amt5 := ln_amt5 +
1253: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4;
1254: -- Pre Tax Deduction for FIT
1249: ln_amt4 := ln_amt4 +
1250: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information3;
1251: -- Supp Earning for NWFIT
1252: ln_amt5 := ln_amt5 +
1253: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4;
1254: -- Pre Tax Deduction for FIT
1255: ln_amt6 := ln_amt6 +
1256: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information6;
1257: -- FIT Withheld
1252: ln_amt5 := ln_amt5 +
1253: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4;
1254: -- Pre Tax Deduction for FIT
1255: ln_amt6 := ln_amt6 +
1256: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information6;
1257: -- FIT Withheld
1258: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1259: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information1;
1260:
1255: ln_amt6 := ln_amt6 +
1256: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information6;
1257: -- FIT Withheld
1258: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1259: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information1;
1260:
1261: elsif p_tax_type = 'UI' then
1262: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 50);
1263: -- Supp Earning for FUTA
1261: elsif p_tax_type = 'UI' then
1262: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 50);
1263: -- Supp Earning for FUTA
1264: ln_amt4 := ln_amt4 +
1265: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information19;
1266: -- Pre Tax Deduction for FUTA
1267: ln_amt6 := ln_amt6 +
1268: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information20;
1269: -- Taxable
1264: ln_amt4 := ln_amt4 +
1265: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information19;
1266: -- Pre Tax Deduction for FUTA
1267: ln_amt6 := ln_amt6 +
1268: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information20;
1269: -- Taxable
1270: ln_amt7 := ln_amt7 +
1271: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information21;
1272: -- Liability
1267: ln_amt6 := ln_amt6 +
1268: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information20;
1269: -- Taxable
1270: ln_amt7 := ln_amt7 +
1271: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information21;
1272: -- Liability
1273: ln_r_er_tax_amt := ln_r_er_tax_amt +
1274: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information22;
1275:
1270: ln_amt7 := ln_amt7 +
1271: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information21;
1272: -- Liability
1273: ln_r_er_tax_amt := ln_r_er_tax_amt +
1274: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information22;
1275:
1276: elsif p_tax_type = 'OASDI' then
1277: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 60);
1278: -- Supp Earning for SS
1276: elsif p_tax_type = 'OASDI' then
1277: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 60);
1278: -- Supp Earning for SS
1279: ln_amt4 := ln_amt4 +
1280: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information11;
1281: -- Pre Tax Deduction for SS
1282: ln_amt6 := ln_amt6 +
1283: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information12;
1284: -- Taxable
1279: ln_amt4 := ln_amt4 +
1280: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information11;
1281: -- Pre Tax Deduction for SS
1282: ln_amt6 := ln_amt6 +
1283: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information12;
1284: -- Taxable
1285: ln_amt7 := ln_amt7 +
1286: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information7;
1287: -- SS EE Withheld
1282: ln_amt6 := ln_amt6 +
1283: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information12;
1284: -- Taxable
1285: ln_amt7 := ln_amt7 +
1286: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information7;
1287: -- SS EE Withheld
1288: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1289: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information8;
1290: -- SS ER Liability
1285: ln_amt7 := ln_amt7 +
1286: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information7;
1287: -- SS EE Withheld
1288: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1289: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information8;
1290: -- SS ER Liability
1291: ln_r_er_tax_amt := ln_r_er_tax_amt +
1292: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information9;
1293: elsif p_tax_type = 'HI' then
1288: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1289: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information8;
1290: -- SS ER Liability
1291: ln_r_er_tax_amt := ln_r_er_tax_amt +
1292: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information9;
1293: elsif p_tax_type = 'HI' then
1294: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 70);
1295: -- Supp Earning for Medicare
1296: ln_amt4 := ln_amt4 +
1293: elsif p_tax_type = 'HI' then
1294: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 70);
1295: -- Supp Earning for Medicare
1296: ln_amt4 := ln_amt4 +
1297: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information17;
1298: -- Pre Tax Deduction for Medicare
1299: ln_amt6 := ln_amt6 +
1300: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information18;
1301: -- Medicare EE Taxable
1296: ln_amt4 := ln_amt4 +
1297: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information17;
1298: -- Pre Tax Deduction for Medicare
1299: ln_amt6 := ln_amt6 +
1300: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information18;
1301: -- Medicare EE Taxable
1302: ln_amt7 := ln_amt7 +
1303: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information13;
1304: -- Medicare Withheld
1299: ln_amt6 := ln_amt6 +
1300: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information18;
1301: -- Medicare EE Taxable
1302: ln_amt7 := ln_amt7 +
1303: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information13;
1304: -- Medicare Withheld
1305: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1306: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information14;
1307: -- Medicare ER Liability
1302: ln_amt7 := ln_amt7 +
1303: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information13;
1304: -- Medicare Withheld
1305: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1306: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information14;
1307: -- Medicare ER Liability
1308: ln_r_er_tax_amt := ln_r_er_tax_amt +
1309: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information15;
1310: elsif p_tax_type = 'EIC' then
1305: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1306: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information14;
1307: -- Medicare ER Liability
1308: ln_r_er_tax_amt := ln_r_er_tax_amt +
1309: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information15;
1310: elsif p_tax_type = 'EIC' then
1311: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 80);
1312: ln_amt1 := 0;
1313: ln_amt2 := 0;
1313: ln_amt2 := 0;
1314: ln_amt3 := 0;
1315: -- EIC Advance
1316: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1317: (-1 * pay_us_fls_reporting_pkg.ltr_action_info(i).action_information26);
1318:
1319: end if;
1320: exit;
1321: -- State Jurisdiction code
1327: if p_tax_type = 'IT' then
1328: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 120);
1329: --SIT Gross
1330: ln_amt2 := ln_amt2 +
1331: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information17;
1332: -- SIT Subj Whable
1333: ln_amt4 := ln_amt4 +
1334: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information2;
1335: -- SIT Subj NWhable
1330: ln_amt2 := ln_amt2 +
1331: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information17;
1332: -- SIT Subj Whable
1333: ln_amt4 := ln_amt4 +
1334: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information2;
1335: -- SIT Subj NWhable
1336: ln_amt5 := ln_amt5 +
1337: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information3;
1338: -- SIT Pre Tax Redns
1333: ln_amt4 := ln_amt4 +
1334: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information2;
1335: -- SIT Subj NWhable
1336: ln_amt5 := ln_amt5 +
1337: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information3;
1338: -- SIT Pre Tax Redns
1339: ln_amt3 := ln_amt3 +
1340: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4;
1341: -- SIT Withheld
1336: ln_amt5 := ln_amt5 +
1337: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information3;
1338: -- SIT Pre Tax Redns
1339: ln_amt3 := ln_amt3 +
1340: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4;
1341: -- SIT Withheld
1342: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1343: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information1;
1344:
1339: ln_amt3 := ln_amt3 +
1340: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4;
1341: -- SIT Withheld
1342: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1343: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information1;
1344:
1345: elsif p_tax_type = 'UI' then
1346: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 130);
1347: /* Always report the ER component if it is there. -- 4335410
1350: Doing an if to get EE or ER Wages instead on NVL as the PL/SQL table will
1351: have a Zero value if there is a NULL in the table. */
1352:
1353: -- SUI EE Gross, SUI ER Gross
1354: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information29,0) <> 0 then
1355: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 140);
1356: ln_amt2 := ln_amt2 +
1357: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information29;
1358: else
1353: -- SUI EE Gross, SUI ER Gross
1354: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information29,0) <> 0 then
1355: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 140);
1356: ln_amt2 := ln_amt2 +
1357: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information29;
1358: else
1359: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 150);
1360: ln_amt2 := ln_amt2 +
1361: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information28;
1357: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information29;
1358: else
1359: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 150);
1360: ln_amt2 := ln_amt2 +
1361: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information28;
1362: end if;
1363:
1364: -- nvl(SUI EE Subj Whable, SUI ER Subj Whable)
1365: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information19,0) <> 0 then
1361: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information28;
1362: end if;
1363:
1364: -- nvl(SUI EE Subj Whable, SUI ER Subj Whable)
1365: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information19,0) <> 0 then
1366: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 160);
1367: ln_amt4 := ln_amt4 +
1368: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information19;
1369: else
1364: -- nvl(SUI EE Subj Whable, SUI ER Subj Whable)
1365: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information19,0) <> 0 then
1366: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 160);
1367: ln_amt4 := ln_amt4 +
1368: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information19;
1369: else
1370: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 170);
1371: ln_amt4 := ln_amt4 +
1372: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information15;
1368: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information19;
1369: else
1370: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 170);
1371: ln_amt4 := ln_amt4 +
1372: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information15;
1373: end if;
1374:
1375: -- nvl(SUI EE Pre Tax Redns, SUI ER Pre Tax Redns)
1376: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information20,0) <> 0 then
1372: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information15;
1373: end if;
1374:
1375: -- nvl(SUI EE Pre Tax Redns, SUI ER Pre Tax Redns)
1376: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information20,0) <> 0 then
1377: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 180);
1378: ln_amt3 := ln_amt3 +
1379: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information20;
1380: else
1375: -- nvl(SUI EE Pre Tax Redns, SUI ER Pre Tax Redns)
1376: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information20,0) <> 0 then
1377: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 180);
1378: ln_amt3 := ln_amt3 +
1379: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information20;
1380: else
1381: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 190);
1382: ln_amt3 := ln_amt3 +
1383: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information16;
1379: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information20;
1380: else
1381: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 190);
1382: ln_amt3 := ln_amt3 +
1383: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information16;
1384: end if;
1385:
1386: -- nvl(SUI EE Taxable, SUI ER Taxable)
1387: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information18,0) <> 0 then
1383: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information16;
1384: end if;
1385:
1386: -- nvl(SUI EE Taxable, SUI ER Taxable)
1387: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information18,0) <> 0 then
1388: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 200);
1389: ln_amt7 := ln_amt7 +
1390: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information18;
1391: else
1386: -- nvl(SUI EE Taxable, SUI ER Taxable)
1387: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information18,0) <> 0 then
1388: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 200);
1389: ln_amt7 := ln_amt7 +
1390: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information18;
1391: else
1392: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 210);
1393: ln_amt7 := ln_amt7 +
1394: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information14;
1390: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information18;
1391: else
1392: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 210);
1393: ln_amt7 := ln_amt7 +
1394: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information14;
1395: end if;
1396:
1397: -- SUI EE Withheld
1398: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1395: end if;
1396:
1397: -- SUI EE Withheld
1398: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1399: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information13;
1400: -- SUI ER Liability
1401: ln_r_er_tax_amt := ln_r_er_tax_amt +
1402: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information21;
1403:
1398: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1399: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information13;
1400: -- SUI ER Liability
1401: ln_r_er_tax_amt := ln_r_er_tax_amt +
1402: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information21;
1403:
1404: elsif p_tax_type in ('SDI', 'HI') then
1405: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 220);
1406: /******************************************************
1413: In case ER is null report EE.
1414: SDI ER Liability is always passed as 0
1415: *******************************************************/
1416: --SDI EE Gross, SDI ER Gross
1417: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information27,0) <> 0 then
1418: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 230);
1419: ln_amt2 := ln_amt2 +
1420: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information27;
1421: else
1416: --SDI EE Gross, SDI ER Gross
1417: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information27,0) <> 0 then
1418: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 230);
1419: ln_amt2 := ln_amt2 +
1420: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information27;
1421: else
1422: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 240);
1423: ln_amt2 := ln_amt2 +
1424: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information26;
1420: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information27;
1421: else
1422: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 240);
1423: ln_amt2 := ln_amt2 +
1424: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information26;
1425: end if;
1426:
1427: -- nvl(SDI EE Subj Whable, SDI ER Subj Whable)
1428: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information11,0) <> 0 then
1424: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information26;
1425: end if;
1426:
1427: -- nvl(SDI EE Subj Whable, SDI ER Subj Whable)
1428: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information11,0) <> 0 then
1429: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 250);
1430: ln_amt4 := ln_amt4 +
1431: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information11;
1432: else
1427: -- nvl(SDI EE Subj Whable, SDI ER Subj Whable)
1428: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information11,0) <> 0 then
1429: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 250);
1430: ln_amt4 := ln_amt4 +
1431: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information11;
1432: else
1433: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 260);
1434: ln_amt4 := ln_amt4 +
1435: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information7;
1431: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information11;
1432: else
1433: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 260);
1434: ln_amt4 := ln_amt4 +
1435: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information7;
1436: end if;
1437:
1438: -- nvl(SDI EE Pre Tax Redns, SDI ER Pre Tax Redns)
1439: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information12,0) <> 0 then
1435: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information7;
1436: end if;
1437:
1438: -- nvl(SDI EE Pre Tax Redns, SDI ER Pre Tax Redns)
1439: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information12,0) <> 0 then
1440: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 270);
1441: ln_amt3 := ln_amt3 +
1442: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information12;
1443: else
1438: -- nvl(SDI EE Pre Tax Redns, SDI ER Pre Tax Redns)
1439: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information12,0) <> 0 then
1440: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 270);
1441: ln_amt3 := ln_amt3 +
1442: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information12;
1443: else
1444: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 280);
1445: ln_amt3 := ln_amt3 +
1446: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information8;
1442: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information12;
1443: else
1444: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 280);
1445: ln_amt3 := ln_amt3 +
1446: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information8;
1447: end if;
1448:
1449: -- nvl(SDI EE Taxable, SDI ER Taxable)
1450: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information10,0) <> 0 then
1446: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information8;
1447: end if;
1448:
1449: -- nvl(SDI EE Taxable, SDI ER Taxable)
1450: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information10,0) <> 0 then
1451: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 290);
1452: ln_amt7 := ln_amt7 +
1453: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information10;
1454: else
1449: -- nvl(SDI EE Taxable, SDI ER Taxable)
1450: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information10,0) <> 0 then
1451: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 290);
1452: ln_amt7 := ln_amt7 +
1453: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information10;
1454: else
1455: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 300);
1456: ln_amt7 := ln_amt7 +
1457: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information6;
1453: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information10;
1454: else
1455: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 300);
1456: ln_amt7 := ln_amt7 +
1457: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information6;
1458: end if;
1459:
1460: -- SDI EE Withheld
1461: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1458: end if;
1459:
1460: -- SDI EE Withheld
1461: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1462: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5;
1463: -- SDI ER Liability
1464: ln_r_er_tax_amt := ln_r_er_tax_amt +
1465: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information9;
1466: elsif p_tax_type = 'WC' then
1461: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1462: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5;
1463: -- SDI ER Liability
1464: ln_r_er_tax_amt := ln_r_er_tax_amt +
1465: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information9;
1466: elsif p_tax_type = 'WC' then
1467: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 350);
1468: null;
1469: /*
1468: null;
1469: /*
1470: -- WC Withheld
1471: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1472: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information22;
1473: */
1474: end if;
1475:
1476: exit;
1479: substr(p_jurisdiction,3,4) <> '-000'then
1480: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 400);
1481: -- Gross Earnings
1482: ln_amt2 := ln_amt2 +
1483: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information7;
1484:
1485: if p_tax_type = 'IT' then
1486: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 410);
1487: -- County Subj Whable
1485: if p_tax_type = 'IT' then
1486: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 410);
1487: -- County Subj Whable
1488: ln_amt4 := ln_amt4 +
1489: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information2;
1490: -- County Subj NWhable
1491: ln_amt5 := ln_amt5 +
1492: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information3;
1493: -- County Pre Tax Redns
1488: ln_amt4 := ln_amt4 +
1489: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information2;
1490: -- County Subj NWhable
1491: ln_amt5 := ln_amt5 +
1492: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information3;
1493: -- County Pre Tax Redns
1494: ln_amt3 := ln_amt3 +
1495: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4;
1496: -- County Withheld
1491: ln_amt5 := ln_amt5 +
1492: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information3;
1493: -- County Pre Tax Redns
1494: ln_amt3 := ln_amt3 +
1495: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4;
1496: -- County Withheld
1497: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R')
1498: = 'R' then
1499: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 420);
1493: -- County Pre Tax Redns
1494: ln_amt3 := ln_amt3 +
1495: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4;
1496: -- County Withheld
1497: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R')
1498: = 'R' then
1499: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 420);
1500: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1501: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information1;
1497: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R')
1498: = 'R' then
1499: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 420);
1500: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1501: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information1;
1502: ln_r_flag := 'Y';
1503: elsif nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R')
1504: = 'NR' then
1505: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 430);
1499: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 420);
1500: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1501: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information1;
1502: ln_r_flag := 'Y';
1503: elsif nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R')
1504: = 'NR' then
1505: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 430);
1506: ln_nr_ee_tax_amt := ln_nr_ee_tax_amt +
1507: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information1;
1503: elsif nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R')
1504: = 'NR' then
1505: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 430);
1506: ln_nr_ee_tax_amt := ln_nr_ee_tax_amt +
1507: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information1;
1508: ln_nr_flag := 'Y';
1509: end if;
1510:
1511: elsif p_tax_type = 'OPT' then
1511: elsif p_tax_type = 'OPT' then
1512: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 440);
1513: -- Head Tax Subj Whable
1514: ln_amt4 := ln_amt4 +
1515: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information2;
1516: -- Head Tax Subj NWhable
1517: ln_amt5 := ln_amt5 +
1518: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information3;
1519: -- Head Tax Pre Tax Redns
1514: ln_amt4 := ln_amt4 +
1515: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information2;
1516: -- Head Tax Subj NWhable
1517: ln_amt5 := ln_amt5 +
1518: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information3;
1519: -- Head Tax Pre Tax Redns
1520: ln_amt3 := ln_amt3 +
1521: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4;
1522:
1517: ln_amt5 := ln_amt5 +
1518: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information3;
1519: -- Head Tax Pre Tax Redns
1520: ln_amt3 := ln_amt3 +
1521: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4;
1522:
1523: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R')
1524: = 'R' then
1525: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 450);
1519: -- Head Tax Pre Tax Redns
1520: ln_amt3 := ln_amt3 +
1521: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4;
1522:
1523: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R')
1524: = 'R' then
1525: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 450);
1526: -- Head Tax Withheld
1527: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1524: = 'R' then
1525: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 450);
1526: -- Head Tax Withheld
1527: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1528: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information6;
1529: -- Head Tax Liability
1530: ln_r_er_tax_amt := ln_r_er_tax_amt +
1531: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5;
1532: ln_r_flag := 'Y';
1527: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1528: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information6;
1529: -- Head Tax Liability
1530: ln_r_er_tax_amt := ln_r_er_tax_amt +
1531: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5;
1532: ln_r_flag := 'Y';
1533: elsif nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R')
1534: = 'NR' then
1535: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 460);
1529: -- Head Tax Liability
1530: ln_r_er_tax_amt := ln_r_er_tax_amt +
1531: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5;
1532: ln_r_flag := 'Y';
1533: elsif nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R')
1534: = 'NR' then
1535: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 460);
1536: -- Head Tax Withheld
1537: ln_nr_ee_tax_amt := ln_nr_ee_tax_amt +
1534: = 'NR' then
1535: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 460);
1536: -- Head Tax Withheld
1537: ln_nr_ee_tax_amt := ln_nr_ee_tax_amt +
1538: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information6;
1539: -- Head Tax Liability
1540: ln_nr_er_tax_amt := ln_nr_er_tax_amt +
1541: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5;
1542: ln_nr_flag := 'Y';
1537: ln_nr_ee_tax_amt := ln_nr_ee_tax_amt +
1538: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information6;
1539: -- Head Tax Liability
1540: ln_nr_er_tax_amt := ln_nr_er_tax_amt +
1541: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5;
1542: ln_nr_flag := 'Y';
1543: end if;
1544: end if;
1545: if ln_nr_flag = 'Y' and ln_r_flag = 'Y' then
1551: substr(p_jurisdiction,3) <> '-000-0000'then
1552: -- Gross Earnings
1553: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 500);
1554: ln_amt2 := ln_amt2 +
1555: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information7;
1556:
1557: if p_tax_type = 'IT' then
1558: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 510);
1559: -- City Subj Whable
1557: if p_tax_type = 'IT' then
1558: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 510);
1559: -- City Subj Whable
1560: ln_amt4 := ln_amt4 +
1561: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information2;
1562: -- City Subj NWhable
1563: ln_amt5 := ln_amt5 +
1564: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information3;
1565: -- City Pre Tax Redns
1560: ln_amt4 := ln_amt4 +
1561: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information2;
1562: -- City Subj NWhable
1563: ln_amt5 := ln_amt5 +
1564: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information3;
1565: -- City Pre Tax Redns
1566: ln_amt3 := ln_amt3 +
1567: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4;
1568: -- City Withheld
1563: ln_amt5 := ln_amt5 +
1564: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information3;
1565: -- City Pre Tax Redns
1566: ln_amt3 := ln_amt3 +
1567: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4;
1568: -- City Withheld
1569: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R') = 'R' then
1570: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 520);
1571: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1565: -- City Pre Tax Redns
1566: ln_amt3 := ln_amt3 +
1567: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4;
1568: -- City Withheld
1569: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R') = 'R' then
1570: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 520);
1571: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1572: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information1;
1573: ln_r_flag := 'Y';
1568: -- City Withheld
1569: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R') = 'R' then
1570: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 520);
1571: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1572: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information1;
1573: ln_r_flag := 'Y';
1574: elsif nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R') = 'NR' then
1575: ln_nr_ee_tax_amt := ln_nr_ee_tax_amt +
1576: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information1;
1570: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 520);
1571: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1572: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information1;
1573: ln_r_flag := 'Y';
1574: elsif nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R') = 'NR' then
1575: ln_nr_ee_tax_amt := ln_nr_ee_tax_amt +
1576: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information1;
1577: ln_nr_flag := 'Y';
1578: end if;
1572: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information1;
1573: ln_r_flag := 'Y';
1574: elsif nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R') = 'NR' then
1575: ln_nr_ee_tax_amt := ln_nr_ee_tax_amt +
1576: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information1;
1577: ln_nr_flag := 'Y';
1578: end if;
1579:
1580: elsif p_tax_type = 'OPT' then
1580: elsif p_tax_type = 'OPT' then
1581: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 530);
1582: -- Head Tax Subj Whable
1583: ln_amt4 := ln_amt4 +
1584: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information2;
1585: -- Head Tax Subj NWhable
1586: ln_amt5 := ln_amt5 +
1587: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information3;
1588: -- Head Tax Pre Tax Redns
1583: ln_amt4 := ln_amt4 +
1584: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information2;
1585: -- Head Tax Subj NWhable
1586: ln_amt5 := ln_amt5 +
1587: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information3;
1588: -- Head Tax Pre Tax Redns
1589: ln_amt3 := ln_amt3 +
1590: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4;
1591: -- Head Tax Withheld
1586: ln_amt5 := ln_amt5 +
1587: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information3;
1588: -- Head Tax Pre Tax Redns
1589: ln_amt3 := ln_amt3 +
1590: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4;
1591: -- Head Tax Withheld
1592: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R') = 'R' then
1593: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 540);
1594: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1588: -- Head Tax Pre Tax Redns
1589: ln_amt3 := ln_amt3 +
1590: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4;
1591: -- Head Tax Withheld
1592: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R') = 'R' then
1593: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 540);
1594: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1595: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information6;
1596: -- Head Tax Liability
1591: -- Head Tax Withheld
1592: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R') = 'R' then
1593: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 540);
1594: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1595: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information6;
1596: -- Head Tax Liability
1597: ln_r_er_tax_amt := ln_r_er_tax_amt +
1598: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5;
1599: ln_r_flag := 'Y';
1594: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1595: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information6;
1596: -- Head Tax Liability
1597: ln_r_er_tax_amt := ln_r_er_tax_amt +
1598: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5;
1599: ln_r_flag := 'Y';
1600: elsif nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R') = 'NR' then
1601: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 550);
1602: -- Head Tax Withheld
1596: -- Head Tax Liability
1597: ln_r_er_tax_amt := ln_r_er_tax_amt +
1598: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5;
1599: ln_r_flag := 'Y';
1600: elsif nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R') = 'NR' then
1601: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 550);
1602: -- Head Tax Withheld
1603: ln_nr_ee_tax_amt := ln_nr_ee_tax_amt +
1604: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information6;
1600: elsif nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R') = 'NR' then
1601: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 550);
1602: -- Head Tax Withheld
1603: ln_nr_ee_tax_amt := ln_nr_ee_tax_amt +
1604: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information6;
1605: -- Head Tax Liability
1606: ln_nr_er_tax_amt := ln_nr_er_tax_amt +
1607: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5;
1608: ln_nr_flag := 'Y';
1603: ln_nr_ee_tax_amt := ln_nr_ee_tax_amt +
1604: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information6;
1605: -- Head Tax Liability
1606: ln_nr_er_tax_amt := ln_nr_er_tax_amt +
1607: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5;
1608: ln_nr_flag := 'Y';
1609: end if;
1610: end if;
1611: if ln_nr_flag = 'Y' and ln_r_flag = 'Y' then
1614:
1615: -- School Jurisdiction code
1616: elsif length(p_jurisdiction) = 8 then
1617: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 600);
1618: if nvl(Pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R')
1619: = nvl(p_resident_jurisdiction, 'R') then
1620:
1621: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 600);
1622: hr_utility.trace('ANK Gross val = ' ||
1619: = nvl(p_resident_jurisdiction, 'R') then
1620:
1621: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 600);
1622: hr_utility.trace('ANK Gross val = ' ||
1623: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5);
1624: -- Gross Earnings
1625: ln_amt2 := ln_amt2 +
1626: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5;
1627:
1622: hr_utility.trace('ANK Gross val = ' ||
1623: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5);
1624: -- Gross Earnings
1625: ln_amt2 := ln_amt2 +
1626: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5;
1627:
1628: if p_tax_type = 'IT' then
1629: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 610);
1630: -- School Subj Whable
1628: if p_tax_type = 'IT' then
1629: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 610);
1630: -- School Subj Whable
1631: ln_amt4 := ln_amt4 +
1632: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information2;
1633: -- School Subj NWhable
1634: ln_amt5 := ln_amt5 +
1635: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information3;
1636: -- School Pre Tax Redns
1631: ln_amt4 := ln_amt4 +
1632: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information2;
1633: -- School Subj NWhable
1634: ln_amt5 := ln_amt5 +
1635: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information3;
1636: -- School Pre Tax Redns
1637: ln_amt3 := ln_amt3 +
1638: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4;
1639: -- School Withheld
1634: ln_amt5 := ln_amt5 +
1635: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information3;
1636: -- School Pre Tax Redns
1637: ln_amt3 := ln_amt3 +
1638: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4;
1639: -- School Withheld
1640: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1641: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information1;
1642: end if;
1637: ln_amt3 := ln_amt3 +
1638: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4;
1639: -- School Withheld
1640: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1641: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information1;
1642: end if;
1643: exit;
1644: end if;
1645:
1704:
1705: --BEGIN
1706: -- hr_utility.trace_on(null, 'FLSP');
1707:
1708: END pay_us_fls_reporting_pkg;