PACKAGE: APPS.ZX_TCM_GET_EXCEPT_PKG

Source

1 PACKAGE ZX_TCM_GET_EXCEPT_PKG AS
2 /* $Header: zxcgetexcepts.pls 120.2 2005/09/01 22:55:08 sachandr 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_tax_regime_code   IN VARCHAR2,
21                              p_tax               IN VARCHAR2,
22                              p_tax_status_code   IN VARCHAR2,
23                              p_tax_rate_code     IN VARCHAR2,
24                              p_trx_date          IN DATE,
25                              p_tax_jurisdiction_id IN NUMBER,
26                              p_multiple_jurisdictions_flag   IN VARCHAR2,
27                              x_exception_rec     OUT NOCOPY exception_rec_type,
28                              x_return_status     OUT NOCOPY VARCHAR2);
29 
30 
31 END;