eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.RCV_ROI_TRANSACTION dependencies on RCV_ROI_PREPROCESSOR

Line 346: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

342: AND pll.ship_to_location_id =NVL(rsl.ship_to_location_id, pll.ship_to_location_id)
343: AND NVL(pl.vendor_product_num, '-999') =NVL(v_vendor_product_num,NVL(pl.vendor_product_num, '-999'));
344:
345: PROCEDURE derive_vendor_rcv_line (
346: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
347: n IN OUT NOCOPY binary_integer,
348: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
349: X_header_record IN rcv_roi_preprocessor.header_rec_type);
350:

Line 348: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

344:
345: PROCEDURE derive_vendor_rcv_line (
346: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
347: n IN OUT NOCOPY binary_integer,
348: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
349: X_header_record IN rcv_roi_preprocessor.header_rec_type);
350:
351:
352: PROCEDURE default_vendor_rcv_line (

Line 349: X_header_record IN rcv_roi_preprocessor.header_rec_type);

345: PROCEDURE derive_vendor_rcv_line (
346: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
347: n IN OUT NOCOPY binary_integer,
348: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
349: X_header_record IN rcv_roi_preprocessor.header_rec_type);
350:
351:
352: PROCEDURE default_vendor_rcv_line (
353: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 353: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

349: X_header_record IN rcv_roi_preprocessor.header_rec_type);
350:
351:
352: PROCEDURE default_vendor_rcv_line (
353: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
354: n IN binary_integer,
355: X_header_id IN rcv_headers_interface.header_interface_id%type,
356: X_header_record IN rcv_roi_preprocessor.header_rec_type);
357:

Line 356: X_header_record IN rcv_roi_preprocessor.header_rec_type);

352: PROCEDURE default_vendor_rcv_line (
353: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
354: n IN binary_integer,
355: X_header_id IN rcv_headers_interface.header_interface_id%type,
356: X_header_record IN rcv_roi_preprocessor.header_rec_type);
357:
358:
359: PROCEDURE validate_vendor_rcv_line (
360: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 360: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

356: X_header_record IN rcv_roi_preprocessor.header_rec_type);
357:
358:
359: PROCEDURE validate_vendor_rcv_line (
360: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
361: n IN binary_integer,
362: X_asn_type IN rcv_headers_interface.asn_type%type,
363: X_header_record IN rcv_roi_preprocessor.header_rec_type);
364:

Line 363: X_header_record IN rcv_roi_preprocessor.header_rec_type);

359: PROCEDURE validate_vendor_rcv_line (
360: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
361: n IN binary_integer,
362: X_asn_type IN rcv_headers_interface.asn_type%type,
363: X_header_record IN rcv_roi_preprocessor.header_rec_type);
364:
365:
366: PROCEDURE derive_ship_to_org_info (
367: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 367: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

363: X_header_record IN rcv_roi_preprocessor.header_rec_type);
364:
365:
366: PROCEDURE derive_ship_to_org_info (
367: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
368: n IN OUT NOCOPY binary_integer,
369: X_header_record IN rcv_roi_preprocessor.header_rec_type);
370:
371: PROCEDURE derive_vendor_info (

Line 369: X_header_record IN rcv_roi_preprocessor.header_rec_type);

365:
366: PROCEDURE derive_ship_to_org_info (
367: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
368: n IN OUT NOCOPY binary_integer,
369: X_header_record IN rcv_roi_preprocessor.header_rec_type);
370:
371: PROCEDURE derive_vendor_info (
372: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
373: n IN OUT NOCOPY binary_integer);

Line 372: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

