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_NOAC_REMARKS

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 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 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 480: from ghr_noac_remarks a

476: l_dummy varchar2(1);
477: --
478: cursor c1 is
479: select null
480: from ghr_noac_remarks a
481: where a.nature_of_action_id = p_nature_of_action_id
482: and a.remark_id = p_remark_id;
483: --
484: Begin