eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_RHT_BUS dependencies on PQH_ROUTING_CATEGORIES

Line 566: from pqh_routing_categories a

562: l_dummy varchar2(1);
563: --
564: cursor c1 is
565: select null
566: from pqh_routing_categories a
567: where a.routing_category_id = p_routing_category_id;
568: --
569: Begin
570: --

Line 583: -- check if routing_category_id value exists in pqh_routing_categories table

579: <> nvl(pqh_rht_shd.g_old_rec.routing_category_id,hr_api.g_number)
580: or not l_api_updating)
581: and p_routing_category_id is not null then
582: --
583: -- check if routing_category_id value exists in pqh_routing_categories table
584: --
585: open c1;
586: --
587: fetch c1 into l_dummy;

Line 592: -- raise error as FK does not relate to PK in pqh_routing_categories

588: if c1%notfound then
589: --
590: close c1;
591: --
592: -- raise error as FK does not relate to PK in pqh_routing_categories
593: -- table.
594: --
595: pqh_rht_shd.constraint_error('PQH_ROUTING_HISTORY_FK1');
596: --