APPS.HXC_TCC_BUS SQL Statements

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

Line: 39

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

Line: 72

End chk_non_updateable_args;

Line: 108

SELECT	'ok'
FROM	sys.dual
WHERE EXISTS (
	SELECT	'x'
	FROM	hxc_mapping_components mpc
	WHERE	mpc.mapping_component_id = p_component_type_id );

Line: 192

SELECT	'ok'
FROM	sys.dual
WHERE EXISTS (
	SELECT	'x'
	FROM	hxc_time_categories htc
	WHERE	htc.time_category_id = p_ref_time_category_id );

Line: 200

SELECT	'error'
FROM	sys.dual
WHERE EXISTS (
	SELECT	'x'
	FROM	hxc_time_category_comps mpc
	WHERE	mpc.time_category_id     = p_time_category_id
	AND	mpc.ref_time_category_id = p_ref_time_category_id
	AND	( mpc.time_category_comp_id <> p_time_category_comp_id OR
		  p_time_category_comp_id IS NULL ) );

Line: 214

SELECT	tcc.ref_time_category_id
FROM	hxc_time_category_comps tcc
,	hxc_time_categories htc
WHERE	htc.time_category_id = p_ref_time_category_id
AND     htc.time_category_id = tcc.time_category_id
AND	tcc.ref_time_category_id IS NOT NULL;

Line: 442

SELECT 'error'
FROM	sys.dual
WHERE EXISTS (
	SELECT	'x'
	FROM	hxc_time_category_comps mpc
	WHERE	mpc.time_category_id     = p_time_category_id
        AND     mpc.component_type_id    = p_component_type_id
        AND     mpc.type                 = p_type
        AND     (
                 (  mpc.type = 'MC' AND
                  ( mpc.value_id             = p_value_id ) OR
                  ( p_value_id IS NULL AND mpc.value_id IS NULL )
                 )
		OR
		 ( mpc.type = 'MC_VS' AND
	           mpc.flex_value_set_id = p_flex_value_set_id )
                OR
                ( mpc.type NOT IN ( 'MC_VS', 'MC' ) )
                )
	AND	( mpc.time_category_comp_id <> p_time_category_comp_id OR
		  p_time_category_comp_id IS NULL ) );

Line: 531

SELECT 'ok'
FROM   dual
WHERE EXISTS (
select 1
FROM   fnd_flex_value_sets
WHERE  flex_value_set_id = p_flex_value_set_id );

Line: 595

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

Line: 605

  	l_proc := g_package||'insert_validate';

Line: 673

End insert_validate;

Line: 678

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

Line: 688

  	l_proc := g_package||'update_validate';

Line: 741

  chk_non_updateable_args
    (p_rec              => p_rec
    );

Line: 748

End update_validate;

Line: 753

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

Line: 764

  	l_proc := g_package||'delete_validate';

Line: 772

	hxc_time_category_utils_pkg.delete_time_category_comp_sql ( p_rec );

Line: 778

End delete_validate;