368: n IN OUT NOCOPY binary_integer,
369: X_header_record IN rcv_roi_preprocessor.header_rec_type);
370:
371: PROCEDURE derive_vendor_info (
372: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
373: n IN OUT NOCOPY binary_integer);
374:
375: PROCEDURE derive_vendor_site_info (
376: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 376: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

372: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
373: n IN OUT NOCOPY binary_integer);
374:
375: PROCEDURE derive_vendor_site_info (
376: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
377: n IN OUT NOCOPY binary_integer);
378:
379: PROCEDURE derive_po_header_info (
380: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 380: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

376: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
377: n IN OUT NOCOPY binary_integer);
378:
379: PROCEDURE derive_po_header_info (
380: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
381: n IN OUT NOCOPY binary_integer);
382:
383: PROCEDURE derive_asn_header_info (
384: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 384: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

380: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
381: n IN OUT NOCOPY binary_integer);
382:
383: PROCEDURE derive_asn_header_info (
384: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
385: n IN OUT NOCOPY binary_integer,
386: x_header_record IN rcv_roi_preprocessor.header_rec_type);
387: PROCEDURE derive_item_info (
388: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 386: x_header_record IN rcv_roi_preprocessor.header_rec_type);

382:
383: PROCEDURE derive_asn_header_info (
384: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
385: n IN OUT NOCOPY binary_integer,
386: x_header_record IN rcv_roi_preprocessor.header_rec_type);
387: PROCEDURE derive_item_info (
388: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
389: n IN OUT NOCOPY binary_integer);
390:

Line 388: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

384: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
385: n IN OUT NOCOPY binary_integer,
386: x_header_record IN rcv_roi_preprocessor.header_rec_type);
387: PROCEDURE derive_item_info (
388: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
389: n IN OUT NOCOPY binary_integer);
390:
391: PROCEDURE derive_substitute_item_info (
392: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 392: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

388: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
389: n IN OUT NOCOPY binary_integer);
390:
391: PROCEDURE derive_substitute_item_info (
392: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
393: n IN OUT NOCOPY binary_integer);
394:
395: PROCEDURE derive_po_line_info (
396: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 396: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

392: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
393: n IN OUT NOCOPY binary_integer);
394:
395: PROCEDURE derive_po_line_info (
396: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
397: n IN OUT NOCOPY binary_integer);
398:
399: PROCEDURE derive_from_org_info (
400: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 400: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

396: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
397: n IN OUT NOCOPY binary_integer);
398:
399: PROCEDURE derive_from_org_info (
400: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
401: n IN OUT NOCOPY binary_integer);
402:
403: PROCEDURE derive_transit_org_info (
404: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 404: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

400: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
401: n IN OUT NOCOPY binary_integer);
402:
403: PROCEDURE derive_transit_org_info (
404: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
405: n IN OUT NOCOPY binary_integer);
406:
407: PROCEDURE derive_location_info (
408: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 408: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

404: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
405: n IN OUT NOCOPY binary_integer);
406:
407: PROCEDURE derive_location_info (
408: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
409: n IN OUT NOCOPY binary_integer);
410:
411: PROCEDURE derive_ship_to_location_info (
412: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 412: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

408: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
409: n IN OUT NOCOPY binary_integer);
410:
411: PROCEDURE derive_ship_to_location_info (
412: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
413: n IN OUT NOCOPY binary_integer);
414:
415: PROCEDURE derive_routing_header_info (
416: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 416: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

412: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
413: n IN OUT NOCOPY binary_integer);
414:
415: PROCEDURE derive_routing_header_info (
416: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
417: n IN OUT NOCOPY binary_integer);
418:
419: PROCEDURE derive_routing_step_info (
420: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 420: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

416: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
417: n IN OUT NOCOPY binary_integer);
418:
419: PROCEDURE derive_routing_step_info (
420: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
421: n IN OUT NOCOPY binary_integer);
422:
423: PROCEDURE derive_deliver_to_person_info (
424: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 424: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

420: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
421: n IN OUT NOCOPY binary_integer);
422:
423: PROCEDURE derive_deliver_to_person_info (
424: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
425: n IN OUT NOCOPY binary_integer);
426:
427: PROCEDURE derive_deliver_to_loc_info (
428: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 428: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

424: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
425: n IN OUT NOCOPY binary_integer);
426:
427: PROCEDURE derive_deliver_to_loc_info (
428: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
429: n IN OUT NOCOPY binary_integer);
430:
431: PROCEDURE derive_from_locator_id (
432: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 432: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

428: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
429: n IN OUT NOCOPY binary_integer);
430:
431: PROCEDURE derive_from_locator_id (
432: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
433: n IN OUT NOCOPY binary_integer);
434:
435: PROCEDURE derive_to_locator_id (
436: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 436: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

432: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
433: n IN OUT NOCOPY binary_integer);
434:
435: PROCEDURE derive_to_locator_id (
436: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
437: n IN OUT NOCOPY binary_integer);
438:
439: PROCEDURE validate_non_services_fields(
440: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 440: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

436: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
437: n IN OUT NOCOPY binary_integer);
438:
439: PROCEDURE validate_non_services_fields(
440: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
441: n IN BINARY_INTEGER );
442:
443: PROCEDURE default_from_subloc_info (
444: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 444: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

440: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
441: n IN BINARY_INTEGER );
442:
443: PROCEDURE default_from_subloc_info (
444: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
445: n IN binary_integer);
446:
447: PROCEDURE default_to_subloc_info (
448: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 448: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

444: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
445: n IN binary_integer);
446:
447: PROCEDURE default_to_subloc_info (
448: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
449: n IN binary_integer);
450:
451: PROCEDURE derive_reason_info (
452: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 452: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

448: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
449: n IN binary_integer);
450:
451: PROCEDURE derive_reason_info (
452: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
453: n IN OUT NOCOPY binary_integer);
454:
455: PROCEDURE derive_auto_transact_code (
456: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 456: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

452: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
453: n IN OUT NOCOPY binary_integer);
454:
455: PROCEDURE derive_auto_transact_code (
456: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
457: n IN OUT NOCOPY binary_integer);
458:
459: PROCEDURE derive_vendor_rcv_line_qty (
460: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 460: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

456: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
457: n IN OUT NOCOPY binary_integer);
458:
459: PROCEDURE derive_vendor_rcv_line_qty (
460: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
461: n IN OUT NOCOPY binary_integer,
462: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
463: X_header_record IN rcv_roi_preprocessor.header_rec_type);
464:

