APPS.PAY_US_W2C_IN_MMREF2_FORMAT dependencies on PAY_US_REPORTING_UTILS_PKG

Line 820: pay_us_reporting_utils_pkg.data_validation(

816:
817: hr_utility.set_location( gv_package || '.format_w2c_total_record',40);
818:
819: pay_us_w2c_in_mmref2_format.ltr_rct_info(i).rct_wage_old_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 852: pay_us_reporting_utils_pkg.data_validation(

848: lv_wage_value_in_cents :=
849: to_char(nvl(pay_us_w2c_in_mmref2_format.ltr_rct_info(i).rct_wage_new,0));
850:
851: pay_us_w2c_in_mmref2_format.ltr_rct_info(i).rct_wage_new_formated :=
852: pay_us_reporting_utils_pkg.data_validation(
853: p_effective_date,
854: p_report_type,
855: p_format,
856: p_report_qualifier,

Line 1123: pay_us_reporting_utils_pkg.data_validation(

1119: /* Negative Value check For Originally Reported Value on RCT */
1120: lv_wage_value_in_cents :=
1121: to_char(nvl(pay_us_w2c_in_mmref2_format.ltr_rcu_info(i).rcu_wage_old,0));
1122: pay_us_w2c_in_mmref2_format.ltr_rcu_info(i).rcu_wage_old_formated :=
1123: pay_us_reporting_utils_pkg.data_validation(
1124: p_effective_date,
1125: p_report_type,
1126: p_format,
1127: p_report_qualifier,

Line 1151: pay_us_reporting_utils_pkg.data_validation(

1147: hr_utility.set_location( gv_package || '.format_w2c_total_record',160);
1148: lv_wage_value_in_cents :=
1149: to_char(nvl(pay_us_w2c_in_mmref2_format.ltr_rcu_info(i).rcu_wage_new,0));
1150: pay_us_w2c_in_mmref2_format.ltr_rcu_info(i).rcu_wage_new_formated :=
1151: pay_us_reporting_utils_pkg.data_validation(
1152: p_effective_date,
1153: p_report_type,
1154: p_format,
1155: p_report_qualifier,

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

2121: --
2122:
2123: -- Compare Orignally Reported and Corrected
2124: lv_old_ssn := replace(replace(replace(replace(
2125: replace(pay_us_reporting_utils_pkg.character_check(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).SSN),
2126: ' '),'I'),'-'),'.'),'''');
2127: lv_new_ssn := replace(replace(replace(replace(
2128: replace(pay_us_reporting_utils_pkg.character_check(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).SSN),
2129: ' '),'I'),'-'),'.'),'''');

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

2124: lv_old_ssn := replace(replace(replace(replace(
2125: replace(pay_us_reporting_utils_pkg.character_check(pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).SSN),
2126: ' '),'I'),'-'),'.'),'''');
2127: lv_new_ssn := replace(replace(replace(replace(
2128: replace(pay_us_reporting_utils_pkg.character_check(pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).SSN),
2129: ' '),'I'),'-'),'.'),'''');
2130: if NVL(lv_old_ssn,'ZZ') <> NVL(lv_new_ssn,'ZZ')
2131: then
2132: ln_num_corrections := ln_num_corrections + 1;