APPS.GHR_NOAC_REMARKS_API SQL Statements

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

Line: 165

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 NOCOPY number
  ,p_effective_date                 in  date
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72);

Line: 188

  l_proc := g_package||'update_noac_remarks';

Line: 195

  savepoint update_noac_remarks;

Line: 214

    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: 230

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

Line: 255

    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: 271

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

Line: 300

    ROLLBACK TO update_noac_remarks;

Line: 313

    ROLLBACK TO update_noac_remarks;

Line: 317

end update_noac_remarks;

Line: 322

procedure delete_noac_remarks
  (p_validate                       in  boolean  default false
  ,p_noac_remark_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: 337

  l_proc := g_package||'update_noac_remarks';

Line: 343

  savepoint delete_noac_remarks;

Line: 356

    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: 366

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

Line: 385

    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: 395

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

Line: 420

    ROLLBACK TO delete_noac_remarks;

Line: 432

    ROLLBACK TO delete_noac_remarks;

Line: 436

end delete_noac_remarks;