APPS.GHR_NOAC_LAS_API SQL Statements

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

Line: 160

procedure update_noac_las
  (p_validate                       in  boolean   default false
  ,p_noac_la_id                     in  number
  ,p_nature_of_action_id            in  number    default hr_api.g_number
  ,p_lac_lookup_code                in  varchar2  default hr_api.g_varchar2
  ,p_enabled_flag                   in  varchar2  default hr_api.g_varchar2
  ,p_date_from                      in  date      default hr_api.g_date
  ,p_date_to                        in  date      default hr_api.g_date
  ,p_object_version_number          in out NOCOPY number
  ,p_valid_first_lac_flag           in  varchar2  default hr_api.g_varchar2
  ,p_valid_second_lac_flag          in  varchar2  default hr_api.g_varchar2
  ,p_effective_date                 in  date
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) ;

Line: 182

  l_proc  := g_package||'update_noac_las';

Line: 188

  savepoint update_noac_las;

Line: 202

    ghr_noac_las_bk2.update_noac_las_b
      (
       p_noac_la_id                     =>  p_noac_la_id
      ,p_nature_of_action_id            =>  p_nature_of_action_id
      ,p_lac_lookup_code                =>  p_lac_lookup_code
      ,p_enabled_flag                   =>  p_enabled_flag
      ,p_date_from                      =>  p_date_from
      ,p_date_to                        =>  p_date_to
      ,p_object_version_number          =>  p_object_version_number
      ,p_valid_first_lac_flag           =>  p_valid_first_lac_flag
      ,p_valid_second_lac_flag          =>  p_valid_second_lac_flag
    ,p_effective_date                 => trunc(p_effective_date)
      );

Line: 219

        (p_module_name => 'UPDATE_noac_las'
        ,p_hook_type   => 'BP'
        );

Line: 245

    ghr_noac_las_bk2.update_noac_las_a
      (
       p_noac_la_id                     =>  p_noac_la_id
      ,p_nature_of_action_id            =>  p_nature_of_action_id
      ,p_lac_lookup_code                =>  p_lac_lookup_code
      ,p_enabled_flag                   =>  p_enabled_flag
      ,p_date_from                      =>  p_date_from
      ,p_date_to                        =>  p_date_to
      ,p_object_version_number          =>  l_object_version_number
      ,p_valid_first_lac_flag           =>  p_valid_first_lac_flag
      ,p_valid_second_lac_flag          =>  p_valid_second_lac_flag
      ,p_effective_date                => trunc(p_effective_date)
      );

Line: 262

        (p_module_name => 'UPDATE_noac_las'
        ,p_hook_type   => 'AP'
        );

Line: 291

    ROLLBACK TO update_noac_las;

Line: 304

    ROLLBACK TO update_noac_las;

Line: 308

end update_noac_las;

Line: 313

procedure delete_noac_las
  (p_validate                       in  boolean  default false
  ,p_noac_la_id                     in  number
  ,p_object_version_number          in out NOCOPY number
  ,p_effective_date                 in  date
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) ;

Line: 328

  l_proc  := g_package||'update_noac_las';

Line: 333

  savepoint delete_noac_las;

Line: 347

    ghr_noac_las_bk3.delete_noac_las_b
      (
       p_noac_la_id                     =>  p_noac_la_id
      ,p_object_version_number          =>  p_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
      );

Line: 357

        (p_module_name => 'DELETE_noac_las'
        ,p_hook_type   => 'BP'
        );

Line: 376

    ghr_noac_las_bk3.delete_noac_las_a
      (
       p_noac_la_id                     =>  p_noac_la_id
      ,p_object_version_number          =>  l_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
      );

Line: 386

        (p_module_name => 'DELETE_noac_las'
        ,p_hook_type   => 'AP'
        );

Line: 411

    ROLLBACK TO delete_noac_las;

Line: 423

    ROLLBACK TO delete_noac_las;

Line: 427

end delete_noac_las;