APPS.HR_ICX_INS SQL Statements

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

Line: 55

  SELECT id_flex_num
  FROM fnd_id_flex_structures
  WHERE id_flex_structure_code = p_context_type
  AND application_id = 800
  AND id_flex_code = 'ICX';

Line: 215

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

Line: 229

  insert into hr_item_contexts
      (item_context_id
      ,object_version_number
      ,id_flex_num
      ,summary_flag
      ,enabled_flag
      ,start_date_active
      ,end_date_active
      ,segment1
      ,segment2
      ,segment3
      ,segment4
      ,segment5
      ,segment6
      ,segment7
      ,segment8
      ,segment9
      ,segment10
      ,segment11
      ,segment12
      ,segment13
      ,segment14
      ,segment15
      ,segment16
      ,segment17
      ,segment18
      ,segment19
      ,segment20
      ,segment21
      ,segment22
      ,segment23
      ,segment24
      ,segment25
      ,segment26
      ,segment27
      ,segment28
      ,segment29
      ,segment30
      )
  Values
    (p_rec.item_context_id
    ,p_rec.object_version_number
    ,p_rec.id_flex_num
    ,p_rec.summary_flag
    ,p_rec.enabled_flag
    ,p_rec.start_date_active
    ,p_rec.end_date_active
    ,p_rec.segment1
    ,p_rec.segment2
    ,p_rec.segment3
    ,p_rec.segment4
    ,p_rec.segment5
    ,p_rec.segment6
    ,p_rec.segment7
    ,p_rec.segment8
    ,p_rec.segment9
    ,p_rec.segment10
    ,p_rec.segment11
    ,p_rec.segment12
    ,p_rec.segment13
    ,p_rec.segment14
    ,p_rec.segment15
    ,p_rec.segment16
    ,p_rec.segment17
    ,p_rec.segment18
    ,p_rec.segment19
    ,p_rec.segment20
    ,p_rec.segment21
    ,p_rec.segment22
    ,p_rec.segment23
    ,p_rec.segment24
    ,p_rec.segment25
    ,p_rec.segment26
    ,p_rec.segment27
    ,p_rec.segment28
    ,p_rec.segment29
    ,p_rec.segment30
    );

Line: 330

End insert_dml;

Line: 369

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

Line: 375

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

Line: 388

End pre_insert;

Line: 422

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

Line: 433

    hr_icx_rki.after_insert
      (p_effective_date              => p_effective_date
      ,p_object_version_number
      => p_rec.object_version_number
      ,p_item_context_id
      => p_rec.item_context_id
      ,p_id_flex_num
      => p_rec.id_flex_num
      ,p_summary_flag
      => p_rec.summary_flag
      ,p_enabled_flag
      => p_rec.enabled_flag
      ,p_start_date_active
      => p_rec.start_date_active
      ,p_end_date_active
      => p_rec.end_date_active
      ,p_segment1
      => p_rec.segment1
      ,p_segment2
      => p_rec.segment2
      ,p_segment3
      => p_rec.segment3
      ,p_segment4
      => p_rec.segment4
      ,p_segment5
      => p_rec.segment5
      ,p_segment6
      => p_rec.segment6
      ,p_segment7
      => p_rec.segment7
      ,p_segment8
      => p_rec.segment8
      ,p_segment9
      => p_rec.segment9
      ,p_segment10
      => p_rec.segment10
      ,p_segment11
      => p_rec.segment11
      ,p_segment12
      => p_rec.segment12
      ,p_segment13
      => p_rec.segment13
      ,p_segment14
      => p_rec.segment14
      ,p_segment15
      => p_rec.segment15
      ,p_segment16
      => p_rec.segment16
      ,p_segment17
      => p_rec.segment17
      ,p_segment18
      => p_rec.segment18
      ,p_segment19
      => p_rec.segment19
      ,p_segment20
      => p_rec.segment20
      ,p_segment21
      => p_rec.segment21
      ,p_segment22
      => p_rec.segment22
      ,p_segment23
      => p_rec.segment23
      ,p_segment24
      => p_rec.segment24
      ,p_segment25
      => p_rec.segment25
      ,p_segment26
      => p_rec.segment26
      ,p_segment27
      => p_rec.segment27
      ,p_segment28
      => p_rec.segment28
      ,p_segment29
      => p_rec.segment29
      ,p_segment30
      => p_rec.segment30
      );

Line: 522

End post_insert;

Line: 539

  hr_icx_bus.insert_validate
     (p_effective_date
     ,p_rec
     );

Line: 546

  hr_icx_ins.pre_insert(p_rec);

Line: 550

  hr_icx_ins.insert_dml(p_rec);

Line: 554

  hr_icx_ins.post_insert
     (p_effective_date
     ,p_rec
     );