DBA Data[Home] [Help]

APPS.GHR_NLA_BUS dependencies on GHR_NOAC_LAS

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

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

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

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

Line 140: ghr_nla_shd.constraint_error('GHR_NOAC_LAS_FK1');

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

Line 473: from ghr_noac_las a

469: l_dummy varchar2(1);
470: --
471: cursor c1 is
472: select null
473: from ghr_noac_las a
474: where a.nature_of_action_id = p_nature_of_action_id
475: and a.lac_lookup_code = p_lac_lookup_code;
476: --
477: Begin