Line 462: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

458:
459: PROCEDURE derive_vendor_rcv_line_qty (
460: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
461: n IN OUT NOCOPY binary_integer,
462: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
463: X_header_record IN rcv_roi_preprocessor.header_rec_type);
464:
465: PROCEDURE validate_transaction_date (
466: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 463: X_header_record IN rcv_roi_preprocessor.header_rec_type);

459: PROCEDURE derive_vendor_rcv_line_qty (
460: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
461: n IN OUT NOCOPY binary_integer,
462: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
463: X_header_record IN rcv_roi_preprocessor.header_rec_type);
464:
465: PROCEDURE validate_transaction_date (
466: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
467: n IN binary_integer);

Line 466: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

462: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
463: X_header_record IN rcv_roi_preprocessor.header_rec_type);
464:
465: PROCEDURE validate_transaction_date (
466: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
467: n IN binary_integer);
468:
469: PROCEDURE validate_quantity_invoiced (
470: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 470: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

466: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
467: n IN binary_integer);
468:
469: PROCEDURE validate_quantity_invoiced (
470: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
471: n IN binary_integer);
472:
473: PROCEDURE validate_transaction_uom (
474: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 474: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

470: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
471: n IN binary_integer);
472:
473: PROCEDURE validate_transaction_uom (
474: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
475: n IN binary_integer);
476:
477: PROCEDURE validate_item_info (
478: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 478: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

474: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
475: n IN binary_integer);
476:
477: PROCEDURE validate_item_info (
478: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
479: n IN binary_integer);
480:
481: PROCEDURE validate_freight_carrier_code (
482: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 482: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

478: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
479: n IN binary_integer);
480:
481: PROCEDURE validate_freight_carrier_code (
482: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
483: n IN binary_integer);
484:
485: PROCEDURE validate_dest_type (
486: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 486: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

482: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
483: n IN binary_integer);
484:
485: PROCEDURE validate_dest_type (
486: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
487: n IN binary_integer);
488:
489: PROCEDURE validate_ship_to_loc (
490: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 490: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

486: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
487: n IN binary_integer);
488:
489: PROCEDURE validate_ship_to_loc (
490: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
491: n IN binary_integer);
492:
493: PROCEDURE validate_deliver_to_person (
494: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 494: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

490: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
491: n IN binary_integer);
492:
493: PROCEDURE validate_deliver_to_person (
494: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
495: n IN binary_integer);
496:
497: PROCEDURE validate_routing_record(
498: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 498: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

494: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
495: n IN binary_integer);
496:
497: PROCEDURE validate_routing_record(
498: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
499: n IN binary_integer);
500:
501: PROCEDURE validate_deliver_to_loc (
502: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 502: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

498: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
499: n IN binary_integer);
500:
501: PROCEDURE validate_deliver_to_loc (
502: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
503: n IN binary_integer);
504:
505: PROCEDURE validate_subinventory (
506: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 506: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

502: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
503: n IN binary_integer);
504:
505: PROCEDURE validate_subinventory (
506: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
507: n IN binary_integer);
508:
509: PROCEDURE validate_locator (
510: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 510: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

506: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
507: n IN binary_integer);
508:
509: PROCEDURE validate_locator (
510: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
511: n IN binary_integer);
512:
513: PROCEDURE validate_tax_code (
514: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 514: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

510: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
511: n IN binary_integer);
512:
513: PROCEDURE validate_tax_code (
514: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
515: n IN binary_integer,
516: /* Bug3454491 (1) */
517: x_asn_type IN rcv_headers_interface.asn_type%TYPE);
518:

