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