APPS.PER_RVR_INS SQL Statements

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

Line: 75

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

Line: 89

  insert into per_ri_view_reports
      (workbench_item_code
      ,workbench_view_report_code
      ,workbench_view_report_type
      ,workbench_view_report_action
      ,workbench_view_country
      ,wb_view_report_instruction
      ,object_version_number
      ,primary_industry
      ,enabled_flag
      )
  Values
    (p_rec.workbench_item_code
    ,p_rec.workbench_view_report_code
    ,p_rec.workbench_view_report_type
    ,p_rec.workbench_view_report_action
    ,p_rec.workbench_view_country
    ,p_rec.wb_view_report_instruction
    ,p_rec.object_version_number
    ,p_rec.primary_industry
    ,p_rec.enabled_flag
    );

Line: 134

End insert_dml;

Line: 173

Procedure pre_insert
  (p_rec  in out nocopy per_rvr_shd.g_rec_type
  ) is

--
  Cursor C_Sel2 is
    Select null
      from per_ri_view_reports
     where workbench_view_report_code =
             per_rvr_ins.g_workbench_view_report_code_i;

Line: 184

  l_proc   varchar2(72) := g_package||'pre_insert';

Line: 224

End pre_insert;

Line: 258

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

Line: 268

    per_rvr_rki.after_insert
      (p_workbench_item_code           => p_rec.workbench_item_code
      ,p_workbench_view_report_code    => p_rec.workbench_view_report_code
      ,p_workbench_view_report_type    => p_rec.workbench_view_report_type
      ,p_workbench_view_report_action  => p_rec.workbench_view_report_action
      ,p_workbench_view_country        => p_rec.workbench_view_country
      ,p_wb_view_report_instruction    => p_rec.wb_view_report_instruction
      ,p_object_version_number         => p_rec.object_version_number
      ,p_primary_industry	           => p_rec.primary_industry
      ,p_enabled_flag                  => p_rec.enabled_flag
      );

Line: 291

End post_insert;

Line: 307

  per_rvr_bus.insert_validate
     (p_rec
     );

Line: 316

  per_rvr_ins.pre_insert(p_rec);

Line: 320

  per_rvr_ins.insert_dml(p_rec);

Line: 324

  per_rvr_ins.post_insert
     (p_rec
     );