[Home] [Help]
PACKAGE: APPS.RCV_TRANSACTIONS_INTERFACE_SV1
Source
1 PACKAGE RCV_TRANSACTIONS_INTERFACE_SV1 AUTHID CURRENT_USER AS
2 /* $Header: RCVTIS2S.pls 120.1.12020000.2 2012/11/18 03:19:28 liayang ship $*/
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_project_locator()
323
324 DESCRIPTION: This procedure is used to validate project enabled locator for bug 13844195
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: Liang Yang 11/16/12 Created
339 ===========================================================================*/
340
341 PROCEDURE validate_project_locator
342 (x_locator_record IN OUT NOCOPY rcv_shipment_line_sv.locator_record_type);
343
344 /*===========================================================================
345 PROCEDURE NAME: validate_tax_code()
346
347 DESCRIPTION:
348
349 PARAMETERS:
350
351 DESIGN REFERENCES:
352
353 ALGORITHM:
354
355 NOTES:
356
357 OPEN ISSUES:
358
359 CLOSED ISSUES:
360
361 CHANGE HISTORY: DFong 09/24/96 Created
362 ===========================================================================*/
363
364 PROCEDURE validate_tax_code
365 (x_tax_name_record IN OUT NOCOPY rcv_shipment_line_sv.tax_name_record_type);
366 /*===========================================================================
367 PROCEDURE NAME: validate_asl()
368
369 DESCRIPTION:
370
371 PARAMETERS:
372
373 DESIGN REFERENCES:
374
375 ALGORITHM:
376
377 NOTES:
378
379 OPEN ISSUES:
380
381 CLOSED ISSUES:
382
383 CHANGE HISTORY: DFong 09/24/96 Created
384 ===========================================================================*/
385
386 PROCEDURE validate_asl
387 (x_asl_record IN OUT NOCOPY rcv_shipment_line_sv.ref_integrity_record_type);
388 /*===========================================================================
389 PROCEDURE NAME: validate_cum_quantity_shipped()
390
391 DESCRIPTION:
392
393 PARAMETERS:
394
395 DESIGN REFERENCES:
396
397 ALGORITHM:
398
399 NOTES:
400
401 OPEN ISSUES:
402
403 CLOSED ISSUES:
404
405 CHANGE HISTORY: DFong 09/24/96 Created
406 ===========================================================================*/
407
408 PROCEDURE validate_cum_quantity_shipped
409 (x_cum_quantity_record IN OUT NOCOPY rcv_shipment_line_sv.cum_quantity_record_type);
410 /*===========================================================================
411 PROCEDURE NAME: validate_ref_integ()
412
413 DESCRIPTION:
414
415 PARAMETERS:
416
417 DESIGN REFERENCES:
418
419 ALGORITHM:
420
421 NOTES:
422
423 OPEN ISSUES:
424
425 CLOSED ISSUES:
426
427 CHANGE HISTORY: DFong 09/24/96 Created
428 ===========================================================================*/
429
430 PROCEDURE validate_ref_integ
431 (x_ref_integrity_rec IN OUT NOCOPY rcv_shipment_line_sv.ref_integrity_record_type,
432 V_header_record IN rcv_shipment_header_sv.headerrectype);
433
434 /*===========================================================================
435 PROCEDURE NAME: validate_country_of_origin()
436
437 DESCRIPTION:
438
439 PARAMETERS:
440
441 DESIGN REFERENCES:
442
443 ALGORITHM:
444
445 NOTES:
446
447 OPEN ISSUES:
448
449 CLOSED ISSUES:
450
451 CHANGE HISTORY: FRKHAN 12/18/98 Created
452 ===========================================================================*/
453
454 PROCEDURE validate_country_of_origin
455 (x_country_of_origin_record IN OUT NOCOPY rcv_shipment_line_sv.country_of_origin_record_type);
456
457 /* <Consigned Inventory Pre-Processor FPI START> */
458 /*==================================================================
459
460 PROCEDURE NAME: validate_consigned_po
461
462 DESCRIPTION: Reject ASBN transaction if it's a shipment against
463 Consigned PO by checking CONSIGNED_FLAG in
464 PO_LINE_LOCATIONS
465
466 PARAMETERS: x_consigned_po_rec IN OUT NOCOPY
467 rcv_shipment_line_sv.po_line_location_id_rtype
468
469 DESIGN
470 REFERENCES:
471
472 CHANGE
473 HISTORY: Created 27-SEPTEMBER-02 DXIE
474
475 =======================================================================*/
476 PROCEDURE validate_consigned_po
477 (x_consigned_po_rec IN OUT NOCOPY rcv_shipment_line_sv.po_line_location_id_rtype);
478
479 /*==================================================================
480
481 PROCEDURE NAME: validate_consumption_po
482
483 DESCRIPTION: Reject ASN, ASBN or Receipt transactions against
484 Consumption PO by checking CONSIGNED_CONSUMPTION_FLAG
485 in PO_HEADERS
486
487 PARAMETERS: x_consumption_po_rec IN OUT NOCOPY
488 rcv_shipment_line_sv.document_num_record_type
489
490 DESIGN
491 REFERENCES:
492
493 CHANGE
494 HISTORY: Created 27-SEPTEMBER-02 DXIE
495
496 =======================================================================*/
497 PROCEDURE validate_consumption_po
498 (x_consumption_po_rec IN OUT NOCOPY rcv_shipment_line_sv.document_num_record_type);
499
500 /*==================================================================
501
502 PROCEDURE NAME: validate_consumption_release
503
504 DESCRIPTION: Reject ASN, ASBN or Receipt transactions against
505 Consumption Release by checking CONSIGNED_CONSUMPTION_FLAG
506 in PO_RELEASES
507
508 PARAMETERS: x_consumption_release_rec IN OUT NOCOPY
509 rcv_shipment_line_sv.release_id_record_type
510
511 DESIGN
512 REFERENCES:
513
514 CHANGE
515 HISTORY: Created 27-SEPTEMBER-02 DXIE
516
517 =======================================================================*/
518 PROCEDURE validate_consumption_release
519 (x_consumption_release_rec IN OUT NOCOPY rcv_shipment_line_sv.release_id_record_type);
520 /*<Consigned Inventory Pre-Processor FPI END>*/
521
522 /*===========================================================================
523
524 PROCEDURE
525 VALIDATE_SECONDARY_PARAMETERS
526
527 DESCRIPTION
528
529 For Dual UOM controlled items validate the secondary UOM code and
530 Secondary UOM. Derive them if either/both are not specified.
531 For Receipt if secondary quantity is there then it will validate it
532 (will do the deviation check for it )else it will derive it.
533
534 DESIGN REFERENCES:
535 http://files.oraclecorp.com/content/AllPublic/Workspaces/
536 Inventory%20Convergence-Public/Design/Oracle%20Purchasing/TDD/PO_ROI_TDD.zip
537
538 MODIFICATION HISTORY
539 10-AUG-2004 Punit Kumar Created
540
541 =======================================================================*/
542
543 Procedure VALIDATE_SECONDARY_PARAMETERS(
544 p_api_version IN NUMBER,
545 p_init_msg_lst IN VARCHAR2,
546 x_att_rec IN OUT NOCOPY RCV_TRANSACTIONS_INTERFACE_SV1.attributes_record_type,
547 x_return_status OUT NOCOPY VARCHAR2,
548 x_msg_count OUT NOCOPY NUMBER,
549 x_msg_data OUT NOCOPY VARCHAR2,
550 p_transaction_id IN NUMBER); /*BUG#10380635 */
551 /*END INVCONV*/
552
553 END RCV_TRANSACTIONS_INTERFACE_SV1;
554
555
556