1 PACKAGE bis_impl_dev_pkg AS
2 /* $Header: BISCONCS.pls 120.2 2005/07/12 01:10:40 smulye noship $ */
3 version CONSTANT VARCHAR (80)
4 := '$Header: BISCONCS.pls 120.2 2005/07/12 01:10:40 smulye noship $';
5
6 function clob_to_varchar2 (
7 p_in clob,
8 p_size integer
9 ) return varchar2;
10
11 procedure Create_Linkage (
12 P_OBJECT_TYPE in VARCHAR2,
13 P_OBJECT_OWNER in VARCHAR2,
14 P_OBJECT_NAME in VARCHAR2,
15 P_CONC_PROGRAM_NAME in VARCHAR2,
16 P_CONC_APP_ID in NUMBER,
17 P_CONC_APP_SHORT_NAME in VARCHAR2,
18 P_ENABLED_FLAG in VARCHAR2,
19 P_REFRESH_MODE in VARCHAR2,
20 P_CREATED_BY in NUMBER := null,
21 P_CREATION_DATE in DATE := null,
22 P_LAST_UPDATED_BY in NUMBER := null,
23 P_LAST_UPDATE_LOGIN in NUMBER := null,
24 P_LAST_UPDATE_DATE in DATE := null,
25 p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,
26 p_commit IN VARCHAR2 := fnd_api.g_FALSE,
27 x_return_status OUT NOCOPY VARCHAR2,
28 x_errorcode OUT NOCOPY NUMBER,
29 x_msg_count OUT NOCOPY NUMBER,
30 x_msg_data OUT NOCOPY VARCHAR2
31 ) ;
32
33 procedure Update_Linkage (
34 P_ROWID in ROWID,
35 P_OBJECT_TYPE in VARCHAR2,
36 P_OBJECT_OWNER in VARCHAR2,
37 P_OBJECT_NAME in VARCHAR2,
38 P_CONC_PROGRAM_NAME in VARCHAR2,
39 P_CONC_APP_ID in NUMBER,
40 P_CONC_APP_SHORT_NAME in VARCHAR2,
41 P_ENABLED_FLAG in VARCHAR2,
42 P_REFRESH_MODE in VARCHAR2,
43 P_LAST_UPDATED_BY in NUMBER := null,
44 P_LAST_UPDATE_LOGIN in NUMBER := null,
45 P_LAST_UPDATE_DATE in DATE := null,
46 p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,
47 p_commit IN VARCHAR2 := fnd_api.g_FALSE,
48 x_return_status OUT NOCOPY VARCHAR2,
49 x_errorcode OUT NOCOPY NUMBER,
50 x_msg_count OUT NOCOPY NUMBER,
51 x_msg_data OUT NOCOPY VARCHAR2
52 ) ;
53
54 procedure Delete_Linkage (
55 P_ROWID in ROWID
56 ) ;
57
58 -- added to detect loop for enabled dependency in RSG
59 PROCEDURE dep_loop_validation (
60 p_object_type IN VARCHAR2,
61 p_object_name IN VARCHAR2,
62 p_dep_object_type IN VARCHAR2,
63 p_dep_object_name IN VARCHAR2,
64 p_enabled_flag IN VARCHAR2,
65 X_RETURN_STATUS OUT NOCOPY VARCHAR2
66 );
67
68 procedure page_name_validation (
69 P_OBJECT_TYPE IN VARCHAR2,
70 P_USER_OBJECT_NAME IN VARCHAR2,
71 X_OBJECT_NAME IN OUT NOCOPY VARCHAR2,
72 X_IS_OA_PAGE IN OUT NOCOPY VARCHAR2,
73 X_RETURN_STATUS OUT NOCOPY VARCHAR2
74 ) ;
75
76 procedure object_name_validation (
77 P_OBJECT_TYPE IN VARCHAR2,
78 P_USER_OBJECT_NAME IN VARCHAR2,
79 X_OBJECT_NAME IN OUT NOCOPY VARCHAR2,
80 X_RETURN_STATUS OUT NOCOPY VARCHAR2
81 ) ;
82
83 procedure object_owner_validation (
84 P_OBJECT_OWNER IN VARCHAR2,
85 X_RETURN_STATUS OUT NOCOPY VARCHAR2
86 ) ;
87
88 procedure conc_program_validation (
89 P_USER_CONC_PROGRAM_NAME IN VARCHAR2,
90 X_CONC_APP_ID IN OUT NOCOPY NUMBER,
91 X_CONC_APP_SHORT_NAME OUT NOCOPY VARCHAR2,
92 X_CONC_PROGRAM_NAME OUT NOCOPY VARCHAR2,
93 X_RETURN_STATUS OUT NOCOPY VARCHAR2
94 ) ;
95
96 FUNCTION Refresh_Program_Exists(
97 P_OBJECT_TYPE in VARCHAR2,
98 P_OBJECT_NAME in VARCHAR2) RETURN VARCHAR2;
99
100 procedure Create_Dependency (
101 P_OBJECT_TYPE in VARCHAR2,
102 P_OBJECT_OWNER in VARCHAR2,
103 P_OBJECT_NAME in VARCHAR2,
104 P_ENABLED_FLAG in VARCHAR2,
105 P_DEPEND_OBJECT_TYPE in VARCHAR2,
106 P_DEPEND_OBJECT_OWNER in VARCHAR2,
107 P_DEPEND_OBJECT_NAME in VARCHAR2,
108 P_FROM_UI in VARCHAR2 DEFAULT NULL,
109 P_CREATED_BY in NUMBER := null,
110 P_CREATION_DATE in DATE := null,
111 P_LAST_UPDATED_BY in NUMBER := null,
112 P_LAST_UPDATE_LOGIN in NUMBER := null,
113 P_LAST_UPDATE_DATE in DATE := null,
114 p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,
115 p_commit IN VARCHAR2 := fnd_api.g_FALSE,
116 x_return_status OUT NOCOPY VARCHAR2,
117 x_errorcode OUT NOCOPY NUMBER,
118 x_msg_count OUT NOCOPY NUMBER,
119 x_msg_data OUT NOCOPY VARCHAR2
120 ) ;
121
122 procedure Update_Dependency (
123 P_ROWID in ROWID := null,
124 P_OBJECT_TYPE in VARCHAR2,
125 P_OBJECT_OWNER in VARCHAR2,
126 P_OBJECT_NAME in VARCHAR2,
127 P_ENABLED_FLAG in VARCHAR2,
128 P_DEPEND_OBJECT_TYPE in VARCHAR2,
129 P_DEPEND_OBJECT_OWNER in VARCHAR2,
130 P_DEPEND_OBJECT_NAME in VARCHAR2,
131 P_FROM_UI in VARCHAR2 DEFAULT NULL,
132 P_LAST_UPDATED_BY in NUMBER := null,
133 P_LAST_UPDATE_LOGIN in NUMBER := null,
134 P_LAST_UPDATE_DATE in DATE := null,
135 p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,
136 p_commit IN VARCHAR2 := fnd_api.g_FALSE,
137 x_return_status OUT NOCOPY VARCHAR2,
138 x_errorcode OUT NOCOPY NUMBER,
139 x_msg_count OUT NOCOPY NUMBER,
140 x_msg_data OUT NOCOPY VARCHAR2
141 ) ;
142
143 procedure Delete_Dependency (
144 P_ROWID in ROWID
145 ) ;
146
147 procedure Create_Properties(
148 P_OBJECT_TYPE in VARCHAR2,
149 P_OBJECT_NAME in VARCHAR2,
150 P_OBJECT_OWNER in VARCHAR2,
151 P_SNAPSHOT_LOG_SQL in VARCHAR2,
152 P_FAST_REFRESH_FLAG in VARCHAR2,
153 P_DIMENSION_FLAG in VARCHAR2,
154 P_CUSTOM_API in VARCHAR2 default null,
155 P_CREATED_BY in NUMBER default null,
156 P_CREATION_DATE in DATE default null,
157 P_LAST_UPDATED_BY in NUMBER default null,
158 P_LAST_UPDATE_LOGIN in NUMBER default null,
159 P_LAST_UPDATE_DATE in DATE default null,
160 p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,
161 p_commit IN VARCHAR2 := fnd_api.g_FALSE,
162 x_return_status OUT NOCOPY VARCHAR2,
163 x_errorcode OUT NOCOPY NUMBER,
164 x_msg_count OUT NOCOPY NUMBER,
165 x_msg_data OUT NOCOPY VARCHAR2
166 ) ;
167
168 -- added for bug3040249
169 procedure Update_Obj_Last_Refresh_Date(
170 P_OBJECT_TYPE in VARCHAR2,
171 P_OBJECT_NAME in VARCHAR2,
172 P_LAST_REFRESH_DATE in DATE
173 );
174
175
176 procedure Update_Properties(
177 P_OBJECT_TYPE in VARCHAR2,
178 P_OBJECT_NAME in VARCHAR2,
179 P_OBJECT_OWNER in VARCHAR2,
180 P_SNAPSHOT_LOG_SQL in VARCHAR2,
181 P_FAST_REFRESH_FLAG in VARCHAR2,
182 P_DIMENSION_FLAG in VARCHAR2,
183 P_CUSTOM_API in VARCHAR2,
184 P_LAST_UPDATED_BY in NUMBER default null,
185 P_LAST_UPDATE_LOGIN in NUMBER default null,
186 P_LAST_UPDATE_DATE in DATE default null,
187 p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,
188 p_commit IN VARCHAR2 := fnd_api.g_FALSE,
189 x_return_status OUT NOCOPY VARCHAR2,
190 x_errorcode OUT NOCOPY NUMBER,
191 x_msg_count OUT NOCOPY NUMBER,
192 x_msg_data OUT NOCOPY VARCHAR2
193 ) ;
194
195 procedure Delete_Properties(
196 P_OBJECT_TYPE in VARCHAR2,
197 P_OBJECT_NAME in VARCHAR2
198 );
199
200 function Get_User_Object_Name (
201 P_OBJECT_TYPE IN VARCHAR2,
202 P_OBJECT_NAME IN VARCHAR2
203 ) RETURN varchar2;
204
205 /* starts BIS407 _OA Cleanup*/
206 function is_page_migrated (
207 P_PAGE_NAME in VARCHAR2
208 ) RETURN boolean;
209
210
211 function get_function_by_page (
212 P_PAGE_NAME in VARCHAR2
213 ) RETURN varchar2;
214
215 procedure migrate_page(
216 P_PAGE_NAME in VARCHAR2,
217 P_NEW_PAGE_NAME in VARCHAR2
218 );
219
220 /* ends BIS407 _OA Cleanup*/
221
222 /* starts: bug 3562027 -- change owner for parent object */
223 FUNCTION is_owner_changed (
224 p_obj_name IN VARCHAR2,
225 p_obj_type IN VARCHAR2,
226 p_new_obj_owner IN VARCHAR2,
227 p_actual_owner OUT NOCOPY VARCHAR2
228 ) RETURN VARCHAR2;
229
230 PROCEDURE change_prop_linkage_owner (
231 p_obj_name IN VARCHAR2,
232 p_obj_type IN VARCHAR2,
233 p_obj_owner IN VARCHAR2
234 );
235 /* sends: bug 3562027 -- change owner for parent object */
236
237 /* starts: bug 3881369 -- inner APIs not blocking exceptions*/
238
239 procedure Create_Properties_Inner(
240 P_OBJECT_TYPE in VARCHAR2,
241 P_OBJECT_NAME in VARCHAR2,
242 P_OBJECT_OWNER in VARCHAR2,
243 P_SNAPSHOT_LOG_SQL in VARCHAR2,
244 P_FAST_REFRESH_FLAG in VARCHAR2,
245 P_DIMENSION_FLAG in VARCHAR2,
246 P_CUSTOM_API in VARCHAR2 default null,
247 P_CREATED_BY in NUMBER default null,
248 P_CREATION_DATE in DATE default null,
249 P_LAST_UPDATED_BY in NUMBER default null,
250 P_LAST_UPDATE_LOGIN in NUMBER default null,
251 P_LAST_UPDATE_DATE in DATE default null,
252 p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,
253 p_commit IN VARCHAR2 := fnd_api.g_FALSE,
254 x_return_status OUT NOCOPY VARCHAR2,
255 x_errorcode OUT NOCOPY NUMBER,
256 x_msg_count OUT NOCOPY NUMBER,
257 x_msg_data OUT NOCOPY VARCHAR2
258 ) ;
259
260
261 procedure Update_Properties_Inner(
262 P_OBJECT_TYPE in VARCHAR2,
263 P_OBJECT_NAME in VARCHAR2,
264 P_OBJECT_OWNER in VARCHAR2,
265 P_SNAPSHOT_LOG_SQL in VARCHAR2,
266 P_FAST_REFRESH_FLAG in VARCHAR2,
267 P_DIMENSION_FLAG in VARCHAR2,
268 P_CUSTOM_API in VARCHAR2,
269 P_LAST_UPDATED_BY in NUMBER default null,
270 P_LAST_UPDATE_LOGIN in NUMBER default null,
271 P_LAST_UPDATE_DATE in DATE default null,
272 p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,
273 p_commit IN VARCHAR2 := fnd_api.g_FALSE,
274 x_return_status OUT NOCOPY VARCHAR2,
275 x_errorcode OUT NOCOPY NUMBER,
276 x_msg_count OUT NOCOPY NUMBER,
277 x_msg_data OUT NOCOPY VARCHAR2
278 ) ;
279
280 procedure Create_Dependency_Inner (
281 P_OBJECT_TYPE in VARCHAR2,
282 P_OBJECT_OWNER in VARCHAR2,
283 P_OBJECT_NAME in VARCHAR2,
284 P_ENABLED_FLAG in VARCHAR2,
285 P_DEPEND_OBJECT_TYPE in VARCHAR2,
286 P_DEPEND_OBJECT_OWNER in VARCHAR2,
287 P_DEPEND_OBJECT_NAME in VARCHAR2,
288 P_FROM_UI in VARCHAR2 DEFAULT NULL,
289 P_CREATED_BY in NUMBER := null,
290 P_CREATION_DATE in DATE := null,
291 P_LAST_UPDATED_BY in NUMBER := null,
292 P_LAST_UPDATE_LOGIN in NUMBER := null,
293 P_LAST_UPDATE_DATE in DATE := null,
294 p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,
295 p_commit IN VARCHAR2 := fnd_api.g_FALSE,
296 x_return_status OUT NOCOPY VARCHAR2,
297 x_errorcode OUT NOCOPY NUMBER,
298 x_msg_count OUT NOCOPY NUMBER,
299 x_msg_data OUT NOCOPY VARCHAR2
300 ) ;
301
302 procedure Update_Dependency_Inner (
303 P_ROWID in ROWID := null,
304 P_OBJECT_TYPE in VARCHAR2,
305 P_OBJECT_OWNER in VARCHAR2,
306 P_OBJECT_NAME in VARCHAR2,
307 P_ENABLED_FLAG in VARCHAR2,
308 P_DEPEND_OBJECT_TYPE in VARCHAR2,
309 P_DEPEND_OBJECT_OWNER in VARCHAR2,
310 P_DEPEND_OBJECT_NAME in VARCHAR2,
311 P_FROM_UI in VARCHAR2 DEFAULT NULL,
312 P_LAST_UPDATED_BY in NUMBER := null,
313 P_LAST_UPDATE_LOGIN in NUMBER := null,
314 P_LAST_UPDATE_DATE in DATE := null,
315 p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,
316 p_commit IN VARCHAR2 := fnd_api.g_FALSE,
317 x_return_status OUT NOCOPY VARCHAR2,
318 x_errorcode OUT NOCOPY NUMBER,
319 x_msg_count OUT NOCOPY NUMBER,
320 x_msg_data OUT NOCOPY VARCHAR2
321 ) ;
322
323 procedure Create_Linkage_Inner (
324 P_OBJECT_TYPE in VARCHAR2,
325 P_OBJECT_OWNER in VARCHAR2,
326 P_OBJECT_NAME in VARCHAR2,
327 P_CONC_PROGRAM_NAME in VARCHAR2,
328 P_CONC_APP_ID in NUMBER,
329 P_CONC_APP_SHORT_NAME in VARCHAR2,
330 P_ENABLED_FLAG in VARCHAR2,
331 P_REFRESH_MODE in VARCHAR2,
332 P_CREATED_BY in NUMBER := null,
333 P_CREATION_DATE in DATE := null,
334 P_LAST_UPDATED_BY in NUMBER := null,
335 P_LAST_UPDATE_LOGIN in NUMBER := null,
336 P_LAST_UPDATE_DATE in DATE := null,
337 p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,
338 p_commit IN VARCHAR2 := fnd_api.g_FALSE,
339 x_return_status OUT NOCOPY VARCHAR2,
340 x_errorcode OUT NOCOPY NUMBER,
341 x_msg_count OUT NOCOPY NUMBER,
342 x_msg_data OUT NOCOPY VARCHAR2
343 ) ;
344
345 procedure Update_Linkage_Inner (
346 P_ROWID in ROWID,
347 P_OBJECT_TYPE in VARCHAR2,
348 P_OBJECT_OWNER in VARCHAR2,
349 P_OBJECT_NAME in VARCHAR2,
350 P_CONC_PROGRAM_NAME in VARCHAR2,
351 P_CONC_APP_ID in NUMBER,
352 P_CONC_APP_SHORT_NAME in VARCHAR2,
353 P_ENABLED_FLAG in VARCHAR2,
354 P_REFRESH_MODE in VARCHAR2,
355 P_LAST_UPDATED_BY in NUMBER := null,
356 P_LAST_UPDATE_LOGIN in NUMBER := null,
357 P_LAST_UPDATE_DATE in DATE := null,
358 p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,
359 p_commit IN VARCHAR2 := fnd_api.g_FALSE,
360 x_return_status OUT NOCOPY VARCHAR2,
361 x_errorcode OUT NOCOPY NUMBER,
362 x_msg_count OUT NOCOPY NUMBER,
363 x_msg_data OUT NOCOPY VARCHAR2
364 ) ;
365 /* ends: bug 3881369 -- inner APIs not blocking exceptions*/
366
367 FUNCTION is_object_seeded
368 ( p_obj_name IN VARCHAR2,
369 p_obj_type IN VARCHAR2) return varchar2;
370 end bis_impl_dev_pkg;