DBA Data[Home] [Help]

APPS.GHR_REI_FLEX_DDF dependencies on GHR_REI_SHD

Line 14: (p_rec in ghr_rei_shd.g_rec_type) is

10: -- ----------------------------------------------------------------------------
11: -- |-------------------------------< ddf >-------------------------------------|
12: -- ----------------------------------------------------------------------------
13: procedure ddf
14: (p_rec in ghr_rei_shd.g_rec_type) is
15: --
16: l_proc varchar2(72) := g_package||'ddf';
17: l_error exception;
18: --

Line 177: l_api_updating := ghr_rei_shd.api_updating

173: -- a) The current g_old_rec is current and
174: -- b) The reason_for_submission value has changed
175: -- c) A record is being inserted
176: --
177: l_api_updating := ghr_rei_shd.api_updating
178: (p_pa_request_extra_info_id => p_pa_request_extra_info_id
179: ,p_object_version_number => p_object_version_number
180: );
181: if ((l_api_updating and

Line 182: nvl(ghr_rei_shd.g_old_rec.rei_information3,hr_api.g_varchar2)

178: (p_pa_request_extra_info_id => p_pa_request_extra_info_id
179: ,p_object_version_number => p_object_version_number
180: );
181: if ((l_api_updating and
182: nvl(ghr_rei_shd.g_old_rec.rei_information3,hr_api.g_varchar2)
183: <> nvl(p_reason_for_submission, hr_api.g_varchar2)) or
184: (not l_api_updating))
185: then
186: hr_utility.set_location(l_proc, 20);

Line 229: l_api_updating := ghr_rei_shd.api_updating

225: hr_utility.set_location('Entering: '|| l_proc, 10);
226: --
227: -- Only proceed with validation if a record is being inserted
228: --
229: l_api_updating := ghr_rei_shd.api_updating
230: (p_pa_request_extra_info_id => p_pa_request_extra_info_id
231: ,p_object_version_number => p_object_version_number
232: );
233: if (not l_api_updating)

Line 274: l_api_updating := ghr_rei_shd.api_updating

270: -- a) The current g_old_rec is current and
271: -- b) The service value has changed
272: -- c) A record is being inserted
273: --
274: l_api_updating := ghr_rei_shd.api_updating
275: (p_pa_request_extra_info_id => p_pa_request_extra_info_id
276: ,p_object_version_number => p_object_version_number
277: );
278: --

Line 280: nvl(ghr_rei_shd.g_old_rec.rei_information5,hr_api.g_varchar2)

276: ,p_object_version_number => p_object_version_number
277: );
278: --
279: if ((l_api_updating and
280: nvl(ghr_rei_shd.g_old_rec.rei_information5,hr_api.g_varchar2)
281: <> nvl(p_service, hr_api.g_varchar2)) or
282: (not l_api_updating))
283: then
284: hr_utility.set_location(l_proc, 20);