APPS.PAY_US_MMRF2_W2C_FORMAT_RECORD dependencies on PAY_US_REPORTING_UTILS_PKG

Line 265: pay_us_reporting_utils_pkg.data_validation(p_effective_date,

261: IF p_input_40 = 'FLAT' THEN
262: -- EIN Validation and format
263: hr_utility.set_location(gv_package || '.format_W2C_RCA_record', 20);
264: l_emp_ein :=
265: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
266: p_report_type,
267: p_format,
268: p_report_qualifier,
269: p_record_name,

Line 539: pay_us_reporting_utils_pkg.data_validation(p_effective_date,

535: --{
536: hr_utility.set_location(gv_package || '.format_W2C_RCE_record', 30);
537: hr_utility.trace('before data_validation of EIN is '||p_input_3);
538: l_emp_ein :=
539: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
540: p_report_type,
541: p_format,
542: p_report_qualifier,
543: p_record_name,

Line 991: l_first_name_old := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(

987: BEGIN
988: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 10);
989: --{
990:
991: l_first_name_old := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(
992: substr(p_first_name_old,1,15),' '),15));
993: l_middle_name_old := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(
994: substr(p_middle_name_old,1,15),' '),15));
995: l_last_name_old := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(

Line 993: l_middle_name_old := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(

989: --{
990:
991: l_first_name_old := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(
992: substr(p_first_name_old,1,15),' '),15));
993: l_middle_name_old := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(
994: substr(p_middle_name_old,1,15),' '),15));
995: l_last_name_old := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(
996: substr(p_last_name_old,1,20),' '),20));
997: l_full_name_old := substr(pay_us_reporting_utils_pkg.Character_check(ltrim(rtrim(p_first_name_old)||' '||

Line 995: l_last_name_old := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(

991: l_first_name_old := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(
992: substr(p_first_name_old,1,15),' '),15));
993: l_middle_name_old := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(
994: substr(p_middle_name_old,1,15),' '),15));
995: l_last_name_old := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(
996: substr(p_last_name_old,1,20),' '),20));
997: l_full_name_old := substr(pay_us_reporting_utils_pkg.Character_check(ltrim(rtrim(p_first_name_old)||' '||
998: rtrim(p_last_name_old))),1,50);
999:

Line 997: l_full_name_old := substr(pay_us_reporting_utils_pkg.Character_check(ltrim(rtrim(p_first_name_old)||' '||

993: l_middle_name_old := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(
994: substr(p_middle_name_old,1,15),' '),15));
995: l_last_name_old := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(
996: substr(p_last_name_old,1,20),' '),20));
997: l_full_name_old := substr(pay_us_reporting_utils_pkg.Character_check(ltrim(rtrim(p_first_name_old)||' '||
998: rtrim(p_last_name_old))),1,50);
999:
1000: l_first_name_new := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(
1001: substr(p_first_name_new,1,15),' '),15));

Line 1000: l_first_name_new := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(

996: substr(p_last_name_old,1,20),' '),20));
997: l_full_name_old := substr(pay_us_reporting_utils_pkg.Character_check(ltrim(rtrim(p_first_name_old)||' '||
998: rtrim(p_last_name_old))),1,50);
999:
1000: l_first_name_new := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(
1001: substr(p_first_name_new,1,15),' '),15));
1002: l_middle_name_new := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(
1003: substr(p_middle_name_new,1,15),' '),15));
1004: l_last_name_new := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(

Line 1002: l_middle_name_new := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(

998: rtrim(p_last_name_old))),1,50);
999:
1000: l_first_name_new := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(
1001: substr(p_first_name_new,1,15),' '),15));
1002: l_middle_name_new := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(
1003: substr(p_middle_name_new,1,15),' '),15));
1004: l_last_name_new := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(
1005: substr(p_last_name_new,1,20),' '),20));
1006: l_full_name_new := substr(pay_us_reporting_utils_pkg.Character_check(ltrim(rtrim(p_first_name_new)||' '||

Line 1004: l_last_name_new := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(

1000: l_first_name_new := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(
1001: substr(p_first_name_new,1,15),' '),15));
1002: l_middle_name_new := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(
1003: substr(p_middle_name_new,1,15),' '),15));
1004: l_last_name_new := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(
1005: substr(p_last_name_new,1,20),' '),20));
1006: l_full_name_new := substr(pay_us_reporting_utils_pkg.Character_check(ltrim(rtrim(p_first_name_new)||' '||
1007: rtrim(p_last_name_new))),1,50);
1008:

