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 52: and nvl(p_noac_la_id,hr_api.g_number)

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

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

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

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

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

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

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

Line 203: if hr_api.not_exists_in_hr_lookups

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

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

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

Line 272: if hr_api.not_exists_in_hr_lookups

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

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

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

Line 341: if hr_api.not_exists_in_hr_lookups

337: --
338: -- check if value of lookup falls within lookup type.
339: --
340: --
341: if hr_api.not_exists_in_hr_lookups
342: (p_lookup_type => 'YES_NO',
343: p_lookup_code => p_valid_first_lac_flag,
344: p_effective_date => p_effective_date) then
345: --

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

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

Line 412: hr_api.mandatory_arg_error

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

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

486: hr_utility.set_location('Entering:'||l_proc, 10);
487: --
488: if (l_api_updating
489: and ( p_nature_of_action_id
490: <> nvl(ghr_nla_shd.g_old_rec.nature_of_action_id,hr_api.g_number)
491: or
492: p_lac_lookup_code
493: <> nvl(ghr_nla_shd.g_old_rec.lac_lookup_code,hr_api.g_varchar2)
494: )

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

489: and ( p_nature_of_action_id
490: <> nvl(ghr_nla_shd.g_old_rec.nature_of_action_id,hr_api.g_number)
491: or
492: p_lac_lookup_code
493: <> nvl(ghr_nla_shd.g_old_rec.lac_lookup_code,hr_api.g_varchar2)
494: )
495: or not l_api_updating) then
496: --
497: -- check if the combination of action_id and lac_lookup_code already exits

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

573: p_object_version_number => p_object_version_number);
574: --
575: if (l_api_updating
576: and p_lac_lookup_code
577: <> nvl(ghr_nla_shd.g_old_rec.lac_lookup_code,hr_api.g_varchar2)
578: or not l_api_updating) then
579: --
580: -- check if value of lookup falls within lookup type.
581: --

Line 583: if hr_api.not_exists_in_hr_lookups

579: --
580: -- check if value of lookup falls within lookup type.
581: --
582: --
583: if hr_api.not_exists_in_hr_lookups
584: (p_lookup_type => 'GHR_US_LEGAL_AUTHORITY',
585: p_lookup_code => p_lac_lookup_code,
586: p_effective_date => p_effective_date) then
587: --