1 PACKAGE jai_po_proc_pkg AUTHID CURRENT_USER AS
2 /* $Header: jai_po_proc.pls 120.3.12020000.2 2013/03/19 00:41:56 vkaranam noship $ */
3 PROCEDURE process_po_taxes
4 (
5 v_type_lookup_code IN VARCHAR2
6 ,v_quot_class_code IN VARCHAR2
7 ,v_vendor_id IN NUMBER
8 ,v_vendor_site_id IN NUMBER
9 ,v_currency IN VARCHAR2
10 ,v_org_id IN NUMBER
11 ,v_item_id IN NUMBER
12 ,v_uom_code IN VARCHAR2
13 ,v_line_loc_id IN NUMBER
14 ,v_po_hdr_id IN NUMBER
15 ,v_po_line_id IN NUMBER
16 ,v_frm_po_line_id IN NUMBER
17 ,v_frm_line_loc_id IN NUMBER
18 ,v_price IN NUMBER
19 ,v_qty IN NUMBER
20 ,v_cre_dt IN DATE
21 ,v_cre_by IN NUMBER
22 ,v_last_upd_dt IN DATE
23 ,v_last_upd_by IN NUMBER
24 ,v_last_upd_login IN NUMBER
25 ,flag IN VARCHAR2
26 ,pn_conv_rate IN NUMBER DEFAULT 1
27 ,pn_assessable_value IN NUMBER
28 ,pn_vat_assess_value IN NUMBER
29 ,p_tax_category_id IN NUMBER DEFAULT NULL
30 ,pv_retroprice_changed IN VARCHAR2 DEFAULT 'N'
31 );
32
33 PROCEDURE process_po_tax_wrapper
34 ( prec_po_header IN po_headers_all%ROWTYPE DEFAULT NULL --Added by Wenqiong for bug16288154
35 ,prec_po_line IN po_lines_all%ROWTYPE DEFAULT NULL
36 ,prec_po_location IN po_line_locations_all%ROWTYPE DEFAULT NULL
37 ,pv_retro_price_flag IN VARCHAR2 DEFAULT 'N'
38 );
39
40 PROCEDURE copy_source_taxes
41 (
42 p_type VARCHAR2
43 ,p_po_hdr_id NUMBER
44 ,p_po_line_id NUMBER
45 ,p_po_line_loc_id NUMBER
46 ,p_line_num NUMBER
47 ,p_ship_num NUMBER
48 ,p_item_id NUMBER
49 ,p_from_hdr_id NUMBER
50 ,p_from_type_lookup_code VARCHAR2
51 ,p_source_line_id NUMBER
52 ,p_source_loc_id NUMBER
53 ,p_cre_dt DATE
54 ,p_cre_by NUMBER
55 ,p_last_upd_dt DATE
56 ,p_last_upd_by NUMBER
57 ,p_last_upd_login NUMBER
58 );
59
60 PROCEDURE copy_quot_taxes
61 (
62 p_line_loc_id IN NUMBER
63 ,p_po_hdr_id IN NUMBER
64 ,p_po_line_id IN NUMBER
65 ,p_item_id IN NUMBER
66 ,p_qty IN NUMBER
67 ,p_frm_hdr_id IN NUMBER
68 ,p_frm_line_id IN NUMBER
69 ,p_price IN NUMBER
70 ,p_unit_code IN VARCHAR2
71 ,p_cre_dt IN DATE
72 ,p_cre_by IN NUMBER
73 ,p_last_upd_dt IN DATE
74 ,p_last_upd_by IN NUMBER
75 ,p_last_upd_login IN NUMBER
76 ,p_call_from IN VARCHAR2 DEFAULT NULL
77 );
78
79 PROCEDURE process_po
80 (
81 pn_header_id IN NUMBER
82 ,pv_action IN VARCHAR2
83 );
84
85 PROCEDURE process_po_line
86 (
87 pn_line_id IN NUMBER
88 ,pr_po_header IN po_headers_all%ROWTYPE DEFAULT NULL
89 ,pv_action IN VARCHAR2
90 );
91
92 PROCEDURE process_po_shipment_line
93 (
94 pn_line_loc_id IN NUMBER
95 ,pr_po_header IN po_headers_all%ROWTYPE DEFAULT NULL
96 ,pr_po_line IN po_lines_all%ROWTYPE DEFAULT NULL
97 ,pv_action IN VARCHAR2
98 );
99
100 PROCEDURE update_currency
101 (
102 pn_po_header_id IN NUMBER
103 ,pv_old_currency IN VARCHAR2
104 ,pv_currency IN VARCHAR2
105 ,pd_last_upd_dt IN DATE
106 ,pn_last_upd_by IN NUMBER
107 ,pn_last_upd_login IN NUMBER
108 );
109 PROCEDURE update_vendor
110 (
111 pn_po_header_id IN NUMBER
112 ,pn_old_vendor_id IN NUMBER
113 ,pn_vendor_id IN NUMBER
114 ,pn_vendor_site_id IN NUMBER
115 ,pd_last_upd_dt IN DATE
116 ,pn_last_upd_by IN NUMBER
117 ,pn_last_upd_login IN NUMBER
118 );
119 PROCEDURE delete_jai_po_lines
120 (
121 pn_line_id IN NUMBER DEFAULT NULL
122 ,pn_line_loc_id IN NUMBER DEFAULT NULL
123 );
124 PROCEDURE delete_po_taxes
125 (
126 pn_po_hdr_id IN NUMBER DEFAULT NULL
127 ,pn_po_line_id IN NUMBER DEFAULT NULL
128 ,pn_line_loc_id IN NUMBER DEFAULT NULL
129 );
130 PROCEDURE insert_jai_line_locs
131 (
132 v_line_loc_id IN NUMBER
133 ,v_po_hdr_id IN NUMBER
134 ,v_po_line_id IN NUMBER
135 ,v_cre_dt IN DATE
136 ,v_cre_by IN NUMBER
137 ,v_last_upd_dt IN DATE
138 ,v_last_upd_by IN NUMBER
139 ,v_last_upd_login IN NUMBER
140 ,flag IN VARCHAR2
141 ,v_item_id IN NUMBER
142 ,v_vendor_id IN NUMBER
143 ,v_vendor_site_id IN NUMBER
144 ,v_qty IN NUMBER DEFAULT NULL
145 ,v_price_override IN NUMBER DEFAULT NULL
146 ,v_tax_category_id IN NUMBER DEFAULT NULL
147 ,v_tax_amount IN NUMBER DEFAULT NULL
148 ,v_total_amount IN NUMBER DEFAULT NULL
149 ,v_currency IN VARCHAR2
150 ,v_tax_modified_flag IN VARCHAR2 DEFAULT 'N'
151 ,v_line_focus_id OUT NOCOPY NUMBER
152 );
153
154 PROCEDURE get_assessable_value
155 (
156 pn_po_hdr_id IN NUMBER,
157 pn_vendor_id IN NUMBER,
158 pn_vendor_site_id IN NUMBER,
159 pn_item_id IN NUMBER,
160 pn_price IN NUMBER,
161 pn_qty IN NUMBER,
162 pv_uom_code IN VARCHAR2,
163 pv_currency IN VARCHAR2,
164 pv_action IN VARCHAR2 DEFAULT NULL,
165 pn_conv_rate IN NUMBER DEFAULT 1,
166 pn_assessable_value OUT NOCOPY NUMBER,
167 pn_vat_assess_value OUT NOCOPY NUMBER
168 );
169 PROCEDURE process_dist(prec_po_location IN po_line_locations_all%ROWTYPE);
170 PROCEDURE cancel_po(pn_po_hdr_id IN NUMBER);
171 PROCEDURE process_requisition(pn_requisition_hdr_id IN NUMBER);
172 PROCEDURE copy_req_to_po(prec_po_location IN po_line_locations_all%ROWTYPE);
173 PROCEDURE process_release
174 (
175 pn_po_release_id IN NUMBER
176 ,pv_action IN VARCHAR2
177 );
178 PROCEDURE insert_po_taxes
179 (
180 v_type_lookup_code IN VARCHAR2
181 ,v_quot_class_code IN VARCHAR2
182 ,v_seq_val IN NUMBER
183 ,v_line_loc_id IN NUMBER
184 ,v_tax_line_no IN NUMBER
185 ,v_po_line_id IN NUMBER
186 ,v_po_hdr_id IN NUMBER
187 ,v_prec1 IN NUMBER
188 ,v_prec2 IN NUMBER
189 ,v_prec3 IN NUMBER
190 ,v_prec4 IN NUMBER
191 ,v_prec5 IN NUMBER
192 ,v_prec6 IN NUMBER
193 ,v_prec7 IN NUMBER
194 ,v_prec8 IN NUMBER
195 ,v_prec9 IN NUMBER
196 ,v_prec10 IN NUMBER
197 ,v_taxid IN NUMBER
198 ,v_price IN NUMBER
199 ,v_qty IN NUMBER
200 ,v_curr IN VARCHAR2
201 ,v_tax_rate IN NUMBER
202 ,v_qty_rate IN NUMBER
203 ,v_uom IN VARCHAR2
204 ,v_tax_amt IN NUMBER
205 ,v_tax_type VARCHAR2
206 ,v_mod_flag IN VARCHAR2
207 ,v_vendor_id IN NUMBER
208 ,v_tax_target_amt IN NUMBER
209 ,v_cre_dt IN DATE
210 ,v_cre_by IN NUMBER
211 ,v_last_upd_dt IN DATE
212 ,v_last_upd_by IN NUMBER
213 ,v_last_upd_login IN NUMBER
214 ,v_tax_category_id IN NUMBER
215 );
216 PROCEDURE copy_agreement_taxes
217 (
218 p_src_ship_id IN NUMBER
219 ,p_qty IN NUMBER
220 ,p_hdr_id IN NUMBER
221 ,p_line_id IN NUMBER
222 ,p_line_loc_id IN NUMBER
223 ,p_ship_type IN VARCHAR2
224 ,p_cre_dt IN DATE
225 ,p_cre_by IN NUMBER
226 ,p_last_upd_dt IN DATE
227 ,p_last_upd_by IN NUMBER
228 ,p_last_upd_login IN NUMBER
229 ,pv_retroprice_changed IN VARCHAR2 DEFAULT 'N'
230 );
231 FUNCTION rfq_quotation_related
232 (
233 pr_po_header po_headers_all%ROWTYPE DEFAULT NULL
234 ,pr_po_line po_lines_all%ROWTYPE DEFAULT NULL
235 ,pr_po_line_loc po_line_locations_all%ROWTYPE DEFAULT NULL
236 ) RETURN BOOLEAN;
237
238 PROCEDURE process_quotation_line
239 (
240 r_old_po_line po_lines_all%ROWTYPE DEFAULT NULL
241 ,r_po_line po_lines_all%ROWTYPE
242 ,pv_action VARCHAR2
243 ,pv_return_code OUT NOCOPY VARCHAR2
244 ,pv_return_message OUT NOCOPY VARCHAR2
245 );
246
247 PROCEDURE process_quotation_line_loc
248 (
249 po_line_loc_rec po_line_locations_all%ROWTYPE
250 ,pv_action VARCHAR2
251 ,pv_return_code OUT NOCOPY VARCHAR2
252 ,pv_return_message OUT NOCOPY VARCHAR2
253 );
254 PROCEDURE process_vendor_change
255 (
256 prec_po_header IN po_headers_all%ROWTYPE
257 ,pn_old_vendor_id IN NUMBER
258 );
259 PROCEDURE delete_po_req_line_taxes
260 (
261 pn_requisition_line_id IN NUMBER
262 );
263 PROCEDURE cancel_po_shipment_line(pr_po_line_loc po_line_locations_all%ROWTYPE);
264 /*--Added below procedures/functions for bug16288154 start*/
265
266 PROCEDURE process_distribution_line
267 (
268 pr_dist PO_DISTRIBUTIONS_ALL%ROWTYPE
269 ,pv_return_code OUT NOCOPY VARCHAR2
270 ,pv_return_message OUT NOCOPY VARCHAR2
271 );
272 procedure process_po_req_line
273 (
274 pn_requisition_line_id NUMBER,
275 pr_requisition_line PO_REQUISITION_LINES_ALL%ROWTYPE DEFAULT NULL,
276 pv_action VARCHAR2
277 );
278 PROCEDURE process_po_line_loc
279 (
280 po_line_loc_rec po_line_locations_all%ROWTYPE
281 ,old_line_loc_rec PO_LINE_LOCATIONS_ALL%ROWTYPE
282 ,pv_action VARCHAR2
283 ,pv_return_code OUT NOCOPY VARCHAR2
284 ,pv_return_message OUT NOCOPY VARCHAR2
285 );
286 --Added by Wenqiong on Feb 16 2013
287 PROCEDURE copy_req_tax_to_po(prec_po_req_line IN PO_REQUISITION_LINES_ALL%ROWTYPE
288 ,pv_return_code OUT NOCOPY VARCHAR2
289 ,pv_return_message OUT NOCOPY VARCHAR2
290 );
291 /*--Added below procedures/functions for bug16288154 end*/
292 END jai_po_proc_pkg;