1 PACKAGE fem_pl_pkg AS
2 /* $Header: fem_pl_pkh.pls 120.3 2006/03/22 14:02:43 gcheng ship $ */
3
4 PROCEDURE obj_def_data_edit_lock_exists (p_object_definition_id IN NUMBER,
5 x_data_edit_lock_exists OUT NOCOPY VARCHAR2);
6
7 PROCEDURE effective_date_incl_rslt_data (
8 p_api_version IN NUMBER,
9 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
10 p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE,
11 x_return_status OUT NOCOPY VARCHAR2,
12 x_msg_count OUT NOCOPY NUMBER,
13 x_msg_data OUT NOCOPY VARCHAR2,
14 p_object_definition_id IN NUMBER,
15 p_new_effective_start_date IN DATE,
16 p_new_effective_end_date IN DATE,
17 x_date_incl_rslt_data OUT NOCOPY VARCHAR2);
18
19 PROCEDURE effective_date_incl_rslt_data (
20 p_object_definition_id IN NUMBER,
21 p_new_effective_start_date IN DATE,
22 p_new_effective_end_date IN DATE,
23 x_msg_count OUT NOCOPY NUMBER,
24 x_msg_data OUT NOCOPY VARCHAR2,
25 x_date_incl_rslt_data OUT NOCOPY VARCHAR2);
26
27 PROCEDURE obj_def_approval_lock_exists (p_object_definition_id IN NUMBER,
28 x_approval_edit_lock_exists OUT NOCOPY VARCHAR2);
29
30 PROCEDURE get_object_def_edit_locks (p_object_definition_id IN NUMBER,
31 x_approval_edit_lock_exists OUT NOCOPY VARCHAR2,
32 x_data_edit_lock_exists OUT NOCOPY VARCHAR2);
33
34 PROCEDURE can_delete_object (
35 p_api_version IN NUMBER,
36 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
37 p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE,
38 x_return_status OUT NOCOPY VARCHAR2,
39 x_msg_count OUT NOCOPY NUMBER,
40 x_msg_data OUT NOCOPY VARCHAR2,
41 p_object_id IN NUMBER,
42 p_process_type IN NUMBER DEFAULT NULL,
43 x_can_delete_obj OUT NOCOPY VARCHAR2);
44
45 PROCEDURE can_delete_object (
46 p_object_id IN NUMBER,
47 p_process_type IN NUMBER DEFAULT NULL,
48 x_can_delete_obj OUT NOCOPY VARCHAR2,
49 x_msg_count OUT NOCOPY NUMBER,
50 x_msg_data OUT NOCOPY VARCHAR2);
51
52 PROCEDURE can_delete_object_def (
53 p_api_version IN NUMBER,
54 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
55 p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE,
56 x_return_status OUT NOCOPY VARCHAR2,
57 x_msg_count OUT NOCOPY NUMBER,
58 x_msg_data OUT NOCOPY VARCHAR2,
59 p_object_definition_id IN NUMBER,
60 p_process_type IN NUMBER DEFAULT NULL,
61 p_calling_program IN VARCHAR2 DEFAULT NULL,
62 x_can_delete_obj_def OUT NOCOPY VARCHAR2);
63
64 PROCEDURE can_delete_object_def (
65 p_object_definition_id IN NUMBER,
66 x_can_delete_obj_def OUT NOCOPY VARCHAR2,
67 x_msg_count OUT NOCOPY NUMBER,
68 x_msg_data OUT NOCOPY VARCHAR2,
69 p_process_type IN NUMBER DEFAULT NULL,
70 p_calling_program IN VARCHAR2 DEFAULT NULL);
71
72 PROCEDURE obj_execution_lock_exists (p_object_id IN NUMBER,
73 p_exec_object_definition_id IN NUMBER,
74 p_ledger_id IN NUMBER DEFAULT NULL,
75 p_cal_period_id IN NUMBER DEFAULT NULL,
76 p_output_dataset_code IN NUMBER DEFAULT NULL,
77 p_source_system_code IN NUMBER DEFAULT NULL,
78 p_exec_mode_code IN VARCHAR2 DEFAULT NULL,
79 p_dimension_id IN NUMBER DEFAULT NULL,
80 p_table_name IN VARCHAR2 DEFAULT NULL,
81 p_hierarchy_name IN VARCHAR2 DEFAULT NULL,
82 p_calling_context IN VARCHAR2 DEFAULT 'ENGINE',
83 x_exec_state OUT NOCOPY VARCHAR2,
84 x_prev_request_id OUT NOCOPY NUMBER,
85 x_msg_count OUT NOCOPY NUMBER,
86 x_msg_data OUT NOCOPY VARCHAR2,
87 x_exec_lock_exists OUT NOCOPY VARCHAR2);
88
89 PROCEDURE register_object_execution (p_api_version IN NUMBER,
90 p_commit IN VARCHAR2 := FND_API.G_FALSE,
91 p_request_id IN NUMBER,
92 p_object_id IN NUMBER,
93 p_exec_object_definition_id IN NUMBER,
94 p_user_id IN NUMBER,
95 p_last_update_login IN NUMBER,
96 p_exec_mode_code IN VARCHAR2 DEFAULT NULL,
97 x_exec_state OUT NOCOPY VARCHAR2,
98 x_prev_request_id OUT NOCOPY NUMBER,
99 x_msg_count OUT NOCOPY NUMBER,
100 x_msg_data OUT NOCOPY VARCHAR2,
101 x_return_status OUT NOCOPY VARCHAR2);
102
103 PROCEDURE register_request (p_api_version IN NUMBER,
104 p_commit IN VARCHAR2 := FND_API.G_FALSE,
105 p_cal_period_id IN NUMBER DEFAULT NULL,
106 p_ledger_id IN NUMBER DEFAULT NULL,
107 p_dataset_io_obj_def_id IN NUMBER DEFAULT NULL,
108 p_output_dataset_code IN NUMBER DEFAULT NULL,
109 p_source_system_code IN NUMBER DEFAULT NULL,
110 p_effective_date IN DATE DEFAULT NULL,
111 p_rule_set_obj_def_id IN NUMBER DEFAULT NULL,
112 p_rule_set_name IN VARCHAR2 DEFAULT NULL,
113 p_request_id IN NUMBER,
114 p_user_id IN NUMBER,
115 p_last_update_login IN NUMBER,
116 p_program_id IN NUMBER,
117 p_program_login_id IN NUMBER,
118 p_program_application_id IN NUMBER,
119 p_exec_mode_code IN VARCHAR2 DEFAULT NULL,
120 p_dimension_id IN NUMBER DEFAULT NULL,
121 p_table_name IN VARCHAR2 DEFAULT NULL,
122 p_hierarchy_name IN VARCHAR2 DEFAULT NULL,
123 x_msg_count OUT NOCOPY NUMBER,
124 x_msg_data OUT NOCOPY VARCHAR2,
125 x_return_status OUT NOCOPY VARCHAR2);
126
127 PROCEDURE unregister_request (p_api_version IN NUMBER,
128 p_commit IN VARCHAR2 := FND_API.G_FALSE,
129 p_request_id IN NUMBER,
130 x_msg_count OUT NOCOPY NUMBER,
131 x_msg_data OUT NOCOPY VARCHAR2,
132 x_return_status OUT NOCOPY VARCHAR2);
133
134 PROCEDURE update_request_status (p_api_version IN NUMBER,
135 p_commit IN VARCHAR2 := FND_API.G_FALSE,
136 p_request_id IN NUMBER,
137 p_exec_status_code IN VARCHAR2,
138 p_user_id IN NUMBER,
139 p_last_update_login IN NUMBER,
140 x_msg_count OUT NOCOPY NUMBER,
141 x_msg_data OUT NOCOPY VARCHAR2,
142 x_return_status OUT NOCOPY VARCHAR2);
143
144 PROCEDURE update_obj_exec_status (p_api_version IN NUMBER,
145 p_commit IN VARCHAR2 := FND_API.G_FALSE,
146 p_request_id IN NUMBER,
147 p_object_id IN NUMBER,
148 p_exec_status_code IN VARCHAR2,
149 p_user_id IN NUMBER,
150 p_last_update_login IN NUMBER,
151 x_msg_count OUT NOCOPY NUMBER,
152 x_msg_data OUT NOCOPY VARCHAR2,
153 x_return_status OUT NOCOPY VARCHAR2);
154
155 PROCEDURE update_obj_exec_errors (p_api_version IN NUMBER,
156 p_commit IN VARCHAR2 := FND_API.G_FALSE,
157 p_request_id IN NUMBER,
158 p_object_id IN NUMBER,
159 p_errors_reported IN NUMBER,
160 p_errors_reprocessed IN NUMBER,
161 p_user_id IN NUMBER,
162 p_last_update_login IN NUMBER,
163 x_msg_count OUT NOCOPY NUMBER,
164 x_msg_data OUT NOCOPY VARCHAR2,
165 x_return_status OUT NOCOPY VARCHAR2);
166
167 PROCEDURE register_object_def (p_api_version IN NUMBER,
168 p_commit IN VARCHAR2 := FND_API.G_FALSE,
169 p_request_id IN NUMBER,
170 p_object_id IN NUMBER,
171 p_object_definition_id IN NUMBER,
172 p_user_id IN NUMBER,
173 p_last_update_login IN NUMBER,
174 x_msg_count OUT NOCOPY NUMBER,
175 x_msg_data OUT NOCOPY VARCHAR2,
176 x_return_status OUT NOCOPY VARCHAR2);
177
178 PROCEDURE register_dependent_objdefs (p_api_version IN NUMBER,
179 p_commit IN VARCHAR2 := FND_API.G_FALSE,
180 p_request_id IN NUMBER,
181 p_object_id IN NUMBER,
182 p_exec_object_definition_id IN NUMBER,
183 p_effective_date IN DATE,
184 p_user_id IN NUMBER,
185 p_last_update_login IN NUMBER,
186 x_msg_count OUT NOCOPY NUMBER,
187 x_msg_data OUT NOCOPY VARCHAR2,
188 x_return_status OUT NOCOPY VARCHAR2);
189
190 PROCEDURE register_table (p_api_version IN NUMBER,
191 p_commit IN VARCHAR2 := FND_API.G_FALSE,
192 p_request_id IN NUMBER,
193 p_object_id IN NUMBER,
194 p_table_name IN VARCHAR2,
195 p_statement_type IN VARCHAR2,
196 p_num_of_output_rows IN NUMBER,
197 p_user_id IN NUMBER,
198 p_last_update_login IN NUMBER,
199 x_msg_count OUT NOCOPY NUMBER,
200 x_msg_data OUT NOCOPY VARCHAR2,
201 x_return_status OUT NOCOPY VARCHAR2);
202
203 PROCEDURE update_num_of_output_rows (p_api_version IN NUMBER,
204 p_commit IN VARCHAR2 := FND_API.G_FALSE,
205 p_request_id IN NUMBER,
206 p_object_id IN NUMBER,
207 p_table_name IN VARCHAR2,
208 p_statement_type IN VARCHAR2,
209 p_num_of_output_rows IN NUMBER,
210 p_user_id IN NUMBER,
211 p_last_update_login IN NUMBER,
212 x_msg_count OUT NOCOPY NUMBER,
213 x_msg_data OUT NOCOPY VARCHAR2,
214 x_return_status OUT NOCOPY VARCHAR2);
215
216 PROCEDURE register_updated_column (p_api_version IN NUMBER,
217 p_commit IN VARCHAR2 := FND_API.G_FALSE,
218 p_request_id IN NUMBER,
219 p_object_id IN NUMBER,
220 p_table_name IN VARCHAR2,
221 p_statement_type IN VARCHAR2,
222 p_column_name IN VARCHAR2,
223 p_user_id IN NUMBER,
224 p_last_update_login IN NUMBER,
225 x_msg_count OUT NOCOPY NUMBER,
226 x_msg_data OUT NOCOPY VARCHAR2,
227 x_return_status OUT NOCOPY VARCHAR2);
228
229 PROCEDURE register_chain (p_api_version IN NUMBER,
230 p_commit IN VARCHAR2 := FND_API.G_FALSE,
231 p_request_id IN NUMBER,
232 p_object_id IN NUMBER,
233 p_source_created_by_request_id IN NUMBER,
234 p_source_created_by_object_id IN NUMBER,
235 p_user_id IN NUMBER,
236 p_last_update_login IN NUMBER,
237 x_msg_count OUT NOCOPY NUMBER,
238 x_msg_data OUT NOCOPY VARCHAR2,
239 x_return_status OUT NOCOPY VARCHAR2);
240
241 PROCEDURE register_temp_object (p_api_version IN NUMBER,
242 p_commit IN VARCHAR2 := FND_API.G_FALSE,
243 p_request_id IN NUMBER,
244 p_object_id IN NUMBER,
245 p_object_type IN VARCHAR2,
249 x_msg_count OUT NOCOPY NUMBER,
246 p_object_name IN VARCHAR2,
247 p_user_id IN NUMBER,
248 p_last_update_login IN NUMBER,
250 x_msg_data OUT NOCOPY VARCHAR2,
251 x_return_status OUT NOCOPY VARCHAR2);
252
253 PROCEDURE update_num_of_input_rows (p_api_version IN NUMBER,
254 p_commit IN VARCHAR2 := FND_API.G_FALSE,
255 p_request_id IN NUMBER,
256 p_object_id IN NUMBER,
257 p_num_of_input_rows IN NUMBER,
258 p_user_id IN NUMBER,
259 p_last_update_login IN NUMBER,
260 x_msg_count OUT NOCOPY NUMBER,
261 x_msg_data OUT NOCOPY VARCHAR2,
262 x_return_status OUT NOCOPY VARCHAR2);
263
264 PROCEDURE register_obj_exec_step (p_api_version IN NUMBER,
265 p_commit IN VARCHAR2 := FND_API.G_FALSE,
266 p_request_id IN NUMBER,
267 p_object_id IN NUMBER,
268 p_exec_step IN VARCHAR2,
269 p_exec_status_code IN VARCHAR2,
270 p_user_id IN NUMBER,
271 p_last_update_login IN NUMBER,
272 x_msg_count OUT NOCOPY NUMBER,
273 x_msg_data OUT NOCOPY VARCHAR2,
274 x_return_status OUT NOCOPY VARCHAR2);
275
276 PROCEDURE unregister_obj_exec_step (p_api_version IN NUMBER,
277 p_commit IN VARCHAR2 := FND_API.G_FALSE,
278 p_request_id IN NUMBER,
279 p_object_id IN NUMBER,
280 p_exec_step IN VARCHAR2,
281 x_msg_count OUT NOCOPY NUMBER,
282 x_msg_data OUT NOCOPY VARCHAR2,
283 x_return_status OUT NOCOPY VARCHAR2);
284
285 PROCEDURE unregister_obj_exec_steps (p_api_version IN NUMBER,
286 p_commit IN VARCHAR2 := FND_API.G_FALSE,
287 p_request_id IN NUMBER,
288 p_object_id IN NUMBER,
289 x_msg_count OUT NOCOPY NUMBER,
290 x_msg_data OUT NOCOPY VARCHAR2,
291 x_return_status OUT NOCOPY VARCHAR2);
292
293 PROCEDURE update_obj_exec_step_status (p_api_version IN NUMBER,
294 p_commit IN VARCHAR2 := FND_API.G_FALSE,
295 p_request_id IN NUMBER,
296 p_object_id IN NUMBER,
297 p_exec_step IN VARCHAR2,
298 p_exec_status_code IN VARCHAR2,
299 p_user_id IN NUMBER,
300 p_last_update_login IN NUMBER,
301 x_msg_count OUT NOCOPY NUMBER,
302 x_msg_data OUT NOCOPY VARCHAR2,
303 x_return_status OUT NOCOPY VARCHAR2);
304
305 PROCEDURE set_exec_state (p_api_version IN NUMBER,
306 p_commit IN VARCHAR2 := FND_API.G_FALSE,
307 p_request_id IN NUMBER,
308 p_object_id IN NUMBER,
309 x_msg_count OUT NOCOPY NUMBER,
310 x_msg_data OUT NOCOPY VARCHAR2,
311 x_return_status OUT NOCOPY VARCHAR2);
312
313 PROCEDURE mapping_exec_lock_exists (p_object_id IN NUMBER,
314 p_exec_object_definition_id IN NUMBER,
315 p_ledger_id IN NUMBER,
316 p_cal_period_id IN NUMBER,
317 p_output_dataset_code IN NUMBER,
318 p_calling_context IN VARCHAR2 DEFAULT 'ENGINE',
319 x_exec_state OUT NOCOPY VARCHAR2,
320 x_prev_request_id OUT NOCOPY NUMBER,
321 x_msg_count OUT NOCOPY NUMBER,
322 x_msg_data OUT NOCOPY VARCHAR2,
323 x_exec_lock_exists OUT NOCOPY VARCHAR2);
324
325 PROCEDURE dim_mbr_ldr_exec_lock_exists (p_object_id IN NUMBER,
326 p_exec_object_definition_id IN NUMBER,
327 p_calling_context IN VARCHAR2 DEFAULT 'ENGINE',
328 x_exec_state OUT NOCOPY VARCHAR2,
329 x_msg_count OUT NOCOPY NUMBER,
330 x_msg_data OUT NOCOPY VARCHAR2,
331 x_exec_lock_exists OUT NOCOPY VARCHAR2,
332 x_prev_request_id OUT NOCOPY NUMBER);
333
334 PROCEDURE datax_ldr_exec_lock_exists (p_object_id IN NUMBER,
335 p_exec_object_definition_id IN NUMBER,
336 p_ledger_id IN NUMBER,
337 p_cal_period_id IN NUMBER,
338 p_output_dataset_code IN NUMBER,
339 p_source_system_code IN NUMBER,
340 p_table_name IN VARCHAR2,
341 p_calling_context IN VARCHAR2 DEFAULT 'ENGINE',
342 x_exec_state OUT NOCOPY VARCHAR2,
343 x_prev_request_id OUT NOCOPY NUMBER,
344 x_msg_count OUT NOCOPY NUMBER,
345 x_msg_data OUT NOCOPY VARCHAR2,
346 x_exec_lock_exists OUT NOCOPY VARCHAR2);
347
348 PROCEDURE hier_ldr_exec_lock_exists (p_object_id IN NUMBER,
349 p_exec_object_definition_id IN NUMBER,
350 p_hierarchy_name IN VARCHAR2,
351 p_calling_context IN VARCHAR2 DEFAULT 'ENGINE',
352 x_exec_state OUT NOCOPY VARCHAR2,
353 x_msg_count OUT NOCOPY NUMBER,
354 x_msg_data OUT NOCOPY VARCHAR2,
355 x_exec_lock_exists OUT NOCOPY VARCHAR2,
356 x_prev_request_id OUT NOCOPY NUMBER);
357
358 PROCEDURE rcm_proc_exec_lock_exists (p_object_id IN NUMBER,
359 p_exec_object_definition_id IN NUMBER,
360 p_ledger_id IN NUMBER,
361 p_cal_period_id IN NUMBER,
362 p_output_dataset_code IN NUMBER,
363 p_calling_context IN VARCHAR2 DEFAULT 'ENGINE',
364 x_exec_state OUT NOCOPY VARCHAR2,
365 x_prev_request_id OUT NOCOPY NUMBER,
366 x_msg_count OUT NOCOPY NUMBER,
367 x_msg_data OUT NOCOPY VARCHAR2,
368 x_exec_lock_exists OUT NOCOPY VARCHAR2);
369
370
371 PROCEDURE check_chaining (
372 p_api_version IN NUMBER DEFAULT 1.0,
373 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
374 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
375 p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE,
376 x_return_status OUT NOCOPY VARCHAR2,
377 x_msg_count OUT NOCOPY NUMBER,
378 x_msg_data OUT NOCOPY VARCHAR2,
379 p_request_id IN NUMBER,
380 p_object_id IN NUMBER,
381 x_dep_request_id OUT NOCOPY NUMBER,
382 x_dep_object_id OUT NOCOPY NUMBER,
383 x_chain_exists OUT NOCOPY VARCHAR2);
384
385 PROCEDURE get_exec_status (
386 p_api_version IN NUMBER DEFAULT 1.0,
387 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
388 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
389 p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE,
390 x_return_status OUT NOCOPY VARCHAR2,
391 x_msg_count OUT NOCOPY NUMBER,
392 x_msg_data OUT NOCOPY VARCHAR2,
393 p_request_id IN NUMBER,
394 p_object_id IN NUMBER,
395 x_exec_status_code OUT NOCOPY VARCHAR2);
396
397
398 END fem_pl_pkg;
|
|
|