1 PACKAGE OE_LINEINFO_GRP AUTHID CURRENT_USER AS
2 /* $Header: OEXLIFOS.pls 120.0 2005/06/01 00:51:15 appldev noship $ */
3
4
5
6
7 Type adj_tbl_type is Table of OE_HEADER_ADJ_UTIL.line_adjustments_rec_type;
8 Type tax_rec_type is record
9 (tax_code VARCHAR2(50),
10 tax_rate NUMBER,
11 tax_amount NUMBER ,
12 tax_date DATE,
13 tax_exempt_flag VARCHAR2(1),
14 tax_exempt_number VARCHAR2(80),
15 tax_exempt_reason_code VARCHAR2(30));
16
17 Procedure Get_Adjustments( p_header_id IN NUMBER
18 ,p_line_id IN NUMBER
19 ,x_adj_detail OUT nocopy OE_Header_Adj_Util.line_adjustments_tab_type
20 ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
21
22 Procedure Get_Tax(p_header_id IN NUMBER
23 ,p_line_id IN NUMBER
24 ,x_tax_rec OUT nocopy oe_lineinfo_grp.tax_rec_type
25 ,x_return_status OUT nocopy VARCHAR2);
26
27 /*Procedure Get_All_Taxes(p_header_id IN NUMBER
28 ,x_tax_tbl OUT nocopy oe_lineinfo_grp.tax_tbl_type);*/
29
30 Procedure Get_Total_Tax(p_header_id IN NUMBER
31 ,x_order_tax_total OUT nocopy NUMBER
32 ,x_return_status OUT nocopy VARCHAR2);
33
34 End OE_LINEINFO_GRP;