DBA Data[Home] [Help]

APPS.GHR_NRE_BUS dependencies on HR_API

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

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

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

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

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

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

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

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

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

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

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

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

Line 278: if hr_api.not_exists_in_hr_lookups

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

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

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

Line 347: if hr_api.not_exists_in_hr_lookups

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

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

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

Line 418: hr_api.mandatory_arg_error

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

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

493: hr_utility.set_location('Entering:'||l_proc, 10);
494: --
495: if (l_api_updating
496: and ( p_nature_of_action_id
497: <> nvl(ghr_nre_shd.g_old_rec.nature_of_action_id,hr_api.g_number)
498: or
499: p_remark_id
500: <> nvl(ghr_nre_shd.g_old_rec.remark_id,hr_api.g_number)
501: )

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

496: and ( p_nature_of_action_id
497: <> nvl(ghr_nre_shd.g_old_rec.nature_of_action_id,hr_api.g_number)
498: or
499: p_remark_id
500: <> nvl(ghr_nre_shd.g_old_rec.remark_id,hr_api.g_number)
501: )
502: or not l_api_updating) then
503: --
504: -- check if the combination of action_id and remark_id already exits