APPS.HXC_HPH_INS SQL Statements

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

Line: 54

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

Line: 62

	  l_proc := g_package||'insert_dml';

Line: 71

  insert into hxc_pref_hierarchies
      (pref_hierarchy_id
      ,type
      ,name
      ,business_group_id
      ,legislation_code
      ,parent_pref_hierarchy_id
      ,edit_allowed
      ,displayed
      ,pref_definition_id
      ,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
      ,object_version_number
      ,orig_pref_hierarchy_id
      ,orig_parent_hierarchy_id
      ,top_level_parent_id         --Performance Fix
      ,code
      ,creation_date
,created_by
,last_updated_by
,last_update_date
,last_update_login
      )
  Values
    (p_rec.pref_hierarchy_id
    ,p_rec.type
    ,p_rec.name
    ,p_rec.business_group_id
    ,p_rec.legislation_code
    ,p_rec.parent_pref_hierarchy_id
    ,p_rec.edit_allowed
    ,p_rec.displayed
    ,p_rec.pref_definition_id
    ,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
    ,p_rec.object_version_number
    ,p_rec.orig_pref_hierarchy_id
    ,p_rec.orig_parent_hierarchy_id
    ,p_rec.top_level_parent_id   --Performance Fix
    ,p_rec.code
     ,sysdate
 ,fnd_global.user_id
 ,fnd_global.user_id
 ,sysdate
 ,fnd_global.login_id
    );

Line: 200

End insert_dml;

Line: 239

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

Line: 245

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

Line: 248

          select  pref_hierarchy_id
            from  hxc_pref_hierarchies
	   where parent_pref_hierarchy_id is null
           connect by prior parent_pref_hierarchy_id = pref_hierarchy_id
           start with pref_hierarchy_id = p_pref_hierarchy_id;

Line: 256

          select hpd.code
          from   hxc_pref_definitions hpd
          where  pref_definition_id = p_pref_definition_id;

Line: 266

	l_proc := g_package||'pre_insert';

Line: 297

End pre_insert;

Line: 331

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

Line: 340

	l_proc := g_package||'post_insert';

Line: 345

    hxc_hph_rki.after_insert
      (p_effective_date              => p_effective_date
      ,p_pref_hierarchy_id
      => p_rec.pref_hierarchy_id
      ,p_type
      => p_rec.type
      ,p_name
      => p_rec.name
      ,p_business_group_id	     => p_rec.business_group_id
      ,p_legislation_code	     => p_rec.legislation_code
      ,p_parent_pref_hierarchy_id
      => p_rec.parent_pref_hierarchy_id
      ,p_edit_allowed
      => p_rec.edit_allowed
      ,p_displayed
      => p_rec.displayed
      ,p_pref_definition_id
      => p_rec.pref_definition_id
      ,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
      ,p_object_version_number
      => p_rec.object_version_number
      ,p_orig_pref_hierarchy_id
      => p_rec.orig_pref_hierarchy_id
      ,p_orig_parent_hierarchy_id
      => p_rec.orig_parent_hierarchy_id
      ,p_top_level_parent_id  --Performance Fix
      =>p_rec.top_level_parent_id
      ,p_code
      => p_rec.code
      );

Line: 450

End post_insert;

Line: 471

  hxc_hph_bus.insert_validate
     (p_effective_date
     ,p_rec
     );

Line: 478

  hxc_hph_ins.pre_insert(p_rec);

Line: 482

  hxc_hph_ins.insert_dml(p_rec);

Line: 486

  hxc_hph_ins.post_insert
     (p_effective_date
     ,p_rec
     );