eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_NLA_BUS dependencies on HR_API

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

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

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

119: (p_noac_la_id => p_noac_la_id,
120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and nvl(p_nature_of_action_id,hr_api.g_number)
124: <> nvl(ghr_nla_shd.g_old_rec.nature_of_action_id,hr_api.g_number)
125: or not l_api_updating) then
126: --
127: -- check if nature_of_action_id value exists in ghr_nature_of_actions table

Line 124: <> nvl(ghr_nla_shd.g_old_rec.nature_of_action_id,hr_api.g_number)

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

Line 195: <> nvl(ghr_nla_shd.g_old_rec.enabled_flag,hr_api.g_varchar2)

191: p_object_version_number => p_object_version_number);
192: --
193: if (l_api_updating
194: and p_enabled_flag
195: <> nvl(ghr_nla_shd.g_old_rec.enabled_flag,hr_api.g_varchar2)
196: or not l_api_updating) then
197: --
198: -- check if value of lookup falls within lookup type.
199: --

Line 201: if hr_api.not_exists_in_hr_lookups

197: --
198: -- check if value of lookup falls within lookup type.
199: --
200: --
201: if hr_api.not_exists_in_hr_lookups
202: (p_lookup_type => 'YES_NO',
203: p_lookup_code => p_enabled_flag,
204: p_effective_date => p_effective_date) then
205: --

Line 263: <> nvl(ghr_nla_shd.g_old_rec.valid_second_lac_flag,hr_api.g_varchar2)

259: p_object_version_number => p_object_version_number);
260: --
261: if (l_api_updating
262: and p_valid_second_lac_flag
263: <> nvl(ghr_nla_shd.g_old_rec.valid_second_lac_flag,hr_api.g_varchar2)
264: or not l_api_updating) then
265: --
266: -- check if value of lookup falls within lookup type.
267: --

Line 269: if hr_api.not_exists_in_hr_lookups

265: --
266: -- check if value of lookup falls within lookup type.
267: --
268: --
269: if hr_api.not_exists_in_hr_lookups
270: (p_lookup_type => 'YES_NO',
271: p_lookup_code => p_valid_second_lac_flag,
272: p_effective_date => p_effective_date) then
273: --

Line 331: <> nvl(ghr_nla_shd.g_old_rec.valid_first_lac_flag,hr_api.g_varchar2)

327: p_object_version_number => p_object_version_number);
328: --
329: if (l_api_updating
330: and p_valid_first_lac_flag
331: <> nvl(ghr_nla_shd.g_old_rec.valid_first_lac_flag,hr_api.g_varchar2)
332: or not l_api_updating) then
333: --
334: -- check if value of lookup falls within lookup type.
335: --

Line 337: if hr_api.not_exists_in_hr_lookups

333: --
334: -- check if value of lookup falls within lookup type.
335: --
336: --
337: if hr_api.not_exists_in_hr_lookups
338: (p_lookup_type => 'YES_NO',
339: p_lookup_code => p_valid_first_lac_flag,
340: p_effective_date => p_effective_date) then
341: --

Line 402: <> nvl(ghr_nla_shd.g_old_rec.date_from,hr_api.g_date)

398: p_object_version_number => p_object_version_number);
399: --
400: if (l_api_updating
401: and p_date_from
402: <> nvl(ghr_nla_shd.g_old_rec.date_from,hr_api.g_date)
403: or not l_api_updating) then
404: --
405: -- check if value of date_from is not null
406: --

Line 407: hr_api.mandatory_arg_error

403: or not l_api_updating) then
404: --
405: -- check if value of date_from is not null
406: --
407: hr_api.mandatory_arg_error
408: (p_api_name => l_proc
409: ,p_argument => 'date_from'
410: ,p_argument_value => p_date_from
411: );

Line 484: <> nvl(ghr_nla_shd.g_old_rec.nature_of_action_id,hr_api.g_number)

480: hr_utility.set_location('Entering:'||l_proc, 10);
481: --
482: if (l_api_updating
483: and ( p_nature_of_action_id
484: <> nvl(ghr_nla_shd.g_old_rec.nature_of_action_id,hr_api.g_number)
485: or
486: p_lac_lookup_code
487: <> nvl(ghr_nla_shd.g_old_rec.lac_lookup_code,hr_api.g_varchar2)
488: )

Line 487: <> nvl(ghr_nla_shd.g_old_rec.lac_lookup_code,hr_api.g_varchar2)

483: and ( p_nature_of_action_id
484: <> nvl(ghr_nla_shd.g_old_rec.nature_of_action_id,hr_api.g_number)
485: or
486: p_lac_lookup_code
487: <> nvl(ghr_nla_shd.g_old_rec.lac_lookup_code,hr_api.g_varchar2)
488: )
489: or not l_api_updating) then
490: --
491: -- check if the combination of action_id and lac_lookup_code already exits

Line 570: <> nvl(ghr_nla_shd.g_old_rec.lac_lookup_code,hr_api.g_varchar2)

566: p_object_version_number => p_object_version_number);
567: --
568: if (l_api_updating
569: and p_lac_lookup_code
570: <> nvl(ghr_nla_shd.g_old_rec.lac_lookup_code,hr_api.g_varchar2)
571: or not l_api_updating) then
572: --
573: -- check if value of lookup falls within lookup type.
574: --

Line 576: if hr_api.not_exists_in_hr_lookups

572: --
573: -- check if value of lookup falls within lookup type.
574: --
575: --
576: if hr_api.not_exists_in_hr_lookups
577: (p_lookup_type => 'GHR_US_LEGAL_AUTHORITY',
578: p_lookup_code => p_lac_lookup_code,
579: p_effective_date => p_effective_date) then
580: --