DBA Data[Home] [Help]

APPS.GHR_NRE_BUS dependencies on HR_API

Line 51: and nvl(p_noac_remark_id,hr_api.g_number)

47: (p_noac_remark_id => p_noac_remark_id,
48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating
51: and nvl(p_noac_remark_id,hr_api.g_number)
52: <> ghr_nre_shd.g_old_rec.noac_remark_id) then
53: --
54: -- raise error as PK has changed
55: --

Line 123: and nvl(p_remark_id,hr_api.g_number)

119: (p_noac_remark_id => p_noac_remark_id,
120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and nvl(p_remark_id,hr_api.g_number)
124: <> nvl(ghr_nre_shd.g_old_rec.remark_id,hr_api.g_number)
125: or not l_api_updating) then
126: --
127: -- check if remark_id value exists in ghr_remarks table

Line 124: <> nvl(ghr_nre_shd.g_old_rec.remark_id,hr_api.g_number)

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and nvl(p_remark_id,hr_api.g_number)
124: <> nvl(ghr_nre_shd.g_old_rec.remark_id,hr_api.g_number)
125: or not l_api_updating) then
126: --
127: -- check if remark_id value exists in ghr_remarks table
128: --

Line 198: and nvl(p_nature_of_action_id,hr_api.g_number)

194: (p_noac_remark_id => p_noac_remark_id,
195: p_object_version_number => p_object_version_number);
196: --
197: if (l_api_updating
198: and nvl(p_nature_of_action_id,hr_api.g_number)
199: <> nvl(ghr_nre_shd.g_old_rec.nature_of_action_id,hr_api.g_number)
200: or not l_api_updating) then
201: --
202: -- check if nature_of_action_id value exists in ghr_nature_of_actions table

Line 199: <> nvl(ghr_nre_shd.g_old_rec.nature_of_action_id,hr_api.g_number)

195: p_object_version_number => p_object_version_number);
196: --
197: if (l_api_updating
198: and nvl(p_nature_of_action_id,hr_api.g_number)
199: <> nvl(ghr_nre_shd.g_old_rec.nature_of_action_id,hr_api.g_number)
200: or not l_api_updating) then
201: --
202: -- check if nature_of_action_id value exists in ghr_nature_of_actions table
203: --

Line 270: <> nvl(ghr_nre_shd.g_old_rec.enabled_flag,hr_api.g_varchar2)

266: p_object_version_number => p_object_version_number);
267: --
268: if (l_api_updating
269: and p_enabled_flag
270: <> nvl(ghr_nre_shd.g_old_rec.enabled_flag,hr_api.g_varchar2)
271: or not l_api_updating) then
272: --
273: -- check if value of lookup falls within lookup type.
274: --

Line 276: if hr_api.not_exists_in_hr_lookups

272: --
273: -- check if value of lookup falls within lookup type.
274: --
275: --
276: if hr_api.not_exists_in_hr_lookups
277: (p_lookup_type => 'YES_NO',
278: p_lookup_code => p_enabled_flag,
279: p_effective_date => p_effective_date) then
280: --

Line 338: <> nvl(ghr_nre_shd.g_old_rec.required_flag,hr_api.g_varchar2)

334: p_object_version_number => p_object_version_number);
335: --
336: if (l_api_updating
337: and p_required_flag
338: <> nvl(ghr_nre_shd.g_old_rec.required_flag,hr_api.g_varchar2)
339: or not l_api_updating) then
340: --
341: -- check if value of lookup falls within lookup type.
342: --

Line 344: if hr_api.not_exists_in_hr_lookups

340: --
341: -- check if value of lookup falls within lookup type.
342: --
343: --
344: if hr_api.not_exists_in_hr_lookups
345: (p_lookup_type => 'YES_NO',
346: p_lookup_code => p_required_flag,
347: p_effective_date => p_effective_date) then
348: --

Line 409: <> nvl(ghr_nre_shd.g_old_rec.date_from,hr_api.g_date)

405: p_object_version_number => p_object_version_number);
406: --
407: if (l_api_updating
408: and p_date_from
409: <> nvl(ghr_nre_shd.g_old_rec.date_from,hr_api.g_date)
410: or not l_api_updating) then
411: --
412: -- check if value of date_from is not null
413: --

Line 414: hr_api.mandatory_arg_error

410: or not l_api_updating) then
411: --
412: -- check if value of date_from is not null
413: --
414: hr_api.mandatory_arg_error
415: (p_api_name => l_proc
416: ,p_argument => 'date_from'
417: ,p_argument_value => p_date_from
418: );

Line 492: <> nvl(ghr_nre_shd.g_old_rec.nature_of_action_id,hr_api.g_number)

488: hr_utility.set_location('Entering:'||l_proc, 10);
489: --
490: if (l_api_updating
491: and ( p_nature_of_action_id
492: <> nvl(ghr_nre_shd.g_old_rec.nature_of_action_id,hr_api.g_number)
493: or
494: p_remark_id
495: <> nvl(ghr_nre_shd.g_old_rec.remark_id,hr_api.g_number)
496: )

Line 495: <> nvl(ghr_nre_shd.g_old_rec.remark_id,hr_api.g_number)

491: and ( p_nature_of_action_id
492: <> nvl(ghr_nre_shd.g_old_rec.nature_of_action_id,hr_api.g_number)
493: or
494: p_remark_id
495: <> nvl(ghr_nre_shd.g_old_rec.remark_id,hr_api.g_number)
496: )
497: or not l_api_updating) then
498: --
499: -- check if the combination of action_id and remark_id already exits