[Home] [Help]
PACKAGE: APPS.FEM_TABLE_REGISTRATION_PKG
Source
1 PACKAGE fem_table_registration_pkg AS
2 /* $Header: FEMTABREGS.pls 120.5 2007/05/08 10:40:16 ugoswami ship $ */
3
4 g_log_level_1 CONSTANT NUMBER := fnd_log.level_statement;
5 g_log_level_2 CONSTANT NUMBER := fnd_log.level_procedure;
6 g_log_level_3 CONSTANT NUMBER := fnd_log.level_event;
7 g_log_level_4 CONSTANT NUMBER := fnd_log.level_exception;
8 g_log_level_5 CONSTANT NUMBER := fnd_log.level_error;
9 g_log_level_6 CONSTANT NUMBER := fnd_log.level_unexpected;
10 g_block CONSTANT VARCHAR2(30) := 'FEM_TABLE_REGISTRATION_PKG';
11 g_table_name CONSTANT VARCHAR2(10) :='TABLE_NAME';
12
13 c_false CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
14 c_true CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
15 c_success CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
16 c_error CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
17 c_unexp CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
18 G_FEM CONSTANT VARCHAR2(3) := 'FEM';
19 c_api_version CONSTANT NUMBER := 1.0;
20
21 PROCEDURE synchronize(p_api_version IN NUMBER,
22 p_init_msg_list IN VARCHAR2,
23 p_commit IN VARCHAR2,
24 p_encoded IN VARCHAR2,
25 p_table_name IN VARCHAR2,
26 p_synchronize_flag OUT NOCOPY VARCHAR2,
27 x_msg_count OUT NOCOPY NUMBER,
28 x_msg_data OUT NOCOPY VARCHAR2,
29 x_return_status OUT NOCOPY VARCHAR2);
30
31 PROCEDURE unregister(p_api_version IN NUMBER,
32 p_init_msg_list IN VARCHAR2,
33 p_commit IN VARCHAR2,
34 p_encoded IN VARCHAR2,
35 p_table_name IN VARCHAR2,
36 x_msg_count OUT NOCOPY NUMBER,
37 x_msg_data OUT NOCOPY VARCHAR2,
38 x_return_status OUT NOCOPY VARCHAR2);
39
40
41 PROCEDURE init(p_api_version IN NUMBER,
42 p_init_msg_list IN VARCHAR2,
43 p_commit IN VARCHAR2,
44 p_encoded IN VARCHAR2,
45 x_msg_count OUT NOCOPY NUMBER,
46 x_msg_data OUT NOCOPY VARCHAR2,
47 x_return_status OUT NOCOPY VARCHAR2);
48
49 PROCEDURE validateClass( p_api_version IN NUMBER,
50 p_init_msg_list IN VARCHAR2,
51 p_commit IN VARCHAR2,
52 p_encoded IN VARCHAR2,
53 p_table_name IN VARCHAR2,
54 x_msg_count OUT NOCOPY NUMBER,
55 x_msg_data OUT NOCOPY VARCHAR2,
56 x_return_status OUT NOCOPY VARCHAR2);
57
58 PROCEDURE populate_tab_col_gt(p_api_version IN NUMBER default c_api_version,
59 p_init_msg_list IN VARCHAR2 default c_false,
60 p_commit IN VARCHAR2 default c_false,
61 p_encoded IN VARCHAR2 default c_true,
62 p_mode IN VARCHAR2,
63 p_owner IN VARCHAR2,
64 p_table_name IN VARCHAR2,
65 x_msg_count OUT NOCOPY NUMBER,
66 x_msg_data OUT NOCOPY VARCHAR2,
67 x_return_status OUT NOCOPY VARCHAR2);
68
69 PROCEDURE populate_tab_col_vl(p_api_version IN NUMBER default c_api_version,
70 p_init_msg_list IN VARCHAR2 default c_false,
71 p_commit IN VARCHAR2 default c_false,
72 p_encoded IN VARCHAR2 default c_true,
73 p_table_name IN VARCHAR2,
74 p_skip_validation IN VARCHAR2,
75 p_mode IN VARCHAR2,
76 x_msg_count OUT NOCOPY NUMBER,
77 x_msg_data OUT NOCOPY VARCHAR2,
78 x_return_status OUT NOCOPY VARCHAR2);
79
80 PROCEDURE dump_gt(p_api_version IN NUMBER default c_api_version,
81 p_init_msg_list IN VARCHAR2 default c_false,
82 p_commit IN VARCHAR2 default c_false,
83 p_encoded IN VARCHAR2 default c_true,
84 x_msg_count OUT NOCOPY NUMBER,
85 x_msg_data OUT NOCOPY VARCHAR2,
86 x_return_status OUT NOCOPY VARCHAR2);
87
88 PROCEDURE raise_proc_key_update_event(p_table_name IN VARCHAR2,
89 x_msg_count OUT NOCOPY NUMBER,
90 x_msg_data OUT NOCOPY VARCHAR2,
91 x_return_status OUT NOCOPY VARCHAR2);
92
93 FUNCTION is_table_registered(p_table_name IN VARCHAR2) RETURN VARCHAR2;
94
95 FUNCTION is_table_column_registered(p_table_name IN VARCHAR2,
96 p_column_name IN VARCHAR2) RETURN VARCHAR2;
97
98 FUNCTION is_table_class_code_valid(p_table_name VARCHAR2,
99 p_table_class_code VARCHAR2) RETURN VARCHAR2;
100
101 FUNCTION is_table_class_list_valid(p_table_name VARCHAR2,
102 p_table_class_lookup_type VARCHAR2) RETURN VARCHAR2;
103
104 FUNCTION get_schema_name(p_app_id IN NUMBER) RETURN VARCHAR2;
105
106 FUNCTION get_schema_name(p_app_short_name IN VARCHAR2) RETURN VARCHAR2;
107
108 PROCEDURE get_tab_list(p_view_name IN VARCHAR2,
109 x_msg_count OUT NOCOPY NUMBER,
110 x_msg_data OUT NOCOPY VARCHAR2,
111 x_return_status OUT NOCOPY VARCHAR2);
112
113 FUNCTION get_Object_Type(p_object_name IN VARCHAR2) RETURN VARCHAR2;
114 FUNCTION get_Fem_Object_Type(p_object_name IN VARCHAR2) RETURN VARCHAR2;
115
116 FUNCTION get_di_view_details(p_table_name IN VARCHAR2) RETURN VARCHAR2;
117
118 PROCEDURE GenerateSysView ( errbuf OUT NOCOPY VARCHAR2
119 ,retcode OUT NOCOPY VARCHAR2
120 ,p_tab_name IN VARCHAR
121 ,p_view_name IN VARCHAR);
122
123 PROCEDURE GenerateAllViews(errbuf OUT NOCOPY VARCHAR2
124 ,retcode OUT NOCOPY VARCHAR2) ;
125
126 END fem_table_registration_pkg;