1 PACKAGE HR_LONG2LOB AS
2 /* $Header: hrl2lmig.pkh 120.3 2005/11/17 11:45 smallina noship $ */
3
4 /******************************************
5 * INIT procedure will do the following steps.
6 *1. Initialize the AD tables with required data.
7 *2. Adding the columns
8 *3. Adding the Triggers
9 ********************************************/
10
11 PROCEDURE DO_INIT(
12 p_appl_short_name IN VARCHAR2,
13 p_table_name IN VARCHAR2,
14 p_old_column_name IN VARCHAR2,
15 p_new_column_data_type IN VARCHAR2
16 );
17
18 /******************************************
19 * MIGRATE procedure will do the following steps.
20 * 1. Migration of data.
21 * 2. Renaming the columns
22 * 3. Dropping the triggers.
23 *******************************************/
24
25 PROCEDURE DO_MIGRATE(
26 p_appl_short_name IN VARCHAR2,
27 p_table_name IN VARCHAR2,
28 p_old_column_name IN VARCHAR2
29 );
30
31 /*******************************************
32 * DROP procedure will do the following step.
33 * 1. Dropping the column
34 *******************************************/
35
36 PROCEDURE DO_DROP(
37 p_appl_short_name IN VARCHAR2,
38 p_table_name IN VARCHAR2,
39 p_old_column_name IN VARCHAR2
40 );
41
42 /*******************************************
43 * UNUSED procedure will do the following step.
44 * 1. Marks the column as unused.
45 *******************************************/
46
47 PROCEDURE DO_UNUSED(
48 p_appl_short_name IN VARCHAR2,
49 p_table_name IN VARCHAR2,
50 p_old_column_name IN VARCHAR2
51 );
52
53 /*******************************************
54 * ALL_DROP procedure will do the following steps.
55 * 1. Initialize the AD tables with required data.
56 * 2. Adding the column
57 * 3. Migration of data.
58 * 4. Renaming the column
59 * 5. Dropping the column
60 *******************************************/
61
62 PROCEDURE DO_ALL_DROP(
63 p_appl_short_name IN VARCHAR2,
64 p_table_name IN VARCHAR2,
65 p_old_column_name IN VARCHAR2,
66 p_new_column_data_type IN VARCHAR2
67 );
68
69 /*******************************************
70 * ALL_UNUSED procedure will do the following steps.
71 * 1. Initialize the AD tables with required data.
72 * 2. Adding the column
73 * 3. Migration of data.
74 * 4. Renaming the column
75 * 5. Marking the column as unused.
76 *******************************************/
77
78 PROCEDURE DO_ALL_UNUSED(
79 p_appl_short_name IN VARCHAR2,
80 p_table_name IN VARCHAR2,
81 p_old_column_name IN VARCHAR2,
82 p_new_column_data_type IN VARCHAR2
83 );
84 END HR_LONG2LOB;