APPS.INV_LOT_API_PKG dependencies on DUAL

Line 1230: FROM DUAL;

1226: END IF;
1227:
1228: SELECT SYSDATE + l_shelf_life_days
1229: INTO l_expiration_date
1230: FROM DUAL;
1231:
1232: IF TRUNC(l_expiration_date) <> trunc(p_expiration_date) THEN
1233: fnd_message.set_name('INV', 'INV_EXP_DATE_NOT_CONSIDER');
1234: fnd_msg_pub.ADD;

Line 1470: -- SELECT MTL_GEN_OBJECT_ID_S.NEXTVAL INTO l_mtl_gen_obj_no FROM dual;

1466: IF( g_debug = 1 ) THEN
1467: print_debug('Populate OUT lot record parameter', 9);
1468: END IF;
1469:
1470: -- SELECT MTL_GEN_OBJECT_ID_S.NEXTVAL INTO l_mtl_gen_obj_no FROM dual;
1471:
1472: -- Replace the INSERT INTO mtl_lot_numbers statement with population of OUT lot record parameter.
1473:
1474: x_lot_rec.inventory_item_id := p_inventory_item_id;