APPS.HXC_TCC_INS SQL Statements

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

Line: 55

Procedure insert_dml
  (p_rec in out nocopy hxc_tcc_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72);

Line: 65

  	l_proc := g_package||'insert_dml';

Line: 75

  insert into hxc_time_category_comps
          (time_category_comp_id
          ,time_category_id
          ,ref_time_category_id
          ,component_type_id
          ,flex_value_set_id
          ,value_id
          ,is_null
          ,equal_to
          ,type
          ,object_version_number
	  ,creation_date
          ,created_by
          ,last_updated_by
          ,last_update_date
          ,last_update_login)
  Values
          (p_rec.time_category_comp_id
          ,p_rec.time_category_id
          ,p_rec.ref_time_category_id
          ,p_rec.component_type_id
          ,p_rec.flex_value_set_id
          ,p_rec.value_id
          ,p_rec.is_null
          ,p_rec.equal_to
          ,p_rec.type
          ,p_rec.object_version_number
          ,sysdate
          ,fnd_global.user_id
          ,fnd_global.user_id
          ,sysdate
          ,fnd_global.login_id
);

Line: 146

End insert_dml;

Line: 185

Procedure pre_insert
  (p_rec  in out nocopy hxc_tcc_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72);

Line: 191

  Cursor C_Sel1 is select hxc_time_category_comps_s.nextval from sys.dual;

Line: 197

  	l_proc := g_package||'pre_insert';

Line: 211

End pre_insert;

Line: 245

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

Line: 255

  	l_proc := g_package||'post_insert';

Line: 260

    hxc_tcc_rki.after_insert (
       p_time_category_comp_id  => p_rec.time_category_comp_id
      ,p_time_category_id       => p_rec.time_category_id
      ,p_ref_time_category_id   => p_rec.ref_time_category_id
      ,p_component_type_id      => p_rec.component_type_id
      ,p_flex_value_set_id      => p_rec.flex_value_set_id
      ,p_value_id               => p_rec.value_id
      ,p_is_null                => p_rec.is_null
      ,p_equal_to               => p_rec.equal_to
      ,p_type                   => p_rec.type
      ,p_object_version_number  => p_rec.object_version_number );

Line: 285

End post_insert;

Line: 306

  hxc_tcc_bus.insert_validate
     (p_rec
     );

Line: 312

  hxc_tcc_ins.pre_insert(p_rec);

Line: 316

  hxc_tcc_ins.insert_dml(p_rec);

Line: 320

  hxc_tcc_ins.post_insert
     (p_rec
     );

Line: 326

      hxc_time_category_utils_pkg.insert_time_category_comp_sql ( p_rec );