Line 1006: l_full_name_new := substr(pay_us_reporting_utils_pkg.Character_check(ltrim(rtrim(p_first_name_new)||' '||

1002: l_middle_name_new := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(
1003: substr(p_middle_name_new,1,15),' '),15));
1004: l_last_name_new := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(
1005: substr(p_last_name_new,1,20),' '),20));
1006: l_full_name_new := substr(pay_us_reporting_utils_pkg.Character_check(ltrim(rtrim(p_first_name_new)||' '||
1007: rtrim(p_last_name_new))),1,50);
1008:
1009: l_emp_number := replace(p_employee_number,' ');
1010:

Line 1026: pay_us_reporting_utils_pkg.data_validation( p_effective_date,

1022: -- Originally reported SSN validation and formatting
1023: l_ssn_old := lpad(' ',9);
1024: IF rtrim(p_ssn_old) IS not NULL then
1025: l_ssn_old :=
1026: pay_us_reporting_utils_pkg.data_validation( p_effective_date,
1027: p_report_type,
1028: p_format,
1029: p_report_qualifier,
1030: p_record_name,

Line 1048: pay_us_reporting_utils_pkg.data_validation( p_effective_date,

1044: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 30);
1045: -- Corrected SSN validation and formatting
1046: l_ssn_new := lpad(' ',9);
1047: l_ssn_new :=
1048: pay_us_reporting_utils_pkg.data_validation( p_effective_date,
1049: p_report_type,
1050: p_format,
1051: p_report_qualifier,
1052: p_record_name,

Line 1108: pay_us_reporting_utils_pkg.data_validation(

1104: --{
1105: if rcw_wage_rec(i).wage_old_value <> 0 then
1106: --{
1107: rcw_wage_rec(i).wage_old_value_formated :=
1108: pay_us_reporting_utils_pkg.data_validation(
1109: p_effective_date,
1110: p_report_type,
1111: p_format,
1112: p_report_qualifier,

Line 1141: pay_us_reporting_utils_pkg.data_validation(

1137: --
1138: if rcw_wage_rec(i).wage_new_value <> 0 then
1139: --{
1140: rcw_wage_rec(i).wage_new_value_formated :=
1141: pay_us_reporting_utils_pkg.data_validation(
1142: p_effective_date,
1143: p_report_type,
1144: p_format,
1145: p_report_qualifier,

Line 1668: l_full_name_new := substr(pay_us_reporting_utils_pkg.Character_check(ltrim(rtrim(p_first_name_new)||' '||

1664: BEGIN
1665: hr_utility.set_location(gv_package || '.format_W2C_RCO_record', 10);
1666: --{
1667:
1668: l_full_name_new := substr(pay_us_reporting_utils_pkg.Character_check(ltrim(rtrim(p_first_name_new)||' '||
1669: rtrim(p_last_name_new))),1,50);
1670:
1671: l_emp_number := replace(p_employee_number,' ');
1672:

Line 1706: pay_us_reporting_utils_pkg.data_validation(

1702: --{
1703: if rco_wage_rec(i).wage_old_value <> 0 then
1704: --{
1705: rco_wage_rec(i).wage_old_value_formated :=
1706: pay_us_reporting_utils_pkg.data_validation(
1707: p_effective_date,
1708: p_report_type,
1709: p_format,
1710: p_report_qualifier,

Line 1739: pay_us_reporting_utils_pkg.data_validation(

1735: --
1736: if rco_wage_rec(i).wage_new_value <> 0 then
1737: --{
1738: rco_wage_rec(i).wage_new_value_formated :=
1739: pay_us_reporting_utils_pkg.data_validation(
1740: p_effective_date,
1741: p_report_type,
1742: p_format,
1743: p_report_qualifier,