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 GHR_NLA_SHD

Line 46: l_api_updating := ghr_nla_shd.api_updating

42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := ghr_nla_shd.api_updating
47: (p_noac_la_id => p_noac_la_id,
48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating

Line 52: <> ghr_nla_shd.g_old_rec.noac_la_id) then

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: --
56: ghr_nla_shd.constraint_error('GHR_NOAC_LAS_PK');

Line 56: ghr_nla_shd.constraint_error('GHR_NOAC_LAS_PK');

52: <> ghr_nla_shd.g_old_rec.noac_la_id) then
53: --
54: -- raise error as PK has changed
55: --
56: ghr_nla_shd.constraint_error('GHR_NOAC_LAS_PK');
57: --
58: elsif not l_api_updating then
59: --
60: -- check if PK is null

Line 66: ghr_nla_shd.constraint_error('GHR_NOAC_LAS_PK');

62: if p_noac_la_id is not null then
63: --
64: -- raise error as PK is not null
65: --
66: ghr_nla_shd.constraint_error('GHR_NOAC_LAS_PK');
67: --
68: end if;
69: --
70: end if;

Line 118: l_api_updating := ghr_nla_shd.api_updating

114: Begin
115: --
116: hr_utility.set_location('Entering:'||l_proc,5);
117: --
118: l_api_updating := ghr_nla_shd.api_updating
119: (p_noac_la_id => p_noac_la_id,
120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating

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 139: ghr_nla_shd.constraint_error('GHR_NOAC_LAS_FK1');

135: --
136: -- raise error as FK does not relate to PK in ghr_nature_of_actions
137: -- table.
138: --
139: ghr_nla_shd.constraint_error('GHR_NOAC_LAS_FK1');
140: --
141: end if;
142: --
143: close c1;

Line 189: l_api_updating := ghr_nla_shd.api_updating

185: Begin
186: --
187: hr_utility.set_location('Entering:'||l_proc, 5);
188: --
189: l_api_updating := ghr_nla_shd.api_updating
190: (p_noac_la_id => p_noac_la_id,
191: p_object_version_number => p_object_version_number);
192: --
193: if (l_api_updating

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 257: l_api_updating := ghr_nla_shd.api_updating

253: Begin
254: --
255: hr_utility.set_location('Entering:'||l_proc, 5);
256: --
257: l_api_updating := ghr_nla_shd.api_updating
258: (p_noac_la_id => p_noac_la_id,
259: p_object_version_number => p_object_version_number);
260: --
261: if (l_api_updating

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 325: l_api_updating := ghr_nla_shd.api_updating

321: Begin
322: --
323: hr_utility.set_location('Entering:'||l_proc, 5);
324: --
325: l_api_updating := ghr_nla_shd.api_updating
326: (p_noac_la_id => p_noac_la_id,
327: p_object_version_number => p_object_version_number);
328: --
329: if (l_api_updating

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 396: l_api_updating := ghr_nla_shd.api_updating

392: Begin
393: --
394: hr_utility.set_location('Entering:'||l_proc, 5);
395: --
396: l_api_updating := ghr_nla_shd.api_updating
397: (p_noac_la_id => p_noac_la_id,
398: p_object_version_number => p_object_version_number);
399: --
400: if (l_api_updating

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 476: l_api_updating := ghr_nla_shd.api_updating

472: Begin
473: --
474: hr_utility.set_location('Entering:'||l_proc, 5);
475: --
476: l_api_updating := ghr_nla_shd.api_updating
477: (p_noac_la_id => p_noac_la_id,
478: p_object_version_number => p_object_version_number);
479: --
480: hr_utility.set_location('Entering:'||l_proc, 10);

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 564: l_api_updating := ghr_nla_shd.api_updating

560: Begin
561: --
562: hr_utility.set_location('Entering:'||l_proc, 5);
563: --
564: l_api_updating := ghr_nla_shd.api_updating
565: (p_noac_la_id => p_noac_la_id,
566: p_object_version_number => p_object_version_number);
567: --
568: if (l_api_updating

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 597: Procedure insert_validate(p_rec in ghr_nla_shd.g_rec_type

593: --
594: -- ----------------------------------------------------------------------------
595: -- |---------------------------< insert_validate >----------------------------|
596: -- ----------------------------------------------------------------------------
597: Procedure insert_validate(p_rec in ghr_nla_shd.g_rec_type
598: ,p_effective_date in date) is
599: --
600: l_proc varchar2(72) := g_package||'insert_validate';
601: --

Line 665: Procedure update_validate(p_rec in ghr_nla_shd.g_rec_type

661: --
662: -- ----------------------------------------------------------------------------
663: -- |---------------------------< update_validate >----------------------------|
664: -- ----------------------------------------------------------------------------
665: Procedure update_validate(p_rec in ghr_nla_shd.g_rec_type
666: ,p_effective_date in date) is
667: --
668: l_proc varchar2(72) := g_package||'update_validate';
669: --

Line 733: Procedure delete_validate(p_rec in ghr_nla_shd.g_rec_type

729: --
730: -- ----------------------------------------------------------------------------
731: -- |---------------------------< delete_validate >----------------------------|
732: -- ----------------------------------------------------------------------------
733: Procedure delete_validate(p_rec in ghr_nla_shd.g_rec_type
734: ,p_effective_date in date) is
735: --
736: l_proc varchar2(72) := g_package||'delete_validate';
737: --