APPS.PAY_US_REPORT_DATA_VALIDATION dependencies on PAY_US_REPORTING_UTILS_PKG

Line 19: Referenced By: Package pay_us_reporting_utils_pkg

15: to support the generation of magnetic tape W2 / SQWL reports
16: for US legilsative requirements.
17:
18: Notes
19: Referenced By: Package pay_us_reporting_utils_pkg
20:
21: Notes
22:
23: History

Line 158: replace(pay_us_reporting_utils_pkg.character_check(p_input_2),

154: IF ((p_report_qualifier = 'MN_SQWL') OR
155: (p_report_qualifier = 'GA_SQWL')) THEN
156: -- Character hypen, period and quotes are eliminated
157: l_ssn := replace(replace(replace(
158: replace(pay_us_reporting_utils_pkg.character_check(p_input_2),
159: ' '),'-'),'.'),'''');
160: ELSE
161: -- Character I is eliminated in addition to hypen, period and quotes
162: l_ssn := replace(replace(replace(replace(

Line 163: replace(pay_us_reporting_utils_pkg.character_check(p_input_2),

159: ' '),'-'),'.'),'''');
160: ELSE
161: -- Character I is eliminated in addition to hypen, period and quotes
162: l_ssn := replace(replace(replace(replace(
163: replace(pay_us_reporting_utils_pkg.character_check(p_input_2),
164: ' '),'I'),'-'),'.'),'''');
165: END IF;
166:
167: hr_utility.trace('SSN after eliminating special chars = '||l_ssn);

Line 295: replace(pay_us_reporting_utils_pkg.character_check(p_input_2),

291: hr_utility.trace('Input SSN before Validation '||p_input_2);
292:
293: -- Character I is eliminated in addition to hypen, period and quotes
294: l_ssn := replace(replace(replace(replace(
295: replace(pay_us_reporting_utils_pkg.character_check(p_input_2),
296: ' '),'I'),'-'),'.'),'''');
297: hr_utility.trace('SSN after eliminating special chars = '||l_ssn);
298: l_1st_three_chars := substr(l_ssn,1,3);
299: l_last_four_chars := substr(l_ssn,(length(l_ssn)-3));