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.HXC_HAV_BUS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 33


    select pbg.security_group_id
      from per_business_groups pbg
         , hxc_alias_values hav
      --   , EDIT_HERE table_name(s) 333
     where hav.alias_value_id = p_alias_value_id;

Line: 105


    select pbg.legislation_code
      from per_business_groups     pbg
         , hxc_alias_values hav
      --   , EDIT_HERE table_name(s) 333
     where hav.alias_value_id = p_alias_value_id;

Line: 387


Procedure chk_non_updateable_args
  (p_rec in hxc_hav_shd.g_rec_type
  ) IS
--
  l_proc     varchar2(72) := g_package || 'chk_non_updateable_args';

Line: 420


End chk_non_updateable_args;

Line: 463


SELECT 'error'
FROM    hxc_alias_values_tl havt,
	hxc_alias_values hav
WHERE   havt.alias_value_id = hav.alias_value_id
AND	havt.alias_value_name = p_name
AND     hav.object_version_number <> NVL(p_ovn, -1)
AND     hav.alias_definition_id = p_alias_definition_id
and     havt.language = USERENV('LANG')
AND     hav.alias_value_id 	<> nvl(p_alias_value_id,9.99E125)
AND     ((p_date_from BETWEEN hav.date_from
                      AND NVL(hav.date_to, HR_GENERAL.END_OF_TIME))
        OR
         (NVL(p_date_to, HR_GENERAL.END_OF_TIME) BETWEEN
          hav.date_from AND NVL(hav.date_to, HR_GENERAL.END_OF_TIME))
        OR
        (hav.date_from BETWEEN p_date_from
		       AND NVL(p_date_to, HR_GENERAL.END_OF_TIME))
        OR
        (NVL(hav.date_to, HR_GENERAL.END_OF_TIME) BETWEEN
         p_date_from AND NVL(p_date_to, HR_GENERAL.END_OF_TIME)));

Line: 621


SELECT 'error'
FROM    hxc_alias_values hav
WHERE   hav.alias_definition_id = p_alias_definition_id
AND     hav.object_version_number <> NVL(p_ovn, -1)
AND     ((p_date_from BETWEEN hav.date_from
                      AND NVL(hav.date_to, HR_GENERAL.END_OF_TIME))
        OR
         (NVL(p_date_to, HR_GENERAL.END_OF_TIME) BETWEEN
          hav.date_from AND NVL(hav.date_to, HR_GENERAL.END_OF_TIME))
        OR
        (hav.date_from BETWEEN p_date_from
		       AND NVL(p_date_to, HR_GENERAL.END_OF_TIME))
        OR
        (NVL(hav.date_to, HR_GENERAL.END_OF_TIME) BETWEEN
         p_date_from AND NVL(p_date_to, HR_GENERAL.END_OF_TIME)))
AND     hav.alias_value_id 		       <> nvl(p_alias_value_id,9.99E125)
AND	hav.attribute_category 		       = p_attribute_category
AND	nvl(hav.attribute1,chr(0))	       = nvl(p_attribute1,chr(0))
AND	nvl(hav.attribute2,chr(0))	       = nvl(p_attribute2,chr(0))
AND	nvl(hav.attribute3,chr(0))	       = nvl(p_attribute3,chr(0))
AND	nvl(hav.attribute4,chr(0))	       = nvl(p_attribute4,chr(0))
AND	nvl(hav.attribute5,chr(0))	       = nvl(p_attribute5,chr(0))
AND	nvl(hav.attribute6,chr(0))	       = nvl(p_attribute6,chr(0))
AND	nvl(hav.attribute7,chr(0))	       = nvl(p_attribute7,chr(0))
AND	nvl(hav.attribute8,chr(0))	       = nvl(p_attribute8,chr(0))
AND	nvl(hav.attribute9,chr(0))	       = nvl(p_attribute9,chr(0))
AND	nvl(hav.attribute10,chr(0))	       = nvl(p_attribute10,chr(0))
AND	nvl(hav.attribute11,chr(0))	       = nvl(p_attribute11,chr(0))
AND	nvl(hav.attribute12,chr(0))	       = nvl(p_attribute12,chr(0))
AND	nvl(hav.attribute13,chr(0))	       = nvl(p_attribute13,chr(0))
AND	nvl(hav.attribute14,chr(0))	       = nvl(p_attribute14,chr(0))
AND	nvl(hav.attribute15,chr(0))	       = nvl(p_attribute15,chr(0))
AND	nvl(hav.attribute16,chr(0))	       = nvl(p_attribute16,chr(0))
AND	nvl(hav.attribute17,chr(0))	       = nvl(p_attribute17,chr(0))
AND	nvl(hav.attribute18,chr(0))	       = nvl(p_attribute18,chr(0))
AND	nvl(hav.attribute19,chr(0))	       = nvl(p_attribute19,chr(0))
AND	nvl(hav.attribute20,chr(0))	       = nvl(p_attribute20,chr(0))
AND	nvl(hav.attribute21,chr(0))	       = nvl(p_attribute21,chr(0))
AND	nvl(hav.attribute22,chr(0))	       = nvl(p_attribute22,chr(0))
AND	nvl(hav.attribute23,chr(0))	       = nvl(p_attribute23,chr(0))
AND	nvl(hav.attribute24,chr(0))	       = nvl(p_attribute24,chr(0))
AND	nvl(hav.attribute25,chr(0))	       = nvl(p_attribute25,chr(0))
AND	nvl(hav.attribute26,chr(0))	       = nvl(p_attribute26,chr(0))
AND	nvl(hav.attribute27,chr(0))	       = nvl(p_attribute27,chr(0))
AND	nvl(hav.attribute28,chr(0))	       = nvl(p_attribute28,chr(0))
AND	nvl(hav.attribute29,chr(0))	       = nvl(p_attribute29,chr(0))
AND	nvl(hav.attribute30,chr(0))	       = nvl(p_attribute30,chr(0));

Line: 764


Procedure insert_validate
  (p_rec                          in hxc_hav_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72);

Line: 773


	l_proc := g_package||'insert_validate';

Line: 841


End insert_validate;

Line: 846


Procedure update_validate
  (p_rec                          in hxc_hav_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72);

Line: 855


	l_proc := g_package||'update_validate';

Line: 861


chk_non_updateable_args
    (p_rec              => p_rec
    );

Line: 921


/*  chk_non_updateable_args
    (p_rec              => p_rec
    ); */

Line: 931


End update_validate;

Line: 936


Procedure delete_validate
  (p_rec                          in hxc_hav_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72);

Line: 945


	l_proc := g_package||'delete_validate';

Line: 954


End delete_validate;