1 PACKAGE FEM_OBJECT_CATALOG_UTIL_PKG AS
2 /* $Header: fem_objcat_utl.pls 120.2 2005/07/26 13:59:38 appldev ship $ */
3 -- Declare package procedures
4 PROCEDURE create_object (x_object_id OUT NOCOPY NUMBER,
5 x_object_definition_id OUT NOCOPY NUMBER,
6 x_msg_count OUT NOCOPY NUMBER,
7 x_msg_data OUT NOCOPY VARCHAR2,
8 x_return_status OUT NOCOPY VARCHAR2,
9 p_api_version IN NUMBER,
10 p_commit IN VARCHAR2,
11 p_object_type_code IN VARCHAR2,
12 p_folder_id IN NUMBER,
13 p_local_vs_combo_id IN NUMBER,
14 p_object_access_code IN VARCHAR2,
15 p_object_origin_code IN VARCHAR2,
16 p_object_name IN VARCHAR2,
17 p_description IN VARCHAR2,
18 p_effective_start_date IN DATE DEFAULT sysdate,
19 p_effective_end_date IN DATE DEFAULT to_date('9999/01/01','YYYY/MM/DD'),
20 p_obj_def_name IN VARCHAR2);
21
22 PROCEDURE create_object_definition (x_object_definition_id OUT NOCOPY NUMBER,
23 x_msg_count OUT NOCOPY NUMBER,
24 x_msg_data OUT NOCOPY VARCHAR2,
25 x_return_status OUT NOCOPY VARCHAR2,
26 p_api_version IN NUMBER,
27 p_commit IN VARCHAR2,
28 p_object_id IN NUMBER,
29 p_effective_start_date IN DATE,
30 p_effective_end_date IN DATE,
31 p_obj_def_name IN VARCHAR2,
32 p_object_origin_code IN VARCHAR2);
33
34 PROCEDURE validate_obj_def_effdate (x_date_range_is_valid OUT NOCOPY VARCHAR2,
35 x_msg_count OUT NOCOPY NUMBER,
36 x_msg_data OUT NOCOPY VARCHAR2,
37 p_object_id IN NUMBER,
38 p_new_effective_start_date IN DATE,
39 p_new_effective_end_date IN DATE);
40
41 PROCEDURE delete_object (x_msg_count OUT NOCOPY NUMBER,
42 x_msg_data OUT NOCOPY VARCHAR2,
43 x_return_status OUT NOCOPY VARCHAR2,
44 p_api_version IN NUMBER,
45 p_commit IN VARCHAR2,
46 p_object_id IN NUMBER);
47
48
49 END fem_object_catalog_util_pkg;
50
51