1 PACKAGE csd_mig_slabs_pkg AUTHID CURRENT_USER AS
2 /* $Header: csdslabs.pls 115.4 2002/11/19 01:59:51 swai noship $*/
3
4 G_NO_OF_SLABS number := 32; --@@optimal slabsize?
5 G_MIN_SLAB_SIZE number := 100000; --@@Minimum size of the batch
6
7 /*get min/max value of next available batch*/
8 procedure get_table_slabs
9 ( p_table_name in VARCHAR, -- Entity/table name CS_ESTIMATE_DETAILS
10 p_module in VARCHAR, -- module id
11 p_slab_number in NUMBER, --Number of the slab
12 x_start_slab out NOCOPY NUMBER, --Start id of the slab
13 x_end_slab out NOCOPY NUMBER ); --End id of the slab
14
15 procedure create_table_slabs
16 ( p_table_name in varchar, --Name of the table
17 p_module in VARCHAR, -- module id
18 p_pk_column in varchar, --Name of the primary key column
19 p_no_of_slabs in number default G_NO_OF_SLABS, --Number of slabs to be created
20 p_min_slab_size in number default G_MIN_SLAB_SIZE ); --Minimum slab size
21
22 END csd_mig_slabs_pkg;
23