APPS.PQP_GB_PSI_ADDDRESS dependencies on HR_NUMBER

Line 1423: OR hr_number.canonical_to_number(l_mailstop) NOT BETWEEN 0 AND 99999 THEN

1419: ,p_token1 => l_mailstop
1420: );
1421:
1422: ELSIF length(l_mailstop) > 5
1423: OR hr_number.canonical_to_number(l_mailstop) NOT BETWEEN 0 AND 99999 THEN
1424: -- raise error
1425: debug('ERROR: Invalid Length.',40);
1426: l_error := PQP_GB_PSI_FUNCTIONS.raise_extract_warning
1427: (p_error_number => 94985

Line 1434: l_mailstop := ltrim(rtrim(to_char(hr_number.canonical_to_number(l_mailstop),'09999')));

1430: );
1431: l_mailstop := substr(l_mailstop,-5);
1432: ELSE
1433: debug('Apply format mask 09999 on correct mailstop',40);
1434: l_mailstop := ltrim(rtrim(to_char(hr_number.canonical_to_number(l_mailstop),'09999')));
1435: END IF; --IF NOT pqp_gb_psi_functions.is_numeric(l_mailstop)
1436:
1437: p_address_mailstop := l_mailstop;
1438: debug_exit(l_proc);