PACKAGE: APPS.CSI_MIG_SLABS_PKG

Source

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