23: -- Pre-reqs : None.
24: -- Paramaeters :
25: -- IN : p_api_version_number IN NUMBER Required
26: -- p_init_msg_list IN VARCHAR2 Optional
27: -- Default = FND_API.G_FALSE
28: -- p_simulate IN VARCHAR2 Optional
29: -- Default = FND_API.G_FALSE
30: -- p_commit IN VARCHAR2 Optional
31: -- Default = FND_API.G_FALSE
25: -- IN : p_api_version_number IN NUMBER Required
26: -- p_init_msg_list IN VARCHAR2 Optional
27: -- Default = FND_API.G_FALSE
28: -- p_simulate IN VARCHAR2 Optional
29: -- Default = FND_API.G_FALSE
30: -- p_commit IN VARCHAR2 Optional
31: -- Default = FND_API.G_FALSE
32: -- p_validation_level IN NUMBER Optional
33: -- Default = FND_API.G_VALID_LEVEL_FULL
27: -- Default = FND_API.G_FALSE
28: -- p_simulate IN VARCHAR2 Optional
29: -- Default = FND_API.G_FALSE
30: -- p_commit IN VARCHAR2 Optional
31: -- Default = FND_API.G_FALSE
32: -- p_validation_level IN NUMBER Optional
33: -- Default = FND_API.G_VALID_LEVEL_FULL
34: -- p_translator_code IN VARCHAR2 Required
35: -- p_location_code_ext IN VARCHAR2 Required
29: -- Default = FND_API.G_FALSE
30: -- p_commit IN VARCHAR2 Optional
31: -- Default = FND_API.G_FALSE
32: -- p_validation_level IN NUMBER Optional
33: -- Default = FND_API.G_VALID_LEVEL_FULL
34: -- p_translator_code IN VARCHAR2 Required
35: -- p_location_code_ext IN VARCHAR2 Required
36: -- p_info_type IN VARCHAR2 Required
37: --
54: -- Pre-reqs : None.
55: -- Paramaeters :
56: -- IN : p_api_version_number IN NUMBER Required
57: -- p_init_msg_list IN VARCHAR2 Optional
58: -- Default = FND_API.G_FALSE
59: -- p_simulate IN VARCHAR2 Optional
60: -- Default = FND_API.G_FALSE
61: -- p_commit IN VARCHAR2 Optional
62: -- Default = FND_API.G_FALSE
56: -- IN : p_api_version_number IN NUMBER Required
57: -- p_init_msg_list IN VARCHAR2 Optional
58: -- Default = FND_API.G_FALSE
59: -- p_simulate IN VARCHAR2 Optional
60: -- Default = FND_API.G_FALSE
61: -- p_commit IN VARCHAR2 Optional
62: -- Default = FND_API.G_FALSE
63: -- p_validation_level IN NUMBER Optional
64: -- Default = FND_API.G_VALID_LEVEL_FULL
58: -- Default = FND_API.G_FALSE
59: -- p_simulate IN VARCHAR2 Optional
60: -- Default = FND_API.G_FALSE
61: -- p_commit IN VARCHAR2 Optional
62: -- Default = FND_API.G_FALSE
63: -- p_validation_level IN NUMBER Optional
64: -- Default = FND_API.G_VALID_LEVEL_FULL
65: -- p_reference_ext1 IN VARCHAR2 Required
66: -- p_reference_ext2 IN VARCHAR2 Required
60: -- Default = FND_API.G_FALSE
61: -- p_commit IN VARCHAR2 Optional
62: -- Default = FND_API.G_FALSE
63: -- p_validation_level IN NUMBER Optional
64: -- Default = FND_API.G_VALID_LEVEL_FULL
65: -- p_reference_ext1 IN VARCHAR2 Required
66: -- p_reference_ext2 IN VARCHAR2 Required
67: -- p_info_type IN VARCHAR2 Required
68: --
84: -- Pre-reqs : None.
85: -- Paramaeters :
86: -- IN : p_api_version_number IN NUMBER Required
87: -- p_init_msg_list IN VARCHAR2 Optional
88: -- Default = FND_API.G_FALSE
89: -- p_simulate IN VARCHAR2 Optional
90: -- Default = FND_API.G_FALSE
91: -- p_commit IN VARCHAR2 Optional
92: -- Default = FND_API.G_FALSE
86: -- IN : p_api_version_number IN NUMBER Required
87: -- p_init_msg_list IN VARCHAR2 Optional
88: -- Default = FND_API.G_FALSE
89: -- p_simulate IN VARCHAR2 Optional
90: -- Default = FND_API.G_FALSE
91: -- p_commit IN VARCHAR2 Optional
92: -- Default = FND_API.G_FALSE
93: -- p_validation_level IN NUMBER Optional
94: -- Default = FND_API.G_VALID_LEVEL_FULL
88: -- Default = FND_API.G_FALSE
89: -- p_simulate IN VARCHAR2 Optional
90: -- Default = FND_API.G_FALSE
91: -- p_commit IN VARCHAR2 Optional
92: -- Default = FND_API.G_FALSE
93: -- p_validation_level IN NUMBER Optional
94: -- Default = FND_API.G_VALID_LEVEL_FULL
95: -- p_entity_address_id IN NUMBER Required
96: -- p_info_type IN VARCHAR2 Required
90: -- Default = FND_API.G_FALSE
91: -- p_commit IN VARCHAR2 Optional
92: -- Default = FND_API.G_FALSE
93: -- p_validation_level IN NUMBER Optional
94: -- Default = FND_API.G_VALID_LEVEL_FULL
95: -- p_entity_address_id IN NUMBER Required
96: -- p_info_type IN VARCHAR2 Required
97: --
98: -- OUT : p_return_status OUT VARCHAR2(1)
114: -- procedure Get_TP_Address
115: -- ***********************************************
116: PROCEDURE Get_TP_Address
117: ( p_api_version_number IN NUMBER,
118: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
119: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
120: p_commit IN VARCHAR2 := FND_API.G_FALSE,
121: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
122: p_return_status OUT NOCOPY VARCHAR2,
115: -- ***********************************************
116: PROCEDURE Get_TP_Address
117: ( p_api_version_number IN NUMBER,
118: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
119: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
120: p_commit IN VARCHAR2 := FND_API.G_FALSE,
121: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
122: p_return_status OUT NOCOPY VARCHAR2,
123: p_msg_count OUT NOCOPY NUMBER,
116: PROCEDURE Get_TP_Address
117: ( p_api_version_number IN NUMBER,
118: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
119: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
120: p_commit IN VARCHAR2 := FND_API.G_FALSE,
121: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
122: p_return_status OUT NOCOPY VARCHAR2,
123: p_msg_count OUT NOCOPY NUMBER,
124: p_msg_data OUT NOCOPY VARCHAR2,
117: ( p_api_version_number IN NUMBER,
118: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
119: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
120: p_commit IN VARCHAR2 := FND_API.G_FALSE,
121: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
122: p_return_status OUT NOCOPY VARCHAR2,
123: p_msg_count OUT NOCOPY NUMBER,
124: p_msg_data OUT NOCOPY VARCHAR2,
125: p_translator_code IN VARCHAR2,
137: -- the automotive team
138: -- ***********************************************
139: PROCEDURE Get_TP_Address_Ref
140: ( p_api_version_number IN NUMBER,
141: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
142: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
143: p_commit IN VARCHAR2 := FND_API.G_FALSE,
144: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
145: p_return_status OUT NOCOPY VARCHAR2,
138: -- ***********************************************
139: PROCEDURE Get_TP_Address_Ref
140: ( p_api_version_number IN NUMBER,
141: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
142: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
143: p_commit IN VARCHAR2 := FND_API.G_FALSE,
144: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
145: p_return_status OUT NOCOPY VARCHAR2,
146: p_msg_count OUT NOCOPY NUMBER,
139: PROCEDURE Get_TP_Address_Ref
140: ( p_api_version_number IN NUMBER,
141: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
142: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
143: p_commit IN VARCHAR2 := FND_API.G_FALSE,
144: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
145: p_return_status OUT NOCOPY VARCHAR2,
146: p_msg_count OUT NOCOPY NUMBER,
147: p_msg_data OUT NOCOPY VARCHAR2,
140: ( p_api_version_number IN NUMBER,
141: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
142: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
143: p_commit IN VARCHAR2 := FND_API.G_FALSE,
144: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
145: p_return_status OUT NOCOPY VARCHAR2,
146: p_msg_count OUT NOCOPY NUMBER,
147: p_msg_data OUT NOCOPY VARCHAR2,
148: p_reference_ext1 IN VARCHAR2,
157: -- procedure Get_TP_Location_Code
158: -- ***********************************************
159: PROCEDURE Get_TP_Location_Code
160: ( p_api_version_number IN NUMBER,
161: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
162: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
163: p_commit IN VARCHAR2 := FND_API.G_FALSE,
164: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
165: p_return_status OUT NOCOPY VARCHAR2,
158: -- ***********************************************
159: PROCEDURE Get_TP_Location_Code
160: ( p_api_version_number IN NUMBER,
161: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
162: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
163: p_commit IN VARCHAR2 := FND_API.G_FALSE,
164: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
165: p_return_status OUT NOCOPY VARCHAR2,
166: p_msg_count OUT NOCOPY NUMBER,
159: PROCEDURE Get_TP_Location_Code
160: ( p_api_version_number IN NUMBER,
161: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
162: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
163: p_commit IN VARCHAR2 := FND_API.G_FALSE,
164: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
165: p_return_status OUT NOCOPY VARCHAR2,
166: p_msg_count OUT NOCOPY NUMBER,
167: p_msg_data OUT NOCOPY VARCHAR2,
160: ( p_api_version_number IN NUMBER,
161: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
162: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
163: p_commit IN VARCHAR2 := FND_API.G_FALSE,
164: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
165: p_return_status OUT NOCOPY VARCHAR2,
166: p_msg_count OUT NOCOPY NUMBER,
167: p_msg_data OUT NOCOPY VARCHAR2,
168: p_entity_address_id IN NUMBER,
174:
175:
176: FUNCTION IS_ENTITY_ENABLED
177: ( p_api_version_number IN NUMBER,
178: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
179: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
180: p_commit IN VARCHAR2 := FND_API.G_FALSE,
181: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
182: p_return_status OUT NOCOPY VARCHAR2,
175:
176: FUNCTION IS_ENTITY_ENABLED
177: ( p_api_version_number IN NUMBER,
178: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
179: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
180: p_commit IN VARCHAR2 := FND_API.G_FALSE,
181: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
182: p_return_status OUT NOCOPY VARCHAR2,
183: p_msg_count OUT NOCOPY NUMBER,
176: FUNCTION IS_ENTITY_ENABLED
177: ( p_api_version_number IN NUMBER,
178: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
179: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
180: p_commit IN VARCHAR2 := FND_API.G_FALSE,
181: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
182: p_return_status OUT NOCOPY VARCHAR2,
183: p_msg_count OUT NOCOPY NUMBER,
184: p_msg_data OUT NOCOPY VARCHAR2,
177: ( p_api_version_number IN NUMBER,
178: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
179: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
180: p_commit IN VARCHAR2 := FND_API.G_FALSE,
181: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
182: p_return_status OUT NOCOPY VARCHAR2,
183: p_msg_count OUT NOCOPY NUMBER,
184: p_msg_data OUT NOCOPY VARCHAR2,
185: p_transaction_type IN VARCHAR2,