PACKAGE: APPS.CCT_UPGRADE_PKG

Source

1 PACKAGE cct_upgrade_pkg AUTHID CURRENT_USER AS
2 /* $Header: cctuupgs.pls 115.18 2004/03/26 00:26:58 sradhakr ship $ */
3    PROCEDURE add_column (
4          schema_name     IN VARCHAR2
5 	    , table_name      IN VARCHAR2
6          , col_name      IN VARCHAR2);
7    /* Added on March 19 2003 rajayara */
8    PROCEDURE add_varchar_column (
9              schema_name     IN VARCHAR2
10 	    , table_name      IN VARCHAR2
11             , col_name      IN VARCHAR2);
12 
13    PROCEDURE update_column
14          (table_name     IN VARCHAR2
15           , new_col_name IN VARCHAR2
16           , old_col_name IN VARCHAR2
17           , new_value    IN NUMBER
18           , old_value    IN NUMBER);
19 
20    PROCEDURE modify_column_to_nullable  (
21          schema_name     IN VARCHAR2
22 	 , table_name    IN VARCHAR2
23          , col_name      IN VARCHAR2);
24 
25   PROCEDURE MODIFY_SEQUENCE_WITH_VALUE  (
26 	  schema_name  IN VARCHAR2
27 	  ,sequence_name    IN VARCHAR2
28 	  ,replacement_value IN VARCHAR2
29          );
30 
31    PROCEDURE modify_new_sequence_from_old  (
32 		schema_name  IN VARCHAR2
33 		  ,sequence_name    IN VARCHAR2
34 	    ,old_sequence_name IN VARCHAR2
35 						   );
36 
37    PROCEDURE modify_sequence_with_verify  (
38 		schema_name  IN VARCHAR2
39 		,sequence_name    IN VARCHAR2
40 	        ,old_sequence_name IN VARCHAR2
41 		);
42 
43    PROCEDURE drop_column (
44          schema_name     IN VARCHAR2
45 	    , table_name      IN VARCHAR2
46          , col_name      IN VARCHAR2);
47    PROCEDURE copy_all_rows (
48 	old_table_name   IN VARCHAR2
49         , new_table_name IN VARCHAR2);
50 
51    PROCEDURE delete_fnd_lookups(
52          lookupType   IN VARCHAR2
53          , lookupCode IN VARCHAR2
54          );
55 
56    PROCEDURE delete_fnd_lookups(
57          lookupType    IN VARCHAR2
58          , lookupCode  IN VARCHAR2
59 	 , lang        IN VARCHAR2
60 	    );
61 
62    Procedure upgrade_mware_values;
63 
64    Procedure change_params_in_mvalues;
65 
66    Procedure delete_prospect_aspect;
67 
68    Procedure delete_middleware_type(p_middleware_type_id IN Number);
69 
70    PROCEDURE upgrade_ao_flg_mw_values;
71 
72    Procedure update_mwparam_in_mwvalues(p_old_type IN VARCHAR2,p_old_param_name IN VARCHAR2,p_new_type IN VARCHAR2,p_new_param_name IN VARCHAR2);
73    Procedure update_agparam_in_agvalues(p_old_type IN VARCHAR2, p_old_param_name in VARCHAR2, p_new_type IN VARCHAR2,p_new_param_name IN VARCHAR2);
74    Procedure update_mtype_in_mware(p_middleware_id IN Number,p_old_type in VARCHAR2, p_new_type IN VARCHAR2);
75    Procedure delete_middleware_value(p_middleware_type in VARCHAR2,p_param_name in VARCHAR2);
76    Procedure update_agent_values(p_agent_param IN VARCHAR2,p_middleware_type_id IN VARCHAR2,p_new_agent_param_id In NUMBER);
77 
78    Procedure increment_ikey_sequence;
79 
80 END cct_upgrade_pkg;