APPS.WMS_WORKFLOW_WRAPPERS dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 531: FROM wms_license_plate_numbers

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

Line 560: FROM wms_license_plate_numbers

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

Line 591: FROM wms_license_plate_numbers

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

Line 605: FROM wms_license_plate_numbers

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

Line 627: FROM wms_license_plate_numbers

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

Line 650: FROM wms_license_plate_numbers

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

Line 665: FROM wms_license_plate_numbers

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