[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;