229: -- Check if this combination of Lot/Sublot already exists in the database
230: --x_found := 1; -- 1 means combination in ic_lots_mst exists
231: --WHILE (x_found = 1)
232: ---LOOP
233: gmi_autolot.generate_lot_number(
234: p_item_id => p_item_id,
235: p_in_lot_no => p_lot_no,
236: p_orgn_code => NULL,
237: p_doc_id => NULL,
340:
341: --x_found := 1; -- 1 means ic_lots_mst exists
342: --WHILE (x_found = 1)
343: --LOOP
344: gmi_autolot.generate_lot_number(
345: p_item_id => p_item_id,
346: p_in_lot_no => NULL,
347: p_orgn_code => NULL,
348: p_doc_id => NULL,
451:
452: --x_found := 1; -- 1 means ic_lots_mst exists
453: --WHILE (x_found = 1)
454: --LOOP
455: gmi_autolot.generate_lot_number(
456: p_item_id => p_item_id,
457: p_in_lot_no => l_dummy_lot,
458: p_orgn_code => NULL,
459: p_doc_id => NULL,