DBA Data[Home] [Help]

APPS.ECE_TRADING_PARTNERS_PUB dependencies on FND_API

Line 36: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE

32: -- Function : Retrieve Supplier/Customer and Address information for a TP
33: -- Pre-reqs : None.
34: -- Paramaeters :
35: -- IN : p_api_version_number IN NUMBER Required
36: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
37: -- p_simulate IN VARCHAR2 Optional Default = FND_API.G_FALSE
38: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
39: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
40: -- p_translator_code IN VARCHAR2 Required

Line 37: -- p_simulate IN VARCHAR2 Optional Default = FND_API.G_FALSE

33: -- Pre-reqs : None.
34: -- Paramaeters :
35: -- IN : p_api_version_number IN NUMBER Required
36: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
37: -- p_simulate IN VARCHAR2 Optional Default = FND_API.G_FALSE
38: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
39: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
40: -- p_translator_code IN VARCHAR2 Required
41: -- p_location_code_ext IN VARCHAR2 Required

Line 38: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

34: -- Paramaeters :
35: -- IN : p_api_version_number IN NUMBER Required
36: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
37: -- p_simulate IN VARCHAR2 Optional Default = FND_API.G_FALSE
38: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
39: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
40: -- p_translator_code IN VARCHAR2 Required
41: -- p_location_code_ext IN VARCHAR2 Required
42: -- p_info_type IN VARCHAR2 Required

Line 39: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

35: -- IN : p_api_version_number IN NUMBER Required
36: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
37: -- p_simulate IN VARCHAR2 Optional Default = FND_API.G_FALSE
38: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
39: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
40: -- p_translator_code IN VARCHAR2 Required
41: -- p_location_code_ext IN VARCHAR2 Required
42: -- p_info_type IN VARCHAR2 Required
43: --

Line 64: -- Default = FND_API.G_FALSE

60: -- Pre-reqs : None.
61: -- Paramaeters :
62: -- IN : p_api_version_number IN NUMBER Required
63: -- p_init_msg_list IN VARCHAR2 Optional
64: -- Default = FND_API.G_FALSE
65: -- p_simulate IN VARCHAR2 Optional
66: -- Default = FND_API.G_FALSE
67: -- p_commit IN VARCHAR2 Optional
68: -- Default = FND_API.G_FALSE

Line 66: -- Default = FND_API.G_FALSE

62: -- IN : p_api_version_number IN NUMBER Required
63: -- p_init_msg_list IN VARCHAR2 Optional
64: -- Default = FND_API.G_FALSE
65: -- p_simulate IN VARCHAR2 Optional
66: -- Default = FND_API.G_FALSE
67: -- p_commit IN VARCHAR2 Optional
68: -- Default = FND_API.G_FALSE
69: -- p_validation_level IN NUMBER Optional
70: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 68: -- Default = FND_API.G_FALSE

64: -- Default = FND_API.G_FALSE
65: -- p_simulate IN VARCHAR2 Optional
66: -- Default = FND_API.G_FALSE
67: -- p_commit IN VARCHAR2 Optional
68: -- Default = FND_API.G_FALSE
69: -- p_validation_level IN NUMBER Optional
70: -- Default = FND_API.G_VALID_LEVEL_FULL
71: -- p_reference_ext1 IN VARCHAR2 Required
72: -- p_reference_ext2 IN VARCHAR2 Required

Line 70: -- Default = FND_API.G_VALID_LEVEL_FULL

66: -- Default = FND_API.G_FALSE
67: -- p_commit IN VARCHAR2 Optional
68: -- Default = FND_API.G_FALSE
69: -- p_validation_level IN NUMBER Optional
70: -- Default = FND_API.G_VALID_LEVEL_FULL
71: -- p_reference_ext1 IN VARCHAR2 Required
72: -- p_reference_ext2 IN VARCHAR2 Required
73: -- p_info_type IN VARCHAR2 Required
74: --

Line 94: -- Default = FND_API.G_FALSE

90: -- Pre-reqs : None.
91: -- Paramaeters :
92: -- IN : p_api_version_number IN NUMBER Required
93: -- p_init_msg_list IN VARCHAR2 Optional
94: -- Default = FND_API.G_FALSE
95: -- p_simulate IN VARCHAR2 Optional
96: -- Default = FND_API.G_FALSE
97: -- p_commit IN VARCHAR2 Optional
98: -- Default = FND_API.G_FALSE