Line 520: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

516: /* Bug3454491 (1) */
517: x_asn_type IN rcv_headers_interface.asn_type%TYPE);
518:
519: PROCEDURE validate_country_of_origin (
520: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
521: n IN binary_integer);
522:
523: PROCEDURE validate_asl (
524: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 524: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

520: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
521: n IN binary_integer);
522:
523: PROCEDURE validate_asl (
524: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
525: n IN binary_integer);
526:
527: PROCEDURE validate_consigned_inventory (
528: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 528: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

524: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
525: n IN binary_integer);
526:
527: PROCEDURE validate_consigned_inventory (
528: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
529: n IN binary_integer,
530: /* Bug3454491 (2) */
531: x_asn_type IN rcv_headers_interface.asn_type%TYPE);
532:

Line 534: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

530: /* Bug3454491 (2) */
531: x_asn_type IN rcv_headers_interface.asn_type%TYPE);
532:
533: PROCEDURE validate_shipped_qty (
534: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
535: n IN binary_integer);
536:
537: PROCEDURE validate_ref_integrity (
538: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 538: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

534: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
535: n IN binary_integer);
536:
537: PROCEDURE validate_ref_integrity (
538: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
539: n IN binary_integer,
540: X_header_record IN rcv_roi_preprocessor.header_rec_type);
541:
542: PROCEDURE exchange_sub_items (

Line 540: X_header_record IN rcv_roi_preprocessor.header_rec_type);

536:
537: PROCEDURE validate_ref_integrity (
538: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
539: n IN binary_integer,
540: X_header_record IN rcv_roi_preprocessor.header_rec_type);
541:
542: PROCEDURE exchange_sub_items (
543: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
544: n IN binary_integer);

Line 543: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

539: n IN binary_integer,
540: X_header_record IN rcv_roi_preprocessor.header_rec_type);
541:
542: PROCEDURE exchange_sub_items (
543: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
544: n IN binary_integer);
545:
546: PROCEDURE validate_ref_integ (
547: x_ref_integrity_rec IN OUT NOCOPY rcv_shipment_line_sv.ref_integrity_record_type,

Line 548: X_header_record IN rcv_roi_preprocessor.header_rec_type);

544: n IN binary_integer);
545:
546: PROCEDURE validate_ref_integ (
547: x_ref_integrity_rec IN OUT NOCOPY rcv_shipment_line_sv.ref_integrity_record_type,
548: X_header_record IN rcv_roi_preprocessor.header_rec_type);
549:
550: PROCEDURE validate_inspection_status (
551: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
552: n IN binary_integer);

Line 551: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

