[Home] [Help]
PACKAGE: APPS.AD_LONGTOLOB_PKG
Source
1 PACKAGE Ad_LongToLob_Pkg
2 -- $Header: adl2lpkgs.pls 120.0 2005/09/30 06:19:19 vpalakur noship $
3 AS
4 -- Constants to indicate the status of the migration process
5 -- Initial status of the tables before starting the migration process.
6 G_INITIALIZED_STATUS CONSTANT VARCHAR2 (30) := 'INITIALIZED';
7 -- Status after adding the NEW columns
8 G_ADD_NEW_COLUMN_STATUS CONSTANT VARCHAR2 (30) := 'NEW_COL_ADDED';
9 -- Status after adding the triggers.
10 G_ADD_TRIGGER_STATUS CONSTANT VARCHAR2 (30) := 'TRIGGER_ADDED';
11 -- Status after migrating the data.
12 G_UPDATE_ROWS_STATUS CONSTANT VARCHAR2 (30) := 'TABLE_UPDATED';
13 G_DROP_OLD_COLUMN_STATUS CONSTANT VARCHAR2 (30) := 'DROP OLD COLUMN';
14 G_COL_RENAMED_STATUS CONSTANT VARCHAR2 (30) := 'LONG_LOB_RENAMED';
15 G_DROP_TRIGGER_STATUS CONSTANT VARCHAR2 (30) := 'TRIGGER_DROPPED';
16 G_COMPLETE_STATUS CONSTANT VARCHAR2 (30) := 'COMPLETED';
17 G_DEFERRED_STATUS CONSTANT VARCHAR2 (30) := 'DEFERRED';
18
19 -- Diffrent actions to be performed on the tables.
20 G_NO_ACTION CONSTANT VARCHAR2 (10) := 'NO_ACTION';
21 G_WITH_DATA CONSTANT VARCHAR2 (10) := 'WITH_DATA';
22 G_WITHOUT_DATA CONSTANT VARCHAR2 (15) := 'WITHOUT_DATA';
23 G_DROP_COLUMN CONSTANT VARCHAR2 (15) := 'DROP_COLUMN';
24
25 PROCEDURE initialize_process(
26 p_Specific_Table VARCHAR2 := NULL ,
27 p_Specific_Product VARCHAR2 := NULL ,
28 p_Specific_Schema VARCHAR2 := NULL );
29 PROCEDURE add_new_column(
30 p_Schema IN VARCHAR2 ,
31 p_Table_Name IN VARCHAR2 ,
32 p_Old_Column_Name IN VARCHAR2 ,
33 p_New_Column_Name IN VARCHAR2 ,
34 p_New_Data_Type IN VARCHAR2 ,
35 p_Curr_Status IN VARCHAR2 ,
36 p_Action IN VARCHAR2 );
37 PROCEDURE write_long_rep;
38 PROCEDURE write_long_rep( p_Path VARCHAR2);
39 PROCEDURE create_transform_triggers(
40 p_Schema IN VARCHAR2 ,
41 p_Table_Name IN VARCHAR2 ,
42 p_Old_Column_Name IN VARCHAR2 ,
43 p_New_Column_Name IN VARCHAR2 ,
44 p_New_Data_Type IN VARCHAR2 );
45 PROCEDURE update_new_data(
46 p_Schema IN VARCHAR2 ,
47 p_Old_Table_Name IN VARCHAR2 ,
48 p_Old_Column_Name IN VARCHAR2 ,
49 p_Old_Data_Type IN VARCHAR2 ,
50 p_New_Column_Name IN VARCHAR2 ,
51 p_Batch_Size IN NUMBER DEFAULT 1000);
52 PROCEDURE defer_table( p_Schema IN VARCHAR2 ,
53 p_Table_Name IN VARCHAR2 );
54 PROCEDURE re_enable_table(p_Schema IN VARCHAR2 ,
55 p_Table_Name IN VARCHAR2 );
56
57 END Ad_LongToLob_Pkg;