APPS.PAY_CNU_INS SQL Statements

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

Line: 53

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

Line: 67

  insert into pay_fr_contribution_usages
      (contribution_usage_id
      ,date_from
      ,date_to
      ,group_code
      ,process_type
      ,element_name
      ,rate_type
      ,contribution_code
      ,retro_contribution_code
      ,contribution_type
      ,contribution_usage_type
      ,rate_category
      ,business_group_id
      ,object_version_number
	  ,code_rate_id
      )
  Values
    (p_rec.contribution_usage_id
    ,p_rec.date_from
    ,p_rec.date_to
    ,p_rec.group_code
    ,p_rec.process_type
    ,p_rec.element_name
    ,p_rec.rate_type
    ,p_rec.contribution_code
    ,p_rec.retro_contribution_code
    ,p_rec.contribution_type
    ,p_rec.contribution_usage_type
    ,p_rec.rate_category
    ,p_rec.business_group_id
    ,p_rec.object_version_number
	,p_rec.code_rate_id
    );

Line: 124

End insert_dml;

Line: 163

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

Line: 169

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

Line: 182

End pre_insert;

Line: 216

Procedure post_insert
  (p_rec                          in pay_cnu_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'post_insert';

Line: 226

    PAY_cnu_RKI.AFTER_INSERT(
       p_contribution_usage_id     => p_rec.contribution_usage_id
      ,p_date_from               => p_rec.date_from
      ,p_date_to                 => p_rec.date_to
      ,p_group_code              => p_rec.group_code
      ,p_process_type            => p_rec.process_type
      ,p_element_name            => p_rec.element_name
      ,p_rate_type               => p_rec.rate_type
      ,p_contribution_code       => p_rec.contribution_code
      ,p_retro_contribution_code => p_rec.retro_contribution_code
      ,p_contribution_type       => p_rec.contribution_type
      ,p_contribution_usage_type => p_rec.contribution_usage_type
      ,p_rate_category           => p_rec.rate_category
      ,p_business_group_id       => p_rec.business_group_id
      ,p_object_version_number   => p_rec.object_version_number
	  ,p_code_rate_id            => p_rec.code_Rate_id
      );

Line: 255

End post_insert;

Line: 273

  pay_cnu_bus.insert_validate
     (p_effective_date
     ,p_rec
     ,l_code_rate_id
     );

Line: 285

  pay_cnu_ins.pre_insert(p_rec);

Line: 289

  pay_cnu_ins.insert_dml(p_rec);

Line: 293

  pay_cnu_ins.post_insert
     (p_rec
     );