[Home] [Help]
26: +==============================================================================*/
27:
28: PROCEDURE Get_LegalInformation(
29:
30: -- ***** Standard API parameters *****
31: p_api_version IN NUMBER,
32: p_init_msg_list IN VARCHAR2,
33: p_commit IN VARCHAR2,
34: x_return_status OUT NOCOPY VARCHAR2,
57: SELECT pvs.vendor_site_code,
58: pv.num_1099,
59: pv.global_attribute2,
60: pv.global_attribute3,
61: pv.standard_industry_class,
62: pvs.address_line1,
63: pvs.address_line2,
64: pvs.address_line3,
65: pvs.city,
79: SELECT decode(pvs.country,'ES',pv.vendor_name,'GR',pvs.vendor_site_code),
80: pv.num_1099,
81: pv.global_attribute2,
82: pv.global_attribute3,
83: pv.standard_industry_class,
84: pvs.address_line1,
85: pvs.address_line2,
86: pvs.address_line3,
87: pvs.city,
103: x_msg_count := NULL;
104: x_msg_data := NULL;
105:
106:
107: -- Standard call to check for call compatibility.
108: IF NOT FND_API.Compatible_API_Call ( l_api_version,
109: p_api_version,
110: l_api_name,
111: G_PKG_NAME ) THEN
192:
193:
194: -- End of API body.
195:
196: -- Standard call to get message count and if count is 1,
197: --get message info.
198: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,
199: p_data => x_msg_data );
200:
257: ELSE
258: l_commit := p_commit;
259: END IF;
260:
261: -- Standard call to check for call compatibility.
262: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
263: p_api_version ,
264: l_api_name ,
265: G_PKG_NAME )
303: p_party_type => p_party_type,
304: p_effective_date =>p_effective_date );
305:
306:
307: -- Standard call to get message count and if count is 1, get message info.
308: FND_MSG_PUB.Count_And_Get
309: ( p_count => x_msg_count ,
310: p_data => x_msg_data
311: );