1 PACKAGE jai_po_tax_pkg AS
2 /* $Header: jai_po_tax.pls 120.16.12020000.2 2012/12/30 10:22:20 anupgupt ship $ */
3 PROCEDURE calculate_tax(
4 p_type IN VARCHAR2,
5 p_header_id NUMBER,
6 P_line_id NUMBER,
7 p_line_loc_id IN NUMBER,
8 p_line_quantity IN NUMBER,
9 p_price IN NUMBER,
10 p_line_uom_code IN VARCHAR2,
11 p_tax_amount IN OUT NOCOPY NUMBER,
12 p_assessable_value IN NUMBER DEFAULT NULL,
13 p_vat_assess_value IN NUMBER, -- Ravi for VAT
14 p_item_id IN NUMBER DEFAULT NULL,
15 p_conv_rate IN NUMBER DEFAULT NULL
16 ,pv_retroprice_changed IN VARCHAR2 DEFAULT 'N' --Added by Kevin Cheng for Retroactive Price 2008/01/10
17 ,pv_called_from IN VARCHAR2 DEFAULT NULL--Added by Eric Ma for Retroactive Price 2008/01/11
18 /* for bug 16013918 by anupgupt
19 , pn_gst_assessable_value IN NUMBER DEFAULT NULL --Added by Jia for GST Bug#10043656 on 2010/09/10
20 */
21 );
22
23 PROCEDURE batch_quot_taxes_copy
24 (
25 p_errbuf OUT NOCOPY VARCHAR2,
26 p_retcode OUT NOCOPY VARCHAR2
27 ) ;
28
29 PROCEDURE copy_reqn_taxes
30 (
31 p_Vendor_Id number,
32 p_Vendor_Site_Id number,
33 p_Po_Header_Id number,
34 p_Po_Line_Id number, --added by Sriram on 22-Nov-2001
35 p_line_location_id number, --added by Sriram on 22-Nov-2001
36 p_Type_Lookup_Code varchar2,
37 p_Quotation_Class_Code varchar2,
38 p_Ship_To_Location_Id number,
39 p_Org_Id number,
40 --p_Rate number, --commented by Sriram on 22-Nov-2001
41 --p_Rate_type number, --commented by Sriram on 22-Nov-2001
42 --p_Rate_date date, --commented by Sriram on 22-Nov-2001
43 --p_Currency_Code varchar2, --commented by Sriram on 22-Nov-2001
44 p_Creation_Date date,
45 p_Created_By number,
46 p_Last_Update_Date date,
47 p_Last_Updated_By number,
48 p_Last_Update_Login number
49 /* Brathod, For Bug# 4242351 */
50 ,p_rate PO_HEADERS_ALL.RATE%TYPE DEFAULT NULL
51 ,p_rate_type PO_HEADERS_ALL.RATE_TYPE%TYPE DEFAULT NULL
52 ,p_rate_date PO_HEADERS_ALL.RATE_DATE%TYPE DEFAULT NULL
53 ,p_currency_code PO_HEADERS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
54 /* End of Bug# 4242351 */
55 );
56
57 PROCEDURE calc_tax(
58 -- Do not use this function to pass line_location_id in place of header_id, use relevant fields to pass
59 -- the parameters
60 p_type IN VARCHAR2, -- Contains the type of document
61 p_header_id IN NUMBER, -- Contains the header_id of the document
62 P_line_id IN NUMBER, -- Contains the line_id of the document
63 p_line_location_id IN NUMBER, -- Shipment line_id of the PO Document
64 p_line_focus_id IN NUMBER, -- unique key of JAI_PO_LINE_LOCATIONS table
65 p_line_quantity IN NUMBER, -- quantity given in the line
66 p_base_value IN NUMBER, -- base value of the line i.e quantity * base price of item
67 p_line_uom_code IN VARCHAR2, -- uom_code of the line item
68 p_tax_amount IN OUT NOCOPY NUMBER, -- total tax amount that should be returned to the calling procedure
69 p_assessable_value IN NUMBER DEFAULT NULL, -- assessable value of line on which excise duty is calculated i.e quantity * assessable_price
70 p_vat_assess_value IN NUMBER, -- vat assessable value /* rallamse bug#4250072 VAT */
71 p_item_id IN NUMBER DEFAULT NULL, -- inventory item given in the line
72 p_conv_rate IN NUMBER DEFAULT NULL, -- Convertion rate from Functional to PO currency
73 p_po_curr IN VARCHAR2 DEFAULT NULL, -- PO Header or Requisition line currency
74 p_func_curr IN VARCHAR2 DEFAULT NULL, -- Functional currency of the organization or operating unit
75 p_requisition_line_id IN NUMBER DEFAULT NULL --Bgowrava for Bug#5877782
76 ,pv_retroprice_changed IN VARCHAR2 DEFAULT 'N' --Added by Kevin Cheng for Retroactive Price 2008/01/10
77 /* for bug 16013918 by anupgupt
78 , pn_gst_assessable_value IN NUMBER DEFAULT NULL --Added by Jia for GST Bug#10043656 on 2010/09/10
79 */
80 );
81
82 PROCEDURE copy_source_taxes
83 (
84 errbuf OUT NOCOPY VARCHAR2,
85 retcode OUT NOCOPY VARCHAR2,
86 p_type VARCHAR2,
87 p_po_hdr_id NUMBER,
88 p_po_line_id NUMBER,
89 p_po_line_loc_id NUMBER,
90 p_line_num NUMBER,
91 p_ship_num NUMBER,
92 p_item_id NUMBER,
93 p_from_hdr_id NUMBER,
94 p_from_type_lookup_code VARCHAR2,
95 p_cre_dt DATE,
96 p_cre_by NUMBER,
97 p_last_upd_dt DATE,
98 p_last_upd_by NUMBER,
99 p_last_upd_login NUMBER
100 );
101
102 PROCEDURE copy_quot_taxes
103 (
104 errbuf OUT NOCOPY VARCHAR2,
105 retcode OUT NOCOPY VARCHAR2,
106 p_line_loc_id IN NUMBER,
107 p_po_hdr_id IN NUMBER,
108 p_po_line_id IN NUMBER,
109 p_qty IN NUMBER,
110 p_frm_hdr_id IN NUMBER,
111 p_frm_line_id IN NUMBER,
112 p_price IN NUMBER,
113 p_unit_code IN VARCHAR2,
114 p_assessable_value IN NUMBER,
115 p_cre_dt IN DATE,
116 p_cre_by IN NUMBER,
117 p_last_upd_dt IN DATE,
118 p_last_upd_by IN NUMBER,
119 p_last_upd_login IN NUMBER
120 );
121
122 PROCEDURE copy_agreement_taxes
123 (
124 errbuf OUT NOCOPY VARCHAR2,
125 retcode OUT NOCOPY VARCHAR2,
126 p_seq_val IN NUMBER,
127 p_qty IN NUMBER,
128 p_hdr_id IN NUMBER,
129 p_line_id IN NUMBER,
130 p_line_loc_id IN NUMBER,
131 p_ship_type IN VARCHAR2,
132 p_cum_flag IN VARCHAR2,
133 p_cre_dt IN DATE,
134 p_cre_by IN NUMBER,
135 p_last_cre_dt IN DATE,
136 p_last_cre_by IN NUMBER,
137 p_last_login IN NUMBER
138 ,pv_retroprice_changed IN VARCHAR2 DEFAULT 'N' --Added by Kevin Cheng for Retroactive Price 2008/01/10
139 );
140
141 PROCEDURE Ja_In_Po_Case1(
142 v_type_lookup_code IN VARCHAR2,
143 v_quot_class_code IN VARCHAR2,
144 vendor_id IN NUMBER,
145 v_vendor_site_id IN NUMBER,
146 currency IN VARCHAR2,
147 v_org_id IN NUMBER,
148 v_item_id IN NUMBER,
149 v_uom_measure IN VARCHAR2,
150 v_line_loc_id IN NUMBER,
151 v_po_hdr_id IN NUMBER,
152 v_po_line_id IN NUMBER,
153 v_frm_po_line_id IN NUMBER,
154 v_frm_line_loc_id IN NUMBER,
155 v_price IN NUMBER,
156 v_qty IN NUMBER,
157 v_cre_dt IN DATE,
158 v_cre_by IN NUMBER,
159 v_last_upd_dt IN DATE,
160 v_last_upd_by IN NUMBER,
161 v_last_upd_login IN NUMBER,
162 flag IN VARCHAR2,
163 success IN OUT NOCOPY NUMBER,
164 p_quantity IN PO_LINE_LOCATIONS_ALL.quantity%TYPE DEFAULT NULL --added by csahoo for bug#6144740
165 );
166
167 PROCEDURE Ja_In_Po_Case2(
168 v_type_lookup_code IN VARCHAR2,
169 v_quot_class_code IN VARCHAR2,
170 vendor_id IN NUMBER,
171 v_vendor_site_id IN NUMBER,
172 currency IN VARCHAR2,
173 v_org_id IN NUMBER,
174 v_item_id IN NUMBER,
175 v_line_loc_id IN NUMBER,
176 v_po_hdr_id IN NUMBER,
177 v_po_line_id IN NUMBER,
178 v_price IN NUMBER,
179 v_qty IN NUMBER,
180 v_cre_dt IN DATE,
181 v_cre_by IN NUMBER,
182 v_last_upd_dt IN DATE,
183 v_last_upd_by IN NUMBER,
184 v_last_upd_login IN NUMBER,
185 v_uom_measure IN VARCHAR2,
186 flag IN VARCHAR2,
187 v_assessable_val IN NUMBER DEFAULT NULL,
188 p_vat_assess_value IN NUMBER , -- added, Harshita for bug #4245062
189 v_conv_rate IN NUMBER DEFAULT NULL,
190 /* Bug 5096787. Added by Lakshmi Gopalsami */
191 v_rate IN NUMBER DEFAULT NULL,
192 v_rate_date IN DATE DEFAULT NULL,
193 v_rate_type IN VARCHAR2 DEFAULT NULL,
194 p_tax_category_id IN NUMBER DEFAULT NULL
195 ,pv_retroprice_changed IN VARCHAR2 DEFAULT 'N' --Added by Kevin Cheng for Retroactive Price 2008/01/13
196 /* for bug 16013918 by anupgupt
197 , pn_gst_assessable_value IN NUMBER DEFAULT NULL --Added by Jia for GST Bug#10043656 on 2010/09/10
198 */
199 );
200
201 PROCEDURE Ja_In_Po_Insert(
202 v_type_lookup_code IN VARCHAR2,
203 v_quot_class_code IN VARCHAR2,
204 v_seq_val IN NUMBER,
205 v_line_loc_id IN NUMBER,
206 v_tax_line_no IN NUMBER,
207 v_po_line_id IN NUMBER,
208 v_po_hdr_id IN NUMBER,
209 v_prec1 IN NUMBER,
210 v_prec2 IN NUMBER,
211 v_prec3 IN NUMBER,
212 v_prec4 IN NUMBER,
213 v_prec5 IN NUMBER,
214 v_prec6 IN NUMBER, -- Date 31/10/2006 Bug 5228046 added by SACSETHI ( added column from Precedence 6 to 10 )
215 v_prec7 IN NUMBER,
216 v_prec8 IN NUMBER,
217 v_prec9 IN NUMBER,
218 v_prec10 IN NUMBER,
219 v_taxid IN NUMBER,
220 v_price IN NUMBER,
221 v_qty IN NUMBER,
222 v_curr IN VARCHAR2,
223 v_tax_rate IN NUMBER,
224 v_qty_rate IN NUMBER,
225 v_uom IN VARCHAR2,
226 v_tax_amt IN NUMBER ,
227 v_tax_type VARCHAR2,
228 v_mod_flag IN VARCHAR2,
229 v_vendor_id IN NUMBER,
230 v_tax_target_amt IN NUMBER,
231 v_cre_dt IN DATE,
232 v_cre_by IN NUMBER,
233 v_last_upd_dt IN DATE,
234 v_last_upd_by IN NUMBER,
235 v_last_upd_login IN NUMBER,
236 v_tax_category_id IN NUMBER -- cbabu for EnhancementBug# 2427465
237 ) ;
238
239 END jai_po_tax_pkg;