[Home] [Help]
PACKAGE: APPS.RCV_TRANSACTIONS_INTERFACE_SV1
Source
1 PACKAGE RCV_TRANSACTIONS_INTERFACE_SV1 AS
2 /* $Header: RCVTIS2S.pls 120.0 2005/06/02 00:14:55 appldev noship $*/
3
4
5 /* INVCONV, Punit Kumar, ROI convergence */
6 /* Defining global variables */
7 g_ret_sts_success CONSTANT VARCHAR2(1) := 'S';
8 g_ret_sts_error CONSTANT VARCHAR2(1) := 'E';
9 g_ret_sts_unexp_error CONSTANT VARCHAR2(1) := 'U';
10
11 /*Exception definitions */
12 g_exc_error EXCEPTION;
13 g_exc_unexpected_error EXCEPTION;
14
15 /*INVCONV , Introduced the following record type*/
16 TYPE attributes_record_type IS RECORD (
17 inventory_item_id RCV_TRANSACTIONS_INTERFACE.item_id%Type,
18 transaction_quantity RCV_TRANSACTIONS_INTERFACE.quantity%Type,
19 transaction_unit_of_measure RCV_TRANSACTIONS_INTERFACE.unit_of_measure%Type,
20 secondary_quantity RCV_TRANSACTIONS_INTERFACE.Secondary_quantity%Type,
21 secondary_unit_of_measure RCV_TRANSACTIONS_INTERFACE.Secondary_UNIT_OF_MEASURE%Type,
22 secondary_uom_code RCV_TRANSACTIONS_INTERFACE.secondary_uom_code%TYPE,
23 to_organization_id RCV_TRANSACTIONS_INTERFACE.to_organization_id%Type,
24 error_record RCV_SHIPMENT_OBJECT_SV.ErrorRecType) ;
25
26
27 /*===========================================================================
28 PROCEDURE NAME: validate_quantity_shipped()
29
30 DESCRIPTION:
31
32 PARAMETERS:
33
34 DESIGN REFERENCES:
35
36 ALGORITHM:
37
38 NOTES:
39
40 OPEN ISSUES:
41
42 CLOSED ISSUES:
43
44 CHANGE HISTORY: DFong 09/24/96 Created
45 ===========================================================================*/
46
47 PROCEDURE validate_quantity_shipped
48 (X_quantity_shipped_record IN OUT NOCOPY rcv_shipment_line_sv.quantity_shipped_record_type);
49 /*===========================================================================
50 PROCEDURE NAME: validate_quantity_invoiced()
51
52 DESCRIPTION:
53
54 PARAMETERS:
55
56 DESIGN REFERENCES:
57
58 ALGORITHM:
59
60 NOTES:
61
62 OPEN ISSUES:
63
64 CLOSED ISSUES:
65
66 CHANGE HISTORY: DFong 09/24/96 Created
67 ===========================================================================*/
68
69 PROCEDURE validate_quantity_invoiced
70 (x_quantity_invoiced_record IN OUT NOCOPY rcv_shipment_line_sv.quantity_invoiced_record_type);
71 /*===========================================================================
72 PROCEDURE NAME: validate_uom()
73
74 DESCRIPTION:
75
76 PARAMETERS:
77
78 DESIGN REFERENCES:
79
80 ALGORITHM:
81
82 NOTES:
83
84 OPEN ISSUES:
85
86 CLOSED ISSUES:
87
88 CHANGE HISTORY: DFong 09/24/96 Created
89 ===========================================================================*/
90
91 PROCEDURE validate_uom
92 (x_uom_record IN OUT NOCOPY rcv_shipment_line_sv.quantity_shipped_record_type);
93 /*===========================================================================
94 PROCEDURE NAME: validate_item()
95
96 DESCRIPTION:
97
98 PARAMETERS:
99
100 DESIGN REFERENCES:
101
102 ALGORITHM:
103
104 NOTES:
105
106 OPEN ISSUES:
107
108 CLOSED ISSUES:
109
110 CHANGE HISTORY: DFong 09/24/96 Created
111 ===========================================================================*/
112
113 PROCEDURE validate_item
114 (x_item_id_record IN OUT NOCOPY rcv_shipment_line_sv.item_id_record_type,
115 x_auto_transact_code IN rcv_transactions_interface.auto_transact_code%type);
116 /*===========================================================================
117 PROCEDURE NAME: validate_item_description()
118
119 DESCRIPTION:
120
121 PARAMETERS:
122
123 DESIGN REFERENCES:
124
125 ALGORITHM:
126
127 NOTES:
128
129 OPEN ISSUES:
130
131 CLOSED ISSUES:
132
133 CHANGE HISTORY: DFong 09/24/96 Created
134 ===========================================================================*/
135
136 PROCEDURE validate_item_description
137 (x_item_id_record IN OUT NOCOPY rcv_shipment_line_sv.item_id_record_type);
138 /*===========================================================================
139 PROCEDURE NAME: validate_substitute_item()
140
141 DESCRIPTION:
142
143 PARAMETERS:
144
145 DESIGN REFERENCES:
146
147 ALGORITHM:
148
149 NOTES:
150
151 OPEN ISSUES:
152
153 CLOSED ISSUES:
154
155 CHANGE HISTORY: DFong 09/24/96 Created
156 ===========================================================================*/
157
158 PROCEDURE validate_substitute_item
159 (x_sub_item_id_record IN OUT NOCOPY rcv_shipment_line_sv.sub_item_id_record_type);
160
161 /*===========================================================================
162 PROCEDURE NAME: validate_item_revision()
163
164 DESCRIPTION:
165
166 PARAMETERS:
167
168 DESIGN REFERENCES:
169
170 ALGORITHM:
171
172 NOTES:
173
174 OPEN ISSUES:
175
176 CLOSED ISSUES:
177
178 CHANGE HISTORY: DFong 09/24/96 Created
179 ===========================================================================*/
180
181 PROCEDURE validate_item_revision
182 (x_item_revision_record IN OUT NOCOPY rcv_shipment_line_sv.item_id_record_type);
183 /*===========================================================================
184 PROCEDURE NAME: validate_freight_carrier()
185
186 DESCRIPTION:
187
188 PARAMETERS:
189
190 DESIGN REFERENCES:
191
192 ALGORITHM:
193
194 NOTES:
195
196 OPEN ISSUES:
197
198 CLOSED ISSUES:
199
200 CHANGE HISTORY: DFong 09/24/96 Created
201 ===========================================================================*/
202
203 PROCEDURE validate_freight_carrier
204 (x_freight_carrier_record IN OUT NOCOPY rcv_shipment_line_sv.freight_carrier_record_type);
205 /*===========================================================================
206 PROCEDURE NAME: validate_subinventory()
207
208 DESCRIPTION:
209
210 PARAMETERS:
211
212 DESIGN REFERENCES:
213
214 ALGORITHM:
215
216 NOTES:
217
218 OPEN ISSUES:
219
220 CLOSED ISSUES:
221
222 CHANGE HISTORY: gkellner 03/25/97 Created
223 ===========================================================================*/
224
225 PROCEDURE validate_subinventory
226 (x_subinventory_record IN OUT NOCOPY rcv_shipment_line_sv.subinventory_record_type);
227
228 /*===========================================================================
229 PROCEDURE NAME: validate_po_lookup_code()
230
231 DESCRIPTION:
232
233 PARAMETERS:
234
235 DESIGN REFERENCES:
236
237 ALGORITHM:
238
239 NOTES:
240
241 OPEN ISSUES:
242
243 CLOSED ISSUES:
244
245 CHANGE HISTORY: gkellner 03/25/97 Created
246 ===========================================================================*/
247
248 PROCEDURE validate_po_lookup_code
249 (x_po_lookup_code_record IN OUT NOCOPY
250 rcv_shipment_line_sv.po_lookup_code_record_type);
251
252 /*===========================================================================
253 PROCEDURE NAME: validate_person()
254
255 DESCRIPTION:
256
257 PARAMETERS:
258
259 DESIGN REFERENCES:
260
261 ALGORITHM:
262
263 NOTES:
264
265 OPEN ISSUES:
266
267 CLOSED ISSUES:
268
269 CHANGE HISTORY: gkellner 03/25/97 Created
270 ===========================================================================*/
271
272 PROCEDURE validate_employee
273 (x_employee_record IN OUT NOCOPY rcv_shipment_line_sv.employee_record_type);
274
275 /*===========================================================================
276 PROCEDURE NAME: validate_location()
277
278 DESCRIPTION:
279
280 PARAMETERS:
281
282 DESIGN REFERENCES:
283
284 ALGORITHM:
285
286 NOTES:
287
288 OPEN ISSUES:
289
290 CLOSED ISSUES:
291
292 CHANGE HISTORY: gkellner 03/25/97 Created
293 ===========================================================================*/
294
295 PROCEDURE validate_location
296 (x_location_record IN OUT NOCOPY rcv_shipment_line_sv.location_record_type);
297
298 /*===========================================================================
299 PROCEDURE NAME: validate_locator()
300
301 DESCRIPTION:
302
303 PARAMETERS:
304
305 DESIGN REFERENCES:
306
307 ALGORITHM:
308
309 NOTES:
310
311 OPEN ISSUES:
312
313 CLOSED ISSUES:
314
315 CHANGE HISTORY: gkellner 03/25/97 Created
316 ===========================================================================*/
317
318 PROCEDURE validate_locator
319 (x_locator_record IN OUT NOCOPY rcv_shipment_line_sv.locator_record_type);
320
321 /*===========================================================================
322 PROCEDURE NAME: validate_tax_code()
323
324 DESCRIPTION:
325
326 PARAMETERS:
327
328 DESIGN REFERENCES:
329
330 ALGORITHM:
331
332 NOTES:
333
334 OPEN ISSUES:
335
336 CLOSED ISSUES:
337
338 CHANGE HISTORY: DFong 09/24/96 Created
339 ===========================================================================*/
340
341 PROCEDURE validate_tax_code
342 (x_tax_name_record IN OUT NOCOPY rcv_shipment_line_sv.tax_name_record_type);
343 /*===========================================================================
344 PROCEDURE NAME: validate_asl()
345
346 DESCRIPTION:
347
348 PARAMETERS:
349
350 DESIGN REFERENCES:
351
352 ALGORITHM:
353
354 NOTES:
355
356 OPEN ISSUES:
357
358 CLOSED ISSUES:
359
360 CHANGE HISTORY: DFong 09/24/96 Created
361 ===========================================================================*/
362
363 PROCEDURE validate_asl
364 (x_asl_record IN OUT NOCOPY rcv_shipment_line_sv.ref_integrity_record_type);
365 /*===========================================================================
366 PROCEDURE NAME: validate_cum_quantity_shipped()
367
368 DESCRIPTION:
369
370 PARAMETERS:
371
372 DESIGN REFERENCES:
373
374 ALGORITHM:
375
376 NOTES:
377
378 OPEN ISSUES:
379
380 CLOSED ISSUES:
381
382 CHANGE HISTORY: DFong 09/24/96 Created
383 ===========================================================================*/
384
385 PROCEDURE validate_cum_quantity_shipped
386 (x_cum_quantity_record IN OUT NOCOPY rcv_shipment_line_sv.cum_quantity_record_type);
387 /*===========================================================================
388 PROCEDURE NAME: validate_ref_integ()
389
390 DESCRIPTION:
391
392 PARAMETERS:
393
394 DESIGN REFERENCES:
395
396 ALGORITHM:
397
398 NOTES:
399
400 OPEN ISSUES:
401
402 CLOSED ISSUES:
403
404 CHANGE HISTORY: DFong 09/24/96 Created
405 ===========================================================================*/
406
407 PROCEDURE validate_ref_integ
408 (x_ref_integrity_rec IN OUT NOCOPY rcv_shipment_line_sv.ref_integrity_record_type,
409 V_header_record IN rcv_shipment_header_sv.headerrectype);
410
411 /*===========================================================================
412 PROCEDURE NAME: validate_country_of_origin()
413
414 DESCRIPTION:
415
416 PARAMETERS:
417
418 DESIGN REFERENCES:
419
420 ALGORITHM:
421
422 NOTES:
423
424 OPEN ISSUES:
425
426 CLOSED ISSUES:
427
428 CHANGE HISTORY: FRKHAN 12/18/98 Created
429 ===========================================================================*/
430
431 PROCEDURE validate_country_of_origin
432 (x_country_of_origin_record IN OUT NOCOPY rcv_shipment_line_sv.country_of_origin_record_type);
433
434 /* <Consigned Inventory Pre-Processor FPI START> */
435 /*==================================================================
436
437 PROCEDURE NAME: validate_consigned_po
438
439 DESCRIPTION: Reject ASBN transaction if it's a shipment against
440 Consigned PO by checking CONSIGNED_FLAG in
441 PO_LINE_LOCATIONS
442
443 PARAMETERS: x_consigned_po_rec IN OUT NOCOPY
444 rcv_shipment_line_sv.po_line_location_id_rtype
445
446 DESIGN
447 REFERENCES:
448
449 CHANGE
450 HISTORY: Created 27-SEPTEMBER-02 DXIE
451
452 =======================================================================*/
453 PROCEDURE validate_consigned_po
454 (x_consigned_po_rec IN OUT NOCOPY rcv_shipment_line_sv.po_line_location_id_rtype);
455
456 /*==================================================================
457
458 PROCEDURE NAME: validate_consumption_po
459
460 DESCRIPTION: Reject ASN, ASBN or Receipt transactions against
461 Consumption PO by checking CONSIGNED_CONSUMPTION_FLAG
462 in PO_HEADERS
463
464 PARAMETERS: x_consumption_po_rec IN OUT NOCOPY
465 rcv_shipment_line_sv.document_num_record_type
466
467 DESIGN
468 REFERENCES:
469
470 CHANGE
471 HISTORY: Created 27-SEPTEMBER-02 DXIE
472
473 =======================================================================*/
474 PROCEDURE validate_consumption_po
475 (x_consumption_po_rec IN OUT NOCOPY rcv_shipment_line_sv.document_num_record_type);
476
477 /*==================================================================
478
479 PROCEDURE NAME: validate_consumption_release
480
481 DESCRIPTION: Reject ASN, ASBN or Receipt transactions against
482 Consumption Release by checking CONSIGNED_CONSUMPTION_FLAG
483 in PO_RELEASES
484
485 PARAMETERS: x_consumption_release_rec IN OUT NOCOPY
486 rcv_shipment_line_sv.release_id_record_type
487
488 DESIGN
489 REFERENCES:
490
491 CHANGE
492 HISTORY: Created 27-SEPTEMBER-02 DXIE
493
494 =======================================================================*/
495 PROCEDURE validate_consumption_release
496 (x_consumption_release_rec IN OUT NOCOPY rcv_shipment_line_sv.release_id_record_type);
497 /*<Consigned Inventory Pre-Processor FPI END>*/
498
499 /*===========================================================================
500
501 PROCEDURE
502 VALIDATE_SECONDARY_PARAMETERS
503
504 DESCRIPTION
505
506 For Dual UOM controlled items validate the secondary UOM code and
507 Secondary UOM. Derive them if either/both are not specified.
508 For Receipt if secondary quantity is there then it will validate it
509 (will do the deviation check for it )else it will derive it.
510
511 DESIGN REFERENCES:
512 http://files.oraclecorp.com/content/AllPublic/Workspaces/
513 Inventory%20Convergence-Public/Design/Oracle%20Purchasing/TDD/PO_ROI_TDD.zip
514
515 MODIFICATION HISTORY
516 10-AUG-2004 Punit Kumar Created
517
518 =======================================================================*/
519
520 Procedure VALIDATE_SECONDARY_PARAMETERS(
521 p_api_version IN NUMBER,
522 p_init_msg_lst IN VARCHAR2,
523 x_att_rec IN OUT NOCOPY RCV_TRANSACTIONS_INTERFACE_SV1.attributes_record_type,
524 x_return_status OUT NOCOPY VARCHAR2,
525 x_msg_count OUT NOCOPY NUMBER,
526 x_msg_data OUT NOCOPY VARCHAR2);
527 /*END INVCONV*/
528
529 END RCV_TRANSACTIONS_INTERFACE_SV1;
530