DBA Data[Home] [Help]

APPS.PER_SHT_BUS dependencies on PER_SHARED_TYPES

Line 56: per_sht_shd.constraint_error('PER_SHARED_TYPES_PK');

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

Line 66: per_sht_shd.constraint_error('PER_SHARED_TYPES_PK');

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

Line 183: from per_shared_types

179: --
180: -- Fix for bug 3478716. added upper for shared_type_name in the following cursor.
181: --
182: cursor c1 is select shared_type_id
183: from per_shared_types
184: where lookup_type = p_lookup_type
185: and system_type_cd = p_system_type_cd
186: and shared_type_code = p_shared_type_code
187: and upper(Shared_type_name) = upper(p_shared_type_name)

Line 326: per_shared_types b

322: --
323: cursor csr_leg_code is
324: select a.legislation_code
325: from per_business_groups a,
326: per_shared_types b
327: where b.shared_type_id = p_shared_type_id
328: and a.business_group_id = b.business_group_id;
329: --
330: -- Declare local variables