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 350: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

346: --AND pll.ship_to_location_id =NVL(rsl.ship_to_location_id, pll.ship_to_location_id) -Bug 7677745
347: AND NVL(pl.vendor_product_num, '-999') =NVL(v_vendor_product_num,NVL(pl.vendor_product_num, '-999'));
348:
349: PROCEDURE derive_vendor_rcv_line (
350: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
351: n IN OUT NOCOPY binary_integer,
352: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
353: X_header_record IN rcv_roi_preprocessor.header_rec_type);
354:

Line 352: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

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

Line 353: X_header_record IN rcv_roi_preprocessor.header_rec_type);

349: PROCEDURE derive_vendor_rcv_line (
350: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
351: n IN OUT NOCOPY binary_integer,
352: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
353: X_header_record IN rcv_roi_preprocessor.header_rec_type);
354:
355:
356: PROCEDURE default_vendor_rcv_line (
357: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 357: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

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

Line 360: X_header_record IN rcv_roi_preprocessor.header_rec_type);

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

Line 364: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

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

Line 367: X_header_record IN rcv_roi_preprocessor.header_rec_type);

363: PROCEDURE validate_vendor_rcv_line (
364: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
365: n IN binary_integer,
366: X_asn_type IN rcv_headers_interface.asn_type%type,
367: X_header_record IN rcv_roi_preprocessor.header_rec_type);
368:
369:
370: PROCEDURE derive_ship_to_org_info (
371: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 371: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

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

Line 373: X_header_record IN rcv_roi_preprocessor.header_rec_type);

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

Line 376: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

