APPS.BEN_PUM_BUS dependencies on BEN_POP_UP_MESSAGES

Line 56: ben_pum_shd.constraint_error('BEN_POP_UP_MESSAGES_PK');

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

Line 66: ben_pum_shd.constraint_error('BEN_POP_UP_MESSAGES_PK');

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

Line 657: from ben_pop_up_messages pum

653: l_dummy varchar2(1);
654: --
655: cursor c1 is
656: select null
657: from ben_pop_up_messages pum
658: where pum.business_group_id +0 = p_business_group_id
659: and pum.pop_up_messages_id <> nvl(p_pop_up_messages_id,-1)
660: and lower(pum.pop_name) = lower(p_pop_name);
661: --

Line 917: ben_pop_up_messages b

913: --
914: cursor csr_leg_code is
915: select a.legislation_code
916: from per_business_groups a,
917: ben_pop_up_messages b
918: where b.pop_up_messages_id = p_pop_up_messages_id
919: and a.business_group_id = b.business_group_id;
920: --
921: -- Declare local variables