APPS.HXC_FLD_MAPPING_API SQL Statements

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

Line: 153

procedure update_fld_mapping
  (p_validate                       in  boolean   default false
  ,p_mapping_id                     in  number
  ,p_object_version_number          in  out nocopy number
  ,p_name                           in     varchar2
  ) is
  --
  -- Declare cursors and local variables
  --
	l_proc varchar2(72);

Line: 169

  	l_proc := g_package||' update_fld_mapping';

Line: 175

  savepoint update_fld_mapping;

Line: 184

    hxc_fld_mapping_BK_2.update_fld_mapping_b
	  (p_mapping_id             => p_mapping_id
	  ,p_object_version_number  => p_object_version_number
	  ,p_name                   => p_name
  );

Line: 192

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

Line: 218

    hxc_fld_mapping_BK_2.update_fld_mapping_a
	  (p_mapping_id             => p_mapping_id
	  ,p_object_version_number  => l_object_version_number
	  ,p_name                   => p_name
  );

Line: 226

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

Line: 256

    ROLLBACK TO update_fld_mapping;

Line: 275

    ROLLBACK TO update_fld_mapping;

Line: 278

END update_fld_mapping;

Line: 284

procedure delete_fld_mapping
  (p_validate                       in  boolean  default false
  ,p_mapping_id                     in  number
  ,p_object_version_number          in  number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72);

Line: 298

  	l_proc := g_package||'delete_fld_mapping';

Line: 304

  savepoint delete_fld_mapping;

Line: 314

    hxc_fld_mapping_BK_3.delete_fld_mapping_b
	  (p_mapping_id            => p_mapping_id
	  ,p_object_version_number => p_object_version_number
	  );

Line: 321

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

Line: 346

  hxc_fld_mapping_BK_3.delete_fld_mapping_a
	  (p_mapping_id            => p_mapping_id
	  ,p_object_version_number => p_object_version_number
	  );

Line: 353

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

Line: 375

    ROLLBACK TO delete_fld_mapping;

Line: 381

    ROLLBACK TO delete_fld_mapping;

Line: 384

end delete_fld_mapping;