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.BEN_OPT_BUS dependencies on PER_SPINAL_POINTS

Line 727: cursor c_per_spinal_points is

723: l_proc varchar2(72) := g_package||'chk_mapping_table_pk_id';
724: l_api_updating boolean;
725: l_dummy varchar2(1);
726: --
727: cursor c_per_spinal_points is
728: select null
729: from per_spinal_points spt
730: where spt.spinal_point_id = p_mapping_table_pk_id
731: and spt.business_group_id = p_business_group_id;

Line 729: from per_spinal_points spt

725: l_dummy varchar2(1);
726: --
727: cursor c_per_spinal_points is
728: select null
729: from per_spinal_points spt
730: where spt.spinal_point_id = p_mapping_table_pk_id
731: and spt.business_group_id = p_business_group_id;
732: --
733: Begin

Line 751: if p_mapping_table_name = 'PER_SPINAL_POINTS' then

747: --
748: -- check if value of Mapping Table Primary Key Id is valid.
749: --
750:
751: if p_mapping_table_name = 'PER_SPINAL_POINTS' then
752: open c_per_spinal_points;
753: --
754: -- fetch value from cursor if it returns a record then the
755: -- mapping_table_pk_id is valid otherwise its invalid

Line 752: open c_per_spinal_points;

748: -- check if value of Mapping Table Primary Key Id is valid.
749: --
750:
751: if p_mapping_table_name = 'PER_SPINAL_POINTS' then
752: open c_per_spinal_points;
753: --
754: -- fetch value from cursor if it returns a record then the
755: -- mapping_table_pk_id is valid otherwise its invalid
756: --

Line 757: fetch c_per_spinal_points into l_dummy;

753: --
754: -- fetch value from cursor if it returns a record then the
755: -- mapping_table_pk_id is valid otherwise its invalid
756: --
757: fetch c_per_spinal_points into l_dummy;
758: if c_per_spinal_points%notfound then
759: --
760: close c_per_spinal_points;
761: --

Line 758: if c_per_spinal_points%notfound then

754: -- fetch value from cursor if it returns a record then the
755: -- mapping_table_pk_id is valid otherwise its invalid
756: --
757: fetch c_per_spinal_points into l_dummy;
758: if c_per_spinal_points%notfound then
759: --
760: close c_per_spinal_points;
761: --
762: -- raise error

Line 760: close c_per_spinal_points;

756: --
757: fetch c_per_spinal_points into l_dummy;
758: if c_per_spinal_points%notfound then
759: --
760: close c_per_spinal_points;
761: --
762: -- raise error
763: --
764: hr_utility.set_message(805,'BEN_93322_INV_SPINAL_POINT_ID');

Line 769: close c_per_spinal_points;

765: hr_utility.raise_error;
766: --
767: end if;
768: --
769: close c_per_spinal_points;
770: --
771: end if;
772: end if;
773: --