[Home] [Help]
PACKAGE: APPS.FEM_ADMIN_UTIL_PKG
Source
1 PACKAGE FEM_Admin_Util_Pkg AS
2 -- $Header: fem_adm_utl.pls 120.4 2008/02/06 23:14:06 ghall ship $
3
4 c_false CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
5 c_true CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
6 c_api_version CONSTANT NUMBER := 1.0;
7
8 PROCEDURE Delete_Obj_Tuning_Options (
9 p_api_version IN NUMBER DEFAULT c_api_version,
10 p_init_msg_list IN VARCHAR2 DEFAULT c_false,
11 p_commit IN VARCHAR2 DEFAULT c_false,
12 p_encoded IN VARCHAR2 DEFAULT c_true,
13 x_return_status OUT NOCOPY VARCHAR2,
14 x_msg_count OUT NOCOPY NUMBER,
15 x_msg_data OUT NOCOPY VARCHAR2,
16 p_object_id IN NUMBER
17 );
18
19 PROCEDURE New_Local_VS_Combo_ID (
20 p_api_version IN NUMBER DEFAULT c_api_version,
21 p_init_msg_list IN VARCHAR2 DEFAULT c_false,
22 p_commit IN VARCHAR2 DEFAULT c_false,
23 p_encoded IN VARCHAR2 DEFAULT c_true,
24 x_return_status OUT NOCOPY VARCHAR2,
25 x_msg_count OUT NOCOPY NUMBER,
26 x_msg_data OUT NOCOPY VARCHAR2,
27 p_gvsc_id IN NUMBER
28 );
29
30 PROCEDURE Validate_Tab_Class_Assignmt (
31 p_api_version IN NUMBER DEFAULT c_api_version,
32 p_init_msg_list IN VARCHAR2 DEFAULT c_false,
33 p_commit IN VARCHAR2 DEFAULT c_false,
34 p_encoded IN VARCHAR2 DEFAULT c_true,
35 x_return_status OUT NOCOPY VARCHAR2,
36 x_msg_count OUT NOCOPY NUMBER,
37 x_msg_data OUT NOCOPY VARCHAR2,
38 p_tab_name IN VARCHAR2
39 );
40
41 PROCEDURE Validate_Tab_Class (
42 p_tab_name IN VARCHAR2,
43 p_tab_class_cd IN VARCHAR2,
44 x_passed_validation OUT NOCOPY VARCHAR2
45 );
46
47 PROCEDURE Validate_View_Class (
48 p_view_name IN VARCHAR2,
49 p_tab_class_cd IN VARCHAR2,
50 x_passed_validation OUT NOCOPY VARCHAR2
51 );
52
53 PROCEDURE Validate_obj_Class_Assignmt (
54 p_api_version IN NUMBER DEFAULT c_api_version,
55 p_init_msg_list IN VARCHAR2 DEFAULT c_false,
56 p_commit IN VARCHAR2 DEFAULT c_false,
57 p_encoded IN VARCHAR2 DEFAULT c_true,
58 x_return_status OUT NOCOPY VARCHAR2,
59 x_msg_count OUT NOCOPY NUMBER,
60 x_msg_data OUT NOCOPY VARCHAR2,
61 p_obj_name IN VARCHAR2,
62 p_obj_type IN VARCHAR2
63 );
64
65 PROCEDURE Get_Table_Owner_for_View (
66 p_api_version IN NUMBER DEFAULT c_api_version,
67 p_init_msg_list IN VARCHAR2 DEFAULT c_false,
68 p_commit IN VARCHAR2 DEFAULT c_false,
69 p_encoded IN VARCHAR2 DEFAULT c_true,
70 x_return_status OUT NOCOPY VARCHAR2,
71 x_msg_count OUT NOCOPY NUMBER,
72 x_msg_data OUT NOCOPY VARCHAR2,
73 p_view_name IN VARCHAR2,
74 x_tab_name OUT NOCOPY VARCHAR2,
75 x_tab_owner OUT NOCOPY VARCHAR2
76 );
77 PROCEDURE Get_Index_Owner_for_View (
78 p_api_version IN NUMBER DEFAULT c_api_version,
79 p_init_msg_list IN VARCHAR2 DEFAULT c_false,
80 p_commit IN VARCHAR2 DEFAULT c_false,
81 p_encoded IN VARCHAR2 DEFAULT c_true,
82 x_return_status OUT NOCOPY VARCHAR2,
83 x_msg_count OUT NOCOPY NUMBER,
84 x_msg_data OUT NOCOPY VARCHAR2,
85 p_view_name IN VARCHAR2,
86 p_index_name IN VARCHAR2,
87 x_tab_name OUT NOCOPY VARCHAR2,
88 x_tab_owner OUT NOCOPY VARCHAR2 );
89
90 END FEM_Admin_Util_Pkg;