APPS.PAY_US_W2C_IN_MMREF2_FORMAT dependencies on PAY_US_REPORTING_UTILS_PKG

Line 788: pay_us_reporting_utils_pkg.data_validation(

784:
785: hr_utility.set_location( gv_package || '.format_w2c_total_record',40);
786:
787: pay_us_w2c_in_mmref2_format.ltr_rct_info(i).rct_wage_old_formated :=
788: pay_us_reporting_utils_pkg.data_validation(
789: p_effective_date,
790: p_report_type,
791: p_format,
792: p_report_qualifier,

Line 820: pay_us_reporting_utils_pkg.data_validation(

816: lv_wage_value_in_cents :=
817: to_char(nvl(pay_us_w2c_in_mmref2_format.ltr_rct_info(i).rct_wage_new,0));
818:
819: pay_us_w2c_in_mmref2_format.ltr_rct_info(i).rct_wage_new_formated :=
820: pay_us_reporting_utils_pkg.data_validation(
821: p_effective_date,
822: p_report_type,
823: p_format,
824: p_report_qualifier,

Line 1083: pay_us_reporting_utils_pkg.data_validation(

1079: /* Negative Value check For Originally Reported Value on RCT */
1080: lv_wage_value_in_cents :=
1081: to_char(nvl(pay_us_w2c_in_mmref2_format.ltr_rcu_info(i).rcu_wage_old,0));
1082: pay_us_w2c_in_mmref2_format.ltr_rcu_info(i).rcu_wage_old_formated :=
1083: pay_us_reporting_utils_pkg.data_validation(
1084: p_effective_date,
1085: p_report_type,
1086: p_format,
1087: p_report_qualifier,

Line 1111: pay_us_reporting_utils_pkg.data_validation(

1107: hr_utility.set_location( gv_package || '.format_w2c_total_record',160);
1108: lv_wage_value_in_cents :=
1109: to_char(nvl(pay_us_w2c_in_mmref2_format.ltr_rcu_info(i).rcu_wage_new,0));
1110: pay_us_w2c_in_mmref2_format.ltr_rcu_info(i).rcu_wage_new_formated :=
1111: pay_us_reporting_utils_pkg.data_validation(
1112: p_effective_date,
1113: p_report_type,
1114: p_format,
1115: p_report_qualifier,

Line 1928: replace(pay_us_reporting_utils_pkg.character_check(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).SSN),

1924: --
1925:
1926: -- Compare Orignally Reported and Corrected
1927: lv_old_ssn := replace(replace(replace(replace(
1928: replace(pay_us_reporting_utils_pkg.character_check(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).SSN),
1929: ' '),'I'),'-'),'.'),'''');
1930: lv_new_ssn := replace(replace(replace(replace(
1931: replace(pay_us_reporting_utils_pkg.character_check(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).SSN),
1932: ' '),'I'),'-'),'.'),'''');

Line 1931: replace(pay_us_reporting_utils_pkg.character_check(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).SSN),

1927: lv_old_ssn := replace(replace(replace(replace(
1928: replace(pay_us_reporting_utils_pkg.character_check(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).SSN),
1929: ' '),'I'),'-'),'.'),'''');
1930: lv_new_ssn := replace(replace(replace(replace(
1931: replace(pay_us_reporting_utils_pkg.character_check(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).SSN),
1932: ' '),'I'),'-'),'.'),'''');
1933: if NVL(lv_old_ssn,'ZZ') <> NVL(lv_new_ssn,'ZZ')
1934: then
1935: ln_num_corrections := ln_num_corrections + 1;