DBA Data[Home] [Help]

PACKAGE: APPS.OE_LINEINFO_GRP

Source


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;