DBA Data[Home] [Help]

APPS.DT_CLIENT_SUPPORT_UTILITY SQL Statements

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

Line: 19

procedure get_update_mode_list
  (p_effective_date                in     date
  ,p_package_name                  in     varchar2
  ,p_procedure_name                in     varchar2
  ,p_base_key_value                in     number
  ,p_correction                       out nocopy boolean
  ,p_update                           out nocopy boolean
  ,p_update_override                  out nocopy boolean
  ,p_update_change_insert             out nocopy boolean
  ) is
  --
  -- Local constants
  --
  c_out_len constant integer := 6;      -- Value must correspond to the length
Line: 43

  l_update               varchar2(6);   -- Char version of boolean OUT value
Line: 44

  l_update_override      varchar2(6);   -- Char version of boolean OUT value
Line: 45

  l_update_change_insert varchar2(6);   -- Char version of boolean OUT value
Line: 47

  l_proc                 varchar2(72) := g_package||'get_update_mode_list';
Line: 61

              'l_update               boolean; '                          ||
Line: 62

              'l_update_override      boolean; '                          ||
Line: 63

              'l_update_change_insert boolean; '                          ||
Line: 68

              ',p_update               =>l_update '                       ||
              ',p_update_override      =>l_update_override '              ||
              ',p_update_change_insert =>l_update_change_insert '         ||
              '); '                                                       ||
Line: 77

              'if l_update then '                                         ||
              ' :update := '||''''||g_true_str||''''||'; '                ||
Line: 80

              ' :update := '||''''||g_false_str||''''||'; '               ||
Line: 82

              'if l_update_override then '                                ||
              ' :update_override := '||''''||g_true_str||''''||'; '       ||
Line: 85

              ' :update_override := '||''''||g_false_str||''''||'; '      ||
Line: 87

              'if l_update_change_insert then '                           ||
              ' :update_change_insert := '||''''||g_true_str||''''||'; '  ||
Line: 90

              ' :update_change_insert := '||''''||g_false_str||''''||'; ' ||
Line: 117

  dbms_sql.bind_variable(l_cursor, ':update', l_update, c_out_len);
Line: 118

  dbms_sql.bind_variable(l_cursor, ':update_override'
                        ,l_update_override, c_out_len);
Line: 120

  dbms_sql.bind_variable(l_cursor, ':update_change_insert'
                        ,l_update_change_insert, c_out_len);
Line: 131

  dbms_sql.variable_value(l_cursor, ':update', l_update);
Line: 132

  dbms_sql.variable_value(l_cursor, ':update_override', l_update_override);
Line: 133

  dbms_sql.variable_value(l_cursor, ':update_change_insert'
                         ,l_update_change_insert);
Line: 151

  if l_update = g_true_str then
    p_update := true;
Line: 154

    p_update := false;
Line: 157

  if l_update_override = g_true_str then
    p_update_override := true;
Line: 160

    p_update_override := false;
Line: 163

  if l_update_change_insert = g_true_str then
    p_update_change_insert := true;
Line: 166

    p_update_change_insert := false;
Line: 179

end get_update_mode_list;
Line: 185

procedure get_delete_mode_list
  (p_effective_date                in     date
  ,p_package_name                  in     varchar2
  ,p_procedure_name                in     varchar2
  ,p_base_key_value                in     number
  ,p_zap                              out nocopy boolean
  ,p_delete                           out nocopy boolean
  ,p_future_change                    out nocopy boolean
  ,p_delete_next_change               out nocopy boolean
  ) is
  --
  -- Local constants
  --
  c_out_len constant integer := 6;      -- Value must correspond to the length
Line: 209

  l_delete               varchar2(6);   -- Char version of boolean OUT value
Line: 211

  l_delete_next_change   varchar2(6);   -- Char version of boolean OUT value
Line: 213

  l_proc                 varchar2(72) := g_package||'get_delete_mode_list';
Line: 227

              'l_delete               boolean; '                        ||
Line: 229

              'l_delete_next_change   boolean; '                        ||
Line: 234

              ',p_delete               =>l_delete '                     ||
              ',p_future_change        =>l_future_change '              ||
              ',p_delete_next_change   =>l_delete_next_change '         ||
              '); '                                                     ||
Line: 243

              'if l_delete then '                                       ||
              ' :delete := '||''''||g_true_str||''''||'; '              ||
Line: 246

              ' :delete := '||''''||g_false_str||''''||'; '             ||
Line: 253

              'if l_delete_next_change then '                           ||
              ' :delete_next_change := '||''''||g_true_str||''''||'; '  ||
Line: 256

              ' :delete_next_change := '||''''||g_false_str||''''||'; ' ||
Line: 283

  dbms_sql.bind_variable(l_cursor, ':delete', l_delete, c_out_len);
Line: 286

  dbms_sql.bind_variable(l_cursor, ':delete_next_change'
                        ,l_delete_next_change, c_out_len);
Line: 297

  dbms_sql.variable_value(l_cursor, ':delete', l_delete);
Line: 299

  dbms_sql.variable_value(l_cursor, ':delete_next_change'
                         ,l_delete_next_change);
Line: 317

  if l_delete = g_true_str then
    p_delete := true;
Line: 320

    p_delete := false;
Line: 329

  if l_delete_next_change = g_true_str then
    p_delete_next_change := true;
