[Home] [Help]
252: 10-NOV-2004 meshah 115.100 added function get_ff_archive_value
253: 15-NOV-2004 djoshi 115.101 changed l_jurisdiciton_code to varchar2(11) in
254: function get_ff_archive_value
255: 07-Nov-2005 sudedas 115.102 4391218 Updated Format_Record function , updated with 2 new input params ,
256: pay_us_mmrf_w2_format_record.format_W2_RW_record
257: 17-Feb-2006 sudedas 115.103 4425800 Added Functions Get_Employee_Count and Get_Total_Wages
258: 30-May-2006 sackumar 115.104 5089997 Added Functions Get_Employee_Count_Monthwise and Get_Wages.
259: 14-Jun-2006 sackumar 115.105 5089997 Modified get_wages to get the workers comp values..
260: 17-Aug-2006 sudedas 115.106 5256745 Updated Format_Record Function with 2 Optional Input
258: 30-May-2006 sackumar 115.104 5089997 Added Functions Get_Employee_Count_Monthwise and Get_Wages.
259: 14-Jun-2006 sackumar 115.105 5089997 Modified get_wages to get the workers comp values..
260: 17-Aug-2006 sudedas 115.106 5256745 Updated Format_Record Function with 2 Optional Input
261: Parameters p_input_43 and p_input_44 and
262: Updated pay_us_mmrf_w2_format_record.format_W2_RW_record.
263: 22-Nov-2006 sudedas 115.107 5640748 Enhanced Get_Total_Wages Function.
264: 01-Dec-2006 sudedas 115.108 Changed Cursors cur_employee_count and cur_summed_balance
265: in Function Get_Total_Wages (Added Jurisdiction Check)
266: 25-Jun-2007 sjawid 115.109 5621099 Added function GET_SUI_WAGES.
1016: END IF; -- SQLWL or W2 SSN check
1017: ELSIF p_input_1 = 'NEG_CHECK' THEN
1018: l_input_2 := replace(p_input_2,' ');
1019: IF p_report_type IN ('W2','W2C') THEN
1020: l_length := pay_us_mmrf_w2_format_record.set_req_field_length(
1021: p_report_type,
1022: p_format,
1023: p_report_qualifier,
1024: p_record_name,
1241: --{
1242: IF (p_report_type = 'W2') THEN
1243: --{
1244: IF p_record_name = 'RA' THEN -- p_record_name
1245: return_value := pay_us_mmrf_w2_format_record.format_W2_RA_record(
1246: p_effective_date,
1247: p_report_type,
1248: p_format,
1249: p_report_qualifier,
1299: l_exclude_from_output_chk
1300: );
1301: ELSIF p_record_name = 'RE' THEN
1302: return_value :=
1303: pay_us_mmrf_w2_format_record.format_W2_RE_record(
1304: p_effective_date,
1305: p_report_type,
1306: p_format,
1307: p_report_qualifier,
1357: l_exclude_from_output_chk
1358: );
1359: ELSIF p_record_name = 'RW' THEN
1360: return_value :=
1361: pay_us_mmrf_w2_format_record.format_W2_RW_record(
1362: p_effective_date,
1363: p_report_type,
1364: p_format,
1365: p_report_qualifier,
1420: );
1421:
1422: ELSIF p_record_name = 'RO' THEN
1423: return_value :=
1424: pay_us_mmrf_w2_format_record.format_W2_RO_record(
1425: p_effective_date,
1426: p_report_type,
1427: p_format,
1428: p_report_qualifier,
1479: );
1480:
1481: ELSIF p_record_name = 'RS' THEN
1482: return_value :=
1483: pay_us_mmrf_w2_format_record.format_W2_RS_record(
1484: p_effective_date,
1485: p_report_type,
1486: p_format,
1487: p_report_qualifier,
1537: l_exclude_from_output_chk
1538: );
1539: ELSIF p_record_name = 'RT' THEN
1540: return_value :=
1541: pay_us_mmrf_w2_format_record.format_W2_RT_record(
1542: p_effective_date,
1543: p_report_type,
1544: p_format,
1545: p_report_qualifier,
1595: l_exclude_from_output_chk
1596: );
1597: ELSIF p_record_name = 'RU' THEN
1598: return_value :=
1599: pay_us_mmrf_w2_format_record.format_W2_RU_record(
1600: p_effective_date,
1601: p_report_type,
1602: p_format,
1603: p_report_qualifier,
1654: );
1655:
1656: -- RV Record formatting vmkulkar
1657: ELSIF p_record_name = 'RV' THEN -- p_record_name
1658: return_value := pay_us_mmrf_w2_format_record.format_W2_RV_record(
1659: p_effective_date,
1660: p_report_type,
1661: p_format,
1662: p_report_qualifier,
1712: l_exclude_from_output_chk
1713: );
1714: ELSIF p_record_name = 'RF' THEN
1715: return_value :=
1716: pay_us_mmrf_w2_format_record.format_W2_RF_record(
1717: p_effective_date,
1718: p_report_type,
1719: p_format,
1720: p_report_qualifier,