DBA Data[Home] [Help]

PACKAGE: APPS.XLE_THIRDPARTY

Source


1 PACKAGE XLE_THIRDPARTY AUTHID CURRENT_USER AS
2 /* $Header: xlethpas.pls 120.5 2005/09/22 06:07:33 rbasker ship $ */
3 
4   TYPE LegalInformation_Rec IS RECORD (
5   legal_name		XLE_ENTITY_PROFILES.NAME%TYPE,
6   registration_number	XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,
7   date_of_birth		PO_VENDORS.GLOBAL_ATTRIBUTE2%TYPE,
8   place_of_birth	PO_VENDORS.GLOBAL_ATTRIBUTE3%TYPE,
9   company_activity_code PO_VENDORS.STANDARD_INDUSTRY_CLASS%TYPE,
10   address_line1		HR_LOCATIONS.ADDRESS_LINE_1%TYPE,
11   address_line2		HR_LOCATIONS.ADDRESS_LINE_2%TYPE,
12   address_line3     	HR_LOCATIONS.ADDRESS_LINE_3%TYPE,
13   city              	HR_LOCATIONS.TOWN_OR_CITY%TYPE,
14   zip               	HR_LOCATIONS.REGION_3%TYPE,
15   province          	HR_LOCATIONS.REGION_1%TYPE,
16   country           	HR_LOCATIONS.COUNTRY%TYPE,
17   state             	HR_LOCATIONS.REGION_2%TYPE);
18 
19 
20 
21 
22 PROCEDURE Get_LegalInformation(
23 
24 	--   *****  Standard API parameters *****
25  	p_api_version           	IN	NUMBER,
26   	p_init_msg_list	        	IN	VARCHAR2,
27   	p_commit			IN	VARCHAR2,
28   	x_return_status         	OUT     NOCOPY  VARCHAR2,
29   	x_msg_count	        	OUT	NOCOPY NUMBER,
30 	x_msg_data			OUT	NOCOPY VARCHAR2,
31 
32 	--   *****  Business Entity information parameters *****
33 	p_business_entity_type          IN      VARCHAR2,
34 	p_business_entity_id            IN      NUMBER,
35 	p_business_entity_site_id       IN      NUMBER,
36 	p_country               	IN      VARCHAR2,
37 	p_legal_function	        IN      VARCHAR2,
38         p_legislative_category          IN      VARCHAR2,
39 	x_legal_information_rec		OUT     NOCOPY LegalInformation_Rec);
40 
41 
42 Procedure Get_TP_VATRegistration_PTY
43    (
44     p_api_version           	IN	NUMBER,
45   	p_init_msg_list	     	IN	VARCHAR2,
46   	p_commit		IN	VARCHAR2,
47   	p_effective_date        IN  zx_registrations.effective_from%Type,
48   	x_return_status         OUT NOCOPY  VARCHAR2,
49   	x_msg_count		OUT	NOCOPY NUMBER,
50 	x_msg_data		OUT	NOCOPY VARCHAR2,
51 	p_party_id       	IN  NUMBER,
52 	p_party_type            IN  VARCHAR2,
53 	x_registration_number   OUT NOCOPY  NUMBER
54    );
55 
56 
57 
58 END;