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;
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;
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;
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;
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;
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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