[Home] [Help]
PACKAGE: APPS.FEM_MIR_PKG
Source
1 PACKAGE FEM_MIR_PKG AUTHID CURRENT_USER AS
2 -- $Header: FEM_MIRS.pls 120.6 2007/05/04 05:52:47 pkakkar ship $
3
4
5 ------------------------------------------------------------
6 -- Global constants definitions
7 -----------------------------------------------------------
8 g_unexpected_exception EXCEPTION;
9
10 G_ZIP_FILE_NAME CONSTANT VARCHAR2(15) := 'ZIP_FILE_NAME';
11 G_SELECTION_SET_NAME CONSTANT VARCHAR2(30) := 'SELECTION_SET_NAME';
12 G_API_NAME CONSTANT VARCHAR2(15) := 'API_NAME';
13 G_PRODUCT_NAME CONSTANT VARCHAR2(15) := 'PRODUCT_NAME';
14 G_DESCRIPTION CONSTANT VARCHAR2(15) := 'DESCRIPTION';
15 G_URL CONSTANT VARCHAR2(4) := 'URL';
16 G_IN_AGENT CONSTANT VARCHAR2(15) := 'IN_AGENT';
17 G_OUT_AGENT CONSTANT VARCHAR2(15) := 'OUT_AGENT';
18 G_USER_ID CONSTANT VARCHAR2(15) := 'USER_ID';
19 G_USER_NAME CONSTANT VARCHAR2(15) := 'USER_NAME';
20 G_CONFIG_ID CONSTANT VARCHAR2(15) := 'CONFIG_ID';
21 G_REQUEST_ID CONSTANT VARCHAR2(15) := 'REQUEST_ID';
22 G_EVENT_KEY CONSTANT VARCHAR2(15) := 'EVENT_KEY';
23 G_RESP_ID CONSTANT VARCHAR2(15) := 'RESP_ID';
24 G_RESP_APPL_ID CONSTANT VARCHAR2(15) := 'RESP_APPL_ID';
25 G_IMPORT_DATA CONSTANT VARCHAR2(15) := 'IMPORT_DATA';
26 G_DB_HOST CONSTANT VARCHAR2(30) := 'DB_HOST';
27 G_TWOTASK CONSTANT VARCHAR2(30) := 'TWO_TASK';
28 G_FEM CONSTANT VARCHAR2(3) := 'FEM';
29 c_fem_ledger CONSTANT VARCHAR2(30) := 'FEM_LEDGER';
30 c_false CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
31 c_true CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
32 c_success CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
33 c_error CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
34 c_unexp CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
35 c_log_level_1 CONSTANT NUMBER := fnd_log.level_statement;
36 c_log_level_2 CONSTANT NUMBER := fnd_log.level_procedure;
37 c_log_level_3 CONSTANT NUMBER := fnd_log.level_event;
38 c_log_level_4 CONSTANT NUMBER := fnd_log.level_exception;
39 c_log_level_5 CONSTANT NUMBER := fnd_log.level_error;
40 c_log_level_6 CONSTANT NUMBER := fnd_log.level_unexpected;
41 c_api_version CONSTANT NUMBER := 1.0;
42 -----------------------------------------------------------
43
44 FUNCTION Get_Dim_Group_Display_Code(
45 p_dimension_varchar_label IN VARCHAR2,
46 p_dimension_group_id IN NUMBER
47 ) RETURN VARCHAR2 ;
48
49 FUNCTION Get_Dim_Group_Display_Code(
50 p_dimension_id IN NUMBER,
51 p_dimension_group_id IN NUMBER
52 ) RETURN VARCHAR2 ;
53
54 FUNCTION Get_Dim_Group_ID(
55 p_api_version IN NUMBER DEFAULT 1.0,
56 p_init_msg_list IN VARCHAR2 DEFAULT c_false,
57 p_commit IN VARCHAR2 DEFAULT c_false,
58 p_encoded IN VARCHAR2 DEFAULT c_true,
59 x_return_status OUT NOCOPY VARCHAR2,
60 x_msg_count OUT NOCOPY NUMBER,
61 x_msg_data OUT NOCOPY VARCHAR2,
62 p_dimension_varchar_label IN VARCHAR2,
63 p_dim_group_display_code IN VARCHAR2
64 ) RETURN NUMBER ;
65
66 FUNCTION Get_Dim_Group_ID(
67 p_api_version IN NUMBER DEFAULT 1.0,
68 p_init_msg_list IN VARCHAR2 DEFAULT c_false,
69 p_commit IN VARCHAR2 DEFAULT c_false,
70 p_encoded IN VARCHAR2 DEFAULT c_true,
71 x_return_status OUT NOCOPY VARCHAR2,
72 x_msg_count OUT NOCOPY NUMBER,
73 x_msg_data OUT NOCOPY VARCHAR2,
74 p_dimension_id IN NUMBER,
75 p_dim_group_display_code IN VARCHAR2
76 ) RETURN NUMBER ;
77
78 FUNCTION Hier_Dim_Grp_Exists(
79 p_api_version IN NUMBER DEFAULT 1.0,
80 p_init_msg_list IN VARCHAR2 DEFAULT c_false,
81 p_commit IN VARCHAR2 DEFAULT c_false,
82 p_encoded IN VARCHAR2 DEFAULT c_true,
83 x_return_status OUT NOCOPY VARCHAR2,
84 x_msg_count OUT NOCOPY NUMBER,
85 x_msg_data OUT NOCOPY VARCHAR2,
86 p_dimension_varchar_label IN VARCHAR2,
87 p_hierarchy_name IN VARCHAR2,
88 p_dim_group_display_code IN VARCHAR2
89 ) RETURN VARCHAR2 ;
90
91 FUNCTION Validate_Hier_Dim_Grps_Order(
92 p_api_version IN NUMBER DEFAULT 1.0,
93 p_init_msg_list IN VARCHAR2 DEFAULT c_false,
94 p_commit IN VARCHAR2 DEFAULT c_false,
95 p_encoded IN VARCHAR2 DEFAULT c_true,
96 x_return_status OUT NOCOPY VARCHAR2,
97 x_msg_count OUT NOCOPY NUMBER,
98 x_msg_data OUT NOCOPY VARCHAR2,
99 p_dimension_varchar_label IN VARCHAR2,
100 p_hierarchy_name IN VARCHAR2,
101 p_parent_dim_grp_dsp_code IN VARCHAR2,
102 p_child_dim_grp_dsp_code IN VARCHAR2
103 ) RETURN VARCHAR2 ;
104
105 FUNCTION Get_Dim_Attr_Varchar_label (
106 p_attribute_id IN NUMBER
107 ) RETURN VARCHAR2;
108
109
110 FUNCTION Get_Dim_Attribute_ID (
111 p_api_version IN NUMBER DEFAULT 1.0
112 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
113 ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
114 ,p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE
115 ,x_return_status OUT NOCOPY VARCHAR2
116 ,x_msg_count OUT NOCOPY NUMBER
117 ,x_msg_data OUT NOCOPY VARCHAR2
118 ,p_dimension_varchar_label IN VARCHAR2
119 ,p_dim_attribute_varchar_label IN VARCHAR2
120 ) RETURN NUMBER;
121
122 FUNCTION Get_Dim_Attribute_ID (
123 p_api_version IN NUMBER DEFAULT 1.0
124 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
125 ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
126 ,p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE
127 ,x_return_status OUT NOCOPY VARCHAR2
128 ,x_msg_count OUT NOCOPY NUMBER
129 ,x_msg_data OUT NOCOPY VARCHAR2
130 ,p_dimension_id IN NUMBER
131 ,p_dim_attribute_varchar_label IN VARCHAR2
132 ) RETURN NUMBER;
133
134 FUNCTION Get_Dim_Attr_Ver_Display_Code (
135 p_attribute_id IN NUMBER
136 ,p_version_id IN NUMBER
137 ) RETURN VARCHAR2;
138
139 FUNCTION Get_Dim_Attr_Ver_Display_Code (
140 p_dim_attr_varchar_label IN VARCHAR2
141 ,p_version_id IN NUMBER
142 ) RETURN VARCHAR2;
143
144 FUNCTION Get_Dim_Attr_Version_ID (
145 p_api_version IN NUMBER DEFAULT 1.0
146 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
147 ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
148 ,p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE
149 ,x_return_status OUT NOCOPY VARCHAR2
150 ,x_msg_count OUT NOCOPY NUMBER
151 ,x_msg_data OUT NOCOPY VARCHAR2
152 ,p_dim_attr_varchar_label IN VARCHAR2
153 ,p_dim_attr_ver_display_code IN VARCHAR2
154 ) RETURN NUMBER;
155
156
157 FUNCTION Get_Dim_Attr_Version_ID (
158 p_api_version IN NUMBER DEFAULT 1.0
159 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
160 ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
161 ,p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE
162 ,x_return_status OUT NOCOPY VARCHAR2
163 ,x_msg_count OUT NOCOPY NUMBER
164 ,x_msg_data OUT NOCOPY VARCHAR2
165 ,p_dim_attribute_id IN NUMBER
166 ,p_dim_attr_ver_display_code IN VARCHAR2
167 ) RETURN NUMBER;
168
169 FUNCTION Get_Dim_Member_Display_Code (
170 p_dimension_id IN NUMBER
171 ,p_member_id IN NUMBER
172 ) RETURN VARCHAR2;
173
174 FUNCTION Get_Dim_Member_Display_Code (
175 p_dimension_varchar_label IN VARCHAR2
176 ,p_member_id IN NUMBER
177 ) RETURN VARCHAR2;
178
179 FUNCTION Get_Dim_Member_ID (
180 p_api_version IN NUMBER DEFAULT 1.0
181 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
182 ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
183 ,p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE
184 ,x_return_status OUT NOCOPY VARCHAR2
185 ,x_msg_count OUT NOCOPY NUMBER
186 ,x_msg_data OUT NOCOPY VARCHAR2
187 ,p_dimension_varchar_label IN VARCHAR2
188 ,p_member_display_code IN VARCHAR2
189 ) RETURN NUMBER;
190
191 FUNCTION Get_Dim_Member_ID (
192 p_api_version IN NUMBER DEFAULT 1.0
193 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
194 ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
195 ,p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE
196 ,x_return_status OUT NOCOPY VARCHAR2
197 ,x_msg_count OUT NOCOPY NUMBER
198 ,x_msg_data OUT NOCOPY VARCHAR2
199 ,p_dimension_id IN NUMBER
200 ,p_member_display_code IN VARCHAR2
201 ) RETURN NUMBER ;
202
203 FUNCTION Get_Value_Set_Display_Code (
204 p_value_set_id IN NUMBER
205 ) RETURN VARCHAR2;
206
207 FUNCTION Get_Value_Set_ID (
208 p_api_version IN NUMBER DEFAULT 1.0
209 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
210 ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
211 ,p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE
212 ,x_return_status OUT NOCOPY VARCHAR2
213 ,x_msg_count OUT NOCOPY NUMBER
214 ,x_msg_data OUT NOCOPY VARCHAR2
215 ,p_value_set_display_code IN VARCHAR2
216 ) RETURN NUMBER;
217
218 FUNCTION Get_Gl_Period_Num(
219 p_cal_period_id IN NUMBER
220 ) RETURN NUMBER;
221
222 FUNCTION Get_Cal_Period_End_Date(
223 p_cal_period_id IN NUMBER
224 ) RETURN DATE;
225
226 FUNCTION Get_Object_ID (
227 p_api_version IN NUMBER DEFAULT 1.0
228 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
229 ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
230 ,p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE
231 ,x_return_status OUT NOCOPY VARCHAR2
232 ,x_msg_count OUT NOCOPY NUMBER
233 ,x_msg_data OUT NOCOPY VARCHAR2
234 ,p_object_def_id IN NUMBER
235 ) RETURN NUMBER;
236
237 FUNCTION Get_Dimension_Id(
238 p_api_version IN NUMBER DEFAULT 1.0
239 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
240 ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
241 ,p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE
242 ,x_return_status OUT NOCOPY VARCHAR2
243 ,x_msg_count OUT NOCOPY NUMBER
244 ,x_msg_data OUT NOCOPY VARCHAR2
245 ,p_dimension_varchar_label IN VARCHAR2
246 ) RETURN NUMBER;
247
248 END FEM_MIR_PKG;