PACKAGE: APPS.ZX_TCM_GET_EXCEPT_PKG

Source

1 PACKAGE ZX_TCM_GET_EXCEPT_PKG AUTHID CURRENT_USER AS
2 /* $Header: zxcgetexcepts.pls 120.3 2010/09/30 18:21:40 msakalab ship $ */
3 
4 TYPE exception_rec_type IS RECORD
5   (tax_exception_id        NUMBER,
6    exception_type_code     VARCHAR2(30),
7    exception_rate          NUMBER
8    );
9 
10 TYPE tax_jurisdiction_rec_type IS RECORD
11   (tax_jurisdiction_id     NUMBER,
12    tax_jurisdiction_code   VARCHAR2(30)
13    );
14 
15 TYPE tax_jurisdiction_tbl_type IS TABLE of tax_jurisdiction_rec_type INDEX BY BINARY_INTEGER;
16 
17 PROCEDURE get_tax_exceptions(p_inventory_item_id IN NUMBER,
18                              p_inventory_organization_id IN NUMBER,
19                              p_product_category  IN VARCHAR2,
20 			     p_fisc_classification_code IN VARCHAR2,
21                              p_tax_regime_code   IN VARCHAR2,
22                              p_tax               IN VARCHAR2,
23                              p_tax_status_code   IN VARCHAR2,
24                              p_tax_rate_code     IN VARCHAR2,
25                              p_trx_date          IN DATE,
26                              p_tax_jurisdiction_id IN NUMBER,
27                              p_multiple_jurisdictions_flag   IN VARCHAR2,
28                              x_exception_rec     OUT NOCOPY exception_rec_type,
29                              x_return_status     OUT NOCOPY VARCHAR2);
30 
31 
32 END;