547: x_ref_integrity_rec IN OUT NOCOPY rcv_shipment_line_sv.ref_integrity_record_type,
548: X_header_record IN rcv_roi_preprocessor.header_rec_type);
549:
550: PROCEDURE validate_inspection_status (
551: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
552: n IN binary_integer);
553:
554: PROCEDURE validate_transaction_type (
555: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 555: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

551: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
552: n IN binary_integer);
553:
554: PROCEDURE validate_transaction_type (
555: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
556: n IN binary_integer);
557:
558: /** OPM change Bug# 3061052**/
559: -- added validate_opm_attributes to validate OPM specific columns.

Line 561: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

557:
558: /** OPM change Bug# 3061052**/
559: -- added validate_opm_attributes to validate OPM specific columns.
560: PROCEDURE validate_opm_attributes(
561: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
562: n IN BINARY_INTEGER ) ;
563:
564: PROCEDURE validate_temp_labor_info(
565: v_trans_tab IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 565: v_trans_tab IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

561: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
562: n IN BINARY_INTEGER ) ;
563:
564: PROCEDURE validate_temp_labor_info(
565: v_trans_tab IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
566: n IN binary_integer,
567: v_header_record IN rcv_roi_preprocessor.header_rec_type);
568:
569: PROCEDURE validate_amount(

Line 567: v_header_record IN rcv_roi_preprocessor.header_rec_type);

563:
564: PROCEDURE validate_temp_labor_info(
565: v_trans_tab IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
566: n IN binary_integer,
567: v_header_record IN rcv_roi_preprocessor.header_rec_type);
568:
569: PROCEDURE validate_amount(
570: v_trans_tab IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
571: n IN binary_integer,

Line 570: v_trans_tab IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

566: n IN binary_integer,
567: v_header_record IN rcv_roi_preprocessor.header_rec_type);
568:
569: PROCEDURE validate_amount(
570: v_trans_tab IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
571: n IN binary_integer,
572: v_header_record IN rcv_roi_preprocessor.header_rec_type );
573:
574: PROCEDURE HANDLE_RCV_ASN_TRANSACTIONS (V_TRANS_TAB IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 572: v_header_record IN rcv_roi_preprocessor.header_rec_type );

568:
569: PROCEDURE validate_amount(
570: v_trans_tab IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
571: n IN binary_integer,
572: v_header_record IN rcv_roi_preprocessor.header_rec_type );
573:
574: PROCEDURE HANDLE_RCV_ASN_TRANSACTIONS (V_TRANS_TAB IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
575: V_HEADER_RECORD IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type);
576:

Line 574: PROCEDURE HANDLE_RCV_ASN_TRANSACTIONS (V_TRANS_TAB IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

570: v_trans_tab IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
571: n IN binary_integer,
572: v_header_record IN rcv_roi_preprocessor.header_rec_type );
573:
574: PROCEDURE HANDLE_RCV_ASN_TRANSACTIONS (V_TRANS_TAB IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
575: V_HEADER_RECORD IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type);
576:
577:
578: PROCEDURE derive_vendor_trans_del (

Line 575: V_HEADER_RECORD IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type);

571: n IN binary_integer,
572: v_header_record IN rcv_roi_preprocessor.header_rec_type );
573:
574: PROCEDURE HANDLE_RCV_ASN_TRANSACTIONS (V_TRANS_TAB IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
575: V_HEADER_RECORD IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type);
576:
577:
578: PROCEDURE derive_vendor_trans_del (
579: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 579: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

575: V_HEADER_RECORD IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type);
576:
577:
578: PROCEDURE derive_vendor_trans_del (
579: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
580: n IN OUT NOCOPY binary_integer,
581: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
582: X_header_record IN rcv_roi_preprocessor.header_rec_type);
583:

Line 581: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

577:
578: PROCEDURE derive_vendor_trans_del (
579: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
580: n IN OUT NOCOPY binary_integer,
581: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
582: X_header_record IN rcv_roi_preprocessor.header_rec_type);
583:
584: Procedure derive_parent_id(
585: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 582: X_header_record IN rcv_roi_preprocessor.header_rec_type);

