APPS.HXC_EGC_BUS SQL Statements

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

Line: 219

Procedure chk_non_updateable_args
  (p_effective_date               in date
  ,p_rec in hxc_egc_shd.g_rec_type
  ) IS
--
  l_proc     varchar2(72) := g_package || 'chk_non_updateable_args';

Line: 250

End chk_non_updateable_args;

Line: 284

SELECT 'error'
FROM	sys.dual
WHERE NOT EXISTS (
	SELECT	'x'
	FROM	hxc_time_entry_rules ter
	WHERE	ter.time_entry_rule_id = p_entity_id );

Line: 292

SELECT 'error'
FROM	dual
WHERE	NOT EXISTS (
	SELECT	'x'
	FROM	hxc_time_recipients tr
	WHERE	tr.time_recipient_id	= p_entity_id );

Line: 300

SELECT 'error'
FROM	dual
WHERE	NOT EXISTS (
	SELECT	'x'
	FROM	hxc_retrieval_rules rr
	WHERE	rr.retrieval_rule_id	= p_entity_id );

Line: 308

SELECT 'error'
FROM	dual
WHERE	NOT EXISTS (
	SELECT	'x'
	FROM	hxc_template_summary hts
	WHERE	hts.template_id	= p_entity_id
        and hts.template_type = 'PUBLIC');

Line: 448

SELECT 'error'
FROM	sys.dual
WHERE NOT EXISTS (
	SELECT	'x'
	FROM	hxc_entity_groups egc
	WHERE	egc.entity_group_id = p_entity_group_id );

Line: 529

SELECT 'error'
FROM	sys.dual
WHERE NOT EXISTS (
	SELECT	'x'
	FROM	hr_lookups lk
	WHERE	lk.lookup_type = 'HXC_ENTITIES'
	AND	lk.lookup_code = p_entity_type
	AND	p_effective_date BETWEEN
		lk.start_date_active and NVL(lk.end_date_active, hr_general.end_of_time) );

Line: 591

    select 'Y'
      from hxc_entity_groups heg,
           hxc_entity_group_comps hec,
	   hxc_time_entry_rules hte1,
	   hxc_time_entry_rules hte2
     where heg.entity_type = 'TIME_ENTRY_RULES' and
           heg.entity_group_id = nvl(p_entity_group_id,-999) and
	   hec.ENTITY_GROUP_ID =heg.entity_group_id and
	   hec.entity_id = hte1.TIME_ENTRY_RULE_ID and
	   hte1.attribute1 = hte2.attribute1 and
	   hte2.time_entry_rule_id = nvl(p_entity_id,-999) and
	   hec.entity_group_comp_id <> nvl(p_entity_group_comp_id,-999);

Line: 641

Procedure insert_validate
  (p_effective_date               in date
  ,p_rec                          in hxc_egc_shd.g_rec_type
  ,p_called_from_form             in varchar2
  ) is
--
  l_proc  varchar2(72);

Line: 652

	l_proc := g_package||'insert_validate';

Line: 692

End insert_validate;

Line: 697

Procedure update_validate
  (p_effective_date               in date
  ,p_rec                          in hxc_egc_shd.g_rec_type
  ,p_called_from_form             in varchar2
  ) is
--
  l_proc  varchar2(72);

Line: 708

	l_proc := g_package||'update_validate';

Line: 722

  chk_non_updateable_args
    (p_effective_date              => p_effective_date
      ,p_rec              => p_rec
    );

Line: 741

End update_validate;

Line: 746

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

Line: 755

	l_proc := g_package||'delete_validate';

Line: 765

End delete_validate;