APPS.HXC_HTC_BUS SQL Statements

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

Line: 11

SELECT	DISTINCT ter.time_entry_rule_id
               , dfcu.application_column_name
FROM	fnd_descr_flex_column_usages dfcu
,	hxc_time_entry_rules ter
WHERE	ter.formula_id IS NOT NULL
AND
        dfcu.application_id = 809 AND
        dfcu.descriptive_flex_context_code = ter.attribute_category AND
        UPPER(dfcu.end_user_column_name) like 'TIME_CATEGORY%'
AND
	DECODE ( dfcu.application_column_name,
        'ATTRIBUTE1', ter.attribute1,
        'ATTRIBUTE2', ter.attribute2,
        'ATTRIBUTE3', ter.attribute3,
        'ATTRIBUTE4', ter.attribute4,
        'ATTRIBUTE5', ter.attribute5,
        'ATTRIBUTE6', ter.attribute6,
        'ATTRIBUTE7', ter.attribute7,
        'ATTRIBUTE8', ter.attribute8,
        'ATTRIBUTE9', ter.attribute9,
        'ATTRIBUTE10', ter.attribute10,
        'ATTRIBUTE11', ter.attribute11,
        'ATTRIBUTE12', ter.attribute12,
        'ATTRIBUTE13', ter.attribute13,
        'ATTRIBUTE14', ter.attribute14,
        'ATTRIBUTE15', ter.attribute15,
        'ATTRIBUTE16', ter.attribute16,
        'ATTRIBUTE17', ter.attribute17,
        'ATTRIBUTE18', ter.attribute18,
        'ATTRIBUTE19', ter.attribute19,
        'ATTRIBUTE20', ter.attribute20,
        'ATTRIBUTE21', ter.attribute21,
        'ATTRIBUTE22', ter.attribute22,
        'ATTRIBUTE23', ter.attribute23,
        'ATTRIBUTE24', ter.attribute24,
        'ATTRIBUTE25', ter.attribute25,
        'ATTRIBUTE26', ter.attribute26,
        'ATTRIBUTE27', ter.attribute27,
        'ATTRIBUTE28', ter.attribute28,
        'ATTRIBUTE29', ter.attribute29,
        'ATTRIBUTE30', ter.attribute30, 'zZz' ) = TO_CHAR(p_time_category_id);

Line: 82

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

Line: 115

End chk_non_updateable_args;

Line: 142

SELECT 'error'
FROM	sys.dual
WHERE EXISTS (
	SELECT	'x'
	FROM	hxc_time_categories map
	WHERE	map.time_category_name	= p_time_category_name AND
	( map.time_category_id <> p_time_category_id OR
	  p_time_category_id IS NULL ) );

Line: 264

Procedure chk_delete
  (
   p_time_category_id  number
  ) IS

  l_proc  varchar2(72);

Line: 272

SELECT 'exists'
FROM	sys.dual
WHERE	EXISTS (
	SELECT	'x'
	FROM   hxc_time_category_comps tcc
	WHERE  tcc.ref_time_category_id = p_time_category_id);

Line: 285

  	l_proc := g_package||'chk_delete';

Line: 323

END chk_delete;

Line: 328

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

Line: 338

  	l_proc := g_package||'insert_validate';

Line: 372

End insert_validate;

Line: 377

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

Line: 387

  	l_proc := g_package||'update_validate';

Line: 419

  chk_non_updateable_args
    (p_rec              => p_rec
    );

Line: 427

End update_validate;

Line: 432

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

Line: 442

  	l_proc := g_package||'delete_validate';

Line: 448

  chk_delete ( p_time_category_id => p_rec.time_category_id );

Line: 453

End delete_validate;