DBA Data[Home] [Help]

APPS.WMS_CONTAINER_PUB dependencies on WMS_LICENSE_PLATE_NUMBERS_S2

Line 1046: SELECT wms_license_plate_numbers_s2.NEXTVAL

1042:
1043: ELSE /* l_insert_update_flag = 'i' */
1044: /* Need to generate a license plate number to go along with the given lpn id */
1045: LOOP
1046: SELECT wms_license_plate_numbers_s2.NEXTVAL
1047: INTO l_curr_seq
1048: FROM DUAL;
1049:
1050: l_new_lpn := l_org.lpn_prefix || TO_CHAR(l_curr_seq) || l_org.lpn_suffix;