APPS.HR_AUTHORIA_MAPPING_API SQL Statements

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

Line: 132

procedure UPDATE_AUTHORIA_MAPPING
  (p_validate                      in     boolean  default false
  ,p_target_page                   in     varchar2
  ,p_authoria_mapping_id           in     number
  ,p_pl_id                         in     number
  ,p_plip_id                       in     number  default HR_API.G_number
  ,p_open_enrollment_flag          in     varchar2
  ,p_object_version_number         in out NOCOPY number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                  varchar2(72) := g_package||'UPDATE_AUTHORIA_MAPPING';

Line: 151

  savepoint UPDATE_AUTHORIA_MAPPING;

Line: 159

    HR_AUTHORIA_MAPPING_BK2.UPDATE_AUTHORIA_MAPPING_b
    (
     p_authoria_mapping_id           => p_authoria_mapping_id
    ,p_pl_id                         => p_pl_id
    ,p_plip_id                       => p_plip_id
    ,p_open_enrollment_flag          => p_open_enrollment_flag
    ,p_target_page                   => p_target_page
    ,p_object_version_number         => p_object_version_number
    );

Line: 172

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

Line: 193

    HR_AUTHORIA_MAPPING_BK2.UPDATE_AUTHORIA_MAPPING_a
    (
     p_authoria_mapping_id           => p_authoria_mapping_id
    ,p_pl_id                         => p_pl_id
    ,p_plip_id                       => p_plip_id
    ,p_open_enrollment_flag          => p_open_enrollment_flag
    ,p_target_page                   => p_target_page
    ,p_object_version_number         => p_object_version_number
    );

Line: 206

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

Line: 227

    rollback to UPDATE_AUTHORIA_MAPPING;

Line: 239

    rollback to UPDATE_AUTHORIA_MAPPING;

Line: 243

end UPDATE_AUTHORIA_MAPPING;

Line: 250

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

Line: 265

  savepoint DELETE_AUTHORIA_MAPPING;

Line: 275

    HR_AUTHORIA_MAPPING_BK3.DELETE_AUTHORIA_MAPPING_b
    (p_authoria_mapping_id           => p_authoria_mapping_id
    ,p_object_version_number         => p_object_version_number
    );

Line: 283

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

Line: 298

    HR_AUTHORIA_MAPPING_BK3.DELETE_AUTHORIA_MAPPING_a
    (p_authoria_mapping_id           => p_authoria_mapping_id
    ,p_object_version_number         => p_object_version_number
    );

Line: 306

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

Line: 323

    rollback to DELETE_AUTHORIA_MAPPING;

Line: 329

    rollback to DELETE_AUTHORIA_MAPPING;

Line: 332

end DELETE_AUTHORIA_MAPPING;