Line 96: -- Default = FND_API.G_FALSE

92: -- IN : p_api_version_number IN NUMBER Required
93: -- p_init_msg_list IN VARCHAR2 Optional
94: -- Default = FND_API.G_FALSE
95: -- p_simulate IN VARCHAR2 Optional
96: -- Default = FND_API.G_FALSE
97: -- p_commit IN VARCHAR2 Optional
98: -- Default = FND_API.G_FALSE
99: -- p_validation_level IN NUMBER Optional
100: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 98: -- Default = FND_API.G_FALSE

94: -- Default = FND_API.G_FALSE
95: -- p_simulate IN VARCHAR2 Optional
96: -- Default = FND_API.G_FALSE
97: -- p_commit IN VARCHAR2 Optional
98: -- Default = FND_API.G_FALSE
99: -- p_validation_level IN NUMBER Optional
100: -- Default = FND_API.G_VALID_LEVEL_FULL
101: -- p_entity_address_id IN NUMBER Required
102: -- p_info_type IN VARCHAR2 Required

Line 100: -- Default = FND_API.G_VALID_LEVEL_FULL

96: -- Default = FND_API.G_FALSE
97: -- p_commit IN VARCHAR2 Optional
98: -- Default = FND_API.G_FALSE
99: -- p_validation_level IN NUMBER Optional
100: -- Default = FND_API.G_VALID_LEVEL_FULL
101: -- p_entity_address_id IN NUMBER Required
102: -- p_info_type IN VARCHAR2 Required
103: --
104: -- OUT : p_return_status OUT VARCHAR2(1)

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

