PACKAGE: APPS.OM_TAX_UTIL

Source

1 PACKAGE om_tax_util AUTHID CURRENT_USER AS
2 /* $Header: OEXUTAXS.pls 120.2 2011/03/16 10:02:17 cpati ship $ */
3 
4 TYPE om_tax_out_rec_type IS RECORD
5 ( trx_id    	           NUMBER,
6   trx_line_id              NUMBER,
7   line_id                  NUMBER,  --Jeevan ER
8   trx_level_type           zx_detail_tax_lines_gt.trx_level_type%TYPE,  -- Jeevan ER
9   tax_amount               NUMBER,
10   taxable_amount           NUMBER,
11   tax_rate_id              NUMBER,
12   tax_rate_code            VARCHAR2(50),
13   tax_rate                 NUMBER,
14   amount_includes_tax_flag VARCHAR2(1));
15 
16 
17 TYPE om_tax_out_tab_type IS TABLE of om_tax_out_rec_type index by
18   binary_integer;
19 
20 om_tax_info_rec_tbl om_tax_out_tab_type;
21 
22 
23 TYPE charge_rec IS RECORD (
24 	           charge_id         OE_PRICE_ADJUSTMENTS.PRICE_ADJUSTMENT_ID%TYPE,
25 	           charge_amount             OE_PRICE_ADJUSTMENTS.ADJUSTED_AMOUNT%TYPE);
26 
27 	        TYPE charge_tbl IS TABLE OF charge_rec INDEX BY BINARY_INTEGER;
28 
29  TYPE om_tax_info_rec IS RECORD (
30                      trx_id OE_ORDER_HEADERS_ALL.header_id%TYPE,
31                      trx_line_id  NUMBER,
32                      line_id  NUMBER,
33                       trx_level_type VARCHAR2(20));
34 
35        TYPE om_tax_rec_tab_type IS TABLE OF om_tax_info_rec INDEX BY BINARY_INTEGER;
36 
37 
38 
39 TYPE tax_rec_tbl_type is TABLE of RA_CUSTOMER_TRX_LINES%ROWTYPE index by
40   binary_integer;
41 
42 tax_rec_tbl         tax_rec_tbl_type;
43 
44 
45 /*TAXER Procedure definition changed as part of tax ER*/
46 PROCEDURE TAX_LINE(
47     p_entity_id_tbl IN OE_Delayed_Requests_PVT.Entity_Id_Tbl_Type,
48     x_tax_out_tbl OUT NOCOPY OM_TAX_UTIL.om_tax_out_tab_type,
49     x_return_status OUT NOCOPY    /* file.sql.39 change */    VARCHAR2)   ;
50 
51 
52 PROCEDURE CALCULATE_TAX ( p_header_id 		in number
53                          ,x_return_status	out NOCOPY /* file.sql.39 change */ varchar2);
54 
55 /* Added for TAXER*/
56 Function get_charge_details(p_header_id		NUMBER,
57 				       p_line_id		NUMBER)
58 	     RETURN charge_tbl;
59 
60 FUNCTION Get_Content_Owner_Id(
61 p_header_id IN NUMBER)  RETURN NUMBER;
62 
63 END OM_TAX_UTIL;