APPS.PER_OSE_INS SQL Statements

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

Line: 74

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

Line: 88

  insert into per_org_structure_elements
      (org_structure_element_id
      ,business_group_id
      ,organization_id_parent
      ,org_structure_version_id
      ,organization_id_child
      ,request_id
      ,program_application_id
      ,program_id
      ,program_update_date
      ,object_version_number
      ,position_control_enabled_flag
      )
  Values
    (p_rec.org_structure_element_id
    ,p_rec.business_group_id
    ,p_rec.organization_id_parent
    ,p_rec.org_structure_version_id
    ,p_rec.organization_id_child
    ,p_rec.request_id
    ,p_rec.program_application_id
    ,p_rec.program_id
    ,p_rec.program_update_date
    ,p_rec.object_version_number
    ,p_rec.position_control_enabled_flag
    );

Line: 137

End insert_dml;

Line: 176

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

Line: 182

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

Line: 195

End pre_insert;

Line: 229

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

Line: 239

    per_ose_rki.after_insert
      (p_org_structure_element_id
      => p_rec.org_structure_element_id
      ,p_business_group_id
      => p_rec.business_group_id
      ,p_organization_id_parent
      => p_rec.organization_id_parent
      ,p_org_structure_version_id
      => p_rec.org_structure_version_id
      ,p_organization_id_child
      => p_rec.organization_id_child
      ,p_request_id
      => p_rec.request_id
      ,p_program_application_id
      => p_rec.program_application_id
      ,p_program_id
      => p_rec.program_id
      ,p_program_update_date
      => p_rec.program_update_date
      ,p_object_version_number
      => p_rec.object_version_number
      ,p_pos_control_enabled_flag
      => p_rec.position_control_enabled_flag
      );

Line: 275

End post_insert;

Line: 292

  per_ose_bus.insert_validate
     (p_rec
     ,p_effective_date
     );

Line: 299

  per_ose_ins.pre_insert(p_rec);

Line: 303

  per_ose_ins.insert_dml(p_rec);

Line: 307

  per_ose_ins.post_insert
     (p_rec
     );

Line: 326

  ,p_program_update_date            in     date     default null
  ,p_pos_control_enabled_flag       in     varchar2 default null
  ,p_org_structure_element_id          out nocopy number
  ,p_object_version_number             out nocopy number
  ) is
--
  l_rec	  per_ose_shd.g_rec_type;

Line: 351

    ,p_program_update_date
    ,null
    ,p_pos_control_enabled_flag
    );