[Home] [Help]
52: <> pqh_rng_shd.g_old_rec.attribute_range_id) then
53: --
54: -- raise error as PK has changed
55: --
56: pqh_rng_shd.constraint_error('PQH_ATTRIBUTE_RANGES_PK');
57: --
58: elsif not l_api_updating then
59: --
60: -- check if PK is null
62: if p_attribute_range_id is not null then
63: --
64: -- raise error as PK is not null
65: --
66: pqh_rng_shd.constraint_error('PQH_ATTRIBUTE_RANGES_PK');
67: --
68: end if;
69: --
70: end if;
136: --
137: -- raise error as FK does not relate to PK in per_all_positions
138: -- table.
139: --
140: pqh_rng_shd.constraint_error('PQH_ATTRIBUTE_RANGES_FK4');
141: --
142: end if;
143: --
144: close c1;
219: --
220: -- raise error as FK does not relate to PK in pqh_routing_categories
221: -- table.
222: --
223: pqh_rng_shd.constraint_error('PQH_ATTRIBUTE_RANGES_FK3');
224: --
225: end if;
226: --
227: close c1;
304: --
305: -- raise error as FK does not relate to PK in pqh_routing_list_members
306: -- table.
307: --
308: pqh_rng_shd.constraint_error('PQH_ATTRIBUTE_RANGES_FK2');
309: --
310: end if;
311: --
312: close c1;
385: e.parent_position_id = p_position_id);
386: --
387: Cursor csr_new_attr_in_rule is
388: Select 'x'
389: From pqh_attribute_ranges
390: Where attribute_id = p_attribute_id
391: and range_name = p_range_name
392: and routing_category_id = p_routing_category_id
393: and routing_list_member_id = p_routing_list_member_id;
576: --
577: -- raise error as FK does not relate to PK in pqh_attributes
578: -- table.
579: --
580: pqh_rng_shd.constraint_error('PQH_ATTRIBUTE_RANGES_FK1');
581: --
582: end if;
583: --
584: close c1;