[Home] [Help]
86: ,1
87: ,240
88: )
89: INTO l_full_name
90: FROM dual;
91:
92: RETURN l_full_name;
93: --
94: END per_ru_full_name;
153: 1,
154: 240
155: )
156: INTO l_full_name
157: FROM DUAL;
158:
159: RETURN l_full_name;
160: --
161: END per_ru_full_name_initials;
179: --
180: BEGIN
181: SELECT 'Y'
182: INTO l_status
183: FROM SYS.dual
184: WHERE EXISTS (
185: SELECT '1'
186: FROM per_all_people_f pp
187: WHERE (p_person_id IS NULL OR p_person_id <> pp.person_id)
315: hr_utility.set_warning;
316: ELSE
317: SELECT translate (p_military_reg_board_code, '0123456789', ' ')
318: INTO l_tmp
319: FROM dual;
320: IF (l_len =7 AND (l_tmp IS NULL OR hr_ni_chk_pkg.chk_nat_id_format(l_tmp,'A') = '0' )) OR (l_len=6 AND l_tmp IS NOT NULL)
321: THEN
322: hr_utility.set_message (800, 'HR_RU_INVALID_MIL_REG_CODE');
323: hr_utility.set_warning;
325: END IF;
326: END validate_mil_reg_board_code;
327:
328: --------------------------------------------------------------------------------------------
329: -- VALIDATE_TAX_NO : Function to Validate Individual Tax Number(INN)
330: --------------------------------------------------------------------------------------------
331: FUNCTION validate_tax_no (p_org_info VARCHAR2)
332: RETURN NUMBER
333: IS
449: END validate_ogrn;
450:
451: --
452: ---------------------------------------------------------------------------------------------------
453: -- CHECK_TAX_NUMBER_UNIQUE :Function to check for the Uniqueness of the Individual Tax Number(INN)
454: ---------------------------------------------------------------------------------------------------
455: FUNCTION check_tax_number_unique (p_tax_no VARCHAR2, p_org_id NUMBER, p_org_info_code VARCHAR2)
456: RETURN NUMBER
457: IS
460:
461: CURSOR c_unique_status
462: IS
463: SELECT 'Y'
464: FROM SYS.dual
465: WHERE EXISTS (
466: SELECT '1'
467: FROM hr_organization_units hou, hr_organization_information hoi
468: WHERE (p_org_id <> hoi.organization_id)
942: -- bug 8660688
943: -- criteria updated to exclude the current assignment during checking
944: SELECT 'Y'
945: INTO l_status
946: FROM SYS.dual
947: WHERE EXISTS (
948: SELECT '1'
949: FROM per_assignments_f paaf,
950: hr_soft_coding_keyflex scl
993:
994: BEGIN
995: SELECT 'Y'
996: INTO l_status
997: FROM SYS.dual
998: WHERE EXISTS (
999: SELECT '1'
1000: FROM per_all_assignments_f paaf,
1001: hr_soft_coding_keyflex scl