APPS.HR_CTX_UPD SQL Statements

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

Line: 54

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

Line: 70

  update hr_ki_contexts
    set
     context_id                      = p_rec.context_id
    ,view_name                       = p_rec.view_name
    ,param_1                         = p_rec.param_1
    ,param_2                         = p_rec.param_2
    ,param_3                         = p_rec.param_3
    ,param_4                         = p_rec.param_4
    ,param_5                         = p_rec.param_5
    ,param_6                         = p_rec.param_6
    ,param_7                         = p_rec.param_7
    ,param_8                         = p_rec.param_8
    ,param_9                         = p_rec.param_9
    ,param_10                        = p_rec.param_10
    ,param_11                        = p_rec.param_11
    ,param_12                        = p_rec.param_12
    ,param_13                        = p_rec.param_13
    ,param_14                        = p_rec.param_14
    ,param_15                        = p_rec.param_15
    ,param_16                        = p_rec.param_16
    ,param_17                        = p_rec.param_17
    ,param_18                        = p_rec.param_18
    ,param_19                        = p_rec.param_19
    ,param_20                        = p_rec.param_20
    ,param_21                        = p_rec.param_21
    ,param_22                        = p_rec.param_22
    ,param_23                        = p_rec.param_23
    ,param_24                        = p_rec.param_24
    ,param_25                        = p_rec.param_25
    ,param_26                        = p_rec.param_26
    ,param_27                        = p_rec.param_27
    ,param_28                        = p_rec.param_28
    ,param_29                        = p_rec.param_29
    ,param_30                        = p_rec.param_30
    ,object_version_number           = p_rec.object_version_number
    where context_id = p_rec.context_id;

Line: 130

End update_dml;

Line: 164

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

Line: 174

End pre_update;

Line: 208

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

Line: 218

    hr_ctx_rku.after_update
      (p_context_id
      => p_rec.context_id
      ,p_view_name
      => p_rec.view_name
      ,p_param_1
      => p_rec.param_1
      ,p_param_2
      => p_rec.param_2
      ,p_param_3
      => p_rec.param_3
      ,p_param_4
      => p_rec.param_4
      ,p_param_5
      => p_rec.param_5
      ,p_param_6
      => p_rec.param_6
      ,p_param_7
      => p_rec.param_7
      ,p_param_8
      => p_rec.param_8
      ,p_param_9
      => p_rec.param_9
      ,p_param_10
      => p_rec.param_10
      ,p_param_11
      => p_rec.param_11
      ,p_param_12
      => p_rec.param_12
      ,p_param_13
      => p_rec.param_13
      ,p_param_14
      => p_rec.param_14
      ,p_param_15
      => p_rec.param_15
      ,p_param_16
      => p_rec.param_16
      ,p_param_17
      => p_rec.param_17
      ,p_param_18
      => p_rec.param_18
      ,p_param_19
      => p_rec.param_19
      ,p_param_20
      => p_rec.param_20
      ,p_param_21
      => p_rec.param_21
      ,p_param_22
      => p_rec.param_22
      ,p_param_23
      => p_rec.param_23
      ,p_param_24
      => p_rec.param_24
      ,p_param_25
      => p_rec.param_25
      ,p_param_26
      => p_rec.param_26
      ,p_param_27
      => p_rec.param_27
      ,p_param_28
      => p_rec.param_28
      ,p_param_29
      => p_rec.param_29
      ,p_param_30
      => p_rec.param_30
      ,p_object_version_number
      => p_rec.object_version_number
      ,p_view_name_o
      => hr_ctx_shd.g_old_rec.view_name
      ,p_param_1_o
      => hr_ctx_shd.g_old_rec.param_1
      ,p_param_2_o
      => hr_ctx_shd.g_old_rec.param_2
      ,p_param_3_o
      => hr_ctx_shd.g_old_rec.param_3
      ,p_param_4_o
      => hr_ctx_shd.g_old_rec.param_4
      ,p_param_5_o
      => hr_ctx_shd.g_old_rec.param_5
      ,p_param_6_o
      => hr_ctx_shd.g_old_rec.param_6
      ,p_param_7_o
      => hr_ctx_shd.g_old_rec.param_7
      ,p_param_8_o
      => hr_ctx_shd.g_old_rec.param_8
      ,p_param_9_o
      => hr_ctx_shd.g_old_rec.param_9
      ,p_param_10_o
      => hr_ctx_shd.g_old_rec.param_10
      ,p_param_11_o
      => hr_ctx_shd.g_old_rec.param_11
      ,p_param_12_o
      => hr_ctx_shd.g_old_rec.param_12
      ,p_param_13_o
      => hr_ctx_shd.g_old_rec.param_13
      ,p_param_14_o
      => hr_ctx_shd.g_old_rec.param_14
      ,p_param_15_o
      => hr_ctx_shd.g_old_rec.param_15
      ,p_param_16_o
      => hr_ctx_shd.g_old_rec.param_16
      ,p_param_17_o
      => hr_ctx_shd.g_old_rec.param_17
      ,p_param_18_o
      => hr_ctx_shd.g_old_rec.param_18
      ,p_param_19_o
      => hr_ctx_shd.g_old_rec.param_19
      ,p_param_20_o
      => hr_ctx_shd.g_old_rec.param_20
      ,p_param_21_o
      => hr_ctx_shd.g_old_rec.param_21
      ,p_param_22_o
      => hr_ctx_shd.g_old_rec.param_22
      ,p_param_23_o
      => hr_ctx_shd.g_old_rec.param_23
      ,p_param_24_o
      => hr_ctx_shd.g_old_rec.param_24
      ,p_param_25_o
      => hr_ctx_shd.g_old_rec.param_25
      ,p_param_26_o
      => hr_ctx_shd.g_old_rec.param_26
      ,p_param_27_o
      => hr_ctx_shd.g_old_rec.param_27
      ,p_param_28_o
      => hr_ctx_shd.g_old_rec.param_28
      ,p_param_29_o
      => hr_ctx_shd.g_old_rec.param_29
      ,p_param_30_o
      => hr_ctx_shd.g_old_rec.param_30
      ,p_object_version_number_o
      => hr_ctx_shd.g_old_rec.object_version_number
      );

Line: 362

End post_update;

Line: 571

  hr_ctx_bus.update_validate
     (p_rec
     );

Line: 580

  hr_ctx_upd.pre_update(p_rec);

Line: 584

  hr_ctx_upd.update_dml(p_rec);

Line: 588

  hr_ctx_upd.post_update
     (p_rec
     );