eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_US_MMRF_SQWL_FORMAT_RECORD dependencies on PAY_US_REPORTING_UTILS_PKG

Line 17: Referenced By: Package pay_us_reporting_utils_pkg

13: The purpose of this package is to format reacord to support the
14: generation of SQWL magnetic tape for US legilsative requirements.
15:
16: Notes
17: Referenced By: Package pay_us_reporting_utils_pkg
18:
19: History
20: 25-Feb-2013 nvelaga 115.50 16100022 Modified the format_SQWL_RE_record to dispaly X for LA_SQWL
21: Location Address, when it is blank.

Line 90: -- from DAT_VALIDATION function in package pay_us_reporting_utils_pkg

86: */
87:
88: -- This function determines the required length for fields
89: -- in various data record. This function is being referenced
90: -- from DAT_VALIDATION function in package pay_us_reporting_utils_pkg
91: --
92: FUNCTION set_req_field_length (p_report_type IN varchar2,
93: p_format IN varchar2,
94: p_report_qualifier IN varchar2,

Line 391: pay_us_reporting_utils_pkg.data_validation(p_effective_date,

387: -- Validation Starts
388: -- EIN Validation
389: IF p_input_40 = 'FLAT' THEN
390: l_emp_ein :=
391: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
392: p_report_type,
393: p_format,
394: p_report_qualifier,
395: p_record_name,

Line 999: pay_us_reporting_utils_pkg.data_validation(p_effective_date,

995: -- not for any of the audit report
996: --
997: hr_utility.trace('before data_validation of ein');
998: l_emp_ein :=
999: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
1000: p_report_type,
1001: p_format,
1002: p_report_qualifier,
1003: p_record_name,

Line 1020: pay_us_reporting_utils_pkg.data_validation(p_effective_date,

1016:
1017: IF l_agent_indicator = '1' THEN
1018: --{
1019: l_agent_ein :=
1020: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
1021: p_report_type,
1022: p_format,
1023: p_report_qualifier,
1024: p_record_name,

Line 1047: pay_us_reporting_utils_pkg.data_validation(p_effective_date,

1043: IF l_input_8 IS NOT NULL THEN --Checking Other EIN for validation
1044: --{
1045: hr_utility.trace('before data_validation of other EIN');
1046: l_other_ein:=
1047: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
1048: p_report_type,
1049: p_format,
1050: p_report_qualifier,
1051: p_record_name,

Line 1208: pay_us_reporting_utils_pkg.character_check(nvl(r_input_25,

1204: r_input_24 := lpad(' ',2);
1205: /*Bug: 2324869 */
1206: /* Commented for Bug# 13998882 */
1207: /* r_input_25 := rpad(substr(replace(
1208: pay_us_reporting_utils_pkg.character_check(nvl(r_input_25,
1209: ' ')),'-'),1,6),12,0); */
1210:
1211: /* Added for Bug# 13998882 */
1212: r_input_25 := rpad(substr(replace(

Line 1213: pay_us_reporting_utils_pkg.character_check(nvl(r_input_25,

1209: ' ')),'-'),1,6),12,0); */
1210:
1211: /* Added for Bug# 13998882 */
1212: r_input_25 := rpad(substr(replace(
1213: pay_us_reporting_utils_pkg.character_check(nvl(r_input_25,
1214: ' ')),'-'),1,7),12, ' ');
1215:
1216: /*Pos:250 - 253 Not supported. Zero Fill. */
1217: r_input_26 := '0';

Line 1752: l_ssn := pay_us_reporting_utils_pkg.data_validation(

1748:
1749: /* Pos:10 - 18 Social security number */
1750:
1751: IF p_input_40 = 'FLAT' THEN
1752: l_ssn := pay_us_reporting_utils_pkg.data_validation(
1753: p_effective_date,
1754: p_report_type,
1755: p_format,
1756: p_report_qualifier,

Line 1786: l_first_name := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(substr(r_input_7,1,20),' '),20));

1782: Pos:54 - 68 Middle name
1783: Pos:69 - 72 suffix Blank */
1784:
1785: /* Last name. p_input_7 */
1786: l_first_name := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(substr(r_input_7,1,20),' '),20));
1787:
1788: /* Middle Name p_input_5 */
1789: l_middle_name := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(substr(r_input_5,1,15),' '),15));
1790:

Line 1789: l_middle_name := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(substr(r_input_5,1,15),' '),15));

1785: /* Last name. p_input_7 */
1786: l_first_name := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(substr(r_input_7,1,20),' '),20));
1787:
1788: /* Middle Name p_input_5 */
1789: l_middle_name := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(substr(r_input_5,1,15),' '),15));
1790:
1791: /* First Name. p_input_6 */
1792: l_last_name := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(substr(r_input_6,1,15),' '),15));
1793: l_suffix := lpad(' ',4);