115: -- Notes : Note text
116:
117: PROCEDURE ece_get_address_wrapper(
118: p_api_version_number IN NUMBER,
119: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
120: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
121: p_commit IN VARCHAR2 := FND_API.G_FALSE,
122: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
123: x_return_status OUT NOCOPY VARCHAR2,

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

116:
117: PROCEDURE ece_get_address_wrapper(
118: p_api_version_number IN NUMBER,
119: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
120: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
121: p_commit IN VARCHAR2 := FND_API.G_FALSE,
122: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
123: x_return_status OUT NOCOPY VARCHAR2,
124: x_msg_count OUT NOCOPY NUMBER,

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

117: PROCEDURE ece_get_address_wrapper(
118: p_api_version_number IN NUMBER,
119: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
120: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
121: p_commit IN VARCHAR2 := FND_API.G_FALSE,
122: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
123: x_return_status OUT NOCOPY VARCHAR2,
124: x_msg_count OUT NOCOPY NUMBER,
125: x_msg_data OUT NOCOPY VARCHAR2,

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

118: p_api_version_number IN NUMBER,
119: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
120: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
121: p_commit IN VARCHAR2 := FND_API.G_FALSE,
122: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
123: x_return_status OUT NOCOPY VARCHAR2,
124: x_msg_count OUT NOCOPY NUMBER,
125: x_msg_data OUT NOCOPY VARCHAR2,
126: x_status_code OUT NOCOPY NUMBER,

Line 171: p_init_msg_list IN VARCHAR2 := fnd_api.G_FALSE,

167: x_region_3_out OUT NOCOPY VARCHAR2);
168:
169: PROCEDURE ece_get_address(
170: p_api_version_number IN NUMBER,
171: p_init_msg_list IN VARCHAR2 := fnd_api.G_FALSE,
172: p_simulate IN VARCHAR2 := fnd_api.G_FALSE,
173: p_commit IN VARCHAR2 := fnd_api.G_FALSE,
174: p_validation_level IN NUMBER := fnd_api.G_VALID_LEVEL_FULL,
175: x_return_status OUT NOCOPY VARCHAR2,

Line 172: p_simulate IN VARCHAR2 := fnd_api.G_FALSE,

168:
169: PROCEDURE ece_get_address(
170: p_api_version_number IN NUMBER,
171: p_init_msg_list IN VARCHAR2 := fnd_api.G_FALSE,
172: p_simulate IN VARCHAR2 := fnd_api.G_FALSE,
173: p_commit IN VARCHAR2 := fnd_api.G_FALSE,
174: p_validation_level IN NUMBER := fnd_api.G_VALID_LEVEL_FULL,
175: x_return_status OUT NOCOPY VARCHAR2,
176: x_msg_count OUT NOCOPY NUMBER,

Line 173: p_commit IN VARCHAR2 := fnd_api.G_FALSE,

169: PROCEDURE ece_get_address(
170: p_api_version_number IN NUMBER,
171: p_init_msg_list IN VARCHAR2 := fnd_api.G_FALSE,
172: p_simulate IN VARCHAR2 := fnd_api.G_FALSE,
173: p_commit IN VARCHAR2 := fnd_api.G_FALSE,
174: p_validation_level IN NUMBER := fnd_api.G_VALID_LEVEL_FULL,
175: x_return_status OUT NOCOPY VARCHAR2,
176: x_msg_count OUT NOCOPY NUMBER,
177: x_msg_data OUT NOCOPY VARCHAR2,

Line 174: p_validation_level IN NUMBER := fnd_api.G_VALID_LEVEL_FULL,

170: p_api_version_number IN NUMBER,
171: p_init_msg_list IN VARCHAR2 := fnd_api.G_FALSE,
172: p_simulate IN VARCHAR2 := fnd_api.G_FALSE,
173: p_commit IN VARCHAR2 := fnd_api.G_FALSE,
174: p_validation_level IN NUMBER := fnd_api.G_VALID_LEVEL_FULL,
175: x_return_status OUT NOCOPY VARCHAR2,
176: x_msg_count OUT NOCOPY NUMBER,
177: x_msg_data OUT NOCOPY VARCHAR2,
178: x_status_code OUT NOCOPY NUMBER,

Line 259: p_init_msg_list IN VARCHAR2 := fnd_api.G_FALSE,

255: -- procedure Get_TP_Address
256: --***********************************************
257: PROCEDURE Get_TP_Address(
258: p_api_version_number IN NUMBER,
259: p_init_msg_list IN VARCHAR2 := fnd_api.G_FALSE,
260: p_simulate IN VARCHAR2 := fnd_api.G_FALSE,
261: p_commit IN VARCHAR2 := fnd_api.G_FALSE,
262: p_validation_level IN NUMBER := fnd_api.G_VALID_LEVEL_FULL,
263: p_return_status OUT NOCOPY VARCHAR2,

Line 260: p_simulate IN VARCHAR2 := fnd_api.G_FALSE,

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

Line 261: p_commit IN VARCHAR2 := fnd_api.G_FALSE,

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

Line 262: p_validation_level IN NUMBER := fnd_api.G_VALID_LEVEL_FULL,

258: p_api_version_number IN NUMBER,
259: p_init_msg_list IN VARCHAR2 := fnd_api.G_FALSE,
260: p_simulate IN VARCHAR2 := fnd_api.G_FALSE,
261: p_commit IN VARCHAR2 := fnd_api.G_FALSE,
262: p_validation_level IN NUMBER := fnd_api.G_VALID_LEVEL_FULL,
263: p_return_status OUT NOCOPY VARCHAR2,
264: p_msg_count OUT NOCOPY NUMBER,
265: p_msg_data OUT NOCOPY VARCHAR2,
266: p_translator_code IN VARCHAR2,

Line 280: p_init_msg_list IN VARCHAR2 := fnd_api.G_FALSE,

276: -- the automotive team
277: --***********************************************
278: PROCEDURE Get_TP_Address_Ref(
279: p_api_version_number IN NUMBER,
280: p_init_msg_list IN VARCHAR2 := fnd_api.G_FALSE,
281: p_simulate IN VARCHAR2 := fnd_api.G_FALSE,
282: p_commit IN VARCHAR2 := fnd_api.G_FALSE,
283: p_validation_level IN NUMBER := fnd_api.G_VALID_LEVEL_FULL,
284: p_return_status OUT NOCOPY VARCHAR2,

Line 281: p_simulate IN VARCHAR2 := fnd_api.G_FALSE,

277: --***********************************************
278: PROCEDURE Get_TP_Address_Ref(
279: p_api_version_number IN NUMBER,
280: p_init_msg_list IN VARCHAR2 := fnd_api.G_FALSE,
281: p_simulate IN VARCHAR2 := fnd_api.G_FALSE,
282: p_commit IN VARCHAR2 := fnd_api.G_FALSE,
283: p_validation_level IN NUMBER := fnd_api.G_VALID_LEVEL_FULL,
284: p_return_status OUT NOCOPY VARCHAR2,
285: p_msg_count OUT NOCOPY NUMBER,

Line 282: p_commit IN VARCHAR2 := fnd_api.G_FALSE,

278: PROCEDURE Get_TP_Address_Ref(
279: p_api_version_number IN NUMBER,
280: p_init_msg_list IN VARCHAR2 := fnd_api.G_FALSE,
281: p_simulate IN VARCHAR2 := fnd_api.G_FALSE,
282: p_commit IN VARCHAR2 := fnd_api.G_FALSE,
283: p_validation_level IN NUMBER := fnd_api.G_VALID_LEVEL_FULL,
284: p_return_status OUT NOCOPY VARCHAR2,
285: p_msg_count OUT NOCOPY NUMBER,
286: p_msg_data OUT NOCOPY VARCHAR2,

Line 283: p_validation_level IN NUMBER := fnd_api.G_VALID_LEVEL_FULL,

279: p_api_version_number IN NUMBER,
280: p_init_msg_list IN VARCHAR2 := fnd_api.G_FALSE,
281: p_simulate IN VARCHAR2 := fnd_api.G_FALSE,
282: p_commit IN VARCHAR2 := fnd_api.G_FALSE,
283: p_validation_level IN NUMBER := fnd_api.G_VALID_LEVEL_FULL,
284: p_return_status OUT NOCOPY VARCHAR2,
285: p_msg_count OUT NOCOPY NUMBER,
286: p_msg_data OUT NOCOPY VARCHAR2,
287: p_reference_ext1 IN VARCHAR2,

Line 298: p_init_msg_list IN VARCHAR2 := fnd_api.G_FALSE,

294: -- procedure Get_TP_Location_Code
295: --***********************************************
296: PROCEDURE Get_TP_Location_Code(
297: p_api_version_number IN NUMBER,
298: p_init_msg_list IN VARCHAR2 := fnd_api.G_FALSE,
299: p_simulate IN VARCHAR2 := fnd_api.G_FALSE,
300: p_commit IN VARCHAR2 := fnd_api.G_FALSE,
301: p_validation_level IN NUMBER := fnd_api.G_VALID_LEVEL_FULL,
302: p_return_status OUT NOCOPY VARCHAR2,

Line 299: p_simulate IN VARCHAR2 := fnd_api.G_FALSE,

295: --***********************************************
296: PROCEDURE Get_TP_Location_Code(
297: p_api_version_number IN NUMBER,
298: p_init_msg_list IN VARCHAR2 := fnd_api.G_FALSE,
299: p_simulate IN VARCHAR2 := fnd_api.G_FALSE,
300: p_commit IN VARCHAR2 := fnd_api.G_FALSE,
301: p_validation_level IN NUMBER := fnd_api.G_VALID_LEVEL_FULL,
302: p_return_status OUT NOCOPY VARCHAR2,
303: p_msg_count OUT NOCOPY NUMBER,

Line 300: p_commit IN VARCHAR2 := fnd_api.G_FALSE,

296: PROCEDURE Get_TP_Location_Code(
297: p_api_version_number IN NUMBER,
298: p_init_msg_list IN VARCHAR2 := fnd_api.G_FALSE,
299: p_simulate IN VARCHAR2 := fnd_api.G_FALSE,
300: p_commit IN VARCHAR2 := fnd_api.G_FALSE,
301: p_validation_level IN NUMBER := fnd_api.G_VALID_LEVEL_FULL,
302: p_return_status OUT NOCOPY VARCHAR2,
303: p_msg_count OUT NOCOPY NUMBER,
304: p_msg_data OUT NOCOPY VARCHAR2,

Line 301: p_validation_level IN NUMBER := fnd_api.G_VALID_LEVEL_FULL,

297: p_api_version_number IN NUMBER,
298: p_init_msg_list IN VARCHAR2 := fnd_api.G_FALSE,
299: p_simulate IN VARCHAR2 := fnd_api.G_FALSE,
300: p_commit IN VARCHAR2 := fnd_api.G_FALSE,
301: p_validation_level IN NUMBER := fnd_api.G_VALID_LEVEL_FULL,
302: p_return_status OUT NOCOPY VARCHAR2,
303: p_msg_count OUT NOCOPY NUMBER,
304: p_msg_data OUT NOCOPY VARCHAR2,
305: p_entity_address_id IN NUMBER,