APPS.PER_CEI_INS SQL Statements

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

Line: 53

Procedure insert_dml
  (p_rec in out nocopy per_cei_shd.g_rec_type
  ) is
  --
  l_proc  varchar2(72) := g_package||'insert_dml';

Line: 60

  l_last_update_date    per_cagr_entitlement_items.last_update_date%TYPE;

Line: 61

  l_last_updated_by     per_cagr_entitlement_items.last_updated_by%TYPE;

Line: 62

  l_last_update_login   per_cagr_entitlement_items.last_update_login%TYPE;

Line: 74

  l_last_update_date   := sysdate;

Line: 75

  l_last_updated_by    := fnd_global.user_id;

Line: 76

  l_last_update_login  := fnd_global.login_id;

Line: 80

  insert into per_cagr_entitlement_items
      (cagr_entitlement_item_id
      ,item_name
      ,element_type_id
      ,input_value_id
	  ,column_type
	  ,column_size
      ,legislation_code
      ,beneficial_rule
      ,cagr_api_id
      ,cagr_api_param_id
      ,business_group_id
      ,category_name
      ,uom
      ,flex_value_set_id
      ,beneficial_formula_id
      ,created_by
      ,creation_date
      ,last_update_date
      ,last_updated_by
      ,last_update_login
      ,object_version_number
      ,beneficial_rule_value_set_id
      ,multiple_entries_allowed_flag
      ,auto_create_entries_flag -- CEI Enh
      ,opt_id
      )
  Values
    (p_rec.cagr_entitlement_item_id
    ,p_rec.item_name
    ,p_rec.element_type_id
    ,p_rec.input_value_id
	,p_rec.column_type
	,p_rec.column_size
    ,p_rec.legislation_code
    ,p_rec.beneficial_rule
    ,p_rec.cagr_api_id
    ,p_rec.cagr_api_param_id
    ,p_rec.business_group_id
    ,p_rec.category_name
    ,p_rec.uom
    ,p_rec.flex_value_set_id
    ,p_rec.beneficial_formula_id
    ,l_created_by
    ,l_creation_date
    ,l_last_update_date
    ,l_last_updated_by
    ,l_last_update_login
    ,p_rec.object_version_number
    ,p_rec.ben_rule_value_set_id
    ,p_rec.mult_entries_allowed_flag
    ,p_rec.auto_create_entries_flag -- CEI Enh
    ,p_rec.opt_id
    );

Line: 157

End insert_dml;

Line: 196

Procedure pre_insert
  (p_rec  in out nocopy per_cei_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'pre_insert';

Line: 202

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

Line: 216

End pre_insert;

Line: 250

Procedure post_insert
  (p_effective_date               in date
  ,p_rec                          in per_cei_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'post_insert';

Line: 263

    per_cei_rki.after_insert
      (p_effective_date              => p_effective_date
      ,p_cagr_entitlement_item_id    => p_rec.cagr_entitlement_item_id
      ,p_item_name                   => p_rec.item_name
      ,p_element_type_id             => p_rec.element_type_id
      ,p_input_value_id              => p_rec.input_value_id
      ,p_column_type                 => p_rec.column_type
      ,p_column_size                 => p_rec.column_size
      ,p_legislation_code            => p_rec.legislation_code
      ,p_cagr_api_id                 => p_rec.cagr_api_id
      ,p_cagr_api_param_id           => p_rec.cagr_api_param_id
      ,p_beneficial_formula_id       => p_rec.beneficial_formula_id
      ,p_business_group_id           => p_rec.business_group_id
      ,p_beneficial_rule             => p_rec.beneficial_rule
      ,p_category_name               => p_rec.category_name
      ,p_uom                         => p_rec.uom
      ,p_flex_value_set_id           => p_rec.flex_value_set_id
      ,p_object_version_number       => p_rec.object_version_number
      ,p_ben_rule_value_set_id       => p_rec.ben_rule_value_set_id
      ,p_mult_entries_allowed_flag   => p_rec.mult_entries_allowed_flag
      ,p_auto_create_entries_flag    => p_rec.auto_create_entries_flag -- CEI Enh
      ,p_opt_id                      => p_rec.opt_id
      );

Line: 298

End post_insert;

Line: 315

  per_cei_bus.insert_validate
     (p_effective_date
     ,p_rec
     );

Line: 322

  per_cei_ins.pre_insert(p_rec);

Line: 326

  per_cei_ins.insert_dml(p_rec);

Line: 330

  per_cei_ins.post_insert
     (p_effective_date
     ,p_rec
     );