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_NRE_BUS dependencies on GHR_NRE_SHD

Line 46: l_api_updating := ghr_nre_shd.api_updating

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

Line 52: <> ghr_nre_shd.g_old_rec.noac_remark_id) then

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

Line 56: ghr_nre_shd.constraint_error('GHR_NOAC_REMARKS_PK');

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

Line 66: ghr_nre_shd.constraint_error('GHR_NOAC_REMARKS_PK');

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

Line 118: l_api_updating := ghr_nre_shd.api_updating

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

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

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

Line 193: l_api_updating := ghr_nre_shd.api_updating

189: Begin
190: --
191: hr_utility.set_location('Entering:'||l_proc,5);
192: --
193: l_api_updating := ghr_nre_shd.api_updating
194: (p_noac_remark_id => p_noac_remark_id,
195: p_object_version_number => p_object_version_number);
196: --
197: if (l_api_updating

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 214: ghr_nre_shd.constraint_error('GHR_NOAC_REMARKS_FK1');

210: --
211: -- raise error as FK does not relate to PK in ghr_nature_of_actions
212: -- table.
213: --
214: ghr_nre_shd.constraint_error('GHR_NOAC_REMARKS_FK1');
215: --
216: end if;
217: --
218: close c1;

Line 264: l_api_updating := ghr_nre_shd.api_updating

260: Begin
261: --
262: hr_utility.set_location('Entering:'||l_proc, 5);
263: --
264: l_api_updating := ghr_nre_shd.api_updating
265: (p_noac_remark_id => p_noac_remark_id,
266: p_object_version_number => p_object_version_number);
267: --
268: if (l_api_updating

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 332: l_api_updating := ghr_nre_shd.api_updating

328: Begin
329: --
330: hr_utility.set_location('Entering:'||l_proc, 5);
331: --
332: l_api_updating := ghr_nre_shd.api_updating
333: (p_noac_remark_id => p_noac_remark_id,
334: p_object_version_number => p_object_version_number);
335: --
336: if (l_api_updating

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 403: l_api_updating := ghr_nre_shd.api_updating

399: Begin
400: --
401: hr_utility.set_location('Entering:'||l_proc, 5);
402: --
403: l_api_updating := ghr_nre_shd.api_updating
404: (p_noac_remark_id => p_noac_remark_id,
405: p_object_version_number => p_object_version_number);
406: --
407: if (l_api_updating

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 484: l_api_updating := ghr_nre_shd.api_updating

480: Begin
481: --
482: hr_utility.set_location('Entering:'||l_proc, 5);
483: --
484: l_api_updating := ghr_nre_shd.api_updating
485: (p_noac_remark_id => p_noac_remark_id,
486: p_object_version_number => p_object_version_number);
487: --
488: hr_utility.set_location('Entering:'||l_proc, 10);

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

Line 537: Procedure insert_validate(p_rec in ghr_nre_shd.g_rec_type

533: --
534: -- ----------------------------------------------------------------------------
535: -- |---------------------------< insert_validate >----------------------------|
536: -- ----------------------------------------------------------------------------
537: Procedure insert_validate(p_rec in ghr_nre_shd.g_rec_type
538: ,p_effective_date in date) is
539: --
540: l_proc varchar2(72) := g_package||'insert_validate';
541: --

Line 595: Procedure update_validate(p_rec in ghr_nre_shd.g_rec_type

591: --
592: -- ----------------------------------------------------------------------------
593: -- |---------------------------< update_validate >----------------------------|
594: -- ----------------------------------------------------------------------------
595: Procedure update_validate(p_rec in ghr_nre_shd.g_rec_type
596: ,p_effective_date in date) is
597: --
598: l_proc varchar2(72) := g_package||'update_validate';
599: --

Line 655: Procedure delete_validate(p_rec in ghr_nre_shd.g_rec_type

651: --
652: -- ----------------------------------------------------------------------------
653: -- |---------------------------< delete_validate >----------------------------|
654: -- ----------------------------------------------------------------------------
655: Procedure delete_validate(p_rec in ghr_nre_shd.g_rec_type
656: ,p_effective_date in date) is
657: --
658: l_proc varchar2(72) := g_package||'delete_validate';
659: --