DBA Data[Home] [Help]

APPS.EC_CODE_CONVERSION_PVT dependencies on FND_API

Line 30: -- Default = FND_API.G_FALSE

26: -- Pre-reqs : None.
27: -- Paramaeters :
28: -- IN : p_api_version_number IN NUMBER Required
29: -- p_init_msg_list IN VARCHAR2 Optional
30: -- Default = FND_API.G_FALSE
31: -- p_simulate IN VARCHAR2 Optional
32: -- Default = FND_API.G_FALSE
33: -- p_commit IN VARCHAR2 Optional
34: -- Default = FND_API.G_FALSE

Line 32: -- Default = FND_API.G_FALSE

28: -- IN : p_api_version_number IN NUMBER Required
29: -- p_init_msg_list IN VARCHAR2 Optional
30: -- Default = FND_API.G_FALSE
31: -- p_simulate IN VARCHAR2 Optional
32: -- Default = FND_API.G_FALSE
33: -- p_commit IN VARCHAR2 Optional
34: -- Default = FND_API.G_FALSE
35: -- p_validation_level IN NUMBER Optional
36: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 34: -- Default = FND_API.G_FALSE

30: -- Default = FND_API.G_FALSE
31: -- p_simulate IN VARCHAR2 Optional
32: -- Default = FND_API.G_FALSE
33: -- p_commit IN VARCHAR2 Optional
34: -- Default = FND_API.G_FALSE
35: -- p_validation_level IN NUMBER Optional
36: -- Default = FND_API.G_VALID_LEVEL_FULL
37: -- p_Category IN VARCHAR2 Required
38: -- p_Key1 IN VARCHAR2 Optional

Line 36: -- Default = FND_API.G_VALID_LEVEL_FULL

32: -- Default = FND_API.G_FALSE
33: -- p_commit IN VARCHAR2 Optional
34: -- Default = FND_API.G_FALSE
35: -- p_validation_level IN NUMBER Optional
36: -- Default = FND_API.G_VALID_LEVEL_FULL
37: -- p_Category IN VARCHAR2 Required
38: -- p_Key1 IN VARCHAR2 Optional
39: -- Default = NULL
40: -- p_Key2 IN VARCHAR2 Optional

Line 74: -- Default = FND_API.G_FALSE

70: -- Pre-reqs : None.
71: -- Paramaeters :
72: -- IN : p_api_version_number IN NUMBER Required
73: -- p_init_msg_list IN VARCHAR2 Optional
74: -- Default = FND_API.G_FALSE
75: -- p_simulate IN VARCHAR2 Optional
76: -- Default = FND_API.G_FALSE
77: -- p_commit IN VARCHAR2 Optional
78: -- Default = FND_API.G_FALSE

Line 76: -- Default = FND_API.G_FALSE

72: -- IN : p_api_version_number IN NUMBER Required
73: -- p_init_msg_list IN VARCHAR2 Optional
74: -- Default = FND_API.G_FALSE
75: -- p_simulate IN VARCHAR2 Optional
76: -- Default = FND_API.G_FALSE
77: -- p_commit IN VARCHAR2 Optional
78: -- Default = FND_API.G_FALSE
79: -- p_validation_level IN NUMBER Optional
80: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 78: -- Default = FND_API.G_FALSE

74: -- Default = FND_API.G_FALSE
75: -- p_simulate IN VARCHAR2 Optional
76: -- Default = FND_API.G_FALSE
77: -- p_commit IN VARCHAR2 Optional
78: -- Default = FND_API.G_FALSE
79: -- p_validation_level IN NUMBER Optional
80: -- Default = FND_API.G_VALID_LEVEL_FULL
81: -- p_Category IN VARCHAR2 Required
82: -- p_Key1 IN VARCHAR2 Optional

Line 80: -- Default = FND_API.G_VALID_LEVEL_FULL

76: -- Default = FND_API.G_FALSE
77: -- p_commit IN VARCHAR2 Optional
78: -- Default = FND_API.G_FALSE
79: -- p_validation_level IN NUMBER Optional
80: -- Default = FND_API.G_VALID_LEVEL_FULL
81: -- p_Category IN VARCHAR2 Required
82: -- p_Key1 IN VARCHAR2 Optional
83: -- Default = NULL
84: -- p_Key2 IN VARCHAR2 Optional

Line 145: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