578: PROCEDURE derive_vendor_trans_del (
579: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
580: n IN OUT NOCOPY binary_integer,
581: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
582: X_header_record IN rcv_roi_preprocessor.header_rec_type);
583:
584: Procedure derive_parent_id(
585: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
586: n IN OUT NOCOPY binary_integer );

Line 585: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

581: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
582: X_header_record IN rcv_roi_preprocessor.header_rec_type);
583:
584: Procedure derive_parent_id(
585: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
586: n IN OUT NOCOPY binary_integer );
587:
588: PROCEDURE derive_trans_del_line_quantity (
589: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 589: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

585: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
586: n IN OUT NOCOPY binary_integer );
587:
588: PROCEDURE derive_trans_del_line_quantity (
589: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
590: n IN OUT NOCOPY binary_integer,
591: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type);
592:
593: PROCEDURE default_vendor_trans_del (

Line 591: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type);

587:
588: PROCEDURE derive_trans_del_line_quantity (
589: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
590: n IN OUT NOCOPY binary_integer,
591: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type);
592:
593: PROCEDURE default_vendor_trans_del (
594: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
595: n IN binary_integer);

Line 594: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

590: n IN OUT NOCOPY binary_integer,
591: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type);
592:
593: PROCEDURE default_vendor_trans_del (
594: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
595: n IN binary_integer);
596:
597: PROCEDURE derive_correction_line (
598: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 598: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

594: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
595: n IN binary_integer);
596:
597: PROCEDURE derive_correction_line (
598: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
599: n IN OUT NOCOPY binary_integer,
600: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
601: X_header_record IN rcv_roi_preprocessor.header_rec_type);
602:

Line 600: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

596:
597: PROCEDURE derive_correction_line (
598: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
599: n IN OUT NOCOPY binary_integer,
600: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
601: X_header_record IN rcv_roi_preprocessor.header_rec_type);
602:
603:
604: PROCEDURE derive_correction_line_qty (

Line 601: X_header_record IN rcv_roi_preprocessor.header_rec_type);

597: PROCEDURE derive_correction_line (
598: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
599: n IN OUT NOCOPY binary_integer,
600: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
601: X_header_record IN rcv_roi_preprocessor.header_rec_type);
602:
603:
604: PROCEDURE derive_correction_line_qty (
605: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 605: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

601: X_header_record IN rcv_roi_preprocessor.header_rec_type);
602:
603:
604: PROCEDURE derive_correction_line_qty (
605: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
606: n IN OUT NOCOPY binary_integer,
607: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type);
608:
609:

Line 607: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type);

603:
604: PROCEDURE derive_correction_line_qty (
605: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
606: n IN OUT NOCOPY binary_integer,
607: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type);
608:
609:
610: PROCEDURE derive_correction_line_amt (
611: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 611: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

607: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type);
608:
609:
610: PROCEDURE derive_correction_line_amt (
611: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
612: n IN OUT NOCOPY binary_integer,
613: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type);
614:
615: PROCEDURE default_vendor_correct (

Line 613: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type);

609:
610: PROCEDURE derive_correction_line_amt (
611: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
612: n IN OUT NOCOPY binary_integer,
613: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type);
614:
615: PROCEDURE default_vendor_correct (
616: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
617: n IN binary_integer);

Line 616: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

612: n IN OUT NOCOPY binary_integer,
613: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type);
614:
615: PROCEDURE default_vendor_correct (
616: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
617: n IN binary_integer);
618:
619:
620: FUNCTION convert_into_correct_qty(source_qty in number,

Line 628: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

624: RETURN NUMBER;
625:
626:
627: PROCEDURE get_interface_available_qty (
628: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
629: n IN binary_integer,
630: x_interface_qty OUT NOCOPY number);
631:
632:

Line 634: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

630: x_interface_qty OUT NOCOPY number);
631:
632:
633: PROCEDURE get_interface_available_amt(
634: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
635: n IN BINARY_INTEGER,
636: x_interface_amt OUT NOCOPY number);
637:
638: PROCEDURE update_interface_available_qty (

Line 639: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

635: n IN BINARY_INTEGER,
636: x_interface_amt OUT NOCOPY number);
637:
638: PROCEDURE update_interface_available_qty (
639: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
640: n IN binary_integer);
641:
642: PROCEDURE update_interface_available_amt (
643: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 643: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

639: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
640: n IN binary_integer);
641:
642: PROCEDURE update_interface_available_amt (
643: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
644: n IN binary_integer);
645:
646: PROCEDURE update_total_transaction_qty(
647: p_interface_transaction_id IN rcv_transactions_interface.interface_transaction_id%type,

Line 668: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

664: );
665:
666:
667: PROCEDURE derive_vendor_rcv_line_amt(
668: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
669: n IN OUT NOCOPY BINARY_INTEGER,
670: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
671: x_header_record IN rcv_roi_preprocessor.header_rec_type );
672:

