APPS.HXC_SEEDDATA_BY_LEVEL_API SQL Statements

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

Line: 123

procedure update_seed_data_by_level
  (p_validate                      in     boolean  default false
  ,p_object_id                     in   number
  ,p_object_type                   in   varchar2
  ,p_hxc_required                  in     varchar2
  ,p_owner_application_id          in   number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                varchar2(72);

Line: 137

	l_proc := g_package||'update_seed_data_by_level';

Line: 143

  savepoint update_seed_data_by_level;

Line: 149

    hxc_seeddata_by_level_bk1.update_seed_data_by_level_b
      (p_object_id              => p_object_id
      ,p_object_type            => p_object_type
      ,p_hxc_required           => p_hxc_required
      ,p_owner_application_id   => p_owner_application_id
      );

Line: 159

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

Line: 183

    hxc_seeddata_by_level_bk1.update_seed_data_by_level_a
      (p_object_id              => p_object_id
      ,p_object_type            => p_object_type
      ,p_hxc_required           => p_hxc_required
      ,p_owner_application_id   => p_owner_application_id
      );

Line: 192

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

Line: 212

    rollback to update_seed_data_by_level;

Line: 221

    rollback to update_seed_data_by_level;

Line: 227

end update_seed_data_by_level;

Line: 234

procedure delete_seed_data_by_level
  (p_validate                      in     boolean  default false
  ,p_object_id                     in   number
  ,p_object_type                   in   varchar2
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                varchar2(72);

Line: 246

	l_proc := g_package||'delete_seed_data_by_level';

Line: 252

  savepoint delete_seed_data_by_level;

Line: 258

    hxc_seeddata_by_level_bk1.delete_seed_data_by_level_b
      (p_object_id              => p_object_id
      ,p_object_type            => p_object_type
      );

Line: 267

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

Line: 287

    hxc_seeddata_by_level_bk1.delete_seed_data_by_level_a
      (p_object_id              => p_object_id
      ,p_object_type            => p_object_type
      );

Line: 294

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

Line: 314

    rollback to delete_seed_data_by_level;

Line: 323

    rollback to delete_seed_data_by_level;

Line: 329

end delete_seed_data_by_level;