[Home] [Help]
PACKAGE: APPS.INL_SHIPMENT_PVT
Source
1 PACKAGE "INL_SHIPMENT_PVT" AUTHID CURRENT_USER AS
2 /* $Header: INLVSHPS.pls 120.37.12020000.4 2013/02/06 13:40:34 acferrei ship $ */
3
4 G_MODULE_NAME CONSTANT VARCHAR2(200) := 'INL.PLSQL.INL_SHIPMENT_PVT.';
5 G_PKG_NAME CONSTANT VARCHAR2(30) := 'INL_SHIPMENT_PVT';
6
7 L_FND_FALSE CONSTANT VARCHAR2(1) := fnd_api.g_false; --Bug#9660082
8 L_FND_VALID_LEVEL_FULL CONSTANT NUMBER := fnd_api.g_valid_level_full; --Bug#9660082
9
10
11 TYPE ship_qty_validation_inf_rec IS RECORD(ship_num VARCHAR2(25),
12 ship_line_num NUMBER);
13
14
15 TYPE ship_qty_validation_inf_tbl IS
16 TABLE OF ship_qty_validation_inf_rec INDEX BY BINARY_INTEGER;
17
18 TYPE inl_Assoc_tp IS RECORD (
19 association_id NUMBER ,
20 ship_header_id NUMBER ,
21 allocation_basis VARCHAR2(30) ,
22 allocation_uom_code VARCHAR2(3) ,
23 to_parent_table_name VARCHAR2(30) ,
24 to_parent_table_id NUMBER
25 );
26
27 TYPE inl_ChLn_Assoc_tp IS RECORD (
28 charge_line_num NUMBER ,
29 charge_line_type_id NUMBER ,
30 landed_cost_flag VARCHAR2(1) ,
31 parent_charge_line_id NUMBER ,
32 adjustment_num NUMBER ,
33 match_id NUMBER ,
34 match_amount_id NUMBER ,
35 charge_amt NUMBER ,
36 currency_code VARCHAR2(15) ,
37 currency_conversion_type VARCHAR2(30) ,
38 currency_conversion_date DATE ,
39 currency_conversion_rate NUMBER ,
40 party_id NUMBER ,
41 party_site_id NUMBER ,
42 trx_business_category VARCHAR2(240),
43 intended_use VARCHAR2(30) ,
44 product_fiscal_class VARCHAR2(240),
45 product_category VARCHAR2(240),
46 product_type VARCHAR2(240),
47 user_def_fiscal_class VARCHAR2(240),
48 tax_classification_code VARCHAR2(30) ,
49 assessable_value NUMBER ,
50 tax_already_calculated_flag VARCHAR2(1) ,
51 ship_from_party_id NUMBER ,
52 ship_from_party_site_id NUMBER ,
53 ship_to_organization_id NUMBER ,
54 ship_to_location_id NUMBER ,
55 bill_from_party_id NUMBER ,
56 bill_from_party_site_id NUMBER ,
57 bill_to_organization_id NUMBER ,
58 bill_to_location_id NUMBER ,
59 poa_party_id NUMBER ,
60 poa_party_site_id NUMBER ,
61 poo_organization_id NUMBER ,
62 poo_location_id NUMBER ,
63 inl_Assoc inl_Assoc_tp
64 );
65 TYPE inl_TxLn_Assoc_tp IS RECORD (
66 tax_line_num NUMBER ,
67 tax_code VARCHAR2(30) ,
68 parent_tax_line_id NUMBER ,
69 adjustment_num NUMBER ,
70 match_id NUMBER ,
71 match_amount_id NUMBER ,
72 source_parent_table_name VARCHAR2(30) ,
73 source_parent_table_id NUMBER ,
74 matched_amt NUMBER ,
75 nrec_tax_amt NUMBER ,
76 currency_code VARCHAR2(15) ,
77 currency_conversion_type VARCHAR2(30) ,
78 currency_conversion_date DATE ,
79 currency_conversion_rate NUMBER ,
80 tax_amt_included_flag VARCHAR2(1) ,
81 inl_Assoc inl_Assoc_tp
82 );
83
84 PROCEDURE Set_ToRevalidate(
85 p_api_version IN NUMBER,
86 p_init_msg_list IN VARCHAR2 := L_FND_FALSE,
87 p_commit IN VARCHAR2 := L_FND_FALSE,
88 p_ship_header_id IN NUMBER,
89 x_msg_count OUT NOCOPY NUMBER,
90 x_msg_data OUT NOCOPY VARCHAR2,
91 x_return_status OUT NOCOPY VARCHAR2
92 );
93
94 PROCEDURE Validate_Shipment(
95 p_api_version IN NUMBER,
96 p_init_msg_list IN VARCHAR2 := L_FND_FALSE,
97 p_commit IN VARCHAR2 := L_FND_FALSE,
98 p_validation_level IN NUMBER := L_FND_VALID_LEVEL_FULL,
99 p_ship_header_id IN NUMBER,
100 p_task_code IN VARCHAR2 DEFAULT NULL, --Bug#9836174
101 x_return_status OUT NOCOPY VARCHAR2,
102 x_msg_count OUT NOCOPY NUMBER,
103 x_msg_data OUT NOCOPY VARCHAR2
104 );
105
106 FUNCTION Validate_InvOpenPeriod(
107 x_trx_date IN VARCHAR2,
108 x_sob_id IN NUMBER,
109 x_org_id IN NUMBER,
110 x_return_status IN OUT NOCOPY VARCHAR2
111 ) RETURN VARCHAR2;
112
113 PROCEDURE Adjust_ShipLines(
114 p_api_version IN NUMBER,
115 p_init_msg_list IN VARCHAR2 := L_FND_FALSE,
116 p_commit IN VARCHAR2 := L_FND_FALSE,
117 p_match_id IN NUMBER,
118 p_adjustment_num IN NUMBER,
119 p_func_currency_code IN VARCHAR2 , --BUG#8468830
120 x_return_status OUT NOCOPY VARCHAR2,
121 x_msg_count OUT NOCOPY NUMBER,
122 x_msg_data OUT NOCOPY VARCHAR2
123 );
124
125 PROCEDURE Adjust_ChargeLines (
126 p_api_version IN NUMBER,
127 p_init_msg_list IN VARCHAR2 := L_FND_FALSE,
128 p_commit IN VARCHAR2 := L_FND_FALSE,
129 p_match_id IN NUMBER,
130 p_adjustment_num IN NUMBER,
131 p_func_currency_code IN VARCHAR2 , --BUG#8468830
132 x_return_status OUT NOCOPY VARCHAR2,
133 x_msg_count OUT NOCOPY NUMBER,
134 x_msg_data OUT NOCOPY VARCHAR2
135 );
136
137 PROCEDURE Adjust_ChargeLines (
138 p_api_version IN NUMBER,
139 p_init_msg_list IN VARCHAR2 := L_FND_FALSE,
140 p_commit IN VARCHAR2 := L_FND_FALSE,
141 p_match_amount_id IN NUMBER,
142 p_adjustment_num IN NUMBER,
143 p_func_currency_code IN VARCHAR2 , --BUG#8468830
144 x_return_status OUT NOCOPY VARCHAR2,
145 x_msg_count OUT NOCOPY NUMBER,
146 x_msg_data OUT NOCOPY VARCHAR2);
147
148 PROCEDURE Adjust_TaxLines (
149 p_api_version IN NUMBER,
150 p_init_msg_list IN VARCHAR2 := L_FND_FALSE,
151 p_commit IN VARCHAR2 := L_FND_FALSE,
152 p_match_id IN NUMBER,
153 p_adjustment_num IN NUMBER,
154 p_func_currency_code IN VARCHAR2 , --BUG#8468830
155 x_return_status OUT NOCOPY VARCHAR2,
156 x_msg_count OUT NOCOPY NUMBER,
157 x_msg_data OUT NOCOPY VARCHAR2
158 );
159
160 PROCEDURE Adjust_Lines (
161 p_api_version IN NUMBER,
162 p_init_msg_list IN VARCHAR2 := L_FND_FALSE,
163 p_commit IN VARCHAR2 := L_FND_FALSE,
164 p_ship_header_id IN NUMBER,
165 x_return_status OUT NOCOPY VARCHAR2,
166 x_msg_count OUT NOCOPY NUMBER,
167 x_msg_data OUT NOCOPY VARCHAR2
168 );
169
170 PROCEDURE Get_1ary2aryQty (
171 p_api_version IN NUMBER,
172 p_init_msg_list IN VARCHAR2 := L_FND_FALSE,
173 p_commit IN VARCHAR2 := L_FND_FALSE,
174 p_inventory_item_id IN NUMBER,
175 p_organization_id IN NUMBER,
176 p_uom_code IN VARCHAR2,
177 p_qty IN NUMBER,
178 x_1ary_uom_code OUT NOCOPY VARCHAR2,
179 x_1ary_qty OUT NOCOPY NUMBER,
180 x_2ary_uom_code OUT NOCOPY VARCHAR2,
181 x_2ary_qty OUT NOCOPY NUMBER,
182 x_return_status OUT NOCOPY VARCHAR2,
183 x_msg_count OUT NOCOPY NUMBER,
184 x_msg_data OUT NOCOPY VARCHAR2
185 );
186
187 FUNCTION Get_SrcAvailableQty(
188 p_ship_line_src_type_code IN VARCHAR2,
189 p_parent_id IN NUMBER
190 ) RETURN NUMBER;
191
192 -- /SCM-051
193 PROCEDURE ProcessAction(
194 p_api_version IN NUMBER,
195 p_init_msg_list IN VARCHAR2 := L_FND_FALSE,
196 p_commit IN VARCHAR2 := L_FND_FALSE,
197 p_ship_header_id IN NUMBER,
198 p_task_code IN VARCHAR2,
199 p_caller IN VARCHAR2,
200 x_return_status OUT NOCOPY VARCHAR2,
201 x_msg_count OUT NOCOPY NUMBER,
202 x_msg_data OUT NOCOPY VARCHAR2);
203 -- /SCM-051
204
205 PROCEDURE Complete_PendingShipment (
206 errbuf OUT NOCOPY VARCHAR2,
207 retcode OUT NOCOPY VARCHAR2,
208 p_organization_id IN NUMBER,
209 p_ship_header_id IN NUMBER
210 );
211
212 PROCEDURE Update_PendingMatchingFlag (
213 p_ship_header_id IN NUMBER,
214 p_pending_matching_flag IN VARCHAR,
215 x_return_status OUT NOCOPY VARCHAR2
216 );
217
218 PROCEDURE Delete_ChargeAssoc(
219 p_api_version IN NUMBER,
220 p_init_msg_list IN VARCHAR2 := L_FND_FALSE,
221 p_commit IN VARCHAR2 := L_FND_FALSE,
222 p_ship_header_id IN NUMBER,
223 p_charge_line_id IN NUMBER,
224 x_return_status OUT NOCOPY VARCHAR2,
225 x_msg_count OUT NOCOPY NUMBER,
226 x_msg_data OUT NOCOPY VARCHAR2
227 );
228
229 -- SCM-051 Bug# 13590582
230 PROCEDURE Check_PoTolerances(
231 p_api_version IN NUMBER,
232 p_init_msg_list IN VARCHAR2 := L_FND_FALSE,
233 p_commit IN VARCHAR2 := L_FND_FALSE,
234 p_ship_header_id IN NUMBER,
235 p_ship_line_id IN NUMBER,
236 p_organization_id IN NUMBER,
237 p_ship_line_num IN NUMBER,
238 p_ship_line_src_id IN NUMBER,
239 p_inventory_item_id IN NUMBER,
240 p_primary_qty IN NUMBER,
241 p_primary_uom_code IN VARCHAR2,
242 p_txn_uom_code IN VARCHAR2,
243 p_new_txn_unit_price IN NUMBER,
244 p_pri_unit_price IN NUMBER,
245 p_currency_code IN VARCHAR2,
246 p_currency_conversion_type IN VARCHAR2,
247 p_currency_conversion_date IN DATE,
248 p_currency_conversion_rate IN NUMBER,
249 x_return_status OUT NOCOPY VARCHAR2,
250 x_msg_count OUT NOCOPY NUMBER,
251 x_msg_data OUT NOCOPY VARCHAR2);
252 -- /SCM-051 Bug# 13590582
253
254 PROCEDURE Check_PoTolerances(
255 p_api_version IN NUMBER,
256 p_init_msg_list IN VARCHAR2 := L_FND_FALSE,
257 p_commit IN VARCHAR2 := L_FND_FALSE,
258 p_ship_header_id IN NUMBER,
259 p_ship_line_id IN NUMBER,
260 p_organization_id IN NUMBER,
261 p_ship_line_num IN NUMBER,
262 p_ship_line_src_id IN NUMBER,
263 p_inventory_item_id IN NUMBER,
264 p_primary_qty IN NUMBER,
265 p_primary_uom_code IN VARCHAR2,
266 p_txn_uom_code IN VARCHAR2,
267 p_pri_unit_price IN NUMBER,
268 p_currency_code IN VARCHAR2,
269 p_currency_conversion_type IN VARCHAR2,
270 p_currency_conversion_date IN DATE,
271 p_currency_conversion_rate IN NUMBER,
272 x_return_status OUT NOCOPY VARCHAR2,
273 x_msg_count OUT NOCOPY NUMBER,
274 x_msg_data OUT NOCOPY VARCHAR2
275 );
276
277 PROCEDURE Check_PoPriceTolerance(
278 p_ship_header_id IN NUMBER,
279 p_ship_line_id IN NUMBER,
280 p_organization_id IN NUMBER,
281 p_ship_line_num IN NUMBER,
282 p_ship_line_src_id IN NUMBER,
283 p_pri_unit_price IN NUMBER,
284 p_primary_uom_code IN VARCHAR2, --BUG#7670307
285 p_currency_code IN VARCHAR2, --BUG#7670307
286 p_currency_conversion_type IN VARCHAR2, --BUG#7670307
287 p_currency_conversion_date IN DATE, --BUG#7670307
288 p_currency_conversion_rate IN NUMBER, --BUG#7670307
289 x_return_validation_status OUT NOCOPY VARCHAR2, -- ebarbosa
290 x_return_status OUT NOCOPY VARCHAR2
291 ); -- ebarbosa
292
293 /* Bug#10032820
294 can't be call from none else process_action
295 PROCEDURE Complete_Shipment (
296 p_api_version IN NUMBER,
297 p_init_msg_list IN VARCHAR2 := L_FND_FALSE,
298 p_commit IN VARCHAR2 := L_FND_FALSE,
299 p_ship_header_id IN NUMBER,
300 p_rcv_enabled_flag IN VARCHAR2,
301 p_pending_matching_flag IN VARCHAR2,
302 p_organization_id IN NUMBER,
303 x_return_status OUT NOCOPY VARCHAR2,
304 x_msg_count OUT NOCOPY NUMBER,
305 x_msg_data OUT NOCOPY VARCHAR2
306 );
307 */
308 FUNCTION Get_MatchedAmt(p_ship_header_id IN NUMBER,
309 p_ship_line_id IN NUMBER,
310 p_charge_line_type_id IN NUMBER,
311 p_tax_code IN VARCHAR2,
312 p_match_table_name IN VARCHAR2,
313 p_summarized_matched_amt IN VARCHAR2) RETURN NUMBER;
314
315 FUNCTION Get_LastUpdateDateForShip(p_ship_header_id IN NUMBER) RETURN DATE; -- Bug #9098758
316
317 PROCEDURE Discard_Updates(p_api_version IN NUMBER,
318 p_init_msg_list IN VARCHAR2 := L_FND_FALSE,
319 p_commit IN VARCHAR2 := L_FND_FALSE,
320 p_ship_header_id IN NUMBER,
321 x_return_status OUT NOCOPY VARCHAR2,
322 x_msg_count OUT NOCOPY NUMBER,
323 x_msg_data OUT NOCOPY VARCHAR2);
324 --- Bug 13914863
325 PROCEDURE Get_1aryQty(p_api_version IN NUMBER,
326 p_init_msg_list IN VARCHAR2 := L_FND_FALSE,
327 p_commit IN VARCHAR2 := L_FND_FALSE,
328 p_inventory_item_id IN NUMBER,
329 p_organization_id IN NUMBER,
330 p_uom_code IN VARCHAR2,
331 p_qty IN NUMBER,
332 x_1ary_uom_code OUT NOCOPY VARCHAR2,
333 x_1ary_qty OUT NOCOPY NUMBER,
334 x_return_status OUT NOCOPY VARCHAR2,
335 x_msg_count OUT NOCOPY NUMBER,
336 x_msg_data OUT NOCOPY VARCHAR2);
337
338 -- Bug 13914863
339 PROCEDURE Get_2aryQty(p_api_version IN NUMBER,
340 p_init_msg_list IN VARCHAR2 := L_FND_FALSE,
341 p_commit IN VARCHAR2 := L_FND_FALSE,
342 p_inventory_item_id IN NUMBER,
343 p_organization_id IN NUMBER,
344 p_uom_code IN VARCHAR2,
345 p_qty IN NUMBER,
346 x_2ary_uom_code OUT NOCOPY VARCHAR2,
347 x_2ary_qty OUT NOCOPY NUMBER,
348 x_return_status OUT NOCOPY VARCHAR2,
349 x_msg_count OUT NOCOPY NUMBER,
350 x_msg_data OUT NOCOPY VARCHAR2);
351
352 -- Bug 13914863
353 FUNCTION Derive_DualQuantities(p_organization_id IN NUMBER,
354 p_inventory_item_id IN NUMBER,
355 p_calling_field IN VARCHAR2,
356 p_txn_qty IN NUMBER,
357 p_txn_uom_code IN VARCHAR2,
358 p_secondary_qty IN NUMBER,
359 p_secondary_uom_code IN VARCHAR2) RETURN NUMBER;
360
361 -- Bug 13914863
362 PROCEDURE Validate_DualQuantities(
363 p_api_version IN NUMBER,
364 p_init_msg_list IN VARCHAR2 := L_FND_FALSE,
365 p_commit IN VARCHAR2 := L_FND_FALSE,
366 p_organization_id IN NUMBER,
367 p_inventory_item_id IN NUMBER,
368 p_primary_qty IN NUMBER,
369 p_primary_uom_code IN VARCHAR2,
370 p_secondary_qty IN NUMBER,
371 p_secondary_uom_code IN VARCHAR2,
372 x_return_status OUT NOCOPY VARCHAR2,
373 x_msg_count OUT NOCOPY NUMBER,
374 x_msg_data OUT NOCOPY VARCHAR2);
375
376 END INL_SHIPMENT_PVT;