1 PACKAGE ZX_TCM_PTP_PKG AS
2 /* $Header: zxcptps.pls 120.13 2006/10/05 20:56:43 nipatel ship $ */
3
4 PROCEDURE GET_PTP(
5 p_party_id IN NUMBER,
6 p_party_type_code IN VARCHAR2,
7 p_le_id IN NUMBER,
8 p_inventory_loc IN NUMBER,
9 p_ptp_id OUT NOCOPY NUMBER,
10 p_return_status OUT NOCOPY VARCHAR2);
11
12 /* ======================================================================
13 Procedure: GET_PTP_HQ
14 Objective: Retrieve the Party Tax Profile for the HQ Establishment
15 of a given Legal Entity.
16 Assumption: Any Legal Entity will have only one HQ Establishment
17 In Parameters: p_le_id - Legal Entity ID
18 OUTPUT Parameters: p_ptp_id - Party Tax Profile ID
19 p_return_status - Success is p_ptp_id is not null
20 ====================================================================== */
21 PROCEDURE GET_PTP_HQ(
22 p_le_id IN xle_entity_profiles.legal_entity_id%TYPE,
23 p_ptp_id OUT NOCOPY zx_party_tax_profile.party_tax_profile_id%TYPE,
24 p_return_status OUT NOCOPY VARCHAR2);
25
26 PROCEDURE GET_TAX_SUBSCRIBER(
27 p_le_id IN NUMBER,
28 p_org_id IN NUMBER,
29 p_ptp_id OUT NOCOPY NUMBER,
30 p_return_status OUT NOCOPY VARCHAR2);
31
32 PROCEDURE GET_LOCATION_ID(
33 p_org_id IN NUMBER,
34 p_location_id OUT NOCOPY NUMBER,
35 p_return_status OUT NOCOPY VARCHAR2);
36
37 Procedure CHECK_TAX_REGISTRATIONS(
38 p_api_version IN NUMBER,
39 p_le_reg_id IN NUMBER,
40 x_return_status OUT NOCOPY VARCHAR2);
41
42 Procedure SYNC_TAX_REGISTRATIONS(
43 p_api_version IN NUMBER,
44 p_le_old_reg_id IN NUMBER,
45 p_le_old_end_date IN DATE,
46 p_le_new_reg_id IN NUMBER,
47 p_le_new_reg_num IN VARCHAR2,
48 x_return_status OUT NOCOPY VARCHAR2);
49
50 Procedure GET_PARTY_TAX_PROF_INFO(
51 p_party_tax_profile_id IN NUMBER,
52 x_tbl_index OUT NOCOPY BINARY_INTEGER,
53 x_return_status OUT NOCOPY VARCHAR2);
54
55 Procedure GET_PARTY_TAX_PROF_INFO(
56 p_party_id IN NUMBER,
57 p_party_type_code IN ZX_PARTY_TAX_PROFILE.PARTY_TYPE_CODE%TYPE,
58 x_tbl_index OUT NOCOPY BINARY_INTEGER,
59 X_RETURN_STATUS OUT NOCOPY VARCHAR2);
60
61 END ZX_TCM_PTP_PKG;
62