Line 1792: l_last_name := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(substr(r_input_6,1,15),' '),15));

1788: /* Middle Name p_input_5 */
1789: l_middle_name := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(substr(r_input_5,1,15),' '),15));
1790:
1791: /* First Name. p_input_6 */
1792: l_last_name := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(substr(r_input_6,1,15),' '),15));
1793: l_suffix := lpad(' ',4);
1794: --}
1795: ELSE
1796: /* Pos:19 - 33 First name

Line 1801: l_first_name := pay_us_reporting_utils_pkg.Character_check(rpad(

1797: Pos:34 - 48 Middle name
1798: Pos:49 - 68 Last name
1799: Pos:69 - 72 suffix */
1800:
1801: l_first_name := pay_us_reporting_utils_pkg.Character_check(rpad(
1802: nvl(substr(r_input_5,1,15),' '),15));
1803: l_middle_name := pay_us_reporting_utils_pkg.Character_check(rpad(
1804: nvl(substr(r_input_6,1,15),' '),15));
1805: l_last_name := pay_us_reporting_utils_pkg.Character_check(rpad(

Line 1803: l_middle_name := pay_us_reporting_utils_pkg.Character_check(rpad(

1799: Pos:69 - 72 suffix */
1800:
1801: l_first_name := pay_us_reporting_utils_pkg.Character_check(rpad(
1802: nvl(substr(r_input_5,1,15),' '),15));
1803: l_middle_name := pay_us_reporting_utils_pkg.Character_check(rpad(
1804: nvl(substr(r_input_6,1,15),' '),15));
1805: l_last_name := pay_us_reporting_utils_pkg.Character_check(rpad(
1806: nvl(substr(r_input_7,1,20),' '),20));
1807: l_suffix := pay_us_reporting_utils_pkg.Character_check(rpad(

Line 1805: l_last_name := pay_us_reporting_utils_pkg.Character_check(rpad(

1801: l_first_name := pay_us_reporting_utils_pkg.Character_check(rpad(
1802: nvl(substr(r_input_5,1,15),' '),15));
1803: l_middle_name := pay_us_reporting_utils_pkg.Character_check(rpad(
1804: nvl(substr(r_input_6,1,15),' '),15));
1805: l_last_name := pay_us_reporting_utils_pkg.Character_check(rpad(
1806: nvl(substr(r_input_7,1,20),' '),20));
1807: l_suffix := pay_us_reporting_utils_pkg.Character_check(rpad(
1808: nvl(substr(r_input_8,1,4),' '),4));
1809: END IF;

Line 1807: l_suffix := pay_us_reporting_utils_pkg.Character_check(rpad(

1803: l_middle_name := pay_us_reporting_utils_pkg.Character_check(rpad(
1804: nvl(substr(r_input_6,1,15),' '),15));
1805: l_last_name := pay_us_reporting_utils_pkg.Character_check(rpad(
1806: nvl(substr(r_input_7,1,20),' '),20));
1807: l_suffix := pay_us_reporting_utils_pkg.Character_check(rpad(
1808: nvl(substr(r_input_8,1,4),' '),4));
1809: END IF;
1810: hr_utility.trace('l_suffix = '||l_suffix);
1811:

Line 1854: l_suffix := pay_us_reporting_utils_pkg.Character_check(rpad(

1850: IF ((p_report_qualifier = 'SC_SQWL') OR
1851: (p_report_qualifier = 'NY_SQWL') OR
1852: (p_report_qualifier = 'NV_SQWL') OR
1853: (p_report_qualifier = 'FL_SQWL')) THEN
1854: l_suffix := pay_us_reporting_utils_pkg.Character_check(rpad(
1855: nvl(substr(r_input_8,1,4),' '),4));
1856: END IF;
1857:
1858: /* Pos: 73 - 149 Blank for Alabama SQWL Ref Bug# 4552131*/

Line 1965: pay_us_reporting_utils_pkg.data_validation(p_effective_date,

1961:
1962: /* Pos:203-213 SUI Insurance Wages. */
1963: IF p_input_40 = 'FLAT' THEN
1964: r_input_20 :=
1965: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
1966: p_report_type,
1967: p_format,
1968: p_report_qualifier,
1969: p_record_name,

Line 1993: pay_us_reporting_utils_pkg.data_validation( p_effective_date,

1989: (p_report_qualifier = 'UT_SQWL') OR /* Bug 9913439 */
1990: (p_report_qualifier = 'TX_SQWL')) THEN /* #5919391 */
1991: --{
1992: r_input_21 :=
1993: pay_us_reporting_utils_pkg.data_validation( p_effective_date,
1994: p_report_type,
1995: p_format,
1996: p_report_qualifier,
1997: p_record_name,

Line 2011: pay_us_reporting_utils_pkg.data_validation( p_effective_date,

2007: /*Added for Bug#9959504*/
2008: IF p_report_qualifier = 'FL_SQWL' THEN
2009:
2010: r_input_37 :=
2011: pay_us_reporting_utils_pkg.data_validation( p_effective_date,
2012: p_report_type,
2013: p_format,
2014: p_report_qualifier,
2015: p_record_name,

Line 2036: pay_us_reporting_utils_pkg.data_validation( p_effective_date,

2032:
2033: /* Bug#14099390 */
2034: IF p_report_qualifier = 'FL_SQWL' THEN
2035: r_input_38 :=
2036: pay_us_reporting_utils_pkg.data_validation( p_effective_date,
2037: p_report_type,
2038: p_format,
2039: p_report_qualifier,
2040: p_record_name,

Line 2351: pay_us_reporting_utils_pkg.data_validation(p_effective_date,

2347: (p_report_qualifier = 'NM_SQWL')) THEN /* Bug#14356614 */
2348: --{
2349: IF p_input_40 = 'FLAT' THEN
2350: r_input_27:=
2351: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
2352: p_report_type,
2353: p_format,
2354: p_report_qualifier,
2355: p_record_name,

Line 2369: pay_us_reporting_utils_pkg.data_validation( p_effective_date,

2365: IF p_exclude_from_output = 'Y' THEN
2366: l_exclude_from_output_chk := TRUE;
2367: END IF;
2368: r_input_28 :=
2369: pay_us_reporting_utils_pkg.data_validation( p_effective_date,
2370: p_report_type,
2371: p_format,
2372: p_report_qualifier,
2373: p_record_name,

Line 2430: pay_us_reporting_utils_pkg.data_validation(p_effective_date,

2426: IF (p_report_qualifier = 'LA_SQWL') THEN
2427: IF p_input_40 = 'FLAT' THEN
2428: hr_utility.trace(' Other state data AL,MD,OH ');
2429: r_input_29 :=
2430: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
2431: p_report_type,
2432: p_format,
2433: p_report_qualifier,
2434: p_record_name,

Line 2500: pay_us_reporting_utils_pkg.data_validation(p_effective_date,

2496: r_input_31 := lpad(' ',11);
2497: r_input_32 := p_input_32;
2498: IF p_input_40 = 'FLAT' THEN
2499: r_input_32:=
2500: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
2501: p_report_type,
2502: p_format,
2503: p_report_qualifier,
2504: p_record_name,

Line 2610: pay_us_reporting_utils_pkg.data_validation(p_effective_date,

2606:
2607: IF p_report_qualifier = 'WA_SQWL' THEN
2608: hr_utility.trace('WA_SQWL');
2609: r_input_4 :=
2610: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
2611: p_report_type,
2612: p_format,
2613: p_report_qualifier,
2614: p_record_name,

Line 2642: pay_us_reporting_utils_pkg.data_validation(p_effective_date,

2638: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
2639: -- Validation Starts
2640: -- EIN Validation
2641: r_input_5 :=
2642: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
2643: p_report_type,
2644: p_format,
2645: p_report_qualifier,
2646: p_record_name,

Line 3241: pay_us_reporting_utils_pkg.data_validation( p_effective_date,

3237: --
3238: FOR i in 1..l_records
3239: LOOP
3240: parameter_record(i).p_output_value :=
3241: pay_us_reporting_utils_pkg.data_validation( p_effective_date,
3242: p_report_type,
3243: p_format,
3244: p_report_qualifier,
3245: p_record_name,

Line 3515: pay_us_reporting_utils_pkg.data_validation(p_effective_date,

3511: -- not for any of the audit report
3512: --
3513: hr_utility.trace('before data_validation of ein');
3514: l_emp_ein :=
3515: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
3516: p_report_type,
3517: p_format,
3518: p_report_qualifier,
3519: p_record_name,

Line 3537: pay_us_reporting_utils_pkg.data_validation(p_effective_date,

3533: IF l_other_ein is not null then
3534: --{
3535: hr_utility.trace('before data_validation of Other EIN');
3536: l_other_ein :=
3537: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
3538: p_report_type,
3539: p_format,
3540: p_report_qualifier,
3541: p_record_name,

Line 3581: pay_us_reporting_utils_pkg.data_validation( p_effective_date,

3577:
3578: hr_utility.trace('value of(i)|| = '|| to_char(i));
3579:
3580: parameter_record(i).p_output_value :=
3581: pay_us_reporting_utils_pkg.data_validation( p_effective_date,
3582: p_report_type,
3583: p_format,
3584: p_report_qualifier,
3585: p_record_name,