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:
21: 05-09-2008 pannapur 115.24 7335939 Modified 139th position for AL_SQWL to display 'AL'

Line 48: -- from DAT_VALIDATION function in package pay_us_reporting_utils_pkg

44: */
45:
46: -- This function determines the required length for fields
47: -- in various data record. This function is being referenced
48: -- from DAT_VALIDATION function in package pay_us_reporting_utils_pkg
49: --
50: FUNCTION set_req_field_length (p_report_type IN varchar2,
51: p_format IN varchar2,
52: p_report_qualifier IN varchar2,

Line 349: pay_us_reporting_utils_pkg.data_validation(p_effective_date,

345: -- Validation Starts
346: -- EIN Validation
347: IF p_input_40 = 'FLAT' THEN
348: l_emp_ein :=
349: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
350: p_report_type,
351: p_format,
352: p_report_qualifier,
353: p_record_name,

Line 950: pay_us_reporting_utils_pkg.data_validation(p_effective_date,

946: -- not for any of the audit report
947: --
948: hr_utility.trace('before data_validation of ein');
949: l_emp_ein :=
950: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
951: p_report_type,
952: p_format,
953: p_report_qualifier,
954: p_record_name,

Line 971: pay_us_reporting_utils_pkg.data_validation(p_effective_date,

967:
968: IF l_agent_indicator = '1' THEN
969: --{
970: l_agent_ein :=
971: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
972: p_report_type,
973: p_format,
974: p_report_qualifier,
975: p_record_name,

Line 998: pay_us_reporting_utils_pkg.data_validation(p_effective_date,

994: IF l_input_8 IS NOT NULL THEN --Checking Other EIN for validation
995: --{
996: hr_utility.trace('before data_validation of other EIN');
997: l_other_ein:=
998: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
999: p_report_type,
1000: p_format,
1001: p_report_qualifier,
1002: p_record_name,

Line 1147: pay_us_reporting_utils_pkg.character_check(nvl(r_input_25,

1143: r_input_23 := rpad(nvl(r_input_23,' '),6);
1144: r_input_24 := lpad(' ',2);
1145: /*Bug: 2324869 */
1146: r_input_25 := rpad(substr(replace(
1147: pay_us_reporting_utils_pkg.character_check(nvl(r_input_25,
1148: ' ')),'-'),1,6),12,0);
1149: /*Pos:250 - 253 Not supported. Zero Fill. */
1150: r_input_26 := '0';
1151: r_input_27 := '0';

Line 1631: l_ssn := pay_us_reporting_utils_pkg.data_validation(

1627:
1628: /* Pos:10 - 18 Social security number */
1629:
1630: IF p_input_40 = 'FLAT' THEN
1631: l_ssn := pay_us_reporting_utils_pkg.data_validation(
1632: p_effective_date,
1633: p_report_type,
1634: p_format,
1635: p_report_qualifier,

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

1661: Pos:54 - 68 Middle name
1662: Pos:69 - 72 suffix Blank */
1663:
1664: /* Last name. p_input_7 */
1665: l_first_name := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(substr(r_input_7,1,20),' '),20));
1666:
1667: /* Middle Name p_input_5 */
1668: l_middle_name := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(substr(r_input_5,1,15),' '),15));
1669:

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

1664: /* Last name. p_input_7 */
1665: l_first_name := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(substr(r_input_7,1,20),' '),20));
1666:
1667: /* Middle Name p_input_5 */
1668: l_middle_name := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(substr(r_input_5,1,15),' '),15));
1669:
1670: /* First Name. p_input_6 */
1671: l_last_name := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(substr(r_input_6,1,15),' '),15));
1672: l_suffix := lpad(' ',4);

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

1667: /* Middle Name p_input_5 */
1668: l_middle_name := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(substr(r_input_5,1,15),' '),15));
1669:
1670: /* First Name. p_input_6 */
1671: l_last_name := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(substr(r_input_6,1,15),' '),15));
1672: l_suffix := lpad(' ',4);
1673: --}
1674: ELSE
1675: /* Pos:19 - 33 First name

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

1676: Pos:34 - 48 Middle name
1677: Pos:49 - 68 Last name
1678: Pos:69 - 72 suffix */
1679:
1680: l_first_name := pay_us_reporting_utils_pkg.Character_check(rpad(
1681: nvl(substr(r_input_5,1,15),' '),15));
1682: l_middle_name := pay_us_reporting_utils_pkg.Character_check(rpad(
1683: nvl(substr(r_input_6,1,15),' '),15));
1684: l_last_name := pay_us_reporting_utils_pkg.Character_check(rpad(

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

1678: Pos:69 - 72 suffix */
1679:
1680: l_first_name := pay_us_reporting_utils_pkg.Character_check(rpad(
1681: nvl(substr(r_input_5,1,15),' '),15));
1682: l_middle_name := pay_us_reporting_utils_pkg.Character_check(rpad(
1683: nvl(substr(r_input_6,1,15),' '),15));
1684: l_last_name := pay_us_reporting_utils_pkg.Character_check(rpad(
1685: nvl(substr(r_input_7,1,20),' '),20));
1686: l_suffix := pay_us_reporting_utils_pkg.Character_check(rpad(

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

1680: l_first_name := pay_us_reporting_utils_pkg.Character_check(rpad(
1681: nvl(substr(r_input_5,1,15),' '),15));
1682: l_middle_name := pay_us_reporting_utils_pkg.Character_check(rpad(
1683: nvl(substr(r_input_6,1,15),' '),15));
1684: l_last_name := pay_us_reporting_utils_pkg.Character_check(rpad(
1685: nvl(substr(r_input_7,1,20),' '),20));
1686: l_suffix := pay_us_reporting_utils_pkg.Character_check(rpad(
1687: nvl(substr(r_input_8,1,4),' '),4));
1688: END IF;

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

1682: l_middle_name := pay_us_reporting_utils_pkg.Character_check(rpad(
1683: nvl(substr(r_input_6,1,15),' '),15));
1684: l_last_name := pay_us_reporting_utils_pkg.Character_check(rpad(
1685: nvl(substr(r_input_7,1,20),' '),20));
1686: l_suffix := pay_us_reporting_utils_pkg.Character_check(rpad(
1687: nvl(substr(r_input_8,1,4),' '),4));
1688: END IF;
1689: hr_utility.trace('l_suffix = '||l_suffix);
1690:

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

1727: IF ((p_report_qualifier = 'SC_SQWL') OR
1728: (p_report_qualifier = 'NY_SQWL') OR
1729: (p_report_qualifier = 'NV_SQWL') OR
1730: (p_report_qualifier = 'FL_SQWL')) THEN
1731: l_suffix := pay_us_reporting_utils_pkg.Character_check(rpad(
1732: nvl(substr(r_input_8,1,4),' '),4));
1733: END IF;
1734:
1735: /* Pos: 73 - 149 Blank for Alabama SQWL Ref Bug# 4552131*/

Line 1828: pay_us_reporting_utils_pkg.data_validation(p_effective_date,

1824:
1825: /* Pos:203-213 SUI Insurance Wages. */
1826: IF p_input_40 = 'FLAT' THEN
1827: r_input_20 :=
1828: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
1829: p_report_type,
1830: p_format,
1831: p_report_qualifier,
1832: p_record_name,

Line 1855: pay_us_reporting_utils_pkg.data_validation( p_effective_date,

1851: (p_report_qualifier = 'KS_SQWL') OR /* Bug 6036926 */
1852: (p_report_qualifier = 'TX_SQWL')) THEN /* #5919391 */
1853: --{
1854: r_input_21 :=
1855: pay_us_reporting_utils_pkg.data_validation( p_effective_date,
1856: p_report_type,
1857: p_format,
1858: p_report_qualifier,
1859: p_record_name,

Line 2115: pay_us_reporting_utils_pkg.data_validation(p_effective_date,

2111: substr(p_input_19,1,2) = '12' )) THEN
2112: --{
2113: IF p_input_40 = 'FLAT' THEN
2114: r_input_27:=
2115: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
2116: p_report_type,
2117: p_format,
2118: p_report_qualifier,
2119: p_record_name,

Line 2133: pay_us_reporting_utils_pkg.data_validation( p_effective_date,

2129: IF p_exclude_from_output = 'Y' THEN
2130: l_exclude_from_output_chk := TRUE;
2131: END IF;
2132: r_input_28 :=
2133: pay_us_reporting_utils_pkg.data_validation( p_effective_date,
2134: p_report_type,
2135: p_format,
2136: p_report_qualifier,
2137: p_record_name,

Line 2174: pay_us_reporting_utils_pkg.data_validation(p_effective_date,

2170: IF (p_report_qualifier = 'LA_SQWL') THEN
2171: IF p_input_40 = 'FLAT' THEN
2172: hr_utility.trace(' Other state data AL,MD,OH ');
2173: r_input_29 :=
2174: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
2175: p_report_type,
2176: p_format,
2177: p_report_qualifier,
2178: p_record_name,

Line 2301: pay_us_reporting_utils_pkg.data_validation(p_effective_date,

2297:
2298: IF p_report_qualifier = 'WA_SQWL' THEN
2299: hr_utility.trace('WA_SQWL');
2300: r_input_4 :=
2301: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
2302: p_report_type,
2303: p_format,
2304: p_report_qualifier,
2305: p_record_name,

Line 2333: pay_us_reporting_utils_pkg.data_validation(p_effective_date,

2329: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
2330: -- Validation Starts
2331: -- EIN Validation
2332: r_input_5 :=
2333: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
2334: p_report_type,
2335: p_format,
2336: p_report_qualifier,
2337: p_record_name,

Line 2755: pay_us_reporting_utils_pkg.data_validation( p_effective_date,

2751: --
2752: FOR i in 1..l_records
2753: LOOP
2754: parameter_record(i).p_output_value :=
2755: pay_us_reporting_utils_pkg.data_validation( p_effective_date,
2756: p_report_type,
2757: p_format,
2758: p_report_qualifier,
2759: p_record_name,

Line 3013: pay_us_reporting_utils_pkg.data_validation(p_effective_date,

3009: -- not for any of the audit report
3010: --
3011: hr_utility.trace('before data_validation of ein');
3012: l_emp_ein :=
3013: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
3014: p_report_type,
3015: p_format,
3016: p_report_qualifier,
3017: p_record_name,

Line 3035: pay_us_reporting_utils_pkg.data_validation(p_effective_date,

3031: IF l_other_ein is not null then
3032: --{
3033: hr_utility.trace('before data_validation of Other EIN');
3034: l_other_ein :=
3035: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
3036: p_report_type,
3037: p_format,
3038: p_report_qualifier,
3039: p_record_name,

Line 3079: pay_us_reporting_utils_pkg.data_validation( p_effective_date,

3075:
3076: hr_utility.trace('value of(i)|| = '|| to_char(i));
3077:
3078: parameter_record(i).p_output_value :=
3079: pay_us_reporting_utils_pkg.data_validation( p_effective_date,
3080: p_report_type,
3081: p_format,
3082: p_report_qualifier,
3083: p_record_name,