Line 670: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

666:
667: PROCEDURE derive_vendor_rcv_line_amt(
668: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
669: n IN OUT NOCOPY BINARY_INTEGER,
670: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
671: x_header_record IN rcv_roi_preprocessor.header_rec_type );
672:
673: PROCEDURE validate_amt_based_rcv_line(
674: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 671: x_header_record IN rcv_roi_preprocessor.header_rec_type );

667: PROCEDURE derive_vendor_rcv_line_amt(
668: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
669: n IN OUT NOCOPY BINARY_INTEGER,
670: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
671: x_header_record IN rcv_roi_preprocessor.header_rec_type );
672:
673: PROCEDURE validate_amt_based_rcv_line(
674: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
675: n IN BINARY_INTEGER,

Line 674: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

670: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
671: x_header_record IN rcv_roi_preprocessor.header_rec_type );
672:
673: PROCEDURE validate_amt_based_rcv_line(
674: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
675: n IN BINARY_INTEGER,
676: x_asn_type IN rcv_headers_interface.asn_type%TYPE,
677: x_header_record IN rcv_roi_preprocessor.header_rec_type
678: );

Line 677: x_header_record IN rcv_roi_preprocessor.header_rec_type

673: PROCEDURE validate_amt_based_rcv_line(
674: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
675: n IN BINARY_INTEGER,
676: x_asn_type IN rcv_headers_interface.asn_type%TYPE,
677: x_header_record IN rcv_roi_preprocessor.header_rec_type
678: );
679:
680:
681: /* Complex work.

Line 689: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

685: * po_line_locations and hence moved it from
686: * derive_po_line_info.
687: */
688: PROCEDURE derive_matching_basis(
689: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
690: n IN BINARY_INTEGER
691: );
692:
693: /* The following procedure and functions are added as part of Bug#6375015 fix.

Line 699: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

695: Function get_deliver_to_person_from_rt()
696: Function get_deliver_to_person_from_rti() */
697:
698: PROCEDURE get_deliver_to_person_from_po(
699: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
700: n IN BINARY_INTEGER
701: );
702:
703: FUNCTION get_deliver_to_person_from_rt(

Line 704: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

700: n IN BINARY_INTEGER
701: );
702:
703: FUNCTION get_deliver_to_person_from_rt(
704: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
705: n IN BINARY_INTEGER
706: ) RETURN NUMBER;
707:
708: FUNCTION get_deliver_to_person_from_rti(

Line 709: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

705: n IN BINARY_INTEGER
706: ) RETURN NUMBER;
707:
708: FUNCTION get_deliver_to_person_from_rti(
709: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
710: n IN BINARY_INTEGER
711: ) RETURN NUMBER;
712:
713: PROCEDURE validate_lcm_line (

Line 714: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

710: n IN BINARY_INTEGER
711: ) RETURN NUMBER;
712:
713: PROCEDURE validate_lcm_line (
714: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
715: n IN binary_integer,
716: X_asn_type IN rcv_headers_interface.asn_type%type,
717: X_header_record IN rcv_roi_preprocessor.header_rec_type);
718:

Line 717: X_header_record IN rcv_roi_preprocessor.header_rec_type);

713: PROCEDURE validate_lcm_line (
714: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
715: n IN binary_integer,
716: X_asn_type IN rcv_headers_interface.asn_type%type,
717: X_header_record IN rcv_roi_preprocessor.header_rec_type);
718:
719: END RCV_ROI_TRANSACTION;
720: