APPS.PAY_US_CUSTOM_SQWL_FORMAT_REC dependencies on PAY_US_REPORTING_UTILS_PKG

Line 18: Referenced By: Package pay_us_reporting_utils_pkg

14: The purpose of this package is to format reacord to support the
15: generation of SQWL magnetic tape for US legilsative requirements.
16:
17: Notes
18: Referenced By: Package pay_us_reporting_utils_pkg
19:
20: History
21:
22: 24-FEB-2004 jgoswami 115.0 3334497 Created

Line 214: /* r_input_2 := rpad(substr(replace( pay_us_reporting_utils_pkg.character_check(nvl(r_input_2,'0')),'-'),1,8),8,0);

210: l_transaction_code := 'H';
211:
212: /* Pos: 2 Len: 10 Desc: State Employer Account Number */
213: /* Ask Legislative Analyst to check for Special Characters */
214: /* r_input_2 := rpad(substr(replace( pay_us_reporting_utils_pkg.character_check(nvl(r_input_2,'0')),'-'),1,8),8,0);
215: */
216:
217: l_emp_account_num := upper(lpad(substr(replace(r_input_2,'-'), 1, 8), 8, '0'));
218:

Line 573: /* r_input_2 := rpad(substr(replace( pay_us_reporting_utils_pkg.character_check(nvl(r_input_2,'0')),'-'),1,8),8,0);

569: /* Bug 4554387 l_transaction_code := 'D'; */
570:
571: /* Pos: 2 Len: 10 Desc: State Employer Account Number */
572: /* Ask Legislative Analyst to check for Special Characters */
573: /* r_input_2 := rpad(substr(replace( pay_us_reporting_utils_pkg.character_check(nvl(r_input_2,'0')),'-'),1,8),8,0);
574: r_input_2 := lpad(replace(replace(nvl(replace(r_input_2,' '),' ') ,'-'),'/'),8,0);
575: */
576:
577: l_emp_account_num := upper(lpad(substr(replace(r_input_2,'-'), 1, 8), 8, '0'));

Line 594: l_ssn := pay_us_reporting_utils_pkg.data_validation(

590: /* Pos:15 Len: 9 Desc: Social security number */
591:
592: IF p_input_40 = 'FLAT' THEN
593:
594: l_ssn := pay_us_reporting_utils_pkg.data_validation(
595: p_effective_date,
596: p_report_type,
597: p_format,
598: p_report_qualifier,

Line 624: l_last_name := pay_us_reporting_utils_pkg.Character_check(

620: Pos:49 - 63 First name
621: Pos:64 - 64 Middle name
622: */
623:
624: l_last_name := pay_us_reporting_utils_pkg.Character_check(
625: nvl(substr(r_input_6,1,25),''));
626: l_first_name := pay_us_reporting_utils_pkg.Character_check(
627: nvl(substr(r_input_7,1,15),''));
628: l_middle_name := ltrim(pay_us_reporting_utils_pkg.Character_check(

Line 626: l_first_name := pay_us_reporting_utils_pkg.Character_check(

622: */
623:
624: l_last_name := pay_us_reporting_utils_pkg.Character_check(
625: nvl(substr(r_input_6,1,25),''));
626: l_first_name := pay_us_reporting_utils_pkg.Character_check(
627: nvl(substr(r_input_7,1,15),''));
628: l_middle_name := ltrim(pay_us_reporting_utils_pkg.Character_check(
629: nvl(substr(r_input_8,1,1),'')));
630:

Line 628: l_middle_name := ltrim(pay_us_reporting_utils_pkg.Character_check(

624: l_last_name := pay_us_reporting_utils_pkg.Character_check(
625: nvl(substr(r_input_6,1,25),''));
626: l_first_name := pay_us_reporting_utils_pkg.Character_check(
627: nvl(substr(r_input_7,1,15),''));
628: l_middle_name := ltrim(pay_us_reporting_utils_pkg.Character_check(
629: nvl(substr(r_input_8,1,1),'')));
630:
631: /* Pos:65-75 SUI Insurance Wages. */
632: IF p_input_40 = 'FLAT' THEN

Line 634: r_input_9 := pay_us_reporting_utils_pkg.data_validation(p_effective_date,

630:
631: /* Pos:65-75 SUI Insurance Wages. */
632: IF p_input_40 = 'FLAT' THEN
633:
634: r_input_9 := pay_us_reporting_utils_pkg.data_validation(p_effective_date,
635: p_report_type,
636: p_format,
637: p_report_qualifier,
638: p_record_name,