13: --
14: IF hr_utility.chk_product_install('Oracle Human Resources', 'HU') THEN
15: --
16: IF p_org_info_type_code='HU_COMPANY_INFORMATION_DETAILS' THEN
17: hr_hu_utility.validate_ss_no(p_org_information3);
18: hr_hu_utility.validate_tax_no(p_org_information4);
19: hr_hu_utility.validate_cs_no(p_org_information4,p_org_information5);
20: END IF;
21: --
14: IF hr_utility.chk_product_install('Oracle Human Resources', 'HU') THEN
15: --
16: IF p_org_info_type_code='HU_COMPANY_INFORMATION_DETAILS' THEN
17: hr_hu_utility.validate_ss_no(p_org_information3);
18: hr_hu_utility.validate_tax_no(p_org_information4);
19: hr_hu_utility.validate_cs_no(p_org_information4,p_org_information5);
20: END IF;
21: --
22: END IF;
15: --
16: IF p_org_info_type_code='HU_COMPANY_INFORMATION_DETAILS' THEN
17: hr_hu_utility.validate_ss_no(p_org_information3);
18: hr_hu_utility.validate_tax_no(p_org_information4);
19: hr_hu_utility.validate_cs_no(p_org_information4,p_org_information5);
20: END IF;
21: --
22: END IF;
23:
52: --
53: IF p_org_info_type_code = 'HU_COMPANY_INFORMATION_DETAILS' THEN
54:
55: IF p_org_information3 <> hr_api.g_varchar2 THEN
56: hr_hu_utility.validate_ss_no(p_org_information3);
57: END IF;
58:
59: IF p_org_information4 <> hr_api.g_varchar2 and p_org_information5 = hr_api.g_varchar2 THEN
60: hr_hu_utility.validate_tax_no(p_org_information4);
56: hr_hu_utility.validate_ss_no(p_org_information3);
57: END IF;
58:
59: IF p_org_information4 <> hr_api.g_varchar2 and p_org_information5 = hr_api.g_varchar2 THEN
60: hr_hu_utility.validate_tax_no(p_org_information4);
61: OPEN get_information5(p_org_information_id);
62: FETCH get_information5 INTO l_information5;
63: CLOSE get_information5;
64: hr_hu_utility.validate_cs_no(p_org_information4,l_information5);
60: hr_hu_utility.validate_tax_no(p_org_information4);
61: OPEN get_information5(p_org_information_id);
62: FETCH get_information5 INTO l_information5;
63: CLOSE get_information5;
64: hr_hu_utility.validate_cs_no(p_org_information4,l_information5);
65:
66: END IF;
67:
68: IF p_org_information5 <> hr_api.g_varchar2 and p_org_information4 = hr_api.g_varchar2 THEN
68: IF p_org_information5 <> hr_api.g_varchar2 and p_org_information4 = hr_api.g_varchar2 THEN
69: OPEN get_information4(p_org_information_id);
70: FETCH get_information4 INTO l_information4;
71: CLOSE get_information4;
72: hr_hu_utility.validate_cs_no(l_information4,p_org_information5);
73: END IF;
74:
75: IF p_org_information5 <> hr_api.g_varchar2 and p_org_information4 <> hr_api.g_varchar2 THEN
76: hr_hu_utility.validate_tax_no(p_org_information4);
72: hr_hu_utility.validate_cs_no(l_information4,p_org_information5);
73: END IF;
74:
75: IF p_org_information5 <> hr_api.g_varchar2 and p_org_information4 <> hr_api.g_varchar2 THEN
76: hr_hu_utility.validate_tax_no(p_org_information4);
77: hr_hu_utility.validate_cs_no(p_org_information4,p_org_information5);
78: END IF;
79: END IF;
80: --
73: END IF;
74:
75: IF p_org_information5 <> hr_api.g_varchar2 and p_org_information4 <> hr_api.g_varchar2 THEN
76: hr_hu_utility.validate_tax_no(p_org_information4);
77: hr_hu_utility.validate_cs_no(p_org_information4,p_org_information5);
78: END IF;
79: END IF;
80: --
81: END IF;