DBA Data[Home] [Help]

APPS.PER_RU_ORG_INFO dependencies on HR_API

Line 95: IF p_org_information2 <> hr_api.g_varchar2 THEN

91: OPEN csr_org_id;
92: FETCH csr_org_id into l_org_id;
93: CLOSE csr_org_id;
94: IF p_org_info_type_code='RU_COMPANY_INFORMATION' THEN
95: IF p_org_information2 <> hr_api.g_varchar2 THEN
96: l_status := hr_ru_utility.validate_tax_no(p_org_information2);
97: IF l_status = 0 THEN
98: hr_utility.set_message (800, 'HR_RU_INVALID_ORG_INN');
99: hr_utility.raise_error;

Line 102: IF p_org_information12 <> hr_api.g_varchar2

98: hr_utility.set_message (800, 'HR_RU_INVALID_ORG_INN');
99: hr_utility.raise_error;
100: END IF;
101: END IF;
102: IF p_org_information12 <> hr_api.g_varchar2
103: THEN
104: l_status := hr_ru_utility.validate_ogrn(p_org_information12);
105: IF l_status = 0 THEN
106: hr_utility.set_message (800, 'HR_RU_INVALID_OGRN_NO');

Line 110: IF p_org_information3 <> hr_api.g_varchar2 THEN

106: hr_utility.set_message (800, 'HR_RU_INVALID_OGRN_NO');
107: hr_utility.raise_error;
108: END IF;
109: END IF;
110: IF p_org_information3 <> hr_api.g_varchar2 THEN
111: l_status := hr_ru_utility.validate_kpp(p_org_information3);
112: IF l_status = 0 THEN
113: hr_utility.set_message (800, 'HR_RU_INVALID_KPP_NO');
114: hr_utility.raise_error;

Line 117: IF p_org_information5 <> hr_api.g_varchar2 THEN

113: hr_utility.set_message (800, 'HR_RU_INVALID_KPP_NO');
114: hr_utility.raise_error;
115: END IF;
116: END IF;
117: IF p_org_information5 <> hr_api.g_varchar2 THEN
118: l_status := hr_ru_utility.validate_si(p_org_information5);
119: IF l_status = 0 THEN
120: hr_utility.set_message (800, 'HR_RU_INVALID_SI_NO');
121: hr_utility.raise_error;

Line 124: IF p_org_information8 <> hr_api.g_varchar2 THEN

120: hr_utility.set_message (800, 'HR_RU_INVALID_SI_NO');
121: hr_utility.raise_error;
122: END IF;
123: END IF;
124: IF p_org_information8 <> hr_api.g_varchar2 THEN
125: l_status := hr_ru_utility.validate_okogu(p_org_information8);
126: IF l_status = 0 THEN
127: hr_utility.set_message (800, 'HR_RU_INVALID_OKOGU_CODE');
128: hr_utility.raise_error;

Line 131: IF p_org_information7 <> hr_api.g_varchar2 THEN

127: hr_utility.set_message (800, 'HR_RU_INVALID_OKOGU_CODE');
128: hr_utility.raise_error;
129: END IF;
130: END IF;
131: IF p_org_information7 <> hr_api.g_varchar2 THEN
132: l_status := hr_ru_utility.validate_okpo(p_org_information7);
133: IF l_status = 0 THEN
134: hr_utility.set_message (800, 'HR_RU_INVALID_OKPO_CODE');
135: hr_utility.raise_error;

Line 138: IF p_org_information4 <> hr_api.g_varchar2 THEN

134: hr_utility.set_message (800, 'HR_RU_INVALID_OKPO_CODE');
135: hr_utility.raise_error;
136: END IF;
137: END IF;
138: IF p_org_information4 <> hr_api.g_varchar2 THEN
139: l_status := hr_ru_utility.validate_org_spifn(p_org_information4);
140: IF l_status = 0 THEN
141: hr_utility.set_message (800, 'HR_RU_INVALID_PENSION_NO');
142: hr_utility.raise_error;

Line 146: IF p_org_information1 <> hr_api.g_varchar2 THEN

142: hr_utility.raise_error;
143: END IF;
144: END IF;
145: ELSIF p_org_info_type_code = 'RU_COMPANY_ACTIVITY_TYPES' THEN
146: IF p_org_information1 <> hr_api.g_varchar2 THEN
147: l_status := hr_ru_utility.validate_okved(p_org_information1);
148: IF l_status = 0 THEN
149: hr_utility.set_message (800, 'HR_RU_INVALID_OKVED_CODE');
150: hr_utility.raise_error;