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
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
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
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: --
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
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
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
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: --
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
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
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
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)
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,