[Home] [Help]
303: and nvl(p_business_group_id,hr_api.g_number)
304: <> nvl(pqh_rst_shd.g_old_rec.business_group_id,hr_api.g_number)
305: or not l_api_updating) then
306: --
307: -- check if business_group_id exists in hr_all_organization_units table
308: --
309: --
310: open c1;
311: --
313: if c1%notfound then
314: --
315: close c1;
316: --
317: -- raise error as FK does not relate to PK in hr_all_organization_units
318: -- table.
319: --
320: pqh_rst_shd.constraint_error('PQH_RULE_SETS_FK3');
321: --
364: p_object_version_number in number) is
365: --
366: l_proc varchar2(72) := g_package||'chk_duplicate_rule_set';
367: l_api_updating boolean;
368: l_business_group_id hr_all_organization_units.business_group_id%type;
369: l_rule_set_name pqh_rule_sets_tl.rule_set_name%type;
370: l_rule_set_id pqh_rule_sets.rule_set_id%type;
371: --
372: cursor c1 is
532: --
533: l_proc varchar2(72) := g_package||'chk_organization_id';
534: l_api_updating boolean;
535: l_dummy varchar2(1);
536: l_business_group_id hr_all_organization_units.business_group_id%type;
537: --
538: cursor c1 is
539: select business_group_id
540: from hr_all_organization_units a
536: l_business_group_id hr_all_organization_units.business_group_id%type;
537: --
538: cursor c1 is
539: select business_group_id
540: from hr_all_organization_units a
541: where a.organization_id = p_organization_id;
542: --
543: Begin
544: --
558: <> nvl(pqh_rst_shd.g_old_rec.organization_id,hr_api.g_number))
559: or not l_api_updating)
560: and p_organization_id is not null then
561: --
562: -- check if organization value exists in hr_all_organization_units table
563: --
564: open c1;
565: --
566: fetch c1 into l_business_group_id;
567: if c1%notfound then
568: --
569: close c1;
570: --
571: -- raise error as FK does not relate to PK in hr_all_organization_units
572: -- table.
573: --
574: hr_utility.set_message(8302,'PQH_ORG_NOT_VALID');
575: hr_utility.raise_error;