1 PACKAGE CN_TABLE_MAPS_PVT AUTHID CURRENT_USER AS
2 /* $Header: cnvtmaps.pls 120.4 2005/09/03 02:53:44 apink noship $ */
3
4 TYPE table_map_rec_type IS RECORD
5 (
6 TABLE_MAP_ID NUMBER := cn_api.G_MISS_NUM,
7 MAPPING_TYPE VARCHAR2(4) := cn_api.G_MISS_CHAR,
8 SOURCE_TABLE_ID NUMBER := cn_api.G_MISS_NUM,
9 DESTINATION_TABLE_ID NUMBER := cn_api.G_MISS_NUM,
10 MODULE_ID NUMBER := cn_api.G_MISS_NUM,
11 LAST_UPDATE_DATE DATE := cn_api.G_MISS_DATE,
12 LAST_UPDATED_BY NUMBER := cn_api.G_MISS_NUM,
13 CREATION_DATE DATE := cn_api.G_MISS_DATE,
14 CREATED_BY NUMBER := cn_api.G_MISS_NUM,
15 LAST_UPDATE_LOGIN NUMBER := cn_api.G_MISS_NUM,
16 ORG_ID NUMBER := cn_api.G_MISS_NUM,
17 SOURCE_TBL_PKCOL_ID NUMBER := cn_api.G_MISS_NUM,
18 DELETE_FLAG VARCHAR2(1) := cn_api.G_MISS_CHAR,
19 SOURCE_HDR_TBL_PKCOL_ID NUMBER := cn_api.G_MISS_NUM,
20 SOURCE_TBL_HDR_FKCOL_ID NUMBER := cn_api.G_MISS_NUM,
21 NOTIFY_WHERE VARCHAR2(1900) := cn_api.G_MISS_CHAR,
22 COLLECT_WHERE VARCHAR2(1900) := cn_api.G_MISS_CHAR
23 );
24
25
26
27 -- Start of comments
28 -- API name : Create_Map
29 -- Type : Private
30 -- Pre-reqs : None
31 -- Function : Procedure to create a new Table Map (Collections data Source)
32 -- and all of the objects that are associated with it.
33 -- Parameters :
34 -- IN : p_api_version NUMBER Required
35 -- p_init_msg_list VARCHAR2 Optional
36 -- Default = FND_API.G_FALSE
37 -- p_commit VARCHAR2 Optional
38 -- Default = FND_API.G_FALSE
39 -- p_validation_level NUMBER Optional
40 -- Default = FND_API.G_VALID_LEVEL_FULL
41 -- OUT : x_return_status VARCHAR2(1)
42 -- x_msg_count NUMBER
43 -- x_msg_data VARCHAR2(2000)
44 -- IN : p_source_name VARCHAR2 Required
45 -- - name of Data Source, e.g. 'Legacy'
46 -- IN OUT : p_table_map_rec p_table_map_rec%ROWTYPE Required
47 -- - details of Data Source. These attributes
48 -- must be populated:
49 -- Source_Table_Id, Destination_table_Id
50 -- Mapping_Type
51 --
52 -- Version : Current version 1.0
53 -- Previous version 1.0
54 -- Initial version 1.0
55 --
56 -- Notes :
57 --
58 -- End of comments
59
60
61 PROCEDURE Create_Map (
62 p_api_version IN NUMBER,
63 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
64 p_commit IN VARCHAR2 := FND_API.G_FALSE,
65 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
66 x_return_status OUT NOCOPY VARCHAR2,
67 x_msg_count OUT NOCOPY NUMBER,
68 x_msg_data OUT NOCOPY VARCHAR2,
69 p_source_name IN VARCHAR2 ,
70 p_table_map_rec IN OUT NOCOPY table_map_rec_type,
71 x_event_id_out OUT NOCOPY NUMBER);
72
73 -- Start of comments
74 -- API name : Delete_Map
75 -- Type : Private
76 -- Pre-reqs : None
77 -- Function : Procedure to delete Table Map (Collections data Source)
78 -- and all of the objects that are associated with it.
79 -- Parameters :
80 -- IN : p_api_version NUMBER Required
81 -- p_init_msg_list VARCHAR2 Optional
82 -- Default = FND_API.G_FALSE
83 -- p_commit VARCHAR2 Optional
84 -- Default = FND_API.G_FALSE
85 -- p_validation_level NUMBER Optional
86 -- Default = FND_API.G_VALID_LEVEL_FULL
87 -- OUT : x_return_status VARCHAR2(1)
88 -- x_msg_count NUMBER
89 -- x_msg_data VARCHAR2(2000)
90 -- IN : p_table_map_id NUMBER Required
91 --
92 --
93 -- End of comments
94 PROCEDURE Delete_Map (
95 p_api_version IN NUMBER,
96 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
97 p_commit IN VARCHAR2 := FND_API.G_FALSE,
98 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
99 x_return_status OUT NOCOPY VARCHAR2,
100 x_msg_count OUT NOCOPY NUMBER,
101 x_msg_data OUT NOCOPY VARCHAR2,
102 p_table_map_id IN NUMBER,
103 p_org_id IN NUMBER);
104
105 PROCEDURE Update_Map
106 (
107 p_api_version IN NUMBER,
108 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
109 p_commit IN VARCHAR2 := FND_API.G_FALSE,
110 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
111 x_return_status OUT NOCOPY VARCHAR2,
112 x_msg_count OUT NOCOPY NUMBER,
113 x_msg_data OUT NOCOPY VARCHAR2,
114 p_table_map_id IN NUMBER,
115 p_mapping_type IN VARCHAR2,
116 p_module_id IN NUMBER,
117 p_source_table_id IN NUMBER,
118 p_source_tbl_pkcol_id IN NUMBER,
119 p_destination_table_id IN NUMBER,
120 p_source_hdr_tbl_pkcol_id IN NUMBER,
121 p_source_tbl_hdr_fkcol_id IN NUMBER,
122 p_notify_where IN VARCHAR2,
123 p_collect_where IN VARCHAR2,
124 p_delete_flag IN VARCHAR2,
125 p_event_id IN NUMBER,
126 p_event_name IN VARCHAR2,
127 p_object_version_number IN OUT NOCOPY NUMBER,
128 x_org_id IN NUMBER
129 );
130
131
132
133 -- Start of comments
134 -- API name : Create_Table_Map_Object
135 -- Type : Private
136 -- Pre-reqs : None
137 -- Function : Procedure to create a new Table Map Object. And example would be
138 -- a Parameter, for use in a Collections
139 -- Notification query. The parameter is created in CN_OBJECTS and
140 -- cross-referenced in CN_TABLE_MAP_OBJECTS
141 -- WARNING: only use this procedure to create a table map object that
142 -- does not yet exist in CN_OBJECTS. If you are creating a
143 -- table map object which references an existing object (for
144 -- example an Extra Collection Table) then just use the
145 -- cn_table_map_objects_pkg.insert_row procedure.
146 -- Parameters :
147 -- IN : p_api_version NUMBER Required
148 -- p_init_msg_list VARCHAR2 Optional
149 -- Default = FND_API.G_FALSE
150 -- p_commit VARCHAR2 Optional
151 -- Default = FND_API.G_FALSE
152 -- p_validation_level NUMBER Optional
153 -- Default = FND_API.G_VALID_LEVEL_FULL
154 -- OUT : x_return_status VARCHAR2(1)
155 -- x_msg_count NUMBER
156 -- x_msg_data VARCHAR2(2000)
157 -- IN : p_table_map_id NUMBER Required
158 -- p_object_name VARCHAR2 Required
159 -- - name of Object, e.g. 'p_param1'
160 -- p_object_value VARCHAR2 Optional
161 -- - value of Object, e.g. 'my_value'
162 -- p_tm_object_type VARCHAR2 Required
163 -- - object type, e.g. 'PARAM'
164 -- p_creation_date Required
165 -- p_created_by Required
166 -- OUT : p_table_map_object_id OUT
167 -- p_object_id OUT
168 --
169 -- End of comments
170 PROCEDURE Create_Table_Map_Object (
171 p_api_version IN NUMBER,
172 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
173 p_commit IN VARCHAR2 := FND_API.G_FALSE,
174 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
175 x_return_status OUT NOCOPY VARCHAR2,
176 x_msg_count OUT NOCOPY NUMBER,
177 x_msg_data OUT NOCOPY VARCHAR2,
178 p_table_map_id IN NUMBER,
179 p_object_name IN VARCHAR2,
180 p_object_value IN VARCHAR2 := NULL,
181 p_tm_object_type IN VARCHAR2,
182 p_creation_date IN DATE,
183 p_created_by IN NUMBER,
184 x_table_map_object_id OUT NOCOPY NUMBER,
185 x_object_id OUT NOCOPY NUMBER,
186 x_org_id IN NUMBER);
187
188
189 -- Start of comments
190 -- API name : Delete_Table_Map_Object
191 -- Type : Private
192 -- Pre-reqs : None
193 -- Function : Procedure to delete a new Table Map Object.
194 -- The procedure will delete both the cross-reference in
195 -- CN_TABLE_MAP_OBJECTS and the object itself in CN_OBJECTS.
196 -- WARNING: Use this procedure for deleting objects like Notification
197 -- Query Parameters. If you only want to delete the CN_TABLE_MAP_OBJECTS
198 -- references to an object (for example an Extra Collection Table)
199 -- then just use the cn_table_map_objects_pkg.delete_row procedure.
200 -- Parameters :
201 -- IN : p_api_version NUMBER Required
202 -- p_init_msg_list VARCHAR2 Optional
203 -- Default = FND_API.G_FALSE
204 -- p_commit VARCHAR2 Optional
205 -- Default = FND_API.G_FALSE
206 -- p_validation_level NUMBER Optional
207 -- Default = FND_API.G_VALID_LEVEL_FULL
208 -- OUT : x_return_status VARCHAR2(1)
209 -- x_msg_count NUMBER
210 -- x_msg_data VARCHAR2(2000)
211 -- IN : p_table_map_object_id NUMBER Required
212 --
213 -- End of comments
214 PROCEDURE Delete_Table_Map_Object (
215 p_api_version IN NUMBER,
216 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
217 p_commit IN VARCHAR2 := FND_API.G_FALSE,
218 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
219 x_return_status OUT NOCOPY VARCHAR2,
220 x_msg_count OUT NOCOPY NUMBER,
221 x_msg_data OUT NOCOPY VARCHAR2,
222 p_table_map_object_id IN NUMBER,
223 x_org_id IN NUMBER);
224
225
226 -- Start of comments
227 -- API name : Get_SQL_Clauses
228 -- Type : Private
229 -- Pre-reqs : None
230 -- Function : Procedure to derive the Notification and Collection
231 -- FROM and WHERE clauses for a data source, using the information
232 -- stored for that source in CN_TABLE_MAPS
233 -- Parameters :
234 -- IN : p_api_version IN NUMBER Required
235 -- p_init_msg_list IN VARCHAR2 Optional
236 -- Default = FND_API.G_FALSE
237 -- p_commit IN VARCHAR2 Optional
238 -- Default = FND_API.G_FALSE
239 -- p_validation_level IN NUMBER Optional
240 -- Default = FND_API.G_VALID_LEVEL_FULL
241 -- OUT : x_return_status OUT VARCHAR2(1)
242 -- x_msg_count OUT NUMBER
243 -- x_msg_data OUT VARCHAR2(2000)
244 -- IN : p_table_map_id IN NUMBER Required
245 -- OUT : x_notify_from OUT VARCHAR2,
246 -- x_notify_where OUT VARCHAR2,
247 -- x_collect_from OUT VARCHAR2,
248 -- x_collect_where OUT VARCHAR2);
249 --
250 -- End of comments
251 PROCEDURE Get_SQL_Clauses
252 ( p_api_version IN NUMBER,
253 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
254 p_commit IN VARCHAR2 := FND_API.G_FALSE,
255 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
256 x_return_status OUT NOCOPY VARCHAR2,
257 x_msg_count OUT NOCOPY NUMBER,
258 x_msg_data OUT NOCOPY VARCHAR2,
259 p_table_map_id IN NUMBER,
260 x_notify_from OUT NOCOPY VARCHAR2,
261 x_notify_where OUT NOCOPY VARCHAR2,
262 x_collect_from OUT NOCOPY VARCHAR2,
263 x_collect_where OUT NOCOPY VARCHAR2,
264 p_org_id IN NUMBER); -- Added For R12 MOAC
265
266
267 PROCEDURE Update_Table_Map_Objects
268 (
269 p_api_version IN NUMBER,
270 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
271 p_commit IN VARCHAR2 := FND_API.G_FALSE,
272 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
273 x_return_status OUT NOCOPY VARCHAR2,
274 x_msg_count OUT NOCOPY NUMBER,
275 x_msg_data OUT NOCOPY VARCHAR2,
276 p_table_map_id IN NUMBER,
277 p_delete_flag IN VARCHAR2,
278 p_object_name IN VARCHAR2,
279 p_object_id IN NUMBER,
280 p_object_value IN VARCHAR2,
281 p_object_version_number IN OUT NOCOPY NUMBER,
282 x_org_id IN NUMBER); -- Added For R12 MOAC
283
284 END cn_table_maps_pvt;
285