PACKAGE: APPS.ZX_TCM_GET_DEF_EXEMPTION

Source

1 PACKAGE ZX_TCM_GET_DEF_EXEMPTION AUTHID CURRENT_USER AS
2 /* $Header: zxcgetdefexempts.pls 120.1 2005/11/09 00:43:22 usrikuma ship $ */
3 
4 TYPE exemption_rec_type IS RECORD
5   ( TAX_EXEMPTION_ID 			NUMBER(15),
6     EXEMPTION_TYPE_CODE 		VARCHAR2(30),
7     EXEMPTION_STATUS_CODE		VARCHAR2(30),
8     EXEMPT_CERTIFICATE_NUMBER 		VARCHAR2(80),
9     EXEMPT_REASON_CODE			VARCHAR2(30),
10     TAX_REGIME_CODE			VARCHAR2(30),
11     TAX_STATUS_CODE			VARCHAR2(30),
12     TAX					VARCHAR2(30),
13     TAX_RATE_CODE			VARCHAR2(50),
14     EFFECTIVE_FROM			DATE,
15     EFFECTIVE_TO			DATE,
16     CONTENT_OWNER_ID			NUMBER(15),
17     PRODUCT_ID				NUMBER,
18     INVENTORY_ORG_ID			NUMBER,
19     RATE_MODIFIER			NUMBER,
20     TAX_JURISDICTION_ID 		NUMBER(15),
21     PARTY_TAX_PROFILE_ID		NUMBER(15));
22 
23 TYPE exemption_rec_tbl_type IS TABLE of exemption_rec_type INDEX BY BINARY_INTEGER;
24 
25 
26 PROCEDURE get_default_exemptions
27                             (p_bill_to_cust_acct_id          IN NUMBER,
28                              p_ship_to_cust_acct_id          IN NUMBER,
29                              p_ship_to_site_use_id           IN NUMBER,
30                              p_bill_to_site_use_id           IN NUMBER,
31                              p_bill_to_party_id              IN NUMBER,
32                              p_bill_to_party_site_id         IN NUMBER,
33                              p_ship_to_party_site_id         IN NUMBER,
34  			     p_legal_entity_id               IN NUMBER,
35    			     p_org_id 			     IN NUMBER,
36 			     p_trx_date			     IN DATE,
37                              p_exempt_certificate_number     IN VARCHAR2,
38                              p_reason_code                   IN VARCHAR2,
39                              p_exempt_control_flag           IN VARCHAR2,
40 			     p_inventory_org_id		     IN NUMBER,
41 			     p_inventory_item_id	     IN NUMBER,
42                              x_return_status                 OUT NOCOPY VARCHAR2,
43                              x_exemption_rec_tbl             OUT NOCOPY exemption_rec_tbl_type);
44 
45 END;