[Home] [Help]
PACKAGE: APPS.ZX_TCM_GET_EXEMPT_PKG
Source
1 PACKAGE ZX_TCM_GET_EXEMPT_PKG AUTHID CURRENT_USER AS
2 /* $Header: zxcgetexempts.pls 120.8.12010000.1 2008/07/28 13:29:05 appldev ship $ */
3
4 TYPE exemption_rec_type IS RECORD
5 (exemption_id NUMBER,
6 percent_exempt NUMBER,
7 discount_special_rate VARCHAR2(30),
8 apply_to_lower_levels_flag VARCHAR2(1),
9 exempt_reason_code VARCHAR2(30),
10 exempt_reason VARCHAR2(240),
11 exempt_certificate_number VARCHAR2(80)
12 );
13
14 /*TYPE tax_jurisdiction_rec_type IS RECORD
15 (tax_jurisdiction_id NUMBER,
16 tax_jurisdiction_code VARCHAR2(30)
17 );
18
19 TYPE tax_jurisdiction_tbl_type IS TABLE of tax_jurisdiction_rec_type INDEX BY BINARY_INTEGER;
20 */
21
22 PROCEDURE get_tax_exemptions(p_bill_to_cust_site_use_id IN NUMBER,
23 p_bill_to_cust_acct_id IN NUMBER,
24 p_bill_to_party_site_ptp_id IN NUMBER,
25 p_bill_to_party_ptp_id IN NUMBER,
26 p_sold_to_party_site_ptp_id IN NUMBER,
27 p_sold_to_party_ptp_id IN NUMBER,
28 p_inventory_org_id IN NUMBER,
29 p_inventory_item_id IN NUMBER,
30 p_exempt_certificate_number IN VARCHAR2,
31 p_reason_code IN VARCHAR2,
32 p_exempt_control_flag IN VARCHAR2,
33 p_tax_date IN DATE,
34 p_tax_regime_code IN VARCHAR2,
35 p_tax IN VARCHAR2,
36 p_tax_status_code IN VARCHAR2,
37 p_tax_rate_code IN VARCHAR2,
38 p_tax_jurisdiction_id IN NUMBER,
39 p_multiple_jurisdictions_flag IN VARCHAR2,
40 p_event_class_rec IN zx_api_pub.event_class_rec_type,
41 x_return_status OUT NOCOPY VARCHAR2,
42 x_exemption_rec OUT NOCOPY exemption_rec_type);
43
44 END;