APPS.PSP_PRT_INS SQL Statements

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

Line: 75

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

Line: 89

  insert into psp_report_templates
      (template_id
      ,template_name
      ,business_group_id
      ,set_of_books_id
      ,object_version_number
      ,report_type
      ,period_frequency_id
      ,report_template_code
      ,display_all_emp_distrib_flag
      ,manual_entry_override_flag
      ,approval_type
      ,custom_approval_code
      ,sup_levels
      ,preview_effort_report_flag
      ,notification_reminder_in_days
      ,sprcd_tolerance_amt
      ,sprcd_tolerance_percent
      ,description
      ,legislation_code
      ,hundred_pcent_eff_at_per_asg
      ,selection_match_level
      )
  Values
    (p_rec.template_id
    ,p_rec.template_name
    ,p_rec.business_group_id
    ,p_rec.set_of_books_id
    ,p_rec.object_version_number
    ,p_rec.report_type
    ,p_rec.period_frequency_id
    ,p_rec.report_template_code
    ,p_rec.display_all_emp_distrib_flag
    ,p_rec.manual_entry_override_flag
    ,p_rec.approval_type
    ,p_rec.custom_approval_code
    ,p_rec.sup_levels
    ,p_rec.preview_effort_report_flag
    ,p_rec.notification_reminder_in_days
    ,p_rec.sprcd_tolerance_amt
    ,p_rec.sprcd_tolerance_percent
    ,p_rec.description
    ,p_rec.legislation_code
    ,p_rec.hundred_pcent_eff_at_per_asg
    ,p_rec.selection_match_level
    );

Line: 158

End insert_dml;

Line: 197

Procedure pre_insert
  (p_rec  in out nocopy psp_prt_shd.g_rec_type
  ) is
--
  Cursor C_Sel1 is select psp_report_templates_s.nextval from sys.dual;

Line: 204

    Select null
      from psp_report_templates
     where template_id =
             psp_prt_ins.g_template_id_i;

Line: 209

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

Line: 250

End pre_insert;

Line: 284

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

Line: 294

    psp_prt_rki.after_insert
      (p_template_id
      => p_rec.template_id
      ,p_template_name
      => p_rec.template_name
      ,p_business_group_id
      => p_rec.business_group_id
      ,p_set_of_books_id
      => p_rec.set_of_books_id
      ,p_object_version_number
      => p_rec.object_version_number
      ,p_report_type
      => p_rec.report_type
      ,p_period_frequency_id
      => p_rec.period_frequency_id
      ,p_report_template_code
      => p_rec.report_template_code
      ,p_display_all_emp_distrib_flag
      => p_rec.display_all_emp_distrib_flag
      ,p_manual_entry_override_flag
      => p_rec.manual_entry_override_flag
      ,p_approval_type
      => p_rec.approval_type
      ,p_custom_approval_code
      => p_rec.custom_approval_code
      ,p_sup_levels
      => p_rec.sup_levels
      ,p_preview_effort_report_flag
      => p_rec.preview_effort_report_flag
      ,p_notification_reminder_in_day
      => p_rec.notification_reminder_in_days
      ,p_sprcd_tolerance_amt
      => p_rec.sprcd_tolerance_amt
      ,p_sprcd_tolerance_percent
      => p_rec.sprcd_tolerance_percent
      ,p_description
      => p_rec.description
      ,p_legislation_code
      => p_rec.legislation_code
      ,p_hundred_pcent_eff_at_per_asg
      => p_rec.hundred_pcent_eff_at_per_asg
      ,p_selection_match_level
      => p_rec.selection_match_level
      );

Line: 350

End post_insert;

Line: 366

  psp_prt_bus.insert_validate
     (p_rec
     );

Line: 375

  psp_prt_ins.pre_insert(p_rec);

Line: 379

  psp_prt_ins.insert_dml(p_rec);

Line: 383

  psp_prt_ins.post_insert
     (p_rec
     );

Line: 406

  ,p_selection_match_level          in     varchar2
  ,p_display_all_emp_distrib_flag   in     varchar2 default null
  ,p_manual_entry_override_flag     in     varchar2 default null
  ,p_custom_approval_code           in     varchar2 default null
  ,p_sup_levels                     in     number   default null
  ,p_notification_reminder_in_day   in     number   default null
  ,p_sprcd_tolerance_amt            in     number   default null
  ,p_sprcd_tolerance_percent        in     number   default null
  ,p_description                    in     varchar2 default null
  ,p_legislation_code               in     varchar2 default null
  ,p_template_id                    in	   number
  ,p_object_version_number             out nocopy number
  ) is
--
  l_rec   psp_prt_shd.g_rec_type;

Line: 451

    ,p_selection_match_level
    );