[Home] [Help]
1: PACKAGE BODY pay_us_fls_reporting_pkg AS
2: /* $Header: pyusflsp.pkb 120.10 2010/08/03 10:13:05 emunisek ship $ */
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:
109:
110: /******************************************************************
111: ** Package Local Variables
112: ******************************************************************/
113: gv_package varchar2(50) := 'pay_us_fls_reporting_pkg';
114:
115:
116: /*******************************************************************
117: ** Procedure to return the values for the Payroll Action of
1146: BEGIN
1147: hr_utility.set_location(gv_package || '.get_fls_jd_values', 10);
1148:
1149: /* Reset the PL/SQL tables */
1150: if pay_us_fls_reporting_pkg.ltr_action_info.count > 0 then
1151: for i in pay_us_fls_reporting_pkg.ltr_action_info.first ..
1152: pay_us_fls_reporting_pkg.ltr_action_info.last loop
1153: pay_us_fls_reporting_pkg.ltr_action_info(i).jurisdiction_code := null;
1154: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information1 := null;
1147: hr_utility.set_location(gv_package || '.get_fls_jd_values', 10);
1148:
1149: /* Reset the PL/SQL tables */
1150: if pay_us_fls_reporting_pkg.ltr_action_info.count > 0 then
1151: for i in pay_us_fls_reporting_pkg.ltr_action_info.first ..
1152: pay_us_fls_reporting_pkg.ltr_action_info.last loop
1153: pay_us_fls_reporting_pkg.ltr_action_info(i).jurisdiction_code := null;
1154: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information1 := null;
1155: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information2 := null;
1148:
1149: /* Reset the PL/SQL tables */
1150: if pay_us_fls_reporting_pkg.ltr_action_info.count > 0 then
1151: for i in pay_us_fls_reporting_pkg.ltr_action_info.first ..
1152: pay_us_fls_reporting_pkg.ltr_action_info.last loop
1153: pay_us_fls_reporting_pkg.ltr_action_info(i).jurisdiction_code := null;
1154: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information1 := null;
1155: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information2 := null;
1156: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information3 := null;
1149: /* Reset the PL/SQL tables */
1150: if pay_us_fls_reporting_pkg.ltr_action_info.count > 0 then
1151: for i in pay_us_fls_reporting_pkg.ltr_action_info.first ..
1152: pay_us_fls_reporting_pkg.ltr_action_info.last loop
1153: pay_us_fls_reporting_pkg.ltr_action_info(i).jurisdiction_code := null;
1154: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information1 := null;
1155: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information2 := null;
1156: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information3 := null;
1157: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4 := null;
1150: if pay_us_fls_reporting_pkg.ltr_action_info.count > 0 then
1151: for i in pay_us_fls_reporting_pkg.ltr_action_info.first ..
1152: pay_us_fls_reporting_pkg.ltr_action_info.last loop
1153: pay_us_fls_reporting_pkg.ltr_action_info(i).jurisdiction_code := null;
1154: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information1 := null;
1155: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information2 := null;
1156: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information3 := null;
1157: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4 := null;
1158: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5 := null;
1151: for i in pay_us_fls_reporting_pkg.ltr_action_info.first ..
1152: pay_us_fls_reporting_pkg.ltr_action_info.last loop
1153: pay_us_fls_reporting_pkg.ltr_action_info(i).jurisdiction_code := null;
1154: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information1 := null;
1155: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information2 := null;
1156: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information3 := null;
1157: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4 := null;
1158: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5 := null;
1159: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information6 := null;
1152: pay_us_fls_reporting_pkg.ltr_action_info.last loop
1153: pay_us_fls_reporting_pkg.ltr_action_info(i).jurisdiction_code := null;
1154: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information1 := null;
1155: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information2 := null;
1156: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information3 := null;
1157: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4 := null;
1158: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5 := null;
1159: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information6 := null;
1160: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information7 := null;
1153: pay_us_fls_reporting_pkg.ltr_action_info(i).jurisdiction_code := null;
1154: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information1 := null;
1155: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information2 := null;
1156: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information3 := null;
1157: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4 := null;
1158: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5 := null;
1159: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information6 := null;
1160: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information7 := null;
1161: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information8 := null;
1154: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information1 := null;
1155: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information2 := null;
1156: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information3 := null;
1157: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4 := null;
1158: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5 := null;
1159: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information6 := null;
1160: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information7 := null;
1161: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information8 := null;
1162: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information9 := null;
1155: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information2 := null;
1156: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information3 := null;
1157: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4 := null;
1158: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5 := null;
1159: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information6 := null;
1160: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information7 := null;
1161: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information8 := null;
1162: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information9 := null;
1163: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information10 := null;
1156: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information3 := null;
1157: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4 := null;
1158: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5 := null;
1159: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information6 := null;
1160: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information7 := null;
1161: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information8 := null;
1162: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information9 := null;
1163: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information10 := null;
1164: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information11 := null;
1157: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4 := null;
1158: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5 := null;
1159: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information6 := null;
1160: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information7 := null;
1161: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information8 := null;
1162: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information9 := null;
1163: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information10 := null;
1164: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information11 := null;
1165: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information12 := null;
1158: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5 := null;
1159: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information6 := null;
1160: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information7 := null;
1161: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information8 := null;
1162: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information9 := null;
1163: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information10 := null;
1164: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information11 := null;
1165: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information12 := null;
1166: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information13 := null;
1159: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information6 := null;
1160: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information7 := null;
1161: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information8 := null;
1162: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information9 := null;
1163: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information10 := null;
1164: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information11 := null;
1165: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information12 := null;
1166: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information13 := null;
1167: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information14 := null;
1160: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information7 := null;
1161: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information8 := null;
1162: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information9 := null;
1163: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information10 := null;
1164: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information11 := null;
1165: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information12 := null;
1166: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information13 := null;
1167: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information14 := null;
1168: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information15 := null;
1161: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information8 := null;
1162: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information9 := null;
1163: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information10 := null;
1164: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information11 := null;
1165: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information12 := null;
1166: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information13 := null;
1167: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information14 := null;
1168: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information15 := null;
1169: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information16 := null;
1162: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information9 := null;
1163: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information10 := null;
1164: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information11 := null;
1165: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information12 := null;
1166: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information13 := null;
1167: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information14 := null;
1168: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information15 := null;
1169: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information16 := null;
1170: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information17 := null;
1163: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information10 := null;
1164: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information11 := null;
1165: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information12 := null;
1166: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information13 := null;
1167: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information14 := null;
1168: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information15 := null;
1169: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information16 := null;
1170: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information17 := null;
1171: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information18 := null;
1164: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information11 := null;
1165: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information12 := null;
1166: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information13 := null;
1167: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information14 := null;
1168: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information15 := null;
1169: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information16 := null;
1170: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information17 := null;
1171: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information18 := null;
1172: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information19 := null;
1165: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information12 := null;
1166: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information13 := null;
1167: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information14 := null;
1168: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information15 := null;
1169: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information16 := null;
1170: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information17 := null;
1171: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information18 := null;
1172: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information19 := null;
1173: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information20 := null;
1166: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information13 := null;
1167: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information14 := null;
1168: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information15 := null;
1169: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information16 := null;
1170: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information17 := null;
1171: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information18 := null;
1172: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information19 := null;
1173: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information20 := null;
1174: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information21 := null;
1167: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information14 := null;
1168: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information15 := null;
1169: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information16 := null;
1170: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information17 := null;
1171: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information18 := null;
1172: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information19 := null;
1173: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information20 := null;
1174: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information21 := null;
1175: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information22 := null;
1168: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information15 := null;
1169: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information16 := null;
1170: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information17 := null;
1171: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information18 := null;
1172: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information19 := null;
1173: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information20 := null;
1174: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information21 := null;
1175: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information22 := null;
1176: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information23 := null;
1169: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information16 := null;
1170: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information17 := null;
1171: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information18 := null;
1172: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information19 := null;
1173: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information20 := null;
1174: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information21 := null;
1175: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information22 := null;
1176: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information23 := null;
1177: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information24 := null;
1170: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information17 := null;
1171: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information18 := null;
1172: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information19 := null;
1173: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information20 := null;
1174: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information21 := null;
1175: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information22 := null;
1176: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information23 := null;
1177: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information24 := null;
1178: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information25 := null;
1171: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information18 := null;
1172: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information19 := null;
1173: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information20 := null;
1174: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information21 := null;
1175: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information22 := null;
1176: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information23 := null;
1177: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information24 := null;
1178: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information25 := null;
1179: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information26 := null;
1172: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information19 := null;
1173: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information20 := null;
1174: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information21 := null;
1175: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information22 := null;
1176: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information23 := null;
1177: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information24 := null;
1178: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information25 := null;
1179: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information26 := null;
1180: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information27 := null;
1173: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information20 := null;
1174: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information21 := null;
1175: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information22 := null;
1176: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information23 := null;
1177: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information24 := null;
1178: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information25 := null;
1179: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information26 := null;
1180: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information27 := null;
1181: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information28 := null;
1174: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information21 := null;
1175: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information22 := null;
1176: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information23 := null;
1177: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information24 := null;
1178: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information25 := null;
1179: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information26 := null;
1180: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information27 := null;
1181: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information28 := null;
1182: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information29 := null;
1175: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information22 := null;
1176: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information23 := null;
1177: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information24 := null;
1178: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information25 := null;
1179: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information26 := null;
1180: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information27 := null;
1181: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information28 := null;
1182: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information29 := null;
1183: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30 := null;
1176: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information23 := null;
1177: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information24 := null;
1178: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information25 := null;
1179: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information26 := null;
1180: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information27 := null;
1181: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information28 := null;
1182: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information29 := null;
1183: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30 := null;
1184: pay_us_fls_reporting_pkg.ltr_action_info(i).sdi1_ee := null; --9164356
1177: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information24 := null;
1178: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information25 := null;
1179: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information26 := null;
1180: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information27 := null;
1181: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information28 := null;
1182: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information29 := null;
1183: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30 := null;
1184: pay_us_fls_reporting_pkg.ltr_action_info(i).sdi1_ee := null; --9164356
1185: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information31 := null; --Added for Bug#9872952
1178: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information25 := null;
1179: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information26 := null;
1180: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information27 := null;
1181: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information28 := null;
1182: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information29 := null;
1183: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30 := null;
1184: pay_us_fls_reporting_pkg.ltr_action_info(i).sdi1_ee := null; --9164356
1185: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information31 := null; --Added for Bug#9872952
1186: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information32 := null; --Added for Bug#9872952
1179: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information26 := null;
1180: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information27 := null;
1181: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information28 := null;
1182: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information29 := null;
1183: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30 := null;
1184: pay_us_fls_reporting_pkg.ltr_action_info(i).sdi1_ee := null; --9164356
1185: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information31 := null; --Added for Bug#9872952
1186: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information32 := null; --Added for Bug#9872952
1187: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information33 := null; --Added for Bug#9872952
1180: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information27 := null;
1181: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information28 := null;
1182: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information29 := null;
1183: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30 := null;
1184: pay_us_fls_reporting_pkg.ltr_action_info(i).sdi1_ee := null; --9164356
1185: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information31 := null; --Added for Bug#9872952
1186: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information32 := null; --Added for Bug#9872952
1187: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information33 := null; --Added for Bug#9872952
1188: end loop;
1181: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information28 := null;
1182: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information29 := null;
1183: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30 := null;
1184: pay_us_fls_reporting_pkg.ltr_action_info(i).sdi1_ee := null; --9164356
1185: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information31 := null; --Added for Bug#9872952
1186: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information32 := null; --Added for Bug#9872952
1187: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information33 := null; --Added for Bug#9872952
1188: end loop;
1189: pay_us_fls_reporting_pkg.ltr_action_info.delete;
1182: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information29 := null;
1183: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30 := null;
1184: pay_us_fls_reporting_pkg.ltr_action_info(i).sdi1_ee := null; --9164356
1185: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information31 := null; --Added for Bug#9872952
1186: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information32 := null; --Added for Bug#9872952
1187: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information33 := null; --Added for Bug#9872952
1188: end loop;
1189: pay_us_fls_reporting_pkg.ltr_action_info.delete;
1190: end if;
1183: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30 := null;
1184: pay_us_fls_reporting_pkg.ltr_action_info(i).sdi1_ee := null; --9164356
1185: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information31 := null; --Added for Bug#9872952
1186: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information32 := null; --Added for Bug#9872952
1187: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information33 := null; --Added for Bug#9872952
1188: end loop;
1189: pay_us_fls_reporting_pkg.ltr_action_info.delete;
1190: end if;
1191:
1185: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information31 := null; --Added for Bug#9872952
1186: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information32 := null; --Added for Bug#9872952
1187: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information33 := null; --Added for Bug#9872952
1188: end loop;
1189: pay_us_fls_reporting_pkg.ltr_action_info.delete;
1190: end if;
1191:
1192: hr_utility.trace('Payroll Action ID=' || p_payroll_action_id);
1193: hr_utility.trace('Tax Unit ID=' || p_tax_unit_id);
1194: for action_rec in c_action_info(p_tax_unit_id, p_payroll_action_id)
1195: loop
1196: hr_utility.set_location(gv_package || '.get_fls_jd_values', 20);
1197: /* Commented out because of DB issue. Bug 1822467 */
1198: --pay_us_fls_reporting_pkg.ltr_action_info(i_count) := action_rec;
1199: pay_us_fls_reporting_pkg.ltr_action_info(i_count).jurisdiction_code
1200: := action_rec.jurisdiction_code;
1201: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information1
1202: := action_rec.action_information1;
1195: loop
1196: hr_utility.set_location(gv_package || '.get_fls_jd_values', 20);
1197: /* Commented out because of DB issue. Bug 1822467 */
1198: --pay_us_fls_reporting_pkg.ltr_action_info(i_count) := action_rec;
1199: pay_us_fls_reporting_pkg.ltr_action_info(i_count).jurisdiction_code
1200: := action_rec.jurisdiction_code;
1201: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information1
1202: := action_rec.action_information1;
1203: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information2
1197: /* Commented out because of DB issue. Bug 1822467 */
1198: --pay_us_fls_reporting_pkg.ltr_action_info(i_count) := action_rec;
1199: pay_us_fls_reporting_pkg.ltr_action_info(i_count).jurisdiction_code
1200: := action_rec.jurisdiction_code;
1201: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information1
1202: := action_rec.action_information1;
1203: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information2
1204: := action_rec.action_information2;
1205: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information3
1199: pay_us_fls_reporting_pkg.ltr_action_info(i_count).jurisdiction_code
1200: := action_rec.jurisdiction_code;
1201: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information1
1202: := action_rec.action_information1;
1203: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information2
1204: := action_rec.action_information2;
1205: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information3
1206: := action_rec.action_information3;
1207: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information4
1201: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information1
1202: := action_rec.action_information1;
1203: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information2
1204: := action_rec.action_information2;
1205: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information3
1206: := action_rec.action_information3;
1207: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information4
1208: := action_rec.action_information4;
1209: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information5
1203: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information2
1204: := action_rec.action_information2;
1205: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information3
1206: := action_rec.action_information3;
1207: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information4
1208: := action_rec.action_information4;
1209: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information5
1210: := action_rec.action_information5;
1211: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information6
1205: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information3
1206: := action_rec.action_information3;
1207: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information4
1208: := action_rec.action_information4;
1209: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information5
1210: := action_rec.action_information5;
1211: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information6
1212: := action_rec.action_information6;
1213: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information7
1207: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information4
1208: := action_rec.action_information4;
1209: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information5
1210: := action_rec.action_information5;
1211: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information6
1212: := action_rec.action_information6;
1213: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information7
1214: := action_rec.action_information7;
1215: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information8
1209: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information5
1210: := action_rec.action_information5;
1211: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information6
1212: := action_rec.action_information6;
1213: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information7
1214: := action_rec.action_information7;
1215: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information8
1216: := action_rec.action_information8;
1217: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information9
1211: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information6
1212: := action_rec.action_information6;
1213: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information7
1214: := action_rec.action_information7;
1215: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information8
1216: := action_rec.action_information8;
1217: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information9
1218: := action_rec.action_information9;
1219: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information10
1213: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information7
1214: := action_rec.action_information7;
1215: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information8
1216: := action_rec.action_information8;
1217: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information9
1218: := action_rec.action_information9;
1219: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information10
1220: := action_rec.action_information10;
1221: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information11
1215: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information8
1216: := action_rec.action_information8;
1217: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information9
1218: := action_rec.action_information9;
1219: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information10
1220: := action_rec.action_information10;
1221: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information11
1222: := action_rec.action_information11;
1223: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information12
1217: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information9
1218: := action_rec.action_information9;
1219: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information10
1220: := action_rec.action_information10;
1221: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information11
1222: := action_rec.action_information11;
1223: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information12
1224: := action_rec.action_information12;
1225: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information13
1219: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information10
1220: := action_rec.action_information10;
1221: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information11
1222: := action_rec.action_information11;
1223: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information12
1224: := action_rec.action_information12;
1225: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information13
1226: := action_rec.action_information13;
1227: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information14
1221: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information11
1222: := action_rec.action_information11;
1223: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information12
1224: := action_rec.action_information12;
1225: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information13
1226: := action_rec.action_information13;
1227: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information14
1228: := action_rec.action_information14;
1229: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information15
1223: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information12
1224: := action_rec.action_information12;
1225: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information13
1226: := action_rec.action_information13;
1227: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information14
1228: := action_rec.action_information14;
1229: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information15
1230: := action_rec.action_information15;
1231: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information16
1225: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information13
1226: := action_rec.action_information13;
1227: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information14
1228: := action_rec.action_information14;
1229: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information15
1230: := action_rec.action_information15;
1231: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information16
1232: := action_rec.action_information16;
1233: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information17
1227: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information14
1228: := action_rec.action_information14;
1229: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information15
1230: := action_rec.action_information15;
1231: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information16
1232: := action_rec.action_information16;
1233: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information17
1234: := action_rec.action_information17;
1235: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information18
1229: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information15
1230: := action_rec.action_information15;
1231: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information16
1232: := action_rec.action_information16;
1233: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information17
1234: := action_rec.action_information17;
1235: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information18
1236: := action_rec.action_information18;
1237: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information19
1231: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information16
1232: := action_rec.action_information16;
1233: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information17
1234: := action_rec.action_information17;
1235: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information18
1236: := action_rec.action_information18;
1237: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information19
1238: := action_rec.action_information19;
1239: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information20
1233: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information17
1234: := action_rec.action_information17;
1235: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information18
1236: := action_rec.action_information18;
1237: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information19
1238: := action_rec.action_information19;
1239: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information20
1240: := action_rec.action_information20;
1241: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information21
1235: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information18
1236: := action_rec.action_information18;
1237: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information19
1238: := action_rec.action_information19;
1239: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information20
1240: := action_rec.action_information20;
1241: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information21
1242: := action_rec.action_information21;
1243: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information22
1237: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information19
1238: := action_rec.action_information19;
1239: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information20
1240: := action_rec.action_information20;
1241: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information21
1242: := action_rec.action_information21;
1243: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information22
1244: := action_rec.action_information22;
1245: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information23
1239: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information20
1240: := action_rec.action_information20;
1241: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information21
1242: := action_rec.action_information21;
1243: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information22
1244: := action_rec.action_information22;
1245: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information23
1246: := action_rec.action_information23;
1247: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information24
1241: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information21
1242: := action_rec.action_information21;
1243: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information22
1244: := action_rec.action_information22;
1245: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information23
1246: := action_rec.action_information23;
1247: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information24
1248: := action_rec.action_information24;
1249: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information25
1243: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information22
1244: := action_rec.action_information22;
1245: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information23
1246: := action_rec.action_information23;
1247: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information24
1248: := action_rec.action_information24;
1249: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information25
1250: := action_rec.action_information25;
1251: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information26
1245: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information23
1246: := action_rec.action_information23;
1247: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information24
1248: := action_rec.action_information24;
1249: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information25
1250: := action_rec.action_information25;
1251: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information26
1252: := action_rec.action_information26;
1253: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information27
1247: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information24
1248: := action_rec.action_information24;
1249: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information25
1250: := action_rec.action_information25;
1251: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information26
1252: := action_rec.action_information26;
1253: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information27
1254: := action_rec.action_information27;
1255: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information28
1249: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information25
1250: := action_rec.action_information25;
1251: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information26
1252: := action_rec.action_information26;
1253: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information27
1254: := action_rec.action_information27;
1255: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information28
1256: := action_rec.action_information28;
1257: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information29
1251: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information26
1252: := action_rec.action_information26;
1253: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information27
1254: := action_rec.action_information27;
1255: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information28
1256: := action_rec.action_information28;
1257: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information29
1258: := action_rec.action_information29;
1259: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information30
1253: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information27
1254: := action_rec.action_information27;
1255: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information28
1256: := action_rec.action_information28;
1257: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information29
1258: := action_rec.action_information29;
1259: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information30
1260: := action_rec.action_information30;
1261: pay_us_fls_reporting_pkg.ltr_action_info(i_count).sdi1_ee
1255: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information28
1256: := action_rec.action_information28;
1257: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information29
1258: := action_rec.action_information29;
1259: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information30
1260: := action_rec.action_information30;
1261: pay_us_fls_reporting_pkg.ltr_action_info(i_count).sdi1_ee
1262: := action_rec.sdi1_ee; --#9164356
1263: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information31 --Added for Bug#9872952
1257: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information29
1258: := action_rec.action_information29;
1259: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information30
1260: := action_rec.action_information30;
1261: pay_us_fls_reporting_pkg.ltr_action_info(i_count).sdi1_ee
1262: := action_rec.sdi1_ee; --#9164356
1263: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information31 --Added for Bug#9872952
1264: := action_rec.action_information31;
1265: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information32 --Added for Bug#9872952
1259: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information30
1260: := action_rec.action_information30;
1261: pay_us_fls_reporting_pkg.ltr_action_info(i_count).sdi1_ee
1262: := action_rec.sdi1_ee; --#9164356
1263: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information31 --Added for Bug#9872952
1264: := action_rec.action_information31;
1265: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information32 --Added for Bug#9872952
1266: := action_rec.action_information32;
1267: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information33 --Added for Bug#9872952
1261: pay_us_fls_reporting_pkg.ltr_action_info(i_count).sdi1_ee
1262: := action_rec.sdi1_ee; --#9164356
1263: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information31 --Added for Bug#9872952
1264: := action_rec.action_information31;
1265: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information32 --Added for Bug#9872952
1266: := action_rec.action_information32;
1267: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information33 --Added for Bug#9872952
1268: := action_rec.action_information33;
1269:
1263: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information31 --Added for Bug#9872952
1264: := action_rec.action_information31;
1265: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information32 --Added for Bug#9872952
1266: := action_rec.action_information32;
1267: pay_us_fls_reporting_pkg.ltr_action_info(i_count).action_information33 --Added for Bug#9872952
1268: := action_rec.action_information33;
1269:
1270: i_count := i_count + 1;
1271: hr_utility.set_location(gv_package || '.get_fls_jd_values', 30);
1271: hr_utility.set_location(gv_package || '.get_fls_jd_values', 30);
1272: end loop;
1273:
1274: hr_utility.set_location(gv_package || '.get_fls_jd_values', 40);
1275: if pay_us_fls_reporting_pkg.ltr_action_info.count > 0 then
1276: for i in pay_us_fls_reporting_pkg.ltr_action_info.first ..
1277: pay_us_fls_reporting_pkg.ltr_action_info.last loop
1278: hr_utility.trace('JD='||pay_us_fls_reporting_pkg.ltr_action_info(i).jurisdiction_code);
1279: end loop;
1272: end loop;
1273:
1274: hr_utility.set_location(gv_package || '.get_fls_jd_values', 40);
1275: if pay_us_fls_reporting_pkg.ltr_action_info.count > 0 then
1276: for i in pay_us_fls_reporting_pkg.ltr_action_info.first ..
1277: pay_us_fls_reporting_pkg.ltr_action_info.last loop
1278: hr_utility.trace('JD='||pay_us_fls_reporting_pkg.ltr_action_info(i).jurisdiction_code);
1279: end loop;
1280: end if;
1273:
1274: hr_utility.set_location(gv_package || '.get_fls_jd_values', 40);
1275: if pay_us_fls_reporting_pkg.ltr_action_info.count > 0 then
1276: for i in pay_us_fls_reporting_pkg.ltr_action_info.first ..
1277: pay_us_fls_reporting_pkg.ltr_action_info.last loop
1278: hr_utility.trace('JD='||pay_us_fls_reporting_pkg.ltr_action_info(i).jurisdiction_code);
1279: end loop;
1280: end if;
1281: hr_utility.trace('AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA');
1274: hr_utility.set_location(gv_package || '.get_fls_jd_values', 40);
1275: if pay_us_fls_reporting_pkg.ltr_action_info.count > 0 then
1276: for i in pay_us_fls_reporting_pkg.ltr_action_info.first ..
1277: pay_us_fls_reporting_pkg.ltr_action_info.last loop
1278: hr_utility.trace('JD='||pay_us_fls_reporting_pkg.ltr_action_info(i).jurisdiction_code);
1279: end loop;
1280: end if;
1281: hr_utility.trace('AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA');
1282:
1326: BEGIN
1327: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 10);
1328: hr_utility.trace('Tax Type Code=' || p_tax_type);
1329: hr_utility.trace('Jurisdiction Code=' || p_jurisdiction);
1330: hr_utility.trace('PL/SQL Count=' || pay_us_fls_reporting_pkg.ltr_action_info.count);
1331:
1332: for i in pay_us_fls_reporting_pkg.ltr_action_info.first ..
1333: pay_us_fls_reporting_pkg.ltr_action_info.last loop
1334:
1328: hr_utility.trace('Tax Type Code=' || p_tax_type);
1329: hr_utility.trace('Jurisdiction Code=' || p_jurisdiction);
1330: hr_utility.trace('PL/SQL Count=' || pay_us_fls_reporting_pkg.ltr_action_info.count);
1331:
1332: for i in pay_us_fls_reporting_pkg.ltr_action_info.first ..
1333: pay_us_fls_reporting_pkg.ltr_action_info.last loop
1334:
1335: hr_utility.trace('PL/SQL Jurisdiction Code=' ||
1336: pay_us_fls_reporting_pkg.ltr_action_info(i).jurisdiction_code);
1329: hr_utility.trace('Jurisdiction Code=' || p_jurisdiction);
1330: hr_utility.trace('PL/SQL Count=' || pay_us_fls_reporting_pkg.ltr_action_info.count);
1331:
1332: for i in pay_us_fls_reporting_pkg.ltr_action_info.first ..
1333: pay_us_fls_reporting_pkg.ltr_action_info.last loop
1334:
1335: hr_utility.trace('PL/SQL Jurisdiction Code=' ||
1336: pay_us_fls_reporting_pkg.ltr_action_info(i).jurisdiction_code);
1337:
1332: for i in pay_us_fls_reporting_pkg.ltr_action_info.first ..
1333: pay_us_fls_reporting_pkg.ltr_action_info.last loop
1334:
1335: hr_utility.trace('PL/SQL Jurisdiction Code=' ||
1336: pay_us_fls_reporting_pkg.ltr_action_info(i).jurisdiction_code);
1337:
1338: hr_utility.trace('PL/SQL Action30 is= ' ||
1339: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30);
1340:
1335: hr_utility.trace('PL/SQL Jurisdiction Code=' ||
1336: pay_us_fls_reporting_pkg.ltr_action_info(i).jurisdiction_code);
1337:
1338: hr_utility.trace('PL/SQL Action30 is= ' ||
1339: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30);
1340:
1341: hr_utility.trace('PL/SQL p_jurisdiction is= ' ||
1342: p_jurisdiction);
1343:
1343:
1344: hr_utility.trace('PL/SQL p_resident_jurisdiction is = ' ||
1345: nvl(p_resident_jurisdiction,'NOT ARCHIVED'));
1346:
1347: if pay_us_fls_reporting_pkg.ltr_action_info(i).jurisdiction_code = p_jurisdiction then
1348:
1349: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 20);
1350:
1351: if p_jurisdiction = '00-000-0000' then
1353:
1354: if p_tax_type <> 'IT' THEN -- If clause added for Bug#9872952
1355: -- Regular Earnings
1356: ln_amt1 := ln_amt1 +
1357: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information2;
1358: -- Gross Earnings
1359: ln_amt2 := ln_amt2 +
1360: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information23;
1361: -- Pre Tax Deduction
1356: ln_amt1 := ln_amt1 +
1357: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information2;
1358: -- Gross Earnings
1359: ln_amt2 := ln_amt2 +
1360: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information23;
1361: -- Pre Tax Deduction
1362: ln_amt3 := ln_amt3 +
1363: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5;
1364:
1359: ln_amt2 := ln_amt2 +
1360: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information23;
1361: -- Pre Tax Deduction
1362: ln_amt3 := ln_amt3 +
1363: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5;
1364:
1365: end if;
1366:
1367: if p_tax_type = 'IT' then
1370: only for FIT Wages based on the FIT Exempt from Wage Accumulation Flag*/
1371: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 40);
1372: -- Regular Earnings
1373: ln_amt1 := ln_amt1 +
1374: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information31;
1375: -- Gross Earnings
1376: ln_amt2 := ln_amt2 +
1377: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information33;
1378: -- Pre Tax Deduction
1373: ln_amt1 := ln_amt1 +
1374: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information31;
1375: -- Gross Earnings
1376: ln_amt2 := ln_amt2 +
1377: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information33;
1378: -- Pre Tax Deduction
1379: ln_amt3 := ln_amt3 +
1380: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information32;
1381: -- End Bug#9872952
1376: ln_amt2 := ln_amt2 +
1377: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information33;
1378: -- Pre Tax Deduction
1379: ln_amt3 := ln_amt3 +
1380: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information32;
1381: -- End Bug#9872952
1382: -- Supp Earning for FIT
1383: ln_amt4 := ln_amt4 +
1384: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information3;
1380: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information32;
1381: -- End Bug#9872952
1382: -- Supp Earning for FIT
1383: ln_amt4 := ln_amt4 +
1384: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information3;
1385: -- Supp Earning for NWFIT
1386: ln_amt5 := ln_amt5 +
1387: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4;
1388: -- Pre Tax Deduction for FIT
1383: ln_amt4 := ln_amt4 +
1384: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information3;
1385: -- Supp Earning for NWFIT
1386: ln_amt5 := ln_amt5 +
1387: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4;
1388: -- Pre Tax Deduction for FIT
1389: ln_amt6 := ln_amt6 +
1390: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information6;
1391: -- FIT Withheld
1386: ln_amt5 := ln_amt5 +
1387: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4;
1388: -- Pre Tax Deduction for FIT
1389: ln_amt6 := ln_amt6 +
1390: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information6;
1391: -- FIT Withheld
1392: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1393: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information1;
1394:
1389: ln_amt6 := ln_amt6 +
1390: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information6;
1391: -- FIT Withheld
1392: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1393: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information1;
1394:
1395: elsif p_tax_type = 'UI' then
1396: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 50);
1397: -- Supp Earning for FUTA
1395: elsif p_tax_type = 'UI' then
1396: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 50);
1397: -- Supp Earning for FUTA
1398: ln_amt4 := ln_amt4 +
1399: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information19;
1400: -- Pre Tax Deduction for FUTA
1401: ln_amt6 := ln_amt6 +
1402: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information20;
1403: -- Taxable
1398: ln_amt4 := ln_amt4 +
1399: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information19;
1400: -- Pre Tax Deduction for FUTA
1401: ln_amt6 := ln_amt6 +
1402: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information20;
1403: -- Taxable
1404: ln_amt7 := ln_amt7 +
1405: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information21;
1406: -- Liability
1401: ln_amt6 := ln_amt6 +
1402: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information20;
1403: -- Taxable
1404: ln_amt7 := ln_amt7 +
1405: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information21;
1406: -- Liability
1407: ln_r_er_tax_amt := ln_r_er_tax_amt +
1408: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information22;
1409:
1404: ln_amt7 := ln_amt7 +
1405: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information21;
1406: -- Liability
1407: ln_r_er_tax_amt := ln_r_er_tax_amt +
1408: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information22;
1409:
1410: elsif p_tax_type = 'OASDI' then
1411: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 60);
1412: -- Supp Earning for SS
1410: elsif p_tax_type = 'OASDI' then
1411: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 60);
1412: -- Supp Earning for SS
1413: ln_amt4 := ln_amt4 +
1414: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information11;
1415: -- Pre Tax Deduction for SS
1416: ln_amt6 := ln_amt6 +
1417: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information12;
1418: -- Taxable
1413: ln_amt4 := ln_amt4 +
1414: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information11;
1415: -- Pre Tax Deduction for SS
1416: ln_amt6 := ln_amt6 +
1417: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information12;
1418: -- Taxable
1419: ln_amt7 := ln_amt7 +
1420: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information7;
1421: -- SS EE Withheld
1416: ln_amt6 := ln_amt6 +
1417: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information12;
1418: -- Taxable
1419: ln_amt7 := ln_amt7 +
1420: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information7;
1421: -- SS EE Withheld
1422: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1423: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information8;
1424: -- SS ER Liability
1419: ln_amt7 := ln_amt7 +
1420: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information7;
1421: -- SS EE Withheld
1422: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1423: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information8;
1424: -- SS ER Liability
1425: ln_r_er_tax_amt := ln_r_er_tax_amt +
1426: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information9;
1427: elsif p_tax_type = 'HI' then
1422: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1423: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information8;
1424: -- SS ER Liability
1425: ln_r_er_tax_amt := ln_r_er_tax_amt +
1426: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information9;
1427: elsif p_tax_type = 'HI' then
1428: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 70);
1429: -- Supp Earning for Medicare
1430: ln_amt4 := ln_amt4 +
1427: elsif p_tax_type = 'HI' then
1428: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 70);
1429: -- Supp Earning for Medicare
1430: ln_amt4 := ln_amt4 +
1431: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information17;
1432: -- Pre Tax Deduction for Medicare
1433: ln_amt6 := ln_amt6 +
1434: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information18;
1435: -- Medicare EE Taxable
1430: ln_amt4 := ln_amt4 +
1431: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information17;
1432: -- Pre Tax Deduction for Medicare
1433: ln_amt6 := ln_amt6 +
1434: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information18;
1435: -- Medicare EE Taxable
1436: ln_amt7 := ln_amt7 +
1437: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information13;
1438: -- Medicare Withheld
1433: ln_amt6 := ln_amt6 +
1434: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information18;
1435: -- Medicare EE Taxable
1436: ln_amt7 := ln_amt7 +
1437: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information13;
1438: -- Medicare Withheld
1439: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1440: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information14;
1441: -- Medicare ER Liability
1436: ln_amt7 := ln_amt7 +
1437: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information13;
1438: -- Medicare Withheld
1439: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1440: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information14;
1441: -- Medicare ER Liability
1442: ln_r_er_tax_amt := ln_r_er_tax_amt +
1443: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information15;
1444: elsif p_tax_type = 'EIC' then
1439: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1440: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information14;
1441: -- Medicare ER Liability
1442: ln_r_er_tax_amt := ln_r_er_tax_amt +
1443: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information15;
1444: elsif p_tax_type = 'EIC' then
1445: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 80);
1446: ln_amt1 := 0;
1447: ln_amt2 := 0;
1447: ln_amt2 := 0;
1448: ln_amt3 := 0;
1449: -- EIC Advance
1450: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1451: (-1 * pay_us_fls_reporting_pkg.ltr_action_info(i).action_information26);
1452:
1453: end if;
1454: exit;
1455: -- State Jurisdiction code
1461: if p_tax_type = 'IT' then
1462: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 120);
1463: --SIT Gross
1464: ln_amt2 := ln_amt2 +
1465: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information17;
1466: -- SIT Subj Whable
1467: ln_amt4 := ln_amt4 +
1468: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information2;
1469: -- SIT Subj NWhable
1464: ln_amt2 := ln_amt2 +
1465: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information17;
1466: -- SIT Subj Whable
1467: ln_amt4 := ln_amt4 +
1468: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information2;
1469: -- SIT Subj NWhable
1470: ln_amt5 := ln_amt5 +
1471: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information3;
1472: -- SIT Pre Tax Redns
1467: ln_amt4 := ln_amt4 +
1468: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information2;
1469: -- SIT Subj NWhable
1470: ln_amt5 := ln_amt5 +
1471: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information3;
1472: -- SIT Pre Tax Redns
1473: ln_amt3 := ln_amt3 +
1474: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4;
1475: -- SIT Withheld
1470: ln_amt5 := ln_amt5 +
1471: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information3;
1472: -- SIT Pre Tax Redns
1473: ln_amt3 := ln_amt3 +
1474: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4;
1475: -- SIT Withheld
1476: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1477: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information1;
1478:
1473: ln_amt3 := ln_amt3 +
1474: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4;
1475: -- SIT Withheld
1476: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1477: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information1;
1478:
1479: elsif p_tax_type = 'UI' then
1480: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 130);
1481: /* Always report the ER component if it is there. -- 4335410
1484: Doing an if to get EE or ER Wages instead on NVL as the PL/SQL table will
1485: have a Zero value if there is a NULL in the table. */
1486:
1487: -- SUI EE Gross, SUI ER Gross
1488: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information29,0) <> 0 then
1489: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 140);
1490: ln_amt2 := ln_amt2 +
1491: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information29;
1492: else
1487: -- SUI EE Gross, SUI ER Gross
1488: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information29,0) <> 0 then
1489: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 140);
1490: ln_amt2 := ln_amt2 +
1491: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information29;
1492: else
1493: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 150);
1494: ln_amt2 := ln_amt2 +
1495: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information28;
1491: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information29;
1492: else
1493: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 150);
1494: ln_amt2 := ln_amt2 +
1495: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information28;
1496: end if;
1497:
1498: -- nvl(SUI EE Subj Whable, SUI ER Subj Whable)
1499: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information19,0) <> 0 then
1495: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information28;
1496: end if;
1497:
1498: -- nvl(SUI EE Subj Whable, SUI ER Subj Whable)
1499: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information19,0) <> 0 then
1500: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 160);
1501: ln_amt4 := ln_amt4 +
1502: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information19;
1503: else
1498: -- nvl(SUI EE Subj Whable, SUI ER Subj Whable)
1499: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information19,0) <> 0 then
1500: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 160);
1501: ln_amt4 := ln_amt4 +
1502: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information19;
1503: else
1504: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 170);
1505: ln_amt4 := ln_amt4 +
1506: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information15;
1502: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information19;
1503: else
1504: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 170);
1505: ln_amt4 := ln_amt4 +
1506: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information15;
1507: end if;
1508:
1509: -- nvl(SUI EE Pre Tax Redns, SUI ER Pre Tax Redns)
1510: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information20,0) <> 0 then
1506: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information15;
1507: end if;
1508:
1509: -- nvl(SUI EE Pre Tax Redns, SUI ER Pre Tax Redns)
1510: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information20,0) <> 0 then
1511: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 180);
1512: ln_amt3 := ln_amt3 +
1513: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information20;
1514: else
1509: -- nvl(SUI EE Pre Tax Redns, SUI ER Pre Tax Redns)
1510: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information20,0) <> 0 then
1511: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 180);
1512: ln_amt3 := ln_amt3 +
1513: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information20;
1514: else
1515: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 190);
1516: ln_amt3 := ln_amt3 +
1517: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information16;
1513: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information20;
1514: else
1515: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 190);
1516: ln_amt3 := ln_amt3 +
1517: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information16;
1518: end if;
1519:
1520: -- nvl(SUI EE Taxable, SUI ER Taxable)
1521: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information18,0) <> 0 then
1517: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information16;
1518: end if;
1519:
1520: -- nvl(SUI EE Taxable, SUI ER Taxable)
1521: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information18,0) <> 0 then
1522: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 200);
1523: ln_amt7 := ln_amt7 +
1524: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information18;
1525: else
1520: -- nvl(SUI EE Taxable, SUI ER Taxable)
1521: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information18,0) <> 0 then
1522: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 200);
1523: ln_amt7 := ln_amt7 +
1524: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information18;
1525: else
1526: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 210);
1527: ln_amt7 := ln_amt7 +
1528: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information14;
1524: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information18;
1525: else
1526: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 210);
1527: ln_amt7 := ln_amt7 +
1528: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information14;
1529: end if;
1530:
1531: -- SUI EE Withheld
1532: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1529: end if;
1530:
1531: -- SUI EE Withheld
1532: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1533: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information13;
1534: -- SUI ER Liability
1535: ln_r_er_tax_amt := ln_r_er_tax_amt +
1536: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information21;
1537:
1532: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1533: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information13;
1534: -- SUI ER Liability
1535: ln_r_er_tax_amt := ln_r_er_tax_amt +
1536: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information21;
1537:
1538: elsif p_tax_type in ('SDI','SDI1','HI') then -- Added 'SDI1' bug 9164356
1539: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 220);
1540: /******************************************************
1547: In case ER is null report EE.
1548: SDI ER Liability is always passed as 0
1549: *******************************************************/
1550: --SDI EE Gross, SDI ER Gross
1551: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information27,0) <> 0 then
1552: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 230);
1553: ln_amt2 := ln_amt2 +
1554: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information27;
1555: else
1550: --SDI EE Gross, SDI ER Gross
1551: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information27,0) <> 0 then
1552: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 230);
1553: ln_amt2 := ln_amt2 +
1554: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information27;
1555: else
1556: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 240);
1557: ln_amt2 := ln_amt2 +
1558: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information26;
1554: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information27;
1555: else
1556: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 240);
1557: ln_amt2 := ln_amt2 +
1558: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information26;
1559: end if;
1560:
1561: -- nvl(SDI EE Subj Whable, SDI ER Subj Whable)
1562: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information11,0) <> 0 then
1558: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information26;
1559: end if;
1560:
1561: -- nvl(SDI EE Subj Whable, SDI ER Subj Whable)
1562: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information11,0) <> 0 then
1563: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 250);
1564: ln_amt4 := ln_amt4 +
1565: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information11;
1566: else
1561: -- nvl(SDI EE Subj Whable, SDI ER Subj Whable)
1562: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information11,0) <> 0 then
1563: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 250);
1564: ln_amt4 := ln_amt4 +
1565: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information11;
1566: else
1567: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 260);
1568: ln_amt4 := ln_amt4 +
1569: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information7;
1565: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information11;
1566: else
1567: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 260);
1568: ln_amt4 := ln_amt4 +
1569: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information7;
1570: end if;
1571:
1572: -- nvl(SDI EE Pre Tax Redns, SDI ER Pre Tax Redns)
1573: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information12,0) <> 0 then
1569: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information7;
1570: end if;
1571:
1572: -- nvl(SDI EE Pre Tax Redns, SDI ER Pre Tax Redns)
1573: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information12,0) <> 0 then
1574: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 270);
1575: ln_amt3 := ln_amt3 +
1576: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information12;
1577: else
1572: -- nvl(SDI EE Pre Tax Redns, SDI ER Pre Tax Redns)
1573: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information12,0) <> 0 then
1574: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 270);
1575: ln_amt3 := ln_amt3 +
1576: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information12;
1577: else
1578: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 280);
1579: ln_amt3 := ln_amt3 +
1580: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information8;
1576: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information12;
1577: else
1578: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 280);
1579: ln_amt3 := ln_amt3 +
1580: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information8;
1581: end if;
1582:
1583: -- nvl(SDI EE Taxable, SDI ER Taxable)
1584: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information10,0) <> 0 then
1580: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information8;
1581: end if;
1582:
1583: -- nvl(SDI EE Taxable, SDI ER Taxable)
1584: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information10,0) <> 0 then
1585: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 290);
1586: ln_amt7 := ln_amt7 +
1587: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information10;
1588: else
1583: -- nvl(SDI EE Taxable, SDI ER Taxable)
1584: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information10,0) <> 0 then
1585: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 290);
1586: ln_amt7 := ln_amt7 +
1587: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information10;
1588: else
1589: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 300);
1590: ln_amt7 := ln_amt7 +
1591: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information6;
1587: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information10;
1588: else
1589: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 300);
1590: ln_amt7 := ln_amt7 +
1591: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information6;
1592: end if;
1593:
1594: /* Commented bug # 9164356 start
1595: -- SDI EE Withheld
1593:
1594: /* Commented bug # 9164356 start
1595: -- SDI EE Withheld
1596: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1597: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5;
1598: -- SDI ER Liability
1599: ln_r_er_tax_amt := ln_r_er_tax_amt +
1600: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information9;
1601: Commented bug # 9164356 end*/
1596: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1597: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5;
1598: -- SDI ER Liability
1599: ln_r_er_tax_amt := ln_r_er_tax_amt +
1600: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information9;
1601: Commented bug # 9164356 end*/
1602:
1603: if (p_tax_type = 'SDI1') then -- Added if else condition #9164356
1604: -- SDI1 EE Withheld
1602:
1603: if (p_tax_type = 'SDI1') then -- Added if else condition #9164356
1604: -- SDI1 EE Withheld
1605: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1606: pay_us_fls_reporting_pkg.ltr_action_info(i).sdi1_ee;
1607: -- SDI1 ER Liability
1608: ln_r_er_tax_amt := ln_r_er_tax_amt +
1609: 0;
1610: else
1609: 0;
1610: else
1611: -- SDI EE Withheld
1612: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1613: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5;
1614: -- SDI ER Liability
1615: ln_r_er_tax_amt := ln_r_er_tax_amt +
1616: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information9;
1617: end if;
1612: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1613: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5;
1614: -- SDI ER Liability
1615: ln_r_er_tax_amt := ln_r_er_tax_amt +
1616: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information9;
1617: end if;
1618: elsif p_tax_type = 'WC' then
1619: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 350);
1620: null;
1620: null;
1621: /*
1622: -- WC Withheld
1623: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1624: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information22;
1625: */
1626: end if;
1627:
1628: exit;
1631: substr(p_jurisdiction,3,4) <> '-000'then
1632: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 400);
1633: -- Gross Earnings
1634: ln_amt2 := ln_amt2 +
1635: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information7;
1636:
1637: if p_tax_type = 'IT' then
1638: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 410);
1639: -- County Subj Whable
1637: if p_tax_type = 'IT' then
1638: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 410);
1639: -- County Subj Whable
1640: ln_amt4 := ln_amt4 +
1641: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information2;
1642: -- County Subj NWhable
1643: ln_amt5 := ln_amt5 +
1644: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information3;
1645: -- County Pre Tax Redns
1640: ln_amt4 := ln_amt4 +
1641: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information2;
1642: -- County Subj NWhable
1643: ln_amt5 := ln_amt5 +
1644: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information3;
1645: -- County Pre Tax Redns
1646: ln_amt3 := ln_amt3 +
1647: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4;
1648: -- County Withheld
1643: ln_amt5 := ln_amt5 +
1644: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information3;
1645: -- County Pre Tax Redns
1646: ln_amt3 := ln_amt3 +
1647: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4;
1648: -- County Withheld
1649: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R')
1650: = 'R' then
1651: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 420);
1645: -- County Pre Tax Redns
1646: ln_amt3 := ln_amt3 +
1647: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4;
1648: -- County Withheld
1649: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R')
1650: = 'R' then
1651: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 420);
1652: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1653: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information1;
1649: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R')
1650: = 'R' then
1651: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 420);
1652: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1653: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information1;
1654: ln_r_flag := 'Y';
1655: elsif nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R')
1656: = 'NR' then
1657: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 430);
1651: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 420);
1652: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1653: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information1;
1654: ln_r_flag := 'Y';
1655: elsif nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R')
1656: = 'NR' then
1657: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 430);
1658: ln_nr_ee_tax_amt := ln_nr_ee_tax_amt +
1659: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information1;
1655: elsif nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R')
1656: = 'NR' then
1657: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 430);
1658: ln_nr_ee_tax_amt := ln_nr_ee_tax_amt +
1659: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information1;
1660: ln_nr_flag := 'Y';
1661: end if;
1662:
1663: elsif p_tax_type = 'OPT' then
1663: elsif p_tax_type = 'OPT' then
1664: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 440);
1665: -- Head Tax Subj Whable
1666: ln_amt4 := ln_amt4 +
1667: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information2;
1668: -- Head Tax Subj NWhable
1669: ln_amt5 := ln_amt5 +
1670: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information3;
1671: -- Head Tax Pre Tax Redns
1666: ln_amt4 := ln_amt4 +
1667: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information2;
1668: -- Head Tax Subj NWhable
1669: ln_amt5 := ln_amt5 +
1670: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information3;
1671: -- Head Tax Pre Tax Redns
1672: ln_amt3 := ln_amt3 +
1673: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4;
1674:
1669: ln_amt5 := ln_amt5 +
1670: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information3;
1671: -- Head Tax Pre Tax Redns
1672: ln_amt3 := ln_amt3 +
1673: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4;
1674:
1675: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R')
1676: = 'R' then
1677: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 450);
1671: -- Head Tax Pre Tax Redns
1672: ln_amt3 := ln_amt3 +
1673: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4;
1674:
1675: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R')
1676: = 'R' then
1677: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 450);
1678: -- Head Tax Withheld
1679: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1676: = 'R' then
1677: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 450);
1678: -- Head Tax Withheld
1679: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1680: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information6;
1681: -- Head Tax Liability
1682: ln_r_er_tax_amt := ln_r_er_tax_amt +
1683: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5;
1684: ln_r_flag := 'Y';
1679: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1680: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information6;
1681: -- Head Tax Liability
1682: ln_r_er_tax_amt := ln_r_er_tax_amt +
1683: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5;
1684: ln_r_flag := 'Y';
1685: elsif nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R')
1686: = 'NR' then
1687: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 460);
1681: -- Head Tax Liability
1682: ln_r_er_tax_amt := ln_r_er_tax_amt +
1683: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5;
1684: ln_r_flag := 'Y';
1685: elsif nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R')
1686: = 'NR' then
1687: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 460);
1688: -- Head Tax Withheld
1689: ln_nr_ee_tax_amt := ln_nr_ee_tax_amt +
1686: = 'NR' then
1687: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 460);
1688: -- Head Tax Withheld
1689: ln_nr_ee_tax_amt := ln_nr_ee_tax_amt +
1690: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information6;
1691: -- Head Tax Liability
1692: ln_nr_er_tax_amt := ln_nr_er_tax_amt +
1693: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5;
1694: ln_nr_flag := 'Y';
1689: ln_nr_ee_tax_amt := ln_nr_ee_tax_amt +
1690: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information6;
1691: -- Head Tax Liability
1692: ln_nr_er_tax_amt := ln_nr_er_tax_amt +
1693: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5;
1694: ln_nr_flag := 'Y';
1695: end if;
1696: end if;
1697: if ln_nr_flag = 'Y' and ln_r_flag = 'Y' then
1703: substr(p_jurisdiction,3) <> '-000-0000'then
1704: -- Gross Earnings
1705: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 500);
1706: ln_amt2 := ln_amt2 +
1707: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information7;
1708:
1709: if p_tax_type = 'IT' then
1710: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 510);
1711: -- City Subj Whable
1709: if p_tax_type = 'IT' then
1710: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 510);
1711: -- City Subj Whable
1712: ln_amt4 := ln_amt4 +
1713: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information2;
1714: -- City Subj NWhable
1715: ln_amt5 := ln_amt5 +
1716: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information3;
1717: -- City Pre Tax Redns
1712: ln_amt4 := ln_amt4 +
1713: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information2;
1714: -- City Subj NWhable
1715: ln_amt5 := ln_amt5 +
1716: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information3;
1717: -- City Pre Tax Redns
1718: ln_amt3 := ln_amt3 +
1719: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4;
1720: -- City Withheld
1715: ln_amt5 := ln_amt5 +
1716: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information3;
1717: -- City Pre Tax Redns
1718: ln_amt3 := ln_amt3 +
1719: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4;
1720: -- City Withheld
1721: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R') = 'R' then
1722: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 520);
1723: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1717: -- City Pre Tax Redns
1718: ln_amt3 := ln_amt3 +
1719: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4;
1720: -- City Withheld
1721: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R') = 'R' then
1722: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 520);
1723: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1724: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information1;
1725: ln_r_flag := 'Y';
1720: -- City Withheld
1721: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R') = 'R' then
1722: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 520);
1723: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1724: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information1;
1725: ln_r_flag := 'Y';
1726: elsif nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R') = 'NR' then
1727: ln_nr_ee_tax_amt := ln_nr_ee_tax_amt +
1728: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information1;
1722: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 520);
1723: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1724: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information1;
1725: ln_r_flag := 'Y';
1726: elsif nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R') = 'NR' then
1727: ln_nr_ee_tax_amt := ln_nr_ee_tax_amt +
1728: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information1;
1729: ln_nr_flag := 'Y';
1730: end if;
1724: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information1;
1725: ln_r_flag := 'Y';
1726: elsif nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R') = 'NR' then
1727: ln_nr_ee_tax_amt := ln_nr_ee_tax_amt +
1728: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information1;
1729: ln_nr_flag := 'Y';
1730: end if;
1731:
1732: elsif p_tax_type = 'OPT' then
1732: elsif p_tax_type = 'OPT' then
1733: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 530);
1734: -- Head Tax Subj Whable
1735: ln_amt4 := ln_amt4 +
1736: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information2;
1737: -- Head Tax Subj NWhable
1738: ln_amt5 := ln_amt5 +
1739: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information3;
1740: -- Head Tax Pre Tax Redns
1735: ln_amt4 := ln_amt4 +
1736: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information2;
1737: -- Head Tax Subj NWhable
1738: ln_amt5 := ln_amt5 +
1739: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information3;
1740: -- Head Tax Pre Tax Redns
1741: ln_amt3 := ln_amt3 +
1742: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4;
1743: -- Head Tax Withheld
1738: ln_amt5 := ln_amt5 +
1739: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information3;
1740: -- Head Tax Pre Tax Redns
1741: ln_amt3 := ln_amt3 +
1742: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4;
1743: -- Head Tax Withheld
1744: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R') = 'R' then
1745: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 540);
1746: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1740: -- Head Tax Pre Tax Redns
1741: ln_amt3 := ln_amt3 +
1742: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4;
1743: -- Head Tax Withheld
1744: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R') = 'R' then
1745: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 540);
1746: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1747: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information6;
1748: -- Head Tax Liability
1743: -- Head Tax Withheld
1744: if nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R') = 'R' then
1745: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 540);
1746: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1747: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information6;
1748: -- Head Tax Liability
1749: ln_r_er_tax_amt := ln_r_er_tax_amt +
1750: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5;
1751: ln_r_flag := 'Y';
1746: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1747: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information6;
1748: -- Head Tax Liability
1749: ln_r_er_tax_amt := ln_r_er_tax_amt +
1750: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5;
1751: ln_r_flag := 'Y';
1752: elsif nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R') = 'NR' then
1753: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 550);
1754: -- Head Tax Withheld
1748: -- Head Tax Liability
1749: ln_r_er_tax_amt := ln_r_er_tax_amt +
1750: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5;
1751: ln_r_flag := 'Y';
1752: elsif nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R') = 'NR' then
1753: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 550);
1754: -- Head Tax Withheld
1755: ln_nr_ee_tax_amt := ln_nr_ee_tax_amt +
1756: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information6;
1752: elsif nvl(pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R') = 'NR' then
1753: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 550);
1754: -- Head Tax Withheld
1755: ln_nr_ee_tax_amt := ln_nr_ee_tax_amt +
1756: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information6;
1757: -- Head Tax Liability
1758: ln_nr_er_tax_amt := ln_nr_er_tax_amt +
1759: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5;
1760: ln_nr_flag := 'Y';
1755: ln_nr_ee_tax_amt := ln_nr_ee_tax_amt +
1756: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information6;
1757: -- Head Tax Liability
1758: ln_nr_er_tax_amt := ln_nr_er_tax_amt +
1759: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5;
1760: ln_nr_flag := 'Y';
1761: end if;
1762: end if;
1763: if ln_nr_flag = 'Y' and ln_r_flag = 'Y' then
1766:
1767: -- School Jurisdiction code
1768: elsif length(p_jurisdiction) = 8 then
1769: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 600);
1770: if nvl(Pay_us_fls_reporting_pkg.ltr_action_info(i).action_information30, 'R')
1771: = nvl(p_resident_jurisdiction, 'R') then
1772:
1773: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 600);
1774: hr_utility.trace('ANK Gross val = ' ||
1771: = nvl(p_resident_jurisdiction, 'R') then
1772:
1773: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 600);
1774: hr_utility.trace('ANK Gross val = ' ||
1775: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5);
1776: -- Gross Earnings
1777: ln_amt2 := ln_amt2 +
1778: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5;
1779:
1774: hr_utility.trace('ANK Gross val = ' ||
1775: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5);
1776: -- Gross Earnings
1777: ln_amt2 := ln_amt2 +
1778: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information5;
1779:
1780: if p_tax_type = 'IT' then
1781: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 610);
1782: -- School Subj Whable
1780: if p_tax_type = 'IT' then
1781: hr_utility.set_location(gv_package || '.get_fls_tax_type_values', 610);
1782: -- School Subj Whable
1783: ln_amt4 := ln_amt4 +
1784: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information2;
1785: -- School Subj NWhable
1786: ln_amt5 := ln_amt5 +
1787: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information3;
1788: -- School Pre Tax Redns
1783: ln_amt4 := ln_amt4 +
1784: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information2;
1785: -- School Subj NWhable
1786: ln_amt5 := ln_amt5 +
1787: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information3;
1788: -- School Pre Tax Redns
1789: ln_amt3 := ln_amt3 +
1790: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4;
1791: -- School Withheld
1786: ln_amt5 := ln_amt5 +
1787: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information3;
1788: -- School Pre Tax Redns
1789: ln_amt3 := ln_amt3 +
1790: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4;
1791: -- School Withheld
1792: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1793: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information1;
1794: end if;
1789: ln_amt3 := ln_amt3 +
1790: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information4;
1791: -- School Withheld
1792: ln_r_ee_tax_amt := ln_r_ee_tax_amt +
1793: pay_us_fls_reporting_pkg.ltr_action_info(i).action_information1;
1794: end if;
1795: exit;
1796: end if;
1797:
1856:
1857: --BEGIN
1858: -- hr_utility.trace_on(null, 'FLSP');
1859:
1860: END pay_us_fls_reporting_pkg;