[Home] [Help]
PACKAGE: APPS.CN_SYS_TABLES_PVT
Source
1 PACKAGE CN_SYS_TABLES_PVT AUTHID CURRENT_USER AS
2 --$Header: cnvsytbs.pls 120.2 2005/08/08 04:45:32 rramakri noship $
3
4 TYPE table_rec_type IS RECORD (
5 object_id cn_objects.object_id%TYPE
6 , name cn_objects.name%TYPE
7 , description cn_objects.description%TYPE
8 , status cn_objects.object_status%TYPE
9 , repository_id cn_objects.repository_id%TYPE
10 , alias cn_objects.alias%TYPE
11 , table_level cn_objects.table_level%TYPE
12 , table_type cn_objects.table_level%TYPE
13 , object_type cn_objects.object_type%TYPE
14 , schema cn_objects.schema%TYPE
15 , calc_eligible_flag cn_objects.calc_eligible_flag%TYPE
16 , user_name cn_objects.user_name%TYPE
17 , org_id cn_objects.org_id%TYPE
18 , object_version_number cn_objects.object_version_number%TYPE
19 );
20
21 TYPE column_rec_type IS RECORD (
22 object_id cn_objects.object_id%TYPE
23 , user_name cn_objects.user_name%TYPE
24 , usage cn_objects.calc_formula_flag%TYPE
25 , foreign_key cn_objects.foreign_key%TYPE
26 , dimension_id cn_objects.dimension_id%TYPE
27 , user_column_name cn_objects.user_column_name%TYPE
28 , classification_column cn_objects.classification_column%TYPE
29 , column_datatype cn_objects.column_datatype%TYPE
30 , value_set_id cn_objects.value_set_id%TYPE
31 , primary_key cn_objects.primary_key%TYPE
32 , position cn_objects.position%TYPE
33 , custom_call cn_objects.custom_call%TYPE
34 , org_id cn_objects.org_id%TYPE
35 , object_version_number cn_objects.object_version_number%TYPE
36 );
37
38 -- Start of comments
39 -- API name : Create_Table
40 -- Type : Private.
41 -- Function : Create the information for the table in cn_objects
42 -- Also create the columns associated with the table
43 -- Pre-reqs : None.
44 -- Parameters :
45 -- IN : p_api_version IN NUMBER Required
46 -- p_init_msg_list IN VARCHAR2 Optional
47 -- Default = FND_API.G_FALSE
48 -- p_commit IN VARCHAR2 Optional
49 -- Default = FND_API.G_FALSE
50 -- p_validation_level IN NUMBER Optional
51 -- Default = FND_API.G_VALID_LEVEL_FULL
52 -- p_table_rec IN table_rec_type Required
53 -- OUT : x_return_status OUT VARCHAR2(1)
54 -- x_msg_count OUT NUMBER
55 -- x_msg_data OUT VARCHAR2(2000)
56 -- Version : Current version 1.0
57 -- Changed....
58 -- Initial version 1.0
59 --
60 -- Notes : Note text
61 --
62 -- End of comments
63 PROCEDURE Create_Table
64 (p_api_version IN NUMBER ,
65 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
66 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
67 p_validation_level IN NUMBER :=
68 FND_API.G_VALID_LEVEL_FULL ,
69 p_table_rec IN OUT NOCOPY table_rec_type ,
70 x_return_status OUT NOCOPY VARCHAR2 ,
71 x_msg_count OUT NOCOPY NUMBER ,
72 x_msg_data OUT NOCOPY VARCHAR2 );
73
74 -- Start of comments
75 -- API name : Update_Table
76 -- Type : Private.
77 -- Function : Update table information
78 -- Pre-reqs : None.
79 -- Parameters :
80 -- IN : p_api_version IN NUMBER Required
81 -- p_init_msg_list IN VARCHAR2 Optional
82 -- Default = FND_API.G_FALSE
83 -- p_commit IN VARCHAR2 Optional
84 -- Default = FND_API.G_FALSE
85 -- p_validation_level IN NUMBER Optional
86 -- Default = FND_API.G_VALID_LEVEL_FULL
87 -- p_old_table_rec IN table_rec_type Required
88 -- p_new_table_rec IN table_rec_type Required
89 -- OUT : x_return_status OUT VARCHAR2(1)
90 -- x_msg_count OUT NUMBER
91 -- x_msg_data OUT VARCHAR2(2000)
92 -- Version : Current version 1.0
93 -- Initial version 1.0
94 --
95 -- Notes : Note text
96 --
97 -- End of comments
98 PROCEDURE Update_Table
99 (p_api_version IN NUMBER ,
100 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
101 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
102 p_validation_level IN NUMBER :=
103 FND_API.G_VALID_LEVEL_FULL ,
104 p_table_rec IN OUT NOCOPY table_rec_type ,
105 x_return_status OUT NOCOPY VARCHAR2 ,
106 x_msg_count OUT NOCOPY NUMBER ,
107 x_msg_data OUT NOCOPY VARCHAR2 );
108
109 -- Start of comments
110 -- API name : Delete_Table
111 -- Type : Private.
112 -- Function : Delete table information
113 -- Pre-reqs : None.
114 -- Parameters :
115 -- IN : p_api_version IN NUMBER Required
116 -- p_init_msg_list IN VARCHAR2 Optional
117 -- Default = FND_API.G_FALSE
118 -- p_commit IN VARCHAR2 Optional
119 -- Default = FND_API.G_FALSE
120 -- p_validation_level IN NUMBER Optional
121 -- Default = FND_API.G_VALID_LEVEL_FULL
122 -- p_table_rec IN table_rec_type Required
123 -- OUT : x_return_status OUT VARCHAR2(1)
124 -- x_msg_count OUT NUMBER
125 -- x_msg_data OUT VARCHAR2(2000)
126 -- Version : Current version 1.0
127 -- Initial version 1.0
128 --
129 -- Notes : Note text
130 --
131 -- End of comments
132
133
134 PROCEDURE Delete_Table
135 (p_api_version IN NUMBER ,
136 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
137 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
138 p_validation_level IN NUMBER :=
139 FND_API.G_VALID_LEVEL_FULL ,
140 p_table_rec IN table_rec_type ,
141 x_return_status OUT NOCOPY VARCHAR2 ,
142 x_msg_count OUT NOCOPY NUMBER ,
143 x_msg_data OUT NOCOPY VARCHAR2 );
144
145 -- Start of comments
146 -- API name : Update_Column
147 -- Type : Private.
148 -- Function : Update column information
149 --
150 -- Pre-reqs : None.
151 -- Parameters :
152 -- IN : p_api_version IN NUMBER Required
153 -- p_init_msg_list IN VARCHAR2 Optional
154 -- Default = FND_API.G_FALSE
155 -- p_commit IN VARCHAR2 Optional
156 -- Default = FND_API.G_FALSE
157 -- p_validation_level IN NUMBER Optional
158 -- Default = FND_API.G_VALID_LEVEL_FULL
159 -- p_column_rec IN column_rec_type Required
160 -- OUT : x_return_status OUT VARCHAR2(1)
161 -- x_msg_count OUT NUMBER
162 -- x_msg_data OUT VARCHAR2(2000)
163 -- Version : Current version 1.0
164 -- Changed....
165 -- Initial version 1.0
166 --
167 -- Notes : Note text
168 --
169 -- End of comments
170
171 PROCEDURE Update_Column
172 (p_api_version IN NUMBER ,
173 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
174 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
175 p_validation_level IN NUMBER :=
176 FND_API.G_VALID_LEVEL_FULL ,
177 p_column_rec IN column_rec_type ,
178 x_return_status OUT NOCOPY VARCHAR2 ,
179 x_msg_count OUT NOCOPY NUMBER ,
180 x_msg_data OUT NOCOPY VARCHAR2 );
181
182 -- Start of comments
183 -- API name : Insert_Column
184 -- Type : Private.
185 -- Function : Insert column information
186 --
187 -- Pre-reqs : None.
188 -- Parameters :
189 -- IN : p_api_version IN NUMBER Required
190 -- p_init_msg_list IN VARCHAR2 Optional
191 -- Default = FND_API.G_FALSE
192 -- p_commit IN VARCHAR2 Optional
193 -- Default = FND_API.G_FALSE
194 -- p_validation_level IN NUMBER Optional
195 -- Default = FND_API.G_VALID_LEVEL_FULL
196 -- p_column_rec IN column_rec_type Required
197 -- OUT : x_return_status OUT VARCHAR2(1)
198 -- x_msg_count OUT NUMBER
199 -- x_msg_data OUT VARCHAR2(2000)
200 -- Version : Current version 1.0
201 -- Changed....
202 -- Initial version 1.0
203 --
204 -- Notes : Note text
205 --
206 -- End of comments
207
208 PROCEDURE Insert_Column
209 (p_api_version IN NUMBER ,
210 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
211 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
212 p_validation_level IN NUMBER :=
213 FND_API.G_VALID_LEVEL_FULL ,
214 p_schema_name IN varchar2 ,
215 p_table_name IN varchar2 ,
216 p_column_name IN varchar2 ,
217 p_column_rec IN column_rec_type ,
218 x_return_status OUT NOCOPY VARCHAR2 ,
219 x_msg_count OUT NOCOPY NUMBER ,
220 x_msg_data OUT NOCOPY VARCHAR2 );
221
222 -- Start of comments
223 -- API name : Delete_Column
224 -- Type : Private.
225 -- Function : Delete column information
226 --
227 -- Pre-reqs : None.
228 -- Parameters :
229 -- IN : p_api_version IN NUMBER Required
230 -- p_init_msg_list IN VARCHAR2 Optional
231 -- Default = FND_API.G_FALSE
232 -- p_commit IN VARCHAR2 Optional
233 -- Default = FND_API.G_FALSE
234 -- p_validation_level IN NUMBER Optional
235 -- Default = FND_API.G_VALID_LEVEL_FULL
236 -- p_column_id IN NUMBER Required
237 -- OUT : x_return_status OUT VARCHAR2(1)
238 -- x_msg_count OUT NUMBER
239 -- x_msg_data OUT VARCHAR2(2000)
240 -- Version : Current version 1.0
241 -- Changed....
242 -- Initial version 1.0
243 --
244 -- Notes : Note text
245 --
246 -- End of comments
247
248
249 PROCEDURE Delete_Column
250 (p_api_version IN NUMBER ,
251 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
252 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
253 p_validation_level IN NUMBER :=
254 FND_API.G_VALID_LEVEL_FULL ,
255 p_column_id IN number ,
256 x_return_status OUT NOCOPY VARCHAR2 ,
257 x_msg_count OUT NOCOPY NUMBER ,
258 x_msg_data OUT NOCOPY VARCHAR2 );
259
260 END CN_SYS_TABLES_PVT;