372: n IN OUT NOCOPY binary_integer,
373: X_header_record IN rcv_roi_preprocessor.header_rec_type);
374:
375: PROCEDURE derive_vendor_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_vendor_site_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_vendor_site_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_po_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_po_header_info (
384: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
385: n IN OUT NOCOPY binary_integer);
386:
387: PROCEDURE derive_asn_header_info (
388: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

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:
387: PROCEDURE derive_asn_header_info (
388: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
389: n IN OUT NOCOPY binary_integer,
390: x_header_record IN rcv_roi_preprocessor.header_rec_type);
391: PROCEDURE derive_item_info (
392: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 390: x_header_record IN rcv_roi_preprocessor.header_rec_type);

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

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: x_header_record IN rcv_roi_preprocessor.header_rec_type);
391: PROCEDURE derive_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_substitute_item_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_substitute_item_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_po_line_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_po_line_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_from_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_from_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_transit_org_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_transit_org_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_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_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_ship_to_location_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_ship_to_location_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_header_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_header_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_routing_step_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_routing_step_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_person_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_person_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_deliver_to_loc_info (
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_deliver_to_loc_info (
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_from_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_from_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 derive_to_locator_id (
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 derive_to_locator_id (
440: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
441: n IN OUT NOCOPY binary_integer);
442:
443: PROCEDURE validate_non_services_fields(
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 OUT NOCOPY binary_integer);
442:
443: PROCEDURE validate_non_services_fields(
444: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
445: n IN BINARY_INTEGER );
446:
447: PROCEDURE default_from_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_from_subloc_info (
448: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
449: n IN binary_integer);
450:
451: PROCEDURE default_to_subloc_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 default_to_subloc_info (
452: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
453: n IN binary_integer);
454:
455: PROCEDURE derive_reason_info (
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 binary_integer);
454:
455: PROCEDURE derive_reason_info (
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_auto_transact_code (
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_auto_transact_code (
460: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
461: n IN OUT NOCOPY binary_integer);
462:
463: PROCEDURE derive_vendor_rcv_line_qty (
464: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 464: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

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

Line 466: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

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

Line 467: X_header_record IN rcv_roi_preprocessor.header_rec_type);

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

Line 470: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

466: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
467: X_header_record IN rcv_roi_preprocessor.header_rec_type);
468:
469: PROCEDURE validate_transaction_date (
470: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
471: n IN binary_integer);
472:
473: PROCEDURE validate_quantity_invoiced (
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_quantity_invoiced (
474: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
475: n IN binary_integer);
476:
477: PROCEDURE validate_transaction_uom (
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_transaction_uom (
478: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
479: n IN binary_integer);
480:
481: PROCEDURE validate_item_info (
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_item_info (
482: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
483: n IN binary_integer);
484:
485: PROCEDURE validate_freight_carrier_code (
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_freight_carrier_code (
486: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
487: n IN binary_integer);
488:
489: PROCEDURE validate_dest_type (
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_dest_type (
490: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
491: n IN binary_integer);
492:
493: PROCEDURE validate_ship_to_loc (
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_ship_to_loc (
494: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
495: n IN binary_integer);
496:
497: PROCEDURE validate_deliver_to_person (
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_deliver_to_person (
498: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
499: n IN binary_integer);
500:
501: PROCEDURE validate_routing_record(
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_routing_record(
502: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
503: n IN binary_integer);
504:
505: PROCEDURE validate_deliver_to_loc (
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_deliver_to_loc (
506: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
507: n IN binary_integer);
508:
509: PROCEDURE validate_subinventory (
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_subinventory (
510: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
511: n IN binary_integer);
512:
513: PROCEDURE validate_locator (
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_locator (
514: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
515: n IN binary_integer);
516:
517: PROCEDURE validate_tax_code (
518: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 518: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

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

Line 524: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

520: /* Bug3454491 (1) */
521: x_asn_type IN rcv_headers_interface.asn_type%TYPE);
522:
523: PROCEDURE validate_country_of_origin (
524: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
525: n IN binary_integer);
526:
527: PROCEDURE validate_asl (
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_asl (
528: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
529: n IN binary_integer);
530:
531: PROCEDURE validate_consigned_inventory (
532: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 532: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

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

Line 538: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

534: /* Bug3454491 (2) */
535: x_asn_type IN rcv_headers_interface.asn_type%TYPE);
536:
537: PROCEDURE validate_shipped_qty (
538: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
539: n IN binary_integer);
540:
541: PROCEDURE validate_ref_integrity (
542: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 542: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

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

Line 544: X_header_record IN rcv_roi_preprocessor.header_rec_type);

540:
541: PROCEDURE validate_ref_integrity (
542: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
543: n IN binary_integer,
544: X_header_record IN rcv_roi_preprocessor.header_rec_type);
545:
546: PROCEDURE exchange_sub_items (
547: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
548: n IN binary_integer);

Line 547: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

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

Line 552: X_header_record IN rcv_roi_preprocessor.header_rec_type);

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

Line 555: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

551: x_ref_integrity_rec IN OUT NOCOPY rcv_shipment_line_sv.ref_integrity_record_type,
552: X_header_record IN rcv_roi_preprocessor.header_rec_type);
553:
554: PROCEDURE validate_inspection_status (
555: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
556: n IN binary_integer);
557:
558: PROCEDURE validate_transaction_type (
559: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 559: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

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

Line 565: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

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

Line 569: v_trans_tab IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

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

Line 571: v_header_record IN rcv_roi_preprocessor.header_rec_type);

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

Line 574: v_trans_tab IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

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

Line 576: v_header_record IN rcv_roi_preprocessor.header_rec_type );

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

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

574: v_trans_tab IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
575: n IN binary_integer,
576: v_header_record IN rcv_roi_preprocessor.header_rec_type );
577:
578: PROCEDURE HANDLE_RCV_ASN_TRANSACTIONS (V_TRANS_TAB IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
579: V_HEADER_RECORD IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type);
580:
581:
582: PROCEDURE derive_vendor_trans_del (

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

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

Line 583: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

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

Line 585: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

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

Line 586: X_header_record IN rcv_roi_preprocessor.header_rec_type);

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

Line 589: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

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

Line 593: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

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

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

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

Line 598: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

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

Line 602: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

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

Line 604: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

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

Line 605: X_header_record IN rcv_roi_preprocessor.header_rec_type);

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

Line 609: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

605: X_header_record IN rcv_roi_preprocessor.header_rec_type);
606:
607:
608: PROCEDURE derive_correction_line_qty (
609: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
610: n IN OUT NOCOPY binary_integer,
611: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type);
612:
613:

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

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

Line 615: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

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

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

613:
614: PROCEDURE derive_correction_line_amt (
615: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
616: n IN OUT NOCOPY binary_integer,
617: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type);
618:
619: PROCEDURE default_vendor_correct (
620: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
621: n IN binary_integer);

Line 620: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

616: n IN OUT NOCOPY binary_integer,
617: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type);
618:
619: PROCEDURE default_vendor_correct (
620: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
621: n IN binary_integer);
622:
623:
624: FUNCTION convert_into_correct_qty(source_qty in number,

Line 632: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

628: RETURN NUMBER;
629:
630:
631: PROCEDURE get_interface_available_qty (
632: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
633: n IN binary_integer,
634: x_interface_qty OUT NOCOPY number);
635:
636:

Line 638: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

634: x_interface_qty OUT NOCOPY number);
635:
636:
637: PROCEDURE get_interface_available_amt(
638: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
639: n IN BINARY_INTEGER,
640: x_interface_amt OUT NOCOPY number);
641:
642: PROCEDURE update_interface_available_qty (

Line 643: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

639: n IN BINARY_INTEGER,
640: x_interface_amt OUT NOCOPY number);
641:
642: PROCEDURE update_interface_available_qty (
643: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
644: n IN binary_integer);
645:
646: PROCEDURE update_interface_available_amt (
647: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 647: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

643: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
644: n IN binary_integer);
645:
646: PROCEDURE update_interface_available_amt (
647: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
648: n IN binary_integer);
649:
650: PROCEDURE update_total_transaction_qty(
651: p_interface_transaction_id IN rcv_transactions_interface.interface_transaction_id%type,

Line 672: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

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

Line 674: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

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

Line 675: x_header_record IN rcv_roi_preprocessor.header_rec_type );

671: PROCEDURE derive_vendor_rcv_line_amt(
672: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
673: n IN OUT NOCOPY BINARY_INTEGER,
674: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
675: x_header_record IN rcv_roi_preprocessor.header_rec_type );
676:
677: PROCEDURE validate_amt_based_rcv_line(
678: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
679: n IN BINARY_INTEGER,

Line 678: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

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

Line 681: x_header_record IN rcv_roi_preprocessor.header_rec_type

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

Line 693: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

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

Line 703: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

699: Function get_deliver_to_person_from_rt()
700: Function get_deliver_to_person_from_rti() */
701:
702: PROCEDURE get_deliver_to_person_from_po(
703: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
704: n IN BINARY_INTEGER
705: );
706:
707: FUNCTION get_deliver_to_person_from_rt(

Line 708: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

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

Line 713: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

709: n IN BINARY_INTEGER
710: ) RETURN NUMBER;
711:
712: FUNCTION get_deliver_to_person_from_rti(
713: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
714: n IN BINARY_INTEGER
715: ) RETURN NUMBER;
716:
717: PROCEDURE validate_lcm_line (

Line 718: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

714: n IN BINARY_INTEGER
715: ) RETURN NUMBER;
716:
717: PROCEDURE validate_lcm_line (
718: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
719: n IN binary_integer,
720: X_asn_type IN rcv_headers_interface.asn_type%type,
721: X_header_record IN rcv_roi_preprocessor.header_rec_type);
722:

Line 721: X_header_record IN rcv_roi_preprocessor.header_rec_type);

717: PROCEDURE validate_lcm_line (
718: X_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
719: n IN binary_integer,
720: X_asn_type IN rcv_headers_interface.asn_type%type,
721: X_header_record IN rcv_roi_preprocessor.header_rec_type);
722:
723: --Bug 7651646
724: PROCEDURE validate_src_txn(
725: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 725: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

721: X_header_record IN rcv_roi_preprocessor.header_rec_type);
722:
723: --Bug 7651646
724: PROCEDURE validate_src_txn(
725: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
726: n IN BINARY_INTEGER);
727:
728: --
729: PROCEDURE get_clm_info( p_validate_type VARCHAR2,

Line 730: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

726: n IN BINARY_INTEGER);
727:
728: --
729: PROCEDURE get_clm_info( p_validate_type VARCHAR2,
730: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
731: n IN BINARY_INTEGER,
732: x_is_clm_po IN OUT NOCOPY VARCHAR2,
733: x_partial_funded_flag IN OUT NOCOPY VARCHAR2);
734:

Line 737: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

733: x_partial_funded_flag IN OUT NOCOPY VARCHAR2);
734:
735: -- Bug 9705269
736: PROCEDURE validate_shipment_source(
737: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
738: n IN BINARY_INTEGER);
739:
740: -- rtv project
741: PROCEDURE validate_parent_rtv

Line 742: ( x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

738: n IN BINARY_INTEGER);
739:
740: -- rtv project
741: PROCEDURE validate_parent_rtv
742: ( x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
743: n IN binary_integer);
744:
745: END RCV_ROI_TRANSACTION;
746: