APPS.WMS_WORKFLOW_WRAPPERS dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 533: FROM wms_license_plate_numbers

529: IF p_content_lpn_status IS NULL THEN
530: BEGIN
531: SELECT status_id
532: INTO l_content_lpn_status
533: FROM wms_license_plate_numbers
534: WHERE lpn_id = l_content_lpn_id
535: AND organization_id = p_source_organization_id;
536: EXCEPTION
537: WHEN OTHERS THEN

Line 562: FROM wms_license_plate_numbers

558: BEGIN
559: SELECT license_plate_number, parent_lpn_id, outermost_lpn_id, status_id
560: INTO l_lpn_n, l_source_parent_lpn_id, l_source_outermost_lpn_id,
561: l_lpn_status
562: FROM wms_license_plate_numbers
563: WHERE lpn_id = l_lpn_id
564: AND organization_id = p_source_organization_id;
565: EXCEPTION
566: WHEN OTHERS THEN

Line 593: FROM wms_license_plate_numbers

589: IF l_source_parent_lpn_id IS NOT NULL THEN
590: IF p_source_parent_lpn_status IS NULL THEN
591: SELECT status_id
592: INTO l_source_parent_lpn_status
593: FROM wms_license_plate_numbers
594: WHERE lpn_id = l_source_parent_lpn_id
595: AND organization_id = p_source_organization_id;
596: ELSE
597: l_source_parent_lpn_status := p_source_parent_lpn_status;

Line 607: FROM wms_license_plate_numbers

603: IF l_source_outermost_lpn_id IS NOT NULL THEN
604: IF p_source_outermost_lpn_status IS NULL THEN
605: SELECT status_id
606: INTO l_source_outermost_lpn_status
607: FROM wms_license_plate_numbers
608: WHERE lpn_id = l_source_outermost_lpn_id
609: AND organization_id = p_source_organization_id;
610: ELSE
611: l_source_outermost_lpn_id := p_source_outermost_lpn_id;

Line 629: FROM wms_license_plate_numbers

625: IF l_dest_lpn_id IS NOT NULL THEN
626: SELECT parent_lpn_id, outermost_lpn_id, status_id
627: INTO l_dest_parent_lpn_id, l_dest_outermost_lpn_id,
628: l_dest_lpn_status
629: FROM wms_license_plate_numbers
630: WHERE lpn_id = l_dest_lpn_id
631: AND organization_id = p_source_organization_id;
632: END IF;
633:

Line 652: FROM wms_license_plate_numbers

648: IF l_dest_parent_lpn_id IS NOT NULL THEN
649: IF p_dest_parent_lpn_status IS NULL THEN
650: SELECT status_id
651: INTO l_dest_parent_lpn_status
652: FROM wms_license_plate_numbers
653: WHERE lpn_id = l_dest_parent_lpn_id
654: AND organization_id = p_source_organization_id;
655: ELSE
656: l_dest_parent_lpn_status := p_dest_parent_lpn_status;

Line 667: FROM wms_license_plate_numbers

663: IF l_dest_outermost_lpn_id IS NOT NULL THEN
664: IF p_dest_outermost_lpn_status IS NULL THEN
665: SELECT status_id
666: INTO l_dest_outermost_lpn_status
667: FROM wms_license_plate_numbers
668: WHERE lpn_id = l_dest_outermost_lpn_id
669: AND organization_id = p_source_organization_id;
670: ELSE
671: l_dest_outermost_lpn_id := p_dest_outermost_lpn_id;