141: */
142:
143: PROCEDURE Convert_from_int_to_ext
144: ( p_api_version_number IN NUMBER,
145: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
146: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
147: p_commit IN VARCHAR2 := FND_API.G_FALSE,
148: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
149: p_return_status OUT NOCOPY VARCHAR2,

Line 146: p_simulate IN VARCHAR2 := FND_API.G_FALSE,

142:
143: PROCEDURE Convert_from_int_to_ext
144: ( p_api_version_number IN NUMBER,
145: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
146: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
147: p_commit IN VARCHAR2 := FND_API.G_FALSE,
148: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
149: p_return_status OUT NOCOPY VARCHAR2,
150: p_msg_count OUT NOCOPY NUMBER,

Line 147: p_commit IN VARCHAR2 := FND_API.G_FALSE,

143: PROCEDURE Convert_from_int_to_ext
144: ( p_api_version_number IN NUMBER,
145: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
146: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
147: p_commit IN VARCHAR2 := FND_API.G_FALSE,
148: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
149: p_return_status OUT NOCOPY VARCHAR2,
150: p_msg_count OUT NOCOPY NUMBER,
151: p_msg_data OUT NOCOPY VARCHAR2,

Line 148: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

144: ( p_api_version_number IN NUMBER,
145: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
146: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
147: p_commit IN VARCHAR2 := FND_API.G_FALSE,
148: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
149: p_return_status OUT NOCOPY VARCHAR2,
150: p_msg_count OUT NOCOPY NUMBER,
151: p_msg_data OUT NOCOPY VARCHAR2,
152: p_Category IN VARCHAR2,

Line 196: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

192: */
193:
194: PROCEDURE Convert_from_ext_to_int
195: ( p_api_version_number IN NUMBER,
196: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
197: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
198: p_commit IN VARCHAR2 := FND_API.G_FALSE,
199: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
200: p_return_status OUT NOCOPY VARCHAR2,

Line 197: p_simulate IN VARCHAR2 := FND_API.G_FALSE,

193:
194: PROCEDURE Convert_from_ext_to_int
195: ( p_api_version_number IN NUMBER,
196: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
197: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
198: p_commit IN VARCHAR2 := FND_API.G_FALSE,
199: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
200: p_return_status OUT NOCOPY VARCHAR2,
201: p_msg_count OUT NOCOPY NUMBER,

Line 198: p_commit IN VARCHAR2 := FND_API.G_FALSE,

194: PROCEDURE Convert_from_ext_to_int
195: ( p_api_version_number IN NUMBER,
196: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
197: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
198: p_commit IN VARCHAR2 := FND_API.G_FALSE,
199: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
200: p_return_status OUT NOCOPY VARCHAR2,
201: p_msg_count OUT NOCOPY NUMBER,
202: p_msg_data OUT NOCOPY VARCHAR2,

Line 199: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

195: ( p_api_version_number IN NUMBER,
196: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
197: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
198: p_commit IN VARCHAR2 := FND_API.G_FALSE,
199: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
200: p_return_status OUT NOCOPY VARCHAR2,
201: p_msg_count OUT NOCOPY NUMBER,
202: p_msg_data OUT NOCOPY VARCHAR2,
203: p_Category IN VARCHAR2,

Line 219: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

215: );
216:
217: PROCEDURE populate_plsql_tbl_with_extval(
218: p_api_version_number IN NUMBER,
219: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
220: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
221: p_commit IN VARCHAR2 := FND_API.G_FALSE,
222: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
223: p_return_status OUT NOCOPY VARCHAR2,

Line 220: p_simulate IN VARCHAR2 := FND_API.G_FALSE,

216:
217: PROCEDURE populate_plsql_tbl_with_extval(
218: p_api_version_number IN NUMBER,
219: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
220: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
221: p_commit IN VARCHAR2 := FND_API.G_FALSE,
222: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
223: p_return_status OUT NOCOPY VARCHAR2,
224: p_msg_count OUT NOCOPY NUMBER,

Line 221: p_commit IN VARCHAR2 := FND_API.G_FALSE,

217: PROCEDURE populate_plsql_tbl_with_extval(
218: p_api_version_number IN NUMBER,
219: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
220: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
221: p_commit IN VARCHAR2 := FND_API.G_FALSE,
222: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
223: p_return_status OUT NOCOPY VARCHAR2,
224: p_msg_count OUT NOCOPY NUMBER,
225: p_msg_data OUT NOCOPY VARCHAR2,

Line 222: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

218: p_api_version_number IN NUMBER,
219: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
220: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
221: p_commit IN VARCHAR2 := FND_API.G_FALSE,
222: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
223: p_return_status OUT NOCOPY VARCHAR2,
224: p_msg_count OUT NOCOPY NUMBER,
225: p_msg_data OUT NOCOPY VARCHAR2,
226: p_key_tbl IN ece_flatfile_pvt.Interface_tbl_type,

Line 231: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

227: p_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type);
228:
229: PROCEDURE populate_plsql_tbl_with_extval(
230: p_api_version_number IN NUMBER,
231: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
232: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
233: p_commit IN VARCHAR2 := FND_API.G_FALSE,
234: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
235: p_return_status OUT NOCOPY VARCHAR2,

Line 232: p_simulate IN VARCHAR2 := FND_API.G_FALSE,

228:
229: PROCEDURE populate_plsql_tbl_with_extval(
230: p_api_version_number IN NUMBER,
231: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
232: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
233: p_commit IN VARCHAR2 := FND_API.G_FALSE,
234: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
235: p_return_status OUT NOCOPY VARCHAR2,
236: p_msg_count OUT NOCOPY NUMBER,

Line 233: p_commit IN VARCHAR2 := FND_API.G_FALSE,

229: PROCEDURE populate_plsql_tbl_with_extval(
230: p_api_version_number IN NUMBER,
231: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
232: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
233: p_commit IN VARCHAR2 := FND_API.G_FALSE,
234: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
235: p_return_status OUT NOCOPY VARCHAR2,
236: p_msg_count OUT NOCOPY NUMBER,
237: p_msg_data OUT NOCOPY VARCHAR2,

Line 234: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

230: p_api_version_number IN NUMBER,
231: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
232: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
233: p_commit IN VARCHAR2 := FND_API.G_FALSE,
234: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
235: p_return_status OUT NOCOPY VARCHAR2,
236: p_msg_count OUT NOCOPY NUMBER,
237: p_msg_data OUT NOCOPY VARCHAR2,
238: p_tbl IN OUT NOCOPY ec_utils.mapping_tbl,

Line 245: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

241:
242:
243: PROCEDURE populate_plsql_tbl_with_intval(
244: p_api_version_number IN NUMBER,
245: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
246: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
247: p_commit IN VARCHAR2 := FND_API.G_FALSE,
248: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
249: p_return_status OUT NOCOPY VARCHAR2,

Line 246: p_simulate IN VARCHAR2 := FND_API.G_FALSE,

242:
243: PROCEDURE populate_plsql_tbl_with_intval(
244: p_api_version_number IN NUMBER,
245: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
246: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
247: p_commit IN VARCHAR2 := FND_API.G_FALSE,
248: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
249: p_return_status OUT NOCOPY VARCHAR2,
250: p_msg_count OUT NOCOPY NUMBER,

Line 247: p_commit IN VARCHAR2 := FND_API.G_FALSE,

243: PROCEDURE populate_plsql_tbl_with_intval(
244: p_api_version_number IN NUMBER,
245: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
246: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
247: p_commit IN VARCHAR2 := FND_API.G_FALSE,
248: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
249: p_return_status OUT NOCOPY VARCHAR2,
250: p_msg_count OUT NOCOPY NUMBER,
251: p_msg_data OUT NOCOPY VARCHAR2,

Line 248: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

244: p_api_version_number IN NUMBER,
245: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
246: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
247: p_commit IN VARCHAR2 := FND_API.G_FALSE,
248: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
249: p_return_status OUT NOCOPY VARCHAR2,
250: p_msg_count OUT NOCOPY NUMBER,
251: p_msg_data OUT NOCOPY VARCHAR2,
252: p_key_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type,

Line 258: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

254:
255: PROCEDURE populate_plsql_tbl_with_intval
256: (
257: p_api_version_number IN NUMBER,
258: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
259: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
260: p_commit IN VARCHAR2 := FND_API.G_FALSE,
261: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
262: p_return_status OUT NOCOPY VARCHAR2,

Line 259: p_simulate IN VARCHAR2 := FND_API.G_FALSE,

255: PROCEDURE populate_plsql_tbl_with_intval
256: (
257: p_api_version_number IN NUMBER,
258: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
259: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
260: p_commit IN VARCHAR2 := FND_API.G_FALSE,
261: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
262: p_return_status OUT NOCOPY VARCHAR2,
263: p_msg_count OUT NOCOPY NUMBER,

Line 260: p_commit IN VARCHAR2 := FND_API.G_FALSE,

256: (
257: p_api_version_number IN NUMBER,
258: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
259: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
260: p_commit IN VARCHAR2 := FND_API.G_FALSE,
261: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
262: p_return_status OUT NOCOPY VARCHAR2,
263: p_msg_count OUT NOCOPY NUMBER,
264: p_msg_data OUT NOCOPY VARCHAR2,

Line 261: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

257: p_api_version_number IN NUMBER,
258: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
259: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
260: p_commit IN VARCHAR2 := FND_API.G_FALSE,
261: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
262: p_return_status OUT NOCOPY VARCHAR2,
263: p_msg_count OUT NOCOPY NUMBER,
264: p_msg_data OUT NOCOPY VARCHAR2,
265: p_apps_tbl IN OUT NOCOPY ec_utils.mapping_tbl,