DBA Data[Home] [Help]

APPS.FEM_MIR_PKG dependencies on FND_API

Line 30: c_false CONSTANT VARCHAR2(1) := FND_API.G_FALSE;

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;

Line 31: c_true CONSTANT VARCHAR2(1) := FND_API.G_TRUE;

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;

Line 32: c_success CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

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;

Line 33: c_error CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

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;

Line 34: c_unexp CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

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;

Line 112: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

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

Line 113: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

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

Line 114: ,p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE

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

Line 124: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

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

Line 125: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

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

Line 126: ,p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE

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

Line 146: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

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

Line 147: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

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

Line 148: ,p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE

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

Line 159: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

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

Line 160: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

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

Line 161: ,p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE

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

Line 181: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

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

Line 182: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

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

Line 183: ,p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE

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

Line 193: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

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

Line 194: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

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

Line 195: ,p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE

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

Line 209: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

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

Line 210: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

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

Line 211: ,p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE

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

Line 228: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

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

Line 229: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

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

Line 230: ,p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE

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

Line 239: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

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

Line 240: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

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

Line 241: ,p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE

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