APPS.HR_AUTHORIA_VARIABLEMAP_API SQL Statements

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

Line: 131

procedure UPDATE_VARIABLEMAP
  (p_validate                      in     boolean  default false
  ,p_ath_dsn                       in     varchar2
  ,p_ath_tablename                 in     varchar2
  ,p_ath_columnname                in     varchar2
  ,p_ath_varname                   in     varchar2
  ,p_ath_variablemap_id            in     number
  ,p_object_version_number         in out nocopy number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                  varchar2(72) := g_package||'UPDATE_VARIABLEMAP';

Line: 150

  savepoint UPDATE_VARIABLEMAP;

Line: 158

    HR_AUTHORIA_VARIABLEMAP_BK2.UPDATE_VARIABLEMAP_b
    (
     p_ath_variablemap_id            => p_ath_variablemap_id
    ,p_ath_dsn                       => p_ath_dsn
    ,p_ath_tablename                 => p_ath_tablename
    ,p_ath_columnname                => p_ath_columnname
    ,p_ath_varname                   => p_ath_varname
    ,p_object_version_number         => p_object_version_number
    );

Line: 171

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

Line: 192

    HR_AUTHORIA_VARIABLEMAP_BK2.UPDATE_VARIABLEMAP_a
    (
     p_ath_variablemap_id            => p_ath_variablemap_id
    ,p_ath_dsn                       => p_ath_dsn
    ,p_ath_tablename                 => p_ath_tablename
    ,p_ath_columnname                => p_ath_columnname
    ,p_ath_varname                   => p_ath_varname
    ,p_object_version_number         => p_object_version_number
    );

Line: 205

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

Line: 226

    rollback to UPDATE_VARIABLEMAP;

Line: 238

    rollback to UPDATE_VARIABLEMAP;

Line: 243

end UPDATE_VARIABLEMAP;

Line: 250

procedure DELETE_VARIABLEMAP
  (p_validate                      in     boolean  default false
  ,p_ath_variablemap_id            in     number
  ,p_object_version_number         in     number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                  varchar2(72) := g_package||
                                               'DELETE_VARIABLEMAP';

Line: 265

  savepoint DELETE_VARIABLEMAP;

Line: 275

    HR_AUTHORIA_VARIABLEMAP_BK3.DELETE_VARIABLEMAP_b
    (p_ath_variablemap_id            => p_ath_variablemap_id
    ,p_object_version_number         => p_object_version_number
    );

Line: 283

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

Line: 298

    HR_AUTHORIA_VARIABLEMAP_BK3.DELETE_VARIABLEMAP_a
    (p_ath_variablemap_id            => p_ath_variablemap_id
    ,p_object_version_number         => p_object_version_number
    );

Line: 306

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

Line: 323

    rollback to DELETE_VARIABLEMAP;

Line: 329

    rollback to DELETE_VARIABLEMAP;

Line: 332

end DELETE_VARIABLEMAP;