[Home] [Help]
PACKAGE: APPS.CN_SYS_TABLES_PVT_W
Source
1 package cn_sys_tables_pvt_w AUTHID CURRENT_USER as
2 /* $Header: cnwsytbs.pls 120.3 2005/09/14 03:44:13 vensrini ship $ */
3 procedure create_table(p_api_version NUMBER
4 , p_init_msg_list VARCHAR2
5 , p_commit VARCHAR2
6 , p_validation_level NUMBER
7 , p4_a0 in out nocopy NUMBER
8 , p4_a1 in out nocopy VARCHAR2
9 , p4_a2 in out nocopy VARCHAR2
10 , p4_a3 in out nocopy VARCHAR2
11 , p4_a4 in out nocopy NUMBER
12 , p4_a5 in out nocopy VARCHAR2
13 , p4_a6 in out nocopy VARCHAR2
14 , p4_a7 in out nocopy VARCHAR2
15 , p4_a8 in out nocopy VARCHAR2
16 , p4_a9 in out nocopy VARCHAR2
17 , p4_a10 in out nocopy VARCHAR2
18 , p4_a11 in out nocopy VARCHAR2
19 , p4_a12 in out nocopy NUMBER
20 , p4_a13 in out nocopy NUMBER
21 , x_return_status out nocopy VARCHAR2
22 , x_msg_count out nocopy NUMBER
23 , x_msg_data out nocopy VARCHAR2
24 );
25 procedure update_table(p_api_version NUMBER
26 , p_init_msg_list VARCHAR2
27 , p_commit VARCHAR2
28 , p_validation_level NUMBER
29 , p4_a0 in out nocopy NUMBER
30 , p4_a1 in out nocopy VARCHAR2
31 , p4_a2 in out nocopy VARCHAR2
32 , p4_a3 in out nocopy VARCHAR2
33 , p4_a4 in out nocopy NUMBER
34 , p4_a5 in out nocopy VARCHAR2
35 , p4_a6 in out nocopy VARCHAR2
36 , p4_a7 in out nocopy VARCHAR2
37 , p4_a8 in out nocopy VARCHAR2
38 , p4_a9 in out nocopy VARCHAR2
39 , p4_a10 in out nocopy VARCHAR2
40 , p4_a11 in out nocopy VARCHAR2
41 , p4_a12 in out nocopy NUMBER
42 , p4_a13 in out nocopy NUMBER
43 , x_return_status out nocopy VARCHAR2
44 , x_msg_count out nocopy NUMBER
45 , x_msg_data out nocopy VARCHAR2
46 );
47 procedure delete_table(p_api_version NUMBER
48 , p_init_msg_list VARCHAR2
49 , p_commit VARCHAR2
50 , p_validation_level NUMBER
51 , p4_a0 NUMBER
52 , p4_a1 VARCHAR2
53 , p4_a2 VARCHAR2
54 , p4_a3 VARCHAR2
55 , p4_a4 NUMBER
56 , p4_a5 VARCHAR2
57 , p4_a6 VARCHAR2
58 , p4_a7 VARCHAR2
59 , p4_a8 VARCHAR2
60 , p4_a9 VARCHAR2
61 , p4_a10 VARCHAR2
62 , p4_a11 VARCHAR2
63 , p4_a12 NUMBER
64 , p4_a13 NUMBER
65 , x_return_status out nocopy VARCHAR2
66 , x_msg_count out nocopy NUMBER
67 , x_msg_data out nocopy VARCHAR2
68 );
69 procedure update_column(p_api_version NUMBER
70 , p_init_msg_list VARCHAR2
71 , p_commit VARCHAR2
72 , p_validation_level NUMBER
73 , p4_a0 NUMBER
74 , p4_a1 VARCHAR2
75 , p4_a2 VARCHAR2
76 , p4_a3 VARCHAR2
77 , p4_a4 NUMBER
78 , p4_a5 VARCHAR2
79 , p4_a6 VARCHAR2
80 , p4_a7 VARCHAR2
81 , p4_a8 NUMBER
82 , p4_a9 VARCHAR2
83 , p4_a10 NUMBER
84 , p4_a11 VARCHAR2
85 , p4_a12 NUMBER
86 , p4_a13 NUMBER
87 , x_return_status out nocopy VARCHAR2
88 , x_msg_count out nocopy NUMBER
89 , x_msg_data out nocopy VARCHAR2
90 );
91 procedure insert_column(p_api_version NUMBER
92 , p_init_msg_list VARCHAR2
93 , p_commit VARCHAR2
94 , p_validation_level NUMBER
95 , p_schema_name VARCHAR2
96 , p_table_name VARCHAR2
97 , p_column_name VARCHAR2
98 , p7_a0 NUMBER
99 , p7_a1 VARCHAR2
100 , p7_a2 VARCHAR2
101 , p7_a3 VARCHAR2
102 , p7_a4 NUMBER
103 , p7_a5 VARCHAR2
104 , p7_a6 VARCHAR2
105 , p7_a7 VARCHAR2
106 , p7_a8 NUMBER
107 , p7_a9 VARCHAR2
108 , p7_a10 NUMBER
109 , p7_a11 VARCHAR2
110 , p7_a12 NUMBER
111 , p7_a13 NUMBER
112 , x_return_status out nocopy VARCHAR2
113 , x_msg_count out nocopy NUMBER
114 , x_msg_data out nocopy VARCHAR2
115 );
116 end cn_sys_tables_pvt_w;