APPS.HXC_TER_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_ter_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72);

Line: 65

  	l_proc := g_package||'insert_dml';

Line: 74

  insert into hxc_time_entry_rules
      (time_entry_rule_id
      ,name
      ,business_group_id
      ,legislation_code
      ,rule_usage
      ,mapping_id
      ,formula_id
      ,description
      ,start_date
      ,end_date
      ,object_version_number
      ,attribute_category
      ,attribute1
      ,attribute2
      ,attribute3
      ,attribute4
      ,attribute5
      ,attribute6
      ,attribute7
      ,attribute8
      ,attribute9
      ,attribute10
      ,attribute11
      ,attribute12
      ,attribute13
      ,attribute14
      ,attribute15
      ,attribute16
      ,attribute17
      ,attribute18
      ,attribute19
      ,attribute20
      ,attribute21
      ,attribute22
      ,attribute23
      ,attribute24
      ,attribute25
      ,attribute26
      ,attribute27
      ,attribute28
      ,attribute29
      ,attribute30
      ,creation_date
,created_by
,last_updated_by
,last_update_date
,last_update_login
      )
  Values
    (p_rec.time_entry_rule_id
    ,p_rec.name
    ,p_rec.business_group_id
    ,p_rec.legislation_code
    ,p_rec.rule_usage
    ,p_rec.mapping_id
    ,p_rec.formula_id
    ,p_rec.description
    ,p_rec.start_date
    ,p_rec.end_date
    ,p_rec.object_version_number
    ,p_rec.attribute_category
    ,p_rec.attribute1
    ,p_rec.attribute2
    ,p_rec.attribute3
    ,p_rec.attribute4
    ,p_rec.attribute5
    ,p_rec.attribute6
    ,p_rec.attribute7
    ,p_rec.attribute8
    ,p_rec.attribute9
    ,p_rec.attribute10
    ,p_rec.attribute11
    ,p_rec.attribute12
    ,p_rec.attribute13
    ,p_rec.attribute14
    ,p_rec.attribute15
    ,p_rec.attribute16
    ,p_rec.attribute17
    ,p_rec.attribute18
    ,p_rec.attribute19
    ,p_rec.attribute20
    ,p_rec.attribute21
    ,p_rec.attribute22
    ,p_rec.attribute23
    ,p_rec.attribute24
    ,p_rec.attribute25
    ,p_rec.attribute26
    ,p_rec.attribute27
    ,p_rec.attribute28
    ,p_rec.attribute29
    ,p_rec.attribute30
     ,sysdate
 ,fnd_global.user_id
 ,fnd_global.user_id
 ,sysdate
 ,fnd_global.login_id
    );

Line: 212

End insert_dml;

Line: 251

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

Line: 257

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

Line: 263

  	l_proc := g_package||'pre_insert';

Line: 277

End pre_insert;

Line: 311

Procedure post_insert
  (p_effective_date               in date
  ,p_rec                          in hxc_ter_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72);

Line: 322

  	l_proc := g_package||'post_insert';

Line: 327

    hxc_ter_rki.after_insert
      (p_effective_date              => p_effective_date
      ,p_time_entry_rule_id          => p_rec.time_entry_rule_id
      ,p_name 			     => p_rec.name
      ,p_business_group_id	     => p_rec.business_group_id
      ,p_legislation_code	     => p_rec.legislation_code
      ,p_rule_usage		     => p_rec.rule_usage
      ,p_formula_id		     => p_rec.formula_id
      ,p_mapping_id                  => p_rec.mapping_id
      ,p_description 		     => p_rec.description
      ,p_start_date 		     => p_rec.start_date
      ,p_end_date 		     => p_rec.end_date
      ,p_object_version_number       => p_rec.object_version_number
      ,p_attribute_category
      => p_rec.attribute_category
      ,p_attribute1
      => p_rec.attribute1
      ,p_attribute2
      => p_rec.attribute2
      ,p_attribute3
      => p_rec.attribute3
      ,p_attribute4
      => p_rec.attribute4
      ,p_attribute5
      => p_rec.attribute5
      ,p_attribute6
      => p_rec.attribute6
      ,p_attribute7
      => p_rec.attribute7
      ,p_attribute8
      => p_rec.attribute8
      ,p_attribute9
      => p_rec.attribute9
      ,p_attribute10
      => p_rec.attribute10
      ,p_attribute11
      => p_rec.attribute11
      ,p_attribute12
      => p_rec.attribute12
      ,p_attribute13
      => p_rec.attribute13
      ,p_attribute14
      => p_rec.attribute14
      ,p_attribute15
      => p_rec.attribute15
      ,p_attribute16
      => p_rec.attribute16
      ,p_attribute17
      => p_rec.attribute17
      ,p_attribute18
      => p_rec.attribute18
      ,p_attribute19
      => p_rec.attribute19
      ,p_attribute20
      => p_rec.attribute20
      ,p_attribute21
      => p_rec.attribute21
      ,p_attribute22
      => p_rec.attribute22
      ,p_attribute23
      => p_rec.attribute23
      ,p_attribute24
      => p_rec.attribute24
      ,p_attribute25
      => p_rec.attribute25
      ,p_attribute26
      => p_rec.attribute26
      ,p_attribute27
      => p_rec.attribute27
      ,p_attribute28
      => p_rec.attribute28
      ,p_attribute29
      => p_rec.attribute29
      ,p_attribute30
      => p_rec.attribute30
      );

Line: 417

End post_insert;

Line: 439

  hxc_ter_bus.insert_validate
     (p_effective_date
     ,p_rec
     );

Line: 446

  hxc_ter_ins.pre_insert(p_rec);

Line: 450

  hxc_ter_ins.insert_dml(p_rec);

Line: 454

  hxc_ter_ins.post_insert
     (p_effective_date
     ,p_rec
     );