DBA Data[Home] [Help]

APPS.WMS_CONTAINER_PUB dependencies on WMS_LICENSE_PLATE_NUMBERS_S2

Line 969: SELECT wms_license_plate_numbers_s2.NEXTVAL

965:
966: ELSE /* l_insert_update_flag = 'i' */
967: /* Need to generate a license plate number to go along with the given lpn id */
968: LOOP
969: SELECT wms_license_plate_numbers_s2.NEXTVAL
970: INTO l_curr_seq
971: FROM DUAL;
972:
973: l_new_lpn := l_org.lpn_prefix || TO_CHAR(l_curr_seq) || l_org.lpn_suffix;