[Home] [Help]
PACKAGE: APPS.ASO_TAX_INT
Source
1 PACKAGE ASO_TAX_INT as
2 /* $Header: asoitaxs.pls 120.7.12010000.1 2008/07/28 22:15:13 appldev ship $ */
3 -- Start of Comments
4 -- Package name : ASO_TAX_INT
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 -- Record Type:
11 -- Charge_Control_Rec_Type
12
13 TYPE Tax_Control_Rec_Type IS RECORD
14 (
15 Tax_Level VARCHAR2(50) := 'SHIPMENT',
16 Update_DB VARCHAR2(1)
17 );
18
19 G_Miss_Tax_Control_Rec Tax_Control_Rec_Type;
20
21 /*
22 *
23 *
24 PROCEDURE Calculate_Tax(
25 P_Api_Version_Number IN NUMBER,
26 P_Tax_Control_Rec IN Tax_Control_Rec_Type
27 := G_Miss_Tax_Control_Rec,
28 P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
29 := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
30 P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type
31 := ASO_QUOTE_PUB.G_Miss_Qte_Line_Rec,
32 P_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
33 := ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC,
34 p_tax_detail_rec IN ASO_QUOTE_PUB.Tax_Detail_Rec_Type
35 := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_REC,
36 x_tax_amount OUT NOCOPY NUMBER,
37 x_tax_detail_tbl OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
38 X_Return_Status OUT NOCOPY VARCHAR2,
39 X_Msg_Count OUT NOCOPY NUMBER,
40 X_Msg_Data OUT NOCOPY VARCHAR2);
41
42 TYPE tax_rec_tbl_type is TABLE of RA_CUSTOMER_TRX_LINES%ROWTYPE index by
43 binary_integer;
44
45 PROCEDURE Calculate_Tax(
46 P_Api_Version_Number IN NUMBER,
47 p_quote_header_id IN NUMBER,
48 p_qte_line_id IN NUMBER :=NULL,
49 P_Tax_Control_Rec IN Tax_Control_Rec_Type
50 := G_Miss_Tax_Control_Rec,
51 x_tax_amount OUT NOCOPY NUMBER,
52 x_tax_detail_tbl OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
53 X_Return_Status OUT NOCOPY VARCHAR2,
54 X_Msg_Count OUT NOCOPY NUMBER,
55 X_Msg_Data OUT NOCOPY VARCHAR2);
56
57 PROCEDURE Calculate_Tax(
58 p_trx_id IN NUMBER,
59 p_trx_line_id IN NUMBER,
60 p_charge_line_id IN NUMBER,
61 p_viewname IN VARCHAR2,
62 x_tax_amount OUT NOCOPY NUMBER,
63 x_tax_rec_tbl OUT NOCOPY ARP_TAX.tax_rec_tbl_type);
64
65 Procedure aso_tax_line
66 (P_Api_Version_Number IN NUMBER,
67 p_qte_header_id IN NUMBER,
68 P_Tax_Control_Rec IN Tax_Control_Rec_Type
69 := G_Miss_Tax_Control_Rec,
70 p_qte_line_id IN NUMBER := NULL,
71 x_tax_value OUT NOCOPY NUMBER,
72 x_tax_detail_tbl OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
73 x_return_status OUT NOCOPY VARCHAR2
74 );
75 *
76 *
77 */
78
79 --Calculate Tax with GTT added as a part of etax By Anoop Rajan om 9 August 2005
80 --Modified on 11 August with NOCOPY Hint added
81 procedure CALCULATE_TAX_WITH_GTT
82 (
83 p_API_VERSION_NUMBER IN NUMBER,
84 p_qte_header_id IN NUMBER,
85 p_qte_line_id IN NUMBER:=NULL,
86 x_return_status OUT NOCOPY VARCHAR2,
87 X_Msg_Count OUT NOCOPY NUMBER,
88 X_Msg_Data OUT NOCOPY VARCHAR2
89 );
90
91 -- Commenting the following routine as part of release 12. Bug 5044986
92 /*
93 *
94 *
95 PROCEDURE print_tax_info_rec( p_debug_level in number := 5 );
96 *
97 *
98 */
99
100 FUNCTION Get_Tax_Detail_Id (
101 p_qte_header_id NUMBER,
102 p_qte_line_id NUMBER,
103 p_shipment_id NUMBER) RETURN NUMBER;
104
105 FUNCTION Get_Tax_Code (
106 p_qte_header_id NUMBER,
107 p_qte_line_id NUMBER,
108 p_shipment_id NUMBER) RETURN VARCHAR2;
109
110 FUNCTION Get_Tax_exempt_flag (
111 p_qte_header_id NUMBER,
112 p_qte_line_id NUMBER,
113 p_shipment_id NUMBER) RETURN VARCHAR2;
114
115 FUNCTION Get_Tax_exempt_number (
116 p_qte_header_id NUMBER,
117 p_qte_line_id NUMBER,
118 p_shipment_id NUMBER) RETURN VARCHAR2;
119
120 FUNCTION Get_Tax_exempt_reason_code (
121 p_qte_header_id NUMBER,
122 p_qte_line_id NUMBER,
123 p_shipment_id NUMBER) RETURN VARCHAR2;
124
125 FUNCTION Get_Tax_Invoice_To (
126 p_ln_invoice_id NUMBER,
127 p_hd_invoice_id NUMBER) RETURN NUMBER;
128
129 FUNCTION GET_ra_trx_type_ID (p_order_type_id NUMBER,p_qte_line_rec ASO_QUOTE_PUB.Qte_Line_rec_Type) RETURN NUMBER;
130
131 --Procedure added by Anoop on 14 Sep 2005 to print TAX GTT details
132 Procedure print_tax_info(rec in number,qte_header_id in number) ;
133 End ASO_TAX_INT;