APPS.GHR_NOAC_REMARKS_API SQL Statements

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

Line: 161

procedure update_noac_remarks
  (p_validate                       in  boolean   default false
  ,p_noac_remark_id                 in  number
  ,p_nature_of_action_id            in  number    default hr_api.g_number
  ,p_remark_id                      in  number    default hr_api.g_number
  ,p_required_flag                  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 number
  ,p_effective_date                 in  date
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'update_noac_remarks';

Line: 187

  savepoint update_noac_remarks;

Line: 206

    ghr_noac_remarks_bk2.update_noac_remarks_b
      (
       p_noac_remark_id                 =>  p_noac_remark_id
      ,p_nature_of_action_id            =>  p_nature_of_action_id
      ,p_remark_id                      =>  p_remark_id
      ,p_required_flag                  =>  p_required_flag
      ,p_enabled_flag                   =>  p_enabled_flag
      ,p_date_from                      =>  l_date_from
      ,p_date_to                        =>  p_date_to
      ,p_object_version_number          =>  p_object_version_number
    ,p_effective_date                 => trunc(p_effective_date)
      );

Line: 221

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

Line: 246

    ghr_noac_remarks_bk2.update_noac_remarks_a
      (
       p_noac_remark_id                 =>  p_noac_remark_id
      ,p_nature_of_action_id            =>  p_nature_of_action_id
      ,p_remark_id                      =>  p_remark_id
      ,p_required_flag                  =>  p_required_flag
      ,p_enabled_flag                   =>  p_enabled_flag
      ,p_date_from                      =>  l_date_from
      ,p_date_to                        =>  p_date_to
      ,p_object_version_number          =>  l_object_version_number
      ,p_effective_date                => trunc(p_effective_date)
      );

Line: 261

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

Line: 290

    ROLLBACK TO update_noac_remarks;

Line: 302

    ROLLBACK TO update_noac_remarks;

Line: 305

end update_noac_remarks;

Line: 310

procedure delete_noac_remarks
  (p_validate                       in  boolean  default false
  ,p_noac_remark_id                 in  number
  ,p_object_version_number          in out number
  ,p_effective_date                 in  date
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'update_noac_remarks';

Line: 328

  savepoint delete_noac_remarks;

Line: 341

    ghr_noac_remarks_bk3.delete_noac_remarks_b
      (
       p_noac_remark_id                 =>  p_noac_remark_id
      ,p_object_version_number          =>  p_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
      );

Line: 350

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

Line: 369

    ghr_noac_remarks_bk3.delete_noac_remarks_a
      (
       p_noac_remark_id                 =>  p_noac_remark_id
      ,p_object_version_number          =>  l_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
      );

Line: 378

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

Line: 403

    ROLLBACK TO delete_noac_remarks;

Line: 414

    ROLLBACK TO delete_noac_remarks;

Line: 417

end delete_noac_remarks;