Line: 332

    p_delete_next_change := false;
Line: 345

end get_delete_mode_list;
Line: 469

procedure get_update_modes_and_dates
  (p_effective_date                in     date
  ,p_package_name                  in     varchar2
  ,p_procedure_name                in     varchar2
  ,p_base_key_value                in     number
  ,p_correction                    out nocopy number
  ,p_update                        out nocopy number
  ,p_update_override               out nocopy number
  ,p_update_change_insert          out nocopy number
  ,p_correction_start_date         out nocopy date
  ,p_correction_end_date           out nocopy date
  ,p_update_start_date             out nocopy date
  ,p_update_end_date               out nocopy date
  ,p_override_start_date           out nocopy date
  ,p_override_end_date             out nocopy date
  ,p_upd_chg_start_date            out nocopy date
  ,p_upd_chg_end_date              out nocopy date
  ) IS
 --
  -- Local variables
  --
  l_cursor               integer;       -- Dynamic sql cursor identifier
Line: 495

  l_proc                 varchar2(72) := g_package||'get_update_modes_and_dates';
Line: 504

              ' l_update                   BOOLEAN; '                     ||
Line: 505

              ' l_update_override          BOOLEAN; '                     ||
Line: 506

              ' l_update_change_insert     BOOLEAN; '                     ||
Line: 512

              ',p_update               => l_update '                      ||
              ',p_update_override      => l_update_override '             ||
              ',p_update_change_insert => l_update_change_insert '        ||
              ',p_correction_start_date => :p_correction_start_date '     ||
              ',p_correction_end_date   => :p_correction_end_date '       ||
              ',p_update_start_date     => :p_update_start_date '         ||
              ',p_update_end_date       => :p_update_end_date '           ||
              ',p_override_start_date   => :p_override_start_date '       ||
              ',p_override_end_date     => :p_override_end_date '         ||
              ',p_upd_chg_start_date    => :p_upd_chg_start_date '        ||
              ',p_upd_chg_end_date      => :p_upd_chg_end_date '          ||
              '); '                                                       ||
Line: 527

              ':p_update    := hr_api.boolean_to_constant(l_update); '    ||
Line: 528

              ':p_update_override
                 := hr_api.boolean_to_constant(l_update_override); '      ||
Line: 530

              ':p_update_change_insert
                 := hr_api.boolean_to_constant(l_update_change_insert); ' ||
Line: 545

                                 OUT  p_update_start_date,
                                 OUT  p_update_end_date,
                                 OUT  p_override_start_date,
                                 OUT  p_override_end_date,
                                 OUT  p_upd_chg_start_date,
                                 OUT  p_upd_chg_end_date,
                                 OUT  p_correction,
                                 OUT  p_update,
                                 OUT  p_update_override,
                                 OUT  p_update_change_insert;
Line: 565

end get_update_modes_and_dates;
Line: 571

procedure get_delete_modes_and_dates
  (p_effective_date                in     date
  ,p_package_name                  in     varchar2
  ,p_procedure_name                in     varchar2
  ,p_base_key_value                in     number
  ,p_zap                           out nocopy number
  ,p_delete                        out nocopy number
  ,p_future_change                 out nocopy number
  ,p_delete_next_change            out nocopy number
  ,p_zap_start_date                out nocopy date
  ,p_zap_end_date                  out nocopy date
  ,p_delete_start_date             out nocopy date
  ,p_delete_end_date               out nocopy date
  ,p_del_future_start_date         out nocopy date
  ,p_del_future_end_date           out nocopy date
  ,p_del_next_start_date           out nocopy date
  ,p_del_next_end_date             out nocopy date
  )   IS
  --
  -- Local variables
  --
  l_cursor               integer;       -- Dynamic sql cursor identifier
Line: 596

  l_proc                 varchar2(72) := g_package||'get_delete_modes_and_dates';
Line: 605

              ' l_delete               BOOLEAN; '                        ||
Line: 607

              ' l_delete_next_change   BOOLEAN; '                        ||
Line: 612

              ',p_delete               => l_delete '                     ||
              ',p_future_change        => l_future_change '              ||
              ',p_delete_next_change   => l_delete_next_change '         ||
              ',p_zap_start_date       => :p_zap_start_date '            ||
              ',p_zap_end_date         => :p_zap_end_date '              ||
              ',p_del_future_start_date =>:p_del_future_start_date '     ||
              ',p_del_future_end_date   => :p_del_future_end_date '      ||
              ',p_delete_start_date    => :p_delete_start_date '         ||
              ',p_delete_end_date      => :p_delete_end_date '           ||
              ',p_del_next_start_date   => :p_del_next_start_date '      ||
              ',p_del_next_end_date     => :p_del_next_end_date '        ||
              '); '                                                      ||
Line: 625

              ':p_delete     := hr_api.boolean_to_constant(l_delete); '  ||
Line: 627

     ':p_delete_next_change :=
                    hr_api.boolean_to_constant(l_delete_next_change); '  ||
Line: 643

                                 OUT  p_delete_start_date,
                                 OUT  p_delete_end_date,
                                 OUT  p_del_next_start_date,
                                 OUT  p_del_next_end_date,
                                 OUT  p_zap,
                                 OUT  p_delete,
                                 OUT  p_future_change,
                                 OUT  p_delete_next_change;
Line: 661

end get_delete_modes_and_dates;