APPS.PAY_US_MMRF2_W2C_FORMAT_RECORD dependencies on PAY_US_REPORTING_UTILS_PKG

Line 272: pay_us_reporting_utils_pkg.data_validation(p_effective_date,

268: IF p_input_40 = 'FLAT' THEN
269: -- EIN Validation and format
270: hr_utility.set_location(gv_package || '.format_W2C_RCA_record', 20);
271: l_emp_ein :=
272: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
273: p_report_type,
274: p_format,
275: p_report_qualifier,
276: p_record_name,

Line 549: pay_us_reporting_utils_pkg.data_validation(p_effective_date,

545: --{
546: hr_utility.set_location(gv_package || '.format_W2C_RCE_record', 30);
547: hr_utility.trace('before data_validation of EIN is '||p_input_3);
548: l_emp_ein :=
549: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
550: p_report_type,
551: p_format,
552: p_report_qualifier,
553: p_record_name,

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

1007: BEGIN
1008: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 10);
1009: --{
1010:
1011: l_first_name_old := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(
1012: substr(p_first_name_old,1,15),' '),15));
1013: l_middle_name_old := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(
1014: substr(p_middle_name_old,1,15),' '),15));
1015: l_last_name_old := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(

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

1009: --{
1010:
1011: l_first_name_old := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(
1012: substr(p_first_name_old,1,15),' '),15));
1013: l_middle_name_old := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(
1014: substr(p_middle_name_old,1,15),' '),15));
1015: l_last_name_old := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(
1016: substr(p_last_name_old,1,20),' '),20));
1017: l_full_name_old := substr(pay_us_reporting_utils_pkg.Character_check(ltrim(rtrim(p_first_name_old)||' '||

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

1011: l_first_name_old := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(
1012: substr(p_first_name_old,1,15),' '),15));
1013: l_middle_name_old := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(
1014: substr(p_middle_name_old,1,15),' '),15));
1015: l_last_name_old := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(
1016: substr(p_last_name_old,1,20),' '),20));
1017: l_full_name_old := substr(pay_us_reporting_utils_pkg.Character_check(ltrim(rtrim(p_first_name_old)||' '||
1018: rtrim(p_last_name_old))),1,50);
1019:

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

1013: l_middle_name_old := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(
1014: substr(p_middle_name_old,1,15),' '),15));
1015: l_last_name_old := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(
1016: substr(p_last_name_old,1,20),' '),20));
1017: l_full_name_old := substr(pay_us_reporting_utils_pkg.Character_check(ltrim(rtrim(p_first_name_old)||' '||
1018: rtrim(p_last_name_old))),1,50);
1019:
1020: l_first_name_new := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(
1021: substr(p_first_name_new,1,15),' '),15));

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

1016: substr(p_last_name_old,1,20),' '),20));
1017: l_full_name_old := substr(pay_us_reporting_utils_pkg.Character_check(ltrim(rtrim(p_first_name_old)||' '||
1018: rtrim(p_last_name_old))),1,50);
1019:
1020: l_first_name_new := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(
1021: substr(p_first_name_new,1,15),' '),15));
1022: l_middle_name_new := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(
1023: substr(p_middle_name_new,1,15),' '),15));
1024: l_last_name_new := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(

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

1018: rtrim(p_last_name_old))),1,50);
1019:
1020: l_first_name_new := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(
1021: substr(p_first_name_new,1,15),' '),15));
1022: l_middle_name_new := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(
1023: substr(p_middle_name_new,1,15),' '),15));
1024: l_last_name_new := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(
1025: substr(p_last_name_new,1,20),' '),20));
1026: l_full_name_new := substr(pay_us_reporting_utils_pkg.Character_check(ltrim(rtrim(p_first_name_new)||' '||

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

1020: l_first_name_new := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(
1021: substr(p_first_name_new,1,15),' '),15));
1022: l_middle_name_new := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(
1023: substr(p_middle_name_new,1,15),' '),15));
1024: l_last_name_new := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(
1025: substr(p_last_name_new,1,20),' '),20));
1026: l_full_name_new := substr(pay_us_reporting_utils_pkg.Character_check(ltrim(rtrim(p_first_name_new)||' '||
1027: rtrim(p_last_name_new))),1,50);
1028:

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

1022: l_middle_name_new := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(
1023: substr(p_middle_name_new,1,15),' '),15));
1024: l_last_name_new := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(
1025: substr(p_last_name_new,1,20),' '),20));
1026: l_full_name_new := substr(pay_us_reporting_utils_pkg.Character_check(ltrim(rtrim(p_first_name_new)||' '||
1027: rtrim(p_last_name_new))),1,50);
1028:
1029: l_emp_number := replace(p_employee_number,' ');
1030:

Line 1046: pay_us_reporting_utils_pkg.data_validation( p_effective_date,

1042: -- Originally reported SSN validation and formatting
1043: l_ssn_old := lpad(' ',9);
1044: IF rtrim(p_ssn_old) IS not NULL then
1045: l_ssn_old :=
1046: pay_us_reporting_utils_pkg.data_validation( p_effective_date,
1047: p_report_type,
1048: p_format,
1049: p_report_qualifier,
1050: p_record_name,

Line 1068: pay_us_reporting_utils_pkg.data_validation( p_effective_date,

1064: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 30);
1065: -- Corrected SSN validation and formatting
1066: l_ssn_new := lpad(' ',9);
1067: l_ssn_new :=
1068: pay_us_reporting_utils_pkg.data_validation( p_effective_date,
1069: p_report_type,
1070: p_format,
1071: p_report_qualifier,
1072: p_record_name,

Line 1129: pay_us_reporting_utils_pkg.data_validation(

1125: --{
1126: if rcw_wage_rec(i).wage_old_value <> 0 then
1127: --{
1128: rcw_wage_rec(i).wage_old_value_formated :=
1129: pay_us_reporting_utils_pkg.data_validation(
1130: p_effective_date,
1131: p_report_type,
1132: p_format,
1133: p_report_qualifier,

Line 1162: pay_us_reporting_utils_pkg.data_validation(

1158: --
1159: if rcw_wage_rec(i).wage_new_value <> 0 then
1160: --{
1161: rcw_wage_rec(i).wage_new_value_formated :=
1162: pay_us_reporting_utils_pkg.data_validation(
1163: p_effective_date,
1164: p_report_type,
1165: p_format,
1166: p_report_qualifier,

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

1703: BEGIN
1704: hr_utility.set_location(gv_package || '.format_W2C_RCO_record', 10);
1705: --{
1706:
1707: l_full_name_new := substr(pay_us_reporting_utils_pkg.Character_check(ltrim(rtrim(p_first_name_new)||' '||
1708: rtrim(p_last_name_new))),1,50);
1709:
1710: l_emp_number := replace(p_employee_number,' ');
1711:

Line 1747: pay_us_reporting_utils_pkg.data_validation(

1743: --{
1744: if rco_wage_rec(i).wage_old_value <> 0 then
1745: --{
1746: rco_wage_rec(i).wage_old_value_formated :=
1747: pay_us_reporting_utils_pkg.data_validation(
1748: p_effective_date,
1749: p_report_type,
1750: p_format,
1751: p_report_qualifier,

Line 1780: pay_us_reporting_utils_pkg.data_validation(

1776: --
1777: if rco_wage_rec(i).wage_new_value <> 0 then
1778: --{
1779: rco_wage_rec(i).wage_new_value_formated :=
1780: pay_us_reporting_utils_pkg.data_validation(
1781: p_effective_date,
1782: p_report_type,
1783: p_format,
1784: p_report_qualifier,