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

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

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

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

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

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

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

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

Line 119: l_api_updating := ghr_nre_shd.api_updating

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

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

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

Line 194: l_api_updating := ghr_nre_shd.api_updating

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

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

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

Line 266: l_api_updating := ghr_nre_shd.api_updating

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

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

331: --
332: l_proc := g_package||'chk_required_flag';
333: hr_utility.set_location('Entering:'||l_proc, 5);
334: --
335: l_api_updating := ghr_nre_shd.api_updating
336: (p_noac_remark_id => p_noac_remark_id,
337: p_object_version_number => p_object_version_number);
338: --
339: if (l_api_updating

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

403: --
404: l_proc := g_package||'chk_date_from';
405: hr_utility.set_location('Entering:'||l_proc, 5);
406: --
407: l_api_updating := ghr_nre_shd.api_updating
408: (p_noac_remark_id => p_noac_remark_id,
409: p_object_version_number => p_object_version_number);
410: --
411: if (l_api_updating

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

485: --
486: l_proc := g_package||'chk_unique_act_rem_id';
487: hr_utility.set_location('Entering:'||l_proc, 5);
488: --
489: l_api_updating := ghr_nre_shd.api_updating
490: (p_noac_remark_id => p_noac_remark_id,
491: p_object_version_number => p_object_version_number);
492: --
493: hr_utility.set_location('Entering:'||l_proc, 10);

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

Line 542: Procedure insert_validate(p_rec in ghr_nre_shd.g_rec_type

538: --
539: -- ----------------------------------------------------------------------------
540: -- |---------------------------< insert_validate >----------------------------|
541: -- ----------------------------------------------------------------------------
542: Procedure insert_validate(p_rec in ghr_nre_shd.g_rec_type
543: ,p_effective_date in date) is
544: --
545: l_proc varchar2(72);
546: --

Line 601: Procedure update_validate(p_rec in ghr_nre_shd.g_rec_type

597: --
598: -- ----------------------------------------------------------------------------
599: -- |---------------------------< update_validate >----------------------------|
600: -- ----------------------------------------------------------------------------
601: Procedure update_validate(p_rec in ghr_nre_shd.g_rec_type
602: ,p_effective_date in date) is
603: --
604: l_proc varchar2(72);
605: --

Line 662: Procedure delete_validate(p_rec in ghr_nre_shd.g_rec_type

658: --
659: -- ----------------------------------------------------------------------------
660: -- |---------------------------< delete_validate >----------------------------|
661: -- ----------------------------------------------------------------------------
662: Procedure delete_validate(p_rec in ghr_nre_shd.g_rec_type
663: ,p_effective_date in date) is
664: --
665: l_proc varchar2(72);
666: --