DBA Data[Home] [Help]

APPS.QA_FLEX_UTIL dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 827: -- from wms_license_plate_numbers. This procedure is called from

823:
824:
825: -- Bug 3096256.
826: -- This procedures returns the Subinventory of an LPN given the LPN_ID
827: -- from wms_license_plate_numbers. This procedure is called from
828: -- getSubinventoryFromLPN() method in ContextElementTable.java.
829: -- For RCV/WMS Enhancements. kabalakr Mon Aug 25 04:12:48 PDT 2003.
830:
831: PROCEDURE get_subinventory_from_lpn(

Line 837: FROM wms_license_plate_numbers

833: x_subinventory OUT NOCOPY VARCHAR2) IS
834:
835: CURSOR C1 IS
836: SELECT subinventory_code
837: FROM wms_license_plate_numbers
838: WHERE lpn_id = p_lpn_id;
839:
840: BEGIN
841:

Line 851: -- from wms_license_plate_numbers. This procedure is called from

847:
848:
849: -- Bug 3096256.
850: -- This procedures returns the Locator of an LPN given the LPN_ID
851: -- from wms_license_plate_numbers. This procedure is called from
852: -- getLocatorFromLPN() method in ContextElementTable.java.
853: -- For RCV/WMS Enhancements. kabalakr Mon Aug 25 04:12:48 PDT 2003.
854:
855: PROCEDURE get_locator_from_lpn(

Line 864: FROM wms_license_plate_numbers

860: l_locator_id NUMBER;
861:
862: CURSOR C1 IS
863: SELECT locator_id
864: FROM wms_license_plate_numbers
865: WHERE lpn_id = p_lpn_id;
866:
867: BEGIN
868: