[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.
1030: END IF; -- SQLWL or W2 SSN check
1031: ELSIF p_input_1 = 'NEG_CHECK' THEN
1032: l_input_2 := replace(p_input_2,' ');
1033: IF p_report_type IN ('W2','W2C') THEN
1034: l_length := pay_us_mmrf_w2_format_record.set_req_field_length(
1035: p_report_type,
1036: p_format,
1037: p_report_qualifier,
1038: p_record_name,
1256: --{
1257: IF (p_report_type = 'W2') THEN
1258: --{
1259: IF p_record_name = 'RA' THEN -- p_record_name
1260: return_value := pay_us_mmrf_w2_format_record.format_W2_RA_record(
1261: p_effective_date,
1262: p_report_type,
1263: p_format,
1264: p_report_qualifier,
1314: l_exclude_from_output_chk
1315: );
1316: ELSIF p_record_name = 'RE' THEN
1317: return_value :=
1318: pay_us_mmrf_w2_format_record.format_W2_RE_record(
1319: p_effective_date,
1320: p_report_type,
1321: p_format,
1322: p_report_qualifier,
1372: l_exclude_from_output_chk
1373: );
1374: ELSIF p_record_name = 'RW' THEN
1375: return_value :=
1376: pay_us_mmrf_w2_format_record.format_W2_RW_record(
1377: p_effective_date,
1378: p_report_type,
1379: p_format,
1380: p_report_qualifier,
1436: );
1437:
1438: ELSIF p_record_name = 'RO' THEN
1439: return_value :=
1440: pay_us_mmrf_w2_format_record.format_W2_RO_record(
1441: p_effective_date,
1442: p_report_type,
1443: p_format,
1444: p_report_qualifier,
1495: );
1496:
1497: ELSIF p_record_name = 'RS' THEN
1498: return_value :=
1499: pay_us_mmrf_w2_format_record.format_W2_RS_record(
1500: p_effective_date,
1501: p_report_type,
1502: p_format,
1503: p_report_qualifier,
1553: l_exclude_from_output_chk
1554: );
1555: ELSIF p_record_name = 'RT' THEN
1556: return_value :=
1557: pay_us_mmrf_w2_format_record.format_W2_RT_record(
1558: p_effective_date,
1559: p_report_type,
1560: p_format,
1561: p_report_qualifier,
1612: p_input_41 /* Bug 13351713 */
1613: );
1614: ELSIF p_record_name = 'RU' THEN
1615: return_value :=
1616: pay_us_mmrf_w2_format_record.format_W2_RU_record(
1617: p_effective_date,
1618: p_report_type,
1619: p_format,
1620: p_report_qualifier,
1671: );
1672:
1673: -- RV Record formatting vmkulkar
1674: ELSIF p_record_name = 'RV' THEN -- p_record_name
1675: return_value := pay_us_mmrf_w2_format_record.format_W2_RV_record(
1676: p_effective_date,
1677: p_report_type,
1678: p_format,
1679: p_report_qualifier,
1729: l_exclude_from_output_chk
1730: );
1731: ELSIF p_record_name = 'RF' THEN
1732: return_value :=
1733: pay_us_mmrf_w2_format_record.format_W2_RF_record(
1734: p_effective_date,
1735: p_report_type,
1736: p_format,
1737: p_report_qualifier,