DBA Data[Home] [Help]

APPS.PER_HU_ORG_INFO dependencies on HR_API

Line 55: IF p_org_information3 <> hr_api.g_varchar2 THEN

51: IF hr_utility.chk_product_install('Oracle Human Resources', 'HU') THEN
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

Line 59: IF p_org_information4 <> hr_api.g_varchar2 and p_org_information5 = hr_api.g_varchar2 THEN

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);
61: OPEN get_information5(p_org_information_id);
62: FETCH get_information5 INTO l_information5;
63: CLOSE get_information5;

Line 68: IF p_org_information5 <> hr_api.g_varchar2 and p_org_information4 = hr_api.g_varchar2 THEN

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
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);

Line 75: IF p_org_information5 <> hr_api.g_varchar2 and p_org_information4 <> hr_api.g_varchar2 THEN

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);
77: hr_hu_utility.validate_cs_no(p_org_information4,p_org_information5);
78: END IF;
79: END IF;